How can I get the wallet balance for an address with a volume of 200k plus transactions?

Question

I am trying to get the wallet balance for this address 0x389044F3ac7472060A0618116e3624A5f0f20F28 as of Aug 31 2022. In the past, I've been able to do so by getting the transaction history and subtracting transactions labelled as sent from incoming ones. This one presents a challenge as I am only able to access the last 100,000 transactions. I know there's got to be a more efficient way to do this.

Is there an API I could use to retrieve the entire transaction history (given its large volume)? Or even better would anyone know how to automate this entire process by retrieving the transaction history and then creating a script to add/subtract balances prior to Aug 31, 2022?

Would appreciate some help on this one. Been stuck for 3 days and I'm about to get chewed up at work if I do not figure out a way to solve this.

Answer 1

You could use Forge framework to fork the mainnet to a certain block height (check what block height was around Aug 31).

That way you can move up and down the history of the mainnet and see what balance that address had at each specific block.

It would look something like that:

pragma solidity ^0.8.0;

import "forge-std/Test.sol";

contract getAddressBalanceTest is Test {
 function getAddressBalance() public {
        vm.createSelectFork(vm.envString("ETH_RPC_URL"), YOUR_BLOCK_HEIGHT);
        address target = 0x389044F3ac7472060A0618116e3624A5f0f20F28;
        console.log("Target balance: ", target.balance);

Hope this helps!

Answer 2

You need the archive node. Every provider has an option for the archive node, it is usually of an extra cost. But you can start your node, using geth or erigon

./erigon --datadir D:/Erigon --chain mainnet --private.api.addr=127.0.0.1:9090 --prune=hrtc --prune.h.older=400000 --prune.r.older=400000 --prune.t.older=400000 --prune.c.older=400000

Then you can query blockchains data at any block. When you call balanceOf method, this actually queries the nodes latest block, but you can specify any of the block numbers in the past. This is the RPC method, all clients should support it. If you use Node.js there is the lib for this: web3js#methods-mymethod-call

Or the example for TypeScript with 0xweb library, which wraps web3js and adds additional tools, like getting the Block Number by Date

npm i 0xweb -g
0xweb init

import { Config } from '@dequanto/Config';
import { ERC20 } from '@dequanto-contracts/openzeppelin/ERC20';
import { BlockDateResolver } from '@dequanto/blocks/BlockDateResolver';
import { EthWeb3Client } from '@dequanto/clients/EthWeb3Client';

async function example () {
    await Config.fetch();

    let client = new EthWeb3Client();
    let dateResolver = new BlockDateResolver(client);
    let blockNumber = await dateResolver.getBlockNumberFor(new Date('2022-10-27T00:00:00Z'));

    let erc20 = new ERC20('0x<TOKEN>', client);
    let balanceOf = erc20.forBlock(blockNumber).balanceOf('0x<USER>');
    console.log('Balance on the date:', balanceOf);
}
example();