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

Monthly Dividend Stocks: The Full List
Monthly payers yielding above 12% - the price move and the payment move behind the numbertable · 2026-10-17 · 15×5 Recurring cash payments per ticker over the trailing year - where the monthly band sitsranking · 2026-10-17 · 7×4Preview: 7 ranked values, largest first.
Monthly Dividend ETFs: Who Actually Pays
Trailing 12 month distribution rate, by fund familyranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. Distributions per year: monthly funds beside quarterly benchmarksranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. Days from ex dividend date to cash, monthly paying fundsranking · 2026-10-17 · 9×2Preview: 9 ranked values, largest first. Monthly cash per share: an option income fund and a bond fundseries · 2026-10-17 · 24×3Preview: a 16-point series, roughly flat.
MOC and MOO Order Cutoff Times: NYSE & Nasdaq
SPY minute volume into the close, June 30 2026 (quarter end)series · 2026-10-17 · 31×2Preview: a 16-point series, ending higher. Share of SPY's regular-session volume by five-minute ET bucketseries · 2026-10-17 · 79×2Preview: a 16-point series, ending lower. Opening and closing windows as a share of regular-session volumeranking · 2026-10-17 · 8×3Preview: 8 ranked values, largest first. SPY: opening and closing window share of session volume, by monthseries · 2026-10-17 · 25×3Preview: a 16-point series, roughly flat.
MO Dividend: Yield, History & Ex-Dates
MO dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.11 MO recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. MO total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
MMM Dividend: Yield, History & Ex-Dates
MMM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.78 MMM recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. MMM total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
Mini Index Options Explained: XSP, XND, MRUT
SPY ex-dividend dates and cash amounts, trailing three yearsseries · 2026-10-17 · 13×3Preview: a 13-point series, ending higher. Open to close moves on monthly expiration Fridays, SPY since 2015ranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Dollar exposure in one 100-multiplier contract, by monthseries · 2026-10-17 · 37×5Preview: a 16-point series, ending higher.
Micro Gold Futures vs GLD: Size, Tax, Cost
What one Micro Gold (MGC) contract controls at different gold pricestable · 2026-10-17 · 7×6 GLD's trailing year, and the gold notional inside one MGCseries · 2026-10-17 · 13×7Preview: a 13-point series, ending higher. GLD overnight gaps against intraday moves, by yearranking · 2026-10-17 · 10×4Preview: 10 ranked values, smallest first. GLD sponsor fee on a stake matching one MGC, by years heldranking · 2026-10-17 · 10×3Preview: 10 ranked values, smallest first.
META Implied Volatility: IV Now & Its History
META ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. META vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. META at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
META Dividend: Yield, History & Ex-Dates
META dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.525 META recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. META total dividends paid per year (regular dividends)ranking · 2026-10-17 · 2×2Preview: 2 ranked values, smallest first.
MDT Dividend: Yield, History & Ex-Dates
MDT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.72 MDT recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. MDT total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
MDLZ Dividend: Yield, History & Ex-Dates
MDLZ dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.52 MDLZ recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 9×2Preview: a 9-point series, ending lower. MDLZ total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
MCD Dividend: Yield, History & Ex-Dates
MCD dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.93 MCD recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. MCD total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Market-Wide Circuit Breakers Explained
SPY-equivalent circuit breaker levels for the next sessiontable · 2026-10-17 · 3×7 March 2020 session by session: open, low and close versus the prior closeseries · 2026-10-17 · 22×6Preview: a 16-point series, ending lower. The four Level 1 halt sessions of March 2020series · 2026-10-17 · 4×8Preview: a 4-point series, ending lower. How the three lines move with each SPY closeseries · 2026-10-17 · 15×5Preview: a 15-point series, roughly flat.
Stock Market Holidays 2026–2027: NYSE & Nasdaq
Upcoming US stock market holidays and early closesseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-10-17 · 4×3Preview: a 4-point series, roughly flat. Regular trading sessions over the trailing yearscalar · 2026-10-17 · 1×3251 The closure calendar ahead, at a glancescalar · 2026-10-17 · 1×610
Market Cap and Which Share Count It Uses
The recovered share count against the filed diluted counttable · 2026-10-17 · 5×6 Dual class tickers and the market cap printed against eachranking · 2026-10-17 · 4×4Preview: 4 ranked values, largest first. Days since the period each filed share count coversranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. Apple's basic and diluted share counts, quarter by quarterseries · 2026-10-17 · 20×4Preview: a 16-point series, ending lower.
MA Dividend: Yield, History & Ex-Dates
MA dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.87 MA recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. MA total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
The Lowest-Volatility Stocks
The calmest large caps: annualized realized volatility over the past year, lowest firstranking · 2026-10-17 · 15×2Preview: 15 ranked values, smallest first. Maximum drawdown of the calmest names: the worst peak-to-trough fall over the past yearranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first.
Low P/E Stocks Near 52-Week Lows
Qualifying large caps as the distance band and the P/E ceiling widenranking · 2026-10-17 · 6×3Preview: 6 ranked values, smallest first. Large caps on a trailing P/E under 15, within 10% of a 52-week lowranking · 2026-10-17 · 15×3Preview: 15 ranked values, smallest first. KO month-end close against its trailing 12-month lowseries · 2026-10-17 · 14×4Preview: a 14-point series, ending higher.
LOW Dividend: Yield, History & Ex-Dates
LOW dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.25 LOW recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. LOW total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
LMT Dividend: Yield, History & Ex-Dates
LMT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×73.6 LMT recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. LMT total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
LLY Dividend: Yield, History & Ex-Dates
LLY dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.73 LLY recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. LLY total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
LIN Dividend: Yield, History & Ex-Dates
LIN dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.6 LIN recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. LIN total dividends paid per year (regular dividends)ranking · 2026-10-17 · 3×2Preview: 3 ranked values, smallest first.
Limited Margin in an IRA: Rules and Limits
Reported short sale volume as a share of total volume, past six monthsranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Front-end Treasury yields, monthly averagesseries · 2026-10-17 · 14×3Preview: a 14-point series, ending higher. How often the settlement wait is overnight, and how often it is longerranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. Calendar days from a sale to its settlement date, session by sessionseries · 2026-10-17 · 70×3Preview: a 16-point series, ending higher.
LEAPS vs Margin Loan: The Financing Cost
Parity-implied financing rate by expiry, deep ITM AAPL strikesranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. AAPL LEAPS calls and puts at matching strikes, one recent sessiontable · 2026-10-17 · 10×9 Implied financing rate at each AAPL LEAPS strike, versus the 1-year Treasurytable · 2026-10-17 · 10×5 AAPL dividends in the twelve months before the pricing sessionseries · 2026-10-17 · 4×3Preview: a 4-point series, ending higher.
KRX After-Hours Trading: Korea's Sessions
AAPL quoted spread by clock time, 15 September 2026series · 2026-10-17 · 24×3Preview: a 16-point series, ending lower. Share of monthly volume by New York clock time, AAPL and KOseries · 2026-10-17 · 32×3Preview: a 16-point series, roughly flat. Share of the day's volume printed minute by minute into the US close, and the closing cross itselfseries · 2026-10-17 · 11×2Preview: a 11-point series, ending higher.
KO Dividend History: Coca-Cola Payouts by Year
Coca-Cola's declared quarterly dividend rate, last five yearsranking · 2026-10-17 · 21×4Preview: 16 ranked values, smallest first. Coca-Cola dividends paid against earnings and operating cash flow, by fiscal yeartable · 2026-10-17 · 13×5 Compound dividend growth over 5, 10 and 25 year windowstable · 2026-10-17 · 4×8 KO dividend dates on file: ex dividend, record and pay datetable · 2026-10-17 · 6×5 KO dividend per share by calendar year, with year over year growthranking · 2026-10-17 · 22×3Preview: 16 ranked values, smallest first.
KO Dividend: Yield, History & Ex-Dates
KO dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.53 KO recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. KO total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
KMB Dividend: Yield, History & Ex-Dates
KMB dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.28 KMB recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. KMB total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
JPM Dividend: Yield, History & Ex-Dates
JPM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.65 JPM recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. JPM total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
JNJ Stock Split History: What the Record Shows
JNJ diluted share count by quarter, 2022 through 2025series · 2026-10-17 · 17×3Preview: a 16-point series, ending lower. JNJ dividends per share by year: as paid, and restated on today's share basisranking · 2026-10-17 · 22×4Preview: 16 ranked values, smallest first. Years since the last forward split across household namesranking · 2026-10-17 · 7×3Preview: 7 ranked values, largest first.
JNJ Dividend 2026: Dates, Raise and Yield
JNJ indicated dividend yield by month in 2026, at the rate in forceseries · 2026-10-17 · 10×3Preview: a 10-point series, ending lower. Every Johnson & Johnson dividend declared with a 2026 ex-dividend dateseries · 2026-10-17 · 4×7Preview: a 4-point series, ending higher.
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
$