> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# unidex_v1_bsc

> Tables in tt-contracts.unidex_v1_bsc

## Tables

### Settlement\_Settlement\_event

Settlement execution events from the UniDex v1 protocol containing solver addresses authorized to execute settlements. Records when solvers are added to or removed from the settlement allow list across multiple chains.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_solver`        | `STRING`    | Address of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.                    |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.unidex_v1_bsc.Settlement_Settlement_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### Settlement\_Trade\_event

Trade execution events from UniDex V1 settlement contracts containing order identifiers, token swap details (buy/sell tokens and amounts), owner addresses, and fee information. Used for tracking DEX (Decentralized Exchange) order settlement and trade volume analysis across multiple chains.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_owner`         | `STRING`    | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_sellToken`     | `STRING`    | Contract address of the token being sold in the trade. Hex-encoded, 0x-prefixed, 42-character string.                                                |
  | `in_buyToken`      | `STRING`    | Contract address of the token being purchased in the trade. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in_sellAmount`    | `STRING`    | Amount of tokens sold in the trade. Numeric string representation of token quantity in smallest denomination.                                        |
  | `in_buyAmount`     | `STRING`    | Amount of tokens received in the trade. Numeric string representation of token quantity in smallest denomination.                                    |
  | `in_feeAmount`     | `STRING`    | Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.                        |
  | `in_orderUid`      | `STRING`    | Unique identifier for the order being executed in the trade. Hex-encoded string containing order hash, owner address, and validity timestamp.        |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.unidex_v1_bsc.Settlement_Trade_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***