STRASMORE/EXPLORE 2,170 QUERIES

How many of the 390 session minutes each US symbol traded in

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-08, from How OHLCV Bars Are Built From Ticks.

as of ranking 10×2read in context →
How many of the 390 session minutes each US symbol traded in — 10 rows by 2 columns, computed from US exchange, SIP and OPRA data.
minutes_traded_bucketstock_count
1-394677
40-781155
79-117747
118-156602
157-195475
196-234470
235-273476
274-312518
313-351644
352-3902020
Rows × columns
10 × 2
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 How many of the 390 session minutes each US symbol traded in, derived from the stored result.
ColumnTypeRangeNotes
minutes_traded_bucket text 10 distinct values (1-39, 118-156, 157-195…)
stock_count number 470 to 4,677 count

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 per_symbol AS
(
    SELECT
        ticker,
        count() AS populated_minutes
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= '2026-06-10 00:00:00'
      AND window_start <  '2026-06-11 06:00:00'
      AND toDate(toTimeZone(window_start, 'America/New_York')) = '2026-06-10'
      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 ticker
)
SELECT
    multiIf(
        populated_minutes <=  39, '1-39',
        populated_minutes <=  78, '40-78',
        populated_minutes <= 117, '79-117',
        populated_minutes <= 156, '118-156',
        populated_minutes <= 195, '157-195',
        populated_minutes <= 234, '196-234',
        populated_minutes <= 273, '235-273',
        populated_minutes <= 312, '274-312',
        populated_minutes <= 351, '313-351',
                                  '352-390') AS minutes_traded_bucket,
    count()                                  AS stock_count
FROM per_symbol
GROUP BY minutes_traded_bucket
ORDER BY min(populated_minutes)

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 analysisHow OHLCV Bars Are Built From Ticks
Trade condition codes that restrict high, low, and last ranking 7×3 → SPY volume by minute into the close, June 10 2026 series 25×3 → Odd lot share of prints and of volume, minute by minute series 15×4 → One-minute AAPL bars rebuilt from individual trades, June 10 2026 series 15×6 → Trading sessions per year under FB and META ranking 15×3 → New listings landing on a symbol that already had history ranking 11×3 → See all 2,170 queries →