ERC20 Credit Debit

Credit and debit entries of all addresses for every ERC20 token transfer.

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.

The ERC20 credit debit table allows you to easily track the inflows and outflows of every ERC20 token belonging to all addresses.

Sample Query

Getting the ERC20 Credit Debit of USDC tokens of an address.

This will provide an overview of all the in and outflows of an ERC20 token of interest to a wallet.

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

Table Columns

Last updated