ETH Credit Debit

Credit and debit entries of all addresses for all ether transfers.

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.

Column Name	Description	Example
address	Address of the account that was credited or debited value amount of ETH	0x274db056083b9495fa75a1d3bdd2ae2ff9dd3a99
counterparty_address	The address of counter party of this credit or debit transfer.	0xa160cdab225685da1d56aa342ad8841c3b53f291
raw_amount	Amount of ETH in wei	99610090438117500000
raw_amount_str	Amount of ETH in wei in string.	99610090438117450000
amount	Amount of ether.	99.610090438
amount_str	Amount of ether in string.	99.6100904381174
usd_amount	The amount of ether moved, in $USD.	152078.709475491
usd_exchange_rate	The exchange rate used to calculate the usd_value.	1526.74
transfer_type	Type of transfers. Includes value_transfer, gas_payment_to_mine, gas_burn	value_transfer
transaction_hash	Transaction hash that this transfer belongs to.	0xf74991ca22457a054af65fef2112df568dcabb0400db4e312ad02cf13a8bdbb3
block_timestamp	The timestamp of the block that the corresponding transaction of this transfer belongs to. This is also the timestamp when this transfer occurred.	44945.3816550926
block_number	The block number that the corresponding transaction of this transfer belongs to.	16439864
block_hash	The block hash that the corresponding transaction of this transfer belongs to.	0xbf90ceea5cd19fea1948bce3d3c0f6a635526a22f5f3ea6a49b8cae4c205a853
unique_id	Unique id generated to each transfer. Includes trace call, transaction_hash, credit and debit transaction type.	trace-call_0xf74991ca22457a054af65fef2112df568dcabb0400db4e312ad02cf13a8bdbb3_2_1_debit