case when action ilike '%deposit%' then 'Stake/Deposit'

when action ilike '%withdraw%' then 'Unstake/Withdraw'

when action ilike 'order_unstake' then 'Order to Unstake'

when action ilike 'claim' then 'Claim Rewards'

else null end as action_type,

count (distinct tx_id) as trxs,

count (distinct address) as Users,

sum (amount/1e9) as Total_Volume,

avg (amount/1e9) as Average_Volume

from solana.core.fact_stake_pool_actions

where succeeded = 'TRUE'

and block_timestamp >= CURRENT_DATE - 7

and action_type is not null

group by 1, 2, 3

order by 1