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

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

case when amount < 10 then ' < 10 FLOW'

when amount >= 10 and amount < 100 then '10 - 100 FLOW'

when amount >= 100 and amount < 1000 then '100 - 1k FLOW'

when amount >= 1000 and amount < 10000 then '1k - 10k FLOW'

else ' > 10k FLOW' end as volume,

count (distinct tx_id) as txns

from flow.core.ez_staking_actions

where tx_succeeded = 'TRUE'

group by 1,2

order by 3 desc