STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

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

Which Stocks Have Daily Options?
Monday, Wednesday, Friday expirations: distinct option roots carrying an expiry on each weekdayseries · 2026-08-22 · 5×3Preview: a 5-point series, ending higher. Daily options vs weekly options: upcoming expiration dates for six household tickersranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first. SPY's expiration on every trading day: each near-term SPY expiry date, its weekday and volumeseries · 2026-08-22 · 11×4Preview: a 11-point series, ending lower. Which tickers carry the most upcoming expirations: option roots by distinct expiration dates in the next six weeksranking · 2026-08-22 · 20×3Preview: 16 ranked values, largest first.
What Is VIX1D? The 1-Day Volatility Index
Implied daily move (IV / 16) against realized daily movement, SPY by monthseries · 2026-08-22 · 14×5Preview: a 14-point series, ending higher. SPY option volume by expiration through one session, June 17 2026series · 2026-08-22 · 14×4Preview: a 14-point series, ending lower. SPY near-the-money implied volatility by days to expiryranking · 2026-08-22 · 8×2Preview: 8 ranked values, largest first. SPY absolute daily move, median and 90th percentile by yearranking · 2026-08-22 · 8×4Preview: 8 ranked values, smallest first.
The Rule of 16 in Options, and When It Breaks
Does a Monday move like three calendar days? SPY by weekdayranking · 2026-08-22 · 5×4Preview: 5 ranked values, smallest first. The largest single session against a typical one, by nametable · 2026-08-22 · 6×5 Implied volatility divided by 16, next to the realized daily moveranking · 2026-08-22 · 6×4Preview: 6 ranked values, largest first. How far SPY travels over one session, and over sixty threeranking · 2026-08-22 · 7×4Preview: 7 ranked values, smallest first.
SPX vs SPY Options: Which One to Trade
SPY option volume by days to expiry, trailing six weeksranking · 2026-08-22 · 5×3Preview: 5 ranked values, largest first. Time value left in deep in-the-money SPY calls, against the dividend at stakeranking · 2026-08-22 · 16×4Preview: 16 ranked values, smallest first. How close SPY closes to the nearest whole-dollar strike on monthly expirationsseries · 2026-08-22 · 13×4Preview: a 13-point series, ending lower. What one contract controls: SPX, SPY and XSPranking · 2026-08-22 · 3×4Preview: 3 ranked values, largest first.
When Do 0DTE Options Trade? By the Hour
Same-day share of options volume by weekday: all sessions, June 1 to July 10, 2026series · 2026-08-13 · 5×5Preview: a 5-point series, ending higher. Median bid-ask spread on SPY same-day contracts quoted $1-$10, by ET hour: July 10, 2026ranking · 2026-08-13 · 7×4Preview: 7 ranked values, largest first. What the last hour trades: same-day volume by premium paid, 10am hour vs. closing hour, July 10, 2026ranking · 2026-08-13 · 5×4Preview: 5 ranked values, largest first. 0DTE contract volume, share of all options volume, and flow rate by ET hour: Friday, July 10, 2026table · 2026-08-13 · 7×5 Same-day calls vs. puts by ET hour, and the put share of 0DTE volume: July 10, 2026ranking · 2026-08-13 · 7×4Preview: 7 ranked values, largest first. Same-day options volume by underlying: the ten heaviest names, July 10, 2026table · 2026-08-13 · 10×5
What Is 0DTE? Zero Days to Expiry Options
July 6, 2026: top roots by same-day-expiry options volumeranking · 2026-08-11 · 8×3Preview: 8 ranked values, largest first. The receipt: July 6, 2026 session completeness and OCC parse coveragescalar · 2026-08-11 · 1×6390 June 2026: whole-month options volume and its same-day-expiry sharescalar · 2026-08-11 · 1×41,477.9 How July 6's same-day SPY contracts finished: out of the money vs. in the moneytable · 2026-08-11 · 2×5 July 6, 2026: whole-tape options volume by days to expiryranking · 2026-08-11 · 5×3Preview: 5 ranked values, largest first. One 0DTE contract, all day: SPY's busiest same-day call and put, July 6, 2026series · 2026-08-11 · 14×4Preview: a 14-point series, ending higher. July 6, 2026: SPY's two busiest same-day contractsranking · 2026-08-11 · 2×3Preview: 2 ranked values, largest first.
DTE Meaning in Options: Days to Expiration
DTE menus compared: expirations traded and 0DTE share by underlying, July 8, 2026table · 2026-08-11 · 6×6 0DTE's rise: same-day share of SPY option volume, June 8-12 of each yearranking · 2026-08-11 · 7×4Preview: 7 ranked values, smallest first. The front of the curve: share of July 8, 2026 volume within a week of expiryscalar · 2026-08-11 · 1×361.8 Options volume by days to expiration: every US option traded July 8, 2026ranking · 2026-08-11 · 6×3Preview: 6 ranked values, largest first. DTE, worked on real contracts: SPY's most-traded option in each DTE band, July 8, 2026table · 2026-08-11 · 6×5 The price of time: at-the-money SPY call price by DTE, midday July 8, 2026series · 2026-08-11 · 11×3Preview: a 11-point series, ending lower.
When Do Options Expire? Friday 4 PM ET & Daily
Who owns Wednesday: roots by distinct Wednesday-dated expirations, July 6-9, 2026 tapetable · 2026-08-10 · 8×5 SPY options volume by June 2026 expiration date: a new expiry every sessionseries · 2026-08-10 · 21×2Preview: a 16-point series, ending higher. NVDA options volume by June 2026 expiration date: top six expiriesseries · 2026-08-10 · 6×2Preview: a 6-point series, ending lower. The July 2026 holiday move: SPY volume in contracts expiring Thursday July 2 vs Friday July 3scalar · 2026-08-10 · 1×212.84 The rest of 2026, measured: each month's busiest forward expiration date, July 6-9 tapeseries · 2026-08-10 · 6×5Preview: a 6-point series, ending lower. June 2026 SPY options volume by days-to-expiry at the time of the tradeseries · 2026-08-10 · 4×3Preview: a 4-point series, ending lower. Options volume by expiration weekday: all US options traded June 1 - July 9, 2026series · 2026-08-10 · 5×5Preview: a 5-point series, ending higher. The daily-expiration club: every root with an expiry on all 21 June 2026 sessionsranking · 2026-08-10 · 11×3Preview: 11 ranked values, largest first.
Pin Risk at Options Expiration Explained
How far the Friday close lands from the nearest whole dollarranking · 2026-08-09 · 10×3Preview: 10 ranked values, largest first. AAPL's final half hour on its tightest monthly expiration close since 2025series · 2026-08-09 · 30×5Preview: a 16-point series, ending lower.
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.
0DTE Options Strategies: How They Trade
Same-day options volume by premium paid: whole US tape, July 10, 2026ranking · 2026-07-31 · 5×4Preview: 5 ranked values, largest first. Median gamma, theta and delta by time to expiry: near-the-money US options, July 15, 2026table · 2026-07-31 · 4×5 How July 10's same-day SPY contracts finished: expired at zero vs. settled with valueranking · 2026-07-31 · 2×4Preview: 2 ranked values, smallest first. SPY intraday travel: close, high and low against the open, June 1 to July 10, 2026series · 2026-07-31 · 28×5Preview: a 16-point series, roughly flat.
Trading US 0DTE Options From Japan
Same-day options volume by Japan Standard Time hour: all US-listed options, Friday July 10, 2026ranking · 2026-07-31 · 7×4Preview: 7 ranked values, largest first. Median bid-ask spread on SPY same-day contracts quoted $1-$10, by Japan Standard Time hour: July 10, 2026ranking · 2026-07-31 · 7×4Preview: 7 ranked values, smallest first. Japanese local time of each US session boundary, January against July: static illustrative reference for 2026series · 2026-07-31 · 4×4Preview: a 4-point series, roughly flat. The US trading day converted into Japan Standard Time: static illustrative reference, July 2026series · 2026-07-31 · 6×5Preview: a 6-point series, ending higher.
Monday, Wednesday, Friday expirations: distinct option roots carrying an expiry on each weekday

Monday, Wednesday, Friday expirations: distinct option roots carrying an expiry on each weekday

most recentas of series 5×3read in context →
Monday, Wednesday, Friday expirations: distinct option roots carrying an expiry on each weekday — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
weekdayroots_with_expirycontracts_mm
1 Monday363.4
2 Tuesday140.6
3 Wednesday4033.5
4 Thursday143.6
5 Friday501995.7
the exact SQL behind every number 
SELECT weekday,
       uniqExact(root) AS roots_with_expiry,
       round(sum(vol) / 1e6, 1) AS contracts_mm
FROM (
    SELECT substring(ticker, 3, length(ticker) - 17) AS root,
           toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6))) AS expiry,
           multiIf(toDayOfWeek(toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6)))) = 1, '1 Monday',
                   toDayOfWeek(toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6)))) = 2, '2 Tuesday',
                   toDayOfWeek(toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6)))) = 3, '3 Wednesday',
                   toDayOfWeek(toDateOrNull(concat('20', substring(ticker, length(ticker) - 14, 6)))) = 4, '4 Thursday',
                   '5 Friday') AS weekday,
           toFloat64(volume) AS vol
    FROM global_markets.options_minute_aggs
    WHERE window_start >= now() - INTERVAL 8 DAY
)
WHERE expiry >= today() - 3 AND expiry <= today() + INTERVAL 30 DAY
GROUP BY weekday
ORDER BY weekday
More from this analysisWhich Stocks Have Daily Options?
SPY's expiration on every trading day: each near-term SPY expiry date, its weekday and volume series 11×4 → Which tickers carry the most upcoming expirations: option roots by distinct expiration dates in the next six weeks ranking 20×3 → Daily options vs weekly options: upcoming expiration dates for six household tickers ranking 6×3 → SPY options volume by June 2026 expiration date: a new expiry every session series 21×2 → See all 2,170 queries →
$