Core Tables
Goerli base type tables available to query via SQL
The Goerli testnet has been deprecated on Spice.ai as of March 22, 2024. Datasets are available but no longer updated.
Goerli base type tables available to query
Table Name | Description |
---|---|
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 | |
| |
Block 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:
The columns and their schema available for each table can be viewed with the describe <table>
command. For example:
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 |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Last updated