Announce something here

symbol_directory

symbol_directory by CloudQuant

Regular price
$250.00 USD
Sale price
$250.00 USD
Regular price
Sold out
Unit price
per 






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