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

2,249 answered market questions

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

Weekly Market Recap: The Week in Numbers
Where the volume went: most dollars traded over the past weekranking · 2026-09-15 · 8×2Preview: 8 ranked values, largest first. The eleven S&P 500 sectors over the past weekranking · 2026-09-15 · 11×2Preview: 11 ranked values, largest first. Biggest stock losers over the past weekranking · 2026-09-15 · 7×3Preview: 7 ranked values, smallest first. The major index ETFs over the past weekranking · 2026-09-15 · 4×4Preview: 4 ranked values, largest first. Biggest stock gainers over the past weekranking · 2026-09-15 · 7×3Preview: 7 ranked values, largest first. Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-09-15 · 5×3Preview: a 5-point series, ending lower.
Upcoming Stock Splits Calendar
Upcoming US stock splits: announced, with a future effective datetable · 2026-09-15 · 30×5 Announced upcoming splits by directionranking · 2026-09-15 · 2×2Preview: 2 ranked values, largest first. Announced stock splits by effective month: forward vs reverseseries · 2026-09-15 · 4×4Preview: a 4-point series, ending lower.
Upcoming Ex-Dividend Dates: Stocks This Week
Three household payers at their last ex-date: prior close, ex-morning open, and the payment for scaleseries · 2026-09-15 · 3×8Preview: a 3-point series, roughly flat. Who goes ex-dividend in the next 14 days: names, cadence and implied yield by size bandtable · 2026-09-15 · 4×5 Names going ex-dividend, day by day: the next seven days of declared recordsseries · 2026-09-15 · 5×5Preview: a 5-point series, ending lower. Ex-dividend dates by calendar month: three-year average, quarterly vs monthly payersseries · 2026-09-15 · 12×4Preview: a 12-point series, ending higher. Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-dateseries · 2026-09-15 · 13×8Preview: a 13-point series, roughly flat. Forward-declared ex-dividend records on file: the receipt behind this calendarscalar · 2026-09-15 · 1×53,507 Every mega-cap ex-dividend event of the past six months: price path from the pre-ex closetable · 2026-09-15 · 5×6 Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yieldseries · 2026-09-15 · 12×8Preview: a 12-point series, ending higher.
Unusual Volume Stocks This Week, Measured
How the whole qualifying universe traded this week, bucketed by relative volumeranking · 2026-09-15 · 7×4Preview: 7 ranked values, smallest first. Persistence check: the eight leaders' daily relative volume across the five sessionstable · 2026-09-15 · 8×5 Highest relative volume this week: trailing 5 sessions vs. the prior 40, for names trading $500M+ in the weekseries · 2026-09-15 · 8×6Preview: a 8-point series, ending lower. The board leader, day by day: daily relative volume and open-to-close change (last 15 sessions)series · 2026-09-15 · 15×5Preview: a 15-point series, roughly flat. Wild multiples the dollar floor removes: highest relative volume among names trading under $500M this weekseries · 2026-09-15 · 6×5Preview: a 6-point series, ending higher.
Unusual Options Activity: Last Session
Market-wide options volume by session, with monthly expirations labelledseries · 2026-09-15 · 25×5Preview: a 16-point series, ending higher. Calls or puts: the board's call and put contract volume on the same sessiontable · 2026-09-15 · 10×5 What follows a heavy options session: next-session absolute move vs. the same names on an ordinary daytable · 2026-09-15 · 5×6 What the session's contracts were made of: options volume by days to expiryranking · 2026-09-15 · 6×4Preview: 6 ranked values, largest first. Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-09-15 · 10×8
Short Squeeze Candidates This Week
Squeeze-shaped mechanics: crowded shorts among liquid names, with a rising priceranking · 2026-09-15 · 12×4Preview: 12 ranked values, largest first. The screened names ranked by short interest against shares outstanding (not float)table · 2026-09-15 · 10×5 Every past screened name, by what it did over the next 30 daysranking · 2026-09-15 · 6×3Preview: 6 ranked values, smallest first. From the whole settlement file down to the screened list, one rule at a timeranking · 2026-09-15 · 4×2Preview: 4 ranked values, largest first. Every input behind this screen, and how many days old it isseries · 2026-09-15 · 3×3Preview: a 3-point series, ending lower. Liquid names at 5+ and 10+ days to cover, settlement by settlementseries · 2026-09-15 · 12×4Preview: a 12-point series, ending higher.
Short Selling Bans Explained: US, Germany, EU
What ESMA measured during the 2020 bans (published estimates, % versus the control group)ranking · 2026-09-15 · 4×2Preview: 4 ranked values, largest first. Every outright short selling ban since 2008, dated to the order that set ittable · 2026-09-15 · 9×5
Recent Stock Splits (Forward and Reverse)
Forward vs reverse splits executed in the last 45 daysranking · 2026-09-15 · 2×2Preview: 2 ranked values, largest first. Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-09-15 · 15×4Preview: 15 ranked values, largest first. Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-09-15 · 15×4Preview: 15 ranked values, largest first.
Options Expiry Days in India: NSE and BSE
Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeksranking · 2026-09-15 · 3×4Preview: 3 ranked values, largest first.
Most Shorted Stocks Right Now, Measured
The receipts: universe size, filter bite, median crowding, and list churn at the latest printscalar · 2026-09-15 · 1×522,567 Largest short positions by shares: latest settlement, liquid namesranking · 2026-09-15 · 10×4Preview: 10 ranked values, largest first. Crowding leaders vs. their own price: about one month of sessionsseries · 2026-09-15 · 4×5Preview: a 4-point series, ending higher. GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-09-15 · 10×4Preview: a 10-point series, ending lower. Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-09-15 · 8×4Preview: a 8-point series, ending higher. Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-09-15 · 8×4Preview: 8 ranked values, largest first. Highest days to cover among liquid names: latest settlement on filetable · 2026-09-15 · 10×5
Stock Market Holidays 2026–2027: NYSE & Nasdaq
Upcoming US stock market holidays and early closesseries · 2026-09-15 · 12×6Preview: a 12-point series, ending higher. Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-09-15 · 4×3Preview: a 4-point series, roughly flat. Regular trading sessions over the trailing yearscalar · 2026-09-15 · 1×3252 The closure calendar ahead, at a glancescalar · 2026-09-15 · 1×610
Is the Stock Market Open Today?
This calendar year's closures: already passed (counted from the tape) plus still ahead (from the calendar)table · 2026-09-15 · 2×5 SPY across recent weekends and holiday weekends: Friday's close vs. the reopening printseries · 2026-09-15 · 11×6Preview: a 11-point series, ending lower. Every upcoming NYSE closure and early close on the calendar feed, with a countdownseries · 2026-09-15 · 12×6Preview: a 12-point series, ending higher. Unscheduled closures on the tape: zero regular-session bars on an ordinary weekdayseries · 2026-09-15 · 5×4Preview: a 5-point series, roughly flat. Market status computed at this page's refresh: weekday check, holiday check, and the ET clockscalar · 2026-09-15 · 1×70 The most recent session on the tape: bar count, same-day SPY options prints, and the last half-day observedscalar · 2026-09-15 · 1×6211 Weekdays in the trailing year when stocks traded but no Treasury yield printedtable · 2026-09-15 · 2×2
How to Read the US Equity Trade Tape
Two companies behind one symbol: TWTR on the daily barsseries · 2026-09-15 · 2×5Preview: a 2-point series, ending higher. The tape column on eight symbols, 2023-03-15ranking · 2026-09-15 · 8×3Preview: 8 ranked values, smallest first. Sessions and symbols on the tape, by yearseries · 2026-09-15 · 24×4Preview: a 16-point series, ending higher. Share of prints with a placeholder participant timestamp, one March session per year (IBM and MSFT)ranking · 2026-09-15 · 24×4Preview: 16 ranked values, smallest first. IBM's NYSE closing auction print: seconds after 4:00 p.m. ET, one March session per yearranking · 2026-09-15 · 17×4Preview: 16 ranked values, smallest first. Placeholder share by session, five large names, July to August 2015series · 2026-09-15 · 15×3Preview: a 15-point series, ending lower. The first session with a populated participant timestampscalar · 2026-09-15 · 1×26.41M Correction indicator counts on one session, fifteen large names, 2023-03-15ranking · 2026-09-15 · 5×3Preview: 5 ranked values, smallest first.
Highest Implied Volatility Stocks Right Now
SPY, the same measurement: the market's calm benchmarkscalar · 2026-09-15 · 1×313.2 ATM implied volatility across every actively traded underlying, latest sessionscalar · 2026-09-15 · 1×5969 Highest ATM implied volatility: liquid single names and funds, latest sessiontable · 2026-09-15 · 12×5
Dividend Increases & Cuts This Week
Increases against cuts, by week of declaration (complete weeks only)series · 2026-09-15 · 26×4Preview: a 16-point series, ending lower. Payers across their own share split: the raw change against the split-adjusted changeseries · 2026-09-15 · 9×7Preview: a 9-point series, ending lower. Increases, cuts and the typical raise this calendar year, by company size (bands use today's market value)table · 2026-09-15 · 4×6 Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows)series · 2026-09-15 · 6×8Preview: a 6-point series, ending lower. Dividend cuts declared in the last 90 days, the deepest 14 first (one week is too thin for a table)series · 2026-09-15 · 14×6Preview: a 14-point series, ending higher.
Can You Day Trade an Index Fund? ETFs vs Funds
VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included)series · 2026-09-15 · 25×2Preview: a 16-point series, ending higher. Typical quoted spread on the three largest S&P 500 ETFs, trailing five daysranking · 2026-09-15 · 3×3Preview: 3 ranked values, smallest first.
Biggest Stock Gainers and Losers This Week
Biggest stock losers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-15 · 10×4Preview: 10 ranked values, smallest first. The four major index ETFs this week, for contextranking · 2026-09-15 · 4×2Preview: 4 ranked values, largest first. Biggest stock gainers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-15 · 10×4Preview: 10 ranked values, largest first.
Biggest Stock Movers This Month
The window and the screened universe behind every board on this pagescalar · 2026-09-15 · 1×521 Where every screened company landed: monthly returns by bucketranking · 2026-09-15 · 6×2Preview: 6 ranked values, largest first. Eight household mega-cap names over the same windowranking · 2026-09-15 · 8×2Preview: 8 ranked values, largest first. Biggest stock losers this month (companies trading $1B+ over the window)ranking · 2026-09-15 · 10×3Preview: 10 ranked values, smallest first. The four major index trackers across the same window, rebased to the first openseries · 2026-09-15 · 21×5Preview: a 16-point series, ending lower. Biggest stock gainers this month (companies trading $1B+ over the window)ranking · 2026-09-15 · 10×3Preview: 10 ranked values, largest first.
Biggest Stock Gainers & Losers of 2026
Excluded from the boards: 2026 splits large enough to fake a year-to-date moveseries · 2026-09-15 · 13×5Preview: a 13-point series, ending higher. The screen, stage by stage: how many names survive each filterranking · 2026-09-15 · 5×2Preview: 5 ranked values, largest first. Biggest stock losers of 2026: worst ten year to date among heavily traded namesranking · 2026-09-15 · 10×3Preview: 10 ranked values, smallest first. The four major index ETFs, year to date, over the same measured windowseries · 2026-09-15 · 4×4Preview: a 4-point series, ending lower. Biggest stock gainers of 2026: top ten year to date among heavily traded namesranking · 2026-09-15 · 10×3Preview: 10 ranked values, largest first. Year-to-date breadth: how the screened universe is distributed across return bucketsranking · 2026-09-15 · 8×3Preview: 8 ranked values, smallest first.
Stocks at 52-Week Highs and Lows
How far the whole screen sits below its 52-week highranking · 2026-09-15 · 6×4Preview: 6 ranked values, smallest first. Stocks at 52-week lows, ordered by year-to-date returnranking · 2026-09-15 · 12×3Preview: 12 ranked values, smallest first. Where five broad-market ETFs sit inside their own 52-week rangeranking · 2026-09-15 · 5×4Preview: 5 ranked values, smallest first. Stocks at 52-week highs, ordered by year-to-date returnranking · 2026-09-15 · 12×3Preview: 12 ranked values, smallest first. New 52-week highs against new lows, daily, over the past six weeksseries · 2026-09-15 · 30×4Preview: a 16-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-14 · 6×4Preview: 6 ranked values, largest first. Intraday high-to-low range as a share of the open, August 2026ranking · 2026-09-14 · 6×3Preview: 6 ranked values, largest first. The five widest AAPL sessions of August 2026 for the same $5,000 accountranking · 2026-09-14 · 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-14 · 21×3Preview: a 16-point series, ending lower.
US Stocks 23/5 Trading: The December 2026 Plan
Extended-hours sale conditions defined on the taperanking · 2026-09-14 · 3×3Preview: 3 ranked values, smallest first.
page 1 of 23
Index roots vs ETF roots: contracts traded on July 6, 2026, with exercise style

Index roots vs ETF roots: contracts traded on July 6, 2026, with exercise style

as of ranking 8×3read in context →
Index roots vs ETF roots: contracts traded on July 6, 2026, with exercise style — 8 rows by 3 columns, computed from US exchange, SIP and OPRA data.
productexercise_stylecontracts_mm
SPYAmerican style, share settled12.1
QQQAmerican style, share settled6.88
SPXWEuropean style, cash settled3.65
IWMAmerican style, share settled1.35
SPXEuropean style, cash settled0.19
NDXPEuropean style, cash settled0.08
RUTEuropean style, cash settled0.03
NDXEuropean style, cash settled0
the exact SQL behind every number 
SELECT root AS product,
       transform(root,
                 ['SPX', 'SPXW', 'NDX', 'NDXP', 'RUT', 'SPY', 'QQQ', 'IWM'],
                 ['European style, cash settled', 'European style, cash settled',
                  'European style, cash settled', 'European style, cash settled',
                  'European style, cash settled', 'American style, share settled',
                  'American style, share settled', 'American style, share settled'],
                 'Other') AS exercise_style,
       round(sum(volume) / 1e6, 2) AS contracts_mm
FROM (
    SELECT substring(ticker, 3, length(ticker) - 17) AS root,
           toFloat64(volume) AS volume
    FROM global_markets.options_minute_aggs
    WHERE window_start >= toDateTime('2026-07-06 08:00:00')
      AND window_start < toDateTime('2026-07-07 04:00:00')
      AND toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2026-07-06')
)
WHERE root IN ('SPX', 'SPXW', 'NDX', 'NDXP', 'RUT', 'SPY', 'QQQ', 'IWM')
GROUP BY product, exercise_style
ORDER BY contracts_mm DESC
More from this analysisAmerican vs European Options Explained
July 6, 2026: contracts traded per 15 minutes, S&P 500 index options vs SPY options series 27×3 → SPY: widest open print to close print gaps on monthly expiration Fridays since 2021 ranking 12×4 → Opening prints on settlement morning, May 15, 2026: twelve large US constituents ranking 12×3 → Opening prints against the previous close: settlement Friday vs an ordinary Friday ranking 8×3 → See all 2,249 queries →
$