ioanUntitled Query
Updated 2023-02-27Copy Reference Fork
9
1
2
3
4
5
6
›
⌄
SELECT TO_VARCHAR(date_trunc('day', HOUR), 'YYYY-MM-DD"T"HH24:MI:SS.FF3TZH') AS day
, TOKEN_ADDRESS AS token
, avg(PRICE) AS price
FROM ethereum.core.fact_hourly_token_prices
WHERE TOKEN_ADDRESS = lower('0x1a4b46696b2bb4794eb3d4c26f1c55f9170fa4c5')
GROUP BY 1, 2
Run a query to Download Data