Contact Sales Team

edi_reference_data by EDI

Name: edi_reference_data
Brand: EDI
SKU: EDI-00104
Price: 9999.99 USD
Availability: InStock

Category: main_tax_category , reference_data ,

Product Type: reference_data

Region: APAC , Europe , Global , Middle East , North America , US ,

Industry: Consumer Discretionary , Consumer Staples , Energy , Financials , Health Care , Industrials , Information Technology , Materials , Real Estate , Telecommunication Services , Utilities ,

Asset Classes: Equity ,

Data Frequency: day

Quantity must be 1 or more

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.