mz0111weekly report 10
    Updated 2023-01-18
    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

    Run a query to Download Data