STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

T-Bill Maturities and How Yields Are Quoted
A nine-month estimate, interpolated between the 3-month and 1-year pointsseries · 2026-10-07 · 26×5Preview: a 16-point series, ending higher. Front-end yields by horizon: 13-week bill, 1-year point, 2-year noteseries · 2026-10-07 · 26×6Preview: a 16-point series, ending higher. The published short end of the Treasury curve, April to September 2026table · 2026-10-07 · 3×6 The same bill on both conventions: coupon equivalent versus discount basistable · 2026-10-07 · 2×5
How VIX Settlement Works: the SOQ
Listed versus traded strikes by moneyness (SPY, Sep 18 2026 expiry, as of Aug 14 2026)ranking · 2026-10-04 · 10×3Preview: 10 ranked values, largest first. Upcoming VIX settlement dates and the SPX expiry each one usesseries · 2026-10-04 · 13×5Preview: a 13-point series, ending higher. Average high to low range by minute, first half hour (SPY, trailing ~4 months)series · 2026-10-04 · 30×3Preview: a 16-point series, ending lower. Expirations three to six weeks out on a pinned session (SPY, Aug 14 2026)series · 2026-10-04 · 3×4Preview: a 3-point series, ending higher.
On-the-Run vs Off-the-Run Treasuries
Average yield step between benchmark tenors, trailing four monthsranking · 2026-10-04 · 2×3Preview: 2 ranked values, smallest first. 2-year and 10-year constant maturity yields, month by monthseries · 2026-10-04 · 24×5Preview: a 16-point series, ending higher. Typical one-day move in the 10-year yield, by monthseries · 2026-10-04 · 23×4Preview: a 16-point series, ending lower. The Treasury constant maturity curve, latest published sessionranking · 2026-10-04 · 10×3Preview: 10 ranked values, smallest first.
MOC and MOO Order Cutoff Times: NYSE & Nasdaq
SPY minute volume into the close, June 30 2026 (quarter end)series · 2026-10-04 · 31×2Preview: a 16-point series, ending higher. Share of SPY's regular-session volume by five-minute ET bucketseries · 2026-10-04 · 79×2Preview: a 16-point series, ending lower. Opening and closing windows as a share of regular-session volumeranking · 2026-10-04 · 8×3Preview: 8 ranked values, largest first. SPY: opening and closing window share of session volume, by monthseries · 2026-10-04 · 25×3Preview: a 16-point series, roughly flat.
KRX After-Hours Trading: Korea's Sessions
AAPL quoted spread by clock time, 15 September 2026series · 2026-10-04 · 24×3Preview: a 16-point series, ending lower. Share of monthly volume by New York clock time, AAPL and KOseries · 2026-10-04 · 32×3Preview: a 16-point series, roughly flat. Share of the day's volume printed minute by minute into the US close, and the closing cross itselfseries · 2026-10-04 · 11×2Preview: a 11-point series, ending higher.
What Does Cross Mean in Trading? 4 Meanings
AAPL quote states in the first five minutes of June 18, 2026: normal, locked, crossedranking · 2026-09-28 · 3×4Preview: 3 ranked values, largest first. AAPL average volume by clock minute, June 2026: the two cross minutes vs ordinary onesseries · 2026-09-28 · 7×4Preview: a 7-point series, roughly flat. Equities condition codes that mark a cross, an opening, a closing, or an official printtable · 2026-09-28 · 13×5
NYSE Imbalance Messages: How to Read Them
Gap between the 3:50 p.m. price and the official close, July 2026 sessionsranking · 2026-09-28 · 6×3Preview: 6 ranked values, largest first. How often the close finished above the 3:50 p.m. price, July 2026 sessionsranking · 2026-09-28 · 6×3Preview: 6 ranked values, largest first. Coca-Cola average volume per five-minute bucket from 3:00 p.m. ET, then the closing auction print, July 2026series · 2026-09-28 · 13×2Preview: a 13-point series, ending higher. Share of regular-session volume in the opening and closing auction prints, July 2026ranking · 2026-09-28 · 6×3Preview: 6 ranked values, largest first.
What Is the Opening Auction? How Stocks Open
The opening cross vs. the rest of the day: SPY, AAPL, NVDA on July 2, 2026series · 2026-07-26 · 3×12Preview: a 3-point series, ending higher. AAPL volume by quarter-hour, July 2, 2026: pre-market to after-hours (ET)series · 2026-07-26 · 64×2Preview: a 16-point series, roughly flat. The 9:30 bar vs. the 12:30 bar: SPY, AAPL, NVDA on July 2, 2026table · 2026-07-26 · 3×8 The tape's own labels for the open, straight from the code dictionaryranking · 2026-07-26 · 5×3Preview: 5 ranked values, smallest first. The receipt: AAPL's opening cross vs. everything that traded before it, July 1-2, 2026scalar · 2026-07-26 · 1×14390
A nine-month estimate, interpolated between the 3-month and 1-year points

A nine-month estimate, interpolated between the 3-month and 1-year points

most recentas of series 26×5read in context →
A nine-month estimate, interpolated between the 3-month and 1-year points — 26 rows by 5 columns, computed from US exchange, SIP and OPRA data.
weekweek_labelbill_3m_pctinterp_9m_pctbill_1y_pct
2026-03-30Mar 303.73.73.69
2026-04-06Apr 63.73.73.69
2026-04-13Apr 133.713.693.69
2026-04-20Apr 203.693.683.68
2026-04-27Apr 273.683.713.72
2026-05-04May 43.693.743.76
2026-05-11May 113.693.763.8
2026-05-18May 183.673.773.82
2026-05-25May 253.693.763.8
2026-06-01Jun 13.783.823.84
2026-06-08Jun 83.793.843.87
2026-06-15Jun 153.813.883.91
2026-06-22Jun 223.843.943.99
2026-06-29Jun 293.853.943.98
2026-07-06Jul 63.863.974.03
2026-07-13Jul 133.853.964.02
2026-07-20Jul 203.914.044.1
2026-07-27Jul 273.874.014.08
2026-08-03Aug 33.893.994.04
2026-08-10Aug 103.883.964
2026-08-17Aug 173.873.964
2026-08-24Aug 243.863.994.05
2026-08-31Aug 313.914.074.15
2026-09-07Sep 73.994.154.24
2026-09-14Sep 144.124.314.41
2026-09-21Sep 214.24.384.48
the exact SQL behind every number
SELECT
    toString(toMonday(date))                AS week,
    formatDateTime(toMonday(date), '%b %e') AS week_label,
    round(avg(toFloat64(yield_3_month)), 2) AS bill_3m_pct,
    round(avg(
        toFloat64(yield_3_month)
        + (toFloat64(yield_1_year) - toFloat64(yield_3_month)) * (273 - 91) / (365 - 91)
    ), 2)                                   AS interp_9m_pct,
    round(avg(toFloat64(yield_1_year)), 2)  AS bill_1y_pct
FROM global_markets.treasury_yields
WHERE date >= '2026-04-01'
  AND date <  '2026-09-26'
  AND yield_3_month > 0
  AND yield_1_year  > 0
GROUP BY week, week_label
ORDER BY week
$