ETF sector and country weights

core.etf_weights

One row per (etf, dimension, label). Five labels belong to more than one taxonomy, so weights within a dimension can exceed 1 - see app/core/etf_taxonomy.py.

5,511 rowsCSV — whole table, not this view

Sources in this table

uw_etf_weights5,511 rowsexportable

active:dimension = country×etf = SMH×source = uw_etf_weights×

etftext	dimensiontext	labeltext	as_of ↓date	weight_fractionnumeric	sourcetext	endpointtext	request_paramsjsonb	vintage_ts

SMH	country	United States	2026-09-25	0.777800000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-25 16:30	2026-09-25 16:30
SMH	country	Taiwan, Province of China	2026-09-25	0.110200000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-25 16:30	2026-09-25 16:30
SMH	country	Taiwan (Province of China)	2026-09-25	0.129700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-25 16:30	2026-09-25 16:30
SMH	country	Taiwan	2026-09-25	0.145300000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-25 16:30	2026-09-25 16:30
SMH	country	Switzerland	2026-09-25	0.009000000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-25 16:30	2026-09-25 16:30
SMH	country	Other	2026-09-25	-0.000400000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-25 16:30	2026-09-25 16:30
SMH	country	Netherlands	2026-09-25	0.067900000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-25 16:30	2026-09-25 16:30
SMH	country	France	2026-09-25	0.024700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-25 16:30	2026-09-25 16:30
SMH	country	United States	2026-09-24	0.777800000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-24 16:30	2026-09-24 16:30
SMH	country	Taiwan, Province of China	2026-09-24	0.110200000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-24 16:30	2026-09-24 16:30
SMH	country	Taiwan (Province of China)	2026-09-24	0.129700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-24 16:30	2026-09-24 16:30
SMH	country	Taiwan	2026-09-24	0.145300000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-24 16:30	2026-09-24 16:30
SMH	country	Switzerland	2026-09-24	0.009000000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-24 16:30	2026-09-24 16:30
SMH	country	Other	2026-09-24	-0.000400000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-24 16:30	2026-09-24 16:30
SMH	country	Netherlands	2026-09-24	0.067900000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-24 16:30	2026-09-24 16:30
SMH	country	France	2026-09-24	0.024700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-24 16:30	2026-09-24 16:30
SMH	country	United States	2026-09-23	0.777800000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-23 16:30	2026-09-23 16:30
SMH	country	Taiwan, Province of China	2026-09-23	0.110200000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-23 16:30	2026-09-23 16:30
SMH	country	Taiwan (Province of China)	2026-09-23	0.129700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-23 16:30	2026-09-23 16:30
SMH	country	Taiwan	2026-09-23	0.145300000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-23 16:30	2026-09-23 16:30
SMH	country	Switzerland	2026-09-23	0.009000000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-23 16:30	2026-09-23 16:30
SMH	country	Other	2026-09-23	-0.000400000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-23 16:30	2026-09-23 16:30
SMH	country	Netherlands	2026-09-23	0.067900000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-23 16:30	2026-09-23 16:30
SMH	country	France	2026-09-23	0.024700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-23 16:30	2026-09-23 16:30
SMH	country	United States	2026-09-22	0.777800000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-22 16:30	2026-09-22 16:30
SMH	country	Taiwan, Province of China	2026-09-22	0.110200000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-22 16:30	2026-09-22 16:30
SMH	country	Taiwan (Province of China)	2026-09-22	0.129700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-22 16:30	2026-09-22 16:30
SMH	country	Taiwan	2026-09-22	0.145300000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-22 16:30	2026-09-22 16:30
SMH	country	Switzerland	2026-09-22	0.009000000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-22 16:30	2026-09-22 16:30
SMH	country	Other	2026-09-22	-0.000400000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-22 16:30	2026-09-22 16:30
SMH	country	Netherlands	2026-09-22	0.067900000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-22 16:30	2026-09-22 16:30
SMH	country	France	2026-09-22	0.024700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-22 16:30	2026-09-22 16:30
SMH	country	United States	2026-09-21	0.777800000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-21 16:30	2026-09-21 16:30
SMH	country	Taiwan, Province of China	2026-09-21	0.110200000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-21 16:30	2026-09-21 16:30
SMH	country	Taiwan (Province of China)	2026-09-21	0.129700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-21 16:30	2026-09-21 16:30
SMH	country	Taiwan	2026-09-21	0.145300000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-21 16:30	2026-09-21 16:30
SMH	country	Switzerland	2026-09-21	0.009000000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-21 16:30	2026-09-21 16:30
SMH	country	Other	2026-09-21	-0.000400000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-21 16:30	2026-09-21 16:30
SMH	country	Netherlands	2026-09-21	0.067900000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-21 16:30	2026-09-21 16:30
SMH	country	France	2026-09-21	0.024700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-21 16:30	2026-09-21 16:30
SMH	country	United States	2026-09-18	0.777800000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-18 16:30	2026-09-18 16:30
SMH	country	Taiwan, Province of China	2026-09-18	0.110200000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-18 16:30	2026-09-18 16:30
SMH	country	Taiwan (Province of China)	2026-09-18	0.129700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-18 16:30	2026-09-18 16:30
SMH	country	Taiwan	2026-09-18	0.145300000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-18 16:30	2026-09-18 16:30
SMH	country	Switzerland	2026-09-18	0.009000000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-18 16:30	2026-09-18 16:30
SMH	country	Other	2026-09-18	-0.000400000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-18 16:30	2026-09-18 16:30
SMH	country	Netherlands	2026-09-18	0.067900000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-18 16:30	2026-09-18 16:30
SMH	country	France	2026-09-18	0.024700000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-18 16:30	2026-09-18 16:30
SMH	country	United States	2026-09-17	0.777800000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-17 16:30	2026-09-17 16:30
SMH	country	Taiwan, Province of China	2026-09-17	0.110200000000	uw_etf_weights	/api/etfs/SMH/weights	{}	2026-09-17 16:30	2026-09-17 16:30