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:

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

Last updated