For TRX credit debit, transaction and block hashes are not appended with 0x as they are from the Tron JSON RPC.

The tron.assets.trx_credit_debit table allows you to easily track the inflows and outflows of ether belonging to all addresses.

Table Columns

Column NameDescriptionExample
addressAddressT9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb
counterparty_addressCounterparty AddressTPe8F7umsULLhpdx587dhu1ZaXeJgGMhVH
raw_amountAmount of token credit/debit.17844760
amountAmount of token credit/debit, normalized.17.84476
transaction_hashTransaction hash resulting in the credit/debit.0f0c68517ae1f212e7cde531494bd1340989e5fd377759b26cfeb54a64f809d1
block_timestampTimestamp of the transaction.2021-02-05 11:03:00
block_numberBlock number.27380261
block_hashBlock hash.0000000001a1ca25bf2c19ae6777cf7fd521eeeace7250edfd4ef7e5bb8439a7
unique_idUnique id of the transaction.fees-0f0c68517ae1f212e7cde531494bd1340989e5fd377759b26cfeb54a64f809d1_debit