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

Sanka555

member

Activity: 96

Merit: 36

Quote from: LoyceV on April 04, 2021, 04:13:38 AM

You guys have burned through roughly 1400 GB last month. Just a FYI: 2000 GB per month is the limit for my current hosting.

Maybe you just need to publish the script ***.bat for windows for example, or on JAVA code (the best variant). which will simply take the Bitcoin Core wallet and make of it

blockchair_bitcoin_addresses_and_balance_*****.txt

I would be very grateful to you for that

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

You guys have burned through roughly 1400 GB last month. Just a FYI: 2000 GB per month is the limit for my current hosting.

BrewMaster

legendary

Activity: 2114

Merit: 1293

There is trouble abrewing

Quote from: bitmover on January 06, 2021, 04:28:16 PM

Nodes shouldn't validate transactions to invalid addresses..

nodes don't relay non-standard transactions already but they must never not-validate any non-standard transaction (when they are confirmed) because that would break the backward compatibility of bitcoin and we no longer would be able to have soft forks.
SegWit addresses are non-standard by old client standards and yet they are valid.

however, this is a double edge sword. we can't prevent people from experimenting. that means they can pay to witness addresses with a version higher than what it is defined. it has been happening from early days too. for example the block 170060 contains P2SH transaction while P2SH soft fork had never happened by then. now every full node treats this particular block as an "exception".

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: willi9974 on March 04, 2021, 07:51:43 AM

what is the list

Read.

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

Data retention and updates
I'll provide daily updates. I keep the latest 3 daily snapshots, and the latest 5 monthly snapshots. One a day (or once a month) I delete the oldest files.

The server ran out of disk space during the last download. Now it should be good for a while again.

willi9974

legendary

Activity: 3500

Merit: 2792

Enjoy 500% bonus + 70 FS

i know (read) the list is from blockchair, but

what is the list
what is the point of the list
why blockchair created this list

Best regards,
Willi

DougM

full member

Activity: 173

Merit: 120

Quote from: LoyceV on February 15, 2021, 10:37:31 AM

Quote from: DougM on February 15, 2021, 10:22:17 AM

so your theory is these are small amount accounts are a result of dust attacks? Could some be 'left over change' during a transaction that is lost/forgotten about?

Dust attacks typically use the minimum amount (546 sat), so that's quite likely. From this data, I can't count the addresses that hold a dust input and also a larger amount.
..
I only checked the last one, and it's an Omli Layer transaction. Great, this crap spams the blockchain too Sad

As for dust attacks: I'm now kinda curious how much was paid in fees (and how much data got added to the blockchain) because of people who included the dust in their transactions. It's a lot of data so I can't quickly get a number for this.

If wallets could start ignoring dust inputs by default, that would be great!

completely agree!

Quote

2,821,479 addresses hold 1000 sat or less. Total value: 1,403,085,278 satoshi (~14 BTC).

So do you think the dust attackers got their money worth? based on your calculations for < 1000 addresses amounts to 14 BTC or ~679K at present value for just the dust. What exactly is their motive to justify this large outlay? I suspect this represents a number of different 'dust attackers' over time so maybe hard to generalize, but I am curious what people think.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: DougM on February 15, 2021, 10:22:17 AM

so your theory is these are small amount accounts are a result of dust attacks? Could some be 'left over change' during a transaction that is lost/forgotten about?

Dust attacks typically use the minimum amount (546 sat), so that's quite likely. From this data, I can't count the addresses that hold a dust input and also a larger amount.

Feel free to check a few:

Code:

1EM72MRxX5teiLDZDkp6vpB7Fs4gVcsBWF 546
197uWhobsZ4boSR8LjZTCpKkHuCQL15y4N 546
1DcjMsvCj1AATH6kQubsikK3pUeyFhSngp 546
1P2o8eACQFFDHHq4zZHSwPaTr347raGNNM 546
1ECYdDEmzRKm53i7H4PhCEar2SdtTemfgC 546
1J9xAa2fFabDZmPmapiczcRoeeSqtXLSC9 546
12wj7j4RSduvEt6TqoKTgH6W92Zdh1MUmL 546
1F1qvANdwZkSFosjxVY9VHD7phnZyhnXhH 546
1FN4QEPDT6K2QT6SNETmgPJdL4Qajx5x2K 546
1JzAdzFR89jT8rTCi8LzV6kj57NeXaBXd1 546
1Mik1tJvn6aunTgSbN2UzitzdZBoxeqV5E 546
3LGrNL6toFoeJb9DGYRKvvaheyVg9jCJq6 546
19gXeh5v5T2UTLJrPPWok424EuyTAtr3vK 546
3Pimkc1JiSiMVvMF4fATmWW1Z76TzVQQex 546
1EB6PXMKDE8fkN9DZPPuzH1qoN6nzuqjN6 546
1DVzTh1zA8azcjWvcHnwKvKc8ACYhSLRwd 546
3BSK1KX3WzdXcQDSoXL39g3X7HH1CKsUqy 546
17c6ii1kBTBDhEhB5DVjY5DLFe9pyYtf4y 546
1AKSbLMPjwErAsijTPUrNF87XfjMzEF7Jt 546
1C7tsDp4SGGsWzySycobW5SKZNDtGdzYd6 546
3BPMryLEyp6eCSgdbayrSroF1abU52H5Ti 546
3JbUHH3ZdfjMar6PDEFVxZVJcL4g3wxFZ1 546
1Km9HaKxEntE8NPaBp1ataTMVKeaMiZe4x 546
3Be4gfZBe2zfWNAR3zjqXpr2aCSwgJ9CkH 546
18kgQniviHyMxTEmhojASfvB39cuwayv19 546
1Nzzx5jFFv8NWoNSAMVxKK5EuVEnr91x2r 546
13CHpohNridm8L6VMSsZ4NqvVdbwqdsCwN 546
1N99f4eC6TbzF7iHCDzMhhaC2HW9qZGc1R 546
18ESDDtFFqFSbHfpe1VfNWg7A2Ym17QCFr 546
14aPgqsQAxrHktVDe4yHwHdmzNAb5pFiBB 546
39ZjTnjbFbXBHmPPm3SxHw8eBV34ggDzL7 546
19AhE5cFabYu1k7EZf1rCNMWz2nmZ4agx1 546
16owPsPAATsEz8mMC2SJEZkcnRC5n9Djb9 546

I only checked the last one, and it's an Omli Layer transaction. Great, this crap spams the blockchain too Sad

As for dust attacks: I'm now kinda curious how much was paid in fees (and how much data got added to the blockchain) because of people who included the dust in their transactions. It's a lot of data so I can't quickly get a number for this.

If wallets could start ignoring dust inputs by default, that would be great!

DougM

full member

Activity: 173

Merit: 120

Quote from: LoyceV on December 26, 2020, 06:37:46 AM

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

fascinating...so your theory is these are small amount accounts are a result of dust attacks? Could some be 'left over change' during a transaction that is lost/forgotten about? Thanks for sharing!

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.

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