List of all Bitcoin addresses with a balance

[alevlaslo]

for 130000000000000000000000000000000000/24000000 years I will find privkey of one address

but if I shall lucky, than I can find it in one second

[1715031569]

1715031569

[1715031569]

1715031569

[1715031569]

1715031569

[1715031569]

1715031569

[1715031569]

1715031569

[LoyceV]

This subdomain is currently offline:

The data
See addresses.loyce.club.

I think I ran out of bandwidth (250 GB) this month. I haven't hit this limit before, so I don't know if it requires manual intervention to be online again in November.
Update: it should be online again November 1^st. I'll upgrade the hosting when transaction fees drop. I need to wait for the current hosting to be online again to copy data anyway.

[LoyceV]

Update: It works again! I'll see what Black Friday brings for hosting offers

[alevlaslo]

well alphabetically, thank you, it is convenient to delete unnecessary things with this command

[LoyceV]

Interesting: I noticed Bitcoin_addresses_November_09._2020.txt.gz is 2 MB smaller than Bitcoin_addresses_November_08_2020.txt.gz. I checked if the newer file might be incomplete, but it doesn't look like that.
It turns out there were 45,303 funded addresses less on the 9^th than on the 8^th, which means someone (or many people) have been consolidating inputs to take advantage of the lower fees during the weekend.
Once I have a different host for these files, I can keep daily snapshots a bit longer to see if there's a pattern.

A day later, there are 149,295 less funded Bitcoin addresses. I didn't expect such a large daily difference.

[LoyceV]

I'm moving this to a new webhost. As a temporary location, the data will be available on http://old.loyce.club/?C=M;O=D until I'm done.
Done! This project now gets 1 TB per month bandwidth (4 times more), and a few more snapshots.

See addresses.loyce.club.

If all goes well, it'll keep 6 snapshots. When I have a few, I'll see how I can keep some older ones too instead of only the most recent days.

[Vod]

I have Notepad++, but I don't have enough RAM, it freezes after selecting all the text and ALT+SHIFT+>>>

Try the free Libre suite.  https://www.libreoffice.org/discover/calc/

Also, Visual Studio code can open large files/

[alevlaslo]

thanks, but I no longer work on the address list, I use the public key to one address

[LoyceV]

If all goes well, it'll keep 6 snapshots. When I have a few, I'll see how I can keep some older ones too instead of only the most recent days.

Update: I changed my script to keep 9 snapshots. I'll keep 4 from the last 3-4 days, and 5 snapshots from the last 4-5 months. The older snapshots will be created in the coming months, I don't have them yet.

I couldn't test this yet, I'll see next month if it works as expected.

[LoyceV]

Update:

If you want to know the balance of a certain address, but you don't want any block explorer or SPV wallet on the planet to know you're looking for that address, you can use this:

Code:

wget -qO- http://addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz | gunzip | grep -m1 1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD; sleep 5m; kill -9 $$

This doesn't save the file on your local drive, stops downloading after the first match, and kills your Bash shell 5 minutes later (so no .bash_history gets saved).
If you want to search more than one address, please download the file first.

New: Direct link to LATEST versions
blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz (currently 862MB)
Bitcoin_addresses_LATEST.txt.gz (currently 750 MB)

New: Keeping track of the total number of funded addresses
See total_number_of_funded_addresses.txt. Starting December 2020, I'll add a daily total address count to this list. Long-term, this might prove useful (or at least produce nice graphs).

Sample:

Code:

31,115,394 funded Bitcoin addresses on September 10, 2020
  23,536,754 of those start with 1
  6,025,854 of those start with 3
  1,552,770 of those start with bc1q

32,467,107 funded Bitcoin addresses on November 12, 2020
  24,223,336 of those start with 1
  6,402,910 of those start with 3
  1,840,844 of those start with bc1q

32,478,246 funded Bitcoin addresses on November 13, 2020
  24,230,032 of those start with 1
  6,400,301 of those start with 3
  1,847,896 of those start with bc1q

If you add up the addresses starting with 1, 3 and bc1q, you'll notice 16 addresses are missing. Those are:

Code:

bc1p23jk6urvv96x2gp3yqszqgpqyqszqgqa6qtuj
bc1p8qsysgrgypgjqufqtgs85gpcyqjzqsqfrw0l9
bc1p8ysyjgrfypfzqu3q9usrqgpeyqnzqfgexpv74
bc1pmfr3p9j00pfxjh0zmgp99y8zftmd3s5pmedqhyptwy6lm87hf5ss52r5n8
bc1pq2kqvpm76ewe20lcacq740p054at9sv7vxs0jn2u0r90af0k633322m7s8v
bc1pqyqszqgpqyqszqgpqyqszqgpqyqszqgpqyqszqgpqyqszqgpqyqs3wf0qm
bc1pv22mcnt30gwvk8g72szz700n4tkkx2qur2adj6pt8hl37hcf9dascxyf42
bc1px5sy2gr9yp8zqm3q2us8wgp4yq4jq0guggdp8
bc1pxcsyvgrxyp8jqmeqtqs8sgpkyq7zq0snaecz5
bc1pxgsyygrzyp9jq6eq2ss8ggpjyq5zq2gqvjed5
bc1pxqsrzgpjyqejqdpqx5srvgphyquzqwgdd7yg9
bc1pxssyggryypxjqmfq2cs8vgp5yqsjq0c760r6g
bc1pxusywgr8ypgzqupqtys8jgphyq4zqgcwqe32u
bc1pxvsyxgrrypxzqmpq25s82gpnypajqlgtqkfun
bc1pxysyzgrpyp9zq63q2vs8xgp3ypdjqhguvkagn
bc1zqyqsywvzqe

I don't know the story behind them, someone has been creating non-standard outputs. See txid 8bb2ce18914cfcb68e21686362b879396c2c27b51f1ec4be25c064f48f848f2d for most of them.

[LoyceV]

I'm happily surprised this data has quite a few daily users:

[LoyceV]

I've counted some dust addresses:
573,966 addresses hold 546 satoshi.
168,663 addresses hold 547 satoshi.
74,835 addresses hold 548 satoshi.
2212 addresses hold 549 satoshi.
12,745 addresses hold 550 satoshi.
1,301 addresses hold 500 satoshi.
310,361 addresses hold 1000 satoshi.
6,010 addresses hold 9 satoshi.
4,209 addresses hold 1001 satoshi.

2,821,479 addresses hold 1000 sat or less. Total value: 1,403,085,278 satoshi (~14 BTC).
30,649,056 addresses hold more than 1000 sat. Total value: 1,858,148,094,500,905 satoshi (~18.58 million BTC).

[bitmover]

I don't know the story behind them, someone has been creating non-standard outputs. See txid 8bb2ce18914cfcb68e21686362b879396c2c27b51f1ec4be25c064f48f848f2d for most of them.

That's interesting.
All of them are unspent, so they aren't spendable probably.

Nodes shouldn't validate transactions to invalid addresses..

[cryptothoughts42]

@LoyceV do you know how to find out which Bitcoin block Blockchair's database dumps are taking a snapshot of?

[LoyceV]

@LoyceV do you know how to find out which Bitcoin block Blockchair's database dumps are taking a snapshot of?

My guess would have been midnight ("Blockchair time"), but it's not because this transaction mined 2021-01-20 00:10 is already included in the LATEST data dump.
If you want a more exact snapshot time: just compare current balances for a few recent transactions and see which one is included in the latest data dump.

[LoyceV]

I'm happily surprised this data has quite a few daily users:

Joke's on me, at the rate this is going this VPS runs out of bandwidth (1 TB/month) 3 days before the end of this month:

[LoyceV]

I've just doubled my allowed bandwidth (paid by Bitcoin Lightning Network) to 2 TB/month. However, the webhost hasn't processed the payment yet. If it processes it on time, you guys can continue downloading tomorrow. If not, it will reach it's 1 TB bandwidth limit tomorrow and get be suspended until the end of the month.

To be continued ........

Update: upgrade completed! I'm curious though: I'd love to know what this data is being used for. There must be more than a thousand downloads per month now.

[blauervogel]

Hi LoyceV, thank you so much for providing the address list.

I wanted to let you know that I am building a collider which is similar to the "Large Bitcoin Collider" project. I know that the chances of a collision are fu**ing small, but I am interested in the design of bitcoin and thought that is a great way to learn about it.

Anyways, I downloaded it only once. So there must be many more interested in the list
Cheers

[LoyceV]

I wanted to let you know that I am building a collider which is similar to the "Large Bitcoin Collider" project. I know that the chances of a collision are fu**ing small

That's a great way to prove to yourself how secure Bitcoin really is
Thanks for posting what you use this for.

[starmyc]

I'm curious though: I'd love to know what this data is being used for. There must be more than a thousand downloads per month now.

Yes, me too I'm genuinely curious about this.