Part of the OpenStudio and EnergyPlus result files results is the Zone Sensible Cooling and Heating Sensible Sizing section which shows calculated design and user loads per thermal zone. To get hourly values (or any time step specified in your simulation settings), check the epluszsz .csv file.

The file location is MODEL NAME > run > epluzsz