Topic: List of all Bitcoin addresses with a balance (Read 8907 times)
I understood everything. Very interesting. Thank you.
I noticed my bandwidth consumption dropped from 20 to 14 TB/month 
But now that I think about it, my memory may be incorrect. I think it used to be 10 TB/month, which means it increased. I'm not so sure anymore, I don't really keep track.
Possibly because there were many days without update. No need to redownload old files. But now that I think about it, my memory may be incorrect. I think it used to be 10 TB/month, which means it increased. I'm not so sure anymore, I don't really keep track.
Hahaha, is this post something that really needs a BTCump?
I noticed my bandwidth consumption dropped from 20 to 14 TB/month But now that I think about it, my memory may be incorrect. I think it used to be 10 TB/month, which means it increased. I'm not so sure anymore, I don't really keep track.Quote
After that users always ask about how to process/edit or manage those big files... most of them don't know any Linux environment or command 
If you know an equivalent that works in Windows, please post it.Quote
Anyway thanks for your contributions to this community.
No problem 
Bump
Hahaha, is this post something that really needs a BTCump?
Always that a user ask me for a list of addresses with balance I always suggest them to search on google for "LoyceV addresses with balance" and it always works
After that users always ask about how to process/edit or manage those big files... most of them don't know any Linux environment or command
Anyway thanks for your contributions to this community.
It should be something like this (not tested):
I would wget the .gz file, pipe it through gunzip, and go from there. That way you only need to download a fraction of the file if you kill it once you reach amounts lower than the desired minimum.
It should be something like this (not tested):
The probability to match by brute force so small number of addresses from the entire set is so small that you should be extremely lucky if you can find even an address with 1 satoshi in it. Asking for reduced number of addresses is telling me you have a weak hardware. This is not what you need for this task. You may need the entire calculating power available on Earth for many years.
Quote
awk -F'\t' 'NR>1 && $2>=100000000{print $1}' blockchair_bitcoin_addresses_and_balance_LATEST.tsv > blockchair_bitcoin_addresses_selected.txt
The probability to match by brute force so small number of addresses from the entire set is so small that you should be extremely lucky if you can find even an address with 1 satoshi in it. Asking for reduced number of addresses is telling me you have a weak hardware. This is not what you need for this task. You may need the entire calculating power available on Earth for many years.
Hey guys,
can we have a list of only addresses with more than 1 BTC - the so called Rich List.
I need one because the full list is more than 2GB now and that tends to slow some programs down. A lightweight version would be really nice, but I can't find any.
Much appreciated.
can we have a list of only addresses with more than 1 BTC - the so called Rich List.
I need one because the full list is more than 2GB now and that tends to slow some programs down. A lightweight version would be really nice, but I can't find any.
Much appreciated.
You can use python and the pandas library. It will open files of any size and sort and slice them data easily.
Ask chatpgpt for help , it is east. But you won't make any money brute forcing them.
can we have a list of only addresses with more than 1 BTC - the so called Rich List.
I need one because the full list is more than 2GB now and that tends to slow some programs down.
So you want to steal millions by brute-forcing Bitcoin addresses, but you can't figure out how to download blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz (which is sorted by highest balance first) and use only the top of this file? I need one because the full list is more than 2GB now and that tends to slow some programs down.
Hey guys,
can we have a list of only addresses with more than 1 BTC - the so called Rich List.
I need one because the full list is more than 2GB now and that tends to slow some programs down. A lightweight version would be really nice, but I can't find any.
Much appreciated.
can we have a list of only addresses with more than 1 BTC - the so called Rich List.
I need one because the full list is more than 2GB now and that tends to slow some programs down. A lightweight version would be really nice, but I can't find any.
Much appreciated.
The list is currently a few days behind again 
It works again, since a week now. See addresses.loyce.club. The list is currently a few days behind again
If blockchair's data source is outdated, my data is outdated too. Unfortunately I don't have the disk space anymore to scrape my own blockchain.
The list is currently a few days behind again
Quote
comm -12 Bitcoin_addresses_LATEST.txt <(cat wallet.txt | fromdos | sort | uniq)
Quote
If you need fromdos, install tofrodos, as it tells you to do.
Now it worked. Thank you very much
Compare two files, one with addresses and second your one with addresses you are searching for:
Sorry, i do not know what i am doing wrong,
I tested with several addresses and only found 1
https://i.ibb.co/R3v2fJk/1.jpg
https://i.ibb.co/M9NXhgL/2.jpg
Code:
#!/usr/bin/env bash
comm -12 <(pv -cN 1st "$1") <(pv -cN 2nd "$2")
>&2 echo -ne "\x7"
comm -12 <(pv -cN 1st "$1") <(pv -cN 2nd "$2")
>&2 echo -ne "\x7"
Sorry, i do not know what i am doing wrong,
I tested with several addresses and only found 1
https://i.ibb.co/R3v2fJk/1.jpg
https://i.ibb.co/M9NXhgL/2.jpg
I use these 3 scripts:
Get addresses and balances and unpack them:
Take only addresses, sort and uniq them:
Compare two files, one with addresses and second your one with addresses you are searching for:
Get addresses and balances and unpack them:
Code:
#!/usr/bin/env bash
wget http://addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz
pv blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz | gunzip > blockchair_bitcoin_addresses_and_balance_LATEST.tsv
>&2 echo -ne "\x7"
wget http://addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz
pv blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz | gunzip > blockchair_bitcoin_addresses_and_balance_LATEST.tsv
>&2 echo -ne "\x7"
Take only addresses, sort and uniq them:
Code:
#!/usr/bin/env bash
pv -B 1M blockchair_bitcoin_addresses_and_balance_LATEST.tsv | cut -f 1 | sort -u > addrs-with-bal.txt
>&2 echo -ne "\x7"
pv -B 1M blockchair_bitcoin_addresses_and_balance_LATEST.tsv | cut -f 1 | sort -u > addrs-with-bal.txt
>&2 echo -ne "\x7"
Compare two files, one with addresses and second your one with addresses you are searching for:
Code:
#!/usr/bin/env bash
comm -12 <(pv -cN 1st "$1") <(pv -cN 2nd "$2")
>&2 echo -ne "\x7"
comm -12 <(pv -cN 1st "$1") <(pv -cN 2nd "$2")
>&2 echo -ne "\x7"
I tried a lot and could not put to work these commands on linux mint
I've deleted your post because of the unnecessary long quote.Your screenshot already shows the problem:
[/quote]Quote
comm -12 Bitcoin_addresses_LATEST.txt <(cat wallet.txt | sort | uniq)
The file with balances is indeed not sorted. And you can't use it, because comm matches whole lines. Remove the balances and sort it, or download the file without balances.Quote
comm -12 Bitcoin_addresses_LATEST.txt <(cat wallet.txt | fromdos | sort | uniq)
If you need fromdos, install tofrodos, as it tells you to do.Running this as root is bad practice.
I get this data from Blockchair.com, and their last update is from April 19. Their other data is still being updated, so it looks like something is stuck with updating the Bitcoin addresses.
The daily updates are back to normal The files haven't been updated in over a week
I get this data from Blockchair.com, and their last update is from April 19. Their other data is still being updated, so it looks like something is stuck with updating the Bitcoin addresses.Files haven't been updated since 19 April 2024.
I posted both posts in the wrong topic. It's correct now, the other post is here. Both updates got stuck, one was waiting for the other, which was waiting for Blockchair. In short: the list of all addresses with a balance is not updated at the moment. The files haven't been updated in over a week
It looks like the daily updates didn't happen, which means the weekly update had no fresh data. I'm not sure why, I'll check it tomorrow.Update: it's fixed. It was waiting for another stuck update. The weekly update is running now, this takes a few hours to complete. Thanks for reporting this.
Files haven't been updated since 19 April 2024.
The files haven't been updated in over a week, though the source files on blockchair are still updated. Don't see any maintenance status mentioned on the download site or this topic.
Jump to: