List of all Bitcoin addresses with a balance

[DeepComplex]

LoyceV,

Thanks for the list. The list is good.


Can you say how you've compiled it, scripts or Linux commands, etc?
did you pull it from the blockchain, utxo?

I would like to learn how to manipulate the data as you did.


Regards,

It took me longer than I expected (because it was more work). Next time it's easy

Based on my what I've seen on the block chain, p2pk addresses were used up to block 278,298.

Searching through the first 278,298 blocks (about 1821 daily "outputs" data dumps), I get 901,980 lines that contain the word pubkey. Without duplicate addresses, it's 203,283.
If I search all data, I get 3,669,383 lines. I don't think any address type ever stopped being used, it's still backwards compatible.
If I check how many of those addresses currently have a balance, I get 39,208 from the shortest list. The full list has 39,979 addresses. I'll continue with this one.

I'm not sure why the hash length varies this much:

Code:

367569  c59bd606c40e325841f17d1365d917f953507040ccb540b351967a402999a02e        2015-07-30 00:50:12     2450    0.0072  1aajpztNecNzGBDjJhGfkrsUJFgeyhBgY       pubkey  2103d68f90ba81455256cb7a0df14fb3930d6df61393207f2f3e71659414d296e0f0ac  0       1
367631  72f822c0a805d88706a5d696a1715d9e08006dcc2433a278a4a91f41db587b75        2015-07-30 12:50:57     70000   0.2048  1aajpztNecNzGBDjJhGfkrsUJFgeyhBgY       pubkey  2103d68f90ba81455256cb7a0df14fb3930d6df61393207f2f3e71659414d296e0f0ac  0       1
367679  3fecf7434af30ca54fdadf03dd7e12c52fcdc753f82afe1f545ebf5fc04388fb        2015-07-30 20:53:11     2435048 7.1252  1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4      pubkey  4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac  1       1
367699  2bb1cf36f7004de8b93978e1b57a924e9e410ba5f1ac1fcf42abe64d9b51decb        2015-07-31 00:54:39     2340276 6.7798  1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4      pubkey  4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac  1       1

Maybe it's the difference between compressed and uncompressed addresses?

Final result: balance_addy_pubkey.txt (6.5 MB). It's sorted by balance, highest first.
Sample:

Code:

323317181009 1PTYXwamXXgQoAhDbmUf98rY2Pg1pYXhin 4104633280c0a93b45217059013ddadab8d35b9a858336028fecdff64c6a5e068fadaf7d2b73bc22795fa160c2304703320516e1b0b20e43d613fa5975787c8287e4ac
87500062957 16mEzobs4wQPuAMq1C8QSQafcDHvzczVcs 410469119c7e7d8e8b9f404d70c36cc09cae033e86d259554fd945c9263560fdc9ddea108db86e5673b3894b0bf97807ff8ac6e322791cf8d4d22f7c55a0e812720aac
80000077848 1P2ZAuW9nUrFfwgVjfL2SA9sPXSruCfzp8 4104a9c9c642db7941be7d9d467786c05b66d13c4fdafeb81d66815fb336e7e19d42981f62f2624826898152444b99b590476c90ea7f2e15f50a00e726368d6ec7c1ac
75000064054 15UkFYLMs5nytwiKWqGgkkVo1fjLFAeJhs 41044da39d1810bb01f7039fa7cdfa3dca6de313bbf2d9db9f24170e87b0206f079adb64cccc5cdf6283a54826adaf265087b3f8eba02577153aeaa6cdea8165d6dfac
55000168944 15BKWJjL5YWXtaP449WAYqVYZQE1szicTn 41042e3d29ccb78680a0da35bac8dc7adf895feb2b8eb9dbc5058400d811f6d7ce46faf0099ef63a05f3a8340e7e95530515303d652f27c2d9b379174b41bfd7046bac
.........
.........
.........
1 13P4fnmSVrHa7g6SiYh6mYF8ucB273TqXR 210354e528107cddb35020d91d28549818cc6a0ac57627eec88d48e248ce381fed98ac
1 13DAZmeDhHreHYTqeY7ZdpZt8oW84BwXEQ 2102fd985d1b8352ac5ae0426d4037cfdc34b6d71043e765ef2879d0d6c00aa88285ac
1 12fBP1Dck3pLUqGG7czQqVKAGHNwUCBZxT 21038b9bdf9d80e0e5f40880fc26d425700cbd71de87b232b2cffb6fecf97fa70214ac
1 12f7dZYL1pTkB7smfU6jf6hNhzP3sTASso 21020454e3b33d1df7037ab7767665219bfe9a99ff4aea5672f3a1e9379ef9703a16ac
1 12d9tPargbPamzfhxEh4wdh5jauA5dtobM 210375106eb0bdf4ed504356e8debd010050c57f9c5a03cea95a8dc6d0d6f0cd48ccac

[1714870624]

1714870624

[1714870624]

1714870624

[1714870624]

1714870624

[1714870624]

1714870624

[1714870624]

1714870624

[LoyceV]

Can you say how you've compiled it, scripts or Linux commands, etc?
did you pull it from the blockchain, utxo?

I don't want to keep going off-topic, so I'll make a new topic for it.
See Get pubkeys out of Bitcoin block data.

[LoyceV]

The list is good.

After thinking it over: I don't think it's correct. This address for example has never sent anything, so as far as I know, it's pubkey can't be known. And yet, it's in my list, while other addresses that have been used to send funds aren't in there.
You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.

[PawGo]

The list is good.

After thinking it over: I don't think it's correct. This address for example has never sent anything, so as far as I know, it's pubkey can't be known. And yet, it's in my list, while other addresses that have been used to send funds aren't in there.
You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.

I did not check your list, but do you have addresses like that:
https://blockchair.com/bitcoin/address/1H5G1HXeMMQGowH98rF6FpGWDnxvdVeTUr

Code:

04b1aac4d864cad13f9d168e2fed8a8f1db59d33f5e4041f32882aa75d5b083e80bba9e05ba25a61f68053fe7e0889e822c56519c9f0653c4f9534ca91f4f56ad6

[LoyceV]

do you have addresses like that:

It's in there:

Code:

5000000000 1H5G1HXeMMQGowH98rF6FpGWDnxvdVeTUr 4104b1aac4d864cad13f9d168e2fed8a8f1db59d33f5e4041f32882aa75d5b083e80bba9e05ba25a61f68053fe7e0889e822c56519c9f0653c4f9534ca91f4f56ad6ac

[DeepComplex]

LoyceV,

Those addresses are V1 bitcoin addresses used in the inception up to around the end of ~ 2012. Presumably by Satoshi et al. They are P2PK addresses.

Regards,

The list is good.

After thinking it over: I don't think it's correct. This address for example has never sent anything, so as far as I know, it's pubkey can't be known. And yet, it's in my list, while other addresses that have been used to send funds aren't in there.
You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.

[DeepComplex]

Can you prepare another list with all addresses with known pubkey and positive balance in the same format as you did before?

Regards,

LoyceV,

Those addresses are V1 bitcoin addresses used in the inception up to around the end of ~ 2012. Presumably by Satoshi et al. They are P2PK addresses.

Regards,

The list is good.

After thinking it over: I don't think it's correct. This address for example has never sent anything, so as far as I know, it's pubkey can't be known. And yet, it's in my list, while other addresses that have been used to send funds aren't in there.
You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.

[LoyceV]

They are P2PK addresses.

Thanks, that link explains why the pubkey for those addresses is known without sending a transaction:

I think P2PKH was used as a convenient way for people to make transactions, as it allowed you to use addresses instead of passing around your public key (which is longer).

Can you prepare another list with all addresses with known pubkey and positive balance in the same format as you did before?

If you can get me an example showing what part of the block data you need, I can get it for you. See this post for a sample of the data.
Please edit your post instead of making 2 posts in a row, see forum rules.

[racminer]

Maybe a dumb question:
 I downloaded this file all_Bitcoin_addresses_ever_used_sorted.txt.gz from  this site http://addresses.loyce.club and I found 18635073 wallets having this form x-ff8bb9190e0e969f5b8176dba0c0f161
where  x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so  what are they ?

Thank you:

[LoyceV]

I found 18635073 wallets having this form x-ff8bb9190e0e969f5b8176dba0c0f161
where  x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so  what are they ?

It's Blockchair.com's way of showing OP_RETURN outputs. I'm not sure how "real" those are, and if you'd get the same result if you'd get the data from your own Bitcoin Core installation. For most purposes you can ignore them.

[racminer]

I found 18635073 wallets having this form x-ff8bb9190e0e969f5b8176dba0c0f161
where  x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so  what are they ?

It's Blockchair.com's way of showing OP_RETURN outputs. I'm not sure how "real" those are, and if you'd get the same result if you'd get the data from your own Bitcoin Core installation. For most purposes you can ignore them.

To be precise:
18125075  d-
     10092   s-
   499906   m-

18635073 Total

[LoyceV]

I'll take this quote from another topic here:

In the list of founded addresses there is unnecessary line "address"  (kind of column header) between addresses "3.." and "bc..", line 31808561. Like you had separated lists and you concatenated them.

Thanks! That "address" should have been removed (but due to copying code I tried to remove the header from another file). It will be fixed in tomorrow's update.

[LoyceV]

how did you compile this list?

See:

Credits
Blockchair Database Dumps has a staggering amount of data, easily accessible (at 10 kB/s) with daily updates. All data presented in this topic comes from Blockchair.

[andresteves]

Thanks @LoyceV, you saved me a lot of time as I was searching for something like for a while and stepped on it today .

Really appreciate.

[citb0in]

Hi LoyceV and rest,

... You're looking for public keys that can be used to brute-force private keys, right? ...

you replied to DeepComplex as he was asking for the pubkey of an address. Can you (or DeepComplex or anyone else) explain to me please, why the pubkey is such a help and thus interesting for assisting in finding out the private key for this particular address? Where can I find more information about this, I am trying to understand. Wouldn't that be a serious concern when I spend some BTC to someone and my pubkey is revealed within the transaction? Thanks for any helpful information to all in advance.

[LoyceV]

Can you (or DeepComplex or anyone else) explain to me please, why the pubkey is such a help and thus interesting for assisting in finding out the private key for this particular address? Where can I find more information about this

I don't know the technical details, but knowing the public key makes brute-forcing a partial private key much easier.

Wouldn't that be a serious concern when I spend some BTC to someone and my pubkey is revealed within the transaction?

No, not without quantum computers.

[citb0in]

I don't know the technical details, but knowing the public key makes brute-forcing a partial private key much easier.

anyone can provide some more information on this topic, please ?

[albert0bsd]

anyone can provide some more information on this topic, please ?

A public key for ECC is a point in the curve it is just a set of coordinates (X,Y) but it represent the privatekey that is just a number, we can add, subtract, multiply and divide values to the publickey and the result is another publickey this is useful because there are some algorithms that can SPEED the search if you know part of the range of the original publickey. This is only useful for partial WIF and puzzles

Examples:
Looking for address of the puzzle 64 without publickey available will take some 292 thousand years with a CPU

Looking for a publickey in the 64 bit range will take 5 to 10 minutes with a CPU. For a GPU this taask can take some 20 Seconds to one minute.

The main problem with Publickey as a target is that all the calculations are made specific per publickey, this means that you can't take a list of 10 Millions of publickeys and expected the same performance.

More information:
https://andrea.corbellini.name/2015/06/08/elliptic-curve-cryptography-breaking-security-and-a-comparison-with-rsa/

[mausuv]

@LoyceV (OP)
Hi, I need Bitcoin Public Key Database with balance
Please upload Bitcoin Public Key Database with balance your site http://addresses.loyce.club/

Example Publickeys.txt

Code:

02ceb6cbbcdbdf5ef7150682150f4ce2c6f4807b349827dcdbdd1f2efa885a2630
02ceb6cbbcdbdf5ef7150682150f4ce2c6f4807b349827dcdbdd1f2efa885a2630
02ceb6cbbcdbdf5ef7150682150f4ce2c6f4807b349827dcdbdd1f2efa885a2630

Bitcoin Public Key Database please any  gdrive github other site send link
i need 1M < 10M public keys .txt formet

[albert0bsd]

Hi, I need Bitcoin Public Key Database with balance

I already ask if LoyceV has or can share that data but seem that it is a lot of work.

The best way is do this with an script, take your list of address of interest and get the publickey with an API if it is available.

Regards!