Yield forecast with Solcast kW -> kWh

[Becker]

Hi, I'm amazed at how well Solcast hits the yield curve:

I would like to use the forecast daily yield to calculate with it.

In Grafana I use integral by 1 day.

Solcast gives just every 30min the power, but not the daily yield.

Is there a easy way to convert the estimated power (of today) in the daily yield ?

Data from Solcast Api:

{"forecasts":[{"pv_estimate":2.1695,"pv_estimate10":1.3586,"pv_estimate90":6.9114,"period_end":"2023-03-02T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.5206,"pv_estimate10":0.904,"pv_estimate90":6.3761,"period_end":"2023-03-02T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.9509,"pv_estimate10":0.5743,"pv_estimate90":3.8097,"period_end":"2023-03-02T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.4962,"pv_estimate10":0.2829,"pv_estimate90":3.5613,"period_end":"2023-03-02T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.6657,"pv_estimate10":0.1731,"pv_estimate90":3.2179,"period_end":"2023-03-02T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.6471,"pv_estimate10":0.1011,"pv_estimate90":0.8891,"period_end":"2023-03-02T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-02T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0143,"pv_estimate10":0.0072,"pv_estimate90":0.0143,"period_end":"2023-03-03T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1932,"pv_estimate10":0.1288,"pv_estimate90":0.20286,"period_end":"2023-03-03T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.5381,"pv_estimate10":0.304,"pv_estimate90":0.5650050000000001,"period_end":"2023-03-03T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.0265,"pv_estimate10":0.5813,"pv_estimate90":1.077825,"period_end":"2023-03-03T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.5174,"pv_estimate10":0.9001,"pv_estimate90":1.6046,"period_end":"2023-03-03T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.9753,"pv_estimate10":1.0957,"pv_estimate90":2.5396,"period_end":"2023-03-03T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.4593,"pv_estimate10":1.2968,"pv_estimate90":3.8025,"period_end":"2023-03-03T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":3.1163,"pv_estimate10":1.5467,"pv_estimate90":5.1632,"period_end":"2023-03-03T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":3.632,"pv_estimate10":1.712,"pv_estimate90":6.1638,"period_end":"2023-03-03T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":3.9613,"pv_estimate10":1.7351,"pv_estimate90":6.9633,"period_end":"2023-03-03T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":4.113,"pv_estimate10":1.7026,"pv_estimate90":7.6286,"period_end":"2023-03-03T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":4.1184,"pv_estimate10":1.6128,"pv_estimate90":8.0784,"period_end":"2023-03-03T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":4.3439,"pv_estimate10":1.5783,"pv_estimate90":8.3711,"period_end":"2023-03-03T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":4.8234,"pv_estimate10":1.5898,"pv_estimate90":8.4879,"period_end":"2023-03-03T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":5.0123,"pv_estimate10":1.4628,"pv_estimate90":8.4938,"period_end":"2023-03-03T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":4.7275,"pv_estimate10":1.212,"pv_estimate90":8.3173,"period_end":"2023-03-03T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":4.234,"pv_estimate10":1.0494,"pv_estimate90":7.694,"period_end":"2023-03-03T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":3.7785,"pv_estimate10":0.8862,"pv_estimate90":7.1481,"period_end":"2023-03-03T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.7812,"pv_estimate10":0.6216,"pv_estimate90":6.0503,"period_end":"2023-03-03T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.8315,"pv_estimate10":0.2992,"pv_estimate90":4.7725,"period_end":"2023-03-03T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.7908,"pv_estimate10":0.1382,"pv_estimate90":3.0731,"period_end":"2023-03-03T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1198,"pv_estimate10":0.0399,"pv_estimate90":0.7705,"period_end":"2023-03-03T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0067,"pv_estimate10":0,"pv_estimate90":0.0135,"period_end":"2023-03-04T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0943,"pv_estimate10":0.0269,"pv_estimate90":0.1886,"period_end":"2023-03-04T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.229,"pv_estimate10":0.0674,"pv_estimate90":0.5656,"period_end":"2023-03-04T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.4173,"pv_estimate10":0.0999,"pv_estimate90":1.1051,"period_end":"2023-03-04T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.7271,"pv_estimate10":0.1265,"pv_estimate90":1.653,"period_end":"2023-03-04T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.9991,"pv_estimate10":0.1398,"pv_estimate90":2.3167,"period_end":"2023-03-04T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.2343,"pv_estimate10":0.1465,"pv_estimate90":3.1491,"period_end":"2023-03-04T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.4882,"pv_estimate10":0.1482,"pv_estimate90":4.1614,"period_end":"2023-03-04T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.6888,"pv_estimate10":0.1465,"pv_estimate90":5.0911,"period_end":"2023-03-04T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.8507,"pv_estimate10":0.1465,"pv_estimate90":6.0462,"period_end":"2023-03-04T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.9544,"pv_estimate10":0.1465,"pv_estimate90":6.9886,"period_end":"2023-03-04T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.9899,"pv_estimate10":0.1382,"pv_estimate90":7.7927,"period_end":"2023-03-04T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.0586,"pv_estimate10":0.1579,"pv_estimate90":8.3883,"period_end":"2023-03-04T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.1499,"pv_estimate10":0.1974,"pv_estimate90":8.5597,"period_end":"2023-03-04T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.1385,"pv_estimate10":0.2237,"pv_estimate90":8.541,"period_end":"2023-03-04T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":2.0128,"pv_estimate10":0.2237,"pv_estimate90":8.2617,"period_end":"2023-03-04T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.8523,"pv_estimate10":0.25,"pv_estimate90":7.837,"period_end":"2023-03-04T14:30:00.0000000Z","period":"PT30M"}]}

P.S. this is my Grafana view:

[Becker]

.. i´ve tried to re-query the values of today, which I stored in my InfluxDB by the node "influxdb in":

select * from "Solcast" WHERE time>now()/d and time<= now() group by time(1d) tz('Europe/Berlin')

but I get always:
"Error: Error from InfluxDB: invalid operation: time and *influxql.BinaryExpr are not compatible"

I just need all the values from solcast of today. So I can build the energy (kWh) on my own.

Any idea how I can get ?
this is the input data:

{"Südwest":[{"pv_estimate":0.526,"pv_estimate10":0.4773,"pv_estimate90":0.5746,"period_end":"2023-03-03T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.9307,"pv_estimate10":0.8586,"pv_estimate90":0.9906,"period_end":"2023-03-03T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.2337,"pv_estimate10":1.1386,"pv_estimate90":1.3166,"period_end":"2023-03-03T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.4616,"pv_estimate10":1.2496,"pv_estimate90":1.579,"period_end":"2023-03-03T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.64,"pv_estimate10":1.2654,"pv_estimate90":1.8491,"period_end":"2023-03-03T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.2755,"pv_estimate10":1.64,"pv_estimate90":2.9803,"period_end":"2023-03-03T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":3.2382,"pv_estimate10":2.1152,"pv_estimate90":5.6464,"period_end":"2023-03-03T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":4.9078,"pv_estimate10":2.5017,"pv_estimate90":7.5886,"period_end":"2023-03-03T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":5.7295,"pv_estimate10":2.637,"pv_estimate90":8.1553,"period_end":"2023-03-03T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":5.8589,"pv_estimate10":2.5118,"pv_estimate90":8.4288,"period_end":"2023-03-03T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":5.5396,"pv_estimate10":2.207,"pv_estimate90":8.5501,"period_end":"2023-03-03T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":5.464,"pv_estimate10":1.9567,"pv_estimate90":8.5883,"period_end":"2023-03-03T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":5.5559,"pv_estimate10":1.7737,"pv_estimate90":8.4616,"period_end":"2023-03-03T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":4.8846,"pv_estimate10":1.4975,"pv_estimate90":7.8786,"period_end":"2023-03-03T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":3.9164,"pv_estimate10":1.1378,"pv_estimate90":7.3849,"period_end":"2023-03-03T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":2.7264,"pv_estimate10":0.7866,"pv_estimate90":6.3448,"period_end":"2023-03-03T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.8548,"pv_estimate10":0.3771,"pv_estimate90":5.218,"period_end":"2023-03-03T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.8893,"pv_estimate10":0.1864,"pv_estimate90":3.5697,"period_end":"2023-03-03T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1213,"pv_estimate10":0.0539,"pv_estimate90":1.1497,"period_end":"2023-03-03T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0068,"pv_estimate10":0,"pv_estimate90":0.0136,"period_end":"2023-03-04T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0943,"pv_estimate10":0.0337,"pv_estimate90":0.1819,"period_end":"2023-03-04T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.229,"pv_estimate10":0.0741,"pv_estimate90":0.5177,"period_end":"2023-03-04T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.4218,"pv_estimate10":0.1145,"pv_estimate90":1.0532,"period_end":"2023-03-04T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.7446,"pv_estimate10":0.1415,"pv_estimate90":1.6244,"period_end":"2023-03-04T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.0109,"pv_estimate10":0.1465,"pv_estimate90":2.2912,"period_end":"2023-03-04T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.2577,"pv_estimate10":0.1465,"pv_estimate90":3.1856,"period_end":"2023-03-04T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.5262,"pv_estimate10":0.1531,"pv_estimate90":4.2797,"period_end":"2023-03-04T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.6772,"pv_estimate10":0.1465,"pv_estimate90":5.2541,"period_end":"2023-03-04T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.6888,"pv_estimate10":0.1132,"pv_estimate90":5.9859,"period_end":"2023-03-04T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.712,"pv_estimate10":0.0999,"pv_estimate90":6.7456,"period_end":"2023-03-04T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.7351,"pv_estimate10":0.0999,"pv_estimate90":7.5812,"period_end":"2023-03-04T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.712,"pv_estimate10":0.0999,"pv_estimate90":8.1303,"period_end":"2023-03-04T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.6656,"pv_estimate10":0.0932,"pv_estimate90":8.314,"period_end":"2023-03-04T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.5611,"pv_estimate10":0.0865,"pv_estimate90":8.3174,"period_end":"2023-03-04T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.418,"pv_estimate10":0.0808,"pv_estimate90":8.0734,"period_end":"2023-03-04T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.3124,"pv_estimate10":0.0808,"pv_estimate90":7.479,"period_end":"2023-03-04T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.1948,"pv_estimate10":0.0943,"pv_estimate90":6.3642,"period_end":"2023-03-04T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.9111,"pv_estimate10":0.0808,"pv_estimate90":6.0591,"period_end":"2023-03-04T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.4698,"pv_estimate10":0.0472,"pv_estimate90":4.811,"period_end":"2023-03-04T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.225,"pv_estimate10":0.0273,"pv_estimate90":3.1317,"period_end":"2023-03-04T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.075,"pv_estimate10":0.0136,"pv_estimate90":0.815,"period_end":"2023-03-04T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0141,"pv_estimate10":0.0071,"pv_estimate90":0.0212,"period_end":"2023-03-05T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1397,"pv_estimate10":0.0698,"pv_estimate90":0.2375,"period_end":"2023-03-05T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3422,"pv_estimate10":0.1816,"pv_estimate90":0.69,"period_end":"2023-03-05T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.7324,"pv_estimate10":0.3243,"pv_estimate90":1.213,"period_end":"2023-03-05T08:00:00.0000000Z","period":"PT30M"}],"Gauben":[{"pv_estimate":0.1315,"pv_estimate10":0.1193,"pv_estimate90":0.1436,"period_end":"2023-03-03T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.2327,"pv_estimate10":0.2147,"pv_estimate90":0.2477,"period_end":"2023-03-03T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3084,"pv_estimate10":0.2847,"pv_estimate90":0.3292,"period_end":"2023-03-03T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3654,"pv_estimate10":0.3124,"pv_estimate90":0.3947,"period_end":"2023-03-03T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.41,"pv_estimate10":0.3164,"pv_estimate90":0.4623,"period_end":"2023-03-03T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.5689,"pv_estimate10":0.41,"pv_estimate90":0.7842,"period_end":"2023-03-03T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.8291,"pv_estimate10":0.5288,"pv_estimate90":1.7136,"period_end":"2023-03-03T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.3005,"pv_estimate10":0.6254,"pv_estimate90":2.0853,"period_end":"2023-03-03T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.4181,"pv_estimate10":0.6593,"pv_estimate90":2.0115,"period_end":"2023-03-03T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.3248,"pv_estimate10":0.628,"pv_estimate90":1.8398,"period_end":"2023-03-03T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":1.1656,"pv_estimate10":0.5517,"pv_estimate90":1.6589,"period_end":"2023-03-03T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":1.0365,"pv_estimate10":0.4892,"pv_estimate90":1.425,"period_end":"2023-03-03T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.9176,"pv_estimate10":0.4434,"pv_estimate90":1.1871,"period_end":"2023-03-03T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.7188,"pv_estimate10":0.3744,"pv_estimate90":0.8873,"period_end":"2023-03-03T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.5201,"pv_estimate10":0.2844,"pv_estimate90":0.5833,"period_end":"2023-03-03T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3486,"pv_estimate10":0.1966,"pv_estimate90":0.36603,"period_end":"2023-03-03T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1978,"pv_estimate10":0.0943,"pv_estimate90":0.20769,"period_end":"2023-03-03T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0965,"pv_estimate10":0.0466,"pv_estimate90":0.10132500000000001,"period_end":"2023-03-03T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0303,"pv_estimate10":0.0135,"pv_estimate90":0.031815,"period_end":"2023-03-03T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-03T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0017,"pv_estimate10":0,"pv_estimate90":0.0034,"period_end":"2023-03-04T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0236,"pv_estimate10":0.0084,"pv_estimate90":0.0455,"period_end":"2023-03-04T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0573,"pv_estimate10":0.0185,"pv_estimate90":0.1294,"period_end":"2023-03-04T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1055,"pv_estimate10":0.0286,"pv_estimate90":0.2633,"period_end":"2023-03-04T08:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1862,"pv_estimate10":0.0354,"pv_estimate90":0.4732,"period_end":"2023-03-04T08:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.2527,"pv_estimate10":0.0366,"pv_estimate90":0.8818,"period_end":"2023-03-04T09:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3144,"pv_estimate10":0.0366,"pv_estimate90":1.3061,"period_end":"2023-03-04T09:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3816,"pv_estimate10":0.0383,"pv_estimate90":1.6425,"period_end":"2023-03-04T10:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.4193,"pv_estimate10":0.0366,"pv_estimate90":1.7997,"period_end":"2023-03-04T10:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.4222,"pv_estimate10":0.0283,"pv_estimate90":1.8339,"period_end":"2023-03-04T11:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.428,"pv_estimate10":0.025,"pv_estimate90":1.8418,"period_end":"2023-03-04T11:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.4338,"pv_estimate10":0.025,"pv_estimate90":1.8708,"period_end":"2023-03-04T12:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.428,"pv_estimate10":0.025,"pv_estimate90":1.7797,"period_end":"2023-03-04T12:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.4164,"pv_estimate10":0.0233,"pv_estimate90":1.5982,"period_end":"2023-03-04T13:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3903,"pv_estimate10":0.0216,"pv_estimate90":1.392,"period_end":"2023-03-04T13:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3545,"pv_estimate10":0.0202,"pv_estimate90":1.145,"period_end":"2023-03-04T14:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.3281,"pv_estimate10":0.0202,"pv_estimate90":0.8708,"period_end":"2023-03-04T14:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.2987,"pv_estimate10":0.0236,"pv_estimate90":0.5854,"period_end":"2023-03-04T15:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.2278,"pv_estimate10":0.0202,"pv_estimate90":0.3043,"period_end":"2023-03-04T15:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1174,"pv_estimate10":0.0118,"pv_estimate90":0.12327,"period_end":"2023-03-04T16:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0562,"pv_estimate10":0.0068,"pv_estimate90":0.05901,"period_end":"2023-03-04T16:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0187,"pv_estimate10":0.0034,"pv_estimate90":0.0281,"period_end":"2023-03-04T17:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T17:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T18:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T18:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T19:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T19:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T20:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T20:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T21:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T21:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T22:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T22:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T23:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-04T23:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T00:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T00:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T01:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T01:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T02:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T02:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T03:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T03:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T04:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T04:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T05:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T05:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0,"pv_estimate10":0,"pv_estimate90":0,"period_end":"2023-03-05T06:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0035,"pv_estimate10":0.0018,"pv_estimate90":0.0053,"period_end":"2023-03-05T06:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0349,"pv_estimate10":0.0175,"pv_estimate90":0.0594,"period_end":"2023-03-05T07:00:00.0000000Z","period":"PT30M"},{"pv_estimate":0.0856,"pv_estimate10":0.0454,"pv_estimate90":0.1725,"period_end":"2023-03-05T07:30:00.0000000Z","period":"PT30M"},{"pv_estimate":0.1831,"pv_estimate10":0.0811,"pv_estimate90":0.3291,"period_end":"2023-03-05T08:00:00.0000000Z","period":"PT30M"}]}

which I write to influxdb, and also I build a chart in NR with:

let mydata = msg.payload;
let series = Object.keys(mydata);
const chart = [{
    "series": series,
    "data": 
        Object.values(mydata).map(arr => { 
            return arr.map(e => {
                return { x: e.period_end, y: Math.round(e.pv_estimate * 100) / 100 } 
            })
            
        }),
    "labels": series
}];
msg.payload = chart;
return msg;

thx to @E1cid

[Colin]

You don't need the and time<=now() as it is unlikely that you have any samples that you recorded tomorrow. Unless you have access to some rather advanced technology.
I don't think you should have the group by clause either.

[Becker]

...

thats tomorrow

[Colin]

OK, I presume you are prefilling that, which is an unusual way to use influx, but I suppose it should not be a problem.

What is the purpose of the group by clause that you have included? Does it make a difference if you remove it?

[UnborN]

@Becker

select * from "Solcast" WHERE time>now()/d and time<= now() group by time(1d)

im not familiar with influxdb query language

When you do a GROUP BY i believe you need to define what aggregation function to run on the data
here with MEAN, we get the average of 1d

SELECT MEAN("PV1"), MEAN("PV2") FROM "Solcast" WHERE time >= now() AND time <= now() + 1d GROUP BY time(1d)

[Becker]

Thank you, I got it now:

query:

SELECT integral("PV1") /3600000, integral("PV2") /3600000 FROM "Solcast" WHERE time >= now() -1d AND time <=now() +2d GROUP BY time(1d)

(H = today, M = tomorrow)

First I tried with the expression:

time >= now() -1d AND time <=now() +1d 

but then the output is faulty

I don´t know why

edit: the first and the last day always were faulty:

maybe because of the "now" ?

[Becker]

if someone is interested for the flow:

[
    {
        "id": "df7660c926cea0ab",
        "type": "http request",
        "z": "a85445c69706ecc9",
        "name": "Solcast Südwest",
        "method": "GET",
        "ret": "obj",
        "paytoqs": "ignore",
        "url": "https://api.solcast.com.au/rooftop_sites/718e-7321-33f2-4c91/forecasts?format=json&api_key=yourkey1",
        "tls": "",
        "persist": false,
        "proxy": "",
        "insecureHTTPParser": false,
        "authType": "",
        "senderr": false,
        "headers": [],
        "x": 340,
        "y": 1140,
        "wires": [
            [
                "1805c5bcd89f23c9"
            ]
        ]
    },
    {
        "id": "833f772a6c142087",
        "type": "inject",
        "z": "a85445c69706ecc9",
        "name": "alle 2h",
        "props": [
            {
                "p": "payload"
            }
        ],
        "repeat": "7200",
        "crontab": "",
        "once": true,
        "onceDelay": "5",
        "topic": "",
        "payload": "true",
        "payloadType": "bool",
        "x": 100,
        "y": 1160,
        "wires": [
            [
                "df7660c926cea0ab",
                "8bece8e8474bf68e"
            ]
        ]
    },
    {
        "id": "8bece8e8474bf68e",
        "type": "http request",
        "z": "a85445c69706ecc9",
        "name": "Solcast Gaube",
        "method": "GET",
        "ret": "obj",
        "paytoqs": "ignore",
        "url": "https://api.solcast.com.au/rooftop_sites/d414-1781-18e5-8865/forecasts?format=json&api_key=yourkey2",
        "tls": "",
        "persist": false,
        "proxy": "",
        "insecureHTTPParser": false,
        "authType": "",
        "senderr": false,
        "headers": [],
        "x": 340,
        "y": 1180,
        "wires": [
            [
                "db2e627fc645fbc2"
            ]
        ]
    },
    {
        "id": "4923a443c22d9c96",
        "type": "comment",
        "z": "a85445c69706ecc9",
        "name": "Solcast",
        "info": "",
        "x": 90,
        "y": 1120,
        "wires": []
    },
    {
        "id": "264bbb44.61e064",
        "type": "influxdb out",
        "z": "a85445c69706ecc9",
        "influxdb": "72e5611c.85f388",
        "name": "Solcast",
        "measurement": "Solcast",
        "precision": "ms",
        "retentionPolicy": "",
        "database": "",
        "retentionPolicyV18Flux": "",
        "org": "",
        "bucket": "",
        "x": 1180,
        "y": 1120,
        "wires": []
    },
    {
        "id": "1805c5bcd89f23c9",
        "type": "change",
        "z": "a85445c69706ecc9",
        "name": "Südwest",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "payload.forecasts",
                "tot": "msg"
            },
            {
                "t": "set",
                "p": "topic",
                "pt": "msg",
                "to": "Südwest",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 520,
        "y": 1140,
        "wires": [
            [
                "985d0b26eb801c71"
            ]
        ]
    },
    {
        "id": "db2e627fc645fbc2",
        "type": "change",
        "z": "a85445c69706ecc9",
        "name": "Gauben",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "payload.forecasts",
                "tot": "msg"
            },
            {
                "t": "set",
                "p": "topic",
                "pt": "msg",
                "to": "Gauben",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 520,
        "y": 1180,
        "wires": [
            [
                "985d0b26eb801c71"
            ]
        ]
    },
    {
        "id": "985d0b26eb801c71",
        "type": "join",
        "z": "a85445c69706ecc9",
        "name": "Objekt",
        "mode": "custom",
        "build": "object",
        "property": "payload",
        "propertyType": "msg",
        "key": "topic",
        "joiner": "\\n",
        "joinerType": "str",
        "accumulate": false,
        "timeout": "",
        "count": "2",
        "reduceRight": false,
        "reduceExp": "",
        "reduceInit": "",
        "reduceInitType": "",
        "reduceFixup": "",
        "x": 690,
        "y": 1160,
        "wires": [
            [
                "b08785f51e204b55",
                "04efabc031578d90"
            ]
        ]
    },
    {
        "id": "b08785f51e204b55",
        "type": "change",
        "z": "a85445c69706ecc9",
        "name": "kombiniere",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": "$zip($$.payload.Südwest,$$.payload.Gauben)",
                "tot": "jsonata"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 830,
        "y": 1160,
        "wires": [
            [
                "a917355c94b03b59"
            ]
        ]
    },
    {
        "id": "a917355c94b03b59",
        "type": "split",
        "z": "a85445c69706ecc9",
        "name": "",
        "splt": "\\n",
        "spltType": "str",
        "arraySplt": 1,
        "arraySpltType": "len",
        "stream": false,
        "addname": "",
        "x": 990,
        "y": 1160,
        "wires": [
            [
                "eebd96403b8c04ce"
            ]
        ]
    },
    {
        "id": "eebd96403b8c04ce",
        "type": "change",
        "z": "a85445c69706ecc9",
        "name": "Influx",
        "rules": [
            {
                "t": "set",
                "p": "payload",
                "pt": "msg",
                "to": " {\t   \"PV1\": $round($$.payload[0].pv_estimate * 1000),\t   \"PV2\": $round($$.payload[1].pv_estimate * 1000),\t   \"time\": $toMillis($$.payload[0].period_end)\t}",
                "tot": "jsonata"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 990,
        "y": 1120,
        "wires": [
            [
                "264bbb44.61e064"
            ]
        ]
    },
    {
        "id": "04efabc031578d90",
        "type": "function",
        "z": "a85445c69706ecc9",
        "name": "Verlauf",
        "func": "let mydata = msg.payload;\nlet series = Object.keys(mydata);\nconst chart = [{\n    \"series\": series,\n    \"data\": \n        Object.values(mydata).map(arr => { \n            return arr.map(e => {\n                return { x: e.period_end, y: Math.round(e.pv_estimate * 100) / 100 } \n            })\n            \n        }),\n    \"labels\": series\n}];\nmsg.payload = chart;\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 820,
        "y": 1200,
        "wires": [
            [
                "3d9b49aceeca7e1e"
            ]
        ]
    },
    {
        "id": "3d9b49aceeca7e1e",
        "type": "ui_chart",
        "z": "a85445c69706ecc9",
        "name": "",
        "group": "d4b6c460b026ec38",
        "order": 1,
        "width": 0,
        "height": 0,
        "label": "Solcast",
        "chartType": "line",
        "legend": "false",
        "xformat": "dd HH:mm",
        "interpolate": "bezier",
        "nodata": "",
        "dot": true,
        "ymin": "",
        "ymax": "",
        "removeOlder": "1",
        "removeOlderPoints": "",
        "removeOlderUnit": "3600",
        "cutout": 0,
        "useOneColor": false,
        "useUTC": false,
        "colors": [
            "#ff8000",
            "#8000ff",
            "#ffff00",
            "#2ca02c",
            "#98df8a",
            "#d62728",
            "#ff9896",
            "#9467bd",
            "#c5b0d5"
        ],
        "outputs": 1,
        "useDifferentColor": false,
        "className": "",
        "x": 1000,
        "y": 1200,
        "wires": [
            []
        ]
    },
    {
        "id": "b475091b62b10ee9",
        "type": "influxdb in",
        "z": "a85445c69706ecc9",
        "influxdb": "72e5611c.85f388",
        "name": "Tageserträge (Integral)",
        "query": "SELECT integral(\"PV1\") /3600000, integral(\"PV2\") /3600000 FROM \"Solcast\" WHERE time >= now() -1d AND time <=now() +2d GROUP BY time(1d)",
        "rawOutput": false,
        "precision": "s",
        "retentionPolicy": "",
        "org": "organisation",
        "x": 370,
        "y": 1260,
        "wires": [
            [
                "104c454d4757ec77"
            ]
        ]
    },
    {
        "id": "104c454d4757ec77",
        "type": "function",
        "z": "a85445c69706ecc9",
        "name": "Tageserträge",
        "func": "let h = msg.payload[1].integral + msg.payload[1].integral_1;\nh = parseFloat(h.toFixed(1));\nlet m = msg.payload[2].integral + msg.payload[2].integral_1;\nm = parseFloat(m.toFixed(1));\nmsg.payload = {h,m};\nmsg.topic = \"Tagesertrag\";\nreturn msg;",
        "outputs": 1,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 720,
        "y": 1260,
        "wires": [
            [
                "0b10c2e3dc2de00e",
                "ef7896bd56460b2c"
            ]
        ]
    },
    {
        "id": "a5c3c9675dc52af9",
        "type": "inject",
        "z": "a85445c69706ecc9",
        "name": "5 Uhr",
        "props": [
            {
                "p": "payload"
            }
        ],
        "repeat": "",
        "crontab": "00 05 * * *",
        "once": true,
        "onceDelay": "10",
        "topic": "",
        "payload": "true",
        "payloadType": "bool",
        "x": 90,
        "y": 1260,
        "wires": [
            [
                "b475091b62b10ee9"
            ]
        ]
    },
    {
        "id": "0b10c2e3dc2de00e",
        "type": "ui_text",
        "z": "a85445c69706ecc9",
        "group": "8cddee4c186097d1",
        "order": 1,
        "width": 0,
        "height": 0,
        "name": "",
        "label": "Tagesertrag heute",
        "format": "{{msg.payload.h}} kWh",
        "layout": "row-spread",
        "className": "",
        "x": 1030,
        "y": 1240,
        "wires": []
    },
    {
        "id": "ef7896bd56460b2c",
        "type": "ui_text",
        "z": "a85445c69706ecc9",
        "group": "8cddee4c186097d1",
        "order": 2,
        "width": 0,
        "height": 0,
        "name": "",
        "label": "Tagesertrag morgen",
        "format": "{{msg.payload.m}} kWh",
        "layout": "row-spread",
        "className": "",
        "x": 1040,
        "y": 1280,
        "wires": []
    },
    {
        "id": "72e5611c.85f388",
        "type": "influxdb",
        "hostname": "127.0.0.1",
        "port": "8086",
        "protocol": "http",
        "database": "db",
        "name": "InfluxDB",
        "usetls": false,
        "tls": "",
        "influxdbVersion": "1.x",
        "url": "http://localhost:8086",
        "rejectUnauthorized": false
    },
    {
        "id": "d4b6c460b026ec38",
        "type": "ui_group",
        "name": "Vorhersage (Verlauf)",
        "tab": "d382539fb663114d",
        "order": 1,
        "disp": true,
        "width": "14",
        "collapse": false,
        "className": ""
    },
    {
        "id": "8cddee4c186097d1",
        "type": "ui_group",
        "name": "Vorhersage pro Tag",
        "tab": "d382539fb663114d",
        "order": 2,
        "disp": true,
        "width": "5",
        "collapse": false,
        "className": ""
    },
    {
        "id": "d382539fb663114d",
        "type": "ui_tab",
        "name": "Solcast",
        "icon": "wi-wu-sunny",
        "order": 16,
        "disabled": false,
        "hidden": false
    }
]

[UnborN]

@Becker

the first and the last day always were faulty
maybe because of the "now" ?

possibly its because it depends when you execute now() .. if you run the query mid-day you'll be missing values because from what i understand you actually need to get the GROUP BY with values that start from the very start of the previous day 00:00 and the very end of tomorrow ?

i didnt understand from your flow if you solved this but you can use a moment() expression in a Change node to calculate these datetimes manually and then pass them to the influxdb query without using now()

{
   "startDate": $moment().subtract(1, "days").format("DD-MM-YYYY 00:00:00"),
   "endDate" : $moment().add(1, "days").format("DD-MM-YYYY 00:00:00")
 }

[{"id":"590f2452fdf93a27","type":"inject","z":"54efb553244c241f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":300,"y":2480,"wires":[["f36a7254e2d82933"]]},{"id":"f36a7254e2d82933","type":"change","z":"54efb553244c241f","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"{\t   \"startDate\": $moment().subtract(1, \"days\").format(\"DD-MM-YYYY 00:00:00\"),\t   \"endDate\" : $moment().add(1, \"days\").format(\"DD-MM-YYYY 00:00:00\")\t   }","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":2480,"wires":[["a3543e8850fd4a04"]]},{"id":"a3543e8850fd4a04","type":"debug","z":"54efb553244c241f","name":"debug 159","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":730,"y":2480,"wires":[]}]

[Colin]

@UnborN

you can use a moment() expression in a Change node to calculate these datetimes manually

I don't think that is necessary as /d can be used to take it to the start of the day.

[UnborN]

i saw that /d option where Becker used it in his 2nd post .. but does it work with influxql ?
i read on stackoverflow that its only for Grafana ?

[Colin]

@UnborN

its only for Grafana

Oh, you may be right. I have not tried it.

[Becker]

@UnborN

possibly its because it depends when you execute now() .. if you run the query mid-day you'll be missing values because from what i understand you actually need to get the GROUP BY with values that start from the very start of the previous day 00:00 and the very end of tomorrow ?

exactly !
because I just need today and tomorrow, I'm querying -1d to +2d, so yesterday and the day after tomorrow is from "now" ( => doesn't matter)