> ## 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.
# traderjoe_v2_avalanche
> Tables in tt-contracts.traderjoe_v2_avalanche
## Tables
### LBFactory\_FeeParametersSet\_event
Fee configuration events from Trader Joe V2 liquidity book (LB) factory contract on Avalanche, capturing dynamic fee parameter updates for individual trading pairs. Used for analyzing fee tier changes, volatility-based fee mechanisms, and protocol revenue share adjustments across different bin steps.
| 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_LBPair` | `STRING` | Contract address of the Trader Joe V2 liquidity book pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_binStep` | `STRING` | Price bin step size for the Trader Joe V2 liquidity pool. Numeric string representing the step granularity in basis points. |
| `in_baseFactor` | `STRING` | Base fee multiplier for the Trader Joe V2 liquidity pool. Numeric string denominated in basis points. |
| `in_filterPeriod` | `STRING` | Time window used to filter and smooth volatility measurements in the Trader Joe V2 fee model. Numeric string representing seconds. |
| `in_decayPeriod` | `STRING` | Time period over which volatility accumulation decays in the Trader Joe V2 fee model. Numeric string representing seconds. |
| `in_reductionFactor` | `STRING` | Multiplier applied to reduce accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. |
| `in_variableFeeControl` | `STRING` | Sensitivity parameter controlling how quickly fees adjust to volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. |
| `in_protocolShare` | `STRING` | Percentage of trading fees allocated to the protocol in the Trader Joe V2 fee model. Numeric string denominated in basis points. |
| `in_maxVolatilityAccumulated` | `STRING` | Maximum accumulated volatility threshold for the liquidity bin pair's dynamic fee calculation. Numeric value representing the cap on volatility accumulation, commonly set to 100000-350000 in Trader Joe V2 configurations. |
| address | removed | in\_LBPair | in\_sender | log\_index | in\_binStep | block\_number | in\_baseFactor | in\_decayPeriod | block\_timestamp | in\_filterPeriod | in\_protocolShare | transaction\_hash | in\_reductionFactor | in\_variableFeeControl | in\_maxVolatilityAccumulated |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | -------------- | --------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------- | ---------------------- | ---------------------------- |
| 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 0x761969787f55cc9f6ccae3a46ca9f0108b160934 | 0x2fbb61a10b96254900c03f1644e9e1d2f5e76dd2 | 5 | 1 | 22707311 | 20000 | 120 | 2022-11-22T17:43:46.000Z | 10 | 0 | 0x6a0efd61c868c5cded03f3c4e37baa8719895d2c4ea7fb3b3f27e59f3dadf7ac | 5000 | 2000000 | 100000 |
| 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 0xbc811ef83fb68c25eedf83767e24a2de0262aca6 | 0x2fbb61a10b96254900c03f1644e9e1d2f5e76dd2 | 8 | 1 | 22707311 | 20000 | 120 | 2022-11-22T17:43:46.000Z | 10 | 0 | 0x6a0efd61c868c5cded03f3c4e37baa8719895d2c4ea7fb3b3f27e59f3dadf7ac | 5000 | 2000000 | 100000 |
| 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 0x42be75636374dfa0e57eb96fa7f68fe7fcdad8a3 | 0x2fbb61a10b96254900c03f1644e9e1d2f5e76dd2 | 45 | 10 | 23927866 | 10000 | 600 | 2022-12-21T16:09:57.000Z | 30 | 0 | 0xf411a21233eee712daab01293ad6993aaa07800ff09f2e2fc82f38e1753b142e | 5000 | 40000 | 350000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBFactory_FeeParametersSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactory\_FeeRecipientSet\_event
Fee recipient address changes for the Trader Joe v2 Liquidity Book (LB) factory contract on Avalanche. Tracks governance updates to protocol fee collection addresses 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_oldRecipient` | `STRING` | Address of the previous fee recipient before the protocol fee recipient was updated. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_newRecipient` | `STRING` | Address of the updated fee recipient for the protocol. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_newRecipient | in\_oldRecipient | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 29 | 29180546 | 2023-04-24T23:25:27.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0x1119fbb02f38764cd90f2d9fb35fedcd8378ac2a | 0xf96970a23b3b95605852769c21fd393f3d8324201d890824fa31db8ad2adc985 |
| 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 3 | 22426953 | 2022-11-15T23:25:00.000Z | 0x1119fbb02f38764cd90f2d9fb35fedcd8378ac2a | 0x0000000000000000000000000000000000000000 | 0x2b8f6617ecb3fdf1d6e8b21a8fb03fa8380fd147a7cd9942d0d5e541a7755f21 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBFactory_FeeRecipientSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactory\_FlashLoanFeeSet\_event
Flash loan fee configuration changes from the Trader Joe V2 Liquidity Book (LB) factory contract on Avalanche. Tracks administrative updates to flash loan fee parameters with old and new values for monitoring protocol fee structure adjustments.
| 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_oldFlashLoanFee` | `STRING` | Previous flash loan fee value denominated in basis points. Numeric string representing the fee charged on flash loans before the change. |
| `in_newFlashLoanFee` | `STRING` | Updated flash loan fee value denominated in basis points. Numeric string representing the fee charged on flash loans after the change. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newFlashLoanFee | in\_oldFlashLoanFee |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- | ------------------- |
| 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 4 | 22426953 | 2022-11-15T23:25:00.000Z | 0x2b8f6617ecb3fdf1d6e8b21a8fb03fa8380fd147a7cd9942d0d5e541a7755f21 | 5000000000000 | 0 |
| 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 1 | 24198931 | 2022-12-28T03:47:35.000Z | 0xd4e942aea7f7ad2e8e922bdbf83504c9fd399ed74809e749d6d4d2e305fdc4a6 | 0 | 5000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBFactory_FlashLoanFeeSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactory\_LBPairCreated\_event
Liquidity Book (LB) pair creation events from Trader Joe V2 decentralized exchange on Avalanche, recording new trading pool deployments with token addresses and bin step parameters. Used for tracking pool launches and analyzing market structure across different fee tiers.
| 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_tokenX` | `STRING` | Contract address of the first token in a liquidity pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenY` | `STRING` | Contract address of the second token in a liquidity pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_binStep` | `STRING` | Price bin step size for the Trader Joe V2 liquidity pool. Numeric string representing the step granularity in basis points. |
| `in_LBPair` | `STRING` | Contract address of the Trader Joe V2 liquidity book pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pid` | `STRING` | Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID. |
| in\_pid | address | removed | in\_LBPair | in\_tokenX | in\_tokenY | log\_index | in\_binStep | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 4 | 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 0xe4e7aaa5a1aab5b55ee44fab2d5dd6fcd80e4d42 | 0x50b7545627a5162f82a992c33b87adc75187b218 | 0x152b9d0fdc40c096757f570a51e494bd4b943e50 | 30 | 2 | 22442423 | 2022-11-16T08:30:56.000Z | 0xe9efcad9cdf96e9ddb323ab03b6d1e4bf0160019308584d95b2d22b93f515505 |
| 5 | 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 0xa7687be7174721178cfd7aa1ae590209649fc0b8 | 0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 33 | 5 | 22442423 | 2022-11-16T08:30:56.000Z | 0xe9efcad9cdf96e9ddb323ab03b6d1e4bf0160019308584d95b2d22b93f515505 |
| 2 | 0x6e77932a92582f504ff6c4bdbcef7da6c198aeef | false | 0x12ef33ed026d6eeb6c1ea90e97401ddf3d45f569 | 0xc7198437980c041c805a1edcba50c1ce5db95118 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 24 | 1 | 22442423 | 2022-11-16T08:30:56.000Z | 0xe9efcad9cdf96e9ddb323ab03b6d1e4bf0160019308584d95b2d22b93f515505 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBFactory_LBPairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactoryV2\_FeeRecipientSet\_event
Fee recipient address change events from Trader Joe V2 Liquidity Book (LB) factory contract on Avalanche. Tracks protocol fee collection address updates for analyzing fee distribution and 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_oldRecipient` | `STRING` | Address of the previous fee recipient before the protocol fee recipient was updated. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_newRecipient` | `STRING` | Address of the updated fee recipient for the protocol. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_newRecipient | in\_oldRecipient | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 5 | 28371397 | 2023-04-06T00:45:25.000Z | 0xc8fc59fceb8259534d8b10879273879eddf7eec0 | 0x0000000000000000000000000000000000000000 | 0x4fbbe17808790bb38e851c8e24287871c4a2897cea2665ebee6c4d5daab7fe85 |
| 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 28 | 29180546 | 2023-04-24T23:25:27.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0xc8fc59fceb8259534d8b10879273879eddf7eec0 | 0xf96970a23b3b95605852769c21fd393f3d8324201d890824fa31db8ad2adc985 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBFactoryV2_FeeRecipientSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactoryV2\_FlashLoanFeeSet\_event
Flash loan fee configuration changes for Trader Joe V2 liquidity book pools on Avalanche. Tracks updates to the protocol's flash loan fee parameter with old and new values for analyzing fee policy 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_oldFlashLoanFee` | `STRING` | Previous flash loan fee value denominated in basis points. Numeric string representing the fee charged on flash loans before the change. |
| `in_newFlashLoanFee` | `STRING` | Updated flash loan fee value denominated in basis points. Numeric string representing the fee charged on flash loans after the change. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newFlashLoanFee | in\_oldFlashLoanFee |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- | ------------------- |
| 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 6 | 28371397 | 2023-04-06T00:45:25.000Z | 0x4fbbe17808790bb38e851c8e24287871c4a2897cea2665ebee6c4d5daab7fe85 | 5000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBFactoryV2_FlashLoanFeeSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactoryV2\_LBPairCreated\_event
Trader Joe V2 Liquidity Book (LB) pair creation events emitted when new liquidity pools are deployed by the LBFactory contract. Contains token pair addresses, pool identifier, bin step size for price granularity, and the deployed LBPair contract address.
| 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_tokenX` | `STRING` | Contract address of the first token in a liquidity pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenY` | `STRING` | Contract address of the second token in a liquidity pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_binStep` | `STRING` | Price bin step size for the Trader Joe V2 liquidity pool. Numeric string representing the step granularity in basis points. |
| `in_LBPair` | `STRING` | Contract address of the Trader Joe V2 liquidity book pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pid` | `STRING` | Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID. |
| in\_pid | address | removed | in\_LBPair | in\_tokenX | in\_tokenY | log\_index | in\_binStep | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 420 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0x9322593fe08c4dbe3ee7f8107fd5da273d3d5bd9 | 0x13e7bcefdde72492e656f3fa58bae6029708e673 | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 4 | 25 | 35306974 | 2023-09-17T15:43:31.000Z | 0xbb32b88731556c2da72a9712afd331c08432e534c5aff7c9e507102bf0ba2748 |
| 419 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0x3a716463892833591fbe425107304d7825c0f3c4 | 0xf9d922c055a3f1759299467dafafdf43be844f7a | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 2 | 100 | 35285220 | 2023-09-17T03:17:36.000Z | 0x18ad0a8c064026b751453eba78a1363dfb66de6499d7d345b5811872c109e32d |
| 273 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0xb47182a94b93da5326beab3ebd3b2221472d5373 | 0x17677b110273c982eab3f9e6691a5aaaddac9294 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 9 | 100 | 31047548 | 2023-06-08T01:33:33.000Z | 0x53eed2682c54cb19aba1af89540582f13774d439cf1820c8f936a41bb319dfc7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBFactoryV2_LBPairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactoryV22\_LBPairCreated\_event
Liquidity Book (LB) trading pair creation events from Trader Joe V2.2 factory contract on Avalanche, capturing new pool deployments with token addresses, bin step parameters, and unique pair identifiers (pid). Used for tracking DEX liquidity pool launches and analyzing fee tier distributions 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_tokenX` | `STRING` | Contract address of the first token in a liquidity pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenY` | `STRING` | Contract address of the second token in a liquidity pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_binStep` | `STRING` | Price bin step size for the Trader Joe V2 liquidity pool. Numeric string representing the step granularity in basis points. |
| `in_LBPair` | `STRING` | Contract address of the Trader Joe V2 liquidity book pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pid` | `STRING` | Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID. |
| in\_pid | address | removed | in\_LBPair | in\_tokenX | in\_tokenY | log\_index | in\_binStep | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 33 | 0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c | false | 0x67d07097c29aaffa9194ba90ca0e03200e8dd410 | 0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 4 | 100 | 47392000 | 2024-06-30T22:24:22.000Z | 0x2f406e47147b7167b32aa3f03531001b0ab249980c4033ba4a0db00be4399cc2 |
| 32 | 0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c | false | 0xd5cd28f57c282cb2206747368d45aaff11d73bc9 | 0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 0 | 50 | 47391825 | 2024-06-30T22:18:20.000Z | 0x32573ca73dcad049feefbf84365075accc1b44d0717d57e74a25f493b0b5640a |
| 31 | 0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c | false | 0xaa40a4cccaf04bf3c8890e67877b012704ee6264 | 0x147929393f770869ad635ce284d66911798d9a5c | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 12 | 50 | 47373609 | 2024-06-30T11:54:36.000Z | 0x9ce1f5353f4fedf04a8920b91e9b7502037e02d076dfaf4a965b0a9902cb6c36 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBFactoryV22_LBPairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_CompositionFee\_event
Composition fee collection events from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, tracking fees earned in token X and Y by liquidity providers. Used to analyze fee revenue distribution across liquidity bins and measure LP earnings.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_feesX` | `STRING` | Composition fee collected in token X for the Trader Joe V2 liquidity bin specified by in\_id. Typically zero in sample data, indicating no fees collected in the X token during these transactions. |
| `in_feesY` | `STRING` | Composition fees collected in token Y for the specified liquidity bin on Trader Joe V2. Denominated in token Y's smallest unit (wei-equivalent), typically non-zero when in\_feesX is zero. |
| in\_id | address | removed | in\_feesX | in\_feesY | in\_sender | log\_index | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | --------- | --------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8362928 | 0xf43f906250bea2d84aeaaf28bd7ac74d5c8dbfb6 | false | 0 | 105 | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 62 | 25939690 | 0xe699e8334d901986d9ff6bc5ae4b44ae5122f1ee | 2023-02-07T06:20:37.000Z | 0xee0f2be18ce4b6c5cf55f6920364ea7a8adf560f92b0fcbed5a83f5cf8a271b4 |
| 8375103 | 0x5851e2d6396bcc26fb9eee21effbf99e0d2b2148 | false | 0 | 28053 | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 36 | 25928961 | 0x72cccefec6bd06c938c1ccaf315aeb16ce91ce34 | 2023-02-07T00:18:17.000Z | 0x089ee5d9702e03ec9d1a3a51395710aec9da279b06ea0bb1881debbbac61d0da |
| 8375105 | 0x5851e2d6396bcc26fb9eee21effbf99e0d2b2148 | false | 0 | 42996 | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 13 | 25930951 | 0xff4f7b726ee86f810531d2842b3bdd8a512db594 | 2023-02-07T01:25:05.000Z | 0x9ae22328f6b080ceb2b3371c592e6248df1674f9f8ccd50fe9d4a05061fc3a6a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPair_CompositionFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_DepositedToBin\_event
Liquidity deposit events from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, recording tokenX and tokenY amounts added to specific price bins. Used for tracking liquidity provision patterns and bin-level capital allocation in 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_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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_amountX` | `STRING` | Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amountY` | `STRING` | Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination. |
| in\_id | address | removed | in\_sender | log\_index | in\_amountX | in\_amountY | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8376213 | 0xb5352a39c11a81fe6748993d586ec448a01f08b5 | false | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 3 | 0 | 5550901764 | 25395491 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 2023-01-25T12:29:25.000Z | 0x00036bddbe5e18e38b30b1081cdc45a4cef12f7629029813524f2c80515aeab8 |
| 8376214 | 0xb5352a39c11a81fe6748993d586ec448a01f08b5 | false | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 5 | 560150433594631662952 | 54492102 | 25395491 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 2023-01-25T12:29:25.000Z | 0x00036bddbe5e18e38b30b1081cdc45a4cef12f7629029813524f2c80515aeab8 |
| 8376205 | 0xb5352a39c11a81fe6748993d586ec448a01f08b5 | false | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 9 | 64767823843330809194 | 9890614517 | 25399257 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 2023-01-25T14:37:33.000Z | 0x00233123e16f5e57b64654199d347b2bf672c63fee324266d29ecc90f56319da |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPair_DepositedToBin_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_FeesCollected\_event
Fee collection events from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, recording accumulated trading fees claimed by liquidity providers. Used to track fee revenue distribution and liquidity provider returns 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amountX` | `STRING` | Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amountY` | `STRING` | Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_sender | log\_index | in\_amountX | in\_amountY | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 0x61921dc906d1576b76e491a7d066c150a108265b | 7 | 0 | 0 | 29685743 | 0x61921dc906d1576b76e491a7d066c150a108265b | 2023-05-06T22:09:48.000Z | 0xfc7a21c8559e606d004c143251b08f3503c02685e7c4708c5e5acc57adc6bd17 |
| 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 0x61921dc906d1576b76e491a7d066c150a108265b | 10 | 0 | 0 | 29653883 | 0x61921dc906d1576b76e491a7d066c150a108265b | 2023-05-06T04:09:20.000Z | 0x9ba0703f6c22535e49104dc11e116714f067459a76042b9095b2965933964c31 |
| 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 0x61921dc906d1576b76e491a7d066c150a108265b | 11 | 0 | 0 | 29675164 | 0x61921dc906d1576b76e491a7d066c150a108265b | 2023-05-06T16:09:37.000Z | 0xbc6588be2e20d63e68ccab7336be2bd223ea5966d1df34d36780de1370b8ab1a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPair_FeesCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_FlashLoan\_event
Flash loan events from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, recording borrowed token amounts, fees, sender/receiver addresses, and pool contract addresses. Used for analyzing flash loan arbitrage patterns and liquidity bootstrapping strategies.
| 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_receiver` | `STRING` | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `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\_fee | address | removed | in\_token | in\_amount | in\_sender | log\_index | in\_receiver | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ----------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0 | 0x1d7a1a79e2b4ef88d2323f3845246d24a3c20f1d | false | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 20073026048 | 0x5a66c9d69deaac0f979c9903ef07b64bb0614b43 | 7 | 0x5a66c9d69deaac0f979c9903ef07b64bb0614b43 | 28153059 | 2023-03-31T22:21:30.000Z | 0xfb6f5f23619af1eca9fc35bb705103bcff15679c95185facdbf552b6defb751f |
| 0 | 0x1d7a1a79e2b4ef88d2323f3845246d24a3c20f1d | false | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 2156865216 | 0x5a66c9d69deaac0f979c9903ef07b64bb0614b43 | 7 | 0x5a66c9d69deaac0f979c9903ef07b64bb0614b43 | 28131749 | 2023-03-31T10:27:12.000Z | 0x04487be5a411aee0e50b9ed26adadbf00c5c0a2bbc33f149efb9e5b1af93ba10 |
| 0 | 0x1d7a1a79e2b4ef88d2323f3845246d24a3c20f1d | false | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 19979723776 | 0x5a66c9d69deaac0f979c9903ef07b64bb0614b43 | 7 | 0x5a66c9d69deaac0f979c9903ef07b64bb0614b43 | 28126758 | 2023-03-31T07:39:29.000Z | 0x9d1fe41a2dd963f3cede72c2669d173c381367707d1b9a8bc99fb21cf1a07402 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPair_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_Swap\_event
Swap event records from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, capturing token exchanges with amounts, fees, bin IDs, and swap direction. Used for analyzing DEX trading volume, liquidity utilization across price bins, and fee generation in concentrated liquidity markets.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_swapForY` | `BOOL` | Indicates the swap direction within the Trader Joe V2 liquidity bin pair (true when swapping token X for token Y, false for Y to X). This boolean determines which token in the pair is being sold and which is being acquired. |
| `in_amountIn` | `STRING` | Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination. |
| `in_amountOut` | `STRING` | Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination. |
| `in_volatilityAccumulated` | `STRING` | Accumulated volatility metric for the Trader Joe V2 liquidity bin at the time of the swap. Always zero in sample data, indicating stable market conditions or unused parameter in this pool configuration. |
| `in_fees` | `STRING` | Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination. |
| in\_id | address | in\_fees | removed | in\_sender | log\_index | in\_amountIn | in\_swapForY | block\_number | in\_amountOut | in\_recipient | block\_timestamp | transaction\_hash | in\_volatilityAccumulated |
| ------- | ------------------------------------------ | ----------------- | ------- | ------------------------------------------ | ---------- | -------------------- | ------------ | ------------- | --------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8112282 | 0xbc811ef83fb68c25eedf83767e24a2de0262aca6 | 12634235884972419 | false | 0x982b21c1ffa10be8e7ca8e35dff87eeaa2702d50 | 6 | 63158545188977121301 | true | 28726846 | 63146082 | 0x982b21c1ffa10be8e7ca8e35dff87eeaa2702d50 | 2023-04-14T07:48:11.000Z | 0xa71392034d4dc8ba8e4abe4b4ac9fa42b413a289cb80cb199ad9ae5f42596e64 | 0 |
| 8112282 | 0xbc811ef83fb68c25eedf83767e24a2de0262aca6 | 2040000000000000 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 25 | 10197960000000000000 | true | 28728413 | 10195947 | 0xf4003f4efbe8691b60249e6afbd307abe7758adb | 2023-04-14T08:40:48.000Z | 0xd657b5681b56d17898622e2c3546536afed0fb5f7f6a175f30f2ae516415634f | 0 |
| 8112282 | 0x855ee438445075f25c18a125ba6607543052a194 | 49859 | false | 0xb2a58c5e5399368716067be72d3548f0927f0fe4 | 7 | 249244507 | false | 28715584 | 249293699303447044401 | 0x1dac32947cd796b4203f69a5a6748e6775d92800 | 2023-04-14T01:29:49.000Z | 0x2bcd7474025d33361d3f5488761334117511c93ae83816ff8ef6f86758956ef4 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPair_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_TransferBatch\_event
Batch liquidity position transfers from Trader Joe v2 liquidity book (LB) pairs on Avalanche, containing bin IDs and token amounts transferred between accounts. Used for tracking multi-bin LP position movements and liquidity provision 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_sender` | `STRING` | Address that initiated the transaction or operation. 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_ids` | `ARRAY` | Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| in\_to | in\_ids | address | in\_from | removed | in\_sender | log\_index | in\_amounts | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c | \["8394238","8394239","8394240","8394241","8394242","8394243","8394244","8394245","8394246","8394247","8394248","8394249","8394250","8394251","8394252","8394253","8394254","8394255"] | 0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c | 0xd13a6119505a470a88ed7ab07818403e5157ce7b | false | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 0 | \["3117552","3117552","3117552","3117552","3117552","1714330","312258","15966579","15966892","15967204","15967518","15654009","15660968","15690999","15706690","15722396","15738119","15753857"] | 28129839 | 2023-03-31T09:23:03.000Z | 0x5813f0cda83dba135f16cccc188c2e17c319ec0be2b5b2c6871c8ed877fedd0a |
| 0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c | \["8394253","8394254","8394255","8394256","8394257","8394258","8394259","8394260","8394261","8394262","8394263"] | 0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c | 0xb92d440fae9c92dbb12c2293e4e4eae357194870 | false | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 0 | \["7159317","7159317","7159317","7159317","7159317","6302157","5457815","5463273","5468736","5474205","5479679"] | 28123610 | 2023-03-31T05:54:13.000Z | 0x40cbd1c4b20a90c8e346259eebe7dc24a334d6f989e35d9d6a2adb60c5a55a0d |
| 0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c | \["8394248","8394249","8394250","8394251","8394252","8394253","8394254","8394255","8394256","8394257","8394258"] | 0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c | 0xff4f7b726ee86f810531d2842b3bdd8a512db594 | false | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 1 | \["27092099","54184199","108368398","162552597","203190746","247561328","209784458","167995450","112108869","56110347","28083087"] | 28126348 | 2023-03-31T07:25:43.000Z | 0x537d18e220c013e49a2aa673153cc8a3117de9945c92c59af0e43abdddaaf382 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPair_TransferBatch_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_TransferSingle\_event
Liquidity bin token transfer events from Trader Joe V2 liquidity book pairs on Avalanche, tracking individual bin position movements between addresses. Used for analyzing liquidity provision activity and LP token ownership changes across price bins.
| 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_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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| in\_id | in\_to | address | in\_from | removed | in\_amount | in\_sender | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 8388612 | 0x0000000000000000000000000000000000000000 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 20008 | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 44 | 23922081 | 2022-12-21T12:55:44.000Z | 0x0048fcc3a253a52c1219b6f52d27867960a2e94634adccb075ea46bb6c559638 |
| 8388604 | 0x0000000000000000000000000000000000000000 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 20000 | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 28 | 23922081 | 2022-12-21T12:55:44.000Z | 0x0048fcc3a253a52c1219b6f52d27867960a2e94634adccb075ea46bb6c559638 |
| 8388608 | 0x0000000000000000000000000000000000000000 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 19999 | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 36 | 23922081 | 2022-12-21T12:55:44.000Z | 0x0048fcc3a253a52c1219b6f52d27867960a2e94634adccb075ea46bb6c559638 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPair_TransferSingle_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_WithdrawnFromBin\_event
Liquidity withdrawal events from Trader Joe V2 liquidity book (LB) pairs on Avalanche, recording tokenX and tokenY amounts removed from specific price bins. Used for tracking liquidity provider position exits and analyzing bin-level liquidity changes 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_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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_amountX` | `STRING` | Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amountY` | `STRING` | Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination. |
| in\_id | address | removed | in\_sender | log\_index | in\_amountX | in\_amountY | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8388611 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 31 | 1805 | 0 | 32170026 | 0x0d3015631c1e642e8eb35b5a0efcea24a7685603 | 2023-07-04T14:34:01.000Z | 0x0ba37de594e61cf9b379f063799e01834a687a54bcff98e69bcd5f810447b621 |
| 8388612 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 33 | 1805 | 0 | 32170026 | 0x0d3015631c1e642e8eb35b5a0efcea24a7685603 | 2023-07-04T14:34:01.000Z | 0x0ba37de594e61cf9b379f063799e01834a687a54bcff98e69bcd5f810447b621 |
| 8388613 | 0x18332988456c4bd9aba6698ec748b331516f5a14 | false | 0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3 | 35 | 1805 | 0 | 32170026 | 0x0d3015631c1e642e8eb35b5a0efcea24a7685603 | 2023-07-04T14:34:01.000Z | 0x0ba37de594e61cf9b379f063799e01834a687a54bcff98e69bcd5f810447b621 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPair_WithdrawnFromBin_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_CollectedProtocolFees\_event
Protocol fee collection events from Trader Joe V2 liquidity book pairs on Avalanche. Records fees withdrawn by the protocol from individual trading pairs, useful for analyzing protocol revenue across different 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_feeRecipient` | `STRING` | Address designated to receive fees collected from the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_protocolFees` | `STRING` | Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_feeRecipient | in\_protocolFees | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x4224f6f4c9280509724db2dbac314621e4465c29 | false | 8 | 36906041 | 2023-10-25T14:43:16.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0x0000000000000000000000001f0ae472000000000000000000000000001567b1 | 0xcd913ac84aea3254315edd29da5cd7998dd2206b534d2d10cfbab4044b70e70b |
| 0xd446eb1660f766d533beceef890df7a69d26f7d1 | false | 5 | 36906041 | 2023-10-25T14:43:16.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0x0000000000000000000000003afa0d460000000000000004a0306793c1e2b8d5 | 0xcd913ac84aea3254315edd29da5cd7998dd2206b534d2d10cfbab4044b70e70b |
| 0x4224f6f4c9280509724db2dbac314621e4465c29 | false | 47 | 30780121 | 2023-06-01T17:43:12.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0x0000000000000000000000001e4988df000000000000000000000000001e6071 | 0xb466adaa6679c66148d45585c7b934d93a4da8402468a454dcff8b33ae6313d6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV2_CollectedProtocolFees_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_CompositionFees\_event
Fee composition events from Trader Joe V2 Liquidity Book pairs on Avalanche, tracking total trading fees and protocol fees collected per transaction. Used for analyzing fee distribution and protocol revenue across 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_totalFees` | `STRING` | Total fees collected from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| `in_protocolFees` | `STRING` | Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| in\_id | address | removed | in\_sender | log\_index | block\_number | in\_totalFees | block\_timestamp | in\_protocolFees | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 8376059 | 0xd446eb1660f766d533beceef890df7a69d26f7d1 | false | 0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc | 72 | 32046247 | 0x000000000000000000000000000000000000000000000000336c78fe8e20fe68 | 2023-07-01T16:38:22.000Z | 0x0000000000000000000000000000000000000000000000000524727fdb034ca4 | 0x9099b1b620b912ef06ee433313b991cfd989ad91acb991e391c3a63f34d84431 |
| 8376059 | 0xd446eb1660f766d533beceef890df7a69d26f7d1 | false | 0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc | 45 | 32049762 | 0x00000000000000000000000000000000000000000000000005edf56763daaa16 | 2023-07-01T18:37:03.000Z | 0x0000000000000000000000000000000000000000000000000097cbbd89fc4435 | 0xd8796cb8eade1f16a247b7727a00870a8b7e35297af8cb4796b4efa4aea4c7c4 |
| 8376059 | 0xd446eb1660f766d533beceef890df7a69d26f7d1 | false | 0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc | 45 | 32033351 | 0x000000000000000000000000021c9cca00000000000000000000000000000000 | 2023-07-01T09:22:48.000Z | 0x00000000000000000000000000360fad00000000000000000000000000000000 | 0x18435f5450fed413ea4ee24630a977c285b126ed662d774dcc5454ea99fe0625 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV2_CompositionFees_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_DepositedToBins\_event
Liquidity deposit events from Trader Joe V2 LBPair contracts recording token amounts deposited into discretized price bins. Bin IDs represent specific price points where liquidity is concentrated, with amounts split between the paired token assets.
| 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_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_ids` | `ARRAY` | Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| in\_to | in\_ids | address | removed | in\_sender | log\_index | in\_amounts | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x05581527c49d84a042e281cc179065b887f1c721 | \["8362692","8362693","8362694","8362695","8362696","8362697","8362698","8362699","8362700","8362701","8362702","8362703","8362704","8362705","8362706","8362707","8362708","8362709","8362710","8362711","8362712","8362713","8362714","8362715","8362716","8362717","8362718","8362719","8362720"] | 0x16396b65d5e0794c44447396f94665d3b9f576a0 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 13 | \["0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000003b910100000000000000000000000000000000","0x000000000000000000000000001dc8800000000000000000058778b106782f1e","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72","0x0000000000000000000000000000000000000000000000000b0f2239c7344d72"] | 36240414 | 2023-10-09T16:55:20.000Z | 0xd05d37653445a7ed6ab6e548fe5c73ee0f62718223103ae46da96b26d0a8b803 |
| 0x170ddec929b8dfdfadbaba9bf994d9f3f7343cf1 | \["8362706","8362707","8362708","8362709","8362710","8362711","8362712","8362713","8362714","8362715","8362716","8362717","8362718","8362719","8362720","8362721","8362722","8362723","8362724","8362725","8362726","8362727","8362728","8362729","8362730","8362731","8362732","8362733","8362734"] | 0x16396b65d5e0794c44447396f94665d3b9f576a0 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 8 | \["0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000007f431400000000000000000000000000000000","0x000000000000000000000000003fa18a000000000000000009c04117a980a27c","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a","0x0000000000000000000000000000000000000000000000001380b18083d8621a"] | 36231164 | 2023-10-09T11:40:00.000Z | 0xb982e7a9f17f919c6c712b43cb70a8aa4f21aa0b7caac9483ea3609a276e9c8e |
| 0x71d725c16f6f2dfb3c49557245d9b7fcb872ec3a | \["8362710","8362711","8362712","8362713","8362714","8362715","8362716","8362717","8362718","8362719","8362720"] | 0x16396b65d5e0794c44447396f94665d3b9f576a0 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 6 | \["0x00000000000000000000000000000000000000000000000009b3fff6f95bfb10","0x000000000000000000000000000000000000000000000000099ab9b4a361108d","0x00000000000000000000000000000000000000000000000009712be85b4c9f27","0x00000000000000000000000000000000000000000000000009382c58d159f25d","0x00000000000000000000000000000000000000000000000008f0dc363065a370","0x000000000000000000000000000000000000000000000000089c9e92e778e93b","0x000000000000000000000000000000000000000000000000083d0cea31b86637","0x00000000000000000000000000000000000000000000000007d3ea38d8528bdc","0x000000000000000000000000000000000000000000000000076315394286bd80","0x00000000000000000000000000000000000000000000000006ec7a5858d7db20","0x000000000000000000000000000000000000000000000000067205f519918ff0"] | 36246676 | 2023-10-09T20:31:18.000Z | 0x51a5b31bcadf326610ff657c93192ef297801a097d7cfd87ad5f24290ccc616f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV2_DepositedToBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_FlashLoan\_event
Flash loan execution records from Trader Joe V2 liquidity book pairs on Avalanche. Contains borrowed amounts, fees charged, active price bin identifiers, and sender/receiver addresses for analyzing arbitrage activity and protocol fee generation.
| 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_receiver` | `STRING` | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_activeId` | `STRING` | Active bin identifier representing the current price point in the liquidity pool at the time of the flash loan. Numeric string value determines the exchange rate between the two tokens in the Trader Joe V2 pair. |
| `in_amounts` | `STRING` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| `in_totalFees` | `STRING` | Total fees collected from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| `in_protocolFees` | `STRING` | Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| address | removed | in\_sender | log\_index | in\_amounts | in\_activeId | in\_receiver | block\_number | in\_totalFees | block\_timestamp | in\_protocolFees | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------------------------------ | ------------ | ------------------------------------------ | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0xd446eb1660f766d533beceef890df7a69d26f7d1 | false | 0xc96debd23d753557ab236b05ea7585c7e1f001ec | 57 | 0x0000000000000000000000018e7475a900000000000000000000000000000000 | 8376002 | 0xc96debd23d753557ab236b05ea7585c7e1f001ec | 31485402 | 0x0000000000000000000000000000829100000000000000000000000000000000 | 2023-06-18T10:40:50.000Z | 0x00000000000000000000000000000d0e00000000000000000000000000000000 | 0x1bd9d1dbcb6764392a20f1dc3ce8036400ef4bd364cc6429825823964db209e9 |
| 0xd446eb1660f766d533beceef890df7a69d26f7d1 | false | 0xc96debd23d753557ab236b05ea7585c7e1f001ec | 45 | 0x000000000000000000000002596654d600000000000000000000000000000000 | 8376003 | 0xc96debd23d753557ab236b05ea7585c7e1f001ec | 31479255 | 0x0000000000000000000000000000c51200000000000000000000000000000000 | 2023-06-18T07:12:20.000Z | 0x000000000000000000000000000013b500000000000000000000000000000000 | 0x80b83cfc9953a8981d2438b7df069a5a1cb3089f06403ec88999d235f885ec61 |
| 0xd446eb1660f766d533beceef890df7a69d26f7d1 | false | 0xc96debd23d753557ab236b05ea7585c7e1f001ec | 33 | 0x00000000000000000000000174adb35100000000000000000000000000000000 | 8376003 | 0xc96debd23d753557ab236b05ea7585c7e1f001ec | 31479353 | 0x00000000000000000000000000007a1f00000000000000000000000000000000 | 2023-06-18T07:15:37.000Z | 0x00000000000000000000000000000c3600000000000000000000000000000000 | 0xac032f8ccf1cf334a29d78631b5e37336ed5212ba8ef32c0bf5e98121dd507d8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV2_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_StaticFeeParametersSet\_event
Fee parameter configuration events from Trader Joe V2 Liquidity Book pairs on Avalanche. Captures updates to static fee settings including base factors, protocol share, volatility controls, and decay periods for analyzing liquidity pool fee structures.
| 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_baseFactor` | `STRING` | Base fee multiplier for the Trader Joe V2 liquidity pool. Numeric string denominated in basis points. |
| `in_filterPeriod` | `STRING` | Time window used to filter and smooth volatility measurements in the Trader Joe V2 fee model. Numeric string representing seconds. |
| `in_decayPeriod` | `STRING` | Time period over which volatility accumulation decays in the Trader Joe V2 fee model. Numeric string representing seconds. |
| `in_reductionFactor` | `STRING` | Multiplier applied to reduce accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. |
| `in_variableFeeControl` | `STRING` | Sensitivity parameter controlling how quickly fees adjust to volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. |
| `in_protocolShare` | `STRING` | Percentage of trading fees allocated to the protocol in the Trader Joe V2 fee model. Numeric string denominated in basis points. |
| `in_maxVolatilityAccumulator` | `STRING` | Maximum threshold for accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. |
| address | removed | in\_sender | log\_index | block\_number | in\_baseFactor | in\_decayPeriod | block\_timestamp | in\_filterPeriod | in\_protocolShare | transaction\_hash | in\_reductionFactor | in\_variableFeeControl | in\_maxVolatilityAccumulator |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | -------------- | --------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------- | ---------------------- | ---------------------------- |
| 0x978631c704bd0863343c975388c1f16886aba892 | false | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | 5 | 29777775 | 8000 | 1200 | 2023-05-09T02:13:56.000Z | 120 | 2500 | 0xf855b6bca882ecb47c6a3adc8806d167ec99d65d8f69ac14eb478ff2a3540ff2 | 5000 | 10000 | 250000 |
| 0x20b32e09359179ec53969f10646142dc2816764c | false | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | 15 | 29794404 | 8000 | 1200 | 2023-05-09T11:36:53.000Z | 300 | 2500 | 0xb4adcd0c8d7fb9923dc27e80e56c71c6a27f9ec03efb5a1d7b1fc79614b6d9cb | 5000 | 7500 | 150000 |
| 0x784c003ea7940aafec91b87608c740440d734a9a | false | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | 26 | 29805554 | 10000 | 600 | 2023-05-09T17:52:58.000Z | 30 | 2000 | 0x227b7ef2e84d028d3b4681df2db237b66e6125765bd8268c2b8c099bacbf9ba5 | 5000 | 15000 | 350000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV2_StaticFeeParametersSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_Swap\_event
Swap events from Trader Joe V2 Liquidity Book (LB) pairs containing swap direction, amounts exchanged, bin identifier, fee breakdown, and volatility accumulator. Used for DEX trading activity analysis and liquidity pool performance tracking.
| 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_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_amountsIn` | `STRING` | Input amounts of tokens provided in the swap operation. Hex-encoded, 0x-prefixed, 64-character string representing two packed uint128 values for token pairs. |
| `in_amountsOut` | `STRING` | Output amounts of tokens received from the swap operation. Hex-encoded, 0x-prefixed, 64-character string representing two packed uint128 values for token pairs. |
| `in_volatilityAccumulator` | `STRING` | Volatility accumulator value tracking price movement activity in the liquidity pool. Numeric string representation. |
| `in_totalFees` | `STRING` | Total fees collected from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| `in_protocolFees` | `STRING` | Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| in\_id | in\_to | address | removed | in\_sender | log\_index | block\_number | in\_amountsIn | in\_totalFees | in\_amountsOut | block\_timestamp | in\_protocolFees | transaction\_hash | in\_volatilityAccumulator |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8112282 | 0xc9ec57087138210a8cbbdd430d5763b94c6122b1 | 0x2f1da4bafd5f2508ec2e2e425036063a374993b6 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 12 | 28637563 | 0x00000000000000000000000009ccb13300000000000000000000000000000000 | 0x0000000000000000000000000000807300000000000000000000000000000000 | 0x000000000000000000000000000000000000000000000008e9a8b126f80c8c4c | 2023-04-12T05:55:44.000Z | 0x0000000000000000000000000000066c00000000000000000000000000000000 | 0x225f916179f682d58941a7f058480a1dba11b3d0cd8a56cf840b25fc10690d42 | 0 |
| 8112282 | 0xafb5ae9934266a131f44f2a80c783d6a827a3d1a | 0x2f1da4bafd5f2508ec2e2e425036063a374993b6 | false | 0x6a68f261f8976559259d74a3494c19ee2bde0e4f | 29 | 28637497 | 0x000000000000000000000000000f423600000000000000000000000000000000 | 0x000000000000000000000000000000c800000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000de0b4451af2e249 | 2023-04-12T05:53:27.000Z | 0x0000000000000000000000000000000a00000000000000000000000000000000 | 0xb81a6f890ed783e7903ad8b7c3cfdb272b1d376d35702597eef70ea773eb2530 | 0 |
| 8112283 | 0xa25ff473d49217d8cef3b8f4112bb8b7a9367546 | 0x2f1da4bafd5f2508ec2e2e425036063a374993b6 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 19 | 28657533 | 0x0000000000000000000000005f04573e00000000000000000000000000000000 | 0x0000000000000000000000000004dd6c00000000000000000000000000000000 | 0x00000000000000000000000000000000000000000000005668cf1d79a9a43fba | 2023-04-12T17:03:41.000Z | 0x00000000000000000000000000003e4500000000000000000000000000000000 | 0x938cae919299a5f4ad9dee56aeec91f279078fee5b1e0c6f3a60379e969c2dec | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV2_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_TransferBatch\_event
Batch liquidity position transfer events from Trader Joe V2 liquidity book (LBPair) contracts on Avalanche. Records minting and burning of multiple liquidity positions with bin IDs and amounts for analyzing liquidity provider 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_sender` | `STRING` | Address that initiated the transaction or operation. 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_ids` | `ARRAY` | Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| in\_to | in\_ids | address | in\_from | removed | in\_sender | log\_index | in\_amounts | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb0ee4e11e1f7c3134e3d23e023c54ab5fa85235e | \["8362831","8362832","8362833","8362834","8362835","8362836","8362837","8362838","8362839"] | 0x16396b65d5e0794c44447396f94665d3b9f576a0 | 0x0000000000000000000000000000000000000000 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 12 | \["23447402188653097033684258193947486735080394","22665177986994131565874567588131657758814439","21884271268650136378829902110147769157952093","21102259540639577015114268904382497992213801","20319672942239229270060967682303496607877689","19539128946689751393823460086741938957459859","18756957260798293638636900526184634905843972","17974797181125309039325532328268665778870317","17190035595247320932931336620910780346978925"] | 29216464 | 2023-04-25T19:43:38.000Z | 0x0072ee6ca514639c6079b3be56ccb766edecce9db6bf233f55c37cad8c3fb743 |
| 0xb1bc6ba8449dfebbbfc0bcf121c76f3c952bad0c | \["8362855","8362856","8362857","8362858","8362859","8362860","8362861","8362862","8362863","8362864","8362865"] | 0x16396b65d5e0794c44447396f94665d3b9f576a0 | 0x0000000000000000000000000000000000000000 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 29 | \["40721214846896704039166499703709175387884920","40709551935933944491682427356744198626863726","40720722907200081457968399308402268686074309","40732696216283645929573854996297350493334443","40721221415368953119854382053431081872037055","40628358470216442949881670470482990213810037","40615053876591136714497345602411070382136123","40638521852462883141239499562363729766947218","40694048345077097308049681985345311865152940","40660589287923871208481197540913601381706213","40696877375989551609131030594471159168065644"] | 29205434 | 2023-04-25T13:26:11.000Z | 0xffe091c1dbea14e5b4665301912dcc5c5fbe53ce22bcfb54afc9a5c60ef82107 |
| 0x829abd0c0c5caf02459be9e8195c7a467b02cc47 | \["8362861"] | 0x16396b65d5e0794c44447396f94665d3b9f576a0 | 0x0000000000000000000000000000000000000000 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 20 | \["2980724945273158774354936370132255039113026209"] | 29204594 | 2023-04-25T12:57:58.000Z | 0x4d58ffc229b88679712f5a7b276d860da2fae61be5d9d128f1f78aa1d756c48d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV2_TransferBatch_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_WithdrawnFromBins\_event
Liquidity withdrawal events from TraderJoe V2 liquidity book pairs, recording removal of tokens from specific price bins. Contains sender address, recipient address, bin identifiers, and withdrawn token amounts for tracking liquidity position exits.
| 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_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_ids` | `ARRAY` | Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| in\_to | in\_ids | address | removed | in\_sender | log\_index | in\_amounts | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x00020c6f6f9fa9b9c4b3dec3daf42a7d73e5882c | \["8388608","8388609","8388610","8388611","8388612"] | 0x9b2cc8e6a2bbb56d6be4682891a91b0e48633c72 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 20 | \["0x0000000000000000000000004530367800000000000000000000000000000000","0x0000000000000000000000003a22adf9000000000000000000000000213d98d6","0x000000000000000000000000000000000000000000000000000000006bef8101","0x00000000000000000000000000000000000000000000000000000000cc326821","0x00000000000000000000000000000000000000000000000000000000b27c24f8"] | 32836158 | 2023-07-20T06:19:56.000Z | 0xa123cfe640c48c563d746bdbd6f6dcc445cdcdeb0890a77b0f477b3473d89c5a |
| 0x00e546cd1301809d5f49daba33e55e4067d417d4 | \["8375195","8375196","8375197","8375198","8375199","8375200","8375201","8375202","8375203","8375204","8375205","8375206","8375207","8375208","8375209","8375210","8375211","8375212","8375213","8375214","8375215","8375216","8375217","8375218","8375219","8375220","8375221","8375222","8375223","8375224","8375225","8375226","8375227","8375228","8375229","8375230","8375231","8375232","8375233","8375234","8375235","8375236","8375237","8375238","8375239","8375240","8375241","8375242","8375243","8375244","8375245","8375246","8375247","8375248","8375249","8375250","8375251","8375252","8375253"] | 0x51146e0bf2dcc368de6f5201fe7c427da28d05de | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 16 | \["0x000000000000000000000000001d447a00000000000000000000000000000000","0x000000000000000000000000001c4abe00000000000000000000000000000000","0x000000000000000000000000001b510200000000000000000000000000000000","0x000000000000000000000000001a574600000000000000000000000000000000","0x00000000000000000000000000195d8900000000000000000000000000000000","0x000000000000000000000000001863cd00000000000000000000000000000000","0x000000000000000000000000001769db00000000000000000000000000000000","0x0000000000000000000000000016716e00000000000000000000000000000000","0x0000000000000000000000000015899000000000000000000000000000000000","0x0000000000000000000000000014a4b200000000000000000000000000000000","0x0000000000000000000000000013b57700000000000000000000000000000000","0x0000000000000000000000000012ba3d00000000000000000000000000000000","0x0000000000000000000000000011e7b200000000000000000000000000000000","0x0000000000000000000000000011392500000000000000000000000000000000","0x0000000000000000000000000009066d00000000000000000000ed9635a52142","0x0000000000000000000000000000000000000000000000000001ed76cb9f3a22","0x0000000000000000000000000000000000000000000000000001cd95e393ce9a","0x0000000000000000000000000000000000000000000000000001a4f06695c3e8","0x00000000000000000000000000000000000000000000000000017ddfe4ab6b4f","0x00000000000000000000000000000000000000000000000000015ec74de216ab","0x00000000000000000000000000000000000000000000000000013d65b9b2115f","0x00000000000000000000000000000000000000000000000000011d35ad715d95","0x0000000000000000000000000000000000000000000000000000fa6118cb4ae4","0x0000000000000000000000000000000000000000000000000000da7a290a9468","0x0000000000000000000000000000000000000000000000000000bcaa33678d3b","0x00000000000000000000000000000000000000000000000000009c2d8985d182","0x00000000000000000000000000000000000000000000000000007ccf46594378","0x00000000000000000000000000000000000000000000000000005d968f30c638","0x00000000000000000000000000000000000000000000000000003e24bea1468f","0x00000000000000000000000000000000000000000000000000003d2d0f26620f","0x00000000000000000000000000000000000000000000000000003c9d7430f73b","0x00000000000000000000000000000000000000000000000000005a81ea634893","0x0000000000000000000000000000000000000000000000000000789d63a68c69","0x000000000000000000000000000000000000000000000000000096ce9c33a97a","0x0000000000000000000000000000000000000000000000000000b504ea218d41","0x0000000000000000000000000000000000000000000000000000d26ad5b499ee","0x0000000000000000000000000000000000000000000000000000f04931517451","0x00000000000000000000000000000000000000000000000000010e52577ba2db","0x00000000000000000000000000000000000000000000000000012c5b7da5d166","0x00000000000000000000000000000000000000000000000000014a64a3cffff0","0x0000000000000000000000000000000000000000000000000001686dc9fa2e7a","0x00000000000000000000000000000000000000000000000000018676f0245d04","0x0000000000000000000000000000000000000000000000000001a480164e8b8e","0x0000000000000000000000000000000000000000000000000001c2893c78ba19","0x0000000000000000000000000000000000000000000000000001e09262a2e8a3","0x0000000000000000000000000000000000000000000000000001fe9b88cd172d","0x00000000000000000000000000000000000000000000000000021ca4aef745b7","0x00000000000000000000000000000000000000000000000000023aadd5217441","0x000000000000000000000000000000000000000000000000000258b6fb4ba2cc","0x000000000000000000000000000000000000000000000000000276c02175d156","0x000000000000000000000000000000000000000000000000000294c9479fffe0","0x0000000000000000000000000000000000000000000000000002b2d26dca2e6a","0x0000000000000000000000000000000000000000000000000002d0db93f45cf4","0x0000000000000000000000000000000000000000000000000002eee4ba1e8b7f","0x00000000000000000000000000000000000000000000000000030cede048ba08","0x00000000000000000000000000000000000000000000000000032af70672e893","0x000000000000000000000000000000000000000000000000000349002c9d171d","0x0000000000000000000000000000000000000000000000000003670952c745a7","0x0000000000000000000000000000000000000000000000000003851278f17432"] | 32851885 | 2023-07-20T15:07:30.000Z | 0x965bbcf3a27cc93bc17c5b61bf35407e5872d84ef6912194df6fbfe960359043 |
| 0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc | \["8376066","8376067","8376068","8376069","8376070","8376071","8376072","8376073","8376074","8376075","8376076","8376077","8376078","8376079","8376080","8376081","8376082","8376083","8376084","8376085","8376086","8376087","8376088","8376089","8376090","8376091","8376092","8376093","8376094","8376095","8376096","8376097","8376098","8376099","8376100","8376101","8376102","8376103","8376104","8376105","8376106","8376107","8376108","8376109","8376110","8376111","8376112","8376113","8376114","8376115","8376116"] | 0xd446eb1660f766d533beceef890df7a69d26f7d1 | false | 0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc | 25 | \["0x0000000000000000000000000a2a981300000000000000000000000000000000","0x0000000000000000000000001455302600000000000000000000000000000000","0x0000000000000000000000001455302600000000000000000000000000000000","0x0000000000000000000000001455302600000000000000000000000000000000","0x0000000000000000000000001455302600000000000000000000000000000000","0x00000000000000000000000032d4f86100000000000000000000000000000000","0x00000000000000000000000032d4f86100000000000000000000000000000000","0x0000000000000000000000005154c09c00000000000000000000000000000000","0x0000000000000000000000005154c09c00000000000000000000000000000000","0x0000000000000000000000006fd488d700000000000000000000000000000000","0x0000000000000000000000008e54511200000000000000000000000000000000","0x0000000000000000000000008e54511200000000000000000000000000000000","0x000000000000000000000000acd4194d00000000000000000000000000000000","0x000000000000000000000000cb53e18800000000000000000000000000000000","0x000000000000000000000001085371fe00000000000000000000000000000000","0x00000000000000000000000126d33a3900000000000000000000000000000000","0x0000000000000000000000014553027400000000000000000000000000000000","0x000000000000000000000001825292ea00000000000000000000000000000000","0x000000000000000000000001bf52236000000000000000000000000000000000","0x000000000000000000000001ddd1eb9b00000000000000000000000000000000","0x0000000000000000000000021ad17c1100000000000000000000000000000000","0x0000000000000000000000023951444c00000000000000000000000000000000","0x00000000000000000000000257d10c8700000000000000000000000000000000","0x0000000000000000000000027844007200000000000000000000000000000000","0x000000000000000000000002789e999000000000000000000000000000000000","0x00000000000000000000000efdddda9a00000000000000000000000000000000","0x00000000000000000000000f10778c0a0000000000000003434fdf97c57d8701","0x0000000000000000000000000000000000000000000000f16141fa5c7d662de5","0x0000000000000000000000000000000000000000000000e17941b758a997e5ae","0x0000000000000000000000000000000000000000000000c1d40716e06dcfa0a7","0x0000000000000000000000000000000000000000000000a22ecc7668321fb72e","0x0000000000000000000000000000000000000000000000828991d5eff65f90ac","0x000000000000000000000000000000000000000000000062e4573577baa3fb54","0x00000000000000000000000000000000000000000000005311b9e53b9ccbc5a3","0x0000000000000000000000000000000000000000000000433f1c94ff7eebf356","0x00000000000000000000000000000000000000000000002399e1f4874333eb59","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000003f4a7540f0776d048","0x000000000000000000000000000000000000000000000001fa53aa0783bb6824"] | 32857606 | 2023-07-20T18:20:08.000Z | 0x25a6f714ea694e74a608b19cd08cc70ab4a57fd61b5a52b3abdf24aa8eea51ad |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV2_WithdrawnFromBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV22\_DepositedToBins\_event
Liquidity deposit events from Trader Joe V2.2 liquidity book pairs on Avalanche, recording when liquidity providers add tokens to specific price bins. Used for analyzing liquidity provision patterns and bin-level liquidity distribution across 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_sender` | `STRING` | Address that initiated the transaction 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_ids` | `ARRAY` | Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| in\_to | in\_ids | address | removed | in\_sender | log\_index | in\_amounts | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x17fdcf5ce6ead000aced290171bd6c38241a5342 | \["8112231","8112232","8112233","8112234","8112235","8112236","8112237","8112238","8112239","8112240","8112241","8112242","8112243","8112244","8112245","8112246","8112247","8112248","8112249","8112250","8112251","8112252","8112253","8112254","8112255","8112256","8112257","8112258","8112259","8112260","8112261","8112262","8112263","8112264","8112265","8112266","8112267","8112268","8112269","8112270","8112271","8112272","8112273","8112274","8112275","8112276","8112277","8112278","8112279","8112280","8112281"] | 0x934cf521743903d27e388d7e8517c636f3cc4d54 | false | 0x18556da13313f3532c54711497a8fedac273220e | 6 | \["0x000000000000000000000000005a84c200000000000000000000000000000000","0x000000000000000000000000009b930300000000000000000000000000000000","0x00000000000000000000000001058a3000000000000000000000000000000000","0x00000000000000000000000001ae119300000000000000000000000000000000","0x00000000000000000000000002b3bb5b00000000000000000000000000000000","0x000000000000000000000000044045d800000000000000000000000000000000","0x000000000000000000000000068ab3f400000000000000000000000000000000","0x00000000000000000000000009d8cbe700000000000000000000000000000000","0x0000000000000000000000000e7f667300000000000000000000000000000000","0x00000000000000000000000014e0e0bc00000000000000000000000000000000","0x0000000000000000000000001d69022b00000000000000000000000000000000","0x0000000000000000000000002885cc4800000000000000000000000000000000","0x000000000000000000000000369cfc4b00000000000000000000000000000000","0x00000000000000000000000047fe874400000000000000000000000000000000","0x0000000000000000000000005cd4ff8b00000000000000000000000000000000","0x000000000000000000000000751585ca00000000000000000000000000000000","0x0000000000000000000000009071853d00000000000000000000000000000000","0x000000000000000000000000ae4cd83500000000000000000000000000000000","0x000000000000000000000000cdbae75300000000000000000000000000000000","0x000000000000000000000000ed84c9ff00000000000000000000000000000000","0x0000000000000000000000010c395f9800000000000000000000000000000000","0x0000000000000000000000012846e43600000000000000000000000000000000","0x000000000000000000000001401be45700000000000000000000000000000000","0x000000000000000000000001524bf79100000000000000000000000000000000","0x0000000000000000000000015db3a6b100000000000000000000000000000000","0x000000000000000000000000b0cb4bac00000000000000a0e820ecb4fb5df433","0x00000000000000000000000000000000000000000000013e46d7846d77648a4d","0x000000000000000000000000000000000000000000000133e5870f67c5e7a194","0x00000000000000000000000000000000000000000000012357dbc75b60a16c71","0x00000000000000000000000000000000000000000000010da71bc6a7875189eb","0x0000000000000000000000000000000000000000000000f41ef057698e460df0","0x0000000000000000000000000000000000000000000000d82cb9b239e53bfbf9","0x0000000000000000000000000000000000000000000000bb3e2138ee1b7d231b","0x00000000000000000000000000000000000000000000009ea31bdb8415127c65","0x00000000000000000000000000000000000000000000008376a1d11e85c4712f","0x00000000000000000000000000000000000000000000006a9007bd892bfdb50e","0x0000000000000000000000000000000000000000000000547d6b2e972e82b993","0x00000000000000000000000000000000000000000000004186512a37db12a1b3","0x000000000000000000000000000000000000000000000031b49ee987edcad3c3","0x000000000000000000000000000000000000000000000024e1956d16efcb8f66","0x00000000000000000000000000000000000000000000001ac46f0c35b6b78164","0x000000000000000000000000000000000000000000000013009309eeaca2b750","0x00000000000000000000000000000000000000000000000d31e288eeeec386fd","0x000000000000000000000000000000000000000000000008f6458dddc70526de","0x000000000000000000000000000000000000000000000005f435cbed68c67b79","0x000000000000000000000000000000000000000000000003de7a6040dc449820","0x000000000000000000000000000000000000000000000002759239a45af6f7b2","0x000000000000000000000000000000000000000000000001876bf17da1264146","0x000000000000000000000000000000000000000000000000ee098673926fd017","0x0000000000000000000000000000000000000000000000008d98105024c06a5e","0x00000000000000000000000000000000000000000000000052626659b48c5ed0"] | 47838432 | 2024-07-11T15:39:05.000Z | 0x242f95f18d643f647953d077c98f39e0a9e3d32f8e5fb4b2deba2d6a4736d3de |
| 0x8f5d6b58850fa1acfb20ca982636ffd821c712c9 | \["8112252","8112253","8112254","8112255","8112256","8112257","8112258","8112259","8112260","8112261"] | 0x934cf521743903d27e388d7e8517c636f3cc4d54 | false | 0x18556da13313f3532c54711497a8fedac273220e | 22 | \["0x0000000000000000000000000108dd2200000000000000000000000000000000","0x000000000000000000000000031b5a9a00000000000000000000000000000000","0x00000000000000000000000006d0738a00000000000000000000000000000000","0x0000000000000000000000000aea96bc00000000000000000000000000000000","0x0000000000000000000000000662f5f300000000000000020bcf7578fcf2b5b2","0x000000000000000000000000000000000000000000000003b36c0d6f3871e7f7","0x000000000000000000000000000000000000000000000002bcbf6bb78608dd16","0x000000000000000000000000000000000000000000000001a7e53933c03e58ac","0x000000000000000000000000000000000000000000000000d1b7a90e9c776e47","0x00000000000000000000000000000000000000000000000054db76dedd33a733"] | 47847099 | 2024-07-11T20:35:02.000Z | 0x596128450037c78ecf82d3c708ef7a34edb7b44f50ce410eed2b994b6509515c |
| 0x97dc90f0ac367b2d41a942f4887b054f6151a2ec | \["8112254","8112255","8112256","8112257","8112258"] | 0x934cf521743903d27e388d7e8517c636f3cc4d54 | false | 0x18556da13313f3532c54711497a8fedac273220e | 123 | \["0x00000000000000000000000007ce11a500000000000000000000000000000000","0x00000000000000000000000007ce11a500000000000000000000000000000000","0x00000000000000000000000003e708ba000000000000000191be6a1fe722ff40","0x000000000000000000000000000000000000000000000003237cd43fce45fe80","0x000000000000000000000000000000000000000000000003237cd43fce45fe80"] | 47838813 | 2024-07-11T15:52:00.000Z | 0xac53f420ddecb0aa6f6d3c09d6a7f6f8a15c19b88c3a1dd69a6702939a0d1ad3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV22_DepositedToBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV22\_Swap\_event
Swap events from Trader Joe V2.2 liquidity book pairs on Avalanche, capturing token exchanges with input/output amounts, fees, bin IDs, and volatility metrics. Used for analyzing DEX trading patterns, fee collection, and liquidity utilization across concentrated liquidity positions.
| 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_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_amountsIn` | `STRING` | Input amounts of tokens provided in the swap operation. Hex-encoded, 0x-prefixed, 64-character string representing two packed uint128 values for token pairs. |
| `in_amountsOut` | `STRING` | Output amounts of tokens received from the swap operation. Hex-encoded, 0x-prefixed, 64-character string representing two packed uint128 values for token pairs. |
| `in_volatilityAccumulator` | `STRING` | Volatility accumulator value tracking price movement activity in the liquidity pool. Numeric string representation. |
| `in_totalFees` | `STRING` | Total fees collected from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| `in_protocolFees` | `STRING` | Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| in\_id | in\_to | address | removed | in\_sender | log\_index | block\_number | in\_amountsIn | in\_totalFees | in\_amountsOut | block\_timestamp | in\_protocolFees | transaction\_hash | in\_volatilityAccumulator |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8378016 | 0x0249e0913088525154dbcf96466a068894054fb6 | 0x4548a429c91505eca33a5f7f3807132f39ab2459 | false | 0x18556da13313f3532c54711497a8fedac273220e | 22 | 46978930 | 0x0000000000000000000000000000000000000000000000015fc728a491ab555f | 0x00000000000000000000000000000000000000000000000000ec1e5067c6b525 | 0x00000000000000000000000004ed379d00000000000000000000000000000000 | 2024-06-21T02:38:07.000Z | 0x000000000000000000000000000000000000000000000000002f394347f48aa1 | 0xd63bb3e5177c471390def535a8191ecc473ff91669ec4fd8a5b6fe6583f74bd2 | 35860 |
| 8378006 | 0x035d10e2ae3406fdd145d59d63ff2aa57870e189 | 0x4548a429c91505eca33a5f7f3807132f39ab2459 | false | 0x18556da13313f3532c54711497a8fedac273220e | 22 | 47001029 | 0x000000000000000000000000000000000000000000000000131e96f4ab5bbffc | 0x000000000000000000000000000000000000000000000000000c55052c40b155 | 0x0000000000000000000000000042dd1100000000000000000000000000000000 | 2024-06-21T15:10:57.000Z | 0x000000000000000000000000000000000000000000000000000277676f402377 | 0x6c89ac3fe60b7c3c26223db7b4be0cd32764f1f384aff2dc28b9f656d1de2487 | 13960 |
| 8377995 | 0x0823e6affade2dda8fa4355a414361c9e1c0edfd | 0x4548a429c91505eca33a5f7f3807132f39ab2459 | false | 0x18556da13313f3532c54711497a8fedac273220e | 14 | 46991320 | 0x00000000000000000000000000000000000000000000000068400c742c24c1df | 0x00000000000000000000000000000000000000000000000000632ad7ef9aa11f | 0x00000000000000000000000001625c3e00000000000000000000000000000000 | 2024-06-21T09:41:59.000Z | 0x0000000000000000000000000000000000000000000000000013d55e631eed06 | 0x04840ee6472dc93d1b915655f29196167ef6ef1bfccaab0e28f6e4c2ef98c365 | 113750 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV22_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV22\_WithdrawnFromBins\_event
Liquidity withdrawal events from Trader Joe V2.2 Liquidity Book (LB) pairs on Avalanche, recording bin IDs and token amounts removed by liquidity providers. Used for tracking LP position exits and liquidity depth changes across price bins.
| 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_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_ids` | `ARRAY` | Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| in\_to | in\_ids | address | removed | in\_sender | log\_index | in\_amounts | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8b88064db1595e37fded18102dff6933a8b6ee90 | \["8377940","8377941","8377942","8377943","8377944","8377945","8377946","8377947","8377948","8377949","8377950","8377951","8377952","8377953","8377954","8377956","8377957","8377958","8377959","8377960","8377961","8377962","8377963","8377964","8377965","8377966","8377967","8377968","8377969","8377970","8377971","8377972","8377973","8377974","8377975","8377976","8377977","8377978","8377979","8377980","8377981","8377982","8377983","8377984","8377985","8377986","8377987","8377988","8377989","8377990","8377991","8377992","8377993","8377994","8377995","8377996","8377997","8377998","8377999","8378000","8378001","8378002","8378003","8378004","8378005","8378006","8378007","8378008","8378009","8378010","8378011","8378012","8378013","8378014","8378015","8378016","8378017","8378018","8378019","8378020","8378021","8378022","8378023","8378024","8378025","8378026","8378027","8378028","8378029","8378030","8378031","8378032","8378033","8378034","8378035","8378036","8378037","8378038","8378039","8378040","8378041","8378042","8378043","8378044","8378045","8378046","8378047","8378048","8378049","8378050","8378051","8378052","8378053","8378054","8378055","8378056","8378057","8378058","8378059","8378060","8378061","8378062","8378063","8378064","8378065","8378066","8378067","8378068","8378069","8378070","8378071","8378072","8378073","8378074","8378075","8378076","8378077","8378078","8378079","8378080","8378081","8378082","8378083","8378084","8378085","8378086","8378087","8378088","8378089","8378090","8378091","8378092","8378093","8378094","8378095","8378096","8378097","8378098","8378099","8378100","8378101","8378102","8378103","8378104","8378105","8378106","8378107","8378108","8378109","8378110","8378111","8378112","8378113","8378114","8378115","8378116","8378117","8378118","8378119","8378120","8378121","8378122","8378123","8378124","8378125","8378126","8378127","8378128","8378129","8378130","8378131","8378132","8378133","8378134","8378135","8378136","8378137","8378138","8378139","8378140"] | 0x4548a429c91505eca33a5f7f3807132f39ab2459 | false | 0x18556da13313f3532c54711497a8fedac273220e | 1 | \["0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ab00000000000000000000000000000000","0x000000000000000000000000002635ab00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ab00000000000000000000000000000000","0x000000000000000000000000002635ab00000000000000000000000000000000","0x000000000000000000000000002635ab00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ab00000000000000000000000000000000","0x000000000000000000000000002635ab00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x000000000000000000000000002635ac00000000000000000000000000000000","0x00000000000000000000000000266b6a00000000000000000000000000000000","0x0000000000000000000000000026802900000000000000000000000000000000","0x0000000000000000000000000026bed400000000000000000000000000000000","0x0000000000000000000000000026cf8c00000000000000000000000000000000","0x0000000000000000000000000026bc8700000000000000000000000000000000","0x0000000000000000000000000026c23700000000000000000000000000000000","0x0000000000000000000000000026ea2100000000000000000000000000000000","0x000000000000000000000000002728d900000000000000000000000000000000","0x000000000000000000000000002709d500000000000000000000000000000000","0x00000000000000000000000000275bf800000000000000000000000000000000","0x00000000000000000000000000277fde00000000000000000000000000000000","0x00000000000000000000000000280e3600000000000000000000000000000000","0x0000000000000000000000000027ea7c00000000000000000000000000000000","0x0000000000000000000000000028954b00000000000000000000dba9686e79f2","0x00000000000000000000000000000000000000000000000009e41fcb4e2ebea3","0x00000000000000000000000000000000000000000000000009e626b67a089be6","0x00000000000000000000000000000000000000000000000009cef43fe5e86cd1","0x00000000000000000000000000000000000000000000000009db99508e313a75","0x00000000000000000000000000000000000000000000000024bda448c78094e1","0x0000000000000000000000000000000000000000000000003fb7e36a8c9fa155","0x0000000000000000000000000000000000000000000000004023b3b8acdab58a","0x00000000000000000000000000000000000000000000000040085a6c35ee3d03","0x0000000000000000000000000000000000000000000000003fd3aba73a1acb7f","0x0000000000000000000000000000000000000000000000003fd1c054bc174f00","0x00000000000000000000000000000000000000000000000040613c87ea05cdf2","0x0000000000000000000000000000000000000000000000003ffcbee5baf47915","0x0000000000000000000000000000000000000000000000003f3434a418f99d63","0x0000000000000000000000000000000000000000000000003f3878bd6b3016c2","0x000000000000000000000000000000000000000000000000401af49bd373ef49","0x0000000000000000000000000000000000000000000000003fddf170583cb9c6","0x0000000000000000000000000000000000000000000000003f78e1ce782babf0","0x0000000000000000000000000000000000000000000000003f7fb948cb4176ea","0x0000000000000000000000000000000000000000000000003ed508e98b5663c8","0x0000000000000000000000000000000000000000000000003ea6ed92e40849ec","0x0000000000000000000000000000000000000000000000003ea7c981a2fa39b0","0x0000000000000000000000000000000000000000000000003e6a389661852a9c","0x0000000000000000000000000000000000000000000000003ea35763559780c9","0x0000000000000000000000000000000000000000000000003e8deff86ce87811","0x0000000000000000000000000000000000000000000000003ea8e95438480521","0x0000000000000000000000000000000000000000000000003ee754139be4597b","0x0000000000000000000000000000000000000000000000003eb02dcf505e94cf","0x0000000000000000000000000000000000000000000000003e9eced7eb5f3087","0x0000000000000000000000000000000000000000000000003e92f9654b7a9e6b","0x0000000000000000000000000000000000000000000000003e8f52f70b2492ac","0x0000000000000000000000000000000000000000000000003e50f15a51bcee5d","0x0000000000000000000000000000000000000000000000003e2ccda28e1049a6","0x0000000000000000000000000000000000000000000000003e59f914ea05253e","0x0000000000000000000000000000000000000000000000003def35e64ef14f94","0x0000000000000000000000000000000000000000000000003d5c116fa6a60dc5","0x0000000000000000000000000000000000000000000000003d050cf631bdfe39","0x0000000000000000000000000000000000000000000000003d048f42d3e00531","0x0000000000000000000000000000000000000000000000003d89c4b87745465a","0x0000000000000000000000000000000000000000000000003db5863e1fd120ab","0x0000000000000000000000000000000000000000000000003d43ee7543a2b2da","0x0000000000000000000000000000000000000000000000003cf71648acec51cf","0x0000000000000000000000000000000000000000000000003cd65e61d459e197","0x0000000000000000000000000000000000000000000000003c6b415ba63bba4b","0x0000000000000000000000000000000000000000000000003c5ebe2150182fae","0x0000000000000000000000000000000000000000000000003c40a6dd5ff6b47a","0x0000000000000000000000000000000000000000000000003c4380e58b8729f5","0x0000000000000000000000000000000000000000000000003c6b0af93c56fa33","0x0000000000000000000000000000000000000000000000003cbb9a219f7fbb1f","0x0000000000000000000000000000000000000000000000003cdac35633dd694a","0x0000000000000000000000000000000000000000000000003d1157952dc2846a","0x0000000000000000000000000000000000000000000000003cf9e30baedd2f86","0x0000000000000000000000000000000000000000000000003ce5b77e00eab18f","0x0000000000000000000000000000000000000000000000003cc615e91673dd92","0x0000000000000000000000000000000000000000000000003cd4dafeda89d016","0x0000000000000000000000000000000000000000000000003cbf24c5e6903377","0x0000000000000000000000000000000000000000000000003c8bf3e970b609b0","0x0000000000000000000000000000000000000000000000003c86a1a6ccaf24d9","0x0000000000000000000000000000000000000000000000003c83938d2f427fe1","0x0000000000000000000000000000000000000000000000003cbed62976e137bb","0x0000000000000000000000000000000000000000000000003cd35bca232b4e34","0x0000000000000000000000000000000000000000000000003cbe1e2f6221838b","0x0000000000000000000000000000000000000000000000003cfc8eca1a388dd0","0x0000000000000000000000000000000000000000000000003d702fbd578d5cf7","0x0000000000000000000000000000000000000000000000003d91de337194ca79","0x0000000000000000000000000000000000000000000000003dc2346e9f25202a","0x0000000000000000000000000000000000000000000000003d7d2c4da1eb3268","0x0000000000000000000000000000000000000000000000003d22200173b8689b","0x0000000000000000000000000000000000000000000000003cf424da8b814523","0x0000000000000000000000000000000000000000000000003ce90dc37463ca35"] | 47946097 | 2024-07-14T06:08:05.000Z | 0x46c4735f1a89d9afe683d66459d1815a2d5356be42d3c813693c8150ceb35069 |
| 0x8b88064db1595e37fded18102dff6933a8b6ee90 | \["8377955"] | 0x4548a429c91505eca33a5f7f3807132f39ab2459 | false | 0x18556da13313f3532c54711497a8fedac273220e | 7 | \["0x000000000000000000000000002635ac00000000000000000000000000000000"] | 47946021 | 2024-07-14T06:05:19.000Z | 0x08803c2c3af42f643be30619a1c96eb5fd6a9fad5cf50983bfc419fcd52ad021 |
| 0xc368b7a71a5ce4ef4e702f3ef1ebdbd66f65ed64 | \["8378040","8378041","8378042","8378043","8378044","8378045","8378046","8378047","8378048","8378049","8378050","8378051","8378052","8378053","8378054","8378055","8378056","8378057","8378058","8378059","8378060","8378061","8378062","8378063","8378064","8378065","8378066","8378067","8378068","8378069","8378070","8378071","8378072","8378073","8378074","8378075","8378076","8378077","8378078","8378079","8378080","8378081","8378082","8378083","8378084","8378085","8378086","8378087","8378088","8378089","8378090"] | 0x4548a429c91505eca33a5f7f3807132f39ab2459 | false | 0x18556da13313f3532c54711497a8fedac273220e | 2 | \["0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f2815400000000000000000000000000000000","0x00000000000000000000000007f8583000000000000000000000000000000000","0x000000000000000000000000080ecb0f00000000000000000000000000000000","0x0000000000000000000000000815cad100000000000000000000000000000000","0x000000000000000000000000083efc8e00000000000000000000000000000000","0x0000000000000000000000000862a08400000000000000000000000000000000","0x000000000000000000000000086110c700000000000000000000000000000000","0x0000000000000000000000000866be9f00000000000000000000000000000000","0x000000000000000000000000086941df00000000000000000000000000000000","0x0000000000000000000000000863c73800000000000000000000000000000000","0x0000000000000000000000000858f39900000000000000000000000000000000","0x000000000000000000000000085ca3f300000000000000000000000000000000","0x000000000000000000000000086abc0200000000000000000000000000000000","0x000000000000000000000000086b62fd00000000000000000000000000000000","0x00000000000000000000000008756eee00000000000000000000000000000000","0x00000000000000000000000007e71b95000000000000000024970dc3bf0ce362","0x00000000000000000000000000000000000000000000000206a7d7f51665c8d4","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11","0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11"] | 47970697 | 2024-07-14T20:23:03.000Z | 0x8d9cc90fb4af11ab60de14c3b5dcf321ef276de79aba9a2aed96e8e8e741ba10 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_avalanche.LBPairV22_WithdrawnFromBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***