Token Tables

Ethereum Token tables available to query via SQL

Links

• Ethereum Token Standards

• ERC-20 Fungible tokens

• ERC-721 NFTs

• ERC-1155 Multi-Token Standard

Token specific tables

Table Name	Description
eth.tokens	ERC-20, ERC-721 and ERC-1155 token contracts
eth.token_transfers	ERC-20, ERC-721, and ERC-1155 token transfers
eth.recent_token_transfers	Token transfers from the last 30 minutes, ~128 blocks
eth.tokens_erc20	ERC-20 token contracts
eth.token_transfers_erc20	ERC-20 token transfers
eth.tokens_erc721	ERC-721 token contracts
eth.token_transfers_erc721	ERC-721 token transfers (NFTs)
eth.tokens_erc1155	ERC-1155 token contracts
eth.token_transfers_erc1155	ERC-1155 token transfers
eth.token_mints	ERC-20, ERC-721, and ERC-1155 token mints
eth.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 eth.tokens;
DESCRIBE eth.token_transfers;
DESCRIBE eth.tokens_erc20;
DESCRIBE eth.token_transfers_erc20;
DESCRIBE eth.tokens_erc721;
DESCRIBE eth.token_transfers_erc721;
DESCRIBE eth.tokens_erc1155;
DESCRIBE eth.token_transfers_erc1155;
DESCRIBE eth.token_mints;
DESCRIBE eth.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
eth.tokens	block_number block_timestamp name symbol
eth.tokens_erc20	block_number block_timestamp name symbol
eth.tokens_erc721	block_number block_timestamp name symbol
eth.tokens_erc1155	block_number block_timestamp name symbol
eth.token_transfers	block_number block_timestamp block_hash transaction_hash
eth.recent_token_transfers	block_number block_timestamp block_hash transaction_hash
eth.token_transfers_erc20	block_number block_timestamp block_hash transaction_hash
eth.token_transfers_erc721	block_number block_timestamp block_hash transaction_hash
eth.token_transfers_erc1155	block_number block_timestamp block_hash transaction_hash
eth.token_mints	block_number block_timestamp block_hash transaction_hash
eth.recent_token_mints	block_number block_timestamp block_hash transaction_hash