size_spread
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 rsp-vs-spy-equal-weight-sp-500.
| ticker | market_cap_bn | cap_weight_pct_of_basket | equal_weight_pct | as_of_date |
|---|---|---|---|---|
| NVDA | 5434.8 | 23.08 | 10 | 2026-09-25 |
| AAPL | 4977.6 | 21.14 | 10 | 2026-09-25 |
| GOOGL | 4206.1 | 17.86 | 10 | 2026-09-25 |
| MSFT | 3832.8 | 16.28 | 10 | 2026-09-25 |
| AMZN | 2693 | 11.44 | 10 | 2026-09-25 |
| META | 1914.9 | 8.13 | 10 | 2026-09-25 |
| KO | 377.8 | 1.6 | 10 | 2026-09-25 |
| MMM | 87.4 | 0.37 | 10 | 2026-09-25 |
| HAS | 12.4 | 0.05 | 10 | 2026-09-25 |
| MOS | 7.3 | 0.03 | 10 | 2026-09-25 |
- Rows × columns
- 10 × 5
- Period covered
- 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 |
|---|---|---|---|
ticker |
text | 10 distinct values (AAPL, AMZN, GOOGL…) | |
market_cap_bn |
number | 7.3 to 5,434.8 | |
cap_weight_pct_of_basket |
number | 0.03 to 23.08 | percent |
equal_weight_pct |
number | every row is 10 | percent |
as_of_date |
date | 2026-09-25 |
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.
SELECT
ticker,
round(cap / 1e9, 1) AS market_cap_bn,
round(100 * cap / sum(cap) OVER (), 2) AS cap_weight_pct_of_basket,
round(100.0 / count() OVER (), 2) AS equal_weight_pct,
toString(snapshot_date) AS as_of_date
FROM
(
SELECT
ticker,
toFloat64(argMax(market_cap, date)) AS cap,
max(date) AS snapshot_date
FROM global_markets.stocks_ratios
WHERE ticker IN ('NVDA', 'MSFT', 'AAPL', 'AMZN', 'GOOGL', 'META', 'KO', 'MMM', 'MOS', 'HAS')
AND date >= today() - 45
AND market_cap > 0
GROUP BY ticker
)
ORDER BY cap DESC
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.