count(distinct TX_ID) as tx_count,

count(distinct ADDRESS) as user,

sum(AMOUNT/1e9) as sol_amount,

CASE

WHEN action IN ('deposit') THEN 'deposit'

when action IN ('deposit_stake') THEN 'stake'

WHEN action IN ('claim') THEN 'withdraw'

when action IN ('order_unstake') THEN 'unstake'

END AS action_type

FROM solana.defi.fact_stake_pool_actions s

WHERE stake_pool_name = 'marinade'

AND s.block_timestamp >= '2025-01-01'

group by action_type