ex_calendar

Name: ex_calendar
Creator: Strasmore
Published: 2026-09-25
License: https://www.strasmore.com/terms/

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-25, from ex-dividend-date-premarket-and-open-orders.

as of 2026-09-25 ranking 3×4read in context →

ex_calendar — 3 rows by 4 columns, computed 2026-09-25 from US exchange, SIP and OPRA data.
ticker	ex_date_label	dividend_usd	reduction_pct
JPM	Oct 6	1.65	0.485
CSCO	Oct 2	0.42	0.392
MSFT	Nov 19	0.98	0.197

Rows × columns: 3 × 4
Computed: 2026-09-25
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 ex_calendar, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	3 distinct values (CSCO, JPM, MSFT)
`ex_date_label`	text	3 distinct values (Nov 19, Oct 2, Oct 6)
`dividend_usd`	number	0.42 to 1.65	US dollars
`reduction_pct`	number	0.197 to 0.485	percent

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 2026-09-25, 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.

WITH
    upcoming AS
    (
        SELECT
            ticker,
            min(ex_dividend_date)                 AS ex_date,
            argMin(cash_amount, ex_dividend_date) AS dividend_usd
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'HD', 'JPM', 'PEP', 'CSCO', 'MRK')
          AND cash_amount > 0
          AND ex_dividend_date >= today()
          AND ex_dividend_date <= today() + 120
        GROUP BY ticker
    ),
    last_price AS
    (
        SELECT
            ticker,
            argMax(close, date) AS px
        FROM global_markets.stocks_daily_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'HD', 'JPM', 'PEP', 'CSCO', 'MRK')
          AND date >= today() - 30
        GROUP BY ticker
    )
SELECT
    u.ticker                                                    AS ticker,
    formatDateTime(u.ex_date, '%b %e')                          AS ex_date_label,
    round(toFloat64(u.dividend_usd), 2)                         AS dividend_usd,
    round(100 * toFloat64(u.dividend_usd) / toFloat64(p.px), 3) AS reduction_pct
FROM upcoming AS u
INNER JOIN last_price AS p ON p.ticker = u.ticker
ORDER BY reduction_pct DESC

SQL to run

WITH
    upcoming AS
    (
        SELECT
            ticker,
            min(ex_dividend_date)                 AS ex_date,
            argMin(cash_amount, ex_dividend_date) AS dividend_usd
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'HD', 'JPM', 'PEP', 'CSCO', 'MRK')
          AND cash_amount > 0
          AND ex_dividend_date >= today()
          AND ex_dividend_date <= today() + 120
        GROUP BY ticker
    ),
    last_price AS
    (
        SELECT
            ticker,
            argMax(close, date) AS px
        FROM global_markets.stocks_daily_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'HD', 'JPM', 'PEP', 'CSCO', 'MRK')
          AND date >= today() - 30
        GROUP BY ticker
    )
SELECT
    u.ticker                                                    AS ticker,
    formatDateTime(u.ex_date, '%b %e')                          AS ex_date_label,
    round(toFloat64(u.dividend_usd), 2)                         AS dividend_usd,
    round(100 * toFloat64(u.dividend_usd) / toFloat64(p.px), 3) AS reduction_pct
FROM upcoming AS u
INNER JOIN last_price AS p ON p.ticker = u.ticker
ORDER BY reduction_pct DESC

⌘/Ctrl + Enter

Work with this data in your AI assistant

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

Claude ChatGPT Gemini Muse Your own agent

More from this analysisex-dividend-date-premarket-and-open-orders

open_vs_reference series 14×3 → ko_history series 14×3 → premarket_trace series 11×4 → Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdays ranking 25×4 → Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years) ranking 25×3 → SPY options median spread by expiration date, near-the-money strikes only ranking 25×4 → See all 2,595 queries →