STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

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

Stock Splits vs Fractional Shares Explained
AAPL prints by trade size, one to ten shares, June 10 2026 sessionranking · 2026-08-22 · 10×2Preview: 10 ranked values, smallest first. NVDA strike ladder and share price across its June 2024 splitseries · 2026-08-22 · 10×5Preview: a 10-point series, ending higher. Forward stock splits at liquid US names, past three yearsranking · 2026-08-22 · 12×3Preview: 12 ranked values, smallest first. Price weighting across ten large US names, latest closeranking · 2026-08-22 · 10×3Preview: 10 ranked values, largest first.
Options Approval Levels: What Each Tier Allows
Every $5 call spread on the same AAPL expiration: risk against maximum gainranking · 2026-08-22 · 7×3Preview: 7 ranked values, largest first. Largest single-session move, open to close, since 2016ranking · 2026-08-22 · 6×4Preview: 6 ranked values, largest first. What a covered call collects across strikes: AAPL, about one month outtable · 2026-08-22 · 6×5 Cash needed to hold 100 shares, six household namesranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first.
Fully Paid Securities Lending Explained
Share of reported KO volume marked short, by sessionseries · 2026-08-22 · 69×3Preview: a 16-point series, ending lower. Cash paid per share and payment count, trailing yearranking · 2026-08-22 · 8×3Preview: 8 ranked values, largest first. Days to cover for two large dividend payers, by settlement dateseries · 2026-08-22 · 47×4Preview: a 16-point series, ending lower. Days to cover: household names against the most in-demand liquid borrowsranking · 2026-08-22 · 10×2Preview: 10 ranked values, largest first.
Held vs Not-Held Orders: Broker Discretion
Distance from AAPL's daily VWAP to that morning's opening printseries · 2026-08-12 · 9×2Preview: a 9-point series, ending higher. Average gap between the daily VWAP and the open, June 2026ranking · 2026-08-12 · 6×3Preview: 6 ranked values, largest first. Share of AAPL prints and volume by trade size, June 17 2026ranking · 2026-08-12 · 5×3Preview: 5 ranked values, largest first. Average quoted spread by half hour, AAPL and KO, June 17 2026series · 2026-08-12 · 15×3Preview: a 15-point series, ending higher.
Professional vs Non-Professional Market Data
US equity and options venues in the exchange reference listranking · 2026-08-08 · 6×3Preview: 6 ranked values, largest first. AAPL quote messages per 15 minutes, pinned session of Jun 16, 2026series · 2026-08-08 · 36×2Preview: a 16-point series, ending higher. Listed option contracts that traded on Jun 16, 2026, by underlyingranking · 2026-08-08 · 5×4Preview: 5 ranked values, largest first. Quote message rate by symbol, 10:00 to 11:00 a.m. ET on Jun 16, 2026ranking · 2026-08-08 · 5×3Preview: 5 ranked values, largest first.
Rule 605 vs 606: Execution Quality Reports
Where AAPL prints fall by trade size, June 17, 2026ranking · 2026-08-07 · 5×3Preview: 5 ranked values, largest first. Share of June 2026 volume reported to FINRA facilitiesranking · 2026-08-07 · 5×3Preview: 5 ranked values, largest first. AAPL quoted spread across the trading clock, June 17, 2026series · 2026-08-07 · 22×3Preview: a 16-point series, ending lower. Effective spread against quoted spread by trade size, AAPLranking · 2026-08-07 · 4×4Preview: 4 ranked values, smallest first.
AAPL prints by trade size, one to ten shares, June 10 2026 session

AAPL prints by trade size, one to ten shares, June 10 2026 session

most recentas of ranking 10×2read in context →
AAPL prints by trade size, one to ten shares, June 10 2026 session — 10 rows by 2 columns, computed from US exchange, SIP and OPRA data.
shares_per_printprints
176797
228637
320789
417012
523429
68718
76988
87647
96377
1020422
the exact SQL behind every number 
SELECT
    toUInt32(size) AS shares_per_print,
    count()        AS prints
FROM global_markets.stocks_trades
WHERE ticker = 'AAPL'
  AND sip_timestamp >= toDateTime('2026-06-10 13:30:00', 'UTC')
  AND sip_timestamp <  toDateTime('2026-06-10 20:00:00', 'UTC')
  AND size BETWEEN 1 AND 10
GROUP BY shares_per_print
ORDER BY shares_per_print
More from this analysisStock Splits vs Fractional Shares Explained
Forward stock splits at liquid US names, past three years ranking 12×3 → Price weighting across ten large US names, latest close ranking 10×3 → NVDA strike ladder and share price across its June 2024 split series 10×5 → The most common split terms of the past five years ranking 12×3 → See all 2,170 queries →
$