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×sector = Basic Materials×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_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
SPYVMC2026-09-160.0487241551864.00Basic MaterialsUNITED STATESUSNorth AmericaVULCAN MATERIALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VMC
SPYSTLD2026-09-160.0496661622148.00Basic MaterialsUNITED STATESUSNorth AmericaSTEEL DYNAMICSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STLD
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
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
SPYNUE2026-09-160.0912592723936.00Basic MaterialsUNITED STATESUSNorth AmericaNUCORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NUE
SPYNEM2026-09-160.19940112742456.00Basic MaterialsUNITED STATESUSNorth AmericaNEWMONTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NEM
SPYMOS2026-09-160.0122023829734.00Basic MaterialsUNITED STATESUSNorth AmericaMOSAICstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MOS
SPYMLM2026-09-160.045854718224.00Basic MaterialsUNITED STATESUSNorth AmericaMARTIN MARIETTA MATERIALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MLM
SPYLYB2026-09-160.0258553099783.00Basic MaterialsUNITED STATESUSNorth AmericaLYONDELLBASELL INDUSTRIES NVstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LYB
SPYIFF2026-09-160.0332023060909.00Basic MaterialsUNITED STATESUSNorth AmericaINTERNATIONAL FLAVORS & FRAGRANCESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IFF
SPYFCX2026-09-160.15300817194414.00Basic MaterialsUNITED STATESUSNorth AmericaFREEPORT-MCMORANstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FCX
SPYECL2026-09-160.1067163029584.00Basic MaterialsUNITED STATESUSNorth AmericaECOLABstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ECL
SPYDOW2026-09-160.0332078589887.00Basic MaterialsUNITED STATESUSNorth AmericaDOWstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DOW
SPYDD2026-09-160.0265961622163.00Basic MaterialsUNITED STATESUSNorth AmericaDUPONT DE NEMOURSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DD
SPYCTVA2026-09-160.0832917999997.00Basic MaterialsUNITED STATESUSNorth AmericaCORTEVAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CTVA
SPYCF2026-09-160.0311701837480.00Basic MaterialsUNITED STATESUSNorth AmericaCF INDUSTRIES HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CF
SPYAPD2026-09-160.0983002664291.00Basic MaterialsUNITED STATESUSNorth AmericaAIR PRODUCTS & CHEMICALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30APD
SPYALB2026-09-160.0198191408695.00Basic MaterialsUNITED STATESUSNorth AmericaALBEMARLEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ALB
IWMWOR2026-09-180.060000814165.00Basic MaterialsUNITED STATESUSNorth AmericaWORTHINGTON INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WOR
IWMWDFC2026-09-180.090000351414.00Basic MaterialsUNITED STATESUSNorth AmericaWD 40stocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WDFC
IWMUSLM2026-09-180.040000284482.00Basic MaterialsUNITED STATESUSNorth AmericaUNITED STATES LIME & MINERALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30USLM
IWMUFPI2026-09-180.1600001488699.00Basic MaterialsUNITED STATESUSNorth AmericaUFP INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UFPI
IWMSXT2026-09-180.1800001113541.00Basic MaterialsUNITED STATESUSNorth AmericaSENSIENT TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SXT
IWMSXC2026-09-180.0300002226883.00Basic MaterialsUNITED STATESUSNorth AmericaSUNCOKE ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SXC
IWMSSRM2026-09-180.2600005713646.00Basic MaterialsUNITED STATESUSNorth AmericaSSR MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SSRM
IWMSLVM2026-09-180.040000894114.00Basic MaterialsUNITED STATESUSNorth AmericaSYLVAMOstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SLVM
IWMSCL2026-09-180.050000572918.00Basic MaterialsUNITED STATESUSNorth AmericaSTEPANstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SCL
IWMPPTA2026-09-180.0600002225644.00Basic MaterialsUNITED STATESUSNorth AmericaPERPETUA RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PPTA
IWMODC2026-09-180.030000258561.00Basic MaterialsUNITED STATESUSNorth AmericaOIL-DRI CORP OF AMERICAstockfalseuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ODC
IWMNGVT2026-09-180.080000918460.00Basic MaterialsUNITED STATESUSNorth AmericaINGEVITYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NGVT
IWMNG2026-09-180.0800008985518.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NG
IWMMUX2026-09-180.0300001345142.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MUX
IWMMTX2026-09-180.070000809410.00Basic MaterialsUNITED STATESUSNorth AmericaMINERALS TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MTX
IWMMTRN2026-09-180.170000542534.00Basic MaterialsUNITED STATESUSNorth AmericaMATERIONstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MTRN
IWMLWLG2026-09-180.0300004134635.00Basic MaterialsUNITED STATESUSNorth AmericaLIGHTWAVE LOGICstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LWLG
IWMKWR2026-09-180.070000360227.00Basic MaterialsUNITED STATESUSNorth AmericaQUAKER CHEMICALstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KWR
IWMKOP2026-09-180.030000474213.00Basic MaterialsUNITED STATESUSNorth AmericaKOPPERS HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KOP
IWMKALU2026-09-180.080000428025.00Basic MaterialsUNITED STATESUSNorth AmericaKAISER ALUMINUMstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KALU
IWMIOSP2026-09-180.080000651552.00Basic MaterialsUNITED STATESUSNorth AmericaINNOSPECstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IOSP
IWMIE2026-09-180.0400003127711.00Basic MaterialsUNITED STATESUSNorth AmericaIVANHOE ELECTRICstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IE
IWMHYMC2026-09-180.0400001410992.00Basic MaterialsUNITED STATESUSNorth AmericaHYCROFT MINING HOLDINGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HYMC
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
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