drone-mostafaPAXG 1
Updated 2023-06-07
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
date_trunc ('week',HOUR) as date,
Avg (PRICE) as avg_PRICE,
Min (PRICE) as Min_PRICE,
Max (PRICE) as Max_PRICE,
Median (PRICE) as Median_PRICE
FROM ethereum.core.fact_hourly_token_prices
WHERE TOKEN_ADDRESS = '0x45804880de22913dafe09f4980848ece6ecbaf78' --PAXG
AND HOUR >= current_date - 180
GROUP by 1
Run a query to Download Data