STRASMORE/EXPLORE 2,170 QUERIES

Every SPCX filing in the EDGAR index since the June 12 listing, on one row

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-20, from SPCX: SpaceX Stock Price Decline From Peak.

as of scalar 1×11read in context →
total filings
19
form4 filings
1
form3 filings
1
eightk filings
8
other filings
9
first form4 label
Jun 17, 2026
first form4 month
6
first form4 dom
17
last filing label
Aug 14, 2026
days since last filing
6
filings since peak
15
Rows × columns
1 × 11
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Every SPCX filing in the EDGAR index since the June 12 listing, on one row, derived from the stored result.
ColumnTypeRangeNotes
total_filings number every row is 19
form4_filings number every row is 1
form3_filings number every row is 1
eightk_filings number every row is 8
other_filings number every row is 9
first_form4_label text 1 distinct value (Jun 17, 2026)
first_form4_month number every row is 6
first_form4_dom number every row is 17
last_filing_label text 1 distinct value (Aug 14, 2026)
days_since_last_filing number every row is 6
filings_since_peak number every row is 15

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number 
SELECT
    count() AS total_filings,
    countIf(form_type = '4') AS form4_filings,
    countIf(form_type = '3') AS form3_filings,
    countIf(form_type = '8-K') AS eightk_filings,
    countIf(form_type NOT IN ('4', '3', '8-K')) AS other_filings,
    formatDateTime(minIf(filing_date, form_type = '4'), '%b %e, %Y') AS first_form4_label,
    toMonth(minIf(filing_date, form_type = '4')) AS first_form4_month,
    toDayOfMonth(minIf(filing_date, form_type = '4')) AS first_form4_dom,
    formatDateTime(max(filing_date), '%b %e, %Y') AS last_filing_label,
    toInt32(today() - max(filing_date)) AS days_since_last_filing,
    countIf(filing_date > toDate('2026-06-16')) AS filings_since_peak
FROM global_markets.stocks_sec_edgar_index
WHERE ticker = 'SPCX'
  AND filing_date >= toDate('2026-06-12') AND filing_date <= today()

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisSPCX: SpaceX Stock Price Decline From Peak
The arc on one row: issue price, first print, June peak, and the latest close scalar 1×15 → News-feed attention from listing day to the latest reading: counts, concentration, and the trailing week scalar 1×14 → Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listing series 47×7 → Stock quote spread and depth by session: the four weeks from listing and the trailing three series 33×5 → SPY vs SPCX open-to-close, regular hours, trailing three weeks series 15×4 → Put/call volume ratio by session, trailing three weeks series 15×5 → See all 2,170 queries →