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

2,173 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.
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.
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,173 queries →
$