maverick_v1_zksyncera

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
800000000000000	0x2c1a605f843a2e18b7d7772f0ce23c236accf7f5	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	50	10800000000000000000000	7287273	581	0x1a31c6b97050c35395ac70be1fad3aa722f17bfc	198	2023-06-29T06:47:36.000Z	0x061e593c1b2c3c23759614918b36ff106630fc21decbd60df72a2f425b098228
7500000000000000	0x2c1a605f843a2e18b7d7772f0ce23c236accf7f5	false	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	0x787c09494ec8bcb24dcaf8659e7d5d69979ee508	54	10800000000000000000000	7270924	-37	0xa4c1ab4b4e71eb43cbd635f5534b9a7425dceec4	2232	2023-06-29T02:10:01.000Z	0x6dcd37c785e9638597196cdbcb3f644446795652da30e1d34241064f1ecbbe84
20000000000000	0x2c1a605f843a2e18b7d7772f0ce23c236accf7f5	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	0x503234f203fc7eb888eec8513210612a43cf6115	2	10800000000000000000000	11497960	-1	0x6e4c9b20ab50299d8fc8558182e7728a004e4ddc	1	2023-08-17T21:06:25.000Z	0xe507d0fe7255b06b6d0471896f1fbc800eaa05c0d3d3e62283d74b7046b3c04d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_zksyncera.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
0x41108b80c758f7081b7df77ca565f08dfe56da4f	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	107	148093	17682191	[{“kind”:0,“binId”:“1”,“deltaA”:“32458737328275896090773”,“deltaB”:“13987208447626951368”,“isActive”:true,“lowerTick”:1501,“deltaLpBalance”:“51836507551221186969410”}]	2023-10-30T09:28:44.000Z	0x47d2816643a0810c28e92bf071dce9d77dbfc96588d9540b521f20dc2240c12a
0x41c8cf74c27554a8972d3bf3d2bd4a14d8b604ab	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	71	29177	17672790	[{“kind”:0,“binId”:“4”,“deltaA”:“0”,“deltaB”:“2314997684999999804”,“isActive”:true,“lowerTick”:379,“deltaLpBalance”:“3860376044151171680620”}]	2023-10-30T06:46:53.000Z	0x1a4467c4b206f1eefddf8dfd465ee12532344170a2bd2a6d4994c02edc716437
0x41c8cf74c27554a8972d3bf3d2bd4a14d8b604ab	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	140	11744	17667201	[{“kind”:0,“binId”:“4”,“deltaA”:“0”,“deltaB”:“2334997664999999944”,“isActive”:true,“lowerTick”:379,“deltaLpBalance”:“3893727025094162600373”}]	2023-10-30T05:09:12.000Z	0x83655a097bade5901ad64f33158efd6d45b80b624a857939d5a4cfee9480c4df

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_zksyncera.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
0x973bbce17dc8532b0e058b3d274b9cb887216aff	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	58	139125	15113352	[{“kind”:0,“binId”:“1”,“deltaA”:“3933953440843798924497”,“deltaB”:“78107737831895968885”,“isActive”:false,“lowerTick”:-2,“deltaLpBalance”:“4039995959999999286082”}]	0x5a09edfcc6f4aa80ef9c996521b1a33650bf4c81	2023-09-29T17:04:03.000Z	0x2719a5e94caf0c97ddd8ab91c2ce688771ad33440bae14d6eca8ac9cdd322d71
0x3ae63fb198652e294b8de4c2ef659d95d5ff28be	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	5	128482	15060652	[{“kind”:0,“binId”:“1”,“deltaA”:“4348470388014673228762”,“deltaB”:“0”,“isActive”:true,“lowerTick”:373,“deltaLpBalance”:“3444917731832794523676”}]	0x39e098a153ad69834a9dac32f0fca92066ad03f4	2023-09-29T01:59:44.000Z	0xd62734c8947a9b8a9c0a534cfea73005d996164b97fad0dc00ed98ab87db19ed
0x3ae63fb198652e294b8de4c2ef659d95d5ff28be	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	93	174777	15081060	[{“kind”:0,“binId”:“2”,“deltaA”:“18837391265974167761454”,“deltaB”:“0”,“isActive”:true,“lowerTick”:374,“deltaLpBalance”:“14405820150813169445487”}]	0x39e098a153ad69834a9dac32f0fca92066ad03f4	2023-09-29T07:49:38.000Z	0xe35f5b0f5dd2f030dc72dd8a9f64343adb2af093333df862c679f4ff9a686d0a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_zksyncera.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_exactOutput	block_timestamp	transaction_hash
0xf4cfd1a8160fd83875856fd601b43c4358a89235	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	32	123197	false	5648086	123159	0x069f4881b3ed47b6c18ae2274e99dc429036786c	false	2023-06-10T01:05:02.000Z	0x2b4fbd32b2dd327364d43cd605151298fc377a28335c4d5bd828fa240d87bb23
0xc9348683a925cb2043cd1dfb006f70d88f65e009	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	25	123245	true	5647855	123183	0x069f4881b3ed47b6c18ae2274e99dc429036786c	false	2023-06-10T01:01:07.000Z	0xf9478626895b3bbf54f965b4ec6b4851221ed013c567f05ab46819495b164e61
0xc9348683a925cb2043cd1dfb006f70d88f65e009	false	0x39e098a153ad69834a9dac32f0fca92066ad03f4	27	2000000	true	5690637	1998922	0x29776a47d6480030ca860479ed3000c4de8cc89b	false	2023-06-10T13:13:04.000Z	0xa2ccefa80517544f7225f5a2443f69a9846b1139db80ece394ac8d7170341c4d

Example Query

Query with partition filter

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