maverick_v1_bsc

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
1000000000000000	0x76311728ff86054ad4ac52d2e9ca005bc702f589	false	0x55d398326f99059ff775485246999027b3197955	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	158	10800000000000000000000	29982747	108	0x34cce05d2729a272794c928997859745ecb52e43	953	2023-07-15T11:11:27.000Z	0xc24ce5ae9ec0572cc4ae9ebf05c37255f22c805907af35a13664bab26f4e34a3
20000000000000000	0x76311728ff86054ad4ac52d2e9ca005bc702f589	false	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	74	10800000000000000000000	31363057	17	0x132c43226c11b7fc62a7e701a40f119f5555c295	4055	2023-09-01T13:25:30.000Z	0xe5e91f46f8ef8723ea065aec0caba7647d386dd01489b2a8d46e11afb268243a
100000000000000	0x76311728ff86054ad4ac52d2e9ca005bc702f589	false	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0xe9e7cea3dedca5984780bafc599bd69add087d56	74	10800000000000000000000	29451297	0	0xecba88e3b18b3602ffad3e049a85512ba3b75a45	1	2023-06-26T22:57:04.000Z	0x880f89fc2ef65e2acd14c198de408b294bf0da456fff7300856031b82f021e22

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_bsc.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
0xe1ee3167982d2c8e11428023a6d750a180ec016c	false	0xd53a9f3fae2bd46d35e9a30ba58112a585542869	365	191	30599936	[{“kind”:0,“binId”:“3”,“deltaA”:“18172643600312794”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-18,“deltaLpBalance”:“18172643600312794”},{“kind”:0,“binId”:“4”,“deltaA”:“35607809510446910”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-17,“deltaLpBalance”:“35607809510446910”},{“kind”:0,“binId”:“5”,“deltaA”:“69770591776225770”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-16,“deltaLpBalance”:“69770591776225770”},{“kind”:0,“binId”:“6”,“deltaA”:“136709770798357720”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-15,“deltaLpBalance”:“136208400980355183”},{“kind”:0,“binId”:“7”,“deltaA”:“12618346140411021”,“deltaB”:“921908317029615227”,“isActive”:true,“lowerTick”:-14,“deltaLpBalance”:“237327914801056619”},{“kind”:0,“binId”:“8”,“deltaA”:“0”,“deltaB”:“494895136255128542”,“isActive”:true,“lowerTick”:-13,“deltaLpBalance”:“494192225124317833”},{“kind”:0,“binId”:“9”,“deltaA”:“0”,“deltaB”:“252572484922278128”,“isActive”:true,“lowerTick”:-12,“deltaLpBalance”:“252572484922278128”},{“kind”:0,“binId”:“10”,“deltaA”:“0”,“deltaB”:“128901772247218021”,“isActive”:true,“lowerTick”:-11,“deltaLpBalance”:“128901772247218021”},{“kind”:0,“binId”:“11”,“deltaA”:“0”,“deltaB”:“65785736295015273”,“isActive”:true,“lowerTick”:-10,“deltaLpBalance”:“65785736295015273”}]	2023-08-05T23:09:08.000Z	0xbf9f628e29780c3fb3d4e6dfda2b1cad3828481f77a27dd2f727c243b6c1f0f4
0xaa35220cb1aeb447f5a400c3d5a64d227c319601	false	0xd53a9f3fae2bd46d35e9a30ba58112a585542869	43	466	30594777	[{“kind”:0,“binId”:“4”,“deltaA”:“3410451931825842386”,“deltaB”:“0”,“isActive”:true,“lowerTick”:272,“deltaLpBalance”:“3410451931825842386”},{“kind”:0,“binId”:“5”,“deltaA”:“5678824850862923767”,“deltaB”:“0”,“isActive”:true,“lowerTick”:273,“deltaLpBalance”:“5671768917050786668”},{“kind”:0,“binId”:“6”,“deltaA”:“9455946698979932562”,“deltaB”:“0”,“isActive”:true,“lowerTick”:274,“deltaLpBalance”:“9404103145140828937”},{“kind”:0,“binId”:“7”,“deltaA”:“15745322372525803799”,“deltaB”:“0”,“isActive”:true,“lowerTick”:275,“deltaLpBalance”:“15132969777506047693”},{“kind”:0,“binId”:“8”,“deltaA”:“26217911807975131210”,“deltaB”:“0”,“isActive”:true,“lowerTick”:276,“deltaLpBalance”:“24570091113428124951”},{“kind”:0,“binId”:“9”,“deltaA”:“15267898708383705657”,“deltaB”:“116283273435141928”,“isActive”:true,“lowerTick”:277,“deltaLpBalance”:“40039625039357648033”},{“kind”:0,“binId”:“10”,“deltaA”:“0”,“deltaB”:“107767143382085747”,“isActive”:true,“lowerTick”:278,“deltaLpBalance”:“22478221293247021996”},{“kind”:0,“binId”:“11”,“deltaA”:“0”,“deltaB”:“64720196869417031”,“isActive”:true,“lowerTick”:279,“deltaLpBalance”:“63684038746727561”},{“kind”:0,“binId”:“12”,“deltaA”:“0”,“deltaB”:“38868097931900699”,“isActive”:true,“lowerTick”:280,“deltaLpBalance”:“38544235606468475”},{“kind”:0,“binId”:“13”,“deltaA”:“0”,“deltaB”:“23342466647497752”,“isActive”:true,“lowerTick”:281,“deltaLpBalance”:“23338971612837473”},{“kind”:0,“binId”:“14”,“deltaA”:“0”,“deltaB”:“14018456733956808”,“isActive”:true,“lowerTick”:282,“deltaLpBalance”:“14018456733956808”}]	2023-08-05T18:49:03.000Z	0x74300de1ee24f6284785c0e4bb78d2ebec90d93dda1d7577cdbb60cb82aede16
0x71dc5af20cf650b8d517e8cb85dc92568bc249d9	false	0xd53a9f3fae2bd46d35e9a30ba58112a585542869	68	304	30591223	[{“kind”:1,“binId”:“42”,“deltaA”:“925093215271043618485”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-7,“deltaLpBalance”:“925093215271043618485”}]	2023-08-05T15:50:30.000Z	0xbbc9b5ba9b3faa5eca9d8dbfd39f881636ff23390a239174fd047c1dea488bef

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_bsc.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
0x9c0352baf49678867920163d57965fcbcf0c63b2	false	0xc670585b3895d6cf13369091760b7f1be47b40ee	152	3	30564370	[{“kind”:3,“binId”:“12”,“deltaA”:“254371795023272782805”,“deltaB”:“247795994272347649526”,“isActive”:true,“lowerTick”:8,“deltaLpBalance”:“387754307396019859016”}]	0xffa13daf5b32e44758a5c4882f4df2612c0311b2	2023-08-04T17:20:13.000Z	0x19d7bb1827d745cc2c0b02dc3fb9632ba1c37b407614160c1ee5302f72a4058f
0xaa35220cb1aeb447f5a400c3d5a64d227c319601	false	0xd53a9f3fae2bd46d35e9a30ba58112a585542869	133	447	30543895	[{“kind”:3,“binId”:“98”,“deltaA”:“8281100851360529974”,“deltaB”:“453487374911537718”,“isActive”:false,“lowerTick”:277,“deltaLpBalance”:“12766834140442716852”}]	0xd53a9f3fae2bd46d35e9a30ba58112a585542869	2023-08-04T00:12:00.000Z	0x3ce77388f2cdb2ebbd36aaae85458e27bdd25e8c3a95863c0694d87da540bbce
0xaa35220cb1aeb447f5a400c3d5a64d227c319601	false	0xd53a9f3fae2bd46d35e9a30ba58112a585542869	122	264	30543806	[{“kind”:0,“binId”:“12”,“deltaA”:“0”,“deltaB”:“10159887214560179”,“isActive”:true,“lowerTick”:280,“deltaLpBalance”:“10075231549001202”},{“kind”:0,“binId”:“11”,“deltaA”:“0”,“deltaB”:“17044480913683619”,“isActive”:true,“lowerTick”:279,“deltaLpBalance”:“16771601994891511”},{“kind”:0,“binId”:“10”,“deltaA”:“0”,“deltaB”:“28659566895538367”,“isActive”:true,“lowerTick”:278,“deltaLpBalance”:“5977852494080461402”},{“kind”:0,“binId”:“9”,“deltaA”:“948781361776475665”,“deltaB”:“45722492481924186”,“isActive”:true,“lowerTick”:277,“deltaLpBalance”:“11127871330090482755”},{“kind”:0,“binId”:“8”,“deltaA”:“19046914739629750345”,“deltaB”:“0”,“isActive”:true,“lowerTick”:276,“deltaLpBalance”:“17856102697408641740”},{“kind”:0,“binId”:“7”,“deltaA”:“30310607636853636436”,“deltaB”:“0”,“isActive”:true,“lowerTick”:275,“deltaLpBalance”:“29131795364617160599”},{“kind”:0,“binId”:“6”,“deltaA”:“18111554493927169316”,“deltaB”:“0”,“isActive”:true,“lowerTick”:274,“deltaLpBalance”:“18012255356526462076”},{“kind”:0,“binId”:“5”,“deltaA”:“10877001427997361913”,“deltaB”:“0”,“isActive”:true,“lowerTick”:273,“deltaLpBalance”:“10863486765339856644”},{“kind”:0,“binId”:“4”,“deltaA”:“6532247693279219723”,“deltaB”:“0”,“isActive”:true,“lowerTick”:272,“deltaLpBalance”:“6532247693279219724”},{“kind”:0,“binId”:“3”,“deltaA”:“3922980079465587797”,“deltaB”:“0”,“isActive”:true,“lowerTick”:271,“deltaLpBalance”:“3922980079465587798”},{“kind”:0,“binId”:“2”,“deltaA”:“2355968944612668812”,“deltaB”:“0”,“isActive”:true,“lowerTick”:270,“deltaLpBalance”:“2355968944612668813”}]	0xd53a9f3fae2bd46d35e9a30ba58112a585542869	2023-08-04T00:07:33.000Z	0x7a90f2db2096e97d81e76b2ea61f126f7610da1258f6c26e769ce28b98665a78

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_bsc.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
0xad0e506a6426b461223ae28d1bf6b20a1a4ba99a	false	0x830c9e0295730bbb220bd78346c6499ff37851fb	100	1190390794766246781500	true	33295190	1189907205967375710876	0x0dee94ddde9a0b644d5d57d700ed03736580da82	3	false	2023-11-07T21:07:18.000Z	0x3b933d9eee5f3048b50e2f7ab3f9ca20a09066bfe85a0f6c9428fe9ef48c588a
0xaa35220cb1aeb447f5a400c3d5a64d227c319601	false	0xd785558a15c67b6201d84ac586b219bd26e7dab5	219	215329824064000000000	true	33288314	891907958808184592	0x5b83802bf19832e76b98ddf4fc775357562ade2d	277	false	2023-11-07T15:22:29.000Z	0x7a954a78144b7d60ad069a6571321aa537b693002c044e7e05c35365c3357516
0xaa35220cb1aeb447f5a400c3d5a64d227c319601	false	0x830c9e0295730bbb220bd78346c6499ff37851fb	406	4997673481990360421	true	33291680	20386536933229944	0xd9c921bf0c494e04d0ade5f37d093135c9c77d20	277	false	2023-11-07T18:11:06.000Z	0xa6799ffeeca4ffdfc66670f1fef8f30e82ace3a6e2ec7bc5240a3c85e6233900

Example Query

Query with partition filter

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