Updated 2023-06-07
    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