ValiMohammadiPrice Correlation
Updated 2022-07-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with PriceALGO as ( select block_hour::date as PriceDate, price_usd as PriceALGO from algorand.prices_swap
where asset_id = 0 and block_hour::date >= current_date - 90 and hour(block_hour) = 23
),
PriceBTC as (select block_timestamp::date as PriceDate, asset_usd as PriceBTC from thorchain.prices
where block_timestamp::date >= current_date - 90 and hour(block_timestamp) = 23 and minute(block_timestamp) = 59 and pool_name = 'BTC.BTC'
),
PriceETH as (select hour::date as PriceDate, price as PriceETH
from ethereum.core.fact_hourly_token_prices
where symbol is null and token_address is null and hour::date >= current_date - 90 and hour(hour) = 23
),
PriceSOL as ( select hour::date as PriceDate, price as PriceSOL from ethereum.core.fact_hourly_token_prices
where token_address = '0xd31a59c85ae9d8edefec411d448f90841571b89c' and hour::date >= current_date - 90 and hour(hour) = 23
)
select PriceDate, PriceETH, PriceBTC, PriceALGO,PriceSOL from PriceETH
left join PriceBTC using(PriceDate)
left join PriceALGO using(PriceDate)
left join PriceSOL using(PriceDate)
Run a query to Download Data