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:etf = SPY×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_of ↑datevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
SPYVMC2026-09-030.0506191585239.00Basic MaterialsUNITED STATESUSNorth AmericaVULCAN MATERIALSstocktrue——uw_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 DYNAMICSstocktrue——uw_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 WILLIAMSstocktrue——uw_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 INDUSTRIESstocktrue——uw_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 AmericaNUCORstocktrue——uw_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 AmericaNEWMONTstocktrue——uw_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 AmericaMOSAICstocktrue——uw_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 MATERIALSstocktrue——uw_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 NVstocktrue——uw_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 KINGDOMGBEuropeLINDEstocktrue——uw_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 & FRAGRANCESstocktrue——uw_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-MCMORANstocktrue——uw_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 AmericaECOLABstocktrue——uw_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 AmericaDOWstocktrue——uw_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 NEMOURSstocktrue——uw_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 AmericaCORTEVAstocktrue——uw_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 LTDstocktrue——uw_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 HOLDINGSstocktrue——uw_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 & CHEMICALSstocktrue——uw_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 AmericaALBEMARLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ALB
SPYVMC2026-09-040.0512711582914.00Basic MaterialsUNITED STATESUSNorth AmericaVULCAN MATERIALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30VMC
SPYSTLD2026-09-040.0493901654440.00Basic MaterialsUNITED STATESUSNorth AmericaSTEEL DYNAMICSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30STLD
SPYSHW2026-09-040.1151752798484.00Basic MaterialsUNITED STATESUSNorth AmericaSHERWIN WILLIAMSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30SHW
SPYPPG2026-09-040.0377392719307.00Basic MaterialsUNITED STATESUSNorth AmericaPPG INDUSTRIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PPG
SPYNUE2026-09-040.0894642778584.00Basic MaterialsUNITED STATESUSNorth AmericaNUCORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30NUE
SPYNEM2026-09-040.20533812998308.00Basic MaterialsUNITED STATESUSNorth AmericaNEWMONTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30NEM
SPYMOS2026-09-040.0124523905910.00Basic MaterialsUNITED STATESUSNorth AmericaMOSAICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30MOS
SPYMLM2026-09-040.046517732714.00Basic MaterialsUNITED STATESUSNorth AmericaMARTIN MARIETTA MATERIALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30MLM
SPYLYB2026-09-040.0247703161883.00Basic MaterialsUNITED STATESUSNorth AmericaLYONDELLBASELL INDUSTRIES NVstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30LYB
SPYLIN2026-09-040.3317195632030.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30LIN
SPYIFF2026-09-040.0332503122181.00Basic MaterialsUNITED STATESUSNorth AmericaINTERNATIONAL FLAVORS & FRAGRANCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30IFF
SPYFCX2026-09-040.15732017538862.00Basic MaterialsUNITED STATESUSNorth AmericaFREEPORT-MCMORANstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30FCX
SPYECL2026-09-040.1064463090442.00Basic MaterialsUNITED STATESUSNorth AmericaECOLABstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30ECL
SPYDOW2026-09-040.0318158762525.00Basic MaterialsUNITED STATESUSNorth AmericaDOWstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30DOW
SPYDD2026-09-040.0268571654869.00Basic MaterialsUNITED STATESUSNorth AmericaDUPONT DE NEMOURSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30DD
SPYCTVA2026-09-040.0884228160215.00Basic MaterialsUNITED STATESUSNorth AmericaCORTEVAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30CTVA
SPYCRH2026-09-040.0947698152089.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30CRH
SPYCF2026-09-040.0308251874326.00Basic MaterialsUNITED STATESUSNorth AmericaCF INDUSTRIES HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30CF
SPYAPD2026-09-040.1009782717697.00Basic MaterialsUNITED STATESUSNorth AmericaAIR PRODUCTS & CHEMICALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30APD
SPYALB2026-09-040.0223781436847.00Basic MaterialsUNITED STATESUSNorth AmericaALBEMARLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30ALB
SPYVMC2026-09-080.0507201585389.00Basic MaterialsUNITED STATESUSNorth AmericaVULCAN MATERIALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30VMC
SPYSTLD2026-09-080.0493191657014.00Basic MaterialsUNITED STATESUSNorth AmericaSTEEL DYNAMICSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30STLD
SPYSHW2026-09-080.1132022802873.00Basic MaterialsUNITED STATESUSNorth AmericaSHERWIN WILLIAMSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30SHW
SPYPPG2026-09-080.0370122723564.00Basic MaterialsUNITED STATESUSNorth AmericaPPG INDUSTRIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30PPG
SPYNUE2026-09-080.0883762782940.00Basic MaterialsUNITED STATESUSNorth AmericaNUCORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30NUE
SPYNEM2026-09-080.20492413018702.00Basic MaterialsUNITED STATESUSNorth AmericaNEWMONTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30NEM
SPYMOS2026-09-080.0128543911982.00Basic MaterialsUNITED STATESUSNorth AmericaMOSAICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30MOS
SPYMLM2026-09-080.046536733869.00Basic MaterialsUNITED STATESUSNorth AmericaMARTIN MARIETTA MATERIALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30MLM
SPYLYB2026-09-080.0253343166833.00Basic MaterialsUNITED STATESUSNorth AmericaLYONDELLBASELL INDUSTRIES NVstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30LYB
SPYLIN2026-09-080.3272355640874.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30LIN