Spellbook Examples

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