| Actor | Fragment | Worker | State |
|---|---|---|---|
| 119844 | 25023 | 26 | running |
| 119845 | 25023 | 26 | running |
| 119846 | 25024 | 26 | running |
| 119847 | 25024 | 26 | 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