ctd_thin — v2026.06.26

97 partitions · 155.6 MB

partition / file	size
cruise_key=1998-02-31JD/data_0.parquet	1.2 MB
cruise_key=1998-04-31JD/data_0.parquet	1.5 MB
cruise_key=1998-07-32NM/data_0.parquet	1.4 MB
cruise_key=2003-02-31JD/data_0.parquet	2.4 MB
cruise_key=2003-07-32NM/data_0.parquet	1.6 MB
cruise_key=2003-10-32NM/data_0.parquet	1.6 MB
cruise_key=2004-01-31JD/data_0.parquet	2.5 MB
cruise_key=2004-04-31JD/data_0.parquet	742 KB
cruise_key=2004-04-32NM/data_0.parquet	1.5 MB
cruise_key=2004-07-31JD/data_0.parquet	1.7 MB
cruise_key=2004-11-33RR/data_0.parquet	1.6 MB
cruise_key=2005-01-32NM/data_0.parquet	1.6 MB
cruise_key=2005-04-32NM/data_0.parquet	1.5 MB
cruise_key=2005-07-32NM/data_0.parquet	1.6 MB
cruise_key=2005-11-32NM/data_0.parquet	1.3 MB
cruise_key=2006-02-31JD/data_0.parquet	2.1 MB
cruise_key=2006-04-32NM/data_0.parquet	1.4 MB
cruise_key=2006-07-32NM/data_0.parquet	1.4 MB
cruise_key=2006-10-33RR/data_0.parquet	1.5 MB
cruise_key=2007-01-31JD/data_0.parquet	1.7 MB
cruise_key=2007-04-31JD/data_0.parquet	1.8 MB
cruise_key=2007-07-32NM/data_0.parquet	1.5 MB
cruise_key=2007-11-32NM/data_0.parquet	1.2 MB
cruise_key=2008-01-31JD/data_0.parquet	1.2 MB
cruise_key=2008-04-31JD/data_0.parquet	1.6 MB
cruise_key=2008-08-32NM/data_0.parquet	1.3 MB
cruise_key=2008-10-32NM/data_0.parquet	1.2 MB
cruise_key=2009-01-32NM/data_0.parquet	1.2 MB
cruise_key=2009-03-31JD/data_0.parquet	1.2 MB
cruise_key=2009-07-33MH/data_0.parquet	2.9 MB
cruise_key=2009-11-32NM/data_0.parquet	1.9 MB
cruise_key=2010-01-32NM/data_0.parquet	2.4 MB
cruise_key=2010-04-31FN/data_0.parquet	1.6 MB
cruise_key=2010-08-32NM/data_0.parquet	2.0 MB
cruise_key=2010-11-32NM/data_0.parquet	1.8 MB
cruise_key=2011-01-32NM/data_0.parquet	2.9 MB
cruise_key=2011-04-3322/data_0.parquet	1.5 MB
cruise_key=2011-08-32NM/data_0.parquet	2.1 MB
cruise_key=2011-10-32NM/data_0.parquet	2.0 MB
cruise_key=2012-02-32NM/data_0.parquet	1.6 MB
cruise_key=2012-03-3322/data_0.parquet	1.3 MB
cruise_key=2012-07-32I1/data_0.parquet	1.5 MB
cruise_key=2012-10-32NM/data_0.parquet	1.7 MB
cruise_key=2013-01-3322/data_0.parquet	2.2 MB
cruise_key=2013-04-3322/data_0.parquet	1.7 MB
cruise_key=2013-07-32NM/data_0.parquet	2.0 MB
cruise_key=2013-11-32NM/data_0.parquet	2.0 MB
cruise_key=2014-02-3322/data_0.parquet	806 KB
cruise_key=2014-04-32I1/data_0.parquet	1.4 MB
cruise_key=2014-07-32NM/data_0.parquet	1.9 MB
cruise_key=2014-11-32NM/data_0.parquet	1.9 MB
cruise_key=2015-01-32NM/data_0.parquet	3.4 MB
cruise_key=2015-04-32NM/data_0.parquet	1.4 MB
cruise_key=2015-07-32OC/data_0.parquet	1.7 MB
cruise_key=2015-11-32OC/data_0.parquet	1.8 MB
cruise_key=2016-01-33UD/data_0.parquet	2.3 MB
cruise_key=2016-04-3322/data_0.parquet	2.3 MB
cruise_key=2016-07-32I1/data_0.parquet	1.7 MB
cruise_key=2016-11-33P4/data_0.parquet	2.0 MB
cruise_key=2017-01-33UD/data_0.parquet	1.7 MB
cruise_key=2017-04-3322/data_0.parquet	2.5 MB
cruise_key=2017-08-33P4/data_0.parquet	1.8 MB
cruise_key=2017-11-33P4/data_0.parquet	1.8 MB
cruise_key=2018-02-3322/data_0.parquet	935 KB
cruise_key=2018-04-3322/data_0.parquet	2.5 MB
cruise_key=2018-06-33P4/data_0.parquet	1.5 MB
cruise_key=2018-10-33P4/data_0.parquet	1.4 MB
cruise_key=2019-02-33UD/data_0.parquet	599 KB
cruise_key=2019-04-33UD/data_0.parquet	1.4 MB
cruise_key=2019-07-39C2/data_0.parquet	1.5 MB
cruise_key=2019-11-32OC/data_0.parquet	1.6 MB
cruise_key=2020-01-33UD/data_0.parquet	2.4 MB
cruise_key=2020-07-33P4/data_0.parquet	1.7 MB
cruise_key=2020-10-33P4/data_0.parquet	1.7 MB
cruise_key=2021-01-33UD/data_0.parquet	1.6 MB
cruise_key=2021-05-3322/data_0.parquet	772 KB
cruise_key=2021-07-33P4/data_0.parquet	1.3 MB
cruise_key=2021-11-33P4/data_0.parquet	1.3 MB
cruise_key=2022-04-3322/data_0.parquet	1.7 MB
cruise_key=2022-08-39C2/data_0.parquet	1.1 MB
cruise_key=2022-11-33P4/data_0.parquet	1.4 MB
cruise_key=2023-01-33UD/data_0.parquet	1.5 MB
cruise_key=2023-04-3322/data_0.parquet	2.3 MB
cruise_key=2023-07-33P4/data_0.parquet	1.3 MB
cruise_key=2023-11-33P4/data_0.parquet	1.4 MB
cruise_key=2024-01-33UD/data_0.parquet	719 KB
cruise_key=2024-04-3322/data_0.parquet	1.7 MB
cruise_key=2024-08-33P4/data_0.parquet	1.6 MB
cruise_key=2024-11-33P4/data_0.parquet	884 KB
cruise_key=2025-01-33UD/data_0.parquet	2.1 MB
cruise_key=2025-02-33UD/data_0.parquet	43 KB
cruise_key=2025-04-3322/data_0.parquet	2.2 MB
cruise_key=2025-07-33P4/data_0.parquet	883 KB
cruise_key=2025-11-33P4/data_0.parquet	533 KB
cruise_key=2026-01-33UD/data_0.parquet	1.4 MB
cruise_key=2026-04-3322/data_0.parquet	1.2 MB
index.html	27 KB

Query every partition at once rather than downloading them individually — hive_partitioning exposes the directory name as a column you can filter on:

SELECT * FROM read_parquet('https://storage.googleapis.com/calcofi-db/ducklake/releases/v2026.06.26/parquet/ctd_thin/**/*.parquet',
hive_partitioning = true) LIMIT 10;