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

RTX Dividend: Yield, History & Ex-Dates
RTX total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
RSP vs SPY: Equal Weight S&P 500
Cap weight versus equal weight across a ten name basketseries · 2026-10-17 · 10×5Preview: a 10-point series, roughly flat. RSP share volume: each quarter's heaviest session against its medianseries · 2026-10-17 · 11×6Preview: a 11-point series, roughly flat. RSP and SPY price paths, both indexed to 100 in January 2019series · 2026-10-17 · 93×5Preview: a 16-point series, ending lower. Calendar year price change, RSP against SPY, first close to last closeranking · 2026-10-17 · 15×4Preview: 15 ranked values, largest first.
Reverse Split: Round Up or Cash in Lieu?
Reverse splits executed per year, and how many used a ratio of 1-for-10 or largerranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first. Reverse split ratios since 2016, by how often each one is usedranking · 2026-10-17 · 12×2Preview: 12 ranked values, largest first. 8-K disclosures mentioning a reverse stock split, and how many spell out the fractionranking · 2026-10-17 · 2×4Preview: 2 ranked values, smallest first. First week post split average close, and what half a share would payseries · 2026-10-17 · 12×4Preview: a 12-point series, ending lower.
Return of Capital in ETF Distributions
QYLD by calendar year: cash paid, average price, implied ratetable · 2026-10-17 · 5×5 Share price indexed to 100, three covered call ETFs, monthlyseries · 2026-10-17 · 59×4Preview: a 16-point series, ending lower. Trailing year distribution rate, price change, and approximate total returnranking · 2026-10-17 · 7×4Preview: 7 ranked values, largest first. Cash distributions per share, month by monthseries · 2026-10-17 · 59×4Preview: a 16-point series, ending lower.
Relative Volume Screener in SQL: Free API
Share of a session's volume completed by each half hour: SPY and KOseries · 2026-10-17 · 13×3Preview: a 13-point series, ending higher. Relative volume screener: top 20 by time adjusted RVOL at 11:00 a.m. ETtable · 2026-10-17 · 20×5 Cisco, September 22, 2026: naive RVOL against time adjusted RVOL through the sessionseries · 2026-10-17 · 13×3Preview: a 13-point series, ending higher. Share of the session completed by 11:00 a.m. ET, twelve household namesranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first.
REIT Payout Ratio: FFO vs EPS Explained
Dividend as a percent of EPS: large equity REITs against every other US dividend payerranking · 2026-10-17 · 2×4Preview: 2 ranked values, largest first. Large equity REITs: dividend as a percent of earnings per share, latest snapshotranking · 2026-10-17 · 11×3Preview: 11 ranked values, largest first. Year-end dividend rate against twelve months earlier: how many large REITs raised or loweredtable · 2026-10-17 · 9×5 Realty Income (O): monthly dividend per share, January 2021 to the latest declared paymentseries · 2026-10-17 · 64×3Preview: a 16-point series, ending higher.
Ex-Dividend Date vs. Record Date: Same Day?
One real dividend: AAPL's most recent completed payout, all four datesscalar · 2026-10-17 · 1×90.27 Median waits along the dividend calendar (trailing 12 months, recurring US dividends)scalar · 2026-10-17 · 1×346,555 Calendar days from ex-dividend date to record date (trailing 12 months)ranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. Ex-date vs. record date by year: share identical, and the median gap in calendar daysranking · 2026-10-17 · 12×4Preview: 12 ranked values, smallest first. The T+1 cutover, week by week: share of dividends with ex-date = record date, April–July 2024ranking · 2026-10-17 · 18×3Preview: 16 ranked values, largest first. Dividends that went ex AFTER the record date: special vs. recurring, trailing 12 monthstable · 2026-10-17 · 2×6
Recent Stock Splits (Forward and Reverse)
Forward vs reverse splits executed in the last 45 daysranking · 2026-10-17 · 2×2Preview: 2 ranked values, largest first. Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-10-17 · 15×4Preview: 15 ranked values, smallest first. Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-10-17 · 15×4Preview: 15 ranked values, smallest first.
Recent Reverse Stock Splits: Last 90 Days
Reverse and forward stock splits per month, trailing yearseries · 2026-10-17 · 12×4Preview: a 12-point series, ending higher. Reverse stock splits effective in the last 90 daysranking · 2026-10-17 · 15×4Preview: 15 ranked values, largest first. Reverse split ratios by size, trailing three yearsranking · 2026-10-17 · 5×2Preview: 5 ranked values, smallest first. Closing prices in the 30 sessions before each recent reverse splitranking · 2026-10-17 · 12×3Preview: 12 ranked values, smallest first.
Qualified Dividend Holding Period: 61 Days
Every 121-day window around a Coca-Cola ex-dividend dateseries · 2026-10-17 · 14×6Preview: a 14-point series, ending higher. How long after the ex-date the cash actually arrivesranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. Days between consecutive ex-dividend dates, against the 121-day windowranking · 2026-10-17 · 6×3Preview: 6 ranked values, smallest first.
Quadruple Witching vs Triple Witching
SPY volume on quarterly expiration Fridays, against the ordinary Fridays around each oneseries · 2026-10-17 · 14×4Preview: a 14-point series, ending higher. Share of SPY regular hours volume by half hour: expiration Friday vs the Friday afterseries · 2026-10-17 · 14×3Preview: a 14-point series, ending lower. Average absolute open to close move on SPY Fridays, expiration vs ordinary, by yearranking · 2026-10-17 · 11×4Preview: 11 ranked values, smallest first. Percent of regular hours volume in the closing auction print, six large listingsranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first.
QQQ Implied Volatility: IV Now & Its History
QQQ ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. QQQ vs SPY: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×3Preview: a 16-point series, ending lower. QQQ at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
QCOM Dividend: Yield, History & Ex-Dates
QCOM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.92 QCOM recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. QCOM total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
How Preferred Stock Dividends Work
Quarterly payers by how many different per-share amounts they paidranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. Days from the ex-dividend date to the pay date, past two yearsranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. Monthly count of dividend declarations across the marketseries · 2026-10-17 · 36×4Preview: a 16-point series, roughly flat. Dividend declarations by stated payment schedule, past three yearsranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first.
Portfolio Dividend Yield: Weighted Average
Trailing 12-month dividend yield across ten household payersranking · 2026-10-17 · 10×4Preview: 10 ranked values, largest first. Two averages of the same five holdingsranking · 2026-10-17 · 2×2Preview: 2 ranked values, largest first. Dividend income from the five-name portfolio, by monthseries · 2026-10-17 · 13×3Preview: a 13-point series, ending lower. A five-name portfolio: share of value against share of incomeranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first.
Portfolio Analysis in SQL: Weights to Drawdown
Position weights from last close times share counttable · 2026-10-17 · 6×6 Pairwise daily return correlation, trailing yearranking · 2026-10-17 · 15×2Preview: 15 ranked values, largest first. Weekly peak-to-trough drawdown of the blended portfolioseries · 2026-10-17 · 53×4Preview: a 16-point series, roughly flat. Trailing twelve-month dividend income by holdingtable · 2026-10-17 · 6×6 Cumulative weight and the Herfindahl concentration indexranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first.
PM Dividend: Yield, History & Ex-Dates
PM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.6 PM recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. PM total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
PLTR Implied Volatility: IV Now & Its History
PLTR ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. PLTR vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. PLTR at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
PG Dividend 2026: Dates, History and Yield
PG trailing twelve-month dividend yield against the month-end share priceseries · 2026-10-17 · 22×3Preview: a 16-point series, ending higher. Every PG quarterly rate increase since 2017, and the size of each stepseries · 2026-10-17 · 10×6Preview: a 10-point series, roughly flat. Every declared 2026 PG dividend: declaration, ex date, record date, paymentseries · 2026-10-17 · 4×7Preview: a 4-point series, ending higher. PG dividend timeline by quarter: declaration to ex date, ex date to paymentranking · 2026-10-17 · 10×4Preview: 10 ranked values, largest first. PG dividends per share by calendar year, and the year-over-year stepranking · 2026-10-17 · 14×4Preview: 14 ranked values, smallest first.
PG Dividend Yield & Ex-Dividend Date 2026
PG dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.088 PG recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. PG total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
PFE Ex-Dividend Date 2026: Pfizer Schedule
PFE dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.43 PFE recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. PFE total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
PEP Dividend History: Every Payment by Year
Forward yield on PEP's declared rate across a band of share pricesranking · 2026-10-17 · 9×4Preview: 9 ranked values, smallest first. Every year with a PEP dividend increase: month, step size and the running streaktable · 2026-10-17 · 23×5 Recent PEP dividends: declaration, ex, record and pay dates with the amountseries · 2026-10-17 · 13×6Preview: a 13-point series, ending lower. PEP dividends by year: annual total, split-adjusted total and growth ratetable · 2026-10-17 · 22×5
PEP Dividend 2026: Ex-Dates and the Raise
PEP indicated dividend yield against the 2026 price rangescalar · 2026-10-17 · 1×9199 PEP monthly price range and indicated yield, 2026series · 2026-10-17 · 10×4Preview: a 10-point series, ending higher. PepsiCo's next ex-dividend dates, confirmed and scheduledseries · 2026-10-17 · 4×6Preview: a 4-point series, roughly flat. PepsiCo dividends per share by year, with the annual stepranking · 2026-10-17 · 10×4Preview: 10 ranked values, smallest first. PepsiCo's four 2026 dividend quarters, confirmed and scheduledseries · 2026-10-17 · 4×8Preview: a 4-point series, ending higher.
PEP Dividend: Yield, History & Ex-Dates
PEP dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.48 PEP recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. PEP total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Paper Trading Before Real Money
One session shape: median quoted spread by half-hour bucket, Ford (F), recent completed sessionsseries · 2026-10-17 · 13×3Preview: a 13-point series, ending lower. Five years of sessions: share closing above the open, typical move, and the extremes (SPY, 2021-2025)table · 2026-10-17 · 5×6 What a real fill costs: median quoted spread in bps of the midpoint, regular hours, recent completed sessionsranking · 2026-10-17 · 6×4Preview: 6 ranked values, smallest first.
ORCL Dividend: Yield, History & Ex-Dates
ORCL dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.5 ORCL recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. ORCL total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Options Expiry Days in India: NSE and BSE
Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeksranking · 2026-10-17 · 3×4Preview: 3 ranked values, largest first.
Which Options Expire on Each Weekday
SPY expiration dates per weekday, by month, since October 2021series · 2026-10-17 · 60×6Preview: a 16-point series, ending lower. Expiration dates reached, by weekday, trailing yearseries · 2026-10-17 · 5×5Preview: a 5-point series, ending higher. Option classes grouped by how many weekdays they expired on, trailing quarterranking · 2026-10-17 · 4×2Preview: 4 ranked values, largest first.
Options Expiration Calendar 2026: All 12 Dates
Every Friday of 2026 through July, shortest session firstseries · 2026-10-17 · 31×4Preview: a 16-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
$