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.Columns
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. | |
trace_address | STRING | Hierarchical 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. | |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. | |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. | |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. | |
value | NUMERIC | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). | |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. | |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. | |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. | |
in__owner | STRING | Address of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string. | |
in__token0 | STRING | Contract 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__token1 | STRING | Contract 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__type | STRING | Descriptive label for the bribe contract being created, typically indicating the protocol name, purpose (LP Fees or Bribes), and token pair. Follows format “Thena [LP Fees | Bribes]: [token0]-[token1]” as seen in sample values like “Thena Bribes: aLVL-WBNB”. |
out_anon0 | STRING | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| gas | value | status | gas_used | in__type | in__owner | out_anon0 | signature | in__token0 | in__token1 | to_address | block_number | from_address | trace_address | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13154091 | 0 | true | 2600957 | Thena LP Fees: aANKRBNB-BTCB | 0x46f99291eedf25fd5c6ae56bbfd6679d0ea3630b | 0x8b1d9bc54426dee13ba7642c01a47818da23053a | 0x0000e66b | 0x52f24a5e03aee338da5fd9df68d2b6fae1178827 | 0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c | 0xd50ceab3071c61c85d04bdd65feb12fee7c91375 | 29465387 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0,7 | 2023-06-27T10:43:11.000Z | 0x58d6c85bdea208b829283026b723d39406636a5f5a1feebac7e00dc70da43588 |
| 10587357 | 0 | true | 2592557 | Thena Bribes: aANKRBNB-BTCB | 0x46f99291eedf25fd5c6ae56bbfd6679d0ea3630b | 0x776c5f3a15fe0cae24876d766a88a33ffe04df1e | 0x0000e66b | 0x52f24a5e03aee338da5fd9df68d2b6fae1178827 | 0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c | 0xd50ceab3071c61c85d04bdd65feb12fee7c91375 | 29465387 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0,9 | 2023-06-27T10:43:11.000Z | 0x58d6c85bdea208b829283026b723d39406636a5f5a1feebac7e00dc70da43588 |
| 10636866 | 0 | true | 2612613 | Thena Bribes: aANKRBNB-ANKRMATIC | 0x46f99291eedf25fd5c6ae56bbfd6679d0ea3630b | 0x108b3289871be664dbf7b1d0ad5be092b3bf88a7 | 0x0000e66b | 0x52f24a5e03aee338da5fd9df68d2b6fae1178827 | 0x738d96caf7096659db4c1afbf1e1bdfd281f388c | 0xd50ceab3071c61c85d04bdd65feb12fee7c91375 | 29465396 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0,9 | 2023-06-27T10:43:38.000Z | 0x16f55fcd81dbf2b46bfef21127567423aa2c3277ccd2b8558c34d9ea13f9ced5 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | NUMERIC | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__rewardsToken | STRING | Contract 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_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| gas | value | status | gas_used | in_reward | signature | to_address | block_number | from_address | trace_address | block_timestamp | in__rewardsToken | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 485358 | 0 | true | 63643 | 43750631623878926941 | 0xb66503cf | 0xafdf574241eaecaf561cc8912820138af94ee1b6 | 33188695 | 0x2fb44fb6ee322d6198144e99d67e066a6d90c3fe | 0,23,0 | 2023-11-04T04:09:10.000Z | 0x54c331bb7d32fbfc17bc9accab2e2d12d0d1b222 | 0x85b0830f797859632c8086cafa81183d8cbe41f226473300ca3de2db22c89cb1 |
| 1268741 | 0 | true | 63643 | 110411664850812837712 | 0xb66503cf | 0xafdf574241eaecaf561cc8912820138af94ee1b6 | 33197574 | 0x2fb44fb6ee322d6198144e99d67e066a6d90c3fe | 0,0,0,2,0,0,0,2,0,20,0 | 2023-11-04T11:33:54.000Z | 0x54c331bb7d32fbfc17bc9accab2e2d12d0d1b222 | 0xab5c9787fc9fc5915f9c0670c765fe5c0a4697a74df650cc493ac2b1f77e339d |
| 331475 | 0 | true | 63643 | 7108424761506579502 | 0xb66503cf | 0xafdf574241eaecaf561cc8912820138af94ee1b6 | 33191169 | 0x2fb44fb6ee322d6198144e99d67e066a6d90c3fe | 0,48,0 | 2023-11-04T06:12:59.000Z | 0x54c331bb7d32fbfc17bc9accab2e2d12d0d1b222 | 0xb6f4e33aa1e194f82b3919fbeb409d927312dc9046b160d4187319afb98859c8 |
Example Query
Example Query
Query with partition filter
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.Columns
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_rewardToken | STRING | Contract address of the reward token being distributed or claimed. 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. |
in_startTimestamp | STRING | Unix 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. |
Sample Data
Sample Data
| address | removed | in_reward | log_index | block_number | in_rewardToken | block_timestamp | transaction_hash | in_startTimestamp |
|---|---|---|---|---|---|---|---|---|
| 0x7548b58f27107ac7cf5fd992bc76ac857cb16fc6 | false | 31250000000000000000000 | 432 | 28524588 | 0x0b15ddf19d47e6a86a56148fb4afffc6929bcb89 | 2023-05-25T16:49:07.000Z | 0x390405de935520799f7d2b51bff68b6793836e2141eefa1b335ab7588080b2f8 | 1685577600 |
| 0xb98fea13b785e559300abb2b0a091e7d0d8ac9d2 | false | 650000000000000000000 | 115 | 28517117 | 0x3bc5ac0dfdc871b365d159f728dd1b9a0b5481e8 | 2023-05-25T10:34:57.000Z | 0x1d9ed61954b7cce2cf29c0a9979958cfe1a855f5bf6361921dc1ceb54b722a25 | 1685577600 |
| 0x9165aa77e7ce3f6a528990b06eee357e445cb033 | false | 250000000000000000000 | 219 | 28524161 | 0x3bc5ac0dfdc871b365d159f728dd1b9a0b5481e8 | 2023-05-25T16:27:46.000Z | 0x76e1340467f2a8ffafcc047a6c7709e6f7bea17eefce56d74a6f9ce01317eca2 | 1685577600 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_rewardsToken | STRING | Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string. |
in_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | in_user | removed | in_reward | log_index | block_number | block_timestamp | in_rewardsToken | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xae6b5316b84ffb5341ce1e1495d685e329bfee01 | 0x28aa4f9ffe21365473b64c161b566c3cdead0108 | false | 423279850456550502781630 | 146 | 31526985 | 2023-09-07T06:43:32.000Z | 0x74ccbe53f77b08632ce0cb91d3a545bf6b8e0979 | 0x02facabdf6327ea964c5b6dbda4eaa95a7c9ed4ccf5535f09220207165b77571 |
| 0x7548b58f27107ac7cf5fd992bc76ac857cb16fc6 | 0x86e0a272a08db7875e8fc2bda6836c1ce670b8bd | false | 175756864260991994011 | 210 | 31531253 | 2023-09-07T10:17:24.000Z | 0x0b15ddf19d47e6a86a56148fb4afffc6929bcb89 | 0x059eaf7b6a6f033ce9e208880504ff54d6fae77d99ce310d4ba388c072f635bb |
| 0x49c49c10ad25949388e191838ff7a9430fd6ced7 | 0x0faa92ab469db5d268fd37c2f1f5e39f72b0e3b3 | false | 1821381446029996411299 | 207 | 31519716 | 2023-09-07T00:39:40.000Z | 0xf4bafaeae73a4a7c8b6479970075e91e641fb1fc | 0x1605d3a2ec865f0f79e96b3cae66cc7b16541c48298908b7b8ffecb632d61fb5 |
Example Query
Example Query
Query with partition filter
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.Columns
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_stable | BOOL | Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values. |
in_pair | STRING | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
in_anon4 | STRING | Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value. |
Sample Data
Sample Data
| address | in_pair | removed | in_anon4 | in_stable | in_token0 | in_token1 | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xafd89d21bdb66d00817d4153e055830b1c2b3970 | 0x535aeeab656c0fbb07da64fe4aa3a15dfc6834c8 | false | 84 | false | 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d | 0xad29abb318791d579433d831ed122afeaf29dcfe | 217 | 25261448 | 2023-01-31T11:48:36.000Z | 0x1d31e44e5b393221a2af8bb92fdb75bdf36881ccda4a5af88a9f4e617ecef922 |
| 0xafd89d21bdb66d00817d4153e055830b1c2b3970 | 0x928fe97eee1f921d80f25dc2eea1df280704fd03 | false | 85 | false | 0xa8cd6e4bf45724d3ac27f9e31e47ba4e399a7b52 | 0xe9e7cea3dedca5984780bafc599bd69add087d56 | 276 | 25265780 | 2023-01-31T15:31:56.000Z | 0x97c5011e9d348e3b3d0b24159a44d25c5079710a8ddccb321f0278c92129e598 |
| 0xafd89d21bdb66d00817d4153e055830b1c2b3970 | 0x6190e79064213e6a2997355153f57904fb4910c3 | false | 137 | false | 0x431e0cd023a32532bf3969cddfc002c00e98429d | 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d | 152 | 25802944 | 2023-02-19T12:59:41.000Z | 0xa4dd3d36d8c86a5dd4fd7fa7a95e324343993807eaf10f0c8ec760d5081e34ca |
Example Query
Example Query
Query with partition filter
Gauge_Harvest_event
No description available.Columns
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
Sample Data
No sample data available.
Example Query
Example Query
Query with partition filter
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.Columns
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. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | NUMERIC | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__rewardToken | STRING | Contract 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__ve | STRING | Contract 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__token | STRING | Contract address of the token. Hex-encoded, 0x-prefixed, 42-character string. |
in__distribution | STRING | Contract 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_bribe | STRING | Contract 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_bribe | STRING | Contract 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_anon6 | BOOL | Boolean 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_anon0 | STRING | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| gas | value | in__ve | status | gas_used | in_anon6 | in__token | out_anon0 | signature | to_address | block_number | from_address | trace_address | block_timestamp | in__rewardToken | in__distribution | transaction_hash | in__external_bribe | in__internal_bribe |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20974628 | 0 | 0xfbbf371c9b0b994eebfcc977cef603f7f31c070d | true | 3470744 | true | 0xa0ae511748c9b8876cd686234842277bbf919a14 | 0xe88c4dd1a77a9763c6df09d61c2de074b7d0edf4 | 0x7379e770 | 0xb065e4f5d71a55a4e4fc2bd871b36e33053cabeb | 30097168 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0,46 | 2023-07-19T10:48:11.000Z | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x8cad03ba4bacf30394d6277baf44047483a541907f5b83d58902d4730256ee3b | 0x1fe98d43a07cbd77963d51baa5bc18fc98a32c62 | 0x5f1c0335b99da38a2f03cc532b7a032a025cd525 |
| 29640097 | 0 | 0xfbbf371c9b0b994eebfcc977cef603f7f31c070d | true | 3470744 | true | 0x5a27771713631d7e3c0f1e781ac1d48f2b76458d | 0xea6db89ba474dc659b00fac41b6facdca94a86d3 | 0x7379e770 | 0xb065e4f5d71a55a4e4fc2bd871b36e33053cabeb | 30097168 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0,34 | 2023-07-19T10:48:11.000Z | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x8cad03ba4bacf30394d6277baf44047483a541907f5b83d58902d4730256ee3b | 0x28953340100b43951043e15fbe3e7c6f097e5dbf | 0xb356891444f65aa1256c76b367a1bff701db1fe2 |
| 38305560 | 0 | 0xfbbf371c9b0b994eebfcc977cef603f7f31c070d | true | 3470744 | true | 0x88db83b049e6996b7d599cd14665e2a875b61974 | 0x637bfc4c53b26f0ad287401b2477bf1af9cb7a00 | 0x7379e770 | 0xb065e4f5d71a55a4e4fc2bd871b36e33053cabeb | 30097168 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0,22 | 2023-07-19T10:48:11.000Z | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x8cad03ba4bacf30394d6277baf44047483a541907f5b83d58902d4730256ee3b | 0xda447227a7670020c621f82497e25710517ad589 | 0x30ada95e13a1ea116d80c79d9ad94f5f22de60ce |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | NUMERIC | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__rewardsToken | STRING | Contract 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_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| gas | value | status | gas_used | in_reward | signature | to_address | block_number | from_address | trace_address | block_timestamp | in__rewardsToken | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27292209 | 0 | true | 48601 | 129274770029098216 | 0xb66503cf | 0x52d96d104b3957ee03540ef036cb661127653e0f | 29703875 | 0x08de2140aa0b2ab6011a8fc7d6755bec0903caf2 | 0,541,0,99,5 | 2023-07-05T18:06:52.000Z | 0x52f24a5e03aee338da5fd9df68d2b6fae1178827 | 0xeb6ac4f2c1cfba202fd059fc981f57a5dd099077e278788644ba60c84bcd17b3 |
| 27212248 | 0 | true | 43604 | 122167195706091628774 | 0xb66503cf | 0x52d96d104b3957ee03540ef036cb661127653e0f | 29703875 | 0x08de2140aa0b2ab6011a8fc7d6755bec0903caf2 | 0,541,0,99,8 | 2023-07-05T18:06:52.000Z | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 0xeb6ac4f2c1cfba202fd059fc981f57a5dd099077e278788644ba60c84bcd17b3 |
| 24970851 | 0 | true | 47844 | 22915734487039877692 | 0xb66503cf | 0x512a4fe3df6d1a960193b8a62c2e413ddfcc87dc | 29703875 | 0x0a9555e82166a99a8cc9fdc23cd5cb88d6be278a | 0,541,0,111,4 | 2023-07-05T18:06:52.000Z | 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d | 0xeb6ac4f2c1cfba202fd059fc981f57a5dd099077e278788644ba60c84bcd17b3 |
Example Query
Example Query
Query with partition filter
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.Columns
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_rewardToken | STRING | Contract address of the reward token being distributed or claimed. 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. |
in_startTimestamp | STRING | Unix 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. |
Sample Data
Sample Data
| address | removed | in_reward | log_index | block_number | in_rewardToken | block_timestamp | transaction_hash | in_startTimestamp |
|---|---|---|---|---|---|---|---|---|
| 0xc7cd651ca104477b024d6af1143b1f11ddb79362 | false | 5731645404072899 | 620 | 31650606 | 0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c | 2023-09-11T14:00:06.000Z | 0x01f85a8bcab3e536049c294f0a6181ca0169c064e2d53456e68b68b7bc1e538a | 1694649600 |
| 0x070022e35f22f9df8ebb1dad9c169d5e0c16873d | false | 18527044528671624 | 533 | 31650606 | 0x55d398326f99059ff775485246999027b3197955 | 2023-09-11T14:00:06.000Z | 0x01f85a8bcab3e536049c294f0a6181ca0169c064e2d53456e68b68b7bc1e538a | 1694649600 |
| 0x18548bcf71bd9d71820af952dc89abd5f298abd9 | false | 3232271644813480982 | 550 | 31650606 | 0x55d398326f99059ff775485246999027b3197955 | 2023-09-11T14:00:06.000Z | 0x01f85a8bcab3e536049c294f0a6181ca0169c064e2d53456e68b68b7bc1e538a | 1694649600 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_rewardsToken | STRING | Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string. |
in_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | in_user | removed | in_reward | log_index | block_number | block_timestamp | in_rewardsToken | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xaa9c6d5b6769fcb017411d0b1247bf55bf954983 | 0x0c181073b52bfe6cab3bf5d5dba36d4ed7131a5c | false | 777799433196351 | 284 | 31251167 | 2023-08-28T15:54:08.000Z | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 0x4f9a1db1f381b8f5369c334ecaabb476ac9789b794f1cbaa41b53a8cd42ea220 |
| 0xaa9c6d5b6769fcb017411d0b1247bf55bf954983 | 0x0c181073b52bfe6cab3bf5d5dba36d4ed7131a5c | false | 29738110449931471 | 282 | 31251167 | 2023-08-28T15:54:08.000Z | 0xa045e37a0d1dd3a45fefb8803d22457abc0a728a | 0x4f9a1db1f381b8f5369c334ecaabb476ac9789b794f1cbaa41b53a8cd42ea220 |
| 0xb2fe5f1bab7181892305f411ca5f5678a3248004 | 0x1de1ecbb8db25752d52c346aa4eeb9359ab5886e | false | 80656768620937382 | 69 | 31257439 | 2023-08-28T21:08:05.000Z | 0x0782b6d8c4551b9760e74c0545a9bcd90bdc41e5 | 0x56bc5a9834809a5e320d6ca8c998310ebf24c24f3a75c05e0e99632340aeca2b |
Example Query
Example Query
Query with partition filter
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.Columns
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_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_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_to | address | removed | in_sender | log_index | in_amount0 | in_amount1 | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x9ddf69b3195f6d6074bb4fe9fd4ebe1446ac5b43 | 0xeb58a4d07990ff50b9f8289701cbddf9052570b5 | false | 0x9ddf69b3195f6d6074bb4fe9fd4ebe1446ac5b43 | 67 | 179101531928354975951 | 100784595672525164864 | 32258841 | 2023-10-02T18:20:51.000Z | 0xdcadbd7b3484e4fafe7b8ad4b28a4f41a7212e4ad724974a3796f1399de83a71 |
| 0x9ddf69b3195f6d6074bb4fe9fd4ebe1446ac5b43 | 0x7e61c053527a7af0c700ad9d2c8207e386273222 | false | 0x9ddf69b3195f6d6074bb4fe9fd4ebe1446ac5b43 | 61 | 1224857558245577703403 | 1096265987817490824101 | 32260217 | 2023-10-02T19:29:42.000Z | 0xd1faae31725849cac526b5aa60175f691b5df71434dd23e05e2e0bf939c90efd |
| 0xd4ae6eca985340dd434d38f470accce4dc78d109 | 0x63db6ba9e512186c2faadacef342fb4a40dc577c | false | 0xd4ae6eca985340dd434d38f470accce4dc78d109 | 54 | 278553158282623676 | 570721035521041282424 | 32255461 | 2023-10-02T15:31:16.000Z | 0x814d8261e5249c3733f82b018ba881908accf71985aa97edcf0101b4c44de420 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
Sample Data
| address | removed | in_sender | log_index | in_amount0 | in_amount1 | block_number | in_recipient | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xd714206a7d63f5a2d613064815995e9cc7061988 | false | 0x4d3a031609178e15acda43855a7cd7f7421c6a8d | 857 | 7291660621564186 | 14674064173540642 | 29642785 | 0x4d3a031609178e15acda43855a7cd7f7421c6a8d | 2023-07-03T14:59:09.000Z | 0x2859701ebe5acc6eb1bce02688048dc659b1707863a59f188a8ba3be549c632c |
| 0xb8a85b80a12931fe2a1f5db9295fbdae03616e9b | false | 0xd66207f31737b77070f3a593224fdebaece467bd | 616 | 62993307923844 | 211904074714096102 | 29642775 | 0xd66207f31737b77070f3a593224fdebaece467bd | 2023-07-03T14:58:39.000Z | 0x3e72c14fa0da5c134c94003f00e6aef76843f9537f7a7a7ff960efdf85a441ff |
| 0x80551245c562380140668b7df20a7e9c773d21bd | false | 0xe30ee861202664395ea440cdf08d6a4e9c09d7e9 | 1332 | 322861 | 396561614006845899 | 29642775 | 0xe30ee861202664395ea440cdf08d6a4e9c09d7e9 | 2023-07-03T14:58:39.000Z | 0x3e72c14fa0da5c134c94003f00e6aef76843f9537f7a7a7ff960efdf85a441ff |
Example Query
Example Query
Query with partition filter
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.Columns
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_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
Sample Data
| address | removed | in_sender | log_index | in_amount0 | in_amount1 | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xf81b6b8aaad4c37f6f2e8aa9988f28ea8e82bb49 | false | 0x0000000000008afdacc486225455281f614843e7 | 40 | 1015765499665536641 | 0 | 27793432 | 2023-04-30T06:34:10.000Z | 0x6000c5f342f473ece23f34986ed2fbffe1ea1a23c456eccbe9650d92f61ce89f |
| 0xf81b6b8aaad4c37f6f2e8aa9988f28ea8e82bb49 | false | 0x0000000000008afdacc486225455281f614843e7 | 48 | 1296832105006697013 | 0 | 27801649 | 2023-04-30T13:25:30.000Z | 0xda3f9958a608ada8bc875ca0a97b13445c1937c192e0dd0be3f637c5caacfa1a |
| 0xf81b6b8aaad4c37f6f2e8aa9988f28ea8e82bb49 | false | 0x0000000000008afdacc486225455281f614843e7 | 28 | 1253608711911794158 | 0 | 27788343 | 2023-04-30T02:19:10.000Z | 0x4a5247fcc8a23344f73c9a5fb0edd82d3c455f1e4322ba765437f9647e7cfaa5 |
Example Query
Example Query
Query with partition filter
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.Columns
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_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
Sample Data
| address | removed | in_sender | log_index | in_amount0 | in_amount1 | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x0d8401cbc650e82d1f21a7461efc6409ef55c4db | false | 0x20a304a7d126758dfe6b243d0fc515f83bca8431 | 128 | 2411452488919138 | 4109634414061478202 | 25764607 | 2023-02-18T04:35:04.000Z | 0xb1d4cd98bf8266079126427336ce4ef0d03efc27b90f3a3f282e7071314b56eb |
| 0x0d8401cbc650e82d1f21a7461efc6409ef55c4db | false | 0x20a304a7d126758dfe6b243d0fc515f83bca8431 | 664 | 2865309555776956 | 4867023470205350830 | 25775742 | 2023-02-18T14:00:56.000Z | 0xee267d06de26413c42f642773f66ca084f3a31a2d957450457197f2a780a6d8d |
| 0x0ec098aa4bc6a31e4f804e653f0488eb0feb1a2a | false | 0x20a304a7d126758dfe6b243d0fc515f83bca8431 | 224 | 104084877899700838 | 8825310809501727012 | 25759730 | 2023-02-18T00:27:29.000Z | 0x0668b2d719c4df38721193b7be5b37df9261a142d60c12778e4bae9b3e033876 |
Example Query
Example Query
Query with partition filter
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.Columns
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_amount0In | STRING | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
in_amount1In | STRING | Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
in_amount0Out | STRING | Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
in_amount1Out | STRING | Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
in_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_to | address | removed | in_sender | log_index | block_number | in_amount0In | in_amount1In | in_amount0Out | in_amount1Out | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x3214e141bdae08be1f382a885cf3d2a448a5e780 | 0x06589abd54582783142e3d1165722e7e10483de0 | false | 0xd4ae6eca985340dd434d38f470accce4dc78d109 | 49 | 26109477 | 0 | 153860312415233186870 | 153845207098753389761 | 0 | 2023-03-02T07:15:50.000Z | 0x48e150c577e47897c0b480078c6f1482c047d3e2dcfb9f2bccd705fcc451519f |
| 0x58f876857a02d6762e0101bb5c46a8c1ed44dc16 | 0x06589abd54582783142e3d1165722e7e10483de0 | false | 0x9b686cfcc1f25738e91fd7777613caa49a9ea372 | 209 | 26125827 | 3915096164694812964290 | 0 | 0 | 3913390503705508454797 | 2023-03-02T21:03:17.000Z | 0x4feed3bd1f0917a9b4ff672a6c53b9f431c61efbdec7e1dc1e5f5f69915a142b |
| 0x7a78ee74d3fa77eebf56797f9bb3bf06b6878154 | 0x06589abd54582783142e3d1165722e7e10483de0 | false | 0xd4ae6eca985340dd434d38f470accce4dc78d109 | 154 | 26103300 | 0 | 366168576027770075252 | 366180745193552018802 | 0 | 2023-03-02T02:04:53.000Z | 0x576c2be22aebbf9e98ee0c2c30dccaa90e5d4e3f0f077ca5f542c91a47ba3e8a |
Example Query
Example Query
Query with partition filter
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.Columns
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_reserve0 | STRING | Reserve 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_reserve1 | STRING | Reserve 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. |
Sample Data
Sample Data
| address | removed | log_index | in_reserve0 | in_reserve1 | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xa99c4051069b774102d6d215c6a9ba69bd616e6a | false | 204 | 3591336996708 | 3843905973121549019581 | 31787003 | 2023-09-16T07:57:20.000Z | 0x95235d3d141b680177b13632e344128243b6bd61a74eb60721457fb01c97655f |
| 0x1d6c1de20424831fd6f843f1d39bf96265b3899d | false | 774 | 732402540370369 | 164853726148154767576 | 31787603 | 2023-09-16T08:27:21.000Z | 0x251f5a2174a30086c15bbb42980fade45afc6c58057e661399b502434d6321c7 |
| 0x1d6c1de20424831fd6f843f1d39bf96265b3899d | false | 134 | 732563964468465 | 164817399813046898090 | 31787758 | 2023-09-16T08:35:06.000Z | 0x1aad038716ebf5b61d17981f7483c491bb304ff5c9b7a4679a8a9aa8f5dcd74c |
Example Query
Example Query
Query with partition filter
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.Columns
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_from | STRING | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_to | STRING | Destination address receiving tokens or assets in the operation. 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
Sample Data
| in_to | address | in_from | removed | in_amount | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xf21dcf85f6abb864b976ee5089ca7c782cf69cb3 | 0x04d6115703b0127888323f142b8046c7c13f857d | 0x0000000000000000000000000000000000000000 | false | 8933096238720646605850 | 299 | 29025584 | 2023-06-12T03:11:03.000Z | 0xa6df73d18d5538db2efe65c5ca6407da204e28f2635fe22be0cb9563703d2589 |
| 0xe5f912110bb8a7f44634d82775d6106c11043a89 | 0x04d6115703b0127888323f142b8046c7c13f857d | 0xf21dcf85f6abb864b976ee5089ca7c782cf69cb3 | false | 8933096238720646605850 | 241 | 29025589 | 2023-06-12T03:11:18.000Z | 0x559c2bed172db5c44dd88667cc27225ffbd37c48cf6dfb6ba86197bf0be2147b |
| 0x6622c4a2885a7a258fb05c2d33a543afdcb375c1 | 0x075e794f631ee81df1aadb510ac6ec8803b0fa35 | 0x3df96fe4e92f38f7c931fa5a00d1f644d1c60dbf | false | 3144804949 | 142 | 29035295 | 2023-06-12T11:17:53.000Z | 0x2716231ffd929b8935c00a755f076307ebb485ac3c6d16646fbaaf96c80b2b95 |
Example Query
Example Query
Query with partition filter
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.Columns
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_stable | BOOL | Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values. |
in_pair | STRING | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
in_anon4 | STRING | Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value. |
Sample Data
Sample Data
| address | in_pair | removed | in_anon4 | in_stable | in_token0 | in_token1 | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xafd89d21bdb66d00817d4153e055830b1c2b3970 | 0x948c553d8c25ad7bd034086f0aae9a9d3c028b90 | false | 76 | false | 0x4d2d32d8652058bf98c772953e1df5c5c85d9f45 | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 151 | 25040871 | 2023-01-23T17:08:38.000Z | 0x4946ddd6e7b0711c8b20c491ae6789d17befea91d733104084e672780e91f346 |
| 0xafd89d21bdb66d00817d4153e055830b1c2b3970 | 0x1ebdf6e38ae6461ef5c8e97346a02934ba6fad84 | false | 292 | false | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c | 211 | 32485154 | 2023-10-10T15:41:36.000Z | 0xda1469a90643d28c0bf0267aa9da869012027e0c0ad0a137c00f9fb43333a9d5 |
| 0xafd89d21bdb66d00817d4153e055830b1c2b3970 | 0x5a797d22b27c13a98df8147acf95771f7b43ac66 | false | 251 | false | 0xd069599e718f963bd84502b49ba8f8657faf5b3a | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 89 | 28032488 | 2023-05-08T14:02:45.000Z | 0xc5d0dda3f9f5395649eed4e7d3f2354ab5ec808b684e6d2b099878df0c9f574e |
Example Query
Example Query
Query with partition filter
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.Columns
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_amount0In | STRING | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
in__tokenIn | STRING | Contract 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_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_stable | BOOL | Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values. |
Sample Data
Sample Data
| in_to | address | removed | in_sender | in_stable | log_index | in__tokenIn | block_number | in_amount0In | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x0027d02b5b88c41a908b73cce3a6bab4d2e16bd2 | 0xd4ae6eca985340dd434d38f470accce4dc78d109 | false | 0x0027d02b5b88c41a908b73cce3a6bab4d2e16bd2 | false | 235 | 0xe9e7cea3dedca5984780bafc599bd69add087d56 | 26542422 | 1300000000000000000000 | 2023-03-17T11:57:32.000Z | 0x7ba250591ade5ec8bad84d25ec656da31f6d9949aee78998f7b67f265c01b062 |
| 0x0027d02b5b88c41a908b73cce3a6bab4d2e16bd2 | 0xd4ae6eca985340dd434d38f470accce4dc78d109 | false | 0x0027d02b5b88c41a908b73cce3a6bab4d2e16bd2 | false | 182 | 0x431e0cd023a32532bf3969cddfc002c00e98429d | 26536931 | 1022725110673124499531 | 2023-03-17T07:19:44.000Z | 0x82b0686fe354349e0bd6651b1a9fda51eca6331cba870a0bb9f93fa6c345214e |
| 0x0038cb35d0d62d56d471636c02af3b83773cc499 | 0xd4ae6eca985340dd434d38f470accce4dc78d109 | false | 0x0038cb35d0d62d56d471636c02af3b83773cc499 | true | 204 | 0xe80772eaf6e2e18b651f160bc9158b2a5cafca65 | 26544717 | 47904419 | 2023-03-17T13:53:16.000Z | 0x604fe40a18f26ecd99b5b06e79287f4228d9a8e319723bc010a3ef1129b99ec1 |
Example Query
Example Query
Query with partition filter
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.Columns
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
Sample Data
| address | removed | in_gauge | in_amount | in_sender | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x62ee96e6365ab515ec647c065c2707d1122d7b26 | false | 0x6daddc3e9eccdc6d6ac4bf30c02033501d7b539c | 11885606145463401235 | 0x194f5dac4bc65cbc238023bb191f2605bf120766 | 96 | 25901387 | 2023-02-23T00:01:12.000Z | 0xaad4c876a94bb923266a06f40e622fff7294efc57651920b8fdefad01dd4dc43 |
| 0x62ee96e6365ab515ec647c065c2707d1122d7b26 | false | 0x9d5f104f53353939dc953687ae0860fb3ea1cfa3 | 17894028481289270191 | 0x194f5dac4bc65cbc238023bb191f2605bf120766 | 228 | 25901387 | 2023-02-23T00:01:12.000Z | 0xaad4c876a94bb923266a06f40e622fff7294efc57651920b8fdefad01dd4dc43 |
| 0x62ee96e6365ab515ec647c065c2707d1122d7b26 | false | 0xb60bffa16da9f5578e041b733b32186f80f0d343 | 35546681206906381492 | 0x194f5dac4bc65cbc238023bb191f2605bf120766 | 180 | 25901387 | 2023-02-23T00:01:12.000Z | 0xaad4c876a94bb923266a06f40e622fff7294efc57651920b8fdefad01dd4dc43 |
Example Query
Example Query
Query with partition filter
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
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
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 | 0x51bfc6e47c96d2b8c564b0ddd2c44fc03707cdc7 | false | 0x0d739ce843d0584aae800f54685d1fa69cec1190 | 278 | 0xdd257d090fa0f9ffb496b790844418593e969ba6 | 28951284 | 2023-06-09T13:09:25.000Z | 0x79f359a9c5e2794dd0f36fb29a08793ca2cfe616fca9d37dc5d51e3590d9a651 | 0x8c1fb9cb10f7bf5b73a29c68824f14003a649457 | 0x237557d5ea86841a634ab4775a2bd5e3c3f8c8c6 |
| 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x2c4166641d5293551190c9f01ac50d0b6abd7086 | false | 0x1560d23c5db98d78537253332b067a6b8981e432 | 40 | 0xd204e3dc1937d3a30fc6f20abc48ac5506c94d1e | 30453746 | 2023-07-31T20:49:32.000Z | 0xfd20cfc9453075f5fda34ec05d7a446f6dcb08b1c81af5065252e72bb3e13e0d | 0x8d4c8b25620dfb89b9f9bd7654252b9bfac8f2d7 | 0xa0d6d0f08e5f37c4a91165cf7365e6dcb1926c51 |
| 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0xfd66a4a4c921cd7194abab38655476a06fbaea05 | false | 0xabed4aaad66583827d5f8b66381d0661a32d3d4d | 136 | 0x993ae2b514677c7ac52baecd8871d2b362a9d693 | 27282614 | 2023-04-12T11:54:40.000Z | 0xd6d3b53102e0a224be23282c2c3ecf4f4f6e35c8494a967521dd085e2eb1af6c | 0x1e0d61c4072f8dee0c6e1666bc87d38eaebe9332 | 0xd45fc0ee56d9b6f440ed5a705677b5e3398604f1 |
Example Query
Example Query
Query with partition filter
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.Columns
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_reward | STRING | Contract address of the reward token being distributed or claimed. 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
Sample Data
| address | removed | in_amount | in_reward | in_sender | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x62ee96e6365ab515ec647c065c2707d1122d7b26 | false | 1555605449861806887556196 | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 0x86069feb223ee303085a1a505892c9d4bdbee996 | 47 | 27097962 | 2023-04-06T00:19:55.000Z | 0x334615b1d1baa3ec7edc17828e70fb3df186adf6fa78c172fa3b9f2156d7f820 |
| 0x62ee96e6365ab515ec647c065c2707d1122d7b26 | false | 1737450000000000000000000 | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 0x86069feb223ee303085a1a505892c9d4bdbee996 | 171 | 24906712 | 2023-01-19T00:00:34.000Z | 0x6f184654174044ce29fb90fe63b30df29405e04eab5a711e046b2f439557ed64 |
| 0x62ee96e6365ab515ec647c065c2707d1122d7b26 | false | 1603222769333789777745000 | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 0x86069feb223ee303085a1a505892c9d4bdbee996 | 36 | 26499966 | 2023-03-16T00:01:14.000Z | 0x79d2a2f917466e2be2f58dfeadfe4549e9f628de5cef5970f14434229f0df58d |
Example Query
Example Query
Query with partition filter