select min (slot_timestamp) as mindate,

pubkey as unique_validator

from ethereum.beacon_chain.fact_deposits

group by unique_validator),

t2 as (

select mindate::date as day,

count (distinct unique_validator) as total_new_validator,

sum (total_new_validator) over (order by day) as cumulative_validator

from t1

group by 1)

select slot_timestamp::date as date,

total_new_validator,

cumulative_validator,

count (deposit_amount) as total_deposit,

sum (deposit_amount) as total_deposit_volume,

avg (deposit_amount) as avg_deposit_volume,

sum (total_deposit_volume) over (order by date) as cumulative_deposit_volume,

count (distinct slot_number) as total_slot

from ethereum.beacon_chain.fact_deposits t1 join t2 t2 on t1.slot_timestamp::date = t2.day

group by 1,2,3

order by 1