mrwildcatPyth Oracle on Ethereum, Top Contracts
    Updated 4 days ago
    -- forked from Pyth Oracle on Polygon, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/5fdb390b-61ae-456e-9159-192473e9720f

    -- forked from Pyth Oracle on Blast, Top Contracts @ https://flipsidecrypto.xyz/edit/queries/70aa138d-2ce9-4ce5-89c0-a9d130f1148f

    -- 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 ethereum.core.fact_traces
    WHERE to_address = LOWER('0x4305FB66699C3B2702D4d05CF36551390A4c69C6')
    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 ethereum.core.fact_transactions
    WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '6 months'
    AND status = 'SUCCESS'
    AND to_address IN (
    Last run: 4 days ago
    CONTRACT_ADDRESS
    PRICE_UPDATES
    NUMBER_OF_USERS
    PROJECT_NAME
    1
    0xf8a319bcd9fff599c191f30eb7b2c876067cb2ad77431Unknown
    2
    0x0c9a3dd6b8f28529d72d7f9ce918d493519ee3838645203Unknown
    3
    0xc1459fcfe23d5db9ddb04935ab7a426bd398eab04591Unknown
    4
    0x2f020e07e680c8826642f6be1b28eca9086bc8501882Unknown
    5
    0x271aca3e9b8ed9f4f618875093bd75a7e1b3116c1431Unknown
    6
    0xdaf4da41aacc0439b412a138fe8274e06341024e880Unknown
    7
    0xc23e8ba7dfc6bc544c8912847cc72a4c1dd4e712440Unknown
    8
    0xa9bbbdde822789f123667044443dc7001fb43c01430Unknown
    9
    0x63506717f6f2324ea15edc6cd0bdcc57379cb271301Unknown
    10
    0xda3cb1b836678255dda230c3853dc491296b2374301Unknown
    11
    0x29ee42d8849bc1ad341c49f0a8522ac57ae10b7b111Unknown
    12
    0x46aaa4b384d7103d3e99552011795a9b270b25fe81Unknown
    13
    0xd04a2e318e4557bb81344ea485b63d0d55732a3781Unknown
    14
    0x5e93bcc3ce5115ed665676256c1959e8217428e870Unknown
    15
    0x3b8dfe237895f737271371f339eecbd66face43e71Unknown
    16
    0xc6f3405c861fa0dca04ec4ba59bc189d1d56ee0561Unknown
    17
    0x57d86c0418120aa3d0d53f3922f165d9e4ca465f50Unknown
    18
    0x20d12300b4805708d4293d29cb83c1e01d6f891351Unknown
    19
    0x8842fe65a7db9bb5de6d50e49af19496da09f9b540Unknown
    20
    0x78357316239040e19fc823372cc179ca75e64b8132Unknown
    36
    2KB
    99s