Do you still have a server running a full node?
Yes.
I never worked with a full node, but I can try to make an API for it that would allow such requests.
I don't think Bitcoin Core can do this directly, but there are some python scripts to dump address data. I think it comes from
chainstate, so I think it would also work on a pruned node.