+----------------------------------+----------+
| left(right(rev_timestamp, 6), 2) | count(*) |
+----------------------------------+----------+
| 14                               |     5755 |
| 18                               |     5599 |
| 20                               |     5450 |
| 13                               |     5427 |
| 15                               |     5028 |
| 19                               |     5021 |
| 22                               |     4929 |
| 17                               |     4818 |
| 10                               |     4728 |
| 16                               |     4710 |
| 11                               |     4595 |
| 21                               |     4531 |
| 12                               |     4507 |
| 09                               |     4177 |
| 08                               |     3073 |
| 23                               |     2667 |
| 00                               |     2150 |
| 07                               |     1906 |
| 06                               |      988 |
| 01                               |      825 |
| 02                               |      736 |
| 05                               |      654 |
| 03                               |      385 |
| 04                               |      320 |
+----------------------------------+----------+