count (distinct tx_id) as TX_Count,

sum (amount/1e9) as Total_Volume

from solana.core.fact_stake_pool_actions

where succeeded = 'TRUE'

and block_timestamp >= CURRENT_DATE - 7

and (action ilike '%withdraw%' or action ilike '%unstake%')

and amount > 0

group by 1

order by TX_Count DESC

limit 10