select distinct_id,
          timestamp,
          event,
          groupArray(event) OVER (PARTITION BY distinct_id ORDER BY timestamp ASC ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING) AS two_before,
          groupArray(event) OVER (PARTITION BY distinct_id ORDER BY timestamp ASC ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING) AS two_after
     from events
    where timestamp > toDateTime('2020-01-09 00:00:00')
      and person.properties.random_uuid = '{random_uuid}'
 order by distinct_id, timestamp

 select distinct_id,
        timestamp,
        event,
        groupArray(event) OVER w1 AS two_before,
        groupArray(event) OVER w2 AS two_after
   from events
  where timestamp > toDateTime('2020-01-09 00:00:00')
    and distinct_id like '%_{random_uuid}'
 window w1 as (PARTITION BY distinct_id ORDER BY timestamp ASC ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING),
        w2 as (PARTITION BY distinct_id ORDER BY timestamp ASC ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING)
order by distinct_id, timestamp