Pages:
Author

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

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
hero member
Activity: 862
Merit: 662
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
sr. member
Activity: 310
Merit: 727
---------> 1231006505
December 14, 2021, 08:12:54 AM
#99
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
legendary
Activity: 2968
Merit: 3406
Crypto Swap Exchange
December 02, 2021, 11:48:20 PM
#98
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].

Most transactions have multiple outputs, so whatever you're looking for, you'll have to narrow it down further.
Unfortunately, you're right Sad
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
December 02, 2021, 03:46:21 PM
#97
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 Sad
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.
legendary
Activity: 2968
Merit: 3406
Crypto Swap Exchange
December 02, 2021, 02:22:14 PM
#96
@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].
newbie
Activity: 24
Merit: 9
November 27, 2021, 10:32:21 PM
#95
Hi Albert0bsd,

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

It would be greatly appreciated.


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?HuhHuh?
only one public key use 2 petakeys / per seconed Huh
how to reached 10 Exabyte keys per second please solve my problem
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 13, 2021, 09:57:19 AM
#94
@mausuv: you should post this in albert0bsd's topic: ecctools - a small collection of tools written in C.
jr. member
Activity: 70
Merit: 1
November 13, 2021, 09:31:10 AM
#93
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?HuhHuh?
only one public key use 2 petakeys / per seconed Huh
how to reached 10 Exabyte keys per second please solve my problem
hero member
Activity: 862
Merit: 662
November 06, 2021, 12:16:07 PM
#92
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!
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 06, 2021, 11:59:21 AM
#91
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.
hero member
Activity: 862
Merit: 662
November 06, 2021, 11:52:36 AM
#90
Hi LoyceV since you already have some useful data, did you believe that you can publish some list like "Public keys with balance".
legendary
Activity: 3654
Merit: 3003
Enjoy 500% bonus + 70 FS
November 05, 2021, 04:25:34 PM
#89
Can i ask you all what you all do with the data Form the file?

Best regards
Willi
jr. member
Activity: 42
Merit: 11
November 05, 2021, 04:18:24 PM
#88
I downloaded your link. Thank you
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 05, 2021, 03:48:11 AM
#87
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.
jr. member
Activity: 42
Merit: 11
November 04, 2021, 03:09:06 PM
#86
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?
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 04, 2021, 09:49:13 AM
#85
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.
newbie
Activity: 2
Merit: 3
November 04, 2021, 06:40:52 AM
#84
Thanks, the correct format is easy to parse. It is very helpful  Smiley
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 03, 2021, 03:46:07 AM
#83
This is what I got after extracting the content of the file provided by the link above. May I know how can I get the balance?
Thanks for this, it looks like gz.blockchair.com changed the file I use a few days ago: it's now much smaller and contains the wrong data. I'm pretty sure that's a mistake. I'll wait a bit to see if they fix it on their own before I contact them.

I'll restore older versions for now.
Update: done! This is the latest version: addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_October_28_2021.tsv.gz. I'll keep an eye on Blockchair to see when I can continue daily updates.
newbie
Activity: 2
Merit: 3
November 03, 2021, 03:03:41 AM
#82
New: Direct link to LATEST versions
blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz (currently 862MB)
Bitcoin_addresses_LATEST.txt.gz (currently 750 MB)

This is what I got after extracting the content of the file provided by the link above. May I know how can I get the balance?

Thx

Code:
block_id	transaction_hash	index	time	value	value_usd	recipient	type	script_hex	is_from_coinbase	is_spendable	spending_block_id	spending_transaction_hash	spending_index	spending_time	spending_value_usd	spending_sequence	spending_signature_hex	spending_witness	lifespan	cdd
707781 3b9e2e90f4fa4fe5bb88a02f6941556af8f96c8da24799f8247e00ea046c5dac 3 2021-11-01 23:57:34 495453564 304267.9375 17A16QmavnUfCW11DAApiJxp7ARnxN5pGX pubkeyhash 76a91443849383122ebb8a28268a89700c9f723663b5b888ac 0 -1 707782 a40e8ce34941857ab0a6d43608e4b3f46f9dec536b9996a0bbdaa4d03ee56483 0 2021-11-02 00:08:47 302479.3438 4294967295 4730440220657eaf1d7a7437bc43d5fed9fefe3a20050d851d20d84e49aae06ae77a282be302200de42995d1845351a51378af797995b417437f7b897d68f010be6d26a8bfb3c40141047146f0e0fcb3139947cf0beb870fe251930ca10d4545793d31033e801b5219abf56c11a3cf3406ca590e4c14b0dab749d20862b3adc4709153c280c2a78be10c 673 0.038592621362499996
707779 a2e73b31479e093808358d69fcd6ca7077784a221d0f2e1e012c81e64b2d4076 1 2021-11-01 23:45:32 8426099 5174.6357 3EJKvTDK4qfnmCZGTupkCJKwpYvcoPh3iC scripthash a9148a4f17a7a0a009defd16398346ff6676c56a54a087 0 -1 707782 2f3b6627353ad9b7a8f0e80b625bfee47658de46f3b92ca3b7ab6f836fb7618c 0 2021-11-02 00:08:47 5144.2178 4294967295 2200209d88df8678e20d25689764c898adf19acd527e6f3c3feb2a8357d92a7286eece ,3045022100c94a1fa096b44e433f28430622c072a85456620583b39134d95e914f21b1c90402204d2b33ad7f0fb23c3fdb9f7b0101efe7ae30b635c27db95d5a492c74e58f05a601,304402207ff9f64a641124f4141dda3283bbe4d26da670f6082745d4ac5e8bfb240cb1de022053b79f60104f6fa5381a1728ad102a6cf6ecacab68254f043ec28f0195a6478901,5221030daf2b128d8a9fb959664ee334b668ca43b74441367cea3616e208fbbaaf568c2103a34f5c21e98f801b0d848e6401538074e049f993e80c66b07c2f28d37e844eef2102778952c666d794865b42e39a2541781d216f9299477001023b8186a7faf57e0353ae 1395 0.0013604639010416665
707776 690c212f2010075bbaa393c3f2d7d3a8739d862ced53384eb596038c9f010109 0 2021-11-01 23:33:04 1029410682 632181.6875 115md8GZ5S8CmvUj8a8cW58YcKvv2SekYf pubkeyhash 76a91400e6e9c2ab476c627c157ccaa2a1a526b86fb79788ac 0 -1 707782 04ff6bbeabb0faa6fec86f7f2dd292b6f3d0524ddcc826b9fd1b62660d5c581e 0 2021-11-02 00:08:47 628465.5 4294967295 473044022053304e19fba6c8933139d647d06146d857a2483ba564f6c72440767a44260d6502204f43503fc1ccc5f4cf3ae2001ec825c3f0d7c85bde9a96e7dcee00bcda668b95012103b3c036c7b89095d00ddf9b23b93c4781d7c486420ea75ce9d6404344e4ddb4fb 2143 0.2553272096673611
707781 2289e6937ea7f96420f4f4a8303acfadb062be2cc9d40e1dc7ff7eee3d8baa0b 0 2021-11-01 23:57:34 1028078900 631363.8125 115md8GZ5S8CmvUj8a8cW58YcKvv2SekYf pubkeyhash 76a91400e6e9c2ab476c627c157ccaa2a1a526b86fb79788ac 0 -1 707782 6f34766bc533b55b108527254a37cdf883df3351a1d3063bca586bc08793305f 0 2021-11-02 00:08:47 627652.4375 4294967295 483045022100b88ac8d9e60b735bbf1cb7a46463257c847f4fa5e40874c2fa2a8a245e2e519e0220189ba4db5a8b95608eeaacdd906265719f006392fb4a94780e9bd4653921e084012103b3c036c7b89095d00ddf9b23b93c4781d7c486420ea75ce9d6404344e4ddb4fb 673 0.08008068283564815
707780 731c26594d1fa8048216542745ac8df127bad75d32289753c945f9adf4e9b218 5 2021-11-01 23:53:51 150000 92.118 32ECMLtoA4R92YLsZi3dVV3J3EhDdgSfkV scripthash a91405e5996d7a30bd3ba56b499e0359afd8679ac10f87 0 -1 707782 7d7607e72ebec8da5243785c5bcb238937dc97ae95198fa426ae5dc2e9de967f 0 2021-11-02 00:08:47 91.5765 4294967295 1600147532e84aaff981d8ac62f86769ba048f2733900b 304402201d96222e49702c434f60c81991169c5594a585dfc66799fd75aa4b6e416e3da70220385f85fdaca12c7b7ef59a6d9298c1a49203dd035424ec97b07f9f313148d71501,036cab780d415f14a6218b01cc435c4eb83d93e2faa2068a76c314485a6bfd4777 896 0.000015555555555555555
707776 a0269077bc0c5c824f5a33a20bc1bc0a912deeb8487cd7c15faa6df6e7e4f334 1 2021-11-01 23:33:04 249126 152.9933 3PbJsixkjmjzsjCpi4xAYxxaL5NnxrbF9B scripthash a914f03e6bf9b389bbd5d5669ff55c4dba30de99553587 0 -1 707782 7d7607e72ebec8da5243785c5bcb238937dc97ae95198fa426ae5dc2e9de967f 1 2021-11-02 00:08:47 152.0939 4294967295 160014f7bae6ee31d59e79da8e857fb63429637f9e0d57 3044022045be9d951d43a01075f501f9b2da5222597420cb9d2f4c9e86eb92ca836065fb022027a5e1f6347bb31253ad9f0725a4b8d129f2413ec4218ad79e6543b964396bf401,034ed258709969db6507e5b86568e6c57d903917034a853fd2f6b7604443431518 2143 0.00006179132152777778
707772 e8d7df31409460f4bc37f2a59389610cb6e34579fc171adadbf78f81a37da600 2 2021-11-01 23:14:31 11564045 7101.7114 bc1q4kmm0ud3qzml0frwcjxhgwlndmpfanzk48rkr2 witness_v0_scripthash 0014adb7b7f1b100b7f7a46ec48d743bf36ec29ecc56 0 -1 707782 73f16d7fadf951296d674880472e753000a6b0b35a362524f900ce13fe203a40 0 2021-11-02 00:08:47 7059.9653 4294967293 304402205761e08d6936715e98d6f1e939f19ab9776a56b1badecc79ab74811487dce17902206e42965c7fc5e0adbcb2556cc5f0dc9c9af37b1dfc46eed4eb0ff887333107b601,0279ac41a2bb9b0cedca41b9b7b9fad4cdff875d7fbb4a3474c3ad74588be19e27 3256 0.004357931773148148
Pages:
Jump to: