[AUnterrainer]

My one liner solution runs in 76ms on my 10 year old mac. q)\ts exec (min;max;avg)@\:measurement by city from flip `city`measurement!("SF";";") 0: `:weather_stations.csv 76 8720688

[anonymoushn]

Your 10 year old mac can ingest the input at 157GB/s? Is that from RAM or from disk?

[AUnterrainer]

Actually I only had a partial file :/ didn't realise that the file in the data folder was only a sample