This table contains a daily snapshot of all holdings of a particular customer or customers

Column	Data Type	Description	Additional Links
history_date	date	individual working days
parent_username	text	parent account name
child_username	text	child account code name
child_display_name	text	child account display name
custodian_name	text	name of custodian
security_id	integer
ticker	text
security_name	text
ccyaccountid	integer
contract_currency	text	currency of contract
quantity	numeric	quantity of holding
latest_price_date	date	latest available price date
latest_price_close	numeric	latest available close price
latest_price_clean	numeric	latest available clean price
market_value_usd	numeric	market value in usd
absolute_market_value_usd	numeric	absolute market value in usd
mtm_total_usd	numeric	total marked to market usd
mtm_price_usd	numeric	marked to market usd due to price change
mtm_fx_usd	numeric	marked to market usd due to FX
mtm_accrued_usd	numeric	marked to market usd due to accrued interest
user_asset_class	text	user defined asset class
user_geography	text	user defined geography
canopy_asset_class	text	canopy defined asset class	https://mesitis.atlassian.net/wiki/spaces/HOW/pages/368836759/Canopy+Asset+Classes
credit_rating	null	not in use
em_dm	null	not in use
tags	jsonb	not in use
market_value_base_ccy	numeric	market value in base currency
absolute_market_value_base_ccy	numeric	absolute market value in base currency
mtm_total_base_ccy	numeric	Profit of the transaction (Market Value - Entry Value) Market Value - Settlement Amount (Gross Amount for TransferfOP)
mtm_price_base_ccy	numeric	The change in MTM only attributable to price movement (prices.close - blotters.trade_price)* flashblotters.quantity
mtm_fx_base_ccy	numeric	The change in MTM only attributable to FX movement Total - Price - Accrued
mtm_accrued_base_ccy	numeric	The change in MTM only attributable to accrued interest (prices.close - prices.clean) - (blotters.trade_date_dirty_px - blotters.trade_price) * flashblotters.quantity
base_ccy	text	account base currency
basefx_rate	numeric	account base fx rate against USD
created_at	date
user_industry
partner_asset_class
partner_geography
uuid_key

Browser not supported