Dump CHIPS addresses with positive balance

Simple utility to list all CHIPS 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:

sudo apt-get install python2.7-dev libleveldb-dev libsqlite3-dev

To install:

Since Ubuntu 20.04, python2.7-pip is no longer supported. You need to manually install it, as this repo is not compatible with python3.

Install pip for python2.7 with the following:

curl https://bootstrap.pypa.io/pip/2.7/get-pip.py --output get-pip.py # Fetch get-pip.py for python 2.7 
python2 get-pip.py

Verify your pip version with: pip --version

Then, manually install dependencies, as pip install -r requirements.txt is also not functional.

pip install plyvel==1.2.0
pip install base58
pip install pysqlite
pip install enum34

Usage

To use this script, you will need copy of chainstate database as created by CHIPS daemon.

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

Show help

python btcposbal2csv.py -h

Example:

The following will read from /home/USER/.chips/chainstate, and write result to /home/USER/addresses_with_balance.csv.

python btcposbal2csv.py /home/USER/.chips/chainstate /home/USER/addresses_with_balance.csv

Notice

• The output may not be complete as there are some transactions which are not understood by the decoding lib, or that which do not have "address" at all. Such transactions are not processed. Number of them and the total ammount in such transactions is displayed after the analysis.
• The output csv file only reflects the chainstate leveldb at 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/USER/addresses_with_balance.csv

Acknowledgement

This utility builds on 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.

FAQ

• Python 3 does not work. Yes, the the code is for python 2 - as stated in the requirements.
• Can this be used for coin XYZ? Currently only BTC is supported. The direct BTC derivatives (LTC, BCH, and others) should be fairly straitforward to add, other not so much.
• Currently this library is not actively developed. It is sufficient for my usecase. If you want some feature added, fork it, open PR, etc. Should some tips come in my way I would be much more inclined to develop this project more actively.