I don't know who's to thank for it, but someone set up a constantly updated ClickHouse database of all data from the Hacker News API at https://play.clickhouse.com/play?user=play#U0VMRUNUIG1heCh0a...
It gets you 80% of the way there on any HN data project.