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

# Sudoswap Trades

### Table Details

| Property     | Value                           |
| ------------ | ------------------------------- |
| Table Name   | `ethereum.nfts.sudoswap_trades` |
| Table Status | Production-Ready                |

### Table Columns

| Column Name           | Data Type         | Description                                                                                                                                                                                             |
| --------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| order\_match\_type    | VARCHAR(4)        | How the order was fulfilled. `BUY` for a direct purchase at list price; `ACCEPT_BID` for a seller accepting an existing bid.                                                                            |
| pool\_address         | VARCHAR(42)       | Address of the EIP-1167 SettlementPool clone that holds the user's USDC collateral.                                                                                                                     |
| token\_address        | VARCHAR(16777216) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. |
| token\_symbol         | VARCHAR(16777216) | Ticker symbol of the token (e.g. "USDC", "WETH").                                                                                                                                                       |
| token\_ids            | ARRAY             | Array of NFT token IDs transferred in this trade. Multiple IDs indicate a batch swap of several NFTs in a single transaction.                                                                           |
| eth\_total\_raw       | NUMBER(38,0)      | Total ETH amount for this Sudoswap trade in wei (not decimal-adjusted). Sum of all ETH transferred for the full batch of NFTs.                                                                          |
| eth\_total\_volume    | FLOAT             | Total ETH amount for this Sudoswap trade (decimal-adjusted). Equal to `eth_total_raw / 1e18`.                                                                                                           |
| usd\_total\_volume    | FLOAT             | Total USD value of this Sudoswap trade, computed as `eth_total_volume * usd_exchange_rate`.                                                                                                             |
| eth\_unit\_price\_raw | NUMBER(38,6)      | ETH price per individual NFT in this trade in wei (not decimal-adjusted).                                                                                                                               |
| eth\_unit\_price      | FLOAT             | ETH price per individual NFT in this trade (decimal-adjusted). Equal to `eth_total_volume / count(token_ids)`.                                                                                          |
| usd\_unit\_price      | FLOAT             | USD price per individual NFT in this trade, computed as `eth_unit_price * usd_exchange_rate`.                                                                                                           |
| usd\_exchange\_rate   | VARCHAR(16777216) | USD price per unit of the token at the time of the event, used to compute `usd_amount`. Sourced from Allium's hourly price feed.                                                                        |
| transaction\_hash     | VARCHAR(66)       | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                                                             |
| block\_timestamp      | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                                                                 |
| block\_number         | NUMBER(38,0)      | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block.                                                                           |
| block\_hash           | VARCHAR(66)       | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                                                                                          |
| \_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.                                                                                                                                           |