select count(*) as tx, date_trunc(day,block_timestamp) as dt,

sum(tx) over (order by dt) as cumulative,

case when dt >= '2022-09-15' then 'post-merge'

else 'pre-merge' end as merge_status

from

(

select distinct tx_hash, block_timestamp

-- case when block_number >= 15537393 then 'post-merge'

--else 'pre-merge' end as merge_status

from ethereum.core.fact_transactions

--where block_number < 15537393

--group by 3

group by 2,4

order by 1 desc