CREATE MATERIALIZED VIEW insights.intraday_position_asset_values_mv AS
SELECT
account_group_id,
asset_id,
group_currency,
position_type,
SUM(market_value_group) AS market_value,
SUM(average_cost_group) AS average_cost,
SUM(fair_value_group) AS fair_value,
SUM(accrued_value_group) AS accrued_value,
SUM(market_value_system) AS market_value_system,
SUM(average_cost_system) AS average_cost_system,
SUM(fair_value_system) AS fair_value_system,
SUM(accrued_value_system) AS accrued_value_system,
SUM(market_value_asset) AS market_value_asset,
SUM(average_cost_asset) AS average_cost_asset,
SUM(fair_value_asset) AS fair_value_asset,
SUM(purchased_quantity) AS quantity,
COUNT(*) AS positions_count,
MAX(change_time) AS change_time
FROM insights.intraday_position_values_mv
GROUP BY
account_group_id,
asset_id,
group_currency,
position_type