freemartianPrice Drop Percentage
Updated 2022-11-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with T1 as (
select
symbol,
avg(price) as T1Price
from ethereum.core.fact_hourly_token_prices
where symbol in ('WETH','UNI','AAVE','WBTC','MATIC','LINK', 'CRV')
and hour::date = '2022-11-17'
group by 1)
select
date_trunc('day', hour) as date,
p.symbol,
(avg(price - T1Price)/avg(T1Price)) * 100 as Price_Drop_Percentage
from ethereum.core.fact_hourly_token_prices p join T1 on p.symbol = T1.symbol
where p.symbol in ('WETH','UNI','AAVE','WBTC','MATIC','LINK', 'CRV')
and hour >= '2022-11-17'
group by 1,2
Run a query to Download Data