Get list of all addresses with a balance over x?

[holy_ship]

Hey, guys!

Trying to make list of abandoned non-empty wallets (in java and bitcoinj library), but not getting one moment:
if I process only TransactionOutput (i.e. receiving address) I'll get rubbish? Because withdrawals from these addresses will not be processed?

But for TransactionInput documentation says: The concept of a "from address" is not well defined in Bitcoin and you should not assume that senders of a transaction can actually receive coins on the same address they used to sign (e.g. this is not true for shared wallets).
deprecated method getFromAddress() doesn't return sending addresses.

How other parsers solve this problem?  


What actually I want to do (maybe such parser already exists):

I want a list of abandoned for 3 years wallets. And a yearly snapshots.
The most intriguing part is: were there wallets that became empty in next years?

For example, at 01/01/2013 there were 50k addresses with funds (1++BTC) (without sending transactions from 2010!)
At 01/01/2014 it became 75k adresses (without sending transactions from 2011) BUT n of previous addresses were "recovered"
At 01/01/2015 it became 175k adresses (without sending transactions from 2012) BUT m of previous addresses were "recovered"

etc

[1713930318]

1713930318

[1713930318]

1713930318

[daboehla]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

[holy_ship]

Didn't you read the question? 

[aplistir]

Hey, guys!

Trying to make list of abandoned non-empty wallets (in java and bitcoinj library), but not getting one moment:
I want a list of abandoned for 3 years wallets. And a yearly snapshots.
The most intriguing part is: were there wallets that became empty in next years?

I would not call addresses without action for 3 years abandoned addresses.
3 years ago bitcoin already had a lot of value, and that means people saved their private keys & seeds carefully. So there wont be that many "abandoned" addresses from that time period.

However. In 2009-2011 bitcoin had almost no value, and that is why keys to many addresses were permanently lost at that time. Most abandoned & forgotten addresses are from that time.

[aplistir]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Thanks for the updated list 

And to "holy_ship" you can easily write a script that can compare balances in this new list against your list of old "abandoned" addresses and see how many have been emptied...

[bigvito19]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Do you have the hash160 download?

[daboehla]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Do you have the hash160 download?

http://ethteam.com/download/balances_hash160_498754.zip
1,3Gb

Best Regards

[bigvito19]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Do you have the hash160 download?

http://ethteam.com/download/balances_hash160_498754.zip
1,3Gb

Best Regards

that's the same thing as the other one you already posted

[hatuey]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Do you have the hash160 download?

http://ethteam.com/download/balances_hash160_498754.zip
1,3Gb

Best Regards

This is awesome growth!!!! thanks for sharing this month's reference list. Could you get one for Ethereum too?

[muiying]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Thank for your fresh list.I have downloaded and extracted the file.However,the csv file shows that there is no decimal point in all the BTC balances of all of the addresses(and the balances become extremely large).Am I missing something here?

[CarDioLogic]

Hey, guys!

Trying to make list of abandoned non-empty wallets (in java and bitcoinj library), but not getting one moment:
if I process only TransactionOutput (i.e. receiving address) I'll get rubbish? Because withdrawals from these addresses will not be processed?

But for TransactionInput documentation says: The concept of a "from address" is not well defined in Bitcoin and you should not assume that senders of a transaction can actually receive coins on the same address they used to sign (e.g. this is not true for shared wallets).
deprecated method getFromAddress() doesn't return sending addresses.

How other parsers solve this problem?  


What actually I want to do (maybe such parser already exists):

I want a list of abandoned for 3 years wallets. And a yearly snapshots.
The most intriguing part is: were there wallets that became empty in next years?

For example, at 01/01/2013 there were 50k addresses with funds (1++BTC) (without sending transactions from 2010!)
At 01/01/2014 it became 75k adresses (without sending transactions from 2011) BUT n of previous addresses were "recovered"
At 01/01/2015 it became 175k adresses (without sending transactions from 2012) BUT m of previous addresses were "recovered"

etc

By "recovered", you mean the bitcoins have been taken out without the owner's consent? How can you be sure the wallet is abandoned, the owner could just be holding bitcoins? Isn't it a bit unethical to "recover" the adresses if you can't be 100% sure it is abondoned?

The way i see it, it would be great to have an automatic system that verifies if an account is abandoned or not. For example, let's say the "system" holds a certain amount of bitcoins to send in very small ammounts to many adresses with, say, 3 years of no activity which then the owner has to send back the same ammount to confirm he is still active, and if he doesn't in a certain period of time (eg. 3 months) the wallet gets labeled as abandoned, and after another period of time the wallet gets recovered.
Not sure if this would even be possible to implement, just a crazy ideia i wanted to voice out.

[acarterczyz]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Do you have the hash160 download?

http://ethteam.com/download/balances_hash160_498754.zip
1,3Gb

Best Regards

You are AWESOME! I've been looking for this! What do you use to extract this? Is is Bitcoin Abe?

[Ned Kelly]

If you are interested to do it in low level.
All data in chainstate files which is leveldb database.
Just iterate over all records in this db and get only records which are below your desirable blockchain hight.

[hatuey]

If you are interested to do it in low level.
All data in chainstate files which is leveldb database.
Just iterate over all records in this db and get only records which are below your desirable blockchain hight.

can you share the steps to do this? I would like to try it but i have no idea what leveldb is or what tool you use to get it

[daboehla]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Thank for your fresh list.I have downloaded and extracted the file.However,the csv file shows that there is no decimal point in all the BTC balances of all of the addresses(and the balances become extremely large).Am I missing something here?

Balance is in satoshi, thats why there is no decimal

[Ned Kelly]

If you are interested to do it in low level.
All data in chainstate files which is leveldb database.
Just iterate over all records in this db and get only records which are below your desirable blockchain hight.

can you share the steps to do this? I would like to try it but i have no idea what leveldb is or what tool you use to get it

As I mentioned, it's low level access. You do not use a tool for it. You need to use some programming language to get access to it.
I myself use C++. Something like that:

Code:

#include "leveldb/db.h"
leveldb::Iterator * it = db->NewIterator(leveldb::ReadOptions());
for (it->SeekToFirst(); it->Valid(); it->Next()) {
		size_t keyFieldSize = it->key().size();
		size_t valueFieldSize = it->value().size();
		vector<uint8_t> dbKey( keyFieldSize, 0 );
		vector<uint8_t> dbValue( valueFieldSize, 0 );
		const char * ptrKeyData = it->key().data();
		const char * ptrValueData = it->value().data();
		memcpy( dbKey.data(), ptrKeyData, keyFieldSize);
		memcpy( dbValue.data(), ptrValueData, valueFieldSize);

Also, you need to lock db, otherwise it become corrupt, or just use a copy of it without locking.

[holy_ship]

By "recovered", you mean the bitcoins have been taken out without the owner's consent?

Isn't it a bit unethical to "recover" the adresses if you can't be 100% sure it is abondoned?

The way i see it, it would be great to have an automatic system that verifies if an account is abandoned or not. For example, let's say the "system" holds a certain amount of bitcoins to send in very small ammounts to many adresses with, say, 3 years of no activity which then the owner has to send back the same ammount to confirm he is still active

Yeah, I see that there are several OPEN groups trying to do this (like LBC or GTB).
So, we can imagine that there's a lot more people trying to do it without publicity.
I just want to know if they succeded or not.

Of course, it is amoral. I wish all these guys had set their bloom filters to much more smaller lists with inactive wallets.
But unfortunatelly, (almost) everyone's interested in full lists with any sum and any history

Your idea is broken, because single transaction now costs about $25. Even if you send 1 satoshi.
Actually, it is much more simple to find the owner.
Just take BTC with transaction message "if you are owner, ADD small amount of BTC to this
address and FROM it once again". Only owner can do this.

[salihno71]

Do not forget that there are hodlers who did not touch their wallet for years and plan to do so, until bitcoin value reaches xxx.

[bitxchange]

Who knows if the balances_498754.csv file shared above contains the compressed or uncompressed format of the bitcoin public address?

[anand9892]

Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  :

Code:

24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

downloaded the balances_498754.zip
but it gives error in csv reader
i even tried to convert it to excel formart but stops as error in 51 percent
pls upload a new file or upload in torrent with link
thanks