TOPIX Indices Schemas#
TOPIX Indices are a series of stock market indices for the Tokyo Stock Exchange, including the TOPIX, which tracks the performance of all domestic companies in the First Section of the TSE.
TOPIX_IDX#
Database includes the following Tables:
IDX - Index values
STAT - Static data, e.g. ISIN, description, security type
TOPIX_IDX - IDX#
Index values
Field |
Data Type |
Description |
|---|---|---|
SYMBOL_NAME |
string |
Symbol Name (Exchange Symbol for Equities & ETFs, and Starting with Exchange Product Code for Derivative Markets followed by expiry and strike as appropriate) |
TIMESTAMP |
nsectime |
Event Timestamp (typically at a nano-second resolution) |
EXCH_TIME |
nsectime |
Event timestamp, as provided by the exchange. For electronic trading this refers to the matching engine timestamp |
PRICE |
double |
TRD: Trade price, IDX: Index value, IND: Indicative price, PRL: Price point to which the depth entry relates, PRL_FULL: Order price, FIXING: Fixing price, RFC: Price associated with a Request for Cross |
OMDSEQ |
uint |
Sequence number allowing ticks of different types at the same timestamp to be sorted into the correct chronological order. e.g. if a trade and a quote have the same timestamp, the one with the lower value of OMDSEQ arrived first. |
TOPIX_IDX - STAT#
Static data, e.g. ISIN, description, security type
Field |
Data Type |
Description |
|---|---|---|
SYMBOL_NAME |
string |
Symbol Name (Exchange Symbol for Equities & ETFs, and Starting with Exchange Product Code for Derivative Markets followed by expiry and strike as appropriate) |
TIMESTAMP |
nsectime |
Event Timestamp (typically at a nano-second resolution) |
NAME |
string[120] |
Description of the instrument |
ISIN |
string[12] |
ISIN code |
SEDOL |
string[7] |
SEDOL code |
EXCH_SYMBOL |
string[25] |
Ticker symbol specified by the exchange |
RTS_SYMBOL |
string[32] |
Ticker symbol used by ICE Data Services |
BBG_TICKER |
string[40] |
Bloomberg ticker symbol |
FIGI |
string[12] |
Financial Instrument Global Identifier, identifying an individual instrument traded on a specific venue |
MIC |
string[4] |
Market Identifier Code (MIC, ISO 10383) identifying the market on which the instrument is traded |
OPERATING_MIC |
string[4] |
Market Identifier Code (MIC, ISO 10383) of the exchange that operates the market on which the instrument is traded |
SEC_TYPE |
string[20] |
Security type, e.g. Equity, ETF, Future |
CURRENCY |
string[3] |
Currency in which the instrument’s price is expressed (or nominal currency for bonds traded as a % of nominal). |
OMDSEQ |
uint |
Sequence number allowing ticks of different types at the same timestamp to be sorted into the correct chronological order. e.g. if a trade and a quote have the same timestamp, the one with the lower value of OMDSEQ arrived first. |