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:etf = QQQ×sector = Consumer Defensive×sorted by as_of ↑×

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-032.329445104961226.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMT
QQQPEP2026-09-030.84095829407460.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PEP
QQQMNST2026-09-030.37888142085747.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MNST
QQQMDLZ2026-09-030.34664627620927.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDLZ
QQQKHC2026-09-030.13247125516267.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KHC
QQQKDP2026-09-030.19659029275435.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KDP
QQQCOST2026-09-031.8041909546005.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COST
QQQCCEP2026-09-030.2138719594045.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CCEP
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
QQQKHC2026-09-070.13128625269427.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57KHC
QQQKDP2026-09-070.19441428992163.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57KDP
QQQCOST2026-09-071.7812839453605.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57COST
QQQCCEP2026-09-070.2067599501249.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57CCEP
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
QQQCCEP2026-09-080.2085599404938.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30CCEP
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
QQQCCEP2026-09-090.2038099458366.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30CCEP
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
QQQCCEP2026-09-100.2041489484377.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30CCEP
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
QQQCCEP2026-09-130.2020849490001.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30CCEP
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