| Actor | Fragment | Worker | State |
|---|---|---|---|
| 33325 | 12222 | 33 | running |
| 33326 | 12222 | 33 | running |
| 33331 | 12223 | 33 | running |
| 33332 | 12223 | 33 | running |
CREATE MATERIALIZED VIEW insights.asset_prices_snapshot_mv AS
SELECT
asset_id,
close,
CAST(date AS TIMESTAMPTZ) AS value_timestamp
FROM (
SELECT
asset_id,
close,
date,
ROW_NUMBER() OVER (PARTITION BY asset_id ORDER BY date DESC) AS rn
FROM asset_service.asset_prices_eod_ft AS asset_prices_eod_ft_next
WHERE
NOT close IS NULL
)
WHERE
rn = 1