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.
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.
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 →
$