# Exporting Homey Insight variable history with high resolution

**URL:** <https://community.homey.app/t/exporting-homey-insight-variable-history-with-high-resolution/146034>\
**Category:** Questions & Help\
**Created:** [November 27, 2025, 8:59pm UTC](https://community.homey.app/t/exporting-homey-insight-variable-history-with-high-resolution/146034 "2025-11-27T20:59:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rasket787](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/rasket787/32/138382_2.png) [@Rasket787](https://community.homey.app/u/Rasket787)\
**Post date:** [November 27, 2025, 8:59pm UTC](https://community.homey.app/t/exporting-homey-insight-variable-history-with-high-resolution/146034/1 "2025-11-27T20:59:16Z")

</div>

Hi all,

I’m trying to access historical data from a Homey variable in HomeyScript. I need to know **exact timestamps when a variable changed to a certain value** , but as far as I understand, HomeyScript and Flows only allow access to the **current value** , not historical data.

I know Insight stores the history, but I can’t export it with high enough precision for longer periods (per-minute or per-second data). I’ve read about unofficial API workarounds, but I’m not sure how to implement them.

Are there any reliable ways to **export or access per-minute/second variable history from Insight** , or do I need to start logging changes externally to get that level of detail?

Thanks for any advice!

---

<div class="post-metadata">

**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\
**Post date:** [November 27, 2025, 9:02pm UTC](https://community.homey.app/t/exporting-homey-insight-variable-history-with-high-resolution/146034/2 "2025-11-27T21:02:58Z")

</div>

Search app store for ‘export’, ‘insights’ and for ‘mysql’.

After 1 hour the data already starts to get averaged. So you’d start the export tool at least each hour.

| Data Age / View Period | Aggregation Interval | Resulting Granularity |
| --- | --- | --- |
| Last Hour | 5 Seconds | Highest resolution (closest to raw data) |
| Past Hours (up to 6 hours) | 60 Seconds (1 Minute) | Slightly reduced resolution |
| Past 24 Hours | 300 Seconds (5 Minutes) | Still good for daily trends |
| Past Week | 3600 Seconds (1 Hour) | Good for viewing daily patterns |
| Past Month | 21,600 Seconds (6 Hours) | Shows larger, slower trends |
| Year and Older | 604,800 Seconds (1 Week) or 1 Day | |