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

I see. But I can't find the Bitcoin address bc1qpcmm7krqrmsjr4k84r85v6s9rhnl9warprrp0t that you originally mentioned in the current LoyceV funded addresses list:

even up to this prefix there is no single hit

The first line has a typo, see the address you posted at the beginning and see this address you mentioned:
bc1qpcmm7krqrmsjr4k84r85v6s9rhnl9warprrp0t
bc1pqcmm7krqrmsjr4k84r85v6s9rhnl9warprrp0t

Apparently you have misspelled the address in your initial question. You have a typo Being that said, the address with the prefix 'bc1p' is in the LoyceV list:

Now we are one step further. These are special other address types. You can find more information HERE.

Hope this answers your question.
citb0in

Sorry, I didn't mention that my question is related to the thread, but indeed.
The LoyceVs list contains the line. So, the question was "Why does the list contain the line if the address doesn't exist in the real blockchain?".
The same for these addresses (for convenience, the first one is also included):
bc1pqcmm7krqrmsjr4k84r85v6s9rhnl9warprrp0t
bc1sw50qgdz25j
bc1pewum2h6sap5ch5lf9qns4t0ufe9f6wf3z5s225
bc1zw508d6qejxtdg4y5r3zarvaryvaxxpcs
bc1pvw7t698cn379acgstnzwtnn8r6qxernnsrul3z
bc1pgptwf4gcrwy3qvq26p3cwapagaxyvsd8syuwhq
bc1putjagjerw0qw9qmy0wxu2pfk0v5t8gu7ranaxg
bc1pj7gr7lpxdnf6fm82jyy602t7xs9jjf3cp30yc7
bc1prkqmm25t4fn84k3j0dvlhkut4yeyuwurekel3c
bc1pxcsyvgrxyp8jqmeqtqs8sgpkyq7zq0sxpf58k
bc1p042rxsz3865566ykcd956pymkn0fxkn8lq96jx
bc1px5sy2gr9yp8zqm3q2us8wgp4yq4jq0gf5cpy9
bc1pxusywgr8ypgzqupqtys8jgphyq4zqgcmufa07
bc1p23jk6urvv96x2gp3yqszqgpqyqszqgqgxs8es
bc1p8ysyjgrfypfzqu3q9usrqgpeyqnzqfgv63qmh
bc1pxvsyxgrrypxzqmpq25s82gpnypajqlg7ux9e3
bc1pxqsrzgpjyqejqdpqx5srvgphyquzqwgc3wgd8
bc1pdv6mhmhayxp7xjxut0zhdpexskf7te5wfa53pv
bc1pjw7qg604staq70s86sfdq80zy5df2ljdl9n370
bc1p8qsysgrgypgjqufqtgs85gpcyqjzqsqul7r68
bc1pxysyzgrpyp9zq63q2vs8xgp3ypdjqhgfsx3d3
bc1pchjs0jhpga0lrqwwn26k6a9v5hj9pr8e522vq8
bc1pxgsyygrzyp9jq6eq2ss8ggpjyq5zq2g4sz4gk
bc1pxssyggryypxjqmfq2cs8vgp5yqsjq0ctxl0l2
bc1zqyqs3juw9m
bc1pm9jzmujvdqjj6y28hptk859zs3yyv78hlz84pm

simply said, its an invalid bitcoin address. Just because blockchair displays it, doesn't mean it exists. Blockchair seems to accept any address via URL parameter, even invalid ones like the one you mentioned.

Valid characters in in bech32 addresses are: 023456789acdefghjklmnpqrstuvwxyz
So invalid characters are: 1bio

Try enter this URL and you will get a similar result of what you asked for:
https://blockchair.com/bitcoin/address/bc1q123testbio123testbio123

However, your question is off-topic. Please make sure that in future you select a suitable subforum in which your question fits. If in doubt, create a new thread.

Hi,
Why do I see only the address bc1qpcmm7krqrmsjr4k84r85v6s9rhnl9warprrp0t on blockchair.com but nowhere else?
BR

I've moved this project to another (donated) server. Everything should be back online again, let me know if there are any issues.

Since HASH160 keeps coming up, I'll link World's fastest and simplest block parser for those who (only) need all HASH160 here. This is for all addresses ever used though.

I've added it to the OP:

Note that I haven't tested it, so as always, do your own research. You shouldn't be messing with bloom filters if you don't know what you're doing anyway

For all of you, a script which downloads and converts LoyceV addresses to brainflayer bloom filter.
Taken are all >1 mBTC addresses.

I did publish that, read the OP.

Thanks for this, I kinda forgot about this data project when I started another (big) download from Blockchair. Since I'm only allowed to download one connection at a time, it blocked other updates.
I'm running an update now, it should be available in about 3 hours.

If that happens, they'll have to figure it out on their own. If you're interested in discussing different parsers, it's probably best to open another topic about it.

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

Nope, only Bitcoin here.

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

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.

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.

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.

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

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

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:

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

Is it possible to gain RIPEMD160 version of these addresses?

Eventually how to convert these addresses to RIPEMD160?