Dataset Name: symbol_directory
Group: reference_data
Vendor: CloudQuant
Data Starts at: 2011-01-03 00:00:00
Symbol Set: US Equities
Asset Class: Equity
Data Update Time(s): 11:00 PM EST
Data Update Frequency: day
Listing of over 30k symbols from Equities to Indices to Futures (OTCBB, CME, NYSE, NasdaqGS, NYSEArca, NasdaqCM, NasdaqGM, NYMEX, BATS, CBOT, AMEX, COMEX, Indices, CBOEFN)
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. |
| AuditLevel | int | One value 4294967295 |
| CaveatEmptor | string | Caveat Emptor (Buyer Beware Y (1%), N (50%) or Blank (49%) ) |
| Class | string | Class (Regular (60%), Index (10%), ETF (9%), ADR (7%), Future (5%), Warrants, Units, Preferred|Series, Preferred, QualificationException, Warrants|Rights, Rights, ETN, Miscellaneous, Series, Nonvoting, Convertible, Foreign, BeneficialInterest, Warrants|Se |
| Cusip | string | Committee on Uniform Security Identification Procedures identifier owned by American Bankers Association operated by Standard and Poor's, requires CUSIP license. |
| ETF | string | Symbol is and ETF (Y or N) |
| Exchange | string | Exchange Identifier for the data source. This may contain the Market Identifier Code (MIC), or and exchange nmemonic (eg. NYSE, TSE, ASX...) or a dataset specific code provided by the data vendor. |
| LastQuote | string | String Time of last quote recorded for the symbol |
| LastUpdated | string | String Time of last update to the symbol data |
| LastUpdator | string | Always 5549 |
| LineSymbol | string | Original Symbol Name (eg ABRpA which would be translated to ABR-A) |
| MarketTier | uint | Market Tier (eg 0 (50%), 1, 2, 5, 6, 10, 20 (24%) , 21, 22 (9%), 30 (12%), 40) |
| Message | string | All entries appear to say 'Normal Archive' |
| NasdaqSymbol | string | Nasdaq Symbol (eg AAC= which would be translated to AAC.U, or CELG^ translated to CELG.R) |
| RoundLotSize | string | Default Round Lot Size (normally 100, sometimes 1 or 10) |
| SecurityName | string | Security Full Name |
| SymbolBase | string | Base Symbol |
| UpdateTime | string | Most Recent update time/date - STRING |
| symbol | string | Trading Symbol or Ticker |