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

Covered Calls on AAPL: A Worked Example
AAPL dividend versus the time value left in the nearest in-the-money call, the day before each ex datetable · 2026-10-17 · 20×7 Outcomes of the repeated monthly AAPL write, by delta targettable · 2026-10-17 · 6×6 One AAPL call per delta target, about 30 days out, with the covered call math appliedtable · 2026-10-17 · 6×10
Covered Call Closed-End Funds vs ETFs
Short-term Treasury yields by month, the reference for fund borrowing costsseries · 2026-10-17 · 36×3Preview: a 16-point series, ending lower. Cash distributions over the trailing year, by declared scheduleranking · 2026-10-17 · 5×2Preview: 5 ranked values, largest first. Monthly cost of a near-the-money call, as a percent of share priceseries · 2026-10-17 · 18×3Preview: a 16-point series, ending lower.
COST Dividend: Yield, History & Ex-Dates
COST dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.47 COST recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. COST total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
COP Dividend: Yield, History & Ex-Dates
COP dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.84 COP recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. COP total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
The Real Risk of One Stock
Annualized volatility: the S&P 500 index versus six single stocks (last ~250 sessions)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first. Same $100 invested: one single stock versus the S&P 500 index, indexed to 100series · 2026-10-17 · 14×3Preview: a 14-point series, ending lower. Maximum drawdown: deepest peak-to-trough drop over the last yearranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
COIN Implied Volatility: IV Now & Its History
COIN ATM implied volatility by time to expiration: latest sessionranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. COIN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-17 · 52×4Preview: a 16-point series, ending lower. COIN at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-17 · 64×2Preview: a 16-point series, ending lower.
CMCSA Dividend: Yield, History & Ex-Dates
CMCSA dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.33 CMCSA recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. CMCSA total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
CL Dividend: Yield, History & Ex-Dates
CL dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.53 CL recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. CL total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
China's Dragon-Tiger List, Explained
How many names a volatility cutoff keeps as the cutoff movesranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. Share of reported volume marked short, with no trader namedranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. How fast US insider transactions reach the public file, by monthseries · 2026-10-17 · 13×4Preview: a 13-point series, ending lower.
CAT Dividend: Yield, History & Ex-Dates
CAT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.63 CAT recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. CAT total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Cash Settled vs Physical Delivery Options
SPY: widest open print to close print gaps on monthly expiration Fridays since 2021ranking · 2026-10-17 · 12×4Preview: 12 ranked values, smallest first. How close SPY closes to a whole dollar strike, expiration Fridays vs every other sessionranking · 2026-10-17 · 4×4Preview: 4 ranked values, smallest first. Dividend owed per assigned contract, recent ex dividend datesseries · 2026-10-17 · 6×3Preview: a 6-point series, ending lower. What 100 shares per contract is worth, six household namesseries · 2026-10-17 · 6×3Preview: a 6-point series, ending lower.
Does Canada Have After-Hours Trading?
Upcoming US market closures and early closesseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. Where US after-hours volume lands in interlisted Canadian names, 15-minute bucketsseries · 2026-10-17 · 16×4Preview: a 16-point series, ending higher. Share of each name's US tape printed outside the regular sessionranking · 2026-10-17 · 13×3Preview: 13 ranked values, largest first. Interlisted US volume on five days the Toronto market sat closedseries · 2026-10-17 · 5×3Preview: a 5-point series, roughly flat.
Can You Use a Limit Order on a Mutual Fund?
One index ETF's price through a single session, in half-hour ET bucketsseries · 2026-10-17 · 13×3Preview: a 13-point series, ending lower. How far one index ETF travelled inside each recent sessionseries · 2026-10-17 · 30×4Preview: a 16-point series, roughly flat. Upcoming market closures that move a fund order's strike dateseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. Gap between the last regular-session minute and the official closeranking · 2026-10-17 · 6×4Preview: 6 ranked values, largest first.
Can You Opt Out of Share Lending?
Share of reported AAPL volume marked short, by sessionseries · 2026-10-17 · 63×3Preview: a 16-point series, ending lower. Cash per share a substitute payment would have replaced, trailing yearranking · 2026-10-17 · 7×4Preview: 7 ranked values, largest first. How crowded is the short side? Days to cover across the whole reporting universeranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Reported short interest and days to cover across seven large capsranking · 2026-10-17 · 7×4Preview: 7 ranked values, smallest first.
Can You Cancel a Mutual Fund Order? 4 pm Cutoff
Upcoming sessions where the standard 4 p.m. cutoff does not applyseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher.
Can You Buy a Put Without Owning Stock?
Days to cover on the latest reported short interestranking · 2026-10-17 · 5×2Preview: 5 ranked values, largest first. One put contract versus the 100 shares it coverstable · 2026-10-17 · 5×5 AAPL put ladder: debit, delta and breakeven by strikeranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first. Overnight gaps across a year of daily barsranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first.
Can a Death Cross Be Bullish? The SPY Record
The window and the cross counts behind the textscalar · 2026-10-17 · 1×115,813 Each SPY death cross and the golden cross that ended itranking · 2026-10-17 · 11×4Preview: 11 ranked values, largest first. SPY close versus its 50-day and 200-day averages, February to July 2020series · 2026-10-17 · 126×4Preview: a 16-point series, ending higher. Forward record after a SPY death cross, by horizontable · 2026-10-17 · 4×9 Every SPY death cross in the daily data, with forward returnstable · 2026-10-17 · 11×6 The 2020 peak, low, death cross and golden cross, dated from the same barsscalar · 2026-10-17 · 1×16338.34
C Dividend: Yield, History & Ex-Dates
C dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.67 C recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. C total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Buying Before or After a Stock Split
Forward and reverse splits by year, US listed companiesranking · 2026-10-17 · 10×3Preview: 10 ranked values, smallest first. Recent forward splits at large US companies, by effective sessionranking · 2026-10-17 · 12×4Preview: 12 ranked values, smallest first. Most-used forward split multipliers, last ten yearsranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. AAPL across its 2020 four for one split: split-adjusted closes and volumeseries · 2026-10-17 · 10×4Preview: a 10-point series, roughly flat.
Bracket Orders and OCO Orders Explained
Share of SPY sessions reaching a given distance from the open (Aug 2023 to Jul 2026)ranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. AAPL's ten largest overnight gaps down, Jan 2023 to Jun 2026ranking · 2026-10-17 · 10×2Preview: 10 ranked values, smallest first. Typical daily range and open-to-close move, trailing yearranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. SPY minute-bar movement and volume by ET clock timeseries · 2026-10-17 · 32×3Preview: a 16-point series, roughly flat.
BMY Dividend: Yield, History & Ex-Dates
BMY dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.63 BMY recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. BMY total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
BLK Dividend: Yield, History & Ex-Dates
BLK dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×75.73 BLK recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. BLK total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 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-10-17 · 10×4Preview: 10 ranked values, smallest first. The four major index ETFs this week, for contextranking · 2026-10-17 · 4×2Preview: 4 ranked values, largest first. Biggest stock gainers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-10-17 · 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-10-17 · 1×522 Where every screened company landed: monthly returns by bucketranking · 2026-10-17 · 6×2Preview: 6 ranked values, largest first. Eight household mega-cap names over the same windowranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first. Biggest stock losers this month (companies trading $1B+ over the window)ranking · 2026-10-17 · 10×3Preview: 10 ranked values, smallest first. The four major index trackers across the same window, rebased to the first openseries · 2026-10-17 · 22×5Preview: a 16-point series, ending lower. Biggest stock gainers this month (companies trading $1B+ over the window)ranking · 2026-10-17 · 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-10-17 · 15×5Preview: a 15-point series, ending higher. The screen, stage by stage: how many names survive each filterranking · 2026-10-17 · 5×2Preview: 5 ranked values, largest first. Biggest stock losers of 2026: worst ten year to date among heavily traded namesranking · 2026-10-17 · 10×3Preview: 10 ranked values, smallest first. The four major index ETFs, year to date, over the same measured windowseries · 2026-10-17 · 4×4Preview: a 4-point series, ending lower. Biggest stock gainers of 2026: top ten year to date among heavily traded namesranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. Year-to-date breadth: how the screened universe is distributed across return bucketsranking · 2026-10-17 · 8×3Preview: 8 ranked values, smallest first.
Best Time of Day to Sell a Mutual Fund
Overnight gap versus the session that follows, complete yearsranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. How far SPY trades from its own open and close, by time of dayseries · 2026-10-17 · 13×3Preview: a 13-point series, ending higher. Average one-day move across six widely held funds, since 2021ranking · 2026-10-17 · 6×2Preview: 6 ranked values, smallest first. How big a one-day move usually is, sessions since 2016ranking · 2026-10-17 · 5×2Preview: 5 ranked values, largest first.
Best Stocks for Day Trading Options (Ranked)
Daily options contract volume, SPY vs QQQ vs IWM vs NVDA, last 20 sessionsseries · 2026-10-17 · 20×6Preview: a 16-point series, ending higher. At-the-money spread as a percent of premium, calls expiring next day, Dec 19 2024, 10:00 to 10:30 ETranking · 2026-10-17 · 5×4Preview: 5 ranked values, smallest first. Stock and ETF underlyings ranked by average daily options contract volume, last 20 sessionsranking · 2026-10-17 · 15×4Preview: 15 ranked values, largest first. Share of all options contract volume by liquidity tier, last 20 sessionsranking · 2026-10-17 · 4×3Preview: 4 ranked values, smallest first.
BAC Dividend: Yield, History & Ex-Dates
BAC dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.32 BAC recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. BAC total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 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
$