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×

as_of leads no index, so this sort reads every matching row and keeps only the top 150 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
SPYRF2026-09-160.03734810207237.00Financial ServicesUNITED STATESUSNorth AmericaREGIONS FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RF
SPYREGN2026-09-160.1189801195149.00HealthcareUNITED STATESUSNorth AmericaREGENERON PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30REGN
SPYREG2026-09-160.0185601971200.00Real EstateUNITED STATESUSNorth AmericaREGENCY CENTERSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30REG
SPYRCL2026-09-160.0968042984023.00Consumer CyclicalUNITED STATESUSNorth AmericaROYAL CARIBBEAN CRUISESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RCL
SPYQCOM2026-09-160.29906012589061.00TechnologyUNITED STATESUSNorth AmericaQUALCOMMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30QCOM
SPYPYPL2026-09-160.07147010550272.00Financial ServicesUNITED STATESUSNorth AmericaPAYPALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PYPL
SPYPWR2026-09-160.1425151790628.00IndustrialsUNITED STATESUSNorth AmericaQUANTA SERVICESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PWR
SPYPTC2026-09-160.0232881381545.00TechnologyUNITED STATESUSNorth AmericaPTCstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PTC
SPYPSX2026-09-160.1630884795286.00EnergyUNITED STATESUSNorth AmericaPHILLIPS 66stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PSX
SPYPSA2026-09-160.0759722006023.00Real EstateUNITED STATESUSNorth AmericaPUBLIC STORAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PSA
SPYPRU2026-09-160.0624274150217.00Financial ServicesUNITED STATESUSNorth AmericaPRUDENTIAL FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PRU
SPYPPL2026-09-160.0386388998480.00UtilitiesUNITED STATESUSNorth AmericaPPLstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PPL
SPYPPG2026-09-160.0359682665901.00Basic MaterialsUNITED STATESUSNorth AmericaPPG INDUSTRIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PPG
SPYPODD2026-09-160.014969828418.00HealthcareUNITED STATESUSNorth AmericaINSULETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PODD
SPYPNW2026-09-160.0177071450409.00UtilitiesUNITED STATESUSNorth AmericaPINNACLE WEST CAPITALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PNW
SPYPNC2026-09-160.1425824792508.00Financial ServicesUNITED STATESUSNorth AmericaPNC FINANCIAL SERVICES GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PNC
SPYPM2026-09-160.45864718615062.00Consumer DefensiveUNITED STATESUSNorth AmericaPHILIP MORRIS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PM
SPYPLTR2026-09-160.61448627424899.00TechnologyUNITED STATESUSNorth AmericaPALANTIRstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PLTR
SPYPLD2026-09-160.19451911317023.00Real EstateUNITED STATESUSNorth AmericaPROLOGISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PLD
SPYPKG2026-09-160.0314981058888.00Consumer CyclicalUNITED STATESUSNorth AmericaPACKAGING CORP OF AMERICAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PKG
SPYPHM2026-09-160.0344172278145.00Consumer CyclicalUNITED STATESUSNorth AmericaPULTEGROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PHM
SPYPH2026-09-160.1777131505051.00IndustrialsUNITED STATESUSNorth AmericaPARKER HANNIFINstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PH
SPYPGR2026-09-160.1945076974704.00Financial ServicesUNITED STATESUSNorth AmericaPROGRESSIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PGR
SPYPG2026-09-160.52549827811547.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PG
SPYPFG2026-09-160.0352312350206.00Financial ServicesUNITED STATESUSNorth AmericaPRINCIPAL FINANCIAL GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PFG
SPYPFE2026-09-160.24013168042135.00HealthcareUNITED STATESUSNorth AmericaPFIZERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PFE
SPYPEP2026-09-160.28187616326131.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PEP
SPYPEG2026-09-160.0539195960216.00UtilitiesUNITED STATESUSNorth AmericaPUBLIC SERVICE ENTERPRISE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PEG
SPYPCG2026-09-160.04519326340079.00UtilitiesUNITED STATESUSNorth AmericaPG&Estocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PCG
SPYPCAR2026-09-160.0956386294610.00IndustrialsUNITED STATESUSNorth AmericaPACCARstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PCAR
SPYPAYX2026-09-160.0578663857499.00IndustrialsUNITED STATESUSNorth AmericaPAYCHEXstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PAYX
SPYPANW2026-09-160.4676369686238.00TechnologyUNITED STATESUSNorth AmericaPALO ALTO NETWORKSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PANW
SPYOXY2026-09-160.0662578684927.00EnergyUNITED STATESUSNorth AmericaOCCIDENTAL PETROLEUMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OXY
SPYOTIS2026-09-160.0408444589265.00IndustrialsUNITED STATESUSNorth AmericaOTIS WORLDWIDEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OTIS
SPYORLY2026-09-160.1065959911672.00Consumer CyclicalUNITED STATESUSNorth AmericaO REILLY AUTOMOTIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ORLY
SPYORCL2026-09-160.37315520281409.00TechnologyUNITED STATESUSNorth AmericaORACLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ORCL
SPYON2026-09-160.0401214687305.00TechnologyUNITED STATESUSNorth AmericaON SEMICONDUCTORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ON
SPYOMC2026-09-160.0347533408714.00Communication ServicesUNITED STATESUSNorth AmericaOMNICOM GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OMC
SPYOKE2026-09-160.0897757535400.00EnergyUNITED STATESUSNorth AmericaONEOKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OKE
SPYODFL2026-09-160.0490502188876.00IndustrialsUNITED STATESUSNorth AmericaOLD DOMINION FREIGHT LINEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ODFL
SPYO2026-09-160.08191711152872.00Real EstateUNITED STATESUSNorth AmericaREALTY INCOMEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30O
SPYNWSA2026-09-160.0169334364187.00Communication ServicesUNITED STATESUSNorth AmericaNEWSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NWSA
SPYNWS2026-09-160.0062711459083.00Communication ServicesUNITED STATESUSNorth AmericaNEWSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NWS
SPYNVR2026-09-160.02541531965.00Consumer CyclicalUNITED STATESUSNorth AmericaNVRstockfalse——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NVR
SPYNVDA2026-09-167.955356289387163.00TechnologyUNITED STATESUSNorth AmericaNVIDIAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NVDA
SPYNUE2026-09-160.0912592723936.00Basic MaterialsUNITED STATESUSNorth AmericaNUCORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NUE
SPYNTRS2026-09-160.0502422213144.00Financial ServicesUNITED STATESUSNorth AmericaNORTHERN TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NTRS
SPYNTAP2026-09-160.0581702363669.00TechnologyUNITED STATESUSNorth AmericaNETAPPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NTAP
SPYNSC2026-09-160.1091782679822.00IndustrialsUNITED STATESUSNorth AmericaNORFOLK SOUTHERNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NSC
SPYNRG2026-09-160.0348242523382.00UtilitiesUNITED STATESUSNorth AmericaNRG ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NRG