Hello:

I am trying to build an event tree from a series timestamps, however for each event I want to be able to return the preceding and succeeding events +/- 2 seconds to capture a complete series of events.

I believe this is called lead/lag in other databases.

I’m not sure how to proceed in building a CTE, short of pulling all the events out an running a filter function on them in Python.

Thanks kindly,

Adam Doherty