Table Details
| Property | Value |
|---|---|
| Table Name | tron.assets.trc10_token_transfers |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | token_id, from_address, to_address |
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_id | VARCHAR(134217728) | Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Each unique token_id within a collection represents a distinct asset. |
| token_name | VARCHAR(134217728) | Name of the asset transferred. |
| token_symbol | VARCHAR(134217728) | Token symbol of the asset transferred. |
| raw_amount_str | VARCHAR(134217728) | Amount of tokens transferred (unnormalized) in string to retain precision. |
| raw_amount | FLOAT | Amount of tokens transferred (unnormalized). |
| amount_str | VARCHAR(134217728) | Amount of token transferred, normalized in string to retain precision. |
| amount | FLOAT | Amount of token transferred, normalized. |
| 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). |
| transaction_hash | VARCHAR(64) | Transaction hash that this transfer belongs to. |
| transfer_type | VARCHAR(134217728) | 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. |
| block_hash | VARCHAR(64) | The block hash that the corresponding transaction of this transfer belongs to. |
| unique_id | VARCHAR(134217728) | Unique ID generated for each transfer. |
| _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. |