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×sector = Industrials×source = uw_etf_holdings×

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
SPYXYL2026-09-160.0391942842957.00IndustrialsUNITED STATESUSNorth AmericaXYLEMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XYL
SPYWM2026-09-160.1215314418786.00IndustrialsUNITED STATESUSNorth AmericaWASTE MANAGEMENTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WM
SPYWAB2026-09-160.0720782029275.00IndustrialsUNITED STATESUSNorth AmericaWESTINGHOUSE AIR BRAKE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WAB
SPYVRT2026-09-160.1412814591698.00IndustrialsUNITED STATESUSNorth AmericaVERTIV HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VRT
SPYVRSK2026-09-160.0366051567113.00IndustrialsUNITED STATESUSNorth AmericaVERISK ANALYTICSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VRSK
SPYURI2026-09-160.096887749184.00IndustrialsUNITED STATESUSNorth AmericaUNITED RENTALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30URI
SPYUPS2026-09-160.1133578930084.00IndustrialsUNITED STATESUSNorth AmericaUNITED PARCEL SERVICEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UPS
SPYUNP2026-09-160.2560227091288.00IndustrialsUNITED STATESUSNorth AmericaUNION PACIFICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UNP
SPYUAL2026-09-160.0530343881985.00IndustrialsUNITED STATESUSNorth AmericaUNITED AIRLINES HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UAL
SPYTXT2026-09-160.0215252075121.00IndustrialsUNITED STATESUSNorth AmericaTEXTRONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TXT
SPYTDG2026-09-160.092849668866.00IndustrialsUNITED STATESUSNorth AmericaTRANSDIGM GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TDG
SPYSWK2026-09-160.0212791859272.00IndustrialsUNITED STATESUSNorth AmericaSTANLEY BLACK & DECKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SWK
SPYSNA2026-09-160.029699619569.00IndustrialsUNITED STATESUSNorth AmericaSNAP-ONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SNA
SPYRTX2026-09-160.40702116090012.00IndustrialsUNITED STATESUSNorth AmericaRAYTHEON TECHNOLOGIESstocktrue——uw_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 SERVICESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RSG
SPYROP2026-09-160.0582921206857.00IndustrialsUNITED STATESUSNorth AmericaROPER TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ROP
SPYROK2026-09-160.0709611330718.00IndustrialsUNITED STATESUSNorth AmericaROCKWELL AUTOMATIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ROK
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
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
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
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
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
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
SPYNOC2026-09-160.1089231596749.00IndustrialsUNITED STATESUSNorth AmericaNORTHROP GRUMMANstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NOC
SPYNDSN2026-09-160.025176633922.00IndustrialsUNITED STATESUSNorth AmericaNORDSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NDSN
SPYMMM2026-09-160.1303996238095.00IndustrialsUNITED STATESUSNorth America3Mstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MMM
SPYMAS2026-09-160.0212442420872.00IndustrialsUNITED STATESUSNorth AmericaMASCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MAS
SPYLUV2026-09-160.0294055844173.00IndustrialsUNITED STATESUSNorth AmericaSOUTHWEST AIRLINESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LUV
SPYLMT2026-09-160.1673352423483.00IndustrialsUNITED STATESUSNorth AmericaLOCKHEED MARTINstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LMT
SPYLII2026-09-160.017569378634.00IndustrialsUNITED STATESUSNorth AmericaLENNOX INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LII
SPYLHX2026-09-160.0718042228200.00IndustrialsUNITED STATESUSNorth AmericaL3HARRIS TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LHX
SPYJBHT2026-09-160.027096890588.00IndustrialsUNITED STATESUSNorth AmericaHUNT J B TRANSPORT SERVICESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JBHT
SPYJ2026-09-160.0260421412142.00IndustrialsUNITED STATESUSNorth AmericaJACOBS SOLUTIONSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30J
SPYITW2026-09-160.1075863131411.00IndustrialsUNITED STATESUSNorth AmericaILLINOIS TOOL WORKSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ITW
SPYIR2026-09-160.0390684255110.00IndustrialsUNITED STATESUSNorth AmericaINGERSOLL RANDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IR
SPYIEX2026-09-160.025200885237.00IndustrialsUNITED STATESUSNorth AmericaIDEXstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IEX
SPYHWM2026-09-160.1397554775062.00IndustrialsUNITED STATESUSNorth AmericaHOWMET AEROSPACEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HWM
SPYHUBB2026-09-160.035672632150.00IndustrialsUNITED STATESUSNorth AmericaHUBBELLstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HUBB
SPYHON2026-09-160.1011423789728.00IndustrialsUNITED STATESUSNorth AmericaHONEYWELL INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HON
SPYHII2026-09-160.016761468975.00IndustrialsUNITED STATESUSNorth AmericaHUNTINGTON INGALLS INDUSTRIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HII
SPYGWW2026-09-160.084003519461.00IndustrialsUNITED STATESUSNorth AmericaWW GRAINGERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GWW
SPYGPN2026-09-160.0309132781009.00IndustrialsUNITED STATESUSNorth AmericaGLOBAL PAYMENTSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GPN
SPYGNRC2026-09-160.015696697447.00IndustrialsUNITED STATESUSNorth AmericaGENERAC HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GNRC
SPYGE2026-09-160.50116712462560.00IndustrialsUNITED STATESUSNorth AmericaGENERAL ELECTRICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GE
SPYGD2026-09-160.1404573035783.00IndustrialsUNITED STATESUSNorth AmericaGENERAL DYNAMICSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GD
SPYFIX2026-09-160.085728420224.00IndustrialsUNITED STATESUSNorth AmericaCOMFORT SYSTEMS USAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FIX
SPYFERG2026-09-160.0635582307164.00IndustrialsUNITED STATESUSNorth AmericaFERGUSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FERG
SPYFDX2026-09-160.1018072625461.00IndustrialsUNITED STATESUSNorth AmericaFEDEXstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FDX
SPYFAST2026-09-160.08652313730953.00IndustrialsUNITED STATESUSNorth AmericaFASTENALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FAST