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

3,094 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-10-05 · 4×4Preview: 4 ranked values, largest first. Share of monthly volume by 15-minute ET clock slice, SPY and AAPLseries · 2026-10-05 · 64×3Preview: a 16-point series, roughly flat. Calendar days spanned by each rolling five-session windowseries · 2026-10-05 · 78×3Preview: a 16-point series, roughly flat.
Crypto Covered Call ETFs: Yield Explained
Implied volatility on near the money contracts, last four monthsranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Monthly near the money implied volatility, two yearsseries · 2026-10-04 · 24×4Preview: a 16-point series, ending lower. Month end close measured against the two year highseries · 2026-10-04 · 24×3Preview: a 16-point series, roughly flat. Count of big up months over the last three yearstable · 2026-10-04 · 3×5 One month call premium as a percentage of the underlying priceranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest 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
KO93.880.755.37
AAPL93.431.944.62
MSFT91.183.874.95
SPY83.592.6313.77
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
More from this analysisDoes the PDT Rule Apply to Crypto and Futures?
Calendar days spanned by each rolling five-session window series 78×3 → Share of monthly volume by 15-minute ET clock slice, SPY and AAPL series 64×3 → SPY contract volume by days to expiry, September 2026 ranking 4×3 → Share of August 2026 options volume expiring within five days, by underlying ranking 6×2 → See all 3,094 queries →
$