| Actor | Fragment | Worker | State |
|---|---|---|---|
| 54010 | 2413 | 3 | running |
| 54011 | 2413 | 3 | running |
| 54020 | 2414 | 3 | running |
| 54021 | 2414 | 3 | running |
CREATE MATERIALIZED VIEW insights.benchmark_twrr_mv AS
SELECT
benchmark_id,
fact_date,
(
value - prev_value
) / prev_value AS daily_subperiod_return
FROM (
SELECT
benchmark_id,
fact_date,
value,
LAG(value) OVER (PARTITION BY benchmark_id ORDER BY fact_date) AS prev_value
FROM olap.benchmark_values_ft
WHERE
disabled_at IS NULL
) AS sub
WHERE
NOT prev_value IS NULL AND prev_value <> 0