boomer77uni easy
Updated 2021-11-11
9
1
2
3
4
5
6
7
8
›
⌄
WITH Variance as (SELECT var_pop(price_usd) as Variance, currency as Currency, avg(price_usd) as Avg_USD, date_trunc('day', block_timestamp) as XXX
FROM terra.oracle_prices
GROUP by Currency, XXX)
SELECT * FROM Variance
WHERE Currency != 'ANC' and Currency != 'MIR' and Currency != 'uluna'
AND XXX BETWEEN '2021-01-01' AND '2021-06-01'
Run a query to Download Data