| Actor | Fragment | Worker | State |
|---|---|---|---|
| 742111 | 62434 | 51 | running |
| 742112 | 62434 | 51 | running |
| 742123 | 62435 | 51 | running |
| 742124 | 62435 | 51 | 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