STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

SPCX: SpaceX Stock Price Decline From Peak
SPY vs SPCX open-to-close, regular hours, trailing three weeksseries · 2026-10-08 · 14×4Preview: a 14-point series, roughly flat. Stock quote spread and depth by session: the four weeks from listing and the trailing threeseries · 2026-10-08 · 33×5Preview: a 16-point series, ending lower. The arc on one row: issue price, first print, June peak, and the latest closescalar · 2026-10-08 · 1×18150 Options quote spread and size at the touch, the sessions on file in the past week and a halfseries · 2026-10-08 · 5×6Preview: a 5-point series, ending higher. Put/call volume ratio by session, trailing three weeksseries · 2026-10-08 · 15×5Preview: a 15-point series, ending lower. News-feed attention from listing day to the latest reading: counts, concentration, and the trailing weekscalar · 2026-10-08 · 1×14769 Latest complete session, half-hour path: closes, lows, and volumeseries · 2026-10-08 · 13×4Preview: a 13-point series, ending lower. Latest session on file: the busiest SPCX option contracts by volumetable · 2026-10-08 · 10×5 Sessions from listing to the first close below the first print: SPCX vs four recent IPOstable · 2026-10-08 · 5×11 Every SPCX filing in the EDGAR index since the June 12 listing, on one rowscalar · 2026-10-08 · 1×1123 Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listingseries · 2026-10-08 · 80×7Preview: a 16-point series, ending lower.
SpaceX Lockup Expiration Date: How to Find It
Every year the SPCX symbol printed a regular sessionseries · 2026-10-04 · 7×4Preview: a 7-point series, ending higher. SPY volume on monthly expiration Fridays against the month's other sessionsseries · 2026-10-04 · 11×3Preview: a 11-point series, ending lower. SPCX regular sessions since June 2026: closing price and share volumeseries · 2026-10-04 · 78×4Preview: a 16-point series, ending lower. Calendar days against regular trading sessions since the SPCX debutseries · 2026-10-04 · 17×3Preview: a 16-point series, ending higher. Where standard lockup conventions land, counted from the first SPCX sessionseries · 2026-10-04 · 4×5Preview: a 4-point series, ending higher.
Single Stock Futures: CME's New Contracts
Deposit on a $10,000 position: Reg T stock margin versus the security futures floorranking · 2026-09-12 · 4×4Preview: 4 ranked values, largest first. Fair value of a 100 share future at an illustrative $100 spot and 4% financingranking · 2026-09-12 · 5×4Preview: 5 ranked values, smallest first.
How an IPO's Opening Price Is Set
A seasoned ticker's opening auction: QQQ minute volume around 9:30 ET, September 4, 2026series · 2026-09-12 · 5×2Preview: a 5-point series, ending higher. New symbols since June 2026: minutes between the 9:30 bell and the first print, ten heaviest first minutesseries · 2026-09-12 · 10×4Preview: a 10-point series, roughly flat.
SPCX: SpaceX's First Month on the Public Market
The whole SPCX tape in one row: prints, print sizes, and the quote censusscalar · 2026-07-27 · 1×1241.01 Symbol-reuse receipt: thirteen months of SPCX minute bars, May 2026 is absent entirelyseries · 2026-07-27 · 12×5Preview: a 12-point series, ending higher. Where the contracts landed: call and put volume by strike buckettable · 2026-07-27 · 19×5 The seasoning curve: regular-hours spread by session, per-update and time-weightedseries · 2026-07-27 · 12×8Preview: a 12-point series, ending lower. June 30 anchors: a mega-cap, SPCX, and a thin small-cap, same session, same mathtable · 2026-07-27 · 3×6 FINRA off-exchange short volume by session: marked-short share and reported volumeseries · 2026-07-27 · 12×4Preview: a 12-point series, ending higher. The first short-interest print, with the old-entity cliff as its own receiptscalar · 2026-07-27 · 1×923.34 The sessions: regular-hours close, close-over-close change, full-day volumeseries · 2026-07-27 · 12×5Preview: a 12-point series, ending lower. Every SpaceX 8-K filed in June 2026, with the opening lines of eachtable · 2026-07-27 · 6×3 Options session by session: contracts, the call/put split, and the put/call ratioseries · 2026-07-27 · 10×7Preview: a 10-point series, ending lower. What it cost to trade the busiest contract: NBBO spread over its three sessionsseries · 2026-07-27 · 3×6Preview: a 3-point series, ending lower. SpaceX's options market in one row: totals, expiry structure, flagship contractsscalar · 2026-07-27 · 1×2210 The information flow in one row: tagging switches on, feed composition, co-tagsscalar · 2026-07-27 · 1×170 The month on one row: issue to close, with the extremes and their receiptsscalar · 2026-07-27 · 1×22135 Listing day on one row: first quote, opening cross, closing cross, day totalsscalar · 2026-07-27 · 1×142.24 The IPO record: the entity behind SPCX since June 12, 2026scalar · 2026-07-27 · 1×8135 SpaceX's 2026 SEC trail by form type, in filing order (CIK 0001181412, deduped by accession)ranking · 2026-07-27 · 12×4Preview: 12 ranked values, largest first. The whole US tape ranked by June 12–30 regular-hours dollar volumeranking · 2026-07-27 · 12×4Preview: 12 ranked values, largest first. Day one by half hour: quote updates and the median spread finding its levelranking · 2026-07-27 · 13×4Preview: 13 ranked values, smallest first.
SpaceX Joins the Nasdaq-100: The Index-Add Trade
July 6's matched volume by where it printed: the cross, continuous on-exchange, off-exchange (TRF)ranking · 2026-07-09 · 3×4Preview: 3 ranked values, largest first. The morning after: July 7, 2026 through 12:59 p.m. ET (window pinned by design; see data notes)scalar · 2026-07-09 · 1×10210 The add-eve receipts row: checkpoints, the last continuous trade, and the auction print itselfscalar · 2026-07-09 · 1×23165.95 July 6, 2026 in five-minute buckets: the slide, the late climb, and the volume underneathseries · 2026-07-09 · 78×3Preview: a 16-point series, ending lower. Levine's three sessions on our tape: day volume, the closing cross, and the cross's share of the dayseries · 2026-07-09 · 3×7Preview: a 3-point series, roughly flat. Entity receipt: the old SPCX tape ends in April 2026, May is silent, SpaceX lists June 12series · 2026-07-09 · 5×6Preview: a 5-point series, ending higher. Every SPCX closing cross since the June 12 listing: size, share of the day, and the official close it setseries · 2026-07-09 · 15×6Preview: a 15-point series, ending lower.
SPY vs SPCX open-to-close, regular hours, trailing three weeks

SPY vs SPCX open-to-close, regular hours, trailing three weeks

most recentas of series 14×4read in context →
SPY vs SPCX open-to-close, regular hours, trailing three weeks — 14 rows by 4 columns, computed from US exchange, SIP and OPRA data.
session_datesession_labelspy_pctspcx_pct
2026-09-17Sep 17-0.070.64
2026-09-18Sep 180.04-1.18
2026-09-21Sep 210.95-1.87
2026-09-22Sep 22-0.092.01
2026-09-23Sep 23-0.65-3.21
2026-09-24Sep 240.42-0.09
2026-09-25Sep 250.330.24
2026-09-28Sep 28-0.36-2.02
2026-09-29Sep 29-0.341.77
2026-09-30Sep 30-0.521.52
2026-10-01Oct 1-0.04-1.63
2026-10-02Oct 2-0.126.29
2026-10-05Oct 50.687.61
2026-10-06Oct 60.13-0.01
the exact SQL behind every number 
SELECT
    a.session_date AS session_date,
    a.session_label AS session_label,
    round(a.spy_pct, 2) AS spy_pct,
    round(b.spcx_pct, 2) AS spcx_pct
FROM (
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
        formatDateTime(toDate(toTimeZone(window_start, 'America/New_York')), '%b %e') AS session_label,
        (argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS spy_pct
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= now() - INTERVAL 21 DAY AND window_start < now()
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY session_date, session_label
    HAVING count() >= 150
       -- the newest session counts only once it reaches its last half hour
       AND (session_date < (SELECT max(toDate(toTimeZone(window_start, 'America/New_York')))
                    FROM global_markets.delayed_stocks_minute_aggs
                    WHERE ticker = 'SPY'
                      AND window_start >= now() - INTERVAL 10 DAY AND window_start < now()
                      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)
            OR max((toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York')))) >= 930)
) a
INNER JOIN (
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
        (argMax(toFloat64(close), window_start) / argMin(toFloat64(open), window_start) - 1) * 100 AS spcx_pct
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPCX'
      AND window_start >= '2026-06-12 00:00:00'
      AND window_start >= now() - INTERVAL 21 DAY AND window_start < now()
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY session_date
    HAVING count() >= 150
       -- the newest session counts only once it reaches its last half hour
       AND (session_date < (SELECT max(toDate(toTimeZone(window_start, 'America/New_York')))
                    FROM global_markets.delayed_stocks_minute_aggs
                    WHERE ticker = 'SPCX'
                      AND window_start >= now() - INTERVAL 10 DAY AND window_start < now()
                      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)
            OR max((toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York')))) >= 930)
) b ON a.session_date = b.session_date
ORDER BY a.session_date
More from this analysisSPCX: SpaceX Stock Price Decline From Peak
Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listing series 80×7 → Stock quote spread and depth by session: the four weeks from listing and the trailing three series 33×5 → Put/call volume ratio by session, trailing three weeks series 15×5 → Latest complete session, half-hour path: closes, lows, and volume series 13×4 → See all 3,256 queries →
$