STRASMORE/EXPLORE 2,830 QUERIES

payment_lag

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-30, from spy-dividend-for-korean-investors.

as of series 31×4read in context →
payment_lag — 31 rows by 4 columns, computed from US exchange, SIP and OPRA data.
ex_datequarter_labeldays_ex_to_paydays_record_to_pay
2019-03-15Mar 20194643
2019-06-21Jun 20194037
2019-09-20Sep 20194138
2019-12-20Dec 20194239
2020-03-20Mar 20204138
2020-06-19Jun 20204239
2020-09-18Sep 20204239
2020-12-18Dec 20204239
2021-03-19Mar 20214239
2021-06-18Jun 20214239
2021-09-17Sep 20214239
2021-12-17Dec 20214542
2022-03-18Mar 20224239
2022-06-17Jun 20224238
2022-09-16Sep 20224542
2022-12-16Dec 20224643
2023-03-17Mar 20234239
2023-06-16Jun 20234541
2023-09-15Sep 20234643
2023-12-15Dec 20234744
2024-03-15Mar 20244643
2024-06-21Jun 20244040
2024-09-20Sep 20244141
2024-12-20Dec 20244242
2025-03-21Mar 20254040
2025-06-20Jun 20254141
2025-09-19Sep 20254242
2025-12-19Dec 20254242
2026-03-20Mar 20264141
2026-06-18Jun 20264343
2026-09-18Sep 20264242
Rows × columns
31 × 4
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_lag, derived from the stored result.
ColumnTypeRangeNotes
ex_date date 2019-03-15 to 2026-09-18
quarter_label text 31 distinct values (Dec 2019, Dec 2020, Dec 2021…)
days_ex_to_pay number 40 to 47
days_record_to_pay number 37 to 44

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_dividend_date)                       AS ex_date,
    formatDateTime(ex_dividend_date, '%b %Y')        AS quarter_label,
    dateDiff('day', ex_dividend_date, max(pay_date)) AS days_ex_to_pay,
    dateDiff('day', max(record_date), max(pay_date)) AS days_record_to_pay
FROM global_markets.stocks_dividends
WHERE ticker = 'SPY'
  AND ex_dividend_date >= '2019-01-01'
  AND ex_dividend_date <= today()
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date
⌘/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 analysisspy-dividend-for-korean-investors
ttm_yield series 32×3 → session_clock series 18×3 → distribution_cycle series 15×5 → The 2s10s spread by month, full history series 604×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → The 5s30s spread month by month, with both legs series 241×4 → See all 2,830 queries →