STRASMORE/EXPLORE 3,022 QUERIES

Calendar days from each VOO ex-date to its record date and pay date

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-04, from VOO Dividend: Ex-Dividend Dates & Yield.

as of series 25×4read in context →
Calendar days from each VOO ex-date to its record date and pay date — 25 rows by 4 columns, computed from US exchange, SIP and OPRA data.
ex_dateex_date_labelex_to_record_daysex_to_pay_days
2020-09-29Sep 29, 202013
2020-12-22Dec 22, 202016
2021-03-26Mar 26, 202135
2021-06-29Jun 29, 202113
2021-09-29Sep 29, 202115
2021-12-21Dec 21, 202116
2022-03-24Mar 24, 202215
2022-06-29Jun 29, 202216
2022-09-28Sep 28, 202215
2022-12-20Dec 20, 202213
2023-03-24Mar 24, 202335
2023-06-29Jun 29, 202316
2023-09-28Sep 28, 202315
2023-12-20Dec 20, 202316
2024-03-22Mar 22, 202435
2024-06-28Jun 28, 202404
2024-09-27Sep 27, 202404
2024-12-23Dec 23, 202403
2025-03-27Mar 27, 202504
2025-06-30Jun 30, 202502
2025-09-29Sep 29, 202502
2025-12-22Dec 22, 202502
2026-03-27Mar 27, 202604
2026-06-26Jun 26, 202604
2026-09-28Sep 28, 202602
Rows × columns
25 × 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 Calendar days from each VOO ex-date to its record date and pay date, derived from the stored result.
ColumnTypeRangeNotes
ex_date date 2020-09-29 to 2026-09-28
ex_date_label text 25 distinct values (Dec 20, 2022, Dec 20, 2023, Dec 21, 2021…)
ex_to_record_days number 0 to 3
ex_to_pay_days number 2 to 6

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,
    concat(formatDateTime(ex_dividend_date, '%b '),
           toString(toDayOfMonth(ex_dividend_date)), ', ',
           toString(toYear(ex_dividend_date)))                      AS ex_date_label,
    dateDiff('day', ex_dividend_date, max(record_date))             AS ex_to_record_days,
    dateDiff('day', ex_dividend_date, max(pay_date))                AS ex_to_pay_days
FROM global_markets.stocks_dividends
WHERE ticker = 'VOO'
  AND ex_dividend_date >= today() - 2200
  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 analysisVOO Dividend: Ex-Dividend Dates & Yield
VOO trailing-twelve-month payout per share and the yield it works out to series 13×4 → VOO declared distributions: ex, record and pay dates with the per-share amount series 13×5 → Which month and which week VOO's ex-dividend date has landed in series 4×5 → VOO distributions per complete calendar year, with the spread between quarters table 11×6 → Declared amount against split-restated amount, per quarter series 56×4 → Calendar days from ex-dividend date to record date, twenty large payers, by month series 41×5 → See all 3,022 queries →