API AccessAccess dataset files directly from scripts, code, or AI agents.
Browse dataset files
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 Previews
scatter-data
Schema
| name | type | description |
|---|---|---|
| company | string | |
| sector | string | |
| market_cap_b | number | Market cap in USD billions |
| pe_ratio | number | Price/Earnings ratio |
constituents
Schema
| name | type | description |
|---|---|---|
| Symbol | string | |
| Name | string | |
| Sector | string |
constituents-financials
Schema
| name | type | description |
|---|---|---|
| Symbol | string | |
| Name | string | |
| Sector | string | |
| Price | number | |
| Price/Earnings | number | |
| Dividend Yield | number | |
| Earnings/Share | number | |
| 52 Week Low | number | |
| 52 Week High | number | |
| Market Cap | number | |
| EBITDA | number | |
| Price/Sales | number | |
| Price/Book | number | |
| SEC Filings | string |
Data Files
| File | Description | Size | Last modified | Download |
|---|---|---|---|---|
scatter-data | 24.4 kB | 5 days ago | scatter-data | |
constituents | 22.9 kB | about 1 month ago | constituents | |
constituents-financials | 97.3 kB | about 1 month ago | constituents-financials |
| Files | Size | Format | Created | Updated | License | Source |
|---|---|---|---|---|---|---|
| 3 | 145 kB | csv | 5 days ago | Open Data Commons Public Domain Dedication and License v1.0 |
List of companies in the S&P 500 (Standard and Poor's 500). The S&P 500 is a free-float, capitalization-weighted index of the top 500 publicly listed stocks in the US (top 500 by market cap). The dataset includes a list of all the stocks contained therein and associated key financials such as price, market capitalization, earnings, price/earnings ratio, price to book etc.
Data
Information on S&P 500 index used to be available on the official webpage on the Standard and Poor's website but until they publish it back, Wikipedia is the best up-to-date and open data source.
- Index listing - see
data/constituents.csvextracted from Wikipedia's SP500 list of companies - Constituent financials - see
data/constituents-financials.csv(source via Yahoo Finance)
Detailed information on the S&P 500 (primarily in XLS format) used to be obtained from its official webpage on the Standard and Poor's website - it was free but registration was required.
- Index listing - see
data/constituents.csvused to be extracted from source Excel file on S&P website (Note this Excel is actually S&P 500 EPS estimates but on sheet 4 it has list of members - [previous file][sp-lsting] was just members but that 404s as of Dec 2014) (Note:but note you have to register and login to access- no longer true as of August 2013) - Historical performance (source XLS on S&P website)
Notes:
- Market Capitalization and EBIDTA are in Billions.
Note: For aggregate information on the S&P (dividends, earnings, etc), see Standard and Poor's 500 Dataset.
Preparation
You can run the script yourself to update the data and publish them to GitHub : see scripts README.
General Financial Notes
Publicly listed US companies are obliged various reports on a regular basis with the SEC. Of these 2 types are of especial interest to investors and others interested in their finances and business. These are:
- 10-K = Annual Report
- 10-Q = Quarterly report
License
All data is licensed under the Open Data Commons Public Domain Dedication and License. All code is licensed under the MIT/BSD license.
Note that while no credit is formally required, a link back or credit to Rufus Pollock and the Open Knowledge Foundation is much appreciated.