NYC Taxi Open NYC Taxi in the Results Explorer
NYC Taxi on BenchBox: 21 published runs across 6 platforms. Latest run 2026-10-26.
Platforms Score definitions Geomean query time Geometric mean of the displayed per-query times of the run. Unit: milliseconds, shown as seconds from 1,000 ms; lower is better. Definition in the benchmark methodology . SF 0.01, power Ranked by geomean query time Rank Platform Version Run date Geomean query time Geomean Ranking Execution environment Tuning mode Trust label 1 DuckDB v1.3.2 2026-08-26 0.6 ms 0.6 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 2 ClickHouse Local — 2026-08-26 2.8 ms 2.8 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 3 DataFusion v53.0.0 2026-08-26 3 ms 3 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 4 ClickHouse Local — 2026-10-26 6.8 ms 6.8 ms Ranked Local, Arm64, 9.8 GB No tuning Maintainer Run
SF 0.1, power Ranked by geomean query time Rank Platform Version Run date Geomean query time Geomean Ranking Execution environment Tuning mode Trust label 1 DuckDB v1.3.2 2026-08-26 1.5 ms 1.5 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 2 ClickHouse Local — 2026-08-26 5.6 ms 5.6 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 3 ClickHouse Local — 2026-10-26 10 ms 10 ms Ranked Local, Arm64, 9.8 GB No tuning Maintainer Run 4 DataFusion v53.0.0 2026-08-26 11 ms 11 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 5 Snowflake v10.35.101 2026-10-01 361 ms 361 ms Ranked Cloud, AWS AWS_US_EAST_2, X-Small No tuning Maintainer Run 6 Databricks v2026.36 2026-10-01 479 ms 479 ms Ranked Cloud, AWS us-east-2, 2X-Small No tuning Maintainer Run 7 BigQuery — 2026-09-25 928 ms 928 ms Ranked Cloud, GCP US No tuning Maintainer Run
SF 1, power Ranked by geomean query time Rank Platform Version Run date Geomean query time Geomean Ranking Execution environment Tuning mode Trust label 1 DuckDB v1.3.2 2026-08-26 5.9 ms 5.9 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 2 DataFusion v53.0.0 2026-08-26 27 ms 27 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 3 ClickHouse Local — 2026-08-26 29 ms 29 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 4 ClickHouse Local — 2026-10-26 61 ms 61 ms Ranked Local, Arm64, 9.8 GB No tuning Maintainer Run 5 Snowflake v10.34.101 2026-09-25 305 ms 305 ms Ranked Cloud, AWS AWS_US_EAST_2, X-Small No tuning Maintainer Run 6 Databricks v2026.36 2026-10-01 593 ms 593 ms Ranked Cloud, AWS us-east-2, 2X-Small No tuning Maintainer Run 7 BigQuery — 2026-09-23 1.05 s 1.05 s Ranked Cloud, GCP US No tuning Maintainer Run
SF 10, power Ranked by geomean query time Rank Platform Version Run date Geomean query time Geomean Ranking Execution environment Tuning mode Trust label 1 Snowflake v10.35.101 2026-10-01 615 ms 615 ms Ranked Cloud, AWS AWS_US_EAST_2, X-Small No tuning Maintainer Run 2 Databricks v2026.36 2026-10-01 665 ms 665 ms Ranked Cloud, AWS us-east-2, 2X-Small No tuning Maintainer Run 3 BigQuery — 2026-09-27 1.02 s 1.02 s Ranked Cloud, GCP US No tuning Maintainer Run
Results snapshot Published results 467 BenchBox version 0.5.1 Core commit d7197c9c12abCorpus commit 869d6fedc079Snapshot SHA-256 cc71e4d1b0c2Read model 20 Produced 2026-11-22 These figures are generated from the same results snapshot the Results Explorer loads. Results withdrawn upstream are absent after the next site build.