mrwildcatpyth sei daily contracts
    Updated 2025-02-11
    -- forked from pyth ethereum daily contracts @ https://flipsidecrypto.xyz/edit/queries/c098e37e-1f21-45c8-8978-7b1a9e6cbe75

    -- forked from pyth polygon daily contracts @ https://flipsidecrypto.xyz/edit/queries/5ef24d4d-6456-4cee-ae85-a5fd69c60434



    WITH daily_contracts AS (
    SELECT DATE_TRUNC('day', block_timestamp) as date,
    COUNT(DISTINCT from_address) as daily_contracts
    FROM sei.core_evm.fact_traces
    WHERE to_address = LOWER('0x2880aB155794e7179c9eE2e38200202908C17B43')
    AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
    GROUP BY 1
    )
    SELECT
    date,
    daily_contracts,
    AVG(daily_contracts) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as seven_day_avg,
    SUM(daily_contracts) OVER (ORDER BY date) as cumulative_contracts
    FROM daily_contracts
    ORDER BY date








    QueryRunArchived: QueryRun has been archived