ETF catalog
Change funds

QQQ vs SPYETF Holdings Overlap

QQQ Invesco QQQ Trust, Series 1SPY State Street SPDR S&P 500 ETF Trust
Weighted overlap39.84% Moderate

For each shared stock, we take the smaller of its two fund weights. Adding those weights gives the overall overlap.

See a simple example

Microsoft Corp. represents 11.77% of QQQ and 6.02% of SPY. The smaller weight, 6.02 percentage points, goes into the total overlap.

What does the rating mean?

In shared stocks

QQQ92.63%

Of QQQ, in shares also held by SPY.

83 of 103 matched share classes are shared

SPY39.84%

Of SPY, in shares also held by QQQ.

83 of 505 matched share classes are shared

Change funds

Search by ticker or fund name.

Invesco QQQ Trust, Series 1

State Street SPDR S&P 500 ETF Trust

Overlap history

Change over the displayed period19 portfolio dates
–
Weighted overlap
15.54% → 39.84%+24.30 pp
Shared stock classes
35 → 83+48
Weighted overlap
Weight (%)
Portfolio date
Shared stock classes
Stock classes
Portfolio date

Audited SEC archive · Dashed lines join consecutive annual filings.

Hover or tap a point for both values. Use arrow keys, Home or End to choose a date. Gaps mark dates without verified data.

Detailed comparisons are available for matched dates from . Earlier archive points are shown in the charts and filing table.

Back to the latest comparison
See all 19 dates and SEC filings
DateWeight (%)ClassesSEC
39.84%83QQQSPY
37.13%85QQQSPY
33.20%85QQQSPY
32.26%88QQQSPY
Audited SEC archive32.29%85QQQSPY
Audited SEC archive28.40%87QQQSPY
Audited SEC archive26.70%85QQQSPY
Audited SEC archive25.05%87QQQSPY
Audited SEC archive23.16%81QQQSPY
Audited SEC archive21.12%78QQQSPY
Audited SEC archive22.47%79QQQSPY
Audited SEC archive19.64%74QQQSPY
Audited SEC archive18.29%72QQQSPY
Audited SEC archive17.71%65QQQSPY
Audited SEC archive14.75%60QQQSPY
Audited SEC archive14.06%57QQQSPY
Audited SEC archive15.20%59QQQSPY
Audited SEC archive11.58%60QQQSPY
Audited SEC archive15.54%35QQQSPY
Methodology

We add the smaller weight of each shared common-stock share class. Weights use each fund’s net assets as reported. We omit dates without a same-day pair of reviewed filings or below 90% matched assets in either fund.

The minimum matched share of net assets was 99.16%. Filings were submitted 49–228 days after their portfolio dates. The archive confirms filing dates. Exact public release times are unavailable. The reviewed series ends on .

Squares and dashed lines show annual audited SEC statements from before N-PORT. We matched stock classes by name and used per-share values to check identity. Each fund keeps its reported valuation. Temporary when-issued positions are excluded. Gaps mark periods with no verified observation. The line also breaks where annual filings give way to quarterly N-PORT data.

Methodology

What changed between filings

→ +2.71 pp
NameContribution to change
Apple, Inc.+0.84 pp
Amazon.com, Inc.+0.72 pp
Microsoft Corp.+0.41 pp
PayPal Holdings, Inc.+0.27 pp
Facebook, Inc.+0.26 pp
All other shared classes+0.20 pp

These are the largest changes in overlap contribution. A difference in reported weights does not establish a trade.

Filing sources

Read the dates and how much of each fund we could compare.

MeasureQQQSPY
Holdings date
Filed
Matched (%)99.96%99.99%
SEC filingSECSEC
What do these numbers mean?

Holdings date · The day the fund recorded its holdings.

Matched (%) · The share of the fund’s net assets that we could identify as common-stock classes.

Inside the two funds

Largest shared positions

Showing the top 3 of 83 matched stock classes.

Name QQQ · Portfolio weightSPY · Portfolio weight Shared weight
Microsoft Corp.11.77%6.02%6.02%
Apple, Inc.12.06%5.80%5.80%
Amazon.com, Inc.10.49%4.51%4.51%

Each shared weight is the smaller of the two fund weights for that stock. Adding these amounts across all shared stocks gives the total overlap.

Only in QQQ

Showing the top 3 of 20 matched stock classes.

NameQQQ · Portfolio weight
Tesla, Inc.1.95%
JD.com, Inc.0.54%
MercadoLibre, Inc.0.48%

Only in SPY

Showing the top 3 of 422 matched stock classes.

NameSPY · Portfolio weight
Johnson & Johnson1.45%
Berkshire Hathaway Inc1.35%
Visa Inc1.27%
See full holdings report options

Overlap by industry

See how many percentage points each industry adds to the 39.84% overlap.

IndustriesContribution (pp)
Services 13.33
Manufacturing 12.12
Retail 4.51
Remaining identified industries 1.18
Unknown industry 8.70

Broad groups based on SEC industry codes (SIC). An industry is unknown when we could not verify its code. Rounded values may add up to a slightly different total.

Industry weights by fund

Each column shows the share of that fund’s net assets in matched stocks in the industry. The difference is in percentage points.

IndustriesQQQ · Portfolio weightSPY · Portfolio weightWeight difference in percentage points
Services 28.01%17.56% +10.45
Manufacturing 30.03%23.62% +6.41
Finance, insurance and real estate 0.00%5.63% -5.63
Retail 10.49%6.76% +3.73
Transport, communications and utilities 3.61%4.05% -0.44
Mining and extraction 0.00%0.07% -0.07
Unknown industry 27.82%42.31% -14.49

Difference = QQQ minus SPY. Broad groups based on SEC industry codes (SIC). An industry is unknown when we could not verify its code.