2,309 answered market questions

wednesday_expiriesranking · 2026-09-17 · 12×3 recentseries · 2026-09-17 · 60×6 monthlyseries · 2026-09-17 · 241×4 inversionsseries · 2026-09-17 · 9×6 front_endseries · 2026-09-17 · 42×5 episodes_comparedtable · 2026-09-17 · 3×9 quote_statesranking · 2026-09-17 · 3×4 cross_minutesseries · 2026-09-17 · 7×4 cross_codestable · 2026-09-17 · 13×5 Where the volume went: most dollars traded over the past weekranking · 2026-09-17 · 8×2 The eleven S&P 500 sectors over the past weekranking · 2026-09-17 · 11×2 Biggest stock losers over the past weekranking · 2026-09-17 · 7×3 The major index ETFs over the past weekranking · 2026-09-17 · 4×4 Biggest stock gainers over the past weekranking · 2026-09-17 · 7×3 Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-09-17 · 5×3 Upcoming US stock splits: announced, with a future effective datetable · 2026-09-17 · 30×5 Announced upcoming splits by directionranking · 2026-09-17 · 2×2 Announced stock splits by effective month: forward vs reverseseries · 2026-09-17 · 4×4 How the whole qualifying universe traded this week, bucketed by relative volumeranking · 2026-09-17 · 7×4 Persistence check: the eight leaders' daily relative volume across the five sessionstable · 2026-09-17 · 8×5 Highest relative volume this week: trailing 5 sessions vs. the prior 40, for names trading $500M+ in the weekseries · 2026-09-17 · 8×6 The board leader, day by day: daily relative volume and open-to-close change (last 15 sessions)series · 2026-09-17 · 15×5 Wild multiples the dollar floor removes: highest relative volume among names trading under $500M this weekseries · 2026-09-17 · 6×5 Market-wide options volume by session, with monthly expirations labelledseries · 2026-09-17 · 25×5 Calls or puts: the board's call and put contract volume on the same sessiontable · 2026-09-17 · 10×5 What follows a heavy options session: next-session absolute move vs. the same names on an ordinary daytable · 2026-09-17 · 5×6 What the session's contracts were made of: options volume by days to expiryranking · 2026-09-17 · 6×4 Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-09-17 · 10×8 volume_curveseries · 2026-09-17 · 13×4 open_vs_lunchtable · 2026-09-17 · 5×6 lunch_povseries · 2026-09-17 · 13×4 curve_dispersionseries · 2026-09-17 · 13×4 worst_windowstable · 2026-09-17 · 8×6 step_uptable · 2026-09-17 · 10×5 rolling_7yseries · 2026-09-17 · 193×5 return_bucketsranking · 2026-09-17 · 5×3 spy_trade_sizesranking · 2026-09-17 · 5×3 spy_option_paceseries · 2026-09-17 · 14×3 session_shapeseries · 2026-09-17 · 16×3 one_lot_shareranking · 2026-09-17 · 6×4 Squeeze-shaped mechanics: crowded shorts among liquid names, with a rising priceranking · 2026-09-17 · 12×4 The screened names ranked by short interest against shares outstanding (not float)table · 2026-09-17 · 10×5 Every past screened name, by what it did over the next 30 daysranking · 2026-09-17 · 6×3 From the whole settlement file down to the screened list, one rule at a timeranking · 2026-09-17 · 4×2 Every input behind this screen, and how many days old it isseries · 2026-09-17 · 3×3 Liquid names at 5+ and 10+ days to cover, settlement by settlementseries · 2026-09-17 · 12×4 worst_windowstable · 2026-09-17 · 5×5 window_vs_decembertable · 2026-09-17 · 3×8 window_volumeranking · 2026-09-17 · 7×4 santa_windowstable · 2026-09-17 · 23×5 folklore_testtable · 2026-09-17 · 2×6 Forward vs reverse splits executed in the last 45 daysranking · 2026-09-17 · 2×2 Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-09-17 · 15×4 Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-09-17 · 15×4 hourly_profileranking · 2026-09-17 · 16×4 cross_shareseries · 2026-09-17 · 8×4 cross_printtable · 2026-09-17 · 6×6 close_secondsseries · 2026-09-17 · 20×4 close_codesranking · 2026-09-17 · 4×3 The receipts: universe size, filter bite, median crowding, and list churn at the latest printscalar · 2026-09-17 · 1×522,567 Largest short positions by shares: latest settlement, liquid namesranking · 2026-09-17 · 10×4 Crowding leaders vs. their own price: about one month of sessionsseries · 2026-09-17 · 4×5 GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-09-17 · 10×4 Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-09-17 · 8×4 Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-09-17 · 8×4 Highest days to cover among liquid names: latest settlement on filetable · 2026-09-17 · 10×5 Upcoming US stock market holidays and early closesseries · 2026-09-17 · 12×6 Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-09-17 · 4×3 Regular trading sessions over the trailing yearscalar · 2026-09-17 · 1×3251 The closure calendar ahead, at a glancescalar · 2026-09-17 · 1×610 This calendar year's closures: already passed (counted from the tape) plus still ahead (from the calendar)table · 2026-09-17 · 2×5 SPY across recent weekends and holiday weekends: Friday's close vs. the reopening printseries · 2026-09-17 · 10×6 Every upcoming NYSE closure and early close on the calendar feed, with a countdownseries · 2026-09-17 · 12×6 Unscheduled closures on the tape: zero regular-session bars on an ordinary weekdayseries · 2026-09-17 · 5×4 Market status computed at this page's refresh: weekday check, holiday check, and the ET clockscalar · 2026-09-17 · 1×70 The most recent session on the tape: bar count, same-day SPY options prints, and the last half-day observedscalar · 2026-09-17 · 1×6211 Weekdays in the trailing year when stocks traded but no Treasury yield printedtable · 2026-09-17 · 2×2 retention_arithmeticseries · 2026-09-17 · 3×4 margin_spread_laddertable · 2026-09-17 · 9×9 cash_account_laddertable · 2026-09-17 · 9×5 SPY, the same measurement: the market's calm benchmarkscalar · 2026-09-17 · 1×313.2 ATM implied volatility across every actively traded underlying, latest sessionscalar · 2026-09-17 · 1×5969 Highest ATM implied volatility: liquid single names and funds, latest sessiontable · 2026-09-17 · 12×5 gap_by_monthseries · 2026-09-17 · 40×5 ex_open_basketranking · 2026-09-17 · 21×4 aapl_dividendsseries · 2026-09-17 · 8×12 Increases against cuts, by week of declaration (complete weeks only)series · 2026-09-17 · 26×4 Payers across their own share split: the raw change against the split-adjusted changeseries · 2026-09-17 · 9×7 Increases, cuts and the typical raise this calendar year, by company size (bands use today's market value)table · 2026-09-17 · 4×6 Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows)series · 2026-09-17 · 6×8 Dividend cuts declared in the last 90 days, the deepest 14 first (one week is too thin for a table)series · 2026-09-17 · 14×6 Biggest stock losers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-17 · 10×4 The four major index ETFs this week, for contextranking · 2026-09-17 · 4×2 Biggest stock gainers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-17 · 10×4 The window and the screened universe behind every board on this pagescalar · 2026-09-17 · 1×520 Where every screened company landed: monthly returns by bucketranking · 2026-09-17 · 6×2 Eight household mega-cap names over the same windowranking · 2026-09-17 · 8×2 Biggest stock losers this month (companies trading $1B+ over the window)ranking · 2026-09-17 · 10×3 The four major index trackers across the same window, rebased to the first openseries · 2026-09-17 · 20×5 Biggest stock gainers this month (companies trading $1B+ over the window)ranking · 2026-09-17 · 10×3

SELECT
    toStartOfMonth(date)                          AS month,
    formatDateTime(month, '%b %Y')                AS month_label,
    round(avg(toFloat64(yield_3_month)), 2)       AS three_month_yield,
    round(avg(toFloat64(yield_2_year)), 2)        AS two_year_yield,
    round(avg(toFloat64(yield_10_year)), 2)       AS ten_year_yield
FROM global_markets.treasury_yields
WHERE date >= toDate('2021-07-01')
  AND date <  toDate('2025-01-01')
  AND yield_3_month > 0
  AND yield_2_year > 0
  AND yield_10_year > 0
GROUP BY month
ORDER BY month