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

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.
Market Cap and Which Share Count It Uses
The recovered share count against the filed diluted counttable · 2026-10-04 · 5×6 Dual class tickers and the market cap printed against eachranking · 2026-10-04 · 4×4Preview: 4 ranked values, largest first. Days since the period each filed share count coversranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. Apple's basic and diluted share counts, quarter by quarterseries · 2026-10-04 · 20×4Preview: a 16-point series, ending lower.
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.
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.
Stock Float vs. Shares Outstanding Explained
Shares outstanding across every company with a recent quarterly filing: percentiles, in millions of sharesscalar · 2026-07-26 · 1×66,111 Daily high-low range and dollar volume by shares-outstanding tier: US common stocks, regular-hours sessions, June 11 to July 10, 2026table · 2026-07-26 · 5×5 Share counts from the latest quarterly income statements on record: three megacapstable · 2026-07-26 · 3×5 Medline (MDLN): the 20 sessions before its 180-day mark vs. every session from it, regular-hours volume and daily rangeseries · 2026-07-26 · 2×8Preview: a 2-point series, ending lower. From every H1 2026 US-dollar listing down to the measured setscalar · 2026-07-26 · 1×5184 Eight of H1 2026's biggest measured US IPOs: shares offered vs. shares outstanding at listingtable · 2026-07-26 · 8×5 Float at listing: shares offered as a share of recorded shares outstanding, H1 2026 US IPOs of $100M+scalar · 2026-07-26 · 1×539
IPO Lockup Expiration: Meaning & Release Date
UBER options tape into the Nov 6, 2019 lockup expiry: put and call contract volume by sessionseries · 2026-07-26 · 13×5Preview: a 13-point series, roughly flat. Five famous lockup expirations: expiry-day price change and volume multiple vs. the prior sessionseries · 2026-07-26 · 5×7Preview: a 5-point series, roughly flat. FB daily closes and volume, Oct 22 – Nov 13, 2012: the run-in to the giant lockup expiry (as-traded prices)series · 2026-07-26 · 15×5Preview: a 15-point series, roughly flat. FB from the eve of the Nov 14, 2012 unlock through month-end: did the expiry-day pop hold?series · 2026-07-26 · 13×4Preview: a 13-point series, ending higher.
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
20261342026-01-052026-10-02
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 78×4 → Calendar days against regular trading sessions since the SPCX debut series 17×3 → SPY volume on monthly expiration Fridays against the month's other sessions series 11×3 → Where standard lockup conventions land, counted from the first SPCX session series 4×5 → See all 3,256 queries →
$