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

Highest IV Rank Stocks Right Now
The top-ranked name's implied volatility by week, with its 52-week high and lowseries · 2026-10-17 · 53×4Preview: a 16-point series, roughly flat. Highest IV rank, screened US underlyings, latest options sessionseries · 2026-10-17 · 15×7Preview: a 15-point series, ending higher. IV rank and IV percentile for twelve widely held tickers, latest sessionseries · 2026-10-17 · 12×7Preview: a 12-point series, roughly flat.
Highest Implied Volatility Stocks Right Now
SPY, the same measurement: the market's calm benchmarkscalar · 2026-10-17 · 1×313.1 ATM implied volatility across every actively traded underlying, latest sessionscalar · 2026-10-17 · 1×5847 Highest ATM implied volatility: liquid single names and funds, latest sessiontable · 2026-10-17 · 12×5
Highest Dividend Yield US Stocks in 2026
Highest dividend yields: US-listed companies over $2B, latest snapshot on filetable · 2026-10-17 · 15×5 How many US companies clear each yield floor, with payout ratio and loss-makersranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. Payout ratio and dividend action by yield band: US payers over $2B, latest snapshottable · 2026-10-17 · 4×6 Walgreens Boots Alliance (WBA): month-end price, quarterly dividend, and yield, 2022-07 to 2024-06series · 2026-10-17 · 24×5Preview: a 16-point series, ending higher.
HD Dividend: Yield, History & Ex-Dates
HD dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×72.33 HD recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. HD total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Has SPY Ever Split? The ETF Split Record
SPY cash distributions on record, by yearranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. Span and size of the split record behind these panelsscalar · 2026-10-17 · 1×427.5 Forward and reverse splits executed each year, US-listed tickersranking · 2026-10-17 · 10×4Preview: 10 ranked values, largest first. Splits executed by household-name stocks since 2014ranking · 2026-10-17 · 11×4Preview: 11 ranked values, smallest first. Split events on record for eight long-lived index ETFsranking · 2026-10-17 · 8×4Preview: 8 ranked values, largest first. Share price of seven index ETFs as a ratio to SPY (trailing six weeks)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, largest first.
GS Dividend: Yield, History & Ex-Dates
GS dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×75 GS recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. GS total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
GOOGL Dividend: Yield, History & Ex-Dates
GOOGL dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.22 GOOGL recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. GOOGL total dividends paid per year (regular dividends)ranking · 2026-10-17 · 2×2Preview: 2 ranked values, smallest first.
Good Faith Violations in Cash Accounts
Every session ahead, and the day a sale made in it settlesseries · 2026-10-17 · 15×4Preview: a 15-point series, ending higher. KO and AAPL closes across the July 2026 holiday week, with settlement datesseries · 2026-10-17 · 9×5Preview: a 9-point series, ending higher. Trailing year: calendar days a sale waited to settleranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first.
Gold Miner Covered Call ETFs: Yield vs Upside
2026 price return, distributions and total return: miners, wrapper and bulliontable · 2026-10-17 · 4×5 Monthly price move, 2026: GDX vs the covered call wrapper GDXYseries · 2026-10-17 · 10×3Preview: a 10-point series, roughly flat. Monthly at-the-money IV: GDX, GDXJ and SPY over the past yearseries · 2026-10-17 · 13×5Preview: a 13-point series, roughly flat. At-the-money implied volatility: gold miners vs bullion vs the S&P 500table · 2026-10-17 · 4×6
GIS Dividend: Yield, History & Ex-Dates
GIS dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.61 GIS recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. GIS total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
GILD Dividend: Yield, History & Ex-Dates
GILD dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.82 GILD recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. GILD total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
GE Dividend: Yield, History & Ex-Dates
GE dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-17 · 1×70.47 GE recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-17 · 10×2Preview: a 10-point series, ending lower. GE total dividends paid per year (regular dividends)ranking · 2026-10-17 · 7×2Preview: 7 ranked values, smallest first.
Futures Block Trades and CME Minimums
Share of AAPL volume reported away from the exchanges, last 60 calendar daysseries · 2026-10-17 · 32×2Preview: a 16-point series, roughly flat.
Fully Paid Securities Lending Explained
Share of reported KO volume marked short, by sessionseries · 2026-10-17 · 68×3Preview: a 16-point series, ending higher. Cash paid per share and payment count, trailing yearranking · 2026-10-17 · 8×3Preview: 8 ranked values, largest first. Days to cover for two large dividend payers, by settlement dateseries · 2026-10-17 · 47×4Preview: a 16-point series, ending lower. Days to cover: household names against the most in-demand liquid borrowsranking · 2026-10-17 · 10×2Preview: 10 ranked values, largest first.
Free Stock Market Data API, No Key Required
Highest large-cap dividend yields, latest sessionranking · 2026-10-17 · 12×3Preview: 12 ranked values, largest first. SPY vs QQQ, normalized return over the last 45 daysseries · 2026-10-17 · 32×3Preview: a 16-point series, ending higher. End-of-day implied-volatility leaders, liquid underlyingsranking · 2026-10-17 · 12×2Preview: 12 ranked values, largest first.
Free Stock Market Data API in Python
Trailing 20-session average volume, four household tickers, millions of sharesseries · 2026-10-17 · 4×4Preview: a 4-point series, ending lower. AAPL daily volume and its trailing 20-session average, millions of sharesseries · 2026-10-17 · 35×3Preview: a 16-point series, ending lower.
Free SQL API for Stock Market Data
SPY implied volatility by days-to-expiry bucket, latest sessionranking · 2026-10-17 · 8×2Preview: 8 ranked values, smallest first. P/E ratios of US companies above $500B market capranking · 2026-10-17 · 12×2Preview: 12 ranked values, smallest first. KO: total cash dividends per share by yearranking · 2026-10-17 · 22×2Preview: 16 ranked values, smallest first.
FINRA Margin Debt Statistics, Explained
Largest month-over-month declines in SPY month-end closesranking · 2026-10-17 · 10×2Preview: 10 ranked values, smallest first. What the market does between the month-end as-of date and a third-week releaseseries · 2026-10-17 · 22×5Preview: a 16-point series, ending lower. Month-end closes that set a new high for the window, by year (SPY)ranking · 2026-10-17 · 21×4Preview: 16 ranked values, largest first. How far SPY travels between month end and the third-week release windowranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first.
Figma Lockup Expiration: FIG on the Tape
Close versus the last pre-release close, five sessions either sideranking · 2026-10-17 · 11×4Preview: 11 ranked values, smallest first. Relative volume around three Figma lockup releases (session 0 = first sellable session)ranking · 2026-10-17 · 11×4Preview: 11 ranked values, smallest first. Every Figma lockup release date: release-day turnover and the sessions afterranking · 2026-10-17 · 5×4Preview: 5 ranked values, largest first. Near-the-money Figma implied volatility around the August 7, 2026 releaseseries · 2026-10-17 · 45×4Preview: a 16-point series, roughly flat. Figma's IPO offering against the shares that changed hands after two releasesranking · 2026-10-17 · 3×2Preview: 3 ranked values, smallest first. Sessions printed per calendar year under this ticker, both listingsranking · 2026-10-17 · 16×4Preview: 16 ranked values, largest first.
Ex-Dividend Dates on the ASX: Rules & Timing
Gap from ex-dividend date to record date, US listed dividends by yearranking · 2026-10-17 · 8×4Preview: 8 ranked values, smallest first. Coca-Cola (KO): the four dividend dates, 2023 to nowseries · 2026-10-17 · 15×4Preview: a 15-point series, ending lower. Wait from record date to payment, by declared dividend cadence (US listed, last two years)ranking · 2026-10-17 · 5×3Preview: 5 ranked values, smallest first.
Ex-Dividend Date: Open Orders and Premarket
KO premarket on its latest ex-dividend morning, both references side by sideseries · 2026-10-17 · 11×4Preview: a 11-point series, ending lower. KO's ex-date opening print, measured against both referencesseries · 2026-10-17 · 13×3Preview: a 13-point series, ending lower. KO: every quarterly ex-dividend adjustment over the trailing three yearsseries · 2026-10-17 · 13×3Preview: a 13-point series, ending lower. Upcoming ex-dividend dates and the size of the open-order reductionranking · 2026-10-17 · 4×4Preview: 4 ranked values, largest first.
What Is an Ex-Dividend Date? How It Works
Payout schedules of recurring US dividend payers (trailing 12 months)ranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. How long after the ex-date the cash arrives (trailing 12 months)ranking · 2026-10-17 · 4×3Preview: 4 ranked values, largest first. Median waits between dividend dates (trailing 12 months, all recurring US dividends)scalar · 2026-10-17 · 1×446,550 Share of US dividends where ex-date = record date, by yearranking · 2026-10-17 · 6×3Preview: 6 ranked values, smallest first. AAPL's last eight dividends: all four dates plus cash per shareseries · 2026-10-17 · 8×5Preview: a 8-point series, ending lower. AAPL's last eight ex-dividend mornings: adjusted reference vs. the actual openseries · 2026-10-17 · 8×6Preview: a 8-point series, ending higher.
Ex-Dividend Calendar from a Free SQL API
Liquid US names going ex-dividend in the next 14 daysranking · 2026-10-17 · 15×4Preview: 15 ranked values, largest first. Declared ex-dividend dates per week, next 12 weeksseries · 2026-10-17 · 12×3Preview: a 12-point series, ending lower. How far ahead dividends were declared, trailing 12 monthsranking · 2026-10-17 · 5×2Preview: 5 ranked values, smallest first.
Event Contracts vs Stock Options
The same $700 at expiry: a YES contract against a $100/$105 call verticaltable · 2026-10-17 · 31×3 One at-the-money AAPL call, tracked against its stock from May 2026series · 2026-10-17 · 23×3Preview: a 16-point series, ending lower. Call delta across strikes, 20 to 45 days to expiryranking · 2026-10-17 · 10×2Preview: 10 ranked values, largest first. What an at-the-money call costs, as a percent of the share priceranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first.
Event Contract Collateral and Max Loss
Return on collateral for each side, by contract priceranking · 2026-10-17 · 13×4Preview: 13 ranked values, smallest first. Near the money SPY put marks, May to June 2026series · 2026-10-17 · 41×4Preview: a 16-point series, roughly flat. Buyer and seller collateral at every contract priceranking · 2026-10-17 · 19×4Preview: 16 ranked values, smallest first. Short dated Treasury yields, trailing 18 monthsseries · 2026-10-17 · 18×4Preview: a 16-point series, ending lower. A 60 cent contract, annualised across holding periodsranking · 2026-10-17 · 7×3Preview: 7 ranked values, largest first.
EURO STOXX 50 Daily Options (OEXP) Explained
SPY's front two weeks of expiries, as of the latest sessionseries · 2026-10-17 · 10×4Preview: a 10-point series, ending lower. Where the Eurex close lands in the US day: FEZ volume share by half hour (ET), trailing two monthsseries · 2026-10-17 · 32×3Preview: a 16-point series, roughly flat. Share of SPY option volume by days to expiry, trailing six weeksranking · 2026-10-17 · 5×2Preview: 5 ranked values, largest first.
ETF vs Mutual Fund Settlement: Two Clocks
SPY by half hour clock bucket, pinned session of Sep 15, 2026series · 2026-10-17 · 13×2Preview: a 13-point series, ending lower. Upcoming trade dates and the day their cash settlesseries · 2026-10-17 · 15×6Preview: a 15-point series, ending higher. Closures and early closes still ahead on the exchange calendarseries · 2026-10-17 · 12×6Preview: a 12-point series, ending higher. How far the 11:00 a.m. print sat from the closing print, Sep 15, 2026ranking · 2026-10-17 · 6×3Preview: 6 ranked values, largest first. Calendar days from trade date to settlement, by weekdayseries · 2026-10-17 · 5×4Preview: a 5-point series, ending higher.
ETF Relative Strength and Alpha Attribution
Annualized volatility and worst single session, trailing two yearsranking · 2026-10-17 · 10×3Preview: 10 ranked values, largest first. 20-session return versus SPY across a nine-fund ETF universeranking · 2026-10-17 · 9×3Preview: 9 ranked values, largest first. Strongest and weakest sleeve versus SPY, by calendar monthseries · 2026-10-17 · 13×4Preview: a 13-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
$