Grand Aggregate Python SequenceIterator Methods

All Grand Aggregate methods produce a double result sequence in which the first element contains the aggregate value, except for agg_count() which returns a uint8 sequence and the two methods agg_approxdc() and agg_approxdc_hash() which return uint4 sequences.

agg_count() Count of all elements
agg_max() Maximum element value
agg_min() Minimum element value
agg_min_max() Both maximum and minimum element value. The result sequence contains two elements: the first is the minimum value, the second is the maximum
agg_sum() Sum of all elements
agg_prd() Product of all elements
agg_avg() Average of all elements
agg_var() Variance of elements
agg_var_samp() Sample Variance of elements
agg_dev() Standard Deviation of elements
agg_dev_samp() Sample Standard Deviation of elements
agg_approxdc() Approximate count of distinct values
agg_approxdc_hash() Approximate count of distinct values for multiple sequences

Example

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

         
    cursor = con.cursor("Quote", "by_sym")
    for quote in cursor:
        ...
        maxit = quote.close.agg_max()
            
        ...