flipside

    Ethereum 3 mega prices
    IBC_insiderEthereum 3 mega prices
    Updated 2022-12-28
    select
    avg(case when SYMBOL='WETH' then PRICE else null end ) as price ,
    date_trunc(day,HOUR) as date
    from
    ethereum.core.fact_hourly_token_prices
    where
    date>CURRENT_DATE-600
    group by date

    Run a query to Download Data