COPY trips
    FROM '/Users/mark/taxi_csv/*.gz'
    WITH (HEADER='false');

> The above managed to complete in 31 minutes and 40 seconds. The resulting import produced 294 GB of data in OmniSciDB's internal format.

I’m really curious how a simple import (no indexes or data typing) into SQLite would compare. But I don’t have 700GB of free SSD space to spare.