mux_v2_arbitrum

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.

Columns

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.

Sample Data

in_id	address	removed	in_symbol	log_index	in_decimals	in_isStable	block_number	block_timestamp	in_tokenAddress	transaction_hash	in_muxTokenAddress
11	0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	false	0x5553444300000000000000000000000000000000000000000000000000000000	2	6	true	117934695	2023-08-04T02:54:55.000Z	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0xde5c0698daad812f3dc8dcfe1f31f349c3c477f2dbe06d45d3571586d6f634ef	0x458cd4bd5ae8fcf602a910423c30323997e497c3
6	0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	false	0x424e420000000000000000000000000000000000000000000000000000000000	0	18	false	11243044	2022-05-05T10:48:48.000Z	0x0000000000000000000000000000000000000000	0x97d6772c5f942adc9c5d671a66a6dac353adfe079abf09778f3ea166ab11fbb9	0xdd3cf6b0182993eced98fd71962dfa18e2eae2e4
5	0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	false	0x4156415800000000000000000000000000000000000000000000000000000000	0	18	false	11243041	2022-05-05T10:48:48.000Z	0x0000000000000000000000000000000000000000	0x7846c8be9b9fde0c5fb055c35456aa0f4500c38bb0bfe2d970803c2393105cb9	0xd8d05915cf0accbbba78720707920aff6eef3943

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mux_v2_arbitrum.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.

Columns

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<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.

Sample Data

address	in_args	removed	in_trader	log_index	in_assetId	block_number	block_timestamp	transaction_hash
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“1000000000000000”,“feeUsd”:“1210300000000000”,“isLong”:true,“pnlUsd”:“200000000000000”,“hasProfit”:false,“assetPrice”:“1210300000000000000000”,“collateralId”:3,“subAccountId”:“0x8371f1525fb09c2915828c6c2718f30095a6d094030301000000000000000000”,“profitAssetId”:3,“remainPosition”:“0”,“collateralPrice”:“1210300000000000000000”,“profitAssetPrice”:“1210300000000000000000”,“remainCollateral”:“997834751714451”}	false	0x8371f1525fb09c2915828c6c2718f30095a6d094	1	3	15969298	2022-06-26T22:29:41.000Z	0x78955162b634e241e57052b4c090a9270b6be16e546f6d9d2c128171062b5e17
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“1000000000000000”,“feeUsd”:“1215100000000000”,“isLong”:true,“pnlUsd”:“200000000000000”,“hasProfit”:false,“assetPrice”:“1215100000000000000000”,“collateralId”:3,“subAccountId”:“0x8371f1525fb09c2915828c6c2718f30095a6d094030301000000000000000000”,“profitAssetId”:3,“remainPosition”:“0”,“collateralPrice”:“1215100000000000000000”,“profitAssetPrice”:“1215100000000000000000”,“remainCollateral”:“997835404493458”}	false	0x8371f1525fb09c2915828c6c2718f30095a6d094	1	3	15948678	2022-06-26T18:29:28.000Z	0x90e1b82d2ec78725bd6a205f955652732a3dc6868d708ad5131f0835711621cf
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“1000000000000000”,“feeUsd”:“1236400000000000”,“isLong”:true,“pnlUsd”:“200000000000000”,“hasProfit”:false,“assetPrice”:“1236400000000000000000”,“collateralId”:3,“subAccountId”:“0x8371f1525fb09c2915828c6c2718f30095a6d094030301000000000000000000”,“profitAssetId”:3,“remainPosition”:“0”,“collateralPrice”:“1236400000000000000000”,“profitAssetPrice”:“1236400000000000000000”,“remainCollateral”:“997838240051764”}	false	0x8371f1525fb09c2915828c6c2718f30095a6d094	1	3	15964326	2022-06-26T21:29:43.000Z	0x45b981d782371a607476636dc146dc3669684451c30000b7786c52d712fbd7af

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mux_v2_arbitrum.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.

Columns

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<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.

Sample Data

address	in_args	removed	in_trader	log_index	in_assetId	block_number	block_timestamp	transaction_hash
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“1348553900000000000000”,“feeUsd”:“4261441402370288500”,“isLong”:true,“pnlUsd”:“72930934146047498909”,“hasProfit”:false,“assetPrice”:“1215387775000000000”,“collateralId”:0,“subAccountId”:“0xac9f5a0a1c0f6862f2485b2f1390d31bfc90f4ab000a01000000000000000000”,“profitAssetId”:10,“collateralPrice”:“1000000000000000000”,“profitAssetPrice”:“1215387775000000000”,“remainCollateral”:“5939099137023695391”}	false	0xac9f5a0a1c0f6862f2485b2f1390d31bfc90f4ab	1	10	113944320	2023-07-22T23:18:07.000Z	0xfbcd005cf746fea06e092ed0a0018688a55bbd99a41146b4b8eb39ec6d4a69ed
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“29467918100000000000000”,“feeUsd”:“0”,“isLong”:true,“pnlUsd”:“485059937443794980442”,“hasProfit”:false,“assetPrice”:“1221183425000000000”,“collateralId”:10,“subAccountId”:“0x72371f787844964515f72beae22cde31bdfacb470a0a01000000000000000000”,“profitAssetId”:10,“collateralPrice”:“1222100000000000000”,“profitAssetPrice”:“1221183425000000000”,“remainCollateral”:“0”}	false	0x72371f787844964515f72beae22cde31bdfacb47	1	10	113944230	2023-07-22T23:17:45.000Z	0x0701aaaae6391b9d56e80adfb7110ff12ffbfa04edc7ae6a50ff7637ee200930
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“40982162000000000000000”,“feeUsd”:“0”,“isLong”:true,“pnlUsd”:“1841176396951709963964”,“hasProfit”:false,“assetPrice”:“1221183425000000000”,“collateralId”:2,“subAccountId”:“0xa63ba502dc5c4db0cc19bac572c25007ae17f54d020a01000000000000000000”,“profitAssetId”:10,“collateralPrice”:“1000000000000000000”,“profitAssetPrice”:“1221183425000000000”,“remainCollateral”:“0”}	false	0xa63ba502dc5c4db0cc19bac572c25007ae17f54d	2	10	113944225	2023-07-22T23:17:43.000Z	0xc45775370af9625b97a991353b766ec397f6bc5af12e23fa1fd3ebac12fd1fbb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mux_v2_arbitrum.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.

Columns

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<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.

Sample Data

address	in_args	removed	in_trader	log_index	in_assetId	block_number	block_timestamp	transaction_hash
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“2004600000000000000”,“feeUsd”:“3177291000000000000”,“isLong”:true,“assetPrice”:“1585000000000000000000”,“collateralId”:0,“subAccountId”:“0x0c9075a7e09aae69b9e20839cb082af2dd6101d5000301000000000000000000”,“newEntryPrice”:“1585000000000000000000”,“remainPosition”:“2004600000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“187028119000000000000”}	false	0x0c9075a7e09aae69b9e20839cb082af2dd6101d5	21	3	34761587	2022-11-02T18:03:39.000Z	0x812e5657c07db0e0067e0698eb8cfe94468a2a40a98c52dc5037c5f6ad96ba1e
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“249300000000000000”,“feeUsd”:“395165430000000000”,“isLong”:false,“assetPrice”:“1585100000000000000000”,“collateralId”:0,“subAccountId”:“0x263dc7d3df7434547f5f32ca0256c7d201d83b9f000300000000000000000000”,“newEntryPrice”:“1585100000000000000000”,“remainPosition”:“249300000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“197604834570000000000”}	false	0x263dc7d3df7434547f5f32ca0256c7d201d83b9f	4	3	34635398	2022-11-02T06:29:10.000Z	0x518072114a8fbf3e00ad1de13d16d6f1e8b8a1108da073b1d18afc18b221332b
0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	{“amount”:“1000000000000000000”,“feeUsd”:“1594300000000000000”,“isLong”:false,“assetPrice”:“1594300000000000000000”,“collateralId”:0,“subAccountId”:“0x4330d2cd1007aee10918064d15cf39ac26fb266f000300000000000000000000”,“newEntryPrice”:“1591366666666666666666”,“remainPosition”:“3000000000000000000”,“collateralPrice”:“1000000000000000000”,“remainCollateral”:“472345900000000000000”}	false	0x4330d2cd1007aee10918064d15cf39ac26fb266f	4	3	34622560	2022-11-02T05:01:43.000Z	0x533f3be16ac0d0792ed5b909909d2f7cb06a811ecec578d2f6078b1487c9081f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mux_v2_arbitrum.LiquidityPool_OpenPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Mlp_Transfer_event

MLP (MUX Liquidity Provider) token transfer events from the MUX Protocol v2 on Arbitrum, tracking movements of liquidity pool shares between addresses. Used for analyzing liquidity provider behavior, vault deposits/withdrawals, and token holder distribution changes.

Columns

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xfb2209f6ea0afb56e04801d62391ea2cccb942cd	0x7cbaf5a14d953ff896e5b3312031515c858737c8	0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	false	67146705215914852	2	228042978	2024-07-02T16:45:41.000Z	0x4b0630a20d2673ea00128aeb9d0d4109aaaaea3ff1979ff0a9d6ab5237cde427
0xfb2209f6ea0afb56e04801d62391ea2cccb942cd	0x7cbaf5a14d953ff896e5b3312031515c858737c8	0x3e0199792ce69dc29a0a36146bfa68bd7c8d6633	false	67294071924932544	2	227813173	2024-07-02T00:45:59.000Z	0x12360381456a1e1ee0ff0abf48e827781601eb5f09d2eeeac410129e0845b6ef
0x290450cdea757c68e4fe6032ff3886d204292914	0x7cbaf5a14d953ff896e5b3312031515c858737c8	0xfb2209f6ea0afb56e04801d62391ea2cccb942cd	false	67294071924932544	26	227924431	2024-07-02T08:30:14.000Z	0x3d11cda2f98927b78bb67195e3abae8d3c3ef5b55708147b8c6237c1494abd7d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mux_v2_arbitrum.Mlp_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MlpFeeTracker_Transfer_event

MLP (MUX Liquidity Provider) fee tracker token transfers on Arbitrum, recording movement of fee-earning shares between accounts including mints from zero address and burns to zero address. Used for tracking liquidity provider fee distribution and share ownership changes in the MUX v2 protocol.

Columns

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x7d64e59464430bff5ca2d2d4a9643ca59e66bda9	0x290450cdea757c68e4fe6032ff3886d204292914	0x0a9bbf8299fed2441009a7bb44874ee453de8e5d	false	16468443204383763450	5	28372398	2022-10-04T17:34:06.000Z	0x17a4a1cd6c18210209c09348b918699b51560e2178d8561f6d7f448230a2083e
0x0000000000000000000000000000000000000000	0x290450cdea757c68e4fe6032ff3886d204292914	0x7d64e59464430bff5ca2d2d4a9643ca59e66bda9	false	16468443204383763450	11	28372398	2022-10-04T17:34:06.000Z	0x17a4a1cd6c18210209c09348b918699b51560e2178d8561f6d7f448230a2083e
0xc12de812ae612b6d514b52d529f97f6acb524c8e	0x290450cdea757c68e4fe6032ff3886d204292914	0x0a9bbf8299fed2441009a7bb44874ee453de8e5d	false	564349749020511730437	5	28271098	2022-10-04T05:39:22.000Z	0x281cd52065fc081e643c458ffeeb06b99a5ff96d0e323f0302d9ede607c20efe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mux_v2_arbitrum.MlpFeeTracker_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ProxyFactory_CreateProxy_event

Proxy contract creation events from MUX Protocol v2 on Arbitrum, tracking position proxy deployments with GMX integration details including owner, collateral token, asset token, and long/short direction. Used for analyzing position opening patterns and protocol usage across different assets and collateral types.

Columns

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_projectId`	`STRING`	Numeric identifier of the MUX protocol project associated with this proxy creation. Values typically range from 1-2, representing different MUX protocol versions or configurations.
`in_proxyId`	`STRING`	Unique identifier for the proxy contract created in this event. Hex-encoded, 0x-prefixed 64-character hash used to track individual proxy instances.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_proxy`	`STRING`	Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_gmxPositionKey`	`STRING`	GMX protocol position identifier that uniquely represents a leveraged trading position. This 66-character hex string links the proxy to its underlying GMX perpetual position on Arbitrum.
`in_assetToken`	`STRING`	Contract address of the underlying asset for this GMX position on Arbitrum. Hex-encoded, 0x-prefixed address typically representing tokens like WETH or WBTC that define the position’s market exposure.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralTokenId`	`INT64`	Numeric identifier for the collateral token used in the GMX position, mapping to standardized token IDs. Common values include 0 (USDC), 1 (USDT), and 3 (WETH) on Arbitrum.
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).

Sample Data

address	removed	in_owner	in_proxy	in_isLong	log_index	in_proxyId	block_number	in_projectId	in_assetToken	block_timestamp	transaction_hash	in_gmxPositionKey	in_collateralToken	in_collateralTokenId
0x2ff2f1d9826ae2410979ae19b88c361073ab0918	false	0x55c774a8856cdbecb84f7e86fd1ec024ceb9998f	0xb5ccb2b9b0aba334371b349194b53679db33d936	true	2	0x1ae3ae3cdbcce23e07b828be4586bc27bbdb8d47241c96b28b1d444ffc547712	44487063	1	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2022-12-08T02:19:30.000Z	0x98b40b3fbb598a71121a117fa3ace703a446a485952245b339c46c1a7643d0fb	0x2aa17c29cb63558da690d5d7ac5d3aea3adedab4af7a2e87f5827d93f66e3348	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	3
0x2ff2f1d9826ae2410979ae19b88c361073ab0918	false	0xfc963a93457c5644e51d955f3b2d3012e27ab3dd	0x23fa52080c4ddbe6a6e39dd8068af382ee0ab04c	false	28	0xf60ec7120326f510b6cbcccdedda2376e865cee10a719dfbfb1881cdaa42d0bc	50687255	1	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2023-01-04T03:08:25.000Z	0x30a75743bec4404b4f845aab53e38bfe330794b53ca38e0c0ec8634e96b445e0	0xa5aa09abd86ee3fc4e18fea05f639b069175d13c1322c009b871d18895caa449	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0
0x2ff2f1d9826ae2410979ae19b88c361073ab0918	false	0xbb876071a63bc4d9bfcf46b012b4437ea7ff4281	0x656848952fddf9dcd336e00e00317c4ef1913305	false	23	0xe0dbc2dcd5cc594501882081bdea87a6e3ae47d73ff3c44b38061f3dddb0e2aa	88936234	1	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2023-05-09T14:07:49.000Z	0x7e70b6e3ba1a56daea45d3d498d4df2e4f48418905223b6d2169e04d6e0a9259	0x170f42a555ed0b15b8f5dd183db82040333bcb03205d6065ba276e2406af5e6a	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mux_v2_arbitrum.ProxyFactory_CreateProxy_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vester_Claim_event

Vested token claim events from MUX Protocol V2 on Arbitrum, recording when users claim their vested rewards with receiver addresses and token amounts. Used for tracking reward distribution and vesting schedule adherence.

Columns

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xbcf8c124975de6277d8397a3cad26e2333620226	false	0	43	0x0b49f8f8ec743b76fea08b4c8f3077f7ffe1a0fd	266766330	2024-10-23T08:53:27.000Z	0x71dece95cff2914fff53def99724fd3713385008a91f8a2ca89778f0d17abdb8
0xbcf8c124975de6277d8397a3cad26e2333620226	false	0	29	0x0def0bacf09a27e0836ef3096f9c3ae859ac13ea	266839720	2024-10-23T14:01:04.000Z	0xaba5d49da02527654c77920dc16dbc9f819808653b25cc910116709ebd8b2471
0xbcf8c124975de6277d8397a3cad26e2333620226	false	287921985484372359	42	0x175fb20b9b5bcf80a0167d403405e6f3a074cfa0	266903320	2024-10-23T18:27:53.000Z	0x286ba12b106314d310d749fd2de371afb996c9f19dfab463d653cebfb905dcf6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.mux_v2_arbitrum.Vester_Claim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LiquidityPool_AddAsset_event

LiquidityPool_ClosePosition_event

LiquidityPool_Liquidate_event

LiquidityPool_OpenPosition_event

Mlp_Transfer_event

MlpFeeTracker_Transfer_event

ProxyFactory_CreateProxy_event

Vester_Claim_event

​Tables

​LiquidityPool_AddAsset_event

​LiquidityPool_ClosePosition_event

​LiquidityPool_Liquidate_event

​LiquidityPool_OpenPosition_event

​Mlp_Transfer_event

​MlpFeeTracker_Transfer_event

​ProxyFactory_CreateProxy_event

​Vester_Claim_event

Tables

LiquidityPool_AddAsset_event

LiquidityPool_ClosePosition_event

LiquidityPool_Liquidate_event

LiquidityPool_OpenPosition_event

Mlp_Transfer_event

MlpFeeTracker_Transfer_event

ProxyFactory_CreateProxy_event

Vester_Claim_event