BLOCK_TIMESTAMP::date as date,

case

when BLOCK_NUMBER < 15537351 then 'Before Merg'

when BLOCK_NUMBER >= 15537351 then 'After Merg' -- 15,537,351 The merg block number

end as period,

count(DISTINCT tx_hash) as swap_tx_cnt,

count(DISTINCT ORIGIN_FROM_ADDRESS) as uniq_sender,

sum(amount) as swap_eth_amt

FROM ethereum.core.ez_eth_transfers

WHERE ORIGIN_TO_ADDRESS in (SELECT address FROM ethereum.core.dim_labels WHERE LABEL_TYPE = 'cex')

AND ORIGIN_FROM_ADDRESS not in (SELECT address FROM ethereum.core.dim_labels WHERE LABEL_TYPE = 'cex')

AND BLOCK_TIMESTAMP::date >= '2022-09-01'

group by 1,2

order by 1