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

The DEX trades table contains successful swaps made on decentralized exchanges (DEX), consolidated into a single table.

### Coverage:

Currently, we support 9 DEX protocols and over 25+ DEX projects on Sui.

| Projects                                                                                                                      | Protocols         |
| ----------------------------------------------------------------------------------------------------------------------------- | ----------------- |
| cetus, cetus\_adapter, daos\_sui, movescription, suiai, suiemoji, suipump, moonbags                                           | cetus\_protocol   |
| bluefin                                                                                                                       | bluefin           |
| turbos                                                                                                                        | turbos            |
| momentum, flowx, kriya, steamm, aftermath, volo, haedal, deepbook, afsui, obric, alphafi, metastable, scallop, suilend, hawal | cetus\_aggregator |
| flowx                                                                                                                         | flowx\_v3         |
| flowx                                                                                                                         | flowx\_v2         |
| bluemove, move\_pump                                                                                                          | bluemove          |
| deepbook                                                                                                                      | deepbook          |
| momentum                                                                                                                      | momentum          |

We add new DEX protocols on a case-by-case basis. If you'd like to request support for a specific DEX, please reach out to our team. Your feedback helps us prioritize our roadmap.

### Table Columns

`_str` columns are numeric fields cast `varchar` to retain precision when summing.

Unique Key: `unique_id`

| Column                          | Description                                                                                                                |
| ------------------------------- | -------------------------------------------------------------------------------------------------------------------------- |
| project                         | The project (decentralized exchange) of the liquidity pool that the swap occurred from.                                    |
| protocol                        | DEX protocol (& version, if applicable) of the contract address facilitating the swap.                                     |
| liquidity\_pool\_address        | The aaddress of the liquidity pool holding the asset                                                                       |
| sender\_address                 | The address of the sender emitted on the swap event logs.                                                                  |
| to\_address                     | Address of the recipient emitted on the swap event logs.                                                                   |
| coin\_sold\_type                | Type of the coin sold.                                                                                                     |
| coin\_sold\_name                | Name of the coin sold.                                                                                                     |
| coin\_sold\_symbol              | Symbol of the coin sold.                                                                                                   |
| coin\_sold\_decimals            | Coin decimals of the coin sold.                                                                                            |
| coin\_sold\_amount\_raw\_str    | Raw amount of coins sold (unnormalized) in string.                                                                         |
| coin\_sold\_amount\_raw         | Raw amount of coins sold (unnormalized).                                                                                   |
| coin\_sold\_amount\_str         | Amount of coins sold in string.                                                                                            |
| coin\_sold\_amount              | Amount of coins sold.                                                                                                      |
| usd\_sold\_amount               | Amount of coin sold in USD value.                                                                                          |
| coin\_bought\_type              | Type of the coin bought.                                                                                                   |
| coin\_bought\_name              | Name of the coin bought.                                                                                                   |
| coin\_bought\_symbol            | Symbol of the coin bought.                                                                                                 |
| coin\_bought\_decimals          | Coin decimals of the coin bought.                                                                                          |
| coin\_bought\_amount\_raw\_str  | Raw amount of coins bought (unnormalized) in string.                                                                       |
| coin\_bought\_amount\_raw       | Raw amount of coins bought (unnormalized).                                                                                 |
| coin\_bought\_amount\_str       | Amount of coins bought in string.                                                                                          |
| coin\_bought\_amount            | Amount of coins bought.                                                                                                    |
| usd\_bought\_amount             | Amount of coin bought in USD value.                                                                                        |
| usd\_amount                     | USD value of the swap. This field preferentially selects the USD value of Native Assets and Stablecoin (USDT/USDC) tokens. |
| transaction\_block\_digest      | Digest of the transaction block containing this swap.                                                                      |
| event\_seq                      | Sequence number of the event within the transaction.                                                                       |
| checkpoint\_timestamp           | Timestamp of the checkpoint containing this swap.                                                                          |
| checkpoint\_sequence            | Sequence number of the checkpoint.                                                                                         |
| checkpoint\_digest              | Digest of the checkpoint.                                                                                                  |
| unique\_id                      | Unique ID of each trade.                                                                                                   |
| \_created\_at                   | Timestamp when the record was created.                                                                                     |
| \_updated\_at                   | Timestamp when the record was last updated.                                                                                |
| \_changed\_since\_full\_refresh | Boolean indicating if the record has changed since the last full refresh.                                                  |