STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
When Do SPX Options Stop Trading?
The final hours of the AM settled SPX monthly, Thursday May 14, 2026 (ET)series · 2026-10-24 · 8×3Preview: a 8-point series, roughly flat. Prior close to expiration-Friday open, monthly expirations (SPY, percent)series · 2026-10-24 · 12×5Preview: a 12-point series, roughly flat. The final hours of the expiring SPXW weekly, Friday May 15, 2026 (ET)series · 2026-10-24 · 7×4Preview: a 7-point series, roughly flat. Expiration Friday, 8:00 a.m. to 10:00 a.m. ET: which root is tradingseries · 2026-10-24 · 2×5Preview: a 2-point series, roughly flat. Contracts traded per session into the May 15, 2026 expiration, by rootseries · 2026-10-24 · 5×4Preview: a 5-point series, ending higher.
The final hours of the AM settled SPX monthly, Thursday May 14, 2026 (ET)

The final hours of the AM settled SPX monthly, Thursday May 14, 2026 (ET)

most recentas of series 8×3read in context →
The final hours of the AM settled SPX monthly, Thursday May 14, 2026 (ET) — 8 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_timeam_settled_spx_contractsweekly_spxw_contracts
15:0066298405
15:1043317972
15:20518333713
15:30670310491
15:401026423697
15:501144333810
16:00694740752
16:10173513366
the exact SQL behind every number
SELECT
    formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 10 MINUTE), '%H:%i') AS et_time,
    sum(if(startsWith(ticker, 'O:SPXW'), 0, volume)) AS am_settled_spx_contracts,
    sum(if(startsWith(ticker, 'O:SPXW'), volume, 0)) AS weekly_spxw_contracts
FROM global_markets.options_minute_aggs
WHERE (startsWith(ticker, 'O:SPX260515') OR startsWith(ticker, 'O:SPXW260515'))
  AND window_start >= toDateTime('2026-05-14 19:00:00', 'UTC')
  AND window_start <  toDateTime('2026-05-14 21:30:00', 'UTC')
GROUP BY et_time
HAVING am_settled_spx_contracts > 0
ORDER BY et_time
$