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