Bitcoin Forum

Bitcoin => Development & Technical Discussion => Topic started by: jratcliff63367 on January 01, 2014, 10:01:43 PM



Title: Raw Bitcoin Address Data in ASCII text file comma separated value format
Post by: jratcliff63367 on January 01, 2014, 10:01:43 PM
I finished up my blockchain parser and produced some interesting data output that I would like to share in the hopes that (a) other people find it useful and (b) other people do some interesting analysis/graphing/reporting on it and (c) to get some bitcoin tips for my effort.

The parser which produced this data is completely open source and consists of a *single* C++ file that is only about 4,000 lines of code that I wrote over Christmas break. 

Here are the links to the data.

The top 150,000 bitcoin addresses by balance and sorted by balance.

https://drive.google.com/file/d/0BwdyTvSh6bUkc2V3RUprclhCSUU/edit?usp=sharing (https://drive.google.com/file/d/0BwdyTvSh6bUkc2V3RUprclhCSUU/edit?usp=sharing)

The top 150,000 bitcoin addresses by balance and sorted by age in days.

https://drive.google.com/file/d/0BwdyTvSh6bUkNWF1ZzdmQVhVOXM/edit?usp=sharing (https://drive.google.com/file/d/0BwdyTvSh6bUkNWF1ZzdmQVhVOXM/edit?usp=sharing)

Some summary statistics about the blockchain measured over time month by month:

https://drive.google.com/file/d/0BwdyTvSh6bUkTm56bll1czk5MjA/edit?usp=sharing (https://drive.google.com/file/d/0BwdyTvSh6bUkTm56bll1czk5MjA/edit?usp=sharing)

The source code that produced this data can be found here:

https://code.google.com/p/blockchain/ (https://code.google.com/p/blockchain/)

To parse the blockchain you need only two source files:

BlockChain.h https://code.google.com/p/blockchain/source/browse/trunk/BlockChain.h (https://code.google.com/p/blockchain/source/browse/trunk/BlockChain.h)
BlockChain.cpp https://code.google.com/p/blockchain/source/browse/trunk/BlockChain.cpp (https://code.google.com/p/blockchain/source/browse/trunk/BlockChain.cpp)

The source that demonstrates how to use the parser is at:

https://code.google.com/p/blockchain/source/browse/trunk/main.cpp (https://code.google.com/p/blockchain/source/browse/trunk/main.cpp)

I have not tested this version on Linux yet.  I will try to get to that soon.  If someone else wants to make sure the Linux version still builds let me know and I will give you access to the project.  If you want to parse the blockchain only, that should work on a 32 bit machine.  However, if you want to process all transactions in the blockchain to produce these reports, you need a 64 bit machine as it allocates about 10gig of memory to assemble all of the data.

The blog post I made associated with this can be found here:

http://codesuppository.blogspot.com/ (http://codesuppository.blogspot.com/)

Over the next few days I plan to do some documentation and cleanup and a few other things.

At any rate, I hope you guys find the data useful.

The comma-separated-value text files contain the following information about each bitcoin address:

*Days since this address was used for a spend output.

*The current value at this address.

*The first time this address was ever used.

*The Last time bitcoins were sent to this address.

*The last time bitcoins were spent from this address (if ever)

*The total number of bitcoins spent from this address.

*The total number of bitcoins received to this address.

*The total number of transactions on this address.

*The public-key of the address.


Title: Re: Raw Bitcoin Address Data in ASCII text file comma separated value format
Post by: bill32767 on March 02, 2019, 11:10:01 PM
Nice one bro, I find your information very useful. Though this post is old, I hope you can respond and on time (if alive...lolzz) We I have a thousand list of address I need to check their balance (all at once maybe with a code or script to load the TXT file and display their balances). Checking them one after the other on the blockchain is stressful and can take my time. The list is made up of its private keys in Hex format arranged like this:

             *BITCOIN ADDRESS*                                                   *PRIVATE KEY IN HEX*

112puGbENBwLroiyaMwtDPLBCkdbRLBJbd      3A7BE45E33DDDEA55FC278BAECCB6163D7E4266EEB6F43C1F1F3837C24815E9A
112r2gz5LjoEdUsB4KEYnpSVxkTa8v3q6m       7B8D2B9229078635D15413C444E71EBAAE0D168F0C343F8278D648A33DA2F700
112ruKBUtZLLeuhapCSeJQiEHxci1jXnWH        EECE8A447C32B88E279D258CCE80A030AE4B9161F96320B8AAB0FE2FE0852BAB

I hope you understand me. Thanks.


Title: Re: Raw Bitcoin Address Data in ASCII text file comma separated value format
Post by: Pmalek on March 03, 2019, 08:25:23 AM
@bill32767 If you need to check multiple bitcoin addresses to find their balance take a look at the balance checker that the user hexafraction created a few years ago. I don't know if it still works.

Here is the original post for it:

OK, I'll do those momentarily.

Done. JAR (https://mega.nz/#!m4p2UbwR!jdxEDK_eDi_BJkRaGLO9AUw1YX9eFX5oYs7nYal5vNk) and source at https://github.com/hexafraction/btc-address-checker

If this program helps you then feel free to donate to the address under my profile info but do not feel obligated in any way to do so.