feyikemiUniswap L2s Comparison
    Updated 2024-07-31
    WITH MaticPrices AS (
    SELECT
    date_trunc('day', hour) AS Date,
    avg(price) AS price
    FROM
    polygon.price.ez_prices_hourly
    WHERE
    symbol ILIKE 'MATIC'
    GROUP BY
    Date
    ),

    ArbitrumPrices AS (
    SELECT
    date_trunc('day', hour) AS Date,
    avg(price) AS price
    FROM
    arbitrum.price.ez_prices_hourly
    WHERE
    symbol ILIKE 'WETH'
    GROUP BY
    Date
    ),

    OptimismPrices AS (
    SELECT
    date_trunc('day', hour) AS Date,
    avg(price) AS price
    FROM
    optimism.price.ez_prices_hourly
    WHERE
    symbol ILIKE 'WETH'
    GROUP BY
    Date
    ),

    QueryRunArchived: QueryRun has been archived