Nft Sales
The optimism.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 |
The last block number in the batch that the data was updated in. |
| __confirmed | boolean |
Flag indicating whether the transfer has been confirmed. |
| __last_modified | timestamp |
The date at which this row was last updated (in ISO-8601 format). |
Supported Protocols
| Protocol | |||
|---|---|---|---|
| bitget-seaport | nftearth-seaport | okx-seaport | opensea-seadrop |
| opensea-seaport | quixotic-seaport | quixotic-v1 | quixotic-v2 |
| quixotic-v3 | quixotic-v4 | quixotic-v5 | tofu-v1 |
| zonic-v1 |
Indexes
| Index |
|---|
| exchange_name, contract_address, token_id, timestamp, log_index, multi_token_sale_index |
| exchange_name, contract_address, timestamp, log_index, multi_token_sale_index |
| exchange_name, timestamp, log_index, multi_token_sale_index |
| seller_address, timestamp, log_index, multi_token_sale_index |
| buyer_address, timestamp, log_index, multi_token_sale_index |
| contract_address, token_id, timestamp, log_index, multi_token_sale_index |
| contract_address, timestamp, log_index, multi_token_sale_index |
| timestamp, log_index, multi_token_sale_index |
| transaction_hash, log_index, multi_token_sale_index |
| __last_modified |
| __indexer_id WHERE __confirmed = false |
| __indexer_id, __block_number |
| block_number, 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.