Get pubkeys out of Bitcoin block data (this was requested here). Note: this list is not meant for verbatim copy/pasting, it's my own notes of what I did (more or less). Get outputs data (currently 148 GB)

Code:

wget -r blockdata.loyce.club/outputs/

Get all addresses with pubkey

Code:

for day in `ls outputs/*gz`; do echo $day; gunzip -c | grep -v is_from_coinbase | grep -v pubkeyhash | grep pubkey | cut -f 1,2,4-11 >> output.txt; done

(output.txt includes more columns than strictly needed) Get currently funded Bitcoin addresses and their balance (1 GB)

Code:

wget addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz

Get all unique addresses that are in both lists

Code:

Get list of balances, addresses and pubkeys

Code:

(the last for-loop is quick and dirty, slow and inefficient, but considering there's not that much data, I didn't bother improving it)