API Returns duplicate offset during fall-back DST transition

Version 25.5.0.25325

The first 1:00 AM bucket (01:00–02:00 EDT, UTC 05:00–06:00) occurs before the transition and should carry the -04:00 offset. 

Per ISO 8601/RFC 3339, the UTC offset in a timestamp must reflect the offset in effect at that instant. During the fall-back transition, the first 1:00 AM hour is still EDT (-04:00) and the second is EST (-05:00). 

I get the same results when using "America/New_York" and "Eastern Standard Time".

# Query Params:
{
  "startTime": "2025-11-02T00:00:00.000",
  "endTime": "2025-11-02T03:00:00.000",
  "aggregateInterval": "01:00:00",
  "timezone": "America/New_York"
}

# Returned buckets
2025-11-02T00:00:00.0000000-04:00
2025-11-02T01:00:00.0000000-05:00  ← incorrect offset
2025-11-02T01:00:00.0000000-05:00
2025-11-02T02:00:00.0000000-05:00

# Expected result
2025-11-02T00:00:00.0000000-04:00
2025-11-02T01:00:00.0000000-04:00  ← first 1 AM is still EDT
2025-11-02T01:00:00.0000000-05:00
2025-11-02T02:00:00.0000000-05:00

Copy