> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Trades

### Table Details

| Property | Value |
| - | - |
| Table Name | `abstract.nfts.trades` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp`, `unique_id` |
| Clustering Key(s) | `block_timestamp::date` |
| Search Optimization | `transaction_hash`, `buyer_address`, `seller_address`, `token_address` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| marketplace | VARCHAR(134217728) | Marketplace where the trade occurred (e.g., opensea, aavegotchi, magiceden, oneplanet, nftkey) |
| protocol | VARCHAR(134217728) | Protocol used for the trade (e.g., x2y2, seaport) |
| order\_match\_type | VARCHAR(134217728) | Type of order match: 'ACCEPT\_BID' or 'BUY' |
| trade\_type | VARCHAR(134217728) | Type of trade: 'SINGLE\_TRADE' or 'BUNDLE\_TRADE' |
| buyer\_address | VARCHAR(42) | Address of the buyer |
| seller\_address | VARCHAR(42) | Address of the seller |
| token\_standard | VARCHAR(134217728) | Token standard of the NFT (e.g., ERC721, ERC1155) |
| token\_address | VARCHAR(42) | Contract address of the NFT collection |
| token\_id | VARCHAR(134217728) | ID of the NFT traded |
| token\_name | VARCHAR(134217728) | Name of the NFT collection |
| token\_symbol | VARCHAR(134217728) | Symbol of the NFT collection |
| item\_quantity | VARCHAR(134217728) | Number of NFTs bought |
| currency\_address | VARCHAR(42) | Address of the currency used in the trade (zero address for native tokens) |
| currency\_symbol | VARCHAR(134217728) | Symbol of the currency used in the trade |
| raw\_price | VARCHAR(134217728) | Price of the NFT in the original currency (not divided by decimals) |
| price | FLOAT | 'raw\_price' divided by the number of decimals of the currency |
| usd\_price | FLOAT | USD price of the NFTs in this trade |
| agg\_fees | VARIANT | Aggregated fees information including creator, platform, and total fees |
| buyer\_fees | VARIANT | Fees paid by the buyer |
| seller\_fees | VARIANT | Fees paid by the seller |
| aggregator\_name | VARCHAR(134217728) | Name of the aggregator used for the trade (if applicable) |
| aggregator\_address | VARCHAR(42) | Contract address of the aggregator used for the trade (if applicable) |
| extra\_fields | VARIANT | Additional information specific to the trade or protocol |
| transaction\_hash | VARCHAR(66) | Transaction hash of this trade |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp of the block when the trade occurred |
| block\_number | NUMBER(38,0) | Number of the block when the trade occurred |
| block\_hash | VARCHAR(66) | Hash of the block when the trade occurred |
| unique\_id | VARCHAR(134217728) | Unique identifier for each trade |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| \_helper\_nft\_tokens\_\_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp when the NFT token metadata used for enrichment was last updated. |
| \_changed\_since\_full\_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |

### Related Docs

* [EVM NFTs Trades](/historical-data/supported-blockchains/evm/core-schemas/nfts/trades)