Comment on page
Token Tables
Goerli Token tables available to query via SQL
Links
Table Name | Description |
|---|---|
ERC-20, ERC-721 and ERC-1155 token contracts | |
ERC-20, ERC-721, and ERC-1155 token transfers | |
Token transfers from the last 30 minutes, ~128 blocks | |
ERC-20 token contracts | |
ERC-20 token transfers | |
ERC-721 token contracts | |
ERC-721 token transfers (NFTs) | |
ERC-1155 token contracts | |
ERC-1155 token transfers | |
ERC-20, ERC-721, and ERC-1155 token mints | |
Token mints from the last 30 minutes, ~128 blocks |
The columns and their schema available for each table can be viewed with the
describe <table> command. For example:/* Show the columns available */
DESCRIBE goerli.tokens;
DESCRIBE goerli.token_transfers;
DESCRIBE goerli.tokens_erc20;
DESCRIBE goerli.token_transfers_erc20;
DESCRIBE goerli.tokens_erc721;
DESCRIBE goerli.token_transfers_erc721;
DESCRIBE goerli.tokens_erc1155;
DESCRIBE goerli.token_transfers_erc1155;
DESCRIBE goerli.token_mints;
DESCRIBE goerli.recent_token_mints;
Query performance can be significantly improved by adding
WHERE clauses to your query on specific indexed columns.Table Name | Indexed Columns |
|---|---|
goerli.tokens | block_number block_timestamp name symbol |
goerli.tokens_erc20 | block_number block_timestamp name symbol |
goerli.tokens_erc721 | block_number block_timestamp name symbol |
goerli.tokens_erc1155 | block_number block_timestamp name symbol |
goerli.token_transfers | block_number block_timestamp block_hash transaction_hash |
goerli.recent_token_transfers | block_number block_timestamp block_hash transaction_hash |
goerli.token_transfers_erc20 | block_number block_timestamp block_hash transaction_hash |
goerli.token_transfers_erc721 | block_number block_timestamp block_hash transaction_hash |
goerli.token_transfers_erc1155 | block_number block_timestamp block_hash transaction_hash |
goerli.token_mints | block_number block_timestamp block_hash transaction_hash |
goerli.recent_token_mints | block_number block_timestamp block_hash transaction_hash |
Last modified 4mo ago