> ## 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        | `mode.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)      | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block.                                                         |
| block\_timestamp            | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                                               |
| transaction\_hash           | VARCHAR(66)       | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                                           |
| transaction\_index          | NUMBER(38,0)      | Zero-based position of the transaction within its block. The first transaction in a block has index 0.                                                                                |
| swapper\_address            | VARCHAR(42)       | Address of the account that initiated the swap (end user).                                                                                                                            |
| from\_address               | VARCHAR(42)       | Address that initiated or sent from in this event. For token transfers, the account whose balance decreased. For transactions, the transaction sender (msg.sender).                   |
| to\_address                 | VARCHAR(42)       | Address that received in this event. For token transfers, the account whose balance increased. For transactions, the destination address (may be a smart contract).                   |
| is\_aggregator              | BOOLEAN           | Boolean indicating if the trade was executed through a DEX aggregator.                                                                                                                |
| usd\_volume                 | FLOAT             | USD value of the individual trade.                                                                                                                                                    |
| total\_usd\_volume          | FLOAT             | Total USD value of all trades in the transaction.                                                                                                                                     |
| senders                     | VARIANT           | Array of addresses that sent tokens in the trade.                                                                                                                                     |
| recipients                  | VARIANT           | Array of addresses that received tokens in the trade.                                                                                                                                 |
| user\_token\_input          | VARCHAR(42)       | Address of the token the user sent in the trade.                                                                                                                                      |
| user\_token\_input\_symbol  | VARCHAR(16777216) | Symbol of the token the user sent.                                                                                                                                                    |
| user\_token\_output         | VARCHAR(42)       | Address of the token the user received in the trade.                                                                                                                                  |
| user\_token\_output\_symbol | VARCHAR(16777216) | Symbol of the token the user received.                                                                                                                                                |
| tokens\_sold                | VARIANT           | Array of token addresses that were sold in the trade.                                                                                                                                 |
| tokens\_bought              | VARIANT           | Array of token addresses that were bought in the trade.                                                                                                                               |
| integrators                 | VARIANT           | Array of integrator addresses used in the trade.                                                                                                                                      |
| integrator\_tags            | VARIANT           | Array of tags associated with the integrators.                                                                                                                                        |
| aggregator\_source          | VARIANT           | Source of the aggregation if the trade was executed through an aggregator.                                                                                                            |
| aggregator\_usd\_volume     | FLOAT             | USD volume of the trade portion executed through aggregators.                                                                                                                         |
| aggregators                 | VARIANT           | Array of aggregator addresses used in the trade.                                                                                                                                      |
| aggregators\_count          | NUMBER(38,0)      | Number of different aggregators used in the trade.                                                                                                                                    |
| aggregator\_details         | VARIANT           | Detailed information about the aggregator portion of the trade.                                                                                                                       |
| liquidity\_source           | VARIANT           | Array of DEX protocols that provided liquidity for the trade.                                                                                                                         |
| liquidity\_usd\_volume      | FLOAT             | USD volume of the trade portion executed through DEX liquidity pools.                                                                                                                 |
| liquidity\_pools            | VARIANT           | Array of liquidity pool addresses used in the trade.                                                                                                                                  |
| liquidity\_pools\_count     | NUMBER(38,0)      | Number of different liquidity pools used in the trade.                                                                                                                                |
| liquidity\_details          | VARIANT           | Detailed information about the liquidity sources used, including protocol, pair, and amounts.                                                                                         |
| total\_trades               | NUMBER(38,0)      | Total number of individual trades executed in this transaction.                                                                                                                       |
| unique\_id                  | VARCHAR(16777216) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| \_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.                                                                                                                         |