dannyamah$VRTX
Updated 2024-05-27
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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