Pages:
Author

Topic: Get list of all addresses with a balance over x? - page 11. (Read 43279 times)

sr. member
Activity: 490
Merit: 258
@daboehla would you have a new hash160 file with all hashes for all addresses?

thanks in advance!
Still waiting for my new PC... I think about somewhere next week I can make a fresh one.
newbie
Activity: 2
Merit: 0
@daboehla would you have a new hash160 file with all hashes for all addresses?

thanks in advance!
newbie
Activity: 78
Merit: 0
There is ';' instead ',' You must replace all in editor.

Code:
1CG4LbEXoBus2egJS8SBh3DDPTrSykzFMG;942800
1Jt1Yng68p6Pd3pYWc1W1nxWSZSx9PZNto;2100390
32i3fvUTZkq2zeHBuosYDkiSCyMDhP62eo;9592347
newbie
Activity: 3
Merit: 0
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
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
newbie
Activity: 6
Merit: 0
Who knows if the balances_498754.csv file shared above contains the compressed or uncompressed format of the bitcoin public address?
sr. member
Activity: 420
Merit: 250
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.
jr. member
Activity: 113
Merit: 1
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.
full member
Activity: 170
Merit: 101

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 dbKey( keyFieldSize, 0 );
vector 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.
sr. member
Activity: 490
Merit: 258
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
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 Wink
newbie
Activity: 54
Merit: 0

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
full member
Activity: 170
Merit: 101

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.
full member
Activity: 168
Merit: 100
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
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?
newbie
Activity: 48
Merit: 0
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?  Huh


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.
newbie
Activity: 1
Merit: 0
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
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?
newbie
Activity: 54
Merit: 0
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
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?
full member
Activity: 706
Merit: 111
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
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
sr. member
Activity: 490
Merit: 258
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
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
full member
Activity: 706
Merit: 111
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
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?
full member
Activity: 378
Merit: 197
Free fresh list:
http://ethteam.com/download/balances_498754.zip

Addresses with balance is rising fast  Cool:
Code:
24'473'765 total addresses
10'772'238 addresses own over 1mbtc
   617'634 addresses own over 1btc

Thanks for the updated list  Smiley

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...
full member
Activity: 378
Merit: 197
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.
Pages:
Jump to: