| Actor | Fragment | Worker | State |
|---|---|---|---|
| 741071 | 55187 | 51 | running |
| 741072 | 55187 | 51 | running |
| 741073 | 55188 | 51 | running |
| 741074 | 55188 | 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