> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# thruster_v1_blast
> Tables in tt-contracts.thruster_v1_blast
## Tables
### CurveFeeDistributor\_CheckpointToken\_event
Token checkpoint events from Thruster V1's Curve-style fee distributor contract on Blast. Records periodic snapshots of accumulated fee tokens for calculating pro-rata distributions to liquidity providers and stakers.
| 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_time` | `STRING` | Unix timestamp representing the time of the event or operation. Integer value stored as string, representing seconds since epoch (January 1, 1970 00:00:00 UTC). |
| `in_tokens` | `STRING` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. |
| address | in\_time | removed | in\_tokens | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ---------- | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaafa3db42ea9c114c36a2a033e04c8bc0813c65c | 1731483633 | false | 28527884366782900851 | 2 | 11336909 | 2024-11-13T07:40:33.000Z | 0xa3a0d47e1376abcc9626754c4ef929b5976cb89913d2310fd6da44f1fd208a2e |
| 0xaafa3db42ea9c114c36a2a033e04c8bc0813c65c | 1729921995 | false | 18445682824960694842 | 12 | 10556090 | 2024-10-26T05:53:15.000Z | 0xa530708e18fb8a1a8dabed49e6e1670eb6a7f97e47831316c8c50bababcf39e2 |
| 0xaafa3db42ea9c114c36a2a033e04c8bc0813c65c | 1730636061 | false | 19746634934750044591 | 22 | 10913123 | 2024-11-03T12:14:21.000Z | 0xd8f90cc5be04519d3cfdf029012df6bbc0ace35a6ed822e642a7c4d492d05a85 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.CurveFeeDistributor_CheckpointToken_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CurveFeeDistributor\_Claimed\_event
Fee claim events from Thruster V1's Curve-style fee distributor on Blast. Records epoch-based reward distributions with recipient addresses and claim amounts for analyzing liquidity provider incentive collection patterns.
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or 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. |
| `in_claim_epoch` | `STRING` | Epoch number being claimed by the recipient in this fee distribution event. Represents the specific reward period for which accumulated fees are being withdrawn. |
| `in_max_epoch` | `STRING` | Latest epoch available for claiming at the time of this transaction. Defines the upper bound of the epoch range that the recipient can claim fees from. |
| address | removed | in\_amount | log\_index | block\_number | in\_max\_epoch | in\_recipient | in\_claim\_epoch | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | -------------- | ------------------------------------------ | ---------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaafa3db42ea9c114c36a2a033e04c8bc0813c65c | false | 572930432078174932 | 12 | 10606946 | 1 | 0x0da8af128e39776cf0a10dfdb9f70fe3490094de | 1 | 2024-10-27T10:08:27.000Z | 0x67b062f3dfda85d1e3566763e6459bc322302f40bbc452047a76753b8353a81f |
| 0xaafa3db42ea9c114c36a2a033e04c8bc0813c65c | false | 4307635410059005612 | 16 | 10602451 | 2 | 0xd8e1cb737bd1608ec9ee19e8d00f2d9e020fa6d3 | 2 | 2024-10-27T07:38:37.000Z | 0xcc930b7c2f524256727f91bd8e2040e05f874381d8f825781aef8e3350153960 |
| 0xaafa3db42ea9c114c36a2a033e04c8bc0813c65c | false | 13725024397854988732 | 1 | 10617584 | 2 | 0x6473788c87b4b6611f7cb66a88042207eec9a146 | 2 | 2024-10-27T16:03:03.000Z | 0x885eb58e721cb8dc087c12c5eee4b6661c8733bf48bfe25fdca6764251bca45a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.CurveFeeDistributor_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GaugeController\_AddType\_event
Gauge type registration events from Thruster V1 DEX (decentralized exchange) on Blast, recording when new liquidity pool categories are added to the voting gauge system. Used for analyzing governance structure and liquidity mining program evolution.
| 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_name` | `STRING` | Name or label identifier for the entity being created, registered, or updated in the event. |
| `in_type_id` | `STRING` | Numeric identifier assigned to a gauge type when added to the Thruster GaugeController. Increments sequentially starting from 0, distinguishing between liquidity pool categories like standard Liquidity and ConcentratedLiquidity. |
| address | in\_name | removed | log\_index | in\_type\_id | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | --------------------- | ------- | ---------- | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | ConcentratedLiquidity | false | 1 | 1 | 9562229 | 2024-10-03T05:44:33.000Z | 0xf4acca0a615376f4dec087bf501ca5411fd83abcc1fb964d318827a765be3bfa |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | Liquidity | false | 1 | 0 | 9562227 | 2024-10-03T05:44:29.000Z | 0xd8bb0e5dea1539ed60426b2a7465d29d0edab0f9bb6bdccd5aabe5c9c31e976b |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | ConcentratedLiquidity | false | 14 | 3 | 10074914 | 2024-10-15T02:34:03.000Z | 0xb7ca9aaad807660500e434049177dda05c25933f9b3cc4078fe213baf62f2573 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.GaugeController_AddType_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GaugeController\_NewGauge\_event
Gauge registration events from Thruster V1's GaugeController contract on Blast, recording when new liquidity pool or staking gauges are added to the protocol's reward distribution system. Used to track gauge deployments and categorization by type for analyzing protocol expansion and incentive structure changes.
| 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_addr` | `STRING` | Contract address referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_gauge_type` | `STRING` | Categorical identifier for the type of gauge being added to the controller, with '0' and '1' representing different gauge categories. All sampled events initialize gauges with type '0' or '1', indicating distinct pool or reward mechanisms. |
| `in_weight` | `STRING` | Voting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value. |
| address | in\_addr | removed | in\_weight | log\_index | block\_number | in\_gauge\_type | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 0x2ec796c665e5101d0d6530c7755c97738d98a6a3 | false | 0 | 1 | 9788519 | 0 | 2024-10-08T11:27:33.000Z | 0x9baa532c37601093176921e7775e1673643ac8da96d205edb5f0bfcc47d68d9c |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 0xc0c6447b443d0652aa4598b4ca8ee68a634d7ca3 | false | 0 | 0 | 9562246 | 0 | 2024-10-03T05:45:07.000Z | 0x065a1e6176ea1f4200bcbfaf6f6032c97fb4d0a347291c8fcc3ac7162d265251 |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 0x9d3b3ae1ea106127091ea946744bc4592e350a36 | false | 0 | 0 | 9562238 | 0 | 2024-10-03T05:44:51.000Z | 0x4a7fb3582ee4b208e45b468e45c975db43eb4728b3a92f510a5f63fef89becb7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.GaugeController_NewGauge_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GaugeController\_NewGaugeWeight\_event
*No description available.*
| 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_address` | `STRING` | - |
| `in_time` | `STRING` | Unix timestamp representing the time of the event or operation. Integer value stored as string, representing seconds since epoch (January 1, 1970 00:00:00 UTC). |
| `in_weight` | `STRING` | Voting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value. |
| `in_total_weight` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.GaugeController_NewGaugeWeight_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GaugeController\_NewTypeWeight\_event
Gauge type weight update events from Thruster V1's GaugeController on Blast, recording when new gauge types are added or weight parameters are modified. Contains type identifiers, weight allocations (in 18-decimal format), and total weight snapshots for analyzing vote-escrowed token (veToken) gauge distribution mechanisms.
| 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_type_id` | `STRING` | Numeric identifier for the gauge type being assigned a weight in the GaugeController. Typically ranges from 0-3 based on sample data, representing different gauge categories like liquidity pools or staking types. |
| `in_time` | `STRING` | Unix timestamp representing the time of the event or operation. Integer value stored as string, representing seconds since epoch (January 1, 1970 00:00:00 UTC). |
| `in_weight` | `STRING` | Voting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value. |
| `in_total_weight` | `STRING` | Total weight across all gauge types at the time of the event, denominated in wei (18 decimals). Can be zero during initial type registration or a large value after gauges have accumulated votes. |
| address | in\_time | removed | in\_weight | log\_index | in\_type\_id | block\_number | block\_timestamp | in\_total\_weight | transaction\_hash |
| ------------------------------------------ | ---------- | ------- | ------------------- | ---------- | ------------ | ------------- | ------------------------ | ------------------------------------------- | ------------------------------------------------------------------ |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 1728518400 | false | 1000000000000000000 | 0 | 1 | 9562229 | 2024-10-03T05:44:33.000Z | 0 | 0xf4acca0a615376f4dec087bf501ca5411fd83abcc1fb964d318827a765be3bfa |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 1728518400 | false | 1000000000000000000 | 0 | 0 | 9562227 | 2024-10-03T05:44:29.000Z | 0 | 0xd8bb0e5dea1539ed60426b2a7465d29d0edab0f9bb6bdccd5aabe5c9c31e976b |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 1729123200 | false | 1000000000000000000 | 13 | 3 | 10074914 | 2024-10-15T02:34:03.000Z | 6111563170384668033878400000000000000000000 | 0xb7ca9aaad807660500e434049177dda05c25933f9b3cc4078fe213baf62f2573 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.GaugeController_NewTypeWeight_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GaugeController\_VoteForGauge\_event
Gauge voting events from Thruster V1 DEX on Blast, recording user votes with weights (in basis points, e.g., 10000 = 100%) allocated to specific liquidity pool gauges. Used for analyzing governance participation and liquidity incentive distribution preferences.
| 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_time` | `STRING` | Unix timestamp representing the time of the event or operation. Integer value stored as string, representing seconds since epoch (January 1, 1970 00:00:00 UTC). |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_gauge_addr` | `STRING` | Contract address of the liquidity gauge receiving the vote allocation on Blast. Hex-encoded, 0x-prefixed 40-character string identifying the specific gauge pool in Thruster's voting system. |
| `in_weight` | `STRING` | Voting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value. |
| address | in\_time | in\_user | removed | in\_weight | log\_index | block\_number | in\_gauge\_addr | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ---------- | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 1729267229 | 0x87001fe0924b20441d3131631cf0278d35862906 | false | 2500 | 12 | 10228707 | 0xfef3933d3294dbf4e0ba8c58f323e39a8d36ad75 | 2024-10-18T16:00:29.000Z | 0xacaa7c36a3d61932ec418da8837bc91851a18837168108f5580111ff70c1a4d0 |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 1729224345 | 0x9b84e5abc7694546170fd96b002ecf456911ae65 | false | 5000 | 15 | 10207265 | 0x831581cd36d22b495ccaab64bff0a1c143df65b3 | 2024-10-18T04:05:45.000Z | 0x80102727dd985093ac83ae510da389d526f1451075009980b5b4c0e379d4d4a6 |
| 0xd40fb88b94d20d5d60a94e00492214061bdb2756 | 1729290235 | 0xdea80ce4dad86c37ac6bf08ea56555ef1ebba619 | false | 5000 | 115 | 10240210 | 0x831581cd36d22b495ccaab64bff0a1c143df65b3 | 2024-10-18T22:23:55.000Z | 0x192f8ddd5fb3c3721a3513dbb76308de2bb4b799881768ca3e328f1ef1bc35e5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.GaugeController_VoteForGauge_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityGauge\_claim\_rewards\_function
*No description available.*
| 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` | `INT64` | 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.LiquidityGauge_claim_rewards_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityGauge\_claim\_rewards2\_function
*No description available.*
| 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` | `INT64` | 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__addr` | `STRING` | Address of the user or account associated with the vault mint or redemption operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.LiquidityGauge_claim_rewards2_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityGauge\_claim\_rewards3\_function
*No description available.*
| 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` | `INT64` | 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__addr` | `STRING` | Address of the user or account associated with the vault mint or redemption operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__receiver` | `STRING` | Address of the account receiving the tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.LiquidityGauge_claim_rewards3_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityGauge\_deposit\_reward\_token\_function
*No description available.*
| 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` | `INT64` | 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__reward_token` | `STRING` | - |
| `in__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.LiquidityGauge_deposit_reward_token_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityGaugeFactory\_GaugeCreated\_event
Liquidity gauge deployment events from Thruster V1 DEX (Decentralized Exchange) on Blast, recording when new reward distribution contracts are created for liquidity pools. Tracks gauge contract addresses and factory activity for analyzing incentive program expansion.
| 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. |
| address | removed | in\_gauge | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xce95373c250f2770f8a7857a8f68e8fd6cc4cdf8 | false | 0xc504509dbdd5d7cc4aea0039e33b94e7228fd4ee | 0 | 10074916 | 2024-10-15T02:34:07.000Z | 0x50ce5054ed75fe1ba9f0ce6ad7908a857253ac03d6b4fbd55f1ee4ae7a07e3d7 |
| 0xce95373c250f2770f8a7857a8f68e8fd6cc4cdf8 | false | 0x2ec796c665e5101d0d6530c7755c97738d98a6a3 | 24 | 9787170 | 2024-10-08T10:42:35.000Z | 0x7783d90d736df3761483a88993d52bcbc122de08d6d915daa8f3572d8ebfbde0 |
| 0xce95373c250f2770f8a7857a8f68e8fd6cc4cdf8 | false | 0xc80b4a125f015befdbb4034dc942627638d23ba2 | 4 | 9562232 | 2024-10-03T05:44:39.000Z | 0xafbb378c3852b477a988b79136fa3c79bf44db0453a7f706fb3ef59a6837917d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.LiquidityGaugeFactory_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MerklGauge\_createMerklCampaign\_function
*No description available.*
| 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` | `INT64` | 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__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| `in_rewardToken` | `STRING` | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.MerklGauge_createMerklCampaign_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MerklGaugeFactory\_GaugeCreated\_event
Gauge deployment events from Thruster V1's Merkl gauge factory contract on Blast, tracking when new liquidity mining gauges are created. Used for analyzing protocol incentive structure deployment and identifying newly incentivized liquidity pools.
| 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. |
| address | removed | in\_gauge | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x85c7e8b618b9cad0f0c40a0b40a4d31d8d51e2af | false | 0x177cb63e86dc30e3dd637497847d9b53ef4b71a2 | 1 | 10074920 | 2024-10-15T02:34:15.000Z | 0x1aad3f5548d56d937784537ff9256403e8f58bc6dbc18935557588cee0d793e0 |
| 0x85c7e8b618b9cad0f0c40a0b40a4d31d8d51e2af | false | 0x59331f4b5bc0cf0f66456efc01e02295127dfbf9 | 1 | 9831093 | 2024-10-09T11:06:41.000Z | 0x88d15104636c02c4c9cf98e7fe9367a6f84fa02cf1017232e4eafd65947e59b4 |
| 0x85c7e8b618b9cad0f0c40a0b40a4d31d8d51e2af | false | 0xd4a35a0542639eb6318f4a035f7c77eb7213364e | 12 | 9874712 | 2024-10-10T11:20:39.000Z | 0x3c1cf5f8e786820f4ce9f4abc681ada72965c73523716e3f0560f14c4da3f8ec |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.MerklGaugeFactory_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair03\_Approval\_event
ERC-20 token approval events for a Thruster V1 liquidity pair on Blast, recording owner authorizations for spenders to transfer LP tokens. Useful for tracking liquidity provider permissions and automated market maker (AMM) interaction patterns.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_spender` | `STRING` | Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| address | removed | in\_owner | in\_value | log\_index | in\_spender | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | --------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 0x8034b01555487c26d4e21f4e33b7a30fbc90d181 | 2448208532993662293 | 4 | 0x98994a9a7a2570367554589189dc9772241650f6 | 11092686 | 2024-11-07T15:59:47.000Z | 0x975366e4fe9a31d7fc478091b13b0d506f17173bd84a5a23130ac9eea4212114 |
| 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 0x8034b01555487c26d4e21f4e33b7a30fbc90d181 | 36462097644816579 | 4 | 0x98994a9a7a2570367554589189dc9772241650f6 | 11105553 | 2024-11-07T23:08:41.000Z | 0xb0e7c6bd25dcddf7bfbae29294bb99ccd6485cb70ea993b2ae31b5906d6454b4 |
| 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 0xabea63c0967f2f5faf4b262c0104233ab5a56ac8 | 666174630776938848634 | 4 | 0x98994a9a7a2570367554589189dc9772241650f6 | 11068847 | 2024-11-07T02:45:09.000Z | 0xfab85bef6682bd24153fd7b32fa4b067945011dba1a53ff961dcd4e58fa39ee9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair03_Approval_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair03\_Burn\_event
Liquidity removal events from Thruster V1 decentralized exchange (DEX) pairs on Blast, capturing burned liquidity provider (LP) tokens and withdrawn token amounts. Used to analyze liquidity provider exits and pool depth changes.
| 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. |
| in\_to | address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x576314f851732b208d807260fe19fec7dba3e40c | 0x4e4b4a3111d128628c427e78a2abad1635fe6542 | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 87 | 9769538743993104 | 451361162189787191612 | 4308398 | 2024-06-03T14:56:51.000Z | 0x7ee5afecf13801b78dcc7f757afb0e5eb5f595f769be2bf475ce9051bc69e2af |
| 0x8034b01555487c26d4e21f4e33b7a30fbc90d181 | 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 117 | 10252768284610105055 | 2706607626806362 | 4281966 | 2024-06-03T00:15:47.000Z | 0x02f799d30da24f17b55b888af6099eeb420b7790b456594b9533a31fe6cde01d |
| 0x8034b01555487c26d4e21f4e33b7a30fbc90d181 | 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 15 | 533838942256543908595 | 139813877258141475 | 4298299 | 2024-06-03T09:20:13.000Z | 0x906e40610fdc58f3418b24ebafe97906d5b4b6c9760f31647bb8a74138adfd6c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair03_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair03\_ClaimGas\_event
*No description available.*
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair03_ClaimGas_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair03\_ClaimYieldAll\_event
Yield claim events from Thruster v1 DEX liquidity pairs on Blast, recording Gas token, WETH (Wrapped Ether), and USDB (Blast USD) rewards distributed to recipients. Used for tracking yield generation and reward distribution patterns across different trading pairs.
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amountWETH` | `STRING` | Amount of WETH (Wrapped Ether) yield claimed from the liquidity pair, denominated in wei (1e18 precision). Returns zero when no WETH yield is available for the claim event. |
| `in_amountUSDB` | `STRING` | Amount of USDB (USD Blast stablecoin) yield claimed from the liquidity pair, denominated in wei (1e-18 USDB). May be zero if only gas or WETH yield was claimed in this event. |
| `in_amountGas` | `STRING` | Amount of native gas token yield claimed from the liquidity pair, denominated in wei. Represents Blast-specific yield accrued to the pair contract that was distributed to the recipient address. |
| address | removed | log\_index | block\_number | in\_amountGas | in\_recipient | in\_amountUSDB | in\_amountWETH | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------ | ------------------------------------------ | -------------- | ------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 62 | 2871426 | 785004679735854063 | 0x8928e47951de5fc5187f04e241fb692e88601b0e | 0 | 0 | 2024-05-01T08:37:47.000Z | 0x2600fd16988dd6c7d1de4e373ea18fcf96ee88283b5d97270bce9c8bc478ace3 |
| 0x4e4b4a3111d128628c427e78a2abad1635fe6542 | false | 71 | 2871426 | 449269933711931339 | 0x8928e47951de5fc5187f04e241fb692e88601b0e | 0 | 0 | 2024-05-01T08:37:47.000Z | 0x2600fd16988dd6c7d1de4e373ea18fcf96ee88283b5d97270bce9c8bc478ace3 |
| 0x4e4b4a3111d128628c427e78a2abad1635fe6542 | false | 31 | 2871797 | 30198168457792 | 0x87c38f456d2a30e2617e4c55a67b22b54cf7a44b | 0 | 7192424136431686873 | 2024-05-01T08:50:09.000Z | 0x4dd9dd8173c29fe3a4e4944b3ebf3069e5f4927855d11581afbde7cc3cc0d33f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair03_ClaimYieldAll_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair03\_Mint\_event
Liquidity provision events for a specific Thruster V1 trading pair on Blast, recording token amounts added to the pool by liquidity providers. Used for tracking liquidity depth changes and LP activity for this pair contract.
| 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. |
| address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ---------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 96 | 1520999427842454902 | 448489581745900 | 5462386 | 2024-06-30T08:03:07.000Z | 0x5b96cdffbb83dfe7c3b2872bdaa1cbe90ca71e1d769ccdec98967477f605ed65 |
| 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 29 | 998497849163933902 | 291428842032545 | 5485337 | 2024-06-30T20:48:09.000Z | 0x455c72ebd74a98045d4cb2a5e9d8bd1a5b7549bbbefca7762eaea1e6d3e9419a |
| 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 20 | 7983966711286611569 | 2351518697397589 | 5477304 | 2024-06-30T16:20:23.000Z | 0x8ab4e538ae5c0feed997c88d69998e03d3b73a1e802201591c45e9e17ded445b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair03_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair03\_Swap\_event
Swap events from a Thruster V1 liquidity pair contract on Blast, recording token exchanges with input/output amounts for both token0 and token1. Used to track trading activity, price movements, and liquidity pool utilization for this specific pair.
| 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. |
| in\_to | address | removed | in\_sender | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | --------------------- | ---------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x948d6128fa998ec864f38f065a3638e49ddb165a | 0x0e9309f32881899f6d4ac2711c6e21367a84ca26 | false | 0x948d6128fa998ec864f38f065a3638e49ddb165a | 15 | 2443590 | 0 | 168097720486413834650 | 3214159957196800 | 0 | 2024-04-21T10:56:35.000Z | 0xe1c1550d0a4e475349f218f738424a04742cb50c55534490079b65fcd84dd8c0 |
| 0xbc8a7a845cc7a8246eb34856afe6f1a3d62bd9c6 | 0x0e9309f32881899f6d4ac2711c6e21367a84ca26 | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 36 | 2450135 | 0 | 23953683123681183837 | 457657085845624 | 0 | 2024-04-21T14:34:45.000Z | 0xda7099ce0d1aeb02f5fb5c517ff9ab9d496a500ec5583e5dfb9a5a59c190479c |
| 0x948d6128fa998ec864f38f065a3638e49ddb165a | 0x0e9309f32881899f6d4ac2711c6e21367a84ca26 | false | 0x948d6128fa998ec864f38f065a3638e49ddb165a | 15 | 2441407 | 0 | 172801464634577204020 | 3308660572815360 | 0 | 2024-04-21T09:43:49.000Z | 0xb52e91ddb678e3eb4dffd92313c770a6915e7a81fa4e84d4dbbaa4b518c6cd3d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair03_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair03\_Sync\_event
Sync events from Thruster V1 decentralized exchange (DEX) liquidity pairs on Blast, recording reserve balance updates for token0 and token1 after each swap or liquidity operation. Used to track pool state changes and calculate real-time exchange rates across trading pairs.
| 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. |
| address | removed | log\_index | in\_reserve0 | in\_reserve1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | --------------------- | -------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x9713899b7de8be42c95e478ac02026ae556cfb5e | false | 256 | 561471961842920344495 | 7517036312103629581 | 4223260 | 2024-06-01T15:38:55.000Z | 0x2d3d97d63a5bc4b9fe2006c501358368ab322115ba77c0bbef43a67eaf126a4d |
| 0x254b286ae84432f4cdcf41851627a2dd4d8a9894 | false | 256 | 586765655930467862913 | 27603527594295000748790251 | 4220124 | 2024-06-01T13:54:23.000Z | 0x0ab00ff755880ac4becc2570e073abc0e7422a2c428cf80e7800323988131fff |
| 0x5e12b6bc8cf96b6bc80e532c53c6e41f16bb2f21 | false | 256 | 155257805589130693709 | 38946114547232211323508411 | 4233851 | 2024-06-01T21:31:57.000Z | 0x50de6d729dbd93bdd4149f3ee24312fee3dc550ba8a9a1b0e739bc97f5baf226 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair03_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair03\_Transfer\_event
ERC-20 token transfer events for a Thruster V1 liquidity pool pair contract on Blast, including LP token mints (from zero address) and burns (to zero address). Useful for tracking liquidity provision, removal, and LP token movements across different addresses.
| 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_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| in\_to | address | in\_from | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe63153c3360aca0f4e7ca7a1fc61c2215faef5a1 | 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | 0xb757df95d845f8deb8b4ddafe74fd54ad2b377a3 | false | 14366252426220003306 | 6 | 8283561 | 2024-09-03T15:22:17.000Z | 0x5060369be13c5327711f88e134b9071a9a4a928e71f36413a6a7431277809919 |
| 0x31dd65f845592199d5949ef1ce15d10891244adb | 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | 0xe63153c3360aca0f4e7ca7a1fc61c2215faef5a1 | false | 14366252426220003306 | 8 | 8283561 | 2024-09-03T15:22:17.000Z | 0x5060369be13c5327711f88e134b9071a9a4a928e71f36413a6a7431277809919 |
| 0x99304d25d7c72979d67b4ee3851e4cff3e53e166 | 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | 0x0000000000000000000000000000000000000000 | false | 247665412796936032 | 27 | 8291594 | 2024-09-03T19:50:03.000Z | 0xaef6a6fc5cecf5a18bc1a325e758ea0dcd3971d4abf8128026df6a0d4e6f7378 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair03_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair1\_Approval\_event
ERC-20 token approval events from Thruster V1 DEX (decentralized exchange) liquidity pool pairs on Blast, recording owner-spender allowance grants for LP (liquidity provider) tokens. Used for tracking liquidity position management and router contract permissions.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_spender` | `STRING` | Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| address | removed | in\_owner | in\_value | log\_index | in\_spender | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | --------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 0xde4c365e5133fcb527e8a9693cbbe622ffbef40b | 5577559786456972927 | 11 | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 7339521 | 2024-08-12T18:54:17.000Z | 0x28512cf5132855f1e05dff78042b72239f7bd22fc617f54c61b6e7369396e2ff |
| 0xb4e6d3178d34d2f8477b54c56a1b5ba7f050574a | false | 0x28ead95628610b4ee91408cfe1c225c71ab6e7a8 | 115792089237316195423570985008687907853269984665640564039457584007913129639 | 11 | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 2215392 | 2024-04-16T04:09:59.000Z | 0xfe3cdf19617d49b889d5c3da93867decd373ba8fb44f9d269ac619cf4bbe6886 |
| 0xd501300075ce211fd79fb74a5267075a5fbcda99 | false | 0x1c7d33d5e05659f809e88a84db193c76c44d88f1 | 115792089237316195423570985008687907853269984665640564039457584007913129639 | 33 | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 2221760 | 2024-04-16T07:42:15.000Z | 0x14dcade1bff3f5b2c3fd1fb9ba814ae1a1cbf33bfc43f9aa949f67a5942ec711 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair1_Approval_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair1\_Burn\_event
Liquidity removal events from Thruster V1 DEX (decentralized exchange) pairs on Blast, recording when liquidity providers burn LP tokens to withdraw their pooled token0 and token1 amounts. Used to track liquidity withdrawals, pool depth changes, and LP position management across trading pairs.
| 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. |
| in\_to | address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 0x09c7cb836831acd899be841c7278b3cbbed2d6c8 | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 8 | 2704611396295564383 | 15756685993770238943 | 519692 | 2024-03-07T22:06:39.000Z | 0xd41ac153a74d78234b4b3c03bfefc979e2594a1fe7da5d64097e7c50ed860d68 |
| 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 0x801792108703cae91f4d435bc61565f25680fbb0 | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 11 | 24546475457691303631 | 1135787110293209676641337 | 491827 | 2024-03-07T06:37:49.000Z | 0xc080409b3263a4b4c3edc42fc21291779c64ee22be8749f196adcf4654a74a87 |
| 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 0x801792108703cae91f4d435bc61565f25680fbb0 | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 8 | 16364316971794202420 | 757191406862139784427557 | 491516 | 2024-03-07T06:27:27.000Z | 0x5cd4c6c65618ef4ed1ec9565ade8d36c618f3c53d83153ca6c18e1e8df27101d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair1_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair1\_ClaimGas\_event
*No description available.*
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair1_ClaimGas_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair1\_ClaimYieldAll\_event
Yield claim events from Thruster V1 liquidity pairs on Blast, capturing gas rebate distributions (WETH, USDB, and native gas) to recipients from individual pair contracts. Used for tracking Blast's unique yield-generating mechanics and analyzing protocol revenue distribution to liquidity providers.
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amountWETH` | `STRING` | Amount of WETH (Wrapped ETH) yield claimed in this event, denominated in wei (smallest unit, 10^-18 WETH). Value is zero in all sample events, indicating no WETH yield was claimed in these instances. |
| `in_amountUSDB` | `STRING` | Amount of USDB (USD Blast stablecoin) yield claimed in this event, denominated in the token's smallest unit (wei-equivalent). Value is zero in sample data, indicating Gas and WETH yields are more commonly claimed on Thruster. |
| `in_amountGas` | `STRING` | Claimed gas yield amount in wei-denominated units from the Thruster V1 liquidity pair on Blast. Sample values show typical gas yield claims ranging from small amounts to over 1.7 ETH equivalent. |
| address | removed | log\_index | block\_number | in\_amountGas | in\_recipient | in\_amountUSDB | in\_amountWETH | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------- | ------------------------------------------ | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xd501300075ce211fd79fb74a5267075a5fbcda99 | false | 110 | 3531731 | 13819087627751899 | 0xbd84b689f7b1c335f7f643c844a77ee5f09108d8 | 0 | 0 | 2024-05-16T15:27:57.000Z | 0x0e4ec24759d71199c291cd114aab63ba88d00275727a5c78b2ec6c20ab63bc56 |
| 0x7834d4dfb06974262435493d0a167384774a271e | false | 333 | 3531731 | 7291000190134098 | 0xbd84b689f7b1c335f7f643c844a77ee5f09108d8 | 0 | 0 | 2024-05-16T15:27:57.000Z | 0x0e4ec24759d71199c291cd114aab63ba88d00275727a5c78b2ec6c20ab63bc56 |
| 0x713ea4a158dc5bcb451beeb13c000698a12f9720 | false | 556 | 3531731 | 1753901328065271750 | 0xbd84b689f7b1c335f7f643c844a77ee5f09108d8 | 0 | 0 | 2024-05-16T15:27:57.000Z | 0x0e4ec24759d71199c291cd114aab63ba88d00275727a5c78b2ec6c20ab63bc56 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair1_ClaimYieldAll_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair1\_Mint\_event
Liquidity provision events from Thruster V1 decentralized exchange (DEX) pairs on Blast, recording token amounts deposited when minting LP (liquidity provider) tokens. Used to track liquidity additions and capital deployment across trading pairs.
| 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. |
| address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------- | ------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc4478cb8c5031fa222e6919b5c1c810be2dcafdf | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 22 | 1417512578058448152 | 89841697127562458392 | 6003790 | 2024-07-12T20:49:55.000Z | 0x2cbf4f2b9dbfc046e7afc2a756b24adb9436feabab4805942a6028d78cbdf47a |
| 0x22d36da4a833360a348969349a027cddfbfea2b7 | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 22 | 34999999999999999 | 177702347247635013614667 | 5999221 | 2024-07-12T18:17:37.000Z | 0x2102f033e1cafdb104c316052b03fad848d1c1bbe42ec90331eb9661bdc702c6 |
| 0x8c8515b75c5cb81a438578b1b1501ef3a7906a90 | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 27 | 4281466616420533594152379 | 4581244303019278525027 | 6007241 | 2024-07-12T22:44:57.000Z | 0x958b33a48e65a0ecdf1da5620f7e5772febe8e0ba55b586f997416461ee2b703 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair1_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair1\_Swap\_event
Swap events from Thruster V1 decentralized exchange (DEX) liquidity pairs on Blast, recording token exchanges with input/output amounts, sender addresses, and recipient details. Used for analyzing trading volume, price impact, and liquidity pool activity across DEX pairs.
| 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. |
| in\_to | address | removed | in\_sender | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | -------------------------- | ---------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x335440b7c22ebb1de1f9c2ab866efc8a9befac0e | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 0x335440b7c22ebb1de1f9c2ab866efc8a9befac0e | 26 | 10519345 | 0 | 1682782596498607951246 | 384350237371357 | 0 | 2024-10-25T09:28:25.000Z | 0xc2f0e27c1d679e41fce256c98ba67526cc21b48b100c8d26e0d7a4a4be191ab2 |
| 0x335440b7c22ebb1de1f9c2ab866efc8a9befac0e | 0x144f33805779f07afc76f7eca76ffc4b5f7c6d45 | false | 0x335440b7c22ebb1de1f9c2ab866efc8a9befac0e | 143 | 10529380 | 0 | 64464412242854110921320460 | 803587426534259 | 0 | 2024-10-25T15:02:55.000Z | 0xada89a5c00da0a40258ec74e3bd4b4fd0f724c2bb7e09c77fda3155f5628a23d |
| 0x3fc57948aa5ab838e1a1053b05324ee21661931c | 0x35a5f5d3cafbb12d7aad2c85a136b6d2334c635e | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 29 | 10516312 | 0 | 11136739370481597 | 3726287262872628745449 | 0 | 2024-10-25T07:47:19.000Z | 0x666c5c83f2c9b4d18a3b8eca1e17bcce628eb1fa0250142528d1b1b425c2806f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair1_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair1\_Sync\_event
Reserve balance snapshots from Thruster V1 DEX liquidity pools on Blast, emitted on each swap or liquidity change. Enables tracking of pool composition, price movements, and total value locked (TVL) over time.
| 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. |
| address | removed | log\_index | in\_reserve0 | in\_reserve1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------ | --------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xdcd43f64b2bb3dcac9502b93f5a15dca3a0f3767 | false | 77 | 212882175750 | 13707320486350 | 3753247 | 2024-05-21T18:31:49.000Z | 0x267878dd9e64dcb654dc54eb3f5c1e9cf06fcfc0861808d78746886dad43593b |
| 0xdcd43f64b2bb3dcac9502b93f5a15dca3a0f3767 | false | 137 | 41523 | 145220684920754 | 3746350 | 2024-05-21T14:41:55.000Z | 0xd79897d8e79d0d17470da2ed6701479809095059f9c8869c1b73732b41712556 |
| 0xdcd43f64b2bb3dcac9502b93f5a15dca3a0f3767 | false | 130 | 26803 | 164302653634013 | 3738387 | 2024-05-21T10:16:29.000Z | 0x556bed3e8bf394a4716660f2e2ed2619e5ee1a85028f9bc734d0a56203a16d62 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair1_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pair1\_Transfer\_event
LP token transfer events from Thruster V1 liquidity pairs on Blast, including mints (from zero address), burns (to zero address), and transfers between addresses. Used for tracking liquidity provision, withdrawal, and LP position changes in the DEX.
| 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_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| in\_to | address | in\_from | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x99304d25d7c72979d67b4ee3851e4cff3e53e166 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | 0x0000000000000000000000000000000000000000 | false | 1782948523125498035 | 16 | 2910151 | 2024-05-02T06:08:37.000Z | 0xced2973770dc8c2808dd652bf0c7cbd6d6f826b0b06310e8f8a36bce4b0b6072 |
| 0x0000000000000000000000000000000000000000 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 10098300881567137749 | 18 | 2910151 | 2024-05-02T06:08:37.000Z | 0xced2973770dc8c2808dd652bf0c7cbd6d6f826b0b06310e8f8a36bce4b0b6072 |
| 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | 0x28d95d037335f37eb6fad447a1348608eb999000 | false | 10098300881567137749 | 14 | 2910151 | 2024-05-02T06:08:37.000Z | 0xced2973770dc8c2808dd652bf0c7cbd6d6f826b0b06310e8f8a36bce4b0b6072 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pair1_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Burn\_event
Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tickLower` | `INT64` | Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
| `in_tickUpper` | `INT64` | Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `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. |
| address | removed | in\_owner | in\_amount | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_tickLower | in\_tickUpper | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | --------------------- | ---------- | ------------------- | ------------------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x96a33ab393a65b08c6b6dc71751d98786027a0d6 | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 383725865187084791239 | 67 | 1471611738996532979 | 9874265087571642498 | 4110172 | -600 | 0 | 2024-05-30T00:49:19.000Z | 0xdeebfa6b6e8ea85a3da0df045f9538d2794a67f6bf422d387430beb198dc3f77 |
| 0x9649ab08123c2709ea93ccfee83cf827e02775ea | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 329690310664407168 | 28 | 8260963176593210 | 23015207644296578 | 4149911 | -1980 | 0 | 2024-05-30T22:53:57.000Z | 0xac44d1ba324b860cbd85c560970504195f903f523b227f4dc10c0e1da94cd99b |
| 0x1d42751ce4f28f58e7b757a586615a0cf31566df | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 918612492984563682 | 29 | 9065631400309490 | 39310135454095052 | 4115326 | -1080 | 0 | 2024-05-30T03:41:07.000Z | 0xecd3ce1c787235754304ec29346e5cda0197f82573930f3d919b41c9df45d765 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_ClaimYieldAll\_event
*No description available.*
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amountETH` | `STRING` | - |
| `in_amountWETH` | `STRING` | - |
| `in_amountUSDB` | `STRING` | - |
| `in_amountGas` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_ClaimYieldAll_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Collect\_event
Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tickLower` | `INT64` | Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
| `in_tickUpper` | `INT64` | Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
| `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. |
| address | removed | in\_owner | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_recipient | in\_tickLower | in\_tickUpper | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------------- | ---------------------- | ------------- | ------------------------------------------ | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x07cfc4c8779d3ab4d6103b3e04f4d719656e81f2 | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 25 | 4018566026775752167 | 1529834261111836161183 | 9712337 | 0xa3f2463bfb45903df1cd74bf6d9998be9128f7b2 | -887200 | 887200 | 2024-10-06T17:08:09.000Z | 0x82922474bb70b20e04be502517854bd82008c57c01490e5ffb8c745de302f0c1 |
| 0x07cfc4c8779d3ab4d6103b3e04f4d719656e81f2 | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 10 | 7813110068097870601 | 2981445801421063027100 | 9712353 | 0xa3f2463bfb45903df1cd74bf6d9998be9128f7b2 | -887200 | 887200 | 2024-10-06T17:08:41.000Z | 0x70575143da6019b5b624156f9ad0be4f3b80063f45f0078fc10ba5169beb041b |
| 0x1834e4325f9e0300be3abb1ee1f19c26f4de6ea2 | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 16 | 4099746694582447716910 | 218817846596748518 | 9710718 | 0x984ff362c105cd8fa55d816ddefdd5889710bcec | -99000 | -22980 | 2024-10-06T16:14:11.000Z | 0x073b611a31be1b235bf62aba364765e622f650c6057bf7e0a3dd99765331eed5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_CollectProtocol\_event
Protocol fee collection events from concentrated liquidity pools, recording fees withdrawn by the protocol from trading activity. Contains token amounts collected (amount0, amount1), sender address initiating the collection, and recipient address receiving the fees.
| 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. |
| address | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------- | ---------------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xb88e12ac0d0d327f7c60f219c03f8446c5d4e6a9 | false | 0x3b143ca171194c97183ef51b0d56554aa68d0588 | 80 | 22571628508952765 | 14035938761931 | 18246495 | 0x6e02c0cbb362835bf74c9567a2aeb7a3d6b921c5 | 2025-04-22T06:20:05.000Z | 0xdcc8fb5fb94fc2a136477ae3be0e317a9aeea54c0ccbbda013fafb5e34e95798 |
| 0x5fa8702d9987b9da17002c0eb31b3a29d4a4ec2f | false | 0x3b143ca171194c97183ef51b0d56554aa68d0588 | 74 | 0 | 2000311312471277272 | 18246495 | 0x6e02c0cbb362835bf74c9567a2aeb7a3d6b921c5 | 2025-04-22T06:20:05.000Z | 0xdcc8fb5fb94fc2a136477ae3be0e317a9aeea54c0ccbbda013fafb5e34e95798 |
| 0x9076204c71aad67b904f979552f07c4ba6025bff | false | 0x3b143ca171194c97183ef51b0d56554aa68d0588 | 83 | 8021588092731040 | 3675389509263971850444 | 18246495 | 0x6e02c0cbb362835bf74c9567a2aeb7a3d6b921c5 | 2025-04-22T06:20:05.000Z | 0xdcc8fb5fb94fc2a136477ae3be0e317a9aeea54c0ccbbda013fafb5e34e95798 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_CollectProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Flash\_event
Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_paid0` | `STRING` | Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination. |
| `in_paid1` | `STRING` | Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_IncreaseObservationCardinalityNext\_event
Uniswap V3 pool event emitted when the observation array cardinality limit is increased, recording the old and new maximum number of price observations the pool can store. Used for tracking oracle capacity expansions that enable longer time-weighted average price (TWAP) calculations.
| 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_observationCardinalityNextOld` | `STRING` | Previous maximum number of price observations the Uniswap V3 pool could store before the increase. String-encoded integer value representing the cardinality limit prior to the update. |
| `in_observationCardinalityNextNew` | `STRING` | Updated maximum number of price observations the Uniswap V3 pool can store. String-encoded integer value representing the new cardinality limit after the increase. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_observationCardinalityNextNew | in\_observationCardinalityNextOld |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | --------------------------------- | --------------------------------- |
| 0x4cc9959ae7a4d380c1100b271bc63d9961ca162f | false | 13 | 1941255 | 2024-04-09T19:52:05.000Z | 0x7fe4070b2328c2a81e516b5c088689da1a213af950c02d3a06ec31c1c50c24cd | 100 | 1 |
| 0x7573ab0e80f8b264f6bc2ac37401f0adbe491759 | false | 24 | 1941295 | 2024-04-09T19:53:25.000Z | 0x7a03ae30f66c0c9de1c978656498b11ab8cf53eec760632134e6ce9e65716a27 | 100 | 1 |
| 0xecb1c17a51d782ac2757e2ab568d159854b9b4bd | false | 7 | 1941215 | 2024-04-09T19:50:45.000Z | 0x9ceefb022dfdbbec9128fcfaa56efaa94529d290fcd69076d82d7319df459721 | 100 | 1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_IncreaseObservationCardinalityNext_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Initialize\_event
Concentrated liquidity pool initialization event emitted when a pool contract is first created and seeded with a starting price. Records the initial sqrtPriceX96 (square root price encoded as Q64.96 fixed-point) and tick index that define the pool's starting exchange rate between token0 and token1.
| 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_sqrtPriceX96` | `STRING` | Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers. |
| `in_tick` | `INT64` | Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool's tick spacing grid. |
| address | in\_tick | removed | log\_index | block\_number | block\_timestamp | in\_sqrtPriceX96 | transaction\_hash |
| ------------------------------------------ | -------- | ------- | ---------- | ------------- | ------------------------ | -------------------------- | ------------------------------------------------------------------ |
| 0xf01ba449ce34b6be5151264445c99a7b23f3517c | -458212 | false | 13 | 418033 | 2024-03-05T13:38:01.000Z | 8901020307485223212 | 0x48d82f069c60e7243ea564d5e3df5584acbc704e17e074cab8d7ea6d05602f3f |
| 0x694078f516d83d0153e4238f0ff070d0e133d585 | -200312 | false | 10 | 409289 | 2024-03-05T08:46:33.000Z | 3543191142285914002319262 | 0x544dec138d0737a6a6432d063532aeec44edddff6885df859567de509d4baecf |
| 0x324adce98e29e6d565d540dff2a6dd52f0f134d9 | -169457 | false | 25 | 394073 | 2024-03-05T00:19:21.000Z | 16571309232919423609230508 | 0x99573eee44dcd28a4483e866905a90768bb37a83372a50f5edbd1fa349a054a3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_Initialize_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Mint\_event
Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tickLower` | `INT64` | Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
| `in_tickUpper` | `INT64` | Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `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. |
| address | removed | in\_owner | in\_amount | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_tickLower | in\_tickUpper | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------------- | ------------------------------------------ | ---------- | ---------------- | --------------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1d42751ce4f28f58e7b757a586615a0cf31566df | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 2007715825048221 | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 8 | 98251610829088 | 89826853113200 | 8457489 | -720 | 1200 | 2024-09-07T15:59:53.000Z | 0x9ced32c260cd1842409048ce9e69fd9cc282c4e493c2a28d48e61892be449b8e |
| 0x1d42751ce4f28f58e7b757a586615a0cf31566df | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 22061014749110972 | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 7 | 1079600115007492 | 987027898407345 | 8465191 | -720 | 1200 | 2024-09-07T20:16:37.000Z | 0xb7ef1b3599efa53beeb4d36b56e4136852910c496228983adf5c24cb088f56f6 |
| 0x1d42751ce4f28f58e7b757a586615a0cf31566df | false | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 2035221866904387 | 0x434575eaea081b735c985fa9bf63cd7b87e227f9 | 4 | 99597674293939 | 91057495991397 | 8452415 | -720 | 1200 | 2024-09-07T13:10:45.000Z | 0x4f45f8b7bb428e0ce724de06d342e0b5027988ca3c7352766ba38c9fdfb4a8e6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_SetFeeProtocol\_event
Protocol fee configuration change events emitted when liquidity pool fee parameters are updated. Records old and new fee protocol values for both tokens in the pool, tracking governance-initiated fee structure modifications.
| 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_feeProtocol0Old` | `INT64` | Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update. |
| `in_feeProtocol1Old` | `INT64` | Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update. |
| `in_feeProtocol0New` | `INT64` | New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees. |
| `in_feeProtocol1New` | `INT64` | New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_SetFeeProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_SetGauge\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_SetGauge_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Swap\_event
Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_sqrtPriceX96` | `STRING` | Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers. |
| `in_liquidity` | `STRING` | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination. |
| `in_tick` | `INT64` | Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool's tick spacing grid. |
| address | in\_tick | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_liquidity | in\_recipient | block\_timestamp | in\_sqrtPriceX96 | transaction\_hash |
| ------------------------------------------ | -------- | ------- | ------------------------------------------ | ---------- | --------------------- | ------------------------ | ------------- | ------------------------ | ------------------------------------------ | ------------------------ | -------------------------------- | ------------------------------------------------------------------ |
| 0x458266a76b6c72eec84cc6e5a96abba9c3695fb6 | -66845 | false | 0x04b94b77c6348744024a7b3e70174922ffe42355 | 23 | -10652745624730959460 | 13351440429687500 | 6182572 | 425654589654041339869 | 0x04b94b77c6348744024a7b3e70174922ffe42355 | 2024-07-17T00:09:19.000Z | 2801899482881398888691573838 | 0xc262921cc8d8a99ea261df214c9cc2c4f5fd692f3f82a74888836f26231081c8 |
| 0x16d34eff8e080684315b36201b19dfb4ee4b738e | 79501 | false | 0x04b94b77c6348744024a7b3e70174922ffe42355 | 27 | 10652745624730959460 | -30837192710264889270141 | 6182572 | 23964244147509680686402 | 0x5eb72fe80612c0490ede9054cbc700aef743aafe | 2024-07-17T00:09:19.000Z | 4218451683245600712881759298123 | 0xc262921cc8d8a99ea261df214c9cc2c4f5fd692f3f82a74888836f26231081c8 |
| 0x32fdf42095aaecfea06f8ec26a361475f3603cb9 | 122104 | false | 0x04b94b77c6348744024a7b3e70174922ffe42355 | 20 | -488373862337350760 | 98054987802208179199790 | 6186787 | 606352707351268878588051 | 0x04b94b77c6348744024a7b3e70174922ffe42355 | 2024-07-17T02:29:49.000Z | 35498333727046277960629216559245 | 0xd6088764194a1b8724ef450adc9deaacec035ba0791df4670e99d8129601fcdd |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory03\_ClaimGas\_event
Gas claim events from Thruster DEX factory contract on Blast L2, recording when users claim accumulated gas rebates with recipient addresses and claimed amounts. Used for analyzing Blast's native gas rebate distribution and protocol fee revenue sharing.
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or 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. |
| address | removed | in\_amount | log\_index | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | false | 614276392630602082 | 202 | 8145558 | 0xbd84b689f7b1c335f7f643c844a77ee5f09108d8 | 2024-08-31T10:42:11.000Z | 0xdb1f04e77e8e5c10e961b7aeb2c817e79a7ec18d1b21872b7d8d8752755a317a |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | false | 12209955202560782 | 344 | 10381753 | 0x2a9d4fbc2142434ed6565e6174e23b599dbac3b1 | 2024-10-22T05:02:01.000Z | 0x7a2733779cbe10e50d4a0a7aa0a9478621c65e49b46ddc9452e891b9fdad3055 |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | false | 266326622112043470 | 87 | 5166797 | 0xbd84b689f7b1c335f7f643c844a77ee5f09108d8 | 2024-06-23T11:50:09.000Z | 0xcbe92b70803b775790ce372adb3900518efcfbadaad7c41706b5c3acea8b2d7e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory03_ClaimGas_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory03\_PairCreated\_event
Liquidity pool creation events from Thruster DEX (Uniswap V2 fork) on Blast, capturing new trading pair deployments with token addresses and sequential pair identifiers. Used for tracking DEX market expansion and identifying newly launched token pairs.
| 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_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_anon3` | `STRING` | Sequential counter tracking the total number of pairs created by the factory contract. |
| address | in\_pair | removed | in\_anon3 | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | --------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0x8343ebe3f8773f77aefae3cd4a360a72bcb6cf37 | false | 1594 | 0x4300000000000000000000000000000000000004 | 0x988c819c2e5477900f4a4907ea543f05667d416b | 104 | 4388681 | 2024-06-05T11:32:57.000Z | 0x66305d63df4f7b6136fc1846f02976d4d5f881148817c84b208a89e829ae7dd7 |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0xdde82adbb9042bb4c83688e88849f1028d51b066 | false | 1592 | 0x4300000000000000000000000000000000000004 | 0xb4ebbfa229cd36ca8d84e900be361d4132fd49c0 | 50 | 4372432 | 2024-06-05T02:31:19.000Z | 0xe661d452bf8b75a182269f981827f78811d5bb6f3c6361303bfe15cf972619fe |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0xe23dc785d32ba1e4e5955978675689280af21fbc | false | 1593 | 0x4300000000000000000000000000000000000004 | 0xd55edfc79c0d14084260d16f38bda75e28abfb6a | 60 | 4386259 | 2024-06-05T10:12:13.000Z | 0x35748f1747f9153ecff7cf778305bae70cab00064086c9cba65a6bf93cf0bc6e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory03_PairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory03\_SetYieldCut\_event
Yield distribution parameter changes for Thruster V1 DEX (decentralized exchange) factory contract on Blast L2. Tracks updates to the yield cut percentage that determines how native Blast yield is split between liquidity providers and the protocol.
| 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_yieldCut` | `STRING` | Yield cut parameter value set in the Thruster Factory contract on Blast, representing the percentage or basis points of yield allocated. Based on the sample value of '2', this likely represents a low percentage allocation (2% or 0.02%). |
| address | removed | log\_index | in\_yieldCut | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | false | 16 | 2 | 1957642 | 2024-04-10T04:58:19.000Z | 0x36d7a183a06ddd412610b3ccbbd775994b30306ab01aa509f600d1686177cb40 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory03_SetYieldCut_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory03\_SetYieldTo\_event
Yield recipient configuration events from Thruster V1 DEX factory contract on Blast, recording changes to the address receiving native yield generated by liquidity pools. Used for tracking yield distribution settings and protocol fee management.
| 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_yieldTo` | `STRING` | Address designated to receive yield generated by the factory contract. Can be set to the zero address (0x000...000) to disable yield distribution. |
| address | removed | log\_index | in\_yieldTo | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | false | 15 | 0x99304d25d7c72979d67b4ee3851e4cff3e53e166 | 1957642 | 2024-04-10T04:58:19.000Z | 0x36d7a183a06ddd412610b3ccbbd775994b30306ab01aa509f600d1686177cb40 |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | false | 1 | 0x0000000000000000000000000000000000000000 | 20788812 | 2025-06-20T02:43:59.000Z | 0xac9693453e29bbe717f4e6b91c8231cad0c11f870e4bd83abf1fcefd9b836390 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory03_SetYieldTo_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory03\_SetYieldToSetter\_event
*No description available.*
| 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_newYieldToSetter` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory03_SetYieldToSetter_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory03\_Swap\_event
Token swap events from Thruster V1 decentralized exchange (DEX) on Blast network. Records individual swaps with input/output amounts, trading pair addresses, and participant addresses for analyzing DEX trading activity and liquidity flows.
| 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_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `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. |
| in\_to | address | in\_pair | removed | in\_sender | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | --------------------- | ---------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xbc8a7a845cc7a8246eb34856afe6f1a3d62bd9c6 | 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0x0e9309f32881899f6d4ac2711c6e21367a84ca26 | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 9 | 2427846 | 0 | 37321483703017034199 | 714444341535462 | 0 | 2024-04-21T02:11:47.000Z | 0x9c37d8d14086c22368016578e4c68e0da8f2301a22ec897733d78bbc4ebc07cb |
| 0x948d6128fa998ec864f38f065a3638e49ddb165a | 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0x0e9309f32881899f6d4ac2711c6e21367a84ca26 | false | 0x948d6128fa998ec864f38f065a3638e49ddb165a | 16 | 2443590 | 0 | 168097720486413834650 | 3214159957196800 | 0 | 2024-04-21T10:56:35.000Z | 0xe1c1550d0a4e475349f218f738424a04742cb50c55534490079b65fcd84dd8c0 |
| 0xbc8a7a845cc7a8246eb34856afe6f1a3d62bd9c6 | 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0x0e9309f32881899f6d4ac2711c6e21367a84ca26 | false | 0x98994a9a7a2570367554589189dc9772241650f6 | 37 | 2450135 | 0 | 23953683123681183837 | 457657085845624 | 0 | 2024-04-21T14:34:45.000Z | 0xda7099ce0d1aeb02f5fb5c517ff9ab9d496a500ec5583e5dfb9a5a59c190479c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory03_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory03\_Sync\_event
Liquidity pool reserve synchronization events from Thruster V1 decentralized exchange (DEX) on Blast, capturing reserve0 and reserve1 updates for each trading pair after swaps or liquidity changes. Used for tracking pool state changes and analyzing liquidity dynamics across Thruster pairs.
| 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_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `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. |
| address | in\_pair | removed | log\_index | in\_reserve0 | in\_reserve1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ----------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0xfcb18d115ec808ae02b2fe4502197fc1533c683e | false | 40 | 80730505780956716 | 2134729552858 | 8984247 | 2024-09-19T20:38:29.000Z | 0x7b335c486b17236c24fd683d28186a5fb5c22c8d614231ac87d1be529d1babd4 |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0xfcb18d115ec808ae02b2fe4502197fc1533c683e | false | 43 | 80441858724068232 | 2142295293435 | 8981009 | 2024-09-19T18:50:33.000Z | 0x49d57e4805b41686e26a467f5f7e14407cfde8c9016442ba1c8ff6a3e1c96663 |
| 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0xfcb18d115ec808ae02b2fe4502197fc1533c683e | false | 1006 | 78103477040550357 | 2206239945611 | 8957376 | 2024-09-19T05:42:47.000Z | 0x71284704633befad8bebc78d73668fbdf769dbdd62f08cbae1b5ae962d7390c7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory03_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory03\_Transfer\_event
ERC-20 liquidity pool (LP) token transfer events from Thruster V1 decentralized exchange (DEX) factory contract on Blast. Tracks LP token mints, burns, and transfers between liquidity providers for analyzing pool participation and position changes.
| 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_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `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_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| in\_to | address | in\_from | in\_pair | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x372894955a6f02510607e129f8286593ccc5df62 | 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0xc3ecadb7a5fab07c72af6bcfbd588b7818c4a40e | 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 3216473438034784 | 16 | 6070378 | 2024-07-14T09:49:31.000Z | 0xaebef4dbc5a6e1c2a24f85e859842c50b1e618afc85b153fd2eee9a27a64a3fb |
| 0x84483fd26d4348d6fcb683fbc6ce75739d0e2322 | 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0xc3ecadb7a5fab07c72af6bcfbd588b7818c4a40e | 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 1061265073023884480 | 26 | 6085653 | 2024-07-14T18:18:41.000Z | 0x03be3326b757362641a55ca06905bff2138c42d2a60ee4e3335171214f95c5c8 |
| 0xb46bbe83db7847b7aca6109351257cd0821c2f11 | 0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13 | 0x0000000000000000000000000000000000000000 | 0x12c69bfa3fb3cba75a1defa6e976b87e233fc7df | false | 17143702131162143152 | 39 | 6080411 | 2024-07-14T15:23:57.000Z | 0x602c3ca1ae07fb9e0c76d14e9ff3eeb43bd2f3ca747f7e4e13424dd02952ce8a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory03_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory1\_ClaimGas\_event
Gas claim events from Thruster V1 DEX factory contract on Blast. Records gas fee rebates distributed to recipients, leveraging Blast's native gas revenue sharing mechanism for protocol participants.
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or 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. |
| address | removed | in\_amount | log\_index | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ----------------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | false | 94427985796411971 | 82 | 5166797 | 0xbd84b689f7b1c335f7f643c844a77ee5f09108d8 | 2024-06-23T11:50:09.000Z | 0xcbe92b70803b775790ce372adb3900518efcfbadaad7c41706b5c3acea8b2d7e |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | false | 3381556466340118 | 86 | 11008662 | 0x2a9d4fbc2142434ed6565e6174e23b599dbac3b1 | 2024-11-05T17:18:59.000Z | 0x5dc231ae1e05d40dce2249c5c5048b091e5f591fceb1bbca0b0b7d89d723c4f8 |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | false | 3037398946866943 | 120 | 9692688 | 0x2a9d4fbc2142434ed6565e6174e23b599dbac3b1 | 2024-10-06T06:13:11.000Z | 0xd9f3a1361866ee78bcebed079731bcf1256b919050a25780082bb44cb7db3d4a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory1_ClaimGas_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory1\_PairCreated\_event
Liquidity pool creation events from Thruster DEX (Decentralized Exchange) v1 factory contract on Blast, recording token pairs, pool addresses, and sequential pair identifiers for tracking new trading pool deployments.
| 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_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_anon3` | `STRING` | Sequential counter tracking the total number of pairs created by the factory contract. |
| address | in\_pair | removed | in\_anon3 | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | --------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x9081817fee6a0fd20dccff5d1d9682929a5adc96 | false | 295 | 0x1d0dceba1b8a74ff7d273ddaa1901de9d297f9c1 | 0x4300000000000000000000000000000000000004 | 36 | 4708418 | 2024-06-12T21:10:51.000Z | 0x44ab96a431c925b6239e99038aaaa14b8a3a25dc80f764e178cb95f988fbe81f |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x8cad5cf7ab1675e913c4d35ab9dcdc5418de4010 | false | 234 | 0x4300000000000000000000000000000000000003 | 0x764933fbad8f5d04ccd088602096655c2ed9879f | 9 | 1377272 | 2024-03-27T18:32:39.000Z | 0xf3e9c14426fc7a53df6402aa4c467d1ace0df6b9d1e47ca9bd244217f80d852d |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x89b91090d5decedb37d742fcf7193bb50989a7a6 | false | 235 | 0x4300000000000000000000000000000000000004 | 0x818a92bc81aad0053d72ba753fb5bc3d0c5c0923 | 61 | 1382142 | 2024-03-27T21:14:59.000Z | 0x3a69e7e2039e5a573bae6d34ddf3169967376bfcdb38dd9476f5cbcabaa346e6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory1_PairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory1\_SetYieldCut\_event
Factory configuration events from Thruster V1 DEX on Blast tracking yield cut parameter changes. Records updates to the protocol's yield distribution settings with the new yield cut value applied to liquidity pools.
| 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_yieldCut` | `STRING` | The percentage of yield allocated to the protocol from liquidity pools, stored as a numeric string. Based on the sample value of '2', this represents a 2% cut of generated yield. |
| address | removed | log\_index | in\_yieldCut | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | false | 18 | 2 | 1957642 | 2024-04-10T04:58:19.000Z | 0x36d7a183a06ddd412610b3ccbbd775994b30306ab01aa509f600d1686177cb40 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory1_SetYieldCut_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory1\_SetYieldTo\_event
Yield recipient configuration events from the Thruster V1 factory contract on Blast, recording changes to the address designated to receive protocol yield. Used for tracking yield distribution setup and protocol fee beneficiary changes.
| 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_yieldTo` | `STRING` | Blast chain address designated to receive yield generated by the Thruster factory contract. Can be set to the zero address (0x000...000) to disable yield collection. |
| address | removed | log\_index | in\_yieldTo | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | false | 17 | 0x99304d25d7c72979d67b4ee3851e4cff3e53e166 | 1957642 | 2024-04-10T04:58:19.000Z | 0x36d7a183a06ddd412610b3ccbbd775994b30306ab01aa509f600d1686177cb40 |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | false | 2 | 0x0000000000000000000000000000000000000000 | 20788812 | 2025-06-20T02:43:59.000Z | 0xac9693453e29bbe717f4e6b91c8231cad0c11f870e4bd83abf1fcefd9b836390 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory1_SetYieldTo_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory1\_SetYieldToSetter\_event
*No description available.*
| 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_newYieldToSetter` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory1_SetYieldToSetter_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory1\_Swap\_event
Token swap events from Thruster DEX (Automated Market Maker) on Blast network. Records input/output amounts and trading pair addresses for analyzing exchange activity and liquidity pool performance.
| 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_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `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. |
| in\_to | address | in\_pair | removed | in\_sender | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ----------------------- | ---------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0c04b1316865dada142312165ac39d146e890f74 | 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0xa9f4fd60150f3c2a8defc1707f8a1b04ea4c0e73 | false | 0x0c04b1316865dada142312165ac39d146e890f74 | 32 | 8231412 | 0 | 94014783582870204492301 | 15451552918749081 | 0 | 2024-09-02T10:23:59.000Z | 0xce7b23c12bdc00968297ca9bf9afc973ebed612ca29f7f3b35be8640a8736f24 |
| 0x7bba508ace1e31c9a20e2d241554f396ef82d015 | 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x05d941a5cfec19326bbdbeb72cd6eadc6e101555 | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 15 | 8229836 | 0 | 3184000000000000 | 3542259393240696441374 | 0 | 2024-09-02T09:31:27.000Z | 0xb1bb40ce4c6a7a14bca5c585cbde51ae351eafa4f8bf6262b876d76a46b3d4ad |
| 0x28e4ff4dd35bcacb040ad6cfd8283eed459b2e2e | 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x35a5f5d3cafbb12d7aad2c85a136b6d2334c635e | false | 0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e | 17 | 8221988 | 0 | 995500000000000 | 340273654800872815645 | 0 | 2024-09-02T05:09:51.000Z | 0x5b1cffad5ab8f668d1583c5202f39c976ea495e9ecadb74ac12bcb4d3978b1b8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory1_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory1\_Sync\_event
Liquidity pool reserve balance updates from Thruster V1 DEX (decentralized exchange) on Blast, emitted when pool states change due to swaps or liquidity operations. Used for tracking real-time pool composition and calculating price movements across trading pairs.
| 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_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `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. |
| address | in\_pair | removed | log\_index | in\_reserve0 | in\_reserve1 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------ | ----------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 25 | 817739207730558299 | 63579312536130385236849 | 7768718 | 2024-08-22T17:20:51.000Z | 0x601ee4eacad848501793ec75f0029302b7ea29907e76209fa5b6b65b4fd1eeea |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 31 | 824851044519767603 | 63025633198413046168437 | 7763266 | 2024-08-22T14:19:07.000Z | 0x3f764a32fbad970a5c7fea10f36a28d9ecbd58519a22d2cc05f4275c2387dafb |
| 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 49 | 833315096672520689 | 62379076598913721499196 | 7753627 | 2024-08-22T08:57:49.000Z | 0x03751da7cfc82370ef0747cf06e6ddc4364e8abfc3f72949a2756908a7cd142b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory1_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterFactory1\_Transfer\_event
Liquidity pool (LP) token transfer events from Thruster V1 DEX factory on Blast, tracking minting, burning, and transfers of LP tokens between addresses. Used for analyzing liquidity provision activity and LP token flows across Thruster trading pairs.
| 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_pair` | `STRING` | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string. |
| `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_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| in\_to | address | in\_from | in\_pair | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0xd32f1644b7a8a4e62d19a5bd8fdd4337b155c3aa | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 8478833849768051234 | 5 | 973346 | 2024-03-18T10:08:27.000Z | 0xeb97b47bc1bd71e640c517a8e40dc1307783cbd7048ea576ff69f16a9c94abad |
| 0x0000000000000000000000000000000000000000 | 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 8478833849768051234 | 7 | 973346 | 2024-03-18T10:08:27.000Z | 0xeb97b47bc1bd71e640c517a8e40dc1307783cbd7048ea576ff69f16a9c94abad |
| 0xa42e1debeba42786a4d2b8226927291462271e96 | 0x37836821a2c03c171fb1a595767f4a16e2b93fc4 | 0x0000000000000000000000000000000000000000 | 0x0f02580e21a0e8241add50e56e1cbc72aa33b4a7 | false | 47582405075961525612 | 16 | 969791 | 2024-03-18T08:09:57.000Z | 0xc4d0559c8c4a5df871c69f256dd76edbe903a42a08d99bbe1aa67bcb5f0a6a40 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterFactory1_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterPoolFactory\_ClaimGas\_event
Gas claim events from Thruster V1 DEX pool factory on Blast, tracking when liquidity providers withdraw accumulated gas rebates with recipient addresses and claim amounts in wei.
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or 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. |
| address | removed | in\_amount | log\_index | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | false | 3220278105073926643 | 10 | 1751912 | 0xbd84b689f7b1c335f7f643c844a77ee5f09108d8 | 2024-04-05T10:40:39.000Z | 0xdfd96f7afd08b5fb0c9cb1b53fe1bd9aeb6271aa10e38d621c612ef82a2f7257 |
| 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | false | 171558991128599745 | 46 | 9692688 | 0x2a9d4fbc2142434ed6565e6174e23b599dbac3b1 | 2024-10-06T06:13:11.000Z | 0xd9f3a1361866ee78bcebed079731bcf1256b919050a25780082bb44cb7db3d4a |
| 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | false | 88203462152608462 | 55 | 11008662 | 0x2a9d4fbc2142434ed6565e6174e23b599dbac3b1 | 2024-11-05T17:18:59.000Z | 0x5dc231ae1e05d40dce2249c5c5048b091e5f591fceb1bbca0b0b7d89d723c4f8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterPoolFactory_ClaimGas_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterPoolFactory\_FeeAmountEnabled\_event
Fee tier configuration events from Thruster V1 DEX factory contract on Blast, recording when new fee levels (0.01% to 1%) and their associated tick spacings are enabled for liquidity pool creation. Used to track available pool configurations and protocol governance changes.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_tickSpacing` | `INT64` | Minimum price movement increment between adjacent ticks in a concentrated liquidity pool. |
| in\_fee | address | removed | log\_index | block\_number | in\_tickSpacing | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ---------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 500 | 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | false | 2 | 158621 | 10 | 2024-02-28T13:30:57.000Z | 0x9c88195007582abc140d2c10aad94d2383800f5758569b2ffd1abb0d7dc66051 |
| 3000 | 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | false | 3 | 158621 | 60 | 2024-02-28T13:30:57.000Z | 0x9c88195007582abc140d2c10aad94d2383800f5758569b2ffd1abb0d7dc66051 |
| 10000 | 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | false | 4 | 158621 | 200 | 2024-02-28T13:30:57.000Z | 0x9c88195007582abc140d2c10aad94d2383800f5758569b2ffd1abb0d7dc66051 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterPoolFactory_FeeAmountEnabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterPoolFactory\_OwnerChanged\_event
Ownership transfer events from Thruster V1 DEX pool factory contract on Blast, recording transitions between old and new owner addresses. Useful for tracking protocol governance changes and administrative control transfers.
| 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_oldOwner` | `STRING` | Address of the previous owner before an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_newOwner` | `STRING` | Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | in\_newOwner | in\_oldOwner | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | false | 0 | 0x3b143ca171194c97183ef51b0d56554aa68d0588 | 0xd6b64e44aae0938118ad0dae251b859d85351c22 | 158631 | 2024-02-28T13:31:17.000Z | 0x8a5dc792cf676316ccb8925157475b5736c2e303461367e36df168d4b580d256 |
| 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | false | 0 | 0xd6b64e44aae0938118ad0dae251b859d85351c22 | 0x0000000000000000000000000000000000000000 | 158621 | 2024-02-28T13:30:57.000Z | 0x9c88195007582abc140d2c10aad94d2383800f5758569b2ffd1abb0d7dc66051 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterPoolFactory_OwnerChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterPoolFactory\_PoolCreated\_event
Liquidity pool creation events from Thruster DEX (decentralized exchange) v1 on Blast, capturing new pool deployments with token pairs, fee tiers (0.05%, 0.3%, 1%), and tick spacing configurations. Useful for tracking pool launches and analyzing DEX liquidity structure evolution.
| 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_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| `in_tickSpacing` | `INT64` | Minimum price movement increment between adjacent ticks in a concentrated liquidity pool. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_fee | address | in\_pool | removed | in\_token0 | in\_token1 | log\_index | block\_number | in\_tickSpacing | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 3000 | 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | 0x306210c082317727332ab2db497f6ffb737d3a6e | false | 0x04c0599ae5a44757c0af6f9ec3b93da8976c150a | 0x818a92bc81aad0053d72ba753fb5bc3d0c5c0923 | 364 | 5052659 | 60 | 2024-06-20T20:25:33.000Z | 0x5ebef4e2941823d3a546294e7525278de84949ef524fbbb2b7c230edc106b961 |
| 3000 | 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | 0x16790c5faea4f735a47cdfb293f8e348f0c2109c | false | 0x1da40c742f32bbee81694051c0ee07485fc630f6 | 0x4300000000000000000000000000000000000003 | 119 | 5019910 | 60 | 2024-06-20T02:13:55.000Z | 0x502184b3ca7bb30e59fb8f0483050c47a7c0d87acc1f45732f4c1f461fedf5d7 |
| 3000 | 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | 0xb8bcfccb4c258b8ff72ad87b0072eb0d912607c2 | false | 0x42e12d42b3d6c4a74a88a61063856756ea2db357 | 0x491e6de43b55c8eae702edc263e32339da42f58c | 226 | 5035339 | 60 | 2024-06-20T10:48:13.000Z | 0x42b8af15907dc1fa7165fe863306304a993d0fcfdfe12c554ae90670d72e4a00 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ThrusterPoolFactory\_Swap\_event
Swap events from Thruster V1 decentralized exchange pools on Blast, capturing token exchanges with amounts, price ticks, and liquidity state. Used for analyzing DEX trading activity, price movements, and liquidity provider performance across Uniswap V3-style concentrated liquidity pools.
| 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount0` | `STRING` | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amount1` | `STRING` | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
| `in_sqrtPriceX96` | `STRING` | Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers. |
| `in_liquidity` | `STRING` | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination. |
| `in_tick` | `INT64` | Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool's tick spacing grid. |
| address | in\_pool | in\_tick | removed | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_liquidity | in\_recipient | block\_timestamp | in\_sqrtPriceX96 | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | -------- | ------- | ------------------------------------------ | ---------- | ------------------ | ------------------------ | ------------- | ------------------------ | ------------------------------------------ | ------------------------ | -------------------------------- | ------------------------------------------------------------------ |
| 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | 0x14c5766f8556683af2d8023e389837044794795a | 119180 | false | 0x0000000000005d737fd1a47e86abb3211bdf46e3 | 3 | 134662468768855327 | -20157668222772003272447 | 6991770 | 27170817748766673779467 | 0x0000000000005d737fd1a47e86abb3211bdf46e3 | 2024-08-04T17:42:35.000Z | 30669952620649277929122305843396 | 0x86a6723e3c12c219be514ab6cf8075ebb1d0a1c1987aa1dd8c0512fa24a6dcdb |
| 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | 0x14c5766f8556683af2d8023e389837044794795a | 118482 | false | 0x0000000000005d737fd1a47e86abb3211bdf46e3 | 17 | -93282587412204974 | 13059136432337694141513 | 6990841 | 27780294787504698677319 | 0x0000000000005d737fd1a47e86abb3211bdf46e3 | 2024-08-04T17:11:37.000Z | 29618053293854239004037778006082 | 0x4f3e2550af1d0198d5787c685b00ea8e446ff78f335682f34285df33cbf9c5ed |
| 0x71b08f13b3c3af35aadeb3949afeb1ded1016127 | 0x32fdf42095aaecfea06f8ec26a361475f3603cb9 | 124660 | false | 0x0000000000005d737fd1a47e86abb3211bdf46e3 | 3 | 103152105001717967 | -26727633078169987781022 | 6966190 | 485049653849083714947160 | 0x0000000000005d737fd1a47e86abb3211bdf46e3 | 2024-08-04T03:29:55.000Z | 40337212845509716505372318099548 | 0x6a5eb04fc499cfe6b18e6d6344e39a4b401cd4a43d86ef04867bb062f5377e33 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.ThrusterPoolFactory_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TokenDistributor\_Claimed\_event
Token claim events from Thruster DEX (Decentralized Exchange) v1 on Blast chain, recording when users claim distributed tokens with claimed amounts and claimer addresses. Used for analyzing token distribution patterns and user participation in airdrops or rewards programs.
| 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_claimer` | `STRING` | Address of the account initiating the claim transaction. 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. |
| address | removed | in\_amount | log\_index | in\_claimer | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x29903f1e60aea99ac4319e6e7923e0b4bfa7f05e | false | 10434220924282308608 | 1 | 0xd3f781b324d703cbc9d01be45d371b8bed580925 | 10024274 | 2024-10-13T22:26:03.000Z | 0x0bf30cf49ae0c0de4a190b860134cbdccf6e29330383e3262a8e92ae90707736 |
| 0x29903f1e60aea99ac4319e6e7923e0b4bfa7f05e | false | 7947785922528303104 | 1 | 0x86d870ad86c5a8452a55a3315eae11a1f518934b | 10002052 | 2024-10-13T10:05:19.000Z | 0xc1e604ebfe715d552acebf36f9bf516566335c8dc3471eae9ac8f8b1d46a513a |
| 0x29903f1e60aea99ac4319e6e7923e0b4bfa7f05e | false | 2189469612449702912 | 1 | 0xd0043d6635d1e22de7e187ba60bc2b8bd23fc8db | 9997008 | 2024-10-13T07:17:11.000Z | 0xdfc129b35aa92de4ba7d055239061c84d13e6f875195c8a77bf55a62dc51dae5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.TokenDistributor_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TokenDistributor\_VeClaimed\_event
Vote-escrowed (ve) token claim events from Thruster V1 DEX (decentralized exchange) on Blast, recording when users claim their veTHRUST governance tokens with claimer addresses and claimed amounts.
| 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_claimer` | `STRING` | Address of the account initiating the claim transaction. 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. |
| address | removed | in\_amount | log\_index | in\_claimer | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x29903f1e60aea99ac4319e6e7923e0b4bfa7f05e | false | 42299767273319079936 | 3 | 0x8296fab023a4a024222f31f0f71e05fbebf1750c | 10046993 | 2024-10-14T11:03:21.000Z | 0x178f6b03fec9e26d5921d97c4128625fa8889677893a44c93af8a9d6b9c0c944 |
| 0x29903f1e60aea99ac4319e6e7923e0b4bfa7f05e | false | 27866014191727480832 | 3 | 0x96ece6a28e6328119f27cb15539dc5df332aaa51 | 10046265 | 2024-10-14T10:39:05.000Z | 0x577b0440818464edbff36b7e7d5d509909d43269432731c680190bda38c7fcc3 |
| 0x29903f1e60aea99ac4319e6e7923e0b4bfa7f05e | false | 7609474489005999104 | 3 | 0x11991696f2d5187c7a6436b28ea3bea2ac87b240 | 10059396 | 2024-10-14T17:56:47.000Z | 0x47c55aa7269361d8db7273111497687f8caccbbf9fb3987587b84488bda3e3c4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thruster_v1_blast.TokenDistributor_VeClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***