Token Tables

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:
1
/* Show the columns available */
2
DESCRIBE eth.tokens;
3
DESCRIBE eth.token_transfers;
4
DESCRIBE eth.tokens_erc20;
5
DESCRIBE eth.token_transfers_erc20;
6
DESCRIBE eth.tokens_erc721;
7
DESCRIBE eth.token_transfers_erc721;
8
DESCRIBE eth.tokens_erc1155;
9
DESCRIBE eth.token_transfers_erc1155;
10
DESCRIBE eth.token_mints;
11
DESCRIBE eth.recent_token_mints;
Copied!

REFERENCE - Previous

SQL Query Tables

NFT Tables

Last modified 11d ago

Export as PDF

Copy link

Edit on GitHub

Contents