| Actor | Fragment | Worker | State |
|---|---|---|---|
| 53906 | 2373 | 3 | running |
| 53907 | 2373 | 3 | running |
| 53908 | 2374 | 3 | running |
| 53909 | 2374 | 3 | running |
CREATE MATERIALIZED VIEW insights.intraday_holdings_latest_mv AS
SELECT
account_id,
asset_id,
currency_code,
purchased_quantity,
average_cost_per_unit,
market_value,
holding_timestamp
FROM (
SELECT
account_id,
asset_id,
currency_code,
purchased_quantity,
average_cost_per_unit,
market_value,
holding_timestamp,
ROW_NUMBER() OVER (PARTITION BY account_id, asset_id ORDER BY holding_timestamp DESC) AS rn
FROM olap.holding_values_intraday_ft
WHERE
disabled_at IS NULL
)
WHERE
rn = 1