MovingAverage Function Example | Teradata Vantage - MovingAverage Example: Simple Moving Average - Teradata® Database

This example computes a simple moving average for the price of stock.

Input

See MovingAverage Examples Input.

SQL Call

SELECT * FROM MovingAverage (
  ON company1_stock PARTITION BY name ORDER BY period
  USING
  MAvgType ('S')
  TargetColumns ('stockprice')
  WindowSize (10)
  IncludeFirst ('true')
) AS dt ORDER BY id;

Output