File Formats for Historical Data - Data Format

About File Name

Data Name File Name Format Description
Quotes for All Products by Trade Date

souba_d_YYYYMMDD_YYYYMMDD_hhmm.csv
When final data of day session, file name has "_last" strings.

YYYY: Year, MM:Month, DD: Day, hh:Hour, mm:Minutes
First date part means Trade Date, Second part of date means Update Day.
Quotes for All Products by Session
(Day Session)

souba_s1_YYYYMMDD_YYYYMMDD_hhmm.csv

YYYY: Year, MM:Month, DD: Day, hh:Hour, mm:Minutes
First date part means Trade Date, Second part of date means Update Day.
Quotes for All Products by Session
(Night Session)

souba_s2_YYYYMMDD_YYYYMMDD_hhmm.csv

YYYY: Year, MM:Month, DD: Day, hh:Hour, mm:Minutes
First date part means Trade Date, Second part of date means Update Day.
Periodic Quotes for All Products by Trade Date souba_np_YYYYMMDD_YYYYMMDD_hhmm.csv YYYY: Year, MM:Month, DD: Day, hh:Hour, mm:Minutes
First date part means Trade Date, Second part of date means Update Day.
Trading Volume and Open Interest shukei_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
This date is Trade Date.
Crude Oil Price in US Dollar Pricelist_XXXX_YYYYMMDD_YYYYMMDD_hhmm.csv YYYY: Year, MM:Month, DD: Day, hh:Hour, mm:Minutes
First date part means Trade Date, Second part of date means Update Day.
Crude Oil Price in US Dollar
(Monthly)
Pricelist_XXXX_YYYYMM.csv YYYY: Year, MM:Month, DD: Day
Open Interest by 2 Categories torikumi_ct2_YYYYMMDD_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
First date part means Trade Date, Second part of date means Update Day.
Open Interest by 6 Categories torikumi_ct6_YYYYMMDD_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
First date part means Trade Date, Second part of date means Update Day.
Open Interest by 2 Categories [Weekly] torikumi_weekly_ct2_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
First date part means Trade Date, Second part of date means Update Day.
Open Interest by 6 Categories [Weekly] torikumi_weekly_ct6_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
First date part means Trade Date, Second part of date means Update Day.
Trading Volume by Top 10 Members baibai_top10_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
This date is Trade Date.
Trading Status status_day_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
Date part means Trade Date.
Spread Market souba_spd1_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
This date is Trade Date.
Spread Market (Detail) souba_spd2_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
This date is Trade Date.
Night Session Reference Quotes (day) night_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
This date is Trade Date.
Night Session Reference Quotes (Year) night_yearly_YYYY.csv YYYY: Year
Theoretical spot price tgs_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
This date is Trade Date.
Off floor Trading souba_j-net_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
This date is Trade Date.
Option Index option_YYYYMMDD.csv YYYY: Year, MM:Month, DD: Day
This date is Trade Date.
Volatility volatility_YYYYMM.csv YYYY: Year, MM:Month
This date is Trade Month.
Gasoline Spot Prices oilspot_gs_YYYYMM.csv YYYY: Year, MM:Month
This date is Trade Month.

Quotes for All Products by Trade Date

Item Item Name Format Description
A Update Date Char Update Date (YYYYMMDD)
B Update Time Char Update Time (HHMMSS)
C Trade Date Char Trade Date (YYYYMMDD)
D Institutions Code Char Institutions Code ("77":TOCOM)
E Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
* Type of trade is not applicable for Nikkei-TOCOM Commodity Index and Nikkei-TOCOM Sub Commodity Index.
F Product Code Varchar Product Code
Here
G Contract Month Char Contract Month(YYYYMM)
H Strike Price Varchar Strike Price
I At the money flag Char "*": At the money
J Volume Fix Flag Char "K" volume fixed
K Settlement Flag Char After the end of Day Session:
'S': Start Price of Settlement
'E': Settlement Price was fixed (Same price with Start Price)
'D': Settlement Price was fixed (Fixed Price is different with Start Price)
L Session end flag Char "1" end of day session
"2" end of night session
M Start Price Varchar Start Price
N High Price Varchar High Price
O Low Price Varchar Low Price
P Current Price Varchar Current Price
Q Last Settlement price Varchar Last Settlement price
R Offset from previous day Varchar Offset from Current Price and Last Settlement price.
S Offset rate from previous day (%) Varchar Commodity Index:
-> Offset from previous day / Last Settlement Price * 100
T Settlement price Varchar Settlement price
U Volume Varchar Volume
V Open Interest Varchar Open Interest
W Volume Total by products Varchar Volume Total by products

Quotes for All Products by Session (Day Session)

Item Item Name Format Description
A Update Date Char Update Date (YYYYMMDD)
B Update Time Char Update Time (HHMMSS)
C Trade Date Char Trade Date (YYYYMMDD)
D Institutions Code Char Institutions Code("77":TOCOM)
E Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
* Type of trade is not applicable for Nikkei-TOCOM Commodity Index and Nikkei-TOCOM Sub Commodity Index.
F Product Code Varchar Product Code
Here
G Contract Month Char Contract Month(YYYYMM)
H Strike Price Varchar Strike Price
I At the money flag Char "*": At the money
J Volume Fix Flag Char "K" volume fixed
K Settlement Flag Char After the end of Day Session:
'S': Start Price of Settlement
'E': Settlement Price was fixed (Same price with Start Price)
'D': Settlement Price was fixed (Fixed Price is different with Start Price)
L Session end flag Char "1" end of day session
"2" end of night session
M Start Price Varchar Start Price
N High Price Varchar High Price
O Low Price Varchar Low Price
P Current Price Varchar Current Price
Q Last Settlement price Varchar Last Day Settlement price
R Offset from previous day Varchar Offset from Current Price and Last Settlement price.
S Settlement price Varchar Settlement price
T Volume Varchar Volume
U Open Interest Varchar Open Interest
V Volume Total by products Varchar Volume Total by products

Quotes for All Products by Session (Night Session)

Item Item Name Format Description
A Update Date Char Update Date (YYYYMMDD)
B Update Time Char Update Time (HHMMSS)
C Trade Date Char Trade Date (YYYYMMDD)
D Institutions Code Char Institutions Code("77":TOCOM)
E Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
* Type of trade is not applicable for Nikkei-TOCOM Commodity Index and Nikkei-TOCOM Sub Commodity Index.
F Product Code Varchar Product Code
Here
G Contract Month Char Contract Month(YYYYMM)
H Strike Price Varchar Strike Price
I At the money flag Char "*": At the money
J Volume Fix Flag Char "K" volume fixed
K Settlement flag Char empty
L Session end flag Char "1" end of day session
"2" end of night session
M Start Price Varchar Start Price
N High Price Varchar High Price
O Low Price Varchar Low Price
P Current Price Varchar Current Price
Q Last Settlement price Varchar Last Day Settlement price
R Offset from previous day Varchar Offset from Current Price and Last Settlement price.
S Settlement price Varchar Settlement price
T Volume Varchar Volume
U Open Interest Varchar Open Interest
V Volume Total by products Varchar Volume Total by products

Periodic Quotes for All Products by Trade Date

Item Item Name Format Description
A Update Date Char Update Date (YYYYMMDD)
B Update Time Char Update Time (HHMMSS)
C Trade Date Char Trade Date?(YYYYMMDD)
D Institutions Code Char Institutions Code("77":TOCOM)
E Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
* Type of trade is not applicable for Nikkei-TOCOM Commodity Index and Nikkei-TOCOM Sub Commodity Index.
F Product Code Varchar Product Code
Here
G Contract Month Char Contract Month(YYYYMM)
H Strike Price Varchar Strike Price
I At the money flag Char "*": At the money
J Volume Fix Flag Char "K" volume fixed
K Settlement price Flag Char After the end of Day Session:
'S': Start Price of Settlement
'E': Settlement Price was fixed (Same price with Start Price)
'D': Settlement Price was fixed (Fixed Price is different with Start Price)
L Session end flag Char "1" end of day session
"2" end of night session
M Start Price Varchar Start Price
N High Price Varchar High Price
O Low Price Varchar Low Price
P Current Price Varchar Current Price
Q Last Settlement price Varchar Last Day Settlement price
R Offset from previous day Varchar Offset from Current Price and Last Settlement price.
S Settlement price Varchar Settlement price
T Volume Varchar Volume
U Open Interest Varchar Open Interest
V Volume Total by products Varchar Volume Total by products

Off Floor Trading

Item Item Name Format Description
A Update Date Char Update Date (YYYYMMDD)
B Update Time Char Update Time (HHMMSS)
C Trade Date Char Trade Date?(YYYYMMDD)
D Institutions Code Char Institutions Code("77":TOCOM)
E Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
* Type of trade is not applicable for Nikkei-TOCOM Commodity Index and Nikkei-TOCOM Sub Commodity Index.
F Product Code Varchar Product Code
Here
G Contract Month Char Contract Month(YYYYMM)
H Strike Price Varchar Strike Price
I At the money flag Char "*": At the money
J Volume Fix Flag Char "K" volume fixed
K Settlement price Flag Char After the end of Day Session:
'S': Start Price of Settlement
'E': Settlement Price was fixed (Same price with Start Price)
'D': Settlement Price was fixed (Fixed Price is different with Start Price)
L Session end flag Char Empty (no value)
M Start Price Varchar Start Price
N High Price Varchar High Price
O Low Price Varchar Low Price
P Current Price Varchar Current Price
Q Last Settlement price Varchar Empty (no value)
R Offset from previous day Varchar Empty (no value)
S Settlement price Varchar Empty (no value)
T Volume Varchar Volume
U Open Interest Varchar Empty (no value)
V Volume Total by products Varchar Empty (no value)

Trading Volume and Open Interest (Daily)

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Type Char Trading Type
="FUD":Physically Delivered Futures Transaction
="FUC":Cash-settled Futures Transaction
="COA":Call Options Transaction
="POA":Put Options Transaction
C Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
D Product Name Varchar Product Name
="GOLD":GOLD STANDARD
="SILV":SILVER
="PLAT":PLATINUM STANDARD
="PALL":PALLADIUM
="M-GD":GOLD MINI
="M-PT":PLATINUM MINI
="GDCD":GOLD Rolling Spot
="PTCD":PLATINUM Rolling Spot
="ALUM":ALUMINUM
="GASO":GASOLINE
="TBGA":Cash-settled BARGE GASOLINE (From May 8, 2017)
="TLGA":Cash-settled LORRY GASOLINE (From May 8, 2017)
="KERO":KEROSENE
="TBKE":Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="TLKE":Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="GSOL":GAS OIL
="TBGO":Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="TLGO":Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="CRUD":DUBAI CRUDE OIL
="CGAS":CHUKYO GASOLINE
="CKER":CHUKYO KEROSENE
="RUBBER":RUBBER
="TGCN":Corn
="TGSB":Soybeans
="TGAB":Azuki Beans
="TGRS":Raw Sugar
E Product Code Varchar Product Code
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD Rolling Spot
="19" :PLATINUM Rolling Spot
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RUBBER
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
F Contract Month Char Contract Month(YYYY/MM)
G Strike Price Varchar Strike Price
H Trading volume(Long) Varchar Trading volume(Long)
I Trading volume
(Off-Floor Trading)(Long)
Varchar Trading volume(Off-Floor Trading)(Long)
J Trading volume
(EFP/EFS)(Long)
Varchar Trading volume(EFP/EFS)(Long)
K Trading volume
(Stop Loss)(Long)
Varchar Trading volume(Stop Loss)(Long)
L Trading volume
(Rounding)(Long)
Varchar Trading volume(Rounding)(Long)
M Trading volume
(Penalty processing)(Long)
Varchar Trading volume(Penalty processing)(Long)
N Trading volume
(Failure during)(Long)
Varchar Trading volume(Failure during)(Long)
O Trading volume
(Other)(Long)
Varchar Trading volume(Other)(Long)
P Trading volume(Short) Varchar Trading volume(Short)
Q Trading volume
(Off-Floor Trading)(Short)
Varchar Trading volume(Off-Floor Trading)(Short)
R Trading volume
(EFP/EFS)(Short)
Varchar Trading volume(EFP/EFS)(Short)
S Trading volume
(Stop Loss)(Short)
Varchar Trading volume(Stop Loss)(Short)
T Trading volume
(Rounding)(Short)
Varchar Trading volume(Rounding)(Short)
U Trading volume
(Penalty processing)(Short)
Varchar Trading volume(Penalty processing)(Short)
V Trading volume
(Failure during)(Short)
Varchar Trading volume(Failure during)(Short)
W Trading volume
(Other)(Short)
Varchar Trading volume(Other)(Short)
X Long position Varchar Long position
Y Short position Varchar Short position
Z Number of Options Exercised(Call) Varchar Number of Options Exercised(Call)
AA Number of Options Exercised(Put) Varchar Number of Options Exercised(Put)
AB Early Delivery, Declared Delivery Volume (Buy)
Varchar Early Delivery, Declared Delivery Volume (Buy)
AC Early Delivery, Declared Delivery Volume (Sell) Varchar Early Delivery, Declared Delivery Volume (Sell)
AD Delivery Volume/Settlement Volume (Buy) Varchar Delivery Volume/Settlement Volume (Buy)
AE Delivery Volume/Settlement Volume (Sell) Varchar Delivery Volume/Settlement Volume (Sell)

Trading Volume and Open Interest (Yearly)

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Type Char Trading Type
="FUD":Physically Delivered Futures Transaction
="FUC":Cash-settled Futures Transaction
="COA":Call Options Transaction
="POA":Put Options Transaction
C Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
D Product Name Varchar Product Name
="GOLD":GOLD
="SILV":SILVER
="PLAT":PLATINUM
="PALL":PALLADIUM
="M-GD":GOLD MINI
="M-PT":PLATINUM MINI
="GDCD":GOLD Rolling Spot
="PTCD":PLATINUM Rolling Spot
="ALUM":ALUMINUM
="GASO":GASOLINE
="TBGA":Cash-settled BARGE GASOLINE (From May 8, 2017)
="TLGA":Cash-settled LORRY GASOLINE (From May 8, 2017)
="KERO":KEROSENE
="TBKE":Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="TLKE":Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="CRUD":CRUDE CRUDE OIL
="GSOL":GAS OIL
="TBGO":Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="TLGO":Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="CRUD":CRUDE OIL
="CGAS":CHUKYO GASOLINE
="CKER":CHUKYO KEROSENE
="RUBBER":RUBBER
="TGCN":Corn
="TGSB":Soybeans
="TGAB":Azuki Beans
="TGRS":Raw Sugar
E Product Code Varchar Product Code
="11" :GOLD
="12" :SILVER
="13" :PLATINUM
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD Rolling Spot
="19" :PLATINUM Rolling Spot
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RUBBER
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
F Contract Month Char Contract Month(YYYY/MM)
G Strike Price Varchar Strike Price
H Trading volume(Long) Varchar Trading volume(Long)
I Trading volume
(EFP/EFS)(Long)
Varchar Trading volume(EFP/EFS)(Long)
J Trading volume(Short) Varchar Trading volume(Short)
K Trading volume
(EFP/EFS)(Short)
Varchar Trading volume(EFP/EFS)(Short)
L Long position Varchar Long position
M Short position Varchar Short position
N Number of Options Exercised(Call) Varchar Number of Options Exercised(Call)
O Number of Options Exercised(Put) Varchar Number of Options Exercised(Put)
P Early Delivery, Declared Delivery Volume (Buy)
Varchar Early Delivery, Declared Delivery Volume (Buy)
Q Early Delivery, Declared Delivery Volume (Sell) Varchar Early Delivery, Declared Delivery Volume (Sell)
R Delivery Volume/Settlement Volume (Buy) Varchar Delivery Volume/Settlement Volume (Buy)
S Delivery Volume/Settlement Volume (Sell) Varchar Delivery Volume/Settlement Volume (Sell)
T Settlement price Varchar Settlement price

Crude Oil Price in US dollar

Item Item Name Format Description
A Update Date Char Update Date (YYYYMMDD)
B Update Time Char Update Time (HHMMSS)
C Trade Date Char Trade Date?(YYYYMMDD)
D Institutions Code Char Institutions Code("77":TOCOM)
E Type Char Type
="12":Cash-settled Futures Transaction
F Product Code Varchar Product Code
="33" :CRUDE OIL
G Contract Month Char Contract Month(YYYY/MM)
H Strike Price Varchar Strike Price
I At the money flag Char "*": At the money
J Volume Fix Flag Char "K" volume fixed
K Settlement price Flag Char After the end of Day Session:
'S': Start Price of Settlement
'E': Settlement Price was fixed (Same price with Start Price)
'D': Settlement Price was fixed (Fixed Price is different with Start Price)
L Session end flag Char "1" end of day session
"2" end of night session
M Start Price Varchar Start Price
N High Price Varchar High Price
O Low Price Varchar Low Price
P Current/Final Price Varchar Current/Final Price
Q Last Settlement price Varchar Last Settlement price
R Offset from previous day Varchar Offset from Current Price to last Settlement Price.

Crude Oil Price in US dollar (Monthly)

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Send Time Char Send Time(hh:mm:ss)
C Type Char Type
="12":Cash-settled Futures Transaction
D Product Code Varchar Product Code
="33" :CRUDE OIL
E Contract Month Char Contract Month(YYYY/MM)
F Start Price Varchar Start Price
G High Price Varchar High Price
H Low Price Varchar Low Price
I Current/Final Price Varchar Current/Final Price
J Offset from previous day Varchar Offset from Current Price to last Settlement Price.
K Volume Fix Flag Char "K" volume was fixed

Open Interest by 2 Categories

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Institutions Code Char Institutions Code ("77":TOCOM)
C Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
D Product Code Varchar Product Code
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD ROLLING SPOT
="19" :PLATINUM ROLLING SPOT
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RUBBER
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
E Categories Char Categories
="40": Commercials
="50": Non-commercials
F Open Interest(Short) Varchar Open Interest (Short)
G Open Interest(Long) Varchar Open Interest (Long)

Open Interest by 6 Categories

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Institutions Code Char Institutions Code ("77":TOCOM)
C Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
D Product Code Varchar Product Code
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD ROLLING SPOT
="19" :PLATINUM ROLLING SPOT
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RUBBER
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
E Categories Char Categories
="40": Commercials
="5B": Prop Market Maker
="5C": Fond / Investment trust
="5D": General Investor
="5E": Agency
="5F": Foreign commodity futures traders
F Open Interest(Short) Varchar Open Interest by categories (Short)
G Open Interest(Long) Varchar Open Interest by categories(Long)

Open Interest by 2 Categories [Weekly]

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Institutions Code Char Institutions Code ("77":TOCOM)
C Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
D Product Code Varchar Product Code
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD Rolling Spot
="19" :PLATINUM ROLLING SPOT
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RUBBER
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
E Open Interest(Commercials)(Short) Varchar Open Interest(Commercials)(Short)
F Open Interest(Commercials)(Long) Varchar Open Interest(Commercials)(Long)
G Open Interest(Non-commercials)(Short) Varchar Open Interest(Non-commercials)(Short)
H Open Interest(Non-commercials)(Long) Varchar Open Interest(Non-commercials)(Long)
I Settlement (Nearby Month) Varchar Settlement (Nearby Month)
* 2nd month for crude oil
J Settlement (Back Month) Varchar Settlement (Back Month)

Open Interest by 6 Categories [Weekly]

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Institutions Code Char Institutions Code ("77":TOCOM)
C Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
D Product Code Varchar Product Code
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD Rolling Spot
="19" :PLATINUM ROLLING SPOT
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RUBBER
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
E Open Interest(Commercials)(Short) Varchar Open Interest(Commercials)(Short)
F Open Interest(Commercials)(Long) Varchar Open Interest(Commercials)(Long)
G Open Interest(Prop, Makert Maker)(Short) Varchar Open Interest(Prop, Makert Maker)(Short)
H Open Interest(Prop, Makert Maker)(Long) Varchar Open Interest(Prop, Makert Maker)(Long)
I Open Interest(Fund / Investment trust)(Short) Varchar Open Interest(Fund / Investment trust)(Short)
J Open Interest(Fund / Investment trust)(Long) Varchar Open Interest(Fund / Investment trust)(Long)
K Open Interest(General Investor)(Short) Varchar Open Interest(General Investor)(Short)
L Open Interest(General Investor)(Long) Varchar Open Interest(General Investor)(Long)
M Open Interest(Agency)(Short) Varchar Open Interest(Agency)(Short)
N Open Interest(Agency)(Long) Varchar Open Interest(Agency)(Long)
O Open Interest(Foreign commodity futures traders)(Short) Varchar Open Interest(Foreign commodity futures traders)(Short)
P Open Interest(Foreign commodity futures traders)(Long) Varchar Open Interest(Foreign commodity futures traders)(Long)
R Settlement (Nearby Month) Varchar Settlement (Nearby Month)
* 2nd month for crude oil
S Settlement (Back Month) Varchar Settlement (Back Month)

Trading Volume by Top 10 Members

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Institutions Code Char Institutions Code("77":TOCOM)
C Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
D Product Code Varchar Product Code
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD Rolling Spot
="19" :PLATINUM ROLLING SPOT
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RUBBER
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
E Sold or Bought Char Sold or Bought
="1": Sold
="2": Bought
="3": Volume
* "1", "2": Before 31 August 2010
* "3": On and after 1 September 2010
F Rank Varchar Rank with each products
G Member code Varchar Member code
H Member Name (japanese) Varchar Member Name (japanese)
I - - -
J Trading Volume Varchar Trading Volume

Trading Status

Item Item Name Format Description
A Update Date Char Update Date (YYYYMMDD)
B Update Time Char Update Time (HHMMSS)
C Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
="21":Call Options Transaction
="22":Put Options Transaction
D Product Code Varchar Product Code
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD Rolling Spot
="19" :PLATINUM ROLLING SPOT
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RUBBER
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
E Contract Month Char Contract Month(YYYYMM)
F Strike Price Varchar Strike Price
G Code1 Varchar Refer to the following Details section.
H Code2 Varchar
I Code3 Varchar
J Message (English) Varchar  
K Message (Japanese) Varchar  

Details

Code1 Code2 Code3 Message (English)
1PO M_PRE_OPEN_NO_J-NET  
[Day Session]Pre-open
1ZA M_ZARABA  
[Day Session]Continuous
1HT A_PRE_CLOSE  
[Day Session]Closing-open
1CL A_AUCTION_CLOSING  
[Day Session]Closed
1EO NO  
Exchange Operation
1NT NO  
Next Trading Day
2PO N_PRE_OPEN  
[Night Session]Pre-open
2ZA N_ZARABA  
[Night Session]Continuous
2HT N_PRE_CLOSE  
[Night Session]Closing-open
2CL N_AUCTION_CLOSING  
[Night Session]Closed
2OL NO  
Off Line
9CB SCB  
Static Circuit Breaker
9CB DCB  
Diyamic Circuit Breaker
9SP *  
Suspended
9CB   END
Lifted(SCB/DCB)
9SP   END
Lifted(halting/pending)

Spread Market

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Spread Type Char Spread Type
="TS": Calendar
="CS":Inter-Commodity
C Product Code (Reg1) Varchar Product Code Reg1
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD Rolling Spot
="19" :PLATINUM ROLLING SPOT
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RSS3 (RUBBER)
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
D Contract Month (Reg1) Char Contract Month Reg1 (YYYYMM)
E Product Code (Reg2) Varchar Product Code (Reg2)
F Contract Month (Reg2) Char Contract Month Reg2 (YYYYMM)
G Start Price(Trade Date) Varchar Start Price (Trade Date)
H High Price(Trade Date) Varchar High Price (Trade Date)
I Low Price(Trade Date) Varchar Low Price (Trade Date)
J Final Price(Trade Date) Varchar Final Price (Trade Date)
K Trading Volume(Trade Date) Varchar Trading Volume (Trade Date)
L Start Price(Night Session) Varchar Start Price (Night Session)
M High Price(Night Session) Varchar High Price (Night Session)
N Low Price(Night Session) Varchar Low Price (Night Session)
O Final Price(Night Session) Varchar Final Price (Night Session)
P Trading Volume(Night Session) Varchar Trading Volume (Night Session)
Q Start Price(Day Session) Varchar Start Price (Day Session)
R High Price(Day Session) Varchar High Price (Day Session)
S Low Price(Day Session) Varchar Low Price (Day Session)
T Final Price(Day Session) Varchar Final Price (Day Session)
U Trading Volume(Day Session) Varchar Trading Volume (Day Session)

Spread Market (Detail)

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Spread Type Char Spread Type
="TS": Calendar
="CS":Inter-Commodity
C Product Code (Reg1) Varchar Product Code Reg1
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="16" :GOLD MINI
="17" :PLATINUM MINI
="18" :GOLD ROLLING SPOT
="19" :PLATINUM ROLLING SPOT
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RSS3 (RUBBER)
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
D Contract Month (Reg1) Char Contract Month Reg1 (YYYYMM)
E Product Code (Reg2) Varchar Product Code (Reg2)
F Contract Month (Reg2) Char Contract Month Reg2 (YYYYMM)
G Spread Price Varchar Spread Price
H Trading Volume(Trade Date) Varchar Trading Volume (Trade Date)
I Trading Volume(Night Session) Varchar Trading Volume (Night Session)
J Trading Volume(Day Session) Varchar Trading Volume (Day Session)

Night Session Reference Quotes

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Update Date Char Update Date (YYYYMMDD)
C Update Time Char Update Time (HHMMSS)
D Summer Time (DST) flag Char '': Not DST
'S': DST
E Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
F Product Code Varchar Product Code
="11" :GOLD STANDARD
="12" :SILVER
="13" :PLATINUM STANDARD
="14" :PALLADIUM
="21" :ALUMINUM
="31" :GASOLINE
="32" :KEROSENE
="33" :DUBAI CRUDE OIL
="34" :GAS OIL
="37" :CHUKYO GASOLINE
="38" :CHUKYO KEROSENE
="41" :Cash-settled BARGE GASOLINE (From May 8, 2017)
="42" :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
="43" :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
="44" :Cash-settled LORRY GASOLINE (From May 8, 2017)
="45" :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
="46" :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
="81" :RSS3 (RUBBER)
="201":Corn
="202":Soybeans
="204":Azuki Beans
="211":Raw Sugar
G Contract Month Char Contract Month(YYYYMM)
H Last Settlement price Varchar Last Day Settlement price
I Night Session Reference Quotes Varchar Night Session Reference Quotes

Theoretical spot price

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Update Date Char Update Date (YYYYMMDD)
C Update Time Char Update Time (HHMMSS)
D Product Code Varchar Product Code
="11" :GOLD
="13" :PLATINUM
E Theoretical spot price Varchar Theoretical spot price

Option Index

Item Item Name Format Description
A Update Date Char Update Date (YYYYMMDD)
B Update Time Char Update Time (HHMMSS)
C Type Char Type
="21":Call Options Transaction
="22":Put Options Transaction
D Product Code Varchar Product Code
"11":GOLD
E Contract Month Char Contract Month(YYYYMM)
F Strike Price Varchar Strike Price
G At the money flag Char "*": At the money
H interest rate Varchar Empty (no value)
I IV Varchar IV
J Delta Varchar Delta Value
K - Varchar -
L - Varchar -
M - Varchar -

Volatility

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Type Char Type
="11":Physically Delivered Futures Transaction
="12":Cash-settled Futures Transaction
C Product Code Varchar Product Code
Here
D Last Settlement price (Back Month) Varchar Last Settlement price (Back Month)
E Volatility Varchar Volatility Value (Historical Volatility)

Gasoline Spot Prices

Item Item Name Format Description
A Trade Date Char Trade Date (YYYYMMDD)
B Barge Gasoline Today's Settlement Price Varchar Barge Gasoline Today's Settlement Price
C Barge Gasoline Monthly Average Varchar Barge Gasoline Monthly Average
D Lorry Gasoline Today's Settlement Price Varchar Lorry Gasoline Today's Settlement Price
E Lorry Gasoline Monthly Average Varchar Lorry Gasoline Monthly Average

Product Name

Product Name and number
11: GOLD
12: SILVER
13: PLATINUM
14: PALLADIUM
16: GOLD MINI
17: PLATINUM MINI
18: GOLD ROLLING SPOT
19: PLATINUM ROLLING SPOT
31: GASOLINE
32: KEROSENE
33: CRUDE OIL
34: GAS OIL
37: CHUKYO GASOLINE
38: CHUKYO KEROSENE
41 :Cash-settled BARGE GASOLINE (From May 8, 2017)
42 :Platts Cash-settled BARGE KEROSENE (From May 8, 2017)
43 :Platts Cash-settled BARGE GAS OIL (From May 8, 2017)
44 :Cash-settled LORRY GASOLINE (From May 8, 2017)
45 :Platts Cash-settled LORRY KEROSENE (From May 8, 2017)
46 :Platts Cash-settled LORRY GAS OIL (From May 8, 2017)
81: RSS3 (RUBBER)
100: Nikkei-TOCOM Commodity Index
101: Nikkei-TOCOM Nearby Month Commodity Index
103: Nikkei-TOCOM Industrial Commodity Index
110: Nikkei-TOCOM Precious Metals Index
111: Nikkei-TOCOM Gold Index
112: Nikkei-TOCOM Silver Index
113: Nikkei-TOCOM Platinum Index
114: Nikkei-TOCOM Palladium Index
130: Nikkei-TOCOM Oil Index
131: Nikkei-TOCOM Gasoline Index
132: Nikkei-TOCOM Kerosene Index
133: Nikkei-TOCOM Crude Oil Index
181: Nikkei-TOCOM Rubber Index
201: Corn
202: Soybeans
204: Azuki Beans
300: Nikkei-TOCOM Agricultural Product & Sugar Index
301: Nikkei-TOCOM Corn Index
302: Nikkei-TOCOM Soybean Index
304: Nikkei-TOCOM Azuki Index
501: Nikkei-TOCOM Leveraged Commodity Index
502: Nikkei-TOCOM Leveraged Nearby Month Commodity Index
503: Nikkei-TOCOM Leveraged Industrial Commodity Index
504: Nikkei-TOCOM Leveraged Precious Metals Index
505: Nikkei-TOCOM Leveraged Oil Index
506: Nikkei-TOCOM Leveraged Agricultural Product & Sugar Index
508: Nikkei-TOCOM Leveraged Gold Index
509: Nikkei-TOCOM Leveraged Silver Index
510: Nikkei-TOCOM Leveraged Platinum Index
511: Nikkei-TOCOM Leveraged Palladium Index
512: Nikkei-TOCOM Leveraged Crude Oil Index
513: Nikkei-TOCOM Leveraged Gasoline Index
514: Nikkei-TOCOM Leveraged Kerosene Index
515: Nikkei-TOCOM Leveraged Corn Index
516: Nikkei-TOCOM Leveraged Soybean Index
517: Nikkei-TOCOM Leveraged Azuki Index
518: Nikkei-TOCOM Leveraged Rubber (RSS3) Index
551: Nikkei-TOCOM Inverse Commodity Index
552: Nikkei-TOCOM Inverse Nearby Month Commodity Index
553: Nikkei-TOCOM Inverse Industrial Commodity Index
554: Nikkei-TOCOM Inverse Precious Metals Index
555: Nikkei-TOCOM Inverse Oil Index
556: Nikkei-TOCOM Inverse Agricultural Product & Sugar Index
558: Nikkei-TOCOM Inverse Gold Index
559: Nikkei-TOCOM Inverse Silver Index
560: Nikkei-TOCOM Inverse Platinum Index
561: Nikkei-TOCOM Inverse Palladium Index
562: Nikkei-TOCOM Inverse Crude Oil Index
563: Nikkei-TOCOM Inverse Gasoline Index
564: Nikkei-TOCOM Inverse Kerosene Index
565: Nikkei-TOCOM Inverse Corn Index
566: Nikkei-TOCOM Inverse Soybean Index
567: Nikkei-TOCOM Inverse Azuki Index
568: Nikkei-TOCOM Inverse Rubber (RSS3) Index
TOP