SQL Moving Window Frames

What & Why

Replace UNBOUNDED PRECEDING with a fixed number, and the frame stops growing — it slides forward with each row instead, always covering the same span. This is the mechanism behind every moving average.

See How It Works

SELECT
  date_day,
  dau,
  SUM(dau) OVER (ORDER BY date_day ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS rolling_7_row_dau
FROM growth.daily_active_users
ORDER BY date_day;