NFTs

Recent NFT Transfers
Transfers of NFTs that conform to both ERC721 and ERC1155 token standards.
Ethereum
Polygon
SELECT * FROM eth.recent_nft_transfers
ORDER BY block_number DESC, token_address, token_id
LIMIT 10
SELECT * FROM polygon.recent_nft_transfers
ORDER BY block_number DESC, token_address, token_id
LIMIT 10
All NFTs from a single collection
Ethereum: All Bored Ape Yacht Club NFTs.
Polygon: All Aavegotchi NFTs.
Ethereum
Polygon
SELECT * FROM eth.nfts
WHERE address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' -- BAYC
ORDER BY CAST(token_id AS NUMERIC)
SELECT * FROM polygon.nfts
WHERE address = '0x86935f11c86623dec8a25696e1c19a8659cbf95d' -- Aavegotchi
ORDER BY CAST(token_id AS NUMERIC)
Current owners of all NFTs from a collection
Ethereum: Current owners of all Bored Ape Yacht Club NFTs.
Polygon: Current owners of all Aavegotchi NFTs.
Ethereum
Polygon
SELECT * FROM eth.nft_owners
WHERE token_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' -- BAYC
ORDER BY CAST(token_id AS NUMERIC)
SELECT * FROM polygon.nft_owners
WHERE token_address = '0x86935f11c86623dec8a25696e1c19a8659cbf95d' -- Aavegotchi
ORDER BY CAST(token_id AS NUMERIC)
Number of smart contracts with NFTs
Returns how many NFT smart contracts exist
Ethereum
Polygon
SELECT COUNT(*) as "num_contracts"
FROM eth.nft_contracts
SELECT COUNT(*) as "num_contracts"
FROM polygon.nft_contracts

Transactions

Tokens

Last modified 8mo ago