with tbl as (select
block_timestamp,
tx_id,
swapper,
amount_in,
CURRENCY_in,
platform,
pool_name
from sei.defi.fact_dex_swaps
),
active_user as (
select
swapper,
count(distinct block_timestamp::date) as days
from tbl
GROUP BY 1
)
select
days,
count(distinct swapper) as swappers
from active_user
group by 1
order by 1