[Question] Fast way to check bulk address bitcoin balance

[DanielHoffman]

Hi i want to check a bulk addresses balance, actually i use request.get in python way with blockstream but it's too slow (around 100 addresses in 46 seconds)

Really appreciate.

[1714244820]

1714244820

[1714244820]

1714244820

[1714244820]

1714244820

[1714244820]

1714244820

[Yamane_Keto]

you can try  https://blockchair.com/API for a limit of 1,000 calls per day Addresses per request (25k) Requests per minute ( 30 MIn) and If it is not enough, you can subscribe to their paid services according to the prices https://blockchair.com/api/plans

if you care about Requests per minute only try blockonomics.co as you can get 100 address every 2 min.
If you tell me specifically what you are looking for, I may give you better options, but https://blockchair.com provides excellent service and diverse options.

[seek3r]

Using requests.get is indeed very slow.

To check the balance of Bitcoin addresses in bulk, you would want an API that supports batch requests.
This would speed up the whole process since you can query multiple addresses within a single API call. The Blockchain.com API supports batch requests for address balances.

Code:

import requests

def fetch_balances(addresses):
    address_list = '|'.join(addresses)

    api_endpoint = f'https://blockchain.info/balance?active={address_list}'

    response = requests.get(api_endpoint)
    data = response.json()

    for address, info in data.items():
        balance = info['final_balance']
        print(f"Address: {address}, Balance: {balance} ")

addresses = ['address1', 'address2', 'address3', ...]

fetch_balances(addresses)

A simple python script that would help you to fetch the balances of multiple addresses. The output would be in satoshis due to API of Blockchain.com

[albert0bsd]

Hi i want to check a bulk addresses balance, actually i use request.get in python way with blockstream but it's too slow (around 100 addresses in 46 seconds)

Why people always want to do this? It is always slow.

The correct way to do this faster is download an updated list of address with balance List of all Bitcoin addresses with a balance

Then load that file into a database/bloom filter or some other custom method.

Check your list against that method.

WIth this way you can be able to check million of address in less than a second

[bitmover]

I think the problem with those free api is that you might even get blocked doing 100 requests in less than a minute.

I made this javascript tool which allows you to do search for address balances, but it can't handle 100 addresses  (I even used a try/catch method with a seocnd api when you get to api request limits)

Take a look

https://bitcoindata.science/bitcoin-balance-check

Hi i want to check a bulk addresses balance, actually i use request.get in python way with blockstream but it's too slow (around 100 addresses in 46 seconds)

Why people always want to do this? It is always slow.

The correct way to do this faster is download an updated list of address with balance List of all Bitcoin addresses with a balance

Then load that file into a database/bloom filter or some other custom method.

Check your list against that method.

WIth this way you can be able to check million of address in less than a second

This is not faster than 46 seconds (as you have to download a huge file)... and the data might not be updated.

[albert0bsd]

This is not faster than 46 seconds (as you have to download a huge file)... and the data might not be updated.

Well that is true the data may bot be updated, but it is a good point to start no? If someone do this he can keep updated their database with other sources scripts and this may avoid all  external web APIs limits.

About the 46 Seconds... it is not bvious?? The time that i mention is after download and process the data.

[bitmover]

This is not faster than 46 seconds (as you have to download a huge file)... and the data might not be updated.

Well that is true the data may bot be updated, but it is a good point to start no? If someone do this he can keep updated their database with other sources scripts and this may avoid all  external web APIs limits.

About the 46 Seconds... it is not bvious?? The time that i mention is after download and process the data.

It is amazing to use this file, especially for privacy purposes. As he is looking all addresses,  nobody knows which one is his.

But data probably don't get updates in every block (like a block explorer). And looks like op is looking for a performance boost

[CryptoDeivid]

This is not faster than 46 seconds (as you have to download a huge file)... and the data might not be updated.

Well that is true the data may bot be updated, but it is a good point to start no? If someone do this he can keep updated their database with other sources scripts and this may avoid all  external web APIs limits.

About the 46 Seconds... it is not bvious?? The time that i mention is after download and process the data.

This time may vary depending on the specific data being used and the processing involved, I thing, but 46 seconds is a relatively short amount of time.

[yhiaali3]

There are many sites that provide this service for free or paid. You can try this free site:

https://cointool.app/batchCheckBalance/btc

It gives good and fast results, and the other good thing about this site is that it gives aggregate address balance results for coins other than Bitcoin on many networks such as:
BTC, ETH, Arbitrum, BSC, Optimism, TRX, HECO, Solana, Polygon,.......etc

[albert0bsd]

And looks like op is looking for a performance boost

In that case a custom host like mempool.space can be installed to handle all the block chain data already parsed and processed in this way you can change your API end point to this localhost server without any restriction..

This time may vary depending on the specific data being used and the processing involved, I thing, but 46 seconds is a relatively short amount of time.

Once that the data is downloaded an proccessed the waiting time will be just small.

[Yamane_Keto]

Code:

import requests

def fetch_balances(addresses):
    address_list = '|'.join(addresses)

    api_endpoint = f'https://blockchain.info/balance?active={address_list}'

A simple python script that would help you to fetch the balances of multiple addresses. The output would be in satoshis due to API of Blockchain.com

The blockchain.info API has a long history of sudden shutdowns, in which you will not receive a notification or alert, and the support team responds slowly and may continue for several days without knowing the cause of the problem.
blockchair.com/API is better.

The correct way to do this faster is download an updated list of address with balance List of all Bitcoin addresses with a balance

It seems that addresses.loyce.club depends on the data that comes from blockchair_bitcoin_addresses_and_balance_DATE.tsv.gz. Therefore, even if you download this file and try to manage the database and then create the API, you are accessing the indirect blockchair/API, which I think would be slower, if If you have the resources, buy a paid service.

[seek3r]

A simple python script that would help you to fetch the balances of multiple addresses. The output would be in satoshis due to API of Blockchain.com
The blockchain.info API has a long history of sudden shutdowns, in which you will not receive a notification or alert, and the support team responds slowly and may continue for several days without knowing the cause of the problem.
blockchair.com/API is better.

But the OP asked for a solution with batch requests and afaik blockchair's API does not support this in a single API call. 
Blockchairs API typically works with individual queries for each address or transaction. This means you would need to send a separate request for each address you want to check, which can be less efficient than a batch request, especially for a large number of addresses.

An alternative to blockchain.com could be the Blockcypher API, but I have no experience with it.

[DanielHoffman]

Using requests.get is indeed very slow.

To check the balance of Bitcoin addresses in bulk, you would want an API that supports batch requests.
This would speed up the whole process since you can query multiple addresses within a single API call. The Blockchain.com API supports batch requests for address balances.

Code:

import requests

def fetch_balances(addresses):
    address_list = '|'.join(addresses)

    api_endpoint = f'https://blockchain.info/balance?active={address_list}'

    response = requests.get(api_endpoint)
    data = response.json()

    for address, info in data.items():
        balance = info['final_balance']
        print(f"Address: {address}, Balance: {balance} ")

addresses = ['address1', 'address2', 'address3', ...]

fetch_balances(addresses)

A simple python script that would help you to fetch the balances of multiple addresses. The output would be in satoshis due to API of Blockchain.com

Thanks but already do check balance in same 50 seconds  , honestly i want to do this very fast but it's okay

[albert0bsd]

Thanks but already do check balance in same 50 seconds  , honestly i want to do this very fast but it's okay

You are very lazy, you omit a lot of good answers.

[btc_enigma]

Feel free to see the following github repo that uses several blockexplorer APIs to check address balances

https://github.com/xylevy/BTCSteroids


PS: Blockonomics API actually allows to lookup multiple addresses in one call and should be quite useful for this task

[apogio]

Another solution to the problem:

Look into LoyceV's datasets: https://bitcointalk.org/index.php?topic=5254914.0

1. Download the daily data from there (it includes every address that has a balance).
2. Import them in a DB
3. Set your code to ask the DB if it includes the address you want. This will be much faster.

Optional tip: If you import batch addresses from the DB into a hashmap then you can check if it contains the address ULTRA FAST.



EDIT: It has already been mentioned by Yamane_Keto & albert0bsd above.

[albert0bsd]

Another solution to the problem:
...

Do you read all the posts before reply?

...
The correct way to do this faster is download an updated list of address with balance List of all Bitcoin addresses with a balance
...

OP is a lazy newbie, he want the code already done, just to run in one-click, he is not developer, maybe he doesn't know what a hashmap or a bloom filter is... if you see he only reply to the person who actually offer some code snippet

[apogio]

Do you read all the posts before reply?

I edited my post above and explained you have already mentioned it. I didn't carefully read your post, sorry.

OP is a lazy newbie, he want the code already done, just to run in one-click, he is not developer, maybe he doesn't know what a hashmap or a bloom filter is... if you see he only reply to the person who actually offer some code snippet

Ok, but OP can also import the file from LoyceV's website to an excel or something else and do the process manually. Excel would crash, now that I think about it.

In fact, OP wants something that can't be done with just one click.

[LoyceV]

The correct way to do this faster is download an updated list of address with balance List of all Bitcoin addresses with a balance

Then load that file into a database/bloom filter or some other custom method.

This is what I would use to quickly check millions of addresses:

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):

Code:

comm -12 Bitcoin_addresses_LATEST.txt <(cat mylist.txt | sort | uniq)

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

This is not faster than 46 seconds (as you have to download a huge file)... and the data might not be updated.

Three things:
1. The server can spit out that file within 46 seconds
2. OP mentioned "bulk", and I don't consider his 100 address test to be bulk.
3. The data is updated daily. I assume OP is trying to brute-force Bitcoin addresses, in which case that doesn't matter.

Even if it takes a few minutes to download, after that you can check billions of addresses per hour.

@OP: what are you trying to accomplish?

[apogio]

3. The data is updated daily. I assume OP is trying to brute-force Bitcoin addresses, in which case that doesn't matter.

Are there still people trying to brute-force keys? I am amazed...