SELECT
date(timestamp) as date_price,
avg(price_usd) as "NEAR (USD)",
avg ("NEAR (USD)") over (order by date_price rows between 6 preceding and current row) as price_ma_7
FROM near.core.fact_prices
WHERE symbol = 'wNEAR'
AND date_price >= CURRENT_DATE - 30
GROUP BY 1
ORDER BY 1