When making a metrics query with #startDate and #endDate, both boundaries are inclusive. Thus, it is hard to perform multiple queries for consecutive time intervals when expecting disjoint results. This is especially evident on older MySQL versions where the precision of a timestamp is on the level of seconds.