How do I query on Ethereum Mainnet Snapshots? [Beginner]

So, I have been thinking of running a light node and learn how the ETH blockchain works. I started with GETH, but I also need a Beacon client for that. After doing some reading I realized a light node is way too slow, whereas a full node is too huge for my system.

I was thinking if there is a way to download a historic snapshot of the ETH Mainnet, and use it locally to query and explore data instead of always staying connected to the chain. I don't wanna use any third party API clients, I plan on doing this totally hands on. For starters, I want to try out basic stuff like what tokens are most actively exchanged between wallets, how many and what type of tokens are sent to the null address, what is the transaction frequency, account balance, gas prices etc.

Again, I am very new to this, I have used ETH wallets, interacted with smart contracts before but all of that was from an end user perspective. I now want to see how stuff works in the backend. Any help/advice would be greatly appreciated.

Thanks!