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.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
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
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.