tron holds the standardized Tron tables. They look much like the tables for the EVM chains, the ones running the Ethereum Virtual Machine: blocks, transactions and logs, plus two more for the transfers Tron handles in its own way rather than through contracts: internal_transactions and wallet_blocks.
Tron writes an address in two forms, and both are here. The columns named *_hex hold the form that looks like an Ethereum address; the plain address-style columns hold the base58 form, the one that starts with a T and appears in wallets and explorers. Pick whichever matches the addresses you are joining against.
Tables
| Table | Since | Description |
|---|---|---|
blocks | 2018-06 | One row per block, following the EVM block shape. |
transactions | 2018-06 | One row per transaction, with what it cost and the resources it used on the same row. |
logs | 2018-10 | One row per contract event log, following the EVM log shape. |
internal_transactions | 2018-10 | One row per internal transaction, with per-token values in call_value_info. |
wallet_blocks | 2018-06 | One row per native wallet action, linked to its transaction. |
number, transactions on transaction_hash, and logs on block_number with log_index.
Tron does not charge one gas fee. It meters two resources instead, energy for running contracts and bandwidth for the size of a transaction, and an account can hold an allowance of either. The receipt_info_energy_fee, receipt_info_energy_usage_total and receipt_info_net_fee columns on transactions record that, which is something the EVM tables have no columns for.
Sample queries
- Daily transactions and fees
- Tokenized assets ranked
- Priced tokens, daily
Sum daily transactions and energy fees over one week.