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
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-260.6 ms0.6 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2ClickHouse Local—2026-08-262.8 ms2.8 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
3DataFusionv53.0.02026-08-263 ms3 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
4ClickHouse Local—2026-10-266.8 ms6.8 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run

SF 0.1, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-261.5 ms1.5 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2ClickHouse Local—2026-08-265.6 ms5.6 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
3ClickHouse Local—2026-10-2610 ms10 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
4DataFusionv53.0.02026-08-2611 ms11 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
5Snowflakev10.35.1012026-10-01361 ms361 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
6Databricksv2026.362026-10-01479 ms479 msRankedCloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
7BigQuery—2026-09-25928 ms928 msRankedCloud, GCP USNo tuningMaintainer Run

SF 1, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-265.9 ms5.9 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2DataFusionv53.0.02026-08-2627 ms27 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
3ClickHouse Local—2026-08-2629 ms29 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
4ClickHouse Local—2026-10-2661 ms61 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
5Snowflakev10.34.1012026-09-25305 ms305 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
6Databricksv2026.362026-10-01593 ms593 msRankedCloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
7BigQuery—2026-09-231.05 s1.05 sRankedCloud, GCP USNo tuningMaintainer Run

SF 10, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1Snowflakev10.35.1012026-10-01615 ms615 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
2Databricksv2026.362026-10-01665 ms665 msRankedCloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
3BigQuery—2026-09-271.02 s1.02 sRankedCloud, GCP USNo tuningMaintainer Run