Is there a way to return a single document per hour?
Another way to describe what I'm after: I'm thinking of a "date histogram" type scenario, but within the query, not with aggregations.
The data is basically a table with users' activity per hour (timestamp), with some values associated with their activity recorded at each hour. They can be active in more than one way (resulting in multiple documents per hour), but for this query, I'd like to simply grab a single document with information per hour, for each user. Is this possible?