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

What Happens When the Yield Curve Un-Inverts
The 2s10s over the trailing six months, with the 2-year and 10-year moves that produced itseries · 2026-10-17 · 26×8Preview: a 16-point series, ending higher. Every 2s10s un-inversion: the crossing and the spread 3, 6 and 12 months latertable · 2026-10-17 · 7×8
What Happens When an ETF Closes
How the tape behaved into the final sessionranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. How long retired listings had traded before their last sessionranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. Listings that printed their final daily bar, by yearranking · 2026-10-17 · 11×2Preview: 11 ranked values, smallest first. Final trading days by month, rolling three yearsseries · 2026-10-17 · 32×3Preview: a 16-point series, ending lower.
What Happens After a Big One-Day Gain
How the next session split: gapped up, gapped up and faded, closed highertable · 2026-10-17 · 5×5 Overnight gap versus intraday run: what the next session didtable · 2026-10-17 · 3×5 Next-session returns after a big one-day gain, by size of the gaintable · 2026-10-17 · 5×5 The full spread of next-session returns for top-20 daily gainersranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. Sample coverage and next-session medians, year by yeartable · 2026-10-17 · 4×5
What Breaks an Options Backtest
How much of a modelled credit survives one volatility point of vegatable · 2026-10-17 · 6×5 Contracts that traded once, and contracts still trading at expiryseries · 2026-10-17 · 57×5Preview: a 16-point series, ending higher. In-the-money calls with extrinsic value below the upcoming dividendtable · 2026-10-17 · 5×5 Traded per-contract records by underlying, August 2021 onwardtable · 2026-10-17 · 5×7 One SPY put traced through its final weeks, June 2024 expiryseries · 2026-10-17 · 35×5Preview: a 16-point series, ending higher.
WFC Dividend: Yield, History & Ex-Dates
WFC dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.5 WFC recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. WFC total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
Weekly Market Recap: The Week in Numbers
Where the volume went: most dollars traded over the past weekranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. The eleven S&P 500 sectors over the past weekranking · 2026-10-17 · 11×2Preview: 11 ranked values, largest first. Biggest stock losers over the past weekranking · 2026-10-17 · 7×3Preview: 7 ranked values, smallest first. The major index ETFs over the past weekranking · 2026-10-17 · 4×4Preview: 4 ranked values, largest first. Biggest stock gainers over the past weekranking · 2026-10-17 · 7×3Preview: 7 ranked values, largest first. Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-10-17 · 5×3Preview: a 5-point series, ending higher.
Weekly Dividend ETFs: How the Payouts Work
Symbols paying on a weekly cadence, by complete calendar yearranking · 2026-10-17 · 5×2Preview: 5 ranked values, smallest first. Symbols with the most ex-dividend dates in the trailing yearranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. Every distribution from the most frequent payer, with its annualized rateseries · 2026-10-17 · 105×4Preview: a 16-point series, roughly flat. Average distribution against the average ex-date price moveranking · 2026-10-17 · 10×4Preview: 10 ranked values, largest first. Trailing-year cash paid and price change, as a percentage of the starting priceranking · 2026-10-17 · 10×4Preview: 10 ranked values, largest first.
Warrants vs Call Options: Key Differences
Recent forward stock splits and the share multiplierranking · 2026-10-17 · 12×4Preview: 12 ranked values, smallest first. Tesla basic and diluted share counts, quarter by quarterseries · 2026-10-17 · 12×5Preview: a 12-point series, ending lower. AAPL call contracts traded, by expiration dateseries · 2026-10-17 · 23×4Preview: a 16-point series, roughly flat. Basic and diluted share counts across eight large capsranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first.
VZ vs T Dividend: Yield, Growth, Coverage
Every quarterly rate AT&T has declared, and when each one startedtable · 2026-10-17 · 8×5 Dividends paid as a share of free cash flow, by fiscal yearranking · 2026-10-17 · 7×3Preview: 7 ranked values, smallest first. Year over year change in dividend per share, Verizon and AT&Tranking · 2026-10-17 · 10×3Preview: 10 ranked values, smallest first. Ex dividend and payment dates by quarter, Verizon and AT&Tseries · 2026-10-17 · 6×8Preview: a 6-point series, roughly flat. Verizon and AT&T side by side: yield, ten year growth, payouttable · 2026-10-17 · 2×8 Dividend per share by calendar year, Verizon and AT&Tranking · 2026-10-17 · 10×3Preview: 10 ranked values, smallest first.
VZ Dividend 2026: Dates, Payout and Yield
Every change in Verizon's quarterly rate since 2015series · 2026-10-17 · 12×5Preview: a 12-point series, ending lower. VZ monthly close and trailing twelve month dividend yieldseries · 2026-10-17 · 25×4Preview: a 16-point series, ending lower. VZ payment cadence: days between ex-dates, and ex-date to cashseries · 2026-10-17 · 27×5Preview: a 16-point series, ending higher. Verizon's declared 2026 dividends: every date and the rateseries · 2026-10-17 · 4×7Preview: a 4-point series, ending higher.
Verizon (VZ) Ex-Dividend Date 2026 & Yield
VZ dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.708 VZ recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. VZ total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Volatility Targeting for Position Sizing
SPY realised volatility by month against a 10% targetseries · 2026-10-17 · 72×4Preview: a 16-point series, roughly flat. What the lookback window costs in daily turnover (SPY, 10% target, 2x cap)ranking · 2026-10-17 · 4×4Preview: 4 ranked values, largest first. One 10% risk budget, six names, six different weightsranking · 2026-10-17 · 6×4Preview: 6 ranked values, smallest first. Weekly realised volatility and the weight it implied, Nov 2019 to Apr 2020series · 2026-10-17 · 25×4Preview: a 16-point series, ending lower.
How VIX Settlement Works: the SOQ
Listed versus traded strikes by moneyness (SPY, Sep 18 2026 expiry, as of Aug 14 2026)ranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. Upcoming VIX settlement dates and the SPX expiry each one usesseries · 2026-10-17 · 13×5Preview: a 13-point series, ending higher. Average high to low range by minute, first half hour (SPY, trailing ~4 months)series · 2026-10-17 · 30×3Preview: a 16-point series, ending lower. Expirations three to six weeks out on a pinned session (SPY, Aug 14 2026)series · 2026-10-17 · 3×4Preview: a 3-point series, ending higher.
V Dividend: Yield, History & Ex-Dates
V dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.67 V recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. V total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
USB Dividend: Yield, History & Ex-Dates
USB dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.54 USB recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 9×2Preview: a 9-point series, ending lower. USB total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
US Stocks 23/5 Trading: The December 2026 Plan
Extended-hours sale conditions defined on the taperanking · 2026-10-17 · 3×3Preview: 3 ranked values, smallest first. SPY daily bar volume vs. the regular-session slice (trailing month)series · 2026-10-17 · 20×5Preview: a 16-point series, ending lower. Where SPY volume prints today, by ET clock hour (trailing month)ranking · 2026-10-17 · 16×4Preview: 16 ranked values, largest first. Share of volume printed outside 9:30 to 4:00 ET, seven household names (trailing month)ranking · 2026-10-17 · 7×4Preview: 7 ranked values, smallest first.
US Stock Splits for Chinese Investors
Forward and reverse splits on the US tape, by yearranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. Recent US splits, stamped in New York and Beijing timeseries · 2026-10-17 · 12×7Preview: a 12-point series, roughly flat. A 137-share lot through real large-cap splitsranking · 2026-10-17 · 7×4Preview: 7 ranked values, smallest first. NVDA traded option strikes, before and after the splitseries · 2026-10-17 · 8×5Preview: a 8-point series, ending higher. One US split session, hour by hour, in both time zonesseries · 2026-10-17 · 16×3Preview: a 16-point series, ending higher.
US Stock Market Hours in UAE Time (GST)
Upcoming US market closures, with early-close times in GSTseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. Share of September 2026 volume by US session windowranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. SPY volume by clock hour, New York and Dubai (1 to 25 September 2026)ranking · 2026-10-17 · 16×4Preview: 16 ranked values, largest first. The US trading day on a UAE clock, across a US time changetable · 2026-10-17 · 10×7
US Stock Market Hours in Sydney Time
Sydney open and close of the first US session each weekseries · 2026-10-17 · 58×5Preview: a 16-point series, roughly flat. The three Sydney opening times, counted from a year of SPY sessionsranking · 2026-10-17 · 3×4Preview: 3 ranked values, smallest first. Upcoming US market closures, in Sydney date and timeseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher.
US Stock Market Hours in Singapore Time
Twelve months of dividends per share, gross and after 30% US withholdingranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. Upcoming US closures, with the early-close finish in Singapore timeseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. SPY volume by Singapore half hour: US winter month vs US summer monthseries · 2026-10-17 · 34×3Preview: a 16-point series, ending higher. Every US clock change since 2022, detected from the opening printseries · 2026-10-17 · 9×5Preview: a 9-point series, roughly flat.
US Stock Market Hours in Mountain Time
The regular session, half hour by half hour, on both clocksseries · 2026-10-17 · 13×3Preview: a 13-point series, ending higher. Sessions grouped by the local time the open landedranking · 2026-10-17 · 2×3Preview: 2 ranked values, largest first. The 9:30 a.m. Eastern open, read on three clocks, by monthseries · 2026-10-17 · 14×6Preview: a 14-point series, roughly flat. Upcoming market closures, with early-close times in Mountain Timeseries · 2026-10-17 · 12×8Preview: a 12-point series, ending higher.
US Market Hours in German Time (CET/CEST)
Upcoming US market closures and half days, in German timeseries · 2026-10-17 · 12×8Preview: a 12-point series, ending higher. US session milestones in ET, UTC and German local timetable · 2026-10-17 · 5×7 The German clock time of the US open, week by weekseries · 2026-10-17 · 58×4Preview: a 16-point series, roughly flat. US sessions each year that land an hour earlier in Germanytable · 2026-10-17 · 5×6 SPY volume and one-minute range by 30-minute bucketseries · 2026-10-17 · 16×4Preview: a 16-point series, ending lower.
US Premarket and After-Hours in Israel Time
AAPL quoted spread and top-of-book size by hour, 16 September 2026ranking · 2026-10-17 · 16×4Preview: 16 ranked values, largest first. Upcoming windows where Israel is not seven hours ahead of New Yorkseries · 2026-10-17 · 3×7Preview: a 3-point series, roughly flat. This week's US sessions mapped onto Israeli weekdays and clock timestable · 2026-10-17 · 5×5 US session boundaries in New York, UTC and Israel timeseries · 2026-10-17 · 4×7Preview: a 4-point series, roughly flat. UTC offsets and the Israel to New York gap, one Wednesday per week aheadseries · 2026-10-17 · 57×5Preview: a 16-point series, roughly flat.
US Dividend Tax for Japanese Investors
Trailing 12-month dividend yield, gross and net of US withholdingranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. One Apple dividend per share, in yen, across four account setupstable · 2026-10-17 · 4×6 What 10% and 30% remove from one quarterly dividend, per shareseries · 2026-10-17 · 8×5Preview: a 8-point series, ending lower. Apple's quarterly dividend, gross and net of US withholdingseries · 2026-10-17 · 15×5Preview: a 15-point series, ending higher.
US Dividend Frequency: Quarterly vs Japan
Average days between consecutive ex-dividend dates, by scheduleranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first.
page 3 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 →
$