Share of regular-session volume printed in the 16:00 ET minute
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-22, from NYSE Parity and D-Quotes: How Fills Allocate.
| ticker | listing_venue | closing_print_pct |
|---|---|---|
| JPM | NYSE listed | 2.9 |
| JNJ | NYSE listed | 2.8 |
| MSFT | Nasdaq listed | 2.8 |
| PEP | Nasdaq listed | 2.7 |
| AAPL | Nasdaq listed | 2.6 |
| CSCO | Nasdaq listed | 2.5 |
| WMT | NYSE listed | 2.1 |
| KO | NYSE listed | 2 |
| XOM | NYSE listed | 0.8 |
| INTC | Nasdaq listed | 0.7 |
- Rows × columns
- 10 × 3
- 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 |
|---|---|---|---|
ticker |
text | 10 distinct values (AAPL, CSCO, INTC…) | |
listing_venue |
text | 2 distinct values (NYSE listed, Nasdaq listed) | |
closing_print_pct |
number | 0.7 to 2.9 | percent |
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
ticker,
multiIf(ticker IN ('KO', 'JPM', 'XOM', 'JNJ', 'WMT'), 'NYSE listed', 'Nasdaq listed') AS listing_venue,
round(100 * sumIf(shares, minute_of_day = 960) / sum(shares), 1) AS closing_print_pct
FROM
(
SELECT
ticker,
toFloat64(volume) AS shares,
toHour(toTimeZone(window_start, 'America/New_York')) * 60
+ toMinute(toTimeZone(window_start, 'America/New_York')) AS minute_of_day
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('KO', 'JPM', 'XOM', 'JNJ', 'WMT', 'AAPL', 'MSFT', 'INTC', 'CSCO', 'PEP')
AND window_start >= today() - 95
AND window_start < today() - 4
)
WHERE minute_of_day >= 570 AND minute_of_day <= 960
GROUP BY ticker
HAVING sum(shares) > 0
ORDER BY closing_print_pct DESC
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 analysisNYSE Parity and D-Quotes: How Fills Allocate
Average shares per trade, ten household names
ranking 10×3
→
Coca-Cola closing print as a share of session volume, by month
series 25×2
→
Gap between the 3:50 p.m. price and the official close, July 2026 sessions
ranking 6×3
→
How often the close finished above the 3:50 p.m. price, July 2026 sessions
ranking 6×3
→
Share of regular-session volume printed in the opening and closing auction minutes, July 2026
ranking 6×3
→
The tape's own labels for the close, straight from the code dictionary
ranking 4×3
→
See all 2,170 queries →