| Actor | Fragment | Worker | State |
|---|---|---|---|
| 102004 | 23388 | 26 | running |
| 102018 | 23386 | 26 | running |
| 102019 | 23386 | 26 | running |
| 102020 | 23387 | 26 | running |
| 102021 | 23389 | 26 | running |
| 102022 | 23389 | 26 | running |
CREATE TABLE asset_service.asset_prices_eod_ft (
asset_id VARCHAR,
date DATE,
currency_code VARCHAR,
close DECIMAL,
nav DECIMAL,
last DECIMAL,
reference_price DECIMAL,
reference_price_source VARCHAR,
PRIMARY KEY (asset_id, date),
WATERMARK FOR date AS CAST((
date - INTERVAL '5 YEARS'
) AS DATE) WITH TTL
)
WITH (
snapshot='true'
) FROM asset_service.asset_service_source TABLE 'public.asset_prices_eod_ft'