â??â??
Another source of monthly hour of day average temperatures is the .stat file (line 64 to 91) that ships with energy plus weather (epw) files, as posted below for Portland OR.Â
I have found this monthly hour of day average data to be quite useful. I use it to have a better understanding of a site location than just ASHRAE climate zone and have had thoughts about proposing the addition of a weather data classification that accounts for diurnal temperature differences in addition to the current degree day and humidity methods used to classify ASHRAE weather file locations. Also, I have have used this data along with solar data from stat files to make a thermodynamic loads calculator for PCM's that uses similar inputs to E+ with calculations that mimic the E+ heat balance method. https://docs.google.com/spreadsheets/d/1bIrKlOCHp4pyF6eUVm3O3kIeMfRNT5uQ4aYyKfD4BEo/edit?usp=sharing
- Average Hourly Statistics for Dry Bulb temperatures °C
      Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
 0:01- 1:00  4.4  6.0  5.4  8.3 10.2 14.8 16.3 15.6 12.7 10.7  6.4  5.3
 1:01- 2:00  4.4  5.9  5.2  8.1  9.6 13.8 15.6 14.8 12.3 10.5  6.3  5.2
 2:01- 3:00  4.5  5.8  5.0  7.7  9.3 13.4 14.9 14.2 11.5 10.4  6.1  5.4
 3:01- 4:00  4.3  5.4  4.8  7.5  8.9 12.8 14.5 13.7 10.9 10.5  6.2  5.2
 4:01- 5:00  4.5  5.3  4.7  7.2  8.7 12.9 14.2 13.4 10.9 10.4  6.2  5.3
 5:01- 6:00  4.4  5.3  4.6  7.4  9.4 13.6 14.9 13.7 10.8 10.2  6.3  5.2
 6:01- 7:00  4.1  5.2  4.5  8.4 10.5 14.7 16.0 15.2 12.0 10.2  6.0  5.2
 7:01- 8:00  4.2  5.5  5.4  9.5 11.6 15.8 17.0 16.8 14.4 11.2  6.2  5.3
 8:01- 9:00  4.6  6.3  6.4 10.3 12.6 17.0 18.3 18.2 16.5 12.2  6.8  5.6
 9:01-10:00  5.2  7.3  7.6 11.5 13.7 18.1 19.6 19.9 18.5 13.2  7.4  6.3
 10:01-11:00  5.9  8.5  8.5 12.3 14.7 19.1 21.3 21.5 20.2 14.5  8.3  6.6
 11:01-12:00  6.5  9.3  9.2 13.4 15.4 20.2 22.8 23.3 22.1 15.8  9.0  7.0
 12:01-13:00  6.9  9.9  9.9 14.2 16.3 21.3 24.3 24.9 23.5 16.4  9.7  7.1
 13:01-14:00  7.0 10.2 10.4 14.9 17.2 22.1 25.4 26.2 24.6 16.7  9.9  7.2
 14:01-15:00  7.0 10.6 10.3 15.5 17.6 22.7 26.4 27.2 25.4 16.9 10.0  7.0
 15:01-16:00  6.6 10.5 10.4 15.7 17.4 23.2 26.6 27.2 25.4 16.2  9.7  6.8
 16:01-17:00  6.0  9.7  9.9 15.3 17.3 23.2 26.5 26.9 24.9 15.5  8.8  6.4
 17:01-18:00  5.6  8.6  9.1 14.8 16.8 22.5 25.8 25.9 22.7 14.3  7.8  6.1
 18:01-19:00  5.4  7.8  8.0 13.4 15.9 21.4 24.3 23.9 20.0 13.3  7.4  6.0
 19:01-20:00  5.1  7.2  7.5 12.0 14.4 19.6 22.4 22.0 17.9 12.5  6.9  5.7
 20:01-21:00  5.1  7.1  6.9 11.2 13.2 18.2 20.8 20.4 16.3 11.9  6.9  6.0
 21:01-22:00  4.8  6.6  6.4 10.4 12.4 16.8 19.5 19.0 15.5 11.5  6.6  5.7
 22:01-23:00  4.6  6.3  6.1  9.6 11.6 16.0 18.4 17.3 14.4 11.0  6.6  5.7
 23:01-24:00  4.5  5.9  5.8  9.1 10.8 15.5 17.3 16.4 13.3 11.0  6.4  5.5
 Max Hour   14  15  14  16  15  17  16  15  15  15  15  14
 Min Hour   7  7  7  5  5  4  5  5  6  7  7  4
This kind of data can easily be plotted in excel or a google sheet. The chart below was made in this google sheet:Â
https://docs.google.com/spreadsheets/d/1u-pGeaIufwclu4AWid44jmF7CnIRdLSUWY5vhQdjDpU/edit?usp=sharing