date_trunc('day', block_timestamp) as date,

sum(event_inputs:ethAmount/1e18) as rocketpool_deposits

from ethereum_core.fact_event_logs

where contract_address = lower('0xae78736cd615f374d3085123a210448e74fc6393')

and event_name = 'TokensMinted'

and date >= current_date - 90

group by date),

lido_deposits as (select

date_trunc('day', block_timestamp) as date,

sum(event_inputs:amount/1e18) as lido_deposits

from ethereum_core.fact_event_logs

where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')

and date >= current_date() - 90

and event_name = 'Submitted'

group by date),

temp as (select * from reth_deposits

full outer join lido_deposits using (date))

select

*,

sum(rocketpool_deposits) over (order by date asc rows between unbounded preceding and current row) as cum_rocketpool_deposits,

sum(lido_deposits) over (order by date asc rows between unbounded preceding and current row) as cum_lido_deposits

from temp