thena_v2_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	0x739e561786c920d025d57ed99be5d4eca3458e3e	false	0x55d398326f99059ff775485246999027b3197955	0x953e94caf91a1e32337d0548b9274f337920edfa	226	30557945	2023-08-04T11:57:40.000Z	0xe428ad0341b0140eaa7f248c316ed95c89e184ef60f4f830fb04fd049d2899da
0x306f06c147f064a010530292a1eb6737c3e378e4	0x8171e3aa02f684bd4e8e04dad286451318cf27a9	false	0x4b6b3d425f82248996d77ecc3f3df1e500aac1db	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	107	30327819	2023-07-27T11:34:13.000Z	0xc937aec72d0c2bdd904aa645ef1c311758ebecce90f7786f46c72f80b887ec5d
0x306f06c147f064a010530292a1eb6737c3e378e4	0x6b32e9178a6670dc9b19a74fe5080c54ea5347c7	false	0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275	0x2170ed0880ac9a755fd29b2688956bd959f933f8	46	28642845	2023-05-29T19:31:10.000Z	0x04d249a68cf3a6782ea964d2e6b2cb952cda8e831d49cbddbc21ec7374535721

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v2_bsc.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_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x8e3ae967604dc4b4ba676e6d34ac603fb07fc921	false	0x05f3abd2b008e8b36a410f3c42e703cb776cecd0	324	284540942553409006115	317284497880175021759	8100	30346132	-2100	2023-07-28T02:52:22.000Z	0x84dba3085bc4b9023664fb0634e2869c986de266d65fa36d1fcec62fc5982523	1339698228464189352727
0x8e3ae967604dc4b4ba676e6d34ac603fb07fc921	false	0x05f3abd2b008e8b36a410f3c42e703cb776cecd0	328	20653620996226909613	304160689546331648806	2940	30346132	-2100	2023-07-28T02:52:22.000Z	0x84dba3085bc4b9023664fb0634e2869c986de266d65fa36d1fcec62fc5982523	1284284418798034500726
0x8e3ae967604dc4b4ba676e6d34ac603fb07fc921	false	0x05f3abd2b008e8b36a410f3c42e703cb776cecd0	316	0	0	2940	30346132	-2100	2023-07-28T02:52:22.000Z	0x84dba3085bc4b9023664fb0634e2869c986de266d65fa36d1fcec62fc5982523	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v2_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
0x1b9a1120a17617d8ec4dc80b921a9a1c50caef7d	false	0x6ca28c08daef2cf1c98741c1542cc9604926f05d	415	1016815065792088813	1198402738918865973	60	58140997	0x6ca28c08daef2cf1c98741c1542cc9604926f05d	-60	2025-08-19T11:45:08.000Z	0xa3b4d63d159fc475ad6bbeb655b860df4c7e0b7958311d259b633f2535b45a4e
0xd405b976ac01023c9064024880999fc450a8668b	false	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	212	872230668920600736166	152244547245345089	-67020	58087458	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	-67440	2025-08-19T00:35:49.000Z	0xc5d92153a17c5d068b4ae18c4032286ca9b9aee693ba66d4ec73c19bc5da1c9a
0xd405b976ac01023c9064024880999fc450a8668b	false	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	207	3221415328995448	3271045087151590934	-67440	58087458	0x015eb9b9ce3ab0ddacdab35880171b0078edc02e	-887220	2025-08-19T00:35:49.000Z	0xc5d92153a17c5d068b4ae18c4032286ca9b9aee693ba66d4ec73c19bc5da1c9a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v2_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
0xc93643c85fb216e459406d524d0aa0fd2045bf7d	false	120	32919502	2023-10-25T18:53:43.000Z	0x9726d2d7a665d95f32e0534764981b2e1da2a8904464f58627d60ca978e9eae4	0	0
0x7b879963ae083732f4514d564f4e4613e24e1f67	false	207	30669041	2023-08-08T08:55:01.000Z	0x036415e92ee554a07d34fd5d17de7810ac83a300ba3e6bc142a389fb62bf3599	0	0
0xda6419a82c4fd30927f54796d7f053f05acd66bc	false	168	27609799	2023-04-23T21:16:15.000Z	0xbf522fb734be276ae82acb4245151095997be129f3c2dd468a85d55d2524d5a0	30	30

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v2_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
2750	0x055557c6606f7b0d34e617653c447f079b0b0a73	false	276	29103858	2023-06-14T20:33:40.000Z	0x3b218924b0dc75ff4113f757b36735e4257f1545cc4adf5e10c9a4946851d9ee
2750	0x055557c6606f7b0d34e617653c447f079b0b0a73	false	152	29103326	2023-06-14T20:07:03.000Z	0x398d71b830b6c47ab03ec561ebfadcc311c5e1ea9b192875fc1f7e5df578d010
2750	0x055557c6606f7b0d34e617653c447f079b0b0a73	false	43	29106575	2023-06-14T22:50:16.000Z	0x0e972fed19766370bb89eeb0fddd86e4c4c6c23a72bb6e7dc251b0bee1315e53

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v2_bsc.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
0x1335ffc90516b022425dbcfe4ea3610aa45f6c3e	false	0x818c686536f8b86dade0841fcc2416cb89201a05	0x818c686536f8b86dade0841fcc2416cb89201a05	28	1	6	75720	29821164	69720	2023-07-09T20:07:48.000Z	0x846b7ab13f1ee89785d926e22ff8c5257eb9fafc34c99f8bdf2b6d24634ebee1	15
0x1335ffc90516b022425dbcfe4ea3610aa45f6c3e	false	0x818c686536f8b86dade0841fcc2416cb89201a05	0x818c686536f8b86dade0841fcc2416cb89201a05	25	3706200377958682631	4395906843184321499074	75720	29821164	63600	2023-07-09T20:07:48.000Z	0x846b7ab13f1ee89785d926e22ff8c5257eb9fafc34c99f8bdf2b6d24634ebee1	488888727287322280756
0x1c2d4f310aea872c5bd55790d2d78ca7b31992a3	false	0xac7042fed4e724107fd5778f4a9cad894a5e18ab	0xac7042fed4e724107fd5778f4a9cad894a5e18ab	19	0	6345213431979255236647	-420	29821759	-480	2023-07-09T20:37:34.000Z	0x89fa44df2244190125aeb8fb9d0f27538e75fc91ab1cb41e3a45f6bd130f14db	2163304573599431174830875

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thena_v2_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
0x1335ffc90516b022425dbcfe4ea3610aa45f6c3e	69607	false	2572230748465381679826660545866	0x00000000000e8716b4e2d12400a01474cdfad760	371	1144766005465000122	-1200814972963038463526	29750920	18209876103669538647801	0x00000000000e8716b4e2d12400a01474cdfad760	2023-07-07T09:26:47.000Z	0xeec773019bc88973414e3c4cd64da9d35f44f16f124272138eb4a623075d7867
0x8e3ae967604dc4b4ba676e6d34ac603fb07fc921	770	false	82340398972765521498041839101	0x00000000000e8716b4e2d12400a01474cdfad760	105	-447817232327099261648	486576536907890584255	29766615	190418573031130748764461	0x00000000000e8716b4e2d12400a01474cdfad760	2023-07-07T22:33:23.000Z	0x60f8d8bfdfb3b401e71a18e6e8d560160293f0b41e6c898c254eb1fcbe842f91
0xf6814792050ccd1c603d8a95468d6d9587ecbdaf	-67786	false	2673013714129407994485449416	0x00000000000e8716b4e2d12400a01474cdfad760	279	-1574559884932405004167	1798000000000000000	29744532	227483750113588565077457	0x00000000000e8716b4e2d12400a01474cdfad760	2023-07-07T04:06:19.000Z	0x03c0472776c489eb2847c6f5363ff2648669073b76785af79826d70fcca9f633

Example Query

Query with partition filter

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

Gauge_Harvest_event

Reward claim events from Thena V2 liquidity gauge contracts on BSC, tracking token amounts harvested by users from their staked positions. Used for analyzing yield farming behavior and protocol reward distribution 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_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
0xb00894e7c895dde3707e2c6fb6abe08156ac4231	0x01ed0c5f8b9e8845236e2fa87245dad888337202	false	130480015041855161423	107	28780021	2023-06-03T14:04:15.000Z	0x7bfcaf9f1e0c6d511ddbdae2e7e08573c30593faa078361fd9e509cd5ed3c2ad
0xbc97db24644c12734bbfcc9d429710e448e055cc	0x048ffae5c45985805e5bed87e5d4ba24198f7bee	false	292792279433113	224	28789991	2023-06-03T22:23:24.000Z	0x5b74586c314aeb8dbc6a7e09c4f510afd5709cf76b14a4a3c9a926a9b7c1f080
0xcc51cf273d7bf3a9318c2db35becac9eb2ef7d0a	0x048ffae5c45985805e5bed87e5d4ba24198f7bee	false	8649466086705458191	222	28789991	2023-06-03T22:23:24.000Z	0x5b74586c314aeb8dbc6a7e09c4f510afd5709cf76b14a4a3c9a926a9b7c1f080

Example Query

Query with partition filter

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

ReferralRewards_Claim_event

Referral reward claim events from Thena V2 DEX (decentralized exchange) on BNB Smart Chain, capturing token payouts to users and their recipients. Useful for tracking referral program participation and reward distribution across various BEP-20 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
0xef559bb92b20744749d5faf497de2aa92b0b60d1	0x664ce330511653cb2744b8ed50dba31c6c4c08ca	false	0xef559bb92b20744749d5faf497de2aa92b0b60d1	0x2952beb1326accbb5243725bd4da2fc937bca087	199	13534728518	26421494	2023-03-13T05:52:15.000Z	0x709aa5f65ca1c9d363332c3b39cc4c7501595adf50424f4c84ea6c9efb443576
0xef559bb92b20744749d5faf497de2aa92b0b60d1	0x664ce330511653cb2744b8ed50dba31c6c4c08ca	false	0xef559bb92b20744749d5faf497de2aa92b0b60d1	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	225	7062875135016100443	26421504	2023-03-13T05:52:45.000Z	0xae56c86964143be1299ab10229a958f429b90b475e178d3cbe00d6b921d08ec5
0x8f0b0254f4058847676c4e52aa1f1e3c40bed61d	0x664ce330511653cb2744b8ed50dba31c6c4c08ca	false	0x8f0b0254f4058847676c4e52aa1f1e3c40bed61d	0x4d2d32d8652058bf98c772953e1df5c5c85d9f45	219	11371557232000000000	31275599	2023-08-29T12:20:06.000Z	0xea734b0d9523c71ce41b251dbba28cfeae748dbd396c7737a0f64a5c464c60f0

Example Query

Query with partition filter

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

Voter_GaugeCreated_event

Gauge creation events emitted when new liquidity mining gauges are deployed for liquidity pools in vote-escrowed token (veToken) protocols. Links pool addresses to their corresponding gauge contracts and associated reward distribution mechanisms for governance-driven liquidity incentives.

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	0x9c95ee2db6b6d167ad26b65e85d3e642ffe85587	false	0x6cc6eaab8d850991f9c4c88fb8898e7b68f8afa9	138	0x993ae2b514677c7ac52baecd8871d2b362a9d693	31307674	2023-08-30T15:09:53.000Z	0x0fc6fee0110d7e76d8087e6f5d8abeebbecb2264af90b8925d77f77b0c9659d7	0xafdf574241eaecaf561cc8912820138af94ee1b6	0xa3d0b523c190c3176f0aecfc6d9998a6a9d3bd4f
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	0x60e0ca8b53741d7e29a757408bd1d8b1eaf6dbe6	false	0x6aec3024508609bd643edddd3411cded2496471b	108	0x993ae2b514677c7ac52baecd8871d2b362a9d693	35693745	2024-01-30T09:44:48.000Z	0xe3cac46e44d6c768193885d7062fd3758c49ac012a184924220c48d2d2391f0a	0x0707e8e5e6165897ee9403acb0c7c4b24ae87ee8	0x110b46f405d933715079cd4624c8bdeb06e1b92f
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	0xcbfb2d1487a8a69a8b0ee8e7fb3ca5e0c338b508	false	0x4ea3ddb7425a78113bef43656ba2f5fcbc9bad0f	200	0x993ae2b514677c7ac52baecd8871d2b362a9d693	32541402	2023-10-12T14:44:24.000Z	0x7c0dbcfd8626296b7fc8a4e6c5dae447b0b67bd31548c5f9a9fb4b8f7c5a9681	0x59283ab0a8ec8b86d1f050b07348af5992e5a6c6	0xca24d3db4ad86f692457d563d7f88d627aff3e9e

Example Query

Query with partition filter

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

VoterV3_DistributeReward_event

Reward distribution events from Thena v2 DEX (Decentralized Exchange) VoterV3 contract on BNB Smart Chain, tracking token amounts sent to liquidity pool gauges. Used for analyzing protocol emissions and liquidity mining incentive allocations 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_gauge	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	false	0x1560d23c5db98d78537253332b067a6b8981e432	14396114643188242676914	0x8635ff9587decbcb28856b0e641e2465245e15aa	242	31934747	2023-09-21T11:27:54.000Z	0xb3feb6c7840dcf1eb4675732fd2ace693d5decd510d15faffa74d60f9200bcc8
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	false	0x36e56f65b9f5c756289811a4c55923afbff31bbe	62939148787621618	0x8635ff9587decbcb28856b0e641e2465245e15aa	215	31934747	2023-09-21T11:27:54.000Z	0xb3feb6c7840dcf1eb4675732fd2ace693d5decd510d15faffa74d60f9200bcc8
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	false	0xbe4d4fa65fc80593b0b06a2b155ffe93f1419358	2139589904712629096422	0x8635ff9587decbcb28856b0e641e2465245e15aa	233	31934747	2023-09-21T11:27:54.000Z	0xb3feb6c7840dcf1eb4675732fd2ace693d5decd510d15faffa74d60f9200bcc8

Example Query

Query with partition filter

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

VoterV3_GaugeCreated_event

Gauge creation events from Thena V2 (Binance Smart Chain) decentralized exchange, capturing when new liquidity pool gauges are initialized with their associated bribe contracts and creator addresses. Used for tracking DEX governance infrastructure deployment and incentive mechanism setup.

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	0xa9c1fe3b78a5d613b2dbc5764c893d4e9593a833	false	0xc01f5fe48c2b9716657b8ca7c2fd24915090b9d6	122	0xf3d66f36af3d43ee9af590278ee4017f049fd54f	31729033	2023-09-14T07:32:31.000Z	0xd8e15c78b12d237bd7be98f34c9b5dd94e392959d3721b891d75ed15ce22d550	0x2bcf89d48b432dd901c6ab879624b1563cad4278	0x5da966f6b6b17119a9865dc8816805fa8633b3d5
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	0x9938256dd2c6a436233685e910efaa44f6d8e81c	false	0x872d5c17ab31b15554fadda7c89c68b54b84f44b	107	0x34922627b7244d47729f03b33eb45d8d263d116b	28032625	2023-05-08T14:09:36.000Z	0xd35a44836f979a99d1169ad802570ab3710d8c92b9a4b71a68a54b7a4cef362c	0x1d114bff05cfba0365944a94a757d1332ef8c64b	0xd24f6d7ac086e409305fa222069e422d1a506f0c
0x3a1d0952809f4948d15ebce8d345962a282c4fcb	0x5a797d22b27c13a98df8147acf95771f7b43ac66	false	0x30c69104d4f305b7403f7ae6e68a8ecd39884cda	82	0x34922627b7244d47729f03b33eb45d8d263d116b	28032619	2023-05-08T14:09:18.000Z	0xd61f5b9031f52e133ab1f45381d5e92f5400aaca771e10d8b5256f1309ad8d88	0x4d332410afddcc288f6cd62c96119a651f9c8bfe	0xbbf2e43a7c61ca1e818d7aba0e398d2fdd47edb5

Example Query

Query with partition filter

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

Gauge_Harvest_event

ReferralRewards_Claim_event

Voter_GaugeCreated_event

VoterV3_DistributeReward_event

VoterV3_GaugeCreated_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

​Gauge_Harvest_event

​ReferralRewards_Claim_event

​Voter_GaugeCreated_event

​VoterV3_DistributeReward_event

​VoterV3_GaugeCreated_event

Tables

AlgebraFactory_Pool_event

AlgebraPool_Burn_event

AlgebraPool_Collect_event

AlgebraPool_CommunityFee_event

AlgebraPool_Fee_event

AlgebraPool_Mint_event

AlgebraPool_Swap_event

Gauge_Harvest_event

ReferralRewards_Claim_event

Voter_GaugeCreated_event

VoterV3_DistributeReward_event

VoterV3_GaugeCreated_event