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.
is there any How-To available which explains in detail how to setup an own block explorer? I have few full-nodes running out there and I'd like to test this as a side-project of a local full-node. Currently I'm using the data files of LoyceV which I'm very satisfied with. But as mentioned before, it requires regularly downloading those huge files. So I'm looking forward to hear some helpful tips how to setup my own block explorer which I could use for querying addresses. I also did not understand why I would need an SPV or Electrum server for that purpose ?