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 Jyz2006

@kaggle.choweric_cme_jpy.cme_jyz2006

17.59 KB
392 rows
7 columns


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

Cme Jyz2007

@kaggle.choweric_cme_jpy.cme_jyz2007

17.47 KB
382 rows
7 columns


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

Cme Jyz2008

@kaggle.choweric_cme_jpy.cme_jyz2008

17.72 KB
377 rows
7 columns


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

Cme Jyz2009

@kaggle.choweric_cme_jpy.cme_jyz2009

17.68 KB
377 rows
7 columns


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

Cme Jyz2010

@kaggle.choweric_cme_jpy.cme_jyz2010

17.68 KB
379 rows
7 columns


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

Cme Jyz2011

@kaggle.choweric_cme_jpy.cme_jyz2011

18 KB
385 rows
7 columns


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

Cme Jyz2012

@kaggle.choweric_cme_jpy.cme_jyz2012

17.04 KB
362 rows
7 columns


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

Cme Jyz2013

@kaggle.choweric_cme_jpy.cme_jyz2013

18.37 KB
380 rows
7 columns


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

Cme Jyz2014

@kaggle.choweric_cme_jpy.cme_jyz2014

17.5 KB
380 rows
7 columns


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

Cme Jyz2015

@kaggle.choweric_cme_jpy.cme_jyz2015

22.94 KB
593 rows
7 columns


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

Cme Jyz2016

@kaggle.choweric_cme_jpy.cme_jyz2016

31.26 KB
847 rows
7 columns


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

Cme Jyz2017

@kaggle.choweric_cme_jpy.cme_jyz2017

37.87 KB
1098 rows
7 columns


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

Cme Jyz2018

@kaggle.choweric_cme_jpy.cme_jyz2018

40.62 KB
1220 rows
7 columns


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

Cme Jyz2019

@kaggle.choweric_cme_jpy.cme_jyz2019

40.69 KB
1260 rows
7 columns


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

Cme Jyz2020

@kaggle.choweric_cme_jpy.cme_jyz2020

39.73 KB
1260 rows
7 columns


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

Cme Jyz2021

@kaggle.choweric_cme_jpy.cme_jyz2021

40.81 KB
1255 rows
7 columns


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

Cme Jyz2022

@kaggle.choweric_cme_jpy.cme_jyz2022

54.44 KB
1269 rows
7 columns


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