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_out) as eth_amount,

avg(AMOUNT_out) as avg_eth

from ethereum.core.ez_dex_swaps

where origin_from_address in ( select DISTINCT miner

from ethereum.core.fact_blocks)

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

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

and symbol_in is not null

group by 1,2