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:continent = North America×endpoint = /api/etfs/XLI/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
XLIXYL2026-06-300.4857171395554.00IndustrialsUNITED STATESUSNorth AmericaXYLEMstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XYL
XLIWM2026-06-301.4234322169117.00IndustrialsUNITED STATESUSNorth AmericaWASTE MANAGEMENTstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WM
XLIWAB2026-06-300.790796996236.00IndustrialsUNITED STATESUSNorth AmericaWESTINGHOUSE AIR BRAKE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WAB
XLIVRT2026-06-302.2232702255268.00IndustrialsUNITED STATESUSNorth AmericaVERTIV HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VRT
XLIVRSK2026-06-300.406635769281.00IndustrialsUNITED STATESUSNorth AmericaVERISK ANALYTICSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VRSK
XLIURI2026-06-301.226887367819.00IndustrialsUNITED STATESUSNorth AmericaUNITED RENTALSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27URI
XLIUPS2026-06-301.3874544383565.00IndustrialsUNITED STATESUSNorth AmericaUNITED PARCEL SERVICEstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UPS
XLIUNP2026-06-302.7916823485896.00IndustrialsUNITED STATESUSNorth AmericaUNION PACIFICstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UNP
XLIUBER2026-06-302.53927511951724.00TechnologyUNITED STATESUSNorth AmericaUBERstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UBER
XLIUAL2026-06-300.7630281905684.00IndustrialsUNITED STATESUSNorth AmericaUNITED AIRLINES HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UAL
XLITXT2026-06-300.2759401021695.00IndustrialsUNITED STATESUSNorth AmericaTEXTRONstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TXT
XLITDG2026-06-301.288044328421.00IndustrialsUNITED STATESUSNorth AmericaTRANSDIGM GROUPstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TDG
XLISWK2026-06-300.252928912709.00IndustrialsUNITED STATESUSNorth AmericaSTANLEY BLACK & DECKERstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SWK
XLISNA2026-06-300.360648304399.00IndustrialsUNITED STATESUSNorth AmericaSNAP-ONstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SNA
XLIRTX2026-06-304.4169507906857.00IndustrialsUNITED STATESUSNorth AmericaRAYTHEON TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RTX
XLIRSG2026-06-300.7366791174230.00IndustrialsUNITED STATESUSNorth AmericaREPUBLIC SERVICESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RSG
XLIROL2026-06-300.2108971716068.00Consumer CyclicalUNITED STATESUSNorth AmericaROLLINSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ROL
XLIROK2026-06-300.952337653330.00IndustrialsUNITED STATESUSNorth AmericaROCKWELL AUTOMATIONstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ROK
XLIPWR2026-06-301.867606881074.00IndustrialsUNITED STATESUSNorth AmericaQUANTA SERVICESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PWR
XLIPH2026-06-302.132063740330.00IndustrialsUNITED STATESUSNorth AmericaPARKER HANNIFINstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PH
XLIPCAR2026-06-301.0928513090033.00IndustrialsUNITED STATESUSNorth AmericaPACCARstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PCAR
XLIPAYX2026-06-300.5477571891992.00IndustrialsUNITED STATESUSNorth AmericaPAYCHEXstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PAYX
XLIOTIS2026-06-300.4749562252983.00IndustrialsUNITED STATESUSNorth AmericaOTIS WORLDWIDEstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27OTIS
XLIODFL2026-06-300.6852631074524.00IndustrialsUNITED STATESUSNorth AmericaOLD DOMINION FREIGHT LINEstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ODFL
XLINSC2026-06-301.2214181318672.00IndustrialsUNITED STATESUSNorth AmericaNORFOLK SOUTHERNstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NSC
XLINOC2026-06-301.175521783909.00IndustrialsUNITED STATESUSNorth AmericaNORTHROP GRUMMANstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NOC
XLINDSN2026-06-300.276390311157.00IndustrialsUNITED STATESUSNorth AmericaNORDSONstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NDSN
XLIMMM2026-06-301.4598713062373.00IndustrialsUNITED STATESUSNorth America3Mstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MMM
XLIMAS2026-06-300.2852251190532.00IndustrialsUNITED STATESUSNorth AmericaMASCOstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MAS
XLILUV2026-06-300.4344692869752.00IndustrialsUNITED STATESUSNorth AmericaSOUTHWEST AIRLINESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LUV
XLILMT2026-06-301.7869441191292.00IndustrialsUNITED STATESUSNorth AmericaLOCKHEED MARTINstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LMT
XLILII2026-06-300.313674185943.00IndustrialsUNITED STATESUSNorth AmericaLENNOX INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LII
XLILHX2026-06-300.9357721093722.00IndustrialsUNITED STATESUSNorth AmericaL3HARRIS TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LHX
XLILDOS2026-06-300.223903738527.00TechnologyUNITED STATESUSNorth AmericaLEIDOS HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LDOS
XLIJBHT2026-06-300.373597438407.00IndustrialsUNITED STATESUSNorth AmericaHUNT J B TRANSPORT SERVICESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27JBHT
XLIJ2026-06-300.257209693320.00IndustrialsUNITED STATESUSNorth AmericaJACOBS SOLUTIONSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27J
XLIITW2026-06-301.2230531535831.00IndustrialsUNITED STATESUSNorth AmericaILLINOIS TOOL WORKSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ITW
XLIIR2026-06-300.5047372090846.00IndustrialsUNITED STATESUSNorth AmericaINGERSOLL RANDstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IR
XLIIEX2026-06-300.290403434598.00IndustrialsUNITED STATESUSNorth AmericaIDEXstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IEX
XLIHWM2026-06-301.8597962349398.00IndustrialsUNITED STATESUSNorth AmericaHOWMET AEROSPACEstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HWM
XLIHUBB2026-06-300.477951310265.00IndustrialsUNITED STATESUSNorth AmericaHUBBELLstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HUBB
XLIHON2026-06-301.2258761859559.00IndustrialsUNITED STATESUSNorth AmericaHONEYWELL INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HON
XLIHII2026-06-300.190630231324.00IndustrialsUNITED STATESUSNorth AmericaHUNTINGTON INGALLS INDUSTRIESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HII
XLIGWW2026-06-301.021521255034.00IndustrialsUNITED STATESUSNorth AmericaWW GRAINGERstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GWW
XLIGNRC2026-06-300.297980345636.00IndustrialsUNITED STATESUSNorth AmericaGENERAC HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GNRC
XLIGE2026-06-306.7407166125838.00IndustrialsUNITED STATESUSNorth AmericaGENERAL ELECTRICstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GE
XLIGD2026-06-301.5543541490286.00IndustrialsUNITED STATESUSNorth AmericaGENERAL DYNAMICSstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GD
XLIFTV2026-06-300.3219561789962.00TechnologyUNITED STATESUSNorth AmericaFORTIVEstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FTV
XLIFIX2026-06-301.204188206357.00IndustrialsUNITED STATESUSNorth AmericaCOMFORT SYSTEMS USAstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FIX
XLIFDX2026-06-301.1883061288905.00IndustrialsUNITED STATESUSNorth AmericaFEDEXstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FDX