Continuous query issue

Is there a way to by pass Group by time in continuous query?

I want to compute average of last 1 hour data every 10 seconds and store these values in a table.

Resample every 10s for 1h
Select mean(*) into average from raw GroupBy time(1h)

This query overwrites the computed mean values every 10s in the same row… I want to write new rows of average of last 1 hour of data.

If I change the group by to 10s, it averages only on 10s of data.