P/E ratios of US companies above $500B market cap

Name: P/E ratios of US companies above $500B market cap
Creator: Strasmore
Published: 2026-08-22
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from Free SQL API for Stock Market Data.

as of 2026-08-22 ranking 12×2read in context →

P/E ratios of US companies above $500B market cap — 12 rows by 2 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
ticker	pe_ratio
NVDA	32.9
AAPL	35.2
GOOGL	17.1
GOOG	16.9
MSFT	26.7
AMZN	20.7
AVGO	59.1
META	20.4
TSLA	358.3
LLY	43.9
MU	21.8
BRK.B	14.7

Rows × columns: 12 × 2
Computed: 2026-08-22
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for P/E ratios of US companies above $500B market cap, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	12 distinct values (AAPL, AMZN, AVGO…)
`pe_ratio`	number	14.7 to 358.3	ratio or rate

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-08-22, and the query below is what returned them.

the exact SQL behind every number

SELECT ticker,
       round(price_to_earnings, 1) AS pe_ratio
FROM global_markets.stocks_ratios
WHERE date = (SELECT max(date) FROM global_markets.stocks_ratios)
  AND market_cap > 5e11
  AND price_to_earnings > 0
  AND ticker NOT IN ('SPCX')
ORDER BY market_cap DESC
LIMIT 12

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisFree SQL API for Stock Market Data

KO: total cash dividends per share by year ranking 22×2 → SPY implied volatility by days-to-expiry bucket, latest session ranking 9×2 → Highest large-cap dividend yields, latest session ranking 12×3 → End-of-day implied-volatility leaders, liquid underlyings ranking 12×2 → SPY vs QQQ, normalized return over the last 45 days series 33×3 → Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years) ranking 25×3 → See all 2,170 queries →