List of all Bitcoin addresses with a balance - page 10.

Evilish

hero member

Activity: 882

Merit: 563

Bitcoin to the moon!

Quote from: LoyceV on January 27, 2021, 01:15:14 PM

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.

Wow, more than a thousand downloads per month. That's bound to eat up a lot of bandwidth seeing as each download must be ~1 GB.

My guess would be some of those are people utilizing your list to locate their full addresses using first bits. I collect physical Bitcoin collectibles and currently use smartbit.com.au to find full addresses associated with physical coins using the provided first bits.

I feel it would be really neat to do that using shell and not having to go through a third party. But for my use case I would probably need to download the file only once and use the same copy over and over seeing as most older collectibles should already be under your latest list.

Thanks for your work on this. Count on one more download and an additional 1 GB increase in bandwidth in the next few days because I am going to download a copy and spin up a small script for my own use soon. Wink

starmyc

full member

Activity: 198

Merit: 130

Some random software engineer

Quote from: LoyceV on January 27, 2021, 01:15:14 PM

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: blauervogel on January 28, 2021, 08:17:11 AM

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 Wink

Thanks for posting what you use this for.

blauervogel

newbie

Activity: 1

Merit: 6

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 Cheesy

Cheers

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: LoyceV on December 18, 2020, 04:34:31 AM

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

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:
Image loading...

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: cryptothoughts42 on January 19, 2021, 11:14:01 PM

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

cryptothoughts42

newbie

Activity: 1

Merit: 0

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

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Quote from: LoyceV on December 06, 2020, 07:16:48 AM

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Update:

Quote from: LoyceV on June 11, 2020, 10:30:34 AM

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.

Quote from: LoyceV on June 11, 2020, 10:30:34 AM

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

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: LoyceV on November 14, 2020, 01:00:02 PM

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.

alevlaslo

hero member

Activity: 1988

Merit: 593

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

Quote from: alevlaslo on October 19, 2020, 10:37:14 AM

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/

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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

Quote from: LoyceV on June 11, 2020, 10:30:34 AM

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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.

alevlaslo

hero member

Activity: 1988

Merit: 593

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

This subdomain is currently offline:

Quote from: LoyceV on June 11, 2020, 10:30:34 AM

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.

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