singapore — 4 answered market questions

Twelve months of dividends per share, gross and after 30% US withholding

most recentas of 2026-11-07 ranking 6×3read in context →

Twelve months of dividends per share, gross and after 30% US withholding — 6 rows by 3 columns, computed 2026-11-07 from US exchange, SIP and OPRA data.
ticker	gross_per_share_usd	net_after_30_pct_usd
JNJ	5.28	3.7
PG	4.29	3
XOM	4.12	2.88
MSFT	3.64	2.55
KO	2.08	1.46
AAPL	1.06	0.74

the exact SQL behind every number

WITH paid AS
(
    SELECT
        ticker,
        ex_dividend_date,
        max(cash_amount) AS cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'JNJ', 'PG', 'KO', 'XOM')
      AND currency = 'USD'
      AND ex_dividend_date >= toDate('2025-09-01')
      AND ex_dividend_date <  toDate('2026-09-01')
    GROUP BY ticker, ex_dividend_date
)
SELECT
    ticker,
    round(sum(cash_amount), 2)        AS gross_per_share_usd,
    round(sum(cash_amount) * 0.70, 2) AS net_after_30_pct_usd
FROM paid
GROUP BY ticker
ORDER BY gross_per_share_usd DESC

More from this analysisUS Stock Market Hours in Singapore Time

SPY volume by Singapore half hour: US winter month vs US summer month series 34×3 → Upcoming US closures, with the early-close finish in Singapore time series 12×6 → Every US clock change since 2022, detected from the opening print series 10×5 → SPY volume by clock hour, New York and Dubai (1 to 25 September 2026) ranking 16×4 → See all 3,293 queries →