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

2,170 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.
AAPL Dividend History: Splits and Raises
Every AAPL stock split and the running share countseries · 2026-08-22 · 3×5Preview: a 3-point series, ending higher. AAPL quarterly dividend by year, split adjusted, with the annual stepranking · 2026-08-22 · 14×3Preview: 14 ranked values, smallest first. AAPL dividends paid against free cash flow, by fiscal yearranking · 2026-08-22 · 13×4Preview: 13 ranked values, smallest first. Longest gaps between consecutive AAPL dividend payments, in yearsranking · 2026-08-22 · 6×4Preview: 6 ranked values, largest first. Every AAPL dividend year, as declared and split adjustedranking · 2026-08-22 · 15×4Preview: 15 ranked values, largest first.
When Companies Announce Dividend Raises
Share of annual raises declared in the same month as the prior raise, by yearranking · 2026-08-03 · 10×4Preview: 10 ranked values, smallest first. Dividend raises by declaration month: US recurring quarterly payers, July 2015 to July 2026ranking · 2026-08-03 · 12×3Preview: 12 ranked values, largest first. JNJ dividend raises: declaration date, old rate, new rate, 2016 to 2026table · 2026-08-03 · 11×5 Typical raise month by company: twelve dividend growers, raises since 2016series · 2026-08-03 · 12×5Preview: a 12-point series, ending lower. Declaration record by year: recurring dividends, count, and days from declaration to ex-datetable · 2026-08-03 · 11×5
Verizon's Dividend Increase History
Consecutive years of dividend increases: six long record US payersranking · 2026-08-02 · 6×4Preview: 6 ranked values, smallest first. Verizon (VZ): annual dividend increase in cents and in percent, 2010 to 2025ranking · 2026-08-02 · 16×3Preview: 16 ranked values, smallest first. Verizon (VZ) dividend increases: declaration date, ex dividend date, and step sizetable · 2026-08-02 · 13×5 Verizon (VZ) dividends per share by calendar year, 2005 to 2025ranking · 2026-08-02 · 21×4Preview: 16 ranked values, smallest 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
$