Get list of all addresses with a balance over x?

[shimozukawa]

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?

[daboehla]

Generate it from the UTXO set, which is saved in the chainstate folder from bitcoin core.
Currently about 18M Addresses.

But chainstate is not a true database.

Its saved in LevelDB. I call this a database.

[Pakar11220]

Is there a way to find/export all addresses with a balance above a certain number to CSV or other file?

No broda you need to explain everything very well to know things differently.

[Mergesort]

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.

[diagla]

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.

[Roper]

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.

[daboehla]

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.

[coder0x15]

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.

[gopro]

Long time ago, but here is a update list
http://ethteam.com/download/balances_20170811.zip

hi! Someone has this file or new?

[jhdscript]

I have one générateur on 11/18

[gopro]

I have one générateur on 11/18

can you share it?

[daboehla]

I have one générateur on 11/18

can you share it?

Here is my latest:
http://ethteam.com/download/balances_493587.zip

To block 493587.

[gopro]

Here is my latest:
http://ethteam.com/download/balances_493587.zip

Many thanks!!!

ps. One day I saw a file with date of last output/input. Someone has such file?

[blocklife]

  would be cool to see someone actually achieve this
could solve the Satoshi 1million bitcoin myth.

[btctousd81]

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 ?

[byteball]

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

[Spendulus]

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

[hatuey]

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

Cheers

[hatuey]

I have one générateur on 11/18

can you share it?

Here is my latest:
http://ethteam.com/download/balances_493587.zip

To block 493587.

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?

[ehrz22]

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