+------------------------+----------+
| left(rev_timestamp, 8) | count(*) |
+------------------------+----------+
| 20180331               |     1098 |
| 20180330               |      690 |
| 20180329               |      744 |
| 20180328               |      739 |
| 20180327               |      802 |
| 20180326               |      691 |
| 20180325               |      856 |
| 20180324               |      560 |
| 20180323               |      667 |
| 20180322               |      741 |
| 20180321               |      671 |
| 20180320               |      844 |
| 20180319               |      850 |
| 20180318               |     2001 |
| 20180317               |      992 |
| 20180316               |      526 |
| 20180315               |      592 |
| 20180314               |      724 |
| 20180313               |      703 |
| 20180312               |      861 |
| 20180311               |      626 |
| 20180310               |     1010 |
| 20180309               |      656 |
| 20180308               |      656 |
| 20180307               |      795 |
| 20180306               |     2449 |
| 20180305               |      819 |
| 20180304               |      833 |
| 20180303               |      650 |
| 20180302               |      552 |
| 20180301               |      618 |
+------------------------+----------+