Documentation
Data model
The trades view
Query the trades view, not the raw senate_trades / house_trades tables. It unions both chambers and resolves three bugs a raw query would otherwise hit.
| Column | What it fixes |
|---|---|
chamber | 'S' / 'H', union of both raw tables |
tkr | coalesce(ticker, ticker_guess). Includes tickers recovered from free text |
txn_date / filed_date | Real DATE columns, not MM/DD/YYYY text that sorts lexically wrong |
tkr_recovered | Flags rows whose ticker came from inference, not the filing itself |
Two dates matter differently: txn_date is when the trade happened; filed_date is when the public could first have known about it. Signal analysis should key off filed_date. Building on txn_date bakes in look-ahead bias. amount_low / amount_high are a disclosure bracket, not a price. The STOCK Act only requires a dollar range, never an exact figure.
Prev: API reference
Next: Scheduling