Bitcoin Forum

Bitcoin => Bitcoin Technical Support => Topic started by: ChrisWit on September 02, 2017, 07:20:46 AM



Title: What command under linux to generate wallets with value
Post by: ChrisWit on September 02, 2017, 07:20:46 AM
Dear Members

I can`t find a topic in which it was described in some way to generate from blockchain on linux (Node) information about  all wallets with a value.
As I remember it was a command to get a list of all wallets with a value greater than 0.00000001 BTC
YES I know that it will take a lot of time to generate such a list.
I have a question whether there is a possibility to generate a list of all wallets with a value of 50BTC or 25BTC?
 :)


Title: Re: What command under linux to generate wallets with value
Post by: Samarkand on September 02, 2017, 09:27:17 AM
I canīt help you directly with your question, but maybe the following website already offers what you want to develop!

https://bitinfocharts.com/de/top-100-richest-bitcoin-addresses.html

You can find some fascinating information there. E.g. there is only a single BTC address with
a balance of more than 100000 Bitcoins (the Bitfinex coldwallet)  ;)


Title: Re: What command under linux to generate wallets with value
Post by: ChrisWit on September 02, 2017, 09:53:21 AM
I know this site very well, on it there is no information on portfolios wallets 50BTC and 25BTC only the bigger.


Title: Re: What command under linux to generate wallets with value
Post by: aleksej996 on September 02, 2017, 12:58:32 PM
https://bitcointalk.org/index.php?topic=2009705.0


Title: Re: What command under linux to generate wallets with value
Post by: ChrisWit on November 30, 2017, 04:48:42 PM
Hello
Can anyone tell me how I can get from blockchain  data :
all wallets with quantity 50BTC or 25BTC to date 2011?
I have linux with blockchain more then 16GB RAM.
Thanks for the explanation :)


Title: Re: What command under linux to generate wallets with value
Post by: LoyceV on November 30, 2017, 05:14:54 PM
all wallets with quantity 50BTC or 25BTC to date 2011?
Someone gave me a csv with all balances up to block 489359 last month. I can't exclude balances newer than 2011, but I can get you all balances with 25 or 50 BTC:
https://pastebin.com/csq9yktk :
Code:
1MUxfpSxAmKpCFb7mRbotHb5g2STmUzD3S;2500000000
1M9J6kkikq22mvZ4mgMpnJzch1wNKtBh7r;2500000000
1AgxXLKftanAQpvnP9JD7Lkm8EPJHF9Nxd;2500000000

The 50BTC version is too big for Pastebin: http://m.uploadedit.com/bbtc/1512062114528.txt:
Code:
18R1zbfonvzUf5nqzMa81kpt9XR37RWrcM;5000000000
12QTdJHdydBHWy7C5aTnoHMR6iGJaP8cfv;5000000000
1PvfT6WgMG1bicC9LbYpPAy6XVSVscPsSt;5000000000


Title: Re: What command under linux to generate wallets with value
Post by: ChrisWit on December 08, 2017, 04:44:32 PM
Hello
Thank`s for that file.
I just have probably the same file .
 But it needs 50BTC before breaking the block.
So it must be sorted by date, I know that this data is in the blockchain just a question- how to get it out.
If I have all 50BTC wallets, can I write a script that checks the last move date on that wallet and load it a list of these 50 BTC wallets.
But I still do not know how to do it technically ...


Title: Re: What command under linux to generate wallets with value
Post by: LoyceV on December 08, 2017, 04:59:57 PM
So it must be sorted by date, I know that this data is in the blockchain just a question- how to get it out.
If I have all 50BTC wallets, can I write a script that checks the last move date on that wallet and load it a list of these 50 BTC wallets.
There are several threads about parsing the blockchain, for example:     
How to read/parse blockchain and get bitcoin addresses having balance. (https://bitcointalk.org/index.php?topic=2242310.0)

Can you explain what exactly you're looking for in those addresses?


Title: Re: What command under linux to generate wallets with value
Post by: ChrisWit on December 09, 2017, 09:25:35 AM
Need for statistic.
I want to calculate how much bitcoin was lost forever.

Could You advice how You get all balances with 25 or 50 BTC from this Big CSV file?  it has got 893MB.
I`m also try do this, but must split for 20 other files and the use some sort program like excel.
What program/editor do You use ?
I Mean  have the editor like "editpadlite" but can`t : example show the line with  5000000000 (50BTC) only


Title: Re: What command under linux to generate wallets with value
Post by: LoyceV on December 09, 2017, 10:06:19 AM
I want to calculate how much bitcoin was lost forever.
This doesn't prove anything: Bitcoins that have never moved are not necessarily lost, and Bitcoins that have been moved can still be lost later on.

Quote
Could You advice how You get all balances with 25 or 50 BTC from this Big CSV file?
i used some standard (Linux) command line tools:
Code:
cat balances_489359.csv | grep ';5000000000' | grep -v 0000000000 > /tmp/50.txt
The first grep gets all lines that contain "5000000000", the second grep gets rid of the lines that have an additional zero (aka 500 BTC). The output goes to a txt-file.

Command line tools are very convenient to process large amounts of text, this line takes less than a second.


Title: Re: What command under linux to generate wallets with value
Post by: ChrisWit on December 09, 2017, 10:19:02 AM
Thank You.