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.
For various reasons, I'm more interested in transaction history - e.g. "even if the balance is 0, has this public address ever occured on the blockchain?" - and for that you need more input than only Blockchair's list of public addresses that have a positive balance "now".
Blockchair also has
all outputs, but at 10 kB/s it's going to take a while. If you can get all addresses ever used from your own version of Bitcoin Core, you're good to go.