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

2,469 answered market questions

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

Weekly Market Recap: The Week in Numbers
Where the volume went: most dollars traded over the past weekranking · 2026-09-22 · 8×2Preview: 8 ranked values, largest first. The eleven S&P 500 sectors over the past weekranking · 2026-09-22 · 11×2Preview: 11 ranked values, largest first. Biggest stock losers over the past weekranking · 2026-09-22 · 7×3Preview: 7 ranked values, smallest first. The major index ETFs over the past weekranking · 2026-09-22 · 4×4Preview: 4 ranked values, largest first. Biggest stock gainers over the past weekranking · 2026-09-22 · 7×3Preview: 7 ranked values, largest first. Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-09-22 · 5×3Preview: a 5-point series, roughly flat.
Upcoming Stock Splits Calendar
Upcoming US stock splits: announced, with a future effective datetable · 2026-09-22 · 30×5 Announced upcoming splits by directionranking · 2026-09-22 · 2×2Preview: 2 ranked values, largest first. Announced stock splits by effective month: forward vs reverseseries · 2026-09-22 · 4×4Preview: a 4-point series, ending lower.
Upcoming Ex-Dividend Dates: Stocks This Week
Three household payers at their last ex-date: prior close, ex-morning open, and the payment for scaleseries · 2026-09-22 · 3×8Preview: a 3-point series, roughly flat. 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×5Preview: a 5-point series, ending lower. Ex-dividend dates by calendar month: three-year average, quarterly vs monthly payersseries · 2026-09-22 · 12×4Preview: a 12-point series, ending higher. Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-dateseries · 2026-09-22 · 13×8Preview: a 13-point series, roughly flat. 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×8Preview: a 12-point series, ending lower.
Unusual Volume Stocks This Week, Measured
How the whole qualifying universe traded this week, bucketed by relative volumeranking · 2026-09-22 · 7×4Preview: 7 ranked values, smallest first. 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×6Preview: a 8-point series, ending lower. The board leader, day by day: daily relative volume and open-to-close change (last 15 sessions)series · 2026-09-22 · 15×5Preview: a 15-point series, roughly flat. Wild multiples the dollar floor removes: highest relative volume among names trading under $500M this weekseries · 2026-09-22 · 6×5Preview: a 6-point series, ending lower.
Unusual Options Activity: Last Session
Market-wide options volume by session, with monthly expirations labelledseries · 2026-09-22 · 25×5Preview: a 16-point series, ending higher. 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×4Preview: 6 ranked values, largest first. Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-09-22 · 10×8
Stock Splits in India: Face Value Explained
Forward and reverse splits by year, US corporate action recordsranking · 2026-09-22 · 11×3Preview: 11 ranked values, largest first. Recent US large-cap splits, restated as an Indian face value cutranking · 2026-09-22 · 5×4Preview: 5 ranked values, smallest first. Whole-number split sizes since 2015, and the face value each impliesranking · 2026-09-22 · 8×3Preview: 8 ranked values, largest first. Split-adjusted daily closes across a split effective date (AAPL, 2020)series · 2026-09-22 · 10×2Preview: a 10-point series, ending lower.
Short Squeeze Candidates This Week
Squeeze-shaped mechanics: crowded shorts among liquid names, with a rising priceranking · 2026-09-22 · 12×4Preview: 12 ranked values, largest first. 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×3Preview: 6 ranked values, largest first. From the whole settlement file down to the screened list, one rule at a timeranking · 2026-09-22 · 4×2Preview: 4 ranked values, largest first. Every input behind this screen, and how many days old it isseries · 2026-09-22 · 3×3Preview: a 3-point series, ending lower. Liquid names at 5+ and 10+ days to cover, settlement by settlementseries · 2026-09-22 · 12×4Preview: a 12-point series, ending higher.
Recent Stock Splits (Forward and Reverse)
Forward vs reverse splits executed in the last 45 daysranking · 2026-09-22 · 2×2Preview: 2 ranked values, largest first. Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-09-22 · 15×4Preview: 15 ranked values, largest first. Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-09-22 · 15×4Preview: 15 ranked values, smallest first.
The Open-Source TradingView Optimizer
Buy-and-hold SPY: the same rule, scored year by yearranking · 2026-09-22 · 9×2Preview: 9 ranked values, smallest first. In-sample rank versus out-of-sample Sharpe, same 24 cellsranking · 2026-09-22 · 24×4Preview: 16 ranked values, smallest first. The parameter surface: Sharpe by fast length, one line per slow lengthranking · 2026-09-22 · 6×4Preview: 6 ranked values, smallest first. A 24-cell moving-average grid on SPY, ranked by Sharperanking · 2026-09-22 · 24×2Preview: 16 ranked values, largest first.
Most Shorted Stocks Right Now, Measured
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×4Preview: 10 ranked values, largest first. Crowding leaders vs. their own price: about one month of sessionsseries · 2026-09-22 · 4×5Preview: a 4-point series, roughly flat. GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-09-22 · 10×4Preview: a 10-point series, ending lower. Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-09-22 · 8×4Preview: a 8-point series, ending higher. Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-09-22 · 8×4Preview: 8 ranked values, largest first. Highest days to cover among liquid names: latest settlement on filetable · 2026-09-22 · 10×5
Stock Market Holidays 2026–2027: NYSE & Nasdaq
Upcoming US stock market holidays and early closesseries · 2026-09-22 · 12×6Preview: a 12-point series, ending higher. Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-09-22 · 4×3Preview: a 4-point series, roughly flat. Regular trading sessions over the trailing yearscalar · 2026-09-22 · 1×3252 The closure calendar ahead, at a glancescalar · 2026-09-22 · 1×610
Leveraged ETF Rebalancing Into the Close
The twelve biggest 2025 index moves and the reset trade each one requiresseries · 2026-09-22 · 12×6Preview: a 12-point series, ending lower. The final half hour on 2025's largest-move session, against a typical 2025 sessionseries · 2026-09-22 · 31×3Preview: a 16-point series, ending higher. 2025 sessions by index move size, and the 3x reset each bucket impliesranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first. Share of session volume printed in the 4:00 p.m. minute, July to December 2025ranking · 2026-09-22 · 8×4Preview: 8 ranked values, largest first.
Is the Stock Market Open Today?
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×6Preview: a 11-point series, ending higher. Every upcoming NYSE closure and early close on the calendar feed, with a countdownseries · 2026-09-22 · 12×6Preview: a 12-point series, ending higher. Unscheduled closures on the tape: zero regular-session bars on an ordinary weekdayseries · 2026-09-22 · 5×4Preview: a 5-point series, roughly flat. 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
Highest Implied Volatility Stocks Right Now
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
Ex-Dividend Calendar from a Free SQL API
Liquid US names going ex-dividend in the next 14 daysranking · 2026-09-22 · 15×4Preview: 15 ranked values, largest first. Declared ex-dividend dates per week, next 12 weeksseries · 2026-09-22 · 12×3Preview: a 12-point series, ending lower. How far ahead dividends were declared, trailing 12 monthsranking · 2026-09-22 · 5×2Preview: 5 ranked values, smallest first.
Eurex Option Codes: ODAX, ODAP, OESX
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×2Preview: 5 ranked values, largest first. SPY option volume by days left to expiry, 17 June 2026ranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first. What one US equity option contract covers, 17 June 2026ranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first.
Do Mutual Funds Trade in the Primary Market?
Where an average session's share volume lands on the clock, September 1 to 15, 2026series · 2026-09-22 · 64×2Preview: a 16-point series, roughly flat. Average trades per session across six exchange-listed funds, August 2026ranking · 2026-09-22 · 6×2Preview: 6 ranked values, largest first. One session of prices in an exchange-listed fund, 30-minute ET bucketsseries · 2026-09-22 · 32×4Preview: a 16-point series, ending higher. How far one exchange-listed fund's price travels within a session, August 2026series · 2026-09-22 · 21×4Preview: a 16-point series, ending lower.
Dividend Increases & Cuts This Week
Increases against cuts, by week of declaration (complete weeks only)series · 2026-09-22 · 26×4Preview: a 16-point series, ending lower. Payers across their own share split: the raw change against the split-adjusted changeseries · 2026-09-22 · 9×7Preview: a 9-point series, ending lower. 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×8Preview: a 11-point series, ending lower. 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×6Preview: a 14-point series, ending higher.
Covered Calls on Futures: How They Work
SPY dividends paid over the past three yearsseries · 2026-09-22 · 12×3Preview: a 12-point series, roughly flat.
Can You Use a Limit Order on a Mutual Fund?
One index ETF's price through a single session, in half-hour ET bucketsseries · 2026-09-22 · 13×3Preview: a 13-point series, ending higher. How far one index ETF travelled inside each recent sessionseries · 2026-09-22 · 29×4Preview: a 16-point series, roughly flat. Upcoming market closures that move a fund order's strike dateseries · 2026-09-22 · 12×6Preview: a 12-point series, ending higher. Gap between the last regular-session minute and the official closeranking · 2026-09-22 · 6×4Preview: 6 ranked values, largest first.
Can German Retail Investors Short Stocks?
Aggregate short interest with no holder named: days to cover, household US namesranking · 2026-09-22 · 8×4Preview: 8 ranked values, largest first. What a put costs to hold: premium and daily decay by time to expiry (AAPL, Q3 2025)ranking · 2026-09-22 · 5×3Preview: 5 ranked values, smallest first. A minus one fund against its index, month by month (SPY vs SH, 2025)series · 2026-09-22 · 12×4Preview: a 12-point series, ending lower. Barrier touches: intraday high versus closing print, NVDA, Q3 2025table · 2026-09-22 · 10×5
Biggest Stock Gainers and Losers This Week
Biggest stock losers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-22 · 10×4Preview: 10 ranked values, smallest first. The four major index ETFs this week, for contextranking · 2026-09-22 · 4×2Preview: 4 ranked values, largest first. Biggest stock gainers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-22 · 10×4Preview: 10 ranked values, largest first.
Biggest Stock Movers This Month
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×2Preview: 6 ranked values, largest first. Eight household mega-cap names over the same windowranking · 2026-09-22 · 8×2Preview: 8 ranked values, largest first.
page 1 of 25
SPCX regular sessions since June 2026: closing price and share volume

SPCX regular sessions since June 2026: closing price and share volume

as of series 68×4read in context →
SPCX regular sessions since June 2026: closing price and share volume — 68 rows by 4 columns, computed from US exchange, SIP and OPRA data.
session_datesession_labelclose_pricevolume_millions
2026-06-12Jun 12161.29495.62
2026-06-15Jun 15192.42219.64
2026-06-16Jun 16201.99274.54
2026-06-17Jun 17192.2179.34
2026-06-18Jun 18184.97189.3
2026-06-22Jun 22154.59150.66
2026-06-23Jun 23156.06132.1
2026-06-24Jun 24154.4665.05
2026-06-25Jun 25153.0152.39
2026-06-26Jun 26152.7466.57
2026-06-29Jun 2916467.85
2026-06-30Jun 30170.7271.38
2026-07-01Jul 1157.6989.81
2026-07-02Jul 2161.8650.66
2026-07-06Jul 6160.475.82
2026-07-07Jul 7149.5866.16
2026-07-08Jul 8148.3352.31
2026-07-09Jul 9152.1239.78
2026-07-10Jul 10145.438.83
2026-07-13Jul 13139.1965.2
2026-07-14Jul 14136.1241.1
2026-07-15Jul 15135.2854.35
2026-07-16Jul 16131.0250.1
2026-07-17Jul 17123.9274.47
2026-07-20Jul 20119.8650.16
2026-07-21Jul 21123.4672.62
2026-07-22Jul 22115.2781.64
2026-07-23Jul 23118.2866.91
2026-07-24Jul 24115.0749.22
2026-07-27Jul 27113.6557.55
2026-07-28Jul 28116.4673.77
2026-07-29Jul 29112.5947.99
2026-07-30Jul 30112.2649.54
2026-07-31Jul 31108.4447.87
2026-08-03Aug 3114.6561.72
2026-08-04Aug 4125.95102.32
2026-08-05Aug 5108.29177.65
2026-08-06Aug 6114.91195.48
2026-08-07Aug 7133.11218.78
2026-08-10Aug 10138.74146.77
2026-08-11Aug 11133.3699.79
2026-08-12Aug 12146.21155.41
2026-08-13Aug 13141.25107.29
2026-08-14Aug 14139.8488.24
2026-08-17Aug 17146.28107.1
2026-08-18Aug 18143.3374.78
2026-08-19Aug 19139.6666.68
2026-08-20Aug 20133.93108.27
2026-08-21Aug 21136.9171.24
2026-08-24Aug 24135.0453.65
2026-08-25Aug 25137.9646.75
2026-08-26Aug 26139.5754.52
2026-08-27Aug 27140.8750.38
2026-08-28Aug 28141.4651.83
2026-08-31Aug 31143.7451.82
2026-09-01Sep 1142.2548.21
2026-09-02Sep 2140.7244.6
2026-09-03Sep 3149.72114.4
2026-09-04Sep 4147.9943.23
2026-09-08Sep 8153.4678.57
2026-09-09Sep 9147.56109.07
2026-09-10Sep 10148.25108.09
2026-09-11Sep 11151.1572.78
2026-09-14Sep 14148.1360.03
2026-09-15Sep 15143.5266.09
2026-09-16Sep 16150.9102.33
2026-09-17Sep 17154.7975.13
2026-09-18Sep 18152.78105.8
the exact SQL behind every number 
SELECT
    toString(toDate(toTimeZone(window_start, 'America/New_York')))                  AS session_date,
    formatDateTime(toDate(toTimeZone(window_start, 'America/New_York')), '%b %e')   AS session_label,
    round(toFloat64(argMax(close, window_start)), 2)                                AS close_price,
    round(sum(volume) / 1e6, 2)                                                     AS volume_millions
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
  AND window_start >= '2026-06-01'
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
GROUP BY session_date, session_label
ORDER BY session_date
More from this analysisSpaceX Lockup Expiration Date: How to Find It
Calendar days against regular trading sessions since the SPCX debut series 15×3 → SPY volume on monthly expiration Fridays against the month's other sessions series 11×3 → Every year the SPCX symbol printed a regular session series 7×4 → Where standard lockup conventions land, counted from the first SPCX session series 4×5 → See all 2,469 queries →
$