# reports

report_id: 445926f6-f996-4f21-b9ac-96de57b764f4
report_type: crypto_inventory
title: JARVIS Finance System – Crypto-Bestandsübersicht
generated_at: 2026-05-14T20:26:54.506833+00:00
format: html
data_quality_status: warning
created_at: 2026-05-14T20:26:54.506833+00:00
file_path:
  /home/agent/jarvis_runtime/finance-system/reports/crypto_inventory_2026-05-14T202654.506024_0000_445926f6.html

summary_json:
  {"coin_count": 19, "data_quality_status": "warning", "total_value_chf": "0.0000", "wallet_count": 5}


# alerts

alert_id: 3135b8ad-7c32-4f81-91b7-a90cb8ca3b4d
priority: kritisch
category: ledger
entity_type: instrument
entity_id: instrument_392d921609e628de82d985fa
rule_id: missing_fx
message: Historic FX is missing; precise CHF total return cannot be calculated.
status: active
created_at: 2026-05-16T10:20:40.857284+00:00
last_seen_at: 2026-05-16T10:41:17.791464+00:00
fingerprint: ebc2a1f6dedbe286561b83a94ac7984a
dedup_key: 145aab1163ffd17522ba13fccbc76099bf3b1e62
evidence_json:
  {"account_id": "account_89dada5563cc9139ffb4bdf5", "instrument_id": "instrument_392d921609e628de82d985fa"}


alert_id: dd2cf155-17ca-4e89-94e8-3cef32613a0c
priority: warnung
category: ledger
entity_type: instrument
entity_id: instrument_5a523c2f16389f35ef848f74
rule_id: snapshot_only
message: Initial snapshot lacks full transaction history; performance is incomplete.
status: active
created_at: 2026-05-16T10:27:56.262396+00:00
last_seen_at: 2026-05-16T10:41:17.791232+00:00
fingerprint: 21ec740301a4c1d8e62afdb7d026ea30
dedup_key: a1de8c862f384d7e011259e1d7726bbb2df9ace4
evidence_json:
  {"account_id": "account_78124e879623a70c1cf0c1cb", "instrument_id": "instrument_5a523c2f16389f35ef848f74"}


# audit_log

audit_id: 781f60a7-b079-4b58-bd97-6ed0b9d3832d
timestamp: 2026-05-14T20:00:16.373467+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_ede605b274c5fd3e07c582c4
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:00:16.373467+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:00:16.373467+00:00
new_values_json:
  {"asset_id": "cryptoasset_d990077f677822ae238571fe", "quantity": "1.19092", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: 0029b7d9-36aa-4260-8f9f-f0a3c8453cf5
timestamp: 2026-05-14T20:00:16.397489+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_25a53ff7f2b3e82c69076efc
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:00:16.397489+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:00:16.397489+00:00
new_values_json:
  {"asset_id": "cryptoasset_a59d59de7003caab014f5a50", "quantity": "0.4848", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: ff3f508d-37db-4e03-b7dd-74d82be2779f
timestamp: 2026-05-14T20:00:16.427660+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_04f5a7bbc7ae944b9fa039a5
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:00:16.427660+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:00:16.427660+00:00
new_values_json:
  {"asset_id": "cryptoasset_69c3ce7ef1c93c72de019745", "quantity": "0.00000827", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}


audit_id: 16d7964a-9588-4756-93ea-e3e67b28a2eb
timestamp: 2026-05-14T20:02:16.599911+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_1bf44d45e14b434466c62c19
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.599911+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.599911+00:00
new_values_json:
  {"asset_id": "cryptoasset_69c3ce7ef1c93c72de019745", "quantity": "4.1458", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}


audit_id: 640c27c9-0439-4fa4-bf96-bb07bb070157
timestamp: 2026-05-14T20:02:16.665973+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_42faa4ddf615c765100fab19
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.665973+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.665973+00:00
new_values_json:
  {"asset_id": "cryptoasset_2500f677b0de8802a4bf89ca", "quantity": "76.64476", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}


audit_id: b3f24353-9f5c-4826-bb16-a85221c23474
timestamp: 2026-05-14T20:02:16.719656+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8092b0278c9d333291a2df8f
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.719656+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.719656+00:00
new_values_json:
  {"asset_id": "cryptoasset_bebb859edbcf1636ae020883", "quantity": "3.89", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: c4a70c62-e146-45de-80e2-0937a49b2437
timestamp: 2026-05-14T20:02:16.774953+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_74bfcba2ecca66532a5f30e9
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.774953+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.774953+00:00
new_values_json:
  {"asset_id": "cryptoasset_e372b4e14a0a966832ee079e", "quantity": "0.06603", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: 43fc4a5a-212c-4f94-b426-a22a6973b2c1
timestamp: 2026-05-14T20:02:16.834588+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_e1ccd868b76de9eb9b910dbf
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.834588+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.834588+00:00
new_values_json:
  {"asset_id": "cryptoasset_c59843f8c5acd3b21a7c926f", "quantity": "99.546", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: 466f0ce3-ff19-4e0f-9448-020240fc52fa
timestamp: 2026-05-14T20:02:16.887425+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_ec3b034a4b058aa1e724e602
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.887425+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.887425+00:00
new_values_json:
  {"asset_id": "cryptoasset_52c5dafd4cd27b874c95b37d", "quantity": "0.02949744", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}


audit_id: 363226c7-f1a7-4581-8a4f-579f716665cb
timestamp: 2026-05-14T20:02:16.946620+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_5dea158b010f8c3e3720a5f3
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.946620+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.946620+00:00
new_values_json:
  {"asset_id": "cryptoasset_2ab3669b3d5981a626da55a8", "quantity": "3.7", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: 3b3ba3f8-2f45-41f6-9825-a21940f215b5
timestamp: 2026-05-14T20:02:16.999816+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8128f6e2096d0b8bd97aaf40
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:16.999816+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:16.999816+00:00
new_values_json:
  {"asset_id": "cryptoasset_8b84f89418c998a1b3ba411d", "quantity": "591.35915997", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 2e575b29-9d57-48eb-9ae3-d4c2e1809938
timestamp: 2026-05-14T20:02:17.047417+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_f8b79a5f9425866cf11c0ea2
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.047417+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.047417+00:00
new_values_json:
  {"asset_id": "cryptoasset_9fd06021a9f142fdd0947c10", "quantity": "6845.2209", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 15e67c60-8d0e-41e0-a443-04dc88b0a0c4
timestamp: 2026-05-14T20:02:17.102027+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_21423276abdbbe8c15ef59c5
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.102027+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.102027+00:00
new_values_json:
  {"asset_id": "cryptoasset_b47f2001e497ca88f261120e", "quantity": "1106.3", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 537ca19c-fb00-4477-a2a8-3fdea1c50463
timestamp: 2026-05-14T20:02:17.158456+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_236c9fa241cf819fa26bbcb4
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.158456+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.158456+00:00
new_values_json:
  {"asset_id": "cryptoasset_98a4d07afe75f30d91f74b83", "quantity": "0.00000005", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}


audit_id: e94a8b88-8c4e-4352-b146-7c5ac254b2e6
timestamp: 2026-05-14T20:02:17.183749+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_1539a1d7762d657b8204a1bc
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.183749+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.183749+00:00
new_values_json:
  {"asset_id": "cryptoasset_98a4d07afe75f30d91f74b83", "quantity": "4436.4290262", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 71d1bd08-5b48-4ef9-9005-63078ec22e4e
timestamp: 2026-05-14T20:02:17.237028+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_d29d7ae91579d315c15f5f20
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.237028+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.237028+00:00
new_values_json:
  {"asset_id": "cryptoasset_5bede362c9a431037f70fa1e", "quantity": "6076.670747", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: 988b23c6-df70-4db5-9e0e-ae84a720da22
timestamp: 2026-05-14T20:02:17.279223+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_47920b7da5806619988fff23
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.279223+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.279223+00:00
new_values_json:
  {"asset_id": "cryptoasset_272a5091996eb8f5df029660", "quantity": "1779.434766", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: ecd58e4b-53da-4920-b644-1f050e94c660
timestamp: 2026-05-14T20:02:17.306964+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8ee79062a432b98506a1acec
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.306964+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.306964+00:00
new_values_json:
  {"asset_id": "cryptoasset_272a5091996eb8f5df029660", "quantity": "170.68932217", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}


audit_id: a0ce8b09-306e-465e-837b-f3d39249d17d
timestamp: 2026-05-14T20:02:17.328975+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_ab74905d7ec536cdf2be8d1f
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.328975+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.328975+00:00
new_values_json:
  {"asset_id": "cryptoasset_272a5091996eb8f5df029660", "quantity": "10964.96647638", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 87e19c80-15d7-499f-804c-6ed44cb207a2
timestamp: 2026-05-14T20:02:17.372586+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_a9b4e4f91f418bcf6ab0a456
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.372586+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.372586+00:00
new_values_json:
  {"asset_id": "cryptoasset_470329d32a0a3d43bad12cef", "quantity": "6.69", "verification_status": "verified", "wallet_id": "wallet_f80f21938e5248ec70b870ac"}


audit_id: 4279e698-68a1-44e3-b85a-03de143e1be1
timestamp: 2026-05-14T20:02:17.425848+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_9ce372b690769b43d49b68a4
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.425848+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.425848+00:00
new_values_json:
  {"asset_id": "cryptoasset_c5f39996f2c8bdc29d042e24", "quantity": "49033.983", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: e45d6d04-da58-4886-8725-c5cdc7ca293b
timestamp: 2026-05-14T20:02:17.449349+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_7bf6705a8271fc8afa6e06b4
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.449349+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.449349+00:00
new_values_json:
  {"asset_id": "cryptoasset_c5f39996f2c8bdc29d042e24", "quantity": "10904.2", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 9d1988d7-e8ff-42f7-b154-bb30e803bbac
timestamp: 2026-05-14T20:02:17.490335+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_a312fcc40df6d707bd5431f8
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.490335+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.490335+00:00
new_values_json:
  {"asset_id": "cryptoasset_567472cf2e850b16a90df5fd", "quantity": "863.110853", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: e1bf3b56-c580-41a3-94b3-69000b87f0a3
timestamp: 2026-05-14T20:02:17.557349+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_2bcb1c67db914ec839e27fba
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.557349+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.557349+00:00
new_values_json:
  {"asset_id": "cryptoasset_48790384d6062bb79c4903ac", "quantity": "203.2901", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 0d3d36f9-5611-43b8-a06a-fed31cc9637e
timestamp: 2026-05-14T20:02:17.585390+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_11ee6f5b5b5fc53d37d52920
old_values_json: {}
user_text_note: productive initial_snapshot 2025-12-31; source XLSX safe subset; legacy CHF values ignored
confirmation_timestamp: 2026-05-14T20:02:17.585390+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:02:17.585390+00:00
new_values_json:
  {"asset_id": "cryptoasset_48790384d6062bb79c4903ac", "quantity": "124.73272", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}


audit_id: f563a2f8-bd27-4384-a0bc-72dbe557b3c6
timestamp: 2026-05-14T20:26:54.506931+00:00
source: reports
action: report_generated
entity_type: report
entity_id: 445926f6-f996-4f21-b9ac-96de57b764f4
old_values_json: {}
confirmation_timestamp: 2026-05-14T20:26:54.506931+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T20:26:54.506931+00:00
new_values_json:
  {"file_path": "/home/agent/jarvis_runtime/finance-system/reports/crypto_inventory_2026-05-14T202654.506024_0000_445926f6.html", "format": "html", "report_type": "crypto_inventory"}


audit_id: bdb726ac-b3f3-4566-b1d2-dcf82cd5d76e
timestamp: 2026-05-14T21:46:05.188407+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_0c4251cca1b3ab63c6279c4c
old_values_json: {}
user_text_note: Nachtrag aus initialer Crypto-Bestandsdatei, manuell geprüft
confirmation_timestamp: 2026-05-14T21:46:05.188407+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T21:46:05.188407+00:00
new_values_json:
  {"asset_id": "cryptoasset_8a4782e68d4ff24fd473be11", "quantity": "0.03576008", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}


audit_id: 875fcff7-dff0-4497-8771-62c7e3bbbbf9
timestamp: 2026-05-14T21:46:05.200964+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_855f111abd945b23077ac7d9
old_values_json: {}
user_text_note: Nachtrag aus initialer Crypto-Bestandsdatei, manuell geprüft
confirmation_timestamp: 2026-05-14T21:46:05.200964+00:00
created_by: system
quality_status: ok
created_at: 2026-05-14T21:46:05.200964+00:00
new_values_json:
  {"asset_id": "cryptoasset_8a4782e68d4ff24fd473be11", "quantity": "0.32318582", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}


audit_id: 4231dc78-1211-4580-b5d7-139a02b214e9
timestamp: 2026-05-15T10:09:51.822803+00:00
source: manual_review_queue
action: create_review_account_metadata
entity_type: account
entity_id: true-wealth-review-brokerage
old_values_json: {}
new_values_json: {"account_type": "brokerage", "currency": "CHF", "platform_id": "true-wealth"}
confirmation_timestamp: 2026-05-15T10:09:51.822803+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.822803+00:00
user_text_note:
  B5 pilot metadata-only brokerage account for True Wealth ETF review items; no cash/ledger/snapshot write.


audit_id: eebba623-71e8-494f-bb1d-be19586978b0
timestamp: 2026-05-15T10:09:51.823255+00:00
source: manual_review_queue
action: update_isin
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
user_text_note: B5 pilot: ISIN read from True Wealth review label; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.823255+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823255+00:00
old_values_json:
  {"isin": null, "quality_flags": ["needs_manual_review", "snapshot_only", "missing_isin", "missing_ticker", "cost_basis_uncertain"]}

new_values_json:
  {"isin": "US9229087690", "quality_flags": ["needs_manual_review", "snapshot_only", "missing_ticker", "cost_basis_uncertain"], "readiness": "review_needed"}


audit_id: e99f2428-233f-44fb-870b-3f03c7be53d3
timestamp: 2026-05-15T10:09:51.823341+00:00
source: manual_review_queue
action: update_ticker_exchange
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {"exchange": null, "ticker": null}
user_text_note: B5 pilot: ticker/exchange from known ETF primary listing; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.823341+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823341+00:00
new_values_json:
  {"exchange": "NYSE ARCA", "readiness": "review_needed", "ticker": "VTI", "ticker_exchange_confirmed": 1}


audit_id: 85d7dc0b-2f60-4f47-9d5b-87e35025d82b
timestamp: 2026-05-15T10:09:51.823490+00:00
source: manual_review_queue
action: confirm_snapshot_date
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {"snapshot_date_confirmed": 0}
new_values_json: {"readiness": "review_needed", "snapshot_date_confirmed": 1}
confirmation_timestamp: 2026-05-15T10:09:51.823490+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823490+00:00
user_text_note:
  B5 pilot: snapshot date missing in parser output; manually confirmed as review metadata only with quality note, no import.


audit_id: 9131c8f6-cfd4-4317-850e-2a4e5d83d178
timestamp: 2026-05-15T10:09:51.823590+00:00
source: manual_review_queue
action: confirm_instrument_mapping
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {"mapped_instrument_id": null, "review_status": "open"}
user_text_note: B5 pilot: confirm instrument mapping by ISIN; no name-only mapping.
confirmation_timestamp: 2026-05-15T10:09:51.823590+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823590+00:00
new_values_json:
  {"mapped_instrument_id": "instrument-US9229087690", "readiness": "review_needed", "review_status": "mapped"}


audit_id: 07aa197e-a069-4771-b8b5-7e5bf50b7113
timestamp: 2026-05-15T10:09:51.823766+00:00
source: manual_review_queue
action: update_isin
entity_type: broker_import_review_item
entity_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
user_text_note: B5 pilot: ISIN read from True Wealth review label; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.823766+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823766+00:00
old_values_json:
  {"isin": null, "quality_flags": ["needs_manual_review", "snapshot_only", "missing_isin", "missing_ticker", "cost_basis_uncertain"]}

new_values_json:
  {"isin": "US9220428588", "quality_flags": ["needs_manual_review", "snapshot_only", "missing_ticker", "cost_basis_uncertain"], "readiness": "review_needed"}


audit_id: 98c00c5f-eed4-4048-9ae6-77d107b5488f
timestamp: 2026-05-15T10:09:51.823828+00:00
source: manual_review_queue
action: update_ticker_exchange
entity_type: broker_import_review_item
entity_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
old_values_json: {"exchange": null, "ticker": null}
user_text_note: B5 pilot: ticker/exchange from known ETF primary listing; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.823828+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823828+00:00
new_values_json:
  {"exchange": "NYSE ARCA", "readiness": "review_needed", "ticker": "VWO", "ticker_exchange_confirmed": 1}


audit_id: 2e606df8-ab5b-4c34-8705-f1767017eb23
timestamp: 2026-05-15T10:09:51.823986+00:00
source: manual_review_queue
action: confirm_instrument_mapping
entity_type: broker_import_review_item
entity_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
old_values_json: {"mapped_instrument_id": null, "review_status": "open"}
user_text_note: B5 pilot: confirm instrument mapping by ISIN; no name-only mapping.
confirmation_timestamp: 2026-05-15T10:09:51.823986+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.823986+00:00
new_values_json:
  {"mapped_instrument_id": "instrument-US9220428588", "readiness": "review_needed", "review_status": "mapped"}


audit_id: 75609d24-d9ea-4c6f-82aa-82a809d72eba
timestamp: 2026-05-15T10:09:51.824173+00:00
source: manual_review_queue
action: update_isin
entity_type: broker_import_review_item
entity_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
user_text_note: B5 pilot: ISIN read from True Wealth review label; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.824173+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.824173+00:00
old_values_json:
  {"isin": null, "quality_flags": ["needs_manual_review", "snapshot_only", "missing_isin", "missing_ticker", "cost_basis_uncertain"]}

new_values_json:
  {"isin": "US92204A7028", "quality_flags": ["needs_manual_review", "snapshot_only", "missing_ticker", "cost_basis_uncertain"], "readiness": "review_needed"}


audit_id: 7344837d-30c8-4ef0-986a-f8b17e187711
timestamp: 2026-05-15T10:09:51.824242+00:00
source: manual_review_queue
action: update_ticker_exchange
entity_type: broker_import_review_item
entity_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
old_values_json: {"exchange": null, "ticker": null}
user_text_note: B5 pilot: ticker/exchange from known ETF primary listing; metadata-only.
confirmation_timestamp: 2026-05-15T10:09:51.824242+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.824242+00:00
new_values_json:
  {"exchange": "NYSE ARCA", "readiness": "review_needed", "ticker": "VGT", "ticker_exchange_confirmed": 1}


audit_id: fc38d36e-b72a-4533-8444-76e345f3dd51
timestamp: 2026-05-15T10:09:51.824398+00:00
source: manual_review_queue
action: confirm_instrument_mapping
entity_type: broker_import_review_item
entity_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
old_values_json: {"mapped_instrument_id": null, "review_status": "open"}
user_text_note: B5 pilot: confirm instrument mapping by ISIN; no name-only mapping.
confirmation_timestamp: 2026-05-15T10:09:51.824398+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:09:51.824398+00:00
new_values_json:
  {"mapped_instrument_id": "instrument-US92204A7028", "readiness": "review_needed", "review_status": "mapped"}


audit_id: 852d0809-fcb0-47cf-bd5e-139f4b06a318
timestamp: 2026-05-15T10:10:55.706475+00:00
source: manual_review_queue
action: correct_detected_presence_flags
entity_type: broker_import_review_item
entity_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {"detected_market_value_present": 0, "detected_quantity_present": 0}
new_values_json: {"detected_market_value_present": 1, "detected_quantity_present": 1}
confirmation_timestamp: 2026-05-15T10:10:55.706475+00:00
created_by: phase_b5_pilot
quality_status: ok
created_at: 2026-05-15T10:10:55.706475+00:00
user_text_note:
  B5 pilot presence-only correction after verifying source table has quantity/value columns; no numeric data stored.


audit_id: a269e3d3-d758-4cb6-b84e-11be6447cb5c
timestamp: 2026-05-15T10:20:15.960489+00:00
source: broker_import_execution_plan
action: create_or_update_execution_plan
entity_type: broker_import_execution_plan
entity_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
old_values_json: {}
user_text_note: B6a final dry-run execution plan created/updated; no productive import.
confirmation_timestamp: 2026-05-15T10:20:15.960489+00:00
created_by: phase_b6a
quality_status: ok
created_at: 2026-05-15T10:20:15.960489+00:00
new_values_json:
  {"payload_status": "ready", "quality_flags": ["cost_basis_uncertain", "fx_missing"], "review_item_id": "9122f3c2-eb76-4f92-b95d-1f9c2a99f686"}


audit_id: d7539363-e42e-4f3f-9c39-ab3b37ee3c0b
timestamp: 2026-05-15T10:20:15.960635+00:00
source: broker_import_execution_plan
action: create_or_update_execution_plan
entity_type: broker_import_execution_plan
entity_id: plan-1c6136ca-852d-4467-ae87-4924ea2bd305
old_values_json: {}
user_text_note: B6a final dry-run execution plan created/updated; no productive import.
confirmation_timestamp: 2026-05-15T10:20:15.960635+00:00
created_by: phase_b6a
quality_status: ok
created_at: 2026-05-15T10:20:15.960635+00:00
new_values_json:
  {"payload_status": "ready", "quality_flags": ["cost_basis_uncertain", "fx_missing"], "review_item_id": "1c6136ca-852d-4467-ae87-4924ea2bd305"}


audit_id: 15e84910-e293-424a-89c6-98c44b3fa6a5
timestamp: 2026-05-15T10:20:15.960699+00:00
source: broker_import_execution_plan
action: create_or_update_execution_plan
entity_type: broker_import_execution_plan
entity_id: plan-8cc9a511-e679-47ee-a57a-30fe53ea72a6
old_values_json: {}
user_text_note: B6a final dry-run execution plan created/updated; no productive import.
confirmation_timestamp: 2026-05-15T10:20:15.960699+00:00
created_by: phase_b6a
quality_status: ok
created_at: 2026-05-15T10:20:15.960699+00:00
new_values_json:
  {"payload_status": "ready", "quality_flags": ["cost_basis_uncertain", "fx_missing"], "review_item_id": "8cc9a511-e679-47ee-a57a-30fe53ea72a6"}


audit_id: eeb7bd54-f6f3-481a-b33e-ae64e333a796
timestamp: 2026-05-15T10:21:23.938362+00:00
source: broker_import_execution_plan
action: execute_mini_import
entity_type: transaction
entity_id: tx-0870b5b9-0c4e-4ffb-94b5-4eef18009b99
old_values_json: {}
confirmation_timestamp: 2026-05-15T10:21:23.938362+00:00
created_by: phase_b6b
quality_status: ok
created_at: 2026-05-15T10:21:23.938362+00:00
new_values_json:
  {"execution_plan_id": "plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686", "quality_status": "warning", "review_item_id": "9122f3c2-eb76-4f92-b95d-1f9c2a99f686", "transaction_type": "initial_position_snapshot"}

user_text_note:
  B6b productive mini-import of exactly one True Wealth reviewed initial snapshot. No values emitted to chat.


audit_id: d124b827-5cfd-4f7a-8cd3-edbd6382abbd
timestamp: 2026-05-15T10:48:28.447340+00:00
source: broker_import_execution_plan
action: execute_mini_import
entity_type: transaction
entity_id: tx-e13645cf-1681-4ac8-b57d-981aad88098c
old_values_json: {}
user_text_note: B6c second controlled mini-import from reviewed True Wealth execution plan; no mass import.
confirmation_timestamp: 2026-05-15T10:48:28.447340+00:00
created_by: phase_b6c
quality_status: ok
created_at: 2026-05-15T10:48:28.447340+00:00
new_values_json:
  {"execution_plan_id": "plan-1c6136ca-852d-4467-ae87-4924ea2bd305", "quality_status": "warning", "review_item_id": "1c6136ca-852d-4467-ae87-4924ea2bd305", "transaction_type": "initial_position_snapshot"}


audit_id: 53f3c5cc-5671-4201-86a9-7b9a8b9ae184
timestamp: 2026-05-15T10:58:02.511142+00:00
source: broker_import_execution_plan
action: execute_mini_import
entity_type: transaction
entity_id: tx-aecd65d3-148f-4e45-9e19-d5c2d85e8133
old_values_json: {}
user_text_note: B6d final controlled True Wealth mini-import from reviewed execution plan; no mass import.
confirmation_timestamp: 2026-05-15T10:58:02.511142+00:00
created_by: phase_b6d
quality_status: ok
created_at: 2026-05-15T10:58:02.511142+00:00
new_values_json:
  {"execution_plan_id": "plan-8cc9a511-e679-47ee-a57a-30fe53ea72a6", "quality_status": "warning", "review_item_id": "8cc9a511-e679-47ee-a57a-30fe53ea72a6", "transaction_type": "initial_position_snapshot"}


audit_id: 82d133d2-eed9-43b0-be1c-d5d296eed3ad
timestamp: 2026-05-15T12:56:13.842993+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_587a0304aacaba2a4bd3f0a6
old_values_json: {}
user_text_note: prepare catalog from existing instruments
confirmation_timestamp: 2026-05-15T12:56:13.842993+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T12:56:13.842993+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "NYSE ARCA", "isin": "US9220428588", "provider": "manual", "provider_symbol": null, "ticker": "VWO"}


audit_id: eba572a7-71c3-44a5-bd59-56a1014635b7
timestamp: 2026-05-15T12:56:13.870310+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ce8a71a4a3457ce6605edf16
old_values_json: {}
user_text_note: prepare catalog from existing instruments
confirmation_timestamp: 2026-05-15T12:56:13.870310+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T12:56:13.870310+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "NYSE ARCA", "isin": "US92204A7028", "provider": "manual", "provider_symbol": null, "ticker": "VGT"}


audit_id: 51910223-ff79-4e88-a95f-4c3db40e7d59
timestamp: 2026-05-15T12:56:13.897495+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_50d5fd9b1d080e95fe7429fc
old_values_json: {}
user_text_note: prepare catalog from existing instruments
confirmation_timestamp: 2026-05-15T12:56:13.897495+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T12:56:13.897495+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "NYSE ARCA", "isin": "US9229087690", "provider": "manual", "provider_symbol": null, "ticker": "VTI"}


audit_id: 4d743a95-e1f4-4577-a2af-9345a711055f
timestamp: 2026-05-15T14:25:28.676336+00:00
source: instrument_search_add_position
action: manual_position_add
entity_type: transaction
entity_id: tx_5332cdb66603ea6ffefdb64e
old_values_json: {}
user_text_note: Ist OK. Preis stand 14.05.2026: USD 59.94
confirmation_timestamp: 2026-05-15T14:25:28.676336+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:25:28.676336+00:00
new_values_json:
  {"account_id": "true-wealth-review-brokerage", "catalog_entry_id": "catalog_587a0304aacaba2a4bd3f0a6", "instrument_id": "instrument-US9220428588", "transaction_type": "manual_adjustment"}


audit_id: cf4f2095-b09f-497e-bd98-30d891459091
timestamp: 2026-05-15T14:26:42.800380+00:00
source: instrument_search_add_position
action: manual_position_add
entity_type: transaction
entity_id: tx_de2c4c482616312b7f28b5a5
old_values_json: {}
user_text_note: Ist OK. Preis stand 14.05.2026: USD 113.45
confirmation_timestamp: 2026-05-15T14:26:42.800380+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:26:42.800380+00:00
new_values_json:
  {"account_id": "true-wealth-review-brokerage", "catalog_entry_id": "catalog_ce8a71a4a3457ce6605edf16", "instrument_id": "instrument-US92204A7028", "transaction_type": "manual_adjustment"}


audit_id: df51e262-43db-49b2-bb55-0769535a28dd
timestamp: 2026-05-15T14:27:30.391153+00:00
source: instrument_search_add_position
action: manual_position_add
entity_type: transaction
entity_id: tx_70e832601465b74bc397bf0d
old_values_json: {}
user_text_note: Ist OK. Preis stand 14.05.2026: USD 364.71
confirmation_timestamp: 2026-05-15T14:27:30.391153+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:27:30.391153+00:00
new_values_json:
  {"account_id": "true-wealth-review-brokerage", "catalog_entry_id": "catalog_50d5fd9b1d080e95fe7429fc", "instrument_id": "instrument-US9229087690", "transaction_type": "manual_adjustment"}


audit_id: d50a5b8f-b49f-46fe-b9f4-a69440ddac82
timestamp: 2026-05-15T14:31:15.849689+00:00
source: instrument_price_mapping
action: confirm_instrument_price_mapping
entity_type: instrument_price_mapping
entity_id: ipm_82cca9f51734b1a1d04f7b7c
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:15.849689+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:15.849689+00:00
new_values_json:
  {"hedge_status": "unknown", "instrument_id": "instrument-US9220428588", "instrument_status": "unknown", "provider": "openfigi", "provider_market": "US", "provider_symbol": "VWO", "valuation_policy": "live_price"}


audit_id: 90b48367-fb64-4788-b473-6d980e29d417
timestamp: 2026-05-15T14:31:15.867548+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_378e3ce00a67c6393b6b2c5a
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:15.867548+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:15.867548+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "US", "isin": "US9220428588", "provider": "openfigi", "provider_symbol": "VWO", "ticker": "VWO"}


audit_id: 9cc36bb2-6531-4a00-a7d3-e3146846f9d3
timestamp: 2026-05-15T14:31:15.881336+00:00
source: instrument_price_mapping_candidate
action: select_mapping_candidate
entity_type: instrument_price_mapping_candidate
entity_id: ipmc_208b2282a32eef2a4890b7ab
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:15.881336+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:15.881336+00:00
new_values_json:
  {"instrument_id": "instrument-US9220428588", "mapping_id": "ipm_82cca9f51734b1a1d04f7b7c", "provider": "openfigi", "provider_symbol": "VWO"}


audit_id: 94a2fdbe-9c1b-49a1-9bc0-f775195270b4
timestamp: 2026-05-15T14:31:47.024914+00:00
source: instrument_price_mapping
action: confirm_instrument_price_mapping
entity_type: instrument_price_mapping
entity_id: ipm_8d538c9112b01f5c5131ef73
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:47.024914+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:47.024914+00:00
new_values_json:
  {"hedge_status": "unknown", "instrument_id": "instrument-US92204A7028", "instrument_status": "unknown", "provider": "openfigi", "provider_market": "US", "provider_symbol": "VGT", "valuation_policy": "live_price"}


audit_id: 3c71b065-1d03-400c-aca4-a3efceec30fd
timestamp: 2026-05-15T14:31:47.037958+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ef2e759ab744c1a3b1f52ebc
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:47.037958+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:47.037958+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "US", "isin": "US92204A7028", "provider": "openfigi", "provider_symbol": "VGT", "ticker": "VGT"}


audit_id: 841a8645-0d23-4ca9-ae9d-7e029733df17
timestamp: 2026-05-15T14:31:47.046696+00:00
source: instrument_price_mapping_candidate
action: select_mapping_candidate
entity_type: instrument_price_mapping_candidate
entity_id: ipmc_e31b9b9f614991e30e953a0f
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:31:47.046696+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:31:47.046696+00:00
new_values_json:
  {"instrument_id": "instrument-US92204A7028", "mapping_id": "ipm_8d538c9112b01f5c5131ef73", "provider": "openfigi", "provider_symbol": "VGT"}


audit_id: 4e24e0e8-c392-4a2e-8c54-14bf0d10bc25
timestamp: 2026-05-15T14:32:37.898125+00:00
source: instrument_price_mapping
action: confirm_instrument_price_mapping
entity_type: instrument_price_mapping
entity_id: ipm_971a1108ea37c7efb9dc03fa
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:32:37.898125+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:32:37.898125+00:00
new_values_json:
  {"hedge_status": "unknown", "instrument_id": "instrument-US9229087690", "instrument_status": "unknown", "provider": "openfigi", "provider_market": "US", "provider_symbol": "VTI", "valuation_policy": "live_price"}


audit_id: 09b9689f-cea7-4111-901f-a150e099d9a6
timestamp: 2026-05-15T14:32:37.909295+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_d7c9ae7fe9a2e0d3bcdb1d52
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:32:37.909295+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:32:37.909295+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "US", "isin": "US9229087690", "provider": "openfigi", "provider_symbol": "VTI", "ticker": "VTI"}


audit_id: c7f8d3f5-738a-4a9c-a90f-403aa261b877
timestamp: 2026-05-15T14:32:37.918201+00:00
source: instrument_price_mapping_candidate
action: select_mapping_candidate
entity_type: instrument_price_mapping_candidate
entity_id: ipmc_f7798e27a58fb8275f36c0f5
old_values_json: {}
user_text_note: Passt
confirmation_timestamp: 2026-05-15T14:32:37.918201+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T14:32:37.918201+00:00
new_values_json:
  {"instrument_id": "instrument-US9229087690", "mapping_id": "ipm_971a1108ea37c7efb9dc03fa", "provider": "openfigi", "provider_symbol": "VTI"}


audit_id: 27a0b21c-680c-46be-88a9-b965b1c0d19b
timestamp: 2026-05-15T15:06:31.341449+00:00
source: dashboard_etf_review
action: confirm_etf_mapping
entity_type: instrument_price_mapping
entity_id: ipm_82cca9f51734b1a1d04f7b7c
old_values_json: {"mapping_status": "mapped"}
confirmation_timestamp: 2026-05-15T15:06:31.341449+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T15:06:31.341449+00:00
new_values_json:
  {"instrument_id": "instrument-US9220428588", "mapping_status": "user_confirmed", "provider": "openfigi", "provider_symbol": "VWO"}


audit_id: 7b7622ab-0d2e-4dd4-b1c9-64c5a584479e
timestamp: 2026-05-15T15:06:31.341535+00:00
source: dashboard_etf_review
action: confirm_etf_mapping
entity_type: instrument_price_mapping
entity_id: ipm_8d538c9112b01f5c5131ef73
old_values_json: {"mapping_status": "mapped"}
confirmation_timestamp: 2026-05-15T15:06:31.341535+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T15:06:31.341535+00:00
new_values_json:
  {"instrument_id": "instrument-US92204A7028", "mapping_status": "user_confirmed", "provider": "openfigi", "provider_symbol": "VGT"}


audit_id: 11c70fd2-547b-4351-9196-0156e0fd847c
timestamp: 2026-05-15T15:06:31.341559+00:00
source: dashboard_etf_review
action: confirm_etf_mapping
entity_type: instrument_price_mapping
entity_id: ipm_971a1108ea37c7efb9dc03fa
old_values_json: {"mapping_status": "mapped"}
confirmation_timestamp: 2026-05-15T15:06:31.341559+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-15T15:06:31.341559+00:00
new_values_json:
  {"instrument_id": "instrument-US9229087690", "mapping_status": "user_confirmed", "provider": "openfigi", "provider_symbol": "VTI"}


audit_id: dab2cd83-2f98-4983-8ded-a62a67e515de
timestamp: 2026-05-15T18:57:49.752498+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_7e8d93c374f0c35921908ac1
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.752498+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.752498+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "1880.985", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
  Adjusted crypto XLSX initial snapshot import; CoinGecko ID supplied in source; legacy CHF values ignored.


audit_id: c9acfdcf-33a3-451a-93c2-903bc1161651
timestamp: 2026-05-15T18:57:49.766394+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_d65b023d3dbcbe356c9aa3d7
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.766394+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.766394+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "682.71534972", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
  Adjusted crypto XLSX initial snapshot import; CoinGecko ID supplied in source; legacy CHF values ignored.


audit_id: 88f1ea67-eecf-41be-acb0-a179ecd05805
timestamp: 2026-05-15T18:57:49.784919+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_6cf26f2b18b8e587d831ec38
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.784919+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.784919+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "1154.5285", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
  Adjusted crypto XLSX initial snapshot import; CoinGecko ID supplied in source; legacy CHF values ignored.


audit_id: c1a1dbfe-0f0c-44b7-a501-446d5df5093e
timestamp: 2026-05-15T18:57:49.811449+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_77cd2d7ae1821495dac7a96b
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.811449+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.811449+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "5815.36346", "verification_status": "verified", "wallet_id": "wallet_35a9bacb19d0e1700fa9acac"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 4bb7956b-eb2b-4912-94d1-bd1301804397
timestamp: 2026-05-15T18:57:49.825366+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_60ffed693f0df17d5db22f27
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.825366+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.825366+00:00
new_values_json:
  {"asset_id": "cryptoasset_b0979ceea0cf857bf2672e7a", "quantity": "55.832925", "verification_status": "verified", "wallet_id": "wallet_716284556b6168ce643d7011"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: b3a87617-9baf-4845-a480-4eb6371fe9ac
timestamp: 2026-05-15T18:57:49.853682+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_2dad4d1d23ec4cfb92e16c4e
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.853682+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.853682+00:00
new_values_json:
  {"asset_id": "cryptoasset_807263d8e19ec0a0fbbb0aeb", "quantity": "5.36812", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: eec448c6-b468-4283-8cdf-9897e267bacc
timestamp: 2026-05-15T18:57:49.867092+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_5346f54862271fd9dc97ea03
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.867092+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.867092+00:00
new_values_json:
  {"asset_id": "cryptoasset_807263d8e19ec0a0fbbb0aeb", "quantity": "4.3783", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 62d7df76-d1c2-4291-8612-999350e13ca0
timestamp: 2026-05-15T18:57:49.894922+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_5aad8aae1d240cb73d548281
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.894922+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.894922+00:00
new_values_json:
  {"asset_id": "cryptoasset_a727b75a784d02cfe4f187cb", "quantity": "17.81559", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 359be4d7-f641-4bdb-a765-582c8a5baede
timestamp: 2026-05-15T18:57:49.921445+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_2e16e9bf655c8a908bb5d2b1
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.921445+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.921445+00:00
new_values_json:
  {"asset_id": "cryptoasset_56e929b006b6354055e5d334", "quantity": "107.19552", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 1deb88e4-9357-4b3f-8a75-2757d24f8312
timestamp: 2026-05-15T18:57:49.947568+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8325b0d67bee03191c4a46fd
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.947568+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.947568+00:00
new_values_json:
  {"asset_id": "cryptoasset_5d8c0c9249eb4e443ee38d22", "quantity": "2561.2647", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 0381babc-853a-49f6-aabe-c833fc988bc7
timestamp: 2026-05-15T18:57:49.973864+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_acacba0cbeb2a92637718fa5
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.973864+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.973864+00:00
new_values_json:
  {"asset_id": "cryptoasset_b45590d11f42f55b673bf50f", "quantity": "1.9030286", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: e0fcc939-488c-4970-9bb5-1db18bf6ccf3
timestamp: 2026-05-15T18:57:49.986971+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_1b6e8b602bef4f2915d73921
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.986971+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.986971+00:00
new_values_json:
  {"asset_id": "cryptoasset_b45590d11f42f55b673bf50f", "quantity": "0.5745352", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 5499d4df-bdf6-4c15-a715-9f7d146208e2
timestamp: 2026-05-15T18:57:49.999797+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_3b9ca31d40e4d62a59d848b5
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:49.999797+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:49.999797+00:00
new_values_json:
  {"asset_id": "cryptoasset_b45590d11f42f55b673bf50f", "quantity": "0.0202", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: d4319f85-3247-417e-9ce2-e540af9fa7f2
timestamp: 2026-05-15T18:57:50.025135+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_360e1468acb72d9f37330278
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.025135+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.025135+00:00
new_values_json:
  {"asset_id": "cryptoasset_2c03aef2ab39bb3ca9f759a7", "quantity": "0.12093431", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 7f8ecace-0717-4175-9e5d-e2626b58d76c
timestamp: 2026-05-15T18:57:50.061244+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8e4f091808561c18ec8879e4
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.061244+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.061244+00:00
new_values_json:
  {"asset_id": "cryptoasset_8335d0d6289e5d1dc68f51ba", "quantity": "1577.231877", "verification_status": "verified", "wallet_id": "wallet_2585cfa4e17d282a4938e4da"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 91def075-6e1f-437c-b0fe-6506b3375f49
timestamp: 2026-05-15T18:57:50.087447+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_90e6266973c5369fb88101df
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.087447+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.087447+00:00
new_values_json:
  {"asset_id": "cryptoasset_0b2a8d03cd5938dff10f2013", "quantity": "18.17779207", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 4023754a-718a-403c-b9f8-e12bd667fe20
timestamp: 2026-05-15T18:57:50.112763+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_199b4ecb61491bb0d7cddc33
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.112763+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.112763+00:00
new_values_json:
  {"asset_id": "cryptoasset_05ee5eb8c1ed2feadd0e2e90", "quantity": "315242.120103", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 34ac5802-f6fa-4602-880c-af7510d1ec8f
timestamp: 2026-05-15T18:57:50.137109+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_1049d676d5ca95dcd1f7b170
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.137109+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.137109+00:00
new_values_json:
  {"asset_id": "cryptoasset_d9985b5dfe30ebb162d7e96b", "quantity": "202.20374053", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 47689325-8ad7-40e8-a1e6-825edd8f0098
timestamp: 2026-05-15T18:57:50.162585+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_dc7e90078e9a40c8e4ba26b3
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.162585+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.162585+00:00
new_values_json:
  {"asset_id": "cryptoasset_0fed5d47a2a5afddd52aeb3e", "quantity": "181.53426042", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 5d3ea5ca-66f4-4ebf-8c7b-758a468da725
timestamp: 2026-05-15T18:57:50.187463+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_42a243fc06025b3a255ef9c7
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.187463+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.187463+00:00
new_values_json:
  {"asset_id": "cryptoasset_27330d9a896ad4e3997c7503", "quantity": "209.09636964", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 9044db03-142e-4827-a084-6eaa86d97b66
timestamp: 2026-05-15T18:57:50.213668+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_0fd3d8e28c3f7f26232052b6
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.213668+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.213668+00:00
new_values_json:
  {"asset_id": "cryptoasset_bb516ab97b3ea319050f47df", "quantity": "899.38006", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 629dfe9b-c642-4cb5-92c5-1da80dbe7c64
timestamp: 2026-05-15T18:57:50.243207+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_4ffa8dc5cf833dbefe7a343b
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.243207+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.243207+00:00
new_values_json:
  {"asset_id": "cryptoasset_6feea8115f112302b2aa2ffa", "quantity": "1758.455617", "verification_status": "verified", "wallet_id": "wallet_f2fc2ca1c828421ad249ee37"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: a8bf9491-dc11-4fb8-b744-e2ada07f8f7d
timestamp: 2026-05-15T18:57:50.260369+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_d0c71206d063c98787b43930
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.260369+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.260369+00:00
new_values_json:
  {"asset_id": "cryptoasset_6feea8115f112302b2aa2ffa", "quantity": "740.813", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 199a63b2-20df-4f6b-a13e-df4e9b75d9bf
timestamp: 2026-05-15T18:57:50.294938+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_e13d03f4a7014b85c19f6fea
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.294938+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.294938+00:00
new_values_json:
  {"asset_id": "cryptoasset_6337d2b8583a17d376482b10", "quantity": "32.7346", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 1b1c0a85-417f-4375-b9f0-60d8a743ec6e
timestamp: 2026-05-15T18:57:50.312609+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_8fc7297417655b1ff25aa9c6
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.312609+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.312609+00:00
new_values_json:
  {"asset_id": "cryptoasset_6337d2b8583a17d376482b10", "quantity": "7.390202", "verification_status": "verified", "wallet_id": "wallet_349ea085e7c763adbad98208"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: c7bc862a-36eb-4432-b98b-20a6f9588315
timestamp: 2026-05-15T18:57:50.346444+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_705b5da9462bcfca30017e19
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.346444+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.346444+00:00
new_values_json:
  {"asset_id": "cryptoasset_3cf5dec425d368f2b3d9e51b", "quantity": "6578.9473", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 3622e2eb-2406-458d-8f0e-3019f2b0db27
timestamp: 2026-05-15T18:57:50.380618+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_e62ab830dee435091e941729
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.380618+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.380618+00:00
new_values_json:
  {"asset_id": "cryptoasset_35fe9e3f11f68f0fd1120aa5", "quantity": "252.93264", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: ae77f391-6ccc-48ab-945e-67f9096a2ca0
timestamp: 2026-05-15T18:57:50.415987+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_84faadac6090ff25b6a43d57
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.415987+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.415987+00:00
new_values_json:
  {"asset_id": "cryptoasset_294c17ec1bc5d1cd4bad64d6", "quantity": "1.78458869", "verification_status": "verified", "wallet_id": "wallet_d775d06f5d60c7ca04e788e9"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 09e903bc-43c2-444f-839f-37c6e6c378df
timestamp: 2026-05-15T18:57:50.453229+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_0384fe07daa828e2a5887074
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.453229+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.453229+00:00
new_values_json:
  {"asset_id": "cryptoasset_d3ec9163a002d626e9e0fda0", "quantity": "748.37630822", "verification_status": "verified", "wallet_id": "wallet_59bba357145ca539dcd1ac95"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 2ed5bf78-323a-4345-97ac-5f2c56cf997e
timestamp: 2026-05-15T18:57:50.489387+00:00
source: crypto_holdings
action: initial_crypto_holding_snapshot
entity_type: crypto_holding
entity_id: cryptoholding_b2d23f8639289d7b3d644d47
old_values_json: {}
confirmation_timestamp: 2026-05-15T18:57:50.489387+00:00
created_by: system
quality_status: ok
created_at: 2026-05-15T18:57:50.489387+00:00
new_values_json:
  {"asset_id": "cryptoasset_fdfe1108bb188b2a2302fda8", "quantity": "111.879892", "verification_status": "verified", "wallet_id": "wallet_35a9bacb19d0e1700fa9acac"}

user_text_note:
[cell repeats an earlier one in this file: 105 characters]


audit_id: 4b8f5a7e-50bf-4d9a-9dd8-c4f7d6ec3201
timestamp: 2026-05-16T10:13:27.710438+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_4bc35e4f0e8eb79439567414
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.710438+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.710438+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "GD", "isin": null, "provider": "openfigi", "provider_symbol": "BBG000DGZJ27", "ticker": "APC"}


audit_id: d9d57fcd-b591-4983-a560-24ed3d553a07
timestamp: 2026-05-16T10:13:27.739493+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_bf03d726da62a83a7b1a6cf1
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.739493+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.739493+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "VP", "isin": null, "provider": "openfigi", "provider_symbol": "BBG01Z6HN5H2", "ticker": "APC"}


audit_id: c3cc4e6f-9c93-4a16-b81a-0aebc0e67a1b
timestamp: 2026-05-16T10:13:27.761189+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b03297450f4c1d72da09cc8f
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.761189+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.761189+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "GF", "isin": null, "provider": "openfigi", "provider_symbol": "BBG000DGZJ27", "ticker": "APC"}


audit_id: b8952c37-e0a5-4789-9ae4-dfdd54da692f
timestamp: 2026-05-16T10:13:27.773411+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_5b8346c3bf234f99d608b6d3
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.773411+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.773411+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "LU", "isin": null, "provider": "openfigi", "provider_symbol": "BBG000DGZJ27", "ticker": "APC"}


audit_id: 5ec2c5be-37f4-4e78-ab0e-0ef3f3f85c5e
timestamp: 2026-05-16T10:13:27.785448+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_eb408b27c09e65519eb2977c
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.785448+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.785448+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "OD", "isin": null, "provider": "openfigi", "provider_symbol": "BBG01Z6HN5H2", "ticker": "APC"}


audit_id: d6b3b97e-e6ab-4055-a030-b73506005928
timestamp: 2026-05-16T10:13:27.803752+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_4b66be1f54e3dd230c446261
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.803752+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.803752+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "PS", "isin": null, "provider": "openfigi", "provider_symbol": "BBG000CDYDR2", "ticker": "APC"}


audit_id: e606b5b8-3931-403f-b030-bdf94ed9561f
timestamp: 2026-05-16T10:13:27.815491+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ffd04dfc93256de8c0c13a7e
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.815491+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.815491+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "M-MKT", "isin": null, "provider": "openfigi", "provider_symbol": "BBG0013R72V8", "ticker": "APC"}


audit_id: 93be51fe-206f-4066-991a-473ba934e65b
timestamp: 2026-05-16T10:13:27.824970+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_262b56ea4f3a7727062ca877
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.824970+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.824970+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "GZ", "isin": null, "provider": "openfigi", "provider_symbol": "BBG00FGWYHQ5", "ticker": "APC"}


audit_id: 8a88114a-7b9e-42b3-a0e2-0a504853f3e8
timestamp: 2026-05-16T10:13:27.833816+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_cb012a9bdf524c20bac4780e
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.833816+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.833816+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "VF", "isin": null, "provider": "openfigi", "provider_symbol": "BBG01Z6HN5H2", "ticker": "APC"}


audit_id: f508da05-605b-4721-b994-d4a8b1b08d3c
timestamp: 2026-05-16T10:13:27.844327+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_392cb0947652e3e7ae98ccc4
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:27.844327+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:27.844327+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "CURNCY", "isin": null, "provider": "openfigi", "provider_symbol": "KKG00000DG62", "ticker": "APC"}


audit_id: 4fc26c6a-721a-4135-af7c-b092cdad2c05
timestamp: 2026-05-16T10:13:39.904838+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_4bc35e4f0e8eb79439567414
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.904838+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.904838+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_4bc35e4f0e8eb79439567414", "country": "Common Stock", "created_at": "2026-05-16T10:13:27.709465+00:00", "exchange": "GD", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.709465+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "GD", "provider_symbol": "BBG000DGZJ27", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.709465+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "GD", "isin": null, "provider": "openfigi", "provider_symbol": "BBG000DGZJ27", "ticker": "APC"}


audit_id: f3017f78-526e-4cd7-9ae4-109c51e28959
timestamp: 2026-05-16T10:13:39.923437+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_bf03d726da62a83a7b1a6cf1
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.923437+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.923437+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_bf03d726da62a83a7b1a6cf1", "country": "Common Stock", "created_at": "2026-05-16T10:13:27.738793+00:00", "exchange": "VP", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.738793+00:00", "name": "ARKO PETROLEUM CORP", "normalized_name": "arko petroleum corp", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "VP", "provider_symbol": "BBG01Z6HN5H2", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.738793+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "VP", "isin": null, "provider": "openfigi", "provider_symbol": "BBG01Z6HN5H2", "ticker": "APC"}


audit_id: 6e107e96-92f0-49b0-ada3-ee8e3e4e5af4
timestamp: 2026-05-16T10:13:39.931847+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b03297450f4c1d72da09cc8f
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.931847+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.931847+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b03297450f4c1d72da09cc8f", "country": "Common Stock", "created_at": "2026-05-16T10:13:27.760733+00:00", "exchange": "GF", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.760733+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "GF", "provider_symbol": "BBG000DGZJ27", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.760733+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "GF", "isin": null, "provider": "openfigi", "provider_symbol": "BBG000DGZJ27", "ticker": "APC"}


audit_id: e813ca08-d7d4-474e-95c5-c8d03de8662a
timestamp: 2026-05-16T10:13:39.946877+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_5b8346c3bf234f99d608b6d3
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.946877+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.946877+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_5b8346c3bf234f99d608b6d3", "country": "Common Stock", "created_at": "2026-05-16T10:13:27.772938+00:00", "exchange": "LU", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.772938+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "LU", "provider_symbol": "BBG000DGZJ27", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.772938+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "LU", "isin": null, "provider": "openfigi", "provider_symbol": "BBG000DGZJ27", "ticker": "APC"}


audit_id: 6c8a2451-99b6-4771-b738-d7bf4595e8ee
timestamp: 2026-05-16T10:13:39.957776+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_eb408b27c09e65519eb2977c
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.957776+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.957776+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_eb408b27c09e65519eb2977c", "country": "Common Stock", "created_at": "2026-05-16T10:13:27.785102+00:00", "exchange": "OD", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.785102+00:00", "name": "ARKO PETROLEUM CORP", "normalized_name": "arko petroleum corp", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "OD", "provider_symbol": "BBG01Z6HN5H2", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.785102+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "OD", "isin": null, "provider": "openfigi", "provider_symbol": "BBG01Z6HN5H2", "ticker": "APC"}


audit_id: 5a8bb314-830c-4cf5-878b-b89a37b6d9b3
timestamp: 2026-05-16T10:13:39.966818+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_4b66be1f54e3dd230c446261
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.966818+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.966818+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_4b66be1f54e3dd230c446261", "country": "Common Stock", "created_at": "2026-05-16T10:13:27.803577+00:00", "exchange": "PS", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.803577+00:00", "name": "ARAB CO FOR PAINT PRODUCTS", "normalized_name": "arab co for paint products", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "PS", "provider_symbol": "BBG000CDYDR2", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.803577+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "PS", "isin": null, "provider": "openfigi", "provider_symbol": "BBG000CDYDR2", "ticker": "APC"}


audit_id: e7e6784f-c109-4d00-b440-ca286c4eb4a7
timestamp: 2026-05-16T10:13:39.977621+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ffd04dfc93256de8c0c13a7e
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.977621+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.977621+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_ffd04dfc93256de8c0c13a7e", "country": "CP", "created_at": "2026-05-16T10:13:27.815377+00:00", "exchange": "M-MKT", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.815377+00:00", "name": "ANADARKO PETROLEUM CORP", "normalized_name": "anadarko petroleum corp", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "M-MKT", "provider_symbol": "BBG0013R72V8", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.815377+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "M-MKT", "isin": null, "provider": "openfigi", "provider_symbol": "BBG0013R72V8", "ticker": "APC"}


audit_id: 6bda09e2-d024-477e-8791-dfcf530b1aa3
timestamp: 2026-05-16T10:13:39.990147+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_262b56ea4f3a7727062ca877
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.990147+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.990147+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_262b56ea4f3a7727062ca877", "country": "Common Stock", "created_at": "2026-05-16T10:13:27.824876+00:00", "exchange": "GZ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.824876+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "GZ", "provider_symbol": "BBG00FGWYHQ5", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.824876+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "GZ", "isin": null, "provider": "openfigi", "provider_symbol": "BBG00FGWYHQ5", "ticker": "APC"}


audit_id: b930a6f5-198f-4b18-aae5-8c5610f72400
timestamp: 2026-05-16T10:13:39.998767+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_cb012a9bdf524c20bac4780e
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:39.998767+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:39.998767+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_cb012a9bdf524c20bac4780e", "country": "Common Stock", "created_at": "2026-05-16T10:13:27.833739+00:00", "exchange": "VF", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.833739+00:00", "name": "ARKO PETROLEUM CORP", "normalized_name": "arko petroleum corp", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "VF", "provider_symbol": "BBG01Z6HN5H2", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.833739+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "VF", "isin": null, "provider": "openfigi", "provider_symbol": "BBG01Z6HN5H2", "ticker": "APC"}


audit_id: 1c3bdb7c-c43f-4d42-9533-fd654723615b
timestamp: 2026-05-16T10:13:40.009093+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_392cb0947652e3e7ae98ccc4
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:13:40.009093+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:40.009093+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_392cb0947652e3e7ae98ccc4", "country": "CRYPTO", "created_at": "2026-05-16T10:13:27.844249+00:00", "exchange": "CURNCY", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:27.844249+00:00", "name": "AlpaCoin", "normalized_name": "alpacoin", "notes": "OpenFIGI search result; manual selection required", "provider": "openfigi", "provider_market": "CURNCY", "provider_symbol": "KKG00000DG62", "sector": null, "source": "openfigi", "source_confidence": "medium", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:27.844249+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "CURNCY", "isin": null, "provider": "openfigi", "provider_symbol": "KKG00000DG62", "ticker": "APC"}


audit_id: 5e3de14d-2eda-4db5-b73f-0547c10bfe17
timestamp: 2026-05-16T10:13:45.697101+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_41abf936994d808d5c2d7b42
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.697101+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.697101+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "NASDAQ", "isin": "US04124A1007", "provider": "fmp", "provider_symbol": "APC", "ticker": "APC"}


audit_id: b946af87-07d4-4d3c-b57c-c66685ad962f
timestamp: 2026-05-16T10:13:45.719965+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_03532f3866c8050ce335692e
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.719965+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.719965+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "NYSE", "isin": "KYG040581061", "provider": "fmp", "provider_symbol": "APCA", "ticker": "APCA"}


audit_id: 40bbd64c-11e7-4f19-910c-15925b7ccb93
timestamp: 2026-05-16T10:13:45.736846+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_2db9ef643c9b45b63d6dc28d
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.736846+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.736846+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "US03834B3096", "provider": "fmp", "provider_symbol": "APCX", "ticker": "APCX"}


audit_id: 8aaf8d7b-a135-4c67-98bc-c2a4b8cd9892
timestamp: 2026-05-16T10:13:45.746320+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1d11a25924afb8a52b683434
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.746320+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.746320+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "AMEX", "isin": "US89834G7521", "provider": "fmp", "provider_symbol": "APCB", "ticker": "APCB"}


audit_id: d3c8f9b6-c502-44a0-829d-86f19efbe545
timestamp: 2026-05-16T10:13:45.759021+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_63b166220793ce68e952cabc
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.759021+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.759021+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": null, "provider": "fmp", "provider_symbol": "APCDF", "ticker": "APCDF"}


audit_id: 55facc68-a5bb-4a3a-88cb-bd51fe94fc8a
timestamp: 2026-05-16T10:13:45.769423+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b2b42fc5b01c9fd14c0b1d29
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.769423+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.769423+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "CA0249441001", "provider": "fmp", "provider_symbol": "APCOF", "ticker": "APCOF"}


audit_id: 932b10f3-7cd4-4867-85b2-eeb9c097f883
timestamp: 2026-05-16T10:13:45.778786+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_dd302faa88a3ecf9cf2460f8
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.778786+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.778786+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "FSX", "isin": "US0378331005", "provider": "fmp", "provider_symbol": "APC.F", "ticker": "APC"}


audit_id: 9b34715d-d5eb-437a-a30e-bdc2aa7c9c19
timestamp: 2026-05-16T10:13:45.790095+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_fbf7a87fa0c955233fffaba0
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.790095+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.790095+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "NASDAQ", "isin": "US03834B1272", "provider": "fmp", "provider_symbol": "APCXW", "ticker": "APCXW"}


audit_id: 61bffea6-fbb6-49ff-a9c0-2a1a0f3a0bef
timestamp: 2026-05-16T10:13:45.798409+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_dcdbed61dbed65b93db28fd3
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.798409+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.798409+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "ASX", "isin": "AU000000APC7", "provider": "fmp", "provider_symbol": "APC.AX", "ticker": "APC"}


audit_id: b1570652-25e0-4b35-910b-2a407322e995
timestamp: 2026-05-16T10:13:45.806579+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_50321460ee722e812bdadcf8
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.806579+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.806579+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "XETRA", "isin": "US0378331005", "provider": "fmp", "provider_symbol": "APC.DE", "ticker": "APC"}


audit_id: 1cb28828-cc64-42e8-88f9-2705e8aa1124
timestamp: 2026-05-16T10:13:45.815798+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_450df5da8850e9c85b249b04
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.815798+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.815798+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "TAI", "isin": "TW0006108004", "provider": "fmp", "provider_symbol": "6108.TW", "ticker": "6108"}


audit_id: 0cadeb47-7d28-45ce-9825-b026e968b8db
timestamp: 2026-05-16T10:13:45.825140+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_95d4488d0c72e94e631fa2a6
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.825140+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.825140+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "BSE", "isin": "INE116A01032", "provider": "fmp", "provider_symbol": "APCOTEXIND.BO", "ticker": "APCOTEXIND"}


audit_id: d408da7a-d684-4c78-9f5b-adbec00f20b5
timestamp: 2026-05-16T10:13:45.833401+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_2ffefb72416ba2fc5c4fcba0
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.833401+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.833401+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "NSE", "isin": "INE116A01032", "provider": "fmp", "provider_symbol": "APCOTEXIND.NS", "ticker": "APCOTEXIND"}


audit_id: 0c980bfa-2573-4a4e-8618-263e59f3dcd8
timestamp: 2026-05-16T10:13:45.843694+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b777367c9efc39f7695ecf9c
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.843694+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.843694+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "ASX", "isin": "AU000000BAP9", "provider": "fmp", "provider_symbol": "BAP.AX", "ticker": "BAP"}


audit_id: 8e6b9364-c6ec-48de-b68c-e1d29c349ae0
timestamp: 2026-05-16T10:13:45.853151+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a54186b4d10109b8b62e19b9
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.853151+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.853151+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "JPX", "isin": "JP3218900003", "provider": "fmp", "provider_symbol": "9697.T", "ticker": "9697"}


audit_id: 14e9a169-e38a-4715-8855-6356156e347b
timestamp: 2026-05-16T10:13:45.862772+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_e0e4b9e7e3f942aa99de0cca
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.862772+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.862772+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "JP3218900003", "provider": "fmp", "provider_symbol": "CCOEF", "ticker": "CCOEF"}


audit_id: 58d80b06-1b7a-443e-9131-aeb1bf0626a0
timestamp: 2026-05-16T10:13:45.871585+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_8f1820c2461be85c6523eb42
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.871585+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.871585+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "US13916V1070", "provider": "fmp", "provider_symbol": "CCOEY", "ticker": "CCOEY"}


audit_id: 40699e18-1e87-4bd4-84cf-3e5a873a4acf
timestamp: 2026-05-16T10:13:45.880936+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ac8a580088c29222dd1c54a7
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.880936+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.880936+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "US0778271033", "provider": "fmp", "provider_symbol": "BLIS", "ticker": "BLIS"}


audit_id: bb77333e-202c-43f2-8df9-e52ccbeb6695
timestamp: 2026-05-16T10:13:45.891280+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_33a64cbb9c5074056de756b1
old_values_json: {}
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:45.891280+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:45.891280+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "HKSE", "isin": "KYG5380R1103", "provider": "fmp", "provider_symbol": "8472.HK", "ticker": "8472"}


audit_id: ba6e81f6-87fd-4957-93cf-4a90c2dbca7a
timestamp: 2026-05-16T10:13:50.385718+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a9a414a5debaab353feffe09
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.385718+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.385718+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "NASDAQ NMS - GLOBAL MARKET", "isin": null, "provider": "finnhub", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 62f3b877-8f90-4c1e-941d-fbe7c564e73a
timestamp: 2026-05-16T10:13:50.407351+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_03749250208af9a6068af45c
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.407351+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.407351+00:00
new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.DE", "ticker": "APC"}


audit_id: 488103c3-625a-4876-aa59-8cc633baf682
timestamp: 2026-05-16T10:13:50.420749+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1a72e6f70f9f9e306267f380
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.420749+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.420749+00:00
new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.AX", "ticker": "APC"}


audit_id: 991de97f-b67d-4629-bcfe-fc4a66c55d09
timestamp: 2026-05-16T10:13:50.430150+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_12617ecd3bb2d1e0d20b4396
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.430150+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.430150+00:00
new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.DU", "ticker": "APC"}


audit_id: 80c05a62-0b04-4f8f-98e4-343fd3c86db9
timestamp: 2026-05-16T10:13:50.439338+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_44a9454072324d848015ec6b
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.439338+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.439338+00:00
new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.F", "ticker": "APC"}


audit_id: 368593f8-7c97-4d12-8561-5e9125a6cd1f
timestamp: 2026-05-16T10:13:50.448407+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_f8e0012fef2140bf3f0742ef
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.448407+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.448407+00:00
new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.HM", "ticker": "APC"}


audit_id: 45767da6-01e3-44e7-a631-cfbcc4e87984
timestamp: 2026-05-16T10:13:50.458012+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_40aa71425eef7fa8eeded689
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.458012+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.458012+00:00
new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.MU", "ticker": "APC"}


audit_id: b62362d0-5488-4bf3-b708-1a6a0310bfbb
timestamp: 2026-05-16T10:13:50.467192+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_3f09ca120dad3c2c04d23aa2
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.467192+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.467192+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "PHILIPPINE STOCK EXCHANGE, INC.", "isin": null, "provider": "finnhub", "provider_symbol": "APC.PM", "ticker": "APC"}


audit_id: e0eb7ad2-8696-4219-8037-74f51c834c54
timestamp: 2026-05-16T10:13:50.476042+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_3438a622c62e2c7b43788fc0
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.476042+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.476042+00:00
new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.SG", "ticker": "APC"}


audit_id: 82495379-0f3a-4a07-946c-82ca3995a8ec
timestamp: 2026-05-16T10:13:50.484475+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_d82c0e75843d3d8b8d2d5e3b
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:13:50.484475+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.484475+00:00
new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.VN", "ticker": "APC"}


audit_id: beb2789b-5e46-43f6-ad64-e97092179a52
timestamp: 2026-05-16T10:13:50.724348+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_c77d8279ad78e196f7cbf674
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.724348+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.724348+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "XETR", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 8cd50453-eb63-4b5a-9068-6115a0ece321
timestamp: 2026-05-16T10:13:50.742128+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_4e08243eea13260b6cc2061f
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.742128+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.742128+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "NYSE", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 5eb8eccc-ca02-4855-a2d6-8730cf225a5e
timestamp: 2026-05-16T10:13:50.756475+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ce6b9d56a408fcfb5105781e
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.756475+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.756475+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "FSX", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: c5a42313-78df-4199-b397-59d45415e405
timestamp: 2026-05-16T10:13:50.770375+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_4c43465d6268a69501f719a5
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.770375+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.770375+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "XSTU", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: db6a3d27-4259-47dc-82b2-cba80ce0a410
timestamp: 2026-05-16T10:13:50.783434+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_cb3abd03289be749adb8dca2
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.783434+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.783434+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "MUNICH", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 5660e1c6-969b-41d5-90d3-f174491a55a8
timestamp: 2026-05-16T10:13:50.796940+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a3e1c58bbfd774e7e51b727a
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.796940+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.796940+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "XDUS", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 2194b173-d68e-4cb4-89ea-890ce5fe12cd
timestamp: 2026-05-16T10:13:50.813804+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b1c90cc5e79548e3d57948c4
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.813804+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.813804+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "CXA", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 4b327430-5a4d-4209-8687-fa4850e3fb46
timestamp: 2026-05-16T10:13:50.827884+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a58e0dfd92ce1fdd131af63a
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.827884+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.827884+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "XHAN", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: f54c5707-a71a-4c29-8638-90a3bae62b2d
timestamp: 2026-05-16T10:13:50.841773+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_e3e9d8d1b2da528ced13937a
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.841773+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.841773+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "ASX", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 3c520f3d-810d-4af0-80d5-fb64da98828a
timestamp: 2026-05-16T10:13:50.860045+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_23381f8924609829c31c437d
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:13:50.860045+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:50.860045+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "FSX", "isin": null, "provider": "twelvedata", "provider_symbol": "APC0", "ticker": "APC0"}


audit_id: 462a5cae-551e-47af-80c7-8d4ee55dd89f
timestamp: 2026-05-16T10:13:51.609052+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_deb762872f42985c61b2ba82
old_values_json: {}
user_text_note: Cache explicit instrument search result from massive
confirmation_timestamp: 2026-05-16T10:13:51.609052+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:51.609052+00:00
new_values_json:
  {"asset_class": "stock", "exchange": "XNAS", "isin": null, "provider": "massive", "provider_symbol": "APC", "ticker": "APC"}


audit_id: ea1752a3-761f-4eea-8c36-5c5b9b136aa8
timestamp: 2026-05-16T10:13:56.859817+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_41abf936994d808d5c2d7b42
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.859817+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.859817+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_41abf936994d808d5c2d7b42", "country": "US", "created_at": "2026-05-16T10:13:45.695793+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US04124A1007", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.695793+00:00", "name": "ARKO Petroleum Corp. Class A Common Stock", "normalized_name": "arko petroleum corp class a common stock", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NASDAQ", "provider_symbol": "APC", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APC", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.695793+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "NASDAQ", "isin": "US04124A1007", "provider": "fmp", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 3cf64e2a-6db3-496a-83cb-99ba26a8e0c8
timestamp: 2026-05-16T10:13:56.874916+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_03532f3866c8050ce335692e
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.874916+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.874916+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_03532f3866c8050ce335692e", "country": "HK", "created_at": "2026-05-16T10:13:45.719441+00:00", "exchange": "NYSE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "KYG040581061", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.719441+00:00", "name": "AP Acquisition Corp.", "normalized_name": "ap acquisition corp", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NYSE", "provider_symbol": "APCA", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APCA", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.719441+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "NYSE", "isin": "KYG040581061", "provider": "fmp", "provider_symbol": "APCA", "ticker": "APCA"}


audit_id: 284f82f8-705e-45ec-8bb0-b9ac88b64f87
timestamp: 2026-05-16T10:13:56.885429+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_2db9ef643c9b45b63d6dc28d
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.885429+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.885429+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_2db9ef643c9b45b63d6dc28d", "country": "US", "created_at": "2026-05-16T10:13:45.736681+00:00", "exchange": "OTC", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US03834B3096", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.736681+00:00", "name": "AppTech Payments Corp.", "normalized_name": "apptech payments corp", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "OTC", "provider_symbol": "APCX", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APCX", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.736681+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "US03834B3096", "provider": "fmp", "provider_symbol": "APCX", "ticker": "APCX"}


audit_id: be0a982e-11fc-47e6-ad7d-489d2b76ff50
timestamp: 2026-05-16T10:13:56.896688+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1d11a25924afb8a52b683434
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.896688+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.896688+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_1d11a25924afb8a52b683434", "country": "US", "created_at": "2026-05-16T10:13:45.746153+00:00", "exchange": "AMEX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US89834G7521", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.746153+00:00", "name": "ActivePassive Core Bond ETF", "normalized_name": "activepassive core bond etf", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "AMEX", "provider_symbol": "APCB", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APCB", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.746153+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "AMEX", "isin": "US89834G7521", "provider": "fmp", "provider_symbol": "APCB", "ticker": "APCB"}


audit_id: 4753eaad-39a9-4571-b1de-5b0cca1b96e3
timestamp: 2026-05-16T10:13:56.905442+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_63b166220793ce68e952cabc
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.905442+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.905442+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_63b166220793ce68e952cabc", "country": "AU", "created_at": "2026-05-16T10:13:45.758880+00:00", "exchange": "OTC", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:45.758880+00:00", "name": "A-Cap Energy Limited", "normalized_name": "a cap energy limited", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "OTC", "provider_symbol": "APCDF", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APCDF", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.758880+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": null, "provider": "fmp", "provider_symbol": "APCDF", "ticker": "APCDF"}


audit_id: 03659a38-14aa-4292-b5a3-a4cb370fe541
timestamp: 2026-05-16T10:13:56.913767+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b2b42fc5b01c9fd14c0b1d29
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.913767+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.913767+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b2b42fc5b01c9fd14c0b1d29", "country": "CA", "created_at": "2026-05-16T10:13:45.769279+00:00", "exchange": "OTC", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "CA0249441001", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.769279+00:00", "name": "American Critical Minerals Corp.", "normalized_name": "american critical minerals corp", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "OTC", "provider_symbol": "APCOF", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APCOF", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.769279+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "CA0249441001", "provider": "fmp", "provider_symbol": "APCOF", "ticker": "APCOF"}


audit_id: dfbc1f29-6b7c-4eef-a91a-947b6fbc6267
timestamp: 2026-05-16T10:13:56.924721+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_dd302faa88a3ecf9cf2460f8
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.924721+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.924721+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_dd302faa88a3ecf9cf2460f8", "country": "US", "created_at": "2026-05-16T10:13:45.778618+00:00", "exchange": "FSX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US0378331005", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.778618+00:00", "name": "Apple Inc.", "normalized_name": "apple inc", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "FSX", "provider_symbol": "APC.F", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APC", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:45.778618+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "FSX", "isin": "US0378331005", "provider": "fmp", "provider_symbol": "APC.F", "ticker": "APC"}


audit_id: f7d4bfc0-ff7e-49db-a3dd-c62c9eb90556
timestamp: 2026-05-16T10:13:56.933610+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_fbf7a87fa0c955233fffaba0
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.933610+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.933610+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_fbf7a87fa0c955233fffaba0", "country": "US", "created_at": "2026-05-16T10:13:45.789932+00:00", "exchange": "NASDAQ", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US03834B1272", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.789932+00:00", "name": "AppTech Payments Corp.", "normalized_name": "apptech payments corp", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NASDAQ", "provider_symbol": "APCXW", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APCXW", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.789932+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "NASDAQ", "isin": "US03834B1272", "provider": "fmp", "provider_symbol": "APCXW", "ticker": "APCXW"}


audit_id: f35eaef0-91be-47ca-abc5-4cc84cadcd49
timestamp: 2026-05-16T10:13:56.942624+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_dcdbed61dbed65b93db28fd3
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.942624+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.942624+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_dcdbed61dbed65b93db28fd3", "country": "AU", "created_at": "2026-05-16T10:13:45.798252+00:00", "exchange": "ASX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "AUD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "AU000000APC7", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.798252+00:00", "name": "APC Minerals Limited", "normalized_name": "apc minerals limited", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "ASX", "provider_symbol": "APC.AX", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APC", "trading_currency": "AUD", "updated_at": "2026-05-16T10:13:45.798252+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "ASX", "isin": "AU000000APC7", "provider": "fmp", "provider_symbol": "APC.AX", "ticker": "APC"}


audit_id: f50efaaa-79db-41e8-80ec-46886eac62fc
timestamp: 2026-05-16T10:13:56.953330+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_50321460ee722e812bdadcf8
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.953330+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.953330+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_50321460ee722e812bdadcf8", "country": "US", "created_at": "2026-05-16T10:13:45.806453+00:00", "exchange": "XETRA", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US0378331005", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.806453+00:00", "name": "Apple Inc.", "normalized_name": "apple inc", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "XETRA", "provider_symbol": "APC.DE", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APC", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:45.806453+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "XETRA", "isin": "US0378331005", "provider": "fmp", "provider_symbol": "APC.DE", "ticker": "APC"}


audit_id: a6ab88fa-f370-4690-8543-11691d0d6983
timestamp: 2026-05-16T10:13:56.961744+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_450df5da8850e9c85b249b04
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.961744+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.961744+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_450df5da8850e9c85b249b04", "country": "TW", "created_at": "2026-05-16T10:13:45.815679+00:00", "exchange": "TAI", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "TWD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "TW0006108004", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.815679+00:00", "name": "APCB Inc.", "normalized_name": "apcb inc", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "TAI", "provider_symbol": "6108.TW", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "6108", "trading_currency": "TWD", "updated_at": "2026-05-16T10:13:45.815679+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "TAI", "isin": "TW0006108004", "provider": "fmp", "provider_symbol": "6108.TW", "ticker": "6108"}


audit_id: 93ff890c-be61-40f8-898d-50360e549804
timestamp: 2026-05-16T10:13:56.970646+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_95d4488d0c72e94e631fa2a6
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.970646+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.970646+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_95d4488d0c72e94e631fa2a6", "country": "IN", "created_at": "2026-05-16T10:13:45.825004+00:00", "exchange": "BSE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "INR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "INE116A01032", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.825004+00:00", "name": "Apcotex Industries Limited", "normalized_name": "apcotex industries limited", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "BSE", "provider_symbol": "APCOTEXIND.BO", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APCOTEXIND", "trading_currency": "INR", "updated_at": "2026-05-16T10:13:45.825004+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "BSE", "isin": "INE116A01032", "provider": "fmp", "provider_symbol": "APCOTEXIND.BO", "ticker": "APCOTEXIND"}


audit_id: fe7869a1-b9e3-41e8-a219-8149d5a7d77c
timestamp: 2026-05-16T10:13:56.981553+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_2ffefb72416ba2fc5c4fcba0
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.981553+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.981553+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_2ffefb72416ba2fc5c4fcba0", "country": "IN", "created_at": "2026-05-16T10:13:45.833304+00:00", "exchange": "NSE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "INR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "INE116A01032", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.833304+00:00", "name": "Apcotex Industries Limited", "normalized_name": "apcotex industries limited", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "NSE", "provider_symbol": "APCOTEXIND.NS", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "APCOTEXIND", "trading_currency": "INR", "updated_at": "2026-05-16T10:13:45.833304+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "NSE", "isin": "INE116A01032", "provider": "fmp", "provider_symbol": "APCOTEXIND.NS", "ticker": "APCOTEXIND"}


audit_id: 4394787f-e86b-407b-8208-c754d53e1bb0
timestamp: 2026-05-16T10:13:56.990000+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b777367c9efc39f7695ecf9c
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.990000+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.990000+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b777367c9efc39f7695ecf9c", "country": "AU", "created_at": "2026-05-16T10:13:45.843529+00:00", "exchange": "ASX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "AUD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "AU000000BAP9", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.843529+00:00", "name": "Bapcor Limited", "normalized_name": "bapcor limited", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "ASX", "provider_symbol": "BAP.AX", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "BAP", "trading_currency": "AUD", "updated_at": "2026-05-16T10:13:45.843529+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "ASX", "isin": "AU000000BAP9", "provider": "fmp", "provider_symbol": "BAP.AX", "ticker": "BAP"}


audit_id: 9be1d2d7-1b65-473f-923d-8fe17df79dd7
timestamp: 2026-05-16T10:13:56.998443+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a54186b4d10109b8b62e19b9
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:56.998443+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:56.998443+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_a54186b4d10109b8b62e19b9", "country": "JP", "created_at": "2026-05-16T10:13:45.853030+00:00", "exchange": "JPX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "JPY", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "JP3218900003", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.853030+00:00", "name": "Capcom Co., Ltd.", "normalized_name": "capcom co ltd", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "JPX", "provider_symbol": "9697.T", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "9697", "trading_currency": "JPY", "updated_at": "2026-05-16T10:13:45.853030+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "JPX", "isin": "JP3218900003", "provider": "fmp", "provider_symbol": "9697.T", "ticker": "9697"}


audit_id: dcb00d45-5b68-4202-be62-39243abd73d7
timestamp: 2026-05-16T10:13:57.009095+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_e0e4b9e7e3f942aa99de0cca
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:57.009095+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:57.009095+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_e0e4b9e7e3f942aa99de0cca", "country": "JP", "created_at": "2026-05-16T10:13:45.862579+00:00", "exchange": "OTC", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "JP3218900003", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.862579+00:00", "name": "Capcom Co., Ltd.", "normalized_name": "capcom co ltd", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "OTC", "provider_symbol": "CCOEF", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "CCOEF", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.862579+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "JP3218900003", "provider": "fmp", "provider_symbol": "CCOEF", "ticker": "CCOEF"}


audit_id: 42d5ef74-ea27-4eb1-bd8d-8438f2ff28d2
timestamp: 2026-05-16T10:13:57.017796+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_8f1820c2461be85c6523eb42
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:57.017796+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:57.017796+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_8f1820c2461be85c6523eb42", "country": "JP", "created_at": "2026-05-16T10:13:45.871352+00:00", "exchange": "OTC", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US13916V1070", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.871352+00:00", "name": "Capcom Co., Ltd.", "normalized_name": "capcom co ltd", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "OTC", "provider_symbol": "CCOEY", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "CCOEY", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.871352+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "US13916V1070", "provider": "fmp", "provider_symbol": "CCOEY", "ticker": "CCOEY"}


audit_id: b9209638-2050-4278-8e0c-87723f523720
timestamp: 2026-05-16T10:13:57.026317+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ac8a580088c29222dd1c54a7
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:57.026317+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:57.026317+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_ac8a580088c29222dd1c54a7", "country": "US", "created_at": "2026-05-16T10:13:45.880782+00:00", "exchange": "OTC", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "US0778271033", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.880782+00:00", "name": "NAPC Defense, Inc.", "normalized_name": "napc defense inc", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "OTC", "provider_symbol": "BLIS", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "BLIS", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:45.880782+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "OTC", "isin": "US0778271033", "provider": "fmp", "provider_symbol": "BLIS", "ticker": "BLIS"}


audit_id: b2ad7ede-ced9-4332-b97c-ba37186dea97
timestamp: 2026-05-16T10:13:57.036916+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_33a64cbb9c5074056de756b1
user_text_note: Cache explicit instrument search result from fmp
confirmation_timestamp: 2026-05-16T10:13:57.036916+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:13:57.036916+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_33a64cbb9c5074056de756b1", "country": "HK", "created_at": "2026-05-16T10:13:45.891136+00:00", "exchange": "HKSE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "HKD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": "KYG5380R1103", "issuer": null, "last_verified_at": "2026-05-16T10:13:45.891136+00:00", "name": "Lapco Holdings Limited", "normalized_name": "lapco holdings limited", "notes": "Financial Modeling Prep stable search/profile result; manual selection required", "provider": "fmp", "provider_market": "HKSE", "provider_symbol": "8472.HK", "sector": null, "source": "fmp", "source_confidence": "medium", "ticker": "8472", "trading_currency": "HKD", "updated_at": "2026-05-16T10:13:45.891136+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "HKSE", "isin": "KYG5380R1103", "provider": "fmp", "provider_symbol": "8472.HK", "ticker": "8472"}


audit_id: 813556ee-cd92-45f5-acd9-8f44001bb31f
timestamp: 2026-05-16T10:14:01.830957+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a9a414a5debaab353feffe09
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.830957+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.830957+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_a9a414a5debaab353feffe09", "country": "US", "created_at": "2026-05-16T10:13:50.385453+00:00", "exchange": "NASDAQ NMS - GLOBAL MARKET", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.385453+00:00", "name": "ARKO PETROLEUM CORP", "normalized_name": "arko petroleum corp", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": "NASDAQ NMS - GLOBAL MARKET", "provider_symbol": "APC", "sector": null, "source": "finnhub", "source_confidence": "medium", "ticker": "APC", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:50.385453+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "NASDAQ NMS - GLOBAL MARKET", "isin": null, "provider": "finnhub", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 30fa489e-9ef5-4e98-9ad2-c9f31c5ad06d
timestamp: 2026-05-16T10:14:01.855274+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_03749250208af9a6068af45c
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.855274+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.855274+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_03749250208af9a6068af45c", "country": null, "created_at": "2026-05-16T10:13:50.406870+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.406870+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "APC.DE", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:50.406870+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.DE", "ticker": "APC"}


audit_id: 5803b83f-dfa2-4f3e-bfed-37ed4c540663
timestamp: 2026-05-16T10:14:01.873576+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_1a72e6f70f9f9e306267f380
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.873576+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.873576+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_1a72e6f70f9f9e306267f380", "country": null, "created_at": "2026-05-16T10:13:50.420644+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.420644+00:00", "name": "APC MINERALS LTD", "normalized_name": "apc minerals ltd", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "APC.AX", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:50.420644+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.AX", "ticker": "APC"}


audit_id: 49a98d3f-327a-4f89-aaa2-501928bc8bfe
timestamp: 2026-05-16T10:14:01.883580+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_12617ecd3bb2d1e0d20b4396
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.883580+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.883580+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_12617ecd3bb2d1e0d20b4396", "country": null, "created_at": "2026-05-16T10:13:50.430058+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.430058+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "APC.DU", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:50.430058+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.DU", "ticker": "APC"}


audit_id: acdb7ea1-bbb0-4ed8-9831-074781be184d
timestamp: 2026-05-16T10:14:01.892691+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_44a9454072324d848015ec6b
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.892691+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.892691+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_44a9454072324d848015ec6b", "country": null, "created_at": "2026-05-16T10:13:50.439258+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.439258+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "APC.F", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:50.439258+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.F", "ticker": "APC"}


audit_id: 2854cd9c-eb39-4037-80a7-877009b0c3ce
timestamp: 2026-05-16T10:14:01.909408+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_f8e0012fef2140bf3f0742ef
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.909408+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.909408+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_f8e0012fef2140bf3f0742ef", "country": null, "created_at": "2026-05-16T10:13:50.448326+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.448326+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "APC.HM", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:50.448326+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.HM", "ticker": "APC"}


audit_id: 1311e376-bcb5-48a2-983f-92400f023c8c
timestamp: 2026-05-16T10:14:01.925126+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_40aa71425eef7fa8eeded689
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.925126+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.925126+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_40aa71425eef7fa8eeded689", "country": null, "created_at": "2026-05-16T10:13:50.457855+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.457855+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "APC.MU", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:50.457855+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.MU", "ticker": "APC"}


audit_id: a5b64dd7-5931-47be-a5c8-db0a3b5956eb
timestamp: 2026-05-16T10:14:01.938830+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_3f09ca120dad3c2c04d23aa2
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.938830+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.938830+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_3f09ca120dad3c2c04d23aa2", "country": "PH", "created_at": "2026-05-16T10:13:50.467075+00:00", "exchange": "PHILIPPINE STOCK EXCHANGE, INC.", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "PHP", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.467075+00:00", "name": "APC GROUP INC", "normalized_name": "apc group inc", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": "PHILIPPINE STOCK EXCHANGE, INC.", "provider_symbol": "APC.PM", "sector": null, "source": "finnhub", "source_confidence": "medium", "ticker": "APC", "trading_currency": "PHP", "updated_at": "2026-05-16T10:13:50.467075+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "PHILIPPINE STOCK EXCHANGE, INC.", "isin": null, "provider": "finnhub", "provider_symbol": "APC.PM", "ticker": "APC"}


audit_id: 4bc794f4-a0e5-423b-9db3-f4356ab51251
timestamp: 2026-05-16T10:14:01.955551+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_3438a622c62e2c7b43788fc0
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.955551+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.955551+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_3438a622c62e2c7b43788fc0", "country": null, "created_at": "2026-05-16T10:13:50.475952+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.475952+00:00", "name": "APPLE INC", "normalized_name": "apple inc", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "APC.SG", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:50.475952+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.SG", "ticker": "APC"}


audit_id: 7852fcf4-8743-40a8-90ed-0ba1e7b78d8e
timestamp: 2026-05-16T10:14:01.969375+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_d82c0e75843d3d8b8d2d5e3b
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:14:01.969375+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:01.969375+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_d82c0e75843d3d8b8d2d5e3b", "country": null, "created_at": "2026-05-16T10:13:50.484394+00:00", "exchange": null, "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": null, "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.484394+00:00", "name": "AN PHU IRRADIATION JSC", "normalized_name": "an phu irradiation jsc", "notes": "Finnhub symbol/profile/quote lookup; manual selection required", "provider": "finnhub", "provider_market": null, "provider_symbol": "APC.VN", "sector": null, "source": "finnhub", "source_confidence": "low", "ticker": "APC", "trading_currency": null, "updated_at": "2026-05-16T10:13:50.484394+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "APC.VN", "ticker": "APC"}


audit_id: ea906514-c495-4a56-a058-b37e113c1b53
timestamp: 2026-05-16T10:14:02.187422+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_c77d8279ad78e196f7cbf674
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.187422+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.187422+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_c77d8279ad78e196f7cbf674", "country": "GERMANY", "created_at": "2026-05-16T10:13:50.724105+00:00", "exchange": "XETR", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.724105+00:00", "name": "Apple Inc.", "normalized_name": "apple inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "XETR", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:50.724105+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "XETR", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 540bcf1b-c6f7-453e-8282-9e6172449eaf
timestamp: 2026-05-16T10:14:02.218758+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_4e08243eea13260b6cc2061f
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.218758+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.218758+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_4e08243eea13260b6cc2061f", "country": "UNITED STATES", "created_at": "2026-05-16T10:13:50.741966+00:00", "exchange": "NYSE", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.741966+00:00", "name": "Arko Petroleum Corp.", "normalized_name": "arko petroleum corp", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "NYSE", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:50.741966+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "NYSE", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 8304e3d6-d3c5-4caf-8786-eed9e0b973c7
timestamp: 2026-05-16T10:14:02.237871+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_ce6b9d56a408fcfb5105781e
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.237871+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.237871+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_ce6b9d56a408fcfb5105781e", "country": "GERMANY", "created_at": "2026-05-16T10:13:50.756360+00:00", "exchange": "FSX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.756360+00:00", "name": "Apple Inc.", "normalized_name": "apple inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "FSX", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:50.756360+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "FSX", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: aa74e0c2-c6c5-4798-b19c-19cae5b7caa2
timestamp: 2026-05-16T10:14:02.255633+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_4c43465d6268a69501f719a5
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.255633+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.255633+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_4c43465d6268a69501f719a5", "country": "GERMANY", "created_at": "2026-05-16T10:13:50.770262+00:00", "exchange": "XSTU", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.770262+00:00", "name": "Apple Inc.", "normalized_name": "apple inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "XSTU", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:50.770262+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "XSTU", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: f29dd5b4-0503-48e0-9afd-8cf5a2946150
timestamp: 2026-05-16T10:14:02.276824+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_cb3abd03289be749adb8dca2
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.276824+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.276824+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_cb3abd03289be749adb8dca2", "country": "GERMANY", "created_at": "2026-05-16T10:13:50.783344+00:00", "exchange": "MUNICH", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.783344+00:00", "name": "Apple Inc.", "normalized_name": "apple inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "MUNICH", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:50.783344+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "MUNICH", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 147835d2-9006-4e9f-b9d3-a2fd5a21e518
timestamp: 2026-05-16T10:14:02.295925+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a3e1c58bbfd774e7e51b727a
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.295925+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.295925+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_a3e1c58bbfd774e7e51b727a", "country": "GERMANY", "created_at": "2026-05-16T10:13:50.796852+00:00", "exchange": "XDUS", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.796852+00:00", "name": "Apple Inc.", "normalized_name": "apple inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "XDUS", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:50.796852+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "XDUS", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: e2105517-4adf-4dd2-8aa5-c227d869d674
timestamp: 2026-05-16T10:14:02.312420+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b1c90cc5e79548e3d57948c4
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.312420+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.312420+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_b1c90cc5e79548e3d57948c4", "country": "AUSTRALIA", "created_at": "2026-05-16T10:13:50.813722+00:00", "exchange": "CXA", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "AUD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.813722+00:00", "name": "APC Minerals Limited", "normalized_name": "apc minerals limited", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "CXA", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "AUD", "updated_at": "2026-05-16T10:13:50.813722+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "CXA", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: a36e1032-464e-40b6-a323-d9b98cbfb1f1
timestamp: 2026-05-16T10:14:02.335906+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a58e0dfd92ce1fdd131af63a
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.335906+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.335906+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_a58e0dfd92ce1fdd131af63a", "country": "GERMANY", "created_at": "2026-05-16T10:13:50.827810+00:00", "exchange": "XHAN", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.827810+00:00", "name": "Apple Inc.", "normalized_name": "apple inc", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "XHAN", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:50.827810+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "XHAN", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 56938b6d-d619-41c1-ad6e-dfc9e40e74cd
timestamp: 2026-05-16T10:14:02.348748+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_e3e9d8d1b2da528ced13937a
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.348748+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.348748+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_e3e9d8d1b2da528ced13937a", "country": "AUSTRALIA", "created_at": "2026-05-16T10:13:50.841698+00:00", "exchange": "ASX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "AUD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.841698+00:00", "name": "APC Minerals Limited", "normalized_name": "apc minerals limited", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "ASX", "provider_symbol": "APC", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC", "trading_currency": "AUD", "updated_at": "2026-05-16T10:13:50.841698+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "ASX", "isin": null, "provider": "twelvedata", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 3b2e46fe-8a0f-4dc5-800c-a30b38393b2d
timestamp: 2026-05-16T10:14:02.361705+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_23381f8924609829c31c437d
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:14:02.361705+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:02.361705+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_23381f8924609829c31c437d", "country": "GERMANY", "created_at": "2026-05-16T10:13:50.859964+00:00", "exchange": "FSX", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "EUR", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:50.859964+00:00", "name": "Apple Inc. Depositary Receipt (APC0)", "normalized_name": "apple inc depositary receipt apc0", "notes": "Twelve Data symbol search result; manual selection required", "provider": "twelvedata", "provider_market": "FSX", "provider_symbol": "APC0", "sector": null, "source": "twelvedata", "source_confidence": "medium", "ticker": "APC0", "trading_currency": "EUR", "updated_at": "2026-05-16T10:13:50.859964+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "FSX", "isin": null, "provider": "twelvedata", "provider_symbol": "APC0", "ticker": "APC0"}


audit_id: 180b3220-61dd-4a99-904b-3b5393622b50
timestamp: 2026-05-16T10:14:03.133883+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_deb762872f42985c61b2ba82
user_text_note: Cache explicit instrument search result from massive
confirmation_timestamp: 2026-05-16T10:14:03.133883+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:14:03.133883+00:00
old_values_json:
  {"asset_class": "stock", "catalog_entry_id": "catalog_deb762872f42985c61b2ba82", "country": "US", "created_at": "2026-05-16T10:13:51.608482+00:00", "exchange": "XNAS", "fund_type": null, "hedge_status": "unknown", "hedged_to_currency": null, "instrument_currency": "USD", "instrument_status": "unknown", "is_currency_hedged": null, "isin": null, "issuer": null, "last_verified_at": "2026-05-16T10:13:51.608482+00:00", "name": "ARKO Petroleum Corp. Class A Common Stock", "normalized_name": "arko petroleum corp class a common stock", "notes": "Massive reference ticker result; US-focused fallback; manual selection required", "provider": "massive", "provider_market": "XNAS", "provider_symbol": "APC", "sector": null, "source": "massive", "source_confidence": "medium", "ticker": "APC", "trading_currency": "USD", "updated_at": "2026-05-16T10:13:51.608482+00:00", "valuation_policy": "live_price"}

new_values_json:
  {"asset_class": "stock", "exchange": "XNAS", "isin": null, "provider": "massive", "provider_symbol": "APC", "ticker": "APC"}


audit_id: 542da18b-052d-4733-8bb2-72c97b0d90e9
timestamp: 2026-05-16T10:17:10.536556+00:00
source: instrument_price_mapping
action: confirm_instrument_price_mapping
entity_type: instrument_price_mapping
entity_id: ipm_104913188419781369c02b8b
old_values_json: {}
user_text_note: test1
confirmation_timestamp: 2026-05-16T10:17:10.536556+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-16T10:17:10.536556+00:00
new_values_json:
  {"hedge_status": "unknown", "instrument_id": "instrument_392d921609e628de82d985fa", "instrument_status": "unknown", "provider": "fmp", "provider_market": "FSX", "provider_symbol": "APC.F", "valuation_policy": "live_price"}


audit_id: ecdfd29a-828b-4f2b-9055-4705a78c6426
timestamp: 2026-05-16T10:20:28.332325+00:00
source: instrument_search_add_position
action: manual_position_add
entity_type: transaction
entity_id: tx_f100e0c20260c668982daa22
old_values_json: {}
user_text_note: test1
confirmation_timestamp: 2026-05-16T10:20:28.332325+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-16T10:20:28.332325+00:00
new_values_json:
  {"account_id": "account_89dada5563cc9139ffb4bdf5", "catalog_entry_id": "catalog_dd302faa88a3ecf9cf2460f8", "instrument_id": "instrument_392d921609e628de82d985fa", "transaction_type": "initial_position_snapshot"}


audit_id: ce0fab23-334f-4c1c-aad3-ec888fb75305
timestamp: 2026-05-16T10:26:23.970826+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a162eee2e891b4f9e091f7d3
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:23.970826+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:23.970826+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "SW", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000J19HG2", "ticker": "ZGLD"}


audit_id: 2334055c-df23-4dea-951b-1c9adc3926d4
timestamp: 2026-05-16T10:26:23.990834+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_a05ec647cee7c5c4a3f558d7
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:23.990834+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:23.990834+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "SE", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000J19HG2", "ticker": "ZGLD"}


audit_id: 84c387dd-04bc-4482-9e54-39d76b35a2e6
timestamp: 2026-05-16T10:26:24.002962+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_478f7a859ee4b2a2beca56a4
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:24.002962+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:24.002962+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "X2", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000W11JF2", "ticker": "ZGLD"}


audit_id: decaabc1-dbd2-4a01-ab7f-58f421130361
timestamp: 2026-05-16T10:26:24.036052+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_7d84216cc9c5b65a5ad49696
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:24.036052+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:24.036052+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "XE", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000W11JF2", "ticker": "ZGLD"}


audit_id: ad62d2d8-9afe-41fa-9842-5ab7e39f7cca
timestamp: 2026-05-16T10:26:24.072320+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_e65e002dca2534f23d3bf257
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:24.072320+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:24.072320+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "XL", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000W11JF2", "ticker": "ZGLD"}


audit_id: b80cd908-13e6-48c2-b654-c0e8e0227363
timestamp: 2026-05-16T10:26:24.103521+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_5ee9f92e0b767c431768e690
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:24.103521+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:24.103521+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "XO", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000W11JF2", "ticker": "ZGLD"}


audit_id: 341ac754-0b99-47cf-805c-e5e8612e0f0a
timestamp: 2026-05-16T10:26:24.123027+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_38d20119c720a9d8c720adf5
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:24.123027+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:24.123027+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "E1", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000W11JF2", "ticker": "ZGLD"}


audit_id: 1bb7b5d4-e92b-43ab-9e4b-2f2086e68a94
timestamp: 2026-05-16T10:26:24.131464+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_230f80a3879abfb89dba9690
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:24.131464+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:24.131464+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "XT", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000W11JF2", "ticker": "ZGLD"}


audit_id: 811ba311-66cb-476c-9a4c-a075efac8e53
timestamp: 2026-05-16T10:26:24.141482+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_3a0077f36db2d7cba9ed73dc
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:24.141482+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:24.141482+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "XW", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG000W11JF2", "ticker": "ZGLD"}


audit_id: fd4e1843-ed2a-46f8-a0f2-0d4ec1691de5
timestamp: 2026-05-16T10:26:24.157707+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_b225fd6afb7add9b9a84163a
old_values_json: {}
user_text_note: Cache explicit instrument search result from openfigi
confirmation_timestamp: 2026-05-16T10:26:24.157707+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:24.157707+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "EU", "isin": "CH0139101593", "provider": "openfigi", "provider_symbol": "BBG001KWSJH4", "ticker": "ZGLD"}


audit_id: 5c440b59-b0e0-4721-9a32-1a9590454ab5
timestamp: 2026-05-16T10:26:28.009513+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_34c38e3634bc5b757897f050
old_values_json: {}
user_text_note: Cache explicit instrument search result from finnhub
confirmation_timestamp: 2026-05-16T10:26:28.009513+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:28.009513+00:00
new_values_json:
  {"asset_class": "etf", "exchange": null, "isin": null, "provider": "finnhub", "provider_symbol": "ZGLD.SW", "ticker": "ZGLD"}


audit_id: 4e4882ee-7226-4c2e-be0d-620579c8f3e6
timestamp: 2026-05-16T10:26:28.274082+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_995cad5321c74174247f1ce6
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:26:28.274082+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:28.274082+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "SIX", "isin": null, "provider": "twelvedata", "provider_symbol": "ZGLD", "ticker": "ZGLD"}


audit_id: f6e1f801-3af5-4ff5-95ba-752ce8716aef
timestamp: 2026-05-16T10:26:28.296955+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_707aa645b169e0b0f1abbf7a
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:26:28.296955+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:28.296955+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "LSE", "isin": null, "provider": "twelvedata", "provider_symbol": "0VR3", "ticker": "0VR3"}


audit_id: 0e088743-c73d-4040-9ddb-ecd370cc3455
timestamp: 2026-05-16T10:26:28.312177+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_305bb386697fb6146838e81b
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:26:28.312177+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:28.312177+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "XHAM", "isin": null, "provider": "twelvedata", "provider_symbol": "ZBK5", "ticker": "ZBK5"}


audit_id: 610550b7-6454-4362-9119-103da3415416
timestamp: 2026-05-16T10:26:28.325227+00:00
source: instrument_catalog
action: upsert_catalog_entry
entity_type: instrument_catalog_entry
entity_id: catalog_934248458afd5c915acae6e7
old_values_json: {}
user_text_note: Cache explicit instrument search result from twelvedata
confirmation_timestamp: 2026-05-16T10:26:28.325227+00:00
created_by: dashboard_search
quality_status: ok
created_at: 2026-05-16T10:26:28.325227+00:00
new_values_json:
  {"asset_class": "etf", "exchange": "CBOE", "isin": null, "provider": "twelvedata", "provider_symbol": "ZGLDZ", "ticker": "ZGLDZ"}


audit_id: 349a0abd-c9b1-43b7-ac29-44c38635c5f2
timestamp: 2026-05-16T10:27:50.989726+00:00
source: instrument_price_mapping
action: confirm_instrument_price_mapping
entity_type: instrument_price_mapping
entity_id: ipm_7f440cadfc018c2e5c6185e7
old_values_json: {}
user_text_note: test1
confirmation_timestamp: 2026-05-16T10:27:50.989726+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-16T10:27:50.989726+00:00
new_values_json:
  {"hedge_status": "unknown", "instrument_id": "instrument_5a523c2f16389f35ef848f74", "instrument_status": "unknown", "provider": "openfigi", "provider_market": "SW", "provider_symbol": "BBG000J19HG2", "valuation_policy": "live_price"}


audit_id: 0ad2f34f-6288-4ec1-b1f0-55d4be2a26b6
timestamp: 2026-05-16T10:27:51.022610+00:00
source: instrument_search_add_position
action: manual_position_add
entity_type: transaction
entity_id: tx_f3aab21c9ecb5abb1c5b1332
old_values_json: {}
user_text_note: test1
confirmation_timestamp: 2026-05-16T10:27:51.022610+00:00
created_by: dashboard
quality_status: ok
created_at: 2026-05-16T10:27:51.022610+00:00
new_values_json:
  {"account_id": "account_78124e879623a70c1cf0c1cb", "catalog_entry_id": "catalog_a162eee2e891b4f9e091f7d3", "instrument_id": "instrument_5a523c2f16389f35ef848f74", "transaction_type": "initial_position_snapshot"}


# transactions

transaction_id: tx-0870b5b9-0c4e-4ffb-94b5-4eef18009b99
transaction_type: initial_position_snapshot
account_id: true-wealth-review-brokerage
instrument_id: instrument-US9229087690
trade_date: 2026-05-14
settlement_date: 2026-05-14
quantity: 128
price_original: 364.71
currency_original: USD
fx_source: missing_in_source
fx_status: missing
gross_amount_chf: 36482.67
source_type: broker_import_reviewed_snapshot
source_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
external_transaction_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
row_hash: d91dcdb723e0725fc4d721d2c3083d3609a33c1bd04c191d3d548fbfaa55d38a
quality_status: warning
created_at: 2026-05-15T10:21:23.938094+00:00
updated_at: 2026-05-15T10:21:23.938094+00:00
notes:
  Initial Snapshot from reviewed True Wealth dry-run execution plan; cost basis/FX incomplete; no positions_snapshot direct write.


# broker_import_dry_runs

dry_run_id: 465c61a7-855a-494c-bf1f-0d7eedda91b7
source_name: PostFinance
source_platform: PostFinance
source_file_label: [runtime-file-redacted]
source_file_type: docx
source_hash: 59ec092da349092c29187801b3b96d77e7685cf22ca667f56b5703fac3f73040
source_filename_hash: 59ec092da349092c29187801b3b96d77e7685cf22ca667f56b5703fac3f73040
snapshot_date_status: missing
detected_sections_json: ["table_1", "table_2", "table_3", "table_4", "table_5"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.590490+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"cost_basis_uncertain": 33, "missing_isin": 33, "missing_ticker": 33, "needs_manual_review": 34, "snapshot_only": 34}

summary_json:
  {"blocked_positions": 33, "candidate_cash_rows": 1, "candidate_positions": 33, "mapped_positions": 0, "rows_total": 40, "source_file_type": "docx", "source_platform": "PostFinance"}


dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
source_name: True Wealth
source_platform: True Wealth
source_file_label: [runtime-file-redacted]
source_file_type: docx
source_hash: 6d55404a91397dc52b8162663c15de00172f9c806d3803db9114a3e970ec63a8
source_filename_hash: 6d55404a91397dc52b8162663c15de00172f9c806d3803db9114a3e970ec63a8
snapshot_date_status: missing
detected_sections_json: ["table_1"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.610688+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"cost_basis_uncertain": 17, "missing_isin": 17, "missing_ticker": 17, "needs_manual_review": 18, "snapshot_only": 18}

summary_json:
  {"blocked_positions": 17, "candidate_cash_rows": 1, "candidate_positions": 17, "mapped_positions": 0, "rows_total": 19, "source_file_type": "docx", "source_platform": "True Wealth"}


dry_run_id: cc21d566-0eeb-4e1f-ab69-f9b99356073d
source_name: Raiffeisen
source_platform: Raiffeisen
source_file_label: [runtime-file-redacted]
source_file_type: xlsx
source_hash: 67e2f92384bf608c8e06772c90519fbfce8f8f58ed475d4cee5c87dd263d476f
source_filename_hash: 67e2f92384bf608c8e06772c90519fbfce8f8f58ed475d4cee5c87dd263d476f
snapshot_date_status: missing
detected_sections_json: ["sheet_1"]
field_coverage_json: {}
created_at: 2026-05-15T09:35:47.626152+00:00
notes: dry-run summary only; no productive ledger writes
quality_flags_json:
  {"aggregate_only": 4, "cash_snapshot_candidate": 3, "missing_instrument_details": 4, "needs_manual_review": 7}

summary_json:
  {"blocked_positions": 4, "candidate_cash_rows": 3, "candidate_positions": 4, "mapped_positions": 0, "rows_total": 8, "source_file_type": "xlsx", "source_platform": "Raiffeisen"}


# broker_import_execution_plans

execution_plan_id: plan-9122f3c2-eb76-4f92-b95d-1f9c2a99f686
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 9122f3c2-eb76-4f92-b95d-1f9c2a99f686
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US9229087690
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: d91dcdb723e0725fc4d721d2c3083d3609a33c1bd04c191d3d548fbfaa55d38a
execution_status: imported
transaction_id: tx-0870b5b9-0c4e-4ffb-94b5-4eef18009b99
created_at: 2026-05-15T10:20:15.960216+00:00
updated_at: 2026-05-15T10:21:23.938094+00:00
executed_at: 2026-05-15T10:21:23.938094+00:00
notes: B6b mini-import executed for exactly one reviewed payload.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "36482.67", "instrument_id": "instrument-US9229087690", "price_original": "364.71", "quantity": "128", "snapshot_date": "2026-05-14", "source_id": "9122f3c2-eb76-4f92-b95d-1f9c2a99f686", "source_row_ref": "table1:row14", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


execution_plan_id: plan-1c6136ca-852d-4467-ae87-4924ea2bd305
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 1c6136ca-852d-4467-ae87-4924ea2bd305
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US9220428588
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: 69b0d49e21558dff03555e0dd70509e800f81507a014215c18722548f809b63b
execution_status: imported
transaction_id: tx-e13645cf-1681-4ac8-b57d-981aad88098c
created_at: 2026-05-15T10:20:15.960591+00:00
updated_at: 2026-05-15T10:48:28.447099+00:00
executed_at: 2026-05-15T10:48:28.447099+00:00
notes: B6c second controlled mini-import from reviewed True Wealth execution plan; no mass import.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "11476.56", "instrument_id": "instrument-US9220428588", "price_original": "59.94", "quantity": "245", "snapshot_date": "2026-05-14", "source_id": "1c6136ca-852d-4467-ae87-4924ea2bd305", "source_row_ref": "table1:row15", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


execution_plan_id: plan-8cc9a511-e679-47ee-a57a-30fe53ea72a6
dry_run_id: 2761d82c-b80f-44d2-8c5f-d969e01b9912
review_item_id: 8cc9a511-e679-47ee-a57a-30fe53ea72a6
source_platform: True Wealth
target_account_id: true-wealth-review-brokerage
target_instrument_id: instrument-US92204A7028
transaction_type: initial_position_snapshot
snapshot_date: 2026-05-14
payload_status: ready
payload_quality_flags_json: ["cost_basis_uncertain", "fx_missing"]
source_row_hash: 4af3459e24c3edf73a406bad31c4ebe4ece6ca7dcefa8acb175c3d1798e49ca1
execution_status: imported
transaction_id: tx-aecd65d3-148f-4e45-9e19-d5c2d85e8133
created_at: 2026-05-15T10:20:15.960672+00:00
updated_at: 2026-05-15T10:58:02.510937+00:00
executed_at: 2026-05-15T10:58:02.510937+00:00
notes: B6d final controlled True Wealth mini-import from reviewed execution plan; no mass import.
planned_write_summary_json:
  {"account_id": "true-wealth-review-brokerage", "cost_basis_quality": "uncertain", "currency_original": "USD", "fx_rate_to_chf": null, "fx_status": "missing", "gross_amount_chf": "32095.35", "instrument_id": "instrument-US92204A7028", "price_original": "113.45", "quantity": "362", "snapshot_date": "2026-05-14", "source_id": "8cc9a511-e679-47ee-a57a-30fe53ea72a6", "source_row_ref": "table1:row17", "source_type": "broker_import_reviewed_snapshot", "trade_date": "2026-05-14", "transaction_type": "initial_position_snapshot"}


# instrument_price_mapping_candidates

candidate_id: ipmc_208b2282a32eef2a4890b7ab
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: openfigi
candidate_provider_symbol: VWO
candidate_exchange: US
candidate_currency: USD
candidate_name: VANGUARD FTSE EMERGING MARKE
candidate_instrument_status: unknown
confidence: high
evidence_source: openfigi_isin_mapping
evidence_note: ISIN match; currency match
review_status: selected
created_at: 2026-05-15T13:22:27.088798+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name passt fuzzy; OpenFIGI ISIN-Datenquelle


candidate_id: ipmc_5edff637f58a03d45e2785e7
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VWO
candidate_exchange: NYSEArca
candidate_currency: USD
candidate_name: Vanguard Emerging Markets Stock Index Fund
candidate_instrument_status: unknown
confidence: medium
evidence_source: yahoo_finance_search
evidence_note: ticker+exchange match; requires manual review
review_status: rejected
created_at: 2026-05-15T13:22:27.089261+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name teilweise ähnlich; Yahoo Search Fallback


candidate_id: ipmc_7bfb02f1cc92277e6a744dc0
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VEU.XA
candidate_exchange: CXA
candidate_currency: USD
candidate_name: VWORLDXUS CDI 1:1 [VEU]
candidate_instrument_status: unknown
confidence: low
evidence_source: yahoo_finance_search
evidence_note: name-only or weak provider match; manual review required
review_status: rejected
created_at: 2026-05-15T13:22:27.089323+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: equity
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
recommended_action: reject_candidate
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Yahoo Search Fallback

risk_flags:
  Assetklasse abweichend,Name unsicher,Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden


candidate_id: ipmc_8890e40a9041eafbac939cd2
instrument_id: instrument-US9220428588
isin: US9220428588
candidate_provider: yahoo_fallback
candidate_provider_symbol: VWOB260515C00067000
candidate_exchange: OPR
candidate_currency: USD
candidate_name: VWOB May 2026 67.000 call
candidate_instrument_status: unknown
confidence: medium
evidence_source: yahoo_finance_search
evidence_note: ticker+exchange match; requires manual review
review_status: rejected
created_at: 2026-05-15T13:22:27.089405+00:00
updated_at: 2026-05-15T14:31:15.866866+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Name unsicher,Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Yahoo Search Fallback


candidate_id: ipmc_e31b9b9f614991e30e953a0f
instrument_id: instrument-US92204A7028
isin: US92204A7028
candidate_provider: openfigi
candidate_provider_symbol: VGT
candidate_exchange: US
candidate_currency: USD
candidate_name: VANGUARD INFO TECH ETF
candidate_instrument_status: unknown
confidence: high
evidence_source: openfigi_isin_mapping
evidence_note: ISIN match; currency match
review_status: selected
created_at: 2026-05-15T13:22:27.968162+00:00
updated_at: 2026-05-15T14:31:47.037509+00:00
candidate_asset_class: etf
candidate_hedge_status: unknown
candidate_valuation_policy: live_price
risk_flags: Hedge unklar,Instrument-Status unklar,mehrere Listings/Kandidaten vorhanden
recommended_action: needs_manual_review
ranking_reason:
  ISIN passt exakt; Provider-Symbol vorhanden; Exchange vorhanden; Währung passt; Assetklasse passt; Name teilweise ähnlich; OpenFIGI ISIN-Datenquelle


# instrument_import_candidates

candidate_id: instrument_candidate_711133c470f8ef7b7641021f
source_file: 260514_Portfolio_True_Wealth.docx
platform: true_wealth
source_row_number: 25
raw_name: Vanguard Global ex-US Real Estate ETF
raw_ticker: GLOBAL
raw_isin: US9220426764
raw_currency: USD
raw_quantity: 232
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: high
proposed_name: Vanguard Global ex-US Real Estate ETF
proposed_ticker: GLOBAL
proposed_isin: US9220426764
proposed_currency: USD
proposed_asset_class: etf
mapping_status: exact_isin_match
created_at: 2026-05-15T19:51:37.173832+00:00
updated_at: 2026-05-15T20:48:32.707600+00:00
review_note:
  ISIN US9220426764 corresponds to Vanguard FTSE All-World ex-US Real Estate Index Fund ETF. Ticker GLOBAL is likely a platform-specific alias or error, but ISIN match is exact.


candidate_id: instrument_candidate_8d29cbe37d41f33d95ad161f
source_file: 260514_Portfolio_True_Wealth.docx
platform: true_wealth
source_row_number: 45
raw_name: L&G Longer Dated All Commodities UCITS ETF
raw_ticker: L
raw_isin: IE00B4WPHX27
raw_currency: USD
raw_quantity: 836
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: high
proposed_name: L&G Longer Dated All Commodities UCITS ETF
proposed_ticker: L
proposed_isin: IE00B4WPHX27
proposed_currency: USD
proposed_asset_class: etf
mapping_status: exact_isin_match
created_at: 2026-05-15T19:51:37.174436+00:00
updated_at: 2026-05-15T20:48:32.707660+00:00
review_note:
  Ticker 'L' is ambiguous and likely incorrect for this specific UCITS ETF. ISIN provided but requires verification against ticker.


candidate_id: instrument_candidate_37cfc02a663c3af46558a155
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 2
raw_name: / / 6 : : Konsolidiert in
raw_ticker: 16:23
raw_currency: CHF
raw_quantity: 14
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Unknown
proposed_ticker: 16:23
proposed_currency: CHF
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.197570+00:00
updated_at: 2026-05-15T20:48:32.707188+00:00
review_note:
  Ticker '16:23' and product name '/ / 6 : : Konsolidiert in' appear to be parsing errors or non-standard identifiers. Cannot map to a valid instrument. Requires manual review.


candidate_id: instrument_candidate_19c943637f01e4d7acc1885d
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 102
raw_name: ADBE
raw_ticker: ADBE
raw_currency: USD
raw_quantity: 20 260.65
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Adobe Inc.
proposed_ticker: ADBE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198000+00:00
updated_at: 2026-05-15T20:48:32.706450+00:00
review_note:
  ISIN is empty. Ticker ADBE corresponds to Adobe Inc., but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_90ea94052680d069c2265925
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 112
raw_name: ANET
raw_ticker: ANET
raw_currency: USD
raw_quantity: 36 143.60
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Arista Networks, Inc.
proposed_ticker: ANET
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198103+00:00
updated_at: 2026-05-15T20:48:32.706843+00:00
review_note:
  ISIN is empty. Ticker ANET corresponds to Arista Networks, but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_073d04d4cbe2e793877e6275
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 122
raw_name: APC
raw_ticker: APC
raw_currency: EUR
raw_quantity: 190
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Unknown/Deprecated
proposed_ticker: APC
proposed_currency: EUR
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198251+00:00
updated_at: 2026-05-15T20:48:32.706924+00:00
review_note:
  ISIN is empty. Ticker APC is ambiguous (e.g., Associated Press, or former APC Energy). Currency EUR suggests European listing, but ticker is primarily US. High risk of ambiguity. Manual verification required.


candidate_id: instrument_candidate_92a693b025538e765b52393e
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 132
raw_name: APP
raw_ticker: APP
raw_currency: USD
raw_quantity: 13 372.386
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: DoorDash, Inc.
proposed_ticker: DASH
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198350+00:00
updated_at: 2026-05-15T20:48:32.706965+00:00
review_note:
  ISIN is empty. Ticker APP is currently used by Booking Holdings (formerly Priceline). The product name 'APP' likely refers to DoorDash, which trades under DASH. Ticker mismatch detected. Manual verification required.


candidate_id: instrument_candidate_637d6d093be4a119fce6f939
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 143
raw_name: AVGO
raw_ticker: AVGO
raw_currency: USD
raw_quantity: 56
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Broadcom Inc.
proposed_ticker: AVGO
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198397+00:00
updated_at: 2026-05-15T20:48:32.707013+00:00
review_note:
  ISIN is empty. Ticker AVGO corresponds to Broadcom Inc., but without ISIN, exact match cannot be confirmed. Manual verification required.


candidate_id: instrument_candidate_ea496ba063247a7efbf2fc74
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 163
raw_name: BABA
raw_ticker: BABA
raw_currency: USD
raw_quantity: 46 170.82391
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Alibaba Group Holding Ltd
proposed_ticker: BABA
proposed_exchange: NYSE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198439+00:00
updated_at: 2026-05-15T20:48:32.707047+00:00
review_note:
  ISIN missing. Ticker BABA corresponds to Alibaba Group Holding Ltd on NYSE. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_19716bb81f8a16940852e7f1
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 172
raw_name: CRWD
raw_ticker: CRWD
raw_currency: USD
raw_quantity: 12 423.00
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: CrowdStrike Holdings Inc
proposed_ticker: CRWD
proposed_exchange: NASDAQ
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198480+00:00
updated_at: 2026-05-15T20:48:32.707077+00:00
review_note:
  ISIN missing. Ticker CRWD corresponds to CrowdStrike Holdings Inc on NASDAQ. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_1ec1155cea3d7ec5750a4c17
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 182
raw_name: GOOG
raw_ticker: GOOG
raw_currency: USD
raw_quantity: 96
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Alphabet Inc Class C
proposed_ticker: GOOG
proposed_exchange: NASDAQ
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198523+00:00
updated_at: 2026-05-15T20:48:32.707106+00:00
review_note:
  ISIN missing. Ticker GOOG corresponds to Alphabet Inc Class C on NASDAQ. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_2f05b84424048fa128f1a705
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 191
raw_name: MCD
raw_ticker: MCD
raw_currency: USD
raw_quantity: 14 129.97071
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: McDonald's Corp
proposed_ticker: MCD
proposed_exchange: NYSE
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198569+00:00
updated_at: 2026-05-15T20:48:32.707156+00:00
review_note:
  ISIN missing. Ticker MCD corresponds to McDonald's Corp on NYSE. Manual verification required to confirm ISIN and exchange.


candidate_id: instrument_candidate_4f35bed10b8653aff2436c97
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 201
raw_name: MSFT
raw_ticker: MSFT
raw_currency: USD
raw_quantity: 19 402.66
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: Microsoft Corporation
proposed_ticker: MSFT
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198611+00:00
updated_at: 2026-05-15T20:48:32.707227+00:00
review_note:
  ISIN is empty. Ticker alone is not enough for confirmation. Manual verification required to assign correct ISIN.


candidate_id: instrument_candidate_73995e5e983c42f19d7e3fde
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 253
raw_name: PANW
raw_ticker: PANW
raw_currency: USD
raw_quantity: 31 168.50
raw_asset_class: equity
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: PANW
proposed_ticker: PANW
proposed_currency: USD
proposed_asset_class: equity
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.198847+00:00
updated_at: 2026-05-15T20:48:32.707380+00:00
review_note:
  ISIN is empty. Ticker alone is not sufficient for confirmation. Manual verification required to assign correct ISIN and exchange.


candidate_id: instrument_candidate_d6dd6a84b6e7fc87d2282f7b
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 308
raw_name: BCHE
raw_ticker: BCHE
raw_currency: USD
raw_quantity: 98
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: BCHE
proposed_ticker: BCHE
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199052+00:00
updated_at: 2026-05-15T20:48:32.707511+00:00
review_note:
  ISIN is empty. Ticker BCHE is not unique enough for confirmation. Requires manual verification of the underlying asset.


candidate_id: instrument_candidate_bbbdba0e4d56ee9db9072c23
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 317
raw_name: IUIT
raw_ticker: IUIT
raw_currency: USD
raw_quantity: 400
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: IUIT
proposed_ticker: IUIT
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199090+00:00
updated_at: 2026-05-15T20:48:32.707541+00:00
review_note:
  ISIN is empty. Ticker IUIT is not unique enough for confirmation. Requires manual verification of the underlying asset.


candidate_id: instrument_candidate_2210109058da8500d7d28d97
source_file: 260514_Portfolio_Postfinance.docx
platform: postfinance
source_row_number: 326
raw_name: WTAI
raw_ticker: WTAI
raw_currency: USD
raw_quantity: 68
raw_asset_class: etf
extracted_by: deterministic_parser
extraction_confidence: medium
proposed_name: WTAI
proposed_ticker: WTAI
proposed_currency: USD
proposed_asset_class: etf
mapping_status: needs_manual_review
created_at: 2026-05-15T19:51:37.199141+00:00
updated_at: 2026-05-15T20:48:32.707567+00:00
review_note:
  ISIN is empty. Ticker WTAI is not unique enough for confirmation. Requires manual verification of the underlying asset.


