mansastNEAR vs wNEAR price
Updated 2022-10-05
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
›
⌄
with stNEARprice as (
select
date(timestamp) as date_,
avg(price_USD) as stNEAR_price
from near.core.fact_prices
where SYMBOL = 'STNEAR'
group by 1),
wNEARprice as(
SELECT
date(timestamp) as dates,
avg(price_USD) as wNEAR_price
from near.core.fact_prices
where SYMBOL = 'wNEAR'
group by 1
)
SELECT
a.date_,
a.stNEAR_price,
b.wNEAR_price
from stNEARprice a inner join wNEARprice b
where a.date_ = b.dates
Run a query to Download Data