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

US Stocks 23/5 Trading: The December 2026 Plan
Extended-hours sale conditions defined on the taperanking · 2026-10-04 · 3×3Preview: 3 ranked values, smallest first. SPY daily bar volume vs. the regular-session slice (trailing month)series · 2026-10-04 · 19×5Preview: a 16-point series, roughly flat. Where SPY volume prints today, by ET clock hour (trailing month)ranking · 2026-10-04 · 16×4Preview: 16 ranked values, largest first. Share of volume printed outside 9:30 to 4:00 ET, seven household names (trailing month)ranking · 2026-10-04 · 7×4Preview: 7 ranked values, smallest first.
Tape A, B, and C Explained: CTA and UTP
Share of prints on each tape, by ET clock hour, across the same basketseries · 2026-10-01 · 16×4Preview: a 16-point series, ending higher. The tape carried by a basket of household symbols, one September 2026 sessionranking · 2026-10-01 · 12×4Preview: 12 ranked values, smallest first. US listing exchanges and the tape each one assignstable · 2026-10-01 · 7×5 Class-share symbols and the notation each tape usesranking · 2026-10-01 · 10×4Preview: 10 ranked values, smallest first.
The 7-5-3-1 Rule in Mutual Funds, Tested
The eight weakest seven-year windows on SPY, dividends counted as cashtable · 2026-09-17 · 8×6 A flat 500-a-month SIP against the same plan stepped up 10% a year, contributions onlytable · 2026-09-17 · 10×5 Rolling seven-year returns on SPY, one window per start monthseries · 2026-09-17 · 193×5Preview: a 16-point series, ending higher. Where the seven-year windows landed: SPY windows by return band, dividends countedranking · 2026-09-17 · 5×3Preview: 5 ranked values, smallest first.
Market Data Timestamps: SIP vs Exchange Clocks
Off exchange AAPL prints by reporting delay, 10 June 2026ranking · 2026-08-14 · 5×3Preview: 5 ranked values, largest first. The same twelve prints, ranked by venue clock and by tape clocktable · 2026-08-14 · 12×7 SIP receive lag by venue, AAPL, 10 June 2026 (microseconds)ranking · 2026-08-14 · 11×4Preview: 11 ranked values, largest first. Prints that change bar when you switch clocks, by bar lengthranking · 2026-08-14 · 4×3Preview: 4 ranked values, largest first.
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.
SIP Feeds vs Direct Exchange Feeds
Which venues sat on the bid side of the quote record, KO on June 16, 2026ranking · 2026-08-09 · 17×3Preview: 16 ranked values, largest first. Quote update traffic across five household tickers, 10:00 to 11:00 a.m. ET on June 16, 2026table · 2026-08-09 · 5×5 US equity exchanges that feed the consolidated tapetable · 2026-08-09 · 18×4 Venue clock to consolidated tape clock, KO quotes on June 16, 2026series · 2026-08-09 · 15×4Preview: a 15-point series, roughly flat.
Why Stock Quotes Are Delayed 15 Minutes
How often the last price changes, minute by minute (June 2026)ranking · 2026-08-06 · 6×3Preview: 6 ranked values, largest first. The 15 minute gap across six household tickers (June 2026)ranking · 2026-08-06 · 6×3Preview: 6 ranked values, largest first. How far SPY travels in 15 minutes, by hour of the session (June 2026)series · 2026-08-06 · 7×4Preview: a 7-point series, ending higher. Live price against a 15 minute delayed view, one SPY sessionseries · 2026-08-06 · 37×5Preview: a 16-point series, ending lower.
Extended-hours sale conditions defined on the tape

Extended-hours sale conditions defined on the tape

most recentas of ranking 3×3read in context →
Extended-hours sale conditions defined on the tape — 3 rows by 3 columns, computed from US exchange, SIP and OPRA data.
idcondition_namemeaning
12Form T/Extended Hours
13Extended Hours (Sold Out Of Sequence)
248Extended Hours TradeTransaction represents a trade that was executed outside of regular market hours. Trades do not update Open, High, Low, and Closing Prices.
the exact SQL behind every number
SELECT
    id,
    any(name)        AS condition_name,
    any(description) AS meaning
FROM global_markets.stocks_condition_codes
WHERE name ILIKE '%form t%'
   OR name ILIKE '%extended%hours%'
GROUP BY id
ORDER BY id
$