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

Options Expiration Calendar 2026: All 12 Dates
Every 2026 monthly options expiration dateseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. Was the April expiration Friday a trading day?ranking · 2026-10-17 · 11×4Preview: 11 ranked values, largest first. AAPL contracts traded into each 2026 expiration date, H1series · 2026-10-17 · 68×4Preview: a 16-point series, ending lower.
Options Approval Levels: What Each Tier Allows
Every $5 call spread on the same AAPL expiration: risk against maximum gainranking · 2026-10-17 · 7×3Preview: 7 ranked values, largest first. Largest single-session move, open to close, since 2016ranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first. What a covered call collects across strikes: AAPL, about one month outtable · 2026-10-17 · 6×5 Cash needed to hold 100 shares, six household namesranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first.
Open-Source GEX Dashboard: How It Works
The same chain, a different question: in the money value by settlement priceranking · 2026-10-17 · 23×2Preview: 16 ranked values, largest first. Gross SPY call and put gamma against the net, trailing 60 calendar daysseries · 2026-10-17 · 42×5Preview: a 16-point series, ending higher. Signed SPY gamma exposure by expiry, next three weeksranking · 2026-10-17 · 11×4Preview: 11 ranked values, largest first. SPY gamma exposure by strike, latest session, contracts inside 30 daystable · 2026-10-17 · 23×5
On-the-Run vs Off-the-Run Treasuries
Average yield step between benchmark tenors, trailing four monthsranking · 2026-10-17 · 2×3Preview: 2 ranked values, smallest first. 2-year and 10-year constant maturity yields, month by monthseries · 2026-10-17 · 24×5Preview: a 16-point series, ending higher. Typical one-day move in the 10-year yield, by monthseries · 2026-10-17 · 24×4Preview: a 16-point series, ending lower. The Treasury constant maturity curve, latest published sessionranking · 2026-10-17 · 10×3Preview: 10 ranked values, smallest first.
O Dividend: Yield, History & Ex-Dates
O dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.272 O recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. O total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
NYSE Parity and D-Quotes: How Fills Allocate
Average shares per trade, ten household namesranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. Coca-Cola closing print as a share of session volume, by monthseries · 2026-10-17 · 25×2Preview: a 16-point series, ending lower. The closing auction print as a share of regular-session volumeranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first.
NVDA Implied Volatility: IV Now & Its History
NVDA ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. NVDA vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. NVDA at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
Non-Marginable Securities: Reg T vs House
Symbols closing the month below $5 and below $1, past two yearsseries · 2026-10-17 · 24×3Preview: a 16-point series, roughly flat. Symbol count and average daily range, by price bucketranking · 2026-10-17 · 6×3Preview: 6 ranked values, smallest first. Average daily range of recent listings, by age since listingranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first.
NKE Dividend: Yield, History & Ex-Dates
NKE dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.41 NKE recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. NKE total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
NFLX Stock Split History: Every Netflix Split
Nominal share prices and the most recent split on recordranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. NFLX near-the-money strike ladder: implied volatility and traded volumeranking · 2026-10-17 · 17×3Preview: 16 ranked values, smallest first. Every Netflix (NFLX) stock split on record, with ratio and chart divisorseries · 2026-10-17 · 3×5Preview: a 3-point series, ending lower. Most recent split ratio on record for household-name US listingsranking · 2026-10-17 · 11×3Preview: 11 ranked values, largest first.
NEE Dividend: Yield, History & Ex-Dates
NEE dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.623 NEE recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. NEE total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
NDX vs QQQ Options: Which One to Trade?
QQQ on the latest session: at-the-money IV, contracts traded and total volumescalar · 2026-10-17 · 1×720.7 QQQ ex-dividend dates and cash per share, most recent firstseries · 2026-10-17 · 9×4Preview: a 9-point series, ending lower. QQQ expiration dates that traded, by weekday, over the last ~45 daysranking · 2026-10-17 · 5×2Preview: 5 ranked values, smallest first. Contract size: one QQQ contract from the latest daily closescalar · 2026-10-17 · 1×4709.8
Mutual Fund Order Cutoff Times by Broker
Upcoming US market closures and early closesseries · 2026-10-17 · 12×7Preview: a 12-point series, ending higher. Full sessions versus shortened sessions over the trailing yearranking · 2026-10-17 · 2×2Preview: 2 ranked values, largest first. Shortened sessions on the SPY tape since January 2024series · 2026-10-17 · 6×5Preview: a 6-point series, roughly flat.
Mutual Fund Frequent Trading Limits Explained
SPY five-minute price marks across one full sessionseries · 2026-10-17 · 78×2Preview: a 16-point series, ending lower. Minutes traded and distinct prices on the same sessionranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. How far SPY sat from its own closing print, by time of dayseries · 2026-10-17 · 13×3Preview: a 13-point series, ending lower. Trading sessions inside common calendar-day block windowsranking · 2026-10-17 · 4×2Preview: 4 ranked values, smallest first.
Mutual Fund Forward Pricing Rule Explained
Upcoming exchange closures, the days a fund NAV is skipped or shortenedseries · 2026-10-17 · 12×5Preview: a 12-point series, ending higher. Shares a $10,000 order buys at the screen NAV versus the struck NAV, ten sharpest sessionsranking · 2026-10-17 · 10×4Preview: 10 ranked values, largest first. How far one closing value lands from the last (SPY daily closes, 2023 onward)ranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Average distance from each ET clock mark to the closing print (SPY, trailing months)series · 2026-10-17 · 13×3Preview: a 13-point series, ending lower.
Mutual Fund Exchange vs Selling and Rebuying
How many calendar days one trading session sits from the nextranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. Upcoming US market holidays and early closesseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. Average SPY volume per minute over the final half hour of the sessionseries · 2026-10-17 · 30×2Preview: a 16-point series, ending higher.
Mutual Fund Cutoffs on Early-Close Days
Minute bars and volume per session: early closes against full sessions, Nov-Dec 2025ranking · 2026-10-17 · 2×4Preview: 2 ranked values, smallest first. SPY volume by half hour: a 1:00 p.m. half day against an ordinary Fridayseries · 2026-10-17 · 13×3Preview: a 13-point series, ending higher. Upcoming 1:00 p.m. early closes, with the hour before each oneseries · 2026-10-17 · 2×6Preview: a 2-point series, ending higher. Every upcoming closure, tagged full closure or early closeseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher.
MSTR Implied Volatility: IV Now & Its History
MSTR ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. MSTR vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. MSTR at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
MSFT Implied Volatility: IV Now & Its History
MSFT ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. MSFT vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. MSFT at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
MSFT Dividend 2026: Dates, Raise, Per Share
Indicated dividend yield on every Microsoft ex-dividend date since 2024series · 2026-10-17 · 11×6Preview: a 11-point series, roughly flat. Trailing yield and payout ratio at the latest stored Microsoft closescalar · 2026-10-17 · 1×7529.05 Microsoft dividends with a 2026 ex-dividend dateseries · 2026-10-17 · 4×7Preview: a 4-point series, ending higher. Microsoft's September dividend raises since 2020, read from each year's November ex-datetable · 2026-10-17 · 7×7 Dividends per share for 2026: calendar year vs Microsoft's July-to-June fiscal yearranking · 2026-10-17 · 2×4Preview: 2 ranked values, largest first.
MSFT Dividend: Yield, History & Ex-Dates
MSFT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.98 MSFT recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. MSFT total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
MS Dividend: Yield, History & Ex-Dates
MS dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.15 MS recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. MS total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
MRK Dividend: Yield, History & Ex-Dates
MRK dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.85 MRK recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. MRK total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Most Shorted Stocks Right Now, Measured
The receipts: universe size, filter bite, median crowding, and list churn at the latest printscalar · 2026-10-17 · 1×522,579 Largest short positions by shares: latest settlement, liquid namesranking · 2026-10-17 · 10×4Preview: 10 ranked values, largest first. Crowding leaders vs. their own price: about one month of sessionsseries · 2026-10-17 · 4×5Preview: a 4-point series, ending lower. GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-10-17 · 10×4Preview: a 10-point series, ending lower. Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-10-17 · 8×4Preview: a 8-point series, ending lower. Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first. Highest days to cover among liquid names: latest settlement on filetable · 2026-10-17 · 10×5
The Most Common SEC Filings, Explained by Data
Total EDGAR filings and the Form 4 share, by quarter (last 12 full quarters)table · 2026-10-17 · 12×6 The EDGAR filing index at a glance: trailing 12 monthsscalar · 2026-10-17 · 1×71.2 The most common SEC form types: share of all EDGAR filings, trailing 12 monthsranking · 2026-10-17 · 12×2Preview: 12 ranked values, largest first. Where the well-known SEC forms rank: filings and overall rank, trailing 12 monthsranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. Apple's EDGAR footprint: filings by form type, trailing 12 monthstable · 2026-10-17 · 6×6 The most-amended SEC forms: /A filings, trailing 12 monthsranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first.
Most Active Stocks After Hours: How It Works
AAPL median quoted spread by half hour, across the close (July 29, 2026)series · 2026-10-17 · 10×3Preview: a 10-point series, roughly flat. One evening ranked: after-hours volume against the same day's regular sessionranking · 2026-10-17 · 13×4Preview: 13 ranked values, largest first. How often an after-hours extreme sat outside the next regular session's rangeseries · 2026-10-17 · 13×4Preview: a 13-point series, roughly flat. Where the extended trading day's volume actually sits, by ET clock hourseries · 2026-10-17 · 16×4Preview: a 16-point series, roughly flat.
Monthly Dividend Stocks: The Full List
Yield distribution across liquid monthly payers, with each band's median 12-month price changetable · 2026-10-17 · 5×5 Realty Income's declared monthly rate by calendar year, the raise over the prior year, and the steps up inside each yeartable · 2026-10-17 · 12×5 Monthly dividend stocks - filing companies paying every month, ranked by daily traded valuetable · 2026-10-17 · 31×6 Monthly payers in the dividend record, by completed calendar yearranking · 2026-10-17 · 21×3Preview: 16 ranked values, smallest first.
page 7 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 →
$