cypherTHOR PRICE
Updated 2021-12-12
9
1
2
3
4
5
6
7
›
⌄
SELECT date_trunc('day', HOUR) as DATE, AVG(PRICE) as thor_price
FROM ethereum.token_prices_hourly
WHERE token_address = '0xa5f2211b9b8170f694421f2046281775e8468044' AND
DATE >= getdate() - interval '180 days'
GROUP BY DATE
ORDER BY DATE DESC
Run a query to Download Data