STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

Limited Margin in an IRA: Rules and Limits
Reported short sale volume as a share of total volume, past six monthsranking · 2026-10-09 · 5×3Preview: 5 ranked values, largest first. Front-end Treasury yields, monthly averagesseries · 2026-10-09 · 14×3Preview: a 14-point series, ending higher. How often the settlement wait is overnight, and how often it is longerranking · 2026-10-09 · 4×3Preview: 4 ranked values, largest first. Calendar days from a sale to its settlement date, session by sessionseries · 2026-10-09 · 70×3Preview: a 16-point series, ending higher.
Is There a Minimum Holding Period for Stocks?
SPY daily closes across a pinned 61 day wash sale window, Jan to Mar 2025series · 2026-10-05 · 41×4Preview: a 16-point series, roughly flat. Trades and share volume per session, six household names, September 2026ranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. Days between ex-dividend date and record date, ten household payersseries · 2026-10-05 · 19×4Preview: a 16-point series, roughly flat. Average days between ex-dividend dates, 2021 to dateseries · 2026-10-05 · 10×4Preview: a 10-point series, ending higher.
Why VIX Options Don't Track the VIX
SPY near-the-money implied volatility by distance to expirationranking · 2026-10-04 · 6×3Preview: 6 ranked values, smallest first. How far the long tenor travels on days the front end jumpsranking · 2026-10-04 · 5×4Preview: 5 ranked values, smallest first. Near-dated versus long-dated SPY implied volatility, session by sessionseries · 2026-10-04 · 81×3Preview: a 16-point series, ending lower. The near-to-far implied volatility gap across liquid namesranking · 2026-10-04 · 6×4Preview: 6 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-10-04 · 1×613 Every incrementally-delivered settlement: measured on one date, on file days laterseries · 2026-10-04 · 13×3Preview: a 13-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-10-04 · 6×5 GME days to cover: as reported in the file, and recomputed on the volume that traded while the print was pendingscalar · 2026-10-04 · 1×839.1 The current state of the cycle: the newest print on file, and the one still in the pipelinescalar · 2026-10-04 · 1×622,593 The blind window: what five stocks did between the settlement date and the day its short interest was publishedtable · 2026-10-04 · 5×6
Who Sets the Ex-Dividend Date? Not the Board
One-time distributions by size: where the ex-date landsranking · 2026-10-04 · 4×4Preview: 4 ranked values, largest first. Regular dividends: ex-date before the record date, or on itseries · 2026-10-04 · 45×5Preview: a 16-point series, ending higher. Board declaration to ex-date to payment, eight household payersranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. Ex-date alignment by payout cadence, since T+1 took effectranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first.
When Is Short Interest Released?
The short interest release schedule: recent FINRA settlement dates and names reportedseries · 2026-10-04 · 16×2Preview: a 16-point series, ending lower. Measured publication lag: settlement date vs the day the file first arrived hereseries · 2026-10-04 · 13×3Preview: a 13-point series, ending lower. The publication lag in one row: fastest, median and slowest across incrementally-delivered settlementsscalar · 2026-10-04 · 1×413 Day-of-month and the gap between consecutive settlement dates: the twice-monthly cadenceseries · 2026-10-04 · 16×3Preview: a 16-point series, roughly flat. The current state of the release cycle: the newest print on file and the settlement still pendingscalar · 2026-10-04 · 1×615
When Do NDX Options Expire?
Listed QQQ option expirations by weekday, trailing 90 days of traded contractsranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Share of QQQ regular-session volume in the first 15 minutes, monthly expiration Fridaysseries · 2026-10-04 · 12×4Preview: a 12-point series, ending lower. NDX monthly expirations ahead: third Friday, Thursday last trade, exchange statusseries · 2026-10-04 · 9×6Preview: a 9-point series, ending higher. QQQ volume by ET hour: quarterly expiration Friday (2026-09-18) vs the prior Friday (2026-09-11)series · 2026-10-04 · 7×3Preview: a 7-point series, ending higher.
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-04 · 10×3Preview: 10 ranked values, largest first. Upcoming VIX settlement dates and the SPX expiry each one usesseries · 2026-10-04 · 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-04 · 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-04 · 3×4Preview: a 3-point series, ending higher.
Street Name vs Holder of Record: Cede & Co
Average days from record date to pay date, eight large dividend payersranking · 2026-10-04 · 8×3Preview: 8 ranked values, largest first. Reported short interest and days to cover, latest settlement date on fileranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. Coca-Cola quarterly dividends: calendar days from ex-dividend date to record dateseries · 2026-10-04 · 15×4Preview: a 15-point series, ending higher. Cash dividends by month: did the record date land on the ex-dividend date?series · 2026-10-04 · 41×5Preview: a 16-point series, ending higher.
SPX vs SPY Options: Which One to Trade
SPY option volume by days to expiry, trailing six weeksranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Time value left in deep in-the-money SPY calls, against the dividend at stakeranking · 2026-10-04 · 15×4Preview: 15 ranked values, smallest first. How close SPY closes to the nearest whole-dollar strike on monthly expirationsseries · 2026-10-04 · 12×4Preview: a 12-point series, roughly flat. What one contract controls: SPX, SPY and XSPranking · 2026-10-04 · 3×4Preview: 3 ranked values, largest first.
Short Delivery Auction in India: NSE Rules
Rule 204 close-out deadline for a short-sale fail, by trade date (US sessions, trailing weeks)series · 2026-10-04 · 15×6Preview: a 15-point series, ending lower. SEBI's close-out formula applied to a US tape (AAPL, trailing three weeks, illustrative)series · 2026-10-04 · 14×4Preview: a 14-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-04 · 1×90.27 Median waits along the dividend calendar (trailing 12 months, recurring US dividends)scalar · 2026-10-04 · 1×346,252 Calendar days from ex-dividend date to record date (trailing 12 months)ranking · 2026-10-04 · 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-04 · 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-04 · 18×3Preview: 16 ranked values, largest first. Dividends that went ex AFTER the record date: special vs. recurring, trailing 12 monthstable · 2026-10-04 · 2×6
Mutual Fund Exchange vs Selling and Rebuying
How many calendar days one trading session sits from the nextranking · 2026-10-04 · 4×3Preview: 4 ranked values, largest first. Upcoming US market holidays and early closesseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. Average SPY volume per minute over the final half hour of the sessionseries · 2026-10-04 · 30×2Preview: a 16-point series, ending higher.
How Stock Settlement Works Under T+1
Trade date to settlement date across real sessions, November 2025series · 2026-10-04 · 11×5Preview: a 11-point series, ending higher. Ex-dividend date to payment date, latest 2026 dividend for nine household payersseries · 2026-10-04 · 9×4Preview: a 9-point series, ending higher. Microsoft dividend dates, from the T+2 era into T+1series · 2026-10-04 · 14×6Preview: a 14-point series, ending lower. Gap between ex-dividend date and record date, by yearranking · 2026-10-04 · 12×3Preview: 12 ranked values, largest first.
Good Faith Violations in Cash Accounts
Every session ahead, and the day a sale made in it settlesseries · 2026-10-04 · 15×4Preview: a 15-point series, ending higher. KO and AAPL closes across the July 2026 holiday week, with settlement datesseries · 2026-10-04 · 9×5Preview: a 9-point series, ending higher. Trailing year: calendar days a sale waited to settleranking · 2026-10-04 · 4×3Preview: 4 ranked values, largest first.
ETF vs Mutual Fund Settlement: Two Clocks
SPY by half hour clock bucket, pinned session of Sep 15, 2026series · 2026-10-04 · 13×2Preview: a 13-point series, ending lower. Upcoming trade dates and the day their cash settlesseries · 2026-10-04 · 15×6Preview: a 15-point series, ending higher. Closures and early closes still ahead on the exchange calendarseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. How far the 11:00 a.m. print sat from the closing print, Sep 15, 2026ranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. Calendar days from trade date to settlement, by weekdayseries · 2026-10-04 · 5×4Preview: a 5-point series, ending higher.
Is the US Market Open on Japanese Holidays?
One-minute SPY bars per session, US Thanksgiving week 2025series · 2026-10-04 · 7×3Preview: a 7-point series, roughly flat. US market closures ahead that Tokyo trades throughseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. What the US tape did on 2026 Tokyo market holidaysseries · 2026-10-04 · 13×5Preview: a 13-point series, roughly flat. US sessions through the Golden Week 2026 Tokyo closureseries · 2026-10-04 · 10×4Preview: a 10-point series, ending higher.
Do Mutual Funds Trade on Market Holidays?
Scheduled early closes ahead, with the exchange close timeseries · 2026-10-04 · 2×4Preview: a 2-point series, ending higher. Upcoming US market closures and shortened sessionsseries · 2026-10-04 · 12×4Preview: a 12-point series, ending higher. Short regular sessions on the SPY tape since January 2024ranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. 2026 sessions that reopened more than three calendar days laterseries · 2026-10-04 · 7×3Preview: a 7-point series, roughly flat.
Cash Settled vs Physical Delivery Options
SPY: widest open print to close print gaps on monthly expiration Fridays since 2021ranking · 2026-10-04 · 12×4Preview: 12 ranked values, smallest first. How close SPY closes to a whole dollar strike, expiration Fridays vs every other sessionranking · 2026-10-04 · 4×4Preview: 4 ranked values, smallest first. Dividend owed per assigned contract, recent ex dividend datesseries · 2026-10-04 · 6×3Preview: a 6-point series, ending lower. What 100 shares per contract is worth, six household namesseries · 2026-10-04 · 6×3Preview: a 6-point series, ending lower.
ASX Options Expiry and Settlement Explained
Average distance from the opening print, first 30 minutes (SPY)series · 2026-10-04 · 31×2Preview: a 16-point series, ending higher. How far eight large caps travel from their opening print by 10:00ranking · 2026-10-04 · 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-04 · 61×2Preview: a 16-point series, roughly flat.
AI Trading Bots and Real Brokerage Orders
Upcoming market closures that move a settlement dateseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. AAPL quoted spread and quote traffic by ET clock time, 14 August 2026series · 2026-10-04 · 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-04 · 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-04 · 5×4Preview: 5 ranked values, largest first. Minutes with a 1% high to low range, January to September 2026ranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first.
When Do VIX Futures Expire? 2026 Dates
The walk-back arithmetic, step by step, for four contractstable · 2026-10-01 · 4×7 Contract months since 2015 that did not settle on a Wednesdaytable · 2026-10-01 · 5×4 Days between consecutive VIX futures settlements, 2026 cycleseries · 2026-10-01 · 12×3Preview: a 12-point series, ending lower. VIX futures final settlement dates, 2026 monthly contractsseries · 2026-10-01 · 12×5Preview: a 12-point series, ending lower.
What Are Tokenized Stocks? Rights & Settlement
Apple share volume by session segment, Aug 17 to Sep 11, 2026ranking · 2026-09-28 · 5×3Preview: 5 ranked values, largest first. Share of volume printed outside the regular session, five names, same four weeksranking · 2026-09-28 · 5×3Preview: 5 ranked values, largest first. Apple dividends: ex-date, record date and pay date, 2024 to August 2026series · 2026-09-28 · 11×7Preview: a 11-point series, ending lower.
Due Bills and Stock Splits: Ex-Date Timing
US stock splits by year, sorted by size of the distributionranking · 2026-09-26 · 10×4Preview: 10 ranked values, smallest first. NVDA across its June 2024 split: stored close and one pre-split shareseries · 2026-09-26 · 10×5Preview: a 10-point series, ending higher. Days between pay date and ex-date, cash distributions that went ex lateranking · 2026-09-26 · 12×3Preview: 12 ranked values, largest first. Recent household-name splits: shares from one shareranking · 2026-09-26 · 15×4Preview: 15 ranked values, largest first.
Can You Sell on the Ex-Dividend Date?
From ex-dividend date to record date to the cash, in calendar daystable · 2026-09-26 · 8×6 Share of 2024 US dividends whose record date fell on the ex-dividend dateseries · 2026-09-26 · 12×3Preview: a 12-point series, ending higher. Shares held short against average daily volume, large dividend payersranking · 2026-09-26 · 8×4Preview: 8 ranked values, largest first.
page 1 of 2
Reported short sale volume as a share of total volume, past six months

Reported short sale volume as a share of total volume, past six months

most recentas of ranking 5×3read in context →
Reported short sale volume as a share of total volume, past six months — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickershort_share_pctbusiest_day_pct
SPY54.276.2
AAPL46.563.3
KO43.265.6
NVDA38.757.4
MSFT36.861.4
the exact SQL behind every number
WITH daily AS
(
    SELECT
        date,
        ticker,
        max(toFloat64(short_volume)) AS short_vol,
        max(toFloat64(total_volume)) AS total_vol
    FROM global_markets.stocks_short_volume
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO')
      AND ticker NOT IN ('SPCX')
      AND date >= today() - 180
    GROUP BY date, ticker
    HAVING max(toFloat64(total_volume)) > 0
)
SELECT
    ticker,
    round(100 * sum(short_vol) / sum(total_vol), 1) AS short_share_pct,
    round(100 * max(short_vol / total_vol), 1)      AS busiest_day_pct
FROM daily
GROUP BY ticker
ORDER BY short_share_pct DESC
$