+------------------------+----------+
| left(rev_timestamp, 8) | count(*) |
+------------------------+----------+
| 20180331               |   159903 |
| 20180330               |   179850 |
| 20180329               |   180538 |
| 20180328               |   185640 |
| 20180327               |   173263 |
| 20180326               |   170460 |
| 20180325               |   148337 |
| 20180324               |   152033 |
| 20180323               |   169498 |
| 20180322               |   211124 |
| 20180321               |   214151 |
| 20180320               |   191460 |
| 20180319               |   173958 |
| 20180318               |   171239 |
| 20180317               |   170141 |
| 20180316               |   164185 |
| 20180315               |   159523 |
| 20180314               |   159202 |
| 20180313               |   158760 |
| 20180312               |   156404 |
| 20180311               |   160736 |
| 20180310               |   154282 |
| 20180309               |   159268 |
| 20180308               |   160585 |
| 20180307               |   171724 |
| 20180306               |   162493 |
| 20180305               |   161487 |
| 20180304               |   159433 |
| 20180303               |   152568 |
| 20180302               |   165899 |
| 20180301               |   161847 |
+------------------------+----------+