List of all Bitcoin addresses with a balance - page 7.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: bitmover on June 03, 2021, 12:29:55 PM

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

Time to add Taproot addresses:

Quote from: dkbit98 on December 09, 2021, 05:59:59 AM

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: majika on January 01, 2022, 07:13:04 AM

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.

Quote

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

majika

jr. member

Activity: 64

Merit: 5

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?

bitxchange

newbie

Activity: 6

Merit: 0

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

albert0bsd

hero member

Activity: 862

Merit: 662

Quote from: TheArchaeologist on December 14, 2021, 08:12:54 AM

Not OP, but are you looking for something like this:

Yes something like that, i already have some lists, but none of them are a exhaustive list or even updated

Regards

TheArchaeologist

sr. member

Activity: 310

Merit: 727

---------> 1231006505

Quote from: albert0bsd on November 06, 2021, 11:52:36 AM

Hi LoyceV since you already have some useful data, did you believe that you can publish some list like "Public keys with balance".

Not OP, but are you looking for something like this:

Code:

address                                  balance         pubkey
12higDjoCCNXSA95xZMWUdPvXNmkAduhWv       0.00010000      044d05240cfbd8a2786eda9dadd520c1609b8593ff8641018d57703d02ba687cf2f187f0cee2221c3afb1b5ff7888caced2423916b61444666ca1216f26181398c
17afxUJouat3fkaaQ9tZrDThxdkXGL4WrM       0.00010000      0428ae82b094ace0e2753b55ade744f65580effe4be3940601cd5a6c51d5af7c5a3747741abcfebf48085010fc7983107da4fbc3dff8b72401779fcfbaa05bd5d3
1PhUXucRd8FzQved2KGK3g1eKfTHPGjgFu       50.00673279     04a2b3590604543737ef6a5cbdf438e44ef66d584efab1565759e1bafc72462d6b5f547466e4cbd610f2dcd65f2c0d6a419cf0170c15d7e783edf7d0247fa74f3b
1DNML6RyHdsqRS7te5SpCkMGoYEkVJU6wD       0.00000890      04ab6c62bcdc3ee4a5ded010007e48c6404347997624af22582147bf4ca7f2b7c3b725d1278f19c87f85652adcc8a198104c233353683bc6c2d1f8149c53c3782b
15J5MZxBkbo88hfHbY96UEDdWWtTJKTBgj       0.00000890      04aeb58ff7e7109ad1d2e8f4f574c733833a8c9c394082cec0f691d63a352ce56d3a1ac62473b62b70b238495808b8c904efff6c02ae9fc97e442f153404b64af2
1EGDbCKGbizMFgwjn4WNHTvAthsvrsixDv       1.00000000      042dfb87e38d92220d20fc181d358dca0f3677f2eabf64425b355deda0ae34a057127b369a80dcb69fb652ddbcb5e91b1c1bd43634be8c00fd1f0c74d3c6b9b8d6
1PyNKEyqtDFB4HBG8ueDVxdPZfgwC6gAqw       0.00001000      046bfe6fa9d6ab1383378cb1f30fb913e9bb18bc7f8cc81aadd2ac70bb5177d4dd73cd7a59373d58738602ba850622e1f470aa8ea45972673bd06b8bdc119f7ef4
1JXFXUBGs2ZtEDAQMdZ3tkCKo38nT2XSEp       0.00001000      04044ee968e705cba538788fd49bdd95ec4b8d96d6fe52c3c0788c4289d6c6ec3305cb603ac45462ffd6093aaddebd0f1201945165d8b0a2b9bb9a70e392aa4936
18FAoviy2XGWRBvDaA1QSUrKuPH2ST8pA2       2.38000000      04d21667e5ab6f05072fec925c9f598af3fcf40aafd31dd89b8994a63f516a7426da3cceb9ff437678dcd02abd8451b51d61075c58f0cc7e072fa71dd8f74b603c
14ccB2QFEKZnd1gLUtgr7vWg6JrMeXaQXK       0.00001000      045551caaca4caa1535fdea7e3dd6646720869e5c0187077aecfeafe60741aa61a35b013eb0f55081e30fc1b3b03bbc39e2430b31073574c39dbe60d122edb8a1b
12u6hecWRHEPceLYZ9yhubZvhgKYuLGf1J       151.00001435    046bd20f8fe764c28f5fe1c4eba69d26e0af42bf1853213d593a5098e075344d6fdc998e9c1e469cad7d799a0891f3bc47ae1f6a1eb6caabd62890a7994f4b6d5f
1XPTgDRhN8RFnzniWCddobD9iKZatrvH4        0.00015529      0434417dd8d89deaf0f6481c2c160d6de0921624ef7b956f38eef9ed4a64e36877be84b77cdee5a8d92b7d93694f89c3011bf1cbdf4fd7d8ca13b58a7bb4ab0804
1BiDsroMqEwDhBmzkKLvCSAddGn8QGmLFf       0.00001000      040bc7100ef382290a250654c0b77841ea844b5ad09843f55bf79fe6bb3a320f178a899280cf6f0a92befe316d922bffc3e8d6f93a8f1b788ac18c7ee44cf2f15a
1JCjFJckVFvN5EFs7oUmzKjPVLq8XyPiwc       10.00000000     04200af342e1bb4b50ada09233ebdca598446d4c7c3c92c915b3ec4fa36ef9c81937a204fe1909509d5b5b429ab00e378a3a1bf7e20e783974e0b1d5263c3bd38b
15Z5YJaaNSxeynvr6uW6jQZLwq3n1Hu6RX       7941.06426123   047a51392bace353f4c3788c9c090ef4f635ec211159ec3b9f1bb7da7679517e126e98e0012bcb4d2b023c479afaaa1ad703ea1b24e1910e2cdad38744ba7aab8a
1JiZxcwHpivk35obqHUYbdNoE1BA8ty5TB       5.00000000      04cb9648aa9f91795d111ded927f1a175c44a53537c817da4616eb071a9ec83a2670430628d20e70ee7a45b23494fc217d1020784d4d56b2f932754d79e4c3b808

SFR10

legendary

Activity: 2968

Merit: 3406

Crypto Swap Exchange

Quote from: LoyceV on December 02, 2021, 03:46:21 PM

But even if you get such a list, it's going to be so long it's not going to help you.

You have a point, but since it's an address with a significant number of txs, I thought that might do the trick when it comes to tracking such addys ^{[if there was a way]}.

Quote from: LoyceV on December 02, 2021, 03:46:21 PM

Most transactions have multiple outputs, so whatever you're looking for, you'll have to narrow it down further.

Unfortunately, you're right Sad

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: SFR10 on December 02, 2021, 02:22:14 PM

Do you know a way to narrow down addresses based on either their tx numbers or the number of txs that seem to have a change address in them ^{[e.g. 2 outputs]}, by any chance?

Nope

But even if you get such a list, it's going to be so long it's not going to help you. Most transactions have multiple outputs, so whatever you're looking for, you'll have to narrow it down further.

SFR10

legendary

Activity: 2968

Merit: 3406

Crypto Swap Exchange

@LoyceV
Do you know a way to narrow down addresses based on either their tx numbers or the number of txs that seem to have a change address in them ^{[e.g. 2 outputs]}, by any chance?
^{- I do know the latter part is a long shot, but I'm dealing with a case that has limited information while the other involved party is ignoring everybody ^{[so far]} + I became impatient ^{[had no luck with Blockchair dumps]}.}

DeepComplex

newbie

Activity: 24

Merit: 9

Hi Albert0bsd,

Can you share your dormant-publickeys (3.5 million public keys)?

It would be greatly appreciated.

Quote from: mausuv on November 13, 2021, 09:31:10 AM

Quote from: albert0bsd on November 06, 2021, 12:16:07 PM

Well, that is a pity, thanks for the fast reply.

I will stick to my current list of dormats-publickeys with subtracted values Total (3.5 Million public keys) at some 400 Gkeys/s

Wonderful work you made.

Thanks!

subtracted problem i need update

i am use your code but very slow (subtracted) https://github.com/albertobsd/ecctools
https://github.com/albertobsd/keysubtracter
hi share your new publickeys with subtracted code please send

and some example explain >>>>> Total (3.5 Million public keys) at some 400 Gkeys/s

my pc for 80 cpu 256 GP ram, 1TP stroage
./keyhunt -m bsgs -f 120.txt -b 120 -S - k 10 >>>>>>>>>> k value i am increaae system bloom filter error why? Huh

?
only one public key use 2 petakeys / per seconed Huh

how to reached 10 Exabyte keys per second please solve my problem

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

@mausuv: you should post this in albert0bsd's topic: ecctools - a small collection of tools written in C.

mausuv

jr. member

Activity: 70

Merit: 1

Quote from: albert0bsd on November 06, 2021, 12:16:07 PM

Well, that is a pity, thanks for the fast reply.

I will stick to my current list of dormats-publickeys with subtracted values Total (3.5 Million public keys) at some 400 Gkeys/s

Wonderful work you made.

Thanks!

subtracted problem i need update

i am use your code but very slow (subtracted) https://github.com/albertobsd/ecctools
https://github.com/albertobsd/keysubtracter
hi share your new publickeys with subtracted code please send

and some example explain >>>>> Total (3.5 Million public keys) at some 400 Gkeys/s

my pc for 80 cpu 256 GP ram, 1TP stroage
./keyhunt -m bsgs -f 120.txt -b 120 -S - k 10 >>>>>>>>>> k value i am increaae system bloom filter error why? Huh

?
only one public key use 2 petakeys / per seconed Huh

how to reached 10 Exabyte keys per second please solve my problem

albert0bsd

hero member

Activity: 862

Merit: 662

Well, that is a pity, thanks for the fast reply.

I will stick to my current list of dormants-publickeys with subtracted values Total (3.5 Million public keys) at some 400 Gkeys/s

Wonderful work you made.

Thanks!

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: albert0bsd on November 06, 2021, 11:52:36 AM

can publish some list like "Public keys with balance".

As far as I know the public key is only known after a transaction was made from that address (or when a message was signed), and I haven't found this data in a format that I can easily scrape. It certainly won't be a very complete list.

albert0bsd

hero member

Activity: 862

Merit: 662

Hi LoyceV since you already have some useful data, did you believe that you can publish some list like "Public keys with balance".

willi9974

legendary

Activity: 3654

Merit: 3003

Top-tier crypto casino and sportsbook

Can i ask you all what you all do with the data Form the file?

Best regards
Willi

jovica888

jr. member

Activity: 46

Merit: 11

I downloaded your link. Thank you

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: jovica888 on November 04, 2021, 03:09:06 PM

At the moment the website is not working.

I don't know why, I don't see any down time on the server-site.

Quote

Can you maybe split files so 1 file will contain only addresses that start with "1" for example "1jFkHrG18Hc6ae9jTxXyJxqHyzmUjNdyQ"?

For Linux users, that's very easy to get:

Code:

wget -qO- http://addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz | gunzip | grep "^1" > Bitcoin_legacy_addy.txt

I don't want to add additional files because this VPS only has 20 GB, and I prefer to keep a few older versions. I got you this as a temporary solution, it's scheduled to be deleted in 72 hours.

Quote

Also can I donate via Paypal?

No, I like my privacy. I can setup some altcoin though if that's okay.

jovica888

jr. member

Activity: 46

Merit: 11

At the moment the website is not working. Can you maybe split files so 1 file will contain only addresses that start with "1" for example "1jFkHrG18Hc6ae9jTxXyJxqHyzmUjNdyQ"?

Also can I donate via Paypal?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: LoyceV on November 03, 2021, 03:46:07 AM

I'll wait a bit to see if they fix it on their own before I contact them.

It looks like they fixed it: gz.blockchair.com/bitcoin/addresses/ is 1GB again (the faulty version was around 200MB). I ran an update yesterday, and tomorrow daily updates should be back to normal.

I noticed my script skips a few days once in a while (for instance, there were no updates between September 27 and October 08). I think it also has to do with Blockchair's data, that's why I keep a few older versions.

Topic: List of all Bitcoin addresses with a balance - page 7. (Read 9401 times)