ERC20 Balances

Historical ERC20 balances of all addresses at every block height.

We only use CEX USD prices to estimate the usd_amount. This has the benefit of excluding scam tokens, but some defi tokens might not be covered.

ERC20 balances table contains the ERC20 balances of all addresses, at every block height. Use this table to easily plot the change in the balance of ERC20 tokens for an address or a group of addresses over time.

Sample Query

Getting the ERC20 Balances of USDC Token from an address over time.

select * from ethereum.assets.erc20_balances
where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy
and token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC Token Address
order by block_number desc 

Table Columns

Last updated