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

US Dividend Frequency: Quarterly vs Japan
Large US monthly dividend payers, trailing 12 monthsranking · 2026-10-17 · 8×3Preview: 8 ranked values, largest first. US dividend payers by payment schedule, trailing 12 monthsranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Apple dividend cycles: declared, ex-date, record, paidseries · 2026-10-17 · 8×7Preview: a 8-point series, ending higher.
Upcoming Stock Splits Calendar
Upcoming US stock splits: announced, with a future effective datetable · 2026-10-17 · 30×5 Announced upcoming splits by directionranking · 2026-10-17 · 2×2Preview: 2 ranked values, smallest first. Announced stock splits by effective month: forward vs reverseseries · 2026-10-17 · 3×4Preview: a 3-point series, ending lower.
Upcoming Reverse Stock Splits: Live Calendar
Reverse versus forward splits by yearranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first. Upcoming reverse stock splits: ratio, effective date and last closetable · 2026-10-17 · 22×6 Pre-split price of reverse splits: the calendar ahead versus the trailing twelve monthstable · 2026-10-17 · 3×5 Reverse versus forward splits by month, last twelve complete monthsseries · 2026-10-17 · 12×5Preview: a 12-point series, ending lower.
Upcoming IPO Lockup Expirations: Next 90 Days
Final prospectus (424B4 / 424B1) on file for each calendar nametable · 2026-10-17 · 56×4 Latest close versus IPO offer price for every name in the calendartable · 2026-10-17 · 57×5 Priced US IPO listings by month, trailing year (the lockup pipeline)series · 2026-10-17 · 13×3Preview: a 13-point series, ending lower. IPO lockup calendar: priced US listings whose 180-day date falls in the next 90 daystable · 2026-10-17 · 63×8 8-K filings from recent IPO issuers that mention a lock-up, last 180 daystable · 2026-10-17 · 22×6
Upcoming Ex-Dividend Dates: Stocks This Week
Three household payers at their last ex-date: prior close, ex-morning open, and the payment for scaleseries · 2026-10-17 · 3×8Preview: a 3-point series, roughly flat. Who goes ex-dividend in the next 14 days: names, cadence and implied yield by size bandtable · 2026-10-17 · 4×5 Names going ex-dividend, day by day: the next seven days of declared recordsseries · 2026-10-17 · 5×5Preview: a 5-point series, ending higher. Ex-dividend dates by calendar month: three-year average, quarterly vs monthly payersseries · 2026-10-17 · 12×4Preview: a 12-point series, ending higher. Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-dateseries · 2026-10-17 · 13×8Preview: a 13-point series, ending higher. Forward-declared ex-dividend records on file: the receipt behind this calendarscalar · 2026-10-17 · 1×52,338 Every mega-cap ex-dividend event of the past six months: price path from the pre-ex closetable · 2026-10-17 · 5×6 Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yieldseries · 2026-10-17 · 12×8Preview: a 12-point series, ending higher.
Upcoming Dividend Payment Dates: Next 2 Weeks
Median days from ex-date to pay date, fixed baskets of twelve names per sector, trailing two yearstable · 2026-10-17 · 7×5 Securities paying a dividend on each day of the next 14 daysseries · 2026-10-17 · 10×4Preview: a 10-point series, ending higher. Dividends paying in the next 14 days, largest names firsttable · 2026-10-17 · 30×8 Days from ex-dividend date to payment date, all cash dividends in the trailing yearranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first.
Unusual Options Activity: Last Session
Market-wide options volume by session, with monthly expirations labelledseries · 2026-10-17 · 25×5Preview: a 16-point series, ending higher. Calls or puts: the board's call and put contract volume on the same sessiontable · 2026-10-17 · 10×5 What follows a heavy options session: next-session absolute move vs. the same names on an ordinary daytable · 2026-10-17 · 5×6 What the session's contracts were made of: options volume by days to expiryranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first. Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-10-17 · 10×8
UNP Dividend: Yield, History & Ex-Dates
UNP dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.42 UNP recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. UNP total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
UNH Dividend: Yield, History & Ex-Dates
UNH dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×72.32 UNH recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. UNH total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
TXN Dividend: Yield, History & Ex-Dates
TXN dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.52 TXN recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. TXN total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
TSLA Implied Volatility: IV Now & Its History
TSLA ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. TSLA vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. TSLA at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
Trailing vs Forward Dividend Yield Explained
Trailing vs forward dividend yield: eight large payers, latest session pricetable · 2026-10-17 · 8×6 3M (MMM): trailing vs forward dividend yield at every month end after a payout resetseries · 2026-10-17 · 26×6Preview: a 16-point series, ending lower. Realty Income (O): trailing vs forward dividend yield at every month end, two yearsseries · 2026-10-17 · 24×7Preview: a 16-point series, roughly flat. Distance between trailing and forward dividend yield, by payment scheduletable · 2026-10-17 · 4×7
Trading Options Inside an IRA: How It Works
Near the money put premium as a percent of the cash it locks upranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. Next declared ex dividend dates and the cash at stake per contractseries · 2026-10-17 · 4×4Preview: a 4-point series, ending higher. What one fully collateralized contract ties up, by underlyingranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first. Average call delta by strike versus spot, one week or less to expirationranking · 2026-10-17 · 6×3Preview: 6 ranked values, smallest first.
TMO Dividend: Yield, History & Ex-Dates
TMO dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.47 TMO recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. TMO total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
The Rule of 16 in Options, and When It Breaks
Does a Monday move like three calendar days? SPY by weekdayranking · 2026-10-17 · 5×4Preview: 5 ranked values, smallest first. The largest single session against a typical one, by nametable · 2026-10-17 · 6×5 Implied volatility divided by 16, next to the realized daily moveranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first. How far SPY travels over one session, and over sixty threeranking · 2026-10-17 · 7×4Preview: 7 ranked values, smallest first.
The Low-Volatility Anomaly
Growth of $100: a calm name (KO), the market (SPY), a wild name (NVDA), weeklyseries · 2026-10-17 · 114×4Preview: a 16-point series, ending higher. Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years)ranking · 2026-10-17 · 25×3Preview: 16 ranked values, smallest first. Volatility thirds: median return, and the range from worst to best name in eachtable · 2026-10-17 · 3×6
The $100,000 Rule for Stock Options (ISOs)
What $100,000 of grant-date value covered, by grant year (MSFT)ranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first. Form 4 lines coded M (derivative exercise), by monthseries · 2026-10-17 · 24×3Preview: a 16-point series, ending higher. Shares that $100,000 of grant-date value covers, by share priceranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first.
TGT Dividend: Yield, History & Ex-Dates
TGT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.16 TGT recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. TGT total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
T Dividend: Yield, History & Ex-Dates
T dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.278 T recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, roughly flat. T total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
Survivorship Bias in Stock Data, Explained
Survivors-only average vs whole-cohort average, by starting yeartable · 2026-10-17 · 7×6 Symbols relisted under a new issuer after a long silenceranking · 2026-10-17 · 5×4Preview: 5 ranked values, smallest first. Symbols that printed a final daily bar, by yearranking · 2026-10-17 · 10×3Preview: 10 ranked values, smallest first. The January 2019 universe, grouped by what happened to each nameranking · 2026-10-17 · 9×4Preview: 9 ranked values, smallest first.
Substitute Payments and Your 1099
One quarterly dividend on 1,000 shares, at a qualified rate versus an ordinary ratetable · 2026-10-17 · 8×6 Calendar days from ex-dividend date to payable date, most recent dividendranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. Days to cover at each short interest settlement, AAPL against KOtable · 2026-10-17 · 35×3 Share of reported volume marked short, trailing four monthsranking · 2026-10-17 · 8×3Preview: 8 ranked values, largest first.
Street Name vs Holder of Record: Cede & Co
Average days from record date to pay date, eight large dividend payersranking · 2026-10-17 · 8×3Preview: 8 ranked values, largest first. Reported short interest and days to cover, latest settlement date on fileranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. Coca-Cola quarterly dividends: calendar days from ex-dividend date to record dateseries · 2026-10-17 · 15×4Preview: a 15-point series, ending higher. Cash dividends by month: did the record date land on the ex-dividend date?series · 2026-10-17 · 41×5Preview: a 16-point series, ending higher.
Straddle vs Strangle: Break-Evens and Margin
How often SPY moved a given distance over 21 sessionsranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. One-month expected move priced by the option marketranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first.
Stocks With the Highest Option Premiums
Premium as a percent of strike by tenor, against the square root of time estimateranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. The same calls ranked by premium as a percent of strikeranking · 2026-10-17 · 9×4Preview: 9 ranked values, largest first. Near the money 30 day calls ranked by dollar premiumtable · 2026-10-17 · 9×5 Percent of strike leaders at a 100 contract floor, with the flow behind themranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first.
Stock Splits vs Fractional Shares Explained
AAPL prints by trade size, one to ten shares, June 10 2026 sessionranking · 2026-10-17 · 10×2Preview: 10 ranked values, smallest first. NVDA strike ladder and share price across its June 2024 splitseries · 2026-10-17 · 10×5Preview: a 10-point series, ending higher. Forward stock splits at liquid US names, past three yearsranking · 2026-10-17 · 12×3Preview: 12 ranked values, smallest first. Price weighting across ten large US names, latest closeranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first.
Stock Splits in Japan and the 100-Share Unit
Large-cap US forward splits since 2022 and the ticket each one cuttable · 2026-10-17 · 12×5 US forward and reverse splits per year since 2016ranking · 2026-10-17 · 11×3Preview: 11 ranked values, largest first. Every AAPL print on September 15, 2026, grouped by trade sizeranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. What a 100-share trading unit would cost on six US namesranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first.
Stock Split Calendar From a Free SQL API
Forward and reverse splits per month, last 36 monthsseries · 2026-10-17 · 36×4Preview: a 16-point series, ending higher. Most common split ratios, last three yearsranking · 2026-10-17 · 12×2Preview: 12 ranked values, largest first. Do the direction labels agree with the ratio columns?ranking · 2026-10-17 · 2×4Preview: 2 ranked values, smallest first.
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
$