The whole US stock market, as one CSV
Every active US-listed company with a price and a market cap — 4,894 rows, 53 fields. Free to download for personal, non-commercial research use.
Most free stock data is either a handful of tickers or locked behind a key with a rate limit. This is the whole listed market in one file, generated from the same endpoint the screener on this site calls, so the CSV and the website cannot disagree with each other.
Licence
The file is for personal, non-commercial research use. The underlying data is licensed from Financial Modeling Prep, and that licence does not extend to commercial use or to redistributing the data: please do not resell the file, republish it in full or upload it to other sites. When you quote figures from it, credit DeltaScreener and link to deltascreener.com.
Cite this page
When you quote figures from the file, either line below gives the credit; the dated file address never changes, so it keeps pointing at the exact numbers you used.
DeltaScreener, "US stock universe dataset", https://deltascreener.com/data, data as of 3 November 2026.<a href="https://deltascreener.com/data">US stock universe dataset</a> (DeltaScreener, data as of 3 November 2026)https://deltascreener.com/data/us-stock-universe-2026-11-03.csvData from DeltaScreener (deltascreener.com), 3 November 2026.For any other use, write to hello@deltascreener.com first.
What is in the file
One row per company, sorted by market capitalisation, largest first. The coverage column counts how many of the 4,894 rows carry a value: an empty cell means not reported, never zero.
| Column | Meaning | Rows with a value |
|---|---|---|
ticker |
Ticker symbol as listed | 4,894 (100%) |
name |
Company name | 4,894 (100%) |
exchange |
Listing exchange | 4,894 (100%) |
sector |
Sector | 4,894 (100%) |
industry |
Industry | 4,894 (100%) |
country |
Country of domicile | 3,699 (76%) |
price |
Last close, USD | 4,894 (100%) |
mktCap |
Market capitalisation, USD | 4,894 (100%) |
enterpriseValue |
Enterprise value, USD | 4,791 (98%) |
volume |
Last session volume, shares | 4,866 (99%) |
avgVolume |
Average daily volume, shares | 4,891 (100%) |
beta |
Beta | 4,893 (100%) |
pe |
Trailing price to earnings | 2,572 (53%) |
pb |
Price to book | 4,446 (91%) |
ps |
Price to sales | 4,420 (90%) |
peg |
PEG ratio | 3,575 (73%) |
evEbitda |
Enterprise value to EBITDA | 2,826 (58%) |
earningsYield |
Earnings yield, percent | 4,201 (86%) |
dividendYield |
Dividend yield, percent | 4,840 (99%) |
payoutRatio |
Payout ratio, percent | 1,561 (32%) |
eps |
Earnings per share, USD | 4,808 (98%) |
bookValuePs |
Book value per share, USD | 630 (13%) |
sales |
Revenue, USD millions | 4,780 (98%) |
profitAfterTax |
Net income, USD millions | 4,788 (98%) |
ebitda |
EBITDA, USD | 4,566 (93%) |
freeCashFlow |
Free cash flow, USD | 4,568 (93%) |
grossMargin |
Gross margin, percent | 3,539 (72%) |
opMargin |
Operating margin, percent | 3,879 (79%) |
netMargin |
Net margin, percent | 3,770 (77%) |
roe |
Return on equity, percent | 3,941 (81%) |
roa |
Return on assets, percent | 4,704 (96%) |
roce |
Return on capital employed, percent | 4,672 (95%) |
debtToEquity |
Debt to equity | 4,517 (92%) |
currentRatio |
Current ratio | 4,527 (93%) |
quickRatio |
Quick ratio | 4,516 (92%) |
interestCoverage |
Interest coverage | 4,460 (91%) |
totalDebt |
Total debt, USD | 4,540 (93%) |
totalCash |
Total cash, USD | 4,582 (94%) |
salesGrowth |
Revenue growth, latest, percent | 4,820 (98%) |
profitGrowth |
Earnings growth, latest, percent | 4,794 (98%) |
salesGrowth3y |
Revenue growth, 3-year CAGR, percent | 4,814 (98%) |
salesGrowth5y |
Revenue growth, 5-year CAGR, percent | 3,630 (74%) |
profitGrowth3y |
Earnings growth, 3-year CAGR, percent | 4,768 (97%) |
profitGrowth5y |
Earnings growth, 5-year CAGR, percent | 1,738 (36%) |
avgRoe3y |
Average return on equity, 3 years, percent | 4,414 (90%) |
avgRoe5y |
Average return on equity, 5 years, percent | 4,414 (90%) |
return3m |
Price return, 3 months, percent | 4,789 (98%) |
return6m |
Price return, 6 months, percent | 4,682 (96%) |
return1y |
Price return, 1 year, percent | 4,539 (93%) |
return3y |
Price return, 3 years, percent | 4,082 (83%) |
return5y |
Price return, 5 years, percent | 3,675 (75%) |
yearHigh |
52-week high, USD | 4,894 (100%) |
yearLow |
52-week low, USD | 4,894 (100%) |
The thinnest columns are bookValuePs (13%), payoutRatio (32%), profitGrowth5y (36%). They are thin because the underlying figure is genuinely absent for most companies, not because the file is truncated — check the coverage before averaging over one of them.
Every published file
Each month gets its own dated file, which is never edited or removed afterwards. /data/us-stock-universe-latest.csv always holds the newest month. Column definitions and the row count are in universe-dataset-meta.json.
| Data as of | File | Size |
|---|---|---|
| 3 November 2026 current | /data/us-stock-universe-2026-11-03.csv | 1.5 MB |
| 31 October 2026 | /data/us-stock-universe-2026-10-31.csv | 1.5 MB |
How it is built
- Universe. Every active US-listed ticker with a company name, a listed exchange, a price above zero and a market cap above zero. Not an index: small caps, ADRs and foreign issuers with a US listing are all in.
- Values. Taken through this site's public screener endpoint, after the same sanitising the website applies — a ratio the screener would refuse to show is empty here too, rather than present and wrong.
- Dates. Prices are the last close before the stamp on the file. Fundamentals are the most recent reported figures, which for a given company may be a quarter or two old.
- Refusal to publish a partial file. The builder compares what it collected against the universe size the API reports and aborts rather than writing a file that quietly dropped part of the market.
Known limits
- It is a snapshot of companies listed today. Companies that have since delisted or been acquired are not in it, so a series built from several monthly files carries survivorship bias.
- Fundamentals are as reported and are not restated for later amendments.
- Figures can differ by a fraction from other providers because of price source and date alignment.
- No ETFs or funds in this file — it is operating companies only.
Built from this data: how many of the 1,000 largest US stocks beat the S&P 500 over six months, and the market statistics by sector. To filter it in the browser instead of downloading it, use the screener.
Frequently Asked Questions
Can I use this data commercially?
No. The file is for personal, non-commercial research use. The underlying data is licensed from Financial Modeling Prep, and that licence does not cover commercial use or redistribution of the data. When you quote figures from the file, credit DeltaScreener and link to deltascreener.com.
How often is it updated?
A new dated file is published each month. The dated file is never overwritten, so a chart or article that cites one keeps showing the numbers its author actually saw. us-stock-universe-latest.csv always carries the most recent month if you want a stable URL instead.
Why are some columns empty for some companies?
An empty cell means the figure was not reported or does not apply, never zero. A company with no earnings has no price-to-earnings ratio; a company with no revenue has no margin. Writing those as 0 would make them look like real values and corrupt any average taken over the column.
Where does the data come from?
The file is generated from this site's own public screener endpoint, the same one the screener on the site calls, so the CSV and the website cannot disagree. Underlying sources are Yahoo Finance, SEC EDGAR, Financial Modeling Prep and Alpha Vantage.
Provided as is, with no warranty of accuracy or fitness for any purpose, and nothing here is a recommendation about any security. See the disclaimer.