maverick_v1_base

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_poolAddress`	`STRING`	Contract address of the liquidity pool. 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`	`STRING`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_activeTick`	`INT64`	Current tick position in the liquidity pool after the swap or pool creation. Signed integer representing the active price tick in the concentrated liquidity pool’s tick-spaced price range.
`in_lookback`	`STRING`	Lookback period for the liquidity pool in Maverick V1. String-encoded integer representing the time window in wei units (10^18 per unit), with a standard value of 10800 units equivalent to 3 hours.
`in_protocolFeeRatio`	`STRING`	Protocol fee ratio allocated to the protocol from trading fees. String-encoded integer where 0 indicates no protocol fee is collected.
`in_tokenA`	`STRING`	Contract address of the first token in a token pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenB`	`STRING`	Contract address of the second token in a token pair. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	removed	in_tokenA	in_tokenB	log_index	in_lookback	block_number	in_activeTick	in_poolAddress	in_tickSpacing	block_timestamp	transaction_hash
100000000000000	0xb2855783a346735e4aae0c1eb894def861fa9b45	false	0x50c5725949a6f0c72e6c4a641f24049a917db0cb	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	22	10800000000000000000000	2624264	-2	0x699d167e9c94b6581a01eca98b8aa1571a403732	4	2023-08-14T18:31:15.000Z	0x5523468202a9387bcde5c046f02d7b64c9b1badd56513123dbf7d36d900f0a21
400000000000000	0xb2855783a346735e4aae0c1eb894def861fa9b45	false	0xcfa3ef56d303ae4faaba0592388f19d7c3399fb4	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	62	10800000000000000000000	9229302	1	0xb65cfcf3442a627a3a707c89dd0072ecf6f0627d	40	2024-01-14T15:59:11.000Z	0x5012cb5099344ee123ab299b3c483ece03d5407cb83da361ccc33bf5c735b348
10000000000000000	0xb2855783a346735e4aae0c1eb894def861fa9b45	false	0x4200000000000000000000000000000000000006	0x64b88c73a5dfa78d1713fe1b4c69a22d7e0faaa7	15	10800000000000000000000	4692060	-22	0x4ebe276c57da1197373733b1136544ebdae9c661	4055	2023-10-01T15:17:47.000Z	0x6e0cf306bdef724fb6ad7a99167c4bb415cf688c110861ec5d2a03a83ce7fd8a

Example Query

Query with partition filter

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

Pool_AddLiquidity_event

Liquidity provision events recording deposits into decentralized exchange (DEX) pools. Contains deposited asset addresses, amounts, liquidity position identifiers, and updated pool liquidity balances for tracking capital inflows and position creation.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_binDeltas`	`ARRAY<STRUCT<deltaA STRING, deltaB STRING, deltaLpBalance STRING, binId STRING, kind INT64, lowerTick INT64, isActive BOOL>>`	Array of liquidity bin state changes in Maverick AMM pools. Each element contains token deltas (deltaA, deltaB), LP balance change (deltaLpBalance), bin identifier (binId), bin type (kind), tick position (lowerTick), and active status (isActive).

Sample Data

address	removed	in_sender	log_index	in_tokenId	block_number	in_binDeltas	block_timestamp	transaction_hash
0xe6917fbf0f44053fd42b55657555afa89806cc24	false	0x32aed3bce901da12ca8489788f3a99fce1056e14	42	3304	5121556	[{“kind”:3,“binId”:“10”,“deltaA”:“26308805579”,“deltaB”:“461972667457940”,“isActive”:true,“lowerTick”:-40,“deltaLpBalance”:“138785433492433”}]	2023-10-11T13:54:19.000Z	0x673a1596c626b0a9a02f9cfa49a672909c7d444a5e7a50dc32a4537a1348a236
0x3d70b2f31f75dc84acdd5e1588695221959b2d37	false	0x32aed3bce901da12ca8489788f3a99fce1056e14	10	3305	5122544	[{“kind”:3,“binId”:“15”,“deltaA”:“337167675239558532”,“deltaB”:“55470669000000000000”,“isActive”:true,“lowerTick”:-152,“deltaLpBalance”:“199687048063164414238”}]	2023-10-11T14:27:15.000Z	0xd59335225e6ebcd1cd67b3eb601f549b0312d5611b3d1206850f5e9a5c38e0be
0x06e6736ca9e922766279a22b75a600fe8b8473b6	false	0xc402d13b0d04867649a632f17528c753d8f6fbd2	26	1	5132446	[{“kind”:3,“binId”:“21”,“deltaA”:“10000000000000002”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-373,“deltaLpBalance”:“15774989950128872492”}]	2023-10-11T19:57:19.000Z	0xc60e3509d79d73537f121fc16109ebe0e3e0817a00d9e2f203dcaf1011d5b635

Example Query

Query with partition filter

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

Pool_RemoveLiquidity_event

Liquidity withdrawal events from decentralized exchange pools recording the removal of assets by liquidity providers. Contains withdrawal amounts, recipient addresses, and pool state changes including updated liquidity balances and token identifiers.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_binDeltas`	`ARRAY<STRUCT<deltaA STRING, deltaB STRING, deltaLpBalance STRING, binId STRING, kind INT64, lowerTick INT64, isActive BOOL>>`	Array of liquidity bin state changes in Maverick AMM pools. Each element contains token deltas (deltaA, deltaB), LP balance change (deltaLpBalance), bin identifier (binId), bin type (kind), tick position (lowerTick), and active status (isActive).

Sample Data

address	removed	in_sender	log_index	in_tokenId	block_number	in_binDeltas	in_recipient	block_timestamp	transaction_hash
0x3d70b2f31f75dc84acdd5e1588695221959b2d37	false	0x32aed3bce901da12ca8489788f3a99fce1056e14	25	4897	8246280	[{“kind”:0,“binId”:“48”,“deltaA”:“3459061190666”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-161,“deltaLpBalance”:“3458869898365”}]	0x32aed3bce901da12ca8489788f3a99fce1056e14	2023-12-22T21:51:47.000Z	0x94d56ec626eeee7188c4d04ef03dd56f2e1d353d8012644dcbf53063fbf76a9c
0x06e6736ca9e922766279a22b75a600fe8b8473b6	false	0x32aed3bce901da12ca8489788f3a99fce1056e14	4	5825	8222136	[{“kind”:0,“binId”:“278”,“deltaA”:“499999499999999985”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-408,“deltaLpBalance”:“499999499999999985”}]	0x32aed3bce901da12ca8489788f3a99fce1056e14	2023-12-22T08:26:59.000Z	0xf8d0b03cbecfe349efd88ba88fd97cc23ac0b85e64d17bc9b694232ed3e8e8e3
0x06e6736ca9e922766279a22b75a600fe8b8473b6	false	0x32aed3bce901da12ca8489788f3a99fce1056e14	2	5814	8211455	[{“kind”:0,“binId”:“297”,“deltaA”:“9999989999999998”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-407,“deltaLpBalance”:“9999989999999999”}]	0x32aed3bce901da12ca8489788f3a99fce1056e14	2023-12-22T02:30:57.000Z	0x001b47ec0e626193619ebb33d1e97a56384bb2ba6365d37a184442fd20488e6c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_base.Pool_RemoveLiquidity_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_tokenAIn`	`BOOL`	Boolean flag indicating whether the input token is token A in the liquidity pool pair.
`in_exactOutput`	`BOOL`	Boolean flag indicating whether the swap specifies an exact output amount rather than an exact input amount.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_activeTick`	`INT64`	Current tick position in the liquidity pool after the swap or pool creation. Signed integer representing the active price tick in the concentrated liquidity pool’s tick-spaced price range.

Sample Data

address	removed	in_sender	log_index	in_amountIn	in_tokenAIn	block_number	in_amountOut	in_recipient	in_activeTick	in_exactOutput	block_timestamp	transaction_hash
0x699d167e9c94b6581a01eca98b8aa1571a403732	false	0x7d2b63a9ab475397d9c247468803f25cf6523b76	12	84909365	false	3171730	84982742683543283829	0x19ceead7105607cd444f5ad10dd51356436095a1	1	false	2023-08-27T10:40:07.000Z	0xd5c08ba712f6bc3afe47c3a2ed9e907ca2ed4ae49db6b59938f13f18c7a77b66
0x699d167e9c94b6581a01eca98b8aa1571a403732	false	0x01538aa697ce8cc8252c70c41452dae86ce22a3e	54	56105349268347444803	true	3181941	56051260	0x1111111254eeb25477b68fb85ed929f73a960582	2	false	2023-08-27T16:20:29.000Z	0x39240d606cbb33b7707de391ccb63d6ad40bad5bdae4516ca4714e2ffc7fed4f
0x699d167e9c94b6581a01eca98b8aa1571a403732	false	0x32aed3bce901da12ca8489788f3a99fce1056e14	24	989000	false	3166154	990154492261616315	0xc738705d74ad79062ebe4a778fbfccf2affaded9	3	false	2023-08-27T07:34:15.000Z	0xb745f9df37d29524355d7e3105de0e24def23692924b74d2bfc6253231ee2e6b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_AddLiquidity_event

Pool_RemoveLiquidity_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_AddLiquidity_event

​Pool_RemoveLiquidity_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_AddLiquidity_event

Pool_RemoveLiquidity_event

Pool_Swap_event