Topic: List of all Bitcoin addresses with a balance - page 11. (Read 8775 times)

AFAIK you don't need to download this if you run a node
on any bitcoind node you can run dumptxoutset command and then just parse it

and when https://github.com/bitcoin/bitcoin/pull/18689/ gets merged, you won't even need to parse it

I thought of another use: what if you wanted to know how many addresses might be ChipMixer chips? They have specific sizes of 1, 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 4096 or 8192 mBTC. A quick search (using yesterday's address list) shows:
1 mBTC: 266408 addresses
2 mBTC: 66301 addresses
4 mBTC: 30343 addresses
8 mBTC: 15695 addresses
16 mBTC: 8290 addresses
32 mBTC: 3894 addresses
64 mBTC: 1797 addresses
128 mBTC: 1167 addresses
256 mBTC: 595 addresses
512 mBTC: 259 addresses
1024 mBTC: 442 addresses
2048 mBTC: 120 addresses
4096 mBTC: 139 addresses
8192 mBTC: 59 addresses

I haven't seen this data yet. I've seen sites that sell historic data, but I'm not sure if they include exchange volumes.
And even if you do find it, the data must have come from the exchanges themselves, and some of them are known to provide fake data.

Nice job LoyceV.

You are good with these kind of data.

I am searching for historical volume data from exchanges, BTC pairs. I tried in coinmarketcap but I couldn't find there. Do you have any idea where I can find it?

For many users that will be true. I just offer one more option

In Ratimov's Russian translation, FontSeli asked how this can be useful for a normal person (thanks Google Translate). I'll answer this here.

I can think of several other uses:

• Say you have a list of your old Bitcoin addresses and want to know if they hold any balance. But you don't want to let any block explorer or Electrum server know which address you're looking at. By downloading all addresses, you can easily do a local search without anyone else knowing which address you're looking for.
• I've also seen cases where someone has an incomplete Bitcoin address, and wants to know if it's worth to pursue recovering the private key. Block explorers don't let you search for incomplete addresses. As a rediculous example, here are all funded addresses that contain "Loyce":

wget

As long as your download doesn't disconnect, I assume the file you're downloading doesn't change. However, one of my downloads got corrupted, so I now test each new .gz-file before sharing it, and before deleting the oldest one.

I thought it must have been OP_RETURN indeed, but didn't look into it.
As an easy "solution", I'll remove the 397,175 "addresses" that contain a "-" from Bitcoin_addresses_DATE.txt.gz. I won't change existing files for this, so updates start in about 2 days.

how did you download these files? i've tried a couple of times using my cloud downloader but each time it failed near the end. i suspected the file might have been removed or changed since it took nearly a day to download.

for some reason blockchair.com assigns these weird format addresses to any outscript that they see. this includes OP_RETURN outputs too which can be found in almost all of the coinbase transactions.
the last one in your list for example is a simple P2PKH script that starts with a garbage being pushed to the stack followed by an OP_DROP which makes the pushto virtually not-exist.
https://blockchair.com/bitcoin/transaction/48e7694b3de213e2ab36cfcfaaa3013a22e1a5dc28168772cb01be99f91a12fa

Background

The data
See addresses.loyce.club. I keep 18 snapshots of Blockchair's daily data.
Sample: blockchair_bitcoin_addresses_and_balance_DATE.tsv.gz (sorted by balance, highest first (in satoshis)):
This file is in TSV format. It's probably too large (30 million rows) to import into a spreadsheet.

I create a new file with all funded addresses, without balances, and without "weird" addresses (the ones with "-" in it).
Sample: Bitcoin_addresses_DATE.txt.gz (sorted in alphabetical order):
This file is in TEXT format. The first addresses are burn addresses, nobody can access those funds. The (incomplete) last address somehow really got funded.

Download speed should be around 1000 times faster than Blockchair. I don't offer uncompressed downloads.

How to use
The most likely use is to check a long list of Bitcoin addresses for a remaining balance.
On Linux, use this to find matching addresses (after extrating the compressed .gz file of course):

• Bitcoin_addresses_LATEST.txt: the extracted latest version downloaded from addresses.loyce.club.
• mylist.txt: your own list of addresses, one address per line.

This takes only seconds to check millions of addresses. If your text file has Microsoft formatting, you may need to use this instead:

If you want the balances of many addresses:

If you want to know the balance of a certain address, but you don't want any block explorer or SPV wallet on the planet to know you're looking for that address, you can use this:
This doesn't save the file on your local drive, stops downloading after the first match, and kills your Bash shell 5 minutes later (so no .bash_history gets saved). Note (January 12, 2021): I now realize my webserver could know when you stop downloading. If you don't want this, remove "-m1" from grep.
If you want to search more than one address, please download the file first.

If you want to create a brainflayer bloom filter: pbies wrote a guide.

Data retention and updates
I'll provide daily updates. I keep the latest 6 daily snapshots, and the latest 12 monthly snapshots. One a day (or once a month) I delete the oldest files.

New: Direct link to LATEST versions
blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz (currently 862MB)
Bitcoin_addresses_LATEST.txt.gz (currently 750 MB)

New: Keeping track of the total number of funded addresses
See total_number_of_funded_addresses.txt. Starting December 2020, I'll add a daily total address count to this list. Long-term, this might prove useful (or at least produce nice graphs).

Credits
Blockchair Database Dumps has a staggering amount of data, easily accessible (at 10 kB/s) with daily updates. All data presented in this topic comes from Blockchair.

No spam please.
Self-moderated against spam. Discussion and questions are welcome.

---

---

Related topics
Bitcoin block data available in CSV format
List of all Bitcoin addresses with a balance
List of all Bitcoin addresses ever used
[~500 GB] Bitcoin block data: inputs, outputs and transactions
[800 GB] Ethereum data