STRASMORE/EXPLORE 2,401 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,401 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

XOM Dividend: Yield, History & Ex-Dates
XOM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-09-19 · 1×71.03 XOM recent dividend payments: ex-dividend date and per-share amountseries · 2026-09-19 · 10×2Preview: a 10-point series, ending lower. XOM total dividends paid per year (regular dividends)ranking · 2026-09-19 · 7×2Preview: 7 ranked values, smallest first.
WMT Dividend: Yield, History & Ex-Dates
WMT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-09-19 · 1×70.248 WMT recent dividend payments: ex-dividend date and per-share amountseries · 2026-09-19 · 10×2Preview: a 10-point series, ending lower. WMT total dividends paid per year (regular dividends)ranking · 2026-09-19 · 7×2Preview: 7 ranked values, largest first.
Why VIX Options Don't Track the VIX
SPY near-the-money implied volatility by distance to expirationranking · 2026-09-19 · 6×3Preview: 6 ranked values, smallest first. How far the long tenor travels on days the front end jumpsranking · 2026-09-19 · 5×4Preview: 5 ranked values, smallest first. Near-dated versus long-dated SPY implied volatility, session by sessionseries · 2026-09-19 · 80×3Preview: a 16-point series, ending lower. The near-to-far implied volatility gap across liquid namesranking · 2026-09-19 · 6×4Preview: 6 ranked values, largest first.
Why Ticker Symbols Break Your Dataset
When each symbol last printed a daily barranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. New listings landing on a symbol that already had historyranking · 2026-09-19 · 11×3Preview: 11 ranked values, smallest first. Which share-class spellings actually carry historyranking · 2026-09-19 · 4×4Preview: 4 ranked values, smallest first. Trading sessions per year under FB and METAranking · 2026-09-19 · 15×3Preview: 15 ranked values, smallest first.
Why Stocks Halt: Limit Up-Limit Down Bands
Where listed symbols sit by price, and which band rule governs each zoneranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. Average minute range through the session, five liquid namesseries · 2026-09-19 · 26×3Preview: a 16-point series, ending lower. How far eight stocks move in a five minute window, trailing yearranking · 2026-09-19 · 8×4Preview: 8 ranked values, largest first. What a 5 percent band is worth in dollars, by price levelranking · 2026-09-19 · 8×4Preview: 8 ranked values, largest first.
Why Are Spreads Wider at the Open? Real Data
Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling windowscalar · 2026-09-19 · 1×2570 Share of quote updates at the one-cent minimum spread, by half hour (regular hours, ET)series · 2026-09-19 · 13×4Preview: a 13-point series, ending higher. Median spread each half hour, as a multiple of each name's tightest bucket (regular hours, ET)series · 2026-09-19 · 13×4Preview: a 13-point series, ending lower. Session by session: how often, and by how much, the open ran wider than middaytable · 2026-09-19 · 3×6 Median quoted spread by phase of the trading day, in basis points (ET clock)ranking · 2026-09-19 · 5×4Preview: 5 ranked values, largest first. The opening premium priced: median and 90th-percentile spread at the open (9:30-10:00 ET) vs. midday (12:00-14:00 ET)table · 2026-09-19 · 3×12 MU: median quoted spread by half hour on July 7, 2026 (ET, regular hours)series · 2026-09-19 · 13×5Preview: a 13-point series, ending lower. MU into July 7, 2026: prior regular-session close, opening print, overnight gapscalar · 2026-09-19 · 1×3984.31
Why Short Interest Data Is Always Two Weeks Old
The pipeline lag in one row: plus the bulk backfill these figures deliberately excludescalar · 2026-09-19 · 1×612 Every incrementally-delivered settlement: measured on one date, on file days laterseries · 2026-09-19 · 12×3Preview: a 12-point series, ending lower. GME, winter 2020-21: each short interest print and the price move before it went public (as-traded prices)table · 2026-09-19 · 6×5 GME days to cover: as reported in the file, and recomputed on the volume that traded while the print was pendingscalar · 2026-09-19 · 1×857 The current state of the cycle: the newest print on file, and the one still in the pipelinescalar · 2026-09-19 · 1×622,567 The blind window: what five stocks did between the settlement date and the day its short interest was publishedtable · 2026-09-19 · 5×6
Why Odd Lots Don't Set the NBBO
Round lot size for a basket of familiar tickers, from the latest closeranking · 2026-09-19 · 9×3Preview: 9 ranked values, largest first. Listed names averaging above $250 a share, by monthseries · 2026-09-19 · 24×2Preview: a 16-point series, ending lower. How many listed names sit in each round lot tierranking · 2026-09-19 · 3×3Preview: 3 ranked values, largest first. AAPL trade sizes on the 27 April 2026 sessionranking · 2026-09-19 · 4×3Preview: 4 ranked values, largest first.
Why Index Options Are Taxed 60/40: Section 1256
Average daily options volume: Section 1256 names against equity optionsranking · 2026-09-19 · 4×3Preview: 4 ranked values, largest first. Share of contract volume by days to expiry, SPX and SPYranking · 2026-09-19 · 5×3Preview: 5 ranked values, largest first.
Who Sets the Ex-Dividend Date? Not the Board
One-time distributions by size: where the ex-date landsranking · 2026-09-19 · 4×4Preview: 4 ranked values, largest first. Regular dividends: ex-date before the record date, or on itseries · 2026-09-19 · 44×5Preview: a 16-point series, ending higher. Board declaration to ex-date to payment, eight household payersranking · 2026-09-19 · 8×4Preview: 8 ranked values, largest first. Ex-date alignment by payout cadence, since T+1 took effectranking · 2026-09-19 · 6×4Preview: 6 ranked values, largest first.
Which Stocks Have Weekly Options? How to Tell
Optionable underlyings by expiration pattern, trailing five weeksranking · 2026-09-19 · 4×2Preview: 4 ranked values, largest first. Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdaysranking · 2026-09-19 · 25×4Preview: 16 ranked values, largest first. Underlyings with a traded expiration on each weekday, trailing five weeksranking · 2026-09-19 · 6×2Preview: 6 ranked values, smallest first. AAPL expirations within 130 days, as of Monday Aug 24, 2026series · 2026-09-19 · 12×5Preview: a 12-point series, ending higher.
Which Stocks Have Daily Options?
Monday, Wednesday, Friday expirations: distinct option roots carrying an expiry on each weekdayseries · 2026-09-19 · 5×3Preview: a 5-point series, ending higher. Daily options vs weekly options: upcoming expiration dates for six household tickersranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. SPY's expiration on every trading day: each near-term SPY expiry date, its weekday and volumeseries · 2026-09-19 · 12×4Preview: a 12-point series, ending lower. Which tickers carry the most upcoming expirations: option roots by distinct expiration dates in the next six weeksranking · 2026-09-19 · 20×3Preview: 16 ranked values, largest first.
Where to Park Idle Cash
The pickup for extending: extra yield over the 1-month bill, in basis pointsseries · 2026-09-19 · 125×3Preview: a 16-point series, ending higher. The short end over the last 180 days: 1-month, 3-month and 1-year bill yieldsseries · 2026-09-19 · 125×5Preview: a 16-point series, ending higher. The current Treasury yield curve: what every maturity pays right nowranking · 2026-09-19 · 7×2Preview: 7 ranked values, smallest first.
When Special Dividends Adjust Options
Time value left in KO calls as they move deeper in the moneyranking · 2026-09-19 · 5×4Preview: 5 ranked values, largest first. One time distributions by size, measured against the ex date closing priceranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. How big each kind of cash distribution is, as a share of the stock priceranking · 2026-09-19 · 5×4Preview: 5 ranked values, largest first. One time cash distributions per calendar year, and their share of all payoutsranking · 2026-09-19 · 9×3Preview: 9 ranked values, largest first.
When Is Short Interest Released?
The short interest release schedule: recent FINRA settlement dates and names reportedseries · 2026-09-19 · 16×2Preview: a 16-point series, ending lower. Measured publication lag: settlement date vs the day the file first arrived hereseries · 2026-09-19 · 12×3Preview: a 12-point series, ending lower. The publication lag in one row: fastest, median and slowest across incrementally-delivered settlementsscalar · 2026-09-19 · 1×412 Day-of-month and the gap between consecutive settlement dates: the twice-monthly cadenceseries · 2026-09-19 · 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-09-19 · 1×631
When Short Options Get Assigned Early
Time value left in AAPL contracts by depth in the moneytable · 2026-09-19 · 5×5 AAPL calls 1 to 5 percent in the money, by days left to expiryranking · 2026-09-19 · 6×4Preview: 6 ranked values, smallest first. Latest cash dividend per share, and what it is worth against the stockseries · 2026-09-19 · 6×4Preview: a 6-point series, ending lower. Put versus call implied volatility, near the money, 20 to 45 days outranking · 2026-09-19 · 5×4Preview: 5 ranked values, smallest first.
When Do Options Start Trading After an IPO?
How long-dated a new chain gets in its first twelve weeksranking · 2026-09-19 · 12×3Preview: 12 ranked values, smallest first. Trading sessions from first equity print to first listed option printranking · 2026-09-19 · 12×4Preview: 12 ranked values, smallest first. How quickly the forty largest new listings got a traded option chainranking · 2026-09-19 · 20×3Preview: 16 ranked values, smallest first. How a new option chain widens: strikes and expirations tradedranking · 2026-09-19 · 12×3Preview: 12 ranked values, smallest first.
What Time Do Options Start Trading?
SPY option volume, minute by minute into the 9:30 openseries · 2026-09-19 · 46×3Preview: a 16-point series, ending higher. US option contract volume by Eastern-time half hourseries · 2026-09-19 · 21×3Preview: a 16-point series, ending higher. Scheduled open and close on every upcoming half dayseries · 2026-09-19 · 2×6Preview: a 2-point series, roughly flat.
What Replaced the PDT Rule? Intraday Margin
What 100 shares, one contract's deliverable, cost at the end of August 2026ranking · 2026-09-19 · 6×4Preview: 6 ranked values, largest first. Intraday high-to-low range as a share of the open, August 2026ranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. The five widest AAPL sessions of August 2026 for the same $5,000 accountranking · 2026-09-19 · 5×3Preview: 5 ranked values, largest first. A $5,000 account holding $20,000 of AAPL from the open: loss and deficit at each session low, August 2026series · 2026-09-19 · 21×3Preview: a 16-point series, ending lower.
What Real-Time Market Data Actually Costs
Where AAPL shares printed across venues, June 16 2026ranking · 2026-09-19 · 12×2Preview: 12 ranked values, largest first. US symbols that traded each month over the past yearseries · 2026-09-19 · 12×3Preview: a 12-point series, ending higher. AAPL quote updates by ET clock hour, June 16 2026ranking · 2026-09-19 · 16×3Preview: 16 ranked values, largest first. One ETF's daily record, year by yearranking · 2026-09-19 · 15×3Preview: 15 ranked values, largest first.
What It Costs to Trade a Stock, Measured
The one-cent floor: share price, percent of quotes exactly one cent wide, and what a penny costs in bpstable · 2026-09-19 · 5×6 NVDA vs SOXS: median quoted spread over the window, with the smallest single-session gapscalar · 2026-09-19 · 1×50.91 NVDA vs SOXS: median quoted spread by session (bps of the midpoint)series · 2026-09-19 · 5×4Preview: a 5-point series, ending lower. The cost-to-trade ladder: median quoted spread in bps of the midpoint, regular hours, recent completed sessionstable · 2026-09-19 · 12×5
What Is VIX1D? The 1-Day Volatility Index
Implied daily move (IV / 16) against realized daily movement, SPY by monthseries · 2026-09-19 · 13×5Preview: a 13-point series, ending lower. SPY option volume by expiration through one session, June 17 2026series · 2026-09-19 · 14×4Preview: a 14-point series, ending lower. SPY near-the-money implied volatility by days to expiryranking · 2026-09-19 · 8×2Preview: 8 ranked values, largest first. SPY absolute daily move, median and 90th percentile by yearranking · 2026-09-19 · 8×4Preview: 8 ranked values, smallest first.
What Is the NBBO? National Best Bid and Offer
NBBO updates per session: four heavily traded names vs. two thin small capsseries · 2026-09-19 · 6×5Preview: a 6-point series, ending lower. Exchange stamp to SIP stamp: the consolidation step, in microsecondsranking · 2026-09-19 · 4×3Preview: 4 ranked values, smallest first. The smallest size the NBBO will show: six names across the price tiersranking · 2026-09-19 · 6×4Preview: 6 ranked values, smallest first. KO: ten consecutive NBBO updates from 1:30 p.m. ET on a recent sessionseries · 2026-09-19 · 10×7Preview: a 10-point series, roughly flat. GME, 2024-05-14: NBBO updates and trades per minute across a five-minute LULD pauseseries · 2026-09-19 · 15×3Preview: a 15-point series, roughly flat. AAPL: average NBBO updates per minute by half-hour bucket (ET, 4 a.m. to 8 p.m.)series · 2026-09-19 · 32×3Preview: a 16-point series, roughly flat.
What Is the 3m10y Spread? The Fed's Yield Curve
3-month and 10-year yields with both spreads, last 90 daysseries · 2026-09-19 · 62×6Preview: a 16-point series, ending higher. 3m10y and 2s10s spreads, monthly averages over twenty yearsseries · 2026-09-19 · 241×4Preview: a 16-point series, ending higher. Every 3m10y inversion since 1985, on monthly averagesseries · 2026-09-19 · 9×6Preview: a 9-point series, roughly flat. Three tenors through the 2022 hiking cycle, monthly averagesseries · 2026-09-19 · 42×5Preview: a 16-point series, ending higher. 2s10s versus 3m10y in three inversion windows, daily closestable · 2026-09-19 · 3×9
page 1 of 25
Payout ratio by yield band: US payers above $1B market cap, latest snapshot on file

Payout ratio by yield band: US payers above $1B market cap, latest snapshot on file

as of table 5×6read in context →
Payout ratio by yield band: US payers above $1B market cap, latest snapshot on file — 5 rows by 6 columns, computed from US exchange, SIP and OPRA data.
yield_bandpayersmedian_yield_pctmedian_payout_ratio_pctpct_paying_over_earningspct_no_positive_eps
under 2%5650.920.62.99.4
2-4%3402.848.211.66.2
4-6%1244.786.337.413.7
6-8%566.6612159.616.1
8% and up6211.2175.379.214.5
the exact SQL behind every number 
SELECT multiIf(dividend_yield * 100 >= 8, '8% and up',
               dividend_yield * 100 >= 6, '6-8%',
               dividend_yield * 100 >= 4, '4-6%',
               dividend_yield * 100 >= 2, '2-4%',
               'under 2%') AS yield_band,
       count() AS payers,
       round(quantileDeterministic(0.5)(dividend_yield * 100, cityHash64(ticker)), 2) AS median_yield_pct,
       round(quantileDeterministicIf(0.5)(dividend_yield * price / earnings_per_share * 100,
                                          cityHash64(ticker), earnings_per_share > 0), 1) AS median_payout_ratio_pct,
       round(100 * countIf(earnings_per_share > 0 AND dividend_yield * price > earnings_per_share)
             / countIf(earnings_per_share > 0), 1) AS pct_paying_over_earnings,
       round(100 * countIf(earnings_per_share <= 0) / count(), 1) AS pct_no_positive_eps
FROM global_markets.stocks_ratios
WHERE date = (SELECT max(date) FROM global_markets.stocks_ratios)
  AND price >= 5
  AND market_cap >= 1000000000
  AND dividend_yield > 0
  AND earnings_per_share IS NOT NULL
GROUP BY yield_band
HAVING countIf(earnings_per_share > 0) > 0
ORDER BY median_yield_pct
More from this analysisDividend Yield Traps: How to Spot One
Dividend outcome over the following 12 months by starting yield band (cohort of June 30, 2025) table 5×7 → How each yield band got there: median price and dividend change over the prior 12 months table 5×5 → Conagra (CAG): month-end price, annualized dividend rate, and yield, 2021-08 to 2026-07 series 60×5 → Highest dividend yields: US-listed companies over $2B, latest snapshot on file table 15×5 → See all 2,401 queries →
$