Kruys-CollinsWeekly Staking Volume AXL
    Updated 2024-09-16
    SELECT
    DATE_TRUNC('month', block_timestamp) AS month,
    DATE_TRUNC('week', block_timestamp) AS week,
    action,
    SUM(amount/1e6) AS total_volume
    FROM
    axelar.gov.fact_staking
    WHERE
    tx_succeeded = TRUE
    AND action IN ('delegate', 'undelegate', 'redelegate')
    GROUP BY
    1,2,3


    QueryRunArchived: QueryRun has been archived