As an example, we'll look at ERC-20. ERC-20 tokens are fungible tokens that all follow a contract standard set by the Ethereum Foundation. To track daily balances, we need to first identify the transfers.
The main base Dune table we’ll use for this purpose is
erc20_ethereum.evt_Transfer which you can find via the data explorer.
In our case, we have broken down the Spell into a more modular series of spells:
- Reformatted transfers
- Daily aggregation of transfers
- Rolling sum of daily transfers
- Final daily balances for Ethereum ERC20 tokens