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

Stock Order Types Explained: The Core Four
How often a buy limit under the prior close was reached (AAPL, one year of sessions)ranking · 2026-10-08 · 6×2Preview: 6 ranked values, largest first. Overnight gap between one close and the next open, year to Sep 2026ranking · 2026-10-08 · 6×4Preview: 6 ranked values, largest first.
Primary Peg vs Market Peg Orders Explained
Distance between the touches, five household names, 15 September 2026ranking · 2026-10-08 · 5×4Preview: 5 ranked values, largest first. Share of quotes at a one cent spread, 15 September 2026ranking · 2026-10-08 · 5×4Preview: 5 ranked values, largest first. AAPL quoted spread by ET hour, 15 September 2026series · 2026-10-08 · 16×2Preview: a 16-point series, ending lower. Distinct best bid prices per 15 minutes, NVDA against KOseries · 2026-10-08 · 64×3Preview: a 16-point series, ending lower.
Market Orders With Protection on CME Globex
Quoted spread across six household names, 10:00 to 10:10 ET on 2026-09-15ranking · 2026-10-08 · 6×4Preview: 6 ranked values, smallest first. Average quoted spread at the open and at midday, 2026-09-15ranking · 2026-10-08 · 6×4Preview: 6 ranked values, largest first. How big is a typical one minute move in SPY? September 2026 regular sessionranking · 2026-10-08 · 5×3Preview: 5 ranked values, largest first. Median one minute range by ET clock bucket, SPY and KO, September 2026series · 2026-10-08 · 39×3Preview: a 16-point series, ending lower.
How Much Slippage to Assume in a Backtest
Distance from the prevailing mid by trade size, AAPL, one midday hourranking · 2026-10-08 · 5×3Preview: 5 ranked values, smallest first. A five cent concession as a share of premium, near-the-money SPY contracts by expiryranking · 2026-10-08 · 5×3Preview: 5 ranked values, smallest first. Quoted spread and the half spread floor, six household names, one midday hourranking · 2026-10-08 · 6×3Preview: 6 ranked values, largest first. A naive open-to-close yardstick, netted against a ladder of slippage assumptionsranking · 2026-10-08 · 6×4Preview: 6 ranked values, smallest first.
Does OPRA Have Depth of Book? Feed Explained
Options trade prints by exchange count, five household names (Sep 16, 2026)ranking · 2026-10-08 · 5×3Preview: 5 ranked values, largest first. Traded volume across strikes, one AAPL expiry (Sep 16, 2026)table · 2026-10-08 · 55×3 Distinct AAPL option contracts trading, by hour of the sessionranking · 2026-10-08 · 8×2Preview: 8 ranked values, largest first. One contract, one minute: displayed size at each exchange's best quoteranking · 2026-10-08 · 8×4Preview: 8 ranked values, largest first. Contracts in the chain versus contracts that traded (Sep 16, 2026)ranking · 2026-10-08 · 12×3Preview: 12 ranked values, largest first.
T-Bill Maturities and How Yields Are Quoted
A nine-month estimate, interpolated between the 3-month and 1-year pointsseries · 2026-10-07 · 26×5Preview: a 16-point series, ending higher. Front-end yields by horizon: 13-week bill, 1-year point, 2-year noteseries · 2026-10-07 · 26×6Preview: a 16-point series, ending higher. The published short end of the Treasury curve, April to September 2026table · 2026-10-07 · 3×6 The same bill on both conventions: coupon equivalent versus discount basistable · 2026-10-07 · 2×5
Options Trade Example: Start to Finish
AAPL's close against the strike and the breakeven, February 20 to March 20, 2026series · 2026-10-07 · 21×5Preview: a 16-point series, roughly flat. The daily mark on one AAPL March 2026 call: premium, intrinsic value, time valueseries · 2026-10-07 · 20×6Preview: a 16-point series, ending lower. The same contract, three exit choices, net of commission and feesranking · 2026-10-07 · 3×3Preview: 3 ranked values, largest first. One contract: premium, cash out, and breakeven across the strikes above the stocktable · 2026-10-07 · 6×6 AAPL March 2026 calls on the chain at entry, February 20, 2026table · 2026-10-07 · 5×5
One Clearinghouse, Many Options Exchanges
Where AAPL option volume printed across venues, September 15, 2026ranking · 2026-10-07 · 18×3Preview: 16 ranked values, largest first. Median quoted spread in the underlying stock, one midday hourranking · 2026-10-07 · 5×3Preview: 5 ranked values, largest first. Listed contracts per underlying on the most recent September 2026 sessionranking · 2026-10-07 · 5×4Preview: 5 ranked values, largest first. US options exchanges on the official participant listtable · 2026-10-07 · 20×4 Near the money AAPL implied volatility and vega by days to expiryranking · 2026-10-07 · 5×3Preview: 5 ranked values, largest first.
Market data quality checks that catch real bugs
Declared split ratio against the close ratio across the effective dateranking · 2026-10-07 · 10×3Preview: 10 ranked values, largest first. One symbol's quote messages against the sequence numbers they spanseries · 2026-10-07 · 60×3Preview: a 16-point series, ending higher. Condition codes on one hour of prints, named from the exchange reference listranking · 2026-10-07 · 9×3Preview: 9 ranked values, largest first. Venue stamp to consolidated stamp, minute by minuteseries · 2026-10-07 · 60×3Preview: a 16-point series, ending lower. Locked, crossed and one sided quote rates across six household namesranking · 2026-10-07 · 6×4Preview: 6 ranked values, smallest first.
Forex Pending Order Types: Limits & Stops
Median and 95th-percentile opening step by weekday (SPY, 2016 to 2026)series · 2026-10-07 · 5×3Preview: a 5-point series, roughly flat. How often a session reached a level set away from the open (SPY, 2016 to 2026)ranking · 2026-10-07 · 5×3Preview: 5 ranked values, largest first. How far the open landed from the prior close (SPY sessions, 2016 to 2026)ranking · 2026-10-07 · 6×3Preview: 6 ranked values, largest first. The ten largest opening steps in SPY, 2016 to 2026series · 2026-10-07 · 10×4Preview: a 10-point series, ending lower.
The Real Disadvantages of a Stock Split
What a one cent tick costs at each price levelranking · 2026-10-07 · 7×4Preview: 7 ranked values, largest first. A one cent tick before and after real forward splitstable · 2026-10-07 · 12×5 NVIDIA traded option strikes across its 2024 splitseries · 2026-10-07 · 7×4Preview: a 7-point series, ending lower. Share count, per share earnings and revenue across a splitseries · 2026-10-07 · 7×5Preview: a 7-point series, ending higher.
What A-share Level 2 Data Actually Contains
AAPL quote updates per three second interval, by Eastern clock hour (16 September 2026)ranking · 2026-10-07 · 16×3Preview: 16 ranked values, smallest first. Book events per three second interval across five household names (10:00 to 10:30 a.m. ET, 16 September 2026)ranking · 2026-10-07 · 5×3Preview: 5 ranked values, largest first. How many distinct best bid prices fit in one three second interval (AAPL, 16 September 2026)ranking · 2026-10-07 · 10×3Preview: 10 ranked values, smallest first.
How Many Shares in an Options Contract?
Recent reverse splits and the deliverable left behindranking · 2026-10-06 · 10×4Preview: 10 ranked values, smallest first. Average near-the-money premium per share, September 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, largest first. Fractional-ratio splits and the share count they leave per contractranking · 2026-10-06 · 12×4Preview: 12 ranked values, largest first. One quote, two multipliers: AAPL near-the-money premium converted to cashseries · 2026-10-06 · 21×4Preview: a 16-point series, ending lower.
Stock Correlation Matrix in One SQL Query
Daily bars per name against sessions shared with SPY, Oct 2025 to Sep 2026ranking · 2026-10-06 · 6×3Preview: 6 ranked values, largest first. AAPL and MSFT return correlation measured quarter by quarterranking · 2026-10-06 · 7×3Preview: 7 ranked values, largest first. Correlation of price levels against correlation of daily returns, same pairsranking · 2026-10-06 · 15×4Preview: 15 ranked values, largest first. Pairwise correlation of daily returns, six large caps, Oct 2025 to Sep 2026ranking · 2026-10-06 · 15×2Preview: 15 ranked values, largest first.
Limit Orders on Crypto Exchanges vs Stocks
The same stock, quoted venue by venue: AAPL spreads by exchangeranking · 2026-10-06 · 3×4Preview: 3 ranked values, smallest first. AAPL print sizes in one hour, Sep 23 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, largest first. Where AAPL's volume sat by ET hour, September 2026series · 2026-10-06 · 16×3Preview: a 16-point series, roughly flat. Average quoted spread across household names, five minutes on Sep 23 2026ranking · 2026-10-06 · 5×3Preview: 5 ranked values, smallest first.
Is a Covered Put Actually Covered?
One month of a crowded short, January 2021series · 2026-10-06 · 24×4Preview: a 16-point series, roughly flat. Twelve months of dividends a short seller owes, per shareranking · 2026-10-06 · 8×4Preview: 8 ranked values, largest first. Days to cover the reported short interest, household namesranking · 2026-10-06 · 8×3Preview: 8 ranked values, largest first. Best and worst 21-session moves since 2021ranking · 2026-10-06 · 6×3Preview: 6 ranked values, largest first.
Buy Stop vs Sell Stop Orders: How Each Fires
How often a 2 percent stop distance gets touched, by nameranking · 2026-10-06 · 6×3Preview: 6 ranked values, largest first. KO quoted spread by half hour of the ET clock, one pinned sessionseries · 2026-10-06 · 14×3Preview: a 14-point series, ending lower. SPY: share of sessions opening a given distance from the prior closeranking · 2026-10-06 · 5×3Preview: 5 ranked values, largest first. Apple's eight widest downside opening gaps since 2021ranking · 2026-10-06 · 8×4Preview: 8 ranked values, largest first.
Why a Limit Order Didn't Fill: 5 Causes
Where one session of AAPL prints actually happened, by venueranking · 2026-10-05 · 15×4Preview: 15 ranked values, largest first. Minutes a session spends near its own low, five household namesseries · 2026-10-05 · 5×4Preview: a 5-point series, roughly flat. Shares traded at KO's lowest price levels in one sessionranking · 2026-10-05 · 8×3Preview: 8 ranked values, smallest first. Odd lots versus round lots in one AAPL session: prints and sharesranking · 2026-10-05 · 5×4Preview: 5 ranked values, largest first.
What Price Does a Market Order Fill At?
Share of AAPL prints carrying a sub-penny price, by ET hour (Sep 16, 2026)ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first. AAPL quoted spread in five minute buckets, 9:00 to 11:00 a.m. ET (Sep 16, 2026)series · 2026-10-05 · 24×3Preview: a 16-point series, ending lower. Quoted spread across six household names, 11:00 to 11:30 a.m. ET on Sep 16, 2026ranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. How AAPL volume splits across print sizes, 10:00 a.m. to 3:00 p.m. ET (Sep 16, 2026)ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first.
Trading API vs Market Data API: Key Differences
Average quoted spread in basis points, 16 September 2026ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first. September 2026 end of day summary, five household namesranking · 2026-10-05 · 5×4Preview: 5 ranked values, largest first. AAPL top of book message volume by ET hour, 16 September 2026ranking · 2026-10-05 · 8×4Preview: 8 ranked values, largest first.
Protective Put vs Stop-Loss Order
How often six household names opened 2% or more below the prior close (10 years)table · 2026-10-05 · 6×5 AAPL's ten deepest overnight gaps down since October 2016, and where the session low wentseries · 2026-10-05 · 10×4Preview: a 10-point series, roughly flat.
Is There a Minimum Holding Period for Stocks?
SPY daily closes across a pinned 61 day wash sale window, Jan to Mar 2025series · 2026-10-05 · 41×4Preview: a 16-point series, roughly flat. Trades and share volume per session, six household names, September 2026ranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. Days between ex-dividend date and record date, ten household payersseries · 2026-10-05 · 19×4Preview: a 16-point series, roughly flat. Average days between ex-dividend dates, 2021 to dateseries · 2026-10-05 · 10×4Preview: a 10-point series, ending higher.
Iron Condor Win Rate and Expectancy
Short strikes touched versus short strikes finishing in the moneyseries · 2026-10-05 · 5×5Preview: a 5-point series, ending higher. Credit, risk and breakeven win rate for nine SPY condor structurestable · 2026-10-05 · 9×6 Premium per dollar of spot at the same 16 delta, five underlyingsranking · 2026-10-05 · 5×4Preview: 5 ranked values, largest first. Advertised iron condor win rate by short delta band (SPY)table · 2026-10-05 · 5×5
Gold vs Real Interest Rates: Does It Hold?
Five pinned episodes: real-yield move, GLD return, and the daily correlation inside eachtable · 2026-10-05 · 5×5 Rolling 12-month correlation: daily GLD returns vs daily changes in the 10-year real yieldtable · 2026-10-05 · 76×4 The 10-year real yield, built from the nominal yield and the breakeventable · 2026-10-05 · 80×5 GLD implied volatility by month, near-the-money contracts with 20 to 45 days to expiryseries · 2026-10-05 · 25×4Preview: a 16-point series, ending higher.
Do Multi-Leg Options Count as One Day Trade?
SPY contract volume by days to expiry, September 2026ranking · 2026-10-05 · 4×3Preview: 4 ranked values, largest first.
Can You Lose More Than You Invest?
The largest US oil tracking fund through April 2020: daily close and session lowseries · 2026-10-05 · 17×3Preview: a 16-point series, ending lower. 2023 run from the first close of the year: year end and peakranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. Deepest overnight gap down per name, 2015 to 2025 (split dates removed)ranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. One NVDA option contract, mid January to March 1, 2024: the furthest travellerseries · 2026-10-05 · 33×3Preview: a 16-point series, ending higher.
Can You Cancel a Limit Order Before It Fills
How often the best quote changed, fifteen minute buckets, Sep 15 2026series · 2026-10-05 · 26×3Preview: a 16-point series, ending lower.
page 15 of 33
Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling window

Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling window

most recentas of scalar 1×2read in context →
win start et min
570
win end et min
570
the exact SQL behind every number 
SELECT toHour(toTimeZone(toDateTime(today() - 14) + toIntervalMinute(810), 'America/New_York')) * 60
         + toMinute(toTimeZone(toDateTime(today() - 14) + toIntervalMinute(810), 'America/New_York')) AS win_start_et_min,
       toHour(toTimeZone(toDateTime(today() - 4) + toIntervalMinute(810), 'America/New_York')) * 60
         + toMinute(toTimeZone(toDateTime(today() - 4) + toIntervalMinute(810), 'America/New_York')) AS win_end_et_min
More from this analysisWhy Are Spreads Wider at the Open? Real Data
MU into July 7, 2026: prior regular-session close, opening print, overnight gap scalar 1×3 → Share of quote updates at the one-cent minimum spread, by half hour (regular hours, ET) series 13×4 → Median spread each half hour, as a multiple of each name's tightest bucket (regular hours, ET) series 13×4 → MU: median quoted spread by half hour on July 7, 2026 (ET, regular hours) series 13×5 → See all 3,293 queries →
$