Trx Token Transfers - Allium Documentation Hub

Table Details

Property	Value
Table Name	`tron.assets.trx_token_transfers`
Table Status	Production-Ready
Unique Key	`block_timestamp::date`, `unique_id`
Clustering Key(s)	`block_timestamp::date, transfer_type`
Search Optimization	`from_address`, `to_address`

Transfers type included:

fees - TRX burnt from transactions / Tron-specific contract transactions such as creating a TRC10 tokens
value_transfer - movement of TRX tokens in most TRX transfers, excluding TRC10 tokens
internal_txn - TRX transferred via internal transactions (aka Traces)
contract_transfer - movement of TRX transferred to contracts
staking-related - movement of TRX to and from Tron staking
- claim_rewards - rewards claimed from staking
exchange-related - movement of TRX to and from Tron TRC10-TRX pools
participate_asset_issue - TRX transfers for participation in asset issuance

Table Columns

Column Name	Data Type	Description
from_address	VARCHAR(34)	Address where the token is being transferred from.
to_address	VARCHAR(34)	Address where the token is being transferred to.
token_address	VARCHAR(34)	Token address of the asset transferred.
token_name	VARCHAR(4)	Name of the asset transferred.
token_symbol	VARCHAR(3)	Token symbol of the asset transferred.
raw_amount	FLOAT	Amount of tokens transferred (unnormalized).
raw_amount_str	VARCHAR(16777216)	Amount of tokens transferred (unnormalized) in string to retain precision.
amount	FLOAT	Amount of token transferred, normalized.
amount_str	VARCHAR(16777216)	Amount of token transferred, normalized in string to retain precision.
usd_amount	FLOAT	The USD amount of the tokens at the time of the transfer.
usd_exchange_rate	FLOAT	The exchange rate used to calculate the `usd_amount`.
transaction_from_address	VARCHAR(34)	The address of the sending party of this transaction.
transaction_to_address	VARCHAR(34)	The address of the receiving party of this transaction (could be a contract address).
transfer_type	VARCHAR(16777216)	The type of transfers, depending on the blockchain. Typically include: `value_transfer`, `gas_burn`, `gas_payment_to_miner`.
block_timestamp	TIMESTAMP_NTZ(9)	The time when the block that contains this transaction was included on the blockchain.
block_number	NUMBER(38,0)	The block number that the corresponding transaction of this transfer belongs to.
unique_id	VARCHAR(16777216)	Unique ID generated for each transfer.
transaction_hash	VARCHAR(16777216)	Transaction hash that this transfer belongs to.
block_hash	VARCHAR(66)	The block hash that the corresponding transaction of this transfer belongs to.
transaction_index	NUMBER(38,0)	The position of this transaction in the block. The first transaction has index 0.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated.
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full refresh.

EVM Assets Trx Token Transfers

​Table Details

​Table Columns

​Related Docs

Table Details

Table Columns

Related Docs