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

2,178 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-08-29 · 1×71.03 XOM recent dividend payments: ex-dividend date and per-share amountseries · 2026-08-29 · 10×2Preview: a 10-point series, ending lower. XOM total dividends paid per year (regular dividends)ranking · 2026-08-29 · 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-08-29 · 1×70.248 WMT recent dividend payments: ex-dividend date and per-share amountseries · 2026-08-29 · 10×2Preview: a 10-point series, ending lower. WMT total dividends paid per year (regular dividends)ranking · 2026-08-29 · 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-08-29 · 6×3Preview: 6 ranked values, smallest first. How far the long tenor travels on days the front end jumpsranking · 2026-08-29 · 5×4Preview: 5 ranked values, smallest first. Near-dated versus long-dated SPY implied volatility, session by sessionseries · 2026-08-29 · 76×3Preview: a 16-point series, roughly flat. The near-to-far implied volatility gap across liquid namesranking · 2026-08-29 · 6×4Preview: 6 ranked values, largest first.
Why Ticker Symbols Break Your Dataset
When each symbol last printed a daily barranking · 2026-08-29 · 6×3Preview: 6 ranked values, largest first. New listings landing on a symbol that already had historyranking · 2026-08-29 · 11×3Preview: 11 ranked values, smallest first. Which share-class spellings actually carry historyranking · 2026-08-29 · 4×4Preview: 4 ranked values, smallest first. Trading sessions per year under FB and METAranking · 2026-08-29 · 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-08-29 · 6×3Preview: 6 ranked values, largest first. Average minute range through the session, five liquid namesseries · 2026-08-29 · 26×3Preview: a 16-point series, ending lower. How far eight stocks move in a five minute window, trailing yearranking · 2026-08-29 · 8×4Preview: 8 ranked values, largest first. What a 5 percent band is worth in dollars, by price levelranking · 2026-08-29 · 8×4Preview: 8 ranked values, largest first.
Why Short Interest Data Is Always Two Weeks Old
The pipeline lag in one row: plus the bulk backfill these figures deliberately excludescalar · 2026-08-29 · 1×611 Every incrementally-delivered settlement: measured on one date, on file days laterseries · 2026-08-29 · 11×3Preview: a 11-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-08-29 · 6×5 GME days to cover: as reported in the file, and recomputed on the volume that traded while the print was pendingscalar · 2026-08-29 · 1×854 The current state of the cycle: the newest print on file, and the one still in the pipelinescalar · 2026-08-29 · 1×622,480 The blind window: what five stocks did between the settlement date and the day its short interest was publishedtable · 2026-08-29 · 5×6
Why Index Options Are Taxed 60/40: Section 1256
Average daily options volume: Section 1256 names against equity optionsranking · 2026-08-29 · 4×3Preview: 4 ranked values, largest first. Share of contract volume by days to expiry, SPX and SPYranking · 2026-08-29 · 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-08-29 · 4×4Preview: 4 ranked values, largest first. Regular dividends: ex-date before the record date, or on itseries · 2026-08-29 · 43×5Preview: a 16-point series, ending higher. Board declaration to ex-date to payment, eight household payersranking · 2026-08-29 · 8×4Preview: 8 ranked values, largest first. Ex-date alignment by payout cadence, since T+1 took effectranking · 2026-08-29 · 6×4Preview: 6 ranked values, largest first.
Where to Park Idle Cash
The pickup for extending: extra yield over the 1-month bill, in basis pointsseries · 2026-08-29 · 126×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-08-29 · 126×5Preview: a 16-point series, ending higher. The current Treasury yield curve: what every maturity pays right nowranking · 2026-08-29 · 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-08-29 · 5×4Preview: 5 ranked values, largest first. One time distributions by size, measured against the ex date closing priceranking · 2026-08-29 · 6×3Preview: 6 ranked values, largest first. How big each kind of cash distribution is, as a share of the stock priceranking · 2026-08-29 · 5×4Preview: 5 ranked values, largest first. One time cash distributions per calendar year, and their share of all payoutsranking · 2026-08-29 · 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-08-29 · 16×2Preview: a 16-point series, ending lower. Measured publication lag: settlement date vs the day the file first arrived hereseries · 2026-08-29 · 11×3Preview: a 11-point series, ending lower. The publication lag in one row: fastest, median and slowest across incrementally-delivered settlementsscalar · 2026-08-29 · 1×411 Day-of-month and the gap between consecutive settlement dates: the twice-monthly cadenceseries · 2026-08-29 · 16×3Preview: a 16-point series, ending lower. The current state of the release cycle: the newest print on file and the settlement still pendingscalar · 2026-08-29 · 1×614
When Short Options Get Assigned Early
Time value left in AAPL contracts by depth in the moneytable · 2026-08-29 · 5×5 AAPL calls 1 to 5 percent in the money, by days left to expiryranking · 2026-08-29 · 6×4Preview: 6 ranked values, smallest first. Latest cash dividend per share, and what it is worth against the stockseries · 2026-08-29 · 6×4Preview: a 6-point series, ending lower. Put versus call implied volatility, near the money, 20 to 45 days outranking · 2026-08-29 · 5×4Preview: 5 ranked values, smallest first.
What Time Do Options Start Trading?
SPY option volume, minute by minute into the 9:30 openseries · 2026-08-29 · 46×3Preview: a 16-point series, ending higher. US option contract volume by Eastern-time half hourseries · 2026-08-29 · 21×3Preview: a 16-point series, ending higher. Scheduled open and close on every upcoming half dayseries · 2026-08-29 · 2×6Preview: a 2-point series, roughly flat.
What Real-Time Market Data Actually Costs
Where AAPL shares printed across venues, June 16 2026ranking · 2026-08-29 · 12×2Preview: 12 ranked values, largest first. US symbols that traded each month over the past yearseries · 2026-08-29 · 12×3Preview: a 12-point series, ending higher. AAPL quote updates by ET clock hour, June 16 2026ranking · 2026-08-29 · 16×3Preview: 16 ranked values, largest first. One ETF's daily record, year by yearranking · 2026-08-29 · 15×3Preview: 15 ranked values, largest first.
What Is VIX1D? The 1-Day Volatility Index
Implied daily move (IV / 16) against realized daily movement, SPY by monthseries · 2026-08-29 · 14×5Preview: a 14-point series, ending higher. SPY option volume by expiration through one session, June 17 2026series · 2026-08-29 · 14×4Preview: a 14-point series, ending lower. SPY near-the-money implied volatility by days to expiryranking · 2026-08-29 · 8×2Preview: 8 ranked values, largest first. SPY absolute daily move, median and 90th percentile by yearranking · 2026-08-29 · 8×4Preview: 8 ranked values, smallest first.
What Is the 2s10s Spread? Yield Curve Data
The 2s10s spread as of the latest close (10-year minus 2-year)scalar · 2026-08-29 · 1×54.2 2s10s spread, monthly average: last 20 yearsseries · 2026-08-29 · 240×2Preview: a 16-point series, ending higher. 2s10s inversion episodes: first close, last close, length, and depthranking · 2026-08-29 · 11×4Preview: 11 ranked values, smallest first. US Treasury yield curve: latest available yield per maturityranking · 2026-08-29 · 7×2Preview: 7 ranked values, smallest first.
What Is Form N-PORT? Fund Holdings Filing
Most-filed EDGAR form types over the trailing yearranking · 2026-08-29 · 12×3Preview: 12 ranked values, largest first. When Q1 2026 13F reports landed, by week after quarter endranking · 2026-08-29 · 13×2Preview: 13 ranked values, largest first. How long institutional managers take to file a 13F after quarter endseries · 2026-08-29 · 12×4Preview: a 12-point series, roughly flat.
What Is Dividend Yield? What's Normal in 2026
Trailing dividend yields: eight household names, latest snapshot on fileranking · 2026-08-29 · 8×3Preview: 8 ranked values, largest first. The market's dividend yield vs. the 10-year Treasury: end-June readings, 2016-2026table · 2026-08-29 · 11×5 Trailing yield by sector fund: twelve months of distributions ÷ latest pricetable · 2026-08-29 · 13×5 Recurring cash dividends by payment schedule: H1 2026, all US-listed payersranking · 2026-08-29 · 5×3Preview: 5 ranked values, largest first. Payout ratio by yield band: US payers, $1B+ market cap, latest snapshottable · 2026-08-29 · 4×6 Dividend yield across the US market: $1B+ market cap, $5+ share price, latest snapshotscalar · 2026-08-29 · 1×62,068 Conagra (CAG): price, quarterly dividend, and yield, month-end 2023-07 to 2026-06series · 2026-08-29 · 36×5Preview: a 16-point series, ending higher.
What Is a Short Squeeze? GameStop, Measured
Four January 2021 squeezes: price multiple and short interest before and after (as-traded prices)table · 2026-08-29 · 4×6 GME weekly price range and shares traded, January through mid-February 2021 (as-traded prices)table · 2026-08-29 · 7×5 GME 2021, one row: January low, late-January peak, February trough, March rebound (as-traded prices)scalar · 2026-08-29 · 1×717.05 GME short interest by settlement date, November 2020 through March 2021ranking · 2026-08-29 · 10×3Preview: 10 ranked values, largest first. GME options volume by week: calls vs. puts and total premium, January 2021table · 2026-08-29 · 5×5 Highest days to cover among liquid names: latest settlement on filetable · 2026-08-29 · 10×5 Days to cover across liquid names: every ticker averaging 5M+ shares/day, latest settlement on filescalar · 2026-08-29 · 1×6745
What Is a Reverse Stock Split? Good or Bad?
2026 executed US stock splits: reverse vs. forwardscalar · 2026-08-29 · 1×3807 The most recent US reverse stock splits on recordseries · 2026-08-29 · 12×4Preview: a 12-point series, roughly flat. 2026's most common reverse split ratiosranking · 2026-08-29 · 10×2Preview: 10 ranked values, largest first. Where reverse-split companies stood a year later (splits executed 12-18 months ago)ranking · 2026-08-29 · 3×3Preview: 3 ranked values, largest first. ASST: daily closes around its 1-for-20 reverse split (execution date 2026-02-06)series · 2026-08-29 · 69×3Preview: a 16-point series, ending higher. Reverse vs. forward splits by year, 2019 to todayranking · 2026-08-29 · 8×4Preview: 8 ranked values, smallest first. ASST's reverse split history on recordseries · 2026-08-29 · 2×6Preview: a 2-point series, roughly flat. What happened next: median move after a reverse split vs. SPY, splits executed 4-9 months agoseries · 2026-08-29 · 3×7Preview: a 3-point series, ending higher.
What Is a Good Dividend Yield in 2026?
Where US dividend payers sit: yield bands, $1B+ market cap, latest snapshotranking · 2026-08-29 · 7×4Preview: 7 ranked values, largest first. The 10-year Treasury yield, month by month: July 2021 to the latest reading on fileseries · 2026-08-29 · 61×3Preview: a 16-point series, ending higher. Trailing yield by sector fund: twelve months of distributions over the late-July 2026 priceranking · 2026-08-29 · 11×4Preview: 11 ranked values, largest first. Intel (INTC): month-end price, quarterly dividend, and quoted yield, Jan 2021 to Jun 2024series · 2026-08-29 · 42×5Preview: a 16-point series, ending lower. Current yield vs five-year dividend growth: ten household payers, July 2026ranking · 2026-08-29 · 10×4Preview: 10 ranked values, smallest first.
What Is a Calendar Spread in Options?
Near the money implied volatility by expiry band, three namesranking · 2026-08-29 · 6×4Preview: 6 ranked values, largest first. AAPL front band against back band implied volatility, trailing monthsseries · 2026-08-29 · 76×4Preview: a 16-point series, ending higher. How often front volatility sat above back volatilityranking · 2026-08-29 · 5×4Preview: 5 ranked values, largest first. Theta and vega across expiry bands, near the money AAPLranking · 2026-08-29 · 6×3Preview: 6 ranked values, largest first.
WFC Dividend: Yield, History & Ex-Dates
WFC dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-08-29 · 1×70.5 WFC recent dividend payments: ex-dividend date and per-share amountseries · 2026-08-29 · 10×2Preview: a 10-point series, ending lower. WFC total dividends paid per year (regular dividends)ranking · 2026-08-29 · 7×2Preview: 7 ranked values, largest first.
Warrants vs Call Options: Key Differences
Recent forward stock splits and the share multiplierranking · 2026-08-29 · 12×4Preview: 12 ranked values, smallest first. Tesla basic and diluted share counts, quarter by quarterseries · 2026-08-29 · 12×5Preview: a 12-point series, ending lower.
page 1 of 22
At-the-money SPY gamma by time to expiry (2026-07-13)

At-the-money SPY gamma by time to expiry (2026-07-13)

as of ranking 4×2read in context →
At-the-money SPY gamma by time to expiry (2026-07-13) — 4 rows by 2 columns, computed from US exchange, SIP and OPRA data.
time_to_expiryavg_gamma
0-7 days0.0398
8-30 days0.0209
31-90 days0.0099
90+ days0.0039
the exact SQL behind every number
SELECT multiIf(days_to_expiry<=7,'0-7 days',days_to_expiry<=30,'8-30 days',
               days_to_expiry<=90,'31-90 days','90+ days') AS time_to_expiry,
       round(avg(gamma), 4) AS avg_gamma
FROM global_markets.options_greeks
WHERE date = '2026-07-13' AND underlying_symbol = 'SPY' AND abs(delta) BETWEEN 0.45 AND 0.55
GROUP BY time_to_expiry ORDER BY min(days_to_expiry)
$