KaskoazulUNI correlation vs ETH + DEX
Updated 2022-04-01
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH UNI_PRICE AS (
select hour,
price as UNI_PRICE
from ethereum.token_prices_hourly
where token_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' -- UNI
and hour >= '2022-01-01'
),
ETH_PRICE AS (
select hour,
price as ETH_PRICE
from ethereum.token_prices_hourly
where symbol = 'ETH' -- ETH
and hour >= '2022-01-01'
),
SUSHI_PRICE AS (
select hour,
price as SUSHI_PRICE
from ethereum.token_prices_hourly
where token_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' -- SUSHI
and hour >= '2022-01-01'
),
RUNE_PRICE AS (
select hour,
price as RUNE_PRICE
from ethereum.token_prices_hourly
where symbol = 'RUNE' -- RUNE
and hour >= '2022-01-01'
),
FIRSTJOIN AS (
select uni.hour,
uni.UNI_PRICE,
eth.ETH_PRICE
Run a query to Download Data