form4_timing
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-10-02, from china-dragon-tiger-list.
| month | month_pretty | within_two_days_pct | filing_count |
|---|---|---|---|
| 2025-08-01 | Aug 2025 | 60.6 | 97812 |
| 2025-09-01 | Sep 2025 | 65.1 | 92544 |
| 2025-10-01 | Oct 2025 | 79.9 | 84840 |
| 2025-11-01 | Nov 2025 | 60.5 | 88842 |
| 2025-12-01 | Dec 2025 | 64.9 | 102321 |
| 2026-01-01 | Jan 2026 | 49.7 | 97473 |
| 2026-02-01 | Feb 2026 | 62 | 167529 |
| 2026-03-01 | Mar 2026 | 66.8 | 182976 |
| 2026-04-01 | Apr 2026 | 75.6 | 97026 |
| 2026-05-01 | May 2026 | 60.1 | 135270 |
| 2026-06-01 | Jun 2026 | 62.9 | 147738 |
| 2026-07-01 | Jul 2026 | 70.5 | 27508 |
| 2026-08-01 | Aug 2026 | 62.4 | 36022 |
| 2026-09-01 | Sep 2026 | 67.8 | 31001 |
- Rows × columns
- 14 × 4
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
month |
date | 2025-08-01 to 2026-09-01 | |
month_pretty |
text | 14 distinct values (Apr 2026, Aug 2025, Aug 2026…) | |
within_two_days_pct |
number | 49.7 to 79.9 | percent |
filing_count |
number | 27,508 to 182,976 | count |
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.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
SELECT
toString(toStartOfMonth(filing_date)) AS month,
formatDateTime(toStartOfMonth(filing_date), '%b %Y') AS month_pretty,
round(100 * countIf(lag_days <= 2) / count(), 1) AS within_two_days_pct,
count() AS filing_count
FROM
(
SELECT
filing_date,
dateDiff('day', transaction_date, filing_date) AS lag_days
FROM global_markets.stocks_form4
WHERE filing_date >= toStartOfMonth(today() - 400)
AND filing_date < toStartOfMonth(today())
AND dateDiff('day', transaction_date, filing_date) BETWEEN 0 AND 180
)
GROUP BY month, month_pretty
ORDER BY month
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.