holy_ship
Jr. Member
Offline
Activity: 115
Merit: 1
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 12, 2017, 08:50:05 AM Last edit: December 12, 2017, 09:15:24 AM by 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? ![Huh](https://bitcointalk.org/Smileys/default/huh.gif) 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
|
|
|
|
|
holy_ship
Jr. Member
Offline
Activity: 115
Merit: 1
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 12, 2017, 10:20:10 AM |
|
Didn't you read the question?
|
|
|
|
aplistir
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 12, 2017, 11:07:09 AM |
|
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.
|
My Address: 121f7zb2U4g9iM4MiJTDhEzqeZGHzq5wLh
|
|
|
aplistir
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 12, 2017, 11:14:36 AM |
|
Thanks for the updated list ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif) 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...
|
My Address: 121f7zb2U4g9iM4MiJTDhEzqeZGHzq5wLh
|
|
|
bigvito19
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 12, 2017, 09:10:27 PM |
|
Do you have the hash160 download?
|
|
|
|
|
bigvito19
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 14, 2017, 10:45:23 PM |
|
that's the same thing as the other one you already posted
|
|
|
|
hatuey
Newbie
Offline
Activity: 54
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 18, 2017, 08:49:31 PM |
|
This is awesome growth!!!! thanks for sharing this month's reference list. Could you get one for Ethereum too?
|
|
|
|
muiying
Newbie
Offline
Activity: 1
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 19, 2017, 03:47:40 PM |
|
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
Newbie
Offline
Activity: 48
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 19, 2017, 07:59:56 PM |
|
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](https://bitcointalk.org/Smileys/default/huh.gif) 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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 20, 2017, 12:37:05 AM |
|
You are AWESOME! I've been looking for this! What do you use to extract this? Is is Bitcoin Abe?
|
|
|
|
Ned Kelly
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 21, 2017, 04:22:09 AM |
|
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
Newbie
Offline
Activity: 54
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 24, 2017, 11:26:44 AM |
|
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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 24, 2017, 01:38:28 PM |
|
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](https://bitcointalk.org/Smileys/default/wink.gif)
|
|
|
|
Ned Kelly
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 25, 2017, 12:33:50 AM |
|
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: #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
Jr. Member
Offline
Activity: 115
Merit: 1
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 26, 2017, 08:20:59 AM |
|
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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 26, 2017, 09:10:51 AM |
|
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
Newbie
Offline
Activity: 6
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 28, 2017, 03:30:42 PM Last edit: December 28, 2017, 09:48:54 PM by bitxchange |
|
Who knows if the balances_498754.csv file shared above contains the compressed or uncompressed format of the bitcoin public address?
|
|
|
|
anand9892
Newbie
Offline
Activity: 3
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 03, 2018, 06:31:43 AM |
|
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
|
|
|
|
|