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_cch2000 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2001 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2002 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2003 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2004 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2005 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2006 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2007 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2008 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2009 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2010 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2011 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2012 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2013 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2014 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2015 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2016 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2017 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2018 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2019 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2020 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2021 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cch2022 (
"date" TIMESTAMP,
"open" BIGINT,
"high" BIGINT,
"low" BIGINT,
"close" BIGINT,
"volume" BIGINT,
"open_interest" BIGINT
);
CREATE TABLE ice_cck2000 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE ice_cck2001 (
"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.