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

How Annual Dividend Per Share Is Calculated
Declared amount against split-restated amount, per quarterseries · 2026-08-14 · 56×4Preview: a 16-point series, ending higher. Eight quarterly declarations, ex-date and pay dateseries · 2026-08-14 · 8×4Preview: a 8-point series, ending higher. Trailing four payments against the indicated rate, by quarterseries · 2026-08-14 · 16×4Preview: a 16-point series, ending higher. One set of payments, four annual dividend totalsranking · 2026-08-14 · 4×3Preview: 4 ranked values, smallest first. Ex-date to pay date across US cash dividends, by yearranking · 2026-08-14 · 7×4Preview: 7 ranked values, smallest first.
How Monthly Stock Returns Are Measured
SPY June 2026: price return vs total return (June ex-dividend included)scalar · 2026-07-26 · 1×6756.4 SPY monthly close-to-close returns: twelve months ending June 2026, simple and logseries · 2026-07-26 · 12×4Preview: a 12-point series, ending lower. SPY over five years, June 2021 to June 2026: price return vs return with dividendsscalar · 2026-07-26 · 1×7428.07 NVDA June 2024: a raw close-to-close calc vs the split-adjusted returnscalar · 2026-07-26 · 1×61,097.46 June 2026 measured two ways: close-to-close vs open-to-close, NVDA and SPYtable · 2026-07-26 · 2×7 SPY on June 30, 2026: official-close vs the final extended-hours printscalar · 2026-07-26 · 1×3746.32 Sum vs compound: twelve SPY monthly returns linked three waysscalar · 2026-07-26 · 1×712
Declared amount against split-restated amount, per quarter

Declared amount against split-restated amount, per quarter

most recentas of series 56×4read in context →
Declared amount against split-restated amount, per quarter — 56 rows by 4 columns, computed from US exchange, SIP and OPRA data.
ex_dateex_date_labelas_declaredsplit_adjusted
2012-08-09Aug 20122.650.0946
2012-11-07Nov 20122.650.0946
2013-02-07Feb 20132.650.0946
2013-05-09May 20133.050.1089
2013-08-08Aug 20133.050.1089
2013-11-06Nov 20133.050.1089
2014-02-06Feb 20143.050.1089
2014-05-08May 20143.290.1175
2014-08-07Aug 20140.470.1175
2014-11-06Nov 20140.470.1175
2015-02-05Feb 20150.470.1175
2015-05-07May 20150.520.13
2015-08-06Aug 20150.520.13
2015-11-05Nov 20150.520.13
2016-02-04Feb 20160.520.13
2016-05-05May 20160.570.1425
2016-08-04Aug 20160.570.1425
2016-11-03Nov 20160.570.1425
2017-02-09Feb 20170.570.1425
2017-05-11May 20170.630.1575
2017-08-10Aug 20170.630.1575
2017-11-10Nov 20170.630.1575
2018-02-09Feb 20180.630.1575
2018-05-11May 20180.730.1825
2018-08-10Aug 20180.730.1825
2018-11-08Nov 20180.730.1825
2019-02-08Feb 20190.730.1825
2019-05-10May 20190.770.1925
2019-08-09Aug 20190.770.1925
2019-11-07Nov 20190.770.1925
2020-02-07Feb 20200.770.1925
2020-05-08May 20200.820.205
2020-08-07Aug 20200.820.205
2020-11-06Nov 20200.2050.205
2021-02-05Feb 20210.2050.205
2021-05-07May 20210.220.22
2021-08-06Aug 20210.220.22
2021-11-05Nov 20210.220.22
2022-02-04Feb 20220.220.22
2022-05-06May 20220.230.23
2022-08-05Aug 20220.230.23
2022-11-04Nov 20220.230.23
2023-02-10Feb 20230.230.23
2023-05-12May 20230.240.24
2023-08-11Aug 20230.240.24
2023-11-10Nov 20230.240.24
2024-02-09Feb 20240.240.24
2024-05-10May 20240.250.25
2024-08-12Aug 20240.250.25
2024-11-08Nov 20240.250.25
2025-02-10Feb 20250.250.25
2025-05-12May 20250.260.26
2025-08-11Aug 20250.260.26
2025-11-10Nov 20250.260.26
2026-02-09Feb 20260.260.26
2026-05-11May 20260.270.27
the exact SQL behind every number
SELECT
    toString(ex_dividend_date)                           AS ex_date,
    formatDateTime(ex_dividend_date, '%b %Y')            AS ex_date_label,
    round(max(toFloat64(cash_amount)), 4)                AS as_declared,
    round(max(toFloat64(split_adjusted_cash_amount)), 4) AS split_adjusted
FROM global_markets.stocks_dividends
WHERE ticker = 'AAPL'
  AND ex_dividend_date >= '2012-01-01'
  AND ex_dividend_date <  '2026-07-01'
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date
$