I’ve been thinking of using absurd-sql for it since I saw https://news.ycombinator.com/item?id=28156831 last week
Here's 1,000,000 rows example I just threw together for you
https://bl.ocks.org/texodus/3802a8671fa77399c7842fd0deffe925
and a CSV example, you try yours right now
https://bl.ocks.org/texodus/02d8fd10aef21b19d6165cf92e43e668
Querying CSV files is particularly painful over the network since we still have to read everything for a full scan.
With Parquet, you would at least only have to read the columns of group by keys and aggregate arguments.
Try it out and share your experiences with us!