Bitcoin Forum
June 23, 2018, 07:05:48 AM *
News: Latest stable version of Bitcoin Core: 0.16.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 [All]
  Print  
Author Topic: Get list of all addresses with a balance over x?  (Read 39865 times)
n4ru
Sr. Member
****
Offline Offline

Activity: 350
Merit: 250



View Profile
August 03, 2013, 09:19:00 PM
 #1

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

ETH-Nova - Fully Automated OC/PL/P-state/Mining/Monitoring for Windows
ETH: 0x00972cd6a2c6786afbcc24ca592b8c86f33f747a / BTC: 1n4ruYy5QWbTDBbPEyBRWwj1Ni4U4Sz5P
1529737548
Hero Member
*
Offline Offline

Posts: 1529737548

View Profile Personal Message (Offline)

Ignore
1529737548
Reply with quote  #2

1529737548
Report to moderator
1529737548
Hero Member
*
Offline Offline

Posts: 1529737548

View Profile Personal Message (Offline)

Ignore
1529737548
Reply with quote  #2

1529737548
Report to moderator
1529737548
Hero Member
*
Offline Offline

Posts: 1529737548

View Profile Personal Message (Offline)

Ignore
1529737548
Reply with quote  #2

1529737548
Report to moderator
The World's Betting Exchange

Bet with play money. Win real Bitcoin. 5BTC Prize Fund for World Cup 2018.

Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
Remember remember the 5th of November
Legendary
*
Offline Offline

Activity: 1708
Merit: 1001

Reverse engineer from time to time


View Profile
August 03, 2013, 10:40:51 PM
 #2

Over a year ago I actually started importing the blockchain and doing just that, but it requires the full blockchain imported into MySQL or your preferred database.

BTC:1AiCRMxgf1ptVQwx6hDuKMu4f7F27QmJC2
battani
Newbie
*
Offline Offline

Activity: 25
Merit: 0



View Profile
August 07, 2013, 03:41:08 PM
 #3

Over a year ago I actually started importing the blockchain and doing just that, but it requires the full blockchain imported into MySQL or your preferred database.

Interested in doing this too. Found this to import blockchain into MongoDB: https://github.com/thelinuxkid/bitcoinquery
Remember remember the 5th of November
Legendary
*
Offline Offline

Activity: 1708
Merit: 1001

Reverse engineer from time to time


View Profile
August 07, 2013, 04:18:53 PM
 #4

I would recommend ABE, but with it, if you start importing from block 0, it might take a month or two to fully import the blockchain, unless of course you have an SSD and fast RAM.

BTC:1AiCRMxgf1ptVQwx6hDuKMu4f7F27QmJC2
w00dy
Member
**
Offline Offline

Activity: 96
Merit: 10


View Profile
August 07, 2013, 07:51:17 PM
 #5

in short:

- get a Linux Box/VM with >=8GB RAM
- download blockparser
- compile it
- run "./parser allBalances  -w 250000 >allBalances.txt"

the parser run take around 2 minutes on my vSphere VM (2x3Ghz Xeon, 16GB of RAM)

now you have a list of the top 250.000 adresses sorted by BTC amount.

add some sed/awk/cut magic to make a csv and you are done.


not as easy for the avg windows joe but not that hard either...


quick'n'dirty Wink

Edit: ofc you need a up-to-date blockchain in <user>/.bitcoin for it to parse
n4ru
Sr. Member
****
Offline Offline

Activity: 350
Merit: 250



View Profile
August 08, 2013, 08:20:37 AM
 #6

in short:

- get a Linux Box/VM with >=8GB RAM
- download blockparser
- compile it
- run "./parser allBalances  -w 250000 >allBalances.txt"

the parser run take around 2 minutes on my vSphere VM (2x3Ghz Xeon, 16GB of RAM)

now you have a list of the top 250.000 adresses sorted by BTC amount.

add some sed/awk/cut magic to make a csv and you are done.


not as easy for the avg windows joe but not that hard either...


quick'n'dirty Wink

Edit: ofc you need a up-to-date blockchain in <user>/.bitcoin for it to parse

Bravo, thank you very much!

ETH-Nova - Fully Automated OC/PL/P-state/Mining/Monitoring for Windows
ETH: 0x00972cd6a2c6786afbcc24ca592b8c86f33f747a / BTC: 1n4ruYy5QWbTDBbPEyBRWwj1Ni4U4Sz5P
Dabs
Staff
Legendary
*
Offline Offline

Activity: 2086
Merit: 1104



View Profile
August 09, 2013, 12:23:02 AM
 #7

Hi,

How large is the resulting file? Can someone be kind enough to post the top 1000 or the top 10,000 addresses as of a certain date? That would be interesting information.

Escrow Service (Services) - GPG ID: 32AD7565, OTC ID: Dabs
All messages concerning escrow or with bitcoin addresses are GPG signed. Please verify.
CompTIA A+, Microsoft Certified Professional, MCSA: Windows 10; Windows Server 2012, MCSE: Cloud Platform and Infrastructure; Productivity; Messaging
w00dy
Member
**
Offline Offline

Activity: 96
Merit: 10


View Profile
August 09, 2013, 06:31:16 AM
 #8

info:   251073 blocks,   16.412 MegaAddrs , 100.00% , elapsed = 133.24s , eta =  0.00s ,

info: found 1838168 addresses with non zero balance

-------------------------

The result is a 2.7GB Text file.

sripped to balance + Adress only, it's 700ish MB, 55MB gzip compressed. I will upload the file later. right now i'm on a very slow 3g connection.
n4ru
Sr. Member
****
Offline Offline

Activity: 350
Merit: 250



View Profile
August 09, 2013, 06:40:04 AM
 #9

info:   251073 blocks,   16.412 MegaAddrs , 100.00% , elapsed = 133.24s , eta =  0.00s ,

info: found 1838168 addresses with non zero balance

-------------------------

The result is a 2.7GB Text file.

sripped to balance + Adress only, it's 700ish MB, 55MB gzip compressed. I will upload the file later. right now i'm on a very slow 3g connection.
Can you upload just the addresses alone? I'll tip a couple bitcents.

ETH-Nova - Fully Automated OC/PL/P-state/Mining/Monitoring for Windows
ETH: 0x00972cd6a2c6786afbcc24ca592b8c86f33f747a / BTC: 1n4ruYy5QWbTDBbPEyBRWwj1Ni4U4Sz5P
w00dy
Member
**
Offline Offline

Activity: 96
Merit: 10


View Profile
August 09, 2013, 12:44:34 PM
 #10

The result is a lot smaller  Smiley

block height was 251073 at the run.

All Adresses (WITH a balance! not all ever used ones). 1,8ish Million. Down to the last Satoshi
Code:
https://mega.co.nz/#!90RxEIZC!cv5xVChAvF_u7aNwnvBHEEyq668AoUjpmFv0t-jWFKA

Same list but with the balance for each Address
Code:
https://mega.co.nz/#!8sR0QCyZ!aMsjDEJw8ulbqHQ_HgNSQBoZcqZdyyCzEgjGjgw3KYM


both 46ish MB zipped, first one 61 MB, 2nd one 82 MB uncompressed.

Please note, you need a real Editor on Windows to open them. Notepad++ for example. Notepad don't cut it here.
dserrano5
Legendary
*
Offline Offline

Activity: 1848
Merit: 1000



View Profile
August 09, 2013, 06:54:54 PM
 #11

Thanks for these listings!

Interesting to see that only ~3% of all addresses have 50 BTC or more. 10% have 1 BTC or more. The median balance is 0.0002 BTC. 44% of all addresses have what today is considered dust (ie less than 5430 satoshis). If only we could map this to (anonymous) individual people…

w00dy
Member
**
Offline Offline

Activity: 96
Merit: 10


View Profile
August 11, 2013, 12:20:42 PM
 #12

44% of all addresses have what today is considered dust (ie less than 5430 satoshis).

 Shocked
w00dy
Member
**
Offline Offline

Activity: 96
Merit: 10


View Profile
January 03, 2014, 02:23:33 PM
 #13

i got a PM asking about a fresh set of lists.

Here we go:

All Adresses (WITH a balance! not all ever used ones). 2,4ish Million. Down to the last Satoshi
Code:
https://mega.co.nz/#!59QG0JCK!SHce3leeLBJTl4Dwk3tnpF9NLFEqh4GNHlnd2M1CIkM

Same list but with the balance for each Address

Code:
https://mega.co.nz/#!c85TQAgZ!Vibawlxa0spSkbo_HEEdf17O790nyxZefPfjSkryVrM

jratcliff63367
Member
**
Offline Offline

Activity: 82
Merit: 10


View Profile
January 08, 2014, 09:36:28 PM
 #14

If you have a 64bit windows machine and the entire blockchain on your hard drive you can use this console app:

First, download an unzip the console app.

https://drive.google.com/file/d/0BwdyTvSh6bUkazZLRk1CQkVsNXM/edit?usp=sharing

Run blockchain.exe passing in the command line argument of wherever the blk?Huh?.dat files are on your machine.

Example: blockchain.exe c:\Users\YourName\AppData\Roaming\Bitcoin\blocks

Once the program comes up, type the command: "scan" and hit enter.  This will scan all of the blockchain.

Next, enable gathering address statistics by typing "statistics" and hitting enter. Warning you must have a lot of memory and swap available on your machine!

Next, type "process" and hit enter.

When that is done you can decide the minimum balance addresses you want to know about.  Say you want all addresses with more than 1000 bitcoins.  Then type: "min_balance 1000" and hit enter.

Now, to get a report of the top 100 addresses with a balance over a thousand type: "top_balance 100"

Scanning and processing the blockchain may take a long time on your machine (several minutes) the first time you run it.  However, doing queries against it once it has been parsed is immediate.

You can also report the oldest addresses by using the command 'oldest' and you can get stats for 'zombie' addresses by typing 'zombie' followed by the number of days.  So, if you type 'zombie 365' it will report stats about how many addresses (higher than the min balance and older than one year).

If somebody wants to build this for Ubuntu or Mac-OS that would be great too.

http://codesuppository.blogspot.com/2014/01/a-command-line-interface-for-blockchain.html
cp1
Hero Member
*****
Offline Offline

Activity: 616
Merit: 500


Stop using branwallets


View Profile
January 08, 2014, 09:39:31 PM
 #15

I'm curious as to what % of possible addresses have been used?

Guide to armory offline install on USB key:  https://bitcointalk.org/index.php?topic=241730.0
jratcliff63367
Member
**
Offline Offline

Activity: 82
Merit: 10


View Profile
January 08, 2014, 10:04:05 PM
 #16

What do you mean?  The percent of all possible addresses which have been used to date is probably something like 0.00000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000 01%
cp1
Hero Member
*****
Offline Offline

Activity: 616
Merit: 500


Stop using branwallets


View Profile
January 08, 2014, 10:08:12 PM
 #17

Of course it's small, I'm just curious.  There's what, 1e48 possible addresses, and something like 100e6 transactions, but how many of those were to unique addresses?  Do we have 1/1e40 of addresses used, or is it smaller?

Guide to armory offline install on USB key:  https://bitcointalk.org/index.php?topic=241730.0
Aleš Janda
Newbie
*
Offline Offline

Activity: 10
Merit: 0



View Profile WWW
January 18, 2014, 08:49:45 PM
 #18

Of course it's small, I'm just curious.  There's what, 1e48 possible addresses, and something like 100e6 transactions, but how many of those were to unique addresses?  Do we have 1/1e40 of addresses used, or is it smaller?

Definitelly smaller. We have 2e7 used addressed now, so total space is ~ 5e40 times larger.

Author of WalletExplorer.com.
Enkel
Member
**
Offline Offline

Activity: 122
Merit: 20



View Profile
January 19, 2014, 04:25:38 AM
 #19

If you have a 64bit windows machine and the entire blockchain on your hard drive you can use this console app:

First, download an unzip the console app.

https://drive.google.com/file/d/0BwdyTvSh6bUkazZLRk1CQkVsNXM/edit?usp=sharing

Run blockchain.exe passing in the command line argument of wherever the blk?Huh?.dat files are on your machine.

Example: blockchain.exe c:\Users\YourName\AppData\Roaming\Bitcoin\blocks

Once the program comes up, type the command: "scan" and hit enter.  This will scan all of the blockchain.

Next, enable gathering address statistics by typing "statistics" and hitting enter. Warning you must have a lot of memory and swap available on your machine!

Next, type "process" and hit enter.

When that is done you can decide the minimum balance addresses you want to know about.  Say you want all addresses with more than 1000 bitcoins.  Then type: "min_balance 1000" and hit enter.

Now, to get a report of the top 100 addresses with a balance over a thousand type: "top_balance 100"

Scanning and processing the blockchain may take a long time on your machine (several minutes) the first time you run it.  However, doing queries against it once it has been parsed is immediate.

You can also report the oldest addresses by using the command 'oldest' and you can get stats for 'zombie' addresses by typing 'zombie' followed by the number of days.  So, if you type 'zombie 365' it will report stats about how many addresses (higher than the min balance and older than one year).

If somebody wants to build this for Ubuntu or Mac-OS that would be great too.

http://codesuppository.blogspot.com/2014/01/a-command-line-interface-for-blockchain.html

Thanks for posting this! (I'm mostly posting so I can find this again in the future for a potential project).

BUT, From the last link (the blog post):

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

micax1
Hero Member
*****
Offline Offline

Activity: 672
Merit: 500


View Profile
June 13, 2014, 07:01:31 PM
 #20

If you have a 64bit windows machine and the entire blockchain on your hard drive you can use this console app:

First, download an unzip the console app.

https://drive.google.com/file/d/0BwdyTvSh6bUkazZLRk1CQkVsNXM/edit?usp=sharing

Run blockchain.exe passing in the command line argument of wherever the blk?Huh?.dat files are on your machine.

Example: blockchain.exe c:\Users\YourName\AppData\Roaming\Bitcoin\blocks

Once the program comes up, type the command: "scan" and hit enter.  This will scan all of the blockchain.

Next, enable gathering address statistics by typing "statistics" and hitting enter. Warning you must have a lot of memory and swap available on your machine!

Next, type "process" and hit enter.

When that is done you can decide the minimum balance addresses you want to know about.  Say you want all addresses with more than 1000 bitcoins.  Then type: "min_balance 1000" and hit enter.

Now, to get a report of the top 100 addresses with a balance over a thousand type: "top_balance 100"

Scanning and processing the blockchain may take a long time on your machine (several minutes) the first time you run it.  However, doing queries against it once it has been parsed is immediate.

You can also report the oldest addresses by using the command 'oldest' and you can get stats for 'zombie' addresses by typing 'zombie' followed by the number of days.  So, if you type 'zombie 365' it will report stats about how many addresses (higher than the min balance and older than one year).

If somebody wants to build this for Ubuntu or Mac-OS that would be great too.

http://codesuppository.blogspot.com/2014/01/a-command-line-interface-for-blockchain.html



after "process" - utility simple gathers final statistics and quits...
Altoidnerd
Sr. Member
****
Offline Offline

Activity: 406
Merit: 250


http://altoidnerd.com


View Profile WWW
June 16, 2014, 07:13:26 AM
 #21

I use znort987/blockparser in ubtunu/debian

Code:

sudo apt-get install libssl-dev build-essential g++-4.4 libboost-all-dev libsparsehash-dev git-core perl

git clone https://github.com/znort987/blockparser

cd blockparser

make

./parser allBalances >manygigs.txt


This does get ALL balances.  Anyone know how to tweak this?

Do you even mine?
http://altoidnerd.com 
12gKRdrz7yy7erg5apUvSRGemypTUvBRuJ
cp1
Hero Member
*****
Offline Offline

Activity: 616
Merit: 500


Stop using branwallets


View Profile
June 16, 2014, 04:34:53 PM
 #22

Can't you just sort the output?

Guide to armory offline install on USB key:  https://bitcointalk.org/index.php?topic=241730.0
micax1
Hero Member
*****
Offline Offline

Activity: 672
Merit: 500


View Profile
October 20, 2014, 05:37:57 PM
 #23

in short:

- get a Linux Box/VM with >=8GB RAM
- download blockparser
- compile it
- run "./parser allBalances  -w 250000 >allBalances.txt"

the parser run take around 2 minutes on my vSphere VM (2x3Ghz Xeon, 16GB of RAM)

now you have a list of the top 250.000 adresses sorted by BTC amount.

add some sed/awk/cut magic to make a csv and you are done.


not as easy for the avg windows joe but not that hard either...


quick'n'dirty Wink

Edit: ofc you need a up-to-date blockchain in <user>/.bitcoin for it to parse

it seems that -w option is not working correctly - I always get output of all addresses ~ 8GB
micax1
Hero Member
*****
Offline Offline

Activity: 672
Merit: 500


View Profile
October 20, 2014, 09:38:35 PM
 #24

Can't you just sort the output?

sort 8GB txt ? )
cp1
Hero Member
*****
Offline Offline

Activity: 616
Merit: 500


Stop using branwallets


View Profile
October 20, 2014, 09:40:05 PM
 #25

Can't you just sort the output?

sort 8GB txt ? )

Why not, I've got 16 GB RAM Smiley

Guide to armory offline install on USB key:  https://bitcointalk.org/index.php?topic=241730.0
teukon
Legendary
*
Offline Offline

Activity: 1246
Merit: 1000



View Profile
October 21, 2014, 12:51:39 AM
 #26

I'm curious as to what % of possible addresses have been used?

I know this is an old question but I was bored.

As of block 326 219 (2014-10-20 23:15:09) I see 50 627 736 distinct addresses in the blockchain (including those with a balance of zero).  There are 2160 = 1 461 501 637 330 902 918 203 684 832 716 283 019 655 932 542 976 different possible addresses (minor assumption about RIPEMD-160 here).  Thus, we've used 3.464*10-39% of all possible addresses (4.s.f).  That's 0.000 000 000 000 000 000 000 000 000 000 000 000 003 464% (4.s.f).

I'm willing to bet I've made an error or two here.
lyth0s
Legendary
*
Offline Offline

Activity: 1260
Merit: 1000


World Class Cryptonaire


View Profile
October 21, 2014, 07:09:18 AM
 #27

Just sent a PM to W00dy to see if we can get an updated address/btc list. I'd like to see how my own collection compares with the rest of the bitcoin users Cheesy

Monero - Truly Anonymous Digital Cash. Bitcoin Reading List 2017
micax1
Hero Member
*****
Offline Offline

Activity: 672
Merit: 500


View Profile
October 27, 2014, 10:07:05 PM
 #28

anybody has updated list?
micax1
Hero Member
*****
Offline Offline

Activity: 672
Merit: 500


View Profile
October 28, 2014, 11:42:03 AM
 #29

If you have a 64bit windows machine and the entire blockchain on your hard drive you can use this console app:

First, download an unzip the console app.

https://drive.google.com/file/d/0BwdyTvSh6bUkazZLRk1CQkVsNXM/edit?usp=sharing

Run blockchain.exe passing in the command line argument of wherever the blk?Huh?.dat files are on your machine.

Example: blockchain.exe c:\Users\YourName\AppData\Roaming\Bitcoin\blocks

Once the program comes up, type the command: "scan" and hit enter.  This will scan all of the blockchain.

Next, enable gathering address statistics by typing "statistics" and hitting enter. Warning you must have a lot of memory and swap available on your machine!

Next, type "process" and hit enter.

When that is done you can decide the minimum balance addresses you want to know about.  Say you want all addresses with more than 1000 bitcoins.  Then type: "min_balance 1000" and hit enter.

Now, to get a report of the top 100 addresses with a balance over a thousand type: "top_balance 100"

Scanning and processing the blockchain may take a long time on your machine (several minutes) the first time you run it.  However, doing queries against it once it has been parsed is immediate.

You can also report the oldest addresses by using the command 'oldest' and you can get stats for 'zombie' addresses by typing 'zombie' followed by the number of days.  So, if you type 'zombie 365' it will report stats about how many addresses (higher than the min balance and older than one year).

If somebody wants to build this for Ubuntu or Mac-OS that would be great too.

http://codesuppository.blogspot.com/2014/01/a-command-line-interface-for-blockchain.html



seems like code stopped working because of too many inputs in blockchain??

got this error code on linux:

Processed block #300000 of 327276 total.
blockchain.out: BlockChain.cpp:2932: TransactionOutput* BitcoinTransactionFactory::getOutputs(uint32_t): Assertion `(mTotalOutputCount+count) < 100000000' failed.
Aborted (core dumped)
micax1
Hero Member
*****
Offline Offline

Activity: 672
Merit: 500


View Profile
October 28, 2014, 01:24:39 PM
 #30

anybody here with knowledge of C++
please recompile:
https://code.google.com/p/blockchain/source/checkout

Thank you!
sologap
Full Member
***
Offline Offline

Activity: 210
Merit: 100



View Profile
March 29, 2015, 09:57:08 PM
 #31

any one got updated list ? im trying to run https://github.com/znort987/blockparser but im getting : Segmentation Fault

  ☠ CRAVEEmbraces the privacy movement ☠   
    Your Market. Your Blockchain Business. Your Profit.   
Har01d
Member
**
Offline Offline

Activity: 75
Merit: 10


View Profile
March 31, 2015, 02:06:34 AM
 #32

×

sologap
Full Member
***
Offline Offline

Activity: 210
Merit: 100



View Profile
March 31, 2015, 10:27:12 AM
 #33

Finally i got blockparser to work, anyone have this problem "Segmentation Fault" follow this to make a swap file: http://askubuntu.com/questions/178712/how-to-increase-swap-space

my box is 250 ssd, 16gb ram, 9GB Swap


Also here is all addresses list without balance as of block # 350544 (the size is 7mb 82mb compressed and 2GB+ extracted)

https://mega.co.nz/#!VNQmiSZL!Yfxt1Ga0t5SlCOoHtl6RVjne5i1ssiOvNXTlid9KAHo

https://mega.co.nz/#!0UpWCTxb!oIMkD8t4PK4iATuuj2TmMNhT4TXJn-pDcED1iyXBvAM

Tips: 1JJAN1ueth6r7UNai37jK5UR6esCL2SUxh



  ☠ CRAVEEmbraces the privacy movement ☠   
    Your Market. Your Blockchain Business. Your Profit.   
tupelo
Member
**
Offline Offline

Activity: 99
Merit: 10


View Profile
April 03, 2015, 11:13:44 AM
 #34

Are you sure that list is not somehow corrupted? For me it stops at line 503 and after that it's only endless lines of 'X's

Does somebody have an intact recent list off all addresses that they could share?
Thanks!
sologap
Full Member
***
Offline Offline

Activity: 210
Merit: 100



View Profile
April 03, 2015, 12:25:48 PM
 #35

Are you sure that list is not somehow corrupted? For me it stops at line 503 and after that it's only endless lines of 'X's

Does somebody have an intact recent list off all addresses that they could share?
Thanks!

oh, i actually couldn't check it because of the size  Shocked, i might forgot something. ill look into it and upload again. sorry about that

Edit: here is the full list with no problems https://mega.co.nz/#!0UpWCTxb!oIMkD8t4PK4iATuuj2TmMNhT4TXJn-pDcED1iyXBvAM

  ☠ CRAVEEmbraces the privacy movement ☠   
    Your Market. Your Blockchain Business. Your Profit.   
tupelo
Member
**
Offline Offline

Activity: 99
Merit: 10


View Profile
April 06, 2015, 03:09:56 PM
 #36

The new one works, thanks a bunch!
sotruxoid
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
April 12, 2015, 07:25:22 PM
 #37

I want to create a database with all the non-empty addresses, but for one particular day only. Any ideas?
Har01d
Member
**
Offline Offline

Activity: 75
Merit: 10


View Profile
April 12, 2015, 11:09:52 PM
 #38

sotruxoid, look at my offer in the post #32: https://bitcointalk.org/index.php?topic=267618.msg10936300#msg10936300
There is no problem to make a snapshot for the specific day.
For example, as for January 13, 2009 0:00 UTC, the list of addresses with the according balances would be the following:

Code:
1CYG7y3fukVLdobqgUtbknwWKUZ5p1HVmV;50.00000000
1Kj7zDjmTcjadztrU1LWT1erGuyToScwex;50.00000000
12bAezJkUhUxUDVZUypN9HP7obfWm58hSw;50.00000000
197x9cjGHGq9ah4AAwduRbu48J9PLiwcFD;50.00000000
1J9Wdx5F57jgNYSw7vaP3oCMWHnjaD3MEq;50.00000000
16bo8EmUnLJAmtDNavgcs1BQ5rU4YcR9UC;50.00000000
1D2zWLwXkdgFw5VtcYVtBhZuq5j4qwiRQP;50.00000000
1NZA1LZDbyeE9qdHWeJnN5DN7ZDJShsssU;50.00000000
19d4S14KCEDXi1Xyt9x98feD9SxWPXYYNm;50.00000000
1CbGkbGuvdoZGnywSfq6iV5MBQuaFQZfKb;50.00000000
1Bw7RG9a19SjCNszmXQZhBwe1gEj4Vb2JZ;50.00000000
16kktFTqsruEfPPphW4YgjktRF28iT8Dby;50.00000000
16cAVR3SQbNzu8KZtGdo8cG1iueWpcngxz;50.00000000
1HRGtCwm8vxA3GUobDLDGo7Wya6FXhwuDe;50.00000000
1LNKBdzwXmisa67qtYCofsZWwgZW2wewmn;50.00000000
1JNWvsrDf8mdH82Y7xp8yACDfm6TpVwZeM;50.00000000
1DcgZPFErBcASaPqsqyB42dUFjCJEro4A2;50.00000000
1NHHWnZKTetjZZfAbVjTS9EHQafdH6xn8a;50.00000000
1Fr947YZyEWZd2JPcvDJbsYN6Po5gXRyau;50.00000000
1FDMwEo8qNa9icVcooBUoGvA6NriePtJJ3;50.00000000
1K2UaAY9jfz7wUxadbD3ivBLGqrcF4ai8M;50.00000000
1Pqrx3NMF9VmMW6ikLZST3veBkUmY6be15;50.00000000
12c6DSiU4Rq3P4ZxziKxzrL5LmMBrzjrJX;50.00000000
1FvzCLoTPGANNjWoUo6jUGuAG3wg1w4YjR;50.00000000
1G5Gp7b1u5cTN5xjypETNpmCTpbDdoXJMA;50.00000000
13zrE76hjXh1wwtUFE6WsCbrG7NPWgRBVW;50.00000000
1Fdby4yp1iUnf8biiVAE14X4XKV6ZKzReR;50.00000000
1BW3idasrBsovBWDzauf1yTh6QWK9UUEj5;50.00000000
1SLkiCeQwBe56cvKMXmo8dYAe8SmjfrwX;50.00000000
1CRtj3XYXjtmHNw44QLZ63AGEM6SFa6wob;50.00000000
1Bhq4Uz1Cg8vZLWy5uT3X3Ea3XDSNvkvCM;50.00000000
18K6LJ9wFKSkYDA3dspswRPWiPgNZKvN7d;50.00000000
1HFtrEq1YGKxFKdq5nKyd7xm6NrAKcT7zf;50.00000000
184wTUutRt5geVhpCzhnp8vmKJWjUQGeah;50.00000000
1NEAg9cRUBUmTV8FG5ed33nPiXwEKaCxra;50.00000000
17uiEVD2d9U33YzfYJ2vZ9BrUhmMYVnK8M;50.00000000
18xzfpkj8cNz8NdmU7eumVjpeDfQSJ1CHR;50.00000000
192kkZSRQHrS4dnBoPGgoYB6WeC1HXyYZe;50.00000000
1AiE8NiskCXRovzHdVzAjydQ9V8Dv7Hiy8;50.00000000
1JhxuRHf7FiJYb8Ymc9czohwm9cJn2WaQW;50.00000000
1CQrDCsUkuvB5SUa9G2eAc8xqYZeK68x7j;50.00000000
1JfbZRwdDHKZmuiZgYArJZhcuuzuw2HuMu;50.00000000
1ArDoL42A6ZZdudpogut2NUGcwxhRj42S8;50.00000000
1281ZBYNe7qJGMsGgHL2YgUEEFwCdXQwBq;50.00000000
1Ky8dP7oR1cBeg1MzkrgHAeHAHyn92DCar;50.00000000
1FnbdYntfohuZ1EhZ7f9oiT2R5sDsZBohL;50.00000000
1ELLM7xHcUC1Z2BnDpGQ2Eg2ZXZeGSDkbU;50.00000000
1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa;50.00000000
19B32mm7b5x6HiBCRVpgQZUswbQ29b9YTo;50.00000000
1FERXfs9RYGhhLe2yBsSqYfSqtmUEBUSTc;50.00000000
1642o19pahkkdwHuPSx6uxk9HMmC243Bu7;50.00000000
1GkQmKAmHtNfnD3LHhTkewJxKHVSta4m2a;50.00000000
1dyoBoF5vDmPCxwSsUZbbYhA5qjAfBTx9;50.00000000
1MBvf6WPKwekXLRxsjjudqUXWJDYUy4qzB;50.00000000
135uQWV3vn5JNgQrWcLd6gWr9S2ybj2BB7;50.00000000
1PwcmHdjVFfQgXpd6V4BGzRY7yLBvGb4eK;50.00000000
1DQCdPGY1MUFwPdJ2bNziT4RfDFusBddyS;50.00000000
1PNF7mJ2VrgZCMSfUjiWxDteNBHEm15kMg;50.00000000
1G43MvhzCqRz1ctsQUmgU4LgLuSVdfU557;50.00000000
1JXLFv719ec3bzTXaSq7vqRFS634LErtJu;50.00000000
1DRzyGtGkXYnFz9n9qxnTFbGpYBv4FNmYM;50.00000000
1PSSGeFHDnKNxiEyFrD1wcEaHr9hrQDDWc;50.00000000
1ExG3uFvQJ12uXotnp78enyMZbfEizWzRn;50.00000000
1JKb22MuD4BhZMru2jpdpy8iRATyEDpy33;50.00000000
14pBXdFvEaPy6t4gbnrrQWu86ZYPTivEx3;50.00000000
16NEqTQenDpSAn18utw6sYD631Cq9znZf7;50.00000000
1GB9LgiyE6Upg2qbVGy2phKfgVZB681WhC;50.00000000
1G6RMmurphMJg6wyobQSzC2az9zZ3VipXE;50.00000000
14fKXAX9CFFGVE2txHtTbLX5owb6x9dYh3;50.00000000
1AiBYt8XbsdyPAELFpcSwRpu45eb2bArMf;50.00000000
1FeGetWU2tR2QSrxnpRwHGXGcxzhN6zQza;50.00000000
1KmbQCNdfCDkEB6yWw5iLjBTGJ5MYptqAL;50.00000000
1N8SwzBqNQccJQBMsVe5ukvSVhf6vxHVSm;50.00000000
16DvfwUBRqaZGaMWnzSnX8TPUantMKXhjV;50.00000000
1UZhhzWo85osGzNrs1BVjoE3FP8ea2umX;50.00000000
13A1W4jLPP75pzvn2qJ5KyyqG3qPSpb9jM;50.00000000
19knNYsDH25AsBGhhoaxnmUKrn9WkVMSUi;50.00000000
1HPgEWbEzFC6FWbcEJtasvZBaW5YTdmfMC;50.00000000
13aK6boaLbWkyLsDBmNZnUGhzh4iL2vQky;50.00000000
1Hr9AYxjsDUTuq8d1c6tCbVpYWBCvHUupm;50.00000000
1B1urSvRRSFjupa5THHsF8FNxTarDVexYg;50.00000000
1CT9huFgxMFveRvzZ7zPPJNoaMm2Fo64VH;50.00000000
1Kc4RPywLu8bK7JvTQJY1MWHo1S4jqQfzM;50.00000000
1AUyVCU1zU8YcfH8FHeJHREzSsE7ZHqgVN;50.00000000
1JRiK5gbEjTEAdFU2kYoQJRCMZgVCQgbpQ;50.00000000
13F1h7nLa4bgwgvjnRnBYh5cn1kpT4Mo2p;50.00000000
1Cef65T8Cqi47KJvc4vYkxuZ9ymBxQfhQf;50.00000000
1GnYgH4V4kHdYEdHwAczRHXwqxdY7xars1;50.00000000
1Pudc88gyFynBVZccRJeYyEV7ZnjfXnfKn;50.00000000
17abzUBJr7cnqfnxnmznn8W38s9f9EoXiq;50.00000000
15ubicBBWFnvoZLT7GiU2qxjRaKJPdkDMG;50.00000000
1DMGtVnRrgZaji7C9noZS3a1QtoaAN2uRG;50.00000000
15kHBARv1ZaCrmyExVUn6Uh7wnJVXveF8A;50.00000000
1HL3xqCGJwCcME5wgjz1NJLj5o79zp3W7y;50.00000000
1PmhUgoVLtTgdcvfi1cwwSTvPvFC67bCQs;50.00000000
1yNErqkG6GFaQTkRjrp38nqpVFn7QJnhV;50.00000000
1Bjrramo5EisLKeUXjw9GcUcfXcVnpi6vK;50.00000000
1GpHVwFv8Qnxov68HxZwdfvMDtEaYucGcR;50.00000000
1ax2fn3tdpH1R3A2yNFtp8Fn7Z7rt9DnY;50.00000000
1GPhCZpM72YrpkZVqQECpT6eKprKFEwkSH;50.00000000
1T2TbagADcZFN433zk1HjYuTiXTPs62Yd;50.00000000
1FdgjwkXbQc1gpHjpHyZNY85vdyQyFfBbg;50.00000000
1QEDtTS36hrcJuv6SvhqoUvVrfMLdkaN7C;50.00000000
1MTKWKTfG1Gxc1sH955eob7kp5cQ3CcexB;50.00000000
1AQ2m6GH78oLgZYCdueUb4Zjxg1L6BkHZM;50.00000000
17xQEk6df1Zyzvzs3oLPU9k5BZ85uGxC19;50.00000000
1H2nuVj2EnEVoYSw3opGjVxJdDqnehiYWN;50.00000000
1HLoD9E4SDFFPDiYfNYnkBLQ85Y51J3Zb1;50.00000000
15yN7NPEpu82sHhB6TzCW5z5aXoamiKeGy;50.00000000
1DnzNm7QC479kSydvzmgb16X2c5GwRVzs1;50.00000000
13QWmek3hEUhhcXL6PkyaQvW8cYuZwGFpM;50.00000000
1Bq1TLyuvZLvu73eueduUMhBL2QfYDeoNt;50.00000000
1BF5nbuKF3UTYCQTpxuH62UA8WJWAqQKo5;50.00000000
1BTsxjF9rXtFvUZ2UFditbeUpohGgKCxUt;50.00000000
14U5EYTN54agAngQu92D9gESvHYfKw8EqA;50.00000000
18xph1cecYkJwD81bHSKZ3SrUsPqinU2bA;50.00000000
1GPrHBrbFjzGVTwA4P4y5QnaDhd3GCYU5x;50.00000000
1KzvBTUbdwNBXiTkzr1msFUtPf7Vu2zLiu;50.00000000
1DmJE9Z1Teye3JmxhoDUcmnMmubCg8dNtF;50.00000000
1H4Urq49poTRfszssMDT12dMnoDxSBEs7e;50.00000000
1P8BjGr7JG8zfDTZBE4Kat2KthsDJ9xg5e;50.00000000
1P9VmZogiic8d5ZUVZofrdtzXgtpbG9fop;50.00000000
1DEwdHYmo8q6AhSHG7UgxEjttNMFdw9e7u;50.00000000
1J6PYEzr4CUoGbnXrELyHszoTSz3wCsCaj;50.00000000
1PN2MiaGhnR65x41pbUWbsfCB62hqG8KSG;50.00000000
14w8FgPQhPRuP4wnVpER9p9Cb7kYQWkzwY;50.00000000
1Dk9PekCU6BkLy5pRHfWvSw791BiVdKBXj;50.00000000
1KyUEsMMKw6MNW8RZKehJpyKNyS8ZmXerX;50.00000000
18GyZ216oMhpCbZ7JkKZyT8x68v2a8HuNA;50.00000000
1AqC4PhwYf7QAyGBhThcyQCKHJyyyLyAwc;50.00000000
1PZnnfPq3EpcGZZyiX8WCbEhm9amzpjTYr;50.00000000
1DJkjSqW9cX9XWdU71WX3Aw6s6Mk4C3TtN;50.00000000
1Fi7o3BKMcT82NVtnMRNqsj8aE5CWbAo4z;50.00000000
12jiJuWynwFcqbNyoay5Sy9pmJn9dsFRgh;50.00000000
1CbjjM7LDBvmtdvyyZbbb8hp3B8gwUEaio;50.00000000
1PQhPpysTvkYRpjpHL48KuQTRW7yS2k9Hx;50.00000000
1HwmP33SaknLYShXfjVU8KmVThU3JiuVgH;50.00000000
12wm668ySFxjAPGnZHPBR4uWqUmNdXg2kP;50.00000000
1EPeRrfFgn8Dm7mbfaFHUNUpD5UnKkeSNQ;50.00000000
1Mdioqy6kR75YvHhf7eqhTsRxoYfQfhbgn;50.00000000
16jZuw5nwn3ZgzWYrRvhi8NZW2b1NRk6S7;50.00000000
1Lh4fvU1NAEdZTuTqoe4c3cPMv3sgkFWbM;50.00000000
1NZz1UN616LfyX87zGRnVifiWRSN5xm9ht;50.00000000
15HWA4SmQ9zm9iYGyxPK7r1oDugPXeWwDk;50.00000000
12RyzPinkywNAN1L78tpBS14QTFQCBhuLE;50.00000000
1LKriCmDaBz4SfCoDjcjR1b9CmQTHibCcr;50.00000000
1nQ5KafzA4DWGa327n8JnZ29q4PKg5Y7m;50.00000000
17iyRRXBHJKbv5DKPPkttWewm3CHdNPGQd;50.00000000
16hWr6twFK4Rt5tAJmoqDeSVQsxZ1tFuJa;50.00000000
17KG5gGwKu1DNNaMdrngw3UdZUh4ZhacNT;50.00000000
1HWP2q1RjpRbjm2K5ZPFnnfbnpNjN7XJWj;50.00000000
1EDV8iD4cDZbKxZu6UGAPW5i2ytQmR5xoQ;50.00000000
1PHB5i7JMEZCKvcjYSQXPbi5oSK8DoJucS;50.00000000
1PeWcJrkpHMnUs3t5GvuwcHh1oBHYNoDwG;50.00000000
15ubjFzmWVvj3TqcpJ1bSsb8joJ6gF6dZa;50.00000000
1JSW4QekxPokWWU4hcRwrheZbZKSkFz9oc;50.00000000
1Jd2omwPAZq3egSS8HsxFMxhWmKdonG9Lz;50.00000000
1MVXEbi7xErjRaszVDwycUbeR8dYBVNKnE;50.00000000
1ALp4qPqGju9gmupfdRwAEyREN38Uqipyv;50.00000000
12vhcB2bfspTua6XLpLcZPP4zpkudmw2re;50.00000000
1DpSDwF12wX5ogkS2HXabT7iWtCkAqJD9k;50.00000000
1KMYVBvfMAUZH4gpRknxvKxbqATMAfuu4x;50.00000000
12XPHPCGYz1WgRhquiAfVeAyjZ7Gbdpih3;50.00000000
1HRRURSfxj8NntfzcPT4ajz7uBefLuwLmB;50.00000000
1PA4XBfKLjACMQUUupBEDzwhSsLRKriAkr;50.00000000
1PWPk2buWhozxYUE3vnb7MnobjCMkEmagU;50.00000000
14kbZs9yn2k5r6R5Tkf6gDKp3b3MDu1eGk;50.00000000
1QHTV856dWWwzSQN738tvEneYgsagQdYpM;50.00000000
12zBX15JrZjgxLkvr3rVUcVcD6323rZ3bY;50.00000000
1KuX1qeF7qimFiurBDxQUktAgNE3qNA8zx;50.00000000
15z1nJqsrAUchqwQ4hsWnyPru2nUjuuDhR;50.00000000
12dRaqF6c7n8rvbhCWsQysKmNKPgDJfepK;50.00000000
1FWcb8Ddw3BXearNaWugikvEfK7gViRde7;50.00000000
1Dw5XyQk2pFDNLQUsc2Eknq5ikQAwfRqsR;50.00000000
1AL11Yfw2ZP9C4wGiWf99jwZyTjWWY4JVn;50.00000000
13t2rxB1FiZ8rSR3jVVNAmJN7hxFCq6pjp;50.00000000
1FUgiNk7jjSeNaA3KCoYmdXdhcd7CWrjGh;50.00000000
1BEKzoSq5kTRNhL9ezh8KJ5vt2NzigQV2K;50.00000000
136g5f3pBidF6q8udL5GGb66CzG7AzBNwv;50.00000000
13iDhZNq6ejzR4GcRZo8F9A9oYR4GgXV3q;50.00000000
1MF2sw6Zan5p4ViuGdxRoNr48M5rFvHkqn;50.00000000
1LNV5xnjneJwXc6jN8X2co586gjiSz6asS;50.00000000
16LoW7y83wtawMg5XmT4M3Q7EdjjUmenjM;50.00000000
18p2otBZ33Ytgk3afUrHsmiPrFLNPiM4G5;50.00000000
1917k1LUodPbbjJenczkVaGyJpSj8CqYTC;50.00000000
1AxA6X2FSY5NSZzWS25RXA7j6uhTGEZ9eD;50.00000000
1F22VKzwQWf2LoSziz78Zc5e7owfrHDRCy;50.00000000
14UyXKWBcVHYcqSpxYcmR9JLZu6pArwDrd;50.00000000
1HCeeU957J4NTXDer2fGvDsb7mVjU9TtLb;50.00000000
1NG4uecvtRyRx9eWxUaw6PVLPKMfDE7nz4;50.00000000
1BwV17G9AyRuPocPeonRTx7VdCAXga43rn;50.00000000
13kjsBfe8D7bwmT938DxCLHzjvae6uvHPg;50.00000000
1HjE5zRg4eYm7jCHB9oSH5WbyZdH1GE2Ns;50.00000000
1BQRxmgPsyWWv6GD64kUDxtNq3K2RGc9KL;50.00000000
1KSHc1tmsUhS9f1TD6RHR8Kmwg9Zv8WhCt;50.00000000
1BnhHuk62o9tPuG5JerexTX3MhnR8sobLm;50.00000000
12ti6ZDtjJTFnfSXJD1yZeojFdc1u4nJcS;50.00000000
1N24Lobvo9BN4iGrm4SRhCUwpwd273dSfq;50.00000000
1DecGxfc8DuoLjV75WdNE7BfjVRGE5ACqi;50.00000000
15eCuQ4Kd25VDhtv9Pko6DL3tt1ACa3tR8;50.00000000
16RGBFEHfNqjzN6UQ95imqtM91PBcQUMCF;50.00000000
1NnYa2jL24hLgXBbk3TAXHANUQEzXNnSHg;50.00000000
1h2Znru8Y624tuVnu1UgUujNACTzaFABz;50.00000000
1MBTMZxy2g1shi2Sx37AwGpo6o5if7iq5F;50.00000000
1PHG1AoZJ5yyg6MV2fkqYCuDDik2NTfzfm;50.00000000
19K4cNVYVyNiwZ5xkzjW9ZtMb8XvBS2LkT;50.00000000
19PVrVqTjMaAUXxNZKytffiebVM9U1S9Dy;50.00000000
1AUR9CVmm5wH8xc2EufyDpuA8HEZcSamhY;50.00000000
135S6YvALYCydS6R82hWi967f3xUnWVQ3S;50.00000000
1PpU2yx6CSruakyYjckH8eUJWAH1XUQ7ZM;50.00000000
1H5canZg3AwU44Fe65HG2siti9mFJnkc8;50.00000000
13ph5zPCBLeZcPph9FBZKeeyDjvU2tvcMY;50.00000000
176n9Cx6LKri6YUxFNBr7aUzb2TbLzJbsM;50.00000000
1FyiELmwtmD2mrN6hRzw6P76zLg3WJoCwB;50.00000000
1DLfzP5v2KegZK88rsNj8z1YKSb4VzBfsu;50.00000000
13pS5WuihmpE7WMQAZkFdvfvVo1NDp7R7V;50.00000000
1J9HkGKPDd7ek9DA1V4NDEma1F1h7vHi8u;50.00000000
17x23dNjXJLzGMev6R63uyRhMWP1VHawKc;50.00000000
1DmKBaveG8iQA7nTGpRQ1bf8cJ7zqSMCjJ;50.00000000
16kf2cAY8V7iZjX21Pm8znMJxqa2TYcqQ5;50.00000000
1MNHWu6JeCrtFyjEPcR6bJSrfQ3kJ3Hyin;50.00000000
1LPBetDzQ3cYwqQepg4teFwR7FnR1TkMCM;50.00000000
1FaUNstQc4FUena9XodmbfHgoMD9yKpT4d;50.00000000
17B3kpD6d9SSaoKATBgGqDn25dFnSvjcVE;50.00000000
128KyT3PMB3WLcZVu48asfaTwtb6tZE2dm;50.00000000
17uWtnxcJdpH7pEXXmr1SLrohVxe18B3fD;50.00000000
1KDnp5D9sEUNGFY2z4JiKhwfbm7zqYp4Bz;50.00000000
1H5BMx61bxfseTU9jUPZgit5B9D3AVviX5;50.00000000
1MMFzwh3r5fxNwpTZvm6iZReX7RUwZxnaY;50.00000000
1PAL9ZNuwAcufS8xSnGMCpQqECFF9g9QN1;50.00000000
1PYELM7jXHy5HhatbXGXfRpGrgMMxmpobu;50.00000000
18a3JX7ZZvu5CdaqY33RxzXB3ytEjspsGq;50.00000000
1B7CyZF8e6TYzhNBSHy8yYuTRJNpMtNChg;50.00000000
1JgpRwCt8rm29g3y4FkVKWWck8qEeKgfZv;50.00000000
1CwoMxSXitseAKdNgfaHtzaUB7mUhcrmMp;50.00000000
1F7RYd4KM2AesmFx83JYgLKibYrfxcWYaV;50.00000000
133xmQyVGHnyQwr2pYNiHUMeDUS3mYVsB7;50.00000000
1AQgsAVd49Tk9kxgsdDRFMwLjyD997p6dJ;50.00000000
1N8Q8bSJPLkoZUkdREsQA1dGsHTPrQ9X3j;50.00000000
1MUuVeuS6DDS5QKR2BNZ9fipXCEsFujaMH;50.00000000
1CtABfwubzxuoHacNEZ6FJCBumtTbz71AA;50.00000000
1Fr33GRhy7zN8eXkWDf31icUBRUmoicnJz;50.00000000
1PLgv319qXvnmiCAL3pH1dydVQSwrr2F5W;50.00000000
1MKRkcXG7cUb83EGNjK5TSHcKgVjVMTou5;50.00000000
1Po1b27dVXkmyQdKXk5AvHUzdgEk5MvMvC;50.00000000
1FhKNo8JmNrPKnqJv5rTFMrw98H7soXTXu;50.00000000
19CAnt15TpQrJ9gjmdZZsLcwRj8E1mkqPP;50.00000000
19X7soRFwUCRX8aUc3NrRZddHgpLmFmpzc;50.00000000
1EvRbs7Fc6R6V8LsnoD3Ntng9vWfmreeRT;50.00000000
1B4HeenWZfzcyHSpHeZGQZtSVUi18wmd2B;50.00000000
1M7U7kbW9CY7znW6sSRzycgPCxr5LkJy2r;50.00000000
1Eof6XM7AKnBdpTt3c92sVb1LaLqH3cnqC;50.00000000
15VF3MsCzjHmFQ3wK3SMrTEBTmFY8zhJnU;50.00000000
1DpJP16GXSht3hJ5DZDumKcwAFqQQVkffN;50.00000000
1BwWdLV5wbnZvSYfNA8zaEMqEDDjvA99wX;50.00000000
18NmcVxBKf5tZXuV5KijPTgbdguGohnBCV;50.00000000
15WV17J7pbDKdZ6eeGBg5yZ9jb26TaW8GB;50.00000000
12GBk2eiu3AEVvNYTwWYnUz49ecRjJ1CR6;50.00000000
1HgeuTkMfQ3xh6hPo9ZZKvHom8AAXdfA4X;50.00000000
1NHVxANujgiDvPxNLQ1cc5B8AEisnx2Yz6;50.00000000
15EMUiFD7XoHpzCA4sErNmqCT4krsQzgKx;50.00000000
13CiNuEMKASJBvGdupqaoRs2MqDNhAqmce;50.00000000
12cbQLTFMXRnSzktFkuoG3eHoMeFtpTu3S;18.00000000
1DUDsfc23Dv9sPMEk5RsrtfzCw5ofi5sVW;10.00000000
1ByLSV2gLRcuqUmfdYcpPQH8Npm8cccsFg;10.00000000 <-- NB
1Q2TWHE3GMdB6BZKafqwxXtWAWgFt5Jvm3;10.00000000
15NUwyBYrZcnUgTagsm1A7M2yL2GntpuaZ;1.00000000
1BDvQZjaAJH4ecZ8aL3fYgTi7rnn3o2thE;1.00000000

For example take a look at https://blockchain.info/address/1ByLSV2gLRcuqUmfdYcpPQH8Npm8cccsFg
It is in the list with the balance of 10 BTC, however its current balance is zero, because the money were spent at January, 14.

If you want to develop your own solution, the only way to do it is to parse all the blocks which were mined before the specified day.

raydan
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
April 23, 2015, 10:38:45 AM
 #39

Are you sure that list is not somehow corrupted? For me it stops at line 503 and after that it's only endless lines of 'X's

Does somebody have an intact recent list off all addresses that they could share?
Thanks!

oh, i actually couldn't check it because of the size  Shocked, i might forgot something. ill look into it and upload again. sorry about that

Edit: here is the full list with no problems https://mega.co.nz/#!0UpWCTxb!oIMkD8t4PK4iATuuj2TmMNhT4TXJn-pDcED1iyXBvAM

at line 3000004 it's only endless lines of 'X's
ChetnotAtkins
Full Member
***
Offline Offline

Activity: 131
Merit: 100


View Profile
May 12, 2015, 07:42:46 PM
 #40

Sologap's list is great, very interesting information, but already outdated

Does someone have a current list?
Thanks!
virtualx
Hero Member
*****
Offline Offline

Activity: 644
Merit: 500



View Profile
May 13, 2015, 08:46:10 AM
 #41

I use znort987/blockparser in ubtunu/debian

Code:

sudo apt-get install libssl-dev build-essential g++-4.4 libboost-all-dev libsparsehash-dev git-core perl

git clone https://github.com/znort987/blockparser

cd blockparser

make

./parser allBalances >manygigs.txt


This does get ALL balances.  Anyone know how to tweak this?

I think you can combine it with grep, this might do:
Code:
grep '50.00000000' manygigs.txt > result.txt

If it does not work, the only method is to modify the code of the blockchain parser which should not be hard to do. Simply iterate all transactions in the blockchain and save those that meet the required conditions. Smiley

Bitcoin_BOy$
Hero Member
*****
Offline Offline

Activity: 742
Merit: 500

|| Web developer ||


View Profile
May 14, 2015, 03:40:49 PM
 #42

Hello , For me I'm a programmer and I can create functions in Php that check address balance
but if you are checking a hazard address that you generate from Python scripts ...
I will say please don't waste your time (Already tested and hated my self after it  Grin) .

Bitcoin Boy.
ChetnotAtkins
Full Member
***
Offline Offline

Activity: 131
Merit: 100


View Profile
May 18, 2015, 10:16:00 PM
 #43

Does someone have a current list of all addresses with a Balance (over x) ?

Thanks
Bitcoin_BOy$
Hero Member
*****
Offline Offline

Activity: 742
Merit: 500

|| Web developer ||


View Profile
May 18, 2015, 11:42:26 PM
 #44

Over a year ago I actually started importing the blockchain and doing just that, but it requires the full blockchain imported into MySQL or your preferred database.

Interested in doing this too. Found this to import blockchain into MongoDB: https://github.com/thelinuxkid/bitcoinquery
Hi , this can be better to check the balance and you won't have to use an api that may ask
for captcha a time to time . But I would like to know for what will this be useful  Huh
I think you can just add your private keys to a wallet like Multi bit and get it ordered
by balance and we are done !

Bitcoin Boy .
tupelo
Member
**
Offline Offline

Activity: 99
Merit: 10


View Profile
May 27, 2015, 09:06:45 AM
 #45

I would also be interested in an up-to-date list of all addresses with balance. No sites I have found provide this service.

Could anybody please post the current list? Thanks!
tupelo
Member
**
Offline Offline

Activity: 99
Merit: 10


View Profile
June 02, 2015, 10:25:34 AM
 #46

bump

Anyone?
Muhammed Zakir
Hero Member
*****
Offline Offline

Activity: 560
Merit: 504


I prefer Zakir over Muhammed when mentioning me!


View Profile WWW
June 02, 2015, 03:34:38 PM
 #47

Hope any of these helps you.

 • https://bitcointalk.org/index.php?topic=959897.msg10500979#msg10500979
 • https://github.com/znort987/blockparser
 • https://bitcointalk.org/index.php?topic=762445.0;all

tupelo
Member
**
Offline Offline

Activity: 99
Merit: 10


View Profile
June 02, 2015, 06:28:48 PM
 #48

Thanks but unfortunately I don't have a local copy of the blockchain. That is why I was hoping a benevolent person like Sologap could post an up-to-date list of addresses with balance. I think such a list would be very useful to a lot of people and I wonder why no blockexplorer provides this service.
fronti
Legendary
*
Offline Offline

Activity: 2016
Merit: 1030



View Profile
June 02, 2015, 07:00:58 PM
 #49

I think most people have now idea why such a list may be usefull.
What do you want for a service?
type in a number of value and see on which position this is?
Or what is your intention?
in which format do you need the list?

look this torrent:
 btc-address-balance-2015-06-02.txt.torrent


If you like to give me a tip:  bc1q8ht32j5hj42us5qfptvu08ug9zeqgvxuhwznzk

"Bankraub ist eine Unternehmung von Dilettanten. Wahre Profis gründen eine Bank." Bertolt Brecht
teukon
Legendary
*
Offline Offline

Activity: 1246
Merit: 1000



View Profile
June 02, 2015, 11:44:50 PM
 #50

I think most people have now idea why such a list may be usefull.
What do you want for a service?
type in a number of value and see on which position this is?
Or what is your intention?
in which format do you need the list?

look this torrent:
 btc-address-balance-2015-06-02.txt.torrent

My guess is curiosity about ranking.  In which case http://ondn.net:800/search would probably do the job.

I wonder what other uses such a complete list would have.
tupelo
Member
**
Offline Offline

Activity: 99
Merit: 10


View Profile
June 03, 2015, 07:25:29 PM
 #51

I am interested in the distribution and want to make graphs for myself.

@fronti: I cannot find that torrent Sad , could you check if it is still available? thanks!

@teukon: thanks that site is also useful
vrzo
Member
**
Offline Offline

Activity: 90
Merit: 10


View Profile
June 13, 2015, 07:11:59 PM
 #52

What is the most recent number of bitcoin addresses with non-zero balance?

EDIT: I found it: 5.03M
ChetnotAtkins
Full Member
***
Offline Offline

Activity: 131
Merit: 100


View Profile
June 15, 2015, 06:27:08 PM
 #53

So does anybody have a current list of addresses with balance? I too could not find the torrent fronti was referring to
maheshmahi
Jr. Member
*
Offline Offline

Activity: 56
Merit: 0


View Profile
June 25, 2015, 02:59:22 PM
 #54

But the resulting file may be upto 3 gb

Crypto-Games - DICE (0.8% house edge) and SLOT for BTC, LTC, DOGE and more (https://www.crypto-games.net/)
samsads
Jr. Member
*
Offline Offline

Activity: 51
Merit: 0


View Profile
December 04, 2015, 01:28:17 PM
 #55

Are you sure that list is not somehow corrupted? For me it stops at line 503 and after that it's only endless lines of 'X's

Does somebody have an intact recent list off all addresses that they could share?
Thanks!

oh, i actually couldn't check it because of the size  Shocked, i might forgot something. ill look into it and upload again. sorry about that

Edit: here is the full list with no problems https://mega.co.nz/#!0UpWCTxb!oIMkD8t4PK4iATuuj2TmMNhT4TXJn-pDcED1iyXBvAM


after 3000000 addresses its only XXXXXXXXXXXX Huh Huh

Please can someone share the updated list.

Will be very much thankful.

Or atleast tell me a way to get all addresses without downloading the whole blockchain

Plz help... I am new to this..
mocacinno
Legendary
*
Offline Offline

Activity: 1260
Merit: 1102


http://www.mocacinno.com


View Profile WWW
December 04, 2015, 01:40:21 PM
 #56

Are you sure that list is not somehow corrupted? For me it stops at line 503 and after that it's only endless lines of 'X's

Does somebody have an intact recent list off all addresses that they could share?
Thanks!

oh, i actually couldn't check it because of the size  Shocked, i might forgot something. ill look into it and upload again. sorry about that

Edit: here is the full list with no problems https://mega.co.nz/#!0UpWCTxb!oIMkD8t4PK4iATuuj2TmMNhT4TXJn-pDcED1iyXBvAM


after 3000000 addresses its only XXXXXXXXXXXX Huh Huh

Please can someone share the updated list.

Will be very much thankful.

Or atleast tell me a way to get all addresses without downloading the whole blockchain

Plz help... I am new to this..

I can try to do this for you... But since it'll take a lot of time and recources, i'm not doing this for free Wink

amaclin
Legendary
*
Offline Offline

Activity: 1260
Merit: 1000


View Profile
December 04, 2015, 01:53:14 PM
 #57

But the resulting file may be upto 3 gb
I have such list for regular (not p2sh addresses) with balances
There are ~5700000 addresses there
And the size of file is 288mb
samsads
Jr. Member
*
Offline Offline

Activity: 51
Merit: 0


View Profile
December 04, 2015, 01:57:49 PM
 #58

But the resulting file may be upto 3 gb
I have such list for regular (not p2sh addresses) with balances
There are ~5700000 addresses there
And the size of file is 288mb

compressed size 288mb??

will you plz share???
amaclin
Legendary
*
Offline Offline

Activity: 1260
Merit: 1000


View Profile
December 04, 2015, 02:04:20 PM
 #59

compressed size 288mb??
will you plz share???
uncompressed. not for free
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
February 20, 2016, 12:44:07 AM
 #60

I have an new address list with balance:
http://rs.keinbrot.com/balances398037.txt


If you like it, plz spend me some beer, cost me lot of brain and cpu time:
1F55vXEqYCq3pnLVe2JTJUXGGRmYgkKxW5

List is ordered by used time to block 398037.
Format: "PublicKey;BalanceInSatoshi"

Already a new:
http://rs.keinbrot.com/balances399271.txt

For futher updates: contact me Wink
manifold
Jr. Member
*
Offline Offline

Activity: 62
Merit: 0


View Profile
March 28, 2016, 05:07:36 PM
 #61

Already a new:
http://rs.keinbrot.com/balances399271.txt

For futher updates: contact me Wink
Thanks so much!!!

 Osiris Bitcoin Forum (http://goo.gl/9U0J6)
This is a recursive text, if you restart reading from the beginning. And you will never get to this point informing you that it had no exit condition.
gortva
Newbie
*
Offline Offline

Activity: 23
Merit: 0


View Profile
May 23, 2016, 01:14:03 PM
 #62

Do somebody have a fresh list?
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
May 25, 2016, 01:15:39 PM
 #63

Do somebody have a fresh list?

Send you a PM
splooge2
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
June 07, 2016, 10:45:03 AM
 #64

can someone post a link to the new list?
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
June 14, 2016, 08:53:38 PM
 #65

can someone post a link to the new list?

For a beer you will get a fresh one Wink
rud3boy
Newbie
*
Offline Offline

Activity: 22
Merit: 0


View Profile
June 28, 2016, 09:02:48 AM
 #66

can someone post a link to the new list?

For a beer you will get a fresh one Wink

Can you post one pls. Wink
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
June 28, 2016, 05:13:53 PM
 #67

can someone post a link to the new list?

For a beer you will get a fresh one Wink

Can you post one pls. Wink


http://ethteam.com/download/balances413127.zip
indexapks
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile WWW
June 29, 2016, 04:08:38 AM
 #68

Very nice bro this is thanks for share it. i have problem to post new thread can i any one help me.
https://2.bp.blogspot.com/-t6sfyTKh7G0/V0vDr6urGrI/AAAAAAAABIE/JKJ9SWS-HEgYoCI7fB5s1lS-5OJU-KZswCLcB/s1600/SnapSave-for-Snapchat-Android.png

http://www.apkhost.net
rud3boy
Newbie
*
Offline Offline

Activity: 22
Merit: 0


View Profile
June 29, 2016, 09:00:09 AM
 #69


Great, Thanks alot!!!!
xcbtrader
Hero Member
*****
Offline Offline

Activity: 867
Merit: 1006


View Profile
June 30, 2016, 09:52:40 AM
 #70


Great Job!!!
Thanks

dream46go
Jr. Member
*
Offline Offline

Activity: 60
Merit: 0


View Profile
July 04, 2016, 08:39:59 PM
 #71

....Why a list may be usefull?
A new service?
 Huh Huh Huh Huh Huh Huh Huh Huh Huh
Ned Kelly
Full Member
***
Offline Offline

Activity: 165
Merit: 100


View Profile
July 06, 2016, 03:39:26 PM
 #72

....Why a list may be usefull?
A new service?
 Huh Huh Huh Huh Huh Huh Huh Huh Huh

You can keep eye on Satoshi's coins movement, or any substantial holdings of "zombie" coins in general.
And if would be movement of those coins, it can have some impact on BTC price.Smiley
But I think you have to do it in real time.
dream46go
Jr. Member
*
Offline Offline

Activity: 60
Merit: 0


View Profile
July 07, 2016, 06:10:23 PM
 #73

....another service......?
dream46go
Jr. Member
*
Offline Offline

Activity: 60
Merit: 0


View Profile
July 16, 2016, 04:12:27 PM
 #74

scan btc, select into a db ... Huh
Windpower
Hero Member
*****
Offline Offline

Activity: 532
Merit: 500


Need a Campaign Manager? Send me a PM


View Profile
July 18, 2016, 11:29:48 AM
 #75

....Why a list may be usefull?
A new service?
 Huh Huh Huh Huh Huh Huh Huh Huh Huh

You can keep eye on Satoshi's coins movement, or any substantial holdings of "zombie" coins in general.
And if would be movement of those coins, it can have some impact on BTC price.Smiley
But I think you have to do it in real time.


Or you could be randomly generating private keys, and hoping to find one that corresponds to an address on that list. Not that hard, just need the compute power and a crap ton of luck.

    ▄██████████████████▄▄
  ▄█████████████████████▄▀▄
▄█████████████████████▄▀▄▀▄▀
███████▀             ▀▄▀▄▀▄▀
███████▄
▀███████████████████▀▄▀▄
  ▀█████████████████▀▄▀▄▀▄
    ▀▀████████████▀▄▀▄▀▄▀▄▀▄
                    ▀▄▀▄▀▄▀▄
▀▄▀▄▀▄▀            ▄▀▄▀▄▀▄▀▄
▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄
  ▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀
    ▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀▄▀
Solar DAO████  ████  ████
████  ████  ████
▄▄▄▄  ▄▄▄▄  ▄▄▄▄
████  ████  ████
▀▀▀▀  ▀▀▀▀  ▀▀▀▀
████  ████  ████
████  ████  ████
▄▄▄▄  ▄▄▄▄  ▄▄▄▄
████  ████  ████
▀▀▀▀  ▀▀▀▀  ▀▀▀▀
████  ████  ████
████  ████  ████
..PV Solar Plants Construction..
    through CROWDFUNDING
████  ████  ████
████  ████  ████
▄▄▄▄  ▄▄▄▄  ▄▄▄▄
████  ████  ████
▀▀▀▀  ▀▀▀▀  ▀▀▀▀
████  ████  ████
████  ████  ████
▄▄▄▄  ▄▄▄▄  ▄▄▄▄
████  ████  ████
▀▀▀▀  ▀▀▀▀  ▀▀▀▀
████  ████  ████
████  ████  ████
████  ████  ████
████  ████  ████
▄▄▄▄  ▄▄▄▄  ▄▄▄▄
████  ████  ████
▀▀▀▀  ▀▀▀▀  ▀▀▀▀
████  ████  ████
████  ████  ████
▄▄▄▄  ▄▄▄▄  ▄▄▄▄
████  ████  ████
▀▀▀▀  ▀▀▀▀  ▀▀▀▀
████  ████  ████
████  ████  ████
[/center]
dream46go
Jr. Member
*
Offline Offline

Activity: 60
Merit: 0


View Profile
July 19, 2016, 09:27:02 PM
 #76

very,very, ton of luck...
16^64 number of keys
I dont understand why? impossible....
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
July 30, 2016, 06:07:48 AM
 #77


Or you could be randomly generating private keys, and hoping to find one that corresponds to an address on that list. Not that hard, just need the compute power and a crap ton of luck.

Better create brainwallets from common passwords, sentences, .. and hope that there are bitcoins.

Tried it with the most common 16M passwords. In the past there were many bitcoins lying around ^^
But today they are all stolen/moved.
rico666
Legendary
*
Offline Offline

Activity: 966
Merit: 1013


฿ → ∞


View Profile WWW
July 31, 2016, 09:00:29 AM
 #78

very,very, ton of luck...
16^64 number of keys
I dont understand why? impossible....

 Roll Eyes

2^160 keys. See also this.

As for the list of balances: you can get an up-to-date list with all addresses that have at least 1 Satoshi on them (~9.2 mio adr) from me. Sorted from highest balance to smallest. So you can cut-off wherever you want. However not for free 0.01BTC - yes, I am that greedy. PM me if interested.

Rico

all non self-referential signatures except mine are lame ... oh wait ...   ·  LBC Thread (News)  ·  BURST Activities
dream46go
Jr. Member
*
Offline Offline

Activity: 60
Merit: 0


View Profile
August 01, 2016, 05:03:40 PM
 #79


Or you could be randomly generating private keys, and hoping to find one that corresponds to an address on that list. Not that hard, just need the compute power and a crap ton of luck.

Better create brainwallets from common passwords, sentences, .. and hope that there are bitcoins.

Tried it with the most common 16M passwords. In the past there were many bitcoins lying around ^^
But today they are all stolen/moved.
Example? Shocked Shocked Shocked
amaclin
Legendary
*
Offline Offline

Activity: 1260
Merit: 1000


View Profile
August 01, 2016, 06:16:03 PM
 #80

Example? Shocked Shocked Shocked

Code:
"5Jo3qrvsat3kEduGEt5HDtjNbjsa8Vexitnh5RcVpW3bLCuuN8K", "1KLdLFRvbxouJNFuRavWZmupxmjodSNA7V", "affricate"
"5Jkgm4yXJKt6iUKGCfHpgw1JMjPReamJvJhtcRG9x8BNC3s58i4", "1CAvkZWvmG9ydB7m66KM9BJFi6v1kefaKR", "affording"
"5J6mtfQFzYdMYLD2bjivYs25meCrhAoXtPhYWDV2Uutum5rjqPu", "1BLNNGVXzXPZtRz55SrvFJqud4xL8XFmfF", "affordable"
"5J7Gb8vjjzW25tqmCG26njkQ2fwSZ5SHQRAdxqcuBCBAJruhCCj", "17dL4QNs6iBUHFJ1eaCZ19uVF4aiKAs2GQ", "affluence"
"5JLxoQnovEQuvqbYpbjV1JwgNMcb4hXH2kg7KwzBmRGgRCwKKKY", "1ACy9tek6px8SqY5VP9Qov3rkdTaEys7CW", "afflictive"
"5Jiz1Wd6xVYHsyKn35o8Y9tyaBFcDBxPFC9jg1WKcMcdnimuEZh", "1MoFDaw1FsKNrYHh8zM3t9tTKmF66VhbLo", "afflictions"
"5JyjT3qp3Mf5Q4DHJSijZAcce9METFdALV6a5DQsarptCRYZCSx", "1Ed4mWcDPLTzXX4uMhSxENV5oAHaDcUir6", "affliction"
"5JxDLt2hBxCKE4XBg2iuttKohn3D3SBCCeUoTf8XEMUVekCoj5V", "12UcKekNo1eYX2hi6m5yeoBfAyYznBkq7B", "afflicting"
"5K46LHWh6CRVMpn6dCR3Q7JL8GyjujWQcfksb8A2vcrctj2xZeK", "1KCqLxbkbKeXy9ZK7hwtCtTV2LU4XK45wj", "afflicted"
"5KCzPrV6mofYkEQbxzsyKRUmkemLJnxw88vmYamdK4AZceSdT1Z", "1H81v5TGAWj1Ai3yryG4mBBjuFBSp2YFN3", "affirming"
"5K8UnLR74dScUpnig1aSkvRFkKoktp3zLndM5miTLHtbPeY8HLU", "16BsVdgcTGw8A8ymr7sHHVKkzgoTVUeVxQ", "affirmatively"
"5J3L7xefXfcG3DqgghzuRjC62W46UjH2A6MHPdCnMwd6wWd6z2X", "1Aq8rHXSqYUkTARqyLLKAjesoyqGus53hT", "affirmative"
"5JHxvtpaUMexxDUycLRUBeYDR9T6tHoGmdyqMJakLnsBngCNmmd", "18Bjb9CedPViYjHswPW2xBwkFd1BTnbC2t", "affirmations"
"5K5fH2bRSACCz9ttfVSHgMRn7muH7GwSST3zvQk1Ty3DDjnVaYZ", "18vbKoA7gmgVuhHsqA5zDo4cPHXXFy4QG8", "affirmation"
"5K4nCLKEp2gWMNGXrnLucpMnoa1qtLEGRgRDgK2JtdJePV8EysK", "1BhC3FHckEiJzux6zUp8gMWWT2YxZzoY9a", "affinities"
"5HyMT1mVSBgUQj9tQV2aQE3BciBpi8yv65kDLTZu9BxV5YZ4Sbm", "1FXoPz3bRSuXwiSejhXJF7N7ACy9zYMc1T", "affiliations"
"5HwJJxA383jSKFTpFh26v9ueiEWi6T39S1DgSk19gab7QAAcQtS", "1Boyefh7mj8CuEF9epZxPu4CTGC3ASLaV5", "affiliation"
"5JVPVDCLJxXaQhZxDRGD6qxmB4Yov2Z6BU6r4mSyw4eTDaYR24r", "1MhW6dZ93Y1n9qB18q2cLHqB6qXGzzANaX", "affiliating"
"5HzHqyyesnXBV3xsUcDJgRRfMM5wRwf1fwx2ZcBacMVucHbR6ZG", "12F257PY8kf1dZvuxkuR69BbDzzwC1yAUm", "affiliates"
"5JJMHoFRJHKPfSVf5xWAFdiZsvMceMCLJdniHEEjpSUn8MGjasT", "1HbG3dT3YYKiXPzxz5ffkQ9ZGKW3QbNsGH", "affiliated"
"5JHnPUqcYUBGBcLr8dZeztKyqktc2S6XA7Nwzk27mUB1C1aSSS8", "13aecydH48acQJKYhfTkgzWpjF8zewWFeA", "affiliate"
"5JJnZ1khhQ1S1P9hqLH8JtWArx4d4kyPVn6n7fjb6DeMhJwsXZd", "16rRytipLfjQ25BhLU955C8NgXS3Y3ciE4", "affidavits"
"5JWGnWDaXFB5HCx2Czt26kVZKuNVsbPjFWN7hv5hyr2u8ajDGcW", "1K9dHY68KuFvaRSrahhVfv1GmNtQmJg4km", "affidavit"
"5Kb7j79ZcY7ST9UXBRM7p8yGuq6nRxjkv65mRMLh4d3Ln98NJ48", "14xT8Es5YUpfrFbET8YQ1WihzCUAkkNdmF", "affianced"
"5JDh6RqjzKxxH2mDF8s2QqfAbsGKxUTLcQ39vqBcqCvk5gUEvYa", "1CpYKzLT9EN8y9QwBcKVc9rEebektZ4eAW", "affective"
"5JChJ4VFP7qViy3TpajvVvGh8g598w2FJfaU91BoUE7MoxYBdvS", "14ywyUVrdvt29qDXdcd5Aj8darYwLKQg1B", "affections"
"5J7NV7uCzPSX2ijrVToGMnQUv6jbComjK5dtdo8hoej5nhYNaeU", "1MUK7F8RohB7TrrVMez5rkp4tK21Hw75ta", "affectionately"
"5KdPi5L2FYAxczK43eJk637RmD5FnedvyrXZLg9UJP1JSh37TJu", "1MU3BF9U8NTWbaLwAkcbNVnLMkYigQ6f2V", "affectionate"
"5HySFpZTviP1esk29thT1b1kB113TVaNvqf5JxC4RJEBKKvChqx", "17bWTRhtF97RxHBVWLNCPbC9gkASVWSXQ8", "affection"
"5K44XkioDrvYTxY8LTscUfiWp7AmaHuubuXXxKtaWnuf2z6ecLt", "14qLkFEVEAXAbtrJBgvgMUtMbJDcpaKFQk", "affectingly"
"5HwqsWYPDzVaFbb8LwFLjYRMLzZQjFNRoT21qhXbwDjx4ndfHFe", "1DyaJiEJYHLZqwCycatUFm8mPzJu2E12ft", "affecting"
"5KZpj57FaLnVdXfweekdmHW9wbKGhHEGzxPSKCV57EgQy57nJsi", "1MTFHz3zv8FRJQTs8zNyZZcozBFRX9pRuR", "affectations"
"5JMtAnk4JoHus8CFjG9TKsDpUPWhPhP17B5JeeJB9jEQHyoZN1t", "1Aqev61Mimo1teifZo9RHaQV8Pv4LaUmGs", "affectation"
"5KZphR3t78KtGUVajvmpxbyfEi2mZQheBre7coXPRHD6JfAeU2R", "13tdhHyaLXfE3gNcsrmExKMf5SkozvyS52", "aesthetics"
"5KYFpEhy1Fy64bDLP3XGPZAeSGvCHaTT7BeTk2nkpvbcYGAgJvm", "1NqsStAkMwQQBViHar6SCrCyaXhtHdPkj3", "aesthetically"
"5KZtzBDuCskkRffmibRohAipTe1fuK8KqW9R9KNAwxfy9iXVsYf", "1yEYpEyTc9N6g2rTafk3a5cYcXYqsppGm", "aesthetic"
dream46go
Jr. Member
*
Offline Offline

Activity: 60
Merit: 0


View Profile
August 01, 2016, 10:07:33 PM
 #81

Example? Shocked Shocked Shocked

Code:
"5Jo3qrvsat3kEduGEt5HDtjNbjsa8Vexitnh5RcVpW3bLCuuN8K", "1KLdLFRvbxouJNFuRavWZmupxmjodSNA7V", "affricate"
"5Jkgm4yXJKt6iUKGCfHpgw1JMjPReamJvJhtcRG9x8BNC3s58i4", "1CAvkZWvmG9ydB7m66KM9BJFi6v1kefaKR", "affording"
"5J6mtfQFzYdMYLD2bjivYs25meCrhAoXtPhYWDV2Uutum5rjqPu", "1BLNNGVXzXPZtRz55SrvFJqud4xL8XFmfF", "affordable"
"5J7Gb8vjjzW25tqmCG26njkQ2fwSZ5SHQRAdxqcuBCBAJruhCCj", "17dL4QNs6iBUHFJ1eaCZ19uVF4aiKAs2GQ", "affluence"
"5JLxoQnovEQuvqbYpbjV1JwgNMcb4hXH2kg7KwzBmRGgRCwKKKY", "1ACy9tek6px8SqY5VP9Qov3rkdTaEys7CW", "afflictive"
"5Jiz1Wd6xVYHsyKn35o8Y9tyaBFcDBxPFC9jg1WKcMcdnimuEZh", "1MoFDaw1FsKNrYHh8zM3t9tTKmF66VhbLo", "afflictions"
"5JyjT3qp3Mf5Q4DHJSijZAcce9METFdALV6a5DQsarptCRYZCSx", "1Ed4mWcDPLTzXX4uMhSxENV5oAHaDcUir6", "affliction"
"5JxDLt2hBxCKE4XBg2iuttKohn3D3SBCCeUoTf8XEMUVekCoj5V", "12UcKekNo1eYX2hi6m5yeoBfAyYznBkq7B", "afflicting"
"5K46LHWh6CRVMpn6dCR3Q7JL8GyjujWQcfksb8A2vcrctj2xZeK", "1KCqLxbkbKeXy9ZK7hwtCtTV2LU4XK45wj", "afflicted"
"5KCzPrV6mofYkEQbxzsyKRUmkemLJnxw88vmYamdK4AZceSdT1Z", "1H81v5TGAWj1Ai3yryG4mBBjuFBSp2YFN3", "affirming"
"5K8UnLR74dScUpnig1aSkvRFkKoktp3zLndM5miTLHtbPeY8HLU", "16BsVdgcTGw8A8ymr7sHHVKkzgoTVUeVxQ", "affirmatively"
"5J3L7xefXfcG3DqgghzuRjC62W46UjH2A6MHPdCnMwd6wWd6z2X", "1Aq8rHXSqYUkTARqyLLKAjesoyqGus53hT", "affirmative"
"5JHxvtpaUMexxDUycLRUBeYDR9T6tHoGmdyqMJakLnsBngCNmmd", "18Bjb9CedPViYjHswPW2xBwkFd1BTnbC2t", "affirmations"
"5K5fH2bRSACCz9ttfVSHgMRn7muH7GwSST3zvQk1Ty3DDjnVaYZ", "18vbKoA7gmgVuhHsqA5zDo4cPHXXFy4QG8", "affirmation"
"5K4nCLKEp2gWMNGXrnLucpMnoa1qtLEGRgRDgK2JtdJePV8EysK", "1BhC3FHckEiJzux6zUp8gMWWT2YxZzoY9a", "affinities"
"5HyMT1mVSBgUQj9tQV2aQE3BciBpi8yv65kDLTZu9BxV5YZ4Sbm", "1FXoPz3bRSuXwiSejhXJF7N7ACy9zYMc1T", "affiliations"
"5HwJJxA383jSKFTpFh26v9ueiEWi6T39S1DgSk19gab7QAAcQtS", "1Boyefh7mj8CuEF9epZxPu4CTGC3ASLaV5", "affiliation"
"5JVPVDCLJxXaQhZxDRGD6qxmB4Yov2Z6BU6r4mSyw4eTDaYR24r", "1MhW6dZ93Y1n9qB18q2cLHqB6qXGzzANaX", "affiliating"
"5HzHqyyesnXBV3xsUcDJgRRfMM5wRwf1fwx2ZcBacMVucHbR6ZG", "12F257PY8kf1dZvuxkuR69BbDzzwC1yAUm", "affiliates"
"5JJMHoFRJHKPfSVf5xWAFdiZsvMceMCLJdniHEEjpSUn8MGjasT", "1HbG3dT3YYKiXPzxz5ffkQ9ZGKW3QbNsGH", "affiliated"
"5JHnPUqcYUBGBcLr8dZeztKyqktc2S6XA7Nwzk27mUB1C1aSSS8", "13aecydH48acQJKYhfTkgzWpjF8zewWFeA", "affiliate"
"5JJnZ1khhQ1S1P9hqLH8JtWArx4d4kyPVn6n7fjb6DeMhJwsXZd", "16rRytipLfjQ25BhLU955C8NgXS3Y3ciE4", "affidavits"
"5JWGnWDaXFB5HCx2Czt26kVZKuNVsbPjFWN7hv5hyr2u8ajDGcW", "1K9dHY68KuFvaRSrahhVfv1GmNtQmJg4km", "affidavit"
"5Kb7j79ZcY7ST9UXBRM7p8yGuq6nRxjkv65mRMLh4d3Ln98NJ48", "14xT8Es5YUpfrFbET8YQ1WihzCUAkkNdmF", "affianced"
"5JDh6RqjzKxxH2mDF8s2QqfAbsGKxUTLcQ39vqBcqCvk5gUEvYa", "1CpYKzLT9EN8y9QwBcKVc9rEebektZ4eAW", "affective"
"5JChJ4VFP7qViy3TpajvVvGh8g598w2FJfaU91BoUE7MoxYBdvS", "14ywyUVrdvt29qDXdcd5Aj8darYwLKQg1B", "affections"
"5J7NV7uCzPSX2ijrVToGMnQUv6jbComjK5dtdo8hoej5nhYNaeU", "1MUK7F8RohB7TrrVMez5rkp4tK21Hw75ta", "affectionately"
"5KdPi5L2FYAxczK43eJk637RmD5FnedvyrXZLg9UJP1JSh37TJu", "1MU3BF9U8NTWbaLwAkcbNVnLMkYigQ6f2V", "affectionate"
"5HySFpZTviP1esk29thT1b1kB113TVaNvqf5JxC4RJEBKKvChqx", "17bWTRhtF97RxHBVWLNCPbC9gkASVWSXQ8", "affection"
"5K44XkioDrvYTxY8LTscUfiWp7AmaHuubuXXxKtaWnuf2z6ecLt", "14qLkFEVEAXAbtrJBgvgMUtMbJDcpaKFQk", "affectingly"
"5HwqsWYPDzVaFbb8LwFLjYRMLzZQjFNRoT21qhXbwDjx4ndfHFe", "1DyaJiEJYHLZqwCycatUFm8mPzJu2E12ft", "affecting"
"5KZpj57FaLnVdXfweekdmHW9wbKGhHEGzxPSKCV57EgQy57nJsi", "1MTFHz3zv8FRJQTs8zNyZZcozBFRX9pRuR", "affectations"
"5JMtAnk4JoHus8CFjG9TKsDpUPWhPhP17B5JeeJB9jEQHyoZN1t", "1Aqev61Mimo1teifZo9RHaQV8Pv4LaUmGs", "affectation"
"5KZphR3t78KtGUVajvmpxbyfEi2mZQheBre7coXPRHD6JfAeU2R", "13tdhHyaLXfE3gNcsrmExKMf5SkozvyS52", "aesthetics"
"5KYFpEhy1Fy64bDLP3XGPZAeSGvCHaTT7BeTk2nkpvbcYGAgJvm", "1NqsStAkMwQQBViHar6SCrCyaXhtHdPkj3", "aesthetically"
"5KZtzBDuCskkRffmibRohAipTe1fuK8KqW9R9KNAwxfy9iXVsYf", "1yEYpEyTc9N6g2rTafk3a5cYcXYqsppGm", "aesthetic"

thank you, where are the source software to generate the wallet from password?
amaclin
Legendary
*
Offline Offline

Activity: 1260
Merit: 1000


View Profile
August 02, 2016, 02:21:12 AM
 #82

thank you, where are the source software to generate the wallet from password?
http://offlinebitcoins.com/
https://www.bitaddress.org/
xcbtrader
Hero Member
*****
Offline Offline

Activity: 867
Merit: 1006


View Profile
January 04, 2017, 12:17:37 PM
 #83

Hello

Another db ?

xcbtrader
Hero Member
*****
Offline Offline

Activity: 867
Merit: 1006


View Profile
January 05, 2017, 01:27:57 PM
 #84


Or you could be randomly generating private keys, and hoping to find one that corresponds to an address on that list. Not that hard, just need the compute power and a crap ton of luck.

Better create brainwallets from common passwords, sentences, .. and hope that there are bitcoins.

Tried it with the most common 16M passwords. In the past there were many bitcoins lying around ^^
But today they are all stolen/moved.
Example? Shocked Shocked Shocked


It's easy in Python.
Please look my github. I post code for make this.

https://github.com/xcbtrader/bitcoin-address

morantis
Hero Member
*****
Offline Offline

Activity: 658
Merit: 500


DATABLOCKCHAIN.IO


View Profile
January 05, 2017, 03:15:17 PM
 #85

i have a thought, just like checking private keys, it is near impossible because of the time that it would take.  instead of hunting and pecking randomly, why not start at block 0/1 and work outward. 

example...block 0...50 coins all went to the address 1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa

assuming that address is satoshi himself or one of the early devs, then, follow those coins...where did they go and where did the next go.   but, not address by address, block by block, parse each block for addresses, eliminate dupes, parse the final remaining for "is the bal <> X"



████ ████ ████████████▄▄▄              
█  █ █  █ ██          ▀▀▀▀██▄▄         
████ ████ ██████████▄▄▄▄    ▀▀█▄       
██   ██           ▀▀▀▀▀██▄▄   ▀█▄     
██   ██  █████████▄▄▄    ▀▀█▄   ▀█▄   
██   ██  ██      ▀▀▀▀██▄▄   ▀█▄   █▌  
██   ██  ██            ▀▀█▄  ▀█▌   █▌ 
██   ██  ██   ██████▄▄    ██  ▐█    █ 
██   ██  ██   ██   ▀▀▀█▌   █▌  ▐▌   █▌
██   ██  ██   ██      ▐█   ▐█   █   ▐█
██   ██  ██   ██       █▌   █▌  █   ▐█▌
██   ██  ███████      ▐█   ▐█  ▐█   ▐█
██   ██              ▄█▌   █▌  █▌   █▌
██   ███████████████▀▀    ▄█  ██    █ 
██                     ▄█▀  ▄█    █▌ 
████████████████████████▀  ▄█▀    █▌  
▄▄▄▄                      ▄█▀    ▄█▀   
█  ██████████████████████▀▀    ▄█▀     
▀▀▀▀                        ▄▄█▀       
▄▄▄▄                 ▄▄▄▄▄█▀▀          
█  ████████████████████▀▀              
▀▀▀▀                                   

       JOIN OUR TOKEN SALE      

FACEBOOK   TWITTER   LINKEDIN   GITHUB   ONE PAGER
eddyfly
Member
**
Offline Offline

Activity: 102
Merit: 10


View Profile
January 12, 2017, 08:11:52 AM
 #86

thank you, where are the source software to generate the wallet from password?
http://offlinebitcoins.com/
https://www.bitaddress.org/
2nd is better tho
cz3kit
Sr. Member
****
Offline Offline

Activity: 378
Merit: 250


View Profile
February 18, 2017, 09:55:24 PM
 #87

Ahh finally. I had been searching for something like this Cheesy
I have it now for future reference Smiley Thanks guys for sharing.

donGeilo
Full Member
***
Offline Offline

Activity: 169
Merit: 100



View Profile
May 28, 2017, 06:55:00 AM
 #88

Hi, does anyone got an up to date list?
 Thx in advance!
Mergesort
Full Member
***
Offline Offline

Activity: 140
Merit: 100


View Profile
August 05, 2017, 02:14:29 AM
 #89

Someone should create a program or website with a database that gets updated with every block. Load the blockchain with all transactions into the database and add changes with every block.
Kaller
Hero Member
*****
Offline Offline

Activity: 597
Merit: 501


Presale is live!


View Profile
August 05, 2017, 08:22:56 AM
 #90

Just to let ya know, many address remain unknown to this day. Even Satoshi's. We still don't know his Bitcoin address.
Most of the richest addresses these days are run by the exchanges.
They load a cold storage wallet with 60,000+ Bitcoins, all on one address.



    ▄▄█████████▄▄      █████████████▄▄       █████████████▄▄        █████     █████        █████   ███████████████████    ██▄                ▄██
   ███████████████▄    ████████████████▄     ████████████████▄      █████     ██████       █████   ███████████████████    ████▄            ▄████
  █████▀     ▀▀███▀    █████     ▀▀█████▄    █████     ▀▀█████▄     █████     ███████      █████          █████           ██████▄        ▄██████
 █████          ▀      █████        ▀▀▀▀▀    ▀▀▀▀▀        ▀▀▀██     █████     ████████     █████          █████           ████████▄    ▄████████
 █████▄                ███▀▀                                          ▀▀█     █████████    █████          █████            ▀██████▀    ▀██████▀
 ▀██████▄▄               ▄▄▄        ▄████    ▄▄▄▄▄        ▄▄▄       ▄         ██████████   █████          █████              ▀██▀  ▄██▄  ▀██▀
  ▀█████████▄▄         █████     ▄▄█████▀    █████     ▄▄█████▀     ███▄▄       ▀▀█ █████  █████          █████                  ▄██████▄
     ▀▀█████▀  ▄▄▄     ████████████████▀     ████████████████▀      █████     ▄▄     ▀▀▀██ █████          █████                ▄██████████▄
         ▀▀ ▄█████▄    █████████████▀▀       ██████████████▀        █████     ████▄       ▀▀▀███          █████              ▄██████████████▄
             ▀█████    █████                 █████     █████        █████     █████    ▄▄▄                █████            ▄████████▀▀████████▄
 ▄█▄          █████    █████                 █████      █████       █████     █████     █████▄▄▄
          █████           ████████▀    ▀████████
▄████▄▄     ▄█████     █████                 █████       █████      █████     █████      ███████
          ▀████           ██████▀        ▀██████
▀████████████████      █████                 █████        █████     █████     █████       ██████
            ▀██           ████▀            ▀████
  ▀▀██████████▀▀       █████                 █████         █████    █████     █████        █████
              ▀           ██▀                ▀██
██
██
██
██
██
██
██
██
██
██
██
██

     ██
    ██
   ██
  ██
 ██
██
 ██
  ██
   ██
    ██
     ██
Whitepaper
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
ANN Thread

██
 ██
  ██
   ██
    ██
     ██
    ██
   ██
  ██
 ██
██











Telegram
Facebook
Twitter
██
██
██
██
██
██
██
██
██
██
██
██
Mergesort
Full Member
***
Offline Offline

Activity: 140
Merit: 100


View Profile
August 08, 2017, 06:55:34 PM
 #91

Just to let ya know, many address remain unknown to this day. Even Satoshi's. We still don't know his Bitcoin address.
Most of the richest addresses these days are run by the exchanges.
They load a cold storage wallet with 60,000+ Bitcoins, all on one address.

How is that possible? I thought all address creations and transactions would be visible in the blockchain?
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
August 11, 2017, 11:59:46 AM
 #92

Long time ago, but here is a update list Smiley
http://ethteam.com/download/balances_20170811.zip
craZyLovE0916
Sr. Member
****
Offline Offline

Activity: 574
Merit: 250


Presale is live!


View Profile
August 12, 2017, 05:17:45 PM
 #93

Technically, you can never get all the addresses given that many addresses are not known on the network (think paper wallets). Until an address has done a transaction on the network or a key is published online it is not possible to know the balance of that address.

For example, no one knows Satoshi's addresses, but they are rumored to contain upwards of 1,000,000 Bitcoins.



    ▄▄█████████▄▄      █████████████▄▄       █████████████▄▄        █████     █████        █████   ███████████████████    ██▄                ▄██
   ███████████████▄    ████████████████▄     ████████████████▄      █████     ██████       █████   ███████████████████    ████▄            ▄████
  █████▀     ▀▀███▀    █████     ▀▀█████▄    █████     ▀▀█████▄     █████     ███████      █████          █████           ██████▄        ▄██████
 █████          ▀      █████        ▀▀▀▀▀    ▀▀▀▀▀        ▀▀▀██     █████     ████████     █████          █████           ████████▄    ▄████████
 █████▄                ███▀▀                                          ▀▀█     █████████    █████          █████            ▀██████▀    ▀██████▀
 ▀██████▄▄               ▄▄▄        ▄████    ▄▄▄▄▄        ▄▄▄       ▄         ██████████   █████          █████              ▀██▀  ▄██▄  ▀██▀
  ▀█████████▄▄         █████     ▄▄█████▀    █████     ▄▄█████▀     ███▄▄       ▀▀█ █████  █████          █████                  ▄██████▄
     ▀▀█████▀  ▄▄▄     ████████████████▀     ████████████████▀      █████     ▄▄     ▀▀▀██ █████          █████                ▄██████████▄
         ▀▀ ▄█████▄    █████████████▀▀       ██████████████▀        █████     ████▄       ▀▀▀███          █████              ▄██████████████▄
             ▀█████    █████                 █████     █████        █████     █████    ▄▄▄                █████            ▄████████▀▀████████▄
 ▄█▄          █████    █████                 █████      █████       █████     █████     █████▄▄▄
          █████           ████████▀    ▀████████
▄████▄▄     ▄█████     █████                 █████       █████      █████     █████      ███████
          ▀████           ██████▀        ▀██████
▀████████████████      █████                 █████        █████     █████     █████       ██████
            ▀██           ████▀            ▀████
  ▀▀██████████▀▀       █████                 █████         █████    █████     █████        █████
              ▀           ██▀                ▀██
██
██
██
██
██
██
██
██
██
██
██
██

     ██
    ██
   ██
  ██
 ██
██
 ██
  ██
   ██
    ██
     ██
Whitepaper
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
ANN Thread

██
 ██
  ██
   ██
    ██
     ██
    ██
   ██
  ██
 ██
██











Telegram
Facebook
Twitter
██
██
██
██
██
██
██
██
██
██
██
██
cz3kit
Sr. Member
****
Offline Offline

Activity: 378
Merit: 250


View Profile
August 12, 2017, 07:20:33 PM
 #94

Technically, you can never get all the addresses given that many addresses are not known on the network (think paper wallets). Until an address has done a transaction on the network or a key is published online it is not possible to know the balance of that address.

For example, no one knows Satoshi's addresses, but they are rumored to contain upwards of 1,000,000 Bitcoins.

I am not sure if this is correct.

If Satoshi's address has bitcoins, they have to come from somewhere. In the case they had been accumulated during the mining process in the beginning of bitcoin, there exists a coinbase transaction which sends the bitcoins to these addresses.
When you create a paper wallet and there are no bitcoins, you are not able to the address to a user, because it never had an incoming or outgoing transaction.

It should be able to scrap all used addresses from the blockchain.

Unless I am forgetting something or I misunderstood a concept, but I think I don't Cheesy
Feel free to correct me.

coder0x15
Jr. Member
*
Offline Offline

Activity: 32
Merit: 1

chess newbie


View Profile
August 12, 2017, 07:47:53 PM
 #95

This list may be generated from raw dat files (blkindex.dat).
Syke
Legendary
*
Offline Offline

Activity: 2646
Merit: 1007


View Profile
August 13, 2017, 08:20:38 PM
 #96

I am not sure if this is correct.

If Satoshi's address has bitcoins, they have to come from somewhere. In the case they had been accumulated during the mining process in the beginning of bitcoin, there exists a coinbase transaction which sends the bitcoins to these addresses.
When you create a paper wallet and there are no bitcoins, you are not able to the address to a user, because it never had an incoming or outgoing transaction.

It should be able to scrap all used addresses from the blockchain.

Unless I am forgetting something or I misunderstood a concept, but I think I don't Cheesy
Feel free to correct me.

You are correct. If an address has any bitcoins, then it received those from an incoming transaction, and thus can be tracked on the blockchain. Addresses that don't appear in the blockchain by definition cannot have any bitcoins in them, so they can be safely ignored.

Buy & Hold
cz3kit
Sr. Member
****
Offline Offline

Activity: 378
Merit: 250


View Profile
August 13, 2017, 10:03:31 PM
 #97


You are correct. If an address has any bitcoins, then it received those from an incoming transaction, and thus can be tracked on the blockchain. Addresses that don't appear in the blockchain by definition cannot have any bitcoins in them, so they can be safely ignored.

Ok, good to know. I thought that I missed something in the concept...

daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
August 14, 2017, 06:51:49 AM
 #98

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.
Micerker
Full Member
***
Offline Offline

Activity: 257
Merit: 100


The All-in-One Cryptocurrency Exchange


View Profile WWW
August 14, 2017, 08:22:31 AM
 #99

Do you will check i with directory.io ??

「   B e a x y   」   THE ALL-IN-ONE CRYPTOCURRENCY EXCHANGE
[ WHITEPAPER ]               Instant Deposit                   24/7 Support                    Referral Program               [ LIGHTPAPER ]
ANN THREAD     ●     BOUNTY THREAD     ●     FACEBOOK     ●     TWITTER     ●     TELEGRAM
cz3kit
Sr. Member
****
Offline Offline

Activity: 378
Merit: 250


View Profile
August 14, 2017, 08:30:15 AM
 #100

Do you will check i with directory.io ??

How you want to do it?
Go through all the pages?
People tried it already and it is nearly impossible to find there something due to length of the keys.

shimozukawa
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile
August 14, 2017, 10:12:17 AM
 #101

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
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
August 16, 2017, 08:42:30 AM
 #102

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
Full Member
***
Offline Offline

Activity: 152
Merit: 100



View Profile
August 16, 2017, 09:41:28 AM
 #103

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
Full Member
***
Offline Offline

Activity: 140
Merit: 100


View Profile
August 16, 2017, 09:47:02 PM
 #104

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
Full Member
***
Offline Offline

Activity: 163
Merit: 100


View Profile
August 16, 2017, 11:34:41 PM
 #105

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
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
September 03, 2017, 10:10:26 AM
 #106

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
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
September 05, 2017, 02:51:14 PM
 #107

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
Jr. Member
*
Offline Offline

Activity: 32
Merit: 1

chess newbie


View Profile
September 10, 2017, 03:15:26 AM
 #108

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
Newbie
*
Offline Offline

Activity: 6
Merit: 0


View Profile
November 15, 2017, 08:40:42 PM
 #109

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

hi! Someone has this file or new?
jhdscript
Member
**
Offline Offline

Activity: 224
Merit: 10


View Profile WWW
November 15, 2017, 08:51:31 PM
 #110

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

gopro
Newbie
*
Offline Offline

Activity: 6
Merit: 0


View Profile
November 15, 2017, 09:09:53 PM
 #111

I have one générateur on 11/18
can you share it? Smiley
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
November 16, 2017, 10:19:40 AM
 #112

I have one générateur on 11/18
can you share it? Smiley
Here is my latest:
http://ethteam.com/download/balances_493587.zip

To block 493587.
gopro
Newbie
*
Offline Offline

Activity: 6
Merit: 0


View Profile
November 17, 2017, 03:02:39 PM
 #113


Many thanks!!!

ps. One day I saw a file with date of last output/input. Someone has such file?
blocklife
Copper Member
Jr. Member
*
Offline Offline

Activity: 87
Merit: 0

Look around you , nothing is secure


View Profile WWW
November 17, 2017, 03:11:33 PM
 #114

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


The purpose of humanity : Genesis Chapter 1 (Rule)
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
November 17, 2017, 03:24:54 PM
 #115

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 ?


byteball
Member
**
Offline Offline

Activity: 112
Merit: 10


View Profile
November 17, 2017, 06:00:38 PM
 #116

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
Legendary
*
Offline Offline

Activity: 1904
Merit: 1009



View Profile
November 18, 2017, 01:03:58 PM
 #117

.....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
Jr. Member
*
Offline Offline

Activity: 54
Merit: 0


View Profile
December 07, 2017, 01:15:33 AM
 #118

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
hatuey
Jr. Member
*
Offline Offline

Activity: 54
Merit: 0


View Profile
December 07, 2017, 01:17:25 AM
 #119


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
Full Member
***
Offline Offline

Activity: 392
Merit: 105



View Profile
December 07, 2017, 03:05:39 AM
 #120

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

holy_ship
Jr. Member
*
Offline Offline

Activity: 56
Merit: 0


View Profile
December 12, 2017, 08:50:05 AM
 #121

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
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
December 12, 2017, 10:02:00 AM
 #122

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
holy_ship
Jr. Member
*
Offline Offline

Activity: 56
Merit: 0


View Profile
December 12, 2017, 10:20:10 AM
 #123

Didn't you read the question?  Huh
aplistir
Full Member
***
Offline Offline

Activity: 246
Merit: 107



View Profile
December 12, 2017, 11:07:09 AM
 #124

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
Full Member
***
Offline Offline

Activity: 246
Merit: 107



View Profile
December 12, 2017, 11:14:36 AM
 #125

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

Thanks for the updated list  Smiley

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
Full Member
***
Offline Offline

Activity: 364
Merit: 100

Buy Extremely Low and Then Sell Whenever You Want


View Profile
December 12, 2017, 09:10:27 PM
 #126

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


Do you have the hash160 download?

Buy Extremely Low
Sell Whenever You Want
Giggty Giggty Giggty
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
December 14, 2017, 12:32:15 PM
 #127

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


Do you have the hash160 download?
http://ethteam.com/download/balances_hash160_498754.zip
1,3Gb

Best Regards
bigvito19
Full Member
***
Offline Offline

Activity: 364
Merit: 100

Buy Extremely Low and Then Sell Whenever You Want


View Profile
December 14, 2017, 10:45:23 PM
 #128

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


Do you have the hash160 download?
http://ethteam.com/download/balances_hash160_498754.zip
1,3Gb

Best Regards

that's the same thing as the other one you already posted

Buy Extremely Low
Sell Whenever You Want
Giggty Giggty Giggty
hatuey
Jr. Member
*
Offline Offline

Activity: 54
Merit: 0


View Profile
December 18, 2017, 08:49:31 PM
 #129

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


Do you have the hash160 download?
http://ethteam.com/download/balances_hash160_498754.zip
1,3Gb

Best Regards

This is awesome growth!!!! thanks for sharing this month's reference list. Could you get one for Ethereum too?
muiying
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
December 19, 2017, 03:47:40 PM
 #130

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

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
Jr. Member
*
Offline Offline

Activity: 50
Merit: 0


View Profile
December 19, 2017, 07:59:56 PM
 #131

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


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
Full Member
***
Offline Offline

Activity: 169
Merit: 100


View Profile
December 20, 2017, 12:37:05 AM
 #132

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


Do you have the hash160 download?
http://ethteam.com/download/balances_hash160_498754.zip
1,3Gb

Best Regards

You are AWESOME! I've been looking for this! What do you use to extract this? Is is Bitcoin Abe?
Ned Kelly
Full Member
***
Offline Offline

Activity: 165
Merit: 100


View Profile
December 21, 2017, 04:22:09 AM
 #133


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
Jr. Member
*
Offline Offline

Activity: 54
Merit: 0


View Profile
December 24, 2017, 11:26:44 AM
 #134


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
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
December 24, 2017, 01:38:28 PM
 #135

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

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
Ned Kelly
Full Member
***
Offline Offline

Activity: 165
Merit: 100


View Profile
December 25, 2017, 12:33:50 AM
 #136


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:
Code:
#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 Offline

Activity: 56
Merit: 0


View Profile
December 26, 2017, 08:20:59 AM
 #137

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
Sr. Member
****
Offline Offline

Activity: 420
Merit: 250


View Profile
December 26, 2017, 09:10:51 AM
 #138

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 Offline

Activity: 2
Merit: 0


View Profile
December 28, 2017, 03:30:42 PM
 #139

Who knows if the balances_498754.csv file shared above contains the compressed or uncompressed format of the bitcoin public address?
anand9892
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile
January 03, 2018, 06:31:43 AM
 #140

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
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
WitoldC
Jr. Member
*
Offline Offline

Activity: 63
Merit: 0


View Profile
January 03, 2018, 02:19:21 PM
 #141

There is ';' instead ',' You must replace all in editor.

Code:
1CG4LbEXoBus2egJS8SBh3DDPTrSykzFMG;942800
1Jt1Yng68p6Pd3pYWc1W1nxWSZSx9PZNto;2100390
32i3fvUTZkq2zeHBuosYDkiSCyMDhP62eo;9592347
blue2358
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile
January 10, 2018, 06:00:04 PM
 #142

@daboehla would you have a new hash160 file with all hashes for all addresses?

thanks in advance!
daboehla
Sr. Member
****
Offline Offline

Activity: 453
Merit: 252



View Profile
January 11, 2018, 07:34:08 AM
 #143

@daboehla would you have a new hash160 file with all hashes for all addresses?

thanks in advance!
Still waiting for my new PC... I think about somewhere next week I can make a fresh one.
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 11, 2018, 08:33:15 AM
 #144

give me few hours, ill upload latest one.

webchris
Member
**
Offline Offline

Activity: 139
Merit: 10


View Profile WWW
January 11, 2018, 10:43:13 PM
 #145

give me few hours, ill upload latest one.

Your lists just pull addresses with balances right? You don't list every address on the blockchain, or do you?

Join a Safe Shared LUX Masternode -> https://www.luxmasternode.com
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 12, 2018, 01:15:48 AM
 #146

give me few hours, ill upload latest one.

Your lists just pull addresses with balances right? You don't list every address on the blockchain, or do you?

nope, only addresses having balance.

edit: here it is

Code:
https://transfer.sh/xGs0K/btctousd81-12jan2018.csv.7z
format

Code:
addresss, hash160, amount

blue2358
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile
January 13, 2018, 10:50:25 PM
 #147

thanks @btctousd81.

would you give the script that allows to create this csv?
did you do it in bash or python or anything else?
Anti-Cen
Member
**
Offline Offline

Activity: 196
Merit: 20

High fees = low BTC price


View Profile
January 13, 2018, 11:17:20 PM
 #148

Interested in doing this too. Found this to import blockchain into MongoDB: https://github.com/thelinuxkid/bitcoinquery

it says "In order to use bitcoinquery you need a Bitcoind RPC server"

I want to do it from windows without running a full node and doing RPC to the local node
See https://bitcointalk.org/index.php?topic=2748620.new#new
Looks like i need some form of Berkeley-DB to run in windows to read Block.dat files that is not so easy to come
by in windows and yes I know it's all spyware

Will upload if i get anything working that should sum all balances (I hope)
but it will be windows based





Mining is CPU-wars and Intel, AMD like it nearly as much as big oil likes miners wasting electricity. Is this what mankind has come too.
Anti-Cen
Member
**
Offline Offline

Activity: 196
Merit: 20

High fees = low BTC price


View Profile
January 13, 2018, 11:33:42 PM
 #149


Nice so did you do it from windows or Linux without using a wrapper around someones
mega-big API or running a full-node and using RPC ?

I am trying to code this myself to read block.dat from several  types of forked BC  from Bitcoin
so I need to go back to raw files I think and then see what happens after a fork date to the data
so off the shelf API's won't help me out.

Will be interesting to see who has money in the forks and are not using it




Mining is CPU-wars and Intel, AMD like it nearly as much as big oil likes miners wasting electricity. Is this what mankind has come too.
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 14, 2018, 03:16:35 AM
 #150

thanks @btctousd81.

would you give the script that allows to create this csv?
did you do it in bash or python or anything else?


Nice so did you do it from windows or Linux without using a wrapper around someones
mega-big API or running a full-node and using RPC ?

I am trying to code this myself to read block.dat from several  types of forked BC  from Bitcoin
so I need to go back to raw files I think and then see what happens after a fork date to the data
so off the shelf API's won't help me out.

Will be interesting to see who has money in the forks and are not using it





i have full node running at home, on linux centos 7 dedicated to only bitcoind.

there is no single readymade script to get all addresses having balance.

what i did was i used rusty-blockparser to get all unspent outputs in csv.
then loaded it in myql
then some queries to get data in proper format and bitcoin-tool to get address to hash160.

then i have this php script which gets run every 4-6 hours and parses all new blocks using rpc. and updates my mysql db.

it was time consuming task took me 2-3 days to get everything in db.

it would be great if someone could create app which can directly read chainstate db.

parsing blockchain is pretty simple using rpc but its fuckin slow as hell.

every output is +1 and old amount + new amount
while
every input is -1 and old amount - new amount

this is my logic to get uptodate all addresses having balance ..

hope this helps.,

i could upload regular updated db daily but my home net has very slow upload speed so it takes around 7-8 hours to upload above dump.

-------------------------------

edit:

if you want only addresses having balance not care about the amount of btc its holding, then just run

rusty-blockparser with unspentcsv callback

you wiill get huge csv dump file then just use grep sed something like that to only get addresses.

the parser takes around 8 -12 hours., even on my amd fx 8350 , 32 gig dedicated machine.

Anti-Cen
Member
**
Offline Offline

Activity: 196
Merit: 20

High fees = low BTC price


View Profile
January 15, 2018, 11:51:50 AM
 #151

i have full node running at home, on linux centos 7 dedicated to only bitcoind.

Yes that's my killer because I run Windows spyware version 10 and is too old to
move over and learn Linux and most the time I can make apps that sing and dance
on windows without any trouble at all.

in fact i am the best "string butcher" in the world

Mining is CPU-wars and Intel, AMD like it nearly as much as big oil likes miners wasting electricity. Is this what mankind has come too.
coder0x15
Jr. Member
*
Offline Offline

Activity: 32
Merit: 1

chess newbie


View Profile
January 15, 2018, 09:28:01 PM
 #152

It doesn't matter what OS you have. Blockchain is equal and fully cross platform. I mean blk*.dat binaries and so on.
@Anti-Cen, "string butcher", so please show us your script that extract all non-zero ballances from blockchain Smiley
initstring
Newbie
*
Offline Offline

Activity: 7
Merit: 0


View Profile
January 28, 2018, 12:43:53 AM
 #153

Quote

edit: here it is

Code:
https://transfer.sh/xGs0K/btctousd81-12jan2018.csv.7z

Hi @btctousd81,

Is there still a working link to download this? I would love a copy and my current full node isn't powerful enough to generate in a reasonable time.

Either way, thanks!
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 28, 2018, 01:46:39 AM
 #154

Quote

edit: here it is

Code:
https://transfer.sh/xGs0K/btctousd81-12jan2018.csv.7z

Hi @btctousd81,

Is there still a working link to download this? I would love a copy and my current full node isn't powerful enough to generate in a reasonable time.

Either way, thanks!

give me few hours, i ll upload it tonight., so most probably i will post updated link tomorrow.,

thanks

initstring
Newbie
*
Offline Offline

Activity: 7
Merit: 0


View Profile
January 29, 2018, 07:01:34 AM
 #155


give me few hours, i ll upload it tonight., so most probably i will post updated link tomorrow.,

thanks

Thank you very much! I'll keep an eye on the thread. Much appreciated!
blocklife
Copper Member
Jr. Member
*
Offline Offline

Activity: 87
Merit: 0

Look around you , nothing is secure


View Profile WWW
January 29, 2018, 10:35:01 AM
 #156

Wouldnt it be easiers if you pulled all discovered addresses from an existing db
then query for there balances
and filter out the ones < x

Problem solved. ?

The purpose of humanity : Genesis Chapter 1 (Rule)
webchris
Member
**
Offline Offline

Activity: 139
Merit: 10


View Profile WWW
January 29, 2018, 03:21:12 PM
 #157

Wouldnt it be easiers if you pulled all discovered addresses from an existing db
then query for there balances
and filter out the ones < x

Problem solved. ?

Then you are relying on the other database to be up-to-date. Plus that db is going to be pretty large as there are quite a few discovered addresses.

Join a Safe Shared LUX Masternode -> https://www.luxmasternode.com
initstring
Newbie
*
Offline Offline

Activity: 7
Merit: 0


View Profile
January 29, 2018, 07:48:09 PM
 #158

Wouldnt it be easiers if you pulled all discovered addresses from an existing db
then query for there balances
and filter out the ones < x

Problem solved. ?

It's fairly easy to pull this info from a full node. The full node I run is in a VM with 4GB RAM, and the method I'm familiar with (https://github.com/znort987/blockparser) requires a machine with closer to 128GB.
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 30, 2018, 02:46:03 AM
 #159

here it is latest dump

https://www.transfernow.net/51dss251ddg5


format

Code:
btc address,hash160,amount in satoshis

Code:
[root@btcnode tmp]# head btctousd81_29jan2018.csv
1111111111111111111114oLvT2,0000000000000000000000000000000000000000,6531128743
111111111111111111112BEH2ro,000000000000000000000000000000000000000a,10940
111111111111111111112xT3273,0000000000000000000000000000000000000011,5340
1111111111111111111141MmnWZ,000000000000000000000000000000000000001a,5340
111111111111111111114ysyUW1,0000000000000000000000000000000000000023,5340
11111111111111111111BZbvjr,0000000000000000000000000000000000000001,1028212
11111111111111111111CJawggc,0000000000000000000000000000000000000064,1548
11111111111111111111HV1eYjP,0000000000000000000000000000000000000092,2730
11111111111111111111HeBAGj,0000000000000000000000000000000000000002,5481
11111111111111111111QekFQw,0000000000000000000000000000000000000003,1

Code:
[root@btcnode tmp]# tail btctousd81_29jan2018.csv
1DpBda3jw6x2rbkSJUFrBfUPKgFbZsr5t9,8c8deefad99de1daffac1446a01132266c9d58fa,35264328
1JtY892wdpUfeVqg3nH3fed2whZBi9xTf,036217897bf7eb792d129b962e8d478e2030ac94,19446553
19b8mLDpqbUwZCZ8Sa9TbMj2ofhcUwc5HF,5e35a15c10dd14e888b58320f737142c48e2eea6,3366861
15SQ4c9BRsR77hbBLBXxGi8h7V7pDFtShG,30ae274c7101a903e1cce0d429383b2d680c947f,10524100
1HB4EbQygbDBqj4DeRWrEHvqEyPdW2k9B7,b168df40270271f6d71e2cd961e40f58e86f7d9e,2882
1H9KeUz92d3DwdTdnH2dR4tjF9Q1ma8uHW,b114e7c464188535cdea560ac484e609d92e07ee,2182583
1GxScqUcg5MZRrkQQeTziivX6CfVTywCXh,af06263ce147c366a49e12964e50f7106e8368e1,3294
3BceAG61bUsfBxb64JpMKB5TuE1mqzPkao,6cdd6d3eb7084e3487eadb47bcec761c87ca966e,540545
1LsweYaesdzt86Ze2WSQQHso5AjoNDRikv,da0cce25e3b57eaa2822ca328a5581a9a694e2ee,3739000
15ozPLgWzBokpRUbNecatNqqDbfpADFtUb,34c38a43d285e03e0a0b4bf65ca0a6f9ae8c97e6,349051

initstring
Newbie
*
Offline Offline

Activity: 7
Merit: 0


View Profile
January 30, 2018, 03:47:17 AM
 #160

here it is latest dump

...

Awesome, thank you so much! I owe you one. Smiley
jrian
Jr. Member
*
Offline Offline

Activity: 35
Merit: 4


View Profile
January 30, 2018, 04:15:01 PM
 #161

here it is latest dump


Code:
[root@btcnode tmp]# head btctousd81_29jan2018.csv
1111111111111111111114oLvT2,0000000000000000000000000000000000000000,6531128743
111111111111111111112BEH2ro,000000000000000000000000000000000000000a,10940
111111111111111111112xT3273,0000000000000000000000000000000000000011,5340
1111111111111111111141MmnWZ,000000000000000000000000000000000000001a,5340
111111111111111111114ysyUW1,0000000000000000000000000000000000000023,5340
11111111111111111111BZbvjr,0000000000000000000000000000000000000001,1028212


can you, please, sort it by balance row next time? Thanks!
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 30, 2018, 04:20:21 PM
 #162

here it is latest dump


Code:
[root@btcnode tmp]# head btctousd81_29jan2018.csv
1111111111111111111114oLvT2,0000000000000000000000000000000000000000,6531128743
111111111111111111112BEH2ro,000000000000000000000000000000000000000a,10940
111111111111111111112xT3273,0000000000000000000000000000000000000011,5340
1111111111111111111141MmnWZ,000000000000000000000000000000000000001a,5340
111111111111111111114ysyUW1,0000000000000000000000000000000000000023,5340
11111111111111111111BZbvjr,0000000000000000000000000000000000000001,1028212


can you, please, sort it by balance row next time? Thanks!


yes, i can do that.,

you can do that too, by loading it in mysql or any other db or
load it in excel. and do sort by amount.

coder0x15
Jr. Member
*
Offline Offline

Activity: 32
Merit: 1

chess newbie


View Profile
January 31, 2018, 05:38:23 AM
 #163

Hi @btctousd81! Please tell what tool you use for to create such database?
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 31, 2018, 10:05:38 AM
 #164

Hi @btctousd81! Please tell what tool you use for to create such database?

please check this

https://bitcointalk.org/index.php?topic=267618.msg28087082#msg28087082

coder0x15
Jr. Member
*
Offline Offline

Activity: 32
Merit: 1

chess newbie


View Profile
January 31, 2018, 10:26:25 AM
 #165

Hi @btctousd81! Please tell what tool you use for to create such database?

please check this

https://bitcointalk.org/index.php?topic=267618.msg28087082#msg28087082

What bitcoin-tool you use to get 'address to hash160'?
You working using bitcoind rpc, not directly with blockchain disk data?
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 31, 2018, 10:36:11 AM
 #166

Hi @btctousd81! Please tell what tool you use for to create such database?

please check this

https://bitcointalk.org/index.php?topic=267618.msg28087082#msg28087082

What bitcoin-tool you use to get 'address to hash160'?
You working using bitcoind rpc, not directly with blockchain disk data?

at initial level, when i needed to convert 20 million+ bitcoin address to hash160, i used bitcoin-tool

ref : https://github.com/matja/bitcoin-tool

ref: https://github.com/matja/bitcoin-tool/issues/20

but for newer blocks data i am using php code to calculate hash160 from address.

i am using bitcoind rpc and not reading blockchain disk data.,

cronjob runs my php script every 6 hours i guess, and parses all new blocks and insrts then in mysql.,


coder0x15
Jr. Member
*
Offline Offline

Activity: 32
Merit: 1

chess newbie


View Profile
January 31, 2018, 01:47:09 PM
 #167

@btctousd81 you can convert Base58 back to ripemd160?
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 31, 2018, 01:49:21 PM
 #168

@btctousd81 you can convert Base58 back to ripemd160?

yes, i can do Base58 to ripemd160 and other way around too.,

Thanks

coder0x15
Jr. Member
*
Offline Offline

Activity: 32
Merit: 1

chess newbie


View Profile
January 31, 2018, 02:00:00 PM
 #169

yes, i can do Base58 to ripemd160
You do not understand anything what you are talking about.
It is possible in the one way, when you know ripemd160 and make base58. Not versa)
Or you invented reverse method?
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
January 31, 2018, 02:03:11 PM
 #170

yes, i can do Base58 to ripemd160
You do not understand anything what you are talking about.
It is possible in the one way, when you know ripemd160 and make base58. Not versa)
Or you invented reverse method?


alright lets not complicate it.

i can convert

1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa

to

62e907b15cbf27d5425399ebf6f0fb50ebb88f18

AND

i can convert

62e907b15cbf27d5425399ebf6f0fb50ebb88f18

to

1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa

sorry for confusion, i am not very good with technical words ripemd and base58.

hope this helps.,


coder0x15
Jr. Member
*
Offline Offline

Activity: 32
Merit: 1

chess newbie


View Profile
January 31, 2018, 04:24:55 PM
 #171

@btctousd81 can you provide UTXOs for to each address?
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
February 01, 2018, 01:51:38 AM
 #172

@btctousd81 can you provide UTXOs for to each address?

previoulsy i could, but i no more keep track of UTXOs .

i only keep track of

address, hash160, unspent output count, amount.

so every vout is +1

and every vin is -1

same goes with amount.

every vout amount is old amount + new amount
every vin amount is old amount - new amount

mugt
Newbie
*
Offline Offline

Activity: 25
Merit: 8


View Profile
February 02, 2018, 02:15:51 PM
 #173



previoulsy i could, but i no more keep track of UTXOs .

i only keep track of

address, hash160, unspent output count, amount.

so every vout is +1

and every vin is -1

same goes with amount.

every vout amount is old amount + new amount
every vin amount is old amount - new amount

@btctousd81 How do you read segwit addresses?
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
February 02, 2018, 02:25:52 PM
 #174



previoulsy i could, but i no more keep track of UTXOs .

i only keep track of

address, hash160, unspent output count, amount.

so every vout is +1

and every vin is -1

same goes with amount.

every vout amount is old amount + new amount
every vin amount is old amount - new amount

@btctousd81 How do you read segwit addresses?


you mean bech32 (starting "bc1") ? then i dont think that bitcoin-core supports it yet for rpc. so cant read/parse those addresses using rpc.

but if you mean P2SH (starting with a "3") then those are p2sh addresses those can be returned by bitcoin-core json/rpc .


lookingdream21
Newbie
*
Offline Offline

Activity: 14
Merit: 0


View Profile
February 02, 2018, 07:55:57 PM
 #175

I would recommend ABE, but with it, if you start importing from block 0, it might take a month or two to fully import the blockchain, unless of course you have an SSD and fast RAM.
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
February 10, 2018, 04:27:14 AM
 #176

Hi everyone,

I've opensourced a small software to parse the chainstate & output all utxos with their addresses (including latest bech32) in CSV format. As for today, computation takes ~8 minutes & creates a 6 GB CSV file (there is 60M utxos).
Feel free to give it a try: https://github.com/mycroft/chainstate

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
February 10, 2018, 05:02:21 AM
 #177

Hi everyone,

I've opensourced a small software to parse the chainstate & output all utxos with their addresses (including latest bech32) in CSV format. As for today, computation takes ~8 minutes & creates a 6 GB CSV file (there is 60M utxos).
Feel free to give it a try: https://github.com/mycroft/chainstate


Thank you, finally someone who is developer and want to help others.,

I Really appreciate it.

i will post results once i try it., Thanks.

starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
February 10, 2018, 05:09:06 AM
 #178

Hi everyone,

I've opensourced a small software to parse the chainstate & output all utxos with their addresses (including latest bech32) in CSV format. As for today, computation takes ~8 minutes & creates a 6 GB CSV file (there is 60M utxos).
Feel free to give it a try: https://github.com/mycroft/chainstate


Thank you, finally someone who is developer and want to help others.,

I Really appreciate it.

i will post results once i try it., Thanks.

In fact, I just tumbled upon this forum after I started working on this and felt it was appropriate to share this stuff...
Ijust got some interests about parsing blockchain recently (wrote my own parser as well, but not opensourced it yet) then chainstate.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
tilistor
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
February 11, 2018, 05:27:27 PM
 #179

You mentioned that the export file has address, hash160 and balance.
Can you please let me know if the address is WIF compressed or uncompressed? Or what type of address it is?

Thanks!
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
February 12, 2018, 09:33:46 AM
 #180

You mentioned that the export file has address, hash160 and balance.

yes.

Can you please let me know if the address is WIF compressed or uncompressed? Or what type of address it is?

Thanks!

its base58 address , p2pk staring with 1 and some are starring with 3 p2sh addressess.

aplistir
Full Member
***
Offline Offline

Activity: 246
Merit: 107



View Profile
February 12, 2018, 06:55:01 PM
 #181


Is there any way to get the extraNonce values of every mined block from 1 -> 150000 ?

I am interested in doing some blockchain archaelogy like this:
https://bitcointalk.org/index.php?topic=507458.0

I already have those for blocks 1-36288, but I would like to have them all the way until block 150000. (After that the extraNonce becomes meaningless.)

The extraNonce value for each block can be found from the block-reward transaction from coinbase.
https://bitcoin.stackexchange.com/questions/48540/how-is-the-extra-nonce-formatted

Would be great if someone either has those, or can help me getting them myself.

My Address: 121f7zb2U4g9iM4MiJTDhEzqeZGHzq5wLh
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
February 13, 2018, 04:36:23 AM
 #182


Is there any way to get the extraNonce values of every mined block from 1 -> 150000 ?

I am interested in doing some blockchain archaelogy like this:
https://bitcointalk.org/index.php?topic=507458.0

I already have those for blocks 1-36288, but I would like to have them all the way until block 150000. (After that the extraNonce becomes meaningless.)

The extraNonce value for each block can be found from the block-reward transaction from coinbase.
https://bitcoin.stackexchange.com/questions/48540/how-is-the-extra-nonce-formatted

Would be great if someone either has those, or can help me getting them myself.

what are you saying ?

satoshi secretly mined and has more than 50 btc which are from genesis block ?

starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
February 13, 2018, 10:14:24 AM
Merited by aplistir (1)
 #183


Is there any way to get the extraNonce values of every mined block from 1 -> 150000 ?

I am interested in doing some blockchain archaelogy like this:
https://bitcointalk.org/index.php?topic=507458.0

I already have those for blocks 1-36288, but I would like to have them all the way until block 150000. (After that the extraNonce becomes meaningless.)

The extraNonce value for each block can be found from the block-reward transaction from coinbase.
https://bitcoin.stackexchange.com/questions/48540/how-is-the-extra-nonce-formatted

Would be great if someone either has those, or can help me getting them myself.

Can you check this file: https://transfer.sh/oZFQr/extranonces.final.gz ? Format is height;hash;extranonce value.

I've got values for ~180k first blocks. Didn't check if all coinbase input scripts had the same format, just exported 2nd value pushed in stack of coinbase input script using my export tools. If values doesn't match yours, please send me your values so I can fix my scripts, but so far, it seems to match values from the order thread.

Cheers.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
aplistir
Full Member
***
Offline Offline

Activity: 246
Merit: 107



View Profile
February 13, 2018, 07:13:07 PM
 #184


Can you check this file: https://transfer.sh/oZFQr/extranonces.final.gz ? Format is height;hash;extranonce value.

I've got values for ~180k first blocks. Didn't check if all coinbase input scripts had the same format, just exported 2nd value pushed in stack of coinbase input script using my export tools. If values doesn't match yours, please send me your values so I can fix my scripts, but so far, it seems to match values from the order thread.

Excellent! Thank you.  Smiley
I have been looking for that information for some time now. I even tried some old blockchain parser, which could not do the job.

I checked the numbers against the ones I have, and the first 36288 extraNonce values are the same than the ones I had  Grin

My Address: 121f7zb2U4g9iM4MiJTDhEzqeZGHzq5wLh
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
February 14, 2018, 02:56:28 AM
 #185


Is there any way to get the extraNonce values of every mined block from 1 -> 150000 ?

I am interested in doing some blockchain archaelogy like this:
https://bitcointalk.org/index.php?topic=507458.0

what are you saying ?

satoshi secretly mined and has more than 50 btc which are from genesis block ?

On the first blocks mined, there were some input script on coinbase transaction (which is useless as it is not used at all in bitcoin's protocol). In this script, they were only 2 pushes in stack of 2 VLI: one for a timestamp (not sure), and another by an extranonce value. This value was used to alter the coinbase TX hash, thus the merkleroot hash, then the block hash value. I guess it was another variable which could be used to reach a valid block hash value (additional ot nonce & timestamp or re-ordering transactions).

This value is not existing anymore and recent blocks have a empty input script for coinbase transaction.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
Sakuraa
Newbie
*
Offline Offline

Activity: 5
Merit: 0


View Profile
February 16, 2018, 11:07:54 PM
 #186

Friend, please upload a new version or update the link to the old one
btctousd81
Sr. Member
****
Offline Offline

Activity: 378
Merit: 252


View Profile WWW
February 17, 2018, 04:35:56 AM
 #187

Friend, please upload a new version or update the link to the old one

i m not at machine., will need 2 days., watch this thread.

ivanxuu
Newbie
*
Offline Offline

Activity: 6
Merit: 0


View Profile
February 19, 2018, 08:53:09 AM
 #188

Hi everyone,

I've opensourced a small software to parse the chainstate & output all utxos with their addresses (including latest bech32) in CSV format. As for today, computation takes ~8 minutes & creates a 6 GB CSV file (there is 60M utxos).
Feel free to give it a try: https://github.com/mycroft/chainstate

Would you mind uploading that CSV file? It contains all addresses, even with no balance, right?
I've alredy tried to compile your code but I'm getting errors related to gmp library. If you can upload that I wouldn't mind reuploading to my own http server so it can be accessed to others.
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
February 19, 2018, 09:55:39 AM
 #189

Would you mind uploading that CSV file? It contains all addresses, even with no balance, right?
I've alredy tried to compile your code but I'm getting errors related to gmp library. If you can upload that I wouldn't mind reuploading to my own http server so it can be accessed to others.

I can't for the moment & until the end of the week unfortunately.
If you have gmp librairies & headers installed, secp256k1 will use it. You'll have to edit the main Makefile and add "-lgmp" in the LDFLAGS line. It will build the binary using it.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
ivanxuu
Newbie
*
Offline Offline

Activity: 6
Merit: 0


View Profile
February 19, 2018, 01:25:32 PM
 #190

Thanks a bunch! That made it!

Now, I've made a copy of ~/.bitcoin/chainstate dir, and move it to the path where i've compiled your program (~/development/chainstate):

$ cp -rp ~/.bitcoin/chainstate ~/development/chainstate/state

But now I'm getting:

user@localhost:~/Deveopment/chainstate $ ./chainstate
chainstate: chainstate.cc:45: int main(): Assertion `idx[0] == 'C'' failed.


Which is weird because if I add the following line before and comment the assertion like this:

~  45         cout << "DBG: "<<idx[0] << " \n";                               
+  46         //assert(idx[0] == 'C');


Then I get lines like:

user@localhost:~/Deveopment/chainstate $ ./chainstate
DBG: 
Invalid output: 79656b5f65746163737566626f00 38c006 30080738760000
79656b5f65746163737566626f00;Invalid address or lost;30080738760000
last block: 06c03835a99fece306e4e25c7c7c7c34747a2ee3a3b177156a93b2ecdf7fd9a3
DBG: C
Invalid output: eacfdcd42b27112ab6c8b435abec20181d05b0ba5d4f1829c002cc3ef0000000 9729b525c0f657759ad3c11de5e525c596843cc30b84b975b5 4
eacfdcd42b27112ab6c8b435abec20181d05b0ba5d4f1829c002cc3ef0000000;Invalid address or lost;4
DBG: C
Invalid output: a59f2e72830363c38a438d12236a15d1ca3074ce980873bd7f3a1699f7010000 d139db52c05d8a0fb4bf2cc101c3916250098c52d03799b092 10000000000
a59f2e72830363c38a438d12236a15d1ca3074ce980873bd7f3a1699f7010000;Invalid address or lost;10000000000
DBG: C
Invalid output: 0118dd986e59473732239d39cb3b8890bf32677719dd8933b05f6614f4020000 83211539cb2ce3daeded5d37ada7692119b33dc8689a5058 1000000
0118dd986e59473732239d39cb3b8890bf32677719dd8933b05f6614f4020000;Invalid address or lost;1000000
DBG: C


What could it be?
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
February 20, 2018, 05:05:44 AM
 #191

But now I'm getting:

user@localhost:~/Deveopment/chainstate $ ./chainstate
chainstate: chainstate.cc:45: int main(): Assertion `idx[0] == 'C'' failed.


Which is weird because if I add the following line before and comment the assertion like this:

~  45         cout << "DBG: "<<idx[0] << " \n";                               
+  46         //assert(idx[0] == 'C');


Then I get lines like:

user@localhost:~/Deveopment/chainstate $ ./chainstate
DBG: 
Invalid output: 79656b5f65746163737566626f00 38c006 30080738760000
79656b5f65746163737566626f00;Invalid address or lost;30080738760000
last block: 06c03835a99fece306e4e25c7c7c7c34747a2ee3a3b177156a93b2ecdf7fd9a3
DBG: C
Invalid output: eacfdcd42b27112ab6c8b435abec20181d05b0ba5d4f1829c002cc3ef0000000 9729b525c0f657759ad3c11de5e525c596843cc30b84b975b5 4
eacfdcd42b27112ab6c8b435abec20181d05b0ba5d4f1829c002cc3ef0000000;Invalid address or lost;4


What could it be?

I think I forgot to handle a case: When the chainstate is obfuscated. When it happens, a new record is added to database, hitting the assert condition and making the parsing go wrong.

I added the forgotten feature, but I'm not 100% sure it is ok. So far my tests were OK (for some reason, my main testing bitcoins db was clear of any obfuscation). Could you pull the source again from https://github.com/mycroft/chainstate and rebuild it to try it ? It would be really helpful.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
ivanxuu
Newbie
*
Offline Offline

Activity: 6
Merit: 0


View Profile
February 20, 2018, 11:17:20 AM
 #192


I think I forgot to handle a case: When the chainstate is obfuscated. When it happens, a new record is added to database, hitting the assert condition and making the parsing go wrong.

I added the forgotten feature, but I'm not 100% sure it is ok. So far my tests were OK (for some reason, my main testing bitcoins db was clear of any obfuscation). Could you pull the source again from https://github.com/mycroft/chainstate and rebuild it to try it ? It would be really helpful.


Your new commit made it possible. Thanks. It's working fine now  Smiley

Is anyone insterested in downloading the CSV file? I can upload it to internet if anyone is insterested.
phucthinh11061997
Newbie
*
Offline Offline

Activity: 20
Merit: 0


View Profile
February 20, 2018, 01:59:31 PM
 #193

Who knows if the balances_498754.csv file shared above contains the compressed or uncompressed format of the bitcoin public address?
aplistir
Full Member
***
Offline Offline

Activity: 246
Merit: 107



View Profile
February 20, 2018, 04:42:03 PM
 #194

Who knows if the balances_498754.csv file shared above contains the compressed or uncompressed format of the bitcoin public address?

It is impossible to know if a bitcoin address is made using a compressed or uncompressed public key. Every bitcoin address has many compressed and uncompressed public keys that will generate that address.
There are 2^160 possible addresses and 2^256 public keys, which makes about 2^96 different keys for each address

But you can make an educated guess based on the date when the address was created. During the last 3-4 years >99% of generated addresses would use compressed public keys. And the oldest ones would probably use uncompressed keys.

The only way to be certain is if there is a spend action from that address. then you can look at the published public key and you will know if it is compressed or not.

My Address: 121f7zb2U4g9iM4MiJTDhEzqeZGHzq5wLh
RebeccaCole
Jr. Member
*
Offline Offline

Activity: 43
Merit: 0


View Profile
February 26, 2018, 11:36:03 AM
 #195

Can't you just sort the output?
rustychainz
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
March 03, 2018, 01:44:36 AM
 #196

anyone have an updated file? balances_498754.zip  is quite old.
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 04, 2018, 06:50:58 PM
 #197

I've generated a new dump for all balances as of today.

Enjoy: https://transfer.sh/12aVfO/balances_20180304.out.gz

Cheers.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
P.
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile
March 05, 2018, 12:49:44 PM
 #198

Need to ask .. as second and third values are

1111111111111111111114oLvT2;43338925513
111111111111111111112BEH2ro;10940

if I check via bitref (or any other tool),

second key balance is 65.57999243
third 0.00010940

seems like greater numbers are flawed somehow?
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 05, 2018, 02:45:08 PM
 #199

Need to ask .. as second and third values are

1111111111111111111114oLvT2;43338925513
111111111111111111112BEH2ro;10940

if I check via bitref (or any other tool),

second key balance is 65.57999243
third 0.00010940

seems like greater numbers are flawed somehow?

You picked a unusable address (ripemd160 hash is 0x0000000000..., that's just lost coins) with more than 50000 utxos attached to it (I count 52057 utxos while blockchain.info only count 51302). Honestly, it will be hard to debug this one, as I don't know how blockchain.info fills its database.

By the way, I don't think there is a problem with big numbers. Other balances seems ok:

Code:
$ grep 1111116d87CjjDyP8SF5v1LTvUq22VFg balances.out
1111116d87CjjDyP8SF5v1LTvUq22VFg;8957970093

$ curl -s https://blockchain.info/fr/rawaddr/1111116d87CjjDyP8SF5v1LTvUq22VFg|grep final_balance
    "final_balance":8957970093,

Another sample:

Code:
$ grep 336xGpGweq1wtY4kRTuA4w6d7yDkBU9czU balances.out
336xGpGweq1wtY4kRTuA4w6d7yDkBU9czU;4897336319144

$ curl -s https://blockchain.info/fr/rawaddr/336xGpGweq1wtY4kRTuA4w6d7yDkBU9czU|grep final_balance
    "final_balance":4897336319144,

Cheers

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
P.
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile
March 06, 2018, 08:24:28 AM
 #200

Thanks for explanation.
Another one is ..
there is one address that begins with 0e0 and few thousands of those starting with bc1. What does those mean?
T.
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 06, 2018, 09:01:29 AM
 #201

Thanks for explanation.
Another one is ..
there is one address that begins with 0e0 and few thousands of those starting with bc1. What does those mean?
T.

The 0e0 thing is something I didn't remove from output, and this is the obfuscation key of my database, and not an address. You can ignore it.

The bc1 addresses are bech32 addresses, introduced last year for segwit transactions. They are used in P2WPKH & P2WSH transactions.

Cheers.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
SoliDCoiNs
Jr. Member
*
Offline Offline

Activity: 112
Merit: 1


View Profile
March 07, 2018, 01:47:29 PM
 #202

Maybe someone has already done this and would like to share their results?
I think all of us would appreciate the effort!
Thanks!
erajaykumarrana
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile
March 13, 2018, 11:26:04 AM
 #203

I've generated a new dump for all balances as of today.

Enjoy: https://transfer.sh/12aVfO/balances_20180304.out.gz

Cheers.


friend can you tell me how you generated this list,  I have to generate it for dash coin....

I have seen your code on github... how can i compile it in visual studio 2017 on windows
do you parse chain state directory...
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 14, 2018, 06:17:37 AM
 #204

friend can you tell me how you generated this list,  I have to generate it for dash coin....

I have seen your code on github... how can i compile it in visual studio 2017 on windows
do you parse chain state directory...

I've used this tool https://github.com/mycroft/chainstate I worked on as you know, using Bitcoin Core 0.15.1's updated chainstate, on Linux.

Unfortunately, I've a bad news for you... First, I've no knowledge in Visual Studio and I'm pretty much sure you'll need to update the code a lot to make it compile.
The good news is that dashcore also merged the new chainstate db format (https://github.com/bitcoin/bitcoin/pull/10195) I'm parsing, so it would be possible that this tool works correctly against dashcore!

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 16, 2018, 10:41:53 AM
 #205

New dump for all bitcoin balances, as of today: balances.out.gz

I think I'll remove small balances in the next version of this dump, as this file is really big and there are way too much really small wallets.

Have a nice day !

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
bigman3912
Newbie
*
Offline Offline

Activity: 12
Merit: 0


View Profile
March 16, 2018, 10:49:21 AM
 #206

Thank you very much. so, i guess your chainstate parser still works?
btw, every balance is matter, even it equals 1 satoshi. Smiley file is not too big. it easily opens on a good pc.
LeonsBTT
Newbie
*
Offline Offline

Activity: 14
Merit: 0


View Profile WWW
March 16, 2018, 02:15:10 PM
 #207

What if a person has more than 1 account?

I mean what is the value of these files?

https://www.leons.io/
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 16, 2018, 02:17:13 PM
 #208

Thank you very much. so, i guess your chainstate parser still works?

Yup, it works great and until Bitcoin Core changes its internal db format, it will continue to work. It only takes a few minutes to generate & sort.

btw, every balance is matter, even it equals 1 satoshi. Smiley file is not too big. it easily opens on a good pc.

This is not a file size problem, but a bandwidth problem. As for now, I'm using a "free" service, but I would rather host it on my own server, but BW is expensive for free stuff like this.

Cheers.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 16, 2018, 02:19:41 PM
 #209

What if a person has more than 1 account?

I mean what is the value of these files?

Nobody can regroup all addresses of a single wallet.

If you don't value this information, you're free to not download it. Smiley

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
LeonsBTT
Newbie
*
Offline Offline

Activity: 14
Merit: 0


View Profile WWW
March 16, 2018, 02:23:40 PM
 #210

What if a person has more than 1 account?

I mean what is the value of these files?

Nobody can regroup all addresses of a single wallet.

If you don't value this information, you're free to not download it. Smiley

What I mean is that if I am a whale that hold 10% of total bitcoins for me it is very easy to have different accounts, adresses etc and divide my coins between them. In other words, What conclusions do you want to get using this data? Do you think that they will be reliable?

https://www.leons.io/
bigman3912
Newbie
*
Offline Offline

Activity: 12
Merit: 0


View Profile
March 16, 2018, 02:40:43 PM
 #211

Thank you very much. so, i guess your chainstate parser still works?

Yup, it works great and until Bitcoin Core changes its internal db format, it will continue to work. It only takes a few minutes to generate & sort.

btw, every balance is matter, even it equals 1 satoshi. Smiley file is not too big. it easily opens on a good pc.

This is not a file size problem, but a bandwidth problem. As for now, I'm using a "free" service, but I would rather host it on my own server, but BW is expensive for free stuff like this.

Cheers.

A few minutes? Whole core? That's really fast. When i tried to parse it with old "blockparser" i have 20% in 2 days and time was increased very fast every hour.

Can you share with me your chainstate parser? Wanna try it. Thanks.
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 16, 2018, 02:58:41 PM
 #212

A few minutes? Whole core? That's really fast. When i tried to parse it with old "blockparser" i have 20% in 2 days and time was increased very fast every hour.

Can you share with me your chainstate parser? Wanna try it. Thanks.

The source code is opensource, on github: https://github.com/mycroft/chainstate
It doesn't parse the blockchain. It just read the chainstate from Bitcoin Core. https://en.bitcoin.it/wiki/Data_directory#chainstate_subdirectory
The chainstate is the result of parsing the blockchain, and contains all unspent transactions for new transaction validation purposes. When a new block is recieved by Bitcoin core, it will update this database to remove spent transactions and fills in new unspent transactions.

As for now, the chainstate is a 3-4GB leveldb database, with ~35 millions records (I didn't check recently). My tool will just read this database, and for each record (which are unspent transactions), decode it and find out which is the address & value (unspent amount of bitcoin).
Then, with a set of scripts, I sort unique addresses & compute their final balance. The whole process takes ~ 10 minutes (and it is not optimized at all).

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
bigman3912
Newbie
*
Offline Offline

Activity: 12
Merit: 0


View Profile
March 16, 2018, 03:02:30 PM
 #213

A few minutes? Whole core? That's really fast. When i tried to parse it with old "blockparser" i have 20% in 2 days and time was increased very fast every hour.

Can you share with me your chainstate parser? Wanna try it. Thanks.

The source code is opensource, on github: https://github.com/mycroft/chainstate
It doesn't parse the blockchain. It just read the chainstate from Bitcoin Core. https://en.bitcoin.it/wiki/Data_directory#chainstate_subdirectory
The chainstate is the result of parsing the blockchain, and contains all unspent transactions for new transaction validation purposes. When a new block is recieved by Bitcoin core, it will update this database to remove spent transactions and fills in new unspent transactions.

As for now, the chainstate is a 3-4GB leveldb database, with ~35 millions records (I didn't check recently). My tool will just read this database, and for each record (which are unspent transactions), decode it and find out which is the address & value (unspent amount of bitcoin).
Then, with a set of scripts, I sort unique addresses & compute their final balance. The whole process takes ~ 10 minutes (and it is not optimized at all).

Understood. Will try it on my dual xeon server.
dxlmz01
Newbie
*
Offline Offline

Activity: 7
Merit: 0


View Profile
March 16, 2018, 08:04:11 PM
 #214

New dump for all bitcoin balances, as of today: balances.out.gz

I think I'll remove small balances in the next version of this dump, as this file is really big and there are way too much really small wallets.

Have a nice day !

Thanks alot, I appreciate all the effort you're putting into this thread


can i ask for a favor ? if its not too much to ask, of course ...

I need a dump of addresses with balances until block #337000, not further.
can you find some spare time in your schedule to provide that ? I will be very thankful.
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 16, 2018, 09:32:02 PM
 #215

New dump for all bitcoin balances, as of today: balances.out.gz

I think I'll remove small balances in the next version of this dump, as this file is really big and there are way too much really small wallets.

Have a nice day !

Thanks alot, I appreciate all the effort you're putting into this thread


can i ask for a favor ? if its not too much to ask, of course ...

I need a dump of addresses with balances until block #337000, not further.
can you find some spare time in your schedule to provide that ? I will be very thankful.

I can do this, but it would require a little work. Can you send me a PM about this (can't send you one, you're blocking messages from newbies like me Wink ) ?

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
dinhbiplus
Jr. Member
*
Offline Offline

Activity: 42
Merit: 1

Fake Everything


View Profile WWW
March 18, 2018, 09:03:36 PM
 #216

Can't you just sort the output?

Best Alexa & Hypestat Service
MELYWEB (https://melyweb.net)
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 18, 2018, 09:19:48 PM
 #217

Can't you just sort the output?

I think I could do this. Mind to submit a patch ?

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
erajaykumarrana
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile
March 19, 2018, 09:42:54 AM
 #218

A few minutes? Whole core? That's really fast. When i tried to parse it with old "blockparser" i have 20% in 2 days and time was increased very fast every hour.

Can you share with me your chainstate parser? Wanna try it. Thanks.

The source code is opensource, on github: https://github.com/mycroft/chainstate
It doesn't parse the blockchain. It just read the chainstate from Bitcoin Core. https://en.bitcoin.it/wiki/Data_directory#chainstate_subdirectory
The chainstate is the result of parsing the blockchain, and contains all unspent transactions for new transaction validation purposes. When a new block is recieved by Bitcoin core, it will update this database to remove spent transactions and fills in new unspent transactions.

As for now, the chainstate is a 3-4GB leveldb database, with ~35 millions records (I didn't check recently). My tool will just read this database, and for each record (which are unspent transactions), decode it and find out which is the address & value (unspent amount of bitcoin).
Then, with a set of scripts, I sort unique addresses & compute their final balance. The whole process takes ~ 10 minutes (and it is not optimized at all).


I think I could do this. Mind to submit a patch ?
[/quote]


frnd... can you please tell me the dependancy package to compile your softwre in ubuntu linux....
I have fresh install of linux ubuntu.... but there are so many errors when I tried to compile it using make....
can you please PM me(I cant send you message as u block newbie....)....

Please help me, i Need all the unspent addresses of many coins.... i dont need balance I just need addresses....
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 19, 2018, 09:57:19 AM
 #219

frnd... can you please tell me the dependancy package to compile your softwre in ubuntu linux....
I have fresh install of linux ubuntu.... but there are so many errors when I tried to compile it using make....
can you please PM me(I cant send you message as u block newbie....)....

Please help me, i Need all the unspent addresses of many coins.... i dont need balance I just need addresses....

I've sent you a PM with my email address so you can communicate privately, if you need to.

Which coins will you this information ?

The chainstate software is tied to Bitcoin Core (0.15+)'s chainstate format. If dash (or any other coin) is not using the same format, it won't work. Note that Bitcoin Core implemented this format in April last year, so it is most likely this software won't work.

I could take a look at DASH, it would require me a few days however.

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
starmyc
Member
**
Offline Offline

Activity: 154
Merit: 60

Software engineer


View Profile WWW
March 19, 2018, 11:49:54 AM
 #220

I could take a look at DASH, it would require me a few days however.

Ok, I was able to extract all current balances for Dash.
Have fun with this: https://transfer.sh/109sSU/balances.dash.out.gz

Software engineer.
Tip me if you find my help useful: 3QBRMM2CLUTd7hqL4T9Ja2wy6B1VkbXyZ3
bigman3912
Newbie
*
Offline Offline

Activity: 12
Merit: 0


View Profile