Combines values on multiple rows of a given field into an array based on group by field(s).
ARRAY(<field>)
ARRAY(<field>, <remove-duplicates-flag>)
ARRAY(<field>, <remove-duplicates-flag>, <filter-out-null-flag>)
select Stock, array(Price) as Trends group by Stock
select Stock, array(Price, true, true) as Trends group by Stock