| Actor | Fragment | Worker | State |
|---|---|---|---|
| 739216 | 58791 | 51 | running |
| 739217 | 58791 | 51 | running |
| 739218 | 58792 | 51 | running |
| 739219 | 58792 | 51 | 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
WHERE
NOT close IS NULL
)
WHERE
rn = 1