Thanks, this explains why the pubkey for those addresses is known without sending a transaction:
I think P2PKH was used as a convenient way for people to make transactions, as it allowed you to use addresses instead of passing around your public key (which is longer).
Can you prepare another list with all addresses with known pubkey and positive balance in the same format as you did before?
If you can get me an example showing what part of the
block data you need, I can get it for you. See
this post for a sample of the data.
Please edit your post instead of making 2 posts in a row, see forum rules.