Token Tables
Links
Table Name | Description |
|---|---|
polygon.tokens | ERC-20, ERC-721 and ERC-1155 token contracts |
polygon.token_transfers | ERC-20, ERC-721, and ERC-1155 token transfers |
polygon.recent_token_transfers | Token transfers from the last 30 minutes, ~128 blocks |
polygon.tokens_erc20 | ERC-20 token contracts |
polygon.token_transfers_erc20 | ERC-20 token transfers |
polygon.tokens_erc721 | ERC-721 token contracts |
polygon.token_transfers_erc721 | ERC-721 token transfers (NFTs) |
polygon.tokens_erc1155 | ERC-1155 token contracts |
polygon.token_transfers_erc1155 | ERC-1155 token transfers |
polygon.token_mints | ERC-20, ERC-721, and ERC-1155 token mints |
polygon.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 polygon.tokens;
DESCRIBE polygon.token_transfers;
DESCRIBE polygon.tokens_erc20;
DESCRIBE polygon.token_transfers_erc20;
DESCRIBE polygon.tokens_erc721;
DESCRIBE polygon.token_transfers_erc721;
DESCRIBE polygon.tokens_erc1155;
DESCRIBE polygon.token_transfers_erc1155;
DESCRIBE polygon.token_mints;
DESCRIBE polygon.recent_token_mints;
Query performance can be significantly improved by adding
WHERE clauses to your query on specific indexed columns.Table Name | Indexed Columns |
|---|---|
polygon.token_transfers | block_number block_timestamp transaction_hash token_address from_address to_address |
Last modified 2mo ago