Elprognerd7- luna vs btc
Updated 2023-01-17Copy Reference Fork
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
recorded_hour as date,
avg(close) as "LUNA Price"
from crosschain.core.fact_hourly_prices
where id = 'terra-luna-2'
and recorded_hour >= '2023-01-08'
group by 1),
BTC as(select
hour as date,
avg(price) as "BTC Price"
from ethereum.core.fact_hourly_token_prices
where symbol = 'WBTC'
and hour >= '2023-01-08'
group by 1)
SELECT
x.date,
"LUNA Price",
"BTC Price"
from luna x join btc y on x.date= y.date
Run a query to Download Data