Dump Bitcoin addresses with positive balance

Simple utility to list all bitcoin addresses with positive balance. It works by analysing the current unspent transaction output set (UTXO), aggregating outputs to same addresses together and write them to csv file.

Prequisities:

python 2.7
pip

To install:

make requirements.txt pip install -r requirements.txt

or install following packages with pip manualy

• hashlib (already included in modern Python installations)
• plyvel
• base58
• sqlite3 (already included in modern Python installations)

Usage

To use you will need copy of chainstate database as created by bitcoin core client. I've not tried different clients.

To get current addresses with positive balance, let the full node client sync with the network. Stop the bitcoin-core client before running this utility. If you not stop the client, the database might get corrupted.
Then run this program with path to chainstate directory (usually $HOME/.bitcoin/chainstate).

Show help

python btcposbal2csv.py -h

Example:

Following will read from $HOME/.bitcoin/chainstate, and write result to $HOME/addresses_with_balance.csv.

python btcposbal2csv.py $HOME/.bitcoin/chainstate $HOME/addresses_with_balance.csv

Or you can just accept the defaults in the Makefile, and run: make

Notice

• The output may not be complete, as there are some transactions which are not understood by the decoding lib, or which do not have "address" at all. Such transactions are not processed. The number of them and the total amount is displayed after the analysis.
• The output csv file only reflects the chainstate leveldb on your disk. So it will always be few blocks behind the network, as you need to stop the bitcoin-core client.

Converting to RIPEMD160

Per request, I'm adding script which is able to convert BTC address to RIPEMD160 representation. BTC address must be in fist column, RIPEMD160 is added to csv. Output goes to stdout.

Example:

python convert2ripemd160.py $HOME/addresses_with_balance.csv

Acknowledgement

This utility builds on the very nice bitcoin_tools lib, which does the UTXO parsing.

Support

If you like this utility, please consider supporting the bitcoin_tools library, which does all the heavy lifting.

If this particular functionality made your life easier, you can support coffee consumption in BTC, 1FxC1mgJkad63beJcECfZMRaFSf4PBLr2f.