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

When Is SQ Day for Nikkei 225 Options?
Opening prints against the previous close: settlement Friday vs an ordinary Fridayranking · 2026-08-16 · 8×3Preview: 8 ranked values, largest first. Share of SPY session volume printed in the opening minute, third Friday vs other Fridaysseries · 2026-08-16 · 11×4Preview: a 11-point series, ending higher. SPY volume by ET clock minute around the open, 13 March vs 20 March 2026series · 2026-08-16 · 46×3Preview: a 16-point series, ending higher.
Japanese IPO Lockups: The 1.5x Release Rule
One US listing traced against a flat line at 1.5x its offer priceseries · 2026-08-07 · 82×3Preview: a 16-point series, roughly flat. Share of US listings trading at 1.5x their offer price, by day since listingranking · 2026-08-07 · 19×2Preview: 16 ranked values, smallest first. US listings clearing 1.5x the offer price on the first close, by listing yearranking · 2026-08-07 · 8×4Preview: 8 ranked values, smallest first.
Nikkei 225 Options and SQ Settlement
SPY implied volatility vs the volatility realized in the following monthseries · 2026-08-03 · 23×5Preview: a 16-point series, roughly flat. Implied vs realized volatility, six heavily traded US underlyings, twelve months to June 30, 2026ranking · 2026-08-03 · 6×4Preview: 6 ranked values, largest first. Median theta and implied volatility by days to expiry: near-the-money SPY contracts, H1 2026table · 2026-08-03 · 60×4 SPY on monthly settlement Fridays: the opening gap, and where the session went afterwardsseries · 2026-08-03 · 16×4Preview: a 16-point series, ending lower. Opening prints on settlement morning, May 15, 2026: twelve large US constituentsranking · 2026-08-03 · 12×3Preview: 12 ranked values, largest first.
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.
Opening prints against the previous close: settlement Friday vs an ordinary Friday

Opening prints against the previous close: settlement Friday vs an ordinary Friday

most recentas of ranking 8×3read in context →
Opening prints against the previous close: settlement Friday vs an ordinary Friday — 8 rows by 3 columns, computed from US exchange, SIP and OPRA data.
symbolsettlement_open_gap_pctordinary_open_gap_pct
XOM0.750.5
PG0.10.58
JPM0.040.63
KO0.02-0.18
NVDA-0.310.97
JNJ-0.320.9
AAPL-0.4-0.11
MSFT-0.57-0.21
the exact SQL behind every number 
SELECT
    ticker                                                              AS symbol,
    round(100 * (toFloat64(anyIf(open,  date = '2026-03-20'))
               / toFloat64(anyIf(close, date = '2026-03-19')) - 1), 2)  AS settlement_open_gap_pct,
    round(100 * (toFloat64(anyIf(open,  date = '2026-03-13'))
               / toFloat64(anyIf(close, date = '2026-03-12')) - 1), 2)  AS ordinary_open_gap_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'JPM', 'JNJ', 'KO', 'PG', 'XOM')
  AND date IN ('2026-03-12', '2026-03-13', '2026-03-19', '2026-03-20')
GROUP BY ticker
HAVING countIf(date = '2026-03-12') > 0
   AND countIf(date = '2026-03-13') > 0
   AND countIf(date = '2026-03-19') > 0
   AND countIf(date = '2026-03-20') > 0
ORDER BY settlement_open_gap_pct DESC
More from this analysisWhen Is SQ Day for Nikkei 225 Options?
SPY volume by ET clock minute around the open, 13 March vs 20 March 2026 series 46×3 → Share of SPY session volume printed in the opening minute, third Friday vs other Fridays series 11×4 → Opening prints on settlement morning, May 15, 2026: twelve large US constituents ranking 12×3 → Implied vs realized volatility, six heavily traded US underlyings, twelve months to June 30, 2026 ranking 6×4 → See all 2,170 queries →
$