BLOCK_TIMESTAMP::date as day,

case

when BLOCK_TIMESTAMP>'2022-09-15 03:00:00.000' then 'Post-merge period'

else 'Pre-merge period'

end as gp,

count(distinct ORIGIN_FROM_ADDRESS) as active_wallets,

count(distinct tx_hash) as count_TXN,

sum(AMOUNT_out_USD) as volume,

volume/count_TXN as avg_volume

from ethereum.core.ez_dex_swaps

WHERE BLOCK_TIMESTAMP>='2022-09-01' and AMOUNT_IN_USD is not null

group by 1,2