Updated

UPDATE_SCRIPT_MAINTENANCE_REPORT

35.3K

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 data...

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/
https://datahub.io/core/s-and-p-500-companies-financials/_r/-/.gitignore
https://datahub.io/core/s-and-p-500-companies-financials/_r/-/README.md
https://datahub.io/core/s-and-p-500-companies-financials/_r/-/UPDATE_SCRIPT_MAINTENANCE_REPORT.md
https://datahub.io/core/s-and-p-500-companies-financials/_r/-/data/constituents-financials.csv
https://datahub.io/core/s-and-p-500-companies-financials/_r/-/data/constituents.csv
https://datahub.io/core/s-and-p-500-companies-financials/_r/-/data/scatter-data.csv
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.jsonmetadata & schema
https://datahub.io/core/s-and-p-500-companies-financials/_r/-/datapackage.json
README.mddocumentation
https://datahub.io/core/s-and-p-500-companies-financials/_r/-/README.md
Typical Usage
  1. 1. Fetch datapackage.json to inspect schema and resources
  2. 2. Download data resources listed in datapackage.json
  3. 3. Read README.md for full context

Data Views

Data Previews

scatter-data

Loading data...

Schema

nametypedescription
companystring
sectorstring
market_cap_bnumberMarket cap in USD billions
pe_rationumberPrice/Earnings ratio

constituents

Loading data...

Schema

nametypedescription
Symbolstring
Namestring
Sectorstring

constituents-financials

Loading data...

Schema

nametypedescription
Symbolstring
Namestring
Sectorstring
Pricenumber
Price/Earningsnumber
Dividend Yieldnumber
Earnings/Sharenumber
52 Week Lownumber
52 Week Highnumber
Market Capnumber
EBITDAnumber
Price/Salesnumber
Price/Booknumber
SEC Filingsstring

Data Files

FileDescriptionSizeLast modifiedDownload
scatter-data
24.4 kBabout 1 month ago
scatter-data
constituents
22.9 kB3 months ago
constituents
constituents-financials
97.3 kB3 months ago
constituents-financials
FilesSizeFormatCreatedUpdatedLicenseSource
3145 kBcsvabout 1 month agoOpen Data Commons Public Domain Dedication and License v1.0

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.