Token Tables
Polygon Token tables available to query via SQL
Links
Table Name | Description |
|---|---|
ERC-20, ERC-721 and ERC-1155 token contracts | |
ERC-20, ERC-721, and ERC-1155 token transfers | |
Token transfers from the last 30 minutes, ~128 blocks | |
ERC-20 token contracts | |
ERC-20 token transfers | |
ERC-721 token contracts | |
ERC-721 token transfers (NFTs) | |
ERC-1155 token contracts | |
ERC-1155 token transfers | |
ERC-20, ERC-721, and ERC-1155 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.tokens | block_number block_timestamp name symbol |
polygon.tokens_erc20 | block_number block_timestamp name symbol |
polygon.tokens_erc721 | block_number block_timestamp name symbol |
polygon.tokens_erc1155 | block_number block_timestamp name symbol |
polygon.token_transfers | block_number block_timestamp block_hash transaction_hash |
polygon.recent_token_transfers | block_number block_timestamp block_hash transaction_hash |
polygon.token_transfers_erc20 | block_number block_timestamp block_hash transaction_hash |
polygon.token_transfers_erc721 | block_number block_timestamp block_hash transaction_hash |
polygon.token_transfers_erc1155 | block_number block_timestamp block_hash transaction_hash |
polygon.token_mints | block_number block_timestamp block_hash transaction_hash |
polygon.recent_token_mints | block_number block_timestamp block_hash transaction_hash |
Last modified 2mo ago