I tried Google BigQuery but it is at day level.
Is there any source for hourly historical weather data for USA?
I tried Google BigQuery but it is at day level.
Is there any source for hourly historical weather data for USA?
NCDC is a great resource for this type of stuff. This data set should have exactly what you're looking for with hourly METAR reports from ASOS stations around the country. There's a ton of other data sets there but this should be closest to what you want.
The Iowa Environmental Mesonet is a great source for hourly data, with a bunch of options for data viewing as well as automation of downloading. https://mesonet.agron.iastate.edu/
Try the RAWS site at Western Regional Climate Center, here. When you visit the WRCC site, you will notice that the site is still under construction. Nevertheless, move your cursor over the state you wish data for, select that state, and an interactive map for that state will be displayed showing the available RAWS data sites from which you may choose. An inventory of available data is then displayed for the chosen site. Keep in mind that some Remote Automatic Weather Stations may have limited records, while others are voluminous.
You may also wish to check this site at the University of Utah, here. Simply select the state for which you wish to retrieve hourly data, select the site of interest, and review the available data. Note that several and various data series are available from which hourly data may be accessed. A user account is required, though, to download data for a series longer than one day.
If you're just wanting to look up specific days when needed, it may wind up being easiest to use Weather Underground's historic data... go to wunderground.com, enter your location, then choose history:
and then there is a basic graph of the day, and additional readout of hourly observations further down the page. I usually find WU a solid option if looking up a day. For larger datasets to run statistical analysis or algorithms on, you'd need something with more flexibility to download data.