| Actor | Fragment | Worker | State |
|---|---|---|---|
| 32853 | 11078 | 33 | running |
| 32854 | 11078 | 33 | running |
| 32866 | 11079 | 33 | running |
| 32867 | 11079 | 33 | running |
CREATE MATERIALIZED VIEW insights.asset_latest_yield_to_maturity_mv AS
SELECT
asset_id,
as_of_date,
yield_to_maturity
FROM (
SELECT
asset_id,
as_of_date,
yield_to_maturity,
ROW_NUMBER() OVER (PARTITION BY asset_id ORDER BY as_of_date DESC, provider_code ASC) AS rn
FROM asset_service.asset_snapshots_ft
WHERE
NOT yield_to_maturity IS NULL
) AS ranked
WHERE
rn = 1