> ## 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          | `hyperevm.nfts.trades`                                                 |
| Table Status        | Production-Ready                                                       |
| Unique Key          | `block_timestamp`, `unique_id`                                         |
| Clustering Key(s)   | `block_timestamp::date, marketplace`                                   |
| Search Optimization | `transaction_hash`, `buyer_address`, `seller_address`, `token_address` |

### Table Columns

| Column Name                          | Data Type         | Description                                                                                    |
| ------------------------------------ | ----------------- | ---------------------------------------------------------------------------------------------- |
| marketplace                          | VARCHAR(16777216) | Marketplace where the trade occurred (e.g., opensea, aavegotchi, magiceden, oneplanet, nftkey) |
| protocol                             | VARCHAR(16777216) | Protocol used for the trade (e.g., x2y2, seaport)                                              |
| order\_match\_type                   | VARCHAR(16777216) | Type of order match: 'ACCEPT\_BID' or 'BUY'                                                    |
| trade\_type                          | VARCHAR(16777216) | 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(16777216) | Token standard of the NFT (e.g., ERC721, ERC1155)                                              |
| token\_address                       | VARCHAR(42)       | Contract address of the NFT collection                                                         |
| token\_id                            | VARCHAR(16777216) | ID of the NFT traded                                                                           |
| token\_name                          | VARCHAR(16777216) | Name of the NFT collection                                                                     |
| token\_symbol                        | VARCHAR(16777216) | Symbol of the NFT collection                                                                   |
| item\_quantity                       | VARCHAR(16777216) | Number of NFTs bought                                                                          |
| currency\_address                    | VARCHAR(42)       | Address of the currency used in the trade (zero address for native tokens)                     |
| currency\_symbol                     | VARCHAR(16777216) | Symbol of the currency used in the trade                                                       |
| raw\_price                           | VARCHAR(16777216) | 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(16777216) | 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(16777216) | 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)