boomer77ANC/mir
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day', block_timestamp) as days,
currency,
symbol,
avg(price_usd)
FROM
terra.oracle_prices
where symbol in ('MIR', 'ANC','LUNA') and days BETWEEN '2021-07-20' and '2021-08-02'
group by 1,2,3
order by 1 DESC
Run a query to Download Data