Bitcoin Forum
June 21, 2024, 10:54:17 PM *
News: Voting for pizza day contest
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Anyone calculate amount of UTXO spent after Aug 1st on BCH chain?  (Read 430 times)
adaseb (OP)
Legendary
*
Offline Offline

Activity: 3794
Merit: 1723


View Profile
August 25, 2017, 08:13:06 AM
 #1

Wondering just how much of the Bitcoin Cash coins were actually sold. This seems like a very easy task, just need to calculate the total sum of all the UTXO after Aug 1st compared to today on the Bitcoin Cash chain.

Any easy way to do this on Python or if somebody already have calculated this for fun?
Coding Enthusiast
Legendary
*
Offline Offline

Activity: 1039
Merit: 2783


Bitcoin and C♯ Enthusiast


View Profile WWW
August 27, 2017, 02:03:36 PM
 #2

There is no way of knowing how much was "sold" using the blockchain.
But out of curiosity from block 478558 which was the fork, 22,093,618.96 BCC was transferred in 5288 blocks.

Process I used:
- Go to https://blockchair.com/bitcoin-cash/blocks
- Exclude blocks before fork height https://blockchair.com/bitcoin-cash/blocks?q=id(478558..)&s=id(desc)
- Export .CSV file
- In excell get the sum of input_total column.

Obviously this is not accurate either because this includes the change and the fees but not block reward.

Projects List+Suggestion box
Donate: 1Q9s or bc1q
|
|
|
FinderOuter(0.19.1)Ann-git
Denovo(0.7.0)Ann-git
Bitcoin.Net(0.26.0)Ann-git
|
|
|
BitcoinTransactionTool(0.11.0)Ann-git
WatchOnlyBitcoinWallet(3.2.1)Ann-git
SharpPusher(0.12.0)Ann-git
aleksej996
Sr. Member
****
Offline Offline

Activity: 490
Merit: 389


Do not trust the government


View Profile
August 27, 2017, 05:09:13 PM
 #3

I am not sure what input_total column would refer to, but I think it might be the sum of coins from all the inputs in those last blocks. This would include inputs from transactions that took place after the fork as well. Only the first block after fork would have all it's inputs from transactions before the fork, the second one could already have a transaction from the previous block as an input.
adaseb (OP)
Legendary
*
Offline Offline

Activity: 3794
Merit: 1723


View Profile
August 28, 2017, 07:55:38 AM
 #4

There is no way of knowing how much was "sold" using the blockchain.
But out of curiosity from block 478558 which was the fork, 22,093,618.96 BCC was transferred in 5288 blocks.

Process I used:
- Go to https://blockchair.com/bitcoin-cash/blocks
- Exclude blocks before fork height https://blockchair.com/bitcoin-cash/blocks?q=id(478558..)&s=id(desc)
- Export .CSV file
- In excell get the sum of input_total column.

Obviously this is not accurate either because this includes the change and the fees but not block reward.

Why don't you just take all the UTXO at the fork block and see which were spent, should be very accurate way of measuring.
Coding Enthusiast
Legendary
*
Offline Offline

Activity: 1039
Merit: 2783


Bitcoin and C♯ Enthusiast


View Profile WWW
August 29, 2017, 05:49:07 PM
 #5


Why don't you just take all the UTXO at the fork block and see which were spent, should be very accurate way of measuring.
Because I don't have the full blockchain at my disposal so I have to look for workarounds. If you have the blockchain and know how to read it then you can have a lot of fun trying different stuff Wink

Projects List+Suggestion box
Donate: 1Q9s or bc1q
|
|
|
FinderOuter(0.19.1)Ann-git
Denovo(0.7.0)Ann-git
Bitcoin.Net(0.26.0)Ann-git
|
|
|
BitcoinTransactionTool(0.11.0)Ann-git
WatchOnlyBitcoinWallet(3.2.1)Ann-git
SharpPusher(0.12.0)Ann-git
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!