Name: Japanese Yen Futures Contracts (CME) [2000-2022]
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Japanese Yen Futures Contracts (CME) [2000-2022]

Contract months: Mar (H), Jun (M), Sep (U), Dec (Z)

Contract description can be found at: https://www.cmegroup.com/markets/fx/g10/japanese-yen.contractSpecs.html

Note that Open Interest is always reported for the previous trading day, to avoid lookahead bias.

Tables

Cme Jyu2004

@kaggle.choweric_cme_jpy.cme_jyu2004

17.22 KB
377 rows
7 columns


CREATE TABLE cme_jyu2004 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2005

@kaggle.choweric_cme_jpy.cme_jyu2005

17.16 KB
385 rows
7 columns


CREATE TABLE cme_jyu2005 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2006

@kaggle.choweric_cme_jpy.cme_jyu2006

17.68 KB
389 rows
7 columns


CREATE TABLE cme_jyu2006 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2007

@kaggle.choweric_cme_jpy.cme_jyu2007

17.84 KB
388 rows
7 columns


CREATE TABLE cme_jyu2007 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2008

@kaggle.choweric_cme_jpy.cme_jyu2008

17.54 KB
377 rows
7 columns


CREATE TABLE cme_jyu2008 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2009

@kaggle.choweric_cme_jpy.cme_jyu2009

17.56 KB
378 rows
7 columns


CREATE TABLE cme_jyu2009 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2010

@kaggle.choweric_cme_jpy.cme_jyu2010

17.61 KB
379 rows
7 columns


CREATE TABLE cme_jyu2010 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2011

@kaggle.choweric_cme_jpy.cme_jyu2011

17.85 KB
386 rows
7 columns


CREATE TABLE cme_jyu2011 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2012

@kaggle.choweric_cme_jpy.cme_jyu2012

17.15 KB
369 rows
7 columns


CREATE TABLE cme_jyu2012 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2013

@kaggle.choweric_cme_jpy.cme_jyu2013

18.26 KB
380 rows
7 columns


CREATE TABLE cme_jyu2013 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2014

@kaggle.choweric_cme_jpy.cme_jyu2014

17.01 KB
379 rows
7 columns


CREATE TABLE cme_jyu2014 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2015

@kaggle.choweric_cme_jpy.cme_jyu2015

21.15 KB
529 rows
7 columns


CREATE TABLE cme_jyu2015 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2016

@kaggle.choweric_cme_jpy.cme_jyu2016

29.17 KB
783 rows
7 columns


CREATE TABLE cme_jyu2016 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2017

@kaggle.choweric_cme_jpy.cme_jyu2017

36.33 KB
1034 rows
7 columns


CREATE TABLE cme_jyu2017 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2018

@kaggle.choweric_cme_jpy.cme_jyu2018

41.48 KB
1261 rows
7 columns


CREATE TABLE cme_jyu2018 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2019

@kaggle.choweric_cme_jpy.cme_jyu2019

40.64 KB
1260 rows
7 columns


CREATE TABLE cme_jyu2019 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2020

@kaggle.choweric_cme_jpy.cme_jyu2020

40.04 KB
1260 rows
7 columns


CREATE TABLE cme_jyu2020 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2021

@kaggle.choweric_cme_jpy.cme_jyu2021

40.42 KB
1255 rows
7 columns


CREATE TABLE cme_jyu2021 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyu2022

@kaggle.choweric_cme_jpy.cme_jyu2022

56.74 KB
1268 rows
7 columns


CREATE TABLE cme_jyu2022 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "open_interest" BIGINT
);

Cme Jyz2000

@kaggle.choweric_cme_jpy.cme_jyz2000

16.6 KB
338 rows
7 columns


CREATE TABLE cme_jyz2000 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyz2001

@kaggle.choweric_cme_jpy.cme_jyz2001

15.17 KB
291 rows
7 columns


CREATE TABLE cme_jyz2001 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyz2002

@kaggle.choweric_cme_jpy.cme_jyz2002

17.29 KB
373 rows
7 columns


CREATE TABLE cme_jyz2002 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyz2003

@kaggle.choweric_cme_jpy.cme_jyz2003

16.55 KB
374 rows
7 columns


CREATE TABLE cme_jyz2003 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyz2004

@kaggle.choweric_cme_jpy.cme_jyz2004

17.31 KB
377 rows
7 columns


CREATE TABLE cme_jyz2004 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);

Cme Jyz2005

@kaggle.choweric_cme_jpy.cme_jyz2005

17.73 KB
386 rows
7 columns


CREATE TABLE cme_jyz2005 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "open_interest" DOUBLE
);