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

# Orderflow

### Table Details

| Property     | Value                           |
| ------------ | ------------------------------- |
| Table Name   | `scroll.dex.orderflow`          |
| Table Status | Production-Ready                |
| Unique Key   | `transaction_hash`, `unique_id` |

### Table Columns

| Column Name                 | Data Type         | Description                                                                                                                                                                                                                                       |
| --------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| frontend                    | VARCHAR(16777216) | The frontend interface used for the transaction                                                                                                                                                                                                   |
| 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. For most trades, this comes from the `transaction_from_address` field in dex.trades / dex.aggregator\_trades. However, for UniswapX and CowProtocol swaps, it comes from the `sender` field instead. |
| 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 volume of the transaction in USD                                                                                                                                                                                                              |
| total\_usd\_volume          | FLOAT             | The total volume of the transaction in USD                                                                                                                                                                                                        |
| 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)       | Address of the token the user is selling                                                                                                                                                                                                          |
| user\_token\_input\_symbol  | VARCHAR(16777216) | Symbol of the token the user is selling                                                                                                                                                                                                           |
| user\_token\_output         | VARCHAR(42)       | Address of the token the user is buying                                                                                                                                                                                                           |
| user\_token\_output\_symbol | VARCHAR(16777216) | Symbol of the token the user is buying                                                                                                                                                                                                            |
| 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(16777216) | Unique identifier for the transaction                                                                                                                                                                                                             |
| \_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 Orderflow](/historical-data/supported-blockchains/evm/core-schemas/dex/orderflow)