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 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
SPYLIN2026-09-160.3278845521078.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LIN
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
SPYCRH2026-09-160.0890517991871.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CRH
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
QQQLIN2026-09-160.9606919847646.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LIN
IWMWS2026-09-180.040000864633.00Basic MaterialsWorthington Steelstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WS
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
IWMUSAR2026-09-180.1000005009645.00Basic MaterialsUSA Rare Earthstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30USAR
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
IWMPRM2026-09-180.1600003921703.00Basic MaterialsLUXEMBOURGLUEuropePERIMETER SOLUTIONS SAstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PRM
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
IWMNPKI2026-09-180.0400002120879.00Basic MaterialsNewparkstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NPKI
IWMNP2026-09-180.040000984733.00Basic MaterialsNEPTUNE INSURANCE HOLDINGS INCstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NP
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
IWMKNF2026-09-180.1100001495319.00Basic MaterialsKNIFE RIVER HOLDINGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KNF
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