query_parquet.sqlite

$ sqlite3
sqlite> .load ./libparquet
sqlite> CREATE VIRTUAL TABLE weather USING parquet('weather.2016.parquet');
sqlite> select ScreenTemperature,DATETIME(ROUND(ObservationDate / 1000), 'unixepoch'),Region from weather where ScreenTemperature = (select max(ScreenTemperature) from weather);
15.8|2016-03-17 00:00:00|Highland & Eilean Siar