vegardChange ETH price from October until Now
Updated 2022-11-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with september as (
select
avg(price) as eth_price
from ethereum.core.fact_hourly_token_prices
where symbol = 'WETH'
and hour::date >= '2022-10-01'
and hour::date < '2022-11-01'
),
november as (
select
avg(price) as eth_price
from ethereum.core.fact_hourly_token_prices
where symbol = 'WETH'
and hour::date >= '2022-11-01'
and hour::date < '2022-12-01'
)
select (november.eth_price - september.eth_price) as net_eth_price_avg, ((november.eth_price - october.eth_price) / october.eth_price) * 100 as change_ratio
from september join november
group by november.eth_price, september.eth_price
Run a query to Download Data