add an extra index to speed up `group by day` queries