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
Large special dividends from well-known payers since 2012

Large special dividends from well-known payers since 2012

as of ranking 12×3read in context →
Large special dividends from well-known payers since 2012 — 12 rows by 3 columns, computed from US exchange, SIP and OPRA data.
payer_yearyearspecial_dividend_usd
COST 2023202315
COST 2020202010
COST 201220127
COST 201720177
CME 202620266.15
FIZZ 202020206
CME 202420245.8
CME 202320235.25
LYB 202220225.2
COST 201520155
CME 202220224.5
CME 201720173.5
the exact SQL behind every number
SELECT
    concat(ticker, ' ', toString(toYear(ex_dividend_date))) AS payer_year,
    toYear(ex_dividend_date) AS year,
    round(cash_amount, 2) AS special_dividend_usd
FROM global_markets.stocks_dividends
WHERE frequency = 0
  AND cash_amount >= 1
  AND ticker IN ('COST', 'FIZZ', 'CME', 'LYB', 'LVS', 'EBAY', 'MPC', 'WSM', 'BBY', 'HRB')
  AND ex_dividend_date >= '2012-01-01'
ORDER BY special_dividend_usd DESC, payer_year ASC
LIMIT 12
$