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

ASX Options Expiry and Settlement Explained
Average distance from the opening print, first 30 minutes (SPY)series · 2026-10-24 · 31×2Preview: a 16-point series, ending higher. How far eight large caps travel from their opening print by 10:00ranking · 2026-10-24 · 8×2Preview: 8 ranked values, largest first. SPY on 15 May 2026: distance from the opening print, 09:30 to 10:30 New York timeseries · 2026-10-24 · 61×2Preview: a 16-point series, roughly flat.
Options Expiry Days in India: NSE and BSE
Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeksranking · 2026-10-17 · 3×4Preview: 3 ranked values, largest first.
Average distance from the opening print, first 30 minutes (SPY)

Average distance from the opening print, first 30 minutes (SPY)

most recentas of series 31×2read in context →
Average distance from the opening print, first 30 minutes (SPY) — 31 rows by 2 columns, computed from US exchange, SIP and OPRA data.
et_timeavg_gap_bps
09:305.6
09:317.3
09:328.1
09:339.3
09:349.9
09:3510.9
09:3611.2
09:3711.9
09:3812.1
09:3912.6
09:4012.4
09:4113.1
09:4213.8
09:4314
09:4414.5
09:4514.9
09:4615.4
09:4715.9
09:4815.8
09:4916.2
09:5016.7
09:5117.2
09:5217.1
09:5317.6
09:5417.8
09:5518.2
09:5618.8
09:5719.5
09:5820.5
09:5920.9
10:0020.7
the exact SQL behind every number 
WITH session_open AS (
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS session_day,
        argMin(toFloat64(open), window_start)                AS first_print
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= today() - 300
      AND window_start <  today() - 2
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) <  960
    GROUP BY session_day
)
SELECT
    formatDateTime(toTimeZone(m.window_start, 'America/New_York'), '%H:%i') AS et_time,
    round(avg(abs(toFloat64(m.close) / s.first_print - 1) * 10000), 1)      AS avg_gap_bps
FROM global_markets.delayed_stocks_minute_aggs AS m
INNER JOIN session_open AS s
    ON toDate(toTimeZone(m.window_start, 'America/New_York')) = s.session_day
WHERE m.ticker = 'SPY'
  AND m.window_start >= today() - 300
  AND m.window_start <  today() - 2
  AND (toHour(toTimeZone(m.window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(m.window_start, 'America/New_York'))) BETWEEN 570 AND 600
  AND s.first_print > 0
GROUP BY et_time
HAVING count() > 0
ORDER BY et_time
More from this analysisASX Options Expiry and Settlement Explained
SPY on 15 May 2026: distance from the opening print, 09:30 to 10:30 New York time series 61×2 → How far eight large caps travel from their opening print by 10:00 ranking 8×2 → Near-dated versus long-dated SPY implied volatility, session by session series 83×3 → The prices behind the arithmetic: Thursday's close, the strike, Friday's open and close series 29×6 → See all 3,293 queries →
$