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 event_action,

count(distinct tx_id) AS TT_txns,

count(distinct delegator) AS TT_users,

count(distinct node_id) AS TT_Nodes,

sum(amount) AS TT_Volume,

avg(amount) AS Avg_Volume,

median(amount) AS Med_Volume,

sum (TT_txns) over (partition by event_action order by date) AS Cumulative_Txns,

sum (TT_Volume) over (partition by event_action order by date) AS Cumulative_Volume

FROM flow.core.ez_staking_actions

WHERE tx_succeeded = 'TRUE'

GROUP BY 1,2