case when block_timestamp::date <= '2022-09-14' then 'Pre Merge'

when block_timestamp::date >= '2022-09-15' then 'Post Merge' end as status,

count(DISTINCT tx_hash) as count_tx,

count(DISTINCT origin_from_address) as users,

sum(AMOUNT_IN) as eth_amount,

avg(AMOUNT_IN) as avg_eth

from ethereum.core.ez_dex_swaps

where origin_from_address in ( select DISTINCT miner

from ethereum.core.fact_blocks)

and symbol_in in ('ETH','WETH') and

block_timestamp::date >= '2022-09-01'

and symbol_out is not null

group by 1,2

order by 5 desc

limit 10