i have the following table:
| date | value |
|---|---|
| 2021-04-07 18:00:00 | 5 |
| 2021-04-07 18:01:00 | 10 |
| 2021-04-07 18:02:00 | 7,5 |
| etc |
And i want to know how could i calculate the average of values every 15 minutes, like this:
| date | Average |
|---|---|
| 2021-04-07 18:00:00 | 7,5 |
| 2021-04-07 18:15:00 | 8 |
| 2021-04-07 18:30:00 | 4,5 |
