Bitcoin Forum
April 28, 2024, 03:11:22 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Raw Bitcoin Address Data in ASCII text file comma separated value format  (Read 1698 times)
jratcliff63367 (OP)
Member
**
Offline Offline

Activity: 82
Merit: 10


View Profile
January 01, 2014, 10:01:43 PM
 #1

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

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

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

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

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
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

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/

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.
1714317082
Hero Member
*
Offline Offline

Posts: 1714317082

View Profile Personal Message (Offline)

Ignore
1714317082
Reply with quote  #2

1714317082
Report to moderator
1714317082
Hero Member
*
Offline Offline

Posts: 1714317082

View Profile Personal Message (Offline)

Ignore
1714317082
Reply with quote  #2

1714317082
Report to moderator
"There should not be any signed int. If you've found a signed int somewhere, please tell me (within the next 25 years please) and I'll change it to unsigned int." -- Satoshi
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714317082
Hero Member
*
Offline Offline

Posts: 1714317082

View Profile Personal Message (Offline)

Ignore
1714317082
Reply with quote  #2

1714317082
Report to moderator
bill32767
Newbie
*
Offline Offline

Activity: 26
Merit: 1


View Profile
March 02, 2019, 11:10:01 PM
 #2

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.
Pmalek
Legendary
*
Offline Offline

Activity: 2744
Merit: 7118



View Profile
March 03, 2019, 08:25:23 AM
 #3

@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 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.

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
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!