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:continent = North America×etf = XLV×

as_of leads no index, so this sort reads every matching row and keeps only the top 150 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
XLVALGN2026-08-020.196000473737.00HealthcareUNITED STATESUSNorth AmericaALIGN TECHNOLOGYstocktrueuw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ALGN
XLVALGN2026-06-300.196170472209.00HealthcareUNITED STATESUSNorth AmericaALIGN TECHNOLOGYstocktrueuw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ALGN
XLVABT2026-08-023.12100012389353.00HealthcareUNITED STATESUSNorth AmericaABBOTT LABORATORIESstocktrueuw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABT
XLVABT2026-06-302.76003812348978.00HealthcareUNITED STATESUSNorth AmericaABBOTT LABORATORIESstocktrueuw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABT
XLVABBV2026-08-027.71600012567115.00HealthcareUNITED STATESUSNorth AmericaABBVIEstocktrueuw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABBV
XLVABBV2026-06-307.76396412526178.00HealthcareUNITED STATESUSNorth AmericaABBVIEstocktrueuw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABBV
XLVA2026-08-020.6650002010121.00HealthcareUNITED STATESUSNorth AmericaAGILENT TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27A
XLVA2026-06-300.6555282003593.00HealthcareUNITED STATESUSNorth AmericaAGILENT TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27A