date_trunc('{{Frequency}}', BLOCK_TIMESTAMP)::date as date,

case

WHEN action in ('DelegatorTokensCommitted','TokensCommitted') THEN 'Stake'

WHEN action in ('DelegatorUnstakedTokensWithdrawn','UnstakedTokensWithdrawn') THEN 'UnStake'

WHEN action in ('DelegatorRewardTokensWithdrawn','RewardTokensWithdrawn') THEN 'Claim Reward'

end as status,

count(distinct tx_id) as tx_cnt,

count(distinct delegator) as user_cnt,

sum(amount) as volume,

sum(tx_cnt) over (partition by status order by date) as cum_tx_cnt,

sum(volume) over (partition by status order by date) as cum_volume

from flow.core.ez_staking_actions

where tx_succeeded = 'TRUE'

group by 1,2

order by 1