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.
Figma Lockup Expiration: FIG on the Tape
Close versus the last pre-release close, five sessions either sideranking · 2026-10-04 · 11×4Preview: 11 ranked values, smallest first. Relative volume around three Figma lockup releases (session 0 = first sellable session)ranking · 2026-10-04 · 11×4Preview: 11 ranked values, smallest first. Every Figma lockup release date: release-day turnover and the sessions afterranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first. Near-the-money Figma implied volatility around the August 7, 2026 releaseseries · 2026-10-04 · 45×4Preview: a 16-point series, roughly flat. Figma's IPO offering against the shares that changed hands after two releasesranking · 2026-10-04 · 3×2Preview: 3 ranked values, smallest first. Sessions printed per calendar year under this ticker, both listingsranking · 2026-10-04 · 16×4Preview: 16 ranked values, largest first.
Does IPO GMP Predict Listing Gains?
Dispersion of the opening move, by first-session dollar turnoverranking · 2026-10-03 · 4×4Preview: 4 ranked values, largest first. Median listing-day move versus the offer price, by listing yearranking · 2026-10-03 · 10×4Preview: 10 ranked values, smallest first. Median open-to-close move, grouped by the size of the opening moveranking · 2026-10-03 · 5×3Preview: 5 ranked values, largest first. Offer to open, and open to close, on the heaviest-traded recent listing daysranking · 2026-10-03 · 12×3Preview: 12 ranked values, largest first.
What Is GMP in an IPO? Grey Market Premium
Where US listings opened relative to their offer price, 2021 through mid-2026ranking · 2026-10-02 · 6×3Preview: 6 ranked values, smallest first. Median listing-day pop by listing year, US issuesranking · 2026-10-02 · 6×4Preview: 6 ranked values, largest first. The second leg: listing-day move from the opening print to the closetable · 2026-10-02 · 4×5
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.
IPO Quiet Period Rules and Timeline
Days from announced deal to first trade, US listings since January 2025ranking · 2026-08-19 · 7×3Preview: 7 ranked values, largest first. The three clocks, dated, for the largest US listings since January 2025table · 2026-08-19 · 10×7
Japanese IPO Lockups: The 1.5x Release Rule
One US listing traced against a flat line at 1.5x its offer priceseries · 2026-08-07 · 82×3Preview: a 16-point series, roughly flat. Share of US listings trading at 1.5x their offer price, by day since listingranking · 2026-08-07 · 19×2Preview: 16 ranked values, smallest first. US listings clearing 1.5x the offer price on the first close, by listing yearranking · 2026-08-07 · 8×4Preview: 8 ranked values, smallest first.
Do Stocks Fall When a Lockup Expires?
Average daily volume before and after the 180 day mark, 2023-2024 IPOsranking · 2026-08-06 · 6×4Preview: 6 ranked values, smallest first. Short-marked share of reported volume, 30 days either side of the markranking · 2026-08-06 · 6×3Preview: 6 ranked values, largest first. RDDT daily close and volume around its 180 day mark, Aug to Oct 2024series · 2026-08-06 · 53×3Preview: a 16-point series, ending higher. Price change over the 30 days before and after the 180 day markranking · 2026-08-06 · 6×3Preview: 6 ranked values, largest first.
How to Find a Lockup Expiration Date
Weekly average daily volume: Reddit's first year of trading, March 2024 to March 2025series · 2026-08-03 · 53×2Preview: a 16-point series, ending lower. Reddit share volume by window, counted in days from the March 20, 2024 pricing dateranking · 2026-08-03 · 5×3Preview: 5 ranked values, largest first. Day 180 counted from the pricing date: nine US listingsseries · 2026-08-03 · 9×6Preview: a 9-point series, ending higher. Volume in the four weeks around day 180 vs the weeks before it: nine US listingsranking · 2026-08-03 · 9×4Preview: 9 ranked values, largest first.
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.
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 →
$