Hello,
In the Netherland you can get a dynamic energy contact. Current has a price per hour and gas a price per day. These prices are determined one day ahead. So today I can lookup the prices for tomorrow ordered per hour. I save these prices in a seperate schema within the HA database. The problem is you don’t have any control over the sensor datetime. It would be great if you could specify the date/time column besides the value column. Or does someone have another solution?
Example of table
datum | prijszp
---------------------+----------
2022-11-25 01:00:00 | 0.26701
2022-11-25 02:00:00 | 0.253799
2022-11-25 03:00:00 | 0.241536
2022-11-25 04:00:00 | 0.243226
2022-11-25 05:00:00 | 0.27404
2022-11-25 06:00:00 | 0.325008
2022-11-25 07:00:00 | 0.391117
2022-11-25 08:00:00 | 0.383432
2022-11-25 09:00:00 | 0.363049
2022-11-25 10:00:00 | 0.381143
2022-11-25 11:00:00 | 0.315852
2022-11-25 12:00:00 | 0.314762
2022-11-25 13:00:00 | 0.348552
2022-11-25 14:00:00 | 0.392316
2022-11-25 15:00:00 | 0.392654
2022-11-25 16:00:00 | 0.432875
2022-11-25 17:00:00 | 0.457443
2022-11-25 18:00:00 | 0.444418
2022-11-25 19:00:00 | 0.403107
2022-11-25 20:00:00 | 0.371039
2022-11-25 21:00:00 | 0.366341
2022-11-25 22:00:00 | 0.370265
2022-11-25 23:00:00 | 0.322425