Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_idINT64Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_symbolSTRINGSymbol of the token involved in the transaction or event.
in_decimalsINT64Number of decimal places for the token. Integer value defining precision for token amount representations.
in_isStableBOOLBoolean flag indicating whether the asset is classified as a stablecoin.
in_tokenAddressSTRINGToken contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_muxTokenAddressSTRINGContract address of the MUX protocol’s liquidity pool token for the asset. Hex-encoded, 0x-prefixed, 42-character string.
in_idaddressremovedin_symbollog_indexin_decimalsin_isStableblock_numberblock_timestampin_tokenAddresstransaction_hashin_muxTokenAddress
60x0ba2e492e8427fad51692ee8958ebf936bee1d84false0x424e4200000000000000000000000000000000000000000000000000000000005718false143339102022-05-06T06:14:02.000Z0x00000000000000000000000000000000000000000x31dbabd1dee3622835f6ee307945c5cc72835f7aafa65409a6caab4827cc645e0x30a667df8562a2460f45ac297d833a36feac0c2f
70x0ba2e492e8427fad51692ee8958ebf936bee1d84false0x46544d00000000000000000000000000000000000000000000000000000000006818false143342132022-05-06T06:24:30.000Z0x00000000000000000000000000000000000000000x36d088796097094542dbe67cbc12805123575f631addbec4fa6426c7368f56ba0x70d30270ccc356f47e5782a1a905ea85b9e08cea
50x0ba2e492e8427fad51692ee8958ebf936bee1d84false0x41564158000000000000000000000000000000000000000000000000000000007018false143339022022-05-06T06:13:47.000Z0xb31f66aa3c1e785363f0875a1b74e27b85fd66c70x03cb4744dfbfa10bf9c10c01daa8f31f766713806ce52b6f0cda665ae581c7d80xac80096d53c5965d9432592d28687c521472b9eb
Query with partition filter
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_assetIdINT64Unique identifier for the asset or token involved in the operation. Hex-encoded, 0x-prefixed, 66-character string.
in_argsSTRUCT<subAccountId STRING, collateralId INT64, profitAssetId INT64, isLong BOOL, amount STRING, assetPrice STRING, collateralPrice STRING, profitAssetPrice STRING, feeUsd STRING, hasProfit BOOL, pnlUsd STRING, remainPosition STRING, remainCollateral STRING>Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.
addressin_argsremovedin_traderlog_indexin_assetIdblock_numberblock_timestamptransaction_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”}false0x17c13c3ac2e455c7a625b6e31016eb207114899627262541542023-02-14T16:43:41.000Z0x49856c1c6b015924ec1a2e714c2c5c9d22f72d94f7234ae69062eff8803c17dc
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”}false0x29a31e68a5c3b052ac04a663f1e60a2cf184ff5327262598682023-02-14T19:55:38.000Z0x5b59c5df7c6662c3a975f682a47849643e184c7ab6d932ff19bd4a83e4bf0e71
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”}false0x2fcf87fc895a79a697e79756b53720b351c4f76123262587592023-02-14T19:18:18.000Z0x95b273ca3a2f757e4f5770965093c563232bb86335e6bf9ddd54d05171b0da5d
Query with partition filter
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_assetIdINT64Unique identifier for the asset or token involved in the operation. Hex-encoded, 0x-prefixed, 66-character string.
in_argsSTRUCT<subAccountId STRING, collateralId INT64, profitAssetId INT64, isLong BOOL, amount STRING, assetPrice STRING, collateralPrice STRING, profitAssetPrice STRING, feeUsd STRING, hasProfit BOOL, pnlUsd STRING, remainCollateral STRING>Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.
addressin_argsremovedin_traderlog_indexin_assetIdblock_numberblock_timestamptransaction_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”}false0xfc6da13c808e3e674e35b76228f53f1de189579c145193763952022-08-31T22:50:53.000Z0x81363085b2a4fde6f48ac3c658aeafe63f688b7a00645eb89c52ef9675733a06
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”}false0xfc6da13c808e3e674e35b76228f53f1de189579c156193397162022-08-31T02:21:45.000Z0x229ebb0f2f48046ad2ab3f0e7ecf087e3a8d080a5f4a5eb0348ad54d4fde7cb9
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”}false0xfc6da13c808e3e674e35b76228f53f1de189579c503193383422022-08-31T01:35:44.000Z0xf61b7b425e271e78a974ad49e53828162646c711789af2529b35dd3a697b5195
Query with partition filter
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_assetIdINT64Unique identifier for the asset or token involved in the operation. Hex-encoded, 0x-prefixed, 66-character string.
in_argsSTRUCT<subAccountId STRING, collateralId INT64, isLong BOOL, amount STRING, assetPrice STRING, collateralPrice STRING, newEntryPrice STRING, feeUsd STRING, remainPosition STRING, remainCollateral STRING>Structured input arguments passed to the contract function that triggered the event. Contains nested data specific to the operation being performed.
addressin_argsremovedin_traderlog_indexin_assetIdblock_numberblock_timestamptransaction_hash
0x0ba2e492e8427fad51692ee8958ebf936bee1d84{“amount”:“382400000000000000”,“feeUsd”:“95195004748800000”,“isLong”:false,“assetPrice”:“311176140000000000000”,“collateralId”:0,“subAccountId”:“0x0c266223c8db48ca1238103f5bd8772146f860a3000600000000000000000000”,“newEntryPrice”:“311176140000000000000”,“remainPosition”:“382400000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“11904804995251200000”}false0x0c266223c8db48ca1238103f5bd8772146f860a346306655362023-05-30T00:46:19.000Z0x470382b893cf95ff2bc8f20cf3eece598d548370a182693b06200dadd20e6e08
0x0ba2e492e8427fad51692ee8958ebf936bee1d84{“amount”:“9923600000000000000”,“feeUsd”:“15075933120000000000”,“isLong”:false,“assetPrice”:“1899000000000000000000”,“collateralId”:0,“subAccountId”:“0x481ff14ef40fe9d23b7f8689d7c8561d0a71029b000300000000000000000000”,“newEntryPrice”:“1899000000000000000000”,“remainPosition”:“9923600000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“188354066880000000000”}false0x481ff14ef40fe9d23b7f8689d7c8561d0a71029b73306671672023-05-30T01:42:07.000Z0xc012b5824f0bb25fb41f503df35fa33af8fc5a9c0cf6b215bcd108b7b43b6a7b
0x0ba2e492e8427fad51692ee8958ebf936bee1d84{“amount”:“64500000000000000”,“feeUsd”:“97988400000000000”,“isLong”:false,“assetPrice”:“1899000000000000000000”,“collateralId”:0,“subAccountId”:“0x7b0ec02aee03d4c884bc4fd24554b1c71c479f71000300000000000000000000”,“newEntryPrice”:“1899000000000000000000”,“remainPosition”:“64500000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“4902011600000000000”}false0x7b0ec02aee03d4c884bc4fd24554b1c71c479f7143306908822023-05-30T15:01:08.000Z0xc020de731756bc189963e333305a490f7d64b89f2d7c89580f8f52905d4a6c8f
Query with partition filter
SELECT *
FROM `tt-contracts.mux_v2_avalanche.LiquidityPool_OpenPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100