flipside

    Optimism Price
    nitsOptimism Price
    Updated 2022-11-09
    SELECT date(hour) as day, avg(price) as avg_price from optimism.core.fact_hourly_token_prices
    WHERE TOKEN_ADDRESS = '0x4200000000000000000000000000000000000042' and hour >= CURRENT_DATE -60
    GROUP by 1

    Run a query to Download Data