mux_v1_arbitrum

Tables

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_perpetualIndex`	`STRING`	Index identifier for the perpetual contract within the liquidity pool. Numeric string representation, zero-indexed.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_trader`	`STRING`	Address that initiated or executed the trade 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.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_penalty`	`STRING`	Penalty amount assessed in the operation. Numeric string representation of token quantity in smallest denomination.
`in_penaltyToLP`	`STRING`	Portion of the liquidation penalty allocated to the liquidity pool. Expressed in wei (1e18 = 1 token), representing approximately half of the total penalty in most observed liquidations.

Sample Data

address	removed	in_price	in_amount	in_trader	log_index	in_penalty	block_number	in_liquidator	in_penaltyToLP	block_timestamp	transaction_hash	in_perpetualIndex
0xab324146c49b23658e5b3930e641bdbdf089cbac	false	47125845160155252540056	359400000000000000	0xceaf2896c78b07d30ab3991aecec3041281256b4	4	169206598200000000000	860593	0xab324146c49b23658e5b3930e641bdbdf089cbac	84603299100000000000	2021-09-14T22:21:02.000Z	0xed2ab19b7d5bd4b38f3a7ba9c09e61bc05d1d57f2bbff7c78e8ea197beb17f29	1
0xab324146c49b23658e5b3930e641bdbdf089cbac	false	3318730446557730545677	31000000000000000	0xb10d235a3d9ad05443c6cd6b21cddd004a549d23	6	1027566300000000000	764711	0xab324146c49b23658e5b3930e641bdbdf089cbac	513783150000000000	2021-09-14T00:13:34.000Z	0x4b9acd1750507d2bb880d1dc364280ddc6db2bf19dbbb6c11ea999498989797a	0
0xab324146c49b23658e5b3930e641bdbdf089cbac	false	4031759383899051158512	121000000000000000	0x9757400188f2f54b83ac4dc290ab89dde526da10	6	4855790500000000000	2398560	0xab324146c49b23658e5b3930e641bdbdf089cbac	2427895250000000000	2021-10-20T14:02:32.000Z	0x7d410c53cea404158f9d3c47d9e3cd7b5a4f900e664afd8fbb6dd0d400e749d8	0

Example Query

Query with partition filter

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

LiquidityPool_Trade_event

Trade execution events from MUX Protocol v1 perpetual futures on Arbitrum, capturing position changes, execution prices, and fee breakdowns (total and LP fees) per trade. Used for analyzing trading activity, fee revenue distribution, and perpetual market dynamics across different contract indices.

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_perpetualIndex`	`STRING`	Index identifier for the perpetual contract within the liquidity pool. Numeric string representation, zero-indexed.
`in_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_lpFee`	`STRING`	Fee collected by liquidity providers from the swap transaction. Numeric string representation without decimals.

Sample Data

in_fee	address	removed	in_lpFee	in_price	in_trader	log_index	in_position	block_number	block_timestamp	transaction_hash	in_perpetualIndex
710973958488645999	0xab324146c49b23658e5b3930e641bdbdf089cbac	false	488794596460944124	1777434896221614994604	0xfdc3109579d251c71cec00119eb00d18e06f2664	12	500000000000000000	13046899	2022-05-27T07:55:05.000Z	0xd5d0c2f93ba5a5e11f41ed849619e1417fd66f218d5868517d7f4359feb1d4bb	0
705154962634685377	0xab324146c49b23658e5b3930e641bdbdf089cbac	false	484794036811346197	1762887406586713442754	0xfdc3109579d251c71cec00119eb00d18e06f2664	11	-500000000000000000	13047005	2022-05-27T07:57:08.000Z	0x89bd223af7c1d4339a408fdb1bc7a6fea665eea0b36aaeaf9b71734e46a06a77	0
202950103734376795	0xab324146c49b23658e5b3930e641bdbdf089cbac	false	139528196317384047	28828139734996703953523	0x431f554877369c81ef35ab6ad39c004f21ec6b7e	11	8800000000000000	13089221	2022-05-27T21:04:04.000Z	0xa4a954f7163ce1454ff88cffc89c3902fdeb3f0bdd688066edf60276195fa72f	1

Example Query

Query with partition filter

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

MCBShareToken_RewardPaid_event

Reward distribution events from MUX Protocol v1’s MCB (MCDEX Community Benefit) share token staking contract on Arbitrum. Tracks individual reward payouts to stakers with recipient addresses and reward amounts denominated in wei.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x67b40388eaa52a973d768f3b35abc33fd3b0aaef	0x7d4ead368f0f206274931ca91069a890bea0893a	false	17003526748823815684	1	4109376	2021-12-27T09:24:10.000Z	0x4e1891fea847f5afbee5e60ee63fce68b586d0c83722675a2a40ecd39305ffea
0x67b40388eaa52a973d768f3b35abc33fd3b0aaef	0xa29bc5e0a0d12dc9928d0567cfabb258992346c6	false	109133140169759057228	2	100431950	2023-06-12T14:50:52.000Z	0x518fd96f9b3346e7bf507481df87167a0578ba4bc4853deae60bacd1212fd380
0x67b40388eaa52a973d768f3b35abc33fd3b0aaef	0xfc10b6ce157735b42ce622361246c44327943cc2	false	12541372395169278112	1	10028223	2022-04-18T12:55:27.000Z	0xf1418e58a18f99fce2412124674ac85e6241d8c506b5713720d0f8661ee491c7

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LiquidityPool_Liquidate_event

LiquidityPool_Trade_event

MCBShareToken_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​LiquidityPool_Liquidate_event

​LiquidityPool_Trade_event

​MCBShareToken_RewardPaid_event

Tables

LiquidityPool_Liquidate_event

LiquidityPool_Trade_event

MCBShareToken_RewardPaid_event