> ## 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          | `celo.dex.trades`                                     |
| Table Status        | Production-Ready                                      |
| Unique Key          | `block_timestamp`, `unique_id`                        |
| Clustering Key(s)   | `block_timestamp::date`                               |
| Search Optimization | `transaction_hash`, `project`, `token_bought_address` |

### Table Columns

| Column Name                     | Data Type          | Description                                                                                                                                                             |
| ------------------------------- | ------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| project                         | VARCHAR(134217728) | The project (decentralized exchange) of the liquidity pool that the swap occurred from.                                                                                 |
| protocol                        | VARCHAR(134217728) | DEX protocol (& version, if applicable) of the contract address facilitating the swap.                                                                                  |
| liquidity\_pool\_address        | VARCHAR(42)        | Contract address of the liquidity pool holding the asset. For protocol without the concept of LP such as airswap, this will be null.                                    |
| sender\_address                 | VARCHAR(42)        | The address of the sender emitted on the swap event logs. This can be a router or pool address.                                                                         |
| to\_address                     | VARCHAR(42)        | Address of the recipient emitted on the swap event logs. For example, recipient\_address from the uniswap v3 swap event log.                                            |
| token\_sold\_address            | VARCHAR(42)        | Token address of the token sold.                                                                                                                                        |
| token\_sold\_name               | VARCHAR(134217728) | Name of the token sold.                                                                                                                                                 |
| token\_sold\_symbol             | VARCHAR(134217728) | Symbol of the token sold.                                                                                                                                               |
| token\_sold\_decimals           | NUMBER(38,0)       | Token decimals of the token sold.                                                                                                                                       |
| token\_sold\_amount\_raw\_str   | VARCHAR(134217728) | Raw amount of tokens sold (unnormalized) in string.                                                                                                                     |
| token\_sold\_amount\_raw        | FLOAT              | Raw amount of tokens sold (unnormalized).                                                                                                                               |
| token\_sold\_amount\_str        | VARCHAR(134217728) | Amount of tokens sold in string.                                                                                                                                        |
| token\_sold\_amount             | FLOAT              | Amount of tokens sold.                                                                                                                                                  |
| usd\_sold\_amount               | FLOAT              | Amount of token sold in USD value.                                                                                                                                      |
| token\_bought\_address          | VARCHAR(42)        | Token address of the token bought, i.e. the asset acquired from the trade.                                                                                              |
| token\_bought\_name             | VARCHAR(134217728) | Name of the token bought.                                                                                                                                               |
| token\_bought\_symbol           | VARCHAR(134217728) | Symbol of the token bought.                                                                                                                                             |
| token\_bought\_decimals         | NUMBER(38,0)       | Token decimals of the token bought.                                                                                                                                     |
| token\_bought\_amount\_raw\_str | VARCHAR(134217728) | Raw amount of tokens bought (unnormalized) in string.                                                                                                                   |
| token\_bought\_amount\_raw      | FLOAT              | Raw amount of tokens bought (unnormalized).                                                                                                                             |
| token\_bought\_amount\_str      | VARCHAR(134217728) | Amount of tokens bought in string.                                                                                                                                      |
| token\_bought\_amount           | FLOAT              | Amount of tokens bought.                                                                                                                                                |
| usd\_bought\_amount             | FLOAT              | Amount of token bought in USD value.                                                                                                                                    |
| usd\_amount                     | FLOAT              | USD value of the swap. This field preferentially selects the USD value of ETH and Stablecoin (USDT/USDC) tokens, as spam token prices may conflate the true swap value. |
| extra\_fields                   | VARIANT            | This field contains all the extra columns emitted from the event/function call that were not part of the convetional DEX trades columns.                                |
| swap\_count                     | NUMBER(38,0)       | Swap count within the transaction.                                                                                                                                      |
| transaction\_fees               | VARCHAR(134217728) | Fees paid at the transaction level. Varchar to retain precision.                                                                                                        |
| transaction\_fees\_usd          | FLOAT              | Fees paid in USD.                                                                                                                                                       |
| fee\_details                    | VARIANT            | Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction.                                                      |
| transaction\_from\_address      | VARCHAR(42)        | Transaction sender address. I.e. the address of the transaction initiator. (from\_address in the raw\.transactions field for the transaction\_hash of this swap).       |
| transaction\_to\_address        | VARCHAR(42)        | Transaction receiver. (to\_address in the raw\.transactions field for the transaction\_hash of this swap).                                                              |
| transaction\_hash               | VARCHAR(66)        | Transaction hash that this swap belongs to.                                                                                                                             |
| transaction\_index              | NUMBER(38,0)       | The position of this transaction in the block that it belongs to. The first transaction has index 0.                                                                    |
| selector                        | VARCHAR(134217728) | 4byte selector of the transaction.                                                                                                                                      |
| log\_index                      | NUMBER(38,0)       | The position of the swap event log in the transaction.                                                                                                                  |
| block\_timestamp                | TIMESTAMP\_NTZ(9)  | Block timestamp of the swap event.                                                                                                                                      |
| block\_number                   | NUMBER(38,0)       | Block number of the swap event.                                                                                                                                         |
| block\_hash                     | VARCHAR(66)        | Block hash of the swap event.                                                                                                                                           |
| unique\_id                      | VARCHAR(134217728) | Unique ID of 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.                                                                                                           |
| \_changed\_since\_full\_refresh | BOOLEAN            | Indicates if the record has changed since the last full data refresh.                                                                                                   |

### Related Docs

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