STAKE_POOL_NAME,

SUM(AMOUNT) AS TOTAL_SOL_WITHDRAWN

FROM solana.defi.fact_stake_pool_actions

WHERE ACTION = 'withdraw'

AND DATE_TRUNC('month', BLOCK_TIMESTAMP) = '2024-08-01'

GROUP BY STAKE_POOL_NAME;