RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

← cluster insights objects asset_twrr_mv
Overview Objects Graph History
materialized view · insights.asset_twrr_mv Explain plan ▶
Parallelism
2
Actors
2 / 2
running
Distribution
HASH
Rows
577,836
State size
38.6 MiB
Created
2026-08-21 06:28
Initialized
2026-08-21 06:27
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
158316 17985 33 running
158317 17985 33 running
sql · insights.asset_twrr_mv — click to expand 
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 insights.asset_price_with_lag_mv AS asset_price_with_lag_mv_next
WHERE
  NOT prev_price IS NULL AND prev_price <> 0
Lineage · insights.asset_twrr_mv 5 objects
Direct (1-hop) dependencies from rw_depend, across schemas. Click a neighbor to expand its dependencies; ⌘/Ctrl-click opens its page. Drag to pan, scroll to zoom. External source/sink endpoints (Kafka, Iceberg) are not shown.