ETH Credit Debit

The ETH credit debit table allows you to easily track the inflows and outflows of ether belonging to all addresses.

ETH can be transferred across wallets in different ways:

• Direct transfers like in this transaction

• Indirect transfers through a router, like the routing of ETH from Tornado.Cash pool in this transaction

​

How is ethereum.assets.credit_debit different from ethereum.raw.transactions ?

• While transactions table includes the value of ETH in direct transfers, ETH transferred via the smart contract router will not be reflected in the value field

-- "value" field will be 0 for Router directed transaction

select * from ethereum.raw.transactions

where hash = '0xf74991ca22457a054af65fef2112df568dcabb0400db4e312ad02cf13a8bdbb3' -- Tornado Cash Routed Txn

• In contrast, credit_debit table will show all ETH transferred.

  • value_transfer from the Tornado.Cash pool to the recipient

  • gas_payment_to_miner from the transaction initiator to the miners and;

  • gas_burn from the transaction

-- The amount field includes the credit and debit ETH amounts 

select * from ethereum.assets.eth_credit_debit

where transaction_hash = '0xf74991ca22457a054af65fef2112df568dcabb0400db4e312ad02cf13a8bdbb3' -- Tornado Cash Routed Txn

order by unique_id desc

​

Table Columns

Using the ETH transfer from Tornado.Cash as an example.