date(block_timestamp) as date,

count (distinct trader) as total_swapper,

sum(total_swapper) over (order by date asc) as cumulative_swapper,

count (distinct tx_id) as total_swap,

sum(total_swap) over (order by date asc) as cumulative_swap

from osmosis.core.fact_swaps inner join osmosis.core.dim_labels

on from_currency=address

and TO_CURRENCY like '%pool%' or TO_CURRENCY is null

and from_decimal is not null

and PROJECT_NAME != 'MEME'

AND tx_status = 'SUCCEEDED'

where block_timestamp::date >= CURRENT_DATE - 90

group by 1

order by 1