CryptoLionPrice BTC ETH
Updated 2022-03-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
date_trunc('week',hour) as week,
symbol,
token_address,
avg(price) as price
FROM ethereum.token_prices_hourly
WHERE hour >= getdate() - interval '10 weeks'
AND (token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'
OR token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')
GROUP BY 1,2,3
ORDER BY 1 DESC
Run a query to Download Data