count(distinct tx_hash) as swaps,

sum(swaps) over (order by day) as total_swaps,

count(distinct origin_from_address) as swappers,

count(distinct pool_name) as pools,

sum(amount_out_usd) as volume_swapped,

sum(volume_swapped) over (order by day) as total_volume_swapped

from base.defi.ez_dex_swaps where (symbol_in='BTCB' or symbol_out='BTCB')

group by 1 order by 1 desc