Pages:
Author

Topic: Quick balance check - page 2. (Read 461 times)

legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
October 14, 2022, 05:42:07 AM
#11
The fastest solution would be to download daily dump of founded addresses (from blockchair or http://addresses.loyce.club/ ), load into local database (for example postgresql) and then have have a program which launches queries to your database.
The fastest solution is this:
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. If your text file has Microsoft formatting, you may need to use this instead:
Code:
comm -12 Bitcoin_addresses_LATEST.txt <(cat mylist.txt | fromdos | sort | uniq)
But, that only gets you a list of funded addresses, not their balances. I'll cook something up:
Code:
grep -f mylist.txt blockchair_bitcoin_addresses_and_balance_LATEST.tsv
This is a bit slower and eats RAM: 500,000 input addresses uses 1.5 GB and took 50 seconds. You could mix it with the earlier command to only search the balance for addresses that aren't empty.

I don't know exactly what you want, you ask question: how to check the balance for thousands of public addresses.
the loyce link only has data address which you can't check the address that you want.
See the explanations on List of all Bitcoin addresses with a balance.
hero member
Activity: 868
Merit: 737
October 13, 2022, 11:15:58 PM
#10
There are some sites where you can check the balance of multiple addresses how about this one below
- https://awebanalysis.com/en/bitcoin-multiple-address-check-balance/
That site uses a captcha, look hard when opening using TOR.
I tried opening that website on Tor Browser and didn't face any captcha or security check
I mean captcha like this,


This website looks old and according to it, the last update was back in 2020. I'd not use it if there is a better alternative out there.
oh, I don't know that, I just found that link on bitmover post.

I've chosen addresses and balances from:

http://addresses.loyce.club/
I don't know exactly what you want, you ask question: how to check the balance for thousands of public addresses.
the loyce link only has data address which you can't check the address that you want.
full member
Activity: 244
Merit: 126
October 13, 2022, 04:53:17 PM
#9
I've chosen addresses and balances from:

http://addresses.loyce.club/
legendary
Activity: 2170
Merit: 1789
October 13, 2022, 09:40:01 AM
#8
This website looks old and according to it, the last update was back in 2020. I'd not use it if there is a better alternative out there.

That site uses a captcha, look hard when opening using TOR.
I tried opening that website on Tor Browser and didn't face any captcha or security check
I think he is referring to the captcha check before you can proceed with the balance checking, not the web security check itself.
legendary
Activity: 2870
Merit: 7490
Crypto Swap Exchange
October 13, 2022, 07:46:56 AM
#7
Is there a way (API?) to quickly check balance for thousands of public addresses?
Locally (Bitcoin Core) or via any market API?

FYI, Bitcoin Core isn't suitable for your needs. It lacks address index, so you'll need to use scantxoutset or import the address on wallet then rescan whole blockchain which take some time. Many block explorer offer API, but i doubt the free option is generous enough to let you get details of thousand address within short time.

There are some sites where you can check the balance of multiple addresses how about this one below
- https://awebanalysis.com/en/bitcoin-multiple-address-check-balance/
That site uses a captcha, look hard when opening using TOR.

I tried opening that website on Tor Browser and didn't face any captcha or security check

Another solution would be to host everything locally - full node, spv server like electrs and then rpc explorer.

Take note depending on which software you use, you only don't to run all 3. For example, Bcoin (full node with address index) or Bitcoin Core and Mempool.space.
legendary
Activity: 1568
Merit: 6660
bitcoincleanup.com / bitmixlist.org
October 13, 2022, 03:32:05 AM
#6
The fastest solution would be to download daily dump of founded addresses (from blockchair or http://addresses.loyce.club/ ), load into local database (for example postgresql) and then have have a program which launches queries to your database. That way you are independent of network connection, API limitations etc. In long term perspective, this is the best solution (of course you need to update your database from time to time).

Another solution would be to host everything locally - full node, spv server like electrs and then rpc explorer.

This is what I'd suggest: a local block explorer that provides the API OP needs.
The dumps from loyce.club are big (over 1GB zipped) and I find downloading them on a daily basis counterproductive.

Why not just a database, if you're going to be dumping data and blocks onto the hard disk? But not SQLite or some other db-as-file.

At least you will be able to make comprehensive SQL queries, make graphs (using something like PowerBI) and scale to many computers if you run out of disk space.
legendary
Activity: 3668
Merit: 6382
Looking for campaign manager? Contact icopress!
October 13, 2022, 03:29:36 AM
#5
The fastest solution would be to download daily dump of founded addresses (from blockchair or http://addresses.loyce.club/ ), load into local database (for example postgresql) and then have have a program which launches queries to your database. That way you are independent of network connection, API limitations etc. In long term perspective, this is the best solution (of course you need to update your database from time to time).

Another solution would be to host everything locally - full node, spv server like electrs and then rpc explorer.

This is what I'd suggest: a local block explorer that provides the API OP needs.
The dumps from loyce.club are big (over 1GB zipped for the addresses with funds) and I find downloading them on a daily basis counterproductive.
legendary
Activity: 952
Merit: 1367
October 13, 2022, 03:18:28 AM
#4
Is there a way (API?) to quickly check balance for thousands of public addresses?
Locally (Bitcoin Core) or via any market API?

The fastest solution would be to download daily dump of founded addresses (from blockchair or http://addresses.loyce.club/ ), load into local database (for example postgresql) and then have have a program which launches queries to your database. That way you are independent of network connection, API limitations etc. In long term perspective, this is the best solution (of course you need to update your database from time to time).

Another solution would be to host everything locally - full node, spv server like electrs and then rpc explorer.
hero member
Activity: 868
Merit: 737
October 12, 2022, 10:33:09 PM
#3
There are some sites where you can check the balance of multiple addresses how about this one below
- https://awebanalysis.com/en/bitcoin-multiple-address-check-balance/
That site uses a captcha, look hard when opening using TOR.
I found another one that doesn't use it, besides that not only bitcoin, we can check also the balance ETH, BCH dan BTG and set a delay if check a large number of addresses
www.homebitcoin.com
legendary
Activity: 3248
Merit: 2971
Block halving is coming.
October 12, 2022, 07:20:53 PM
#2
There are some sites where you can check the balance of multiple addresses how about this one below
- https://awebanalysis.com/en/bitcoin-multiple-address-check-balance/

Or if you preferred API calls then blochchain.info still has some API calls that you can use for checking multiple addresses.

Read the answer from this post below
- https://bitcoin.stackexchange.com/questions/62018/blockchain-info-multi-address-lookup

It's old but still works.
full member
Activity: 244
Merit: 126
October 12, 2022, 07:03:33 PM
#1
Is there a way (API?) to quickly check balance for thousands of public addresses?
Locally (Bitcoin Core) or via any market API?
Pages:
Jump to: