Metiocreluna/btc terra schema
Updated 2022-03-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with luna as (
SELECT block_timestamp as time, price_usd as price
from terra.oracle_prices
where
date(block_timestamp) >='2021-10-01'
and currency='uluna'
),
btc as(
SELECT block_timestamp as time, price_usd as price
from terra.oracle_prices
where
date(block_timestamp) >='2021-10-01'
and symbol = 'mBTC'
)
select btc.time as time, luna.price as luna_price, btc.price as btc_price, luna_price/btc_price as luna_btc_price
from luna,btc
where luna.time=btc.time
order by btc.time desc
Run a query to Download Data