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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: Mek on August 16, 2023, 01:37:12 AM

if I run my own full node, how can I generate the same TSV file as is available on loyce.club site? (all addresses with balance)

As far as I know, all you need for this is the data in the "chainstate" directory, which isn't that much. There are a few parsers out there, just try to find which one you like.
I don't need more frequent updates, so I never setup my own parser.

ABCbits

legendary

Activity: 2870

Merit: 7490

Crypto Swap Exchange

Quote from: Mek on August 16, 2023, 01:37:12 AM

Hello
if I run my own full node, how can I generate the same TSV file as is available on loyce.club site? (all addresses with balance)
Thanks.

It depends on which software you use to run full node. Some software (including Bitcoin Core) doesn't have address index, which force you to either perform workaround (e.g. load and parse UTXO) or install additional software (such as Electrum server or self-hosted mempool.space) which perform address index.

Mek

jr. member

Activity: 72

Merit: 6

mtc.mekweb.eu - mega transistor clock

Hello
if I run my own full node, how can I generate the same TSV file as is available on loyce.club site? (all addresses with balance)
Thanks.

seoincorporation

legendary

Activity: 3346

Merit: 3125

Quote from: pbies on August 14, 2023, 04:30:18 PM

Quote from: mausuv on December 23, 2022, 11:14:22 AM

...

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

...

I can share such database. It is 5 MB as .rar.

Inside are: transaction ids, amounts, public keys.

You can obtain such file by go program with name "bitcoin-utxo-dump".

I was reading about bitcoin-utxo-dump and looks like the right tool for this project, the files are not 5 MB, the file should be around 7GB and it takes close to 20 minutes to get all the unspent coins. After that we should group the unspent transactions from the same address and that way we can know the balance from each address...

The thing here is, you should run the dump each hour, then group the address and make a new csv file with the data, then update the database from the csv file, sounds as a busy cron job, but is possible.

Source: https://github.com/in3rsha/bitcoin-utxo-dump

pbies

full member

Activity: 297

Merit: 133

Quote from: mausuv on December 23, 2022, 11:14:22 AM

...

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

...

I can share such database. It is 5 MB as .rar.

Inside are: transaction ids, amounts, public keys.

You can obtain such file by go program with name "bitcoin-utxo-dump".

wordbustingmistake

newbie

Activity: 2

Merit: 0

Quote from: pbies on January 22, 2023, 11:58:45 PM

Is it possible to gain RIPEMD160 version of these addresses?

Eventually how to convert these addresses to RIPEMD160?

P2PKH (26-35 characters long addresses starting 1, base58check encoded) and P2WPKH (42 characters long addresses starting bc1q, bech32 encoded) addresses are basically Ripemd160 hashes of public keys just encoded and with a little overhead (e.g. checksums). From loyce set of addresses you need to select only addresses matching proper length and starting characters, then use a decoder to verify checksums, decode addresses to hex and remove whatever overhead is leftover. Bit library for Python has base58 and base32 classes with methods to do that, so it's going to be something like:

Code:

print(base58.b58decode_check(P2PKH_address)[1:].hex())
print(bytes(base32.decode(P2WPKH_address)[1]).hex())

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: pbies on January 22, 2023, 11:58:45 PM

Is it possible to gain RIPEMD160 version of these addresses?

Eventually how to convert these addresses to RIPEMD160?

I'm not sure what RIPEMD160 is, and how it relates to pubkeys, but I think this applies:

Quote from: NotATether on March 24, 2021, 01:23:02 AM

The very act of hashing destroys any relation there could have been with inputs, no matter what the hashing algorithm is.

pbies

full member

Activity: 297

Merit: 133

Is it possible to gain RIPEMD160 version of these addresses?

Eventually how to convert these addresses to RIPEMD160?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: mausuv on December 23, 2022, 11:14:22 AM

@LoyceV (OP)
Hi, I need Bitcoin Public Key Database with balance

As albert0bsd said, it's complicated. Read the last few pages of this topic, read LoyceV's small Linux commands for handling big data and most importantly read this post on the problems I ran into at my attempt to get all known pubkeys.
I haven't found a solution, which is why I abandoned the pubkey project. If you can tell me how to get pubkeys out of the data I've published, I'll may it another try.

albert0bsd

hero member

Activity: 862

Merit: 662

Quote from: mausuv on December 23, 2022, 11:14:22 AM

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!

mausuv

jr. member

Activity: 70

Merit: 1

@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

hero member

Activity: 862

Merit: 662

Quote from: citb0in on August 30, 2022, 10:31:09 AM

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/

citb0in

hero member

Activity: 630

Merit: 731

Bitcoin g33k

Quote from: LoyceV on August 30, 2022, 10:26:18 AM

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 ?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: citb0in on August 30, 2022, 10:18:56 AM

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.

Quote

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

hero member

Activity: 630

Merit: 731

Bitcoin g33k

Hi LoyceV and rest,

Quote from: LoyceV on April 22, 2022, 02:45:08 AM

... 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.

andresteves

newbie

Activity: 31

Merit: 0

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: ?? on ??

how did you compile this list?

See:

Quote from: LoyceV on June 11, 2020, 10:30:34 AM

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

I'll take this quote from another topic here:

Quote from: PawGo on June 22, 2022, 03:15:49 AM

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.

racminer

member

Activity: 245

Merit: 17

Quote from: LoyceV on May 04, 2022, 09:29:29 AM

Quote from: racminer on May 04, 2022, 07:02:20 AM

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

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: racminer on May 04, 2022, 07:02:20 AM

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.

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