STRASMORE/EXPLORE 3,293 QUERIES

payment_calendar

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-24, from att-dividend-for-foreign-shareholders.

as of series 8×7read in context →
payment_calendar — 8 rows by 7 columns, computed from US exchange, SIP and OPRA data.
ex_dateex_date_labelrecord_datepay_dateusd_per_sharedays_ex_to_recorddays_ex_to_pay
2025-01-1010 января 20252025-01-102025-02-030.2775024
2025-04-1010 апреля 20252025-04-102025-05-010.2775021
2025-07-1010 июля 20252025-07-102025-08-010.2775022
2025-10-1010 октября 20252025-10-102025-11-030.2775024
2026-01-1212 января 20262026-01-122026-02-020.2775021
2026-04-1010 апреля 20262026-04-102026-05-010.2775021
2026-07-1010 июля 20262026-07-102026-08-030.2775024
2026-10-099 октября 20262026-10-122026-11-020.2775324
Rows × columns
8 × 7
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 payment_calendar, derived from the stored result.
ColumnTypeRangeNotes
ex_date date 2025-01-10 to 2026-10-09
ex_date_label text 8 distinct values
record_date date 2025-01-10 to 2026-10-12
pay_date date 2025-02-03 to 2026-11-02
usd_per_share number every row is 0.2775 US dollars
days_ex_to_record number 0 to 3
days_ex_to_pay number 21 to 24

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
    toString(ex) AS ex_date,
    concat(
        toString(toDayOfMonth(ex)), ' ',
        ['января','февраля','марта','апреля','мая','июня','июля','августа','сентября','октября','ноября','декабря'][toMonth(ex)], ' ',
        toString(toYear(ex))
    ) AS ex_date_label,
    toString(rec)                    AS record_date,
    toString(pay)                    AS pay_date,
    round(amt, 4)                    AS usd_per_share,
    dateDiff('day', ex, toDate(rec)) AS days_ex_to_record,
    dateDiff('day', ex, toDate(pay)) AS days_ex_to_pay
FROM
(
    SELECT
        ex_dividend_date            AS ex,
        any(record_date)            AS rec,
        any(pay_date)               AS pay,
        toFloat64(max(cash_amount)) AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'T'
      AND ex_dividend_date >= addYears(today(), -2)
    GROUP BY ex_dividend_date
)
ORDER BY ex
⌘/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