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

2,170 answered market questions

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

SpaceX Lockup Expiration Date: How to Find It
Every year the SPCX symbol printed a regular sessionseries · 2026-08-22 · 7×4Preview: a 7-point series, ending higher. SPY volume on monthly expiration Fridays against the month's other sessionsseries · 2026-08-22 · 11×3Preview: a 11-point series, ending lower. SPCX regular sessions since June 2026: closing price and share volumeseries · 2026-08-22 · 49×4Preview: a 16-point series, ending lower. Calendar days against regular trading sessions since the SPCX debutseries · 2026-08-22 · 11×3Preview: a 11-point series, ending higher. Where standard lockup conventions land, counted from the first SPCX sessionseries · 2026-08-22 · 4×5Preview: a 4-point series, ending higher.
SPCX: SpaceX Stock Price Decline From Peak
SPY vs SPCX open-to-close, regular hours, trailing three weeksseries · 2026-08-20 · 15×4Preview: a 15-point series, roughly flat. Stock quote spread and depth by session: the four weeks from listing and the trailing threeseries · 2026-08-20 · 33×5Preview: a 16-point series, ending lower. The arc on one row: issue price, first print, June peak, and the latest closescalar · 2026-08-20 · 1×15150 Options quote spread and size at the touch, the sessions on file in the past week and a halfseries · 2026-08-20 · 4×6Preview: a 4-point series, roughly flat. Put/call volume ratio by session, trailing three weeksseries · 2026-08-20 · 15×5Preview: a 15-point series, roughly flat. News-feed attention from listing day to the latest reading: counts, concentration, and the trailing weekscalar · 2026-08-20 · 1×14627 Latest complete session, half-hour path: closes, lows, and volumeseries · 2026-08-20 · 7×4Preview: a 7-point series, ending higher. Latest session on file: the busiest SPCX option contracts by volumetable · 2026-08-20 · 10×5 Sessions from listing to the first close below the first print: SPCX vs four recent IPOstable · 2026-08-20 · 5×11 Every SPCX filing in the EDGAR index since the June 12 listing, on one rowscalar · 2026-08-20 · 1×1119 Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listingseries · 2026-08-20 · 47×7Preview: a 16-point series, ending lower.
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.
Every year the SPCX symbol printed a regular session

Every year the SPCX symbol printed a regular session

most recentas of series 7×4read in context →
Every year the SPCX symbol printed a regular session — 7 rows by 4 columns, computed from US exchange, SIP and OPRA data.
yearsessionsfirst_sessionlast_session
2020112020-12-162020-12-31
20212522021-01-042021-12-31
20222502022-01-032022-12-30
20232332023-01-032023-12-29
20242282024-01-022024-12-31
20252032025-01-022025-12-31
20261052026-01-052026-08-21
the exact SQL behind every number 
SELECT
    toString(toYear(d))  AS year,
    count()              AS sessions,
    toString(min(d))     AS first_session,
    toString(max(d))     AS last_session
FROM
(
    SELECT DISTINCT toDate(toTimeZone(window_start, 'America/New_York')) AS d
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPCX'
      AND window_start >= '2015-01-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 year
ORDER BY year
More from this analysisSpaceX Lockup Expiration Date: How to Find It
SPCX regular sessions since June 2026: closing price and share volume series 49×4 → SPY volume on monthly expiration Fridays against the month's other sessions series 11×3 → Calendar days against regular trading sessions since the SPCX debut series 11×3 → Where standard lockup conventions land, counted from the first SPCX session series 4×5 → See all 2,170 queries →
$