BTW, climate.gov keeps historical data all the way back to the 1950s. Could you just pull from their api instead of storing it yourself? even if it was a daily average snapped once a week, that would be useful :)

I would also be willing to pay for a subscription in order to have access to historical data. We plan lots of sailing trips along the west US coastline and it would be super useful!