STRASMORE/EXPLORE 2,173 QUERIES

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

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from Dividend Withholding Tax for Non-US Investors.

as 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
Rows × columns
4 × 6
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Median dividend yield by band, gross and net of US withholding: US payers over $1B, derived from the stored result.
ColumnTypeRangeNotes
yield_band text 4 distinct values (1.5-3%, 3-5%, 5% and up…)
payers number 164 to 520
gross_yield_pct number 0.72 to 6.64 percent
net_yield_15_pct number 0.61 to 5.64 percent
net_yield_30_pct number 0.5 to 4.64 percent
withheld_points_30_pct number 0.22 to 1.99 percent

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

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 → Highest dividend yields: US-listed companies over $2B, latest snapshot on file table 15×5 → Trailing yield by sector fund: twelve months of distributions ÷ latest price table 13×5 → See all 2,173 queries →