STRASMORE/EXPLORE 3,022 QUERIES

Which month and which week VOO's ex-dividend date has landed in

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 4×5read in context →
Which month and which week VOO's ex-dividend date has landed in — 4 rows by 5 columns, computed from US exchange, SIP and OPRA data.
ex_monthex_dates_seenearliest_daylatest_dayavg_day
March10102722.9
June10233027.8
September11132925.7
December10172621.6
Rows × columns
4 × 5
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 Which month and which week VOO's ex-dividend date has landed in, derived from the stored result.
ColumnTypeRangeNotes
ex_month text 4 distinct values (December, June, March…)
ex_dates_seen number 10 to 11
earliest_day number 10 to 23
latest_day number 26 to 30
avg_day number 21.6 to 27.8

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
    any(monthName(ex_date))              AS ex_month,
    count()                              AS ex_dates_seen,
    min(toDayOfMonth(ex_date))           AS earliest_day,
    max(toDayOfMonth(ex_date))           AS latest_day,
    round(avg(toDayOfMonth(ex_date)), 1) AS avg_day
FROM
(
    SELECT ex_dividend_date AS ex_date
    FROM global_markets.stocks_dividends
    WHERE ticker = 'VOO'
      AND ex_dividend_date >= today() - 3700
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
)
GROUP BY toMonth(ex_date)
ORDER BY toMonth(ex_date)
⌘/Ctrl + Enter

Work with this data in your AI assistant

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

More from this analysisVOO Dividend: Ex-Dividend Dates & Yield
Calendar days from each VOO ex-date to its record date and pay date series 25×4 → 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 → 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 →