So if i understand it correctly, you don’t have an onchain metric that can tell you how many xpubs (zpubs …) own how many btc? Because that information is never included in transactions? 🤔
Discussion
Basically yes, a btc address is a hash derived from the pubkey, which is itself derived from the private key. Transactions include only sending and receiving addresses + signatures (derived directly from the private key).