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 Jyh2000

@kaggle.choweric_cme_jpy.cme_jyh2000

14.21 KB
255 rows
7 columns


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

Cme Jyh2001

@kaggle.choweric_cme_jpy.cme_jyh2001

14.33 KB
261 rows
7 columns


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

Cme Jyh2002

@kaggle.choweric_cme_jpy.cme_jyh2002

13.83 KB
260 rows
7 columns


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

Cme Jyh2003

@kaggle.choweric_cme_jpy.cme_jyh2003

17.03 KB
372 rows
7 columns


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

Cme Jyh2004

@kaggle.choweric_cme_jpy.cme_jyh2004

16.67 KB
375 rows
7 columns


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

Cme Jyh2005

@kaggle.choweric_cme_jpy.cme_jyh2005

16.48 KB
377 rows
7 columns


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

Cme Jyh2006

@kaggle.choweric_cme_jpy.cme_jyh2006

17.56 KB
381 rows
7 columns


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

Cme Jyh2007

@kaggle.choweric_cme_jpy.cme_jyh2007

17.33 KB
380 rows
7 columns


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

Cme Jyh2008

@kaggle.choweric_cme_jpy.cme_jyh2008

17.15 KB
376 rows
7 columns


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

Cme Jyh2009

@kaggle.choweric_cme_jpy.cme_jyh2009

17.35 KB
375 rows
7 columns


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

Cme Jyh2010

@kaggle.choweric_cme_jpy.cme_jyh2010

17.38 KB
375 rows
7 columns


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

Cme Jyh2011

@kaggle.choweric_cme_jpy.cme_jyh2011

17.49 KB
379 rows
7 columns


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

Cme Jyh2012

@kaggle.choweric_cme_jpy.cme_jyh2012

17.27 KB
383 rows
7 columns


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

Cme Jyh2013

@kaggle.choweric_cme_jpy.cme_jyh2013

17.32 KB
365 rows
7 columns


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

Cme Jyh2014

@kaggle.choweric_cme_jpy.cme_jyh2014

18.05 KB
378 rows
7 columns


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

Cme Jyh2015

@kaggle.choweric_cme_jpy.cme_jyh2015

18.07 KB
403 rows
7 columns


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

Cme Jyh2016

@kaggle.choweric_cme_jpy.cme_jyh2016

25.32 KB
652 rows
7 columns


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

Cme Jyh2017

@kaggle.choweric_cme_jpy.cme_jyh2017

32.43 KB
903 rows
7 columns


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

Cme Jyh2018

@kaggle.choweric_cme_jpy.cme_jyh2018

39.14 KB
1159 rows
7 columns


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

Cme Jyh2019

@kaggle.choweric_cme_jpy.cme_jyh2019

41.47 KB
1261 rows
7 columns


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

Cme Jyh2020

@kaggle.choweric_cme_jpy.cme_jyh2020

40.93 KB
1260 rows
7 columns


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

Cme Jyh2021

@kaggle.choweric_cme_jpy.cme_jyh2021

39.93 KB
1260 rows
7 columns


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

Cme Jyh2022

@kaggle.choweric_cme_jpy.cme_jyh2022

50.52 KB
1270 rows
7 columns


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

Cme Jym2000

@kaggle.choweric_cme_jpy.cme_jym2000

14.59 KB
260 rows
7 columns


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

Cme Jym2001

@kaggle.choweric_cme_jpy.cme_jym2001

13.96 KB
255 rows
7 columns


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