Grand Aggregate Python SequenceIterator Methods
All Grand Aggregate methods produce a
double
result sequence in which the first element contains the aggregate value, except foragg_count()
which returns auint8
sequence and the two methodsagg_approxdc()
andagg_approxdc_hash()
which returnuint4
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() ...