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

# Unhydrated Orderflow

### Table Details

| Property          | Value                           |
| ----------------- | ------------------------------- |
| Table Name        | `celo.dex.unhydrated_orderflow` |
| Table Status      | Production-Ready                |
| Unique Key        | `block_timestamp`, `unique_id`  |
| Clustering Key(s) | `block_timestamp::date`         |

### Table Columns

| Column Name                 | Data Type          | Description                                                       |
| --------------------------- | ------------------ | ----------------------------------------------------------------- |
| block\_number               | NUMBER(38,0)       | The block number in which the transaction was included.           |
| block\_timestamp            | TIMESTAMP\_NTZ(9)  | The timestamp of the block in which the transaction was included. |
| transaction\_hash           | VARCHAR(66)        | The hash of the transaction.                                      |
| transaction\_index          | NUMBER(38,0)       | The index of the transaction within the block.                    |
| swapper\_address            | VARCHAR(42)        | The address of the user performing the swap.                      |
| from\_address               | VARCHAR(42)        | The address initiating the transaction (msg.sender).              |
| to\_address                 | VARCHAR(42)        | The address receiving the transaction.                            |
| is\_aggregator              | BOOLEAN            | Flag indicating if the transaction is an aggregator.              |
| usd\_volume                 | FLOAT              | The max usd\_amount of the swap within the entire transaction.    |
| total\_usd\_volume          | FLOAT              | The sum of the usd\_amount of all swaps within the transaction.   |
| senders                     | VARIANT            | Array of addresses sending tokens in the transaction.             |
| recipients                  | VARIANT            | Array of addresses receiving tokens in the transaction.           |
| user\_token\_input          | VARCHAR(42)        | First token sold in chronological order.                          |
| user\_token\_input\_symbol  | VARCHAR(134217728) | Symbol of the first token sold in chronological order.            |
| user\_token\_output         | VARCHAR(42)        | Last token bought in chronological order.                         |
| user\_token\_output\_symbol | VARCHAR(134217728) | Symbol of the last token bought in chronological order.           |
| tokens\_sold                | VARIANT            | Array of tokens sold in the transaction.                          |
| tokens\_bought              | VARIANT            | Array of tokens bought in the transaction.                        |
| integrators                 | VARIANT            | Array of integrator names involved in the transaction.            |
| integrator\_tags            | VARIANT            | Array of integrator contract addresses.                           |
| aggregator\_source          | VARIANT            | Source of the aggregator.                                         |
| aggregator\_usd\_volume     | FLOAT              | USD volume of the aggregator portion.                             |
| aggregators                 | VARIANT            | Array of aggregator contracts involved.                           |
| aggregators\_count          | NUMBER(38,0)       | Count of aggregators involved.                                    |
| aggregator\_details         | VARIANT            | JSON details of aggregator swaps.                                 |
| liquidity\_source           | VARIANT            | Array of liquidity sources used.                                  |
| liquidity\_usd\_volume      | FLOAT              | USD volume from liquidity sources.                                |
| liquidity\_pools            | VARIANT            | Array of liquidity pool addresses used.                           |
| liquidity\_pools\_count     | NUMBER(38,0)       | Count of liquidity pools involved.                                |
| liquidity\_details          | VARIANT            | JSON details of liquidity pool swaps.                             |
| total\_trades               | NUMBER(38,0)       | Total number of trades in the transaction.                        |
| unique\_id                  | VARCHAR(134217728) | Unique identifier for the orderflow record.                       |
| \_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.     |