• The transaction hash in this table contains a 0x prefix.

Logs (or event logs), is a way for smart contracts to communicate with the outside world by “documenting” small pieces of information. Event logs allow other people to know that something has happened without them having to query the contract directly.

The most common form of event logs today are TRC20 token transfer events.

To learn more, please refer to the following articles:

Sample Query&

Querying the event logs from the example given below.

select *

  from tron.raw.logs

where 1=1 

and transaction_hash ='0x84e1db9240482a20090d5bc9b1a3a4a3fc503eb05d821b3e5c3cc8bd5d031938'

Table Columns

The example used here is an event log of USDC transfers in a swap between USDC and TRX on SunSwap.

Column NameDescriptionExample
block_timestampThe time when the block that contains this log was included on the blockchain.2021-07-21 16:35:03
addressThe address of the contract that emitted this log.TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8
address_evmThe EVM address of the contract that emitted this log.0x3487b63d30b5b2c87fb7ffa8bcfade38eaac1abe
address_hexThe HEX address of the contract that emitted this log.413487b63d30b5b2c87fb7ffa8bcfade38eaac1abe
dataUnindexed data containing further information of the event, encoded in hex.0x00000000000000000000000000000000000000000000000000000000eb30ad7b
topic0The keccak256 hash of a flattened event signature string.0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef
topic1First indexed topic of the event.0x000000000000000000000000a2c2426d23bb43809e6eba1311afddde8d45f5d8
topic2Second indexed topic of the event0x000000000000000000000000ec5e8661f8855b1724d4f668f11ab722b4b3b74d
topic3Third indexed topic of the event.
log_indexThe position of this log in the block that it belongs to. The first log has index 0.72
transaction_hashUnique identifier of the transaction that this log belongs to.0x84e1db9240482a20090d5bc9b1a3a4a3fc503eb05d821b3e5c3cc8bd5d031938
transaction_indexThe position of this transaction in the block that it belongs to. The first transaction has index 0.147
transaction_from_addressThe address of the sending party of this transaction.TQooBX9o8iSSprLWW96YShBogx7Uwisuim
transaction_from_address_evmThe address of the sending party of this transaction in EVM.0xa2c2426d23bb43809e6eba1311afddde8d45f5d8
transaction_from_address_hexThe address of the sending party of this transaction in HEX.41a2c2426d23bb43809e6eba1311afddde8d45f5d8
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).TXX1i3BWKBuTxUmTERCztGyxSSpRagEcjX
transaction_to_address_evmThe address of the receiving party of this transaction in EVM.0xec5e8661f8855b1724d4f668f11ab722b4b3b74d
transaction_to_address_hexThe address of the receiving party of this transaction in HEX.41ec5e8661f8855b1724d4f668f11ab722b4b3b74d
block_numberThe length of the chain, in blocks.32,136,671
block_hashUnique identifier of the block that includes this log.0x0000000001ea5ddf0658451b173368cc9e952c809f5cef9dcc926bde08377b41
_created_atTimestamp of the row creation.2023-05-19 02:36:24
_updated_atTimestamp of the row update.2023-05-19 02:36:24