16.20 - Example - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

prodname
Advanced SQL Engine
Teradata Database
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1145-162K

The following example calculates the 50-day moving average of the closing price of the stock for Zemlinsky Bros. Corporation. The ticker name for the company is ZBC.

   SELECT MarketDay, ClosingPrice, 
      MAVG(ClosingPrice,50, MarketDay) AS ZBCAverage
   FROM MarketDailyClosing
   WHERE Ticker = 'ZBC'
   ORDER BY MarketDay;

The results for the query might look something like the following table.

MarketDay ClosingPrice ZBCAverage
12/27/1999 89 1/16 85 1/2
12/28/1999 91 1/8 86 1/16
12/29/1999 92 3/4 86 1/2
12/30/1999 94 1/2 87