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.
| session | session_label | tickers_count | minute_bars_millions |
|---|---|---|---|
| 2026-07-20 | Jul 20 | 11737 | 1.79 |
| 2026-07-21 | Jul 21 | 11905 | 1.81 |
| 2026-07-22 | Jul 22 | 11768 | 1.79 |
| 2026-07-23 | Jul 23 | 11737 | 1.84 |
| 2026-07-24 | Jul 24 | 11717 | 1.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
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
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 →