7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

Because the window size is 5, the stockprice_mavg and volume_mavg columns contain the weighted average value of the previous five rows (days). Because of IncludeFirst argument('true'), the output table includes the first five rows even though they contain null values for those columns.

WMAVG Example Output Table
id name period stockprice volume stockprice_mavg volume_mavg
1 IBM 1961-05-1700:00:00 460 640000    
1 IBM 1961-05-1800:00:00 457 707200    
1 IBM 1961-05-1900:00:00 452 747200    
1 IBM 1961-05-2200:00:00 459 1.3312e+06    
1 IBM 1961-05-2300:00:00 462 1.848e+06 458.4 1257386.6666666667
1 IBM 1961-05-2400:00:00 459 779200 458.73333333333335 1165546.6666666667
1 IBM 1961-05-2500:00:00 463 528000 460.46666666666664 980693.3333333334
1 IBM 1961-05-2600:00:00 479 843200 467.1333333333333 912853.3333333334
1 IBM 1961-05-2900:00:00 493 1.728e+06 476.6666666666667 1133546.6666666667
1 IBM 1961-05-3100:00:00 490 880000 482.93333333333334 1045120.0
1 IBM 1961-06-0100:00:00 492 760000 488.0 981226.6666666666
1 IBM 1961-06-0200:00:00 498 1.848e+06 492.8666666666667 1281280.0
1 IBM 1961-06-0500:00:00 499 1.3472e+06 495.73333333333335 1326400.0
... ... ... ... ... ... ...