mimo_v3_iotex

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

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_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_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	block_number	in_tickSpacing	block_timestamp	transaction_hash
3000	0xf36788bf206f75f29f99aa9d418fd8164b3b8198	0x84be60e555e9b552255fdfba4cf822f57ab41b41	false	0x710d054e3f35e0c606f1e5b1ba7b43ad930964df	0xa00744882684c3e4747faefd68d283ea44099d03	34045001	60	2025-01-04T09:38:20.000Z	0x209ca2021f2c1b2b879d4369267c62146a71fdfc9c40edd50c50959e8f51dd53
10000	0xf36788bf206f75f29f99aa9d418fd8164b3b8198	0x71bbcf3c729bed25aa1c18d50879558e1239c48c	false	0x710d054e3f35e0c606f1e5b1ba7b43ad930964df	0xa00744882684c3e4747faefd68d283ea44099d03	34044964	200	2025-01-04T09:35:15.000Z	0xdf831c674bcbc4fb7386f35bbd6de420c2372b98f05f4962a2725081c691fab3
100	0xf36788bf206f75f29f99aa9d418fd8164b3b8198	0x4c40182cf796dab232278b40055008e55dae0f3f	false	0x710d054e3f35e0c606f1e5b1ba7b43ad930964df	0xa00744882684c3e4747faefd68d283ea44099d03	34044988	1	2025-01-04T09:37:15.000Z	0xd262597274a4c583f1fa98ce9b710309837f0885fb6678f2a17d44f72793f6e4

Example Query

Query with partition filter

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

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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_owner	in_amount	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x140530ea14f9968ecd9a5df01a69eff02a6a9644	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	0	10	0	0	36627751	-887220	887220	2025-06-03T15:32:05.000Z	0xd108add98bf75b60b6bc5094c1f1225ebfc290df3a231c82a3c420f0035d7050
0x140530ea14f9968ecd9a5df01a69eff02a6a9644	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	280868907142999248547	54	396102083626902301917	199159121500629479338	36627762	-887220	887220	2025-06-03T15:33:05.000Z	0xe504713530ff73e55136ea5422b88c8abe81f69407adf0c863f92acc2fd8e2a7
0x546fe5ec57eef82b1092d684c05194cc1913b9ba	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	0	0	0	0	33165642	-887220	887220	2024-11-14T08:29:20.000Z	0x50edd244f76a122347111297bcad9ec872e3e5c08d9bfda3cdbfae5f9a921fe6

Example Query

Query with partition filter

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

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`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_owner	log_index	in_amount0	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x00d9974fb3f90228abefd4c477a2b0f349837e70	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	4	0	194832972824977735	30043240	0x9117f5ef4156709092f79740a97b1638ca399a00	-62760	-54660	2024-05-17T11:55:50.000Z	0x11c8e2d5e5db4497c80a5c3059685bd511346306af9f855d74158944aa2dee4f
0xaccea99119433bc455b1ffa789cc731d8e0fe65c	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	4	36150341588231411490	102743950513171852	30043339	0x9117f5ef4156709092f79740a97b1638ca399a00	-62760	-54660	2024-05-17T12:04:05.000Z	0x2b9c083008e1601d41c6e2bb38f087e425883d25de80859de147b37ea7fa8c3b
0xaccea99119433bc455b1ffa789cc731d8e0fe65c	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	5	16066818483658405104	45663978005854156	30043314	0x9117f5ef4156709092f79740a97b1638ca399a00	-62760	-54660	2024-05-17T12:02:00.000Z	0x73cb29b57f0f3fb63e96893fd978bae4b68b4f5f60033ef3a1eaf359837dc923

Example Query

Query with partition filter

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

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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_owner	in_amount	in_sender	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xa6055aa78685db4d778f4317a3021992d3c36324	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	300	0x6afd2d627cb163d1916d8ca84bf9796294044adf	3	1	1628964907	29522300	-887220	887220	2024-04-17T08:19:05.000Z	0x637d277ce532126e593857d5a9b40c79d4cc6958364ef1c01e5905d85d503c84
0xa6055aa78685db4d778f4317a3021992d3c36324	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	300	0x6afd2d627cb163d1916d8ca84bf9796294044adf	5	1	1628964907	29522317	-887220	887220	2024-04-17T08:20:30.000Z	0x0c0afb22a98cb8d03cfea0bd14d2aeebe2c3a753c9fa6e0734b1d4f8c8ce89b9
0xa6055aa78685db4d778f4317a3021992d3c36324	false	0x6afd2d627cb163d1916d8ca84bf9796294044adf	300	0x6afd2d627cb163d1916d8ca84bf9796294044adf	2	1	1628964907	29522342	-887220	887220	2024-04-17T08:22:35.000Z	0x9d4ea035ffcb2a4c768e6b22776a5c71eba114ef28001953e008104a17963fff

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	in_sqrtPriceX96	transaction_hash
0x57381e739ae096960b6136d3abd0904c36a86a86	-276423	false	0x000000000011650e52806dc33ec54f2aa56eaacf	5	13809454516427768468	-13666872	36588337	1530110588845077794	0x000000000011650e52806dc33ec54f2aa56eaacf	2025-06-01T08:26:45.000Z	78837446475428261851586	0x1d55f616549707076c152ed03b4629d6af61a3aff0ed9583acfe91b1a7d7860f
0x57381e739ae096960b6136d3abd0904c36a86a86	-276423	false	0x2003f7211071c84870fc284a17324ae840df4a4d	7	58897704737981435396	-58294987	36587410	1530110588845077794	0x2003f7211071c84870fc284a17324ae840df4a4d	2025-06-01T07:09:25.000Z	78839941170716646164610	0x52062ccb64288adfb053849f8d006cd9d92c270eaaef4bd5174633257fc28df8
0x57381e739ae096960b6136d3abd0904c36a86a86	-276424	false	0x000000000011650e52806dc33ec54f2aa56eaacf	5	13188904878923409467	-13052146	36589902	1530110588845077794	0x45e3de35dab1a692cc8625dc2a817c8eae414f21	2025-06-01T10:39:45.000Z	78835700270615683453825	0xdf2ff90182375b7d2f1cd9fd691d79fbc57b735aa9c504a14d37e31f5178190b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event