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

JNJ Dividend 2026: Dates, Raise and Yield
The annual step up in the JNJ quarterly dividend rate, and the running streakranking · 2026-10-17 · 11×3Preview: 11 ranked values, largest first. JNJ monthly price range in 2026series · 2026-10-17 · 10×4Preview: a 10-point series, ending higher. JNJ dividends per share by calendar year, with the top quarterly rate declared in eachtable · 2026-10-17 · 11×6
JNJ Dividend: Yield, History & Ex-Dates
JNJ dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.34 JNJ recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. JNJ total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
IV Rank vs IV Percentile: Formulas Explained
IV rank vs IV percentile, eight liquid names, 52 week lookbacktable · 2026-10-17 · 8×5 The same session scored at five different lookback windowsranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. Current, 52 week low and 52 week high ATM IV for each nametable · 2026-10-17 · 8×6 AAPL at the money implied volatility, weekly, trailing 52 weeksseries · 2026-10-17 · 53×5Preview: a 16-point series, ending lower. One stock, one session, three definitions of the IV inputtable · 2026-10-17 · 3×6
Iron Condor Screener from the SQL API
How many of each week's candidates still cleared a week laterseries · 2026-10-17 · 11×5Preview: a 11-point series, roughly flat. Survivors as the credit floor and the delta band moveranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. Where each underlying's implied volatility sits in its own yearranking · 2026-10-17 · 6×4Preview: 6 ranked values, smallest first. One chain, one expiration: delta at every 5 point striketable · 2026-10-17 · 18×5 Iron condor candidates that cleared every filtertable · 2026-10-17 · 8×7
Investing at All-Time Highs: What the Data Says
Calendar days from a record close to the next one, SPYranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. Forward price change after record closes vs all other sessions, SPYtable · 2026-10-17 · 3×7 Deepest closing declines from a record close, SPYtable · 2026-10-17 · 7×5 Record closes per year, SPY (price basis, first four years of the file excluded)table · 2026-10-17 · 20×7
IBM Dividend: Yield, History & Ex-Dates
IBM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.69 IBM recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. IBM total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
How to Read an Options Symbol (OSI Format)
One eight-digit field, from single-dollar strikes to index levelstable · 2026-10-17 · 4×6 One expiration, four strikes: every OSI field cut out of the symboltable · 2026-10-17 · 8×7
How to Invest in the DAX: Which Index You Get
When a US listed German equity fund trades, by ET half hourseries · 2026-10-17 · 32×3Preview: a 16-point series, roughly flat. Price only versus dividends reinvested, both starting at 100ranking · 2026-10-17 · 15×4Preview: 15 ranked values, smallest first. What a distributing fund pays out, and whenseries · 2026-10-17 · 14×4Preview: a 14-point series, roughly flat.
How to Check if a Fund Still Owns a Stock
How old the newest available 13F snapshot is, day by dayseries · 2026-10-17 · 91×2Preview: a 16-point series, ending lower. What kind of position every 13F line actually reportsranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Days between a quarter end and the 13F-HR that reports itseries · 2026-10-17 · 22×5Preview: a 16-point series, ending higher. One filer's reported Apple position, quarter by quarterseries · 2026-10-17 · 22×4Preview: a 16-point series, ending lower.
How Stock Splits Get Announced: 8-K to Ex-Date
Splits with an effective date still ahead, inside the next six monthstable · 2026-10-17 · 35×5 Announcement to effective date: the spread across forward splitsranking · 2026-10-17 · 5×2Preview: 5 ranked values, smallest first. Median wait from first split story to effective date, by monthseries · 2026-10-17 · 19×6Preview: a 16-point series, ending lower. The quickest and slowest announcement windows, by companytable · 2026-10-17 · 10×5
How Stock Settlement Works Under T+1
Trade date to settlement date across real sessions, November 2025series · 2026-10-17 · 11×5Preview: a 11-point series, ending higher. Ex-dividend date to payment date, latest 2026 dividend for nine household payersseries · 2026-10-17 · 9×4Preview: a 9-point series, ending higher. Microsoft dividend dates, from the T+2 era into T+1series · 2026-10-17 · 14×6Preview: a 14-point series, ending lower. Gap between ex-dividend date and record date, by yearranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first.
How QQQ Holdings Are Weighted, and Capped
QQQ volume on the December reconstitution Friday against the rest of the monthranking · 2026-10-17 · 10×4Preview: 10 ranked values, smallest first. Average daily dollar volume, non-technology Nasdaq-100 members, trailing three monthsranking · 2026-10-17 · 12×2Preview: 12 ranked values, largest first. Market value of the largest Nasdaq-100 securities, and each one's share of the groupranking · 2026-10-17 · 11×3Preview: 11 ranked values, largest first.
How Pre-IPO Shares Trade Before the Ticker
Offer price versus first open and first close, larger US IPOs of the trailing yeartable · 2026-10-17 · 12×8 DXYZ close versus its June 30, 2026 published NAV of $34.30series · 2026-10-17 · 35×6Preview: a 16-point series, ending lower. DXYZ monthly closes and ranges since its March 2024 listingseries · 2026-10-17 · 32×5Preview: a 16-point series, roughly flat. DXYZ weekly closes through the 2026 premium peak and the SpaceX listingseries · 2026-10-17 · 29×5Preview: a 16-point series, ending lower.
How Often Mutual Funds Change Holdings
Days from quarter end to 13F filing date, by reporting quarterseries · 2026-10-17 · 8×4Preview: a 8-point series, roughly flat. Price change since the last quarter-end snapshot dateranking · 2026-10-17 · 6×4Preview: 6 ranked values, smallest first. How old each quarter-end holdings snapshot is todayseries · 2026-10-17 · 6×4Preview: a 6-point series, ending lower. Splits and new listings per month across the US marketseries · 2026-10-17 · 13×3Preview: a 13-point series, ending lower.
How Often Do Stocks Split?
The most common reverse-split ratios, 2016 to todayranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. Forward and reverse stock splits per year, 2016 to todayranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first. The most common forward-split ratios, 2016 to todayranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. Every share-count adjustment since 2016, by typeranking · 2026-10-17 · 3×2Preview: 3 ranked values, largest first. Recent forward splits among widely held stocksseries · 2026-10-17 · 10×4Preview: a 10-point series, roughly flat.
How Much Does One Share of Stock Cost?
Median and 90th percentile US share price, by monthseries · 2026-10-17 · 48×4Preview: a 16-point series, ending lower. Highest closing share prices on the most recent sessionranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. How many US stocks trade in each price bandranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first. Price to earnings ratio, same ten household namesranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. Closing share price, ten household US namesranking · 2026-10-17 · 10×2Preview: 10 ranked values, largest first.
How Many Puts to Hedge a Portfolio: Formula
What rounding the contract count leaves uncovered, by account sizetable · 2026-10-17 · 7×6 SPY put premium as a percent of protected notional, by strike distanceranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. The same $189,000 hedge priced three ways (levels scaled from the ETF close)table · 2026-10-17 · 3×6 Beta for six household names, measured over two consecutive 12-month windowsranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first.
How Long Can a Stock Trade Under $1? The Rules
Listed stocks closing under $1, session by session, trailing five monthsseries · 2026-10-17 · 104×3Preview: a 16-point series, ending higher. How long the sub-$1 names have already been there: consecutive sessions closing under $1ranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. Reverse splits executed per month, trailing twelve full monthsseries · 2026-10-17 · 12×3Preview: a 12-point series, ending lower. Listed stocks closing under $1 on the latest session, by price bandranking · 2026-10-17 · 5×4Preview: 5 ranked values, smallest first.
How Do Market Makers Make Money? The Spread
US stock venues: public exchanges vs off-exchange reporting facilitiesranking · 2026-10-17 · 2×3Preview: 2 ranked values, largest first. AAPL trades by venue, latest session: off-exchange firstranking · 2026-10-17 · 19×4Preview: 16 ranked values, largest first. Average quoted spread: liquid mega-caps vs a thin small-cap (past week)ranking · 2026-10-17 · 3×4Preview: 3 ranked values, smallest first. AAPL average quoted spread by half-hour (ET), one extended sessionseries · 2026-10-17 · 32×2Preview: a 16-point series, ending lower. AAPL: NBBO quote updates on the latest sessionscalar · 2026-10-17 · 1×40.93
How DAX Index Weights Are Calculated
Price move versus dividends paid, 2021 through 2025ranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. A 10 percent index cap, worked on a 40 stock baskettable · 2026-10-17 · 12×5
How Companies Execute Buybacks: Rule 10b-18
Diluted shares outstanding by calendar quarter, three long-running programmesseries · 2026-10-17 · 20×4Preview: a 16-point series, ending lower. Three-year change in diluted share count, ten household namesranking · 2026-10-17 · 10×4Preview: 10 ranked values, smallest first. Share of continuous-session volume, by half hour of the trading dayseries · 2026-10-17 · 13×3Preview: a 13-point series, ending higher. A day's repurchase ceiling under the 25% volume conditionranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first.
How Big Is the OPRA Options Quote Feed?
One session, two tapes: every options NBBO update vs. every stock NBBO updatescalar · 2026-10-17 · 1×95.37 SPY's 2026-expiry option chain: one root's share of the quote firehosescalar · 2026-10-17 · 1×13138.7 The five busiest SPY option contracts of the session, symbol unpackedseries · 2026-10-17 · 5×7Preview: a 5-point series, roughly flat.
How After-Market Orders Work: AMO vs Live
AAPL volume by ET half hour, September 2026series · 2026-10-17 · 32×3Preview: a 16-point series, roughly flat. Share of monthly volume by session phase, September 2026ranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. Median overnight gap against median intraday range, twelve months to September 2026ranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Upcoming US market holidays and early closesseries · 2026-10-17 · 12×7Preview: a 12-point series, ending higher.
How ADRs Work: Ratios, Fees and Dividends
A year of tape on five large exchange-listed foreign issuer receiptsranking · 2026-10-17 · 5×2Preview: 5 ranked values, largest first. Recent share-count adjustments on large foreign issuer receiptsranking · 2026-10-17 · 8×3Preview: 8 ranked values, largest first. Dividend cadence and annual cash per share, receipts against US payersranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. Days from ex-dividend date to payment, four years of distributionsranking · 2026-10-17 · 8×3Preview: 8 ranked values, largest first.
HON Dividend: Yield, History & Ex-Dates
HON dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.7 HON recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending higher. HON total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Historical Volatility vs Implied Volatility
SPY: monthly implied volatility against the next month's realized volatilityseries · 2026-10-17 · 17×4Preview: a 16-point series, ending lower. Average implied volatility against next-month realized volatility, by nametable · 2026-10-17 · 6×5 Annualized historical volatility over three lookback windowsranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first. AAPL realized volatility: 20-session against 60-session lookbackseries · 2026-10-17 · 72×3Preview: a 16-point series, ending higher.
Highest IV Rank Stocks Right Now
Where IV percentile sits furthest above IV rank, latest sessiontable · 2026-10-17 · 12×6 How the screened universe distributes across IV rank, latest sessiontable · 2026-10-17 · 10×7
page 9 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 →
$