STRASMORE/EXPLORE 2,173 QUERIES

One week of the US minute tape: symbols and bars per session, Jul 20-24, 2026

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-05, from Local A-Share Data Lake for AI Agents.

as of series 5×4read in context →
One week of the US minute tape: symbols and bars per session, Jul 20-24, 2026 — 5 rows by 4 columns, computed from US exchange, SIP and OPRA data.
sessionsession_labeltickers_countminute_bars_millions
2026-07-20Jul 20117371.79
2026-07-21Jul 21119051.81
2026-07-22Jul 22117681.79
2026-07-23Jul 23117371.84
2026-07-24Jul 24117171.76
Rows × columns
5 × 4
Period covered
to
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 One week of the US minute tape: symbols and bars per session, Jul 20-24, 2026, derived from the stored result.
ColumnTypeRangeNotes
session date 2026-07-20 to 2026-07-24
session_label text 5 distinct values (Jul 20, Jul 21, Jul 22…)
tickers_count number 11,717 to 11,905 count
minute_bars_millions number 1.76 to 1.84

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
SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS session,
       formatDateTime(toDate(toTimeZone(window_start, 'America/New_York')), '%b %e') AS session_label,
       uniqExact(ticker) AS tickers_count,
       round(count() / 1000000, 2) AS minute_bars_millions
FROM global_markets.delayed_stocks_minute_aggs
WHERE toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-07-20')
  AND toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-07-24')
GROUP BY session, session_label
ORDER BY session

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 analysisLocal A-Share Data Lake for AI Agents
Survivorship, measured: March cohorts of US symbols still trading in late July 2026 table 10×5 Who left the tape: March 2021 symbols by daily dollar volume, checked against late July 2026 ranking 5×4 Where the volume sits: share of June 2026 volume by half hour, New York time series 32×3 How far the price travels inside one minute: KO, by New York clock time, 17 June 2026 series 18×2 Trading sessions per month: SPY bars, July 2025 through June 2026 series 12×4 Minute bars per session: nine widely held names, June 2026 series 9×4 See all 2,173 queries →