> ## 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_bsc
> Tables in tt-contracts.mux_v2_bsc
## 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 |
| ------ | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ---------- | ------------ | ------------ | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 8 | 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | false | 0x4255534400000000000000000000000000000000000000000000000000000000 | 611 | 18 | true | 17653780 | 2022-05-09T12:31:42.000Z | 0xe9e7cea3dedca5984780bafc599bd69add087d56 | 0xfa9886a04ace799c33e2a9cf686663ec54ed35c40fdaa2fe11e96722df3aeeef | 0x523d3e0dacd7c470ebe8880abe808161696cebec |
| 9 | 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | false | 0x4f50000000000000000000000000000000000000000000000000000000000000 | 109 | 18 | false | 24543836 | 2023-01-06T06:42:22.000Z | 0x0000000000000000000000000000000000000000 | 0xd4027770c2a5bda15dff1ec734e2112169b19815c3430945922adef2f2c25ee3 | 0x8feb4121c45265515f36925ca412f85588c00b7e |
| 3 | 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | false | 0x4554480000000000000000000000000000000000000000000000000000000000 | 824 | 18 | false | 17541089 | 2022-05-05T13:54:38.000Z | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0xb815c3b70c3f2db3bbb2ca7ae0187054367c9a13e22e64fe2eaefb49c32b24c5 | 0xea09cbb3f286f7c1a377c4db825c1cefad2476ae |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.mux_v2_bsc.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 |
| ------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"260762000000000000000","feeUsd":"6541829907558000000","isLong":true,"pnlUsd":"9623265152800000000","hasProfit":true,"assetPrice":"16724906000000000000","collateralId":1,"subAccountId":"0xc4b1eb9a3cd7543edaf3f1ad385dc455aec63247010501000000000000000000","profitAssetId":5,"remainPosition":"0","collateralPrice":"1000000000000000000","profitAssetPrice":"16724906000000000000","remainCollateral":"395648403326780800000"} | false | 0xc4b1eb9a3cd7543edaf3f1ad385dc455aec63247 | 318 | 5 | 22050059 | 2022-10-10T08:14:09.000Z | 0x08208b21e40a7a341884b386e0b93cff056a2c48d67b86c61eb59aecced17f2b |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"10000000000000000","feeUsd":"2775346582800000","isLong":true,"pnlUsd":"6668834400000000","hasProfit":false,"assetPrice":"277534658280000000000","collateralId":6,"subAccountId":"0x8371f1525fb09c2915828c6c2718f30095a6d094060601000000000000000000","profitAssetId":6,"remainPosition":"0","collateralPrice":"277868100000000000000","profitAssetPrice":"277534658280000000000","remainCollateral":"9956000000000000"} | false | 0x8371f1525fb09c2915828c6c2718f30095a6d094 | 189 | 6 | 22044737 | 2022-10-10T03:46:58.000Z | 0xdef8a2c41fe3ca03d07fa672ffa8d2f754c81c93d162a9e2099cabe0cc54ef44 |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"10000000000000000","feeUsd":"2777176384400000","isLong":true,"pnlUsd":"6478998400000000","hasProfit":false,"assetPrice":"277717638440000000000","collateralId":6,"subAccountId":"0x8371f1525fb09c2915828c6c2718f30095a6d094060601000000000000000000","profitAssetId":6,"remainPosition":"0","collateralPrice":"278051300000000000000","profitAssetPrice":"277717638440000000000","remainCollateral":"9956698550231558"} | false | 0x8371f1525fb09c2915828c6c2718f30095a6d094 | 163 | 6 | 22045933 | 2022-10-10T04:47:03.000Z | 0x7e5181f9ee6cf7465eb1243781237b86aec064f49208456da52bd2967856f6d6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.mux_v2_bsc.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 |
| ------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"211700000000000000","feeUsd":"312524242000000000","isLong":false,"pnlUsd":"3196670000000000000","hasProfit":false,"assetPrice":"1642000000000000000000","collateralId":0,"subAccountId":"0x7c424d4b753185c6e91e0cdd5fd98076198c51b2000300000000000000000000","profitAssetId":1,"collateralPrice":"1000000000000000000","profitAssetPrice":"1000000000000000000","remainCollateral":"1412381413771026861"} | false | 0x7c424d4b753185c6e91e0cdd5fd98076198c51b2 | 68 | 3 | 25021919 | 2023-01-23T01:10:06.000Z | 0xf4c2e6988638c11947a0c9b45b726883674a8bfc332853aa130fd773c71d0c0e |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"218270000000000000000","feeUsd":"54754908368158887","isLong":true,"pnlUsd":"1060442968000000000","hasProfit":false,"assetPrice":"313573260000000000","collateralId":3,"subAccountId":"0xffd3003a187d9951e49bda206f32a6e765360427030701000000000000000000","profitAssetId":7,"collateralPrice":"1441700000000000000000","profitAssetPrice":"313573260000000000","remainCollateral":"187974474174224"} | false | 0xffd3003a187d9951e49bda206f32a6e765360427 | 300 | 7 | 26376348 | 2023-03-11T15:51:27.000Z | 0x03917c3389894be7de2a2ea27b1246cab9f8f9680ee749e8182d12b6d2ffb91a |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"31810000000000000000","feeUsd":"0","isLong":true,"pnlUsd":"31328580341381072154","hasProfit":false,"assetPrice":"1889230200000000000","collateralId":0,"subAccountId":"0x6516f1d22f2949474c504870ac87a5d5168fa1c5000901000000000000000000","profitAssetId":1,"collateralPrice":"886663880000000000","profitAssetPrice":"1000000000000000000","remainCollateral":"0"} | false | 0x6516f1d22f2949474c504870ac87a5d5168fa1c5 | 421 | 9 | 26366656 | 2023-03-11T07:43:40.000Z | 0x9cfb14216ef5f7a1a1a18fa41f9791dcd746a6ace42475a9a7c3ce16a0d55fd0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.mux_v2_bsc.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 |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"4190300000000000000000","feeUsd":"860042313800000000","isLong":true,"assetPrice":"205246000000000000","collateralId":6,"subAccountId":"0x1f4db76256be8c0186493e87c8f24fae755df4ec060701000000000000000000","newEntryPrice":"205246000000000000","remainPosition":"4190300000000000000000","collateralPrice":"246150000000000000000","remainCollateral":"46506023506804794"} | false | 0x1f4db76256be8c0186493e87c8f24fae755df4ec | 227 | 7 | 24012398 | 2022-12-18T13:59:35.000Z | 0x0bed4c89ff2ee23d9bb9da362bac728e5b181a7e952a8c4e3706d75e6fed4352 |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"167600000000000000","feeUsd":"198706560000000000","isLong":true,"assetPrice":"1185600000000000000000","collateralId":3,"subAccountId":"0x2a9f1b316656917de70d3240c67520da2274d1be030301000000000000000000","newEntryPrice":"1185600000000000000000","remainPosition":"167600000000000000","collateralPrice":"1185600000000000000000","remainCollateral":"4532400000000000"} | false | 0x2a9f1b316656917de70d3240c67520da2274d1be | 149 | 3 | 24019897 | 2022-12-18T20:18:56.000Z | 0x5b89b54390dc8761c65cb078e1b88540745c104fb6d79b5aac4198904b8ca21b |
| 0x855e99f768fad76dd0d3eb7c446c0b759c96d520 | \{"amount":"466000000000000000","feeUsd":"552955600000000000","isLong":true,"assetPrice":"1186600000000000000000","collateralId":3,"subAccountId":"0x2a9f1b316656917de70d3240c67520da2274d1be030301000000000000000000","newEntryPrice":"1186335479797979797979","remainPosition":"633600000000000000","collateralPrice":"1186600000000000000000","remainCollateral":"20066400000000000"} | false | 0x2a9f1b316656917de70d3240c67520da2274d1be | 111 | 3 | 24022558 | 2022-12-18T22:33:15.000Z | 0xdfd9fb3db5a7d156f6b669a3d60c8a186b8c8402ff20a577b7fbe033a7b3315d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.mux_v2_bsc.LiquidityPool_OpenPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***