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 = Basic Materials×sorted by as_of ↑×

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-030.0506191585239.00Basic MaterialsUNITED STATESUSNorth AmericaVULCAN MATERIALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VMC
SPYSTLD2026-09-030.0500191656858.00Basic MaterialsUNITED STATESUSNorth AmericaSTEEL DYNAMICSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STLD
SPYSHW2026-09-030.1142622802607.00Basic MaterialsUNITED STATESUSNorth AmericaSHERWIN WILLIAMSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SHW
SPYPPG2026-09-030.0370092723306.00Basic MaterialsUNITED STATESUSNorth AmericaPPG INDUSTRIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PPG
SPYNUE2026-09-030.0896202782676.00Basic MaterialsUNITED STATESUSNorth AmericaNUCORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NUE
SPYNEM2026-09-030.20833713017466.00Basic MaterialsUNITED STATESUSNorth AmericaNEWMONTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NEM
SPYMOS2026-09-030.0122353911614.00Basic MaterialsUNITED STATESUSNorth AmericaMOSAICstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MOS
SPYMLM2026-09-030.045825733799.00Basic MaterialsUNITED STATESUSNorth AmericaMARTIN MARIETTA MATERIALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MLM
SPYLYB2026-09-030.0251623166533.00Basic MaterialsUNITED STATESUSNorth AmericaLYONDELLBASELL INDUSTRIES NVstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LYB
SPYIFF2026-09-030.0331723126769.00Basic MaterialsUNITED STATESUSNorth AmericaINTERNATIONAL FLAVORS & FRAGRANCESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IFF
SPYFCX2026-09-030.15638617564654.00Basic MaterialsUNITED STATESUSNorth AmericaFREEPORT-MCMORANstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FCX
SPYECL2026-09-030.1059453094999.00Basic MaterialsUNITED STATESUSNorth AmericaECOLABstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ECL
SPYDOW2026-09-030.0326918775452.00Basic MaterialsUNITED STATESUSNorth AmericaDOWstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DOW
SPYDD2026-09-030.0266671657318.00Basic MaterialsUNITED STATESUSNorth AmericaDUPONT DE NEMOURSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DD
SPYCTVA2026-09-030.0888668172212.00Basic MaterialsUNITED STATESUSNorth AmericaCORTEVAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CTVA
SPYCF2026-09-030.0317411877085.00Basic MaterialsUNITED STATESUSNorth AmericaCF INDUSTRIES HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CF
SPYAPD2026-09-030.1015992721696.00Basic MaterialsUNITED STATESUSNorth AmericaAIR PRODUCTS & CHEMICALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27APD
SPYALB2026-09-030.0233351438955.00Basic MaterialsUNITED STATESUSNorth AmericaALBEMARLEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ALB
IWMWOR2026-09-050.060000807653.00Basic MaterialsUNITED STATESUSNorth AmericaWORTHINGTON INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WOR
IWMWDFC2026-09-050.090000348598.00Basic MaterialsUNITED STATESUSNorth AmericaWD 40stocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WDFC
IWMUSLM2026-09-050.040000282194.00Basic MaterialsUNITED STATESUSNorth AmericaUNITED STATES LIME & MINERALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27USLM
IWMUFPI2026-09-050.1500001476731.00Basic MaterialsUNITED STATESUSNorth AmericaUFP INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UFPI
IWMSXT2026-09-050.1900001104605.00Basic MaterialsUNITED STATESUSNorth AmericaSENSIENT TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SXT
IWMSXC2026-09-050.0300002209019.00Basic MaterialsUNITED STATESUSNorth AmericaSUNCOKE ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SXC
IWMSSRM2026-09-050.2700005667798.00Basic MaterialsUNITED STATESUSNorth AmericaSSR MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SSRM
IWMSLVM2026-09-050.040000886942.00Basic MaterialsUNITED STATESUSNorth AmericaSYLVAMOstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SLVM
IWMSCL2026-09-050.040000568384.00Basic MaterialsUNITED STATESUSNorth AmericaSTEPANstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SCL
IWMPPTA2026-09-050.0700002207780.00Basic MaterialsUNITED STATESUSNorth AmericaPERPETUA RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PPTA
IWMODC2026-09-050.030000256493.00Basic MaterialsUNITED STATESUSNorth AmericaOIL-DRI CORP OF AMERICAstockfalseuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ODC
IWMNGVT2026-09-050.080000911068.00Basic MaterialsUNITED STATESUSNorth AmericaINGEVITYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NGVT
IWMMTX2026-09-050.070000802898.00Basic MaterialsUNITED STATESUSNorth AmericaMINERALS TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MTX
IWMMTRN2026-09-050.160000538178.00Basic MaterialsUNITED STATESUSNorth AmericaMATERIONstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MTRN
IWMLWLG2026-09-050.0300004101459.00Basic MaterialsUNITED STATESUSNorth AmericaLIGHTWAVE LOGICstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LWLG
IWMKWR2026-09-050.070000357323.00Basic MaterialsUNITED STATESUSNorth AmericaQUAKER CHEMICALstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KWR
IWMKOP2026-09-050.030000470429.00Basic MaterialsUNITED STATESUSNorth AmericaKOPPERS HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KOP
IWMKALU2026-09-050.090000424593.00Basic MaterialsUNITED STATESUSNorth AmericaKAISER ALUMINUMstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KALU
IWMIOSP2026-09-050.070000646316.00Basic MaterialsUNITED STATESUSNorth AmericaINNOSPECstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IOSP
IWMIE2026-09-050.0400003102631.00Basic MaterialsUNITED STATESUSNorth AmericaIVANHOE ELECTRICstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IE
IWMHYMC2026-09-050.0400001399684.00Basic MaterialsUNITED STATESUSNorth AmericaHYCROFT MINING HOLDINGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HYMC
IWMHWKN2026-09-050.080000502418.00Basic MaterialsUNITED STATESUSNorth AmericaHAWKINSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HWKN
IWMHUN2026-09-050.0500004307510.00Basic MaterialsUNITED STATESUSNorth AmericaHUNTSMANstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HUN
IWMHCC2026-09-050.1800001362611.00Basic MaterialsUNITED STATESUSNorth AmericaWARRIOR MET COALstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HCC
IWMGPRE2026-09-050.0300001782999.00Basic MaterialsUNITED STATESUSNorth AmericaGREEN PLAINSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GPRE
IWMFUL2026-09-050.1000001433774.00Basic MaterialsUNITED STATESUSNorth AmericaFULLER H Bstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FUL
IWMFMC2026-09-050.0500003261639.00Basic MaterialsUNITED STATESUSNorth AmericaFMCstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FMC
IWMECVT2026-09-050.0400002833731.00Basic MaterialsUNITED STATESUSNorth AmericaECOVYSTstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ECVT
IWMCMC2026-09-050.2500002893183.00Basic MaterialsUNITED STATESUSNorth AmericaCOMMERCIAL METALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CMC
IWMCENX2026-09-050.1100001800568.00Basic MaterialsUNITED STATESUSNorth AmericaCENTURY ALUMINUMstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CENX
IWMCC2026-09-050.0800003938477.00Basic MaterialsUNITED STATESUSNorth AmericaCHEMOURSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CC
IWMCBT2026-09-050.1400001344857.00Basic MaterialsUNITED STATESUSNorth AmericaCABOTstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CBT