flipside

    floor price
    Abbas_ra21floor price
    Updated 2022-07-04
    select
    date_trunc('day', HOUR) as date,
    sum(PRICE)/count(*) as Floor_price
    from ethereum.core.fact_hourly_token_prices
    where TOKEN_ADDRESS = '0xf59257e961883636290411c11ec5ae622d19455e'
    group by 1
    Run a query to Download Data