sarathAlgorand price correlation
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with data1 as (SELECT date(block_hour) as date,avg(price_usd) as algo_price from algorand.prices_swap where asset_name='ALGO'
GROUP by 1),
data2 as (
SELECT date(hour) as date1,avg(price) as ETH_price from ethereum.core.fact_hourly_token_prices where symbol='WETH'
GROUP by 1
),
data3 as(
SELECT date(block_hour) as date2,avg(price_usd) as BTC_price from algorand.prices_swap where asset_name ='Wrapped BTC'
GROUP by 1
)
SELECT date,Algo_price,ETH_price,BTC_price from data1 join data2 on data1.date=data2.date1 join data3 on data1.date=data3.date2
LIMIT 100
Run a query to Download Data