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.
Quadruple Witching vs Triple Witching
SPY volume on quarterly expiration Fridays, against the average ordinary Fridayseries · 2026-08-22 · 13×4Preview: a 13-point series, ending higher. Share of SPY regular hours volume by half hour: expiration Friday vs the Friday afterseries · 2026-08-22 · 14×3Preview: a 14-point series, ending lower. Average absolute open to close move on SPY Fridays, expiration vs ordinary, by yearranking · 2026-08-22 · 10×4Preview: 10 ranked values, smallest first. Percent of regular hours volume printed in the 4:00 p.m. minute, six large listingsranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first.
Non-Marginable Securities: Reg T vs House
Symbols closing the month below $5 and below $1, past two yearsseries · 2026-08-22 · 24×3Preview: a 16-point series, ending lower. Symbol count and average daily range, by price bucketranking · 2026-08-22 · 6×3Preview: 6 ranked values, smallest first. Average daily range of recent listings, by age since listingranking · 2026-08-22 · 5×3Preview: 5 ranked values, largest first.
MOC and MOO Order Cutoff Times: NYSE & Nasdaq
SPY minute volume into the close, June 30 2026 (quarter end)series · 2026-08-22 · 31×2Preview: a 16-point series, ending higher. Share of SPY's regular-session volume by five-minute ET bucketseries · 2026-08-22 · 79×2Preview: a 16-point series, ending lower. Opening and closing windows as a share of regular-session volumeranking · 2026-08-22 · 8×3Preview: 8 ranked values, largest first. SPY: opening and closing window share of session volume, by monthseries · 2026-08-22 · 25×3Preview: a 16-point series, ending lower.
Hard-to-Borrow Lists and Borrow Fees
Every KO ex-dividend date a short position would have paid through, 2023 to mid-2026series · 2026-08-22 · 14×3Preview: a 14-point series, ending higher. Daily short volume as a share of total AAPL volume, May to July 2026series · 2026-08-22 · 53×3Preview: a 16-point series, roughly flat. How many liquid stocks sit in each days-to-cover bucketranking · 2026-08-22 · 5×2Preview: 5 ranked values, largest first. Days to cover across six household names, latest settlement dateranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first.
Early Lockup Release: Triggers and Waivers
IPO registration and prospectus filings since 2022ranking · 2026-08-22 · 7×3Preview: 7 ranked values, largest first. Form 8-K disclosures mentioning a lockup, by monthseries · 2026-08-22 · 17×4Preview: a 16-point series, ending higher. How much of a company an IPO actually sellsranking · 2026-08-22 · 6×2Preview: 6 ranked values, smallest first. Days from listing to a company's first lockup 8-Kranking · 2026-08-22 · 3×2Preview: 3 ranked values, smallest first.
Why stocks drop on the ex-dividend date
KO: dividend per share against the realised opening drop, every ex-date 2021 to 2025series · 2026-08-14 · 20×4Preview: a 16-point series, roughly flat. Opening drop per dollar of dividend paid, ex-dates 2021 to 2025ranking · 2026-08-14 · 10×4Preview: 10 ranked values, largest first. Pooled opening drop per dollar paid, by calendar yearranking · 2026-08-14 · 5×3Preview: 5 ranked values, largest first. Quarterly dividend against ordinary overnight moves, 2021 to 2025ranking · 2026-08-14 · 10×4Preview: 10 ranked values, smallest 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.
How Futures Margin Works: SPAN and Calls
SPY typical and largest daily move, month by month since 2019series · 2026-08-10 · 91×4Preview: a 16-point series, ending higher. Short term Treasury yields, the reference a stock margin loan is priced offseries · 2026-08-10 · 91×4Preview: a 16-point series, ending higher. One day move size across six household names, five years to July 2026ranking · 2026-08-10 · 6×3Preview: 6 ranked values, largest first. A decade of SPY daily closing moves, sorted into size bucketsranking · 2026-08-10 · 6×3Preview: 6 ranked values, largest first.
Time in Force Explained: Day, GTC, IOC, FOK
SPY share volume by ET clock hour, June 2026series · 2026-08-07 · 16×2Preview: a 16-point series, roughly flat. Print sizes across five names, 10:00 to 11:00 a.m. ET on 2026-06-10ranking · 2026-08-07 · 5×3Preview: 5 ranked values, largest first. US stock splits per month, forward and reverseseries · 2026-08-07 · 12×3Preview: a 12-point series, ending higher. SPY volume per minute into the close, June 2026 session averageseries · 2026-08-07 · 16×2Preview: a 16-point series, roughly flat.
Japanese IPO Lockups: The 1.5x Release Rule
One US listing traced against a flat line at 1.5x its offer priceseries · 2026-08-07 · 82×3Preview: a 16-point series, roughly flat. Share of US listings trading at 1.5x their offer price, by day since listingranking · 2026-08-07 · 19×2Preview: 16 ranked values, smallest first. US listings clearing 1.5x the offer price on the first close, by listing yearranking · 2026-08-07 · 8×4Preview: 8 ranked values, smallest first.
How to Find a Stock's Earnings Date
Spacing between each name's eight biggest overnight moves, July 2024 to June 2026table · 2026-08-03 · 7×5 Where fiscal quarters actually end: statement periods by calendar month, July 2023 to June 2026ranking · 2026-08-03 · 12×3Preview: 12 ranked values, smallest first. NVDA: the ten largest overnight moves, July 2024 to June 2026ranking · 2026-08-03 · 10×3Preview: 10 ranked values, smallest first.
How to Find a Lockup Expiration Date
Weekly average daily volume: Reddit's first year of trading, March 2024 to March 2025series · 2026-08-03 · 53×2Preview: a 16-point series, ending lower. Reddit share volume by window, counted in days from the March 20, 2024 pricing dateranking · 2026-08-03 · 5×3Preview: 5 ranked values, largest first. Day 180 counted from the pricing date: nine US listingsseries · 2026-08-03 · 9×6Preview: a 9-point series, ending higher. Volume in the four weeks around day 180 vs the weeks before it: nine US listingsranking · 2026-08-03 · 9×4Preview: 9 ranked values, largest first.
Event Contract Prices as Probabilities
Yes and No probabilities across one SPY chain: call side, put side, and the pair totaltable · 2026-08-03 · 8×5 How a near coin flip resolves: average implied probability by checkpoint, split by outcomeranking · 2026-08-03 · 6×4Preview: 6 ranked values, smallest first. Contracts priced near a coin flip: implied vs realized outcome by name, 2023 through June 2026ranking · 2026-08-03 · 6×4Preview: 6 ranked values, largest first. Implied probability vs what happened: SPY calls 30 days from expiry, 2022 through June 2026ranking · 2026-08-03 · 10×4Preview: 10 ranked values, smallest first.
Pattern Day Trader Rule: What Replaced It
US trading sessions per month, January 2025 through June 2026series · 2026-08-01 · 18×3Preview: a 16-point series, ending higher. SPY share volume by half hour, week of July 6, 2026 (Eastern time)series · 2026-08-01 · 32×2Preview: a 16-point series, roughly flat. Median and 90th percentile full day range, eight names, H1 2026ranking · 2026-08-01 · 8×3Preview: 8 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
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 →
$