title: Moving window/average based on timestamps in PostgreSQL
body: <p>My question is the same as the one asked <a href="https://stackoverflow.com/questions/13818524/moving-average-based-on-timestamps-in-postgresql">here</a>, except the chosen answer goes "assuming you want to restart the rolling average after each 15 minute interval." What if I don't? I.e. what if I want a different rolling average for every row and the next fifteen minutes of rows?</p>