per_year
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-09-26, from what-is-a-dividend.
| year | ko_usd | aapl_usd | msft_usd |
|---|---|---|---|
| 2023 | 1.84 | 0.95 | 2.79 |
| 2024 | 1.94 | 0.99 | 3.08 |
| 2025 | 2.04 | 1.03 | 3.4 |
- Rows × columns
- 3 × 4
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
year |
number | 2,023 to 2,025 | |
ko_usd |
number | 1.84 to 2.04 | US dollars |
aapl_usd |
number | 0.95 to 1.03 | US dollars |
msft_usd |
number | 2.79 to 3.4 | US dollars |
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.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
SELECT
toYear(ex_dividend_date) AS year,
round(sumIf(dividend, ticker = 'KO'), 4) AS ko_usd,
round(sumIf(dividend, ticker = 'AAPL'), 4) AS aapl_usd,
round(sumIf(dividend, ticker = 'MSFT'), 4) AS msft_usd
FROM
(
SELECT
ticker,
ex_dividend_date,
toFloat64(argMax(cash_amount, _ingest_time)) AS dividend
FROM global_markets.stocks_dividends
WHERE ticker IN ('KO', 'AAPL', 'MSFT')
AND cash_amount > 0
AND toYear(ex_dividend_date) BETWEEN toYear(today()) - 3 AND toYear(today()) - 1
GROUP BY ticker, ex_dividend_date
)
GROUP BY year
ORDER BY year
Olah data ini di asisten AI Anda
Terbuka siap dikueri, dengan data halaman ini. Gratis, tanpa akun.