thena_v3_bsc

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
0x306f06c147f064a010530292a1eb6737c3e378e4	0xb57f746daed4202fb2774d082522e439cca94f03	false	0xafbe3b8b0939a5538de32f7752a78e08c8492295	0xf4c8e32eadec4bfe97e0f595add0f4450a863a11	181	36435411	2024-02-25T04:58:14.000Z	0x8d2ed54683f3188d39129ad1dbfe09183c1bc9d71d975ae25bd84515e999dcb6
0x306f06c147f064a010530292a1eb6737c3e378e4	0x733a0b28e4d7f2cb421730c4e4e26f2adce3d240	false	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	0x64048a7eecf3a2f1ba9e144aac3d7db6e58f555e	433	28058652	2023-05-09T11:53:32.000Z	0xbbeb49630c6c1325f4c68d765248e1c0e4388a9e3de3c49b84c3070d04b7f907
0x306f06c147f064a010530292a1eb6737c3e378e4	0xbff0a89c458ec68854fc0ff36793b51db1d07c05	false	0x55d398326f99059ff775485246999027b3197955	0x6985884c4392d348587b19cb9eaaf157f13271cd	56	39814443	2024-06-21T19:40:13.000Z	0x1ca4ee922067b868549378210c1ee61d2e0d51238a821d8a738ccce5d241f3f2

Example Query

Query with partition filter

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

AlgebraFactoryV2_CustomPool_event

Custom liquidity pool deployment events from Thena V3 (Algebra-based) DEX on BNB Smart Chain. Tracks pool creation with token pair addresses, deployer addresses, and pool contract addresses for monitoring new trading pair launches.

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_deployer`	`STRING`	Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string.
`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	in_deployer	block_number	block_timestamp	transaction_hash
0x30055f87716d3dfd0e5198c27024481099fb4a98	0x070cec06718ac590ba325ade0dfadd19bf5a1349	false	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0x8dedf84656fa932157e27c060d8613824e7979e3	540	0xf807462b5ce54a89e2f5b847d8281030eafe241b	61456551	2025-09-17T06:40:24.000Z	0x637902a08765dc68b86bebbd0acf5495d9aa3d0ff13d66a1126f347894497ed1
0x30055f87716d3dfd0e5198c27024481099fb4a98	0x72fb92b9945a7cc24c0758ad9764c59e827b5b67	false	0x18ea4df6a9cde2472f2321a4ec77da106498a66e	0xf4c8e32eadec4bfe97e0f595add0f4450a863a11	2	0xf807462b5ce54a89e2f5b847d8281030eafe241b	57769224	2025-08-16T06:17:23.000Z	0xd2e4e7c51295df64ff179dbc4184a3bd06262aad3f5736bb322083a948695caf
0x30055f87716d3dfd0e5198c27024481099fb4a98	0xba33814784f190063686abdbb46e3f9ab7628472	false	0x0df0587216a4a1bb7d5082fdc491d93d2dd4b413	0xf5d8a096cccb31b9d7bce5afe812be23e3d4690d	63	0xf807462b5ce54a89e2f5b847d8281030eafe241b	54710574	2025-07-20T17:00:49.000Z	0x27a5c4a09c7997bab9845cc5683d9e5bc4250902a500eb20163a0ede3f6cbf1c

Example Query

Query with partition filter

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

AlgebraFactoryV2_Pool_event

Pool creation events from Thena V3 (Algebra-based) decentralized exchange factory contract on BNB Smart Chain. Tracks new liquidity pool deployments with token pair addresses for analyzing protocol growth and market coverage.

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
0x30055f87716d3dfd0e5198c27024481099fb4a98	0x5b090adf404dba1cf71cd8ca4a56a08a231ed363	false	0x7b4bf9feccff207ef2cb7101ceb15b8516021acd	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	2	50404602	2025-05-27T12:54:46.000Z	0x0da41526979f56dcde551f7934a4a47c64bf9aee2002791c3e9c99cfb2516c58
0x30055f87716d3dfd0e5198c27024481099fb4a98	0x0971fe76c5bebc1f14ab1ad8d2f293e3d0e70086	false	0xb994882a1b9bd98a71dd6ea5f61577c42848b0e8	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	2	50396616	2025-05-27T09:34:46.000Z	0x511eaea7b898b217eec0705954ea1d7765c461f99e956ed6460ecc9607e2e9f8
0x30055f87716d3dfd0e5198c27024481099fb4a98	0x8b293f31a04beb4bef06e4e9a64d90f051c416a6	false	0x5bff88ca1442c2496f7e475e9e7786383bc070c0	0x80eede496655fb9047dd39d9f418d5483ed600df	5	50411791	2025-05-27T15:54:32.000Z	0xc57d698d1c310880bfadcc22ea6c3bea69fa0e02a5a0695a7984bff0f028cb49

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraFactoryV2_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_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0xab3790c5fab8aff0a41640eb2c7b280289c657e5	false	0xbed76f58edd506a0080b413ca45b2da29b8e638a	325	1395809963	11310294612126109661	216540	36573761	215760	2024-03-01T00:31:15.000Z	0xe65c945a7180e3ffe10c9212878dfd67fd649a00c862e60ea01859aa205b0eb5	7695223398317033
0xab3790c5fab8aff0a41640eb2c7b280289c657e5	false	0xbed76f58edd506a0080b413ca45b2da29b8e638a	329	10571167723	23967097140318757401	220680	36573761	212460	2024-03-01T00:31:15.000Z	0xe65c945a7180e3ffe10c9212878dfd67fd649a00c862e60ea01859aa205b0eb5	2713389188662039
0xd405b976ac01023c9064024880999fc450a8668b	false	0xdaa7d60733577453481ed790330617384b876613	85	897096837950761269039	1985160261199603159	-56460	36576458	-63240	2024-03-01T02:46:18.000Z	0x87996004e0ed22631b623e0db423b280e16f578ba7aa32d67071aba8d919aca1	271152625053613951346

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v3_bsc.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
0xd405b976ac01023c9064024880999fc450a8668b	false	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	725	199561211106232599153	3275696445607198288	-70140	65299811	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	-70860	2025-10-20T15:53:55.000Z	0x494d63c037ac9a773712b22ff6104ca6fbf5430f8e4376c6f5185a4b280baee4
0xd405b976ac01023c9064024880999fc450a8668b	false	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	720	220512020752237592241	2369707322692	887220	65299811	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	-70140	2025-10-20T15:53:55.000Z	0x494d63c037ac9a773712b22ff6104ca6fbf5430f8e4376c6f5185a4b280baee4
0xd405b976ac01023c9064024880999fc450a8668b	false	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	1085	1409120772440012	2599522025322746243	-70380	65264289	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	-887220	2025-10-20T08:29:46.000Z	0x63a0c160f696f2639a6b088635b06cc0f65594e49b344de9c8c7bb6aeeaba755

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v3_bsc.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	in_communityFee0New	in_communityFee1New
0x3401cf94c6f81347b426df1d0f6269b7a24feb2e	false	97	29844481	2023-07-10T15:38:28.000Z	0x9ae0fd1a8152ccb3510927eb09d53769a0c82002fa1e79f0cd8544b1429cd794	0	0
0xb48fdf4d9897973f677f8c5e5d12280f6074d310	false	241	29844840	2023-07-10T15:56:28.000Z	0xe9dab6865cfd977bfb2321c5c2333dd7d9326edc2648fdd12ca028840c1e4d02	30	30
0x70efad801f5e254a0a650fec28f814ed9e3c98f5	false	247	29844816	2023-07-10T15:55:16.000Z	0x35ebf6a19cd43ffc58fc6eee3efe6f23b161dc00f101d5572e67585e70a91576	30	30

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v3_bsc.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
6287	0x011077b8199cab999e895aed7f8a78755a678106	false	742	35987213	2024-02-09T14:44:36.000Z	0x30781be362132a30a4a20ae1448039c0ed455b97e584078cace5f70f94b1e0f7
6299	0x011077b8199cab999e895aed7f8a78755a678106	false	315	35980176	2024-02-09T08:52:14.000Z	0x8c44e7067c4e0549dd6fc32f63a954106183941be52e62dd90507d199a06285a
6299	0x011077b8199cab999e895aed7f8a78755a678106	false	266	35982206	2024-02-09T10:34:05.000Z	0xc6d7943e9d878649753ccfa4890a71e15ea1e06dde9108cd3e608a8a33de513d

Example Query

Query with partition filter

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

AlgebraPool_Flash_event

Flash loan events from Thena V3 Algebra-based liquidity pools on BNB Smart Chain, recording borrowed amounts (amount0/amount1) and repayment fees (paid0/paid1) for arbitrage and liquidation analysis.

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_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_paid0	in_paid1	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x1b9a1120a17617d8ec4dc80b921a9a1c50caef7d	false	26504716012621643710	0	0x59145855a30c473f2c8936584d55143e49ec1da5	61	2650471601262164370960839	0	30043561	0x59145855a30c473f2c8936584d55143e49ec1da5	2023-07-17T13:59:40.000Z	0x1ad93cc27e39fd176cfa0f9fc7c4d46a260853bdf510a2226996c0c70992b0b3
0xc8cbf9b12552c0b85fc368aa530cc31e00526e2f	false	0	85303500063513317953893	0xc40119c7269a5fa813d878bf83d14e3462fc8fde	225	0	30751081493696221324402444	29185769	0xd2094b870d80cfb7dada4893ad0030d642ca9f72	2023-06-17T17:01:43.000Z	0x4a304ff08851106691f626045b0f55d403e3a0958363bdf82b96e8ce7209c3a6
0x5b0baf66718caabda49a4af32eb455c3b99b5821	false	200000000000000	0	0xf0796b0a1f7f5fc1f09e5473b88eec0b85b14725	67	2000000000000000000	0	35909630	0xf0796b0a1f7f5fc1f09e5473b88eec0b85b14725	2024-02-06T21:58:56.000Z	0x9697166593bdecf4d0263f789ee252dd72a7c715e9b6098c37cc3cf55ef8f079

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPool_Flash_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
0x01e0d483ac9e04c443ad1b82f0e967813962d568	false	0xfd91d0bced526771ade0ccdee53f4f17b22551cc	0xfd91d0bced526771ade0ccdee53f4f17b22551cc	249	952286100330153595590597991	32761332263866298735	-160800	43537403	-170100	2024-10-29T08:56:18.000Z	0xae7dffde277f50a435b41f8571a27fe73f4ea15190cbd252b5863be15ca23524	886567631856869412265032
0x01e0d483ac9e04c443ad1b82f0e967813962d568	false	0xfd91d0bced526771ade0ccdee53f4f17b22551cc	0xfd91d0bced526771ade0ccdee53f4f17b22551cc	251	325346425230600593462760685	0	-165000	43537403	-166740	2024-10-29T08:56:18.000Z	0xae7dffde277f50a435b41f8571a27fe73f4ea15190cbd252b5863be15ca23524	935557211047593151618630
0x1123e75b71019962cd4d21b0f3018a6412edb63c	false	0x10bf6e7b28b1cffb1c047d7f815953931e5ee947	0x10bf6e7b28b1cffb1c047d7f815953931e5ee947	18	3847772176721786874	22907906285126810010	15240	43542318	13860	2024-10-29T13:02:03.000Z	0x49e311a5bfda53f80dca6c0e61b3c9167a89e2a4cd3b6dca23677447cf7b731e	280495328820891352547

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v3_bsc.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
0xf6814792050ccd1c603d8a95468d6d9587ecbdaf	-64020	false	3226877801004988143950392724	0x0000000000016a723d0d576df7dc79ec149ac760	104	33069794956602223727486	-55041171997864435077	34232994	197755655391208188892984	0x0000000000016a723d0d576df7dc79ec149ac760	2023-12-10T13:14:01.000Z	0x9629fe93b8e45c314b2dc1ba94b4a27cc53fb956e3cd88aa00c8a6771ae44cb9
0xf6814792050ccd1c603d8a95468d6d9587ecbdaf	-63989	false	3231860011208729558521034226	0x0000000000016a723d0d576df7dc79ec149ac760	11	-33069794956602223727486	54844414999999995904	34232994	197755655391208188892984	0x0000000000016a723d0d576df7dc79ec149ac760	2023-12-10T13:14:01.000Z	0xfffd3dbd949578229fe3a26af2486493f0466ae5d5fb132f1fbb338ba0671ff4
0xf6814792050ccd1c603d8a95468d6d9587ecbdaf	-63977	false	3233878462401815111433405892	0x000000000003a3c2878a1df56a486c9683220456	513	-657487950172072636529	1099082250779224558	34228794	197755655391208188892984	0x000000000003a3c2878a1df56a486c9683220456	2023-12-10T09:43:40.000Z	0x7a120ee9e76e1008cea92249819b05d700e2e8ab99f0796edb80dbdfe3ee970b

Example Query

Query with partition filter

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

AlgebraPoolV2_Burn_event

Liquidity removal events from Thena V3 (Algebra-based) automated market maker pools on BNB Smart Chain. Tracks position burns with withdrawn token amounts, tick ranges, and liquidity deltas for analyzing LP activity and pool depth changes.

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.
`in_pluginFee`	`STRING`	Fee charged by the plugin module on the liquidity pool operation. Numeric string representation in smallest denomination.

Sample Data

address	removed	in_owner	log_index	in_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x90a420de9894f48ecb05a50ef67aaa89a9049e16	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	148	0	999999999999999999	-78300	54273468	-79080	2025-07-16T21:56:18.000Z	0x2f63641dec661485bcd7a5d44679e917c18306fcfafab95ca0791df014bcf01e	1310918808691582790690
0xca1574c79735182db0468daa2751b7ec5549c609	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	312	0	86348280199528007745	73200	54222847	69180	2025-07-16T11:23:23.000Z	0x89d20c615d371a8e1bca8550211dee51bd0c5e3ff9c53c0c61ff01ad9114a1a0	12205474484666651691
0xca1574c79735182db0468daa2751b7ec5549c609	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	285	307785644576270832	0	80640	54258144	76980	2025-07-16T18:44:43.000Z	0x182139581a9b62c627e44190ef41be00ab12319d05962ecc8a72d54bbb9822ef	86390314460735348963

Example Query

Query with partition filter

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

AlgebraPoolV2_Collect_event

Fee collection events from Thena v3 concentrated liquidity pools on BNB Smart Chain using Algebra protocol. Records liquidity provider withdrawals of accumulated token0 and token1 fees within specified tick ranges.

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
0x1796b29414933826149b5b51f1a99d0d3bd0f4f6	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	146	985956544427068	35494356628948	887220	49358607	0x993ae2b514677c7ac52baecd8871d2b362a9d693	-887220	2025-05-09T08:58:07.000Z	0x26b5b83390fd93e5285836d5aee0aabb099979cdcb3ed9e52bdd683a165944f2
0x2c950a64b03565eaeddb6c33d8f8c749aa3b89bf	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	76	3234588750	0	887220	49358612	0x993ae2b514677c7ac52baecd8871d2b362a9d693	-887220	2025-05-09T08:58:14.000Z	0xc36042aa8359b933d39cf42079506900b2369cb430bfbb1255fa4b44a5c6bd0e
0x27a3b3d61830efe5ca13ad59dc8efaa73833d691	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	99	16745635665937	5270022009917	60	49358596	0x993ae2b514677c7ac52baecd8871d2b362a9d693	-60	2025-05-09T08:57:50.000Z	0x36d9909496fc00acc58a255dbbf987d78230a47d02b7e129fec6361fff723292

Example Query

Query with partition filter

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

AlgebraPoolV2_CommunityFee_event

Community fee parameter changes for Thena V3 liquidity pools on BNB Smart Chain using Algebra protocol. Tracks fee adjustments at the pool level with typical values of 125 and 1000 basis points for protocol revenue allocation.

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_communityFeeNew`	`STRING`	New community fee rate for the Thena Algebra V3 pool, expressed in basis points. Common values include 125 (1.25%) and 1000 (10%), representing the protocol’s fee share allocation.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_communityFeeNew
0x5c00011065740c8f8a1da551741e9dc679b84570	false	434	56512453	2025-08-05T08:26:24.000Z	0xe0788448a695c4e47aaf042bd3713cd95aec8b0367eae1218e4a562cc6672cd9	1000
0x5c00011065740c8f8a1da551741e9dc679b84570	false	436	56512453	2025-08-05T08:26:24.000Z	0xe0788448a695c4e47aaf042bd3713cd95aec8b0367eae1218e4a562cc6672cd9	125
0xb641cccda9faa3e9ccf1b4c63a85982bd86e644c	false	66	57731790	2025-08-15T22:29:25.000Z	0x3095060f6234a1a11d191c37a1b861e9ba7c5358137d5da8f8335995d0de84a9	125

Example Query

Query with partition filter

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

AlgebraPoolV2_Fee_event

Fee tier update events from Thena V3 Algebra-based liquidity pools on BNB Smart Chain. Captures dynamic fee adjustments (measured in basis points) for analyzing fee tier changes and pool economics across DEX (decentralized exchange) trading pairs.

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
3409	0x03bdad39d368b1eccdd0a613c87e5e64cbebf2de	false	10	52411597	2025-06-30T18:01:22.000Z	0xdb48ad3936b0979bfa479778032c0886be9c206b99990a9cb66a07a517fa0e16
3411	0x03bdad39d368b1eccdd0a613c87e5e64cbebf2de	false	183	52423329	2025-06-30T20:28:01.000Z	0xa86506fe1bb4f5eef81ad4e1b61ff2454164b98e30ed5d2140055eb40c0dfb1e
3411	0x03bdad39d368b1eccdd0a613c87e5e64cbebf2de	false	1424	52392305	2025-06-30T14:00:13.000Z	0x24d5de3a70a8435f63ca00701e4d663bfba7293bcdd418323edefd7c4ec95497

Example Query

Query with partition filter

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

AlgebraPoolV2_Mint_event

Liquidity provision events from Thena V3 Algebra pools on BSC, capturing mints with tick ranges, token amounts, and liquidity changes. Used to analyze concentrated liquidity positions and liquidity provider behavior across AMM pools.

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
0x03bdad39d368b1eccdd0a613c87e5e64cbebf2de	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	584	55056077994204954967	83024787064052506	-52080	50211961	-58320	2025-05-24T04:36:59.000Z	0xe3db0d47a60ef27ac1814c1737669ea59d5fc180b2b447516837d7cbd4438c6a	16355363382808127836
0xa4f0ecc42df9a82db3bfc645f4b5a80a6bb56e24	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	10	965686402380476569561	1212049554930432814	-52020	50233560	-56040	2025-05-24T13:37:06.000Z	0x66e218e469c3ee65c25b74b442d2327653cce60fbcee98b342f2c948df3a38e7	426684323767792088666
0xa4f0ecc42df9a82db3bfc645f4b5a80a6bb56e24	false	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	0x643b68bf3f855b8475c0a700b6d1020bfc21d02e	198	271024945285934284171	181579848641903934	-52560	50252986	-55620	2025-05-24T21:42:49.000Z	0xc5bd6b83256d6dd4351451e790568af1b518355a77ae94deb550daa69eb4c594	138642274718653018782

Example Query

Query with partition filter

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

AlgebraPoolV2_Swap_event

Swap events from Thena V3 (Algebra protocol fork) liquidity pools on BNB Smart Chain, capturing token exchange amounts, execution price, tick position, and fee parameters. Used for analyzing DEX trading volume, price impact, and liquidity utilization across concentrated liquidity positions.

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.
`in_overrideFee`	`STRING`	Custom fee override value in basis points applied to this specific swap transaction. Typically ranges from 500-1000 (0.5%-1.0%), allowing dynamic fee adjustments per swap on Thena’s Algebra-based pools.
`in_pluginFee`	`STRING`	Fee charged by the plugin module on the liquidity pool operation. Numeric string representation in smallest denomination.

Sample Data

address	in_tick	removed	in_price	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	in_overrideFee	block_timestamp	transaction_hash
0x9ea0f51fd2133d995cf00229bc523737415ad318	-63228	false	3357308239540069675164260446	0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c	1356	-3462153841720315259	6191275596608590	48127217	28631658705017199911	0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c	990	2025-04-06T18:17:52.000Z	0xb9b9639b5680dbc3c02490c53655247b4517d9c376167f8402f0a0652ed3742d
0x9ea0f51fd2133d995cf00229bc523737415ad318	-63330	false	3340192997421820119649725577	0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c	638	-2909641366185801592	5154632209929677	48127134	28631658705017199911	0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c	990	2025-04-06T18:13:43.000Z	0x3be7311aba9d043cdcb226659c3382eb87448d0498995cc62df7347678961872
0x9ea0f51fd2133d995cf00229bc523737415ad318	-63261	false	3351690157988668056871237897	0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c	1764	1133763413613577322	-2030430671036716	48127515	28635235871772899919	0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c	990	2025-04-06T18:32:46.000Z	0x50ed54d9804a39c262208382e20d014488268bba64c0db56542cd9031a20f977

Example Query

Query with partition filter

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

Gauge_Harvest_event

Harvest event records from Thena V3 gauge contracts on BNB Smart Chain, capturing reward claims by liquidity providers with user addresses and reward amounts. Used for analyzing gauge incentive distribution patterns and LP reward claiming behavior.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xe2c96a636c64322d444c58de20e599b3ce9c6116	0x0231487c02af8a878ac03382a839dce84d80aa76	false	311063187672212451626	271	36646128	2024-03-03T12:55:29.000Z	0xd1fd6ec66ecda566ed0d5aefd6b1e914fa65a88f2bb32b94fab2fe02769cd00f
0xd777e84b0d29128351a35045d7ae728780def54d	0x03762abbf8c766663a643aa3e6548e35524c2f9e	false	350580423689427935993	126	36649586	2024-03-03T15:48:51.000Z	0x90f91fe2f2bccb5c16444de42c7728234bcb89cb4b2ef874a1cc9864f992142b
0xd777e84b0d29128351a35045d7ae728780def54d	0x03762abbf8c766663a643aa3e6548e35524c2f9e	false	316730583084436291761	254	36657979	2024-03-03T22:49:00.000Z	0xc8fbe9c00d734745408a51dd71b1851dbf1803f551dc53c3d73b399bcdf8910c

Example Query

Query with partition filter

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

GaugeFactoryV2_CreateGauge_event

Gauge creation events from Thena V3 decentralized exchange on BNB Smart Chain, recording when new liquidity mining gauges are deployed with their associated strategy contracts. Used for tracking gauge deployment activity and analyzing Thena’s incentive structure expansion.

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_strategy`	`STRING`	Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_gauge	log_index	in_strategy	block_number	block_timestamp	transaction_hash
0x479ce658dd4195556c60ea9fde92cf0f42ea8692	false	0x0c59f754977a3a170f3df68682f05200c26b2036	39	0xbd227b908697225e516a1110f81aa87b59960e5b	50476979	2025-05-28T19:06:08.000Z	0xd377e6e8e55a580beb0d56338e68bcae4b3eb4e4d19dd5bd444fe2d06f85c5a2
0x479ce658dd4195556c60ea9fde92cf0f42ea8692	false	0xfe7406dc5acd57612934c5451f2ef920eb0a17b9	29	0x4b5eae4fbcf8df12b408dca84f0ecda5b940db70	50477145	2025-05-28T19:10:17.000Z	0x951601cbbd6874e3fd9be7b3972ef786faa05cb6af99d357e46aaafce8c7561a
0x479ce658dd4195556c60ea9fde92cf0f42ea8692	false	0x2f5f85d1b709bf732becdda41a00b3965ff9c1b3	28	0x02dbbc330e6b71b822f3787142b6c5199dfa1cef	50446743	2025-05-28T06:29:02.000Z	0x34f3c33ad6750585770c65275783040c367414714e7163a5ec13b16507ef0978

Example Query

Query with partition filter

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

GaugeV2_Harvest_event

Reward claim events from Thena v3 liquidity mining gauges on BNB Smart Chain, capturing when users harvest tokens from staking positions. Records user addresses, reward token amounts, and gauge contract addresses for tracking incentive distributions and farming activity.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_token	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xb53d64d4af104e00b781b8280127339e134f3b0f	0x04e0e61845b0fdd58fc49591534bffaf26b5bd2e	false	0xf4c8e32eadec4bfe97e0f595add0f4450a863a11	1914478040140835594505	489	60681101	2025-09-10T13:03:22.000Z	0x62141cf0edc320de3293225ab96620bcdce2101819e037bdfda1421a225551b4
0x96a658dcea13c6c8e09bd8174c7a74b2211c7a07	0x14a0567b9096e08ac7d7440ee5ce6e8c4ae7fd4f	false	0xf4c8e32eadec4bfe97e0f595add0f4450a863a11	15947597996366696196	764	60674421	2025-09-10T11:39:52.000Z	0x7f5ca09cf5156b93f681a860ec178ae70a7e9a8631c5e19590068984e00148c2
0x6b01c724ebb8fca2683e6c0e9fd2c0ed339e725b	0x16ce1b15ed1278921d7cae34bf60a81227cfc295	false	0xf4c8e32eadec4bfe97e0f595add0f4450a863a11	326566258544554658511	297	60723381	2025-09-10T21:51:57.000Z	0xecea20d973df6b855bceb63e2b68e0807ae3a849d32cd6aba9ed0193c223ca30

Example Query

Query with partition filter

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

ReferralRewards_Claim_event

Referral reward claim events from Thena V3 DEX (decentralized exchange) on BNB Smart Chain, recording token payouts to referrers with user address, token contract, and claim amount. Used to analyze referral program economics and reward distribution patterns across different tokens.

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__user`	`STRING`	Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__token`	`STRING`	Contract address of the token. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in__to	address	removed	in__user	in__token	log_index	in__amount	block_number	block_timestamp	transaction_hash
0x637b935cba030aeb876eae07aa7ff637166de4d6	0x664ce330511653cb2744b8ed50dba31c6c4c08ca	false	0x637b935cba030aeb876eae07aa7ff637166de4d6	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	212	143885934550075445860	26570619	2023-03-18T11:48:24.000Z	0x0f26c236d9e0e35d7199de94beb65d1fab3e12b31475b58699485fd838e53fb9
0x06f9e5f8f5c170b9eece58676d932bcc398f52e5	0x664ce330511653cb2744b8ed50dba31c6c4c08ca	false	0x06f9e5f8f5c170b9eece58676d932bcc398f52e5	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	78	1187333175859420	27979504	2023-05-06T17:50:09.000Z	0xb2fb1b69a5f93ea7e1cde275182851e90c94f162bbe636fd9cd52738166ad8cc
0xf91328ec49725c8bcef2df037ee76ab0b1fc5cb5	0x664ce330511653cb2744b8ed50dba31c6c4c08ca	false	0xf91328ec49725c8bcef2df037ee76ab0b1fc5cb5	0xfa4ba88cf97e282c505bea095297786c16070129	304	5740300564379301799	29469014	2023-06-27T13:44:57.000Z	0x5a14afeeb824c4f2f25831aa76f3c37886d47352738506dde921b08160f0805a

Example Query

Query with partition filter

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

Voter_Vote_event

Voting actions from Thena V3 decentralized exchange (DEX) on BNB Smart Chain, capturing when veNFT token holders cast votes using their tokenIds. Used for analyzing governance participation and vote-escrowed token (veToken) holder behavior in liquidity gauge voting.

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_voter`	`STRING`	Address of the account casting the vote or participating in governance. 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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	in_voter	log_index	in_tokenId	block_number	in_timestamp	block_timestamp	transaction_hash
0x8fbb1ecebb9e9839bc0de00b9c4c585cabdd0462	false	0x19f30627d73de2bbc3b993e8c070bf9d8f37e433	196	18357	52440294	1750896000	2025-07-01T00:00:05.000Z	0x1ad2743a2babdd6584853a8cbaa972285b502f879ef134293f5319e5d4a3a5d1
0x8fbb1ecebb9e9839bc0de00b9c4c585cabdd0462	false	0x43949c0660ac8252575303e22849ca7211c8e824	187	11940	52440294	1750896000	2025-07-01T00:00:05.000Z	0x1ad2743a2babdd6584853a8cbaa972285b502f879ef134293f5319e5d4a3a5d1
0x8fbb1ecebb9e9839bc0de00b9c4c585cabdd0462	false	0xb55e8288309789d5f3158600f1ae0d549508b7c4	171	20604	52440294	1750896000	2025-07-01T00:00:05.000Z	0xe1569854adcafe3716be6942af6dab13d74354357543c3881a4472cd36bd9db9

Example Query

Query with partition filter

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

VoterV3_GaugeCreated_event

Gauge creation events from Thena V3 DEX (decentralized exchange) on BNB Smart Chain, recording when new liquidity pool gauges are deployed with associated internal and external bribe contracts. Used for tracking the expansion of Thena’s vote-escrowed tokenomics system and analyzing incentive structures across pools.

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_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_internal_bribe`	`STRING`	Contract address of the internal bribe contract associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
`in_external_bribe`	`STRING`	Contract address of the external bribe contract associated with the gauge. 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_gauge	log_index	in_creator	block_number	block_timestamp	transaction_hash	in_external_bribe	in_internal_bribe
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	0xf937145b516cff1ea501cf1210832a5b7ea42c3a	false	0x9632caa7800427b582e66f0784a00e4156a430cd	193	0x993ae2b514677c7ac52baecd8871d2b362a9d693	28089722	2023-05-10T13:49:06.000Z	0x00baf462724a74bbd39b9da7780e173fb0effe2e8ff119829895c0b8870fb342	0x6343ef6495b6f6b9c624076f09d23e67b19c1976	0x8af4e70dd6d481f57c5776b82288f06d2b81f31a
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	0xb33d77159ea381176ab1eb11475fd65912d83728	false	0x62c4527398f92f798f8d8bb5cdd176239761db95	66	0xb7ee483080b3b1a82e24b3c80d94c5c1f536fdb7	28093115	2023-05-10T16:38:47.000Z	0x38a0137a52e41045802050750c4071061fd908d0b313561e0e1ea65c262ed080	0xe05205f4affce5c5b7b81241adc4b1e6fb1ec90b	0xb454b8628ea2e701366ff97952122a7808cd3b9f
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	0x1d6c1de20424831fd6f843f1d39bf96265b3899d	false	0xab75b2d521e698794a85ec92cb34c771d8f48c5f	43	0xb7ee483080b3b1a82e24b3c80d94c5c1f536fdb7	28093241	2023-05-10T16:45:05.000Z	0x4cc3f4f840cd40b2ea83dc380f6455a9a3014b2c99a54dd2ed823425da5bd6bc	0x39693783992446fa818ff8284df4eb1bf8c713d4	0xe3c19d7586d8c073831942233e8e62d85ea3cb2e

Example Query

Query with partition filter

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

VotingIncentives_RewardPaid_event

Voting incentive reward distributions from Thena V3 DEX (Decentralized Exchange) on BNB Smart Chain, recording individual user reward claims with token addresses and amounts. Useful for analyzing voter incentive programs, reward token distributions, and governance participation patterns.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardsToken`	`STRING`	Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	in_rewardsToken	transaction_hash
0x04e5cd31cda647cf897935e8704d2f933402b6fa	0x9675fecd8b2ed8e7cae2880ef300a2122dcfffe7	false	4119456586965168	599	56245254	2025-08-03T00:46:12.000Z	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x7ce6435ed6d658f2bba5c98c868da2ca6dcc8d90c653613e5fd99486f609c2a1
0x04e5cd31cda647cf897935e8704d2f933402b6fa	0x9675fecd8b2ed8e7cae2880ef300a2122dcfffe7	false	961042352475339	597	56245254	2025-08-03T00:46:12.000Z	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x7ce6435ed6d658f2bba5c98c868da2ca6dcc8d90c653613e5fd99486f609c2a1
0xdc64daef04f95978f63ad3d8855c2b154cf14054	0xe9f6b6bb8ca582e0e5dcbb03e95b247843fdcf2f	false	71755766130425	292	56245546	2025-08-03T00:49:51.000Z	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x4258b5431adf5ff3c419610e536e585750fa94210f54f47929ea7c74a41a6d27

Example Query

Query with partition filter

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

VotingIncentivesFactory_CreateVotingIncentives_event

Factory deployment events for voting incentive contracts on Thena v3 DEX (BSC), linking gauge addresses to their corresponding incentive contract addresses. Used to track the creation of incentive mechanisms for liquidity pool governance voting.

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_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_votingIncentives`	`STRING`	Contract address of the voting incentives contract created by this factory event. Links to the specific incentive distribution contract associated with the gauge in the Thena v3 protocol on BSC.

Sample Data

address	removed	in_gauge	log_index	block_number	block_timestamp	transaction_hash	in_votingIncentives
0x82f144accf4779ca8c49928be28fac5fa157d218	false	0x4b8ee910bdc98f5b48ba13c7635ca3a69d064055	132	55661861	2025-07-28T23:13:00.000Z	0x255d26ecbece5432350812c189c92170783a31d14b262f01b2a6e9586fa709ce	0x2107d6efc387c502972d3136e397ce1fd6c2aed4
0x82f144accf4779ca8c49928be28fac5fa157d218	false	0xc3c8816b73b0f51c1fad934dfa633e7052a09ac6	352	54180242	2025-07-16T02:30:47.000Z	0x26091729dee60b785f2a21e3098c5299ec7c31e3f42fdb791f26abd15e8e3134	0x6caf50a5f1132f496a2d1ef917a60408726eab82
0x82f144accf4779ca8c49928be28fac5fa157d218	false	0x3e3ef982a6662c7ab94e4d086a0ed8c652bdaa2c	349	52828999	2025-07-04T08:59:12.000Z	0x5fe2754fe2adaa93af2cfc00175dcbdfc3b6a0fb087225708970dd255d3a6190	0xe7fd074d0259aa0b790a6809f07c4ba976f5ae09

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AlgebraFactory_Pool_event

AlgebraFactoryV2_CustomPool_event

AlgebraFactoryV2_Pool_event

AlgebraPool_Burn_event

AlgebraPool_Collect_event

AlgebraPool_CommunityFee_event

AlgebraPool_Fee_event

AlgebraPool_Flash_event

AlgebraPool_Mint_event

AlgebraPool_Swap_event

AlgebraPoolV2_Burn_event

AlgebraPoolV2_Collect_event

AlgebraPoolV2_CommunityFee_event

AlgebraPoolV2_Fee_event

AlgebraPoolV2_Mint_event

AlgebraPoolV2_Swap_event

Gauge_Harvest_event

GaugeFactoryV2_CreateGauge_event

GaugeV2_Harvest_event

ReferralRewards_Claim_event

Voter_Vote_event

VoterV3_GaugeCreated_event

VotingIncentives_RewardPaid_event

VotingIncentivesFactory_CreateVotingIncentives_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AlgebraFactory_Pool_event

​AlgebraFactoryV2_CustomPool_event

​AlgebraFactoryV2_Pool_event

​AlgebraPool_Burn_event

​AlgebraPool_Collect_event

​AlgebraPool_CommunityFee_event

​AlgebraPool_Fee_event

​AlgebraPool_Flash_event

​AlgebraPool_Mint_event

​AlgebraPool_Swap_event

​AlgebraPoolV2_Burn_event

​AlgebraPoolV2_Collect_event

​AlgebraPoolV2_CommunityFee_event

​AlgebraPoolV2_Fee_event

​AlgebraPoolV2_Mint_event

​AlgebraPoolV2_Swap_event

​Gauge_Harvest_event

​GaugeFactoryV2_CreateGauge_event

​GaugeV2_Harvest_event

​ReferralRewards_Claim_event

​Voter_Vote_event

​VoterV3_GaugeCreated_event

​VotingIncentives_RewardPaid_event

​VotingIncentivesFactory_CreateVotingIncentives_event

Tables

AlgebraFactory_Pool_event

AlgebraFactoryV2_CustomPool_event

AlgebraFactoryV2_Pool_event

AlgebraPool_Burn_event

AlgebraPool_Collect_event

AlgebraPool_CommunityFee_event

AlgebraPool_Fee_event

AlgebraPool_Flash_event

AlgebraPool_Mint_event

AlgebraPool_Swap_event

AlgebraPoolV2_Burn_event

AlgebraPoolV2_Collect_event

AlgebraPoolV2_CommunityFee_event

AlgebraPoolV2_Fee_event

AlgebraPoolV2_Mint_event

AlgebraPoolV2_Swap_event

Gauge_Harvest_event

GaugeFactoryV2_CreateGauge_event

GaugeV2_Harvest_event

ReferralRewards_Claim_event

Voter_Vote_event

VoterV3_GaugeCreated_event

VotingIncentives_RewardPaid_event

VotingIncentivesFactory_CreateVotingIncentives_event