Parquet

The real reason Parquet screams isn't zstd or snappy — it's a footer trick that lets the engine refuse to read most of your data at all, and if you don't respect its shape, you can make Parquet slower than the CSV you replaced.