| Actor | Fragment | Worker | State |
|---|---|---|---|
| 736564 | 56643 | 51 | running |
| 736565 | 56643 | 51 | running |
| 736580 | 56644 | 51 | running |
| 736581 | 56644 | 51 | running |
| 736590 | 56645 | 51 | running |
| 736591 | 56645 | 51 | running |
| 736592 | 56646 | 51 | running |
| 736593 | 56646 | 51 | running |
| 736594 | 56647 | 51 | running |
| 736595 | 56647 | 51 | running |
CREATE MATERIALIZED VIEW insights.benchmark_twrr_by_currency_mv WITH ( backfill_order=FIXED(asset_service.assets_dm -> insights.benchmark_twrr_by_asset_mv) ) AS SELECT b.benchmark_id, b.fact_date, ad.issue_currency_code AS currency_code, SUM(b.daily_subperiod_return) AS daily_subperiod_return FROM insights.benchmark_twrr_by_asset_mv AS b JOIN asset_service.assets_dm AS ad ON ad.id = b.asset_id WHERE NOT ad.issue_currency_code IS NULL GROUP BY b.benchmark_id, b.fact_date, ad.issue_currency_code