Links

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
Last modified 4mo ago