Cocoa Futures Contracts (ICE) [2000-2022]
Individual contract OHLC, Volume, Open Interest data (2000-2022)
@kaggle.choweric_ice_cocoa
Individual contract OHLC, Volume, Open Interest data (2000-2022)
@kaggle.choweric_ice_cocoa
CREATE TABLE ice_ccu2006 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2007 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2008 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2009 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2010 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2011 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2012 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2013 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2014 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2015 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2016 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2017 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2018 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2019 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2020 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2021 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccu2022 (
"date" TIMESTAMP,
"open" BIGINT,
"high" BIGINT,
"low" BIGINT,
"close" BIGINT,
"volume" BIGINT,
"open_interest" BIGINT
);
CREATE TABLE ice_ccz2000 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccz2001 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccz2002 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccz2003 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccz2004 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccz2005 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccz2006 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_ccz2007 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
Anyone who has the link will be able to view this.