Distributions Feed¶
General Information¶
VertiyData’s Distribution database consists of “J” code transactions made by private equity and venture capital firms to their investors disclosed on Form 4. While there are many other types of insider transactions marked by filers as “Distributions”, they do not typically provide any informational edge for investors, and are not included in our database.
Distributions of stock from private equity firms and venture capital firms to their investors can have wide-ranging effects on a stock’s trade and ownership composition. Such distributions can provide trading opportunities, valuation insights, and other important data points. Distributions are typically made within the first four years of a company going public and they can happen with little warning or fanfare.
We began processing distribution transactions in real-time in December 2025. Our historical data goes back to 2003. Point-in-Time files are available starting December 2025. The point-in-time format allows you to build daily snapshots by ingesting daily delta (inserts/edits) files rather than reprocessing the entire history every day.
Notes on the point-in-time format¶
- Updates to company-related fields (ticker, cusip, company_name, etc.) do not trigger updates in the feed, only updates to event specific fields trigger an update.
- Company-related fields are as of the asof field, not the original insert, meaning values such as ticker, cusip, etc. may change when comparing an initial insert to a later update for the same ipo_id. (e.g. a transaction with ticker "FOO" at insert will show as "BAR" on subsequent updates if the company's ticker changed between the two asof dates. The original insert will always show "FOO", however.)
- Not all fields are available with point-in-time accuracy. Please see the Data Dictionary for more information.
Data Dictionary¶
| Heading | Description |
|---|---|
| ticker | Ticker of the company. Tickers in [square brackets] indicate de-listed or inactive companies. |
| cusip | CUSIP identifier of the company |
| class_status | Denotes the status of the company at the time of last_update. Useful to exclude posthumous edits to inactive companies from your modeling / testing. |
| company_name | Name of the company |
| sector | Sector of the company |
| mcap | [Not Point In Time Data] Market Cap of the company as of the filing date. |
| insider_name | Name of the insider |
| rptcik | SEC assigned unique identifier of the Insider |
| position_type | Position the insider held at the company, at the time of the transaction. Can be the following values “CEO”, “CFO”, “Officer”, Director”, “10% Owner”, or “Other”. |
| age | Age of the insider (calculated by using confirmed birthdate and the grants date). |
| gender | Gender of the insider |
| disclosure_date | The date that the filing was filed at the SEC |
| filed_time | The exact date and time in YYYY-MM-DD hh:mm:ss the filing was filed at the SEC. |
| received_time | The exact time in YYYY-MM-DD hh:mm:ss.ssssss that we received the filing, usually within seconds after file_time above. The date and time listed is generated by our internal servers. This field is NULL for all transactions prior to 2008. NOTE: This field may read earlier than the file_time field as our server time and the SEC's server time are not synced. |
| txn_date | The date of the transaction. If an insider has multiple transactions which have been grouped together in a single transaction, we will show the latest date as the transaction date. |
| code | Transaction Type: at present, always "J" |
| distribution_type | D = Disposition. We only include net disposition transactions. |
| shares | Amount of shares transacted. |
| value | Dollar value of the transaction. |
| avg_pps | The average price per share of the transaction. |
| shares_owned | The number of shares owned by the insider after the transaction. IMPORTANT - this value is often inaccurate and companies disclose this value inconsistently. |
| pct_chg | The percentage change in shares owned. A value of 0 means it is a New position. IMPORTANT - this value is often inaccurate as it is reliant on the shares owned provided in the filing. Companies disclose the shares owned value inconsistently. |
| txnid | Verity's unique numerical id given to each transaction, this should be considered your Primary Key. |
| last_update | The date of the last update for this entry. |
| form4a_update | Returns TRUE if the transaction had been edited or created due to a Form 4/A. A Form 4/A is filed by a company to fix an error or omission in a previously filed Form 4. |
| split_edit | Returns TRUE if the edit was due to a split. |
| edit_action | "U" for update, "D" for delete and "I" for new insert. |
| asof | The date the record appeared in the feed |