flipside

    surge of optimism4
    sarathsurge of optimism4
    Updated 2022-12-21
    select
    date(hour) as date ,
    symbol,
    avg(price)


    from optimism.core.fact_hourly_token_prices
    where symbol in ('WETH', 'OP', 'WBTC')
    and date > '2022-10-24'
    group by 1, 2
    Run a query to Download Data