select
    left(timestamp, 8) as day,
    count(*) as events
from log.Edit_17541122
where
    event_editor = "wikitext-2017" and
    event_action = "ready" and
    event_platform = "other" and
    timestamp >= "20180911"
group by left(timestamp, 8)

         day  events
0   20180911     235
1   20180912     207
2   20180913     233
3   20180914     239
4   20180915     245
5   20180916     239
6   20180917     221
7   20180918     222
8   20180919     238
9   20180920     269
10  20180921     268
11  20180922     280
12  20180923     274
13  20180924     191