drone-mostafaPAXG 4
Updated 2023-05-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with One_year as (SELECT Avg (PRICE) as avg_PRICE_First
FROM ethereum.core.fact_hourly_token_prices
WHERE TOKEN_ADDRESS = '0x45804880de22913dafe09f4980848ece6ecbaf78' --PAXG
AND HOUR >= current_date -180 and HOUR <= current_date -175)
SELECT
date_trunc ('day',HOUR) as date, avg_PRICE_First,
Median (PRICE) as Median_PRICE,
((Median_PRICE - avg_PRICE_First) / avg_PRICE_First) * 100 as "Price Growth Percentage"
FROM ethereum.core.fact_hourly_token_prices
left join One_year
WHERE TOKEN_ADDRESS = '0x45804880de22913dafe09f4980848ece6ecbaf78' --PAXG
AND HOUR >= current_date -180
GROUP by 1 , 2
Run a query to Download Data