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

AXP Dividend: Yield, History & Ex-Dates
AXP dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.95 AXP recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. AXP total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
AVGO Dividend: Yield, History & Ex-Dates
AVGO dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.65 AVGO recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending higher. AVGO total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
Average Dividend Yield by Sector: 2026 Data
Basket median dividend yield by month, with the 10-year Treasury yieldseries · 2026-10-17 · 36×4Preview: a 16-point series, ending lower. The universe choice: sector means with and without non-payerstable · 2026-10-17 · 11×6 Dividend yield by sector: median payer, equal-weighted mean, cap-weightedtable · 2026-10-17 · 11×5 Dividends paid as a share of operating cash flow, by sectorranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first.
ASX Options Expiry and Settlement Explained
Average distance from the opening print, first 30 minutes (SPY)series · 2026-10-17 · 31×2Preview: a 16-point series, ending higher. How far eight large caps travel from their opening print by 10:00ranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. SPY on 15 May 2026: distance from the opening print, 09:30 to 10:30 New York timeseries · 2026-10-17 · 61×2Preview: a 16-point series, roughly flat.
AMZN Implied Volatility: IV Now & Its History
AMZN ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. AMZN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. AMZN at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
AMGN Dividend: Yield, History & Ex-Dates
AMGN dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×72.52 AMGN recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. AMGN total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
AMD Implied Volatility: IV Now & Its History
AMD ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. AMD vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. AMD at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
AI Trading Bots and Real Brokerage Orders
Upcoming market closures that move a settlement dateseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. AAPL quoted spread and quote traffic by ET clock time, 14 August 2026series · 2026-10-17 · 36×3Preview: a 16-point series, roughly flat. AAPL near-the-money option volume and implied volatility by time to expiry, August 2026ranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Trade print sizes across five liquid names, 13:00 to 14:00 ET on 14 August 2026ranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. Minutes with a 1% high to low range, January to September 2026ranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first.
h5i-db: Point-in-Time Data for Backtests
Stock splits taking effect each quarter, forward and reverseseries · 2026-10-17 · 16×3Preview: a 16-point series, ending higher. When market headlines publish, by New York clock hourranking · 2026-10-17 · 24×2Preview: 16 ranked values, smallest first. How long 13F holdings filings take to reach the publicseries · 2026-10-17 · 16×3Preview: a 16-point series, ending lower. Days between a dividend declaration and its ex-date, by monthseries · 2026-10-17 · 24×3Preview: a 16-point series, roughly flat.
After-Hours Trading on Holidays and Weekends
Average SPY minute bars per calendar day, by weekdayseries · 2026-10-17 · 7×4Preview: a 7-point series, roughly flat. Upcoming US market closures and early closesseries · 2026-10-17 · 12×7Preview: a 12-point series, ending higher. SPY minute bars by ET clock hour: a normal day, a holiday, a half dayranking · 2026-10-17 · 15×4Preview: 15 ranked values, smallest first. First and last SPY print, Thanksgiving 2025 week and the week afterseries · 2026-10-17 · 12×5Preview: a 12-point series, roughly flat.
Premarket and After-Hours Trading Hours (ET)
Share of a month's volume by clock window: SPY, AAPL, NVDA (full sessions only)table · 2026-10-17 · 3×5 The session envelope, read from SPY minute bars (last two weeks, ET)scalar · 2026-10-17 · 1×7240 Stock headlines by ET hour of publication (last 30 days, all days)ranking · 2026-10-17 · 24×3Preview: 16 ranked values, smallest first. AAPL median quoted spread: regular session vs extended hours (past week, full sessions)series · 2026-10-17 · 2×3Preview: a 2-point series, ending lower. AAPL median shares per traded minute, and the share of minutes that traded at all (ET)series · 2026-10-17 · 32×3Preview: a 16-point series, ending lower.
ADP Dividend: Yield, History & Ex-Dates
ADP dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.7 ADP recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. ADP total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Accenture (ACN) Dividend History and Raises
Every increase in the ACN quarterly rate, ranked by sizetable · 2026-10-17 · 13×5 ACN dividend record: declared, ex, record and pay datestable · 2026-10-17 · 14×6 ACN dividends per share by calendar year, with the payment countranking · 2026-10-17 · 17×3Preview: 16 ranked values, smallest first.
ACN Dividend: Yield, History & Ex-Dates
ACN dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.71 ACN recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. ACN total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
ABT Dividend: Yield, History & Ex-Dates
ABT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.63 ABT recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. ABT total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
ABBV Dividend: Yield, History & Ex-Dates
ABBV dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.73 ABBV recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. ABBV total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
AAPL Implied Volatility: IV Now & Its History
AAPL ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. AAPL vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. AAPL at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
Apple (AAPL) Dividend 2026: Per Share & Yield
AAPL dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.27 AAPL recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. AAPL total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
Stocks at 52-Week Highs and Lows
How far the whole screen sits below its 52-week highranking · 2026-10-17 · 6×4Preview: 6 ranked values, smallest first. Stocks at 52-week lows, ordered by year-to-date returnranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. Where five broad-market ETFs sit inside their own 52-week rangeranking · 2026-10-17 · 5×4Preview: 5 ranked values, smallest first. Stocks at 52-week highs, ordered by year-to-date returnranking · 2026-10-17 · 12×3Preview: 12 ranked values, smallest first. New 52-week highs against new lows, daily, over the past six weeksseries · 2026-10-17 · 30×4Preview: a 16-point series, ending lower.
What $1,000 a Month in Dividends Takes
S&P 500 tracker distributions per share, by calendar year (2015-2025)ranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first. Payout ratio by yield band: US payers, $1B+ market cap, latest snapshottable · 2026-10-17 · 4×5 Capital needed for $12,000 a year of distributions, by fund yieldtable · 2026-10-17 · 10×5 Conagra (CAG): price, quarterly dividend, and yield, month-end 2023-07 to 2026-06series · 2026-10-17 · 36×5Preview: a 16-point series, ending higher.
US Earnings Release Times in Beijing Time
Earnings headlines by US weekday, and the Beijing day a post-close print arrives onseries · 2026-10-16 · 5×4Preview: a 5-point series, roughly flat. JPM before the open: the heaviest premarket morning of Q3 2026, on both clocksranking · 2026-10-16 · 12×4Preview: 12 ranked values, smallest first. Earnings headlines by the hour on a Beijing clock, Q3 2026ranking · 2026-10-16 · 24×4Preview: 16 ranked values, largest first. AAPL after the close: the heaviest post-close evening of Q3 2026, on both clockstable · 2026-10-16 · 16×5
The Volatility Risk Premium, Measured
The ten deepest 21 session shortfalls, one per calendar monthranking · 2026-10-16 · 10×4Preview: 10 ranked values, smallest first. SPY implied volatility against the realized volatility that followed, by monthseries · 2026-10-16 · 62×5Preview: a 16-point series, roughly flat. Distribution of the 21 session volatility risk premium, in volatility pointsranking · 2026-10-16 · 6×3Preview: 6 ranked values, largest first. The volatility risk premium by option tenor, each matched to its own realized windowtable · 2026-10-16 · 4×5 The 21 session premium across strikes, puts and calls, 20 to 45 days to expiryranking · 2026-10-16 · 7×3Preview: 7 ranked values, largest first.
Tax-Loss Harvesting Deadlines: The Real Dates
Regular-session minutes in the last two weeks of December 2025 (SPY)series · 2026-10-16 · 12×5Preview: a 12-point series, roughly flat. The 61 day wash sale window around each late-December 2025 sessionseries · 2026-10-16 · 7×6Preview: a 7-point series, ending higher. Daily open-to-close gap versus SPY, in basis points, July to December 2025ranking · 2026-10-16 · 4×3Preview: 4 ranked values, smallest first. Ex-date to pay-date lag for household payers, December 2025 into January 2026ranking · 2026-10-16 · 10×4Preview: 10 ranked values, largest first.
Paying per request for market data: x402
Rows returned by two common market-data request shapesseries · 2026-10-16 · 5×3Preview: a 5-point series, ending lower. Dividend records with an ex-date in each of the last 12 monthsseries · 2026-10-16 · 12×4Preview: a 12-point series, ending higher. Quote updates in a single pinned hour, by symbolranking · 2026-10-16 · 5×3Preview: 5 ranked values, largest first. SEC filings indexed per month over the trailing yearseries · 2026-10-16 · 12×3Preview: a 12-point series, roughly flat.
How to Read a 10-Q: Quarterly Filing Guide
Apple weighted average basic and diluted share count, in millionsseries · 2026-10-16 · 11×4Preview: a 11-point series, ending lower. Apple quarterly revenue and net income, by period endseries · 2026-10-16 · 11×4Preview: a 11-point series, ending higher. Apple gross and operating margin by quarterseries · 2026-10-16 · 11×3Preview: a 11-point series, ending higher. Quarterly versus annual reports filed since January 2023ranking · 2026-10-16 · 6×3Preview: 6 ranked values, largest first.
Direct Stock Purchase Plans: How They Fill
The monthly price band a pooled plan purchase lands inside (KO)series · 2026-10-16 · 13×6Preview: a 13-point series, ending lower. One ordinary session in KO, in 30 minute ET bucketsseries · 2026-10-16 · 32×3Preview: a 16-point series, ending lower. KO ex-dividend dates and cash per share, trailing three yearsseries · 2026-10-16 · 12×3Preview: a 12-point series, ending higher. Where a September 2026 batch could have landed, eight widely held namesranking · 2026-10-16 · 8×3Preview: 8 ranked values, largest first.
When Is Short Interest Released?
The short interest release schedule: recent FINRA settlement dates and names reportedseries · 2026-10-11 · 16×2Preview: a 16-point series, ending lower. Measured publication lag: settlement date vs the day the file first arrived hereseries · 2026-10-11 · 14×3Preview: a 14-point series, ending lower. The publication lag in one row: fastest, median and slowest across incrementally-delivered settlementsscalar · 2026-10-11 · 1×414 Day-of-month and the gap between consecutive settlement dates: the twice-monthly cadenceseries · 2026-10-11 · 16×3Preview: a 16-point series, ending higher. The current state of the release cycle: the newest print on file and the settlement still pendingscalar · 2026-10-11 · 1×630
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
$