I have seen Apple engineers post numerous times on threads about this topic. Each time they state that historical data goes back to Aug 1, 2021 and that's it. It's a joke really. If you truly need historical data (and an actual reliable weather API), you should probably consider something else.
Topic:
App & System Services
SubTopic:
General
Tags: