> ## 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.
# mux_v2_avalanche
> Tables in tt-contracts.mux_v2_avalanche
## Tables
### LiquidityPool\_AddAsset\_event
Event log recording the addition of a new asset to a MUX Protocol v2 liquidity pool, including asset identifier, token addresses, decimal precision, symbol, and stablecoin classification. Used for tracking pool composition changes and supported asset configurations.
| 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_id` | `INT64` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_symbol` | `STRING` | Symbol of the token involved in the transaction or event. |
| `in_decimals` | `INT64` | Number of decimal places for the token. Integer value defining precision for token amount representations. |
| `in_isStable` | `BOOL` | Boolean flag indicating whether the asset is classified as a stablecoin. |
| `in_tokenAddress` | `STRING` | Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_muxTokenAddress` | `STRING` | Contract address of the MUX protocol's liquidity pool token for the asset. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_id | address | removed | in\_symbol | log\_index | in\_decimals | in\_isStable | block\_number | block\_timestamp | in\_tokenAddress | transaction\_hash | in\_muxTokenAddress |
| ------ | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ---------- | ------------ | ------------ | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 6 | 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | false | 0x424e420000000000000000000000000000000000000000000000000000000000 | 57 | 18 | false | 14333910 | 2022-05-06T06:14:02.000Z | 0x0000000000000000000000000000000000000000 | 0x31dbabd1dee3622835f6ee307945c5cc72835f7aafa65409a6caab4827cc645e | 0x30a667df8562a2460f45ac297d833a36feac0c2f |
| 7 | 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | false | 0x46544d0000000000000000000000000000000000000000000000000000000000 | 68 | 18 | false | 14334213 | 2022-05-06T06:24:30.000Z | 0x0000000000000000000000000000000000000000 | 0x36d088796097094542dbe67cbc12805123575f631addbec4fa6426c7368f56ba | 0x70d30270ccc356f47e5782a1a905ea85b9e08cea |
| 5 | 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | false | 0x4156415800000000000000000000000000000000000000000000000000000000 | 70 | 18 | false | 14333902 | 2022-05-06T06:13:47.000Z | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0x03cb4744dfbfa10bf9c10c01daa8f31f766713806ce52b6f0cda665ae581c7d8 | 0xac80096d53c5965d9432592d28687c521472b9eb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.mux_v2_avalanche.LiquidityPool_AddAsset_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_ClosePosition\_event
Position closure events from MUX Protocol liquidity pools containing trader address, position size, asset prices, profit/loss, fees, and remaining balances. Used for tracking leverage trading activity and calculating realized PnL across perpetual futures positions.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assetId` | `INT64` | Unique identifier for the asset or token involved in the operation. Hex-encoded, 0x-prefixed, 66-character string. |
| `in_args` | `STRUCT` | Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed. |
| address | in\_args | removed | in\_trader | log\_index | in\_assetId | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"6887550000000000000000","feeUsd":"6816532102777320000","isLong":true,"pnlUsd":"345053719659000000000","hasProfit":true,"assetPrice":"504943340000000000","collateralId":0,"subAccountId":"0x17c13c3ac2e455c7a625b6e31016eb2071148996000701000000000000000000","profitAssetId":0,"remainPosition":"0","collateralPrice":"1000000000000000000","profitAssetPrice":"1000000000000000000","remainCollateral":"447493784974593600000"} | false | 0x17c13c3ac2e455c7a625b6e31016eb2071148996 | 2 | 7 | 26254154 | 2023-02-14T16:43:41.000Z | 0x49856c1c6b015924ec1a2e714c2c5c9d22f72d94f7234ae69062eff8803c17dc |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"7640410000000000000000","feeUsd":"4289204155124218000","isLong":true,"pnlUsd":"353517033645800000000","hasProfit":true,"assetPrice":"515031220000000000","collateralId":9,"subAccountId":"0x29a31e68a5c3b052ac04a663f1e60a2cf184ff53090701000000000000000000","profitAssetId":0,"remainPosition":"0","collateralPrice":"1000000000000000000","profitAssetPrice":"1000000000000000000","remainCollateral":"357714773880036480000"} | false | 0x29a31e68a5c3b052ac04a663f1e60a2cf184ff53 | 2 | 7 | 26259868 | 2023-02-14T19:55:38.000Z | 0x5b59c5df7c6662c3a975f682a47849643e184c7ab6d932ff19bd4a83e4bf0e71 |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"642000000000000000","feeUsd":"1954925952000000000","isLong":true,"pnlUsd":"1476600000000000000","hasProfit":true,"assetPrice":"1553600000000000000000","collateralId":0,"subAccountId":"0x2fcf87fc895a79a697e79756b53720b351c4f761000301000000000000000000","profitAssetId":3,"remainPosition":"0","collateralPrice":"1000000000000000000","profitAssetPrice":"1553600000000000000000","remainCollateral":"198724926368000000000"} | false | 0x2fcf87fc895a79a697e79756b53720b351c4f761 | 2 | 3 | 26258759 | 2023-02-14T19:18:18.000Z | 0x95b273ca3a2f757e4f5770965093c563232bb86335e6bf9ddd54d05171b0da5d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.mux_v2_avalanche.LiquidityPool_ClosePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_Liquidate\_event
Position liquidation events from MUX Protocol perpetual futures contracts containing trader and liquidator addresses, position details, collateral amounts, profit/loss calculations, and penalty distributions to liquidity pools.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assetId` | `INT64` | Unique identifier for the asset or token involved in the operation. Hex-encoded, 0x-prefixed, 66-character string. |
| `in_args` | `STRUCT` | Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed. |
| address | in\_args | removed | in\_trader | log\_index | in\_assetId | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"17797000000000000000","feeUsd":"0","isLong":false,"pnlUsd":"3473611341200000000","hasProfit":false,"assetPrice":"19339179200000000000","collateralId":0,"subAccountId":"0xfc6da13c808e3e674e35b76228f53f1de189579c000500000000000000000000","profitAssetId":1,"collateralPrice":"1000000000000000000","profitAssetPrice":"1000000000000000000","remainCollateral":"0"} | false | 0xfc6da13c808e3e674e35b76228f53f1de189579c | 14 | 5 | 19376395 | 2022-08-31T22:50:53.000Z | 0x81363085b2a4fde6f48ac3c658aeafe63f688b7a00645eb89c52ef9675733a06 |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"1120300000000000000","feeUsd":"0","isLong":false,"pnlUsd":"10952362316484000000","hasProfit":false,"assetPrice":"287467047000000000000","collateralId":3,"subAccountId":"0xfc6da13c808e3e674e35b76228f53f1de189579c030600000000000000000000","profitAssetId":1,"collateralPrice":"1594800000000000000000","profitAssetPrice":"1000000000000000000","remainCollateral":"0"} | false | 0xfc6da13c808e3e674e35b76228f53f1de189579c | 15 | 6 | 19339716 | 2022-08-31T02:21:45.000Z | 0x229ebb0f2f48046ad2ab3f0e7ecf087e3a8d080a5f4a5eb0348ad54d4fde7cb9 |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"154200000000000000","feeUsd":"0","isLong":false,"pnlUsd":"5026920000000000000","hasProfit":false,"assetPrice":"1575300000000000000000","collateralId":0,"subAccountId":"0xfc6da13c808e3e674e35b76228f53f1de189579c000300000000000000000000","profitAssetId":1,"collateralPrice":"1000000000000000000","profitAssetPrice":"1000000000000000000","remainCollateral":"0"} | false | 0xfc6da13c808e3e674e35b76228f53f1de189579c | 50 | 3 | 19338342 | 2022-08-31T01:35:44.000Z | 0xf61b7b425e271e78a974ad49e53828162646c711789af2529b35dd3a697b5195 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.mux_v2_avalanche.LiquidityPool_Liquidate_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_OpenPosition\_event
Perpetual futures position opening events from MUX Protocol liquidity pools containing trader address, asset and collateral identifiers, position size, entry price, leverage direction (long/short), fees charged, and remaining collateral balances. Used for tracking perpetual contract position entries and margin requirements.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assetId` | `INT64` | Unique identifier for the asset or token involved in the operation. Hex-encoded, 0x-prefixed, 66-character string. |
| `in_args` | `STRUCT` | Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed. |
| address | in\_args | removed | in\_trader | log\_index | in\_assetId | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"382400000000000000","feeUsd":"95195004748800000","isLong":false,"assetPrice":"311176140000000000000","collateralId":0,"subAccountId":"0x0c266223c8db48ca1238103f5bd8772146f860a3000600000000000000000000","newEntryPrice":"311176140000000000000","remainPosition":"382400000000000000","collateralPrice":"1000000000000000000","remainCollateral":"11904804995251200000"} | false | 0x0c266223c8db48ca1238103f5bd8772146f860a3 | 4 | 6 | 30665536 | 2023-05-30T00:46:19.000Z | 0x470382b893cf95ff2bc8f20cf3eece598d548370a182693b06200dadd20e6e08 |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"9923600000000000000","feeUsd":"15075933120000000000","isLong":false,"assetPrice":"1899000000000000000000","collateralId":0,"subAccountId":"0x481ff14ef40fe9d23b7f8689d7c8561d0a71029b000300000000000000000000","newEntryPrice":"1899000000000000000000","remainPosition":"9923600000000000000","collateralPrice":"1000000000000000000","remainCollateral":"188354066880000000000"} | false | 0x481ff14ef40fe9d23b7f8689d7c8561d0a71029b | 7 | 3 | 30667167 | 2023-05-30T01:42:07.000Z | 0xc012b5824f0bb25fb41f503df35fa33af8fc5a9c0cf6b215bcd108b7b43b6a7b |
| 0x0ba2e492e8427fad51692ee8958ebf936bee1d84 | \{"amount":"64500000000000000","feeUsd":"97988400000000000","isLong":false,"assetPrice":"1899000000000000000000","collateralId":0,"subAccountId":"0x7b0ec02aee03d4c884bc4fd24554b1c71c479f71000300000000000000000000","newEntryPrice":"1899000000000000000000","remainPosition":"64500000000000000","collateralPrice":"1000000000000000000","remainCollateral":"4902011600000000000"} | false | 0x7b0ec02aee03d4c884bc4fd24554b1c71c479f71 | 4 | 3 | 30690882 | 2023-05-30T15:01:08.000Z | 0xc020de731756bc189963e333305a490f7d64b89f2d7c89580f8f52905d4a6c8f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.mux_v2_avalanche.LiquidityPool_OpenPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***