flipside

    Untitled Query
    boomer77Untitled Query
    Updated 2022-08-29
    select date_trunc('day', hour) as dt, avg(price) as price_usd
    from ethereum.core.fact_hourly_token_prices
    where token_address = '0x71ab77b7dbb4fa7e017bc15090b2163221420282' and hour::date > '2022-01-10'
    group by 1
    Run a query to Download Data