2
Chicago Booth

Location: Documentation » US Stock and Indices Databases » ts_print

 

ts_print Daily Data Items

 

Header Item ID Subno Format Entity Types
Ask Adjusted, End of Period
Adjask adjask 0 11.5 list
Ask Adjusted, Last Available Nonmissing
Adjaskprev adjask 1 11.5 list
Ask, End of Period
Askprev ask 0 11.5 list
Ask, Last Available Nonmissing
Ask ask 1 11.5 list
Askhi Adjusted, Maximum in Period
Adjaskhi adjaskhi 0 11.5 list
Askhi, Maximum in Period
Askhi askhi 0 11.5 list
Associated Index Returns
Indtret indtret INDNO 11.6 list
Associated Index Returns Without Dividends
Indaret indaret INDNO 11.6 list
Associated Index Returns Without Dividends, Cumulative
Cumindaret cumindaret INDNO 11.6 list
Associated Index Returns on Income
Indiret indiret INDNO 11.6 list
Associated Index Returns on Income, Cumulative
Cumindiret cumindiret INDNO 11.6 list
Associated Index Returns, Cumulative
Cumindtret cumindtret INDNO 11.6 list
Associated Portfolios Returns
Porttret porttret PORTID 11.6 list
Associated Portfolios Returns Without Dividends
Portaret portaret PORTID 11.6 list
Associated Portfolios Returns on Income
Portiret portiret PORTID 11.6 list
Bid Adjusted, End of Period
Adjbidprev adjbid 0 11.5 list
Bid Adjusted, Last Available Nonmissing
Adjbid adjbid 1 11.5 list
Bid, End of Period
Bid bid 0 11.5 list
Bid, Last Available Nonmissing
Bidprev bid 1 11.5 list
Bidlo Adjusted, Minimum in Period
Adjbidlo adjbidlo 0 11.5 list
Bidlo, Minimum in Period
Bidlo bidlo 0 11.5 list
CUSIP, End of Period
NCUSIP ncusip 0 8.8 list
CUSIP, End of Previous Period
NCUSIPE ncusip 1 8.8 list
CUSIP, Header
CUSIP cusip 0 8.8 list
CUSIP, Most Recent
NCUSIPL ncusip 2 8.8 list
Capitalization, End of Period
TCap tcap 0 15.2l list, index
Capitalization, End of Previous Period
Cape cap 1 15.2l list, index
Company Name, End of Period
Company Name comnam 0 32.32 list
Company Name, End of Previous Period
Effective Name comnam 1 32.32 list
Company Name, Most Recent
Last Company Name comnam 2 32.32 list
Cumulative Factor to Adjust Prices Over a Date Range
Cumfacpr cumfacpr 0 11.6 list
Cumulative Factor to Adjust Shares/Volume Over a Date Range
Cumfacshr cumfacshr 0 11.6 list
Date
Caldt caldt 0 9 list, index
Date - YYYYMMDD Trading Date (partial period data)
Altdt altdt 0 9 list
Dividend Amount in Period, Adjusted
Adjdiv adjdiv 0 11.5 list
Dividend Amount in Period, Beginning Basis
Divamt divamt 0 11.5 list
Dividend Amount in Period, Ordinary, Adjusted
Adjodiv adjodiv 0 11.5 list
Dividend Amount in Period, Ordinary, Beginning Basis
Odivamt odivamt 0 11.5 list
Entity Begin Date Range or Event Date
Date1 date1 0 9 list
Entity End Date Range
Date2 date2 0 9 list
Excess Returns Without Dividends vs. Associated Portfolios
Portxsaret portxsaret PORTID 11.6 list
Excess Returns Without Dividends vs. Associated Portfolios, Cumulative
Cumxsparet cumxsparet PORTID 11.6 list
Excess Returns Without Dividends vs. Index Series
Xsaret xsaret INDNO 11.6 list
Excess Returns Without Dividends vs. Index Series, Cumulative
Cumxsaret cumxsaret INDNO 11.6 list
Excess Returns on Income vs. Associated Portfolios
Portxsiret portxsiret PORTID 11.6 list
Excess Returns on Income vs. Associated Portfolios, Cumulative
Cumxspiret cumxspiret PORTID 11.6 list
Excess Returns on Income vs. Index Series
Xsiret xsiret INDNO 11.6 list
Excess Returns on Income vs. Index Series, Cumulative
Cumxsiret cumxsiret INDNO 11.6 list
Excess Returns on Trade-only Prices vs. Associated Portfolios
Portxstoret portxstoret PORTID 11.6 list
Excess Returns on Trade-only Prices vs. Index Series
Xstoret xstoret INDNO 11.6 list
Excess Returns on Trade-only Prices vs. Index Series, Cumulative
Cumxstoret cumxstoret INDNO 11.6 list
Excess Returns vs. Associated Portfolios
Portxstret portxstret PORTID 11.6 list
Excess Returns vs. Associated Portfolios, Cumulative
Cumxsptret cumxsptret PORTID 11.6 list
Excess Returns vs. Index Series
Xstret xstret INDNO 11.6 list
Excess Returns vs. Index Series, Cumulative
Cumxstret cumxstret INDNO 11.6 list
Exchange Code, End of Period
EX exchcd 0 2 list
Exchange Code, End of Previous Period
EXE exchcd 1 2 list
Exchange Code, Most Recent
EXL exchcd 2 2 list
Factor to Adjust Price in Period
Facpr facpr 0 11.6 list
Group Flag of Associated Index, End of Period
SPInd grpflg 16 8 list
Group Flag of Associated Index, End of Previous Period
ESPInd egrpflg 16 8 list
Group Flag of Associated Index, Last Flag, All Periods
LSPInd lgrpflg 16 8 list
Highest Close
High high 0 11.5 list
Index Count Total
Totcnt cnt 0 6 list, index, port
Index Count Used
Usdcnt cnt 1 6 list, index, port
Index Level of Returns
Tind tind 0 11.2 list, index
Index Level of Returns Without Dividends
Aind aind 0 11.2 list, index
Index Level of Returns on Income
Iind iind 0 11.2 list, index
Lowest Close
Low low 0 11.5 list
Member Portfolio Returns Without Dividends, Cumulative
Cumparet cumparet PORTID 11.6 list
Member Portfolio Returns on Income, Cumulative
Cumpiret cumpiret PORTID 11.6 list
Member Portfolio Returns, Cumulative
Cumptret cumptret PORTID 11.6 list
NAICs, End of Period
Naics snaics 0 7.7 list
NAICs, End of Previous Period
Naicse snaics 1 7.7 list
NAICs, Most Recent
Naicsl snaics 2 7.7 list
NASDAQ Company Number
Compno compno 0 8 list
NASDAQ Index Code, End of Period
Nsdinx nsdinx 0 2 list
NASDAQ Index Code, End of Previous Period
Nsdinxe nsdinx 1 2 list
NASDAQ Index Code, Most Recent
Nsdinxl nsdinx 2 2 list
NASDAQ Market Makers, End of Period
Mmcnt mmcnt 0 4 list
NASDAQ Market Makers, End of Previous Period
Mmcnte mmcnt 1 4 list
NASDAQ Market Makers, Most Recent
Mmcntl mmcnt 2 4 list
NASDAQ National Market Indicator, End of Period
Nmsind nmsind 0 2 list
NASDAQ National Market Indicator, End of Previous Period
Nmsinde nmsind 1 2 list
NASDAQ National Market Indicator, Most Recent
Nmsindl nmsind 2 2 list
NASDAQ Status Code, End of Period
Trtscd trtscd 0 2 list
NASDAQ Status Code, End of Previous Period
Trtscde trtscd 1 2 list
NASDAQ Status Code, Most Recent
Trtscdl trtscd 2 2 list
Number of Trades
Numtrd numtrd 0 9 list
PERMCO/INDCO
PERMCO permco 0 8 list, index
PERMNO/INDNO
PERMNO permno 0 8 list, index
Portfolio Assignment
Port port PORTID 4 list
Portfolio Statistic
Portstat portstat PORTID 15.2l list
Price Adjusted, End of Period
Adjprcprev adjprc 0 11.5 list
Price Adjusted, Last Available Nonmissing
Adjprc adjprc 1 11.5 list
Price, End of Period
Prc prc 0 11.5 list
Price, Last Available Nonmissing
Prcprev prc 1 11.5 list
Price, Open
OpenPrc openprc 0 11.5 list
Price, Open, Adjusted
AdjOpenPrc adjopenprc 0 11.5 list
Primary Exchange, End of Period
Primexch primexch 0 list
Primary Exchange, End of Previous Period
Primexche primexch 1 list
Primary Exchange, Most Recent
Primexchl primexch 2 list
Returns
Ret ret 0 11.6 list, index, port
Returns Without Dividends
Retx retx 0 11.6 list, index
Returns Without Dividends, Cumulative
Cumaret cumaret 0 11.6 list, index
Returns Without Dividends, Trade-only Prices
Toretx toretx 0 11.6 list
Returns on Income
Reti reti 0 11.6 list, index
Returns on Income, Cumulative
Cumiret cumiret 0 11.6 list, index
Returns on Trade-only Prices
Toret toret 0 11.6 list
Returns, Cumulative
Cumtret cumtret 0 11.6 list, index
SIC Code, End of Period
SIC siccd 0 4 list
SIC Code, End of Previous Period
SICE siccd 1 4 list
SIC Code, Most Recent
SICL siccd 2 4 list
Security Status, End of Period
Secstat secstat 0 list
Security Status, End of Previous Period
Secstate secstat 1 list
Security Status, Most Recent
Secstatl secstat 2 list
Share Class, End of Period
CL shrcls 0 1.1 list
Share Class, End of Previous Period
CLE shrcls 1 1.1 list
Share Class, Most Recent
CLL shrcls 2 1.1 list
Share Type Code, End of Period
SC shrcd 0 3 list
Share Type Code, End of Previous Period
SCE shrcd 1 3 list
Share Type Code, Most Recent
SCL shrcd 2 3 list
Shares Outstanding
Shr shr 0 9 list
Shares Outstanding, Adjusted
Adjshr adjshr 0 9 list
Shares Outstanding, Adjusted for Rights
Adjshrxr adjshr 1 9 list
Shares Outstanding, Unadjusted for Rights
Shrxr shr 1 9 list
Ticker, End of Period
Ticker ticker 0 5.5 list
Ticker, End of Previous Period
Tickere ticker 1 5.5 list
Ticker, Most Recent
Tickerl ticker 2 5.5 list
Trade-only Price, Adjusted, End of Period
Adjtprcprev adjtprc 0 11.5 list
Trade-only Price, Adjusted, Last Available Nonmissing
Adjtprc adjtprc 1 11.5 list
Trade-only Price, End of Period
Trpc tprc 0 11.5 list
Trade-only Price, Last Available Nonmissing
Tprcprev tprc 1 11.5 list
Trading Status, End of Period
Trdstat trdstat 0 list
Trading Status, End of Previous Period
Trdstate trdstat 1 list
Trading Status, Most Recent
Trdstatl trdstat 2 list
Trading Ticker Symbol, End of Period
Symbol tsymbol 0 10.1 list
Trading Ticker Symbol, End of Previous Period
Symbole tsymbol 1 10.1 list
Trading Ticker Symbol, Most Recent
Symboll tsymbol 2 10.1 list
Volume, Average
Volavg volavg 0 9 list
Volume, Median
Volmed volmed 0 9 list
Volume, Total
Vol vol 0 13 list
Volume, Total Adjusted
Adjvol adjvol 0 11 list
Weight Summation for the Members of a Portfolio
Weight weight 0 14.2l list, port