Token Tables

Goerli Token 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.

Links

• Ethereum Token Standards

• ERC-20 Fungible tokens

• ERC-721 NFTs

• ERC-1155 Multi-Token Standard

Token specific tables

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;

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
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