Core Tables
Ethereum base type tables available to query via SQL
Last updated
Ethereum base type tables available to query via SQL
Last updated
Table Name | Description |
---|---|
The table list is also available as a SQL query using show tables
. For example:
The columns and their schema available for each table can be viewed with the describe <table>
command. For example:
Query performance can be significantly improved by adding WHERE
clauses to your query on specific indexed columns.
Table Name | Indexed Columns |
---|---|
Block headers
Block headers from the last 30 minutes, ~128 blocks
Block transactions
Block transactions from the last 30 minutes, ~128 blocks
Transaction event logs
Transaction event logs from the last 30 minutes, ~128 blocks
A listing of all contracts
All call frames executed during a transaction, also known as internal transactions
eth.traces
data from the last 30 minutes, ~128 blocks
Block withdrawals
Block withdrawals from the last 30 minutes, ~128 blocks
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