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:sector = Basic Materials×

as_of leads no index, so this sort reads every matching row and keeps only the top 100 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
IWMHWKN2026-09-180.080000506466.00Basic MaterialsUNITED STATESUSNorth AmericaHAWKINSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HWKN
IWMHUN2026-09-180.0500004342358.00Basic MaterialsUNITED STATESUSNorth AmericaHUNTSMANstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HUN
IWMHCC2026-09-180.1600001373655.00Basic MaterialsUNITED STATESUSNorth AmericaWARRIOR MET COALstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HCC
IWMGPRE2026-09-180.0300001797431.00Basic MaterialsUNITED STATESUSNorth AmericaGREEN PLAINSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GPRE
IWMGOLD2026-09-180.030000520760.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GOLD
IWMFUL2026-09-180.0900001445390.00Basic MaterialsUNITED STATESUSNorth AmericaFULLER H Bstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FUL
IWMFMC2026-09-180.0500003288039.00Basic MaterialsUNITED STATESUSNorth AmericaFMCstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FMC
IWMECVT2026-09-180.0400002856655.00Basic MaterialsUNITED STATESUSNorth AmericaECOVYSTstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ECVT
IWMCSTM2026-09-180.1200003511008.00Basic MaterialsFRANCEFREuropeCONSTELLIUM SEstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CSTM
IWMCMC2026-09-180.2500002916591.00Basic MaterialsUNITED STATESUSNorth AmericaCOMMERCIAL METALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CMC
IWMCENX2026-09-180.0900001815132.00Basic MaterialsUNITED STATESUSNorth AmericaCENTURY ALUMINUMstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CENX
IWMCC2026-09-180.0700003970333.00Basic MaterialsUNITED STATESUSNorth AmericaCHEMOURSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CC
IWMCBT2026-09-180.1400001355725.00Basic MaterialsUNITED STATESUSNorth AmericaCABOTstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CBT
IWMBCPC2026-09-180.180000842860.00Basic MaterialsUNITED STATESUSNorth AmericaBALCHEMstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BCPC
IWMBCC2026-09-180.090000942962.00Basic MaterialsUNITED STATESUSNorth AmericaBOISE CASCADEstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BCC
IWMAVNT2026-09-180.1300002417902.00Basic MaterialsUNITED STATESUSNorth AmericaAVIENTstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AVNT
IWMASH2026-09-180.1100001199232.00Basic MaterialsUNITED STATESUSNorth AmericaASHLANDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ASH
IWMAMR2026-09-180.070000277125.00Basic MaterialsUNITED STATESUSNorth AmericaALPHA METALLURGICAL RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AMR
SPYVMC2026-09-150.0494811561764.00Basic MaterialsUNITED STATESUSNorth AmericaVULCAN MATERIALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30VMC
SPYSTLD2026-09-150.0496491632444.00Basic MaterialsUNITED STATESUSNorth AmericaSTEEL DYNAMICSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30STLD
SPYSHW2026-09-150.1134582760978.00Basic MaterialsUNITED STATESUSNorth AmericaSHERWIN WILLIAMSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SHW
SPYPPG2026-09-150.0357782682929.00Basic MaterialsUNITED STATESUSNorth AmericaPPG INDUSTRIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PPG
SPYNUE2026-09-150.0902062741360.00Basic MaterialsUNITED STATESUSNorth AmericaNUCORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NUE
SPYNEM2026-09-150.20248112824032.00Basic MaterialsUNITED STATESUSNorth AmericaNEWMONTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NEM
SPYMOS2026-09-150.0124753854022.00Basic MaterialsUNITED STATESUSNorth AmericaMOSAICstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MOS
SPYMLM2026-09-150.046576722844.00Basic MaterialsUNITED STATESUSNorth AmericaMARTIN MARIETTA MATERIALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MLM
SPYLYB2026-09-150.0259513119583.00Basic MaterialsUNITED STATESUSNorth AmericaLYONDELLBASELL INDUSTRIES NVstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LYB
SPYLIN2026-09-150.3270515556454.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LIN
SPYIFF2026-09-150.0329923080445.00Basic MaterialsUNITED STATESUSNorth AmericaINTERNATIONAL FLAVORS & FRAGRANCESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30IFF
SPYFCX2026-09-150.15263717304238.00Basic MaterialsUNITED STATESUSNorth AmericaFREEPORT-MCMORANstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30FCX
SPYECL2026-09-150.1064463048988.00Basic MaterialsUNITED STATESUSNorth AmericaECOLABstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ECL
SPYDOW2026-09-150.0328088644931.00Basic MaterialsUNITED STATESUSNorth AmericaDOWstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30DOW
SPYDD2026-09-150.0265761632591.00Basic MaterialsUNITED STATESUSNorth AmericaDUPONT DE NEMOURSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30DD
SPYCTVA2026-09-150.0853588051081.00Basic MaterialsUNITED STATESUSNorth AmericaCORTEVAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CTVA
SPYCRH2026-09-150.0896688042955.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CRH
SPYCF2026-09-150.0318661849228.00Basic MaterialsUNITED STATESUSNorth AmericaCF INDUSTRIES HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CF
SPYAPD2026-09-150.0990512681319.00Basic MaterialsUNITED STATESUSNorth AmericaAIR PRODUCTS & CHEMICALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30APD
SPYALB2026-09-150.0204481417671.00Basic MaterialsUNITED STATESUSNorth AmericaALBEMARLEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ALB
QQQLIN2026-09-150.9627519827206.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LIN
IWMWS2026-09-170.040000882961.00Basic MaterialsWorthington Steelstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WS
IWMWOR2026-09-170.060000831333.00Basic MaterialsUNITED STATESUSNorth AmericaWORTHINGTON INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WOR
IWMWDFC2026-09-170.090000358838.00Basic MaterialsUNITED STATESUSNorth AmericaWD 40stocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WDFC
IWMUSLM2026-09-170.040000290514.00Basic MaterialsUNITED STATESUSNorth AmericaUNITED STATES LIME & MINERALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30USLM
IWMUSAR2026-09-170.1000005115669.00Basic MaterialsUSA Rare Earthstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30USAR
IWMUFPI2026-09-170.1600001520251.00Basic MaterialsUNITED STATESUSNorth AmericaUFP INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30UFPI
IWMSXT2026-09-170.1800001137089.00Basic MaterialsUNITED STATESUSNorth AmericaSENSIENT TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SXT
IWMSXC2026-09-170.0300002273979.00Basic MaterialsUNITED STATESUSNorth AmericaSUNCOKE ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SXC
IWMSSRM2026-09-170.2600005834518.00Basic MaterialsUNITED STATESUSNorth AmericaSSR MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SSRM
IWMSLVM2026-09-170.040000913022.00Basic MaterialsUNITED STATESUSNorth AmericaSYLVAMOstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SLVM
IWMSCL2026-09-170.050000584982.00Basic MaterialsUNITED STATESUSNorth AmericaSTEPANstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SCL