Instrument Symbology Cross Reference from OID Schemas#
Instrument Symbology Cross Reference from OID to Available Symbologies
OQD_XOID#
Database includes the following Tables:
XREF - Symbology Mapping
OQD_XOID - XREF#
Symbology Mapping
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) |
END_DATE |
msectime |
Calendar Event End Date, or Last Valid Date |
EXCH |
string[10] |
Exchange from which the update originates (Country Code + [MIC or PRIM for Primary, or COMP for Composite]) |
ID_TYPE |
string[5] |
XREF |
ID_SYMBOL |
string[32] |
Symbology Code |
DELETED_TIME |
msectime |
Internal OneTick field. Usually null unless hidden ticks are requested (e.g. SHOW_HIDDEN_TICKS). |
TICK_STATUS |
int |
Internal OneTick field. Always 0 unless hidden ticks are requested (e.g. SHOW_HIDDEN_TICKS). |