| Actor | Fragment | Worker | State |
|---|---|---|---|
| 99549 | 22110 | 26 | running |
| 99550 | 22110 | 26 | running |
| 99563 | 22111 | 26 | running |
| 99564 | 22111 | 26 | running |
CREATE MATERIALIZED VIEW insights.fx_rates_snapshot_mv AS
SELECT
source_currency_code,
target_currency_code,
rate,
CAST(date AS TIMESTAMPTZ) AS value_timestamp
FROM (
SELECT
source_currency_code,
target_currency_code,
rate,
date,
ROW_NUMBER() OVER (PARTITION BY source_currency_code, target_currency_code ORDER BY date DESC) AS rn
FROM asset_service.foreign_exchange_rates_eod_ft
WHERE
source_currency_code <> target_currency_code
)
WHERE
rn = 1