with miner as (

select

DISTINCT miner

from ethereum.core.fact_blocks

where NETWORK='mainnet'

SELECT

BLOCK_TIMESTAMP::date as date,

case

when BLOCK_NUMBER < 15537351 then 'Before Merge'

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

end as period,

count(DISTINCT tx_hash) as swap_tx_cnt,

count(DISTINCT SENDER) as uniq_swapper,

sum(amount_in) as swap_eth_amt,

sum(swap_tx_cnt) over (partition by period order by date) as cum_swap_tx,

sum(swap_eth_amt) over (partition by period order by date) as cum_swap_eth_amt,

sum(uniq_swapper) over (partition by period order by date) as cum_swap_users

FROM ethereum.core.ez_dex_swaps

WHERE SYMBOL_IN = 'WETH'

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

group by 1,2

order by 1