Updated 2023-05-09
    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