Skip to main content
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:

​
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 NameDescriptionExample
addressAddress of the account that was credited or debited value amount of ETH0x274db056083b9495fa75a1d3bdd2ae2ff9dd3a99
counterparty_addressThe address of counter party of this credit or debit transfer.0xa160cdab225685da1d56aa342ad8841c3b53f291
raw_amountAmount of ETH in wei99610090438117500000
raw_amount_strAmount of ETH in wei in string.99610090438117450000
amountAmount of ether.99.610090438
amount_strAmount of ether in string.99.6100904381174
usd_amountThe amount of ether moved, in $USD.152078.709475491
usd_exchange_rateThe exchange rate used to calculate the usd_value.1526.74
transfer_typeType of transfers. Includes value_transfer, gas_payment_to_mine, gas_burnvalue_transfer
transaction_hashTransaction hash that this transfer belongs to.0xf74991ca22457a054af65fef2112df568dcabb0400db4e312ad02cf13a8bdbb3
block_timestampThe 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_numberThe block number that the corresponding transaction of this transfer belongs to.16439864
block_hashThe block hash that the corresponding transaction of this transfer belongs to.0xbf90ceea5cd19fea1948bce3d3c0f6a635526a22f5f3ea6a49b8cae4c205a853
unique_idUnique id generated to each transfer. Includes trace call, transaction_hash, credit and debit transaction type.trace-call_0xf74991ca22457a054af65fef2112df568dcabb0400db4e312ad02cf13a8bdbb3_2_1_debit
⌘I