List of all Bitcoin addresses ever used - weekly updates work again!

[mg24680]

Thanks but I'm missing Jan 06, already had Jan 05 ...  what for?  Simpler and easier for me to incrementally process the MB files rather than to download and process the huge GB file each time ... yes, agreed, I could rebuild Jan 06 from the GB ... it is just that I noticed too late that my daily Jan 06 download failed and would rather not download the GB unless I really have to.

[LoyceV]

Thanks but I'm missing Jan 06, already had Jan 05 ...

I guess it's time for me to hit the couch if I make such mistakes. Try again: freshly_downloaded_Bitcoin_addresses_in_original_order_20250106.txt (23 MB).

what for?  Simpler and easier for me to incrementally process the MB files rather than to download and process the huge GB file each time ... yes, agreed, I could rebuild Jan 06 from the GB ... it is just that I noticed too late that my daily Jan 06 download failed and would rather not download the GB unless I really have to.

If you ever need it again: I get the daily data from blockchair_bitcoin_outputs_20250106.tsv.gz (69 MB):

Code:

gunzip -c blockchair_bitcoin_outputs_20250106.tsv.gz | grep -v 'is_from_coinbase' | cut -f 7 | awk '!a[$0]++' > freshly_downloaded_Bitcoin_addresses_in_original_order_20250106.txt

[mg24680]

Thank you.

[BTCHunterPL]

Hi I need script addresses or addresses with balance to
BSV, BCH, BTG, BTC, DASH, DOGE, ETH, LTC, ZEC, CLAM
In return, I can give my script that saves all 10 cryptocurrencies at once from the same HEX in separate locations.
at the moment only CPU in later CUDA + CPU.
Then the searcher script searches for addresses from the saved files, if they are saved on the desktop

[LoyceV]

Hi I need script addresses or addresses with balance to
BSV, BCH, BTG, BTC, DASH, DOGE, ETH, LTC, ZEC, CLAM

All addresses ever used (which is what this topic is about) or addresses with balance (which is a different topic)?
I can do several of those (not all), but it's a lot of data to process and will take me some time. I'll tell you what I've told others: feel free to make me an offer

[AMDG85]

Hi everyone,

I need a database of BTC addresses (Legacy format is enough) that have had at least one transaction.

Here’s the situation: I have a client who used a password-protected wallet address. It’s the address of a mining pool where they received BTC when they used to mine. The pool (50BTC) is long gone, and they don’t remember the address.

I downloaded a database from alladdresses . loyce . club and parsed the old wallets starting with "1", but couldn’t find the address. I’m guessing this might not be a complete database.

Does anyone know if it’s actually complete? Or does anyone have any tips on how to find all the addresses related to the 50BTC pool?

Thanks in advance for your help!

[LoyceV]

I downloaded a database from alladdresses . loyce . club and parsed the old wallets starting with "1", but couldn’t find the address. I’m guessing this might not be a complete database.

What makes you think the address you're looking for is not in this list?

Does anyone know if it’s actually complete?

Until proven otherwise, I will assume my list is complete. To prove it's not, all you need to show is one used address that isn't in this list.

[LoyceV]

Somehow, sorting was still inconsistent. To be clear: from now on, I use this to sort addresses:

Code:

LC_ALL=C

That means you're going to have to sort your own files in the same way if you to be able to use comm for finding matches.

Note: files are still updating. This will take a couple of hours to apply (sorting large files is very demanding if you don't have 256 GB RAM).

[joaquinvazmar]

Hi Loyce, I truly appreciate what youve done regarding the dataset of used bitcoin addresses.

I need to get a pretty updated (it can have a couple of months of not being updated) dataset of all bitcoin addresses that have received funds for a university data science project.

Which is the one you'd suggest using? I think that it's better to have them ordered alphabetically than chronologically.

Is the one posted as sorted in your website complete?

Thank you very much.

I am more than open to provide a contributing donation to your website for the help you've given us

[LoyceV]

I need to get a pretty updated (it can have a couple of months of not being updated) dataset of all bitcoin addresses that have received funds for a university data science project.

I wanted to say my data is updated weekly, but one of the weekly updates was last completed on March 25. I'll look into this, and expect the new update to be ready within a day.

Which is the one you'd suggest using? I think that it's better to have them ordered alphabetically than chronologically.

It depends on what you're looking for. Chronological holds more information, alphabetical is probably more practical to work with. Note that the exact sorting may not be what you expect: the way numbers or capitals are sorted seems to depend on localisation.

Is the one posted as sorted in your website complete?

Yes. Anything newer you can add yourself from "daily updates".

I am more than open to provide a contributing donation to your website for the help you've given us

Thanks. There's a donation address on my site, in my profile, or on my other site

Update: I found the culprit: I made a mistake when I wanted to speed things up. It's fixed now.

[Woodman]

Hi LoyceV, in the list of addresses with a balance on the site at the very end there are a lot of incomprehensible addresses such as

bc1vyyqqmzdqlle8vcp9qzqgpqqyqqf0veh2ugcegml
bc1wlptgs5n9ve6kuez5d7pnqw3shqlxyce3wpunsancv5mk2cmhdf6xgmrkvd3hyetttwhxvd
bc1vyyqqmp8slle8ky86mtrsmsy6pjqgpqqyj7enw4cqqryqzqxspuy2yz2p
bc1vy2qsp3qpszqgqpqqqzh0ywxmq0vqgp9x0z828z4wqjkq9kqyqsqqpthj8rdsx6av2mx
bc1wqqqqqqqqqqfeywjtqwd

that do not have a balance.

Is this some kind of bug or something, please check.

[LoyceV]

bc1vyyqqmzdqlle8vcp9qzqgpqqyqqf0veh2ugcegml

I can't find this one in the lastest files. Which file did you use exactly?

bc1wlptgs5n9ve6kuez5d7pnqw3shqlxyce3wpunsancv5mk2cmhdf6xgmrkvd3hyetttwhxvd

This address exists and holds 547 sats.

bc1vyyqqmp8slle8ky86mtrsmsy6pjqgpqqyj7enw4cqqryqzqxspuy2yz2p

This one also exists.

bc1vy2qsp3qpszqgqpqqqzh0ywxmq0vqgp9x0z828z4wqjkq9kqyqsqqpthj8rdsx6av2mx

Exists

bc1wqqqqqqqqqqfeywjtqwd

Exists.

[Woodman]

Thanks for the information, apparently I accidentally deleted the q when copying. It was about the address bc1vyyqqmzdqlle8vcp9qzqgpqqyqqqf0veh2ugcegml.

I used the service for verification https://bitaps.com / for some reason, it does not show information on these addresses.

https://bitaps.com/bc1wqqqqqqqqqqfeywjtqwd - Not found

https://bitaps.com/bc1wlptgs5n9ve6kuez5d7pnqw3shqlxyce3wpunsancv5mk2cmhdf6xgmrkvd3hyetttwhxvd - Not found

https://bitaps.com/bc1vyyqqmp8slle8ky86mtrsmsy6pjqgpqqyj7enw4cqqryqzqxspuy2yz2p - Not found

https://bitaps.com/bc1vy2qsp3qpszqgqpqqqzh0ywxmq0vqgp9x0z828z4wqjkq9kqyqsqqpthj8rdsx6av2mx - Not found

This is the first time I've encountered such a situation, apparently these are non-standard addresses that not all explorers can show  

[LoyceV]

I used the service for verification https://bitaps.com / for some reason, it does not show information on these addresses.
~
This is the first time I've encountered such a situation, apparently these are non-standard addresses that not all explorers can show  

So the bug is with Bitaps. I checked bc1vyyqqmzdqlle8vcp9qzqgpqqyqqqf0veh2ugcegml, it shows up on Blockchair.com, mempool.space and a watch-only Electrum wallet connected to my own node. It's good to be aware there can be "different interpretation" in what gets shown. A more serious problem for instance is that a watch-only Electrum wallet doesn't show "send to pupkey" inputs, but most block explorers show it. You wouldn't want to miss out on a 50 BTC block reward from 2010 because of that!

[pbies]

I am downloading the dump with 4-5 threads (aria2c) but it is slow - few MB/s.

Is there other place where I can download with full speed on my 1Gb network connection (like 125 MB/s)?

@LoyceV

[LoyceV]

I am downloading the dump with 4-5 threads (aria2c) but it is slow - few MB/s.
Is there other place where I can download with full speed on my 1Gb network connection (like 125 MB/s)?

I haven't seen any other site that offers these 40 GB files
The reason it's slow, is because my server has 1 TB NVMe and 2 TB "SAN" network storage. The 2 TB is much slower, and that's where I store these files. I just tested it:

Code:

-                     0%[                    ]  67.00M  2.40MB/s    eta 4h 50m

So I guess you'll just have to wait a few hours. I agree this speed is far too slow, but this is just a "fun" data project and I don't really want to spend more on hosting.

I also tested Bitcoin addresses with a balance:

Code:

-                    41%[=======>            ] 561.19M  55.5MB/s    eta 11s

This is a different server. Much smaller, but fast disk.