Skip to main content

Tables

BribeFactory_createBribe_function

Bribe contract creation events from Thena DEX (decentralized exchange) on BNB Smart Chain, recording deployment of incentive contracts for liquidity pool trading pairs. Used to track governance incentive mechanisms and fee distribution infrastructure setup for LP (liquidity provider) rewards.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueNUMERICAmount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__ownerSTRINGAddress of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string.
in__token0STRINGContract address of the first token in the Thena liquidity pair being created for bribes or fee distribution. Hex-encoded, 0x-prefixed 40-character string on BSC.
in__token1STRINGContract address of the second token in the Thena liquidity pool pair for which the bribe contract is being created. Hex-encoded, 0x-prefixed 40-character string for BSC (Binance Smart Chain).
in__typeSTRINGDescriptive label for the bribe contract being created, typically indicating the protocol name, purpose (LP Fees or Bribes), and token pair. Follows format “Thena [LP FeesBribes]: [token0]-[token1]” as seen in sample values like “Thena Bribes: aLVL-WBNB”.
out_anon0STRINGActual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
gasvaluestatusgas_usedin__typein__ownerout_anon0signaturein__token0in__token1to_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
131540910true2600957Thena LP Fees: aANKRBNB-BTCB0x46f99291eedf25fd5c6ae56bbfd6679d0ea3630b0x8b1d9bc54426dee13ba7642c01a47818da23053a0x0000e66b0x52f24a5e03aee338da5fd9df68d2b6fae11788270x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c0xd50ceab3071c61c85d04bdd65feb12fee7c91375294653870x3a1d0952809f4948d15ebce8d345962a282c4fcb0,72023-06-27T10:43:11.000Z0x58d6c85bdea208b829283026b723d39406636a5f5a1feebac7e00dc70da43588
105873570true2592557Thena Bribes: aANKRBNB-BTCB0x46f99291eedf25fd5c6ae56bbfd6679d0ea3630b0x776c5f3a15fe0cae24876d766a88a33ffe04df1e0x0000e66b0x52f24a5e03aee338da5fd9df68d2b6fae11788270x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c0xd50ceab3071c61c85d04bdd65feb12fee7c91375294653870x3a1d0952809f4948d15ebce8d345962a282c4fcb0,92023-06-27T10:43:11.000Z0x58d6c85bdea208b829283026b723d39406636a5f5a1feebac7e00dc70da43588
106368660true2612613Thena Bribes: aANKRBNB-ANKRMATIC0x46f99291eedf25fd5c6ae56bbfd6679d0ea3630b0x108b3289871be664dbf7b1d0ad5be092b3bf88a70x0000e66b0x52f24a5e03aee338da5fd9df68d2b6fae11788270x738d96caf7096659db4c1afbf1e1bdfd281f388c0xd50ceab3071c61c85d04bdd65feb12fee7c91375294653960x3a1d0952809f4948d15ebce8d345962a282c4fcb0,92023-06-27T10:43:38.000Z0x16f55fcd81dbf2b46bfef21127567423aa2c3277ccd2b8558c34d9ea13f9ced5
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.BribeFactory_createBribe_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ExternalBribe_notifyRewardAmount_function

External bribe reward notifications from Thena V1 DEX (decentralized exchange) on BNB Smart Chain, recording token reward amounts distributed to liquidity pool voters. Used for analyzing voter incentive programs and bribe market dynamics across different reward tokens and bribe contracts.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueNUMERICAmount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__rewardsTokenSTRINGContract address of the reward token being distributed to bribe recipients on BSC. Hex-encoded, 0x-prefixed 40-character string identifying the ERC-20 token used for incentive payments.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
gasvaluestatusgas_usedin_rewardsignatureto_addressblock_numberfrom_addresstrace_addressblock_timestampin__rewardsTokentransaction_hash
4853580true63643437506316238789269410xb66503cf0xafdf574241eaecaf561cc8912820138af94ee1b6331886950x2fb44fb6ee322d6198144e99d67e066a6d90c3fe0,23,02023-11-04T04:09:10.000Z0x54c331bb7d32fbfc17bc9accab2e2d12d0d1b2220x85b0830f797859632c8086cafa81183d8cbe41f226473300ca3de2db22c89cb1
12687410true636431104116648508128377120xb66503cf0xafdf574241eaecaf561cc8912820138af94ee1b6331975740x2fb44fb6ee322d6198144e99d67e066a6d90c3fe0,0,0,2,0,0,0,2,0,20,02023-11-04T11:33:54.000Z0x54c331bb7d32fbfc17bc9accab2e2d12d0d1b2220xab5c9787fc9fc5915f9c0670c765fe5c0a4697a74df650cc493ac2b1f77e339d
3314750true6364371084247615065795020xb66503cf0xafdf574241eaecaf561cc8912820138af94ee1b6331911690x2fb44fb6ee322d6198144e99d67e066a6d90c3fe0,48,02023-11-04T06:12:59.000Z0x54c331bb7d32fbfc17bc9accab2e2d12d0d1b2220xb6f4e33aa1e194f82b3919fbeb409d927312dc9046b160d4187319afb98859c8
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.ExternalBribe_notifyRewardAmount_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ExternalBribe_RewardAdded_event

External bribe reward distribution events from Thena V1 DEX (decentralized exchange) on BNB Smart Chain, capturing when incentive tokens are added to liquidity pool gauges with amounts, token addresses, and distribution start times. Used for analyzing protocol incentive programs and vote-escrowed token (veTHE) bribery mechanisms.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_rewardTokenSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_startTimestampSTRINGUnix timestamp indicating when the external bribe reward distribution period begins for this pool. Appears to represent a standardized epoch start time across multiple reward additions.
addressremovedin_rewardlog_indexblock_numberin_rewardTokenblock_timestamptransaction_hashin_startTimestamp
0x7548b58f27107ac7cf5fd992bc76ac857cb16fc6false31250000000000000000000432285245880x0b15ddf19d47e6a86a56148fb4afffc6929bcb892023-05-25T16:49:07.000Z0x390405de935520799f7d2b51bff68b6793836e2141eefa1b335ab7588080b2f81685577600
0xb98fea13b785e559300abb2b0a091e7d0d8ac9d2false650000000000000000000115285171170x3bc5ac0dfdc871b365d159f728dd1b9a0b5481e82023-05-25T10:34:57.000Z0x1d9ed61954b7cce2cf29c0a9979958cfe1a855f5bf6361921dc1ceb54b722a251685577600
0x9165aa77e7ce3f6a528990b06eee357e445cb033false250000000000000000000219285241610x3bc5ac0dfdc871b365d159f728dd1b9a0b5481e82023-05-25T16:27:46.000Z0x76e1340467f2a8ffafcc047a6c7709e6f7bea17eefce56d74a6f9ce01317eca21685577600
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.ExternalBribe_RewardAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ExternalBribe_RewardPaid_event

External bribe reward distribution events from Thena DEX (Decentralized Exchange) v1 on BNB Smart Chain (BSC), capturing when users claim incentive payments for voting or liquidity provision. Used for tracking bribe campaigns, voter rewards, and protocol incentive flows across different reward tokens.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardsTokenSTRINGContract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_rewardlog_indexblock_numberblock_timestampin_rewardsTokentransaction_hash
0xae6b5316b84ffb5341ce1e1495d685e329bfee010x28aa4f9ffe21365473b64c161b566c3cdead0108false423279850456550502781630146315269852023-09-07T06:43:32.000Z0x74ccbe53f77b08632ce0cb91d3a545bf6b8e09790x02facabdf6327ea964c5b6dbda4eaa95a7c9ed4ccf5535f09220207165b77571
0x7548b58f27107ac7cf5fd992bc76ac857cb16fc60x86e0a272a08db7875e8fc2bda6836c1ce670b8bdfalse175756864260991994011210315312532023-09-07T10:17:24.000Z0x0b15ddf19d47e6a86a56148fb4afffc6929bcb890x059eaf7b6a6f033ce9e208880504ff54d6fae77d99ce310d4ba388c072f635bb
0x49c49c10ad25949388e191838ff7a9430fd6ced70x0faa92ab469db5d268fd37c2f1f5e39f72b0e3b3false1821381446029996411299207315197162023-09-07T00:39:40.000Z0xf4bafaeae73a4a7c8b6479970075e91e641fb1fc0x1605d3a2ec865f0f79e96b3cae66cc7b16541c48298908b7b8ffecb632d61fb5
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.ExternalBribe_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_stableBOOLBoolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
in_pairSTRINGContract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
in_anon4STRINGSequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.
addressin_pairremovedin_anon4in_stablein_token0in_token1log_indexblock_numberblock_timestamptransaction_hash
0xafd89d21bdb66d00817d4153e055830b1c2b39700x535aeeab656c0fbb07da64fe4aa3a15dfc6834c8false84false0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0xad29abb318791d579433d831ed122afeaf29dcfe217252614482023-01-31T11:48:36.000Z0x1d31e44e5b393221a2af8bb92fdb75bdf36881ccda4a5af88a9f4e617ecef922
0xafd89d21bdb66d00817d4153e055830b1c2b39700x928fe97eee1f921d80f25dc2eea1df280704fd03false85false0xa8cd6e4bf45724d3ac27f9e31e47ba4e399a7b520xe9e7cea3dedca5984780bafc599bd69add087d56276252657802023-01-31T15:31:56.000Z0x97c5011e9d348e3b3d0b24159a44d25c5079710a8ddccb321f0278c92129e598
0xafd89d21bdb66d00817d4153e055830b1c2b39700x6190e79064213e6a2997355153f57904fb4910c3false137false0x431e0cd023a32532bf3969cddfc002c00e98429d0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d152258029442023-02-19T12:59:41.000Z0xa4dd3d36d8c86a5dd4fd7fa7a95e324343993807eaf10f0c8ec760d5081e34ca
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Factory_PairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Gauge_Harvest_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Gauge_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GaugeFactory_createGaugeV2_function

Gauge creation function calls from Thena V1’s GaugeFactory on BNB Smart Chain, capturing liquidity pool gauge deployments with associated vote-escrowed (ve) token, reward token, and internal/external bribe contract addresses. Used for tracking voting incentive infrastructure setup across Thena’s liquidity pools.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueNUMERICAmount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__rewardTokenSTRINGContract address of the token distributed as rewards through the newly created gauge. Always set to the Thena platform token (0xf4c8…a11) across all gauge deployments in the samples.
in__veSTRINGContract address of the vote-escrowed (ve) token contract used in Thena’s gauge voting system. Consistently references the same veToken contract across all gauge deployments on BSC.
in__tokenSTRINGContract address of the token. Hex-encoded, 0x-prefixed, 42-character string.
in__distributionSTRINGContract address of the distribution contract responsible for reward allocation in Thena’s gauge system. Typically matches the from_address as the distribution contract initiates gauge creation.
in__internal_bribeSTRINGContract address of the internal bribe contract associated with the gauge being created. This contract manages reward distributions to voters from protocol-controlled incentives, distinct from external third-party bribes.
in__external_bribeSTRINGContract address of the external bribe contract associated with this gauge deployment. Hex-encoded, 0x-prefixed 40-character address on BSC that handles third-party incentives for vote-escrowed token holders.
in_anon6BOOLBoolean flag indicating whether the gauge creation is anonymous or publicly attributed. Consistently true across all sample rows, suggesting most Thena V1 gauges are created anonymously on BSC.
out_anon0STRINGActual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
gasvaluein__vestatusgas_usedin_anon6in__tokenout_anon0signatureto_addressblock_numberfrom_addresstrace_addressblock_timestampin__rewardTokenin__distributiontransaction_hashin__external_bribein__internal_bribe
2097462800xfbbf371c9b0b994eebfcc977cef603f7f31c070dtrue3470744true0xa0ae511748c9b8876cd686234842277bbf919a140xe88c4dd1a77a9763c6df09d61c2de074b7d0edf40x7379e7700xb065e4f5d71a55a4e4fc2bd871b36e33053cabeb300971680x3a1d0952809f4948d15ebce8d345962a282c4fcb0,462023-07-19T10:48:11.000Z0xf4c8e32eadec4bfe97e0f595add0f4450a863a110x3a1d0952809f4948d15ebce8d345962a282c4fcb0x8cad03ba4bacf30394d6277baf44047483a541907f5b83d58902d4730256ee3b0x1fe98d43a07cbd77963d51baa5bc18fc98a32c620x5f1c0335b99da38a2f03cc532b7a032a025cd525
2964009700xfbbf371c9b0b994eebfcc977cef603f7f31c070dtrue3470744true0x5a27771713631d7e3c0f1e781ac1d48f2b76458d0xea6db89ba474dc659b00fac41b6facdca94a86d30x7379e7700xb065e4f5d71a55a4e4fc2bd871b36e33053cabeb300971680x3a1d0952809f4948d15ebce8d345962a282c4fcb0,342023-07-19T10:48:11.000Z0xf4c8e32eadec4bfe97e0f595add0f4450a863a110x3a1d0952809f4948d15ebce8d345962a282c4fcb0x8cad03ba4bacf30394d6277baf44047483a541907f5b83d58902d4730256ee3b0x28953340100b43951043e15fbe3e7c6f097e5dbf0xb356891444f65aa1256c76b367a1bff701db1fe2
3830556000xfbbf371c9b0b994eebfcc977cef603f7f31c070dtrue3470744true0x88db83b049e6996b7d599cd14665e2a875b619740x637bfc4c53b26f0ad287401b2477bf1af9cb7a000x7379e7700xb065e4f5d71a55a4e4fc2bd871b36e33053cabeb300971680x3a1d0952809f4948d15ebce8d345962a282c4fcb0,222023-07-19T10:48:11.000Z0xf4c8e32eadec4bfe97e0f595add0f4450a863a110x3a1d0952809f4948d15ebce8d345962a282c4fcb0x8cad03ba4bacf30394d6277baf44047483a541907f5b83d58902d4730256ee3b0xda447227a7670020c621f82497e25710517ad5890x30ada95e13a1ea116d80c79d9ad94f5f22de60ce
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.GaugeFactory_createGaugeV2_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

InternalBribe_notifyRewardAmount_function

Reward distribution events from Thena v1 DEX internal bribe contracts on BNB Smart Chain, tracking when incentive tokens are allocated to liquidity pools. Used for analyzing voting incentive programs and gauge reward mechanics across different token pairs.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueNUMERICAmount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__rewardsTokenSTRINGContract address of the reward token being distributed through the bribe mechanism. Hex-encoded, 0x-prefixed 40-character string representing various tokens on BSC used as incentives.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
gasvaluestatusgas_usedin_rewardsignatureto_addressblock_numberfrom_addresstrace_addressblock_timestampin__rewardsTokentransaction_hash
272922090true486011292747700290982160xb66503cf0x52d96d104b3957ee03540ef036cb661127653e0f297038750x08de2140aa0b2ab6011a8fc7d6755bec0903caf20,541,0,99,52023-07-05T18:06:52.000Z0x52f24a5e03aee338da5fd9df68d2b6fae11788270xeb6ac4f2c1cfba202fd059fc981f57a5dd099077e278788644ba60c84bcd17b3
272122480true436041221671957060916287740xb66503cf0x52d96d104b3957ee03540ef036cb661127653e0f297038750x08de2140aa0b2ab6011a8fc7d6755bec0903caf20,541,0,99,82023-07-05T18:06:52.000Z0xf4c8e32eadec4bfe97e0f595add0f4450a863a110xeb6ac4f2c1cfba202fd059fc981f57a5dd099077e278788644ba60c84bcd17b3
249708510true47844229157344870398776920xb66503cf0x512a4fe3df6d1a960193b8a62c2e413ddfcc87dc297038750x0a9555e82166a99a8cc9fdc23cd5cb88d6be278a0,541,0,111,42023-07-05T18:06:52.000Z0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0xeb6ac4f2c1cfba202fd059fc981f57a5dd099077e278788644ba60c84bcd17b3
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.InternalBribe_notifyRewardAmount_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

InternalBribe_RewardAdded_event

Reward distribution events from Thena V1 DEX (Decentralized Exchange) internal bribe contracts on BNB Smart Chain, recording incentive amounts deposited to influence gauge voting. Tracks reward token addresses, amounts, and epoch start timestamps for analyzing liquidity mining incentive programs and governance bribery mechanics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_rewardTokenSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_startTimestampSTRINGUnix timestamp indicating when this reward distribution period begins on Thena v1. Stored as a string representation of seconds since epoch, typically aligned to periodic reward cycles.
addressremovedin_rewardlog_indexblock_numberin_rewardTokenblock_timestamptransaction_hashin_startTimestamp
0xc7cd651ca104477b024d6af1143b1f11ddb79362false5731645404072899620316506060x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c2023-09-11T14:00:06.000Z0x01f85a8bcab3e536049c294f0a6181ca0169c064e2d53456e68b68b7bc1e538a1694649600
0x070022e35f22f9df8ebb1dad9c169d5e0c16873dfalse18527044528671624533316506060x55d398326f99059ff775485246999027b31979552023-09-11T14:00:06.000Z0x01f85a8bcab3e536049c294f0a6181ca0169c064e2d53456e68b68b7bc1e538a1694649600
0x18548bcf71bd9d71820af952dc89abd5f298abd9false3232271644813480982550316506060x55d398326f99059ff775485246999027b31979552023-09-11T14:00:06.000Z0x01f85a8bcab3e536049c294f0a6181ca0169c064e2d53456e68b68b7bc1e538a1694649600
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.InternalBribe_RewardAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

InternalBribe_RewardPaid_event

Bribe reward distribution events from Thena V1 DEX (decentralized exchange) on BSC (BNB Smart Chain), tracking token incentives paid to users for voting or liquidity provision. Each record captures the reward amount, token address, and recipient for analyzing protocol incentive mechanics and governance participation.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardsTokenSTRINGContract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_rewardlog_indexblock_numberblock_timestampin_rewardsTokentransaction_hash
0xaa9c6d5b6769fcb017411d0b1247bf55bf9549830x0c181073b52bfe6cab3bf5d5dba36d4ed7131a5cfalse777799433196351284312511672023-08-28T15:54:08.000Z0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c0x4f9a1db1f381b8f5369c334ecaabb476ac9789b794f1cbaa41b53a8cd42ea220
0xaa9c6d5b6769fcb017411d0b1247bf55bf9549830x0c181073b52bfe6cab3bf5d5dba36d4ed7131a5cfalse29738110449931471282312511672023-08-28T15:54:08.000Z0xa045e37a0d1dd3a45fefb8803d22457abc0a728a0x4f9a1db1f381b8f5369c334ecaabb476ac9789b794f1cbaa41b53a8cd42ea220
0xb2fe5f1bab7181892305f411ca5f5678a32480040x1de1ecbb8db25752d52c346aa4eeb9359ab5886efalse8065676862093738269312574392023-08-28T21:08:05.000Z0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e50x56bc5a9834809a5e320d6ca8c998310ebf24c24f3a75c05e0e99632340aeca2b
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.InternalBribe_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) pools.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressremovedin_senderlog_indexin_amount0in_amount1block_numberblock_timestamptransaction_hash
0x9ddf69b3195f6d6074bb4fe9fd4ebe1446ac5b430xeb58a4d07990ff50b9f8289701cbddf9052570b5false0x9ddf69b3195f6d6074bb4fe9fd4ebe1446ac5b4367179101531928354975951100784595672525164864322588412023-10-02T18:20:51.000Z0xdcadbd7b3484e4fafe7b8ad4b28a4f41a7212e4ad724974a3796f1399de83a71
0x9ddf69b3195f6d6074bb4fe9fd4ebe1446ac5b430x7e61c053527a7af0c700ad9d2c8207e386273222false0x9ddf69b3195f6d6074bb4fe9fd4ebe1446ac5b436112248575582455777034031096265987817490824101322602172023-10-02T19:29:42.000Z0xd1faae31725849cac526b5aa60175f691b5df71434dd23e05e2e0bf939c90efd
0xd4ae6eca985340dd434d38f470accce4dc78d1090x63db6ba9e512186c2faadacef342fb4a40dc577cfalse0xd4ae6eca985340dd434d38f470accce4dc78d10954278553158282623676570721035521041282424322554612023-10-02T15:31:16.000Z0x814d8261e5249c3733f82b018ba881908accf71985aa97edcf0101b4c44de420
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Pair_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Claim_event

Claim events from liquidity pool pair contracts recording amounts of both tokens withdrawn by liquidity providers. Tracks sender address, recipient address, and claimed amounts in smallest token denomination for both token0 and token1.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0xd714206a7d63f5a2d613064815995e9cc7061988false0x4d3a031609178e15acda43855a7cd7f7421c6a8d857729166062156418614674064173540642296427850x4d3a031609178e15acda43855a7cd7f7421c6a8d2023-07-03T14:59:09.000Z0x2859701ebe5acc6eb1bce02688048dc659b1707863a59f188a8ba3be549c632c
0xb8a85b80a12931fe2a1f5db9295fbdae03616e9bfalse0xd66207f31737b77070f3a593224fdebaece467bd61662993307923844211904074714096102296427750xd66207f31737b77070f3a593224fdebaece467bd2023-07-03T14:58:39.000Z0x3e72c14fa0da5c134c94003f00e6aef76843f9537f7a7a7ff960efdf85a441ff
0x80551245c562380140668b7df20a7e9c773d21bdfalse0xe30ee861202664395ea440cdf08d6a4e9c09d7e91332322861396561614006845899296427750xe30ee861202664395ea440cdf08d6a4e9c09d7e92023-07-03T14:58:39.000Z0x3e72c14fa0da5c134c94003f00e6aef76843f9537f7a7a7ff960efdf85a441ff
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Pair_Claim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Fees_event

Trading fee collection events from Automated Market Maker (AMM) liquidity pairs recording fee amounts in both token0 and token1 denominations. Used for tracking protocol revenue and liquidity provider earnings across decentralized exchange pools.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_senderlog_indexin_amount0in_amount1block_numberblock_timestamptransaction_hash
0xf81b6b8aaad4c37f6f2e8aa9988f28ea8e82bb49false0x0000000000008afdacc486225455281f614843e74010157654996655366410277934322023-04-30T06:34:10.000Z0x6000c5f342f473ece23f34986ed2fbffe1ea1a23c456eccbe9650d92f61ce89f
0xf81b6b8aaad4c37f6f2e8aa9988f28ea8e82bb49false0x0000000000008afdacc486225455281f614843e74812968321050066970130278016492023-04-30T13:25:30.000Z0xda3f9958a608ada8bc875ca0a97b13445c1937c192e0dd0be3f637c5caacfa1a
0xf81b6b8aaad4c37f6f2e8aa9988f28ea8e82bb49false0x0000000000008afdacc486225455281f614843e72812536087119117941580277883432023-04-30T02:19:10.000Z0x4a5247fcc8a23344f73c9a5fb0edd82d3c455f1e4322ba765437f9647e7cfaa5
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Pair_Fees_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_senderlog_indexin_amount0in_amount1block_numberblock_timestamptransaction_hash
0x0d8401cbc650e82d1f21a7461efc6409ef55c4dbfalse0x20a304a7d126758dfe6b243d0fc515f83bca843112824114524889191384109634414061478202257646072023-02-18T04:35:04.000Z0xb1d4cd98bf8266079126427336ce4ef0d03efc27b90f3a3f282e7071314b56eb
0x0d8401cbc650e82d1f21a7461efc6409ef55c4dbfalse0x20a304a7d126758dfe6b243d0fc515f83bca843166428653095557769564867023470205350830257757422023-02-18T14:00:56.000Z0xee267d06de26413c42f642773f66ca084f3a31a2d957450457197f2a780a6d8d
0x0ec098aa4bc6a31e4f804e653f0488eb0feb1a2afalse0x20a304a7d126758dfe6b243d0fc515f83bca84312241040848778997008388825310809501727012257597302023-02-18T00:27:29.000Z0x0668b2d719c4df38721193b7be5b37df9261a142d60c12778e4bae9b3e033876
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Pair_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0InSTRINGAmount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in_amount1InSTRINGAmount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in_amount0OutSTRINGAmount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in_amount1OutSTRINGAmount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressremovedin_senderlog_indexblock_numberin_amount0Inin_amount1Inin_amount0Outin_amount1Outblock_timestamptransaction_hash
0x3214e141bdae08be1f382a885cf3d2a448a5e7800x06589abd54582783142e3d1165722e7e10483de0false0xd4ae6eca985340dd434d38f470accce4dc78d1094926109477015386031241523318687015384520709875338976102023-03-02T07:15:50.000Z0x48e150c577e47897c0b480078c6f1482c047d3e2dcfb9f2bccd705fcc451519f
0x58f876857a02d6762e0101bb5c46a8c1ed44dc160x06589abd54582783142e3d1165722e7e10483de0false0x9b686cfcc1f25738e91fd7777613caa49a9ea3722092612582739150961646948129642900039133905037055084547972023-03-02T21:03:17.000Z0x4feed3bd1f0917a9b4ff672a6c53b9f431c61efbdec7e1dc1e5f5f69915a142b
0x7a78ee74d3fa77eebf56797f9bb3bf06b68781540x06589abd54582783142e3d1165722e7e10483de0false0xd4ae6eca985340dd434d38f470accce4dc78d10915426103300036616857602777007525236618074519355201880202023-03-02T02:04:53.000Z0x576c2be22aebbf9e98ee0c2c30dccaa90e5d4e3f0f077ca5f542c91a47ba3e8a
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Pair_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserve0STRINGReserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
in_reserve1STRINGReserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
addressremovedlog_indexin_reserve0in_reserve1block_numberblock_timestamptransaction_hash
0xa99c4051069b774102d6d215c6a9ba69bd616e6afalse20435913369967083843905973121549019581317870032023-09-16T07:57:20.000Z0x95235d3d141b680177b13632e344128243b6bd61a74eb60721457fb01c97655f
0x1d6c1de20424831fd6f843f1d39bf96265b3899dfalse774732402540370369164853726148154767576317876032023-09-16T08:27:21.000Z0x251f5a2174a30086c15bbb42980fade45afc6c58057e661399b502434d6321c7
0x1d6c1de20424831fd6f843f1d39bf96265b3899dfalse134732563964468465164817399813046898090317877582023-09-16T08:35:06.000Z0x1aad038716ebf5b61d17981f7483c491bb304ff5c9b7a4679a8a9aa8f5dcd74c
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Pair_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressin_fromremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
0xf21dcf85f6abb864b976ee5089ca7c782cf69cb30x04d6115703b0127888323f142b8046c7c13f857d0x0000000000000000000000000000000000000000false8933096238720646605850299290255842023-06-12T03:11:03.000Z0xa6df73d18d5538db2efe65c5ca6407da204e28f2635fe22be0cb9563703d2589
0xe5f912110bb8a7f44634d82775d6106c11043a890x04d6115703b0127888323f142b8046c7c13f857d0xf21dcf85f6abb864b976ee5089ca7c782cf69cb3false8933096238720646605850241290255892023-06-12T03:11:18.000Z0x559c2bed172db5c44dd88667cc27225ffbd37c48cf6dfb6ba86197bf0be2147b
0x6622c4a2885a7a258fb05c2d33a543afdcb375c10x075e794f631ee81df1aadb510ac6ec8803b0fa350x3df96fe4e92f38f7c931fa5a00d1f644d1c60dbffalse3144804949142290352952023-06-12T11:17:53.000Z0x2716231ffd929b8935c00a755f076307ebb485ac3c6d16646fbaaf96c80b2b95
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Pair_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PairFactory_PairCreated_event

Event logs emitted when a new liquidity pool pair is created by a DEX (Decentralized Exchange) factory contract. Records the deployed pair contract address, constituent token addresses, and creation metadata for tracking protocol liquidity expansion.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_stableBOOLBoolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
in_pairSTRINGContract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
in_anon4STRINGSequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.
addressin_pairremovedin_anon4in_stablein_token0in_token1log_indexblock_numberblock_timestamptransaction_hash
0xafd89d21bdb66d00817d4153e055830b1c2b39700x948c553d8c25ad7bd034086f0aae9a9d3c028b90false76false0x4d2d32d8652058bf98c772953e1df5c5c85d9f450xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c151250408712023-01-23T17:08:38.000Z0x4946ddd6e7b0711c8b20c491ae6789d17befea91d733104084e672780e91f346
0xafd89d21bdb66d00817d4153e055830b1c2b39700x1ebdf6e38ae6461ef5c8e97346a02934ba6fad84false292false0x2170ed0880ac9a755fd29b2688956bd959f933f80x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c211324851542023-10-10T15:41:36.000Z0xda1469a90643d28c0bf0267aa9da869012027e0c0ad0a137c00f9fb43333a9d5
0xafd89d21bdb66d00817d4153e055830b1c2b39700x5a797d22b27c13a98df8147acf95771f7b43ac66false251false0xd069599e718f963bd84502b49ba8f8657faf5b3a0xf4c8e32eadec4bfe97e0f595add0f4450a863a1189280324882023-05-08T14:02:45.000Z0xc5d0dda3f9f5395649eed4e7d3f2354ab5ec808b684e6d2b099878df0c9f574e
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.PairFactory_PairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Router_Swap_event

Swap events from Thena V1 decentralized exchange (DEX) router on BNB Smart Chain, capturing token input amounts, pool types (stable/volatile), and participating addresses. Used for analyzing trading volume, routing patterns, and liquidity utilization across Thena’s automated market maker (AMM) pools.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0InSTRINGAmount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
in__tokenInSTRINGContract address of the token being swapped into the pool on BNB Smart Chain. Hex-encoded, 0x-prefixed 40-character string representing the incoming token in Thena v1 Router swap events.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_stableBOOLBoolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
in_toaddressremovedin_senderin_stablelog_indexin__tokenInblock_numberin_amount0Inblock_timestamptransaction_hash
0x0027d02b5b88c41a908b73cce3a6bab4d2e16bd20xd4ae6eca985340dd434d38f470accce4dc78d109false0x0027d02b5b88c41a908b73cce3a6bab4d2e16bd2false2350xe9e7cea3dedca5984780bafc599bd69add087d562654242213000000000000000000002023-03-17T11:57:32.000Z0x7ba250591ade5ec8bad84d25ec656da31f6d9949aee78998f7b67f265c01b062
0x0027d02b5b88c41a908b73cce3a6bab4d2e16bd20xd4ae6eca985340dd434d38f470accce4dc78d109false0x0027d02b5b88c41a908b73cce3a6bab4d2e16bd2false1820x431e0cd023a32532bf3969cddfc002c00e98429d2653693110227251106731244995312023-03-17T07:19:44.000Z0x82b0686fe354349e0bd6651b1a9fda51eca6331cba870a0bb9f93fa6c345214e
0x0038cb35d0d62d56d471636c02af3b83773cc4990xd4ae6eca985340dd434d38f470accce4dc78d109false0x0038cb35d0d62d56d471636c02af3b83773cc499true2040xe80772eaf6e2e18b651f160bc9158b2a5cafca6526544717479044192023-03-17T13:53:16.000Z0x604fe40a18f26ecd99b5b06e79287f4228d9a8e319723bc010a3ef1129b99ec1
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Router_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_DistributeReward_event

Reward distribution events emitted when a Voter contract allocates tokens to gauge contracts. Records the sender address, target gauge contract, and token amount distributed for liquidity mining incentives.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_gaugein_amountin_senderlog_indexblock_numberblock_timestamptransaction_hash
0x62ee96e6365ab515ec647c065c2707d1122d7b26false0x6daddc3e9eccdc6d6ac4bf30c02033501d7b539c118856061454634012350x194f5dac4bc65cbc238023bb191f2605bf12076696259013872023-02-23T00:01:12.000Z0xaad4c876a94bb923266a06f40e622fff7294efc57651920b8fdefad01dd4dc43
0x62ee96e6365ab515ec647c065c2707d1122d7b26false0x9d5f104f53353939dc953687ae0860fb3ea1cfa3178940284812892701910x194f5dac4bc65cbc238023bb191f2605bf120766228259013872023-02-23T00:01:12.000Z0xaad4c876a94bb923266a06f40e622fff7294efc57651920b8fdefad01dd4dc43
0x62ee96e6365ab515ec647c065c2707d1122d7b26false0xb60bffa16da9f5578e041b733b32186f80f0d343355466812069063814920x194f5dac4bc65cbc238023bb191f2605bf120766180259013872023-02-23T00:01:12.000Z0xaad4c876a94bb923266a06f40e622fff7294efc57651920b8fdefad01dd4dc43
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Voter_DistributeReward_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
in_creatorSTRINGAddress of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
in_internal_bribeSTRINGContract address of the internal bribe contract associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
in_external_bribeSTRINGContract address of the external bribe contract associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedin_gaugelog_indexin_creatorblock_numberblock_timestamptransaction_hashin_external_bribein_internal_bribe
0x3a1d0952809f4948d15ebce8d345962a282c4fcb0x51bfc6e47c96d2b8c564b0ddd2c44fc03707cdc7false0x0d739ce843d0584aae800f54685d1fa69cec11902780xdd257d090fa0f9ffb496b790844418593e969ba6289512842023-06-09T13:09:25.000Z0x79f359a9c5e2794dd0f36fb29a08793ca2cfe616fca9d37dc5d51e3590d9a6510x8c1fb9cb10f7bf5b73a29c68824f14003a6494570x237557d5ea86841a634ab4775a2bd5e3c3f8c8c6
0x3a1d0952809f4948d15ebce8d345962a282c4fcb0x2c4166641d5293551190c9f01ac50d0b6abd7086false0x1560d23c5db98d78537253332b067a6b8981e432400xd204e3dc1937d3a30fc6f20abc48ac5506c94d1e304537462023-07-31T20:49:32.000Z0xfd20cfc9453075f5fda34ec05d7a446f6dcb08b1c81af5065252e72bb3e13e0d0x8d4c8b25620dfb89b9f9bd7654252b9bfac8f2d70xa0d6d0f08e5f37c4a91165cf7365e6dcb1926c51
0x3a1d0952809f4948d15ebce8d345962a282c4fcb0xfd66a4a4c921cd7194abab38655476a06fbaea05false0xabed4aaad66583827d5f8b66381d0661a32d3d4d1360x993ae2b514677c7ac52baecd8871d2b362a9d693272826142023-04-12T11:54:40.000Z0xd6d3b53102e0a224be23282c2c3ecf4f4f6e35c8494a967521dd085e2eb1af6c0x1e0d61c4072f8dee0c6e1666bc87d38eaebe93320xd45fc0ee56d9b6f440ed5a705677b5e3398604f1
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Voter_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Voter_NotifyReward_event

Reward distribution events emitted when tokens are allocated to voting gauges in Decentralized Exchange (DEX) voter contracts. Records the sender address, reward token contract, and token amount distributed to incentivize liquidity provision and governance participation.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountin_rewardin_senderlog_indexblock_numberblock_timestamptransaction_hash
0x62ee96e6365ab515ec647c065c2707d1122d7b26false15556054498618068875561960xf4c8e32eadec4bfe97e0f595add0f4450a863a110x86069feb223ee303085a1a505892c9d4bdbee99647270979622023-04-06T00:19:55.000Z0x334615b1d1baa3ec7edc17828e70fb3df186adf6fa78c172fa3b9f2156d7f820
0x62ee96e6365ab515ec647c065c2707d1122d7b26false17374500000000000000000000xf4c8e32eadec4bfe97e0f595add0f4450a863a110x86069feb223ee303085a1a505892c9d4bdbee996171249067122023-01-19T00:00:34.000Z0x6f184654174044ce29fb90fe63b30df29405e04eab5a711e046b2f439557ed64
0x62ee96e6365ab515ec647c065c2707d1122d7b26false16032227693337897777450000xf4c8e32eadec4bfe97e0f595add0f4450a863a110x86069feb223ee303085a1a505892c9d4bdbee99636264999662023-03-16T00:01:14.000Z0x79d2a2f917466e2be2f58dfeadfe4549e9f628de5cef5970f14434229f0df58d
Query with partition filter
SELECT *
FROM `tt-contracts.thena_v1_bsc.Voter_NotifyReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100