Hello I mean Public Key's. Can you modyfy your code pease ?
I don't have such skill, the documentation doesn't mention public key at all and Insight itself is no longer updated. I'm afraid you couldn't accomplish your goal with this method.
LoyceV post the code!
This works (on Linux) to display addresses that exist in both lists:
# Only once:
cat blockchair_bitcoin_addresses_latest.tsv | cut -f 1 | sort | uniq > alladdresseswithbalance.txt
# Option 1:
comm -12 alladdresseswithbalance.txt <(cat mylist.txt | sort | uniq) # fastest
# Option 2:
cat alladdresseswithbalance.txt <(cat mylist.txt | sort | uniq) | sort | uniq -d # 5 times slower
Option 1 takes 6 seconds on my old laptop, checking 300,000 addresses against 30 million addresses with balance.
4 pipeline? That's crazy, i never used more than 3 pipeline at once.