Announce something here

edi_reference_data

edi_reference_data by EDI

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


Important Dataset Notes

This dataset is not available for direct online purchase. Please contact sales directly at sales@CloudQuant.com. The data is available through our normal sales department who can provide you with current pricing and a quote for accessing this valuable dataset. This may be due to a number of reasons such as dataset intended use, size of the company (or investment fund) using the dataset, or for simple legal requirements that CloudQuant needs to ensure are in place prior to licensing the dataset to you.