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.
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.
SPCX: The Week It Went Underwater
Print-size anatomy and quote census: full weekscalar · 2026-07-26 · 1×55.52 The symbol's trading history by month: the gap and the new entity's arrivalseries · 2026-07-26 · 12×5Preview: a 12-point series, ending higher. Median quoted spread by session, regular hours (bps of midpoint)series · 2026-07-26 · 5×3Preview: a 5-point series, ending lower. FINRA daily short volume during the week: short shares and their off-exchange shareranking · 2026-07-26 · 4×4Preview: 4 ranked values, largest first. The new entity's short-interest prints to date, with implied days-to-covertable · 2026-07-26 · 2×5 SPCX by session: close, change, shares, dollarsseries · 2026-07-26 · 5×5Preview: a 5-point series, ending lower. SPCX, week of July 6, 2026: the slide, receiptedscalar · 2026-07-26 · 1×14161.86 Rank receipt: the week's dollar volume against every other tickerscalar · 2026-07-26 · 1×311 Options on the new entity, full week: contracts, put-call, busiest contractscalar · 2026-07-26 · 1×43.14 The week's contracts by strike bucket ($20 buckets; tails capped at $80 and $240)table · 2026-07-26 · 9×6 The week's news flow: counts, plus the three storyline receipts, quoted verbatimscalar · 2026-07-26 · 1×951 The week's heaviest tickers by regular-hours dollar volume: where the newcomer now sitsranking · 2026-07-26 · 12×4Preview: 12 ranked values, largest first. Large recent debuts, first month on one ruler: first trade to the day-28 close (ET regular hours)table · 2026-07-26 · 7×8 Every week of the new entity's life: open-to-close return and RTH dollars (entity-bounded)ranking · 2026-07-26 · 5×4Preview: 5 ranked values, largest first.
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 →
$