proger / utxo-dump

Bitcoind chainstate UTXOs to CSV

utxo-dump

Dump UTXOs from bitcoind (v0.15.x or newer) chainstate to csv.

Quick start (you need Nix 1.11.15 or newer):

$ git clone https://github.com/cryptah/utxo-dump ~/utxo-dump
$ cd ~/utxo-dump
$ nix-shell

## dump the chainstate database to CSV:

[nix-shell:~/utxo-dump]$ utxo2csv ~/.bitcoin/chainstate | pv > utxo.csv

## selectively parse pubkey scripts to human-readable list of opcodes:

[nix-shell:~/utxo-dump]$ tail utxo.csv | awk -F, '{print $7}' | python -mcryptah.script

The resulting csv file will be around 3x larger than the chainstate database, so plan accordingly.

utxo-dump's Issues

MULTISIG script address support

TRANSCATION is https://blockchain.info/tx/696f4c3686ac9ed5dd7ea6b37fc26830d690444420c89eaab642fd64e6270000

[nix-shell:~/utxo-dump]$ head -n666 utxo.csv |grep -v tx_id |grep -v p2pk|grep -v p2sh

696f4c3686ac9ed5dd7ea6b37fc26830d690444420c89eaab642fd64e6270000,1,0,320938,7800,unk,512102b37d95ab362de46450f8e6210b4a562b2d400943f7af188d398dfd9498c83ce1211c434e5452505254590000000000000000d806c1d50000005d653bd9080000000052ae
55a3f75f26e40035612b3bdcec54afbeb45596eea0f24ad7318e68b023740000,1,0,324911,1250,unk,51210309a1d83fa88602e6ae72cd2679cdb813df4ee889ce47cb4b8ecdd607e44526fe211c434e5452505254590000000000000000d806c1d500000042610c84050000000052ae

[nix-shell:~/utxo-dump]$ head -n666 utxo.csv |grep -v tx_id |grep -v p2pk|grep -v p2sh |head -1 |awk -F, '{print $7}' | python -mcryptah.script
1 <02b37d95ab362de46450f8e6210b4a562b2d400943f7af188d398dfd9498c83ce1> <1c434e5452505254590000000000000000d806c1d50000005d653bd90800000000> 2 OP_CHECKMULTISIG

litecoin label:enhancement

hello.
i am wondering if utxo-dump can easly be extend to litecoin/BCH and other btc blockchain forks ?
i am a bit lost never used nix-shell feature/api before ...
thanks.