Anatomy of TSLA's prints on July 2, 2026: off-exchange vs. on-exchange
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-07-26, from What Is Dark Pool Trading? FINRA Volume Data.
| where_it_printed | prints_thousands | shares_m | median_print_shares | prints_10k_plus | largest_print_k_shares | largest_is_closing_auction |
|---|---|---|---|---|---|---|
| Off-exchange (TRF) | 922 | 36.8 | 2 | 34 | 592 | 0 |
| On-exchange | 737 | 37.4 | 24 | 21 | 4491 | 1 |
- Rows × columns
- 2 × 7
- 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 |
|---|---|---|---|
where_it_printed |
text | 2 distinct values (Off-exchange (TRF), On-exchange) | |
prints_thousands |
number | 737 to 922 | |
shares_m |
number | 36.8 to 37.4 | count |
median_print_shares |
number | 2 to 24 | count |
prints_10k_plus |
number | 21 to 34 | |
largest_print_k_shares |
number | 592 to 4,491 | count |
largest_is_closing_auction |
number | 0 to 1 |
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
if(exchange = 4, 'Off-exchange (TRF)', 'On-exchange') AS where_it_printed,
round(count() / 1e3) AS prints_thousands,
round(toFloat64(sum(size)) / 1e6, 1) AS shares_m,
round(quantileDeterministic(0.5)(toFloat64(size), toUInt64(sip_timestamp))) AS median_print_shares,
countIf(size >= 10000) AS prints_10k_plus,
round(toFloat64(max(size)) / 1e3) AS largest_print_k_shares,
if(maxIf(size, has(conditions, 8)) = max(size), 1, 0) AS largest_is_closing_auction
FROM global_markets.stocks_trades
WHERE ticker = 'TSLA'
AND sip_timestamp >= '2026-07-02 00:00:00' AND sip_timestamp < '2026-07-03 00:00:00'
AND NOT hasAny(conditions, [15, 16, 38])
GROUP BY where_it_printed
ORDER BY where_it_printed
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 analysisWhat Is Dark Pool Trading? FINRA Volume Data
NVDA's off-exchange share of volume by Eastern-time hour, July 2, 2026
ranking 16×4
→
Where AAPL's trade reports came from on July 2, 2026: and which carry a TRF timestamp
ranking 6×4
→
Off-exchange share of matched volume: five liquid names, July 2, 2026
ranking 5×4
→
The receipt: TRF timestamps and the FINRA venue code agree on every AAPL report
scalar 1×5
→
20-session regular-hours ADV: shares, dollars, and the extended-hours share (June 11 – July 10, 2026)
table 5×5
→
Where AAPL's 10,000-share-and-up prints executed: July 6, 2026
table 4×5
→
See all 2,170 queries →