Bitcoin Forum

I was wondering if there was a way to retrieve all bitcoin public addresses with a non-zero balance.

You should be able to do it using this BlockParser (https://www.reddit.com/r/Bitcoin/comments/aab5uu/blockparser_a_way_to_get_the_balance_of_all/). Note that you will have to run a fully synchronised node with txindex set to 1.

this website have all bitcoin addresses and sorted https://bitkeys.work/?page=0  8)

if someone have an idea to crawl and extract the list text file  ???

it is possible  ;D
1- with idm go to tasks > add batch download>from 0 to 1000> ok (about 110MB) (50*1000=50k top bitcoin addresses)
concatenating all the htmls files in one html edit with notepad++ the final file and make sure to only keep the addresses in first column 

(you need to repeat this many times)

i did try this ... bored and stop :'(

I was digging history of my spent merit and found https://github.com/mycroft/chainstate (https://github.com/mycroft/chainstate) which parse UTXO from Bitcoin Core chainstate.
I think this is what you're looking for.


Possible if you have unlimited tons of time to be wasted, would you want to edit 500K HTML pages manually?

Thanks you quoting me!
The tool is still working great FYI, and https://balances.syndevio.com/ (https://balances.syndevio.com/) is still maintained with it too, for whoever might be insterested :-)

write/edit some python or C++ scripts  ;D

1-concat all the 500k HTML pages into one file (or 50k pages each time)
2-use some condition delete/keep all lines with/contain
3-sort and done

i did try this  ;D

As an aside, the FAQ at https://bitkeys.work/faq.php (https://bitkeys.work/faq.php) seems a bit...wrong and alarmist?

He's implying that you need 2^80 (~1e24) tries to get a 50% chance of "colliding with one of those keys" (using the birthday paradox). Which seems pretty bad given the current network hashrate of ~1e20 H/s.

But... I think you'd only be colliding with one of your other zillion collision attempts, not one of the relatively miniscule ~1e8 addresses actually used. Unless my math is wrong. *shrug*

(1eX = 1*10^X)

More info: https://download.wpsoftware.net/bitcoin-birthday.pdf (https://download.wpsoftware.net/bitcoin-birthday.pdf)

What you are looking for is the current UTXO set.

UTXO stands for Unspent Transaction Output.

This is the set of all the transaction outputs that can be spent.

I open-sourced the Bitcoin blockchain https://www.dolthub.com/repositories/web3/bitcoin (https://www.dolthub.com/repositories/web3/bitcoin). It's a little behind (will catch up soon to the head block) but you can easily query all wallets in SQL with it. CC this blog https://www.dolthub.com/blog/2022-06-01-free-the-sql-data/ (https://www.dolthub.com/blog/2022-06-01-free-the-sql-data/) for some ideas.

All this parsing is in fact unnecessary because @LoyceV has a project called List of all Bitcoin addresses with a balance (https://bitcointalk.org/index.php?topic=5254914.0) that is updated daily with address dumps from Blockchair.

It is merely a text file of addresses with balances next to them.

Very interesting, I was not aware of that. Usually what I do for my needs (if I need to check many addresses from program), is just to download snapshot with addresses/balances etc and load into postgresql database.
I will take a look at that project, if it save me some time, I would probably start using it.