STRASMORE/EXPLORE 2,170 QUERIES

Next week on the calendar: closures, ex-dividends, and the monthly expiry's pull

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-07-26, from Market Recap: Week of July 6, 2026.

as of scalar 1×4read in context →
closures next week
0
ex dividends next week
692
household ex div next week
0
jul17 expiry pct of week volume
14
Rows × columns
1 × 4
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 Next week on the calendar: closures, ex-dividends, and the monthly expiry's pull, derived from the stored result.
ColumnTypeRangeNotes
closures_next_week number every row is 0
ex_dividends_next_week number every row is 692
household_ex_div_next_week number every row is 0
jul17_expiry_pct_of_week_volume number every row is 14 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 , and the query below is what returned them.

the exact SQL behind every number 
SELECT
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date >= '2026-07-11' AND date <= '2026-07-17' AND status != 'open') AS closures_next_week,
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-13' AND ex_dividend_date <= '2026-07-17') AS ex_dividends_next_week,
    (SELECT countIf(ticker IN ('AAPL', 'MSFT', 'JPM', 'KO', 'JNJ', 'XOM', 'CVX', 'PG', 'WMT', 'HD')) FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-13' AND ex_dividend_date <= '2026-07-17') AS household_ex_div_next_week,
    (SELECT round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260717') / sum(size), 1) FROM global_markets.options_trades WHERE sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-11 00:00:00') AS jul17_expiry_pct_of_week_volume

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisMarket Recap: Week of July 6, 2026
SK Hynix's US debut: the raise, the delayed open, the close vs offer, and where the first-day tape ranks in 2026 scalar 1×14 → Session verification: five sessions, no holiday, next scheduled closure scalar 1×6 → The week's corporate calendar: filings, dividends, splits, news scalar 1×10 → SPY's week in trailing-year context (open-to-close weekly returns, ~53 weeks) scalar 1×5 → Treasury curve: the Friday July 10 print vs the July 2 close, both late receipts on file scalar 1×6 → Weekly breadth: July 10 close vs July 2 close, names with $5M+ traded during the week scalar 1×4 → See all 2,170 queries →