Ready-to-query database
Open the packaged database and query a convenience view without importing the 1.5 GB CSV.
SELECT *
FROM open_market_purchases
ORDER BY "Date" DESC
LIMIT 20;A one-time SEC Form 4 research package with 1.63M publishable rows, CSV/Parquet/DuckDB delivery, a free 10,000-row sample and commercial-license contact for team or product use.
Founding buyer price
Regular price $199
Evaluate before purchase
The free sample uses deterministic positions from a versioned schema 2.0.0 release. No email gate, no synthetic rows and no hidden columns. The ZIP includes a manifest, methodology note and SHA-256 checksums.
Product proof
Open the packaged database and query a convenience view without importing the 1.5 GB CSV.
SELECT *
FROM open_market_purchases
ORDER BY "Date" DESC
LIMIT 20;Start from a Jupyter workflow, reusable SQL and documented views for purchases, sales and cluster analysis.
Inspect the 64-field contractSee the type of event studies the release supports before buying the complete research package.
Research contract
The export is deliberately more than a list of names and transaction values. Canonical identity fields make SEC rows auditable; quality columns describe how each row entered the publishable set; derived columns expose the exact enrichment used in the product.
Interactive schema preview
Switch between source, lineage, quality and enrichment groups. Every field exposes its type, origin, nullability and a representative value; examples describe the schema and are not a live customer record.
Stable compatibility fields available in API transaction responses and the bulk release.
| Field | Type | Origin | Example |
|---|---|---|---|
idStable internal transaction identifier. | integerRequired | SEC / legacy source | 1568928 |
FormLegacy-compatible display label for the filing form. | stringRequired | SEC / legacy source | Form 4 |
TickerNormalized uppercase issuer ticker. | stringRequired | SEC / legacy source | AAPL |
ExecutiveReporting-owner name as stored by the transaction pipeline. | stringRequired | SEC / legacy source | DOE JOHN |
PositionReported relationship or officer title before standardized role enrichment. | stringNullable | SEC / legacy source | Chief Financial Officer |
DateTransaction date. This is not necessarily the filing or acceptance date. | dateRequired | SEC / legacy source | 2026-07-23 |
TypeSEC transaction code such as P, S, A, M, F or G. | stringRequired | SEC / legacy source | P |
SharesNumber of securities reported in the transaction. | numberRequired | SEC / legacy source | 500 |
PriceReported per-security transaction price. Zero can be valid for grants and other technical events. | numberRequired | SEC / legacy source | 202.45 |
Total_ValueLegacy-compatible nominal value stored with the transaction. | numberRequired | SEC / legacy source | 101225.00 |
NotesFootnote or explanatory filing text when available. | stringNullable | SEC / legacy source | Shares sold pursuant to a Rule 10b5-1 plan. |
Reproducible starting points
These queries run against the packaged DuckDB database and use the included convenience views. Copy them as a starting point, then inspect the methodology before interpreting any result as a signal.
Rank issuers with at least three distinct Code P buyers in the trailing 90 days.
SELECT
"Ticker",
COUNT(*) AS purchases,
COUNT(DISTINCT "Executive") AS distinct_buyers,
SUM(calculated_total_value) AS disclosed_value
FROM open_market_purchases
WHERE "Date" >= CURRENT_DATE - INTERVAL 90 DAY
GROUP BY "Ticker"
HAVING COUNT(DISTINCT "Executive") >= 3
ORDER BY distinct_buyers DESC, disclosed_value DESC
LIMIT 50;Build a role cohort using calculated 30-day security outcomes and a minimum sample size.
SELECT
standard_role,
COUNT(*) AS purchases,
MEDIAN(market_return_30d) AS median_market_return_30d
FROM open_market_purchases
WHERE return_status_30d = 'calculated'
GROUP BY standard_role
HAVING COUNT(*) >= 30
ORDER BY purchases DESC;Measure the exact mix of canonical SEC rows and validated historical records in the release.
SELECT
validation_status,
source_verification_status,
COUNT(*) AS rows,
ROUND(100.0 * COUNT(*) / SUM(COUNT(*)) OVER (), 2) AS share_pct
FROM transactions
GROUP BY validation_status, source_verification_status
ORDER BY rows DESC;Validate the workflow
Import the free sample, inspect column types and confirm how identifiers, null values and transaction codes behave in your own stack.
Current release
SEC verified · 49.4%
Canonical Form 4/4-A transactions identified by accession, transaction table and sequence.
Validated legacy · 50.6%
Historical rows retained after deterministic quality rules; their status remains visible instead of being presented as canonical SEC parses.
Only current rows in sec_verified or validated_legacy state enter the commercial release.
Canonical rows preserve accession, filing date, table and transaction sequence when available.
Roles, clusters and price outcomes expose their algorithm or source version in the schema.
Applications
Screen purchase clusters, compare executive cohorts and build auditable event-study inputs without maintaining a Form 4 parser.
Test transaction code, role, ownership and post-transaction outcomes from a local DuckDB or Parquet workflow.
Prototype screens and internal tools with the bulk release, then move recurring targeted queries to the documented API.
Teach or reproduce financial-data research from a versioned export with lineage, quality states and explicit limitations.
Choose the delivery model
The products solve different jobs. Use the sample to validate fit, the complete release for exhaustive local research, and the API for targeted application requests.
Evaluate
Validate the schema and import workflow with a deterministic subset.
Best for
Schema review and technical evaluation
Research
Run full-history research locally from one versioned snapshot.
Founding buyer price · one-time payment · regular $199
Best for
Backtests, joins, event studies and academic work
Integrate
Request targeted JSON from applications and recurring workflows.
Best for
Fintech products, dashboards and operational queries
Dataset checkout terms are controlled by Gumroad. API pricing, quotas, overages and renewal terms are controlled by the plan displayed on RapidAPI at the time you subscribe.
Buyer package
Every format is generated from the same validated release and checked against the same row count. Choose the workflow that fits your research environment.
Portable UTF-8 source export for databases, scripts and archival workflows.
Compressed columnar data for fast analytical scans in DuckDB, Polars, pandas and Spark.
A local database with the full table and convenience views for purchases, sales and clusters.
A guided Jupyter analysis, reusable SQL, 64-field dictionary, methodology and integrity checks.
Release history
2026-07-29 UTC · 1,633,946 rows
This is the first commercially documented release in the public changelog. Future releases are listed here only after their manifests are generated; purchase does not imply future updates unless the checkout explicitly includes them.
Founding customer offer
API access, manually activated after purchase.
Requests per calendar month for evaluation and internal research.
Allocate them 3, 2 + 1, or 1 + 1 + 1 across candidate features.
Roadmap votes are advisory and influence prioritization; they do not guarantee implementation or timing. API access is non-transferable, subject to fair use and available while this founding offer is displayed.
Methodology guardrails
Open-market flow treats code P as purchase and code S as sale. Awards, options, gifts and tax withholdings remain available but are not interchangeable directional signals.
Cluster counts use distinct reporting owners with code P in inclusive 7, 30 and 90 calendar-day windows. A cluster flag requires at least three owners in the 30-day window.
Market outcomes measure the security's price change from the transaction-date close. They are not benchmark adjusted and do not establish causation or predict future performance.
Buyer questions
The same versioned research snapshot in CSV, compressed Parquet and ready-to-query DuckDB formats, containing 1,633,946 publishable transactions and 64 documented columns. It also includes a Jupyter quickstart, reusable SQL, an offline data dictionary, methodology, license summary, release manifest and SHA-256 checksums.
Yes. The free evaluation archive contains 10,000 real rows and all 64 columns from a schema 2.0.0 release snapshot. Rows are selected at deterministic, evenly spaced positions across that release. The archive also includes its methodology, manifest and checksums.
The archive contains only CSV, JSON and TXT files—no executable files, scripts, macros or spreadsheet workbooks. Its build validates the ZIP structure and rejects cells that look like spreadsheet formulas. A published SHA-256 checksum lets you verify that the download was not altered. No download can carry an absolute zero-risk guarantee, so use your normal endpoint-security controls.
No. They are descriptive post-transaction price outcomes. Market returns use the security close around the transaction date and do not subtract SPY or another benchmark. Insider-basis returns use the reported transaction price when available.
No. SEC records and historical sources vary. Missing values remain null rather than being invented. Current release coverage is published below and the dictionary states when each field can be absent.
The 1.5 GB CSV exceeds the practical row and memory limits of ordinary spreadsheets. The included DuckDB and Parquet files are designed to make the complete release usable without loading it into Excel or into memory.
While the offer is displayed, a verified buyer can request three months of API access with up to 5,000 requests per calendar month and receives three Founding Customer Roadmap Vote points. Activation is manual through client@insider-alpha.com. Votes influence prioritization but do not guarantee implementation or delivery dates.
The checkout listing controls the exact update entitlement. The standard research license does not permit resale, public redistribution or embedding the raw dataset in another commercial data product. Contact us for commercial licensing.
Every release records its schema version, generation timestamp, row count and checksum. The current SHA-256 begins 002f598df06855ee….
Generated 2026-07-29T21:18:38.313847Z. Research data may contain issuer-reported errors, amendments, null fields and corporate-action edge cases; review the documented limitations before production use.
The sample contains exactly one CSV, one JSON manifest and two TXT documents. No executables, scripts, macros or workbooks.
Generation verifies 64 columns, row counts, archive CRC and rejects values that look like spreadsheet formulas.
Confirm the downloaded artifact against its public SHA-256:
850f007868b1c3200f76c986dee8f3013efdff1269a3b3573716aed233a1f0d7