PlaywoUntitled Query
    Updated 2022-11-09
    WITH timeframe AS (
    SELECT date_hour AS hour
    FROM crosschain.core.dim_date_hours
    WHERE hour >= TO_DATE('{{start_date}}') AND hour <= TO_DATE('{{end_date}}') AND hour < CURRENT_TIMESTAMP
    )

    SELECT hour,
    COALESCE(
    (SELECT sum(CASE WHEN action = 'withdraw' THEN -amount ELSE amount END) FROM solana.core.fact_stake_pool_actions WHERE block_timestamp <= hour AND block_timestamp >= TO_DATE('{{start_date}}'))
    , 0) AS net_change
    FROM timeframe
    Run a query to Download Data