Cumulative Aggregate Python SequenceIterator Methods

All Cumulative Aggregate methods produce a result sequence which is of the same type as the object's sequence or of type double depending on the operation performed. The value of each element is the result of the specified operation on all of the preceding elements.

cum_agg_max() Returns a sequence of the same type with the cumulative maximum: each element is the maximum value of all the preceding elements
cum_agg_min() Returns a sequence of the same type with the cumulative minimum: each element is the minimum value of all the preceding elements
cum_agg_sum() Returns a sequence of the same type with the cumulative sum: each element is the sum of all the preceding elements
cum_agg_prd() Returns a sequence of the same type with the cumulative product: each element is the product of all the preceding elements
cum_agg_avg() Returns a double sequence with the cumulative average: each element is the average of all the preceding elements
cum_agg_var() Returns a double sequence with the cumulative variance: each element is the variance of all the preceding elements
cum_agg_var_samp() Returns a double sequence with the cumulative sample variance: each element is the cumulative sample variance of all the preceding elements
cum_agg_dev() Returns a double sequence with the cumulative standard deviation: each element is the cumulative standard deviation of all the preceding elements
cum_agg_dev_samp() Returns a double sequence with the sample standard deviation: each element is the cumulative sample standard deviation of all the preceding elements

Example

Following is an example code snippet demonstrating a cumulative aggregate function:

         
    cursor = con.cursor("Quote", "by_sym")
    for quote in cursor:
        cumVol = quote.volume.cum_agg_sum()
        ...