Here’s a thread on results with duckdb, I don’t mean to discourage you taking a shot at all though: https://github.com/gunnarmorling/1brc/discussions/39

Instructions on how to create it can be found here:

https://github.com/gunnarmorling/1brc?tab=readme-ov-file#run...

The Python version:

https://github.com/gunnarmorling/1brc/blob/main/src/main/pyt...

In the original 1BRC, it's a python script that generates the data.