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

Does the PDT Rule Apply to Crypto and Futures?
Regular session, premarket and after-hours share of volumeranking · 2026-11-07 · 4×4Preview: 4 ranked values, largest first. Share of monthly volume by 15-minute ET clock slice, SPY and AAPLseries · 2026-11-07 · 64×3Preview: a 16-point series, roughly flat. Calendar days spanned by each rolling five-session windowseries · 2026-11-07 · 79×3Preview: a 16-point series, roughly flat.
Crypto Covered Call ETFs: Yield Explained
Implied volatility on near the money contracts, last four monthsranking · 2026-11-07 · 5×3Preview: 5 ranked values, largest first. Monthly near the money implied volatility, two yearsseries · 2026-11-07 · 24×4Preview: a 16-point series, ending higher. Month end close measured against the two year highseries · 2026-11-07 · 24×3Preview: a 16-point series, ending higher. Count of big up months over the last three yearstable · 2026-11-07 · 3×5 One month call premium as a percentage of the underlying priceranking · 2026-11-07 · 5×3Preview: 5 ranked values, largest first.
Limit Orders on Crypto Exchanges vs Stocks
The same stock, quoted venue by venue: AAPL spreads by exchangeranking · 2026-10-06 · 3×4Preview: 3 ranked values, smallest first. AAPL print sizes in one hour, Sep 23 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, largest first. Where AAPL's volume sat by ET hour, September 2026series · 2026-10-06 · 16×3Preview: a 16-point series, roughly flat. Average quoted spread across household names, five minutes on Sep 23 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, smallest first.
Regular session, premarket and after-hours share of volume

Regular session, premarket and after-hours share of volume

most recentas of ranking 4×4read in context →
Regular session, premarket and after-hours share of volume — 4 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickerregular_session_pctpremarket_pctafter_hours_pct
KO94.221.424.36
MSFT91.642.595.77
AAPL90.632.876.5
SPY83.612.8813.52
the exact SQL behind every number
SELECT
    ticker,
    round(100 * toFloat64(sumIf(volume, et_min >= 570 AND et_min < 960)) / toFloat64(sum(volume)), 2) AS regular_session_pct,
    round(100 * toFloat64(sumIf(volume, et_min <  570))                  / toFloat64(sum(volume)), 2) AS premarket_pct,
    round(100 * toFloat64(sumIf(volume, et_min >= 960))                  / toFloat64(sum(volume)), 2) AS after_hours_pct
FROM
(
    SELECT
        ticker,
        volume,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
          + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_min
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'AAPL', 'MSFT', 'KO')
      AND window_start >= today() - 45
      AND window_start <  today() - 2
)
GROUP BY ticker
ORDER BY regular_session_pct DESC
$