Pages:
Author

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

legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
December 26, 2020, 07:37:46 AM
#32
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).
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
December 18, 2020, 05:34:31 AM
#31
I'm happily surprised this data has quite a few daily users:
Image loading...
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
December 06, 2020, 08:16:48 AM
#30
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.
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 19, 2020, 05:08:22 PM
#29
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.
hero member
Activity: 1988
Merit: 593
November 15, 2020, 06:19:45 AM
#28
thanks, but I no longer work on the address list, I use the public key to one address
Vod
legendary
Activity: 3668
Merit: 3010
Licking my boob since 1970
November 14, 2020, 02:26:55 PM
#27
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/
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 14, 2020, 02:00:02 PM
#26
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.

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.
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 09, 2020, 07:46:28 AM
#25
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 9th than on the 8th, 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.
hero member
Activity: 1988
Merit: 593
November 03, 2020, 03:06:14 AM
#24
well alphabetically, thank you, it is convenient to delete unnecessary things with this command







legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
November 01, 2020, 05:07:10 AM
#23
Update: It works again! I'll see what Black Friday brings for hosting offers Smiley
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
This subdomain is currently offline:
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 1st. 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.
hero member
Activity: 1988
Merit: 593
for 130000000000000000000000000000000000/24000000 years I will find privkey of one address Smiley

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






hero member
Activity: 1988
Merit: 593
thank you, I already figured it out, I have an old hard drive, I had to wait 1 hour.
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
how do I remove extra characters?
You mean remove the balance? I just use cut. I got you 3 new files with only addresses.
hero member
Activity: 1988
Merit: 593
I have Notepad++, but I don't have enough RAM, it freezes after selecting all the text and ALT+SHIFT+>>>
legendary
Activity: 2212
Merit: 5622
Non-custodial BTC Wallet
how do I remove extra characters? The program does not accept with them, each line only must has an address only, there should be nothing else

Which program are you using?
You will struggle a lot to manipulate this kind of data in apps such as excel.

personally, I could only open that 1GB files in my python environment. All other programs just froze

Edit: I was able to open the larger file in Notepad++.
hero member
Activity: 1988
Merit: 593
how do I remove extra characters? The program does not accept with them, each line only must has an address only, there should be nothing else
hero member
Activity: 1988
Merit: 593
thank you very much!
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
I have Windows, where do I need to set this command and what program to install?
I have no idea Tongue

So I got you this instead: http://alladdresses.loyce.club:20319/tmp/
It won't be updated, and it's scheduled to be deleted in 7 days.
hero member
Activity: 1988
Merit: 593
thank you, but I have Windows, where do I need to set this command and what program to install?
Pages:
Jump to: