It’s on firebase/bigquery to avoid people doing what OP did

If you click the api link bottom of page it’ll explain.

I used the API! It only takes a few hours to download your own copy with the tool I used https://github.com/jasonthorsness/unlurker

I had to CTRL-C and resume a few times when it stalled; it might be a bug in my tool

Is there any advantage to making all these requests instead of using Clickhouse o BigQuery?

Probably not :P. I made the client for another project, https://hn.unlurker.com, and then just jumped straight to using it to download the whole thing instead of searching for an already available full data set.

My mistake - apologies. Had misunderstood what you did