...
| sensor_id | year | field | count | sum | average |
|---|---|---|---|---|---|
| 12345 | 2003 | temperature | 120 | 8400.0 | 60.0 |
| 12345 | 2003 | pH | 120 | 240.0 | 2.0 |
bins_month
| sensor_id | month | year | field | count | sum | average |
|---|---|---|---|---|---|---|
| 12345 | 6 | 2003 | temperature | 10 | 600.0 | 60.0 |
| 12345 | 6 | 2003 | pH | 10 | 20.0 | 2.0 |
bins_day
| sensor_id | day | month | year | field | count | sum | average |
|---|---|---|---|---|---|---|---|
| 12345 | 13 | 6 | 2003 | temperature | 1 | 60.0 | 60.0 |
| 12345 | 13 | 6 | 2003 | pH | 1 | 2.0 | 2.0 |
bins_hour
| sensor_id | hour | day | month | year | field | count | sum | average |
|---|---|---|---|---|---|---|---|---|
| 12345 | 19 | 13 | 6 | 2003 | temperature | 1 | 60.0 | 60.0 |
| 12345 | 19 | 13 | 6 | 2003 | pH | 1 | 2.0 | 2.0 |
Other possible tables:
...