Nft Sales
The ethereum.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 block number at which the event took place 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 | |||
|---|---|---|---|
| 0x-v2 | 0x-v3 | alphasharks-v1 | archipelago-v1 |
| blur-v1 | blur-v2 | element-v1 | element-v2 |
| ens_vision-v1 | ens_vision-v2 | gem-v1 | gem-v2 |
| gem-v3 | gem-v4 | gem-v5 | gem-v6 |
| genie-v1 | liquidifty-v1 | looksrare-v2 | makersplace-v1 |
| makersplace-v2 | makersplace-v3 | manifold-v1 | nf3-v1 |
| nftx-v2 | opensea-seadrop | opensea-seaport | rarible-v1 |
| rarible-v2 | reservoir-v1 | reservoir-v2 | reservoir-v3 |
| reservoir-v4 | reservoir-v5 | reservoir-v6 | reservoir-v7 |
| sudoswap-v1 | sudoswap-v2 | thirdweb-v1 | treasure-v1 |
| uniswap-v1 | uniswap-v2 | x2y2-v1 | zerion-dna |
Indexes
| Index |
|---|
| exchange_name, contract_address, timestamp, log_index, multi_token_sale_index |
| __last_modified |
| buyer_address, 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 |
| __indexer_id WHERE __confirmed = false |
| seller_address, timestamp, log_index, multi_token_sale_index |
| __indexer_id, __block_number |
| timestamp, log_index, multi_token_sale_index |
| exchange_name, contract_address, token_id, timestamp, log_index, multi_token_sale_index |
| transaction_hash, log_index, multi_token_sale_index |
| exchange_name, timestamp, log_index, multi_token_sale_index |
| 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.