Not sure what you mean by “pattern”. Have you seen the datetime scalar available in both DQL and GraphQL schemas? Each order would have a datetime predicate, and from there any number of aggregation queries could be performed for nodes matching a time period.