> ## Documentation Index > Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt > Use this file to discover all available pages before exploring further. > ## Agent Instructions > To query the Token Terminal data catalog, read https://tokenterminal.com/docs/catalog/agents-manual.md first. It is the whole catalog as one page: table naming grammar, key columns, partition and cluster rules, units, additivity, and the tables that are documented but not served yet. > Never query a catalog table on a time bound alone. Also filter its cluster key, which you read from INFORMATION_SCHEMA.COLUMNS; an empty result means the object is a view, whose pruning contract is on its page. Compute is billed to the caller's own Google Cloud project. # EVM ecosystem > Standardized blocks, transactions, logs and traces for every EVM chain. EVM stands for Ethereum Virtual Machine, the engine that runs contracts on Ethereum. Every chain in this family runs that same engine, so they all keep the same kind of records and get the same four core tables: `blocks`, `transactions`, `logs` and `traces`. The [Tables](#tables) section below lists the columns once for the whole family. ## Chains

Chain	`chain_id`	blocks	transactions	logs	traces
Anime	`anime`	✓	✓	✓	✓
ApeChain	`apechain`	✓	✓	✓	✓
Arbitrum	`arbitrum`	✓	✓	✓	✓
Arc	`arc`	✓	✓	✓	✓
Avalanche	`avalanche`	✓	✓	✓	✓
Base	`base`	✓	✓	✓	✓
Berachain	`berachain`	✓	✓	✓	✓
Blast	`blast`	✓	✓	✓	✓
BNB Smart Chain	`bsc`	✓	✓	✓	✓
BOB	`bob`	✓	✓	✓	✓
Boba Network	`bobanetwork`	✓	✓	✓	✓
Celo	`celo`	✓	✓	✓	✓
Ethereum	`ethereum`	✓	✓	✓	✓
Flow EVM	`flowevm`	✓	✓	✓	✓
Fraxtal	`fraxtal`	✓	✓	✓	✓
Galactica	`galactica`	✓	✓	✓	✓
Gnosis	`gnosis`	✓	✓	✓	✓
Gravity Alpha	`gravityalpha`	✓	✓	✓	✓
Hedera EVM	`hederaevm`	✓	✓	✓	✗
Humanity	`humanity`	✓	✓	✓	✓
HyperEVM	`hyperevm`	✓	✓	✓	✗
Immutable zkEVM	`immutablezkevm`	✓	✓	✓	✓
Injective EVM	`injectiveevm`	✓	✓	✓	✗
Ink	`ink`	✓	✓	✓	✓
IoTeX	`iotex`	✓	✓	✓	✗
Katana	`katananetwork`	✓	✓	✓	✓
Linea	`linea`	✓	✓	✓	✓
Manta	`manta`	✓	✓	✓	✓
MegaETH	`megaeth`	✓	✓	✓	✗
Metis	`metis`	✓	✓	✓	✓
Mode	`mode`	✓	✓	✓	✓
Monad	`monad`	✓	✓	✓	✓
opBNB	`opbnb`	✓	✓	✓	✓
Optimism	`optimism`	✓	✓	✓	✓
Plasma	`plasma`	✓	✓	✓	✓
Polygon	`polygon`	✓	✓	✓	✓
Robinhood Chain	`robinhoodchain`	✓	✓	✓	✓
Rootstock	`rootstock`	✓	✓	✓	✓
Scroll	`scroll`	✓	✓	✓	✓
Sei EVM	`seievm`	✓	✓	✓	✓
Settlus	`settlus`	✓	✓	✓	✓
Shape	`shape`	✓	✓	✓	✓
Soneium	`soneium`	✓	✓	✓	✓
Sonic	`sonic`	✓	✓	✓	✓
Story	`story`	✓	✓	✓	✓
Superseed	`superseed`	✓	✓	✓	✓
Tempo	`tempo`	✓	✓	✓	✓
Unichain	`unichain`	✓	✓	✓	✓
Viction	`viction`	✓	✓	✓	✓
World Chain	`worldchain`	✓	✓	✓	✓
World Mobile Chain	`worldmobilechain`	✓	✓	✓	✓
XDC	`xdc`	✓	✓	✓	✗
X Layer	`xlayer`	✓	✓	✓	✓
ZKsync Era	`zksyncera`	✓	✓	✓	✓

## Tables Every chain in the EVM family runs the Ethereum Virtual Machine, the same engine Ethereum runs, so every one of their datasets has the same four core tables with the same columns. The schemas apply to every chain listed in the [chain matrix](#chains). A receipt is the chain's record of what a transaction cost and whether it worked. Those fields sit on the transaction's own row, named `receipt_*`. > [!WARNING] > > Every table splits by day: `blocks` on `timestamp`, the rest on `block_timestamp`. Bound that column in every query; without a bound the query reads the whole table. **blocks** A block is a batch of transactions that the network agreed on and added to the chain as one unit. `blocks` contains one row per block, keyed on the block number.

Column	Type	Description
`timestamp`	TIMESTAMP	The time the block was produced. Partition column.
`number`	INT64	The block number.
`block_hash`	STRING	The hash of the block.
`transaction_count`	INT64	The number of transactions in the block.
`gas_limit`	INT64	The maximum gas the block allows.
`gas_used`	INT64	The gas consumed by all transactions in the block.
`blob_gas_used`	INT64	The blob gas consumed by the block.
`excess_blob_gas`	INT64	The running excess of blob gas above the target.
`base_fee_per_gas`	INT64	The base fee per gas unit, in wei.
`miner`	STRING	The address credited with producing the block.
`parent_hash`	STRING	The hash of the parent block.
`nonce`	STRING	The proof-of-work nonce.
`sha3_uncles`	STRING	The hash of the block's uncle list.
`logs_bloom`	STRING	The bloom filter over the block's logs.
`transactions_root`	STRING	The root hash of the transaction trie.
`state_root`	STRING	The root hash of the state trie.
`receipts_root`	STRING	The root hash of the receipt trie.
`difficulty`	INT64	The proof-of-work difficulty.
`total_difficulty`	NUMERIC	The cumulative difficulty up to this block.
`size`	INT64	The block size in bytes.
`extra_data`	STRING	Arbitrary data included by the block producer.
`parent_beacon_block_root`	STRING	The root of the parent beacon block.
`mix_hash`	STRING	The mix hash from block sealing.
`uncles`	ARRAY\	The hashes of the block's uncles.
`withdrawals`	ARRAY\	Validator withdrawals credited in the block: address, amount, index and validator index.
`withdrawals_root`	STRING	The root hash of the withdrawal list.

**Daily blocks and gas** **Count blocks and gas used per day.** `blocks` splits on `timestamp`, not `block_timestamp`. ```sql theme={null} select timestamp_trunc(timestamp, day) as day, count(*) as blocks, sum(gas_used) as gas_used from `ethereum.blocks` where timestamp >= timestamp('2026-08-16') and timestamp < timestamp('2026-08-23') group by day order by day ``` **transactions** A transaction is one signed instruction an account sent to the chain: a payment, or a call into a contract. `transactions` contains one row per transaction, with its receipt fields on the same row.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the block containing the transaction. Partition column.
`block_number`	INT64	The number of the block containing the transaction.
`transaction_hash`	STRING	The hash of the transaction.
`transaction_index`	INT64	The position of the transaction within the block.
`from_address`	STRING	The sending address.
`to_address`	STRING	The receiving address. Null for contract creations.
`value`	NUMERIC	The native value transferred, in wei.
`gas`	INT64	The gas limit set by the sender.
`gas_price`	INT64	The gas price, in wei.
`nonce`	INT64	The sender's transaction count at submission.
`input`	STRING	The data sent with the transaction, saying which contract function to run and with what arguments.
`block_hash`	STRING	The hash of the containing block.
`max_fee_per_gas`	INT64	The EIP-1559 fee cap per gas unit.
`max_priority_fee_per_gas`	INT64	The EIP-1559 priority fee per gas unit.
`transaction_type`	INT64	The transaction type identifier.
`receipt_type`	INT64	The type identifier recorded on the receipt.
`receipt_effective_gas_price`	INT64	The gas price paid, in wei.
`receipt_blob_gas_price`	INT64	The blob gas price paid.
`receipt_cumulative_gas_used`	INT64	The gas used in the block up to and including this transaction.
`receipt_gas_used`	INT64	The gas used by this transaction.
`receipt_blob_gas_used`	INT64	The blob gas used by this transaction.
`receipt_contract_address`	STRING	The address of the contract created, when the transaction deploys one.
`receipt_status`	BOOL	Whether the transaction succeeded.
`receipt_logs_bloom`	STRING	The bloom filter over the transaction's logs.
`receipt_transaction_index`	INT64	The transaction index recorded on the receipt.
`v`	STRING	The signature recovery value.
`r`	STRING	The signature r value.
`s`	STRING	The signature s value.
`chain_id`	INT64	The chain id the transaction was signed for.
`blob_versioned_hashes`	ARRAY\	The versioned hashes of attached blobs.
`max_fee_per_blob_gas`	INT64	The blob gas fee cap.
`access_list`	ARRAY\	The declared access list: address and storage keys.

**Daily success rate** **Count daily transactions and their success rate over one week.** ```sql theme={null} select timestamp_trunc(block_timestamp, day) as day, count(*) as transactions, countif(receipt_status) as successful from `ethereum.transactions` where block_timestamp >= timestamp('2026-08-16') and block_timestamp < timestamp('2026-08-23') group by day order by day ``` **logs** A log is a note a contract writes when something happens inside it: a transfer, a swap, a deposit. Each contract decides what it announces this way, so logs are the main record of what apps did. `logs` contains one row per log.

Column	Type	Description
`block_timestamp`	TIMESTAMP	The time of the block containing the log. Partition column.
`block_number`	INT64	The number of the block containing the log.
`transaction_hash`	STRING	The hash of the transaction that emitted the log.
`log_index`	INT64	The position of the log within the block.
`address`	STRING	The contract that emitted the log.
`data`	STRING	The rest of the log's contents, the part that is not searchable.
`topics`	ARRAY\	The searchable fields of the log. The first one identifies which event this is.
`removed`	BOOL	Whether the log was removed by a reorganization.
`block_hash`	STRING	The hash of the containing block.
`transaction_index`	INT64	The position of the emitting transaction within the block.

**One contract's logs** **Count the logs one contract emitted on a single day.** `address` is the contract that wrote the log. ```sql theme={null} select count(*) as logs, count(distinct transaction_hash) as transactions from `ethereum.logs` where block_timestamp >= timestamp('2026-08-20') and block_timestamp < timestamp('2026-08-21') and address = '0xdac17f958d2ee523a2206206994597c13d831ec7' ``` **traces** A trace is a record of one internal step a transaction took, including the calls a contract makes to other contracts. A single transaction usually produces many of them. `traces` contains one row per step: a call, a contract creation, a contract self-destruct, or a reward.

Column	Type	Description
`from_address`	STRING	The calling address.
`gas`	INT64	The gas available to the call.
`gas_used`	INT64	The gas used by the call.
`to_address`	STRING	The called address.
`input`	STRING	The call data.
`value`	FLOAT64	The native value transferred by the call, in wei.
`trace_type`	STRING	The trace type: call, create, suicide or reward.
`transaction_hash`	STRING	The hash of the containing transaction.
`block_timestamp`	TIMESTAMP	The time of the block containing the trace. Partition column.
`block_number`	INT64	The number of the containing block.
`trace_address`	STRING	The position of the call in the call tree.
`output`	STRING	The return data of the call.
`error`	STRING	The error raised by the call, when it failed.
`revert_reason`	STRING	The revert reason string, when one was returned.
`transaction_index`	INT64	The position of the containing transaction within the block.
`trace_id`	STRING	The unique identifier of the trace.
`status`	BOOL	Whether the call succeeded.

The chains marked ✓ for `traces` in the [chain matrix](#chains) have this table. **Calls into one contract** **Count the internal calls into one contract on a single day.** `to_address` is the contract being called, whether directly or from another contract. ```sql theme={null} select count(*) as calls, count(distinct transaction_hash) as transactions from `ethereum.traces` where block_timestamp >= timestamp('2026-08-20') and block_timestamp < timestamp('2026-08-21') and to_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' ``` ## Exceptions * Ethereum adds two tables to the four, `beacon_validators` and `uncle_blocks`, documented on its [Raw](https://tokenterminal.com/docs/catalog/chain-verticals/evm/ethereum/raw.md) page. * HyperEVM publishes its receipt fields as a separate `receipts` table; every other chain keeps them on the transaction row. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.