Updated 2024-05-27
    SELECT
    hour::date AS date,
    avg(price),
    max(price) as latest_price,
    '222835990' AS circulating_supply,
    latest_price * circulating_supply AS mktcap
    FROM arbitrum.price.ez_hourly_token_prices
    WHERE symbol = 'VRTX'
    AND date >= '2023-07-01'
    GROUP BY 1
    ORDER BY 1 DESC
    QueryRunArchived: QueryRun has been archived