1๏ธโฃ๐๐๏ธ The One Billion Row Challenge -- A fun exploration of how quickly 1B rows from a text file can be aggregated.
Using duckdb to load and query the data. Execution time is around 30 seconds on my PC. On stronger hardware, it can be faster.
python run.py measurements.txt