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

Mek

jr. member

Activity: 69

Merit: 6

mtc.mekweb.eu - mega transistor clock

Quote from: LoyceV on August 16, 2023, 08:22:29 AM

Quote from: Mek on August 16, 2023, 02: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.

OK, can you please publish the way you generate the TSV file? The latest one on the website is already a week old. Maybe someone needs more frequent updates, or to have a backup plan should your website go down or stop being updated (these things happen...)

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: stas87 on August 20, 2023, 01:20:50 PM

Hi, thanks you for the ability to download all funded bitcoin addresses. Do you have such option for USDT (Tron) addresses? Or its blockchain is a way too heavy? Thanks

Nope, only Bitcoin here.

stas87

newbie

Activity: 4

Merit: 0

Hi, thanks you for the ability to download all funded bitcoin addresses. Do you have such option for USDT (Tron) addresses? Or its blockchain is a way too heavy? Thanks

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: Mek on August 16, 2023, 02: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: 2842

Merit: 7333

Crypto Swap Exchange

Quote from: Mek on August 16, 2023, 02: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: 69

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: 2982

Merit: 2681

Top Crypto Casino

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

Quote from: mausuv on December 23, 2022, 12:14:22 PM

...

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: 244

Merit: 126

Quote from: mausuv on December 23, 2022, 12:14:22 PM

...

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 23, 2023, 12:58:45 AM

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 23, 2023, 12:58:45 AM

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, 02: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: 244

Merit: 126

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, 12:14:22 PM

@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: 828

Merit: 657

Quote from: mausuv on December 23, 2022, 12:14:22 PM

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: 828

Merit: 657

Quote from: citb0in on August 30, 2022, 11: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, 11: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, 11: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, 03: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: 28

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, 11: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.

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