Pledged Shares Feed¶
General Information¶
The VerityData Pledged Shares database tracks all shares pledged since 2011.
Point-in-time Data Availability¶
We began processing pledged shares in May 2020. Our historical data goes back to 2011. Point-in-Time files are available starting May 15, 2020.
Additional Point-in-time notes¶
- Updates to company-related fields (ticker, cusip, company_name, etc.) do not trigger updates in the feed, only updates to transaction 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 txnid. (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 Dictionaries¶
| 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 the lastupdate. 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 | [Not Point In Time Data] Position the insider held at the company, at the time of the transaction. |
| age | Age of the insider (calculated by using confirmed birthdate and the grants date). |
| gender | Gender of the insider. |
| formtype | Form-type of the source filing. |
| 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 seconds after the filed_time. 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 filed_time field as our server time and the SEC's server time are not synced. |
| pledged_date | The date the shares were pledged as of. |
| shares_pledged | The number of shares pledged as reported in the filing. If the filing states that the Insider can pledge up to a certain percentage, shares_pledged is based on the maximum percentage. |
| shares_owned | The number of shares owned by the insider as reported in the Proxy. |
| estimated_value | TRUE when the exact amount is not disclosed. |
| is_closed | TRUE when the position is closed. |
| not_listed | TRUE when the Insider was not listed among Principal Shareholders in the Proxy. |
| details | Text details provided. |
| id | Verity's unique numerical id, this should be considered your Primary Key. |
| last_update | The date of the last update for this entry. |
| split_edit | 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. |