STRASMORE/EXPLORE 3,256 QUERIES

dividend_history

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-10-09, from aapl-dividend-for-thai-investors.

as of series 16×3read in context →
dividend_history — 16 rows by 3 columns, computed from US exchange, SIP and OPRA data.
ex_dateex_labeldividend_usd
2022-11-044 พ.ย. 25650.23
2023-02-1010 ก.พ. 25660.23
2023-05-1212 พ.ค. 25660.24
2023-08-1111 ส.ค. 25660.24
2023-11-1010 พ.ย. 25660.24
2024-02-099 ก.พ. 25670.24
2024-05-1010 พ.ค. 25670.25
2024-08-1212 ส.ค. 25670.25
2024-11-088 พ.ย. 25670.25
2025-02-1010 ก.พ. 25680.25
2025-05-1212 พ.ค. 25680.26
2025-08-1111 ส.ค. 25680.26
2025-11-1010 พ.ย. 25680.26
2026-02-099 ก.พ. 25690.26
2026-05-1111 พ.ค. 25690.27
2026-08-1010 ส.ค. 25690.27
Rows × columns
16 × 3
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for dividend_history, derived from the stored result.
ColumnTypeRangeNotes
ex_date date 2022-11-04 to 2026-08-10
ex_label text 16 distinct values (10 ก.พ. 2566, 10 ก.พ. 2568, 10 พ.ค. 2567…)
dividend_usd number 0.23 to 0.27 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
    ex_date                                     AS ex_date,
    concat(
        toString(toDayOfMonth(ex_date)), ' ',
        arrayElement(['ม.ค.', 'ก.พ.', 'มี.ค.', 'เม.ย.', 'พ.ค.', 'มิ.ย.', 'ก.ค.', 'ส.ค.', 'ก.ย.', 'ต.ค.', 'พ.ย.', 'ธ.ค.'], toMonth(ex_date)),
        ' ',
        toString(toYear(ex_date) + 543)
    )                                           AS ex_label,
    round(toFloat64(amount), 4)                 AS dividend_usd
FROM
(
    SELECT
        id,
        any(ex_dividend_date) AS ex_date,
        max(cash_amount)      AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND ex_dividend_date >= today() - 1500
      AND ex_dividend_date <= today()
    GROUP BY id
)
ORDER BY ex_date
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.