block_timestamp::date as day,

count(distinct tx_id) as swaps_count,

count(distinct swapper) as swappers_count,

sum(swaps_count) over(order by day) as cumulative_swaps_count,

sum(swappers_count) over(order by day) as cumulative_swappers_count

from solana.core.fact_swaps

where succeeded = 1

and block_timestamp >= '2022-06-01'

group by day

order by day