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

2,170 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-08-26 · 8×2Preview: 8 ranked values, largest first. The eleven S&P 500 sectors over the past weekranking · 2026-08-26 · 11×2Preview: 11 ranked values, largest first. Biggest stock losers over the past weekranking · 2026-08-26 · 7×3Preview: 7 ranked values, smallest first. The major index ETFs over the past weekranking · 2026-08-26 · 4×4Preview: 4 ranked values, largest first. Biggest stock gainers over the past weekranking · 2026-08-26 · 7×3Preview: 7 ranked values, largest first. Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-08-26 · 5×3Preview: a 5-point series, ending higher.
Upcoming Stock Splits Calendar
Upcoming US stock splits: announced, with a future effective datetable · 2026-08-26 · 30×5 Announced upcoming splits by directionranking · 2026-08-26 · 2×2Preview: 2 ranked values, smallest first. Announced stock splits by effective month: forward vs reverseseries · 2026-08-26 · 5×4Preview: a 5-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-08-26 · 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-08-26 · 4×5 Names going ex-dividend, day by day: the next seven days of declared recordsseries · 2026-08-26 · 5×5Preview: a 5-point series, roughly flat. Ex-dividend dates by calendar month: three-year average, quarterly vs monthly payersseries · 2026-08-26 · 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-08-26 · 13×8Preview: a 13-point series, ending higher. Forward-declared ex-dividend records on file: the receipt behind this calendarscalar · 2026-08-26 · 1×54,357 Every mega-cap ex-dividend event of the past six months: price path from the pre-ex closetable · 2026-08-26 · 5×6 Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yieldseries · 2026-08-26 · 12×8Preview: a 12-point series, ending higher.
Unusual Options Activity: Last Session
Market-wide options volume by session, with monthly expirations labelledseries · 2026-08-26 · 25×5Preview: a 16-point series, ending higher. Calls or puts: the board's call and put contract volume on the same sessiontable · 2026-08-26 · 10×5 What follows a heavy options session: next-session absolute move vs. the same names on an ordinary daytable · 2026-08-26 · 5×6 What the session's contracts were made of: options volume by days to expiryranking · 2026-08-26 · 6×4Preview: 6 ranked values, largest first. Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-08-26 · 10×8
Recent Stock Splits (Forward and Reverse)
Forward vs reverse splits executed in the last 45 daysranking · 2026-08-26 · 2×2Preview: 2 ranked values, largest first. Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-08-26 · 15×4Preview: 15 ranked values, largest first. Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-08-26 · 15×4Preview: 15 ranked values, smallest first.
Option Expiration Cycles Explained
Third Friday expirations over the next fourteen months, by underlyings listing themranking · 2026-08-26 · 14×3Preview: 14 ranked values, largest first. Monthly expirations beyond 300 days out, by underlyings listing themranking · 2026-08-26 · 14×2Preview: 14 ranked values, largest first. Listed expiration dates, one broad lineup against a thinner chainranking · 2026-08-26 · 6×4Preview: 6 ranked values, largest first. Every expiration listed on the AAPL chain, with contracts on each dateseries · 2026-08-26 · 23×4Preview: a 16-point series, ending lower.
Most Shorted Stocks Right Now, Measured
The receipts: universe size, filter bite, median crowding, and list churn at the latest printscalar · 2026-08-26 · 1×522,480 Largest short positions by shares: latest settlement, liquid namesranking · 2026-08-26 · 10×4Preview: 10 ranked values, largest first. Crowding leaders vs. their own price: about one month of sessionsseries · 2026-08-26 · 5×5Preview: a 5-point series, ending higher. GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-08-26 · 10×4Preview: a 10-point series, ending lower. Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-08-26 · 8×4Preview: a 8-point series, ending lower. Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-08-26 · 8×4Preview: 8 ranked values, smallest first. Highest days to cover among liquid names: latest settlement on filetable · 2026-08-26 · 10×5
Stock Market Holidays 2026–2027: NYSE & Nasdaq
Upcoming US stock market holidays and early closesseries · 2026-08-26 · 12×6Preview: a 12-point series, ending higher. Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-08-26 · 4×3Preview: a 4-point series, roughly flat. Regular trading sessions over the trailing yearscalar · 2026-08-26 · 1×3252 The closure calendar ahead, at a glancescalar · 2026-08-26 · 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-08-26 · 2×5 SPY across recent weekends and holiday weekends: Friday's close vs. the reopening printseries · 2026-08-26 · 11×6Preview: a 11-point series, ending lower. Every upcoming NYSE closure and early close on the calendar feed, with a countdownseries · 2026-08-26 · 12×6Preview: a 12-point series, ending higher. Unscheduled closures on the tape: zero regular-session bars on an ordinary weekdayseries · 2026-08-26 · 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-08-26 · 1×70 The most recent session on the tape: bar count, same-day SPY options prints, and the last half-day observedscalar · 2026-08-26 · 1×6204 Weekdays in the trailing year when stocks traded but no Treasury yield printedtable · 2026-08-26 · 2×2
Highest Implied Volatility Stocks Right Now
SPY, the same measurement: the market's calm benchmarkscalar · 2026-08-26 · 1×312.3 ATM implied volatility across every actively traded underlying, latest sessionscalar · 2026-08-26 · 1×5947 Highest ATM implied volatility: liquid single names and funds, latest sessiontable · 2026-08-26 · 12×5
Dividend Increases & Cuts This Week
Increases against cuts, by week of declaration (complete weeks only)series · 2026-08-26 · 26×4Preview: a 16-point series, ending lower. Payers across their own share split: the raw change against the split-adjusted changeseries · 2026-08-26 · 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-08-26 · 4×6 Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows)series · 2026-08-26 · 12×8Preview: a 12-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-08-26 · 14×6Preview: a 14-point series, ending higher.
Biggest Stock Gainers and Losers This Week
Biggest stock losers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-08-26 · 10×4Preview: 10 ranked values, smallest first. The four major index ETFs this week, for contextranking · 2026-08-26 · 4×2Preview: 4 ranked values, largest first. Biggest stock gainers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-08-26 · 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-08-26 · 1×520 Where every screened company landed: monthly returns by bucketranking · 2026-08-26 · 6×2Preview: 6 ranked values, smallest first. Eight household mega-cap names over the same windowranking · 2026-08-26 · 8×2Preview: 8 ranked values, largest first. Biggest stock losers this month (companies trading $1B+ over the window)ranking · 2026-08-26 · 10×3Preview: 10 ranked values, smallest first. The four major index trackers across the same window, rebased to the first openseries · 2026-08-26 · 20×5Preview: a 16-point series, ending higher. Biggest stock gainers this month (companies trading $1B+ over the window)ranking · 2026-08-26 · 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-08-26 · 12×5Preview: a 12-point series, ending higher. The screen, stage by stage: how many names survive each filterranking · 2026-08-26 · 5×2Preview: 5 ranked values, largest first. Biggest stock losers of 2026: worst ten year to date among heavily traded namesranking · 2026-08-26 · 10×3Preview: 10 ranked values, smallest first. The four major index ETFs, year to date, over the same measured windowseries · 2026-08-26 · 4×4Preview: a 4-point series, ending lower. Biggest stock gainers of 2026: top ten year to date among heavily traded namesranking · 2026-08-26 · 10×3Preview: 10 ranked values, largest first. Year-to-date breadth: how the screened universe is distributed across return bucketsranking · 2026-08-26 · 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-08-26 · 6×4Preview: 6 ranked values, smallest first. Stocks at 52-week lows, ordered by year-to-date returnranking · 2026-08-26 · 5×3Preview: 5 ranked values, smallest first. Where five broad-market ETFs sit inside their own 52-week rangeranking · 2026-08-26 · 5×4Preview: 5 ranked values, smallest first. Stocks at 52-week highs, ordered by year-to-date returnranking · 2026-08-26 · 12×3Preview: 12 ranked values, smallest first. New 52-week highs against new lows, daily, over the past six weeksseries · 2026-08-26 · 31×4Preview: a 16-point series, ending higher.
Unusual Volume Stocks This Week, Measured
How the whole qualifying universe traded this week, bucketed by relative volumeranking · 2026-08-25 · 7×4Preview: 7 ranked values, smallest first. Persistence check: the eight leaders' daily relative volume across the five sessionstable · 2026-08-25 · 8×5 Highest relative volume this week: trailing 5 sessions vs. the prior 40, for names trading $500M+ in the weekseries · 2026-08-25 · 8×6Preview: a 8-point series, ending higher. The board leader, day by day: daily relative volume and open-to-close change (last 15 sessions)series · 2026-08-25 · 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-08-25 · 6×5Preview: a 6-point series, ending higher.
META Implied Volatility: IV Now & Its History
META ATM implied volatility by time to expiration: latest sessionranking · 2026-08-25 · 4×3Preview: 4 ranked values, smallest first. META vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-25 · 50×4Preview: a 16-point series, ending lower. META at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-25 · 62×2Preview: a 16-point series, ending higher.
How Implied Volatility Is Calculated
Where the Newton step misbehaves: AAPL vega by strike zone, June 30, 2026ranking · 2026-08-25 · 6×3Preview: 6 ranked values, largest first. At the money implied volatility and solver convergence, eight names, June 30, 2026ranking · 2026-08-25 · 8×4Preview: 8 ranked values, largest first. One solve per contract: AAPL implied volatility by strike zone, June 30, 2026ranking · 2026-08-25 · 6×3Preview: 6 ranked values, largest first. One AAPL contract, re-solved every session into its July 17, 2026 expiryseries · 2026-08-25 · 29×3Preview: a 16-point series, ending lower.
Short Squeeze Candidates This Week
Squeeze-shaped mechanics: crowded shorts among liquid names, with a rising priceranking · 2026-08-24 · 12×4Preview: 12 ranked values, largest first. The screened names ranked by short interest against shares outstanding (not float)table · 2026-08-24 · 10×5 Every past screened name, by what it did over the next 30 daysranking · 2026-08-24 · 6×3Preview: 6 ranked values, smallest first. From the whole settlement file down to the screened list, one rule at a timeranking · 2026-08-24 · 4×2Preview: 4 ranked values, largest first. Every input behind this screen, and how many days old it isseries · 2026-08-24 · 3×3Preview: a 3-point series, ending lower. Liquid names at 5+ and 10+ days to cover, settlement by settlementseries · 2026-08-24 · 12×4Preview: a 12-point series, ending higher.
How Earnings Move Option Greeks
The Tesla $400 May call through its Q1 earnings (Apr 8 - May 6 2026)series · 2026-08-24 · 21×5Preview: a 16-point series, roughly flat. Tesla's 8-K filings across Q1 2026 (EDGAR index)table · 2026-08-24 · 4×3 Near-the-money Tesla May-expiry implied volatility around the printseries · 2026-08-24 · 21×3Preview: a 16-point series, ending higher.
AMZN Implied Volatility: IV Now & Its History
AMZN ATM implied volatility by time to expiration: latest sessionranking · 2026-08-24 · 4×3Preview: 4 ranked values, smallest first. AMZN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-08-24 · 50×4Preview: a 16-point series, ending lower. AMZN at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-24 · 62×2Preview: a 16-point series, ending higher.
Apple Stock Split History and Ratios
Apple's yearly price range, split-adjusted, 2012 through the current yearranking · 2026-08-24 · 15×4Preview: 15 ranked values, smallest first.
page 1 of 22
Eleven tickers on February 24, 2022: gap, intraday extremes, close (% vs prior close)

Eleven tickers on February 24, 2022: gap, intraday extremes, close (% vs prior close)

as of table 11×6read in context →
Eleven tickers on February 24, 2022: gap, intraday extremes, close (% vs prior close) — 11 rows by 6 columns, computed from US exchange, SIP and OPRA data.
tickerprior_closegap_pctlow_vs_prior_pcthigh_vs_prior_pctday_change_pct
QQQ329.41-3.2-3.43.53.4
SPY421.97-2.6-2.71.61.5
DIA331.44-2.6-2.60.40.3
XLE67.642.1-3.42.2-0.9
GLD178.282.4-1.72.4-0.6
TLT136.621.8-0.320.2
VIXY20.1711.1-3.811.2-3
LMT389.142.3-0.42.51.7
NOC386.12.514.42.4
RTX92.270.8-3.22.62.1
GD216.250.2-2.21.21.1
the exact SQL behind every number 
SELECT
    ticker,
    round(prior_close, 2) AS prior_close,
    round((rth_open / prior_close - 1) * 100, 1) AS gap_pct,
    round((rth_low / prior_close - 1) * 100, 1) AS low_vs_prior_pct,
    round((rth_high / prior_close - 1) * 100, 1) AS high_vs_prior_pct,
    round((rth_close / prior_close - 1) * 100, 1) AS day_change_pct
FROM (
    SELECT
        ticker,
        argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959 AND toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2022-02-23')) AS prior_close,
        argMinIf(toFloat64(open), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959 AND toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2022-02-24')) AS rth_open,
        minIf(toFloat64(low), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959 AND toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2022-02-24')) AS rth_low,
        maxIf(toFloat64(high), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959 AND toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2022-02-24')) AS rth_high,
        argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959 AND toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2022-02-24')) AS rth_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('QQQ', 'SPY', 'DIA', 'XLE', 'GLD', 'TLT', 'VIXY', 'LMT', 'NOC', 'RTX', 'GD')
      AND window_start >= toDateTime('2022-02-23 00:00:00') AND window_start < toDateTime('2022-02-24 23:59:00')
    GROUP BY ticker
)
ORDER BY indexOf(['QQQ', 'SPY', 'DIA', 'XLE', 'GLD', 'TLT', 'VIXY', 'LMT', 'NOC', 'RTX', 'GD'], ticker)
More from this analysisFeb 24, 2022: War at the Open, Green by Close
QQQ daily closes, February 22 – March 14, 2022 series 15×4 → QQQ by half-hour: February 24, 2022 regular session series 13×4 → 2-year and 10-year Treasury yields, February 18 – March 8, 2022 (%) series 12×3 → QQQ sessions since 2003: intraday low ≤ −3% vs prior close AND close ≥ +1% series 2×4 → See all 2,170 queries →
$