when action in ('DelegatorUnstakedTokensWithdrawn','UnstakedTokensWithdrawn') then 'Unstake'

when action in ('DelegatorRewardTokensWithdrawn','RewardTokensWithdrawn') then 'Claim Reward' end as type,

count(distinct tx_id) as txns, count(distinct delegator) as users, count(distinct node_id) as nodes,

sum(amount) as total_vol, avg(amount) as avg_vol, median(amount) as median_vol, min(amount) as min_vol, max(amount) as max_vol

from flow.core.ez_staking_actions

where tx_succeeded = 'TRUE'

group by 1,2