date_trunc('day', block_timestamp) as day,

tx_hash,

event_inputs:to as staker,

event_inputs:value/1e18 as amount

from ethereum.core.fact_event_logs

where contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')

and event_inputs:from = '0x0000000000000000000000000000000000000000'),

depositors as (select startday, sum(count(*)) over (order by startday) as stakers

from (select staker, min(day) as startday

from data

group by staker

)

group by startday

order by startday desc)

select *, stakers - lag(stakers, 1, 0) over ( order by startday) as new_stakers

from depositors