STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Premarket and After-Hours Trading Hours (ET)
Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only)table · 2026-08-22 · 3×5 The session envelope, read from SPY minute bars (last two weeks, ET)scalar · 2026-08-22 · 1×7240 Stock headlines by ET hour of publication (last 30 days, all days)ranking · 2026-08-22 · 24×3Preview: 16 ranked values, smallest first. AAPL median quoted spread: regular session vs extended hours (past week, full sessions)series · 2026-08-22 · 2×3Preview: a 2-point series, ending lower. AAPL median shares per traded minute, and the share of minutes that traded at all (ET)series · 2026-08-22 · 32×3Preview: a 16-point series, ending lower.
Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only)

Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only)

most recentas of table 3×5read in context →
Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only) — 3 rows by 5 columns, computed from US exchange, SIP and OPRA data.
tickerpremarket_pctregular_pctpost_close_30min_pctevening_pct
SPY5.182.310.91.7
AAPL6.786.93.82.6
NVDA5.391.22.21.4
the exact SQL behind every number 
WITH full_sessions AS (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS session_date
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= now() - INTERVAL 30 DAY
      AND toDate(toTimeZone(window_start, 'America/New_York')) < toDate(toTimeZone(now(), 'America/New_York'))
    GROUP BY session_date
    HAVING max(toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 1140
)
SELECT ticker,
       round(100 * sumIf(volume, m < 570) / sum(volume), 1) AS premarket_pct,
       round(100 * sumIf(volume, m >= 570 AND m < 960) / sum(volume), 1) AS regular_pct,
       round(100 * sumIf(volume, m >= 960 AND m < 990) / sum(volume), 1) AS post_close_30min_pct,
       round(100 * sumIf(volume, m >= 990) / sum(volume), 1) AS evening_pct
FROM (
    SELECT ticker, volume,
           toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York')) AS m
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'AAPL', 'NVDA')
      AND window_start >= now() - INTERVAL 30 DAY
      AND toDate(toTimeZone(window_start, 'America/New_York')) IN (SELECT session_date FROM full_sessions)
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 240 AND 1199
)
GROUP BY ticker
ORDER BY indexOf(['SPY', 'AAPL', 'NVDA'], ticker)
More from this analysisPremarket and After-Hours Trading Hours (ET)
AAPL median shares per traded minute, and the share of minutes that traded at all (ET) series 32×3 → Stock headlines by ET hour of publication (last 30 days, all days) ranking 24×3 → AAPL median quoted spread: regular session vs extended hours (past week, full sessions) series 2×3 → The session envelope, read from SPY minute bars (last two weeks, ET) scalar 1×7 → See all 2,170 queries →
$