tron.transactions

Tron transaction records — sender, recipient, contract calls, fees, and execution results.

Table Description

The transactions table contains information about all transactions on the Tron blockchain. Each row represents a single transaction and includes information such as block number, hash, timestamp, sender, recipient, value, gas, gas price, and more. Transactions are the fundamental unit of interaction with the Tron blockchain. Transactions are created by users and are used to send value, deploy smart contracts, and interact with smart contracts.

Table Schema

Column	Type	Description
block_time	timestamp(3)	The exact UTC timestamp when the block containing this transaction was added to the chain
block_number	bigint	The sequential number of the block containing this transaction
value	uint256	Amount of TRX sent from sender to recipient, measured in sun (1 TRX = 10^6 sun)
gas_limit	bigint	Maximum number of energy units this transaction can consume
gas_price	bigint	Price per unit of energy for this transaction, denominated in sun
gas_used	bigint	Actual amount of energy units consumed by this transaction’s execution
max_fee_per_gas	bigint	Maximum total amount per energy unit the initiator is willing to pay
max_priority_fee_per_gas	bigint	Maximum additional fee per energy unit the initiator is willing to pay as a tip
priority_fee_per_gas	bigint	Actual additional fee per energy unit paid as a tip
nonce	bigint	Sequential number representing the count of transactions sent from the sender’s address
index	bigint	Position of this transaction within its containing block
success	boolean	Whether the transaction executed successfully (true) or failed (false)
from	varbinary	Address of the account that initiated and signed this transaction
to	varbinary	Address of the recipient account or contract for this transaction
block_hash	varbinary	Unique identifier (hash) of the block containing this transaction
data	varbinary	Input data for the transaction, which may include function calls or contract interaction data
hash	varbinary	Unique identifier (hash) of this specific transaction
type	varchar	Type of transaction indicating its structure and fee mechanism
access_list	array(row(address varbinary, storagekeys array(varbinary)))	List of addresses and storage keys the transaction plans to access, used for energy optimization
block_date	date	The UTC date of the block in which this transaction was included

Table Sample

Examples

Show all transactions sent by a specific address

select * 
from tron.transactions where "from" = 0x50A1b5c358F8D34F0d35aA2f10742c46054E247e

Count the number of transactions per block

SELECT 
    block_number, 
    COUNT(*)
FROM tron.transactions
GROUP BY 1
ORDER BY 1 DESC
LIMIT 10

Show the top 10 transactions with the highest gas price

SELECT 
    hash, 
    gas_price
FROM tron.transactions
ORDER BY gas_price DESC
LIMIT 10