Transactions

Transactions are cryptographically signed instructions from accounts.

An account will initiate a transaction to update the state of the TRON network.

Transactions always originate from an externally owned account (a smart contract can not initiate a transaction).

Learn more in the official Tron documentation here.

Sample Query

Daily transaction senders on Tron network between January to February 2023.

select 
    date(block_timestamp) as date,
    count(distinct from_address) as senders,
    count(*) as count_all
  from tron.raw.transactions
where 1=1 
    and date(block_timestamp) >= '2023-01-01' 
    and date(block_timestamp) <= '2023-02-01'
group by 1 
order by 1 desc

Table Columns

The example used here is a swap between USDC and TRX on SunSwap.

Column Name	Description	Example
block_timestamp	2023-05-17 09:59:15	2021-07-21 16:35:03
hash	Unique identifier of a transaction.	0x84e1db9240482a20090d5bc9b1a3a4a3fc503eb05d821b3e5c3cc8bd5d031938
nonce	The transaction nonce, unique to the wallet	0
transaction_index	1900-02-21 00:00:00	147
from_address	The address of the sending party of this transaction.	TQooBX9o8iSSprLWW96YShBogx7Uwisuim
from_address_evm	The address of the sending party of this transaction in EVM.	0xa2c2426d23bb43809e6eba1311afddde8d45f5d8
from_address_hex	The address of the sending party of this transaction in HEX.	41a2c2426d23bb43809e6eba1311afddde8d45f5d8
to_address	The address of the receiving party of this transaction (could be a contract address).	TXX1i3BWKBuTxUmTERCztGyxSSpRagEcjX
to_address_evm	The address of the receiving party of this transaction in EVM.	0xec5e8661f8855b1724d4f668f11ab722b4b3b74d
to_address_hex	The address of the receiving party of this transaction in HEX.	41ec5e8661f8855b1724d4f668f11ab722b4b3b74d
value	The amount of ether sent in this transaction, in wei.	0
gas	The maximum amount of gas allocated for this transaction in wei.	45,900
gas_price	Cost per unit of gas specified by the transaction in wei. The higher the gas price, the higher chance of getting included in a block.	140
input	The data sent along with the transaction.	0x99a1340900000000000000000000000000000000000000000000000000000010bb0ca82300000000000000000000000000000000000000000000000000000000ed8d4b1f0000000000000000000000000000000000000000000000000000000060f84cbb
block_number	51234241	32,136,671
block_hash	The hash of the block where this transaction was in. Null when it's a pending log.	0x0000000001ea5ddf0658451b173368cc9e952c809f5cef9dcc926bde08377b41
max_fee_per_gas	The maximum fee per gas that the transaction sender is willing to pay for this transaction (introduced in EIP1559)	0
max_priority_fee_per_gas	The maximum fee per gas the transaction sender is willing to give to validators (Proof of Stake) or miners (Proof of Work) to incentivize them to include their transaction (introduced in EIP1559)	0
receipt_cumulative_gas_used	The amount of gas used by this specific transaction alone.	1,496,960
receipt_gas_used	Gas consumed by the transaction in wei.	45,900
receipt_effective_gas_price	The total base charge plus tip paid for each unit of gas.	140
receipt_contract_address	The contract address created for contract creation, otherwise null
receipt_contract_address_evm	The contract address created for contract creation in EVM.
receipt_contract_address_hex	The contract address created for contract creation in HEX.
receipt_root	32 bytes of post-transaction stateroot (pre Byzantium).
receipt_status	Success status of the transaction. Either 1 (success) or 0 (failure).	1
log_count	Number of logs generated in this transaction.	3
transaction_type	The transaction type.	0
_created_at	Timestamp of the row creation.	2023-05-19 02:36:20
_updated_at	Timestamp of the row update.	2023-05-19 02:36:20