block_timestamp::date as day,

count(distinct tx_hash) as swaps_count,

count(distinct origin_from_address) 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 bsc.core.fact_event_logs

where event_name ilike '%swap%'

and block_timestamp >= '2022-06-01'

group by day

order by day