core
core copied to clipboard
Published
1 week ago
•
home-assistant
home-assistant
Opower thinks I have "return to grid"
The problem
Opower with Puget Sound Energy created a repair "Return to grid statistics for account:
What version of Home Assistant Core has the issue?
2025.5.0
What was the last working version of Home Assistant Core?
2025.4.4
What type of installation are you running?
Home Assistant OS
Integration causing the issue
Opower
Link to integration documentation on our website
https://www.home-assistant.io/integrations/opower/
Diagnostics information
No response
Example YAML snippet
Anything in the logs that might be useful for us?
Additional information
I believe this is where it's getting mixed up. There was a reset to 0 on May 27th 2024, July 27th 2024, December 27th 2024 and April 27th 2025. I believe this is something related to billing cycles, but I'm not entirely sure.
Edit: PSE's bill states our metering for the last cycle began on 3/28 and ended 4/29, which seems to somewhat coincide with the 27th?
Hey there @tronikos, mind taking a look at this issue as it has been labeled with an integration (opower) you are listed as a code owner for? Thanks!
Code owner commands
Code owners of opower can trigger bot actions by commenting:
@home-assistant closeCloses the issue.@home-assistant rename Awesome new titleRenames the issue.@home-assistant reopenReopen the issue.@home-assistant unassign opowerRemoves the current integration label and assignees on the issue, add the integration domain after the command.@home-assistant add-label needs-more-informationAdd a label (needs-more-information, problem in dependency, problem in custom component) to the issue.@home-assistant remove-label needs-more-informationRemove a label (needs-more-information, problem in dependency, problem in custom component) on the issue.
(message by CodeOwnersMention)
opower documentation opower source (message by IssueLinks)
![home-assistant[bot] avatar](https://avatars.githubusercontent.com/in/97978?v=4 "Published by a pub.dev verified publisher"){kind=small}
Here's my gas return statistic. I don't return any gas to the system, so I think it's easier to see what went wrong, as it clearly should never be above 0.
I'm not sure what, but my guess is that there's an incorrect assumption being made about Opower's data. Maybe it needs to be told explicitly that there is/isn't return power, or somehow check against the billing cycle? I'm not sure...
What do you see on your utility website for one of these dates? It was either a bug on the opower side or on the integration whenever it pulled that data. One way to resolve this is to delete all Opower statistics at https://my.home-assistant.io/create-link/?redirect=developer_statistics and reload the integration. You will have to enter selection mode, button on the left of the search box, select all opower statistics, and click on delete selected statistics.
Statistic reads that on January 2, 2025 at 1:00am, return electricity went up 55.82kWh. The PSE website though shows no anomalies around that time on either the billing (daily) or the hourly views, however this is right at the threshold between 2 billing views.
Edit: "Right at" is poor wording. It's close to, but not necessarily right at, which makes it confusing...
As you can see in the following data, consumption is always positive and looks normal.
Opower Hourly Data
Getting historical data: account= Account(customer=Customer(uuid='00000001'), uuid='00000002', utility_account_id='0001', id='0001', meter_type=<MeterType.ELEC: 'ELEC'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= hour start_date= 2024-12-30 00:00:00 end_date= 2025-01-05 00:00:00
start_time end_time consumption provided_cost start_minus_prev_end end_minus_prev_end
2024-12-30 00:00:00-08:00 2024-12-30 01:00:00-08:00 2.3832 0 None None
2024-12-30 01:00:00-08:00 2024-12-30 02:00:00-08:00 2.2794 0 0:00:00 1:00:00
2024-12-30 02:00:00-08:00 2024-12-30 03:00:00-08:00 2.1456 0 0:00:00 1:00:00
2024-12-30 03:00:00-08:00 2024-12-30 04:00:00-08:00 2.3232 0 0:00:00 1:00:00
2024-12-30 04:00:00-08:00 2024-12-30 05:00:00-08:00 2.2146 0 0:00:00 1:00:00
2024-12-30 05:00:00-08:00 2024-12-30 06:00:00-08:00 2.076 0 0:00:00 1:00:00
2024-12-30 06:00:00-08:00 2024-12-30 07:00:00-08:00 2.025 0 0:00:00 1:00:00
2024-12-30 07:00:00-08:00 2024-12-30 08:00:00-08:00 1.9098 0 0:00:00 1:00:00
2024-12-30 08:00:00-08:00 2024-12-30 09:00:00-08:00 1.899 0 0:00:00 1:00:00
2024-12-30 09:00:00-08:00 2024-12-30 10:00:00-08:00 1.7736 0 0:00:00 1:00:00
2024-12-30 10:00:00-08:00 2024-12-30 11:00:00-08:00 1.9602 0 0:00:00 1:00:00
2024-12-30 11:00:00-08:00 2024-12-30 12:00:00-08:00 2.0094 0 0:00:00 1:00:00
2024-12-30 12:00:00-08:00 2024-12-30 13:00:00-08:00 1.7868 0 0:00:00 1:00:00
2024-12-30 13:00:00-08:00 2024-12-30 14:00:00-08:00 2.9814 0 0:00:00 1:00:00
2024-12-30 14:00:00-08:00 2024-12-30 15:00:00-08:00 3.6612 0 0:00:00 1:00:00
2024-12-30 15:00:00-08:00 2024-12-30 16:00:00-08:00 3.0252 0 0:00:00 1:00:00
2024-12-30 16:00:00-08:00 2024-12-30 17:00:00-08:00 2.757 0 0:00:00 1:00:00
2024-12-30 17:00:00-08:00 2024-12-30 18:00:00-08:00 3.2196 0 0:00:00 1:00:00
2024-12-30 18:00:00-08:00 2024-12-30 19:00:00-08:00 2.8104 0 0:00:00 1:00:00
2024-12-30 19:00:00-08:00 2024-12-30 20:00:00-08:00 2.6826 0 0:00:00 1:00:00
2024-12-30 20:00:00-08:00 2024-12-30 21:00:00-08:00 3.606 0 0:00:00 1:00:00
2024-12-30 21:00:00-08:00 2024-12-30 22:00:00-08:00 3.1476 0 0:00:00 1:00:00
2024-12-30 22:00:00-08:00 2024-12-30 23:00:00-08:00 2.8296 0 0:00:00 1:00:00
2024-12-30 23:00:00-08:00 2024-12-31 00:00:00-08:00 2.6598 0 0:00:00 1:00:00
2024-12-31 00:00:00-08:00 2024-12-31 01:00:00-08:00 2.3892 0 0:00:00 1:00:00
2024-12-31 01:00:00-08:00 2024-12-31 02:00:00-08:00 2.3568 0 0:00:00 1:00:00
2024-12-31 02:00:00-08:00 2024-12-31 03:00:00-08:00 2.409 0 0:00:00 1:00:00
2024-12-31 03:00:00-08:00 2024-12-31 04:00:00-08:00 2.3118 0 0:00:00 1:00:00
2024-12-31 04:00:00-08:00 2024-12-31 05:00:00-08:00 1.9218 0 0:00:00 1:00:00
2024-12-31 05:00:00-08:00 2024-12-31 06:00:00-08:00 1.8372 0 0:00:00 1:00:00
2024-12-31 06:00:00-08:00 2024-12-31 07:00:00-08:00 2.193 0 0:00:00 1:00:00
2024-12-31 07:00:00-08:00 2024-12-31 08:00:00-08:00 2.0844 0 0:00:00 1:00:00
2024-12-31 08:00:00-08:00 2024-12-31 09:00:00-08:00 2.6208 0 0:00:00 1:00:00
2024-12-31 09:00:00-08:00 2024-12-31 10:00:00-08:00 1.4658 0 0:00:00 1:00:00
2024-12-31 10:00:00-08:00 2024-12-31 11:00:00-08:00 1.9662 0 0:00:00 1:00:00
2024-12-31 11:00:00-08:00 2024-12-31 12:00:00-08:00 2.2098 0 0:00:00 1:00:00
2024-12-31 12:00:00-08:00 2024-12-31 13:00:00-08:00 2.0076 0 0:00:00 1:00:00
2024-12-31 13:00:00-08:00 2024-12-31 14:00:00-08:00 3.0636 0 0:00:00 1:00:00
2024-12-31 14:00:00-08:00 2024-12-31 15:00:00-08:00 3.8148 0 0:00:00 1:00:00
2024-12-31 15:00:00-08:00 2024-12-31 16:00:00-08:00 3.2736 0 0:00:00 1:00:00
2024-12-31 16:00:00-08:00 2024-12-31 17:00:00-08:00 2.9802 0 0:00:00 1:00:00
2024-12-31 17:00:00-08:00 2024-12-31 18:00:00-08:00 3.0822 0 0:00:00 1:00:00
2024-12-31 18:00:00-08:00 2024-12-31 19:00:00-08:00 3.4962 0 0:00:00 1:00:00
2024-12-31 19:00:00-08:00 2024-12-31 20:00:00-08:00 2.6952 0 0:00:00 1:00:00
2024-12-31 20:00:00-08:00 2024-12-31 21:00:00-08:00 3.1758 0 0:00:00 1:00:00
2024-12-31 21:00:00-08:00 2024-12-31 22:00:00-08:00 3.0492 0 0:00:00 1:00:00
2024-12-31 22:00:00-08:00 2024-12-31 23:00:00-08:00 3.2424 0 0:00:00 1:00:00
2024-12-31 23:00:00-08:00 2025-01-01 00:00:00-08:00 2.9922 0 0:00:00 1:00:00
2025-01-01 00:00:00-08:00 2025-01-01 01:00:00-08:00 2.4012 0 0:00:00 1:00:00
2025-01-01 01:00:00-08:00 2025-01-01 02:00:00-08:00 2.2632 0 0:00:00 1:00:00
2025-01-01 02:00:00-08:00 2025-01-01 03:00:00-08:00 2.1102 0 0:00:00 1:00:00
2025-01-01 03:00:00-08:00 2025-01-01 04:00:00-08:00 2.4174 0 0:00:00 1:00:00
2025-01-01 04:00:00-08:00 2025-01-01 05:00:00-08:00 2.2728 0 0:00:00 1:00:00
2025-01-01 05:00:00-08:00 2025-01-01 06:00:00-08:00 2.2704 0 0:00:00 1:00:00
2025-01-01 06:00:00-08:00 2025-01-01 07:00:00-08:00 2.3412 0 0:00:00 1:00:00
2025-01-01 07:00:00-08:00 2025-01-01 08:00:00-08:00 1.9212 0 0:00:00 1:00:00
2025-01-01 08:00:00-08:00 2025-01-01 09:00:00-08:00 1.9854 0 0:00:00 1:00:00
2025-01-01 09:00:00-08:00 2025-01-01 10:00:00-08:00 1.9008 0 0:00:00 1:00:00
2025-01-01 10:00:00-08:00 2025-01-01 11:00:00-08:00 1.9836 0 0:00:00 1:00:00
2025-01-01 11:00:00-08:00 2025-01-01 12:00:00-08:00 1.8324 0 0:00:00 1:00:00
2025-01-01 12:00:00-08:00 2025-01-01 13:00:00-08:00 1.9614 0 0:00:00 1:00:00
2025-01-01 13:00:00-08:00 2025-01-01 14:00:00-08:00 3.1632 0 0:00:00 1:00:00
2025-01-01 14:00:00-08:00 2025-01-01 15:00:00-08:00 3.9846 0 0:00:00 1:00:00
2025-01-01 15:00:00-08:00 2025-01-01 16:00:00-08:00 2.592 0 0:00:00 1:00:00
2025-01-01 16:00:00-08:00 2025-01-01 17:00:00-08:00 2.3892 0 0:00:00 1:00:00
2025-01-01 17:00:00-08:00 2025-01-01 18:00:00-08:00 2.0484 0 0:00:00 1:00:00
2025-01-01 18:00:00-08:00 2025-01-01 19:00:00-08:00 3.6648 0 0:00:00 1:00:00
2025-01-01 19:00:00-08:00 2025-01-01 20:00:00-08:00 2.9634 0 0:00:00 1:00:00
2025-01-01 20:00:00-08:00 2025-01-01 21:00:00-08:00 3.1236 0 0:00:00 1:00:00
2025-01-01 21:00:00-08:00 2025-01-01 22:00:00-08:00 2.9658 0 0:00:00 1:00:00
2025-01-01 22:00:00-08:00 2025-01-01 23:00:00-08:00 2.1912 0 0:00:00 1:00:00
2025-01-01 23:00:00-08:00 2025-01-02 00:00:00-08:00 2.22 0 0:00:00 1:00:00
2025-01-02 00:00:00-08:00 2025-01-02 01:00:00-08:00 2.0118 0 0:00:00 1:00:00
2025-01-02 01:00:00-08:00 2025-01-02 02:00:00-08:00 2.1732 0 0:00:00 1:00:00
2025-01-02 02:00:00-08:00 2025-01-02 03:00:00-08:00 2.286 0 0:00:00 1:00:00
2025-01-02 03:00:00-08:00 2025-01-02 04:00:00-08:00 2.6352 0 0:00:00 1:00:00
2025-01-02 04:00:00-08:00 2025-01-02 05:00:00-08:00 2.4378 0 0:00:00 1:00:00
2025-01-02 05:00:00-08:00 2025-01-02 06:00:00-08:00 1.8384 0 0:00:00 1:00:00
2025-01-02 06:00:00-08:00 2025-01-02 07:00:00-08:00 1.884 0 0:00:00 1:00:00
2025-01-02 07:00:00-08:00 2025-01-02 08:00:00-08:00 2.0622 0 0:00:00 1:00:00
2025-01-02 08:00:00-08:00 2025-01-02 09:00:00-08:00 2.0442 0 0:00:00 1:00:00
2025-01-02 09:00:00-08:00 2025-01-02 10:00:00-08:00 1.9812 0 0:00:00 1:00:00
2025-01-02 10:00:00-08:00 2025-01-02 11:00:00-08:00 1.9986 0 0:00:00 1:00:00
2025-01-02 11:00:00-08:00 2025-01-02 12:00:00-08:00 1.9122 0 0:00:00 1:00:00
2025-01-02 12:00:00-08:00 2025-01-02 13:00:00-08:00 1.7556 0 0:00:00 1:00:00
2025-01-02 13:00:00-08:00 2025-01-02 14:00:00-08:00 3.6144 0 0:00:00 1:00:00
2025-01-02 14:00:00-08:00 2025-01-02 15:00:00-08:00 3.4128 0 0:00:00 1:00:00
2025-01-02 15:00:00-08:00 2025-01-02 16:00:00-08:00 3.6492 0 0:00:00 1:00:00
2025-01-02 16:00:00-08:00 2025-01-02 17:00:00-08:00 2.9298 0 0:00:00 1:00:00
2025-01-02 17:00:00-08:00 2025-01-02 18:00:00-08:00 3.5754 0 0:00:00 1:00:00
2025-01-02 18:00:00-08:00 2025-01-02 19:00:00-08:00 2.9004 0 0:00:00 1:00:00
2025-01-02 19:00:00-08:00 2025-01-02 20:00:00-08:00 2.6256 0 0:00:00 1:00:00
2025-01-02 20:00:00-08:00 2025-01-02 21:00:00-08:00 3.051 0 0:00:00 1:00:00
2025-01-02 21:00:00-08:00 2025-01-02 22:00:00-08:00 2.8248 0 0:00:00 1:00:00
2025-01-02 22:00:00-08:00 2025-01-02 23:00:00-08:00 2.2578 0 0:00:00 1:00:00
2025-01-02 23:00:00-08:00 2025-01-03 00:00:00-08:00 2.1402 0 0:00:00 1:00:00
2025-01-03 00:00:00-08:00 2025-01-03 01:00:00-08:00 2.238 0 0:00:00 1:00:00
2025-01-03 01:00:00-08:00 2025-01-03 02:00:00-08:00 2.436 0 0:00:00 1:00:00
2025-01-03 02:00:00-08:00 2025-01-03 03:00:00-08:00 2.211 0 0:00:00 1:00:00
2025-01-03 03:00:00-08:00 2025-01-03 04:00:00-08:00 2.1738 0 0:00:00 1:00:00
2025-01-03 04:00:00-08:00 2025-01-03 05:00:00-08:00 1.758 0 0:00:00 1:00:00
2025-01-03 05:00:00-08:00 2025-01-03 06:00:00-08:00 1.8198 0 0:00:00 1:00:00
2025-01-03 06:00:00-08:00 2025-01-03 07:00:00-08:00 1.851 0 0:00:00 1:00:00
2025-01-03 07:00:00-08:00 2025-01-03 08:00:00-08:00 1.9014 0 0:00:00 1:00:00
2025-01-03 08:00:00-08:00 2025-01-03 09:00:00-08:00 1.863 0 0:00:00 1:00:00
2025-01-03 09:00:00-08:00 2025-01-03 10:00:00-08:00 1.8606 0 0:00:00 1:00:00
2025-01-03 10:00:00-08:00 2025-01-03 11:00:00-08:00 2.034 0 0:00:00 1:00:00
2025-01-03 11:00:00-08:00 2025-01-03 12:00:00-08:00 1.8084 0 0:00:00 1:00:00
2025-01-03 12:00:00-08:00 2025-01-03 13:00:00-08:00 1.662 0 0:00:00 1:00:00
2025-01-03 13:00:00-08:00 2025-01-03 14:00:00-08:00 3.057 0 0:00:00 1:00:00
2025-01-03 14:00:00-08:00 2025-01-03 15:00:00-08:00 3.8274 0 0:00:00 1:00:00
2025-01-03 15:00:00-08:00 2025-01-03 16:00:00-08:00 2.4882 0 0:00:00 1:00:00
2025-01-03 16:00:00-08:00 2025-01-03 17:00:00-08:00 2.8446 0 0:00:00 1:00:00
2025-01-03 17:00:00-08:00 2025-01-03 18:00:00-08:00 3.0252 0 0:00:00 1:00:00
2025-01-03 18:00:00-08:00 2025-01-03 19:00:00-08:00 3.0276 0 0:00:00 1:00:00
2025-01-03 19:00:00-08:00 2025-01-03 20:00:00-08:00 2.7354 0 0:00:00 1:00:00
2025-01-03 20:00:00-08:00 2025-01-03 21:00:00-08:00 2.9538 0 0:00:00 1:00:00
2025-01-03 21:00:00-08:00 2025-01-03 22:00:00-08:00 2.9382 0 0:00:00 1:00:00
2025-01-03 22:00:00-08:00 2025-01-03 23:00:00-08:00 2.1522 0 0:00:00 1:00:00
2025-01-03 23:00:00-08:00 2025-01-04 00:00:00-08:00 2.2596 0 0:00:00 1:00:00
2025-01-04 00:00:00-08:00 2025-01-04 01:00:00-08:00 2.4246 0 0:00:00 1:00:00
2025-01-04 01:00:00-08:00 2025-01-04 02:00:00-08:00 2.2176 0 0:00:00 1:00:00
2025-01-04 02:00:00-08:00 2025-01-04 03:00:00-08:00 2.3364 0 0:00:00 1:00:00
2025-01-04 03:00:00-08:00 2025-01-04 04:00:00-08:00 2.406 0 0:00:00 1:00:00
2025-01-04 04:00:00-08:00 2025-01-04 05:00:00-08:00 2.19 0 0:00:00 1:00:00
2025-01-04 05:00:00-08:00 2025-01-04 06:00:00-08:00 2.1882 0 0:00:00 1:00:00
2025-01-04 06:00:00-08:00 2025-01-04 07:00:00-08:00 1.9242 0 0:00:00 1:00:00
2025-01-04 07:00:00-08:00 2025-01-04 08:00:00-08:00 1.7796 0 0:00:00 1:00:00
2025-01-04 08:00:00-08:00 2025-01-04 09:00:00-08:00 1.803 0 0:00:00 1:00:00
2025-01-04 09:00:00-08:00 2025-01-04 10:00:00-08:00 1.7394 0 0:00:00 1:00:00
2025-01-04 10:00:00-08:00 2025-01-04 11:00:00-08:00 1.8918 0 0:00:00 1:00:00
2025-01-04 11:00:00-08:00 2025-01-04 12:00:00-08:00 1.6578 0 0:00:00 1:00:00
2025-01-04 12:00:00-08:00 2025-01-04 13:00:00-08:00 1.818 0 0:00:00 1:00:00
2025-01-04 13:00:00-08:00 2025-01-04 14:00:00-08:00 3.0252 0 0:00:00 1:00:00
2025-01-04 14:00:00-08:00 2025-01-04 15:00:00-08:00 3.591 0 0:00:00 1:00:00
2025-01-04 15:00:00-08:00 2025-01-04 16:00:00-08:00 2.3244 0 0:00:00 1:00:00
2025-01-04 16:00:00-08:00 2025-01-04 17:00:00-08:00 2.7426 0 0:00:00 1:00:00
2025-01-04 17:00:00-08:00 2025-01-04 18:00:00-08:00 3.5826 0 0:00:00 1:00:00
2025-01-04 18:00:00-08:00 2025-01-04 19:00:00-08:00 3.1254 0 0:00:00 1:00:00
2025-01-04 19:00:00-08:00 2025-01-04 20:00:00-08:00 2.5296 0 0:00:00 1:00:00
2025-01-04 20:00:00-08:00 2025-01-04 21:00:00-08:00 2.8002 0 0:00:00 1:00:00
2025-01-04 21:00:00-08:00 2025-01-04 22:00:00-08:00 2.7192 0 0:00:00 1:00:00
2025-01-04 22:00:00-08:00 2025-01-04 23:00:00-08:00 2.2932 0 0:00:00 1:00:00
2025-01-04 23:00:00-08:00 2025-01-05 00:00:00-08:00 2.3334 0 0:00:00 1:00:00
2025-01-05 00:00:00-08:00 2025-01-05 01:00:00-08:00 2.3076 0 0:00:00 1:00:00
2025-01-05 01:00:00-08:00 2025-01-05 02:00:00-08:00 2.2488 0 0:00:00 1:00:00
2025-01-05 02:00:00-08:00 2025-01-05 03:00:00-08:00 2.1648 0 0:00:00 1:00:00
2025-01-05 03:00:00-08:00 2025-01-05 04:00:00-08:00 2.172 0 0:00:00 1:00:00
2025-01-05 04:00:00-08:00 2025-01-05 05:00:00-08:00 2.3394 0 0:00:00 1:00:00
2025-01-05 05:00:00-08:00 2025-01-05 06:00:00-08:00 2.2236 0 0:00:00 1:00:00
2025-01-05 06:00:00-08:00 2025-01-05 07:00:00-08:00 1.839 0 0:00:00 1:00:00
2025-01-05 07:00:00-08:00 2025-01-05 08:00:00-08:00 1.7214 0 0:00:00 1:00:00
2025-01-05 08:00:00-08:00 2025-01-05 09:00:00-08:00 1.638 0 0:00:00 1:00:00
2025-01-05 09:00:00-08:00 2025-01-05 10:00:00-08:00 1.7214 0 0:00:00 1:00:00
2025-01-05 10:00:00-08:00 2025-01-05 11:00:00-08:00 1.7028 0 0:00:00 1:00:00
2025-01-05 11:00:00-08:00 2025-01-05 12:00:00-08:00 1.743 0 0:00:00 1:00:00
2025-01-05 12:00:00-08:00 2025-01-05 13:00:00-08:00 1.7028 0 0:00:00 1:00:00
2025-01-05 13:00:00-08:00 2025-01-05 14:00:00-08:00 2.1096 0 0:00:00 1:00:00
2025-01-05 14:00:00-08:00 2025-01-05 15:00:00-08:00 3.5154 0 0:00:00 1:00:00
2025-01-05 15:00:00-08:00 2025-01-05 16:00:00-08:00 2.1282 0 0:00:00 1:00:00
2025-01-05 16:00:00-08:00 2025-01-05 17:00:00-08:00 2.5806 0 0:00:00 1:00:00
2025-01-05 17:00:00-08:00 2025-01-05 18:00:00-08:00 2.9286 0 0:00:00 1:00:00
2025-01-05 18:00:00-08:00 2025-01-05 19:00:00-08:00 2.4888 0 0:00:00 1:00:00
2025-01-05 19:00:00-08:00 2025-01-05 20:00:00-08:00 2.487 0 0:00:00 1:00:00
2025-01-05 20:00:00-08:00 2025-01-05 21:00:00-08:00 2.5056 0 0:00:00 1:00:00
2025-01-05 21:00:00-08:00 2025-01-05 22:00:00-08:00 2.4996 0 0:00:00 1:00:00
2025-01-05 22:00:00-08:00 2025-01-05 23:00:00-08:00 2.1558 0 0:00:00 1:00:00
2025-01-05 23:00:00-08:00 2025-01-06 00:00:00-08:00 2.1654 0 0:00:00 1:00:00
2025-01-06 00:00:00-08:00 2025-01-06 01:00:00-08:00 2.1 0 0:00:00 1:00:00
2025-01-06 01:00:00-08:00 2025-01-06 02:00:00-08:00 2.2974 0 0:00:00 1:00:00
2025-01-06 02:00:00-08:00 2025-01-06 03:00:00-08:00 2.1672 0 0:00:00 1:00:00
2025-01-06 03:00:00-08:00 2025-01-06 04:00:00-08:00 2.4504 0 0:00:00 1:00:00
2025-01-06 04:00:00-08:00 2025-01-06 05:00:00-08:00 1.932 0 0:00:00 1:00:00
2025-01-06 05:00:00-08:00 2025-01-06 06:00:00-08:00 1.8978 0 0:00:00 1:00:00
2025-01-06 06:00:00-08:00 2025-01-06 07:00:00-08:00 1.9878 0 0:00:00 1:00:00
2025-01-06 07:00:00-08:00 2025-01-06 08:00:00-08:00 1.797 0 0:00:00 1:00:00
2025-01-06 08:00:00-08:00 2025-01-06 09:00:00-08:00 1.5708 0 0:00:00 1:00:00
2025-01-06 09:00:00-08:00 2025-01-06 10:00:00-08:00 1.8192 0 0:00:00 1:00:00
2025-01-06 10:00:00-08:00 2025-01-06 11:00:00-08:00 1.527 0 0:00:00 1:00:00
2025-01-06 11:00:00-08:00 2025-01-06 12:00:00-08:00 1.6128 0 0:00:00 1:00:00
2025-01-06 12:00:00-08:00 2025-01-06 13:00:00-08:00 1.6416 0 0:00:00 1:00:00
2025-01-06 13:00:00-08:00 2025-01-06 14:00:00-08:00 3.2412 0 0:00:00 1:00:00
2025-01-06 14:00:00-08:00 2025-01-06 15:00:00-08:00 3.489 0 0:00:00 1:00:00
2025-01-06 15:00:00-08:00 2025-01-06 16:00:00-08:00 2.4396 0 0:00:00 1:00:00
2025-01-06 16:00:00-08:00 2025-01-06 17:00:00-08:00 2.847 0 0:00:00 1:00:00
2025-01-06 17:00:00-08:00 2025-01-06 18:00:00-08:00 3.1884 0 0:00:00 1:00:00
2025-01-06 18:00:00-08:00 2025-01-06 19:00:00-08:00 2.742 0 0:00:00 1:00:00
2025-01-06 19:00:00-08:00 2025-01-06 20:00:00-08:00 2.6358 0 0:00:00 1:00:00
2025-01-06 20:00:00-08:00 2025-01-06 21:00:00-08:00 2.6886 0 0:00:00 1:00:00
2025-01-06 21:00:00-08:00 2025-01-06 22:00:00-08:00 2.9112 0 0:00:00 1:00:00
2025-01-06 22:00:00-08:00 2025-01-06 23:00:00-08:00 2.4006 0 0:00:00 1:00:00
2025-01-06 23:00:00-08:00 2025-01-07 00:00:00-08:00 2.3406 0 0:00:00 1:00:00
Getting historical data: account= Account(customer=Customer(uuid='00000001'), uuid='00000000', utility_account_id='0000', id='0000', meter_type=<MeterType.GAS: 'GAS'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= hour start_date= 2024-12-30 00:00:00 end_date= 2025-01-05 00:00:00
start_time end_time consumption provided_cost start_minus_prev_end end_minus_prev_end
2024-12-30 00:00:00-08:00 2024-12-30 01:00:00-08:00 0.02 0 None None
2024-12-30 01:00:00-08:00 2024-12-30 02:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-30 02:00:00-08:00 2024-12-30 03:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-30 03:00:00-08:00 2024-12-30 04:00:00-08:00 0.04 0 0:00:00 1:00:00
2024-12-30 04:00:00-08:00 2024-12-30 05:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-30 05:00:00-08:00 2024-12-30 06:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-30 06:00:00-08:00 2024-12-30 07:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-30 07:00:00-08:00 2024-12-30 08:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-30 08:00:00-08:00 2024-12-30 09:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-30 09:00:00-08:00 2024-12-30 10:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-30 10:00:00-08:00 2024-12-30 11:00:00-08:00 0.08 0 0:00:00 1:00:00
2024-12-30 11:00:00-08:00 2024-12-30 12:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-30 12:00:00-08:00 2024-12-30 13:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-30 13:00:00-08:00 2024-12-30 14:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-30 14:00:00-08:00 2024-12-30 15:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-30 15:00:00-08:00 2024-12-30 16:00:00-08:00 0.06 0 0:00:00 1:00:00
2024-12-30 16:00:00-08:00 2024-12-30 17:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-30 17:00:00-08:00 2024-12-30 18:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-30 18:00:00-08:00 2024-12-30 19:00:00-08:00 0.04 0 0:00:00 1:00:00
2024-12-30 19:00:00-08:00 2024-12-30 20:00:00-08:00 0.06 0 0:00:00 1:00:00
2024-12-30 20:00:00-08:00 2024-12-30 21:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-30 21:00:00-08:00 2024-12-30 22:00:00-08:00 0.06 0 0:00:00 1:00:00
2024-12-30 22:00:00-08:00 2024-12-30 23:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-30 23:00:00-08:00 2024-12-31 00:00:00-08:00 0.06 0 0:00:00 1:00:00
2024-12-31 00:00:00-08:00 2024-12-31 01:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-31 01:00:00-08:00 2024-12-31 02:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-31 02:00:00-08:00 2024-12-31 03:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-31 03:00:00-08:00 2024-12-31 04:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-31 04:00:00-08:00 2024-12-31 05:00:00-08:00 0.06 0 0:00:00 1:00:00
2024-12-31 05:00:00-08:00 2024-12-31 06:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-31 06:00:00-08:00 2024-12-31 07:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-31 07:00:00-08:00 2024-12-31 08:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-31 08:00:00-08:00 2024-12-31 09:00:00-08:00 0.1 0 0:00:00 1:00:00
2024-12-31 09:00:00-08:00 2024-12-31 10:00:00-08:00 0.08 0 0:00:00 1:00:00
2024-12-31 10:00:00-08:00 2024-12-31 11:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-31 11:00:00-08:00 2024-12-31 12:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-31 12:00:00-08:00 2024-12-31 13:00:00-08:00 0.08 0 0:00:00 1:00:00
2024-12-31 13:00:00-08:00 2024-12-31 14:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-31 14:00:00-08:00 2024-12-31 15:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-31 15:00:00-08:00 2024-12-31 16:00:00-08:00 0.04 0 0:00:00 1:00:00
2024-12-31 16:00:00-08:00 2024-12-31 17:00:00-08:00 0.06 0 0:00:00 1:00:00
2024-12-31 17:00:00-08:00 2024-12-31 18:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-31 18:00:00-08:00 2024-12-31 19:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-31 19:00:00-08:00 2024-12-31 20:00:00-08:00 0.04 0 0:00:00 1:00:00
2024-12-31 20:00:00-08:00 2024-12-31 21:00:00-08:00 0 0 0:00:00 1:00:00
2024-12-31 21:00:00-08:00 2024-12-31 22:00:00-08:00 0.02 0 0:00:00 1:00:00
2024-12-31 22:00:00-08:00 2024-12-31 23:00:00-08:00 0.04 0 0:00:00 1:00:00
2024-12-31 23:00:00-08:00 2025-01-01 00:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-01 00:00:00-08:00 2025-01-01 01:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-01 01:00:00-08:00 2025-01-01 02:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-01 02:00:00-08:00 2025-01-01 03:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-01 03:00:00-08:00 2025-01-01 04:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 04:00:00-08:00 2025-01-01 05:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-01 05:00:00-08:00 2025-01-01 06:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 06:00:00-08:00 2025-01-01 07:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-01 07:00:00-08:00 2025-01-01 08:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 08:00:00-08:00 2025-01-01 09:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-01 09:00:00-08:00 2025-01-01 10:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 10:00:00-08:00 2025-01-01 11:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-01 11:00:00-08:00 2025-01-01 12:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 12:00:00-08:00 2025-01-01 13:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-01 13:00:00-08:00 2025-01-01 14:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 14:00:00-08:00 2025-01-01 15:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-01 15:00:00-08:00 2025-01-01 16:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-01 16:00:00-08:00 2025-01-01 17:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-01 17:00:00-08:00 2025-01-01 18:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 18:00:00-08:00 2025-01-01 19:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-01 19:00:00-08:00 2025-01-01 20:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-01 20:00:00-08:00 2025-01-01 21:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 21:00:00-08:00 2025-01-01 22:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-01 22:00:00-08:00 2025-01-01 23:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-01 23:00:00-08:00 2025-01-02 00:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 00:00:00-08:00 2025-01-02 01:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-02 01:00:00-08:00 2025-01-02 02:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-02 02:00:00-08:00 2025-01-02 03:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 03:00:00-08:00 2025-01-02 04:00:00-08:00 0.28 0 0:00:00 1:00:00
2025-01-02 04:00:00-08:00 2025-01-02 05:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 05:00:00-08:00 2025-01-02 06:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-02 06:00:00-08:00 2025-01-02 07:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 07:00:00-08:00 2025-01-02 08:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 08:00:00-08:00 2025-01-02 09:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-02 09:00:00-08:00 2025-01-02 10:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-02 10:00:00-08:00 2025-01-02 11:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 11:00:00-08:00 2025-01-02 12:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-02 12:00:00-08:00 2025-01-02 13:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 13:00:00-08:00 2025-01-02 14:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-02 14:00:00-08:00 2025-01-02 15:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 15:00:00-08:00 2025-01-02 16:00:00-08:00 0.1 0 0:00:00 1:00:00
2025-01-02 16:00:00-08:00 2025-01-02 17:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 17:00:00-08:00 2025-01-02 18:00:00-08:00 0.16 0 0:00:00 1:00:00
2025-01-02 18:00:00-08:00 2025-01-02 19:00:00-08:00 0.1 0 0:00:00 1:00:00
2025-01-02 19:00:00-08:00 2025-01-02 20:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 20:00:00-08:00 2025-01-02 21:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-02 21:00:00-08:00 2025-01-02 22:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 22:00:00-08:00 2025-01-02 23:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-02 23:00:00-08:00 2025-01-03 00:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-03 00:00:00-08:00 2025-01-03 01:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 01:00:00-08:00 2025-01-03 02:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 02:00:00-08:00 2025-01-03 03:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-03 03:00:00-08:00 2025-01-03 04:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 04:00:00-08:00 2025-01-03 05:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 05:00:00-08:00 2025-01-03 06:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 06:00:00-08:00 2025-01-03 07:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 07:00:00-08:00 2025-01-03 08:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 08:00:00-08:00 2025-01-03 09:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 09:00:00-08:00 2025-01-03 10:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-03 10:00:00-08:00 2025-01-03 11:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 11:00:00-08:00 2025-01-03 12:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 12:00:00-08:00 2025-01-03 13:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 13:00:00-08:00 2025-01-03 14:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 14:00:00-08:00 2025-01-03 15:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 15:00:00-08:00 2025-01-03 16:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-03 16:00:00-08:00 2025-01-03 17:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 17:00:00-08:00 2025-01-03 18:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 18:00:00-08:00 2025-01-03 19:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 19:00:00-08:00 2025-01-03 20:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-03 20:00:00-08:00 2025-01-03 21:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 21:00:00-08:00 2025-01-03 22:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-03 22:00:00-08:00 2025-01-03 23:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-03 23:00:00-08:00 2025-01-04 00:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 00:00:00-08:00 2025-01-04 01:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-04 01:00:00-08:00 2025-01-04 02:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 02:00:00-08:00 2025-01-04 03:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-04 03:00:00-08:00 2025-01-04 04:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 04:00:00-08:00 2025-01-04 05:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-04 05:00:00-08:00 2025-01-04 06:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-04 06:00:00-08:00 2025-01-04 07:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-04 07:00:00-08:00 2025-01-04 08:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 08:00:00-08:00 2025-01-04 09:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-04 09:00:00-08:00 2025-01-04 10:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 10:00:00-08:00 2025-01-04 11:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-04 11:00:00-08:00 2025-01-04 12:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 12:00:00-08:00 2025-01-04 13:00:00-08:00 0.08 0 0:00:00 1:00:00
2025-01-04 13:00:00-08:00 2025-01-04 14:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 14:00:00-08:00 2025-01-04 15:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 15:00:00-08:00 2025-01-04 16:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-04 16:00:00-08:00 2025-01-04 17:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-04 17:00:00-08:00 2025-01-04 18:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 18:00:00-08:00 2025-01-04 19:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-04 19:00:00-08:00 2025-01-04 20:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-04 20:00:00-08:00 2025-01-04 21:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-04 21:00:00-08:00 2025-01-04 22:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 22:00:00-08:00 2025-01-04 23:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-04 23:00:00-08:00 2025-01-05 00:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 00:00:00-08:00 2025-01-05 01:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 01:00:00-08:00 2025-01-05 02:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 02:00:00-08:00 2025-01-05 03:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 03:00:00-08:00 2025-01-05 04:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 04:00:00-08:00 2025-01-05 05:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-05 05:00:00-08:00 2025-01-05 06:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 06:00:00-08:00 2025-01-05 07:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 07:00:00-08:00 2025-01-05 08:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 08:00:00-08:00 2025-01-05 09:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 09:00:00-08:00 2025-01-05 10:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 10:00:00-08:00 2025-01-05 11:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 11:00:00-08:00 2025-01-05 12:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 12:00:00-08:00 2025-01-05 13:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 13:00:00-08:00 2025-01-05 14:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 14:00:00-08:00 2025-01-05 15:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 15:00:00-08:00 2025-01-05 16:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-05 16:00:00-08:00 2025-01-05 17:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-05 17:00:00-08:00 2025-01-05 18:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-05 18:00:00-08:00 2025-01-05 19:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-05 19:00:00-08:00 2025-01-05 20:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 20:00:00-08:00 2025-01-05 21:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 21:00:00-08:00 2025-01-05 22:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-05 22:00:00-08:00 2025-01-05 23:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-05 23:00:00-08:00 2025-01-06 00:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 00:00:00-08:00 2025-01-06 01:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 01:00:00-08:00 2025-01-06 02:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 02:00:00-08:00 2025-01-06 03:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-06 03:00:00-08:00 2025-01-06 04:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-06 04:00:00-08:00 2025-01-06 05:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 05:00:00-08:00 2025-01-06 06:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 06:00:00-08:00 2025-01-06 07:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 07:00:00-08:00 2025-01-06 08:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 08:00:00-08:00 2025-01-06 09:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 09:00:00-08:00 2025-01-06 10:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 10:00:00-08:00 2025-01-06 11:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 11:00:00-08:00 2025-01-06 12:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 12:00:00-08:00 2025-01-06 13:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 13:00:00-08:00 2025-01-06 14:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 14:00:00-08:00 2025-01-06 15:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 15:00:00-08:00 2025-01-06 16:00:00-08:00 0.06 0 0:00:00 1:00:00
2025-01-06 16:00:00-08:00 2025-01-06 17:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-06 17:00:00-08:00 2025-01-06 18:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 18:00:00-08:00 2025-01-06 19:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 19:00:00-08:00 2025-01-06 20:00:00-08:00 0.04 0 0:00:00 1:00:00
2025-01-06 20:00:00-08:00 2025-01-06 21:00:00-08:00 0.02 0 0:00:00 1:00:00
2025-01-06 21:00:00-08:00 2025-01-06 22:00:00-08:00 0 0 0:00:00 1:00:00
2025-01-06 22:00:00-08:00 2025-01-06 23:00:00-08:00 0.02 0 0:00:00 1:00:00
Opower Daily Data
Getting historical data: account= Account(customer=Customer(uuid='00000001'), uuid='00000002', utility_account_id='0001', id='0001', meter_type=<MeterType.ELEC: 'ELEC'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= day start_date= 2024-12-30 00:00:00 end_date= 2025-01-05 00:00:00
start_time end_time consumption provided_cost start_minus_prev_end end_minus_prev_end
2024-12-30 00:00:00-08:00 2024-12-31 00:00:00-08:00 60.1662 0 None None
2024-12-31 00:00:00-08:00 2025-01-01 00:00:00-08:00 62.6388 0 0:00:00 1 day, 0:00:00
2025-01-01 00:00:00-08:00 2025-01-02 00:00:00-08:00 58.9674 0 0:00:00 1 day, 0:00:00
2025-01-02 00:00:00-08:00 2025-01-03 00:00:00-08:00 60.0018 0 0:00:00 1 day, 0:00:00
2025-01-03 00:00:00-08:00 2025-01-04 00:00:00-08:00 56.9262 0 0:00:00 1 day, 0:00:00
2025-01-04 00:00:00-08:00 2025-01-05 00:00:00-08:00 57.4434 0 0:00:00 1 day, 0:00:00
2025-01-05 00:00:00-08:00 2025-01-06 00:00:00-08:00 53.0892 0 0:00:00 1 day, 0:00:00
2025-01-06 00:00:00-08:00 2025-01-07 00:00:00-08:00 55.725 0 0:00:00 1 day, 0:00:00
Getting historical data: account= Account(customer=Customer(uuid='00000001'), uuid='00000000', utility_account_id='0000', id='0000', meter_type=<MeterType.GAS: 'GAS'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= day start_date= 2024-12-30 00:00:00 end_date= 2025-01-05 00:00:00
start_time end_time consumption provided_cost start_minus_prev_end end_minus_prev_end
2024-12-30 00:00:00-08:00 2024-12-31 00:00:00-08:00 0.58 0 None None
2024-12-31 00:00:00-08:00 2025-01-01 00:00:00-08:00 0.7 0 0:00:00 1 day, 0:00:00
2025-01-01 00:00:00-08:00 2025-01-02 00:00:00-08:00 0.52 0 0:00:00 1 day, 0:00:00
2025-01-02 00:00:00-08:00 2025-01-03 00:00:00-08:00 0.98 0 0:00:00 1 day, 0:00:00
2025-01-03 00:00:00-08:00 2025-01-04 00:00:00-08:00 0.4 0 0:00:00 1 day, 0:00:00
2025-01-04 00:00:00-08:00 2025-01-05 00:00:00-08:00 0.52 0 0:00:00 1 day, 0:00:00
2025-01-05 00:00:00-08:00 2025-01-06 00:00:00-08:00 0.46 0 0:00:00 1 day, 0:00:00
2025-01-06 00:00:00-08:00 2025-01-07 00:00:00-08:00 0.44 0 0:00:00 1 day, 0:00:00
Opower Billing Data
Getting historical data: account= Account(customer=Customer(uuid='00000001'), uuid='00000002', utility_account_id='0001', id='0001', meter_type=<MeterType.ELEC: 'ELEC'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= bill start_date= 2024-12-30 00:00:00 end_date= 2025-01-05 00:00:00
start_time end_time consumption provided_cost start_minus_prev_end end_minus_prev_end
2024-11-28 00:00:00-08:00 2024-12-31 00:00:00-08:00 1810.0 255.58 None None
2024-12-31 00:00:00-08:00 2025-01-30 00:00:00-08:00 1717.0 237.89 0:00:00 30 days, 0:00:00
Getting historical data: account= Account(customer=Customer(uuid='00000001'), uuid='00000000', utility_account_id='0000', id='0000', meter_type=<MeterType.GAS: 'GAS'>, read_resolution=<ReadResolution.QUARTER_HOUR: 'QUARTER_HOUR'>) aggregate_type= bill start_date= 2024-12-30 00:00:00 end_date= 2025-01-05 00:00:00
start_time end_time consumption provided_cost start_minus_prev_end end_minus_prev_end
2024-11-28 00:00:00-08:00 2024-12-31 00:00:00-08:00 50.028 59.51 None None
2024-12-31 00:00:00-08:00 2025-01-30 00:00:00-08:00 58.794 69.22 0:00:00 30 days, 0:00:00
What do you see on your utility website for one of these dates? It was either a bug on the opower side or on the integration whenever it pulled that data. One way to resolve this is to delete all Opower statistics at https://my.home-assistant.io/create-link/?redirect=developer_statistics and reload the integration. You will have to enter selection mode, button on the left of the search box, select all opower statistics, and click on delete selected statistics.
Hm, I didn't think about it beforehand, but the return statistics are only calculated for the past 2 months of hourly data, but the issues were from at least 5 months ago, so I unfortunately don't actually get to see if anything changed...
The integration every 12h pulls hourly data from the past 2 months to apply any corrections to the data from your utility. This is supposed to override any existing values. Maybe there is a bug and this produced negative values?
Does your utility offer a download option of your usage? Can you check whether it says estimated usage for those dates?
If you want to see the data stored in your recorder database see #143993 for some examples of SQL queries you could run. Maybe you could compare with the current data you got from the API and see if there is any pattern?
Note, the first time the new code in 2025.5 ran it looked for any negative values in existing statistics and moved them to separate statistics. If you don't want to lose granular old consumption data, an alternative to deleting all opower statistics is to just delete the return ones and reload the integration. The migration will run again but this time it won't find any negative values.
Does your utility offer a download option of your usage? Can you check whether it says estimated usage for those dates?
The data seems okay. The entire NOTES column is empty, but the usage is always a small, but positive number.
To further confirm it, the query you provided to check for compensation returned nothing.
SELECT
DATETIME(s.start_ts, 'unixepoch', 'localtime') AS start_timestamp,
s.state,
sm.name
FROM statistics_meta AS sm
JOIN statistics AS s ON s.metadata_id = sm.id
WHERE sm.source = "opower"
AND sm.statistic_id like "%compensation"
AND s.state > 0;
The return query obviously gives the same data as the HA statistic graph I provided above though.
Return Data
| start_timestamp | state | name |
|---|---|---|
| 2024-06-29 01:00:00 | 30.84299999999348 | Opower pse elec 000 return |
| 2024-06-30 01:00:00 | 30.89879999999539 | Opower pse elec 000 return |
| 2024-07-01 01:00:00 | 29.87159999999858 | Opower pse elec 000 return |
| 2024-07-31 00:00:00 | 31.187400000024354 | Opower pse elec 000 return |
| 2024-08-30 00:00:00 | 41.14919999999984 | Opower pse elec 000 return |
| 2024-09-29 01:00:00 | 49.20419999999285 | Opower pse elec 000 return |
| 2024-09-30 01:00:00 | 35.88779999999679 | Opower pse elec 000 return |
| 2024-10-01 01:00:00 | 36.73079999999027 | Opower pse elec 000 return |
| 2024-11-29 01:00:00 | 49.897200000006706 | Opower pse elec 000 return |
| 2024-11-30 01:00:00 | 43.981199999994715 | Opower pse elec 000 return |
| 2024-12-01 01:00:00 | 43.12080000000424 | Opower pse elec 000 return |
| 2025-01-01 00:00:00 | 1.282199999972363 | Opower pse elec 000 return |
| 2025-01-01 01:00:00 | 54.302999999999884 | Opower pse elec 000 return |
| 2025-01-02 01:00:00 | 55.81680000000051 | Opower pse elec 000 return |
| 2024-06-29 01:00:00 | 0.27999999999974534 | Opower pse gas 999 return |
| 2024-06-30 01:00:00 | 0.15999999999985448 | Opower pse gas 999 return |
| 2024-07-01 01:00:00 | 0.15999999999985448 | Opower pse gas 999 return |
| 2024-07-02 00:00:00 | 2.7284841053187847e-12 | Opower pse gas 999 return |
| 2024-08-30 00:00:00 | 0.26000000000294676 | Opower pse gas 999 return |
| 2024-08-30 01:00:00 | 0.1999999999998181 | Opower pse gas 999 return |
| 2024-08-31 01:00:00 | 0.1999999999998181 | Opower pse gas 999 return |
| 2024-09-01 01:00:00 | 0.1999999999998181 | Opower pse gas 999 return |
| 2024-09-29 01:00:00 | 0.41999999999916326 | Opower pse gas 999 return |
| 2024-09-30 01:00:00 | 0.3400000000001455 | Opower pse gas 999 return |
| 2024-10-01 01:00:00 | 0.23999999999978172 | Opower pse gas 999 return |
| 2024-10-31 00:00:00 | 0.06000000000312866 | Opower pse gas 999 return |
| 2024-11-29 00:00:00 | 1.200000000001637 | Opower pse gas 999 return |
| 2024-11-29 01:00:00 | 1.0799999999999272 | Opower pse gas 999 return |
| 2024-11-30 01:00:00 | 1.2399999999997817 | Opower pse gas 999 return |
| 2024-12-01 01:00:00 | 2.360000000000582 | Opower pse gas 999 return |
| 2024-12-02 01:00:00 | 1.699999999999818 | Opower pse gas 999 return |
| 2025-01-01 00:00:00 | 0.16000000000349246 | Opower pse gas 999 return |
| 2025-01-01 01:00:00 | 0.42000000000007276 | Opower pse gas 999 return |
| 2025-01-02 01:00:00 | 0.9399999999995998 | Opower pse gas 999 return |
| 2025-01-03 00:00:00 | 5.4569682106375694e-12 | Opower pse gas 999 return |
| 2025-01-31 00:00:00 | 2.020000000003165 | Opower pse gas 999 return |
I can definitely just delete the erroneous return values and call it good, but I am just curious as to what went wrong, as maybe it's a small bug somewhere.
There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates. Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.
![issue-triage-workflows[bot] avatar](https://avatars.githubusercontent.com/u/13844975?v=4 "Published by a pub.dev verified publisher"){kind=small}
not stale. I've actually had the same issue with PG&E and have been following this thread to see what shakes out.
There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates. Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.