Consolidated Holdings

Consolidated Holdings

Sample here

FieldData TypeDescription
history_datedate
parent_usernametext
parent_user_idinteger
child_usernametext
child_display_nametext
child_user_idinteger
custodian_nametext
counterparty_idinteger
security_idinteger
tickertext
security_nametext
ccyaccountidinteger
contract_currencytext
quantitynumeric
latest_price_datedate
latest_price_closenumeric
latest_price_cleannumeric
market_value_usdnumeric
absolute_market_value_usdnumeric
mtm_total_usdnumeric
mtm_price_usdnumeric
mtm_fx_usdnumeric
mtm_accrued_usdnumeric
user_asset_classtext
user_industrytext
user_geographytext
canopy_asset_classtext
partner_asset_classtext
partner_geographytext
credit_ratingtext
em_dmtext
tagsjsonb
market_value_base_ccynumeric
absolute_market_value_base_ccynumeric
mtm_total_base_ccynumeric
mtm_price_base_ccynumeric
mtm_fx_base_ccynumeric
mtm_accrued_base_ccynumeric
base_ccytext
basefx_ratenumeric
history_date_texttext
created_attimestamp without time zone
uuid_keyuuid
canopy_geographytext
partner_industrytext
bb_composite_ratingtext
contract_typetext
latest_price_idinteger
latest_price_source_idinteger
avg_pricenumeric
contract_fx_ratenumeric
market_value_ccynumeric

Did this page help you?