| Actor | Fragment | Worker | State |
|---|---|---|---|
| 157822 | 17890 | 33 | running |
| 157823 | 17890 | 33 | running |
| 157826 | 17891 | 33 | running |
| 157827 | 17891 | 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