Continuous query with moving windows with defied execution interval


Is it possible to write a continuous query on a moving windows at a given interval ?

For example: mean of past 7 days but this function execution has to be performed every hour or so. I found a discussion here but it is few years old. I am wondering, if Kapacitor is still the only way to achieve this ?