CASE when BLOCK_NUMBER < 15537393 then 'Before Merge'

when BLOCK_NUMBER >= 15537393 then 'After Merge' END as period,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as wallets,

COUNT(distinct TX_HASH) as tx_count,

sum(AMOUNT_IN_USD) as swap_amount_in_USD,

sum(AMOUNT_OUT) as ETH_amount_out

FROM ethereum.core.ez_dex_swaps

WHERE block_timestamp >= '2022-09-01'

AND SYMBOL_OUT = 'WETH'

GROUP BY 1