You'll likely be working with tokens that are fungible (erc20) and nonfungible (erc721 and erc1155) a lot in your analysis. There are a couple tables that are must knows for this:
tokens.erc20: contains useful information such as the token
decimalsfor any given
contract_address, the latter of which is needed to get the actual amount from raw amounts in onchain data.
tokens.nft: contains the collection
symbolfor any given
These tables are usually joined on
contract_address at the end of a query to make everything more human readable.
If you're looking for how to calculate native token balances like ethereum (ETH) balances then check out this guide