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
80x855e99f768fad76dd0d3eb7c446c0b759c96d520false0x425553440000000000000000000000000000000000000000000000000000000061118true176537802022-05-09T12:31:42.000Z0xe9e7cea3dedca5984780bafc599bd69add087d560xfa9886a04ace799c33e2a9cf686663ec54ed35c40fdaa2fe11e96722df3aeeef0x523d3e0dacd7c470ebe8880abe808161696cebec
90x855e99f768fad76dd0d3eb7c446c0b759c96d520false0x4f5000000000000000000000000000000000000000000000000000000000000010918false245438362023-01-06T06:42:22.000Z0x00000000000000000000000000000000000000000xd4027770c2a5bda15dff1ec734e2112169b19815c3430945922adef2f2c25ee30x8feb4121c45265515f36925ca412f85588c00b7e
30x855e99f768fad76dd0d3eb7c446c0b759c96d520false0x455448000000000000000000000000000000000000000000000000000000000082418false175410892022-05-05T13:54:38.000Z0x2170ed0880ac9a755fd29b2688956bd959f933f80xb815c3b70c3f2db3bbb2ca7ae0187054367c9a13e22e64fe2eaefb49c32b24c50xea09cbb3f286f7c1a377c4db825c1cefad2476ae
Query with partition filter
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.
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
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”}false0xc4b1eb9a3cd7543edaf3f1ad385dc455aec632473185220500592022-10-10T08:14:09.000Z0x08208b21e40a7a341884b386e0b93cff056a2c48d67b86c61eb59aecced17f2b
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”}false0x8371f1525fb09c2915828c6c2718f30095a6d0941896220447372022-10-10T03:46:58.000Z0xdef8a2c41fe3ca03d07fa672ffa8d2f754c81c93d162a9e2099cabe0cc54ef44
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”}false0x8371f1525fb09c2915828c6c2718f30095a6d0941636220459332022-10-10T04:47:03.000Z0x7e5181f9ee6cf7465eb1243781237b86aec064f49208456da52bd2967856f6d6
Query with partition filter
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.
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
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”}false0x7c424d4b753185c6e91e0cdd5fd98076198c51b2683250219192023-01-23T01:10:06.000Z0xf4c2e6988638c11947a0c9b45b726883674a8bfc332853aa130fd773c71d0c0e
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”}false0xffd3003a187d9951e49bda206f32a6e7653604273007263763482023-03-11T15:51:27.000Z0x03917c3389894be7de2a2ea27b1246cab9f8f9680ee749e8182d12b6d2ffb91a
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”}false0x6516f1d22f2949474c504870ac87a5d5168fa1c54219263666562023-03-11T07:43:40.000Z0x9cfb14216ef5f7a1a1a18fa41f9791dcd746a6ace42475a9a7c3ce16a0d55fd0
Query with partition filter
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.
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
0x855e99f768fad76dd0d3eb7c446c0b759c96d520{“amount”:“4190300000000000000000”,“feeUsd”:“860042313800000000”,“isLong”:true,“assetPrice”:“205246000000000000”,“collateralId”:6,“subAccountId”:“0x1f4db76256be8c0186493e87c8f24fae755df4ec060701000000000000000000”,“newEntryPrice”:“205246000000000000”,“remainPosition”:“4190300000000000000000”,“collateralPrice”:“246150000000000000000”,“remainCollateral”:“46506023506804794”}false0x1f4db76256be8c0186493e87c8f24fae755df4ec2277240123982022-12-18T13:59:35.000Z0x0bed4c89ff2ee23d9bb9da362bac728e5b181a7e952a8c4e3706d75e6fed4352
0x855e99f768fad76dd0d3eb7c446c0b759c96d520{“amount”:“167600000000000000”,“feeUsd”:“198706560000000000”,“isLong”:true,“assetPrice”:“1185600000000000000000”,“collateralId”:3,“subAccountId”:“0x2a9f1b316656917de70d3240c67520da2274d1be030301000000000000000000”,“newEntryPrice”:“1185600000000000000000”,“remainPosition”:“167600000000000000”,“collateralPrice”:“1185600000000000000000”,“remainCollateral”:“4532400000000000”}false0x2a9f1b316656917de70d3240c67520da2274d1be1493240198972022-12-18T20:18:56.000Z0x5b89b54390dc8761c65cb078e1b88540745c104fb6d79b5aac4198904b8ca21b
0x855e99f768fad76dd0d3eb7c446c0b759c96d520{“amount”:“466000000000000000”,“feeUsd”:“552955600000000000”,“isLong”:true,“assetPrice”:“1186600000000000000000”,“collateralId”:3,“subAccountId”:“0x2a9f1b316656917de70d3240c67520da2274d1be030301000000000000000000”,“newEntryPrice”:“1186335479797979797979”,“remainPosition”:“633600000000000000”,“collateralPrice”:“1186600000000000000000”,“remainCollateral”:“20066400000000000”}false0x2a9f1b316656917de70d3240c67520da2274d1be1113240225582022-12-18T22:33:15.000Z0xdfd9fb3db5a7d156f6b669a3d60c8a186b8c8402ff20a577b7fbe033a7b3315d
Query with partition filter
SELECT *
FROM `tt-contracts.mux_v2_bsc.LiquidityPool_OpenPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100