Sample here
| Field | Data Type | Description |
|---|---|---|
| history_date | date | |
| parent_username | text | |
| parent_user_id | integer | |
| child_username | text | |
| child_display_name | text | |
| child_user_id | integer | |
| custodian_name | text | |
| counterparty_id | integer | |
| security_id | integer | |
| ticker | text | |
| security_name | text | |
| ccyaccountid | integer | |
| contract_currency | text | |
| quantity | numeric | |
| latest_price_date | date | |
| latest_price_close | numeric | |
| latest_price_clean | numeric | |
| market_value_usd | numeric | |
| absolute_market_value_usd | numeric | |
| mtm_total_usd | numeric | |
| mtm_price_usd | numeric | |
| mtm_fx_usd | numeric | |
| mtm_accrued_usd | numeric | |
| user_asset_class | text | |
| user_industry | text | |
| user_geography | text | |
| canopy_asset_class | text | |
| partner_asset_class | text | |
| partner_geography | text | |
| credit_rating | text | |
| em_dm | text | |
| tags | jsonb | |
| market_value_base_ccy | numeric | |
| absolute_market_value_base_ccy | numeric | |
| mtm_total_base_ccy | numeric | |
| mtm_price_base_ccy | numeric | |
| mtm_fx_base_ccy | numeric | |
| mtm_accrued_base_ccy | numeric | |
| base_ccy | text | |
| basefx_rate | numeric | |
| history_date_text | text | |
| created_at | timestamp without time zone | |
| uuid_key | uuid | |
| canopy_geography | text | |
| partner_industry | text | |
| bb_composite_rating | text | |
| contract_type | text | |
| latest_price_id | integer | |
| latest_price_source_id | integer | |
| avg_price | numeric | |
| contract_fx_rate | numeric | |
| market_value_ccy | numeric |