flipside

    Hourly Vertex_price
    feyikemiHourly Vertex_price
    Updated 2024-05-05
    SELECT
    date_trunc('day', hour) as date,
    median(price) as price
    FROM
    arbitrum.price.ez_hourly_token_prices
    WHERE
    token_address = lower('0x95146881b86B3ee99e63705eC87AfE29Fcc044D9')
    GROUP BY 1
    ORDER BY 1 DESC
    QueryRunArchived: QueryRun has been archived