from blast.core.ez_decoded_event_logs

where decoded_log:service='0x5ff315aa82a8b2b435f866d20ecd46959999bdcd'

and contract_address='0xe1784da2b8f42c31fb729e870a4a8064703555c2'

and event_name='Stake'

and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

group by 1),

tab2 as (select date_trunc('{{Time_Frame}}',block_timestamp) as date, sum(decoded_log:amount/pow(10,18)) as unstaking_volume

from blast.core.ez_decoded_event_logs

where decoded_log:service='0x5ff315aa82a8b2b435f866d20ecd46959999bdcd'

and contract_address='0xe1784da2b8f42c31fb729e870a4a8064703555c2'

and event_name='Unstake'

and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

group by 1)

select tab1.date as "Date", staking_volume-unstaking_volume as net_volume, sum(net_volume) over (order by "Date") as "Net Staking Amount ($ETH)"

from tab1 left join tab2 on tab1.date=tab2.date

group by 1,2

order by 1