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

Mutual Fund Cutoffs on Early-Close Days
Minute bars and volume per session: early closes against full sessions, Nov-Dec 2025ranking · 2026-10-04 · 2×4Preview: 2 ranked values, smallest first. SPY volume by half hour: a 1:00 p.m. half day against an ordinary Fridayseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Upcoming 1:00 p.m. early closes, with the hour before each oneseries · 2026-10-04 · 2×6Preview: a 2-point series, ending higher. Every upcoming closure, tagged full closure or early closeseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher.
Best Time of Day to Sell a Mutual Fund
Overnight gap versus the session that follows, complete yearsranking · 2026-10-04 · 5×3Preview: 5 ranked values, smallest first. How far SPY trades from its own open and close, by time of dayseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Average one-day move across six widely held funds, since 2021ranking · 2026-10-04 · 6×2Preview: 6 ranked values, smallest first. How big a one-day move usually is, sessions since 2016ranking · 2026-10-04 · 5×2Preview: 5 ranked values, largest first.
Minute bars and volume per session: early closes against full sessions, Nov-Dec 2025

Minute bars and volume per session: early closes against full sessions, Nov-Dec 2025

most recentas of ranking 2×4read in context →
Minute bars and volume per session: early closes against full sessions, Nov-Dec 2025 — 2 rows by 4 columns, computed from US exchange, SIP and OPRA data.
categorysessionsavg_minute_barsavg_volume_millions
Early close 1 p.m.221137.1
Full session 4 p.m.2739069.8
the exact SQL behind every number 
WITH day_totals AS
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
        count()                                              AS regular_bars,
        sum(volume)                                          AS regular_volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= '2025-11-20 00:00:00'
      AND window_start <  '2026-01-03 06:00:00'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
    GROUP BY et_date
)
SELECT
    if(regular_bars < 300, 'Early close 1 p.m.', 'Full session 4 p.m.') AS category,
    count()                                                            AS sessions,
    round(avg(regular_bars))                                           AS avg_minute_bars,
    round(avg(regular_volume) / 1e6, 1)                                AS avg_volume_millions
FROM day_totals
GROUP BY category
ORDER BY avg_minute_bars
More from this analysisMutual Fund Cutoffs on Early-Close Days
SPY volume by half hour: a 1:00 p.m. half day against an ordinary Friday series 13×3 → Every upcoming closure, tagged full closure or early close series 12×6 → Upcoming 1:00 p.m. early closes, with the hour before each one series 2×6 → Short regular sessions on the SPY tape since January 2024 ranking 6×3 → See all 3,256 queries →
$