Skip to content

Nft Sales

The canto.nft_sales table provides indexed views of all NFT sales transacted on the chain, with support for USD price conversions, multi-token NFT sales, semi-fungible NFT sales, aggregator annotations, and much more. All NFT sales tables follows the same database schema presented below.

Columns

Name Type Description
aggregator_name text The name of the aggregator that facilitated NFT sale (null if not found).
block_number integer The block number of the NFT sale.
buyer_address text The address of that bought the NFT.
contract_address text The contract address of the NFT that was sold.
contract_version text The version of the exchange contract that facilitated the NFT sale (e.g. wyvern or seaport for OpenSea).
eth_price numeric The total value of this sale in ETH (null if not WETH, MATIC, or stablecoin payment token).
exchange_name text The name of the exchange that facilitated the NFT sale.
is_multi_token_sale boolean Whether the sale is a multi-token sale, including more than one unique NFT for the given payment.
log_index integer The log index of the NFT sale.
multi_token_sale_index integer The index of the sale within the multi-token sale (will be 0 if not a multi-token sale).
native_price numeric The total value of this sale in the native chain currency (null if not ETH, MATIC, or stablecoin payment token).
payment_token_address text The address of the payment token used for this sale.
platform_fee numeric The platform fee paid to the exchange that facilitated the NFT sale.
price numeric The total value of this sale in the payment token (in Wei).
quantity numeric The quantity of NFTs sold in this transaction.
royalty_fee numeric The royalty fee paid to the creator of the NFT.
seller_address text The address that sold the NFT.
timestamp timestamp without time zone The timestamp of the NFT sale.
token_id numeric The token ID of the NFT that was sold.
transaction_hash text The transaction hash of the NFT sale.
usd_price numeric The total value of this sale in USD (null if not WETH or stablecoin payment token).
__block_number integer An internal identifier for the indexer that updates this row. Use block_number instead when querying.
__confirmed boolean Flag indicating whether the transfer has been confirmed.

Supported Protocols

Protocol
alto-v1

Indexes

Index
block_number, log_index, multi_token_sale_index
__indexer_id, __block_number
__indexer_id WHERE __confirmed = false
transaction_hash, log_index, multi_token_sale_index
timestamp, log_index, multi_token_sale_index
contract_address, timestamp, log_index, multi_token_sale_index
contract_address, token_id, timestamp, log_index, multi_token_sale_index
buyer_address, timestamp, log_index, multi_token_sale_index
seller_address, timestamp, log_index, multi_token_sale_index
exchange_name, timestamp, log_index, multi_token_sale_index
exchange_name, contract_address, timestamp, log_index, multi_token_sale_index
exchange_name, contract_address, token_id, timestamp, log_index, multi_token_sale_index

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.