Resample is not timezone aware

[paradox460]

Describe the bug If using an offset timezone, say, -0700, and running resample on daily binned values, the values will display with an offset of 7 hours before the bin should start.

Ex: a bin for March 5th would show as March 4 @ 17:00

[dbuezas]

For the record, this is about using home assistant in a non gmt-0 time zone (not using time offset)

[deltamelter]

Plotly graph certainly looks nicer than Apexchart version, but one of the data series is not being interpreted correctly. Coloured bars are from source in UTC with "Z" notation, the grey bars that they overlay are from an adjusted source (+1:00). Plotly isn't respecting the timezone. Everything else in config looks the same.

- start_time: '2024-04-03T16:00:00+01:00'
  end_time: '2024-04-03T17:00:00+01:00'
  price_pence_per_kwh: 6.604500000000001

- start: '2024-04-03T15:00:00+00:00'
  end: '2024-04-03T15:30:00+00:00'
  value_inc_vat: 0.247485
- start: '2024-04-03T15:30:00+00:00'
  end: '2024-04-03T16:00:00+00:00'
  value_inc_vat: 0.26271