thena_v2_opbnb

Tables

AlgebraFactory_Pool_event

Pool creation events emitted by Algebra DEX (Decentralized Exchange) factory contracts, recording the deployment of new liquidity pools with their token pair addresses. Used for tracking pool deployments and identifying tradable pairs across Algebra-based DEX implementations.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x9e92b57bff702530a0c3be9ff5fe2c24f95a91f6	0xa7e84de1f48743143223ba17153ea88732490cd2	false	0x7c6b91d9be155a6db01f749217d76ff02a7227f2	0xe7798f023fc62146e8aa1b36da45fb70855a77ea	59	13733213	2024-01-17T10:22:16.000Z	0xa3ee4f41cb74bf02631f55d8fd144145ac9fa0082686259c20e0a9a3e2dad9ca
0x9e92b57bff702530a0c3be9ff5fe2c24f95a91f6	0x2c8d50474decffbae19cb2af02d646897b2b869c	false	0x9e5aac1ba1a2e6aed6b32689dfcf62a509ca96f3	0xe7798f023fc62146e8aa1b36da45fb70855a77ea	80	14177399	2024-01-22T13:45:22.000Z	0x711a582663f00a7cac00444d8b91545d5032db2c98cd5fb4b76f3bf5445a95a7
0x9e92b57bff702530a0c3be9ff5fe2c24f95a91f6	0x14054241589d8b97f8cb5ce753334f9ae93c12a8	false	0x7c6b91d9be155a6db01f749217d76ff02a7227f2	0x9e5aac1ba1a2e6aed6b32689dfcf62a509ca96f3	85	14177320	2024-01-22T13:44:03.000Z	0x474d083c95778fb4fb87d284f6a9f9692a85a316cbaeb87b8567f4ffa4ec9983

Example Query

Query with partition filter

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

AlgebraPool_Burn_event

Liquidity removal events from Algebra-based concentrated liquidity pools. Records owner address, tick range boundaries, withdrawn liquidity amount, and returned token0/token1 quantities for position burning operations.

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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`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_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash
0x55ce9b92f2d0a842e639c354d72f2e85c5382e5f	false	0x09efc1a1837e835c21a73ea8ef7d7330c5bc8692	86	-15490	34278087	-887270	2024-09-11T05:16:50.000Z	0x815a4f59075107f0e825964ae766ada705e11632c0643e361a1505699f20c84b
0x55ce9b92f2d0a842e639c354d72f2e85c5382e5f	false	0x09efc1a1837e835c21a73ea8ef7d7330c5bc8692	85	-13570	34278087	-15490	2024-09-11T05:16:50.000Z	0x815a4f59075107f0e825964ae766ada705e11632c0643e361a1505699f20c84b
0x55ce9b92f2d0a842e639c354d72f2e85c5382e5f	false	0x09efc1a1837e835c21a73ea8ef7d7330c5bc8692	1	-15010	34323738	-15740	2024-09-11T17:57:41.000Z	0xa2b573d87e6d18351f9c4408ae80e5b03dda6a3efb1c75342d414893fd183665

Example Query

Query with partition filter

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

AlgebraPool_Collect_event

Concentrated liquidity position fee collection events from Algebra protocol pools. Records token amounts withdrawn by position owners from specific tick ranges, including owner address, recipient address, and collected quantities of both token0 and token1.

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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`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	in_topTick	block_number	in_recipient	in_bottomTick	block_timestamp	transaction_hash
0x55ce9b92f2d0a842e639c354d72f2e85c5382e5f	false	0x09efc1a1837e835c21a73ea8ef7d7330c5bc8692	5	2597096588507933697	0	887270	69722536	0x09efc1a1837e835c21a73ea8ef7d7330c5bc8692	-15320	2025-07-24T06:58:49.000Z	0x4d4a64ac634a9cae51081db3c058ecb0caedd4634943aac26da9f0ca35411139
0x55ce9b92f2d0a842e639c354d72f2e85c5382e5f	false	0x09efc1a1837e835c21a73ea8ef7d7330c5bc8692	10	161841869867487648	132438899993739974	-15320	69722536	0x09efc1a1837e835c21a73ea8ef7d7330c5bc8692	-16050	2025-07-24T06:58:49.000Z	0x4d4a64ac634a9cae51081db3c058ecb0caedd4634943aac26da9f0ca35411139
0x2c8d50474decffbae19cb2af02d646897b2b869c	false	0x27681cb9c7c834e7e55c009a2760f5121e61edbd	5	47543272444875117989	1176958961366	-80280	69779911	0x27681cb9c7c834e7e55c009a2760f5121e61edbd	-82090	2025-07-24T14:56:57.000Z	0x7c2c02c5fb7d436cb5cc742e3491d4c3afac22b984520c8a6a6c79ba82f0e539

Example Query

Query with partition filter

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

AlgebraPool_CommunityFee_event

Community fee configuration change events from Algebra DEX (Decentralized Exchange) liquidity pools. Records protocol fee adjustments for token0 and token1, used for tracking fee policy changes across pool contracts.

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_communityFee0New`	`STRING`	Updated community fee rate for token0 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%.
`in_communityFee1New`	`STRING`	Updated community fee rate for token1 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x2c8d50474decffbae19cb2af02d646897b2b869c	false	5	14177434	2024-01-22T13:45:57.000Z	0x0dd4b4588c4952819166bfe1b06550ccaef5bf94fd1f9ded44e5fe996767575e
0x14054241589d8b97f8cb5ce753334f9ae93c12a8	false	16	14177353	2024-01-22T13:44:36.000Z	0x94970f46d72e7919ce6c805e9f5c616d88e10aa9d58cd5c750d2f2b161d327c8
0xa7e84de1f48743143223ba17153ea88732490cd2	false	33	13733351	2024-01-17T10:24:34.000Z	0xc597f6bed0c08774f6cb9c92c5010ec0d735e84cfb8b3172b325d6aa57d4626c

Example Query

Query with partition filter

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

AlgebraPool_Fee_event

Fee change events emitted by Algebra-based liquidity pools when the pool’s fee tier is updated. Records the new fee amount in basis points, used for tracking dynamic fee adjustments in concentrated liquidity protocols.

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_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.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
1277	0x14054241589d8b97f8cb5ce753334f9ae93c12a8	false	3	63390453	2025-06-17T15:31:28.000Z	0x38668aa60e660a2a30271189684f0c3f803f19c7762a6dca5765d3ae8bb4ac3d
1277	0x14054241589d8b97f8cb5ce753334f9ae93c12a8	false	18	63390331	2025-06-17T15:30:27.000Z	0x32dc09ef11941ec156705a4631d7ad15a208974515693789e427e32ff119d087
1277	0x14054241589d8b97f8cb5ce753334f9ae93c12a8	false	5	63387696	2025-06-17T15:08:29.000Z	0xf6e0e1f1769fdfdeb39db1cae812395983ca8f14aa427fb76c4c45ab95c189aa

Example Query

Query with partition filter

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

AlgebraPool_Mint_event

Liquidity addition events from Algebra-based concentrated liquidity pools containing sender, owner, token amounts, tick range boundaries, and liquidity units. Used for tracking liquidity provider positions and pool depth changes across Algebra DEX deployments.

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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`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_sender	log_index	in_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x2c8d50474decffbae19cb2af02d646897b2b869c	false	0xa2baca4cf3e9f2901d1be9bdee20a6f93fb34cb4	0xa2baca4cf3e9f2901d1be9bdee20a6f93fb34cb4	33	2426410068968504183	0	887270	56339382	-74660	2025-05-07T20:12:32.000Z	0x02af8e30d90375847497b88de3befae81cb797497d917107de9ef5be2f531249	58052904635513429
0x2c8d50474decffbae19cb2af02d646897b2b869c	false	0xa2baca4cf3e9f2901d1be9bdee20a6f93fb34cb4	0xa2baca4cf3e9f2901d1be9bdee20a6f93fb34cb4	31	6025696571234443469	18970383058990019	-74660	56339382	-76560	2025-05-07T20:12:32.000Z	0x02af8e30d90375847497b88de3befae81cb797497d917107de9ef5be2f531249	10318348262082298219
0x2c8d50474decffbae19cb2af02d646897b2b869c	false	0xa2baca4cf3e9f2901d1be9bdee20a6f93fb34cb4	0xa2baca4cf3e9f2901d1be9bdee20a6f93fb34cb4	22	9138781730612112860	0	-74280	56323169	-74990	2025-05-07T17:57:26.000Z	0x21af339022d98e5cbfe4c0b20e1bbb65ae1636d5984cfc8b1cdd615dd10d6f96	6166822649312374034

Example Query

Query with partition filter

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

AlgebraPool_Swap_event

Swap events from Algebra Protocol concentrated liquidity pools containing sender, recipient, token amounts exchanged, post-swap price and tick, and liquidity depth. Used for DEX trade analysis and liquidity tracking.

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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`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_price	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	transaction_hash
0x55ce9b92f2d0a842e639c354d72f2e85c5382e5f	-17183	false	33556574787157855505487220664	0x000000000000c6399510f47ef7691db4db17ae8a	3	41928370880486119	-7519947489539918	73351425	15478878620079782830	0x000000000000c6399510f47ef7691db4db17ae8a	2025-08-14T06:59:34.000Z	0x0223124c46701cd8ae282deab96ff8a47d4242c71c67ee3f5091d8dd46a27eca
0x55ce9b92f2d0a842e639c354d72f2e85c5382e5f	-17152	false	33609360092623770774868461118	0x000000000000c6399510f47ef7691db4db17ae8a	3	45856210085358215	-8250905846498543	73348958	15478878620079782830	0x000000000000c6399510f47ef7691db4db17ae8a	2025-08-14T06:39:00.000Z	0xa52bc594fb300c87a106e5b0030752f094a44eb4b88d9d720a62c63e6921b379
0xdc83c475dab357b6c3cd66e1a16cfdab08992560	67263	false	2287772567061244729865705590687	0x000000000000c6399510f47ef7691db4db17ae8a	3	15490269984416249	-12941772587580404571	73449942	6179788124294190141	0x000000000000c6399510f47ef7691db4db17ae8a	2025-08-14T20:40:32.000Z	0xedc6fb55a7723c3298bdaed9af00e8acb3a9d7928cf564fdf42cace5540462e9

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AlgebraFactory_Pool_event

AlgebraPool_Burn_event

AlgebraPool_Collect_event

AlgebraPool_CommunityFee_event

AlgebraPool_Fee_event

AlgebraPool_Mint_event

AlgebraPool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AlgebraFactory_Pool_event

​AlgebraPool_Burn_event

​AlgebraPool_Collect_event

​AlgebraPool_CommunityFee_event

​AlgebraPool_Fee_event

​AlgebraPool_Mint_event

​AlgebraPool_Swap_event

Tables

AlgebraFactory_Pool_event

AlgebraPool_Burn_event

AlgebraPool_Collect_event

AlgebraPool_CommunityFee_event

AlgebraPool_Fee_event

AlgebraPool_Mint_event

AlgebraPool_Swap_event