Event based function
Here is example vertica site given, to create event id when stock big > $5 based on timestamp
SELECT stock, CONDITIONAL_CHANGE_EVENT(bid> 5)
OVER(ORDER BY ts) FROM Tickstore3;
My question is: this only work for one stock, if have more than one stock in the table, has any like: partition by or group by function to generate each stock event_id?