I recalculated the storage requirement for a full node over 200 years, and the data size is only 105 TB. Satoshi's design is truly remarkable.
I've some doubts that your prediction of blockchain size is correct.
My full node shows this current space consumption:
666G ./blocks
12G ./chainstate
66G ./indexes
For a more accurate prediction it's necessary to look at the slope of growth since the time when blockchain data spammers started to congest mempools (Ordinals crap and similar bs). While there were periods of mempool congestion before Taproot for other reasons, mempools got emptied below blocksize limit eventually. Since a few years after inception of Ordinals and NFT crap on Bitcoin blockchain, I haven't observed non-full blocks (didn't check every block though) with exception of miners publishing "empty blocks" (only with mandatory coinbase transaction) occasionally.
16 years yielding 666GiB, I'm aware it's not been 16 years of full blocks, I hardly can believe your calculation of landing at 105TB (I assume you meant TiB) after 200 years.
My rough estimate with a growth slope of about 91GiB/y for the last two years
1, gives me a crude rough growth of 18,200 GiB in 200y which gives us a blockchain size in the ballpark of 18.x TiB. I'm pretty sure we'll have capable storage media and communication network technology by then to handle this easily.
[1] See graph with 3y- or 5y-view at
https://ycharts.com/indicators/bitcoin_blockchain_sizeBut anyway, that's not my gripe with your proposal. You don't provide any solution how to implement what you propose, so it's kind of empty and leaving out a picture of the required added complexity.
What about retrieval and verification of old transactions? Bitcoin's transaction model is not based on balances. It seams incompatible to me to suddenly add balances in some sort of "summary".
2. Archiving and Data Removal:
Once the summarized data is generated, older blocks are archived or removed from the active blockchain data. These older blocks are still available for reference, but no longer need to be part of the active ledger that full nodes must store.
And exactly how do you want to achieve this in a trustless and decentralized way? Remember some of the key design features of Bitcoin?
I don't want to repeat or go further into details of your proposal for now as I don't quite see the necessity as critized by prior replies.
Post edit: added reference to blockchain size graph