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
80xc6bd76fa1e9e789345e003b361e4a0037dfb7260false0x4f50000000000000000000000000000000000000000000000000000000000000018false560749782022-12-27T12:39:45.000Z0x42000000000000000000000000000000000000420x50e7f99ca4cec230687b0889f4ea0b127acbc94a9abfa76a5ffb708cd0c5fb4e0x69663eb604c7d534e9149fa855d89d9104e75363
50xc6bd76fa1e9e789345e003b361e4a0037dfb7260false0x4156415800000000000000000000000000000000000000000000000000000000018false560748582022-12-27T12:39:30.000Z0x00000000000000000000000000000000000000000xdc8cd51a1c562e1110481f7bfb68686507ec47bb21a6adb354672043084d7de10x50ec9b92b3bd46969b1ae5e10543ca6fb49fba4f
60xc6bd76fa1e9e789345e003b361e4a0037dfb7260false0x424e420000000000000000000000000000000000000000000000000000000000018false560749122022-12-27T12:39:30.000Z0x00000000000000000000000000000000000000000x76b83eaa87beb73a0a7a70d6da7bd49bc66ee07a8931769b4a5163063cda9da60x253be9f0e2a8749df6ac7466d096b264788745e0
Query with partition filter
SELECT *
FROM `tt-contracts.mux_v2_optimism.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
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“59170000000000000”,“feeUsd”:“986841401900000000”,“isLong”:false,“pnlUsd”:“7928780000000000000”,“hasProfit”:false,“assetPrice”:“26901000000000000000000”,“collateralId”:0,“subAccountId”:“0xcb11673592cc6c4b9584f33bbba6c6cf07dde3f7000400000000000000000000”,“profitAssetId”:0,“remainPosition”:“0”,“collateralPrice”:“1000000000000000000”,“profitAssetPrice”:“1000000000000000000”,“remainCollateral”:“73616605012100000000”}false0xcb11673592cc6c4b9584f33bbba6c6cf07dde3f7141108246612023-10-14T01:48:19.000Z0x7f119cb82cbce39c347a10dbbaf099c4d299a36d0fbe005297e5315d81ac157a
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“1081400000000000000”,“feeUsd”:“1006934796000000000”,“isLong”:false,“pnlUsd”:“1081400000000000000”,“hasProfit”:true,“assetPrice”:“1551900000000000000000”,“collateralId”:0,“subAccountId”:“0xcb11673592cc6c4b9584f33bbba6c6cf07dde3f7000300000000000000000000”,“profitAssetId”:0,“remainPosition”:“0”,“collateralPrice”:“1000000000000000000”,“profitAssetPrice”:“1000000000000000000”,“remainCollateral”:“23992416364000000000”}false0xcb11673592cc6c4b9584f33bbba6c6cf07dde3f7731108245172023-10-14T01:43:31.000Z0x96efd32be1f542eec6cd45a40b8bb7c7241c2b4ebd7838a3e2a6655181acbd4c
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“9233330000000000000000”,“feeUsd”:“7064897001228080000”,“isLong”:false,“pnlUsd”:“36108968297600000000”,“hasProfit”:false,“assetPrice”:“1214755960000000000”,“collateralId”:0,“subAccountId”:“0x45ceeda2ccdc679c1df920e72e03e1cd8a8b6efb000800000000000000000000”,“profitAssetId”:0,“remainPosition”:“0”,“collateralPrice”:“1000000000000000000”,“profitAssetPrice”:“1000000000000000000”,“remainCollateral”:“104118054493262400000”}false0x45ceeda2ccdc679c1df920e72e03e1cd8a8b6efb581108246762023-10-14T01:48:49.000Z0xefac1d8978b27d734851f559b93cc3ec18e748f00a541e0462e6445fe0846da5
Query with partition filter
SELECT *
FROM `tt-contracts.mux_v2_optimism.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
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“222900000000000000”,“feeUsd”:“460425026249999999”,“isLong”:true,“pnlUsd”:“3499530000000000000”,“hasProfit”:false,“assetPrice”:“1935000000000000000000”,“collateralId”:8,“subAccountId”:“0xffd3003a187d9951e49bda206f32a6e765360427080301000000000000000000”,“profitAssetId”:3,“collateralPrice”:“2446300000000000000”,“profitAssetPrice”:“1935000000000000000000”,“remainCollateral”:“673746655541302295”}false0xffd3003a187d9951e49bda206f32a6e76536042713926046042023-04-20T16:02:59.000Z0x8337ea57a573dcc5fc5cd044158ab62bf4832b2082e53fceeffe4e9d8299036c
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“349400000000000000”,“feeUsd”:“716615119850000000”,“isLong”:true,“pnlUsd”:“10447060000000000000”,“hasProfit”:false,“assetPrice”:“1921300000000000000000”,“collateralId”:3,“subAccountId”:“0x8231df717e2cec9f4ae2ba8ecc46efd7769eda8e030301000000000000000000”,“profitAssetId”:3,“collateralPrice”:“1921300000000000000000”,“profitAssetPrice”:“1921300000000000000000”,“remainCollateral”:“910000054208089”}false0x8231df717e2cec9f4ae2ba8ecc46efd7769eda8e13926049182023-04-20T16:03:29.000Z0xea3df8ef722de9a630b323bcecbe9bc81b2ad7947833ba668905827fb156e0f2
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“313000000000000000”,“feeUsd”:“1044254388000000000”,“isLong”:true,“pnlUsd”:“17903600000000000000”,“hasProfit”:false,“assetPrice”:“1917400000000000000000”,“collateralId”:3,“subAccountId”:“0xb50eee16704dedcd22681499ea9c78bcc9561648030301000000000000000000”,“profitAssetId”:3,“collateralPrice”:“1917400000000000000000”,“profitAssetPrice”:“1917400000000000000000”,“remainCollateral”:“1297543888599145”}false0xb50eee16704dedcd22681499ea9c78bcc956164813926434482023-04-20T19:28:35.000Z0x920c65f823088cbcfc5a86190f70d97b64a1a27cfea168ff43266f2eca9ecc34
Query with partition filter
SELECT *
FROM `tt-contracts.mux_v2_optimism.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
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“1753700000000000000”,“feeUsd”:“2571064496000000000”,“isLong”:false,“assetPrice”:“1832600000000000000000”,“collateralId”:0,“subAccountId”:“0x3d5d2ac4fecf16bb1651a445d5b17f977a823546000300000000000000000000”,“newEntryPrice”:“1832600000000000000000”,“remainPosition”:“1753700000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“32138935504000000000”}false0x3d5d2ac4fecf16bb1651a445d5b17f977a8235464231079367212023-08-08T05:23:39.000Z0xbf31397b9dabd7d92232300bb041346b33b55df49b4c61add2d2e77b1d0f4cfe
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“967600000000000000”,“feeUsd”:“1415405280000000000”,“isLong”:false,“assetPrice”:“1828500000000000000000”,“collateralId”:0,“subAccountId”:“0x3d5d2ac4fecf16bb1651a445d5b17f977a823546000300000000000000000000”,“newEntryPrice”:“1828500000000000000000”,“remainPosition”:“967600000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“34694594720000000000”}false0x3d5d2ac4fecf16bb1651a445d5b17f977a8235465331079444422023-08-08T09:41:01.000Z0xf01ac9170414d9ee3c7250958953524907b4339dde58c7148b6f619cb50b3075
0xc6bd76fa1e9e789345e003b361e4a0037dfb7260{“amount”:“183100000000000000”,“feeUsd”:“496524414100000000”,“isLong”:true,“assetPrice”:“1831700000000000000000”,“collateralId”:0,“subAccountId”:“0x3d5d2ac4fecf16bb1651a445d5b17f977a823546000301000000000000000000”,“newEntryPrice”:“1821743689732548972041”,“remainPosition”:“1648900000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“30038684465900000000”}false0x3d5d2ac4fecf16bb1651a445d5b17f977a8235466331079287532023-08-08T00:58:03.000Z0x70048262057544ef667b9141de76e9a4748636559ba2a7057e2d6d5604e0e10a
Query with partition filter
SELECT *
FROM `tt-contracts.mux_v2_optimism.LiquidityPool_OpenPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100