| Actor | Fragment | Worker | State |
|---|---|---|---|
| 53697 | 2507 | 3 | running |
| 53698 | 2507 | 3 | running |
CREATE MATERIALIZED VIEW adib_rm.asset_latest_price_mv AS
SELECT
asset_id,
adjusted_last_close_price AS price,
fact_date AS price_date,
CASE
WHEN prev_price IS NULL OR prev_price = 0
THEN NULL
ELSE (
adjusted_last_close_price - prev_price
) / prev_price * 100
END AS price_change_pct_1d
FROM (
SELECT
asset_id,
fact_date,
adjusted_last_close_price,
prev_price,
ROW_NUMBER() OVER (PARTITION BY asset_id ORDER BY fact_date DESC) AS rn
FROM adib_rm.asset_price_with_lag_mv
) AS ranked
WHERE
rn = 1