NFT Tables
Table Name | Description |
|---|---|
polygon.nfts | All NFTs from both ERC721 and ERC1155 contracts. |
polygon.nft_contracts | All erc721 contracts & subset of erc1155 contracts that contain NFTs. |
polygon.nft_transfers | Transfers of erc721 & erc1155 NFTs. Does not include fungible tokens from erc1155 contracts. |
polygon.nft_owners | Tracks the current owner of an NFT.
This table is mutable; the number of rows within a given time or block range can be different due to changes in NFT ownership. |
polygon.recent_nft_transfers | Transfers of NFTs from the last 30 minutes, ~128 blocks |
polygon.nft_airdrop_transfers | Airdrops of NFTs |
polygon.recent_nft_airdrop_transfers | Airdrops of NFTs 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.nfts;
DESCRIBE polygon.nft_contracts;
DESCRIBE polygon.nft_transfers;
DESCRIBE polygon.nft_owners;
DESCRIBE polygon.recent_nft_transfers;
DESCRIBE polygon.nft_airdrop_transfers;
DESCRIBE polygon.recent_nft_airdrop_transfers;
Query performance can be significantly improved by adding
WHERE clauses to your query on specific indexed columns.Table Name | Indexed Columns |
|---|---|
polygon.nft_transfers | block_number |
polygon.nft_airdrop_transfers | block_number |
Last modified 27d ago