Japanese Yen Futures Contracts (CME) [2000-2022]
Individual contract OHLC, Volume, Open Interest data (2000-2022)
@kaggle.choweric_cme_jpy
Individual contract OHLC, Volume, Open Interest data (2000-2022)
@kaggle.choweric_cme_jpy
CREATE TABLE cme_jyh2000 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2001 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2002 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2003 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2004 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2005 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2006 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2007 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2008 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2009 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2010 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2011 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2012 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2013 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2014 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2015 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2016 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2017 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2018 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2019 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2020 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2021 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyh2022 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"open_interest" BIGINT
);
CREATE TABLE cme_jym2000 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2001 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2002 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2003 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2004 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2005 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2006 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2007 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2008 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2009 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2010 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2011 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2012 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2013 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2014 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2015 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2016 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2017 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2018 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2019 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2020 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2021 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jym2022 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"open_interest" BIGINT
);
CREATE TABLE cme_jyu2000 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2001 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2002 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2003 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2004 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2005 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2006 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2007 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2008 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2009 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2010 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2011 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2012 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2013 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2014 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2015 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2016 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2017 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2018 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2019 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2020 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2021 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyu2022 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"open_interest" BIGINT
);
CREATE TABLE cme_jyz2000 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2001 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2002 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2003 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2004 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2005 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2006 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2007 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2008 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2009 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2010 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2011 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2012 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2013 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2014 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2015 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2016 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2017 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2018 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2019 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2020 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2021 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"open_interest" DOUBLE
);
CREATE TABLE cme_jyz2022 (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"open_interest" BIGINT
);
Anyone who has the link will be able to view this.