STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

NYSE Parity and D-Quotes: How Fills Allocate
Average shares per trade, ten household namesranking · 2026-10-04 · 10×3Preview: 10 ranked values, largest first. Coca-Cola closing print as a share of session volume, by monthseries · 2026-10-04 · 24×2Preview: a 16-point series, ending lower. The closing auction print as a share of regular-session volumeranking · 2026-10-04 · 10×3Preview: 10 ranked values, largest first.
Average shares per trade, ten household names

Average shares per trade, ten household names

most recentas of ranking 10×3read in context →
Average shares per trade, ten household names — 10 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickerlisting_venueavg_shares_per_trade
INTCNasdaq listed118
CSCONasdaq listed99
WMTNasdaq listed94
XOMNYSE listed88
PEPNasdaq listed70
KONYSE listed64
AAPLNasdaq listed57
JPMNYSE listed55
JNJNYSE listed54
MSFTNasdaq listed51
the exact SQL behind every number 
SELECT
    ticker,
    multiIf(ticker IN ('KO', 'JPM', 'XOM', 'JNJ'), 'NYSE listed', 'Nasdaq listed') AS listing_venue,
    round(toFloat64(sum(volume)) / sum(transactions), 0) AS avg_shares_per_trade
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('KO', 'JPM', 'XOM', 'JNJ', 'WMT', 'AAPL', 'MSFT', 'INTC', 'CSCO', 'PEP')
  AND date >= today() - 120
  AND date <  today() - 4
GROUP BY ticker
HAVING sum(transactions) > 0
ORDER BY avg_shares_per_trade DESC
More from this analysisNYSE Parity and D-Quotes: How Fills Allocate
The closing auction print as a share of regular-session volume ranking 10×3 → Coca-Cola closing print as a share of session volume, by month series 24×2 → KO on Sep 23, 2026: the eight largest prints of the session ranking 8×4 → Closing auction share of consolidated daily volume, by day type ranking 4×3 → See all 3,256 queries →
$