cap_illustration
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-09-26, from what-stocks-are-in-the-dax.
| symbol | as_of_label | weight_pct | over_cap_pct |
|---|---|---|---|
| NVDA | Sep 25, 2026 | 28.27 | 13.27 |
| AAPL | Sep 25, 2026 | 25.9 | 10.9 |
| MSFT | Sep 25, 2026 | 19.94 | 4.94 |
| AMZN | Sep 25, 2026 | 14.01 | 0 |
| JPM | Sep 25, 2026 | 4.74 | 0 |
| JNJ | Sep 25, 2026 | 3.4 | 0 |
| KO | Sep 25, 2026 | 1.97 | 0 |
| PG | Sep 25, 2026 | 1.77 | 0 |
- Rows × columns
- 8 × 4
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
symbol |
text | 8 distinct values (AAPL, AMZN, JNJ…) | |
as_of_label |
text | 1 distinct value (Sep 25, 2026) | |
weight_pct |
number | 1.77 to 28.27 | percent |
over_cap_pct |
number | 0 to 13.27 | percent |
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 , and the query below is what returned them.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
WITH latest AS
(
SELECT
ticker,
argMax(toFloat64(market_cap), date) AS mcap,
max(date) AS as_of
FROM global_markets.stocks_ratios
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'AMZN', 'JPM', 'JNJ', 'PG', 'KO')
AND date >= today() - 400
AND market_cap > 0
GROUP BY ticker
),
basket AS
(
SELECT sum(mcap) AS total
FROM latest
)
SELECT
l.ticker AS symbol,
formatDateTime(l.as_of, '%b %e, %Y') AS as_of_label,
round(100 * l.mcap / b.total, 2) AS weight_pct,
round(greatest(100 * l.mcap / b.total - 15, 0), 2) AS over_cap_pct
FROM latest AS l
CROSS JOIN basket AS b
ORDER BY weight_pct DESC
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.