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

When Do Options Start Trading After an IPO?
How a new option chain widens: strikes and expirations tradedranking · 2026-10-17 · 12×3Preview: 12 ranked values, smallest first.
When Do NDX Options Expire?
Listed QQQ option expirations by weekday, trailing 90 days of traded contractsranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Share of QQQ regular-session volume in the first 15 minutes, monthly expiration Fridaysseries · 2026-10-17 · 12×4Preview: a 12-point series, ending lower. NDX monthly expirations ahead: third Friday, Thursday last trade, exchange statusseries · 2026-10-17 · 8×6Preview: a 8-point series, ending higher. QQQ volume by ET hour: quarterly expiration Friday (2026-09-18) vs the prior Friday (2026-09-11)series · 2026-10-17 · 7×3Preview: a 7-point series, ending higher.
When Do Index Funds Trade? ETFs vs Mutual Funds
Quoted spread on large index ETFs, five-minute slice of September 15, 2026ranking · 2026-10-17 · 6×3Preview: 6 ranked values, smallest first. Two index ETFs through one session, September 15, 2026 (percent change from the day's first print)series · 2026-10-17 · 32×3Preview: a 16-point series, roughly flat. How wide each session ran from high to low, as a percent of the closeseries · 2026-10-17 · 31×3Preview: a 16-point series, ending higher. How many separate trades an index ETF prints per session (VOO)series · 2026-10-17 · 17×3Preview: a 16-point series, ending higher.
What Time Do Options Start Trading?
SPY option volume, minute by minute into the 9:30 openseries · 2026-10-17 · 46×3Preview: a 16-point series, ending higher. US option contract volume by Eastern-time half hourseries · 2026-10-17 · 21×3Preview: a 16-point series, ending higher. Scheduled open and close on every upcoming half dayseries · 2026-10-17 · 2×6Preview: a 2-point series, roughly flat.
What Stocks Are in the DAX 40?
SAP's US line: price move vs dividend contribution by yearranking · 2026-10-17 · 10×4Preview: 10 ranked values, largest first. Dividend dates per year: SAP's US line vs Coca-Colaranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. How a 15% weight cap bites in a market-cap-weighted basketranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first.
What It Costs to Trade a Stock, Measured
The one-cent floor: share price, percent of quotes exactly one cent wide, and what a penny costs in bpstable · 2026-10-17 · 5×6 NVDA vs SOXS: median quoted spread over the window, with the smallest single-session gapscalar · 2026-10-17 · 1×50.86 NVDA vs SOXS: median quoted spread by session (bps of the midpoint)series · 2026-10-17 · 5×4Preview: a 5-point series, ending lower. The cost-to-trade ladder: median quoted spread in bps of the midpoint, regular hours, recent completed sessionstable · 2026-10-17 · 12×5
What Is Vomma? The Convexity of Vega
How far the vega-only estimate falls short, by size of the vol moveranking · 2026-10-17 · 7×3Preview: 7 ranked values, smallest first. Vega and vomma across strikes, one SPY expiryranking · 2026-10-17 · 7×4Preview: 7 ranked values, largest first. Implied volatility across strikes on the same SPY expiryranking · 2026-10-17 · 7×4Preview: 7 ranked values, largest first. Percent change in vega per vol point, by time to expiry (SPY)ranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first.
What Is VIX1D? The 1-Day Volatility Index
Implied daily move (IV / 16) against realized daily movement, SPY by monthseries · 2026-10-17 · 13×5Preview: a 13-point series, ending higher. SPY option volume by expiration through one session, June 17 2026series · 2026-10-17 · 14×4Preview: a 14-point series, ending lower. SPY near-the-money implied volatility by days to expiryranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. SPY absolute daily move, median and 90th percentile by yearranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first.
What Is the Term Premium in Bond Yields?
Ten year inflation expectations: market implied against model basedseries · 2026-10-17 · 18×5Preview: a 16-point series, ending lower. The 10 year yield split into implied inflation and an implied real yieldseries · 2026-10-17 · 18×5Preview: a 16-point series, ending higher. Month over month change in the 3 month bill and the 10 year, in basis pointsseries · 2026-10-17 · 26×4Preview: a 16-point series, ending higher. The 5 year, the 10 year, and the implied 5y5y forward rateseries · 2026-10-17 · 26×5Preview: a 16-point series, ending higher. The Treasury curve now and a year ago, by maturitytable · 2026-10-17 · 6×3
What Is the NBBO? National Best Bid and Offer
NBBO updates per session: four heavily traded names vs. two thin small capsseries · 2026-10-17 · 6×5Preview: a 6-point series, ending lower. Exchange stamp to SIP stamp: the consolidation step, in microsecondsranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. The smallest size the NBBO will show: six names across the price tiersranking · 2026-10-17 · 6×4Preview: 6 ranked values, smallest first. KO: ten consecutive NBBO updates from 1:30 p.m. ET on a recent sessionseries · 2026-10-17 · 10×7Preview: a 10-point series, roughly flat. GME, 2024-05-14: NBBO updates and trades per minute across a five-minute LULD pauseseries · 2026-10-17 · 15×3Preview: a 15-point series, roughly flat. AAPL: average NBBO updates per minute by half-hour bucket (ET, 4 a.m. to 8 p.m.)series · 2026-10-17 · 32×3Preview: a 16-point series, roughly flat.
What Is the 5s30s Spread? 20 Years of Data
Inverted sessions per year: 2s10s, 5s30s, and the split stateranking · 2026-10-17 · 9×4Preview: 9 ranked values, smallest first. The 5s30s spread month by month, with both legsseries · 2026-10-17 · 241×4Preview: a 16-point series, ending higher. Which leg moved: 5-year and 30-year travel inside each inversionranking · 2026-10-17 · 14×4Preview: 14 ranked values, smallest first. Every 5s30s inversion of at least five sessions, last 30 yearstable · 2026-10-17 · 14×5 5s30s and 2s10s, monthly averages over 20 yearsseries · 2026-10-17 · 241×3Preview: a 16-point series, ending higher.
What Is the 3m10y Spread? The Fed's Yield Curve
3-month and 10-year yields with both spreads, last 90 daysseries · 2026-10-17 · 62×6Preview: a 16-point series, ending lower. 3m10y and 2s10s spreads, monthly averages over twenty yearsseries · 2026-10-17 · 241×4Preview: a 16-point series, ending higher. Every 3m10y inversion since 1985, on monthly averagesseries · 2026-10-17 · 9×6Preview: a 9-point series, roughly flat. Three tenors through the 2022 hiking cycle, monthly averagesseries · 2026-10-17 · 42×5Preview: a 16-point series, ending higher. 2s10s versus 3m10y in three inversion windows, daily closestable · 2026-10-17 · 3×9
What Is the 2s10s Spread? Yield Curve Data
The 2s10s spread as of the latest close (10-year minus 2-year)scalar · 2026-10-17 · 1×54.77 2s10s spread, monthly average: last 20 yearsseries · 2026-10-17 · 240×2Preview: a 16-point series, ending higher. 2s10s inversion episodes: first close, last close, length, and depthranking · 2026-10-17 · 11×4Preview: 11 ranked values, smallest first. US Treasury yield curve: latest available yield per maturityranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
What Is FINRA Short Interest? Days to Cover
TSLA short interest vs. average daily volume, bi-monthly (last 2 years)series · 2026-10-17 · 47×3Preview: a 16-point series, ending lower. Short interest reporting dates: recent settlements, weekday, coverage and publication lagseries · 2026-10-17 · 9×5Preview: a 9-point series, ending lower. How liquid US stocks distribute by short interest as a percent of shares outstandingranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. The latest FINRA short interest file: one snapshot of the whole marketscalar · 2026-10-17 · 1×422,579 GameStop, Nov 2020 – Mar 2021: short interest, days to cover and the closing price at each settlementseries · 2026-10-17 · 10×4Preview: a 10-point series, ending higher. Days to cover across all liquid US tickers, latest settlement (min 1M shares/day)scalar · 2026-10-17 · 1×62,923 Six household names at the latest settlement: shares short, percent of shares outstanding, days to covertable · 2026-10-17 · 6×6
What Is RVOL (Relative Volume)? How to Read It
SPY: median shares traded per minute, by 30-minute clock bucket (ET, last 30 days, extended hours)series · 2026-10-17 · 32×2Preview: a 16-point series, roughly flat. SPY: average share of full-day volume completed by each clock time (last 20 sessions)ranking · 2026-10-17 · 5×2Preview: 5 ranked values, smallest first. Top 10 by full-day RVOL: latest completed session (20-day ADV above 5M shares, full history required)series · 2026-10-17 · 10×5Preview: a 10-point series, ending lower. Full-day RVOL percentiles across high-volume US stocks and ETFs (20-day ADV above 5M shares), latest completed sessionranking · 2026-10-17 · 6×2Preview: 6 ranked values, smallest first. MU, the biggest-volume session of June 2026: time-adjusted vs. naive RVOL, plus the full-day figurescalar · 2026-10-17 · 1×832.8
What Is Form N-PORT? Fund Holdings Filing
Most-filed EDGAR form types over the trailing yearranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. When Q1 2026 13F reports landed, by week after quarter endranking · 2026-10-17 · 13×2Preview: 13 ranked values, largest first. How long institutional managers take to file a 13F after quarter endseries · 2026-10-17 · 13×4Preview: a 13-point series, roughly flat.
Risk Reversal Options: Sell a Put, Buy a Call
The two legs closest to 25 delta, and what they net totable · 2026-10-17 · 3×6 Payoff per share at expiration across AAPL prices, against owning the sharestable · 2026-10-17 · 11×5 The 25-delta risk reversal for SPY, AAPL and TSLA, nearest-to-30-day expiration, latest sessiontable · 2026-10-17 · 3×6 AAPL out-of-the-money strip for the Aug 21, 2026 expiration, priced at the Jul 20, 2026 closetable · 2026-10-17 · 28×5
What Is a Reverse Stock Split? Good or Bad?
2026 executed US stock splits: reverse vs. forwardscalar · 2026-10-17 · 1×3969 The most recent US reverse stock splits on recordseries · 2026-10-17 · 12×4Preview: a 12-point series, roughly flat. 2026's most common reverse split ratiosranking · 2026-10-17 · 10×2Preview: 10 ranked values, largest first. Where reverse-split companies stood a year later (splits executed 12-18 months ago)ranking · 2026-10-17 · 3×3Preview: 3 ranked values, largest first. ASST: daily closes around its 1-for-20 reverse split (execution date 2026-02-06)series · 2026-10-17 · 69×3Preview: a 16-point series, ending higher. Reverse vs. forward splits by year, 2019 to todayranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first. ASST's reverse split history on recordseries · 2026-10-17 · 2×6Preview: a 2-point series, roughly flat. What happened next: median move after a reverse split vs. SPY, splits executed 4-9 months agoseries · 2026-10-17 · 3×7Preview: a 3-point series, ending higher.
What Is a Liquidity Heatmap? How to Read One
AAPL top of book by half hour (ET), latest session: NBBO updates and displayed size at the best bid and ask as a share of the peak bucketseries · 2026-10-17 · 32×4Preview: a 16-point series, ending lower.
What Is a High VIX? Levels and Extremes
SPY realized volatility by calendar year, with the biggest day and the count of 2%+ sessionsranking · 2026-10-17 · 23×4Preview: 16 ranked values, smallest first. SPY daily closes from the VIX record close (March 16, 2020) through March 27series · 2026-10-17 · 10×4Preview: a 10-point series, ending higher. SPY on August 5, 2024, in half-hour buckets (ET): the low and the close of eachseries · 2026-10-17 · 13×3Preview: a 13-point series, ending higher. SPY 30-day at-the-money implied volatility, sessions per VIX-style rungranking · 2026-10-17 · 4×4Preview: 4 ranked values, largest first.
What Is a Good Dividend Yield in 2026?
Where US dividend payers sit: yield bands, $1B+ market cap, latest snapshotranking · 2026-10-17 · 7×4Preview: 7 ranked values, largest first. The 10-year Treasury yield, month by month: July 2021 to the latest reading on fileseries · 2026-10-17 · 61×3Preview: a 16-point series, ending higher. Trailing yield by sector fund: twelve months of distributions over the late-July 2026 priceranking · 2026-10-17 · 11×4Preview: 11 ranked values, largest first. Intel (INTC): month-end price, quarterly dividend, and quoted yield, Jan 2021 to Jun 2024series · 2026-10-17 · 42×5Preview: a 16-point series, ending lower. Current yield vs five-year dividend growth: ten household payers, July 2026ranking · 2026-10-17 · 10×4Preview: 10 ranked values, smallest first.
What Is a Calendar Spread in Options?
Near the money implied volatility by expiry band, three namesranking · 2026-10-17 · 6×4Preview: 6 ranked values, smallest first. AAPL front band against back band implied volatility, trailing monthsseries · 2026-10-17 · 82×4Preview: a 16-point series, ending lower. How often front volatility sat above back volatilityranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. Theta and vega across expiry bands, near the money AAPLranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first.
What Is a Bid-Ask Spread? Real Costs
Typical quoted spread: six liquid names vs. two thin small caps, with the 100-share costranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first. AAPL median quoted spread by 30-minute bucket (ET, extended hours included)series · 2026-10-17 · 32×2Preview: a 16-point series, ending lower. The same curve at four checkpoints: premarket, the open, midday, the closeseries · 2026-10-17 · 4×2Preview: a 4-point series, ending lower. AAPL: the last recorded NBBO quote in our data windowscalar · 2026-10-17 · 1×70.029
What Happens When the Yield Curve Un-Inverts
Which leg did the work: 2-year and 10-year moves over the 91 days before each crossingtable · 2026-10-17 · 7×9 SPY's change from the crossing-day close, 3, 6 and 12 months after each un-inversiontable · 2026-10-17 · 2×5 The 2s10s spread by month, full historyseries · 2026-10-17 · 605×5Preview: a 16-point series, ending lower.
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
$