API Access
Access dataset files directly from scripts, code, or AI agents.
Browse dataset files
API Access
Access dataset files directly from scripts, code, or AI agents.
Each file has a stable URL (r-link) that you can use directly in scripts, apps, or AI agents. These URLs are permanent and safe to hardcode.
Start with these files — they give you everything you need to understand and access the dataset.
- 1. Fetch datapackage.json to inspect schema and resources
- 2. Download data resources listed in datapackage.json
- 3. Read README.md for full context
Data Views
Data Files
Explore with AIdata
| Field | Type | Format | Description |
|---|---|---|---|
| Date | date | default | First day of each month in ISO 8601 format (YYYY-MM-DD). All dates are set to the 1st of the month. |
| SP500 | number | Level ('price') of the S&P 500 index | |
| Dividend | number | Dividend per share (monthly, annualised) | |
| Earnings | number | Earnings per share (monthly, annualised) | |
| Consumer Price Index | number | Consumer Price Index (CPI-U); pre-1913 spliced from Warren-Pearson price index | |
| Long Interest Rate | number | 10 year interest rate (gov bonds) | |
| Real Price | number | Inflation-adjusted S&P 500 price in January 2000 dollars | |
| Real Dividend | number | Inflation-adjusted dividend per share in January 2000 dollars | |
| Real Earnings | number | Inflation-adjusted earnings per share in January 2000 dollars | |
| PE10 | number | Cyclically Adjusted Price Earnings Ratio P/E10 or CAPE. Values are 0.0 for 1871-01 through 1880-12 (the first 120 months) because computing PE10 requires 10 years of trailing real earnings history. Values are also 0.0 for FRED-only extension rows beyond the Shiller dataset. |
Download
Download CSVAbout
- Monthly S&P 500 index data from 1871 to present, including price, dividend, earnings, CPI, interest rate, inflation-adjusted values, and the Shiller CAPE (PE10) ratio. Recent months beyond the Shiller dataset are extended with FRED price data; for those rows only SP500 is populated and all other fields are 0.
- Last updated
- 5 May 2026
- Total rows
- ...
- Format
- CSV
- File size
- 124 kB
About this dataset
S&P 500 index data including level, dividend, earnings and P/E ratio on a monthly basis since 1871. The S&P 500 (Standard and Poor's 500) is a free-float, capitalization-weighted index of the top 500 publicly listed stocks in the US (top 500 by market cap).
Data
The data provided here is a tidied and CSV'd version of that collected and
prepared by the Economist Robert Shiller and made available on his
website. The Shiller dataset currently extends through 2023-06.
Months after that are extended automatically with S&P 500 price data from the
Federal Reserve Bank of St. Louis (FRED). Because FRED only publishes
the index price, those rows contain only the SP500 value; Dividend,
Earnings, Consumer Price Index, Long Interest Rate, Real Price,
Real Dividend, Real Earnings, and PE10 are 0 for all rows from
2023-07 onward.
Additionally, PE10 (the Shiller CAPE ratio) is 0 for the first ~10 years of the
dataset (1871-01 through 1880-12) because computing it requires 10 years of
trailing real earnings history, which is not yet available at the start of the series.
Source Data Construction
Details of the data construction as described on Shiller's website (and slightly reformatted):
Stock market data used in my book, Irrational Exuberance [Princeton University Press 2000, Broadway Books 2001, 2nd ed., 2005] are available for download, Excel file (xls). This data set consists of monthly stock price, dividends, and earnings data and the consumer price index (to allow conversion to real values), all starting January 1871.
The price, dividend, and earnings series are from the same sources as described in Chapter 26 of my earlier book (Market Volatility [Cambridge, MA: MIT Press, 1989]), although now I use monthly data, rather than annual data. Monthly dividend and earnings data are computed from the S&P four-quarter totals for the quarter since 1926, with linear interpolation to monthly figures. Dividend and earnings data before 1926 are from Cowles and associates (Common Stock Indexes, 2nd ed. [Bloomington, Ind.: Principia Press, 1939]), interpolated from annual data.
Stock price data are monthly averages of daily closing prices through January 2000, the last month available as this book goes to press. The CPI-U (Consumer Price Index-All Urban Consumers) published by the U.S. Bureau of Labor Statistics begins in 1913; for years before 1913 1 spliced to the CPI Warren and Pearson's price index, by multiplying it by the ratio of the indexes in January 1913. December 1999 and January 2000 values for the CPI-U are extrapolated. See George F. Warren and Frank A. Pearson, Gold and Prices (New York: John Wiley and Sons, 1935). Data are from their Table 1, pp. 11–14.
For the Plots, I have multiplied the inflation-corrected series by a constant so that their value in january 2000 equals their nominal value, i.e., so that all prices are effectively in January 2000 dollars.
License
No exact statement on license of original data but given size and factual nature believe one can assume these are public domain (and I, the maintainer, explicitly license under the ODC Public Domain Dedication and License (PDDL)).
That said, it would be natural to credit Robert Shiller for preparing this dataset and kindly making it publicly available.