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

### Table Details

| Property          | Value                                  |
| ----------------- | -------------------------------------- |
| Table Name        | `unichain.dex.unhydrated_orderflow_v2` |
| Table Status      | Production-Ready                       |
| Unique Key        | `block_timestamp`, `transaction_hash`  |
| Clustering Key(s) | `block_timestamp::date`                |

### Table Columns

| Column Name         | Data Type         | Description                                                                                                                                             |
| ------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- |
| origin              | VARCHAR(16777216) | The frontend or entry point of the transaction, from integrator metadata or Allium's label of the transaction `to_address`.                             |
| integrators         | VARIANT           | Normalized frontend/wallet identifiers (e.g. `ledger`, `exodus`, `jumper_exchange`) extracted from aggregator event metadata.                           |
| meta\_aggregator    | VARCHAR(16777216) | Project name of the highest-priority meta-aggregator or intent protocol (e.g. `lifi`, `cow_protocol`).                                                  |
| aggregator          | VARCHAR(16777216) | Project name of the standard aggregator (e.g. `paraswap_v5`, `1inch`). Null if a meta-aggregator exists.                                                |
| pmm\_address        | VARCHAR(16777216) | Private market maker address from maker/executor/signerWallet fields (RFQ and limit-order protocols).                                                   |
| solver\_address     | VARCHAR(16777216) | Solver/filler address for intent-based protocols.                                                                                                       |
| swapper\_address    | VARCHAR(16777216) | The end user of the swap: `sender_address` for intent-based swaps, otherwise the transaction sender.                                                    |
| from\_address       | VARCHAR(16777216) | Transaction sender (`transaction_from_address`).                                                                                                        |
| to\_address         | VARCHAR(16777216) | Transaction recipient (`transaction_to_address`).                                                                                                       |
| usd\_volume         | FLOAT             | Largest single swap leg in the transaction; approximates the user's trade size.                                                                         |
| total\_usd\_volume  | FLOAT             | Sum of all swap volumes in the transaction including intermediate hops.                                                                                 |
| user\_token\_input  | VARCHAR(16777216) | First token sold in chronological order.                                                                                                                |
| user\_token\_output | VARCHAR(16777216) | Last token bought in chronological order.                                                                                                               |
| liquidity\_details  | VARIANT           | Array of pool objects (`project`, `protocol`, `liquidity_pool_address`, `pair`, `usd_amount`, `log_index`, `id`) for all AMM swaps. Excludes RFQ fills. |
| block\_number       | NUMBER(38,0)      | Sequential number of the block that contains this record.                                                                                               |
| block\_timestamp    | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                 |
| transaction\_index  | NUMBER(38,0)      | Zero-based position of the transaction within its block.                                                                                                |
| transaction\_hash   | VARCHAR(66)       | Hash of the transaction that produced this 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.                                                                                           |

### Related Docs

* [EVM DEX Unhydrated Orderflow V2](/historical-data/supported-blockchains/evm/core-schemas/dex/unhydrated-orderflow-v2)