WITH daily_prices AS (

SELECT

DATE_TRUNC('day', p.HOUR) AS day,

AVG(p.PRICE) AS avg_daily_price

FROM

aptos.price.ez_prices_hourly p

WHERE

p.SYMBOL = 'APT'

AND p.HOUR >= DATEADD(day, -60, CURRENT_DATE)

GROUP BY

day

SELECT

day,

avg_daily_price,

AVG(avg_daily_price) OVER (ORDER BY day ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS moving_avg_7d,

AVG(avg_daily_price) OVER (ORDER BY day ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS moving_avg_30d

FROM

daily_prices

ORDER BY

day ASC;