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

3,293 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-24 · 3×3Preview: 3 ranked values, smallest first. SPY daily bar volume vs. the regular-session slice (trailing month)series · 2026-10-24 · 20×5Preview: a 16-point series, ending lower. Where SPY volume prints today, by ET clock hour (trailing month)ranking · 2026-10-24 · 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-24 · 7×4Preview: 7 ranked values, smallest first.
After-Hours Trading on Holidays and Weekends
Average SPY minute bars per calendar day, by weekdayseries · 2026-10-24 · 7×4Preview: a 7-point series, roughly flat. Upcoming US market closures and early closesseries · 2026-10-24 · 12×7Preview: a 12-point series, ending higher. SPY minute bars by ET clock hour: a normal day, a holiday, a half dayranking · 2026-10-24 · 15×4Preview: 15 ranked values, smallest first. First and last SPY print, Thanksgiving 2025 week and the week afterseries · 2026-10-24 · 12×5Preview: a 12-point series, roughly flat.
Who Matches Overnight US Stock Trades?
US stock venue records that are not exchangestable · 2026-10-03 · 9×4 AAPL trade prints by ET clock hour, Tue Sep 15 2026ranking · 2026-10-03 · 16×3Preview: 16 ranked values, largest first. AAPL median quoted spread by ET clock hour, Tue Sep 15 2026ranking · 2026-10-03 · 16×3Preview: 16 ranked values, largest first. Share of one session's volume printed before 9 a.m. ETranking · 2026-10-03 · 6×3Preview: 6 ranked values, largest first.
Why Overnight Orders Must Be Limit Orders
Where the consolidated tape starts and stops each day (AAPL, September 2026)series · 2026-09-27 · 13×5Preview: a 13-point series, roughly flat. Median quoted spread by ET hour (AAPL, pinned session of September 16, 2026)ranking · 2026-09-27 · 16×3Preview: 16 ranked values, largest first. Average per-minute volume by ET hour (AAPL, 4:00 a.m. to 8:00 p.m., September 2026)table · 2026-09-27 · 16×5 Median per-minute price range, premarket versus midday (September 2026)ranking · 2026-09-27 · 5×4Preview: 5 ranked values, largest first.
Overnight Trading Order Types: Limit Only
The eight widest prior-close to regular-open distances in AAPL, Sep 2023 to Sep 2026table · 2026-09-27 · 8×5 Where AAPL's share volume sits on the ET clock, July to August 2026ranking · 2026-09-27 · 16×3Preview: 16 ranked values, largest first. AAPL quoted spread and top-of-book size by ET hour, September 15, 2026ranking · 2026-09-27 · 16×3Preview: 16 ranked values, largest first. Average quoted spread, 4 a.m. hour vs noon hour, September 15, 2026ranking · 2026-09-27 · 5×3Preview: 5 ranked values, largest first.
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
$