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

COVID Crash 2020: Four Halts, Peak to Trough
10-year and 3-month Treasury yields through the crash, daily closesseries · 2026-07-26 · 31×3Preview: a 16-point series, ending lower. SPY options: puts vs calls traded, March 2–13, 2020 (millions of contracts)series · 2026-07-26 · 10×4Preview: a 10-point series, roughly flat. March 9 and full-crash moves: cruise, airline, energy, bank, tech, staples vs SPYranking · 2026-07-26 · 7×3Preview: 7 ranked values, smallest first. SPY by half-hour: March 9, 2020 regular sessionseries · 2026-07-26 · 13×4Preview: a 13-point series, ending higher. SPY on March 9, 2020: the circuit-breaker session, receiptedscalar · 2026-07-26 · 1×11297.42 The COVID crash, peak to trough to recovery: SPY daily closes, one rowscalar · 2026-07-26 · 1×11338.31 The four circuit-breaker sessions of March 2020: SPY close, change, volumeseries · 2026-07-26 · 4×4Preview: a 4-point series, ending higher.
10-year and 3-month Treasury yields through the crash, daily closes

10-year and 3-month Treasury yields through the crash, daily closes

most recentas of series 31×3read in context →
10-year and 3-month Treasury yields through the crash, daily closes — 31 rows by 3 columns, computed from US exchange, SIP and OPRA data.
dateten_year_pctthree_month_pct
2020-02-181.551.58
2020-02-191.561.58
2020-02-201.521.58
2020-02-211.461.56
2020-02-241.381.53
2020-02-251.331.53
2020-02-261.331.53
2020-02-271.31.45
2020-02-281.131.27
2020-03-021.11.13
2020-03-031.020.95
2020-03-041.020.72
2020-03-050.920.62
2020-03-060.740.45
2020-03-090.540.33
2020-03-100.760.44
2020-03-110.820.42
2020-03-120.880.33
2020-03-130.940.28
2020-03-160.730.24
2020-03-171.020.19
2020-03-181.180.02
2020-03-191.120.04
2020-03-200.920.05
2020-03-230.760.02
2020-03-240.840.01
2020-03-250.880
2020-03-260.830
2020-03-270.720.03
2020-03-300.70.12
2020-03-310.70.11
the exact SQL behind every number
SELECT
    toString(date) AS date,
    round(yield_10_year, 2) AS ten_year_pct,
    round(yield_3_month, 2) AS three_month_pct
FROM global_markets.treasury_yields
WHERE date >= '2020-02-18' AND date <= '2020-03-31'
  AND isNotNull(yield_10_year)
ORDER BY date
$