> ## 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.

# NFT Trades

The `near.nfts.trades` model captures NFT sales from nep-171 compatible tokens. This model provides detailed information about each trade, including marketplace, protocol, and various trade-specific details.

<Note>
  * Marketplace royalties and fees coverage is nested under the `extra_fields` segment for purchases involving payout of royalties.
</Note>

### Marketplace and Protocol Coverage

| Marketplace  |
| ------------ |
| apollo42     |
| fewandfar    |
| l2e          |
| mitte        |
| nft\_uniqart |
| paras        |
| tradeport    |

### Sample Query

NFT Volume Across Marketplace in the last 90 days.

```sql theme={null}
select
    date(block_timestamp) as date,
    marketplace,
    sum(usd_price) as usd_volume
from near.nfts.trades
where block_timestamp >= current_timestamp - interval '90 days'
group by all
```

### Model Description

NFT trades events NEAR event logs receipt. Broadly, this includes nep-171 compatible tokens.

### Columns

| Column Name                          | Description                                                    |
| ------------------------------------ | -------------------------------------------------------------- |
| marketplace                          | The marketplace of the trade.                                  |
| protocol                             | The protocol of the trade.                                     |
| order\_match\_type                   | The type of order match.                                       |
| trade\_type                          | The type of trade.                                             |
| buyer\_address                       | The address of the buyer.                                      |
| seller\_address                      | The address of the seller.                                     |
| token\_standard                      | The standard of the token, e.g. nep-171.                       |
| token\_address                       | The contract address of the NFT being traded.                  |
| token\_id                            | The ID of the NFT being traded.                                |
| token\_name                          | The name of the NFT being traded.                              |
| token\_symbol                        | The symbol of the NFT being traded.                            |
| item\_quantity                       | The quantity of the NFT being traded. Defaults to 1.           |
| currency\_address                    | The contract address of the currency used to pay for the NFT.  |
| currency\_name                       | The name of the currency used to pay for the NFT.              |
| currency\_symbol                     | The symbol of the currency used to pay for the NFT.            |
| raw\_price                           | The raw price of the NFT being traded.                         |
| price                                | The price of the NFT being traded.                             |
| usd\_price                           | The price of the NFT being traded in USD.                      |
| agg\_fees                            | The aggregate fees of the trade.                               |
| buyer\_fees                          | The fees paid by the buyer.                                    |
| seller\_fees                         | The fees paid by the seller.                                   |
| extra\_fields                        | The extra fields of the trade.                                 |
| signer\_id                           | The address of the transaction signer.                         |
| receiver\_id                         | The address of the transaction receiver.                       |
| transaction\_hash                    | The hash of the transaction.                                   |
| block\_height                        | The block height of the transaction.                           |
| receipt\_id                          | The ID of the receipt.                                         |
| unique\_id                           | The unique ID of the trade.                                    |
| \_helper\_nft\_tokens\_\_updated\_at | The timestamp of the last update of the NFT tokens.            |
| \_created\_at                        | The timestamp of the entry of the trade in the database.       |
| \_updated\_at                        | The timestamp of the last update of the trade in the database. |