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×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
SPYLIN2026-09-030.3337235640338.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LIN
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
SPYCRH2026-09-030.0922038164086.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CRH
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
QQQLIN2026-09-030.9829739948511.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LIN
IWMWS2026-09-050.040000857681.00Basic MaterialsWorthington Steelstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WS
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
IWMUSAR2026-09-050.1100004969429.00Basic MaterialsUSA Rare Earthstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27USAR
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
IWMPRM2026-09-050.1600003890243.00Basic MaterialsLUXEMBOURGLUEuropePERIMETER SOLUTIONS SAstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PRM
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
IWMNPKI2026-09-050.0300002103851.00Basic MaterialsNewparkstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NPKI
IWMNP2026-09-050.040000976813.00Basic MaterialsNEPTUNE INSURANCE HOLDINGS INCstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NP
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
IWMNG2026-09-050.0900008913402.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NG
IWMMUX2026-09-050.0300001334362.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MUX
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
IWMKNF2026-09-050.1100001483307.00Basic MaterialsKNIFE RIVER HOLDINGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KNF
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