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

3,256 answered market questions

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

EURO STOXX 50 Daily Options (OEXP) Explained
SPY's front two weeks of expiries, as of the latest sessionseries · 2026-10-04 · 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-10-04 · 32×3Preview: a 16-point series, roughly flat. Share of SPY option volume by days to expiry, trailing six weeksranking · 2026-10-04 · 5×2Preview: 5 ranked values, largest first.
DAX Options Settlement Price: ODAX vs ODAP
DAX option settlement clock: last trading time and settlement auction, CETtable · 2026-09-25 · 3×5
DAX Futures Explained: FDAX, FDXM, FDXS
Quarterly third Friday volume against the trailing 20 session averageseries · 2026-09-23 · 14×5Preview: a 14-point series, ending higher. Share of a Germany fund's monthly volume printed after the 17:30 CET Frankfurt closeseries · 2026-09-23 · 12×3Preview: a 12-point series, ending lower. Where a listed Germany fund's volume sits on the New York clock (Jun to Aug 2026)ranking · 2026-09-23 · 8×3Preview: 8 ranked values, largest first.
Eurex Option Codes: ODAX, ODAP, OESX
One US options symbol, taken apart: busiest SPY contracts on 17 June 2026table · 2026-09-22 · 8×6 Distinct expirations traded per underlying, 17 June 2026ranking · 2026-09-22 · 5×2Preview: 5 ranked values, largest first. SPY option volume by days left to expiry, 17 June 2026ranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first. What one US equity option contract covers, 17 June 2026ranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first.
DAX Daily Options: How Eurex 0DTE Works
Same-day expiries as a share of SPY option volume: every session, July 2026series · 2026-08-03 · 21×4Preview: a 16-point series, roughly flat. Expirations on the SPY option board: every listed expiry over 30 days, 16 July 2026series · 2026-08-03 · 13×4Preview: a 13-point series, ending lower. Median implied volatility by days to expiry: near-the-money SPY contracts, 16 July 2026ranking · 2026-08-03 · 5×4Preview: 5 ranked values, smallest first. Distinct expirations listed for the rest of July 2026: eight US namesranking · 2026-08-03 · 8×3Preview: 8 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-10-02Fri Oct 2Oct 1, 20261835.5
2026-10-05Mon Oct 5Oct 1, 2026376.2
2026-10-06Tue Oct 6Oct 1, 2026155.4
2026-10-07Wed Oct 7Oct 1, 2026194.2
2026-10-08Thu Oct 8Oct 1, 202696.8
2026-10-09Fri Oct 9Oct 1, 2026308.3
2026-10-12Mon Oct 12Oct 1, 202642.2
2026-10-13Tue Oct 13Oct 1, 202627.2
2026-10-14Wed Oct 14Oct 1, 202621.4
2026-10-15Thu Oct 15Oct 1, 202611.4
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,256 queries →
$