datavortexstakers
    Updated 2025-01-26
    WITH weekly_staking_data AS (
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week,
    COUNT(
    DISTINCT CASE
    WHEN action IN ('TokensCommitted', 'DelegatorTokensCommitted') THEN tx_id
    ELSE NULL
    END
    ) AS weekly_stake_actions,
    SUM(
    CASE
    WHEN action IN ('TokensCommitted', 'DelegatorTokensCommitted') THEN amount
    ELSE 0
    END
    ) AS weekly_stake_volume,
    DATE_TRUNC('month', block_timestamp) AS month
    FROM
    flow.gov.ez_staking_actions
    WHERE
    tx_succeeded = TRUE
    AND block_timestamp >= '2024-01-01'
    GROUP BY
    DATE_TRUNC('week', block_timestamp),
    DATE_TRUNC('month', block_timestamp)
    )
    SELECT
    week,
    SUM(
    CASE
    WHEN month >= TIMESTAMP '2024-02-01'
    AND month <= TIMESTAMP '2024-07-31' THEN weekly_stake_actions
    END
    ) AS "6 months before August 2024 stake actions",
    SUM(
    CASE
    WHEN month >= TIMESTAMP '2024-02-01'
    QueryRunArchived: QueryRun has been archived