
Dataset Name: edi_reference_data
Group: reference_data
Vendor: EDI
Data Starts at: 2020-08-17 00:00:00
Symbol Set: Global Equities
Asset Class: Equity
Data Update Time(s): 23:30 EST
Data Update Frequency: day
EDI reference data for trading securities. Includes cross references to other identifiers.
Data Contained in this Dataset
Column | Type | Description |
---|---|---|
_seq | uint | Internal sequence number used to keep data rows in order |
timestamp | string | Timestamp of the Data - America/New York Time. |
muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. |
symbol | string | Trading Symbol or Ticker |
lstuniqueid | int64 | Unique Listing Record ID - Concatenation of a sequence number and the WCA ScexhID. The sequence number will usually be 1 unless additional listings exists for the same security in the same market, usually as a result of secondary trading currencies. |
scexhid | int | Unique global level Listing ID |
lstactioncd | string | Record Action Status Code |
lstaction | string | Record Action Status |
lstchangedt | string | Record Last Changed Date and Time |
listcreatedt | string | Listing Creation Date |
listsourceflag | string | Indicates if the listing level data in the record is (M)ain or (S)econdary. |
listsource | string | List Source |
globalstatuscd | string | Global Status Code. Indicates the global listing activity status of a security. |
globalstatus | string | Global Status Value |
issid | int | Unique global level Issuer ID (can be used to link all securities of a company togther) |
issuername | string | Name of Issuer |
secid | int | Unique global level Security ID (can be used to link all multiple listings together |
securitydescription | string | Security Description |
parvalue | double | Security Parvalue |
parvaluecurencd | string | Parvalue Currency Code - ISO 4217 |
parvaluecuren | string | Parvalue Currency |
isin | string | International Securities Identification Number. An international code which identifies a securities issue |
uscode | string | USCode (global level identifier) |
sectycd | string | Type of Equity Instrument Code |
secty | string | Security Type |
primaryexchgcd | string | Exchange code for the primary listing (empty if unknown) |
primaryexchg | string | Primary Exchange |
listcntrycd | string | Listing Country Code - ISO 3166-1 |
listcntry | string | Listing Country |
registercntrycd | string | Register Country Code - ISO 3166-1 |
registercntry | string | Register Country |
tradingcurencd | string | Trading Currency Code - ISO 4217 |
tradingcuren | string | Trading Currency |
multicurenflag | string | Set to (T)rue if there is currently more than one listing in the market, otherwise set to (F)alse. |
multicuren | string | Multi-Currency |
bbgcompid | string | Bloomberg Composite Global ID |
bbgcompticker | string | Bloomberg Composite Ticker |
figi | string | FIGI ID. The FIGI code (https://www.openfigi.com) that identifies the stock across related exchanges in the same country. |
figiticker | string | FIGI ID. The FIGI code (https://www.openfigi.com) that identifies the stock across related exchanges in the same country. |
sedol | string | Sedol for underlying constituent. Stock Exchange Daily Official List identifier assigned by the London Stock Exchange, requires SEDOL license |
sedoldefunct | string | Indicates a defunct SEDOL |
sedoldefunctlup | string | Defunct Sedol |
sedolmic | string | Main Operational Market Identifier code indicated by the London Stock Exchange - ISO 10383 with a small number of non standard codes. |
sedolmiclup | string | SEDOL Market |
exchgcd | string | EDI maintained Exchange code. Equivalent to the MIC code but necessary as MIC might not be available in a timely fashion. |
exchg | string | Exchange or Market place name |
operationalmic | string | Operational Market Identification Code - ISO 10383 |
operationalmiclup | string | Operational Exchange |
lotsize | int | Lot Size. Indicates the minimum number of shares that can be aquired in one transaction. |
segmentmicname | string | Market Segment Name. Not the ISO 10383 MICSEG lookup name but used when no Segment MIC is available. |
segmentmic | string | Market Identification Code - ISO 10383 |
segmentmiclup | string | Segment Market |
localcode | string | Local Code. Usually unique at Market Level but there are exceptions to this rule. Either an alpha string, or a number. |
localdot | string | Local Code but with Market formatting using dot separator. Only currently reformatted for NYSE, otherwise the LocalDot value equals the Localcode value. |
localslash | string | Local Code but with Market formatting using a forward slash separator. Only currently reformatted for NYSE, otherwise LocalSlash value equals Localcode value. |
localspace | string | Local Code but with Market formatting using space separator. Only currently reformatted for NYSE, otherwise LocalSpace value equals Localcode value. |
liststatuscd | string | Listing Status Code. Indicates the listing activity status at market level |
liststatus | string | Indicates whether a security is Listed on an Exchange or Unlisted Indicates Exchange Listing Status |
listdt | string | Listing Date |
delistdt | string | Delisting Date |
cntryofincorpcd | string | Country of Incorporation Code of the Issuer - ISO 3166-1 |
cntryofincorp | string | Country of Incorporation |
sic | string | Standard Industrial Classification Code |
cik | string | Central Index Key |
gics | string | Global Industry Standard Classification |
lei | string | Legal Entity Identifier |
naics | string | North American Industrial Classification System |
indusid | string | Proprietary Industry Sector Code |
indus | string | Industry |
figiglobalshareclassid | string | Complementary FIGI Share Class Identification Code |
cfi | string | Classification of Financial Instruments (CFI) Code. A 6 character instrument classification code. |
cic | string | Complementary Identification Code |
fisn | string | Financial Instrument Short Name |
structcd | string | Structured Certificate of Deposit (eg CEF, REIT, MLP, ETF, VCT, SCT, BT, ARF, ETC, CCI, ROYTRT, ETN, ET, PWR&PIPE, ISF) |
struct | string | Structured Certificate of Deposit |
voting | string | Voting or non Voting Rights Code |
votinglup | string | Voting or non Voting Rights value |
votepersec | double | Number of Votes per Security |
sharesoutstanding | string | Shares outstanding refer to a company's stock currently held by all its shareholders, including share blocks held by institutional investors and restricted shares owned by the company’s officers and insiders. |
sharesoutstandingdt | string | Effective Date for current Shares Outstanding figure |
unlistedclassessos | string | Most recent known Shares Outstanding figure for Unlisted Share Classes |
unlistedclassessosdt | string | Effective Date for Unlisted Share Classes Outstanding figure |