Now I am wondering how to get the historical balance of ETH and ERC-20 Tokens, like the web tool provided by etherscan. I attempted to add all the transactions on Etherscan to get the historical ERC-20 balances but some of the balances are less than zero which is impossible.
For example, considering address 0x3CC3AE64f26C8FA893358E5AE7717a0D001C0940 and token contract (Aura) 0xC0c293ce456fF0ED870ADd98a0828Dd4d2903DBF, this address received 1,014.571495152404966172 Aura on May-01-2023 as shown by tx 0xe5213a18e203f51f76f36f86a0c63eb7b69867eee80e29b0c577073ee1f1e6d3. However, the web tool shows that on May-03-2023 is zero but on May-02-2023 is 1,014.571495152404966172. But I haven't found any tx that pays 1,014.571495152404966172 Aura on May-02-2023 or May-03-2023. So I am wondering why the web tool shows that on May-03-2023 is zero.
I appreciate your answers and help!