Tron Dataset
This is the Tron chain dataset provided by Nodit Datashare. You can review the table structure of the stored data, along with the primary keys and columns for each table. This information lets you understand the types and structure of data you can extract using Datashare.
Dataset
This is the Tron chain dataset available in Nodit Datashare. Select the dataset you need to extract data, and view the schema for each dataset in Data Schema.
| Table | Description |
|---|---|
account_meta | Account metadata |
blocks | Block data |
contracts | Contract data |
internal_transactions | Internal transaction data |
logs | Event log data |
logs_decoded | Event log data decoded using 4byte.directory |
native_holders | Native token holder data |
native_transfers | Native token transfer data |
sunswap_trades | SunSwap trade data |
sunswap_v1_5_tron_exchange | SunSwap v1.5 exchange address data |
sunswap_v1_tron_exchange | SunSwap v1 exchange address data |
sunswap_v2_tron_exchange | SunSwap v2 exchange address data |
sunswap_v3_tron_exchange | SunSwap v3 exchange address data |
system_contracts | System contract data |
transaction_info | Transaction execution information |
transactions | Transaction data |
trc10_meta | TRC-10 metadata |
trc10_transfers | TRC-10 transfer data |
trc1155_meta | TRC-1155 metadata |
trc1155_transfers | TRC-1155 transfer data |
trc20_meta | TRC-20 metadata |
trc20_transfers | TRC-20 transfer data |
trc721_inventories | TRC-721 inventory data |
trc721_meta | TRC-721 metadata |
trc721_transfers | TRC-721 transfer data |
Data Schema
The data schema for each table. For each column, you can review the type and description, as well as the table's Unique Key and the "Filterable Columns" available for filtering.
account_meta
Unique Key: address, block_number
Filterable Columns: address
| Column | Type | Description |
|---|---|---|
account_id | VARCHAR | The internal identifier for the account. |
creator_address | VARCHAR | The address that created this account. |
account_name | VARCHAR | The name assigned to the account. |
type | VARCHAR | The account type (e.g., Normal, AssetIssue). |
address | VARCHAR | The account address in Base58 format. |
lowercase_address | VARCHAR | The account address normalized to lowercase. |
evm_address | VARCHAR | The account address converted to EVM-compatible format. |
create_time | BIGINT | The Unix timestamp (in milliseconds) when the account was created. |
block_number | BIGINT | The number of the block in which this account was created. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
tx_id | VARCHAR | The ID of the transaction used to create the account. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
blocks
Unique Key: block_number
Filterable Columns: None
| Column | Type | Description |
|---|---|---|
block_id | VARCHAR | The unique identifier hash of the block. |
tx_trie_root | VARCHAR | The root hash of the trie structure combining all transactions in the block. |
parent_hash | VARCHAR | The hash of the previous block, forming the chain linkage. |
witness_address | VARCHAR | The address of the Super Representative (SR) that produced this block. |
version | BIGINT | The protocol version the block conforms to. |
account_state_root | VARCHAR | The root hash of the global account state trie after block processing. |
transactions | ARRAY(VARCHAR) | The list of transaction IDs included in the block. |
block_number | BIGINT | The sequential number indicating the block's position in the chain. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
contracts
Unique Key: address, block_number, tx_index
Filterable Columns: address, origin_address, internal_origin_address
| Column | Type | Description |
|---|---|---|
address | VARCHAR | The Base58 address of the deployed smart contract. |
lowercase_address | VARCHAR | The contract address normalized to lowercase. |
evm_address | VARCHAR | The contract address converted to EVM-compatible format. |
origin_address | VARCHAR | The address that originally deployed the contract. |
internal_origin_address | VARCHAR | The address that deployed the contract via an internal transaction. |
bytecode | VARCHAR | The executable bytecode of the contract. |
abi | VARCHAR | The ABI (Application Binary Interface) definition for interacting with the contract. |
name | VARCHAR | The name assigned to the contract. |
code_hash | VARCHAR | The hash of the contract bytecode. |
version | BIGINT | The version information of the contract. |
call_value | BIGINT | The amount of TRX sent at contract deployment. |
consume_user_resource_percent | BIGINT | The percentage of energy costs borne by the user when calling the contract. |
origin_energy_limit | BIGINT | The maximum energy limit per contract call set by the deployer. |
function_sighashes | ARRAY(VARCHAR) | The list of 4-byte signature hashes for functions defined in the contract. |
block_number | BIGINT | The number of the block in which the contract was deployed. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the contract deployment was produced. |
tx_id | VARCHAR | The ID of the contract deployment transaction. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
internal_transactions
Unique Key: hash
Filterable Columns: caller_address, transfer_to_address
| Column | Type | Description |
|---|---|---|
hash | VARCHAR | The unique identifier hash of the internal transaction. |
caller_address | VARCHAR | The contract or address that initiated the internal transaction. |
transfer_to_address | VARCHAR | The destination address that received assets via the internal transaction. |
note | VARCHAR | A memo or description attached to the internal transaction. |
rejected | BOOLEAN | Indicates whether the internal transaction was rejected (failed). |
extra | VARCHAR | Additional data included in the internal transaction. |
call_value_info | ARRAY(ROW(call_value BIGINT, asset_id VARCHAR)) | The list of assets (TRX or TRC-10) transferred via the internal transaction. |
internal_tx_index | BIGINT | The sequential position of the internal transaction within the parent transaction. |
block_number | BIGINT | The number of the block containing this internal transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this internal transaction was produced. |
tx_id | VARCHAR | The ID of the parent transaction containing this internal transaction. |
tx_index | BIGINT | The sequential position of the parent transaction within the block. |
logs
Unique Key: log_index, tx_id
Filterable Columns: address
| Column | Type | Description |
|---|---|---|
address | VARCHAR | The address of the smart contract that emitted the event. |
topics | ARRAY(VARCHAR) | The list of topic hashes used for event identification and indexing. |
data | VARCHAR | The ABI-encoded event parameter data. |
log_index | BIGINT | The sequential position of this log within the block. |
block_number | BIGINT | The number of the block containing this event log. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this event log was produced. |
tx_id | VARCHAR | The ID of the transaction that emitted this event. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
native_holders
Unique Key: address, block_number
Filterable Columns: address
| Column | Type | Description |
|---|---|---|
address | VARCHAR | The address of the account holding TRX. |
value | VARCHAR | The TRX balance held by this account. |
block_id | VARCHAR | The unique identifier of the block in which this snapshot was recorded. |
block_number | BIGINT | The number of the block in which this snapshot was recorded. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
native_transfers
Unique Key: internal_tx_index, block_number, tx_index
Filterable Columns: from_address, to_address
| Column | Type | Description |
|---|---|---|
from_address | VARCHAR | The address that sent TRX. |
to_address | VARCHAR | The address that received TRX. |
value | VARCHAR | The amount of TRX transferred. |
internal_tx_index | BIGINT | The internal sequential position of this transfer within the transaction. |
type | VARCHAR | The type of native transfer. |
exchange_id | BIGINT | The ID of the Exchange if this transfer is exchange-related. |
block_number | BIGINT | The number of the block containing this transfer. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this transfer was produced. |
tx_id | VARCHAR | The ID of the transaction containing this transfer. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
system_contracts
Unique Key: tx_id
Filterable Columns: None
| Column | Type | Description |
|---|---|---|
system_contract_type | VARCHAR | The type of system contract executed. |
block_number | BIGINT | The number of the block containing this system contract transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
tx_id | VARCHAR | The unique identifier of the transaction. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
abbr | VARCHAR | The abbreviation (ticker) of the asset. |
abi | VARCHAR | The ABI definition of the smart contract. |
account_address | VARCHAR | The target account address for the system contract operation. |
account_id | VARCHAR | The internal identifier of the target account. |
account_name | VARCHAR | The name of the target account. |
actives | VARCHAR | The list of active permissions set on the account. |
amount | BIGINT | The amount of TRX or assets used in the operation. |
asset_id | BIGINT | The ID of the TRC-10 asset involved in the operation. |
asset_name | VARCHAR | The name of the TRC-10 asset. |
balance | BIGINT | The balance of the account involved in the operation. |
brokerage | BIGINT | The reward distribution ratio of the Super Representative (SR). |
buy_asset_id | BIGINT | The TRC-10 ID of the asset to purchase in an exchange. |
buy_asset_quantity | BIGINT | The quantity of the asset to purchase in an exchange. |
bytecode | VARCHAR | The bytecode of the smart contract to deploy. |
call_asset_value | BIGINT | The amount of TRC-10 assets sent when calling the contract. |
call_value | BIGINT | The amount of TRX sent when calling the contract. |
code_hash | VARCHAR | The hash of the contract bytecode. |
consume_user_resource_percent | BIGINT | The percentage of energy costs borne by the user when calling the contract. |
contract_address | VARCHAR | The address of the smart contract targeted by the operation. |
count | BIGINT | The number of items related to the operation. |
data | VARCHAR | Data included in the system contract operation. |
description | VARCHAR | A description of the TRC-10 asset or account. |
end_time | BIGINT | The end time (in milliseconds) of a TRC-10 asset sale or specific operation. |
exchange_id | BIGINT | The ID of the Exchange targeted by the operation. |
expected | BIGINT | The expected output quantity or other expected value. |
first_asset_balance | BIGINT | The current balance of the first asset in the Exchange. |
first_asset_id | BIGINT | The TRC-10 ID of the first asset registered in the Exchange. |
free_asset_net_limit | BIGINT | The free bandwidth limit per TRC-10 asset holder. |
from_address | VARCHAR | The address that sent the asset. |
from_amount | BIGINT | The quantity of the asset sent in an exchange. |
frozen_amount | BIGINT | The quantity of frozen assets. |
frozen_balance | BIGINT | The frozen TRX balance. |
frozen_days | BIGINT | The TRX freeze duration in days. |
frozen_duration | BIGINT | The total TRX freeze period. |
frozen_supply | ARRAY(ROW(frozen_amount BIGINT, frozen_days BIGINT)) | The list of initially frozen supply amounts for TRC-10 assets. |
is_add_approval | BOOLEAN | Indicates whether the operation adds an approval. |
issuer_address | VARCHAR | The address of the account that issued the TRC-10 asset. |
lock | BOOLEAN | Indicates whether reward funds are locked. |
lock_period | BIGINT | The lock period for reward funds. |
name | VARCHAR | The name of the asset or contract. |
new_limit | BIGINT | The updated energy or bandwidth limit. |
new_public_limit | BIGINT | The updated public bandwidth limit. |
num | BIGINT | The numerator value of the TRC-10 asset's TRX exchange ratio. |
order | VARCHAR | The order or sequence information for the operation. |
order_id | VARCHAR | The unique identifier of the trade order. |
origin_address | VARCHAR | The address that originally called the system contract operation. |
origin_energy_limit | BIGINT | The maximum energy limit per contract call set by the deployer. |
owner | ROW(type VARCHAR, id BIGINT, permission_name VARCHAR, threshold BIGINT, parent_id BIGINT, operations VARCHAR, keys ARRAY(ROW(address VARCHAR, weight BIGINT))) | The owner permission information used for transaction signing. |
owner_address | VARCHAR | The address of the account that performed the system contract operation. |
parameters | VARCHAR | The list of network parameters to modify in a governance proposal. |
precision | BIGINT | The decimal precision of the TRC-10 asset. |
proposal_id | BIGINT | The unique number of the governance proposal. |
public_free_asset_net_limit | BIGINT | The total free bandwidth limit applied to all users in common. |
public_free_asset_net_usage | BIGINT | The current usage of the public free bandwidth limit. |
public_latest_free_net_time | BIGINT | The time at which the public free bandwidth was last used. |
quant | BIGINT | The quantity of assets injected into an exchange. |
receive_description | VARCHAR | A description of the receive details for a shielded transaction. |
receiver_address | VARCHAR | The destination address receiving the assets. |
resource | VARCHAR | The type of resource being frozen or delegated (BANDWIDTH or ENERGY). |
second_asset_balance | BIGINT | The current balance of the second asset in the Exchange. |
second_asset_id | BIGINT | The TRC-10 ID of the second asset registered in the Exchange. |
sell_asset_id | BIGINT | The TRC-10 ID of the asset to sell in an exchange. |
sell_asset_quantity | BIGINT | The quantity of the asset to sell in an exchange. |
spend_description | VARCHAR | A description of the spend details for a shielded transaction. |
start_time | BIGINT | The start time (in milliseconds) of a TRC-10 asset sale or specific operation. |
support | BOOLEAN | Indicates whether a governance proposal is supported. |
to_address | VARCHAR | The destination address receiving the assets. |
to_amount | BIGINT | The quantity of assets received in an exchange. |
total_supply | VARCHAR | The total supply of the TRC-10 asset. |
trx_hash | VARCHAR | The hash of the related TRX transaction. |
trx_num | BIGINT | The TRX quantity in the exchange ratio between a TRC-10 asset and TRX. |
type | VARCHAR | The type of system contract or operation. |
unfreeze_balance | BIGINT | The TRX balance subject to an unfreeze operation. |
update_url | VARCHAR | The URL for updating asset or proposal-related information. |
url | VARCHAR | The URL associated with the asset or account. |
vote_address | VARCHAR | The address of the Super Representative (SR) that received votes. |
vote_score | BIGINT | The vote score assigned to the SR. |
votes | ARRAY(ROW(vote_address VARCHAR, vote_count BIGINT)) | The list of SR election votes, where each entry contains a vote address and vote count. |
witness | ROW(type VARCHAR, id BIGINT, permission_name VARCHAR, threshold BIGINT, parent_id BIGINT, operations VARCHAR, keys ARRAY(ROW(address VARCHAR, weight BIGINT))) | The witness permission information used for transaction signing. |
transaction_info
Unique Key: tx_id
Filterable Columns: owner_address, to_address
| Column | Type | Description |
|---|---|---|
result | VARCHAR | The execution result of the transaction (success/failure). |
fee | BIGINT | The total fee consumed for transaction processing (in sun). |
contract_address | VARCHAR | The address of the smart contract deployed by the transaction. |
res_message | VARCHAR | The result message returned when the transaction fails. |
asset_issue_id | BIGINT | The asset ID for asset issuance-related transactions. |
withdraw_amount | BIGINT | The amount withdrawn as staking rewards (in sun). |
unfreeze_amount | BIGINT | The amount of TRX processed in an unfreeze operation (in sun). |
exchange_received_amount | BIGINT | The quantity of assets received in an exchange transaction. |
exchange_inject_another_amount | BIGINT | The quantity of another asset additionally injected into the Exchange. |
exchange_withdraw_another_amount | BIGINT | The quantity of another asset withdrawn from the Exchange. |
exchange_id | BIGINT | The unique ID of the exchange transaction. |
shielded_transaction_fee | BIGINT | The fee consumed for processing a shielded transaction. |
order_id | VARCHAR | The unique ID of the order associated with this transaction. |
order_details | ARRAY(VARCHAR) | The list of order detail information. |
packing_fee | BIGINT | The fee charged for transaction packing. |
withdraw_expire_amount | BIGINT | The amount withdrawn from expired Stake v2 funds. |
cancel_unfreeze_v2_amount | VARCHAR | The TRX amount from a cancelled Unfreeze v2 operation. |
energy_usage | BIGINT | The total energy consumed for transaction execution, including deployer energy. |
energy_fee | BIGINT | The energy fee paid in TRX when energy is insufficient (in sun). |
origin_energy_usage | BIGINT | The energy consumption provided by the contract deployer. |
energy_usage_total | BIGINT | The total energy consumed for transaction execution. |
net_usage | BIGINT | The bandwidth consumed for transaction processing. |
net_fee | BIGINT | The bandwidth fee paid in TRX when bandwidth is insufficient (in sun). |
receipt_result | VARCHAR | The receipt value indicating the contract execution result. |
energy_penalty_total | BIGINT | The total additional energy charged as an energy penalty. |
owner_address | VARCHAR | The address of the account that signed and executed the transaction. |
to_address | VARCHAR | The recipient address of the transaction. |
status | BOOLEAN | The processing status of the transaction. |
block_number | BIGINT | The number of the block containing this transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this transaction was produced. |
tx_id | VARCHAR | The unique identifier of the transaction. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
transactions
Unique Key: tx_id
Filterable Columns: owner_address, to_address
| Column | Type | Description |
|---|---|---|
contract_ret | VARCHAR | The result code from smart contract execution. |
ref_block_bytes | VARCHAR | A 2-byte value representing the number of the block this transaction references. |
ref_block_hash | VARCHAR | A portion of the hash of the block this transaction references. |
expiration | BIGINT | The time (in milliseconds) at which this transaction expires if not processed. |
fee_limit | BIGINT | The maximum fee limit (in sun) for smart contract execution. |
data | VARCHAR | A memo or data attached to the transaction. |
type | VARCHAR | The contract type of the transaction. |
type_url | VARCHAR | The protobuf type URL of the transaction contract. |
provider | VARCHAR | Information about the transaction submitter or provider. |
contract_name | VARCHAR | The name of the smart contract called. |
values | VARCHAR | The contract parameter values included in the transaction. |
permission_id | BIGINT | The ID of the multi-signature permission used to sign the transaction. |
owner_address | VARCHAR | The address of the account that signed and executed the transaction. |
to_address | VARCHAR | The destination address that received TRX or assets. |
amount | BIGINT | The TRX amount corresponding to the system_contract_type. |
tx_timestamp | BIGINT | The time (in milliseconds) at which the transaction was created. |
is_multi_sig | BOOLEAN | Indicates whether this is a multi-signature transaction. |
status | BOOLEAN | The processing status of the transaction. |
block_number | BIGINT | The number of the block containing this transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this transaction was produced. |
tx_id | VARCHAR | The unique identifier of the transaction. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
extra_ret | VARCHAR | The additional result code returned after transaction execution. |
trc10_meta
Unique Key: asset_id, block_number
Filterable Columns: None
| Column | Type | Description |
|---|---|---|
asset_id | BIGINT | The unique ID of the TRC-10 asset. |
name | VARCHAR | The name of the TRC-10 asset. |
owner_address | VARCHAR | The address of the account that issued this TRC-10 asset. |
abbr | VARCHAR | The abbreviation (ticker) of the TRC-10 asset. |
total_supply | VARCHAR | The total supply of the TRC-10 asset. |
trx_num | BIGINT | The TRX unit quantity in the exchange ratio with TRX. |
num | BIGINT | The asset unit quantity in the exchange ratio with TRX. |
precision | BIGINT | The decimal precision of the TRC-10 asset. |
start_time | BIGINT | The start time (in milliseconds) of the TRC-10 asset public sale. |
end_time | BIGINT | The end time (in milliseconds) of the TRC-10 asset public sale. |
order | BIGINT | The display order of the asset in a listing. |
description | VARCHAR | A description of the TRC-10 asset. |
url | VARCHAR | The project page URL associated with the TRC-10 asset. |
free_asset_net_limit | BIGINT | The free bandwidth limit per individual asset holder. |
public_free_asset_net_limit | BIGINT | The total free bandwidth limit applied to all users in common. |
block_number | BIGINT | The number of the block containing the asset issuance transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
tx_id | VARCHAR | The ID of the asset issuance transaction. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
trc10_transfers
Unique Key: asset_id, internal_tx_index, tx_id
Filterable Columns: from_address, to_address
| Column | Type | Description |
|---|---|---|
asset_id | BIGINT | The ID of the TRC-10 asset transferred. |
from_address | VARCHAR | The address that sent the TRC-10 asset. |
to_address | VARCHAR | The address that received the TRC-10 asset. |
value | VARCHAR | The quantity of TRC-10 assets transferred. |
internal_tx_index | BIGINT | The internal sequential position of this transfer within the transaction. |
type | VARCHAR | The type of transfer. |
exchange_id | BIGINT | The ID of the Exchange if this asset transfer occurred through an Exchange. |
block_number | BIGINT | The number of the block containing this transfer. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
tx_id | VARCHAR | The ID of the transaction containing this transfer. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
trc1155_meta
Unique Key: token_address, block_number
Filterable Columns: token_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the TRC-1155 contract. |
deployer | VARCHAR | The address of the account that deployed the TRC-1155 contract. |
name | VARCHAR | The name of the TRC-1155 contract. |
symbol | VARCHAR | The symbol (ticker) of the TRC-1155 contract. |
type | VARCHAR | Indicates whether the token conforms to the standard. |
block_number | BIGINT | The number of the block in which the contract was deployed. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the contract deployment was produced. |
tx_id | VARCHAR | The ID of the contract deployment transaction. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
trc1155_transfers
Unique Key: log_index, batch_index, tx_id
Filterable Columns: token_address, from_address, to_address, operator
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the TRC-1155 contract where the transfer occurred. |
from_address | VARCHAR | The address that sent the tokens. |
to_address | VARCHAR | The address that received the tokens. |
operator | VARCHAR | The operator address that approved or executed the token transfer. |
value | VARCHAR | The quantity of tokens transferred. |
token_id | VARCHAR | The ID of the TRC-1155 token transferred. |
log_index | BIGINT | The sequential position of this event log within the block. |
batch_index | BIGINT | The sequential position of this item within a batch transfer. |
block_number | BIGINT | The number of the block containing this transfer. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
tx_id | VARCHAR | The ID of the transaction containing this transfer. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
trc20_meta
Unique Key: token_address, block_number
Filterable Columns: token_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the TRC-20 contract. |
deployer | VARCHAR | The address of the account that deployed the TRC-20 contract. |
name | VARCHAR | The name of the TRC-20 token. |
symbol | VARCHAR | The symbol (ticker) of the TRC-20 token. |
decimals | VARCHAR | The number of decimal places for the TRC-20 token. |
total_supply | VARCHAR | The total supply of the TRC-20 token. |
type | VARCHAR | Indicates whether the token conforms to the standard. |
block_number | BIGINT | The number of the block in which the contract was deployed. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the contract deployment was produced. |
tx_id | VARCHAR | The ID of the contract deployment transaction. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
trc20_transfers
Unique Key: log_index, tx_id
Filterable Columns: token_address, from_address, to_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the TRC-20 contract where the transfer occurred. |
from_address | VARCHAR | The address that sent the tokens. |
to_address | VARCHAR | The address that received the tokens. |
value | VARCHAR | The quantity of TRC-20 tokens transferred. |
log_index | BIGINT | The sequential position of this event log within the block. |
block_number | BIGINT | The number of the block containing this transfer. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
tx_id | VARCHAR | The ID of the transaction containing this transfer. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
trc721_inventories
Unique Key: token_address, token_id, block_number
Filterable Columns: token_address, address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The TRC-721 contract address of the NFT. |
address | VARCHAR | The address of the account currently holding the NFT. |
token_id | VARCHAR | The unique token ID identifying the specific NFT. |
block_number | BIGINT | The number of the block in which this inventory snapshot was recorded. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
tx_id | VARCHAR | The ID of the transaction that recorded this ownership state. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
trc721_meta
Unique Key: token_address, block_number
Filterable Columns: token_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the TRC-721 contract. |
deployer | VARCHAR | The address of the account that deployed the TRC-721 contract. |
name | VARCHAR | The name of the TRC-721 NFT collection. |
symbol | VARCHAR | The symbol (ticker) of the TRC-721 NFT collection. |
type | VARCHAR | Indicates whether the token conforms to the standard. |
block_number | BIGINT | The number of the block in which the contract was deployed. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing the contract deployment was produced. |
tx_id | VARCHAR | The ID of the contract deployment transaction. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
trc721_transfers
Unique Key: log_index, tx_id
Filterable Columns: token_address, from_address, to_address
| Column | Type | Description |
|---|---|---|
token_address | VARCHAR | The address of the TRC-721 contract where the transfer occurred. |
from_address | VARCHAR | The address that sent the NFT. |
to_address | VARCHAR | The address that received the NFT. |
token_id | VARCHAR | The unique token ID of the transferred NFT. |
log_index | BIGINT | The sequential position of this event log within the block. |
block_number | BIGINT | The number of the block containing this transfer. |
block_timestamp | TIMESTAMP(6) | The time at which the block was produced. |
tx_id | VARCHAR | The ID of the transaction containing this transfer. |
tx_index | BIGINT | The sequential position of the transaction within the block. |
sunswap_trades
Unique Key: tx_id, log_index
Filterable Columns: sender, recipient, bought_token_address, sold_token_address, project_contract_address
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP(6) | The time at which the block containing this trade was produced. |
tx_id | VARCHAR | The ID of the transaction containing this trade. |
log_index | INTEGER | The sequential position of this event log within the block. |
sender | VARCHAR | The address that initiated the trade. |
recipient | VARCHAR | The address that receives the assets as a result of the trade. |
bought_token_amount | VARCHAR | The quantity of tokens purchased in this trade. |
sold_token_amount | VARCHAR | The quantity of tokens sold in this trade. |
bought_token_address | VARCHAR | The contract address of the purchased token. |
sold_token_address | VARCHAR | The contract address of the sold token. |
project_contract_address | VARCHAR | The address of the SunSwap pool contract where the trade occurred. |
sunswap_ver | VARCHAR | The version of SunSwap where this trade occurred. |
sunswap_v1_5_tron_exchange
Unique Key: exchange
Filterable Columns: exchange, token
| Column | Type | Description |
|---|---|---|
exchange | VARCHAR | The Exchange contract address of the SunSwap v1.5 pool. |
contract_address | VARCHAR | The factory contract address where the Exchange creation event occurred. |
tx_id | VARCHAR | The ID of the Exchange creation transaction. |
log_index | INTEGER | The sequential position of this event log within the block. |
block_timestamp | TIMESTAMP(6) | The time at which the block in which the Exchange was created was produced. |
block_number | INTEGER | The number of the block in which the Exchange was created. |
token | VARCHAR | The address of the token paired with TRX in this Exchange. |
sunswap_v1_tron_exchange
Unique Key: exchange
Filterable Columns: exchange, token
| Column | Type | Description |
|---|---|---|
exchange | VARCHAR | The Exchange contract address of the SunSwap v1 pool. |
contract_address | VARCHAR | The factory contract address where the Exchange creation event occurred. |
tx_id | VARCHAR | The ID of the Exchange creation transaction. |
log_index | INTEGER | The sequential position of this event log within the block. |
block_timestamp | TIMESTAMP(6) | The time at which the block in which the Exchange was created was produced. |
block_number | INTEGER | The number of the block in which the Exchange was created. |
token | VARCHAR | The address of the token paired with TRX in this Exchange. |
sunswap_v2_tron_exchange
Unique Key: pair
Filterable Columns: pair, token0, token1
| Column | Type | Description |
|---|---|---|
pair | VARCHAR | The pair contract address of the SunSwap v2 pool. |
contract_address | VARCHAR | The factory contract address where the pool creation event occurred. |
tx_id | VARCHAR | The ID of the pool creation transaction. |
log_index | INTEGER | The sequential position of this event log within the block. |
block_timestamp | TIMESTAMP(6) | The time at which the block in which the pool was created was produced. |
block_number | INTEGER | The number of the block in which the pool was created. |
_0 | VARCHAR | The original event field name _0, which contains currently unused data. |
token0 | VARCHAR | The contract address of the first token in the pool. |
token1 | VARCHAR | The contract address of the second token in the pool. |
sunswap_v3_tron_exchange
Unique Key: pool
Filterable Columns: pool, token0, token1
| Column | Type | Description |
|---|---|---|
pool | VARCHAR | The contract address of the SunSwap v3 pool. |
contract_address | VARCHAR | The factory contract address where the pool creation event occurred. |
tx_id | VARCHAR | The ID of the pool creation transaction. |
log_index | INTEGER | The sequential position of this event log within the block. |
block_timestamp | TIMESTAMP(6) | The time at which the block in which the pool was created was produced. |
block_number | INTEGER | The number of the block in which the pool was created. |
fee | VARCHAR | The fee tier charged for trades in the pool. |
tick_spacing | VARCHAR | The tick spacing value of the pool, which determines price precision. |
token0 | VARCHAR | The contract address of the first token in the pool. |
token1 | VARCHAR | The contract address of the second token in the pool. |
token_ohlcv_5m
Unique Key: bucket, base_token_address, quote
Filterable Columns: base_token_address
| Column | Type | Description |
|---|---|---|
partition_day | DATE | The date value used for partition pruning. |
bucket | TIMESTAMP(6) | The start time of the 5-minute OHLCV aggregation interval. |
base_token_address | VARCHAR | The contract address of the base token whose price is quoted. |
base_symbol | VARCHAR | The symbol (ticker) of the base token. |
quote | VARCHAR | The contract address of the quote token used to express the base token's price. |
open | DOUBLE | The opening price at the start of the interval. |
high | DOUBLE | The highest price during the interval. |
low | DOUBLE | The lowest price during the interval. |
close | DOUBLE | The closing price at the end of the interval. |
volume | DOUBLE | The total trading volume of the base token during the interval. |
quote_volume | DOUBLE | The total trading volume of the quote token during the interval. |
trade_count | BIGINT | The number of trades that occurred within the interval. |
token_ohlcv_1h
Unique Key: bucket, base_token_address, quote
Filterable Columns: base_token_address
| Column | Type | Description |
|---|---|---|
partition_day | DATE | The date value used for partition pruning. |
bucket | TIMESTAMP(6) | The start time of the 1-hour OHLCV aggregation interval. |
base_token_address | VARCHAR | The contract address of the base token whose price is quoted. |
base_symbol | VARCHAR | The symbol (ticker) of the base token. |
quote | VARCHAR | The contract address of the quote token used to express the base token's price. |
open | DOUBLE | The opening price at the start of the interval. |
high | DOUBLE | The highest price during the interval. |
low | DOUBLE | The lowest price during the interval. |
close | DOUBLE | The closing price at the end of the interval. |
volume | DOUBLE | The total trading volume of the base token during the interval. |
quote_volume | DOUBLE | The total trading volume of the quote token during the interval. |
trade_count | BIGINT | The number of trades that occurred within the interval. |
token_ohlcv_1d
Unique Key: bucket, base_token_address, quote
Filterable Columns: base_token_address
| Column | Type | Description |
|---|---|---|
partition_day | DATE | The date value used for partition pruning. |
bucket | TIMESTAMP(6) | The start time of the 1-day OHLCV aggregation interval. |
base_token_address | VARCHAR | The contract address of the base token whose price is quoted. |
base_symbol | VARCHAR | The symbol (ticker) of the base token. |
quote | VARCHAR | The contract address of the quote token used to express the base token's price. |
open | DOUBLE | The opening price at the start of the interval. |
high | DOUBLE | The highest price during the interval. |
low | DOUBLE | The lowest price during the interval. |
close | DOUBLE | The closing price at the end of the interval. |
volume | DOUBLE | The total trading volume of the base token during the interval. |
quote_volume | DOUBLE | The total trading volume of the quote token during the interval. |
trade_count | BIGINT | The number of trades that occurred within the interval. |