Bitcoin Forum

Bitcoin => Development & Technical Discussion => Topic started by: tkastet on November 07, 2018, 10:11:34 AM



Title: All bitcoin addresses with balance
Post by: tkastet on November 07, 2018, 10:11:34 AM
Hi, I did not find how to reply to the topic: https://bitcointalk.org/index.php?topic=267618.320, so I created this topic. Many are looking for a list of all Bitcoin balances, here it is: all balance (https://yadi.sk/d/30cT61sqyaLFQA)


Title: Re: All bitcoin addresses with balance
Post by: bob123 on November 07, 2018, 12:37:58 PM
You weren't able to reply to this topic because it has been locked.

Probably by the OP because the question already has been answered.


User starmyc has posted a link to such a dump:

Quote from: starmyc
There is: I compute a bunch of them everyday, and make them available on https://balances.syndevio.com/ (https://balances.syndevio.com/)

Regards


Title: Re: All bitcoin addresses with balance
Post by: aplistir on November 07, 2018, 01:40:45 PM
Hi, I did not find how to reply to the topic: https://bitcointalk.org/index.php?topic=267618.320, so I created this topic. Many are looking for a list of all Bitcoin balances, here it is: all balance (https://yadi.sk/d/30cT61sqyaLFQA)

Thanks for the current list ;D

I downloaded it, and it is a list of balances as you said. (file is ok, safe to download)
The balances of many addresses are like this:
Code:
33QoG5ioV4hseifKT9iaqrmD2eis7DicWA;1e+12
1ucXXZQSEf4zny2HRwAQKtVpkLPTUKRtt;1e+12
1P1iThxBH542Gmk1kZNXyji4E4iwpvSbrt;1e+12
I guess they are not exact balances. Later in the file the smaller balances are correct.

You weren't able to reply to this topic because it has been locked.

User starmyc has posted a link to such a dump:

Thumbs up for Starmyc, he does excellent job in making the balances available, but his list is not free to download, it is great to sometimes  have current balances available for free too:)
 


Title: Re: All bitcoin addresses with balance
Post by: RocketSingh on November 07, 2018, 03:51:26 PM
Hi, I did not find how to reply to the topic: https://bitcointalk.org/index.php?topic=267618.320, so I created this topic. Many are looking for a list of all Bitcoin balances, here it is: all balance (https://yadi.sk/d/30cT61sqyaLFQA)
What is the total number of addresses having any balance on it?


Title: Re: All bitcoin addresses with balance
Post by: TryNinja on November 07, 2018, 04:53:37 PM
Hi, I did not find how to reply to the topic: https://bitcointalk.org/index.php?topic=267618.320, so I created this topic. Many are looking for a list of all Bitcoin balances, here it is: all balance (https://yadi.sk/d/30cT61sqyaLFQA)
What is the total number of addresses having any balance on it?
From that file, 22439679 addresses (22,4 millions).


Title: Re: All bitcoin addresses with balance
Post by: tkastet on November 07, 2018, 04:55:32 PM
Quote from: RocketSingh
What is the total number of addresses having any balance on it?
With a balance above zero: 22439679 addresses.
In the file 22440325 addresses. Zero balances can be deleted. The file is posted immediately after parsing and has not been edited.

Quote from: aplistir

The balances of many addresses are like this:
Code:
33QoG5ioV4hseifKT9iaqrmD2eis7DicWA;1e+12
1ucXXZQSEf4zny2HRwAQKtVpkLPTUKRtt;1e+12
1P1iThxBH542Gmk1kZNXyji4E4iwpvSbrt;1e+12
I guess they are not exact balances. Later in the file the smaller balances are correct.

This is normal, this is the result of the parser, all values ​​are in Satoshi.
The list is accurate =)
1e+12 (https://online.unitconverterpro.com/library/metric-prefixes.php) is a number with twelve zeros (in satoshi).

Quote from: bob123
User starmyc has posted a link to such a dump

With respect to Starmyc, but...
Quote from: aplistir
but his list is not free to download, it is great to sometimes  have current balances available for free too:)




Title: Re: All bitcoin addresses with balance
Post by: starmyc on November 07, 2018, 08:18:46 PM
With respect to Starmyc, but...
Quote from: aplistir
but his list is not free to download, it is great to sometimes  have current balances available for free too:)

Actually, It was opened yesterday! Enjoy today's: https://balances.syndevio.com/balances/balances-bitcoin-20181107-0100-6awuMqze.gz


Title: Re: All bitcoin addresses with balance
Post by: vozphongtom on November 09, 2018, 11:56:17 AM
Hi, I did not find how to reply to the topic: https://bitcointalk.org/index.php?topic=267618.320, so I created this topic. Many are looking for a list of all Bitcoin balances, here it is: all balance (https://yadi.sk/d/30cT61sqyaLFQA)

thank you so much i really need this database

if anyone can update this database , it is best support

what is software i read it on pc  ?


Title: Re: All bitcoin addresses with balance
Post by: AdolfinWolf on November 09, 2018, 02:04:39 PM
what is software i read it on pc  ?
I think you can read it with just about any text editor, (after you unpacked it obviously.)


I just downloaded the sample and opened it up. Am i right in assuming that all balances of the sample are also "truncated".

Code:
3D2oetdNuZUqQHPJ......[truncated]......;13866086137914
If not, what are those numbers behind the ; referring to? amount of satoshi stored?


Title: Re: All bitcoin addresses with balance
Post by: TryNinja on November 09, 2018, 03:43:29 PM
I just downloaded the sample and opened it up. Am i right in assuming that all balances of the sample are also "truncated".

Code:
3D2oetdNuZUqQHPJ......[truncated]......;13866086137914
If not, what are those numbers behind the ; referring to? amount of satoshi stored?
Yes.

Check the last post from OP:

This is normal, this is the result of the parser, all values ​​are in Satoshi.
The list is accurate =)
1e+12 (https://online.unitconverterpro.com/library/metric-prefixes.php) is a number with twelve zeros (in satoshi).


Title: Re: All bitcoin addresses with balance
Post by: drawingthesun on November 11, 2018, 02:49:50 AM
Anyone have a script to get this out of a Bitcoin core node ourselves?


Title: Re: All bitcoin addresses with balance
Post by: keychainX on November 12, 2018, 08:34:04 PM
Anyone have a script to get this out of a Bitcoin core node ourselves?

There are several on github.

https://github.com/alecalve/python-bitcoin-blockchain-parser
and
https://github.com/tenthirtyone/blocktools

my favourite though is https://github.com/znort987/blockparser but the official version has a bug and crashes around block 424.000
but there are custom made versions that passes this bug...


Title: Re: All bitcoin addresses with balance
Post by: tkastet on November 13, 2018, 09:41:37 AM
In this case, the user's starmyc (https://bitcointalk.org/index.php?action=profile;u=1771203) chainstate parser (https://github.com/mycroft/chainstate) is used.
Respect, bro, starmyc :)


Title: Re: All bitcoin addresses with balance
Post by: tkastet on June 17, 2019, 07:13:16 AM
New list (https://yadi.sk/d/b-Ap5lIoznL1IA).


Title: Re: All bitcoin addresses with balance
Post by: walletscat on July 08, 2019, 10:34:15 AM
New list (https://yadi.sk/d/b-Ap5lIoznL1IA).

Do you have all listings?
address, hash160, amount
For example:
Code:
1DpBda3jw6x2rbkSJUFrBfUPKgFbZsr5t9,8c8deefad99de1daffac1446a01132266c9d58fa,35264328
1JtY892wdpUfeVqg3nH3fed2whZBi9xTf,036217897bf7eb792d129b962e8d478e2030ac94,19446553
19b8mLDpqbUwZCZ8Sa9TbMj2ofhcUwc5HF,5e35a15c10dd14e888b58320f737142c48e2eea6,3366861
15SQ4c9BRsR77hbBLBXxGi8h7V7pDFtShG,30ae274c7101a903e1cce0d429383b2d680c947f,10524100
or
Code:
8c8deefad99de1daffac1446a01132266c9d58fa,35264328
036217897bf7eb792d129b962e8d478e2030ac94,19446553
5e35a15c10dd14e888b58320f737142c48e2eea6,3366861
30ae274c7101a903e1cce0d429383b2d680c947f,10524100
download link die  :'(
Code:
https://bitcointalk.org/index.php?topic=267618.msg29206287#msg29206287
and
https://bitcointalk.org/index.php?topic=267618.msg26309298#msg26309298