Core Tables

Ethereum base type tables available to query via SQL

Ethereum base type tables available to query

Table Name	Description
eth.blocks	Block headers
eth.recent_blocks	Block headers from the last 30 minutes, ~128 blocks
eth.transactions	Block transactions
eth.recent_transactions	Block transactions from the last 30 minutes, ~128 blocks
eth.logs	Transaction event logs
eth.recent_logs	Transaction event logs from the last 30 minutes, ~128 blocks
eth.contracts	A listing of all contracts
eth.traces	All call frames executed during a transaction, also known as internal transactions
eth.recent_traces	eth.traces data from the last 30 minutes, ~128 blocks
eth.withdrawals	Block withdrawals
eth.recent_withdrawals	Block withdrawals from the last 30 minutes, ~128 blocks

The table list is also available as a SQL query using show tables. For example:

SHOW TABLES IN eth

The columns and their schema available for each table can be viewed with the describe <table> command. For example:

/* Show the columns available */
DESCRIBE eth.blocks;
DESCRIBE eth.transactions;
DESCRIBE eth.logs;
DESCRIBE eth.recent_logs;
DESCRIBE eth.contracts;
DESCRIBE eth.traces;
DESCRIBE eth.withdrawals;

Improving query performance - indexed columns

Query performance can be significantly improved by adding WHERE clauses to your query on specific indexed columns.

Table Name	Indexed Columns
eth.blocks	number timestamp hash
eth.transactions	block_number block_timestamp hash
eth.logs	block_number block_timestamp address
eth.contracts	block_number block_timestamp address
eth.traces	block_number
eth.withdrawals	block_number