tax treaties — 4 answered market questions

Median dividend yield by band, gross and net of US withholding: US payers over $1B

most recentas of 2026-10-04 table 4×6read in context →

Median dividend yield by band, gross and net of US withholding: US payers over $1B — 4 rows by 6 columns, computed 2026-10-04 from US exchange, SIP and OPRA data.
yield_band	payers	gross_yield_pct	net_yield_15_pct	net_yield_30_pct	withheld_points_30_pct
under 1.5%	461	0.77	0.65	0.54	0.23
1.5-3%	339	2.28	1.94	1.6	0.68
3-5%	228	3.71	3.15	2.6	1.11
5% and up	164	6.79	5.77	4.75	2.04

the exact SQL behind every number

SELECT multiIf(dividend_yield * 100 >= 5, '5% and up',
               dividend_yield * 100 >= 3, '3-5%',
               dividend_yield * 100 >= 1.5, '1.5-3%',
               'under 1.5%') AS yield_band,
       count() AS payers,
       round(quantileDeterministic(0.5)(toFloat64(dividend_yield) * 100, cityHash64(ticker)), 2) AS gross_yield_pct,
       round(quantileDeterministic(0.5)(toFloat64(dividend_yield) * 100, cityHash64(ticker)) * 0.85, 2) AS net_yield_15_pct,
       round(quantileDeterministic(0.5)(toFloat64(dividend_yield) * 100, cityHash64(ticker)) * 0.70, 2) AS net_yield_30_pct,
       round(quantileDeterministic(0.5)(toFloat64(dividend_yield) * 100, cityHash64(ticker)) * 0.30, 2) AS withheld_points_30_pct
FROM global_markets.stocks_ratios
WHERE date = (SELECT max(date) FROM global_markets.stocks_ratios)
  AND price >= 5
  AND market_cap >= 1000000000
  AND dividend_yield > 0
GROUP BY yield_band
ORDER BY gross_yield_pct

More from this analysisDividend Withholding Tax for Non-US Investors

Latest quarterly dividend, gross and net of US withholding: eight large US payers table 8×5 → Six broad US funds: trailing-year distribution yield, gross and net of withholding table 6×7 → Coca-Cola quarterly dividend since 2021: gross, net at 15%, net at 30% series 23×6 → One Apple dividend per share, in yen, across four account setups table 4×6 → See all 3,256 queries →