LTirrellprice_impact_airdrops_anc
Updated 2021-10-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- select
-- o.block_timestamp as date,
-- o.symbol as sym,
-- o.luna_exchange_rate
-- from
-- terra.oracle_prices o
-- where
-- sym in ('ANC', 'MIR', 'MINE')
-- order by
-- date
-- LIMIT
-- 100
WITH anc AS (
select
date_trunc('hour', o.block_timestamp) as date,
o.symbol as sym,
o.luna_exchange_rate as exchange_rate_luna,
o.price_usd
from
terra.oracle_prices o
where
sym = 'MIR'
),
luna AS (
select
date_trunc('hour', o.block_timestamp) as date,
o.symbol as sym,
o.price_usd
from
terra.oracle_prices o
where
sym = 'LUNA'
),
L_Airdrops AS (
select
date_trunc('hour', m.block_timestamp) as date,
Run a query to Download Data