| Actor | Fragment | Worker | State |
|---|---|---|---|
| 120108 | 25049 | 26 | running |
| 120122 | 25047 | 26 | running |
| 120123 | 25047 | 26 | running |
| 120124 | 25048 | 26 | running |
| 120125 | 25050 | 26 | running |
| 120126 | 25050 | 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'