As mentioned in the comment elsewhere in this thread, I run an API service (oikolab.com) that does this. You can get hourly data for any location from 1950 onward.