datavortexRewards
    Updated 2024-11-30
    WITH epoch_boundaries AS (
    SELECT
    DATE '2024-11-06' AS epoch_start,
    DATE '2024-11-13' AS epoch_end
    UNION
    ALL
    SELECT
    DATE '2024-11-13',
    DATE '2024-11-20'
    UNION
    ALL
    SELECT
    DATE '2024-11-20',
    DATE '2024-11-27'
    UNION
    ALL
    SELECT
    DATE '2024-11-27',
    DATE '2024-12-04'
    ),
    epoch_data AS (
    SELECT
    SUM(
    CASE
    WHEN action = 'TokenUnstaked' THEN amount
    ELSE 0
    END
    ) AS total_validator_unstaked,
    SUM(
    CASE
    WHEN action = 'DelegatorTokensUnstaked' THEN amount
    ELSE 0
    END
    ) AS total_delegator_unstaked,
    SUM(
    CASE
    QueryRunArchived: QueryRun has been archived