List of all Bitcoin addresses with a balance

[bitxchange]

You deserve praise for making the list available and keeping updates running.

Have fun converting base58 and bech32 addresses to hash160, python style:

Code:

import segwit_addr
import base58
import argparse
import sys
import hashlib
import binascii

parser = argparse.ArgumentParser()
parser.add_argument('address', help='Enter bech32 address')
args = parser.parse_args()

address = sys.argv[1]

def validate_base58(a):
    base58Decoder = base58.b58decode(a).hex()
    prefixAndHash = base58Decoder[:len(base58Decoder)-8]
    checksum = base58Decoder[len(base58Decoder)-8:]
    hash = prefixAndHash
    for x in range(1,3):
        hash = hashlib.sha256(binascii.unhexlify(hash)).hexdigest()
        #print("Hash#", x, " : ", hash)
    #print("--------------------------------------")
    if(checksum == hash[:8]):
        return True
    else:
        return False

if validate_base58(address) is True:
    base58_decoded = base58.b58decode_check(address).hex()[2:]
    print (base58_decoded)
else:
    decoded = segwit_addr.decode('bc', address)
    if decoded[0] == 0:
        #print(decoded[2])
        hash160_bin = []
        for x in decoded[1]:
            hash160_bin.append(f'{x:08b}')

        hash160_hex = []
        for x in hash160_bin:
            hash160_hex.append(f'{int(x, 2):X}')

        print(''.join(hash160_hex))

and running it:

Code:

# python3 segwit_addr_decode.py 1P5ZEDWTKTFGxQjZphgWPQUpe554WKDfHQ
f22f5563839ba6ba5aa8d3726fcbc675cb3e4c9e

# python3 segwit_addr_decode.py 34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo
23e522dfc6656a8fda3d47b4fa53f7585ac758cd

# python3 segwit_addr_decode.py bc1qxv55wuzz4qsfgss3uq2zwg5y88d7qv5hg67d2d
3329477042A820944211E01427228439DBE03297

useful information on bech32 encoding: https://en.bitcoin.it/wiki/Bech32
test segwit address: https://bitcoin.sipa.be/bech32/demo/demo.html
test base58 encoded address: http://lenschulwitz.com/base58

[majika]

Hi LoyceV

I can see the utility of having the data in this format..
However call me stupid BUT a far simpler way would be to parse data directly from your own node?

> Dump out in raw addresses which have a positive int, then parse/query. Or am I missing something here??
I suppose another method would be to check for DATES where pub_key was involved in OUTPUT. to figure out addresses with positive balance.
I'm sure there is a far more elegant solution to the problem, with which a little touch of Python could go a long way to solving the BTC address > balance question.

PS. What about a "BTC Address Rich List" This is fundamentally based on a similar principle as what your wishing to achieve, is it not?

[LoyceV]

However call me stupid BUT a far simpler way would be to parse data directly from your own node?

As far as I know, that's not so simple. But if you can figure it out, I'd love to see your results. I expect it to be quite slow.

PS. What about a "BTC Address Rich List" This is fundamentally based on a similar principle as what your wishing to achieve, is it not?

The list with balance is a "Rich List":

Code:

wget -qO- http://addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz | gunzip | grep -vP "address\tbalance" | head -n 50 
34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo      26547968732321
bc1qgdjqv0av3q56jvd82tkdjpy7gdp9ut8tlqmgrpmv24sq90ecnvqqjwvw97  16800998536372
1P5ZEDWTKTFGxQjZphgWPQUpe554WKDfHQ      12038957274655
37XuVSEpWW4trkfmvWzegTHQt7BdktSKUs      9450511456719
38UmuUqPCrFmQo4khkomQwZ4VbY2nZMJ67      8406701772536
1FeexV6bAHb8ybZjqQMjJrcCrHGW9sb6uF      7995721697629
3Kzh9qAqVWQhEsfQz7zEQL1EuSx5tyNLNS      7642003887352
3LYJfcfHPXYJreMsASk2jkn69LWEYKzexb      7360113647202
3M219KR5vEneNb47ewrPfWyb5jQ2DjxRP6      7143400000000
bc1qa5wkgaew2dkv56kfvj49j0av5nml45x9ek9hz6      6937017585302
1LdRcdxfbSnmCYYNdeYpUnztiYzVfBEQeC      5388006072455
1AC4fMwgY8j9onSbXEWeH6Zan8QGMSdmtA      5183035998549
3FpYfDGJSdkMAvZvCrwPHDqdmGqUkTsJys      4579246787700
1LruNZjwamWJXThX2Y8C2d47QqhAkkc5os      4400008617726
3Gpex6g5FPmYWm26myFq7dW12ntd8zMcCY      4001396038553
bc1q5shngj24323nsrmxv99st02na6srekfctt30ch      4000032768183
385cR5DM96n1HvBDMzLHPYcw89fZAXULJP      3860186558087
3LQUu4v9z6KNch71j7kbj8GPeAGUo1FW6a      3792697744959
bc1q7ydrtdn8z62xhslqyqtyt38mm4e2c4h3mxjkug      3600041000054
159QgP4Ewvadjc4HDpaaR6pir2R4ZfzVfQ      3441500117745
bc1q5pucatprjrqltdp58f92mhqkfuvwpa43vhsjwpxlryude0plzyhqjkqazp  3369998788200
3LCGsSmfr24demGvriN4e3ft8wEcDuHFqh      3322004105156
12XqeqZRVkBDgmPLVY4ZC6Y4ruUUEug8Fx      3235400000564
bc1qx9t2l3pyny2spqpqlye8svce70nppwtaxwdrp4      3141523355441
3FHNBLobJnbCTFTVakh5TXmEneyf5PT61B      3127534535966
12ib7dApVFvg82TXKycWBNpN8kFyiAN1dr      3100007042388
3FupZp77ySr7jwoLYEJ9mwzJpvoNBXsBnE      2949754539921
12tkqA9xSoowkzoERHMWNKsTey55YEBqkv      2815105848732
3JJpCZCk4h4TpQeU7SA1yhH768Xgbtdbfg      2660550102022
1ftuUgzrr5hnVzXnFBDjELvVe69rPtBRi       2589500002000
3JZq4atUahhuA9rLhXLMhhTo133J9rF97j      2550364890459
17MWdxfjPYP2PYhdy885QtihfbW181r1rn      2449535042970
35ULMyVnFoYaPaMxwHTRmaGdABpAThM4QR      2430500118088
19D5J8c59P2bAkWKvxSYw8scD3KUNWoZ1C      2396900153670
1aXzEKiDJKzkPxTZy9zGc3y1nCDwDPub2       2363051758452
bc1qjysjfd9t9aspttpjqzv68k0ydpe7pvyd5vlyn37868473lell5tqkz456m  2328178254950
1932eKraQ3Ad9MeNBHb14WFQbNrLaKeEpT      2289999043553
19iqYbeATe4RxghQZJnYVFU4mjUUu76EA6      2243324021699
1MDq7zyLw6oKichbFiDDZ3aaK59byc6CT8      2240000017757
bc1qd4ysezhmypwty5dnw7c8nqy5h5nxg0xqsvaefd0qn5kq32vwnwqqgv4rzr  2200000010000
3DVJfEsDTPkGDvqPCLC41X85L1B1DQWDyh      2040626414582
3HSMPBUuAPQf6CU5B3qa6fALrrZXswHaF1      2020488810100
bc1q4jchcr7nla277su5lpjzttxp3xg5j8wds5lcwg      2017184466165
bc1qtw30nantkrh7y5ue73gm4mmy0zezfqxug3psr94sd967qwg7f76scfmr9p  2013623538292
17rm2dvb439dZqyMe2d4D6AQJSgg6yeNRn      2000800192617
1PeizMg76Cf96nUQrYg8xuoZWLQozU5zGW      1941443070193
3K5dmrkBMS8ZVgERMLwiw7PJuG8GWTbo8e      1860004653628
bc1qvpgyac88vqtslewxu7yu9dqwp8rd83zch55zpm3xgn3mgg72w3kqv0s8qa  1792998389600
1AjPJ1eq4VMt3NxBZwAD5BvpajxoGUJ89n      1727771271755
15HEcdBfaDD9tUxfPxgiPbTJi6ooQb11B2      1681996864863

[LoyceV]

I have been monitoring the total number of funded addresses here , with the data provided by LoyceV here

Time to add Taproot addresses:

I know that Taproot addresses are starting with bc1p, and Native Sewgit addresses start with bc1q.

Starting today, I've added bc1p-addresses to total_number_of_funded_addresses.txt and total_number_of_funded_addresses.json:

Code:

"03/01/2022":[
	{"total": 39644562,
	  "1": 23810601,
	  "3": 8474856,
	  "bc1q": 7342678}],
"04/01/2022":[
	{"total": 39631173,
	  "1": 23822116,
	  "3": 8429494,
	  "bc1q": 7362835}],
"05/01/2022":[
	{"total": 39633563,
	  "1": 23822618,
	  "3": 8421989,
	  "bc1q": 7371925,
	  "bc1p": 17027}]
}

I'm curious to see how fast those numbers will go up.

[mynonce]

I like what you're doing, but only a proposal:

Code:

"05/01/2022":[
	{"total": 39633563, 100.00%,
	  "1": 23822618, 60.11%,
	  "3": 8421989, 21.25%, 
	  "bc1q": 7371925, 18.60%
	  "bc1p": 17027, 0.04%}]

Maybe with percentage?  

[bitmover]

I like what you're doing, but only a proposal:

Code:

"05/01/2022":[
	{"total": 39633563, 100.00%,
	  "1": 23822618, 60.11%,
	  "3": 8421989, 21.25%, 
	  "bc1q": 7371925, 18.60%
	  "bc1p": 17027, 0.04%}]

Maybe with percentage?  

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.
You can see the percentage here
https://bitcoindata.science/bitcoin-funded-addresses.html

Time to add Taproot addresses:

I know that Taproot addresses are starting with bc1p, and Native Sewgit addresses start with bc1q.

Starting today, I've added bc1p-addresses to total_number_of_funded_addresses.txt and total_number_of_funded_addresses.json:

Code:

"03/01/2022":[
	{"total": 39644562,
	  "1": 23810601,
	  "3": 8474856,
	  "bc1q": 7342678}],
"04/01/2022":[
	{"total": 39631173,
	  "1": 23822116,
	  "3": 8429494,
	  "bc1q": 7362835}],
"05/01/2022":[
	{"total": 39633563,
	  "1": 23822618,
	  "3": 8421989,
	  "bc1q": 7371925,
	  "bc1p": 17027}]
}

I'm curious to see how fast those numbers will go up.

I will add this by tomorrow
 Thanks for the heads-up

[LoyceV]

Maybe with percentage?  

I created the json-file for bitmover, and I prefer his solution:

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.
You can see the percentage here https://bitcoindata.science/bitcoin-funded-addresses.html

[mynonce]

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.

Maybe with percentage?  

I created the json-file for bitmover, and I prefer his solution:

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.
You can see the percentage here https://bitcoindata.science/bitcoin-funded-addresses.html

Thanks.
I didn't know this site https://bitcoindata.science/bitcoin-funded-addresses.html

[bitmover]

Maybe with percentage?  

I created the json-file for bitmover, and I prefer his solution:

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.
You can see the percentage here https://bitcoindata.science/bitcoin-funded-addresses.html

just added the taproot addresses to the front end:



The problem is that the numbers are still very small. Let's see how fast those numbers will grow so we can actually see those addresses in the charts.

[mynonce]

@LoyceV, @bitmover
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.

[bitmover]

@LoyceV, @bitmover
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.

I just made a search here:
https://blockchair.com/bitcoin/outputs?s=time(desc)&q=is_from_coinbase(true),is_spendable(true)#f=is_from_coinbase,time,is_spendable

According to blockchair.com, there are 196,479 outputs of coinbase transactions which are spendable. I.e, they are unmoved.

[mynonce]

@LoyceV, @bitmover
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.

I just made a search here:
https://blockchair.com/bitcoin/outputs?s=time(desc)&q=is_from_coinbase(true),is_spendable(true)#f=is_from_coinbase,time,is_spendable
According to blockchair.com, there are 196,479 outputs of coinbase transactions which are spendable. I.e, they are unmoved.

We have block 0 in that list  But block 0 output is unspendable.

These are the number of outputs but not how many Bitcoin. It should be > 1 million Bitcoin (at least)

[LoyceV]

Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.

You can probably get this from Bitcoin block data (550 GB): inputs, outputs and transactions, but I still don't have a(n affordable) webhost for this data, and https://gz.blockchair.com/ has been offline for a few days.
It would be interesting to create an all-time graph, showing how the number of unspent new Bitcoins changes since the creation of Bitcoin. But I'll skip this one: too much data to process.

[LoyceV]

My LATEST version is currently stuck at January 5, 2022. It turns out Blockchair hasn't updated their archives in the last 6 days, and before that their archives were offline for a few days. I'm hoping it will be back online eventually.

[PawGo]

My LATEST version is currently stuck at January 5, 2022. It turns out Blockchair hasn't updated their archives in the last 6 days, and before that their archives were offline for a few days. I'm hoping it will be back online eventually.

They informed about troubles, AFAIK something related to situation in Kazakhstan. Archive pages were completely inaccessible recently, now they are back, but with old data.

[LoyceV]

situation in Kazakhstan.

What are the odds they host this in Kazakhstan

[PawGo]

situation in Kazakhstan.

What are the odds they host this in Kazakhstan

https://status.blockchair.com/

General status: Some of our servers are currently unavailable due to a global Internet shutdown in Kazakhstan: https://twitter.com/disclosetv/status/1478694856402817026. We're working on activating our reserve infrastructure. Some historical Ethereum transactions may be missing. Situation updates will be available at https://status.blockchair.com/ and at https://twitter.com/Blockchair/status/1478698203792949249

[LoyceV]

Blockchair's problems have long been resolved.

I'm closing in on another potential problem: this VPS might run out of bandwidth (2TB) before the end of this month. If that happens it will get suspended, and be back online next month. This hosting package doesn't allow adding more bandwidth, and I've paid this server until November 2023, so I'm not switching elsewhere any time soon.

I'm glad to see this data is in high demand though:

[LoyceV]

Last month, I killed my webserver for the last days to stop my VPS from being suspended. I turned it back on this month, but Blockchair hasn't updated their data dumps yet this month so you're all downloading the same version over and over again

[PawGo]

Last month, I killed my webserver for the last days to stop my VPS from being suspended. I turned it back on this month, but Blockchair hasn't updated their data dumps yet this month so you're all downloading the same version over and over again

https://www.youtube.com/watch?v=JKDo6g4CCeU

If you want to keep "fixed filename", maybe add one more, small file with "update date" inside.