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

Two Decades of Rising Dividends
How a two-decade streak compounds: Microsoft's annual dividend, year by yearranking · 2026-08-22 · 22×2Preview: 16 ranked values, smallest first. Dividend growth champions: 20+ straight years of raises, ranked by how many times over the payout grewranking · 2026-08-22 · 20×3Preview: 16 ranked values, largest first.
How a two-decade streak compounds: Microsoft's annual dividend, year by year

How a two-decade streak compounds: Microsoft's annual dividend, year by year

most recentas of ranking 22×2read in context →
How a two-decade streak compounds: Microsoft's annual dividend, year by year — 22 rows by 2 columns, computed from US exchange, SIP and OPRA data.
yearannual_dividend
20040.08
20050.32
20060.37
20070.41
20080.46
20090.52
20100.55
20110.68
20120.83
20130.97
20141.15
20151.29
20161.47
20171.59
20181.72
20191.89
20202.09
20212.3
20222.54
20232.79
20243.08
20253.4
the exact SQL behind every number
SELECT toYear(ex_dividend_date) AS year,
       round(sum(cash_amount), 4) AS annual_dividend
FROM global_markets.stocks_dividends
WHERE ticker = 'MSFT'
  AND frequency IN (1, 2, 4, 12)
  AND ex_dividend_date >= '2004-01-01'
  AND ex_dividend_date < toStartOfYear(today())
GROUP BY year
ORDER BY year
$