As a newbie in the field I would like to know how can I find the most often executed smart contracts in the ethereum chain? Do I need to run a full node for that?
Thanks for your help!
A good start is ETH Gas Station's Gas Burner's list.
You can craft your own queries using Google's BigQuery Ethereum dataset.