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-10-24 · 4×4Preview: 4 ranked values, largest first. Share of monthly volume by 15-minute ET clock slice, SPY and AAPLseries · 2026-10-24 · 64×3Preview: a 16-point series, roughly flat. Calendar days spanned by each rolling five-session windowseries · 2026-10-24 · 78×3Preview: a 16-point series, roughly flat.
Can You Day Trade an Index Fund? ETFs vs Funds
VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included)series · 2026-10-24 · 32×2Preview: a 16-point series, ending lower. Typical quoted spread on the three largest S&P 500 ETFs, trailing five daysranking · 2026-10-24 · 3×3Preview: 3 ranked values, smallest first.
Do Multi-Leg Options Count as One Day Trade?
SPY contract volume by days to expiry, September 2026ranking · 2026-10-05 · 4×3Preview: 4 ranked values, largest first.
Does an Expired Option Count as a Day Trade?
Distinct SPY expiration dates traded each weekseries · 2026-09-27 · 13×3Preview: a 13-point series, ending lower. Share of August 2026 options volume expiring within five days, by underlyingranking · 2026-09-27 · 6×2Preview: 6 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
KO94.260.94.84
MSFT92.522.195.28
AAPL92.272.335.4
SPY83.892.6713.45
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,293 queries →
$