STRASMORE/EXPLORE 2,170 QUERIES

Price weighting across ten large US names, latest close

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 Stock Splits vs Fractional Shares Explained.

as of ranking 10×3read in context →
Price weighting across ten large US names, latest close — 10 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickershare_priceindex_weight_pct
GS1011.523.1
CAT825.0518.8
MSFT481.811
UNH384.888.8
V366.088.4
JPM3548.1
HD335.197.7
AAPL312.087.1
NVDA218.055
KO90.512.1
Rows × columns
10 × 3
Computed
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 Price weighting across ten large US names, latest close, derived from the stored result.
ColumnTypeRangeNotes
ticker text 10 distinct values (AAPL, CAT, GS…)
share_price number 90.51 to 1,011.5 US dollars
index_weight_pct number 2.1 to 23.1 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.

the exact SQL behind every number
SELECT
    ticker,
    share_price,
    round(100 * share_price / sum(share_price) OVER (), 1) AS index_weight_pct
FROM
(
    SELECT
        ticker,
        round(toFloat64(argMax(close, date)), 2) AS share_price
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'CAT', 'GS', 'HD', 'JPM', 'KO', 'MSFT', 'NVDA', 'UNH', 'V')
      AND date >= today() - 20
    GROUP BY ticker
)
ORDER BY share_price DESC

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 analysisStock Splits vs Fractional Shares Explained
Forward stock splits at liquid US names, past three years ranking 12×3 AAPL prints by trade size, one to ten shares, June 10 2026 session ranking 10×2 NVDA strike ladder and share price across its June 2024 split series 10×5 The most common split terms of the past five years ranking 12×3 Forward and reverse splits per calendar year ranking 11×3 US stock splits by year: forward and reverse counts, 2017 through July 2026 ranking 10×3 See all 2,170 queries →