| Actor | Fragment | Worker | State |
|---|---|---|---|
| 743017 | 62541 | 51 | running |
| 743018 | 62541 | 51 | running |
| 743019 | 62542 | 51 | running |
| 743020 | 62542 | 51 | running |
| 743029 | 62538 | 51 | running |
| 743030 | 62538 | 51 | running |
| 743033 | 62539 | 51 | running |
| 743034 | 62539 | 51 | running |
| 743035 | 62540 | 51 | running |
| 743036 | 62540 | 51 | running |
CREATE MATERIALIZED VIEW insights.benchmark_twrr_mv AS
SELECT
benchmark_id,
fact_date,
(
amount - prev_amount
) / prev_amount AS daily_subperiod_return
FROM (
SELECT
v.benchmark_id,
v.date AS fact_date,
v.amount,
LAG(v.amount) OVER (PARTITION BY v.benchmark_id ORDER BY v.date) AS prev_amount
FROM asset_service.benchmark_values_ft AS v
JOIN asset_service.benchmarks_dm AS b
ON b.id = v.benchmark_id
WHERE
b.disabled_at IS NULL
) AS sub
WHERE
NOT prev_amount IS NULL AND prev_amount <> 0