Logs - Allium Documentation Hub

Table Details

Property	Value
Table Name	`tron.raw.logs`
Table Status	Production-Ready
Unique Key	`transaction_hash`, `coalesce(cast(log_index as string), '-1')`
Clustering Key(s)	`to_date(block_timestamp)`
Search Optimization	`address`, `topic0`

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

The most common form of event logs today are TRC20 token transfer events. To learn more, please refer to the following articles:

Official TRON Documentation

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 Name	Data Type	Description
block_timestamp	TIMESTAMP_NTZ(9)	The time when the block that contains this log was included on the blockchain.
address	VARCHAR(34)	The address of the contract that emitted this log.
address_evm	VARCHAR(42)	The EVM address of the contract that emitted this log.
address_hex	VARCHAR(42)	The HEX address of the contract that emitted this log.
data	VARCHAR(16777216)	Unindexed data containing further information of the event, encoded in hex.
topic0	VARCHAR(66)	The keccak256 hash of a flattened event signature string.
topic1	VARCHAR(66)	First indexed topic of the event.
topic2	VARCHAR(66)	Second indexed topic of the event.
topic3	VARCHAR(66)	Third indexed topic of the event.
log_index	NUMBER(38,0)	The position of this log in the block that it belongs to. The first log has index 0.
transaction_hash	VARCHAR(66)	Unique identifier of the transaction that this log belongs to.
transaction_index	NUMBER(38,0)	The position of this transaction in the block that it belongs to. The first transaction has index 0.
transaction_from_address	VARCHAR(34)	The address of the sending party of this transaction.
transaction_from_address_evm	VARCHAR(42)	The address of the sending party of this transaction in EVM.
transaction_from_address_hex	VARCHAR(42)	The address of the sending party of this transaction in HEX.
transaction_to_address	VARCHAR(34)	The address of the receiving party of this transaction (could be a contract address).
transaction_to_address_evm	VARCHAR(42)	The address of the receiving party of this transaction in EVM.
transaction_to_address_hex	VARCHAR(42)	The address of the receiving party of this transaction in HEX.
block_number	NUMBER(38,0)	The length of the chain, in blocks.
block_hash	VARCHAR(66)	Unique identifier of the block that includes this log.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of the entry creation.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of the entry update.

EVM Raw Logs