Advisor firm changes as registration dates
search_ria_advisor_movesAdvisors who left one firm and registered at another: the person, from and to firms with class, the registration end and begin dates, the gap, and the move type (WIREHOUSE_TO_RIA, IBD_TO_RIA, RIA_TO_RIA, ...). Filter by from firm, to firm, advisor, move type and date window. Bulk corporate re-registrations (an acquirer re-registering a roster on one day, 99,737 rows) are EXCLUDED unless include_bulk; departures with no registered destination are excluded unless include_departures. A move is two dates on IAPD, never a statement about why. Not a prediction of who will move.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| since | No | ISO date; registration ended on or after. | |
| until | No | ISO date. | |
| cursor | No | next_cursor from a previous page of this tool, unchanged. | |
| move_type | No | ||
| to_dfx_id | No | An RIA graph id of the form dfx:ria:<uuid> (from search_ria, resolve_name or search_entities), or the firm's CRD number as a string. | |
| from_dfx_id | No | An RIA graph id of the form dfx:ria:<uuid> (from search_ria, resolve_name or search_entities), or the firm's CRD number as a string. | |
| include_bulk | No | ||
| advisor_dfx_id | No | A dfx:ria: advisor id or an individual CRD. | |
| include_departures | No |