flipside

    Dust txns (all chains) (not all contracts)
    0xC2eAf96831Cd62f8dC3B85674D749154F205562cDust txns (all chains) (not all contracts)
    Updated 2023-09-13
    WITH
    prices_optimism AS (
    SELECT
    HOUR,
    TOKEN_ADDRESS,
    PRICE
    FROM
    (
    SELECT
    HOUR,
    TOKEN_ADDRESS,
    price,
    ROW_NUMBER() OVER (
    PARTITION BY
    TOKEN_ADDRESS
    ORDER BY
    HOUR DESC
    ) as rn
    FROM
    optimism.core.fact_hourly_token_prices
    ) as prices
    WHERE
    rn = 1
    ),
    prices_arbitrum AS (
    SELECT
    HOUR,
    TOKEN_ADDRESS,
    PRICE
    FROM
    (
    SELECT
    HOUR,
    TOKEN_ADDRESS,
    price,
    ROW_NUMBER() OVER (
    Run a query to Download Data