| Actor | Fragment | Worker | State |
|---|---|---|---|
| 53870 | 2358 | 3 | running |
| 53871 | 2358 | 3 | running |
| 53872 | 2359 | 3 | running |
| 53873 | 2359 | 3 | running |
CREATE MATERIALIZED VIEW adib_rm.asset_price_with_lag_mv AS 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