select date_trunc('day', block_timestamp) as date,

sum(AMOUNT) as staked_amount,

sum(AMOUNT_USD) as staked_amount_usd

from ethereum.core.ez_token_transfers

where to_address = '0x4da27a545c0c5b758a6ba100e3a049001de870f5' and date >= '2021-01-01'

group by 1)

, unstake as (

select date_trunc('day', block_timestamp) as date,

sum(AMOUNT) as unstaked_amount,

sum(AMOUNT_USD) as unstaked_amount_usd

from ethereum.core.ez_token_transfers

where from_address = '0x4da27a545c0c5b758a6ba100e3a049001de870f5' and date >= '2021-01-01'

group by 1)

select

stake.date as Day,

staked_amount,

staked_amount_usd,

unstaked_amount,

unstaked_amount_usd,

zeroifnull(staked_amount)-zeroifnull(unstaked_amount) as diff,

zeroifnull(staked_amount_usd)-zeroifnull(unstaked_amount_usd) as diff_usd,

case when diff<0 then '-' when diff>0 then '+' end as status,

sum(staked_amount) over(order by Day asc) as staked_amount_cummulative,

sum(unstaked_amount) over(order by Day asc) as unstaked_amount_cummulative,

sum(diff) over(order by Day asc) as net_cummulative,

sum(diff_usd) over(order by Day asc) as net_cummulative_usd

from stake join unstake on stake.date=unstake.date order by Day asc