Rice Business Stock Market Data Portal

This data is licensed by Rice Business from Nasdaq Data Link . It covers all NYSE and Nasdaq listed common stocks beginning in 2000.

Here are some sample prompts you could use to get started, but feel free to just ask for whatever data you want:

• What are the industry names that I can filter on?
• I want the history of Apple's adjusted closing price beginning in 2020.
• I want all insider trades for Tesla for the past two years.
• What is the current median PE ratio of mid-cap oil and gas stocks?
• I want the history of DuPont ratios for all biotech stocks for the past five years.
• What was Tesla's ROE for each of the past 12 quarters on a trailing 4-quarters basis?

For large downloads (for example, if you want to download an entire table, which is more than 30 million rows for some tables), this page might time out. A better way to download large amounts of data is to use the Rice Business Data Python Notebook The notebook executes in Google Colab, so no setup is required. You only need to paste in your access token and click the "Run" buttons.

You might also be interested in learn-investments.rice-business.org

Detailed descriptions of the database tables and the variables in each table can be found on our Table Descriptions page. Here are some general issues to be aware of:

• To filter on a categorical variable, the exact values of the categorical variable must be determined. It can help to ask the chatbot to "list the possible values of variable x in table y".
• The SEP table contains three types of prices. The open, high, low, close and volume variables are split adjusted. The closeunadj variable is not split adjusted. The closeadj variable is both split and dividend adjusted (like yfinance), so total returns including dividends can be computed (to a sufficient degree of precision) as percent changes in closeadj.
• Financial statement data is available in the SF1 table either as reported or including restatements. Data from both 10Ks and 10Qs is available. As reported 10K data is selected by filtering on dimension='ARY'. As reported 10Q data is selected by filtering on dimension='ARQ'. The most recent data including restatements is selected by filtering on dimension='MRY' or dimension='MRQ'. Data is also available quarter by quarter on a trailing four quarters basis as dimension='ART' or dimension='MRT'.
• The reportperiod variable in the SF1 table is the end of the fiscal period. The datekey variable is the date at which the statement was filed (for ARx data). There are also fiscalperiod and calendardate variables (see the Table Descriptions page).