This message was deleted.

for whoever will be looking into this one, here is a simple example using wikipedia:

select __time, channel, page, count(*),
      count(*) over (order by __time rows between 1 following and 1 following)  
      from wikipedia
group by 1, 2, 3