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

3,256 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.
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.
Best Stocks for Day Trading Options (Ranked)
Daily options contract volume, SPY vs QQQ vs IWM vs NVDA, last 20 sessionsseries · 2026-10-04 · 20×6Preview: a 16-point series, ending lower. At-the-money spread as a percent of premium, calls expiring next day, Dec 19 2024, 10:00 to 10:30 ETranking · 2026-10-04 · 5×4Preview: 5 ranked values, smallest first. Stock and ETF underlyings ranked by average daily options contract volume, last 20 sessionsranking · 2026-10-04 · 15×4Preview: 15 ranked values, largest first. Share of all options contract volume by liquidity tier, last 20 sessionsranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest 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.
What Replaced the PDT Rule? Intraday Margin
What 100 shares, one contract's deliverable, cost at the end of August 2026ranking · 2026-09-26 · 6×4Preview: 6 ranked values, largest first. Intraday high-to-low range as a share of the open, August 2026ranking · 2026-09-26 · 6×3Preview: 6 ranked values, largest first. The five widest AAPL sessions of August 2026 for the same $5,000 accountranking · 2026-09-26 · 5×3Preview: 5 ranked values, largest first. A $5,000 account holding $20,000 of AAPL from the open: loss and deficit at each session low, August 2026series · 2026-09-26 · 21×3Preview: a 16-point series, ending lower.
The 10:00 AM Rule in Stocks, Tested
Volume and range coverage by half hour of the session, 2023 to 2025series · 2026-09-26 · 13×3Preview: a 13-point series, ending lower. Median quoted spread by five minute bucket, SPY and AAPL, 10 March 2026series · 2026-09-26 · 12×3Preview: a 12-point series, ending lower. First 30 minutes: share of the day's range and volume, 2023 to 2025ranking · 2026-09-26 · 6×3Preview: 6 ranked values, largest first. Average one minute range by ET clock minute, 09:30 to 10:59series · 2026-09-26 · 90×3Preview: a 16-point series, roughly flat. Session coverage behind the long-run panelsranking · 2026-09-26 · 6×4Preview: 6 ranked values, largest first.
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-09-26 · 32×2Preview: a 16-point series, ending higher. Typical quoted spread on the three largest S&P 500 ETFs, trailing five daysranking · 2026-09-26 · 3×3Preview: 3 ranked values, smallest first.
Can You Make $1,000 a Day Day Trading?
Intraday range (high minus low, over the open), 2021 to 2025table · 2026-09-19 · 4×5 Share of sessions whose intraday range reached 1%, 2% and 4%ranking · 2026-09-19 · 4×4Preview: 4 ranked values, smallest first. Absolute close-to-close move, 2021 to 2025table · 2026-09-19 · 4×5 Capital at which $1,000 equals the whole, a tenth and a hundredth of the median daily rangetable · 2026-09-19 · 4×6 Daily return required for $1,000 a day, by account sizeranking · 2026-09-19 · 6×2Preview: 6 ranked values, largest first.
Pattern Day Trader Rule: What Replaced It
US trading sessions per month, January 2025 through June 2026series · 2026-08-01 · 18×3Preview: a 16-point series, ending higher. SPY share volume by half hour, week of July 6, 2026 (Eastern time)series · 2026-08-01 · 32×2Preview: a 16-point series, roughly flat. Median and 90th percentile full day range, eight names, H1 2026ranking · 2026-08-01 · 8×3Preview: 8 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,256 queries →
$