mimo_v2_iotex

Tables

MimoFactory_PairCreated_event

Liquidity pool creation events from Mimo v2 decentralized exchange (DEX) factory contract on IoTeX blockchain, recording new trading pairs with their token addresses and sequential pair identifiers. Used for tracking DEX pool deployments and analyzing liquidity expansion patterns across token pairs.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	block_number	block_timestamp	transaction_hash
0xda257cbe968202dea212bbb65ab49f174da58b9d	0xf4e0e3885f7629356e018e61d2cf8c14bb03f361	false	186	0x210860a8d8830e43a93b37856af3fc357395ac88	0xa00744882684c3e4747faefd68d283ea44099d03	13612968	2021-10-07T18:11:25.000Z	0x8a783b18286d7532d3e5ab3c99904310b24ec07151ce24c780a1670b6fa2a272
0xda257cbe968202dea212bbb65ab49f174da58b9d	0xe9af35d52fc48bdbe136bdfcf9d1715d0ff330fe	false	185	0x6fbcdc1169b5130c59e72e51ed68a84841c98cd1	0xacee9b11cd4b3f57e58880277ac72c8c41abe4e4	13612148	2021-10-07T17:01:15.000Z	0xfb83c909d0164ef0e8d0f3204a5569378e251e2b1dbfb8425d1d453ce65823ce
0xda257cbe968202dea212bbb65ab49f174da58b9d	0xf32fba776934f474434dc6ea622646ea5ffcff03	false	489	0x32085b8ea854529178bd0f4e92d3fd2475a3a159	0x3ea683354bf8d359cd9ec6e08b5aec291d71d880	17124899	2022-04-29T19:02:55.000Z	0xaf112dcb72d74bb6b146ca7e9fa5e96d60464295ed20c960a9886f2bdf79c5b0

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	0x53bdd401a871bd0f84e94619edcc0c24489d4aab	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	6	71476207824	1844363110956	16665620	2022-04-03T04:22:50.000Z	0x197fac327c80284304b1d6e421ecce341275012ec2ca48dac67bab81b00acccf
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	0xc019b1861f5b9d8e07aa47e30ea1291bd7087d30	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	6	1156197124290048324	588469075339231437694	16665635	2022-04-03T04:24:05.000Z	0x8f52e9c07c30f4cbc75a84e0a931caf6c7c158a0b4ba07fb84d94ddd96690f5d
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	0x53bdd401a871bd0f84e94619edcc0c24489d4aab	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	5	205618163530647713	5304829989999999996	16668569	2022-04-03T08:28:55.000Z	0xcd11f1b690ab6db9492725685c167c620afdda3d6e4256a826942efec1c5794b

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x53bdd401a871bd0f84e94619edcc0c24489d4aab	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	5	27321565039658530599	14999999158538562227	34991110	2025-02-28T16:06:35.000Z	0x89f50aebbf96f89dac5546050dd6771110bfd35c1b6c0f4b943be259c3169ce4
0x53bdd401a871bd0f84e94619edcc0c24489d4aab	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	5	182548228418140575274	100000000000000000000	34987493	2025-02-28T11:05:10.000Z	0xd3d127daa5f70bffe51b7a5b3296bbf46b78cbdb67761f9af5b52d3766c95b6c
0x3396d2ec0dd33e6a86bd201208aec8415b0b2991	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	9	17058065757555135710	66556538042976494415	17992044	2022-06-19T02:53:00.000Z	0x97920e33120a77f5f4ca78aa48b0687f9b4258d247c1468e859d4f8aee5c1ef4

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	0xfbc64b5ad21c3c151aaf980113ac91df57d379e8	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	13	40022606	6183696153435947	228290694684120332	2025-09-18T00:00:05.000Z	0x52face07c26cf6264521ef0af29365c1620a2f5ba85b00301627519da957df9e
0x147cdae2bf7e809b9789ad0765899c06b361c5ce	0xe82b7054471d3f5cc825c50350da3bca64f7be4e	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	3	40022606	5525	205721402066910502	2025-09-18T00:00:05.000Z	0xf1f9312e0b88270c06a4226800ebfdcb29e9c76eef3f450eebd583f07f999187
0x8055a2ef7f270c1f6b486e1efe3720d8aee2acaa	0x11dc33d4df35055cc3b8b11b6702db62ac28f666	false	0x147cdae2bf7e809b9789ad0765899c06b361c5ce	133	40022608	138123025217861588	98922455403158536043	2025-09-18T00:00:10.000Z	0x542f34832c5506d0994d9faafa862bfe457bdf5cc80b0489ec643fcb64b9b02c

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0xb4bcc9923337746b3931fded94187c321eef5d81	false	21	581339322992780340156124	213507736964887721052	30811920	2024-07-01T00:22:45.000Z	0x2cf68d365fecdfdda8d9cdbbe9f5626c020885a28efdabd3b68eba97d1e8103d
0x8f5c53d654d90f2ac077dacc9c17bf9f8dc126c3	false	24	893374683395407966734565	8252621516404349188318	30811920	2024-07-01T00:22:45.000Z	0x2cf68d365fecdfdda8d9cdbbe9f5626c020885a28efdabd3b68eba97d1e8103d
0x1a1657252cbdd4706225e3634e92eeba8ee4e9e9	false	5	706321052	1223531223037803150	30812519	2024-07-01T01:12:40.000Z	0x5446e9f7ba1d8e8b686378be5c247dc05276aa7e13507eec1bbd24dbdf825c2f

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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
0x0000000000000000000000000000000000000000	0x2a382b6d2dac1cba6e4820fd04e3c2c14e1aa7b2	0x2a382b6d2dac1cba6e4820fd04e3c2c14e1aa7b2	false	9349467281714266	9	21658612	2023-01-17T17:13:05.000Z	0x8c80b80fe46e494331f7b97bc504f6bf1bceee204b46301dc708bf692afe5316
0x2a382b6d2dac1cba6e4820fd04e3c2c14e1aa7b2	0x2a382b6d2dac1cba6e4820fd04e3c2c14e1aa7b2	0x0c97af9a5ec1cdea687c67fb5e46314dc263180c	false	9349467281714266	8	21658612	2023-01-17T17:13:05.000Z	0x8c80b80fe46e494331f7b97bc504f6bf1bceee204b46301dc708bf692afe5316
0x2a7775e754ca239c54030d7d804c7cb49cb38567	0x2a7775e754ca239c54030d7d804c7cb49cb38567	0x0c97af9a5ec1cdea687c67fb5e46314dc263180c	false	760863093205128254	0	21658579	2023-01-17T17:10:20.000Z	0x940bb4dcaba2a6a5900a9129b96b674c3972d4fd80959c8e78dfd1e4bbaf14ce

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MimoFactory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MimoFactory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

MimoFactory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event