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_name = UNITED STATES×etf = DIA×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
DIAWMT2026-06-301.3102555097433.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMT
DIAV2026-06-303.9690565097433.00Financial ServicesUNITED STATESUSNorth AmericaVISAstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27V
DIAUNH2026-06-304.8082395097433.00HealthcareUNITED STATESUSNorth AmericaUNITEDHEALTH GROUPstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UNH
DIATRV2026-06-303.8190125097433.00Financial ServicesUNITED STATESUSNorth AmericaTRAVELERS COMPANIESstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TRV
DIASHW2026-06-303.9832855097433.00Basic MaterialsUNITED STATESUSNorth AmericaSHERWIN WILLIAMSstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SHW
DIAPG2026-06-301.6964135097433.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PG
DIANVDA2026-06-302.3147525097433.00TechnologyUNITED STATESUSNorth AmericaNVIDIAstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NVDA
DIANKE2026-06-300.4748895097433.00Consumer CyclicalUNITED STATESUSNorth AmericaNIKEstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NKE
DIAMSFT2026-06-304.3153035097433.00TechnologyUNITED STATESUSNorth AmericaMICROSOFTstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MSFT
DIAMRK2026-06-301.4865605097433.00HealthcareUNITED STATESUSNorth AmericaMERCK & COstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MRK
DIAMMM2026-06-301.8730655097433.00IndustrialsUNITED STATESUSNorth America3Mstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MMM
DIAMCD2026-06-303.1270965097433.00Consumer CyclicalUNITED STATESUSNorth AmericaMCDONALDSstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MCD
DIAKO2026-06-300.9401775097433.00Consumer DefensiveUNITED STATESUSNorth AmericaCOCA COLAstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KO
DIAJPM2026-06-303.7867365097433.00Financial ServicesUNITED STATESUSNorth AmericaJPMORGAN CHASEstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27JPM
DIAJNJ2026-06-302.9380665097433.00HealthcareUNITED STATESUSNorth AmericaJOHNSON & JOHNSONstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27JNJ
DIAIBM2026-06-303.2531945097433.00TechnologyUNITED STATESUSNorth AmericaIBMstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IBM
DIAHON2026-06-302.5902005097433.00IndustrialsUNITED STATESUSNorth AmericaHONEYWELL INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HON
DIAHD2026-06-304.0799985097433.00Consumer CyclicalUNITED STATESUSNorth AmericaHOME DEPOTstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HD
DIAGS2026-06-3011.7000915097433.00Financial ServicesUNITED STATESUSNorth AmericaGOLDMAN SACHS GROUPstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GS
DIAGOOGL2026-06-304.1342555097433.00Communication ServicesUNITED STATESUSNorth AmericaALPHABETstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GOOGL
DIADIS2026-06-301.1134745097433.00Communication ServicesUNITED STATESUSNorth AmericaWALT DISNEYstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DIS
DIACVX2026-06-301.9176045097433.00EnergyUNITED STATESUSNorth AmericaCHEVRONstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CVX
DIACSCO2026-06-301.3588435097433.00TechnologyUNITED STATESUSNorth AmericaCISCO SYSTEMSstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CSCO
DIACRM2026-06-301.8123305097433.00TechnologyUNITED STATESUSNorth AmericaSALESFORCEstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CRM
DIACAT2026-06-3012.3193565097433.00IndustrialsUNITED STATESUSNorth AmericaCATERPILLARstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CAT
DIABA2026-06-302.5042455097433.00IndustrialsUNITED STATESUSNorth AmericaBOEINGstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BA
DIAAXP2026-06-303.9130645097433.00Financial ServicesUNITED STATESUSNorth AmericaAMERICAN EXPRESSstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AXP
DIAAMZN2026-06-302.7572505097433.00Consumer CyclicalUNITED STATESUSNorth AmericaAMAZON stocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AMZN
DIAAMGN2026-06-304.1892065097433.00HealthcareUNITED STATESUSNorth AmericaAMGENstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AMGN
DIAAAPL2026-06-303.3474775097433.00TechnologyUNITED STATESUSNorth AmericaAPPLEstocktrue——uw_etf_holdings/api/etfs/DIA/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AAPL