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

3,293 answered market questions

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

What Is a Short Squeeze? GameStop, Measured
Four January 2021 squeezes: price multiple and short interest before and after (as-traded prices)table · 2026-10-11 · 4×6 GME weekly price range and shares traded, January through mid-February 2021 (as-traded prices)table · 2026-10-11 · 7×5 GME 2021, one row: January low, late-January peak, February trough, March rebound (as-traded prices)scalar · 2026-10-11 · 1×717.05 GME short interest by settlement date, November 2020 through March 2021ranking · 2026-10-11 · 10×3Preview: 10 ranked values, largest first. GME options volume by week: calls vs. puts and total premium, January 2021table · 2026-10-11 · 5×5 Highest days to cover among liquid names: latest settlement on filetable · 2026-10-11 · 10×5 Days to cover across liquid names: every ticker averaging 5M+ shares/day, latest settlement on filescalar · 2026-10-11 · 1×6824
VOO Dividend: Ex-Dividend Dates & Yield
VOO trailing-twelve-month payout per share and the yield it works out toseries · 2026-10-11 · 13×4Preview: a 13-point series, ending lower. Calendar days from each VOO ex-date to its record date and pay dateseries · 2026-10-11 · 24×4Preview: a 16-point series, ending lower. Which month and which week VOO's ex-dividend date has landed inseries · 2026-10-11 · 4×5Preview: a 4-point series, ending lower. VOO declared distributions: ex, record and pay dates with the per-share amountseries · 2026-10-11 · 13×5Preview: a 13-point series, ending higher. VOO distributions per complete calendar year, with the spread between quarterstable · 2026-10-11 · 11×6
Santa Claus Rally: Hit Rate and Returns by Year
The five weakest Santa Claus windows on record, with the calendar year that followed eachtable · 2026-10-11 · 5×5 Santa Claus window vs. the rest of December vs. the whole month, SPY, all years on recordtable · 2026-10-11 · 3×8 SPY volume in each Santa Claus window session as a share of its year's average daily volumeranking · 2026-10-11 · 7×4Preview: 7 ranked values, smallest first. Santa Claus rally window return by year, SPY, with the full calendar December alongsidetable · 2026-10-11 · 23×5 Failed vs. successful Santa Claus windows and the calendar year that followedtable · 2026-10-11 · 2×6
PFE Dividend 2026: Ex-Dates and Payments
PFE indicated dividend yield by month end, 2026table · 2026-10-11 · 9×5 PFE quarterly dividend rate by year, from declared amountstable · 2026-10-11 · 10×6 PFE prior close versus the ex-dividend morning opening printseries · 2026-10-11 · 9×6Preview: a 9-point series, ending lower. PFE dividends declared for 2026: ex-date, record date, pay date and amountseries · 2026-10-11 · 4×7Preview: a 4-point series, roughly flat.
Payout Ratio Over 100%: What It Means
Realty Income: dividend cover on net income, then on net income plus depreciationseries · 2026-10-11 · 8×4Preview: a 8-point series, ending lower. The same payout ratio twice: on earnings, then on free cash flowranking · 2026-10-11 · 9×3Preview: 9 ranked values, largest first. 3M: quarterly net income against dividends paid, mid 2022 to end 2024series · 2026-10-11 · 11×4Preview: a 11-point series, roughly flat. Verizon: earnings, depreciation, operating cash and dividends by quarterseries · 2026-10-11 · 8×6Preview: a 8-point series, ending higher.
Payment in Lieu of Dividends, Explained
PFE short interest by settlement date, Aug 2025 through Jul 2026series · 2026-10-11 · 24×3Preview: a 16-point series, ending higher. Ex-dividend events per month across the whole US calendarseries · 2026-10-11 · 12×4Preview: a 12-point series, roughly flat. The most recent regular dividend for eleven household namestable · 2026-10-11 · 11×5 Reported short interest across the same dividend payersranking · 2026-10-11 · 11×3Preview: 11 ranked values, largest first.
Altria (MO) Dividend Increase History by Year
Altria's quarterly dividend through the Kraft and PMI spin-offs, 2006 to 2009series · 2026-10-11 · 16×3Preview: a 16-point series, ending lower. Every Altria quarterly dividend increase since the 2008 PMI spin-offseries · 2026-10-11 · 21×7Preview: a 16-point series, ending lower. Altria dividend record and payment dates this calendar yearseries · 2026-10-11 · 4×6Preview: a 4-point series, ending higher. Altria free cash flow versus dividends paid, by fiscal yeartable · 2026-10-11 · 6×5 Which month Altria and PMI announce their dividend raisesseries · 2026-10-11 · 2×5Preview: a 2-point series, ending higher.
Locked and Crossed Markets, Explained With Data
Whole-tape census: locked, crossed, and one-sided records across every NBBO update of the sessionscalar · 2026-10-11 · 1×7410 The receipts: locked vs crossed totals, and the rate by session stretch (premarket, open, noon, close, ET)scalar · 2026-10-11 · 1×10352.1 The census by name: eight liquid tickers and two thin small caps, recent completed sessionstable · 2026-10-11 · 10×7 Locked-or-crossed records per 10,000 updates by 30-minute ET bucket, checked set, extended hours includedseries · 2026-10-11 · 32×3Preview: a 16-point series, ending lower.
How to Read the COT Report: Columns Explained
SPY move from Tuesday close to Friday close, the age of a COT snapshotranking · 2026-10-11 · 11×4Preview: 11 ranked values, largest first. Latest days to cover, and where it sits in five years of the same name's historytable · 2026-10-11 · 6×5 AAPL days to cover and its rank inside the three-year windowseries · 2026-10-11 · 72×4Preview: a 16-point series, roughly flat. Net calls minus puts on AAPL, raw contracts and as a share of volumeseries · 2026-10-11 · 30×6Preview: a 16-point series, ending lower.
Highest Days to Cover Stocks Right Now
The receipts: file size, liquid names, thin names, and the liquid medianscalar · 2026-10-11 · 1×522,579 Highest days to cover among liquid names: 5M average-volume floorranking · 2026-10-11 · 12×4Preview: 12 ranked values, largest first. Today's liquid top-3 days-to-cover names, traced back eight settlementsseries · 2026-10-11 · 8×4Preview: a 8-point series, ending lower. Highest days to cover, latest settlement: 500k average-volume floortable · 2026-10-11 · 12×5 Days to cover by liquidity band: median stays low, the extremes live in thin namesranking · 2026-10-11 · 5×4Preview: 5 ranked values, smallest first.
Hard-to-Borrow Lists and Borrow Fees
Every KO ex-dividend date a short position would have paid through, 2023 to mid-2026series · 2026-10-11 · 14×3Preview: a 14-point series, ending higher. Daily short volume as a share of total AAPL volume, May to July 2026series · 2026-10-11 · 53×3Preview: a 16-point series, roughly flat. How many liquid stocks sit in each days-to-cover bucketranking · 2026-10-11 · 5×2Preview: 5 ranked values, largest first. Days to cover across six household names, latest settlement dateranking · 2026-10-11 · 6×3Preview: 6 ranked values, largest first.
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-10-11 · 23×2Preview: a 16-point series, ending higher. Typical quoted spread on the three largest S&P 500 ETFs, trailing five daysranking · 2026-10-11 · 3×3Preview: 3 ranked values, smallest first.
Can You Sell on the Ex-Dividend Date?
From ex-dividend date to record date to the cash, in calendar daystable · 2026-10-11 · 8×6 Share of 2024 US dividends whose record date fell on the ex-dividend dateseries · 2026-10-11 · 12×3Preview: a 12-point series, ending higher. Shares held short against average daily volume, large dividend payersranking · 2026-10-11 · 8×4Preview: 8 ranked values, largest first. Ex-date opening gap by dividend size, US quarterly dividends 2024 to 2025ranking · 2026-10-11 · 5×4Preview: 5 ranked values, largest first.
Can German Retail Investors Short Stocks?
Aggregate short interest with no holder named: days to cover, household US namesranking · 2026-10-11 · 8×4Preview: 8 ranked values, largest first. What a put costs to hold: premium and daily decay by time to expiry (AAPL, Q3 2025)ranking · 2026-10-11 · 5×3Preview: 5 ranked values, smallest first. A minus one fund against its index, month by month (SPY vs SH, 2025)series · 2026-10-11 · 12×4Preview: a 12-point series, ending lower. Barrier touches: intraday high versus closing print, NVDA, Q3 2025table · 2026-10-11 · 10×5
Why the Greeks Don't Add Up to Your P&L
Root sum of squared daily moves versus the net move, SPY by monthseries · 2026-10-09 · 12×4Preview: a 12-point series, roughly flat.
What Limit Price Should I Set on a Stock?
How many cents separate MSFT's bid and ask, by share of quotesranking · 2026-10-09 · 8×3Preview: 8 ranked values, smallest first. AAPL quoted spread by time of day, premarket through late sessionseries · 2026-10-09 · 26×3Preview: a 16-point series, ending lower. Average quoted spread across five household names, mid-sessionranking · 2026-10-09 · 5×4Preview: 5 ranked values, largest first. Share of prints under 100 shares, same mid-session windowranking · 2026-10-09 · 5×4Preview: 5 ranked values, largest first.
The Rule of 72 (and Where It Breaks)
An 8% average return at rising volatility: compound rate and doubling timeranking · 2026-10-09 · 8×3Preview: 8 ranked values, largest first. Rule of 72 against the exact doubling time, by annual returnranking · 2026-10-09 · 11×4Preview: 11 ranked values, largest first. Average return against compound return, five price histories, 2015 through 2024ranking · 2026-10-09 · 5×4Preview: 5 ranked values, smallest first. Ten-year US inflation rate and the time to halve a dollar's purchasing powertable · 2026-10-09 · 26×4 Years to double: the Rule of 72 on the average against the compounded pathtable · 2026-10-09 · 5×5
Split-Adjusting Your Dividend History
Apple trailing dividend yield, as-paid sum against split-aware sumseries · 2026-10-09 · 15×3Preview: a 15-point series, ending lower. Dividend records restated by splits, six widely held payersranking · 2026-10-09 · 6×4Preview: 6 ranked values, smallest first. Apple daily closes around the 2020 split, each against the prior sessionseries · 2026-10-09 · 15×3Preview: a 15-point series, ending higher. Every Apple split on record through 2020, with its cumulative factorseries · 2026-10-09 · 3×4Preview: a 3-point series, ending lower. Apple dividends as paid, and restated onto today's share countseries · 2026-10-09 · 6×5Preview: a 6-point series, ending higher.
REST Polling vs WebSockets for Market Data
NVDA quote updates per second, grouped by how busy the second wasranking · 2026-10-09 · 5×3Preview: 5 ranked values, smallest first. AAPL opening minute: quote updates and distinct prices, second by secondtable · 2026-10-09 · 60×4 Quote messages per second, four names, 10:30 to 11:00 a.m. ETranking · 2026-10-09 · 4×3Preview: 4 ranked values, largest first. AAPL trades per second, fifteen minute buckets through the sessionseries · 2026-10-09 · 26×2Preview: a 16-point series, ending lower.
Options Approval Denied? What to Do Next
Large single-session SPY declines by calendar yearranking · 2026-10-09 · 11×3Preview: 11 ranked values, largest first.
Local Volatility vs Implied Volatility
SPY at-the-money and downside implied volatility across expiry bands, September 2026ranking · 2026-10-09 · 5×4Preview: 5 ranked values, smallest first. SPY implied volatility by strike distance from spot, 20 to 45 day expiries, September 2026ranking · 2026-10-09 · 7×3Preview: 7 ranked values, largest first. SPY at-the-money implied volatility and downside skew spread, week by week, 2026series · 2026-10-09 · 39×4Preview: a 16-point series, ending lower. Forward volatility embedded in the SPY monthly expiry curve, last week of September 2026series · 2026-10-09 · 5×4Preview: a 5-point series, ending higher.
How to Read a 10-K Annual Report Filing
Which 10-K sections get captured, and how long they runranking · 2026-10-09 · 3×4Preview: 3 ranked values, largest first. The biggest risk-factor categories, by number of companies disclosingranking · 2026-10-09 · 7×2Preview: 7 ranked values, largest first. The 10-K family on EDGAR: annual filings, amendments and late noticesranking · 2026-10-09 · 4×2Preview: 4 ranked values, largest first. When annual filings land: 10-K filings by calendar month, three yearsseries · 2026-10-09 · 12×4Preview: a 12-point series, roughly flat. One company's 10-K text, fiscal year by fiscal year (AAPL)ranking · 2026-10-09 · 3×3Preview: 3 ranked values, largest first.
Futures Price Limits and Price Banding
Typical and tail one-minute moves in the S&P 500 ETF, by half hour of the sessionseries · 2026-10-09 · 13×3Preview: a 13-point series, ending lower. Between-session gaps on four equity index ETFs, 2015 to datetable · 2026-10-09 · 4×5 Share of S&P 500 ETF sessions opening 1% or 2% from the prior close, by yeartable · 2026-10-09 · 12×5 S&P 500 ETF path on August 5, 2024, measured against the prior closeseries · 2026-10-09 · 39×3Preview: a 16-point series, ending lower.
Trailing Stop vs Trailing Stop-Limit Orders
When each trail width would first have been reached, same position, January to June 2022series · 2026-10-08 · 5×4Preview: a 5-point series, ending lower. A 10% trail ratcheting under AAPL's high-water close, January to mid-March 2022series · 2026-10-08 · 50×5Preview: a 16-point series, roughly flat. How far SPY's open sat from the prior close, every session since 2006ranking · 2026-10-08 · 6×3Preview: 6 ranked values, smallest first. The ten deepest gap-down opens in SPY since 2006, and where those sessions tradedranking · 2026-10-08 · 10×4Preview: 10 ranked values, largest first.
Stock Order Types Explained: The Core Four
AAPL average quoted spread by ET clock time, Sep 16 2026series · 2026-10-08 · 64×3Preview: a 16-point series, ending lower. Average quoted spread across six household names, one mid-morning hourranking · 2026-10-08 · 6×3Preview: 6 ranked values, smallest first.
Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling window

Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling window

most recentas of scalar 1×2read in context →
win start et min
570
win end et min
570
the exact SQL behind every number
SELECT toHour(toTimeZone(toDateTime(today() - 14) + toIntervalMinute(810), 'America/New_York')) * 60
         + toMinute(toTimeZone(toDateTime(today() - 14) + toIntervalMinute(810), 'America/New_York')) AS win_start_et_min,
       toHour(toTimeZone(toDateTime(today() - 4) + toIntervalMinute(810), 'America/New_York')) * 60
         + toMinute(toTimeZone(toDateTime(today() - 4) + toIntervalMinute(810), 'America/New_York')) AS win_end_et_min
$