| Actor | Fragment | Worker | State |
|---|---|---|---|
| 53862 | 2356 | 3 | running |
| 53863 | 2356 | 3 | running |
| 53864 | 2357 | 3 | running |
| 53865 | 2357 | 3 | running |
CREATE MATERIALIZED VIEW insights.asset_twrr_mv AS
SELECT
asset_id,
fact_date,
(
adjusted_last_close_price - prev_price
) / prev_price AS daily_subperiod_return
FROM (
SELECT
asset_id,
fact_date,
adjusted_last_close_price,
LAG(adjusted_last_close_price) OVER (PARTITION BY asset_id ORDER BY fact_date) AS prev_price
FROM olap.asset_adjusted_prices_ft
) AS sub
WHERE
NOT prev_price IS NULL AND prev_price <> 0