STRASMORE/EXPLORE 2,170 QUERIES

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

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from Premarket and After-Hours Trading Hours (ET).

as 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
Rows × columns
3 × 5
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only), derived from the stored result.
ColumnTypeRangeNotes
ticker text 3 distinct values (AAPL, NVDA, SPY)
premarket_pct number 5.1 to 6.7 percent
regular_pct number 82.3 to 91.2 percent
post_close_30min_pct number 2.2 to 10.9 percent
evening_pct number 1.4 to 2.6 percent

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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)

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

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 → SPY volume by half hour, premarket through after-hours (same session, ET clock) table 32×2 → The US trading day converted into ten local clocks: static illustrative reference, July 2026 table 10×6 → See all 2,170 queries →