Aggregation by date

I don't think you can do this with aggs, because as you found out, it does it based on the hour and not a range.
I'm not sure what else you could do though sorry, someone else might have an idea.