maverick_v1_ethereum

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	0xeb6625d65a0553c9dbc64449e56abfe519bd9c9b	false	0x183015a9ba6ff60230fdeadc3f43b3d788b13e21	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	434	10800000000000000000000	17655195	6	0x123683d168d8615b73bd7c85a1dc947414965d53	20	2023-07-09T09:14:35.000Z	0x4cd03a7ebb5fd031c3c32cadc693d2758ad7d79d7f74ff2d6aeeaa93e373677d
300000000000000	0xeb6625d65a0553c9dbc64449e56abfe519bd9c9b	false	0x5f98805a4e8be255a32880fdec7f6728c6568ba0	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	249	10800000000000000000000	17245035	-3	0xeab253203605d0b2ca7bde2157009d121cffdd27	40	2023-05-12T15:31:23.000Z	0x819fe889eef162be410a815c2a8dbcf940f811703bfc8c613517d160ac1085e5
300000000000000	0xeb6625d65a0553c9dbc64449e56abfe519bd9c9b	false	0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f	0x5f98805a4e8be255a32880fdec7f6728c6568ba0	114	10800000000000000000000	17726333	13	0x2e9b3deca040abe4cb11b8ba4135da6f379a44b0	10	2023-07-19T09:25:59.000Z	0x7631796bb09977315a985c4145075063ce833c99121b9c51f839386a3d0907a1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_ethereum.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
0x0ce176e1b11a8f88a4ba2535de80e81f88592bad	false	0xe7583af5121a8f583efd82767cccfeb71069d93a	202	910	18518070	[{“kind”:0,“binId”:“1”,“deltaA”:“0”,“deltaB”:“2398675137153562”,“isActive”:true,“lowerTick”:19,“deltaLpBalance”:“2439938458463125”},{“kind”:0,“binId”:“2”,“deltaA”:“0”,“deltaB”:“3479970364253428”,“isActive”:true,“lowerTick”:20,“deltaLpBalance”:“3544374310349838”},{“kind”:0,“binId”:“3”,“deltaA”:“0”,“deltaB”:“5286302464579040”,“isActive”:true,“lowerTick”:21,“deltaLpBalance”:“5390083381950164”},{“kind”:0,“binId”:“4”,“deltaA”:“0”,“deltaB”:“7869089935185491”,“isActive”:true,“lowerTick”:22,“deltaLpBalance”:“8043312439433952”},{“kind”:0,“binId”:“5”,“deltaA”:“0”,“deltaB”:“11842748758827697”,“isActive”:true,“lowerTick”:23,“deltaLpBalance”:“12090951085731325”},{“kind”:0,“binId”:“6”,“deltaA”:“0”,“deltaB”:“16818604529284237”,“isActive”:true,“lowerTick”:24,“deltaLpBalance”:“8585244174902977”},{“kind”:0,“binId”:“7”,“deltaA”:“0”,“deltaB”:“26286374398714597”,“isActive”:true,“lowerTick”:25,“deltaLpBalance”:“26275616741498127”},{“kind”:0,“binId”:“8”,“deltaA”:“0”,“deltaB”:“42037176245681924”,“isActive”:true,“lowerTick”:26,“deltaLpBalance”:“42031849282577066”},{“kind”:0,“binId”:“9”,“deltaA”:“0”,“deltaB”:“67157251184459277”,“isActive”:true,“lowerTick”:27,“deltaLpBalance”:“67157251184459277”},{“kind”:0,“binId”:“10”,“deltaA”:“0”,“deltaB”:“106253311777007924”,“isActive”:true,“lowerTick”:28,“deltaLpBalance”:“106253311777007924”},{“kind”:0,“binId”:“11”,“deltaA”:“0”,“deltaB”:“166468713156476737”,“isActive”:true,“lowerTick”:29,“deltaLpBalance”:“166468713156476737”},{“kind”:0,“binId”:“14”,“deltaA”:“0”,“deltaB”:“243489986514634106”,“isActive”:true,“lowerTick”:30,“deltaLpBalance”:“243489986514634110”},{“kind”:0,“binId”:“15”,“deltaA”:“0”,“deltaB”:“344881095533876298”,“isActive”:true,“lowerTick”:31,“deltaLpBalance”:“344881095533876303”},{“kind”:0,“binId”:“18”,“deltaA”:“0”,“deltaB”:“107161436641591”,“isActive”:true,“lowerTick”:13,“deltaLpBalance”:“108239455972982”},{“kind”:0,“binId”:“19”,“deltaA”:“0”,“deltaB”:“338019835504681”,“isActive”:true,“lowerTick”:14,“deltaLpBalance”:“341701642815156”},{“kind”:0,“binId”:“20”,“deltaA”:“0”,“deltaB”:“593056655975319”,“isActive”:true,“lowerTick”:15,“deltaLpBalance”:“600275284090280”},{“kind”:0,“binId”:“21”,“deltaA”:“0”,“deltaB”:“855902371114265”,“isActive”:true,“lowerTick”:16,“deltaLpBalance”:“868020941333019”},{“kind”:0,“binId”:“22”,“deltaA”:“0”,“deltaB”:“1175827802488993”,“isActive”:true,“lowerTick”:17,“deltaLpBalance”:“1194361363816144”},{“kind”:0,“binId”:“23”,“deltaA”:“0”,“deltaB”:“1610731898099130”,“isActive”:true,“lowerTick”:18,“deltaLpBalance”:“1637330906533887”}]	2023-11-07T05:43:35.000Z	0x39b448af7e6131eb7a59d6be3810442f1bdfa36df86afa29f75eb6a35c810f8f
0x0ce176e1b11a8f88a4ba2535de80e81f88592bad	false	0xe7583af5121a8f583efd82767cccfeb71069d93a	233	910	18519320	[{“kind”:0,“binId”:“1”,“deltaA”:“0”,“deltaB”:“2302728131667421”,“isActive”:true,“lowerTick”:19,“deltaLpBalance”:“2342340920124601”},{“kind”:0,“binId”:“2”,“deltaA”:“0”,“deltaB”:“3340771549683293”,“isActive”:true,“lowerTick”:20,“deltaLpBalance”:“3402599337935846”},{“kind”:0,“binId”:“3”,“deltaA”:“0”,“deltaB”:“5074850365995881”,“isActive”:true,“lowerTick”:21,“deltaLpBalance”:“5174480046672160”},{“kind”:0,“binId”:“4”,“deltaA”:“0”,“deltaB”:“7554326337778074”,“isActive”:true,“lowerTick”:22,“deltaLpBalance”:“7721579941856597”},{“kind”:0,“binId”:“5”,“deltaA”:“0”,“deltaB”:“11369038808474594”,“isActive”:true,“lowerTick”:23,“deltaLpBalance”:“11607313042302077”},{“kind”:0,“binId”:“6”,“deltaA”:“0”,“deltaB”:“16145860348112874”,“isActive”:true,“lowerTick”:24,“deltaLpBalance”:“8241834407906861”},{“kind”:0,“binId”:“7”,“deltaA”:“0”,“deltaB”:“25234919422766025”,“isActive”:true,“lowerTick”:25,“deltaLpBalance”:“25224592071838213”},{“kind”:0,“binId”:“8”,“deltaA”:“0”,“deltaB”:“40355689195854664”,“isActive”:true,“lowerTick”:26,“deltaLpBalance”:“40350575311274000”},{“kind”:0,“binId”:“9”,“deltaA”:“0”,“deltaB”:“64470961137080934”,“isActive”:true,“lowerTick”:27,“deltaLpBalance”:“64470961137080934”},{“kind”:0,“binId”:“10”,“deltaA”:“0”,“deltaB”:“102003179305927651”,“isActive”:true,“lowerTick”:28,“deltaLpBalance”:“102003179305927651”},{“kind”:0,“binId”:“11”,“deltaA”:“0”,“deltaB”:“159809964630217736”,“isActive”:true,“lowerTick”:29,“deltaLpBalance”:“159809964630217736”},{“kind”:0,“binId”:“14”,“deltaA”:“0”,“deltaB”:“233750387054048843”,“isActive”:true,“lowerTick”:30,“deltaLpBalance”:“233750387054048846”},{“kind”:0,“binId”:“15”,“deltaA”:“0”,“deltaB”:“331085851712521388”,“isActive”:true,“lowerTick”:31,“deltaLpBalance”:“331085851712521392”},{“kind”:0,“binId”:“18”,“deltaA”:“0”,“deltaB”:“102874979175927”,“isActive”:true,“lowerTick”:13,“deltaLpBalance”:“103909877734063”},{“kind”:0,“binId”:“19”,“deltaA”:“0”,“deltaB”:“324499042084494”,“isActive”:true,“lowerTick”:14,“deltaLpBalance”:“328033577102550”},{“kind”:0,“binId”:“20”,“deltaA”:“0”,“deltaB”:“569334389736306”,“isActive”:true,“lowerTick”:15,“deltaLpBalance”:“576264272726669”},{“kind”:0,“binId”:“21”,“deltaA”:“0”,“deltaB”:“821666276269696”,“isActive”:true,“lowerTick”:16,“deltaLpBalance”:“833300103679699”},{“kind”:0,“binId”:“22”,“deltaA”:“0”,“deltaB”:“1128794690389433”,“isActive”:true,“lowerTick”:17,“deltaLpBalance”:“1146586909263498”},{“kind”:0,“binId”:“23”,“deltaA”:“0”,“deltaB”:“1546302622175166”,“isActive”:true,“lowerTick”:18,“deltaLpBalance”:“1571837670272532”}]	2023-11-07T09:56:35.000Z	0x5b0264abef607297a2aaba1ec1e516852ae49342278c8b2453b23800a09b48df
0xb0ba344cdf607dd952c6cbf70b21caed77c3d200	false	0xe7583af5121a8f583efd82767cccfeb71069d93a	207	910	18518079	[{“kind”:0,“binId”:“8”,“deltaA”:“1760029302720106448926”,“deltaB”:“0”,“isActive”:true,“lowerTick”:-1,“deltaLpBalance”:“1760029302720106448926”},{“kind”:0,“binId”:“9”,“deltaA”:“3452494724493785095652”,“deltaB”:“0”,“isActive”:true,“lowerTick”:0,“deltaLpBalance”:“3254959766794871055738”},{“kind”:0,“binId”:“10”,“deltaA”:“5704299709623586442906”,“deltaB”:“0”,“isActive”:true,“lowerTick”:1,“deltaLpBalance”:“4618703742724256291982”},{“kind”:0,“binId”:“11”,“deltaA”:“4262136906533535208156”,“deltaB”:“2915520587823222231431”,“isActive”:true,“lowerTick”:2,“deltaLpBalance”:“5620008621161397893621”},{“kind”:0,“binId”:“12”,“deltaA”:“0”,“deltaB”:“7816871362841791482353”,“isActive”:true,“lowerTick”:3,“deltaLpBalance”:“6267199717385014159409”},{“kind”:0,“binId”:“13”,“deltaA”:“0”,“deltaB”:“8175839455190166157802”,“isActive”:true,“lowerTick”:4,“deltaLpBalance”:“6855746325458976012452”},{“kind”:0,“binId”:“14”,“deltaA”:“0”,“deltaB”:“8788639204240130431865”,“isActive”:true,“lowerTick”:5,“deltaLpBalance”:“8562443877531051319666”},{“kind”:0,“binId”:“15”,“deltaA”:“0”,“deltaB”:“9376062708266568852029”,“isActive”:true,“lowerTick”:6,“deltaLpBalance”:“9017333797813763959462”}]	2023-11-07T05:45:23.000Z	0xc627fdac65d351aec20470fe729333eb090a4e352bb165257131e186bb583155

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_ethereum.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
0x11a653ddfbb61e0feff5484919f06d9d254bf65f	false	0xbbf1ee38152e9d8e3470dc47947eaa65dca94913	438	1513	17652646	[{“kind”:2,“binId”:“85”,“deltaA”:“272806676583462519154”,“deltaB”:“177841981914699622”,“isActive”:false,“lowerTick”:381,“deltaLpBalance”:“319999680000000008”}]	0xbbf1ee38152e9d8e3470dc47947eaa65dca94913	2023-07-09T00:37:35.000Z	0x6fc2b040a6ef50242206b2e7f24e76e7cc99aaf56d98f9be78dc191afbc420f0
0x6c6fc818b25df89a8ada8da5a43669023bad1f4c	false	0xbbf1ee38152e9d8e3470dc47947eaa65dca94913	238	1550	17658591	[{“kind”:3,“binId”:“26”,“deltaA”:“28534121351765420652444”,“deltaB”:“0”,“isActive”:false,“lowerTick”:-2,“deltaLpBalance”:“15263067867000000000000”}]	0x26f0519442a4a349c22e150f942da4c3d6331803	2023-07-09T20:42:59.000Z	0x06bed68e9abb57cf0989acfd3239ebda200378bda8fe4e3c67ad3cb505eedc6b
0x012245db1919bbb6d727b9ce787c3169f963a898	false	0xbbf1ee38152e9d8e3470dc47947eaa65dca94913	278	1692	17652927	[{“kind”:3,“binId”:“24”,“deltaA”:“4999994000000000000”,“deltaB”:“49318942371285947”,“isActive”:false,“lowerTick”:1506,“deltaLpBalance”:“4999994000000000000”}]	0xbbf1ee38152e9d8e3470dc47947eaa65dca94913	2023-07-09T01:34:59.000Z	0x8786c32f83431568c9756b78cd5258f62b4d754ef6accb5cece8225359466ef7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.maverick_v1_ethereum.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
0xe8d7a52aabe8a0569314f28e90fdb8544860a424	false	0xbbf1ee38152e9d8e3470dc47947eaa65dca94913	164	20243250000	true	17615771	20240843936	0x3e7bfa35d6d76076482ed6b627fe862098a7da15	0	false	2023-07-03T20:20:11.000Z	0x7a7631ec27dd652bd9539ac7eeeff73498a53d680a6e3c4fe4232ac569d3ca6c
0x2df64ac2e8874c43021675ed7a65d3429e30b96b	false	0xbbf1ee38152e9d8e3470dc47947eaa65dca94913	156	874207634035595580344	true	17614507	370179673	0xdd84ce1adcb3a4908db61a1dfa3353c3974c5a2b	3	false	2023-07-03T16:05:23.000Z	0xe4c582813af66ed52aa70f3435d9bb02344e0bfb607b4df715963a8a6a9a7f9a
0x2df64ac2e8874c43021675ed7a65d3429e30b96b	false	0xbbf1ee38152e9d8e3470dc47947eaa65dca94913	367	400000000	false	17612541	893839883904348228899	0xfcfc9d90eb596eb1e17b6905b4748591da87cd4c	3	false	2023-07-03T09:26:47.000Z	0x9d78afa124237db3e2e5da9d8bed104ba77b24072a43d88f1c95127163f12e8e

Example Query

Query with partition filter

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