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

ETF Relative Strength and Alpha Attribution
Share of each fund's daily variation explained by SPY, trailing two yearsranking · 2026-10-17 · 9×2Preview: 9 ranked values, largest first.
ES Futures Trading Hours and the Daily Break
Cash-tape sessions by weekday over the trailing windowseries · 2026-10-17 · 5×4Preview: a 5-point series, ending higher. S&P 500 cash-tape volume by Eastern clock hourranking · 2026-10-17 · 16×3Preview: 16 ranked values, largest first. Average quoted spread by Eastern clock hour, Sep 16 2026ranking · 2026-10-17 · 16×3Preview: 16 ranked values, largest first. Average cash-tape volume, minute by minute into the 4:00 p.m. ET closeseries · 2026-10-17 · 31×2Preview: a 16-point series, ending higher.
Equity vs Index Put/Call Ratio: What's High?
The total is a call-volume-weighted blend of the two bucketsranking · 2026-10-17 · 11×4Preview: 11 ranked values, largest first. The same equity ratio, computed with and without ETF optionsseries · 2026-10-17 · 23×4Preview: a 16-point series, roughly flat. Single-stock bucket vs ETF bucket, session by sessionseries · 2026-10-17 · 33×6Preview: a 16-point series, ending higher. Put/call volume ratio by underlying, trailing 60 sessionstable · 2026-10-17 · 12×5
Early Lockup Release: Triggers and Waivers
IPO registration and prospectus filings since 2022ranking · 2026-10-17 · 7×3Preview: 7 ranked values, largest first. Form 8-K disclosures mentioning a lockup, by monthseries · 2026-10-17 · 18×4Preview: a 16-point series, ending higher. How much of a company an IPO actually sellsranking · 2026-10-17 · 6×2Preview: 6 ranked values, smallest first. Days from listing to a company's first lockup 8-Kranking · 2026-10-17 · 3×2Preview: 3 ranked values, smallest first.
DUK Dividend: Yield, History & Ex-Dates
DUK dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.085 DUK recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. DUK total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
How to Download 10-K Filings from EDGAR
Section sizes inside one AAPL annual reportranking · 2026-10-17 · 2×2Preview: 2 ranked values, largest first. 10-K filings by calendar month, complete years since 2021series · 2026-10-17 · 12×3Preview: a 12-point series, roughly flat. Filings on record by form type, trailing yearranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. Ticker to CIK, with the ten-digit padded formtable · 2026-10-17 · 5×5 Companies using the phrase 'artificial intelligence' in their annual reportranking · 2026-10-17 · 6×3Preview: 6 ranked values, smallest first.
Is the US Market Open on Japanese Holidays?
One-minute SPY bars per session, US Thanksgiving week 2025series · 2026-10-17 · 7×3Preview: a 7-point series, roughly flat. US market closures ahead that Tokyo trades throughseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. What the US tape did on 2026 Tokyo market holidaysseries · 2026-10-17 · 13×5Preview: a 13-point series, roughly flat. US sessions through the Golden Week 2026 Tokyo closureseries · 2026-10-17 · 10×4Preview: a 10-point series, ending higher.
Does the PDT Rule Apply to Crypto and Futures?
Regular session, premarket and after-hours share of volumeranking · 2026-10-17 · 4×4Preview: 4 ranked values, largest first. Share of monthly volume by 15-minute ET clock slice, SPY and AAPLseries · 2026-10-17 · 64×3Preview: a 16-point series, roughly flat. Calendar days spanned by each rolling five-session windowseries · 2026-10-17 · 77×3Preview: a 16-point series, roughly flat.
Buy on the Ex-Dividend Date: Do You Get Paid?
Calendar days from ex-dividend date to record date, twenty large payers, by monthseries · 2026-10-17 · 41×5Preview: a 16-point series, ending higher. Ex-date open vs prior close, against the dividend as a share of priceranking · 2026-10-17 · 21×4Preview: 16 ranked values, largest first. Apple's recent dividends: the four dates and where a T+1 purchase settlesseries · 2026-10-17 · 8×12Preview: a 8-point series, roughly flat.
Do Stock Splits Need Shareholder Approval?
Forward and reverse splits taking effect each year since 2016ranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first. Most-used reverse split ratios since 2023ranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. Four megacap forward splits and the ratio each one paid outseries · 2026-10-17 · 4×4Preview: a 4-point series, roughly flat. Forward splits by calendar month of effective date, 2015 to 2025series · 2026-10-17 · 12×3Preview: a 12-point series, ending lower. SEC filings in the five months before each split took effectranking · 2026-10-17 · 4×4Preview: 4 ranked values, smallest first.
Do Mutual Funds Trade on Market Holidays?
Scheduled early closes ahead, with the exchange close timeseries · 2026-10-17 · 2×4Preview: a 2-point series, ending higher. Upcoming US market closures and shortened sessionsseries · 2026-10-17 · 12×4Preview: a 12-point series, ending higher. Short regular sessions on the SPY tape since January 2024ranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. 2026 sessions that reopened more than three calendar days laterseries · 2026-10-17 · 7×3Preview: a 7-point series, roughly flat.
Dividends vs Buybacks: Shareholder Yield
Dividend yield, buyback yield and total shareholder yieldranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. AAPL diluted share count, every reported quarter since 2021series · 2026-10-17 · 20×3Preview: a 16-point series, ending lower. The exact quarters behind each buyback yieldtable · 2026-10-17 · 8×5 Share of net income already committed to the dividendranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first.
Dividend Yield vs Treasury Yield
How many of the 15 payers yield less than the 3-month T-billscalar · 2026-10-17 · 1×415 Dividend yield by ticker vs the 3-month Treasury bill (flat line)ranking · 2026-10-17 · 15×3Preview: 15 ranked values, largest first.
Dividend Yield Traps: How to Spot One
Dividend outcome over the following 12 months by starting yield band (cohort of June 30, 2025)table · 2026-10-17 · 5×7 Payout ratio by yield band: US payers above $1B market cap, latest snapshot on filetable · 2026-10-17 · 5×6 How each yield band got there: median price and dividend change over the prior 12 monthstable · 2026-10-17 · 5×5 Conagra (CAG): month-end price, annualized dividend rate, and yield, 2021-08 to 2026-07series · 2026-10-17 · 60×5Preview: a 16-point series, ending higher.
Dividend Withholding Tax for Non-US Investors
Median dividend yield by band, gross and net of US withholding: US payers over $1Btable · 2026-10-17 · 4×6 Coca-Cola quarterly dividend since 2021: gross, net at 15%, net at 30%series · 2026-10-17 · 23×6Preview: a 16-point series, ending higher. Latest quarterly dividend, gross and net of US withholding: eight large US payerstable · 2026-10-17 · 8×5 Six broad US funds: trailing-year distribution yield, gross and net of withholdingtable · 2026-10-17 · 6×7
Dividend Payout Ratio: How to Calculate It
Payout ratio and dividend yield: familiar large US payers, latest snapshotranking · 2026-10-17 · 8×3Preview: 8 ranked values, largest first. US dividend payers by payout-ratio band: $1B+ market cap, $5+ share priceranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. Coca-Cola (KO): recurring dividends per share by calendar year, 2015-2025ranking · 2026-10-17 · 11×3Preview: 11 ranked values, smallest first.
Dividend Increases Expected This Month
MSFT dividend raise declarations, 2019 to 2025 (pinned)series · 2026-10-17 · 7×6Preview: a 7-point series, ending lower. Companies expected to raise their dividend this month, declared names firstseries · 2026-10-17 · 50×7Preview: a 16-point series, ending higher. When dividend raises get declared: share by calendar month, starting from this monthranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. Declared vs. still expected: this month in each of the last six yearsseries · 2026-10-17 · 6×4Preview: a 6-point series, ending lower.
Dividend Increases & Cuts This Week
Increases against cuts, by week of declaration (complete weeks only)series · 2026-10-17 · 26×4Preview: a 16-point series, roughly flat. Payers across their own share split: the raw change against the split-adjusted changeseries · 2026-10-17 · 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-10-17 · 4×6 Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows)series · 2026-10-17 · 10×8Preview: a 10-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-10-17 · 14×6Preview: a 14-point series, ending higher.
Build a Dividend Income Tracker With SQL
Yield on cost against current yield, per positionranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. Annual dividend income per position, with a running portfolio totalranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. What the sample list paid per calendar year, share counts held fixedranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first. Projected dividend income by month, next twelve monthsseries · 2026-10-17 · 12×4Preview: a 12-point series, roughly flat. Latest declared dividend per share for each sample holdingtable · 2026-10-17 · 6×5
Which Companies Cut Their Dividends?
Dividend cuts at major US companies, ranked by the size of the drop (last 6 years)ranking · 2026-10-17 · 14×4Preview: 14 ranked values, largest first. AT&T's annual dividend per share, before and after its 2022 resetranking · 2026-10-17 · 8×2Preview: 8 ranked values, largest first.
Did Stocks Take 25 Years to Recover From 1929?
SPY cash distributions each year, as a percent of the year's opening share priceranking · 2026-10-17 · 19×2Preview: 16 ranked values, smallest first. Price weight vs market-cap weight across eight large US namesranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. SPY from its October 2007 peak month: price only vs dividends reinvestedtable · 2026-10-17 · 75×4
DE Dividend: Yield, History & Ex-Dates
DE dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.62 DE recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. DE total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
CVX Dividend: Yield, History & Ex-Dates
CVX dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×71.78 CVX recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. CVX total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
CSCO Dividend: Yield, History & Ex-Dates
CSCO dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.42 CSCO recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. CSCO total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Crypto Covered Call ETFs: Yield Explained
Implied volatility on near the money contracts, last four monthsranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first. Monthly near the money implied volatility, two yearsseries · 2026-10-17 · 24×4Preview: a 16-point series, ending lower. Month end close measured against the two year highseries · 2026-10-17 · 24×3Preview: a 16-point series, roughly flat. Count of big up months over the last three yearstable · 2026-10-17 · 3×5 One month call premium as a percentage of the underlying priceranking · 2026-10-17 · 5×3Preview: 5 ranked values, largest first.
CRM Dividend: Yield, History & Ex-Dates
CRM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.44 CRM recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. CRM total dividends paid per year (regular dividends)ranking · 2026-10-17 · 2×2Preview: 2 ranked values, smallest first.
Covered Calls on KO: Premium vs Dividend
Monthly 30 delta call premium versus trailing dividend yieldranking · 2026-10-17 · 7×4Preview: 7 ranked values, smallest first. KO 30 delta monthly call premium, month by monthseries · 2026-10-17 · 12×4Preview: a 12-point series, ending higher. KO call chain: premium split into intrinsic and extrinsic value, by delta bandranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first. Median near-the-money implied volatility, July to September 2026ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first. Extrinsic value in KO's in-the-money calls versus the dividend, in the week before each ex dateseries · 2026-10-17 · 11×5Preview: a 11-point series, ending lower.
Covered Calls on AAPL: A Worked Example
The same 0.30 delta AAPL write, repeated on the first session of every monthseries · 2026-10-17 · 61×7Preview: a 16-point series, ending higher. Implied volatility and premium on 0.25 to 0.35 delta calls, AAPL against comparison namesranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest 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
$