MLDZMNsol2
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 tb1 as (select
HOUR::date as day,
avg(price) as ETH_price,
lag(ETH_price) ignore nulls over(ORDER BY day ASC) as lag_price,
((ETH_price-lag_price)/ETH_price)*100 as deviation_price_ETH,
((first_value(ETH_price) over ( order by day asc) -
first_value(ETH_price) over (order by day desc)
)/first_value(ETH_price) over ( order by day asc))*100 as diff_ETH
from ethereum.core.fact_hourly_token_prices
where hour>= '2023-05-15'
and symbol in ('WETH')
group by 1),
tb2 as (select
HOUR::date as day,
avg(price) as BTC_price,
lag(BTC_price) ignore nulls over(ORDER BY day ASC) as lag_price,
((BTC_price-lag_price)/BTC_price)*100 as deviation_price_BTC
from ethereum.core.fact_hourly_token_prices
where hour>= '2023-05-15'
and symbol in ('WBTC')
group by 1),
tb3 as (select
recorded_hour::date as day,
avg (close) as SOL_price,
lag(SOL_price) ignore nulls over(ORDER BY day ASC) as lag_price,
((SOL_price-lag_price)/SOL_price)*100 as deviation_price_SOL
from solana.core.fact_token_prices_hourly
where symbol='SOL'
and recorded_hour::date >= '2023-05-15'
group by 1)
select
tb1.day as day,
ETH_price,
Run a query to Download Data