Pages:
Author

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

jr. member
Activity: 115
Merit: 1
Didn't you read the question?  Huh
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
jr. member
Activity: 115
Merit: 1
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
full member
Activity: 406
Merit: 105
.....2,023,005 bitcoins reside in addresses which have been untouched in over three years. ....

It makes me sad to think of all those abandoned BTC... I wish I could call them into my wallet and give them a nice home where they will be loved and cherished.



These are cared for by the God of Hodling.

This untouched wallet addresses made bitcoin price more valuable. How I wish I can have small amount of that. But I'm not wishing that I'm one of the owner's of that addresses, it's very unlucky of them. I also wish bitcoin will make a way how to recover forgotten private keys of wallet addresses.
newbie
Activity: 54
Merit: 0

Thank you for your two previous shares about these lists. I have used them to compare the increase of wallets and balances in them. Adoption is increasing! or at least wallet distribution. Can't really be sure which one it is in reality but all in all, there are more wallets with btc in them every day!

Could you share the steps to obtain this list mate?
newbie
Activity: 54
Merit: 0
I am curious to see what the mass coverage of BTC has done in terms of adoption and new users.

Is there a way to get an updated list?

Would it be possible to have some instructions as to how to get this list myself? - I am sorry for the noob question. I am still relatively new myself to blockchain and all its features. I have been reading up and down about crypto but haven't dwelled into the tech side. Can anyone share a guide or something to obtain this kind of list every once in a while.

To me the best metric is seeing how many active wallets hold BTC and how spread btc is through all these wallets. Wealth transfer at its best Cheesy

Cheers
legendary
Activity: 2926
Merit: 1386
.....2,023,005 bitcoins reside in addresses which have been untouched in over three years. ....

It makes me sad to think of all those abandoned BTC... I wish I could call them into my wallet and give them a nice home where they will be loved and cherished.



These are cared for by the God of Hodling.
member
Activity: 266
Merit: 42
The rising tide lifts all boats
Generate it from the UTXO set, which is saved in the chainstate folder from bitcoin core.
Currently about 18M Addresses.

Thanks for the data.
I'm currently trying to write a tool that can also calculate the balances based on the chainstate LevelDB. However, the deserialization of the values seems very complex (see https://github.com/bitcoin/bitcoin/blob/d4a42334d447cad48fb3996cad0fd5c945b75571/src/coins.h#L21). I'm curious if you were able to reuse any code of the bitcoin core client or if you rewrote everything by yourself.
The new format in 0.15 Bitcoin Core client is much simpler: they now store each output separately.
Satoshis amounts are packed in a bit tricky way, but I guess "uncompress value" can be translated from the C++ source into any language of your choice.
When you open LevelDB in another program, you need to turn Snappy compression off in order not to corrupt the data if you want to run bitcoind again. Unfortunately, I found no way to open it read-only (in Java).
sr. member
Activity: 434
Merit: 270
Smiley would be cool to see someone actually achieve this
could solve the Satoshi 1million bitcoin myth.



what is this Satoshi 1million bitcoin myth ? you are talking about ?

copper member
Activity: 81
Merit: 0
Look around you , nothing is secure
 Smiley would be cool to see someone actually achieve this
could solve the Satoshi 1million bitcoin myth.

newbie
Activity: 6
Merit: 0

Many thanks!!!

ps. One day I saw a file with date of last output/input. Someone has such file?
sr. member
Activity: 490
Merit: 258
newbie
Activity: 6
Merit: 0
I have one générateur on 11/18
can you share it? Smiley
member
Activity: 266
Merit: 10
I have one générateur on 11/18
newbie
Activity: 6
Merit: 0
Long time ago, but here is a update list Smiley
http://ethteam.com/download/balances_20170811.zip

hi! Someone has this file or new?
jr. member
Activity: 36
Merit: 3
This list may be generated from raw dat files (blkindex.dat).
Generate it from the UTXO set, which is saved in the chainstate folder from bitcoin core.
Currently about 18M Addresses.

You about "real-time" UTXO set. I mean crypto proof UTXO set which is calculated from raw dump on concrete time.
sr. member
Activity: 490
Merit: 258
This list may be generated from raw dat files (blkindex.dat).
Generate it from the UTXO set, which is saved in the chainstate folder from bitcoin core.
Currently about 18M Addresses.

Thanks for the data.
I'm currently trying to write a tool that can also calculate the balances based on the chainstate LevelDB. However, the deserialization of the values seems very complex (see https://github.com/bitcoin/bitcoin/blob/d4a42334d447cad48fb3996cad0fd5c945b75571/src/coins.h#L21). I'm curious if you were able to reuse any code of the bitcoin core client or if you rewrote everything by yourself.
I wrote a C# program. Tried to copy most of the functions and modified to get it running. (VarInt, txout script compression)
Yeah it took me some time to get all running. Very complex compressing.
Currently I am on holiday but if you need some help in about one week you can contact me.
newbie
Activity: 1
Merit: 0
This list may be generated from raw dat files (blkindex.dat).
Generate it from the UTXO set, which is saved in the chainstate folder from bitcoin core.
Currently about 18M Addresses.

Thanks for the data.
I'm currently trying to write a tool that can also calculate the balances based on the chainstate LevelDB. However, the deserialization of the values seems very complex (see https://github.com/bitcoin/bitcoin/blob/d4a42334d447cad48fb3996cad0fd5c945b75571/src/coins.h#L21). I'm curious if you were able to reuse any code of the bitcoin core client or if you rewrote everything by yourself.
full member
Activity: 161
Merit: 100
For example, no one knows Satoshi's addresses, but they are rumored to contain upwards of 1,000,000 Bitcoins.

So, he's a billionaire on paper. If he were to sell his BTC, how much would he expect to lose due to the associated crash in the BTC marketplace?

Why would he need to? If he is able to spend his bitcoins for whatever he needs he should be fine without selling anything.

I'd imagine that any change at all in the addresses suspected to be his would either cause some excitement or panic.
full member
Activity: 140
Merit: 100
For example, no one knows Satoshi's addresses, but they are rumored to contain upwards of 1,000,000 Bitcoins.

So, he's a billionaire on paper. If he were to sell his BTC, how much would he expect to lose due to the associated crash in the BTC marketplace?

Why would he need to? If he is able to spend his bitcoins for whatever he needs he should be fine without selling anything.
Pages:
Jump to: