azogue
commented
7 months ago Hola @bananet,
El error que comentas es bastante extraño... ¿estás totalmente seguro de que ocurre como dices? ¿todos los días?
Si tienes el 'recorder' activado, puedes extraer los datos del sensor PVPC con el siguiente query SQL (para MariaDB):
SELECT
states_meta.entity_id,
states.state,
from_unixtime(states.last_updated_ts) AS last_updated,
from_unixtime(if(states.last_changed_ts IS NULL,states.last_updated_ts,states.last_changed_ts)) AS last_changed,
state_attributes.shared_attrs
FROM states
LEFT JOIN states_meta
ON (states.metadata_id=states_meta.metadata_id)
LEFT JOIN state_attributes
ON (states.attributes_id=state_attributes.attributes_id)
WHERE last_changed_ts IS NULL
AND states_meta.entity_id = 'sensor.pvpc'
AND from_unixtime(states.last_updated_ts) >= '2023-12-29 00:00:00'
AND from_unixtime(states.last_updated_ts) < '2023-12-30 12:00:00';(más info sobre cómo acceder a la DB de HA en https://data.home-assistant.io/, concretamente en https://data.home-assistant.io/docs/states)
Con esa query, en mi instancia de HA, obtengo los siguientes valores (en formato CSV):
entity_id,state,last_updated,last_changed,shared_attrs
sensor.pvpc,0.14582,2023-12-29 00:00:00.255331,2023-12-29 00:00:00.255331,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":8,""next_better_price"":0.13903,""hours_to_better_price"":1,""num_better_prices_ahead"":7,""price_position"":8,""price_ratio"":0.14,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[5,4,6,3,1,2,7,0,14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.13903,2023-12-29 01:00:00.255320,2023-12-29 01:00:00.255320,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":7,""next_better_price"":0.13884,""hours_to_better_price"":2,""num_better_prices_ahead"":4,""price_position"":5,""price_ratio"":0.08,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[5,4,6,3,1,2,7,14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.13914,2023-12-29 02:00:00.256207,2023-12-29 02:00:00.256207,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":6,""next_better_price"":0.13884,""hours_to_better_price"":1,""num_better_prices_ahead"":4,""price_position"":6,""price_ratio"":0.08,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[5,4,6,3,2,7,14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.13884,2023-12-29 03:00:00.254940,2023-12-29 03:00:00.254940,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":5,""next_better_price"":0.13105,""hours_to_better_price"":1,""num_better_prices_ahead"":3,""price_position"":4,""price_ratio"":0.08,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[5,4,6,3,7,14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.13105,2023-12-29 04:00:00.255847,2023-12-29 04:00:00.255847,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":4,""next_better_price"":0.13009,""hours_to_better_price"":1,""num_better_prices_ahead"":1,""price_position"":2,""price_ratio"":0.01,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[5,4,6,7,14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.13009,2023-12-29 05:00:00.253988,2023-12-29 05:00:00.253988,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":3,""price_position"":1,""price_ratio"":0.0,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[5,6,7,14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.13439,2023-12-29 06:00:00.254926,2023-12-29 06:00:00.254926,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":2,""price_position"":3,""price_ratio"":0.04,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[6,7,14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.1445,2023-12-29 07:00:00.264945,2023-12-29 07:00:00.264945,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":1,""price_position"":7,""price_ratio"":0.13,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[7,14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.17307,2023-12-29 08:00:00.278134,2023-12-29 08:00:00.278134,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P2"",""available_power"":7400,""next_period"":""P1"",""hours_to_next_period"":2,""next_better_price"":0.16946,""hours_to_better_price"":1,""num_better_prices_ahead"":5,""price_position"":14,""price_ratio"":0.39,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[14,15,16,23,9,8,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.16946,2023-12-29 09:00:00.254956,2023-12-29 09:00:00.254956,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P2"",""available_power"":7400,""next_period"":""P1"",""hours_to_next_period"":1,""next_better_price"":0.15153,""hours_to_better_price"":5,""num_better_prices_ahead"":4,""price_position"":13,""price_ratio"":0.36,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[14,15,16,23,9,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.21089,2023-12-29 10:00:00.255551,2023-12-29 10:00:00.255551,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P1"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":4,""next_better_price"":0.2007,""hours_to_better_price"":1,""num_better_prices_ahead"":9,""price_position"":20,""price_ratio"":0.74,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[14,15,16,23,22,17,13,11,12,10,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.2007,2023-12-29 11:00:00.254868,2023-12-29 11:00:00.254868,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P1"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":3,""next_better_price"":0.20065,""hours_to_better_price"":2,""num_better_prices_ahead"":7,""price_position"":18,""price_ratio"":0.64,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[14,15,16,23,22,17,13,11,12,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.2042,2023-12-29 12:00:00.255325,2023-12-29 12:00:00.255325,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P1"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":2,""next_better_price"":0.20065,""hours_to_better_price"":1,""num_better_prices_ahead"":7,""price_position"":19,""price_ratio"":0.67,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[14,15,16,23,22,17,13,12,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.20065,2023-12-29 13:00:00.254688,2023-12-29 13:00:00.254688,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P1"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":1,""next_better_price"":0.15153,""hours_to_better_price"":1,""num_better_prices_ahead"":6,""price_position"":17,""price_ratio"":0.64,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[14,15,16,23,22,17,13,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.15153,2023-12-29 14:00:00.255616,2023-12-29 14:00:00.255616,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P2"",""available_power"":7400,""next_period"":""P1"",""hours_to_next_period"":4,""price_position"":9,""price_ratio"":0.2,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[14,15,16,23,22,17,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.1541,2023-12-29 15:00:00.254930,2023-12-29 15:00:00.254930,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P2"",""available_power"":7400,""next_period"":""P1"",""hours_to_next_period"":3,""price_position"":10,""price_ratio"":0.22,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[15,16,23,22,17,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.16471,2023-12-29 16:00:00.254276,2023-12-29 16:00:00.254276,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P2"",""available_power"":7400,""next_period"":""P1"",""hours_to_next_period"":2,""price_position"":11,""price_ratio"":0.32,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[16,23,22,17,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.17392,2023-12-29 17:00:00.257854,2023-12-29 17:00:00.257854,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P2"",""available_power"":7400,""next_period"":""P1"",""hours_to_next_period"":1,""next_better_price"":0.17383,""hours_to_better_price"":5,""num_better_prices_ahead"":2,""price_position"":16,""price_ratio"":0.4,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[23,22,17,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.23357,2023-12-29 18:00:00.254746,2023-12-29 18:00:00.254746,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P1"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":4,""next_better_price"":0.17383,""hours_to_better_price"":4,""num_better_prices_ahead"":2,""price_position"":21,""price_ratio"":0.94,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[23,22,18,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.2363,2023-12-29 19:00:00.255423,2023-12-29 19:00:00.255423,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P1"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":3,""next_better_price"":0.23605,""hours_to_better_price"":2,""num_better_prices_ahead"":3,""price_position"":23,""price_ratio"":0.97,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[23,22,21,19,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.23989,2023-12-29 20:00:00.255036,2023-12-29 20:00:00.255036,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P1"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":2,""next_better_price"":0.23605,""hours_to_better_price"":1,""num_better_prices_ahead"":3,""price_position"":24,""price_ratio"":1.0,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[23,22,21,20],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.23605,2023-12-29 21:00:00.280577,2023-12-29 21:00:00.280577,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P1"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":1,""next_better_price"":0.17383,""hours_to_better_price"":1,""num_better_prices_ahead"":2,""price_position"":22,""price_ratio"":0.97,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[23,22,21],""next_better_price (next day)"":0.12925,""hours_to_better_price (next day)"":3,""num_better_prices_ahead (next day)"":24,""price_ratio (next day)"":2.83,""max_price (next day)"":0.12968,""max_price_at (next day)"":8,""min_price (next day)"":0.07169,""min_price_at (next day)"":14,""next_best_at (next day)"":[14,23,13,15,12,22,16,11,5,4,21,17,10,3,20,19,18,7,6,9,2,1,0,8],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""price_next_day_00h"":0.12925,""price_next_day_01h"":0.12863,""price_next_day_02h"":0.12746,""price_next_day_03h"":0.11706,""price_next_day_04h"":0.10878,""price_next_day_05h"":0.10505,""price_next_day_06h"":0.12624,""price_next_day_07h"":0.1245,""price_next_day_08h"":0.12968,""price_next_day_09h"":0.12695,""price_next_day_10h"":0.11267,""price_next_day_11h"":0.09119,""price_next_day_12h"":0.08405,""price_next_day_13h"":0.07714,""price_next_day_14h"":0.07169,""price_next_day_15h"":0.07806,""price_next_day_16h"":0.08941,""price_next_day_17h"":0.1117,""price_next_day_18h"":0.12076,""price_next_day_19h"":0.11839,""price_next_day_20h"":0.11711,""price_next_day_21h"":0.11058,""price_next_day_22h"":0.08868,""price_next_day_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.17383,2023-12-29 22:00:00.255393,2023-12-29 22:00:00.255393,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P2"",""available_power"":7400,""next_period"":""P3"",""hours_to_next_period"":2,""next_better_price"":0.16518,""hours_to_better_price"":1,""num_better_prices_ahead"":1,""price_position"":15,""price_ratio"":0.4,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[23,22],""next_better_price (next day)"":0.12925,""hours_to_better_price (next day)"":2,""num_better_prices_ahead (next day)"":24,""price_ratio (next day)"":1.76,""max_price (next day)"":0.12968,""max_price_at (next day)"":8,""min_price (next day)"":0.07169,""min_price_at (next day)"":14,""next_best_at (next day)"":[14,23,13,15,12,22,16,11,5,4,21,17,10,3,20,19,18,7,6,9,2,1,0,8],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""price_next_day_00h"":0.12925,""price_next_day_01h"":0.12863,""price_next_day_02h"":0.12746,""price_next_day_03h"":0.11706,""price_next_day_04h"":0.10878,""price_next_day_05h"":0.10505,""price_next_day_06h"":0.12624,""price_next_day_07h"":0.1245,""price_next_day_08h"":0.12968,""price_next_day_09h"":0.12695,""price_next_day_10h"":0.11267,""price_next_day_11h"":0.09119,""price_next_day_12h"":0.08405,""price_next_day_13h"":0.07714,""price_next_day_14h"":0.07169,""price_next_day_15h"":0.07806,""price_next_day_16h"":0.08941,""price_next_day_17h"":0.1117,""price_next_day_18h"":0.12076,""price_next_day_19h"":0.11839,""price_next_day_20h"":0.11711,""price_next_day_21h"":0.11058,""price_next_day_22h"":0.08868,""price_next_day_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.16518,2023-12-29 23:00:00.260055,2023-12-29 23:00:00.260055,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P2"",""available_power"":7400,""next_period"":""P3"",""hours_to_next_period"":1,""price_position"":12,""price_ratio"":0.32,""max_price"":0.23989,""max_price_at"":20,""min_price"":0.13009,""min_price_at"":5,""next_best_at"":[23],""next_better_price (next day)"":0.12925,""hours_to_better_price (next day)"":1,""num_better_prices_ahead (next day)"":24,""price_ratio (next day)"":1.61,""max_price (next day)"":0.12968,""max_price_at (next day)"":8,""min_price (next day)"":0.07169,""min_price_at (next day)"":14,""next_best_at (next day)"":[14,23,13,15,12,22,16,11,5,4,21,17,10,3,20,19,18,7,6,9,2,1,0,8],""price_00h"":0.14582,""price_01h"":0.13903,""price_02h"":0.13914,""price_03h"":0.13884,""price_04h"":0.13105,""price_05h"":0.13009,""price_06h"":0.13439,""price_07h"":0.1445,""price_08h"":0.17307,""price_09h"":0.16946,""price_10h"":0.21089,""price_11h"":0.2007,""price_12h"":0.2042,""price_13h"":0.20065,""price_14h"":0.15153,""price_15h"":0.1541,""price_16h"":0.16471,""price_17h"":0.17392,""price_18h"":0.23357,""price_19h"":0.2363,""price_20h"":0.23989,""price_21h"":0.23605,""price_22h"":0.17383,""price_23h"":0.16518,""price_next_day_00h"":0.12925,""price_next_day_01h"":0.12863,""price_next_day_02h"":0.12746,""price_next_day_03h"":0.11706,""price_next_day_04h"":0.10878,""price_next_day_05h"":0.10505,""price_next_day_06h"":0.12624,""price_next_day_07h"":0.1245,""price_next_day_08h"":0.12968,""price_next_day_09h"":0.12695,""price_next_day_10h"":0.11267,""price_next_day_11h"":0.09119,""price_next_day_12h"":0.08405,""price_next_day_13h"":0.07714,""price_next_day_14h"":0.07169,""price_next_day_15h"":0.07806,""price_next_day_16h"":0.08941,""price_next_day_17h"":0.1117,""price_next_day_18h"":0.12076,""price_next_day_19h"":0.11839,""price_next_day_20h"":0.11711,""price_next_day_21h"":0.11058,""price_next_day_22h"":0.08868,""price_next_day_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.12925,2023-12-30 00:00:00.255737,2023-12-30 00:00:00.255737,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":80,""next_better_price"":0.12863,""hours_to_better_price"":1,""num_better_prices_ahead"":22,""price_position"":23,""price_ratio"":0.99,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,5,4,21,17,10,3,20,19,18,7,6,9,2,1,0,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.12863,2023-12-30 01:00:00.256253,2023-12-30 01:00:00.256253,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":79,""next_better_price"":0.12746,""hours_to_better_price"":1,""num_better_prices_ahead"":21,""price_position"":22,""price_ratio"":0.98,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,5,4,21,17,10,3,20,19,18,7,6,9,2,1,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.12746,2023-12-30 02:00:00.256238,2023-12-30 02:00:00.256238,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":78,""next_better_price"":0.11706,""hours_to_better_price"":1,""num_better_prices_ahead"":20,""price_position"":21,""price_ratio"":0.96,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,5,4,21,17,10,3,20,19,18,7,6,9,2,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.11706,2023-12-30 03:00:00.256292,2023-12-30 03:00:00.256292,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":77,""next_better_price"":0.10878,""hours_to_better_price"":1,""num_better_prices_ahead"":13,""price_position"":14,""price_ratio"":0.78,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,5,4,21,17,10,3,20,19,18,7,6,9,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.10878,2023-12-30 04:00:00.255783,2023-12-30 04:00:00.255783,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":76,""next_better_price"":0.10505,""hours_to_better_price"":1,""num_better_prices_ahead"":9,""price_position"":10,""price_ratio"":0.64,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,5,4,21,17,10,20,19,18,7,6,9,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.10505,2023-12-30 05:00:00.255953,2023-12-30 05:00:00.255953,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":75,""next_better_price"":0.09119,""hours_to_better_price"":6,""num_better_prices_ahead"":8,""price_position"":9,""price_ratio"":0.58,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,5,21,17,10,20,19,18,7,6,9,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.12624,2023-12-30 06:00:00.255750,2023-12-30 06:00:00.255750,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":74,""next_better_price"":0.1245,""hours_to_better_price"":1,""num_better_prices_ahead"":15,""price_position"":19,""price_ratio"":0.94,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,21,17,10,20,19,18,7,6,9,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.1245,2023-12-30 07:00:00.255986,2023-12-30 07:00:00.255986,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":73,""next_better_price"":0.11267,""hours_to_better_price"":3,""num_better_prices_ahead"":14,""price_position"":18,""price_ratio"":0.91,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,21,17,10,20,19,18,7,9,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.12968,2023-12-30 08:00:00.258152,2023-12-30 08:00:00.258152,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":72,""next_better_price"":0.12695,""hours_to_better_price"":1,""num_better_prices_ahead"":15,""price_position"":24,""price_ratio"":1.0,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,21,17,10,20,19,18,9,8],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.12695,2023-12-30 09:00:00.255789,2023-12-30 09:00:00.255789,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":71,""next_better_price"":0.11267,""hours_to_better_price"":1,""num_better_prices_ahead"":14,""price_position"":20,""price_ratio"":0.95,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,21,17,10,20,19,18,9],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.11267,2023-12-30 10:00:00.255845,2023-12-30 10:00:00.255845,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":70,""next_better_price"":0.09119,""hours_to_better_price"":1,""num_better_prices_ahead"":10,""price_position"":13,""price_ratio"":0.71,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,21,17,10,20,19,18],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"
sensor.pvpc,0.09119,2023-12-30 11:00:00.265667,2023-12-30 11:00:00.265667,"{""state_class"":""measurement"",""data_id"":""1001"",""tariff"":""2.0TD"",""period"":""P3"",""available_power"":7400,""next_period"":""P2"",""hours_to_next_period"":69,""next_better_price"":0.08405,""hours_to_better_price"":1,""num_better_prices_ahead"":7,""price_position"":8,""price_ratio"":0.34,""max_price"":0.12968,""max_price_at"":8,""min_price"":0.07169,""min_price_at"":14,""next_best_at"":[14,23,13,15,12,22,16,11,21,17,20,19,18],""price_00h"":0.12925,""price_01h"":0.12863,""price_02h"":0.12746,""price_03h"":0.11706,""price_04h"":0.10878,""price_05h"":0.10505,""price_06h"":0.12624,""price_07h"":0.1245,""price_08h"":0.12968,""price_09h"":0.12695,""price_10h"":0.11267,""price_11h"":0.09119,""price_12h"":0.08405,""price_13h"":0.07714,""price_14h"":0.07169,""price_15h"":0.07806,""price_16h"":0.08941,""price_17h"":0.1117,""price_18h"":0.12076,""price_19h"":0.11839,""price_20h"":0.11711,""price_21h"":0.11058,""price_22h"":0.08868,""price_23h"":0.07385,""unit_of_measurement"":""€/kWh"",""icon"":""mdi:currency-eur"",""friendly_name"":""ESIOS PVPC""}"Operando un poco con ellos, con pandas, para revisar los valores del estado y atributos del sensor:
import json
import pandas as pd
# set pandas output format
pd.options.display.width = 300
pd.options.display.max_columns = 30
# read CSV with DB query
df = pd.read_csv("pvpc-2023-12-29.csv")
# process data and extract sensor attributes as new columns
data = df.join(df.shared_attrs.apply(json.loads).apply(pd.Series))
data.set_index(pd.to_datetime(data.last_changed).dt.floor(freq="S"), inplace=True)
data.set_index("state", append=True, inplace=True)
cols_prices = [
'price_00h', 'price_01h', 'price_02h', 'price_03h', 'price_04h', 'price_05h', 'price_06h', 'price_07h', 'price_08h', 'price_09h', 'price_10h', 'price_11h',
'price_12h', 'price_13h', 'price_14h', 'price_15h', 'price_16h', 'price_17h', 'price_18h', 'price_19h', 'price_20h', 'price_21h', 'price_22h', 'price_23h',
'price_next_day_00h', 'price_next_day_01h', 'price_next_day_02h', 'price_next_day_03h', 'price_next_day_04h', 'price_next_day_05h', 'price_next_day_06h', 'price_next_day_07h', 'price_next_day_08h', 'price_next_day_09h', 'price_next_day_10h', 'price_next_day_11h',
# 'price_next_day_12h', 'price_next_day_13h', 'price_next_day_14h', 'price_next_day_15h', 'price_next_day_16h', 'price_next_day_17h', 'price_next_day_18h', 'price_next_day_19h', 'price_next_day_20h', 'price_next_day_21h', 'price_next_day_22h', 'price_next_day_23h'
]
# show state + price attributes for the day, to check values
print(data.loc["2023-12-29", cols_prices[:24]])No se ve nada extraño... ✅
¿Podrías pasar más info de tu config? y/o revisar en tu base de datos de HA estos valores?
Cierro issue, pero ábrela de nuevo si realmente está ocurriendo ese error tras actualizar los datos para el día siguiente 👍
Hola Eugenio. Gracias por tu trabajo.
He detectado esto en la integración, no sé si me pasa solo a mi o es general.
Al actualizarse los precios del día siguiente, sobre las 20:15, en teoría, ocurre un error.
Los sensores:
sensor.pvpc','price_20h') al 23h
Se llenan con los datos de
De tal manera que el sensor.pvpc en estas 4 últimas horas, opera como si fuesen las 4 últimas del día siguiente.
¿Puedes revisarlo?
Yo lo he corregido de momento con una automatización, pero supongo que en tu código es sencillo depurarlo.
Si no estoy en lo cierto, me dices.