2,469 answered market questions

Where the volume went: most dollars traded over the past weekranking · 2026-09-22 · 8×2 The eleven S&P 500 sectors over the past weekranking · 2026-09-22 · 11×2 Biggest stock losers over the past weekranking · 2026-09-22 · 7×3 The major index ETFs over the past weekranking · 2026-09-22 · 4×4 Biggest stock gainers over the past weekranking · 2026-09-22 · 7×3 Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-09-22 · 5×3 Upcoming US stock splits: announced, with a future effective datetable · 2026-09-22 · 30×5 Announced upcoming splits by directionranking · 2026-09-22 · 2×2 Announced stock splits by effective month: forward vs reverseseries · 2026-09-22 · 4×4 Three household payers at their last ex-date: prior close, ex-morning open, and the payment for scaleseries · 2026-09-22 · 3×8 Who goes ex-dividend in the next 14 days: names, cadence and implied yield by size bandtable · 2026-09-22 · 4×5 Names going ex-dividend, day by day: the next seven days of declared recordsseries · 2026-09-22 · 5×5 Ex-dividend dates by calendar month: three-year average, quarterly vs monthly payersseries · 2026-09-22 · 12×4 Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-dateseries · 2026-09-22 · 13×8 Forward-declared ex-dividend records on file: the receipt behind this calendarscalar · 2026-09-22 · 1×53,605 Every mega-cap ex-dividend event of the past six months: price path from the pre-ex closetable · 2026-09-22 · 5×6 Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yieldseries · 2026-09-22 · 12×8 How the whole qualifying universe traded this week, bucketed by relative volumeranking · 2026-09-22 · 7×4 Persistence check: the eight leaders' daily relative volume across the five sessionstable · 2026-09-22 · 8×5 Highest relative volume this week: trailing 5 sessions vs. the prior 40, for names trading $500M+ in the weekseries · 2026-09-22 · 8×6 The board leader, day by day: daily relative volume and open-to-close change (last 15 sessions)series · 2026-09-22 · 15×5 Wild multiples the dollar floor removes: highest relative volume among names trading under $500M this weekseries · 2026-09-22 · 6×5 Market-wide options volume by session, with monthly expirations labelledseries · 2026-09-22 · 25×5 Calls or puts: the board's call and put contract volume on the same sessiontable · 2026-09-22 · 10×5 What follows a heavy options session: next-session absolute move vs. the same names on an ordinary daytable · 2026-09-22 · 5×6 What the session's contracts were made of: options volume by days to expiryranking · 2026-09-22 · 6×4 Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-09-22 · 10×8 Forward and reverse splits by year, US corporate action recordsranking · 2026-09-22 · 11×3 Recent US large-cap splits, restated as an Indian face value cutranking · 2026-09-22 · 5×4 Whole-number split sizes since 2015, and the face value each impliesranking · 2026-09-22 · 8×3 Split-adjusted daily closes across a split effective date (AAPL, 2020)series · 2026-09-22 · 10×2 Squeeze-shaped mechanics: crowded shorts among liquid names, with a rising priceranking · 2026-09-22 · 12×4 The screened names ranked by short interest against shares outstanding (not float)table · 2026-09-22 · 10×5 Every past screened name, by what it did over the next 30 daysranking · 2026-09-22 · 6×3 From the whole settlement file down to the screened list, one rule at a timeranking · 2026-09-22 · 4×2 Every input behind this screen, and how many days old it isseries · 2026-09-22 · 3×3 Liquid names at 5+ and 10+ days to cover, settlement by settlementseries · 2026-09-22 · 12×4 Forward vs reverse splits executed in the last 45 daysranking · 2026-09-22 · 2×2 Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-09-22 · 15×4 Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-09-22 · 15×4 Buy-and-hold SPY: the same rule, scored year by yearranking · 2026-09-22 · 9×2 In-sample rank versus out-of-sample Sharpe, same 24 cellsranking · 2026-09-22 · 24×4 The parameter surface: Sharpe by fast length, one line per slow lengthranking · 2026-09-22 · 6×4 A 24-cell moving-average grid on SPY, ranked by Sharperanking · 2026-09-22 · 24×2 The receipts: universe size, filter bite, median crowding, and list churn at the latest printscalar · 2026-09-22 · 1×522,567 Largest short positions by shares: latest settlement, liquid namesranking · 2026-09-22 · 10×4 Crowding leaders vs. their own price: about one month of sessionsseries · 2026-09-22 · 4×5 GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-09-22 · 10×4 Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-09-22 · 8×4 Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-09-22 · 8×4 Highest days to cover among liquid names: latest settlement on filetable · 2026-09-22 · 10×5 Upcoming US stock market holidays and early closesseries · 2026-09-22 · 12×6 Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-09-22 · 4×3 Regular trading sessions over the trailing yearscalar · 2026-09-22 · 1×3252 The closure calendar ahead, at a glancescalar · 2026-09-22 · 1×610 The twelve biggest 2025 index moves and the reset trade each one requiresseries · 2026-09-22 · 12×6 The final half hour on 2025's largest-move session, against a typical 2025 sessionseries · 2026-09-22 · 31×3 2025 sessions by index move size, and the 3x reset each bucket impliesranking · 2026-09-22 · 5×3 Share of session volume printed in the 4:00 p.m. minute, July to December 2025ranking · 2026-09-22 · 8×4 This calendar year's closures: already passed (counted from the tape) plus still ahead (from the calendar)table · 2026-09-22 · 2×5 SPY across recent weekends and holiday weekends: Friday's close vs. the reopening printseries · 2026-09-22 · 11×6 Every upcoming NYSE closure and early close on the calendar feed, with a countdownseries · 2026-09-22 · 12×6 Unscheduled closures on the tape: zero regular-session bars on an ordinary weekdayseries · 2026-09-22 · 5×4 Market status computed at this page's refresh: weekday check, holiday check, and the ET clockscalar · 2026-09-22 · 1×70 The most recent session on the tape: bar count, same-day SPY options prints, and the last half-day observedscalar · 2026-09-22 · 1×6210 Weekdays in the trailing year when stocks traded but no Treasury yield printedtable · 2026-09-22 · 2×2 SPY, the same measurement: the market's calm benchmarkscalar · 2026-09-22 · 1×311.8 ATM implied volatility across every actively traded underlying, latest sessionscalar · 2026-09-22 · 1×51,038 Highest ATM implied volatility: liquid single names and funds, latest sessiontable · 2026-09-22 · 12×5 Liquid US names going ex-dividend in the next 14 daysranking · 2026-09-22 · 15×4 Declared ex-dividend dates per week, next 12 weeksseries · 2026-09-22 · 12×3 How far ahead dividends were declared, trailing 12 monthsranking · 2026-09-22 · 5×2 One US options symbol, taken apart: busiest SPY contracts on 17 June 2026table · 2026-09-22 · 8×6 Distinct expirations traded per underlying, 17 June 2026ranking · 2026-09-22 · 5×2 SPY option volume by days left to expiry, 17 June 2026ranking · 2026-09-22 · 5×3 What one US equity option contract covers, 17 June 2026ranking · 2026-09-22 · 5×3 Where an average session's share volume lands on the clock, September 1 to 15, 2026series · 2026-09-22 · 64×2 Average trades per session across six exchange-listed funds, August 2026ranking · 2026-09-22 · 6×2 One session of prices in an exchange-listed fund, 30-minute ET bucketsseries · 2026-09-22 · 32×4 How far one exchange-listed fund's price travels within a session, August 2026series · 2026-09-22 · 21×4 Increases against cuts, by week of declaration (complete weeks only)series · 2026-09-22 · 26×4 Payers across their own share split: the raw change against the split-adjusted changeseries · 2026-09-22 · 9×7 Increases, cuts and the typical raise this calendar year, by company size (bands use today's market value)table · 2026-09-22 · 4×6 Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows)series · 2026-09-22 · 11×8 Dividend cuts declared in the last 90 days, the deepest 14 first (one week is too thin for a table)series · 2026-09-22 · 14×6 SPY dividends paid over the past three yearsseries · 2026-09-22 · 12×3 One index ETF's price through a single session, in half-hour ET bucketsseries · 2026-09-22 · 13×3 How far one index ETF travelled inside each recent sessionseries · 2026-09-22 · 29×4 Upcoming market closures that move a fund order's strike dateseries · 2026-09-22 · 12×6 Gap between the last regular-session minute and the official closeranking · 2026-09-22 · 6×4 Aggregate short interest with no holder named: days to cover, household US namesranking · 2026-09-22 · 8×4 What a put costs to hold: premium and daily decay by time to expiry (AAPL, Q3 2025)ranking · 2026-09-22 · 5×3 A minus one fund against its index, month by month (SPY vs SH, 2025)series · 2026-09-22 · 12×4 Barrier touches: intraday high versus closing print, NVDA, Q3 2025table · 2026-09-22 · 10×5 Biggest stock losers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-22 · 10×4 The four major index ETFs this week, for contextranking · 2026-09-22 · 4×2 Biggest stock gainers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-22 · 10×4 The window and the screened universe behind every board on this pagescalar · 2026-09-22 · 1×521 Where every screened company landed: monthly returns by bucketranking · 2026-09-22 · 6×2 Eight household mega-cap names over the same windowranking · 2026-09-22 · 8×2

SELECT
    ticker,
    round(100 * countIf(toUInt64(round(toFloat64(price) * 10000)) % 100 != 0) / count(), 2)       AS subpenny_trade_pct,
    round(100 * sumIf(size, toUInt64(round(toFloat64(price) * 10000)) % 100 != 0) / sum(size), 2) AS subpenny_volume_pct
FROM global_markets.stocks_trades
WHERE ticker IN ('MSFT', 'AAPL', 'NVDA', 'KO', 'BAC', 'T', 'F')
  AND sip_timestamp >= '2026-06-17 14:00:00'
  AND sip_timestamp <  '2026-06-17 14:15:00'
  AND price > 0
GROUP BY ticker
ORDER BY subpenny_trade_pct DESC