posts by hour on identica
public text v1 · immutable+--------------+---------------+----------+
| day(created) | hour(created) | count(*) |
+--------------+---------------+----------+
| 23 | 0 | 2141 |
| 23 | 1 | 1778 |
| 23 | 2 | 1750 |
| 23 | 3 | 1902 |
| 23 | 4 | 1754 |
| 23 | 5 | 1916 |
| 23 | 6 | 1863 |
| 23 | 7 | 1812 |
| 23 | 8 | 1724 |
| 23 | 9 | 2010 |
| 23 | 10 | 1864 |
| 23 | 11 | 2067 |
| 23 | 12 | 2523 |
| 23 | 13 | 2030 |
| 23 | 14 | 2072 |
| 23 | 15 | 2197 |
| 23 | 16 | 2136 |
| 23 | 17 | 2429 |
| 23 | 18 | 2313 |
| 23 | 19 | 2062 |
| 23 | 20 | 2505 |
| 23 | 21 | 2645 |
| 23 | 22 | 6577 |
| 23 | 23 | 6839 |
| 24 | 0 | 7113 |
| 24 | 1 | 6391 |
| 24 | 2 | 4359 |
| 24 | 3 | 4472 |
| 24 | 4 | 3180 |
| 24 | 5 | 434 |
+--------------+---------------+----------+