S&P 500 Companies with Financial Information

API Access

Access dataset files directly from scripts, code, or AI agents.

Browse dataset files

Dataset Files

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.

/core/s-and-p-500-companies-financials/

├ .gitignore

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/.gitignore

├ README.md

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/README.md

├ UPDATE_SCRIPT_MAINTENANCE_REPORT.md

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/UPDATE_SCRIPT_MAINTENANCE_REPORT.md

├ data/constituents-financials.csv

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/data/constituents-financials.csv

├ data/constituents.csv

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/data/constituents.csv

├ data/scatter-data.csv

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/data/scatter-data.csv

└ datapackage.json

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/datapackage.json

Key Files

Start with these files — they give you everything you need to understand and access the dataset.

datapackage.json— metadata & schema

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/datapackage.json

README.md— documentation

https://datahub.io/core/s-and-p-500-companies-financials/_r/-/README.md

Typical Usage

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 AI

scatter-data

Field	Type	Description
company	string	Full company name
sector	string	GICS sector classification
market_cap_b	number	Market capitalisation in USD billions
pe_ratio	number	Trailing price-to-earnings ratio

Download

Download CSV

About

Filtered view of S&P 500 constituents for scatter plot visualisation: companies with positive P/E ratios below 100, with market capitalisation expressed in USD billions.
Last updated: 20 May 2026
Total rows: ...
Format: CSV
File size: 23.6 kB
Sources: Wikipedia: List of S&P 500 companies; Yahoo Finance (via yfinance)
License: Open Data Commons Public Domain Dedication and License v1.0

constituents

Download

Download CSV

About

List of all S&P 500 index constituents with ticker symbol, company name, and GICS sector, sourced from Wikipedia.
Last updated: 9 February 2026
Total rows: ...
Format: CSV
File size: 22.9 kB
Sources: Wikipedia: List of S&P 500 companies; Yahoo Finance (via yfinance)
License: Open Data Commons Public Domain Dedication and License v1.0

constituents-financials

Field	Type	Description
Symbol	string	Stock ticker symbol (e.g. AAPL)
Name	string	Full company name
Sector	string	GICS sector classification
Price	number	Current stock price in USD
Price/Earnings	number	Trailing twelve-month price-to-earnings ratio
Dividend Yield	number	Annual dividend yield as a decimal (e.g. 0.02 = 2%)
Earnings/Share	number	Trailing twelve-month earnings per share in USD
52 Week Low	number	Lowest stock price over the trailing 52 weeks in USD
52 Week High	number	Highest stock price over the trailing 52 weeks in USD
Market Cap	integer	Market capitalisation in raw USD (e.g. 83294183424 ≈ $83.3 billion)
EBITDA	integer	Earnings before interest, taxes, depreciation, and amortisation in raw USD
Price/Sales	number	Price-to-sales ratio (trailing 12 months)
Price/Book	number	Price-to-book ratio
SEC Filings	string	URL to the company's EDGAR filing page on SEC.gov

Download

Download CSV

About

S&P 500 constituent companies with key financial metrics sourced via Yahoo Finance, including stock price, market capitalisation, earnings, dividends, and valuation ratios.
Last updated: 20 May 2026
Total rows: ...
Format: CSV
File size: 96.5 kB
Sources: Wikipedia: List of S&P 500 companies; Yahoo Finance (via yfinance)
License: Open Data Commons Public Domain Dedication and License v1.0

About this dataset

Update Script Maintenance Report

Date: 2026-03-04

Root cause: updater failed on transient Yahoo Finance errors and workflow lacked explicit write permission.
Fixes made: hardened financial fetch loop to tolerate per-symbol fetch failures, modernized workflow triggers/actions, and added permissions: contents: write.
Validation: reviewed script exception handling and workflow commit guard.
Known blockers: upstream Yahoo Finance rate limiting can still reduce completeness on some runs.