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

2,170 answered market questions

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

Covered Call Closed-End Funds vs ETFs
Short-term Treasury yields by month, the reference for fund borrowing costsseries · 2026-08-22 · 36×3Preview: a 16-point series, ending lower. Cash distributions over the trailing year, by declared scheduleranking · 2026-08-22 · 5×2Preview: 5 ranked values, largest first. Monthly cost of a near-the-money call, as a percent of share priceseries · 2026-08-22 · 18×3Preview: a 16-point series, roughly flat.
Best Time of Day to Sell a Mutual Fund
Overnight gap versus the session that follows, complete yearsranking · 2026-08-22 · 5×3Preview: 5 ranked values, smallest first. How far SPY trades from its own open and close, by time of dayseries · 2026-08-22 · 13×3Preview: a 13-point series, ending higher. Average one-day move across six widely held funds, since 2021ranking · 2026-08-22 · 6×2Preview: 6 ranked values, smallest first. How big a one-day move usually is, sessions since 2016ranking · 2026-08-22 · 5×2Preview: 5 ranked values, largest first.
International Fund NAV: Fair Value Pricing
The overnight and New York halves of the day, year by yearranking · 2026-08-10 · 6×3Preview: 6 ranked values, smallest first. Foreign listings during New York hours, sorted by the US large cap moveranking · 2026-08-10 · 5×4Preview: 5 ranked values, smallest first. Average move by New York half hour, two foreign listingsseries · 2026-08-10 · 25×3Preview: a 16-point series, ending lower. Where the daily move lands: overnight gap versus the New York sessionranking · 2026-08-10 · 6×3Preview: 6 ranked values, largest first.
How Mutual Fund NAV Is Calculated: Example
Share of SPY's session volume by half hour, June 2026 averageseries · 2026-08-06 · 13×2Preview: a 13-point series, ending higher. Average move from the 11:30 a.m. ET European close to the 4:00 p.m. close, Q2 2026ranking · 2026-08-06 · 5×3Preview: 5 ranked values, largest first. One session's price path, SPY every 15 minutes on June 17, 2026series · 2026-08-06 · 27×2Preview: a 16-point series, ending lower. Distance from the 10:00 a.m. ET price to the close, SPY, by monthseries · 2026-08-06 · 12×4Preview: a 12-point series, roughly flat.
ETF Premium and Discount to NAV, Explained
How far seven ETFs travel in a regular session, first half of 2026ranking · 2026-08-06 · 7×3Preview: 7 ranked values, largest first. Median session move by month, 2026 first halfseries · 2026-08-06 · 6×4Preview: a 6-point series, roughly flat. Average minute bar range by ET clock time, second quarter 2026series · 2026-08-06 · 26×4Preview: a 16-point series, ending lower. Median move before and after European markets close, first half of 2026ranking · 2026-08-06 · 4×3Preview: 4 ranked values, largest first.
Mutual Funds vs ETFs: What Actually Differs
Quoted bid-ask spread by fund: venue quotes, 11:00 to 13:59 ET, July 22, 2026ranking · 2026-08-02 · 7×4Preview: 7 ranked values, smallest first. The first active ETF share class: DFMC weekly closes since its March 2026 listingseries · 2026-08-02 · 20×4Preview: a 16-point series, ending lower. How far the price travels inside a day: seven ETFs, July 2026 sessionsranking · 2026-08-02 · 7×4Preview: 7 ranked values, largest first. One session, many prices: VOO in half-hour marks, Wednesday July 22, 2026series · 2026-08-02 · 32×3Preview: a 16-point series, roughly flat.
When Do Mutual Fund Trades Settle?
Short end vs long end of the Treasury curve: monthly averages, July 2024 to June 2026series · 2026-08-01 · 24×4Preview: a 16-point series, ending lower. Trading sessions vs calendar days, twelve months through June 2026series · 2026-08-01 · 12×4Preview: a 12-point series, ending lower. How far the S&P 500 tracker moved open to close: sessions by size band, July 2025 to June 2026ranking · 2026-08-01 · 5×3Preview: 5 ranked values, largest first. Longest breaks between US trading sessions, January to late July 2026ranking · 2026-08-01 · 10×2Preview: 10 ranked values, largest first.
When Do Mutual Funds Trade? NAV Pricing at 4 pm
The same 15 sessions, summarized: the close's floor, average, and peakscalar · 2026-07-26 · 1×416.3 SPY volume share of the final 30 minutes and final minute: last 15 sessions through July 10, 2026series · 2026-07-26 · 15×3Preview: a 15-point series, ending lower. Month-end sessions vs all other sessions: SPY close concentration, January–June 2026scalar · 2026-07-26 · 1×76 The spread a fund buyer never pays: median quoted spread, July 10, 2026 regular sessionranking · 2026-07-26 · 3×3Preview: 3 ranked values, smallest first. How much of SPY's day trades at the very end: July 10, 2026 regular sessionscalar · 2026-07-26 · 1×322.5 The print NAV is struck from: AAPL's closing auction cross, July 10, 2026scalar · 2026-07-26 · 1×65.47
Short-term Treasury yields by month, the reference for fund borrowing costs

Short-term Treasury yields by month, the reference for fund borrowing costs

most recentas of series 36×3read in context →
Short-term Treasury yields by month, the reference for fund borrowing costs — 36 rows by 3 columns, computed from US exchange, SIP and OPRA data.
monthavg_1_month_yield_pctavg_3_month_yield_pct
2023-085.545.56
2023-095.535.56
2023-105.575.6
2023-115.535.52
2023-125.545.44
2024-015.545.45
2024-025.495.44
2024-035.515.47
2024-045.485.44
2024-055.55.45
2024-065.465.51
2024-075.485.43
2024-085.55.3
2024-095.064.92
2024-104.924.72
2024-114.714.62
2024-124.54.39
2025-014.424.34
2025-024.374.33
2025-034.374.34
2025-044.354.32
2025-054.374.36
2025-064.244.42
2025-074.374.41
2025-084.464.3
2025-094.244.07
2025-104.153.98
2025-114.033.94
2025-123.773.68
2026-013.733.67
2026-023.723.69
2026-033.743.72
2026-043.693.7
2026-053.713.69
2026-063.693.81
2026-073.743.87
the exact SQL behind every number
SELECT
    formatDateTime(toStartOfMonth(date), '%Y-%m') AS month,
    round(avg(yield_1_month), 2)                  AS avg_1_month_yield_pct,
    round(avg(yield_3_month), 2)                  AS avg_3_month_yield_pct
FROM global_markets.treasury_yields
WHERE date >= toStartOfMonth(today() - 1090)
  AND date <  toStartOfMonth(today())
  AND yield_1_month > 0
  AND yield_3_month > 0
GROUP BY month
ORDER BY month
$