# Newbie query to return a single doc from every 4 hours of data
**URL:** https://discuss.elastic.co/t/newbie-query-to-return-a-single-doc-from-every-4-hours-of-data/147277
**Category:** Elasticsearch
**Created:** [September 4, 2018, 10:28pm UTC](https://discuss.elastic.co/t/newbie-query-to-return-a-single-doc-from-every-4-hours-of-data/147277 "2018-09-04T22:28:42Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Mark\_Lloyd](https://discuss.elastic.co/u/Mark_Lloyd)
#### Post date: [September 4, 2018, 10:28pm UTC](https://discuss.elastic.co/t/newbie-query-to-return-a-single-doc-from-every-4-hours-of-data/147277/1 "2018-09-04T22:28:42Z")
Hi All
I'm very new to elastic search. I have an index that is indexing data received by ES every 10 seconds of everyday.
Now I want to query that data and filter it on some fields (got that sorted) and return data in groups, lets say groups of every 4 hours for past 24 hrs. I dont want to sum or avg anything in particular.
I want to return the closest single doc to each interval to basically build up some data points for use in a graph.
I'm looking at aggs but that only returns buckets with document counts.
I'm not even sure what term or concept I should be looking for in the docs.
Can anyone help out there?
Cheers
---
### Author:  [@abdon](https://discuss.elastic.co/u/abdon)
#### Post date: [September 7, 2018, 9:50am UTC](https://discuss.elastic.co/t/newbie-query-to-return-a-single-doc-from-every-4-hours-of-data/147277/2 "2018-09-07T09:50:36Z")
I think the [top\_hits aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-top-hits-aggregation.html) may be what you're looking for. This is an aggregation that you can nest in a bucket aggregation (in your case a date\_histogram aggregation with a 4 hour interval). The top\_hits aggregation then shows you one or more documents in each of those buckets, based on whatever sorting criteria you apply.
---
### Author:  [@Mark\_Lloyd](https://discuss.elastic.co/u/Mark_Lloyd)
#### Post date: [September 8, 2018, 11:28pm UTC](https://discuss.elastic.co/t/newbie-query-to-return-a-single-doc-from-every-4-hours-of-data/147277/3 "2018-09-08T23:28:52Z")
Many thanks for the tip
I’ll be trying it out this coming week
Appreciated
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 6, 2018, 11:29pm UTC](https://discuss.elastic.co/t/newbie-query-to-return-a-single-doc-from-every-4-hours-of-data/147277/4 "2018-10-06T23:29:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.