Ethdrain

Python 3 script allowing to copy and index the Ethereum blockchain in an efficient way to ElasticSearch by connecting to a local node supporting RPC (tried with Parity).

I hardcoded the use of Elasticsearch but feel free to fork it to support others.

Pull requests are welcome!

As of now, this tool saves all block data as well as the related transaction data. The relation is kept as follows:

• "ethereum-block" documents have:
  • a "transactionCount" property, with the count of their respective transactions.
  • a "transactions" property, with is an "array" of transaction hashes.
• "ethereum-transaction" documents have:
  • a "blockNumber" property, refering to their parent block.
  • a "blockTimestamp" property, refering to their parent block's timestamp.

The value of a transaction is stored in ether, not in wei and a sum is available at block level ("txValueSum" field).

The following fields are converted from their hex value to a real number:

• Block number
• Gas limit
• Gas used
• Size
• Transaction value

I was able to download the entire blockchain (3'400'000 block approx.) using this tool.

You can customize most of the useful parameters by tweaking the constants in the script:

# Elasticsearch maximum number of connectionsES_MAXSIZE = 10# Parallel processing semaphore sizeSEM_SIZE   = 256# Size of chunk size in blocksCHUNK_SIZE = 500# Size of multiprocessing Pool processing the chunksPOOL_SIZE  = 8

Basic examples

# Indexing blocks 0 to 5000> ./ethdrain.py -s 0 -e 5000# Indexing blocks 3'000'000 to the latest one> ./ethdrain.py -s 3000000# Starting from the latest block indexed by ES, indexing up to block 3'500'000> ./ethdrain.py -e 3500000# Automatic mode (could be used in a cron job).# Starting from the latest block indexed by ES to the latest one available on the local node> ./ethdrain.py

Continuous sync

In order to perform continuous sync of the blockchain, you can run the script without any parameters and use the watch command:

# Will index the missing block in elastic search every 10 secondswatch -n 10 ./ethdrain.py

Usage

>  ./ethdrain.py -husage: ethdrain.py [-h] [-s START_BLOCK] [-e END_BLOCK] [-f FILE] [-u ESURL]                   [-m ESMAXSIZE] [-r ETHRPCURL]optional arguments:  -h, --help            show this help message and exit  -s START_BLOCK, --start START_BLOCK                        What block to start indexing. If nothing is provided,                        the lastest block indexed in ElasticSearch will be                        used.  -e END_BLOCK, --end END_BLOCK                        What block to finish indexing. If nothing is provided,                        the latest one will be used.  -f FILE, --file FILE  Use an input file, each block number on a new line.  -u ESURL, --esurl ESURL                        The elasticsearch url and port. Accepts all the same                        parameters needed as a normal Elasticsearch client                        expects.  -m ESMAXSIZE, --esmaxsize ESMAXSIZE                        The elasticsearch max chunk size.  -r ETHRPCURL, --ethrpcurl ETHRPCURL                        The Ethereum RPC node url and port.

Benchmarks

Few benchmarks of copying blocks into ElasticSearch as well as all related transactions on an Intel i7-6700 @ 4GHz and 32GB of RAM. The POOL_SIZE parameter was set to 12.

Planned features

• Support of a graph database
• Indexing of addresses / contracts

To-do

• Friendly help/doc inside the script
• Include some unit-testing