mrwildcatPyth Oracle on Blast, Top Contracts
    Updated 2025-02-11
    -- forked from Pyth Oracle on Avalanche, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/9ba1950e-7aa8-43d0-8a4c-c005f08e09af

    -- forked from Pyth Oracle on Optimism, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/cbd225e2-ebea-499c-9143-b297643ecccb

    -- forked from Pyth Oracle on Gnosis, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/3f87d077-c73f-4683-b616-dd51e661e6a9

    -- forked from Pyth Oracle on Base, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/94c89a33-82dc-4e44-a0b9-77239dd3e404

    -- forked from Pyth Oracle on BSC, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/c5bddb69-cd5a-48ad-84cd-0ddae8ee1ae2

    WITH price_updates AS (
    SELECT
    from_address AS contract_address,
    COUNT(*) AS update_count
    FROM blast.core.fact_traces
    WHERE to_address = LOWER('0xA2aa501b19aff244D90cc15a4Cf739D2725B5729')
    AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
    AND SUBSTRING(input, 1, 10) IN (
    '0xef9e5e28', '0xb9256d28', '0x785bdda0', '0xf4347f83',
    '0x4716e9c5', '0xaccca7f9', '0x0d4702e1', '0x631a316c'
    )
    AND type = 'CALL'
    GROUP BY 1
    ),
    user_counts AS (
    SELECT
    to_address AS contract_address,
    COUNT(DISTINCT from_address) AS unique_users
    FROM blast.core.fact_transactions
    WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
    AND status = 'SUCCESS'
    AND to_address IN (
    SELECT contract_address
    FROM price_updates
    )
    GROUP BY 1
    QueryRunArchived: QueryRun has been archived