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

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
Ex-Dividend Calendar from a Free SQL API
Liquid US names going ex-dividend in the next 14 daysranking · 2026-11-01 · 15×4Preview: 15 ranked values, largest first. Declared ex-dividend dates per week, next 12 weeksseries · 2026-11-01 · 12×3Preview: a 12-point series, ending lower. How far ahead dividends were declared, trailing 12 monthsranking · 2026-11-01 · 5×2Preview: 5 ranked values, smallest first.
Liquid US names going ex-dividend in the next 14 days

Liquid US names going ex-dividend in the next 14 days

most recentas of ranking 15×4read in context →
Liquid US names going ex-dividend in the next 14 days — 15 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickergoes_expayablecash_amount
BXNov 2Nov 91.12
OKENov 2Nov 161.07
PNWNov 2Dec 10.925
AONNov 2Nov 130.82
EWBCNov 2Nov 170.8
CNov 2Nov 250.67
NRGNov 2Nov 160.475
VCLTNov 2Nov 40.366
VCITNov 2Nov 40.3501
ALLYNov 2Nov 160.35
VCSHNov 2Nov 40.3045
LVSNov 2Nov 100.3
KMINov 2Nov 160.2975
BIVNov 2Nov 40.291311
BSVNov 2Nov 40.274313
the exact SQL behind every number 
WITH liquid AS
(
    SELECT ticker
    FROM global_markets.stocks_daily_aggs
    WHERE date >= today() - 45
    GROUP BY ticker
    HAVING avg(toFloat64(close) * volume) > 1e8
)
SELECT
    ticker,
    formatDateTime(ex_dividend_date, '%b %e')  AS goes_ex,
    formatDateTime(any(pay_date), '%b %e')     AS payable,
    max(cash_amount)                           AS cash_amount
FROM global_markets.stocks_dividends
WHERE ex_dividend_date >= today()
  AND ex_dividend_date <  today() + 14
  AND currency = 'USD'
  AND ticker IN (SELECT ticker FROM liquid)
  AND ticker NOT IN ('SPCX')
GROUP BY ticker, ex_dividend_date
ORDER BY ex_dividend_date, cash_amount DESC, ticker
LIMIT 15
More from this analysisEx-Dividend Calendar from a Free SQL API
How far ahead dividends were declared, trailing 12 months ranking 5×2 → Declared ex-dividend dates per week, next 12 weeks series 12×3 → Pairwise daily return correlation, trailing year ranking 15×2 → Cumulative weight and the Herfindahl concentration index ranking 6×4 → See all 3,293 queries →
$