STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Dividend Withholding Tax for Non-US Investors
Median dividend yield by band, gross and net of US withholding: US payers over $1Btable · 2026-08-22 · 4×6 Coca-Cola quarterly dividend since 2021: gross, net at 15%, net at 30%series · 2026-08-22 · 22×6Preview: a 16-point series, ending higher. Latest quarterly dividend, gross and net of US withholding: eight large US payerstable · 2026-08-22 · 8×5 Six broad US funds: trailing-year distribution yield, gross and net of withholdingtable · 2026-08-22 · 6×7
Median dividend yield by band, gross and net of US withholding: US payers over $1B

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

most recentas of 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 from US exchange, SIP and OPRA data.
yield_bandpayersgross_yield_pctnet_yield_15_pctnet_yield_30_pctwithheld_points_30_pct
under 1.5%5200.720.610.50.22
1.5-3%3672.261.921.580.68
3-5%2193.713.152.61.11
5% and up1646.645.644.641.99
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 22×6 → Monthly dividend stocks - filing companies paying every month, ranked by daily traded value table 29×6 → See all 2,173 queries →
$