STRASMORE/EXPLORE 2,178 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,178 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Upcoming Stock Splits Calendar
Upcoming US stock splits: announced, with a future effective datetable · 2026-08-30 · 30×5 Announced upcoming splits by directionranking · 2026-08-30 · 2×2Preview: 2 ranked values, smallest first. Announced stock splits by effective month: forward vs reverseseries · 2026-08-30 · 5×4Preview: a 5-point series, ending lower.
Upcoming Ex-Dividend Dates: Stocks This Week
Three household payers at their last ex-date: prior close, ex-morning open, and the payment for scaleseries · 2026-08-30 · 3×8Preview: a 3-point series, roughly flat. Who goes ex-dividend in the next 14 days: names, cadence and implied yield by size bandtable · 2026-08-30 · 4×5 Names going ex-dividend, day by day: the next seven days of declared recordsseries · 2026-08-30 · 5×5Preview: a 5-point series, ending lower. Ex-dividend dates by calendar month: three-year average, quarterly vs monthly payersseries · 2026-08-30 · 12×4Preview: a 12-point series, ending higher. Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-dateseries · 2026-08-30 · 13×8Preview: a 13-point series, ending higher. Forward-declared ex-dividend records on file: the receipt behind this calendarscalar · 2026-08-30 · 1×54,427 Every mega-cap ex-dividend event of the past six months: price path from the pre-ex closetable · 2026-08-30 · 5×6 Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yieldseries · 2026-08-30 · 12×8Preview: a 12-point series, ending higher.
Unusual Options Activity: Last Session
Market-wide options volume by session, with monthly expirations labelledseries · 2026-08-30 · 25×5Preview: a 16-point series, ending higher. Calls or puts: the board's call and put contract volume on the same sessiontable · 2026-08-30 · 10×5 What follows a heavy options session: next-session absolute move vs. the same names on an ordinary daytable · 2026-08-30 · 5×6 What the session's contracts were made of: options volume by days to expiryranking · 2026-08-30 · 6×4Preview: 6 ranked values, largest first. Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-08-30 · 10×8
Recent Stock Splits (Forward and Reverse)
Forward vs reverse splits executed in the last 45 daysranking · 2026-08-30 · 2×2Preview: 2 ranked values, largest first. Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-08-30 · 15×4Preview: 15 ranked values, largest first. Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-08-30 · 15×4Preview: 15 ranked values, smallest first.
Most Shorted Stocks Right Now, Measured
The receipts: universe size, filter bite, median crowding, and list churn at the latest printscalar · 2026-08-30 · 1×522,480 Largest short positions by shares: latest settlement, liquid namesranking · 2026-08-30 · 10×4Preview: 10 ranked values, largest first. Crowding leaders vs. their own price: about one month of sessionsseries · 2026-08-30 · 5×5Preview: a 5-point series, ending higher. GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-08-30 · 10×4Preview: a 10-point series, ending lower. Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-08-30 · 8×4Preview: a 8-point series, ending lower. Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-08-30 · 8×4Preview: 8 ranked values, smallest first. Highest days to cover among liquid names: latest settlement on filetable · 2026-08-30 · 10×5
Stock Market Holidays 2026–2027: NYSE & Nasdaq
Upcoming US stock market holidays and early closesseries · 2026-08-30 · 12×6Preview: a 12-point series, ending higher. Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-08-30 · 4×3Preview: a 4-point series, roughly flat. Regular trading sessions over the trailing yearscalar · 2026-08-30 · 1×3252 The closure calendar ahead, at a glancescalar · 2026-08-30 · 1×610
Highest Implied Volatility Stocks Right Now
SPY, the same measurement: the market's calm benchmarkscalar · 2026-08-30 · 1×312.3 ATM implied volatility across every actively traded underlying, latest sessionscalar · 2026-08-30 · 1×5947 Highest ATM implied volatility: liquid single names and funds, latest sessiontable · 2026-08-30 · 12×5
Dividend Increases & Cuts This Week
Increases against cuts, by week of declaration (complete weeks only)series · 2026-08-30 · 26×4Preview: a 16-point series, ending lower. Payers across their own share split: the raw change against the split-adjusted changeseries · 2026-08-30 · 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-08-30 · 4×6 Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows)series · 2026-08-30 · 7×8Preview: a 7-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-08-30 · 14×6Preview: a 14-point series, ending higher.
Biggest Stock Gainers and Losers This Week
Biggest stock losers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-08-30 · 10×4Preview: 10 ranked values, smallest first. The four major index ETFs this week, for contextranking · 2026-08-30 · 4×2Preview: 4 ranked values, largest first. Biggest stock gainers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-08-30 · 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-08-30 · 1×518 Where every screened company landed: monthly returns by bucketranking · 2026-08-30 · 6×2Preview: 6 ranked values, smallest first. Eight household mega-cap names over the same windowranking · 2026-08-30 · 8×2Preview: 8 ranked values, largest first. Biggest stock losers this month (companies trading $1B+ over the window)ranking · 2026-08-30 · 10×3Preview: 10 ranked values, smallest first. The four major index trackers across the same window, rebased to the first openseries · 2026-08-30 · 18×5Preview: a 16-point series, ending higher. Biggest stock gainers this month (companies trading $1B+ over the window)ranking · 2026-08-30 · 10×3Preview: 10 ranked values, largest first.
Stocks at 52-Week Highs and Lows
How far the whole screen sits below its 52-week highranking · 2026-08-30 · 6×4Preview: 6 ranked values, smallest first. Stocks at 52-week lows, ordered by year-to-date returnranking · 2026-08-30 · 3×3Preview: 3 ranked values, largest first. Where five broad-market ETFs sit inside their own 52-week rangeranking · 2026-08-30 · 5×4Preview: 5 ranked values, smallest first. Stocks at 52-week highs, ordered by year-to-date returnranking · 2026-08-30 · 12×3Preview: 12 ranked values, smallest first. New 52-week highs against new lows, daily, over the past six weeksseries · 2026-08-30 · 31×4Preview: a 16-point series, ending higher.
XOM Dividend: Yield, History & Ex-Dates
XOM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-08-29 · 1×71.03 XOM recent dividend payments: ex-dividend date and per-share amountseries · 2026-08-29 · 10×2Preview: a 10-point series, ending lower. XOM total dividends paid per year (regular dividends)ranking · 2026-08-29 · 7×2Preview: 7 ranked values, smallest first.
WMT Dividend: Yield, History & Ex-Dates
WMT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-08-29 · 1×70.248 WMT recent dividend payments: ex-dividend date and per-share amountseries · 2026-08-29 · 10×2Preview: a 10-point series, ending lower. WMT total dividends paid per year (regular dividends)ranking · 2026-08-29 · 7×2Preview: 7 ranked values, largest first.
Why VIX Options Don't Track the VIX
SPY near-the-money implied volatility by distance to expirationranking · 2026-08-29 · 6×3Preview: 6 ranked values, smallest first. How far the long tenor travels on days the front end jumpsranking · 2026-08-29 · 5×4Preview: 5 ranked values, smallest first. Near-dated versus long-dated SPY implied volatility, session by sessionseries · 2026-08-29 · 76×3Preview: a 16-point series, roughly flat. The near-to-far implied volatility gap across liquid namesranking · 2026-08-29 · 6×4Preview: 6 ranked values, largest first.
Why Ticker Symbols Break Your Dataset
When each symbol last printed a daily barranking · 2026-08-29 · 6×3Preview: 6 ranked values, largest first. New listings landing on a symbol that already had historyranking · 2026-08-29 · 11×3Preview: 11 ranked values, smallest first. Which share-class spellings actually carry historyranking · 2026-08-29 · 4×4Preview: 4 ranked values, smallest first. Trading sessions per year under FB and METAranking · 2026-08-29 · 15×3Preview: 15 ranked values, smallest first.
Why Stocks Halt: Limit Up-Limit Down Bands
Where listed symbols sit by price, and which band rule governs each zoneranking · 2026-08-29 · 6×3Preview: 6 ranked values, largest first. Average minute range through the session, five liquid namesseries · 2026-08-29 · 26×3Preview: a 16-point series, ending lower. How far eight stocks move in a five minute window, trailing yearranking · 2026-08-29 · 8×4Preview: 8 ranked values, largest first. What a 5 percent band is worth in dollars, by price levelranking · 2026-08-29 · 8×4Preview: 8 ranked values, largest first.
Why Short Interest Data Is Always Two Weeks Old
The pipeline lag in one row: plus the bulk backfill these figures deliberately excludescalar · 2026-08-29 · 1×611 Every incrementally-delivered settlement: measured on one date, on file days laterseries · 2026-08-29 · 11×3Preview: a 11-point series, ending lower. GME, winter 2020-21: each short interest print and the price move before it went public (as-traded prices)table · 2026-08-29 · 6×5 GME days to cover: as reported in the file, and recomputed on the volume that traded while the print was pendingscalar · 2026-08-29 · 1×854 The current state of the cycle: the newest print on file, and the one still in the pipelinescalar · 2026-08-29 · 1×622,480 The blind window: what five stocks did between the settlement date and the day its short interest was publishedtable · 2026-08-29 · 5×6
Why Index Options Are Taxed 60/40: Section 1256
Average daily options volume: Section 1256 names against equity optionsranking · 2026-08-29 · 4×3Preview: 4 ranked values, largest first. Share of contract volume by days to expiry, SPX and SPYranking · 2026-08-29 · 5×3Preview: 5 ranked values, largest first.
Who Sets the Ex-Dividend Date? Not the Board
One-time distributions by size: where the ex-date landsranking · 2026-08-29 · 4×4Preview: 4 ranked values, largest first. Regular dividends: ex-date before the record date, or on itseries · 2026-08-29 · 43×5Preview: a 16-point series, ending higher. Board declaration to ex-date to payment, eight household payersranking · 2026-08-29 · 8×4Preview: 8 ranked values, largest first. Ex-date alignment by payout cadence, since T+1 took effectranking · 2026-08-29 · 6×4Preview: 6 ranked values, largest first.
Where to Park Idle Cash
The pickup for extending: extra yield over the 1-month bill, in basis pointsseries · 2026-08-29 · 126×3Preview: a 16-point series, ending higher. The short end over the last 180 days: 1-month, 3-month and 1-year bill yieldsseries · 2026-08-29 · 126×5Preview: a 16-point series, ending higher. The current Treasury yield curve: what every maturity pays right nowranking · 2026-08-29 · 7×2Preview: 7 ranked values, smallest first.
When Special Dividends Adjust Options
Time value left in KO calls as they move deeper in the moneyranking · 2026-08-29 · 5×4Preview: 5 ranked values, largest first. One time distributions by size, measured against the ex date closing priceranking · 2026-08-29 · 6×3Preview: 6 ranked values, largest first. How big each kind of cash distribution is, as a share of the stock priceranking · 2026-08-29 · 5×4Preview: 5 ranked values, largest first. One time cash distributions per calendar year, and their share of all payoutsranking · 2026-08-29 · 9×3Preview: 9 ranked values, largest first.
When Is Short Interest Released?
The short interest release schedule: recent FINRA settlement dates and names reportedseries · 2026-08-29 · 16×2Preview: a 16-point series, ending lower. Measured publication lag: settlement date vs the day the file first arrived hereseries · 2026-08-29 · 11×3Preview: a 11-point series, ending lower. The publication lag in one row: fastest, median and slowest across incrementally-delivered settlementsscalar · 2026-08-29 · 1×411 Day-of-month and the gap between consecutive settlement dates: the twice-monthly cadenceseries · 2026-08-29 · 16×3Preview: a 16-point series, ending lower. The current state of the release cycle: the newest print on file and the settlement still pendingscalar · 2026-08-29 · 1×614
When Short Options Get Assigned Early
Time value left in AAPL contracts by depth in the moneytable · 2026-08-29 · 5×5 AAPL calls 1 to 5 percent in the money, by days left to expiryranking · 2026-08-29 · 6×4Preview: 6 ranked values, smallest first. Latest cash dividend per share, and what it is worth against the stockseries · 2026-08-29 · 6×4Preview: a 6-point series, ending lower. Put versus call implied volatility, near the money, 20 to 45 days outranking · 2026-08-29 · 5×4Preview: 5 ranked values, smallest first.
What Time Do Options Start Trading?
SPY option volume, minute by minute into the 9:30 openseries · 2026-08-29 · 46×3Preview: a 16-point series, ending higher. US option contract volume by Eastern-time half hourseries · 2026-08-29 · 21×3Preview: a 16-point series, ending higher.
page 1 of 22
The short end over the last 180 days: 1-month, 3-month and 1-year bill yields

The short end over the last 180 days: 1-month, 3-month and 1-year bill yields

as of series 126×5read in context →
The short end over the last 180 days: 1-month, 3-month and 1-year bill yields — 126 rows by 5 columns, computed from US exchange, SIP and OPRA data.
dateone_month_pctthree_month_pctone_year_pctas_of_label
2026-03-023.743.723.54Mar 2, 2026
2026-03-033.753.713.55Mar 3, 2026
2026-03-043.753.713.58Mar 4, 2026
2026-03-053.753.73.59Mar 5, 2026
2026-03-063.753.693.55Mar 6, 2026
2026-03-093.753.713.56Mar 9, 2026
2026-03-103.753.713.56Mar 10, 2026
2026-03-113.753.713.6Mar 11, 2026
2026-03-123.763.723.66Mar 12, 2026
2026-03-133.753.723.66Mar 13, 2026
2026-03-163.753.723.64Mar 16, 2026
2026-03-173.743.723.63Mar 17, 2026
2026-03-183.733.733.68Mar 18, 2026
2026-03-193.733.733.73Mar 19, 2026
2026-03-203.733.743.8Mar 20, 2026
2026-03-233.733.743.76Mar 23, 2026
2026-03-243.743.743.81Mar 24, 2026
2026-03-253.733.733.77Mar 25, 2026
2026-03-263.743.733.83Mar 26, 2026
2026-03-273.743.733.77Mar 27, 2026
2026-03-303.743.713.71Mar 30, 2026
2026-03-313.743.73.68Mar 31, 2026
2026-04-013.743.73.68Apr 1, 2026
2026-04-023.723.73.68Apr 2, 2026
2026-04-033.713.713.72Apr 3, 2026
2026-04-063.723.723.72Apr 6, 2026
2026-04-073.683.713.68Apr 7, 2026
2026-04-083.673.693.69Apr 8, 2026
2026-04-093.663.683.68Apr 9, 2026
2026-04-103.673.693.7Apr 10, 2026
2026-04-133.693.713.7Apr 13, 2026
2026-04-143.713.713.71Apr 14, 2026
2026-04-153.723.713.7Apr 15, 2026
2026-04-163.693.73.69Apr 16, 2026
2026-04-173.693.73.64Apr 17, 2026
2026-04-203.693.713.65Apr 20, 2026
2026-04-213.673.693.69Apr 21, 2026
2026-04-223.683.693.69Apr 22, 2026
2026-04-233.693.693.7Apr 23, 2026
2026-04-243.693.693.67Apr 24, 2026
2026-04-273.73.683.69Apr 27, 2026
2026-04-283.683.683.71Apr 28, 2026
2026-04-293.683.683.75Apr 29, 2026
2026-04-303.723.683.72Apr 30, 2026
2026-05-013.713.683.73May 1, 2026
2026-05-043.713.73.78May 4, 2026
2026-05-053.73.693.77May 5, 2026
2026-05-063.73.693.73May 6, 2026
2026-05-073.723.693.76May 7, 2026
2026-05-083.713.693.75May 8, 2026
2026-05-113.713.73.79May 11, 2026
2026-05-123.713.73.8May 12, 2026
2026-05-133.713.693.79May 13, 2026
2026-05-143.723.693.79May 14, 2026
2026-05-153.713.693.82May 15, 2026
2026-05-183.693.683.81May 18, 2026
2026-05-193.663.673.83May 19, 2026
2026-05-203.653.653.79May 20, 2026
2026-05-213.723.683.83May 21, 2026
2026-05-223.723.683.86May 22, 2026
2026-05-263.723.683.82May 26, 2026
2026-05-273.723.683.8May 27, 2026
2026-05-283.723.693.8May 28, 2026
2026-05-293.723.693.79May 29, 2026
2026-06-013.723.783.83Jun 1, 2026
2026-06-023.723.773.82Jun 2, 2026
2026-06-033.713.783.84Jun 3, 2026
2026-06-043.713.783.82Jun 4, 2026
2026-06-053.713.783.88Jun 5, 2026
2026-06-083.73.83.85Jun 8, 2026
2026-06-093.693.793.9Jun 9, 2026
2026-06-103.693.793.9Jun 10, 2026
2026-06-113.693.783.85Jun 11, 2026
2026-06-123.693.783.86Jun 12, 2026
2026-06-153.693.793.84Jun 15, 2026
2026-06-163.673.793.84Jun 16, 2026
2026-06-173.683.833.98Jun 17, 2026
2026-06-183.693.834Jun 18, 2026
2026-06-223.663.854.04Jun 22, 2026
2026-06-233.653.854.01Jun 23, 2026
2026-06-243.663.853.99Jun 24, 2026
2026-06-253.73.843.96Jun 25, 2026
2026-06-263.73.833.94Jun 26, 2026
2026-06-293.713.873.97Jun 29, 2026
2026-06-303.73.873.98Jun 30, 2026
2026-07-013.673.854Jul 1, 2026
2026-07-023.73.823.96Jul 2, 2026
2026-07-063.693.873.95Jul 6, 2026
2026-07-073.693.864.06Jul 7, 2026
2026-07-083.673.874.06Jul 8, 2026
2026-07-093.723.834.02Jul 9, 2026
2026-07-103.713.854.06Jul 10, 2026
2026-07-133.733.894.12Jul 13, 2026
2026-07-143.733.844.02Jul 14, 2026
2026-07-153.733.833.97Jul 15, 2026
2026-07-163.763.843.99Jul 16, 2026
2026-07-173.733.854.01Jul 17, 2026
2026-07-203.723.864.03Jul 20, 2026
2026-07-213.753.874.08Jul 21, 2026
2026-07-223.763.894.11Jul 22, 2026
2026-07-233.823.954.15Jul 23, 2026
2026-07-243.83.964.14Jul 24, 2026
2026-07-273.83.964.14Jul 27, 2026
2026-07-283.763.94.09Jul 28, 2026
2026-07-293.733.834.04Jul 29, 2026
2026-07-303.793.824.04Jul 30, 2026
2026-07-313.783.834.08Jul 31, 2026
2026-08-033.793.914.07Aug 3, 2026
2026-08-043.783.894.04Aug 4, 2026
2026-08-053.773.894.03Aug 5, 2026
2026-08-063.83.94.06Aug 6, 2026
2026-08-073.793.874.01Aug 7, 2026
2026-08-103.793.894.04Aug 10, 2026
2026-08-113.793.894.03Aug 11, 2026
2026-08-123.783.874Aug 12, 2026
2026-08-133.793.873.97Aug 13, 2026
2026-08-143.793.863.98Aug 14, 2026
2026-08-173.793.874Aug 17, 2026
2026-08-183.783.863.99Aug 18, 2026
2026-08-193.773.864Aug 19, 2026
2026-08-203.83.873.99Aug 20, 2026
2026-08-213.83.884.03Aug 21, 2026
2026-08-243.793.874.04Aug 24, 2026
2026-08-253.793.864.01Aug 25, 2026
2026-08-263.83.854.02Aug 26, 2026
2026-08-273.813.844.04Aug 27, 2026
the exact SQL behind every number
SELECT date,
       round(yield_1_month, 2) AS one_month_pct,
       round(yield_3_month, 2) AS three_month_pct,
       round(yield_1_year, 2) AS one_year_pct,
       formatDateTime(date, '%b %e, %Y') AS as_of_label
FROM global_markets.treasury_yields
WHERE date >= (SELECT max(date) FROM global_markets.treasury_yields) - 180
  AND yield_1_month IS NOT NULL
ORDER BY date
$