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

Sources in this table

as_ofto
column equals (exact text)
sort
chart against as_of
reset

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_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
SPYSHW2026-09-160.1133422743422.00Basic MaterialsUNITED STATESUSNorth AmericaSHERWIN WILLIAMSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SHW
SPYSCHW2026-09-160.26390819526851.00Financial ServicesUNITED STATESUSNorth AmericaSCHWAB CHARLESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SCHW
SPYSBUX2026-09-160.17017713603149.00Consumer CyclicalUNITED STATESUSNorth AmericaSTARBUCKSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SBUX
SPYSBAC2026-09-160.0293451268383.00Real EstateUNITED STATESUSNorth AmericaSBA COMMUNICATIONSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SBAC
SPYRVTY2026-09-160.0249931334430.00HealthcareREVVITYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RVTY
SPYRTX2026-09-160.40702116090012.00IndustrialsUNITED STATESUSNorth AmericaRAYTHEON TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RTX
SPYRSG2026-09-160.0675672391853.00IndustrialsUNITED STATESUSNorth AmericaREPUBLIC SERVICESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RSG
SPYROST2026-09-160.1113223853130.00Consumer CyclicalUNITED STATESUSNorth AmericaROSS STORESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ROST
SPYROP2026-09-160.0582921206857.00IndustrialsUNITED STATESUSNorth AmericaROPER TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ROP
SPYROL2026-09-160.0151393513058.00Consumer CyclicalUNITED STATESUSNorth AmericaROLLINSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ROL
SPYROK2026-09-160.0709611330718.00IndustrialsUNITED STATESUSNorth AmericaROCKWELL AUTOMATIONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ROK
SPYRMD2026-09-160.0508921734893.00HealthcareUNITED STATESUSNorth AmericaRESMEDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RMD
SPYRL2026-09-160.020164463695.00Consumer CyclicalUNITED STATESUSNorth AmericaRALPH LAURENstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RL
SPYRJF2026-09-160.0438892075083.00Financial ServicesUNITED STATESUSNorth AmericaRAYMOND JAMES FINANCIALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RJF
SPYRF2026-09-160.03734810207237.00Financial ServicesUNITED STATESUSNorth AmericaREGIONS FINANCIALstocktrueuw_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 PHARMACEUTICALSstocktrueuw_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 CENTERSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30REG
SPYRDDT2026-09-160.0315321556752.00Communication ServicesREDDIT INCstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RDDT
SPYRCL2026-09-160.0968042984023.00Consumer CyclicalUNITED STATESUSNorth AmericaROYAL CARIBBEAN CRUISESstocktrueuw_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 AmericaQUALCOMMstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30QCOM
SPYQ2026-09-160.0369382502253.00TechnologyQNITY ELECTRONICS INCstocktrueACI0F5BH8US748149AN17uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30Q
SPYPYPL2026-09-160.07147010550272.00Financial ServicesUNITED STATESUSNorth AmericaPAYPALstocktrueuw_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 SERVICESstocktrueuw_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 AmericaPTCstocktrueuw_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 66stocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PSX
SPYPSKY2026-09-160.0053783758323.00Communication ServicesParamount Skydance Corporation Class Bstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PSKY
SPYPSA2026-09-160.0759722006023.00Real EstateUNITED STATESUSNorth AmericaPUBLIC STORAGEstocktrueuw_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 FINANCIALstocktrueuw_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 AmericaPPLstocktrueuw_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 INDUSTRIESstocktrueuw_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 AmericaINSULETstocktrueuw_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 CAPITALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PNW
SPYPNR2026-09-160.0140261932958.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PNR
SPYPNC2026-09-160.1425824792508.00Financial ServicesUNITED STATESUSNorth AmericaPNC FINANCIAL SERVICES GROUPstocktrueuw_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 INTERNATIONALstocktrueuw_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 AmericaPALANTIRstocktrueuw_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 AmericaPROLOGISstocktrueuw_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 AMERICAstocktrueuw_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 AmericaPULTEGROUPstocktrueuw_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 HANNIFINstocktrueuw_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 AmericaPROGRESSIVEstocktrueuw_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 & GAMBLEstocktrueuw_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 GROUPstocktrueuw_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 AmericaPFIZERstocktrueuw_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 AmericaPEPSICOstocktrueuw_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 GROUPstocktrueuw_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&Estocktrueuw_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 AmericaPACCARstocktrueuw_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 AmericaPAYCHEXstocktrueuw_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 NETWORKSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PANW