select

distinct from_address as depositors,

date_trunc('week', block_timestamp) as dt

--sum(eth_value)/1e18 as staked_eth

--case when block_number > 15537393 then 'post_merge'

--else 'pre_merge' end as merge_status

from ethereum.core.fact_traces

where

--block_number > 14537393 -- block height before merge

-- and

to_address=lower('0x00000000219ab540356cBB839Cbe05303d7705Fa') --eth staking address

group by 2,1

select

dt,

--staked_eth,

count(depositors) as depositor_count,

--sum(staked_eth) over (order by dt) as cumulate_staked_eth,

sum(depositor_count) over (order by dt) as cumulate_depositors

--merge_status

from deposit

group by 1

order by 1 desc