CREATE MATERIALIZED VIEW insights.intraday_position_summary_mv AS
SELECT
account_group_id,
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(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(positions_count) AS positions_count,
MAX(change_time) AS change_time
FROM insights.intraday_position_asset_values_mv
GROUP BY
account_group_id,
position_type,
group_currency