# 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}


# 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"}


# 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"}


