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.
Cost Basis After a Stock Split, Step by Step
Forward and reverse splits per calendar yearranking · 2026-08-22 · 11×3Preview: 11 ranked values, smallest first. The most common split terms of the past five yearsranking · 2026-08-22 · 12×3Preview: 12 ranked values, largest first. One hypothetical 100-share lot through every AAPL splitseries · 2026-08-22 · 3×5Preview: a 3-point series, ending lower. Every KO dividend of the past four years, one new lot each if reinvestedseries · 2026-08-22 · 16×3Preview: a 16-point series, ending higher.
How Fractional Shares Hit the Tape
Small AAPL print sizes: five sessions in January 2026 against five in July 2026table · 2026-08-12 · 26×3 Average shares per print by month, September 2025 through July 2026series · 2026-08-12 · 11×5Preview: a 11-point series, ending lower. Odd lots, round lots and sub-one-share prints across six names, July 8 to 10, 2026ranking · 2026-08-12 · 6×4Preview: 6 ranked values, largest first. AAPL average print size across the February 2026 boundaryseries · 2026-08-12 · 19×4Preview: a 16-point series, roughly flat.
Dividend Reinvestment Plans (DRIPs) Explained
Days from ex-dividend date to cash: six household dividend payersranking · 2026-08-11 · 6×4Preview: 6 ranked values, largest first. KO: ex-dividend close against the pay date close, 2021 to 2026series · 2026-08-11 · 22×5Preview: a 16-point series, ending lower. Reinvestment events a year: a monthly payer against a quarterly payerranking · 2026-08-11 · 10×3Preview: 10 ranked values, smallest first. How often listed payers distribute, trailing yearranking · 2026-08-11 · 5×3Preview: 5 ranked values, largest 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
$