feyikemiBenqi Total Stakers
    Updated 2024-08-31
    -- Credit to Yasmin https://flipsidecrypto.xyz/yasmin/q/R2lWu8hkSCJ1/user-staker

    WITH Total_Metrics AS (
    SELECT
    COUNT(DISTINCT decoded_log:user) AS Total_Stakers
    FROM avalanche.core.ez_decoded_event_logs
    WHERE
    tx_status = 'SUCCESS'
    AND event_name = 'Submitted'
    AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
    AND block_timestamp >= '2024-01-01'
    ),

    August AS (
    SELECT
    COUNT(DISTINCT decoded_log:user) AS Total_Stakers_August
    FROM avalanche.core.ez_decoded_event_logs
    WHERE
    tx_status = 'SUCCESS'
    AND event_name = 'Submitted'
    AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
    AND block_timestamp::date BETWEEN '2024-08-01' AND '2024-08-31'
    ),

    Past_24H AS (
    SELECT
    COUNT(DISTINCT decoded_log:user) AS Total_Stakers_Past_24H
    FROM avalanche.core.ez_decoded_event_logs
    WHERE
    tx_status = 'SUCCESS'
    AND event_name = 'Submitted'
    AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
    AND block_timestamp >= current_date - INTERVAL '1 day'
    )

    SELECT
    QueryRunArchived: QueryRun has been archived