select

distinct from_address as depositors,

date_trunc('day', block_timestamp) as dt

from ethereum.core.fact_traces

where

BLOCK_TIMESTAMP > '2020-10-14'

and

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

group by 2,1

select

dt,

count(depositors) as depositor_count,

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

from deposit

group by 1

order by 1 desc