stake_pool as staking_pool,

stake_pool_name as pool_name,

count (distinct tx_id) as no_of_txns,

count (distinct address) as no_of_users,

'Unstake' as action_type,

round(sum (amount/1e9),2) as total_volume,

round(avg (amount/1e9),2) as avg_volume

from solana.core.fact_stake_pool_actions

where succeeded = 'TRUE'

and action like '%withdraw%'

and block_timestamp >= dateadd('week', -1, getdate())

and action_type is not null

and amount > 0

group by day,

staking_pool,