sunslingeraycealex
Updated 2021-11-11
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('day',block_timestamp) AS Date,
symbol,
avg(price_usd) AS Avg_USD
from terra.oracle_prices
where symbol IN ('UST','AUT','CAT','CHT','CNT','DKT','EUT','GBT')
and block_timestamp >= getdate() - interval '6 months'
and price_usd <> 0
group by 1,2
order by 1 DESC
Run a query to Download Data