Understanding the Behavior of Pandas GroupBy with Time Zone Conversion and DST Transition

Understanding Time Zones and Timestamps in Postgres: A Guide to Handling Offset and Time Zone Data