Read aggregate shielded-pool values without treating unknowns as zero
A chain analytics export can report aggregate value in Zcash pools without exposing recipient balances. The node also reports whether it monitors each pool.
Preserve the observation flag
For each pool keep its ID, the boolean monitored, and the optional amount in zatoshis. Sample all rows at the same tip hash. Store missing amounts as missing values in the destination schema.
zcash-cli getblockchaininfo | jq '{bestblockhash, pools: [.valuePools[] | {id, monitored, chainValueZat}]}'
Interpret a change in one pool
A rise in an aggregate pool value can reflect movement between pools. It cannot identify a user or establish a particular wallet's receipt. Before comparing snapshots, check that both contain measured amounts for the same pool and that chain reorganization did not change the sample history.