Token Tables
Goerli token specific tables
Links
Table Name | Description |
|---|---|
goerli.tokens | ERC-20, ERC-721 and ERC-1155 token contracts |
goerli.token_transfers | ERC-20, ERC-721, and ERC-1155 token transfers |
goerli.recent_token_transfers | Token transfers from the last 30 minutes, ~128 blocks |
goerli.tokens_erc20 | ERC-20 token contracts |
goerli.token_transfers_erc20 | ERC-20 token transfers |
goerli.tokens_erc721 | ERC-721 token contracts |
goerli.token_transfers_erc721 | ERC-721 token transfers (NFTs) |
goerli.tokens_erc1155 | ERC-1155 token contracts |
goerli.token_transfers_erc1155 | ERC-1155 token transfers |
goerli.token_mints | ERC-20, ERC-721, and ERC-1155 token mints |
goerli.recent_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 1mo ago