# Query and export data for same period over a number of days **URL:** \ **Category:** Kibana\ **Created:** [March 26, 2019, 10:36am UTC](https://discuss.elastic.co/t/query-and-export-data-for-same-period-over-a-number-of-days/173902 "2019-03-26T10:36:18Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![johncam](https://avatars.discourse-cdn.com/v4/letter/j/2bfe46/32.png) [@johncam](https://discuss.elastic.co/u/johncam)\ **Post date:** [March 26, 2019, 10:36am UTC](https://discuss.elastic.co/t/query-and-export-data-for-same-period-over-a-number-of-days/173902/1 "2019-03-26T10:36:18Z")
Is it possible to perform a search over a specified 30 minute timeframe over a number of days? For example, I would like to query the CPU metric from metricbeat between 09:00 and 09:30 for the last 7 days and export this to CSV. Would I need to do this for each day separately or is this possible via a more complex query? ---
**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\ **Post date:** [March 26, 2019, 8:14pm UTC](https://discuss.elastic.co/t/query-and-export-data-for-same-period-over-a-number-of-days/173902/2 "2019-03-26T20:14:37Z")
You could create a [scripted field](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) that returns the time of day for each document, and then filter on that field for the time you want. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 23, 2019, 8:14pm UTC](https://discuss.elastic.co/t/query-and-export-data-for-same-period-over-a-number-of-days/173902/3 "2019-04-23T20:14:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.