day,

near_price,

AVG(near_price) OVER (ORDER BY day ROWS BETWEEN 20 PRECEDING AND CURRENT ROW) AS moving_avg20,

AVG(near_price) OVER (ORDER BY day ROWS BETWEEN 50 PRECEDING AND CURRENT ROW) AS moving_avg50

FROM (

SELECT

date_trunc('day', timestamp) AS day,

AVG(price_usd) AS near_price

FROM

near.core.fact_prices

WHERE

symbol = 'wNEAR'

AND day >= CURRENT_DATE - INTERVAL '60 days'

GROUP BY

day

) subquery

ORDER BY

day;