ETF Overlap Tool

QQQ vs SPY ETF Overlap

Snapshot overlap answer

QQQ and SPY share 88 matched holdings in the stored snapshots. Their weighted holdings overlap is 52.6%. QQQ has 94.6% in common holdings, while SPY has 52.6%. The holdings dates are Jul 29, 2026 and Jul 29, 2026.

Compare ETF holdings

Enter two different ETF tickers. The base comparison uses a 50% and 50% model, which you can change after the result loads.

Examples: VOO and VTI, QQQ and VGT, or SCHD and VYM.

Data dates and coverage

Complete

Each ETF keeps its own FMP update time. Pineify does not replace different timestamps with a single date. Result retrieved Jul 30, 2026, 05:02 AM UTC.

QQQ
Updated Jul 29, 2026, 03:07 AM UTC
Identified coverage: 99.9%
Positive long weight: 100.1%. Identified long: 100.0%.
Signed source weight: 100.0%. Unmatched long: 0.1%.
Excluded negative weight: 0.1%.
SPY
Updated Jul 29, 2026, 05:07 PM UTC
Identified coverage: 100.0%
Positive long weight: 100.0%. Identified long: 100.0%.
Signed source weight: 100.0%. Unmatched long: 0.0%.
Shared holdings
88
Resolved holding identities present in both ETF snapshots.
Weighted overlap
52.6%
Sum of the smaller weight for each shared holding.
QQQ common exposure
94.6%
Share of QQQ invested in holdings that also appear in SPY.
SPY common exposure
52.6%
Share of SPY invested in holdings that also appear in QQQ.

Top shared holdings

Ranked by the smaller weight contributed by the two ETFs.

Complete
Shared holdings for QQQ and SPY
HoldingQQQ weightSPY weightOverlap slice
AAPLApple Inc8.43%7.80%7.80%
NVDANVIDIA Corp8.04%7.45%7.45%
MSFTMicrosoft Corp4.93%4.56%4.56%
AMZNAmazon.com Inc4.19%3.53%3.53%
GOOGLAlphabet Inc3.28%3.06%3.06%
AVGOBroadcom Inc3.05%2.82%2.82%
GOOGAlphabet Inc3.06%2.45%2.45%
METAMeta Platforms Inc2.96%2.03%2.03%
MUMicron Technology Inc4.31%1.45%1.45%
TSLATesla Inc2.59%1.35%1.35%
AMDAdvanced Micro Devices Inc3.45%1.16%1.16%
WMTWalmart Inc2.57%0.77%0.77%
CSCOCisco Systems Inc2.12%0.71%0.71%
COSTCostco Wholesale Corp2.00%0.67%0.67%
INTCIntel Corp2.02%0.64%0.64%

Top unique holdings

These resolved holdings appear on one side of the current snapshots, not both.

Unique to QQQ

  • SPCXSpace Exploration Technologies Corp1.04%
  • SHOPShopify Inc0.74%
  • ASMLASML Holding NV0.68%
  • ARMARM Holdings PLC0.48%
  • MELIMercadoLibre Inc0.44%
  • PDDPDD Holdings Inc0.27%
  • CCEPCoca-Cola Europacific Partners PLC0.23%
  • ALABAstera Labs Inc0.21%
  • No tickerFerrovial NV0.21%
  • TRIThomson Reuters Corp0.18%

Unique to SPY

  • LLYELI LILLY + CO1.51%
  • JPMJPMORGAN CHASE + CO1.50%
  • BRK-BBERKSHIRE HATHAWAY INC CL B1.47%
  • JNJJOHNSON + JOHNSON1.00%
  • XOMEXXONMOBIL HOLDINGS CORP0.99%
  • VVISA INC CLASS A SHARES0.95%
  • ABBVABBVIE INC0.73%
  • MAMASTERCARD INC A0.71%
  • BACBANK OF AMERICA CORP0.64%
  • UNHUNITEDHEALTH GROUP INC0.61%

Sector overlap

Sector weights are compared by normalized provider labels. Unknown weight is not reassigned.

70.0%Complete
QQQ classification coverage
Classified ratio: 100.0%. Unknown weight: 0.0%.
SPY classification coverage
Classified ratio: 100.0%. Unknown weight: 0.0%.
Sector overlap for QQQ and SPY
BucketQQQSPYOverlap
Information Technology60.93%38.42%38.42%
Communication Services13.07%9.23%9.23%
Consumer Discretionary10.68%8.76%8.76%
Consumer Staples6.25%4.55%4.55%
Health Care3.56%9.07%3.56%
Industrials2.70%8.29%2.70%
Utilities1.14%2.26%1.14%
Materials1.04%1.69%1.04%
Energy0.45%3.38%0.45%
Financials0.17%12.15%0.17%
Cash & Others0.01%0.30%0.01%
Real Estate0.00%1.90%0.00%

Country overlap

Country exposure uses the current provider classification for each ETF.

95.7%Complete
QQQ classification coverage
Classified ratio: 100.0%. Unknown weight: 0.0%.
SPY classification coverage
Classified ratio: 100.0%. Unknown weight: 0.0%.
Country overlap for QQQ and SPY
BucketQQQSPYOverlap
United States94.27%97.26%94.27%
United Kingdom1.82%0.45%0.45%
Singapore0.78%0.32%0.32%
Other0.35%0.30%0.30%
Ireland0.27%1.15%0.27%
Netherlands1.15%0.11%0.11%
Canada0.92%0.02%0.02%
Uruguay0.44%0.00%0.00%
Switzerland0.00%0.31%0.00%
Bermuda0.00%0.08%0.00%

Market-cap style overlap

Applicable equity holdings are grouped by Pineify v1 market-cap thresholds. Bonds, cash, and derivatives are excluded.

99.0%Complete
QQQ classification coverage
Classified ratio: 99.3%. Unknown weight: 0.7%.
SPY classification coverage
Classified ratio: 100.0%. Unknown weight: 0.0%.
Market-cap style overlap for QQQ and SPY
BucketQQQSPYOverlap
Large cap98.96%99.59%98.96%
Unclassified0.68%0.00%0.00%
Mid cap0.00%0.12%0.00%

Model your whole-portfolio exposure

Enter each ETF as a share of the whole portfolio. Pineify keeps any remainder unmodeled and does not rescale the inputs.

0% remains outside this two-ETF model.

Shared exposure
73.6%
Combined exposure to holdings present in both ETFs.
Duplicate slice
26.3%
The smaller scaled position for every shared holding.
Unmodeled remainder
0.0%
Portfolio weight outside the two entered ETFs.

Method

  • Weighted overlap is the sum of the smaller holding weight for every matched security.
  • Pineify retains valid ISIN, CUSIP, and symbol aliases. Matching proceeds in stages and only accepts unique, non-conflicting identities. Names are not fuzzy matched.
  • Common exposure is calculated separately for each ETF. It is not the same metric as weighted overlap.
  • Negative weights are reported separately and excluded from the long-only overlap calculation.
  • Market-cap style uses Pineify methodology v1: small below $2 billion, mid from $2 billion to below $10 billion, and large at $10 billion or more. Market-cap data older than seven days is stale and the affected weight remains unclassified.

Methodology version: holdings-overlap-v1

Sources and warnings

  • FMP etf-holdings for QQQProvider time: Jul 29, 2026, 03:07 AM UTC. Retrieved Jul 30, 2026, 05:02 AM UTC.
  • FMP etf-info for QQQProvider time: Jul 30, 2026, 03:10 AM UTC. Retrieved Jul 30, 2026, 05:02 AM UTC.
  • FMP etf-sector-weightings for QQQProvider time: No provider timestamp. Retrieved Jul 30, 2026, 05:02 AM UTC.
  • FMP etf-country-weightings for QQQProvider time: No provider timestamp. Retrieved Jul 30, 2026, 05:02 AM UTC.
  • FMP etf-holdings for SPYProvider time: Jul 29, 2026, 05:07 PM UTC. Retrieved Jul 30, 2026, 05:02 AM UTC.
  • FMP etf-info for SPYProvider time: Jul 30, 2026, 12:27 AM UTC. Retrieved Jul 30, 2026, 05:02 AM UTC.
  • FMP etf-sector-weightings for SPYProvider time: No provider timestamp. Retrieved Jul 30, 2026, 05:02 AM UTC.
  • FMP etf-country-weightings for SPYProvider time: No provider timestamp. Retrieved Jul 30, 2026, 05:02 AM UTC.
  • FMP market-capitalization-batchProvider time: No provider timestamp. Retrieved Jul 30, 2026, 05:02 AM UTC.

Data notes

  • Negative holding weight is reported separately and excluded from long-only overlap.
  • Some positive holding weight did not have a reliable security identity.
  • Holding tables show the highest-weight rows; calculations use every resolved holding.
  • 2 market-cap observations were too old for current style classification.
  • The two ETF holdings snapshots have different FMP update times.

What this QQQ and SPY result means

Holding count and weight answer different questions

The shared count shows how many resolved holding identities appear on both sides. Weighted overlap shows how much of the smaller position lines up for each shared security.

This is not a performance comparison

The page does not compare fees, liquidity, tracking error, taxes, or historical returns. Use those factors in a separate fund review before making an investment decision.

ETF overlap questions

A next step after overlap

Put the duplicate exposure in research context

ETF overlap explains portfolio composition. Finance Agent can help you inspect the funds, sectors, and holdings behind the result. It does not turn overlap into a buy or sell recommendation.

Pineify ETF Overlap is an information tool, not investment advice. The analysis does not compare fees, liquidity, past performance, or expected returns, and it does not recommend one ETF over another. Data can be incomplete or delayed. No tool or AI system can predict ETF prices or guarantee a return.