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

Stock Split Calendar From a Free SQL API
The stock split calendar: recent and scheduledtable · 2026-10-17 · 24×5
Stock Splits and the Dow Divisor, Explained
Price weight vs cap weight across a stand-in basketranking · 2026-10-17 · 12×4Preview: 12 ranked values, largest first. Forward and reverse splits executed per yearranking · 2026-10-17 · 11×3Preview: 11 ranked values, largest first. Splits of 4-for-1 or larger since 2020, well-known namesranking · 2026-10-17 · 17×4Preview: 16 ranked values, largest first.
Cost Basis After a Stock Split, Step by Step
Forward and reverse splits per calendar yearranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first. The most common split terms of the past five yearsranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. One hypothetical 100-share lot through every AAPL splitseries · 2026-10-17 · 3×5Preview: a 3-point series, ending lower. Every KO dividend of the past four years, one new lot each if reinvestedseries · 2026-10-17 · 16×3Preview: a 16-point series, ending higher.
Stock Split Candidates: Who Might Split Next?
Split-shaped but stubborn: large caps above $500 with no forward split on recordtable · 2026-10-17 · 12×5 Large-cap forward splits since 2020: the close the session before, and the price the ratio implied aftertable · 2026-10-17 · 16×6 Stock split candidates: large caps above $500 a share, ranked by pricetable · 2026-10-17 · 15×8 Apple, monthly highest and lowest close, 2014 through 2020, restated to the share basis of each dayseries · 2026-10-17 · 84×4Preview: a 16-point series, ending lower. Apple forward splits: the close before each one and the price it landed attable · 2026-10-17 · 3×5
Stock Market Hours: Open 9:30, Close 4:00 ET
Upcoming US stock market holidays and early closes, from the exchange calendarseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. Trading sessions over the trailing year, counted from the SPY tapescalar · 2026-10-17 · 1×7253 A full trading day on the SPY tape, split by session window (recent full-length session)scalar · 2026-10-17 · 1×15390 Single-name vs. ETF options at the 4:00 p.m. bell: AAPL and SPY options trades around the close (same session)series · 2026-10-17 · 2×6Preview: a 2-point series, ending higher. The most recent early-close session on the SPY tape, split by session windowscalar · 2026-10-17 · 1×13210 SPY volume by half hour on the early-close session, premarket through the shortened after-hours (ET clock)table · 2026-10-17 · 26×2 SPY volume by half hour, premarket through after-hours (same session, ET clock)table · 2026-10-17 · 32×2
SPY Implied Volatility: IV Now & Its History
SPY ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first. SPY vs QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×3Preview: a 16-point series, ending lower. SPY at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
SPY ETF Price in Korean Won: KRW per Share
SPY closing price in US dollars, month by monthseries · 2026-10-17 · 14×3Preview: a 14-point series, ending higher. When the US session lands on the Korean clock: June against January 2026ranking · 2026-10-17 · 16×3Preview: 16 ranked values, largest first. One share of SPY in Korean won, across input exchange ratesranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first. What a broker's FX spread adds to the won cost of one shareranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. A won budget against whole shares and fractional sharesranking · 2026-10-17 · 5×4Preview: 5 ranked values, smallest first.
SPY Dividend Yield: Why It Trails the Index
Every SPY distribution over the last three years, against the share priceseries · 2026-10-17 · 12×5Preview: a 12-point series, ending lower. Days from ex-dividend date to pay date, last three yearsranking · 2026-10-17 · 3×4Preview: 3 ranked values, largest first. Trailing 12-month dividend yield: SPY against two open-end S&P 500 ETFsranking · 2026-10-17 · 3×3Preview: 3 ranked values, largest first. SPY by calendar year: price change against dividends collectedranking · 2026-10-17 · 7×3Preview: 7 ranked values, smallest first.
SPX vs SPY Options: Which One to Trade
SPY option volume by days to expiry, trailing six weeksranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Time value left in deep in-the-money SPY calls, against the dividend at stakeranking · 2026-10-17 · 15×4Preview: 15 ranked values, smallest first. How close SPY closes to the nearest whole-dollar strike on monthly expirationsseries · 2026-10-17 · 13×4Preview: a 13-point series, roughly flat. What one contract controls: SPX, SPY and XSPranking · 2026-10-17 · 3×4Preview: 3 ranked values, largest first.
SPX Options vs ES Futures Options: Which to Use
Daily S&P 500 moves by month, measured on SPYseries · 2026-10-17 · 13×6Preview: a 13-point series, ending lower. Share of SPY volume by hour of the day (ET), trailing monthranking · 2026-10-17 · 16×2Preview: 16 ranked values, largest first.
SPLG Is Now SPYM: What Changed for Holders
Both symbols on the daily tape: where one span ends and the next beginstable · 2026-10-17 · 2×5 Daily bars printed each month under each symbolseries · 2026-10-17 · 19×3Preview: a 16-point series, ending higher. Average daily traded value across the SPDR core familyranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. Listed option contracts with volume, by underlying symbol and monthseries · 2026-10-17 · 15×3Preview: a 15-point series, ending higher. The last sessions as SPLG and the first as SPYM, close by closeseries · 2026-10-17 · 20×5Preview: a 16-point series, roughly flat. Quarterly distributions across the symbol changeseries · 2026-10-17 · 11×4Preview: a 11-point series, ending higher.
SPGI Dividend: Yield, History & Ex-Dates
SPGI dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.97 SPGI recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. SPGI total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
SPCX: SpaceX Stock Price Decline From Peak
SPY vs SPCX open-to-close, regular hours, trailing three weeksseries · 2026-10-17 · 14×4Preview: a 14-point series, ending higher. Stock quote spread and depth by session: the four weeks from listing and the trailing threeseries · 2026-10-17 · 33×5Preview: a 16-point series, ending lower. The arc on one row: issue price, first print, June peak, and the latest closescalar · 2026-10-17 · 1×18150 Options quote spread and size at the touch, the sessions on file in the past week and a halfseries · 2026-10-17 · 5×6Preview: a 5-point series, ending higher. Put/call volume ratio by session, trailing three weeksseries · 2026-10-17 · 15×5Preview: a 15-point series, ending higher. News-feed attention from listing day to the latest reading: counts, concentration, and the trailing weekscalar · 2026-10-17 · 1×14808 Latest complete session, half-hour path: closes, lows, and volumeseries · 2026-10-17 · 13×4Preview: a 13-point series, ending lower. Latest session on file: the busiest SPCX option contracts by volumetable · 2026-10-17 · 10×5 Sessions from listing to the first close below the first print: SPCX vs four recent IPOstable · 2026-10-17 · 5×11 Every SPCX filing in the EDGAR index since the June 12 listing, on one rowscalar · 2026-10-17 · 1×1123 Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listingseries · 2026-10-17 · 87×7Preview: a 16-point series, ending lower.
SpaceX Lockup Expiration Date: How to Find It
Every year the SPCX symbol printed a regular sessionseries · 2026-10-17 · 7×4Preview: a 7-point series, ending higher. SPY volume on monthly expiration Fridays against the month's other sessionsseries · 2026-10-17 · 11×3Preview: a 11-point series, ending lower. SPCX regular sessions since June 2026: closing price and share volumeseries · 2026-10-17 · 88×4Preview: a 16-point series, ending lower. Calendar days against regular trading sessions since the SPCX debutseries · 2026-10-17 · 19×3Preview: a 16-point series, ending higher. Where standard lockup conventions land, counted from the first SPCX sessionseries · 2026-10-17 · 4×5Preview: a 4-point series, ending higher.
S&P 500 Dividend Yield: How It's Measured
Trailing twelve month distribution yields: broad index, equal weight, dividend screens, sector fundstable · 2026-10-17 · 9×6 SPY distributions per share and price, both rebased to 100 at 2015ranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first. Tracker distribution yield vs the 10 year Treasury, calendar year ends 2015-2025table · 2026-10-17 · 11×5 Cap weighted vs equal weighted dividend yield, by company sizetable · 2026-10-17 · 5×6
SO Dividend: Yield, History & Ex-Dates
SO dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.76 SO recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. SO total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Short Squeeze Candidates This Week
Squeeze-shaped mechanics: crowded shorts among liquid names, with a rising priceranking · 2026-10-17 · 12×4Preview: 12 ranked values, largest first. The screened names ranked by short interest against shares outstanding (not float)table · 2026-10-17 · 10×5 Every past screened name, by what it did over the next 30 daysranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. From the whole settlement file down to the screened list, one rule at a timeranking · 2026-10-17 · 4×2Preview: 4 ranked values, largest first. Every input behind this screen, and how many days old it isseries · 2026-10-17 · 3×3Preview: a 3-point series, ending lower. Liquid names at 5+ and 10+ days to cover, settlement by settlementseries · 2026-10-17 · 12×4Preview: a 12-point series, ending higher.
Short Interest vs Short Volume: The Difference
Data points per dataset: AAPL, last 60 daysranking · 2026-10-17 · 2×2Preview: 2 ranked values, smallest first. Highest days to cover, latest settlement date (min 1M shares/day traded)ranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. AAPL daily short volume ratio (last ~60 days)series · 2026-10-17 · 32×2Preview: a 16-point series, ending higher. AAPL short interest vs. average daily volume, bi-monthly (last 2 years)series · 2026-10-17 · 47×3Preview: a 16-point series, ending higher. AAPL days to cover at each settlement date (last 2 years)series · 2026-10-17 · 47×3Preview: a 16-point series, roughly flat.
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-17 · 16×6Preview: a 16-point series, roughly flat. SEBI's close-out formula applied to a US tape (AAPL, trailing three weeks, illustrative)series · 2026-10-17 · 14×4Preview: a 14-point series, ending higher.
SEC 30-Day Yield vs Distribution Yield
Trailing twelve-month yield and indicated yield, same funds, same dayranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first. One bond fund, two distribution yields, month by monthseries · 2026-10-17 · 38×4Preview: a 16-point series, ending higher. The market rate backdrop: 3-month and 10-year Treasury yieldsseries · 2026-10-17 · 54×4Preview: a 16-point series, ending higher. Two years of regular distributions: how many, and how variableranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first.
SCHD vs VOO: Why the Dividend Yields Differ
SCHD and VOO annualized dividend yield: twelve month-ends through July 2026series · 2026-10-17 · 12×5Preview: a 12-point series, ending lower. Quarterly distributions per share: SCHD and VOO, 2025 Q1 through 2026 Q2ranking · 2026-10-17 · 6×3Preview: 6 ranked values, smallest first. Latest dividend yield: index heavyweights beside dividend-screen staplesranking · 2026-10-17 · 12×4Preview: 12 ranked values, largest first. Trailing twelve-month distribution yield: dividend funds beside the S&P 500 trackertable · 2026-10-17 · 7×5
SBUX Dividend: Yield, History & Ex-Dates
SBUX dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.63 SBUX recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. SBUX total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Rule 144 and Selling Restricted Stock
Recent US listings and their six-month Rule 144 marktable · 2026-10-17 · 15×5 Reported insider open-market sales by size, trailing yearranking · 2026-10-17 · 5×2Preview: 5 ranked values, largest first. The two Rule 144 volume tests, in millions of sharestable · 2026-10-17 · 6×5 Weekly share turnover across US companies, four-week averageranking · 2026-10-17 · 5×2Preview: 5 ranked values, smallest first.
RTX Dividend: Yield, History & Ex-Dates
RTX dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.73 RTX recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower.
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
$