Columns and types
These columns come from the same versioned logical catalog used by the query validator and engine. They describe the fields you can query. Some historical rows have missing values; fields absent from older shards can return typed NULL.
| accession | VARCHAR |
| rowKind | VARCHAR |
| rowSk | VARCHAR |
| formType | VARCHAR |
| issuerCik | VARCHAR |
| issuerTicker | VARCHAR |
| resolvedTicker | VARCHAR |
| availableAt | TIMESTAMP |
| availabilitySource | VARCHAR |
| securityTitle | VARCHAR |
| transactionDate | DATE |
| deemedExecutionDate | DATE |
| transactionFormType | VARCHAR |
| transactionCode | VARCHAR |
| equitySwapInvolved | BOOLEAN |
| acquiredDisposed | VARCHAR |
| shares | DOUBLE |
| pricePerShare | DOUBLE |
| totalValue | DOUBLE |
| sharesOwnedFollowing | DOUBLE |
| directIndirect | VARCHAR |
| natureOfOwnership | VARCHAR |
| exercisePrice | DOUBLE |
| exerciseDate | DATE |
| expirationDate | DATE |
| underlyingTitle | VARCHAR |
| underlyingShares | DOUBLE |
| rawArchiveKey | VARCHAR |
| sourceUrl | VARCHAR |
No matching rows. Clear the filter to see all records.
Current logical schema for lake.insider_transactions
Coverage and timing
The logical view is backed by canonical manifest-resolved data. Query this name rather than guessing a physical database collection or object-storage path.
`availableAt` is the point-in-time column: filter `availableAt <= as_of`. `transactionDate` is when the trade happened, often days before anyone could know; it is never availability. Join prices and other tables on `resolvedTicker`, never `issuerTicker`. `issuerTicker` is the filer's free text (`NYSE: KRC`, `LEN, LEN.B`, `vicr`, `none`), and 0.8% to 1.6% of rows a year are not a ticker; `resolvedTicker` is that text reduced to one symbol, null when the issuer has no listed symbol. Rows do not repeat per reporting owner. Join to `insider_filings` on `accession` for owner names and roles, and aggregate shares before that join so a joint filing is not counted twice. `transactionCode` is SEC's code: P open-market or private purchase, S open-market or private sale, A grant or award, M option exercise, F tax withholding, G gift. A P row is a purchase signal, not proof that a public-market copy could execute on the same terms. Do not treat A, M or F as buys. `acquiredDisposed` is A (acquired) or D (disposed). `shares` and `pricePerShare` are as reported; `pricePerShare` is 0 for grants. `sourceUrl` is the filing's SEC EDGAR index page, built from `issuerCik` and `accession` as in `insider_filings`.
Run a limited query
Use a registered API key with lake scope. Select needed columns, bind user-supplied values and restrict dates when the table has a time dimension. Query results are durable parts with a schema and manifest rather than an unbounded in-memory array.
This reference documents the schema and its meaning. Run queries in your signed-in workspace; this page does not execute SQL or show private results and datasets.
SELECT "accession", "rowKind", "rowSk"
FROM lake.insider_transactions
LIMIT 20;