Simplify Analytics
← Data Explorer

ETF holdings

core.etf_holdings

Class E accrual. Cash rows are sentinel-tickered; see the ck_etf_holdings_cash_is_sentinel constraint.

16,657 rowsCSV — whole table, not this view

Sources in this table

as_ofto
column equals (exact text)
sort
chart against as_of
reset
active:country_code = US×endpoint = /api/etfs/QQQ/holdings×sector = Consumer Defensive×

as_of leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.

etftexttickertextvintage_datedateweightnumericsharesnumericsectortextcountry_nametextcountry_codetextcontinenttextshort_nametextsecurity_typetexthas_optionsbooleancusiptextisintextsourcetextendpointtextrequest_paramsjsonbas_of ↓datevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
QQQWMT2026-09-162.349840103901495.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WMT
QQQPEP2026-09-160.83182629111124.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PEP
QQQMNST2026-09-160.39065041661660.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MNST
QQQMDLZ2026-09-160.35869427340753.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MDLZ
QQQKDP2026-09-160.19361528940301.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KDP
QQQCOST2026-09-161.7767499449456.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COST
QQQWMT2026-09-152.363352103685811.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WMT
QQQPEP2026-09-150.83916829050700.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PEP
QQQMNST2026-09-150.39127741575168.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MNST
QQQMDLZ2026-09-150.35729227283997.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MDLZ
QQQKDP2026-09-150.19177728880241.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KDP
QQQCOST2026-09-151.7923429429828.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30COST
QQQWMT2026-09-142.369295103693514.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30WMT
QQQPEP2026-09-140.83875429052858.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30PEP
QQQMNST2026-09-140.38495641578257.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30MNST
QQQMDLZ2026-09-140.35659727286024.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30MDLZ
QQQKDP2026-09-140.19105928882386.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30KDP
QQQCOST2026-09-141.8152299430529.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30COST
QQQWMT2026-09-132.305074103822810.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30WMT
QQQPEP2026-09-130.83057029088520.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30PEP
QQQMNST2026-09-130.37435941629315.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30MNST
QQQMDLZ2026-09-130.35348027321375.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30MDLZ
QQQKHC2026-09-130.13074625239507.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30KHC
QQQKDP2026-09-130.18834628957706.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30KDP
QQQCOST2026-09-131.7701939442405.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30COST
QQQWMT2026-09-102.295292103761274.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30WMT
QQQPEP2026-09-100.84016629071280.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30PEP
QQQMNST2026-09-100.37507941604643.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30MNST
QQQMDLZ2026-09-100.35687927305183.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30MDLZ
QQQKHC2026-09-100.13083325224547.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30KHC
QQQKDP2026-09-100.19048928940546.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30KDP
QQQCOST2026-09-101.7816369436805.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30COST
QQQWMT2026-09-092.272889103476670.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30WMT
QQQPEP2026-09-090.83144428991545.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30PEP
QQQMNST2026-09-090.36891441490535.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30MNST
QQQMDLZ2026-09-090.35277927230295.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30MDLZ
QQQKHC2026-09-090.13058825155357.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30KHC
QQQKDP2026-09-090.19216628861181.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30KDP
QQQCOST2026-09-091.7630069410905.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30COST
QQQWMT2026-09-082.270974102892078.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30WMT
QQQPEP2026-09-080.83963128827765.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30PEP
QQQMNST2026-09-080.37050141256151.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30MNST
QQQMDLZ2026-09-080.34729927076471.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30MDLZ
QQQKHC2026-09-080.13172925013237.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30KHC
QQQKDP2026-09-080.19441328698161.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30KDP
QQQCOST2026-09-081.7726229357705.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30COST
QQQWMT2026-09-072.296843103945882.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57WMT
QQQPEP2026-09-070.83360029123000.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57PEP
QQQMNST2026-09-070.37579441678659.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57MNST
QQQMDLZ2026-09-070.34490527353759.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57MDLZ