LTirrellUntitled Query
Updated 2021-10-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH mir AS (
select
distinct date_trunc('hour', o.block_timestamp) as date,
o.symbol as sym,
o.luna_exchange_rate as exchange_rate_luna
from
terra.oracle_prices o
where
sym = 'MIR'
)
select
date,
avg(exchange_rate_luna)
from
mir
group by
date
order by
date
Run a query to Download Data