flipside

    What was the total amount of SOL withdrawn from each stake pool in August?
    maymoth55What was the total amount of SOL withdrawn from each stake pool in August?
    Updated 2025-04-24
    SELECT
    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;

    Last run: about 2 months ago
    STAKE_POOL_NAME
    TOTAL_SOL_WITHDRAWN
    1
    		jito542605853478748
    2
    		blazestake158084247815842
    3
    		jpool422875911381
    3
    80B
    1s