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
EURO STOXX 50 Daily Options (OEXP) Explained
SPY's front two weeks of expiries, as of the latest sessionseries · 2026-11-07 · 10×4Preview: a 10-point series, ending lower. Where the Eurex close lands in the US day: FEZ volume share by half hour (ET), trailing two monthsseries · 2026-11-07 · 32×3Preview: a 16-point series, roughly flat. Share of SPY option volume by days to expiry, trailing six weeksranking · 2026-11-07 · 5×2Preview: 5 ranked values, largest first.
SPY's front two weeks of expiries, as of the latest session

SPY's front two weeks of expiries, as of the latest session

most recentas of series 10×4read in context →
SPY's front two weeks of expiries, as of the latest session — 10 rows by 4 columns, computed from US exchange, SIP and OPRA data.
expiry_dateexpiry_labelas_of_labelcontracts_k
2026-11-09Mon Nov 9Nov 6, 2026955.8
2026-11-10Tue Nov 10Nov 6, 2026191
2026-11-11Wed Nov 11Nov 6, 2026133
2026-11-12Thu Nov 12Nov 6, 202670
2026-11-13Fri Nov 13Nov 6, 2026429
2026-11-16Mon Nov 16Nov 6, 202649.1
2026-11-17Tue Nov 17Nov 6, 202642.4
2026-11-18Wed Nov 18Nov 6, 202623.3
2026-11-19Thu Nov 19Nov 6, 202615
2026-11-20Fri Nov 20Nov 6, 2026794.3
the exact SQL behind every number 
SELECT
    toString(expiration_date)                                                                          AS expiry_date,
    concat(formatDateTime(expiration_date, '%a %b'), ' ', toString(toDayOfMonth(expiration_date)))     AS expiry_label,
    concat(formatDateTime(any(date), '%b'), ' ', toString(toDayOfMonth(any(date))), ', ', toString(toYear(any(date)))) AS as_of_label,
    round(toFloat64(sum(volume)) / 1000, 1)                                                            AS contracts_k
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND date = (SELECT max(date) FROM global_markets.options_greeks WHERE underlying_symbol = 'SPY')
  AND expiration_date <= date + 14
GROUP BY expiration_date
ORDER BY expiration_date
More from this analysisEURO STOXX 50 Daily Options (OEXP) Explained
Where the Eurex close lands in the US day: FEZ volume share by half hour (ET), trailing two months series 32×3 → Share of SPY option volume by days to expiry, trailing six weeks ranking 5×2 → Same-day expiries as a share of SPY option volume: every session, July 2026 series 21×4 → Expirations on the SPY option board: every listed expiry over 30 days, 16 July 2026 series 13×4 → See all 3,293 queries →
$