(select

count(case when ACTION in ('deposit','deposit_dao','deposit_dao_with_referrer','deposit_stake','deposit_dao_stake') then 1 else null end) as stake_number,

count (case when ACTION in ('withdraw_dao','withdraw_stake','withdraw_dao_stake','withdraw') then 1 else null end) as unstake_number,

sum(case when ACTION in ('deposit','deposit_dao','deposit_dao_with_referrer','deposit_stake','deposit_dao_stake') then AMOUNT else null end) as stake_volume,

sum (case when ACTION in ('withdraw_dao','withdraw_stake','withdraw_dao_stake','withdraw') then AMOUNT else null end) as unstake_volume,

stake_volume-unstake_volume as flow,

date_trunc('day', BLOCK_TIMESTAMP) as date

from solana.core.fact_stake_pool_actions

where

group by date)

select * ,

sum(stake_volume) over (order by date) as cumulative_stake_volume,

sum(unstake_volume) over (order by date) as cumulative_unstake_volume,

sum(flow) over (order by date) as cumulative_flow

from t1