+----------+------------+----------+
| mytime   | logday     | maxcount |
+----------+------------+----------+
| 00:00:00 | 1986-01-28 |        1 |
| 00:30:00 | 1986-01-28 |        1 |
| 01:00:00 | 1986-01-28 |        1 |
| 01:30:00 | 1986-01-28 |        1 |
| 02:00:00 | 1986-01-28 |        1 |
| 02:30:00 | 1986-01-28 |        1 |
| 03:00:00 | 1986-01-28 |        1 |
| 03:30:00 | 1986-01-28 |        1 |
| 04:00:00 | 1986-01-28 |        1 |
| 04:30:00 | 1986-01-28 |        1 |
| 05:00:00 | 1986-01-28 |        1 |
| 05:30:00 | 1986-01-28 |        1 |
| 06:00:00 | 1986-01-28 |        1 |
| 06:30:00 | 1986-01-28 |        1 |
| 07:00:00 | 1986-01-28 |        1 |
| 07:30:00 | 1986-01-28 |        1 |
| 08:00:00 | 1986-01-28 |        1 |
| 08:30:00 | 1986-01-28 |        1 |
| 09:00:00 | 1986-01-28 |        1 |
| 09:30:00 | 1986-01-28 |        1 |
| 10:00:00 | 1986-01-28 |        1 |
| 10:30:00 | 1986-01-28 |        1 |
| 11:00:00 | 1986-01-28 |        1 |
| 11:30:00 | 1986-01-28 |        1 |
| 12:00:00 | 1986-01-28 |        1 |
| 12:30:00 | 1986-01-28 |        1 |
| 13:00:00 | 1986-01-28 |        1 |
| 13:30:00 | 1986-01-28 |        1 |
| 14:00:00 | 1986-01-28 |        1 |
| 14:30:00 | 1986-01-28 |        1 |
| 15:00:00 | 1986-01-28 |        1 |
| 15:30:00 | 1986-01-28 |        1 |
| 16:00:00 | 1986-01-28 |        1 |
| 16:30:00 | 1986-01-28 |        1 |
| 17:00:00 | 1986-01-28 |        1 |
| 17:30:00 | 1986-01-28 |        1 |
| 18:00:00 | 1986-01-28 |        1 |
| 18:30:00 | 1986-01-28 |        1 |
| 19:00:00 | 1986-01-28 |        1 |
| 19:30:00 | 1986-01-28 |        1 |
| 20:00:00 | 1986-01-28 |        1 |
| 20:30:00 | 1986-01-28 |        1 |
| 21:00:00 | 1986-01-28 |        1 |
| 21:30:00 | 1986-01-28 |        1 |
| 22:00:00 | 1986-01-28 |        1 |
| 22:30:00 | 1986-01-28 |        1 |
| 23:00:00 | 1986-01-28 |        1 |
| 23:30:00 | 1986-01-28 |        1 |
| 00:00:00 | 1996-01-01 |        1 |
| 00:30:00 | 1996-01-01 |        1 |
| 01:00:00 | 1996-01-01 |        1 |
| 01:30:00 | 1996-01-01 |        1 |
| 02:00:00 | 1996-01-01 |        1 |
| 02:30:00 | 1996-01-01 |        1 |
| 03:00:00 | 1996-01-01 |        1 |
| 03:30:00 | 1996-01-01 |        1 |
| 04:00:00 | 1996-01-01 |        1 |
| 04:30:00 | 1996-01-01 |        1 |
| 05:00:00 | 1996-01-01 |        1 |
| 05:30:00 | 1996-01-01 |        1 |
| 06:00:00 | 1996-01-01 |        1 |
| 06:30:00 | 1996-01-01 |        1 |
| 07:00:00 | 1996-01-01 |        1 |
| 07:30:00 | 1996-01-01 |        1 |
| 08:00:00 | 1996-01-01 |        1 |
| 08:30:00 | 1996-01-01 |        1 |
| 09:00:00 | 1996-01-01 |        1 |
| 09:30:00 | 1996-01-01 |        1 |
| 10:00:00 | 1996-01-01 |        1 |
| 10:30:00 | 1996-01-01 |        1 |
| 11:00:00 | 1996-01-01 |        1 |
| 11:30:00 | 1996-01-01 |        1 |
| 12:00:00 | 1996-01-01 |        1 |
| 12:30:00 | 1996-01-01 |        1 |
| 13:00:00 | 1996-01-01 |        1 |
| 13:30:00 | 1996-01-01 |        1 |
| 14:00:00 | 1996-01-01 |        1 |
| 14:30:00 | 1996-01-01 |        1 |
| 15:00:00 | 1996-01-01 |        1 |
| 15:30:00 | 1996-01-01 |        1 |
| 16:00:00 | 1996-01-01 |        1 |
| 16:30:00 | 1996-01-01 |        1 |
| 17:00:00 | 1996-01-01 |        1 |
| 17:30:00 | 1996-01-01 |        1 |
| 18:00:00 | 1996-01-01 |        1 |
| 18:30:00 | 1996-01-01 |        1 |
| 19:00:00 | 1996-01-01 |        1 |
| 19:30:00 | 1996-01-01 |        1 |
| 20:00:00 | 1996-01-01 |        1 |
| 20:30:00 | 1996-01-01 |        1 |
| 21:00:00 | 1996-01-01 |        1 |
| 21:30:00 | 1996-01-01 |        1 |
| 00:00:00 | 2005-12-03 |      308 |
| 00:30:00 | 2005-12-03 |      191 |
| 01:00:00 | 2005-12-03 |      137 |
| 01:30:00 | 2005-12-03 |      109 |
| 02:00:00 | 2005-12-03 |       82 |
| 02:30:00 | 2005-12-03 |       63 |
| 03:00:00 | 2005-12-03 |       45 |
| 03:30:00 | 2005-12-03 |       36 |
| 04:00:00 | 2005-12-03 |       31 |
| 04:30:00 | 2005-12-03 |       25 |
| 05:00:00 | 2005-12-03 |       19 |
| 05:30:00 | 2005-12-03 |       16 |
| 06:00:00 | 2005-12-03 |       13 |
| 06:30:00 | 2005-12-03 |       12 |
| 07:00:00 | 2005-12-03 |        9 |
| 07:30:00 | 2005-12-03 |        6 |
| 08:00:00 | 2005-12-03 |        1 |
| 08:30:00 | 2005-12-03 |        1 |
| 09:00:00 | 2005-12-03 |        1 |
| 09:30:00 | 2005-12-03 |        1 |
| 10:00:00 | 2005-12-03 |        1 |
| 10:30:00 | 2005-12-03 |        1 |
| 11:00:00 | 2005-12-03 |        1 |
| 11:30:00 | 2005-12-03 |        1 |
| 12:00:00 | 2005-12-03 |        1 |
| 12:30:00 | 2005-12-03 |        1 |
| 13:00:00 | 2005-12-03 |        1 |
| 00:30:00 | 2005-12-04 |       73 |
| 01:00:00 | 2005-12-04 |       81 |
| 01:30:00 | 2005-12-04 |       79 |
| 02:00:00 | 2005-12-04 |       87 |
| 02:30:00 | 2005-12-04 |       86 |
| 03:00:00 | 2005-12-04 |       86 |
| 03:30:00 | 2005-12-04 |       80 |
| 04:00:00 | 2005-12-04 |       73 |
| 04:30:00 | 2005-12-04 |       69 |
| 05:00:00 | 2005-12-04 |       72 |
| 05:30:00 | 2005-12-04 |       87 |
| 06:00:00 | 2005-12-04 |      106 |
| 06:30:00 | 2005-12-04 |      130 |
| 07:00:00 | 2005-12-04 |      139 |
| 07:30:00 | 2005-12-04 |      181 |
| 08:00:00 | 2005-12-04 |      215 |
| 08:30:00 | 2005-12-04 |      245 |
| 09:00:00 | 2005-12-04 |      252 |
| 09:30:00 | 2005-12-04 |      264 |
| 10:00:00 | 2005-12-04 |      309 |
| 10:30:00 | 2005-12-04 |      309 |
| 11:00:00 | 2005-12-04 |      304 |
| 11:30:00 | 2005-12-04 |      328 |
| 12:00:00 | 2005-12-04 |      336 |
| 12:30:00 | 2005-12-04 |      347 |
| 13:00:00 | 2005-12-04 |      329 |
| 13:30:00 | 2005-12-04 |      352 |
| 14:00:00 | 2005-12-04 |      370 |
| 14:30:00 | 2005-12-04 |      415 |
| 15:00:00 | 2005-12-04 |      390 |
| 15:30:00 | 2005-12-04 |      410 |
| 16:00:00 | 2005-12-04 |      416 |
| 16:30:00 | 2005-12-04 |      432 |
| 17:00:00 | 2005-12-04 |      416 |
| 17:30:00 | 2005-12-04 |      424 |
| 18:00:00 | 2005-12-04 |      432 |
| 18:30:00 | 2005-12-04 |      437 |
| 19:00:00 | 2005-12-04 |      470 |
| 19:30:00 | 2005-12-04 |      508 |
| 20:00:00 | 2005-12-04 |      534 |
| 20:30:00 | 2005-12-04 |      507 |
| 21:00:00 | 2005-12-04 |      504 |
| 21:30:00 | 2005-12-04 |      472 |
| 22:00:00 | 2005-12-04 |      451 |
| 22:30:00 | 2005-12-04 |      427 |
| 23:00:00 | 2005-12-04 |      383 |
| 23:30:00 | 2005-12-04 |      305 |
+----------+------------+----------+