SELECT

DATE_TRUNC('day', hour) AS price_date

, symbol

, AVG(price) AS avg_price

, AVG(avg_price) OVER (PARTITION BY symbol ORDER BY price_date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS ma_7_days

, ROW_NUMBER() OVER (PARTITION BY symbol ORDER BY price_date DESC) AS date_order

FROM optimism.core.fact_hourly_token_prices

WHERE 0=0

AND symbol IN ('ETH', 'OP', 'VELO')

AND hour >= (SELECT MIN(hour) FROM optimism.core.fact_hourly_token_prices WHERE symbol = 'VELO')

GROUP BY 1, 2

AVG(CASE WHEN price_date < '2022-10-01' THEN avg_price END) AS q3_average

, AVG(CASE WHEN price_date >= '2022-10-01' and price_date < '2023-01-01' THEN avg_price END) AS q4_average

, (q4_average-q3_average)/q3_average*100 AS diff_percentage

FROM price_

WHERE 0=0

AND symbol = 'VELO'

AND price_date >= '2022-07-01'