Table Details
| Property | Value |
|---|---|
| Table Name | tron.staking.events |
| Table Status | Production-Ready |
| Unique Key | block_timestamp::date, unique_id |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | owner_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| event | VARCHAR(16777216) | Tron staking event type. Includes v1_stake, v1_unstake, v2_stake, v2_unstake, v2_cancel_unstaking, v2_withdraw_unstaked, claim_reward, and others. |
| staker | VARCHAR(16777216) | Tron address that initiated the staking transaction. |
| owner_address | VARCHAR(16777216) | Address of the token or position owner. In NFT contexts, the wallet that holds the token; in staking contexts, the account that initiated the stake. |
| receiver_address | VARCHAR(16777216) | Recipient address of a Tron staking transaction. May equal owner_address for self-delegation. |
| raw_amount | VARCHAR(16777216) | Token amount in the smallest indivisible unit (not decimal-adjusted). Same concept as amount_raw — the column is named raw_amount in models that follow the raw_ prefix convention. |
| amount | FLOAT | Token amount normalized by the token’s decimal precision (amount_raw / 10^decimals). This is the human-readable value (e.g. 1.5 USDC rather than 1500000). |
| usd_amount | FLOAT | USD value of the token amount at the time of the event, computed using the hourly USD exchange rate. |
| frozen_duration | VARIANT | Duration (in days) for which TRX is locked/frozen in a staking transaction. |
| resource | VARCHAR(16777216) | Resource type selected for TRX staking — ENERGY (for smart contract execution) or BANDWIDTH (for transaction bandwidth). |
| contract_ret | VARCHAR(16777216) | Return status of the Tron smart contract call (e.g. SUCCESS, REVERT, OUT_OF_ENERGY). |
| transaction_type | VARCHAR(16777216) | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee. |
| transaction_hash | VARCHAR(64) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_hash | VARCHAR(64) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |