| Actor | Fragment | Worker | State |
|---|---|---|---|
| 740355 | 61862 | 51 | running |
| 740356 | 61862 | 51 | running |
| 740357 | 61861 | 51 | running |
| 740358 | 61861 | 51 | running |
| 740361 | 61863 | 51 | running |
| 740362 | 61863 | 51 | running |
| 740363 | 61864 | 51 | running |
| 740364 | 61864 | 51 | running |
| 740365 | 61865 | 51 | running |
| 740366 | 61865 | 51 | running |
| 740367 | 61866 | 51 | running |
| 740368 | 61866 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.report_holdings_daily_mv AS SELECT pag.portfolio_id, pag.type AS account_group_type, a.dim_balance_date, a.asset_id, ast.name_en AS asset_name_en, ast.name_ar AS asset_name_ar, ast.type AS asset_type, ast.ticker, ast.isin, a.asset_currency, a.currency_code, a.market_value, a.total_average_cost, a.fair_value, a.accrued_value, a.market_value_system_currency, a.fair_value_system_currency, a.market_value_asset_currency, a.fair_value_asset_currency, a.total_average_cost_asset_currency, a.quantity, a.weight, a.fair_value_weight, pxl.adjusted_last_close_price AS unit_price FROM insights.portfolio_to_account_groups_mv AS pag JOIN insights.position_by_asset_mv AS a ON a.account_group_id = pag.account_group_id AND a.position_type = 'POSITION' AND a.source_entity_type = 'portfolio' LEFT JOIN asset_service.assets_dm AS ast ON ast.id = a.asset_id LEFT JOIN insights.asset_price_with_lag_mv AS pxl ON pxl.asset_id = a.asset_id AND pxl.fact_date = a.dim_balance_date