CREATE MATERIALIZED VIEW insights.position_summary_mv AS
SELECT
account_group_id,
source_entity_type,
dim_value_date AS dim_balance_date,
position_type,
group_currency AS currency_code,
SUM(market_value) AS market_value,
SUM(average_cost) AS total_average_cost,
SUM(fair_value) AS fair_value,
SUM(accrued_value) AS accrued_value,
SUM(relationship_value) AS relationship_value,
SUM(fair_relationship_value) AS fair_relationship_value,
SUM(market_value_system) AS market_value_system_currency,
SUM(average_cost_system) AS total_average_cost_system_currency,
SUM(fair_value_system) AS fair_value_system_currency,
SUM(accrued_value_system) AS accrued_value_system_currency,
SUM(relationship_value_system) AS relationship_value_system_currency,
SUM(fair_relationship_value_system) AS fair_relationship_value_system_currency
FROM insights.position_asset_values_mv AS position_asset_values_mv_next
GROUP BY
account_group_id,
source_entity_type,
dim_value_date,
position_type,
group_currency