select Quote_count('IBM'); quote_count ------------- 5 (1 row) select Quote_first('IBM'); quote_first ------------- 11-01-2013 (1 row) select Quote_last('IBM'); quote_last ------------ 11-06-2013 (1 row) select cs_sum(Volume) from Quote_get('IBM'); cs_sum -------- 1500 (1 row) select cs_max(Close) from Quote_get(array['ABB','IBM'], date('03-Nov-2013'), date('05-Nov-2013')); cs_max ------------------ 60.2000007629395 40.2000007629395 (2 rows) select cs_min(Close) from Quote_get(array['ABB','IBM']); cs_min ------------------ 60.2000007629395 10.5 (2 rows) select cs_count(Day) from Quote_get('IBM'); cs_count ---------- 5 (1 row) select cs_approxdc(Volume/200) from Quote_get('IBM'); cs_approxdc ------------- 3 (1 row) select cs_avg(Volume) from Quote_get('IBM'); cs_avg -------- 300 (1 row) select cs_prd(High - Low) from Quote_get('IBM'); cs_prd -------- 0 (1 row) select cs_var(Open) from Quote_get('IBM'); cs_var ----------------- 201.22160451355 (1 row) select cs_dev(Close) from Quote_get('IBM'); cs_dev ------------------ 14.1428992745525 (1 row) select cs_sum('int4:{1,2,3}'); cs_sum -------- 6 (1 row) select cs_sum(Close) from Quote_concat(array['ABB','IBM']); cs_sum ------------------ 282.300003051758 (1 row) select cs_sum(cs_limit(cs_filter_pos(cs_const(1, 'char')), 0, 3)); cs_sum -------- 6 (1 row) select cs_sum(cs_cum_sum(cs_limit(cs_const(1, 'int4'), 0, 3))); cs_sum -------- 10 (1 row) select cs_median(Close) from Quote_get(array['ABB','IBM']); cs_median ------------------ 65.3499984741211 30.2000007629395 (2 rows) select cs_all('int2:{2,3,6}'); cs_all -------- 2 (1 row) select cs_any('char:{2,3,6}'); cs_any -------- 7 (1 row)