CryptoLionPrice History
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_trunc('day',block_hour) as day,
underlying_symbol,
avg(ctoken_price) as ctoken_price,
avg(price) as price
FROM compound.market_stats
INNER JOIN ethereum.token_prices_hourly on hour = block_hour and underlying_symbol = symbol
WHERE block_hour >= getdate() - interval '60 days'
AND contract_name <> 'cSAI'
AND contract_name <> 'cWBTC'
GROUP BY day, 2
ORDER BY day
Run a query to Download Data