> ## 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_arbitrum
> Tables in tt-contracts.traderjoe_v2_arbitrum
## Tables
### LBFactory\_FeeParametersSet\_event
Fee parameter configuration events from Trader Joe V2 Liquidity Book (LB) factory on Arbitrum. Tracks dynamic fee settings for individual liquidity pairs including bin step, base factor, volatility controls, and protocol share 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_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 parameter for the liquidity bin pair's dynamic fee calculation. Controls fee sensitivity to price movements, with higher values allowing greater fee adjustments based on market volatility. |
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | -------------- | --------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------- | ---------------------- | ---------------------------- |
| 0x1886d09c9ade0c5db822d85d21678db67b6c2982 | false | 0xcba0b8384adfddf2fa4b99b29f0145e8979beb29 | 0xf1ec4e41b49582af7e00d6525af78111f37b94a8 | 3 | 100 | 66171462 | 8000 | 1200 | 2023-03-02T20:55:37.000Z | 300 | 0 | 0xa429a2e18b82a5c985ca92e2332afea143916a5316d5e2b149bc74becb1240bb | 5000 | 7500 | 150000 |
| 0x1886d09c9ade0c5db822d85d21678db67b6c2982 | false | 0xcca7bc4c85736339ecacdb6f55a077cba6db255e | 0xf1ec4e41b49582af7e00d6525af78111f37b94a8 | 3 | 100 | 64508096 | 8000 | 1200 | 2023-02-25T17:45:39.000Z | 300 | 0 | 0x330c39254fadab9280a9da41d6e465abacc665b236546696728ed0012fb5048c | 5000 | 7500 | 150000 |
| 0x1886d09c9ade0c5db822d85d21678db67b6c2982 | false | 0xba7c96e66f7808699f47c364e388272f95a8bfa8 | 0xf1ec4e41b49582af7e00d6525af78111f37b94a8 | 6 | 25 | 73226239 | 10000 | 600 | 2023-03-24T15:47:23.000Z | 30 | 0 | 0x602eb3fd226d9b988c8e67cabc8dabe283117084f19be2a902eeab3101f4a3c3 | 5000 | 15000 | 350000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBFactory_FeeParametersSet_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 DEX (Decentralized Exchange) on Arbitrum, recording new token pair pools with their bin step parameters and pool identifiers. Used for tracking pool deployments and analyzing market expansion 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_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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 8 | 0x1886d09c9ade0c5db822d85d21678db67b6c2982 | false | 0xa14dbce13c22c97fd99daa0de3b1b480c7c3fdf6 | 0x6c2c06790b3e3e3c38e12ee22f8183b37a13ee55 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 3 | 20 | 52327456 | 2023-01-11T14:55:50.000Z | 0x294ef4c85b51d713d8ca082324d68b88771ded06882cf23f2eb0088363760b55 |
| 9 | 0x1886d09c9ade0c5db822d85d21678db67b6c2982 | false | 0xc710ab0e740b40c3b1ad5d6d8b22f8bcb7473749 | 0x18c11fd286c5ec11c3b683caa813b77f5163a122 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 6 | 25 | 52327456 | 2023-01-11T14:55:50.000Z | 0x294ef4c85b51d713d8ca082324d68b88771ded06882cf23f2eb0088363760b55 |
| 10 | 0x1886d09c9ade0c5db822d85d21678db67b6c2982 | false | 0x5d5b29301936f0c8af52425efc2bc5330c73956d | 0x32eb7902d4134bf98a28b963d26de779af92a212 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 9 | 25 | 52327456 | 2023-01-11T14:55:50.000Z | 0x294ef4c85b51d713d8ca082324d68b88771ded06882cf23f2eb0088363760b55 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBFactory_LBPairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactoryV2\_FeeRecipientSet\_event
Fee recipient configuration changes from Trader Joe V2 Liquidity Book (LB) factory contract on Arbitrum. Tracks historical updates to protocol fee collection addresses for analyzing fee distribution governance and treasury management.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_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 | 1 | 77473199 | 2023-04-06T01:15:41.000Z | 0xc8fc59fceb8259534d8b10879273879eddf7eec0 | 0x0000000000000000000000000000000000000000 | 0xe6826a136ea7e84573ff9c849e9e856a9c52fe7177e733ccf0b874036f93709d |
| 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 38 | 89350950 | 2023-05-10T19:02:55.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0xc8fc59fceb8259534d8b10879273879eddf7eec0 | 0x32a5ef2a18109120923e814d3f36589240cab6d88c465eee8a13ead043d3dc77 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 Arbitrum. Records old and new fee values (in basis points) when protocol administrators update flash loan parameters.
| 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 | 2 | 77473199 | 2023-04-06T01:15:41.000Z | 0xe6826a136ea7e84573ff9c849e9e856a9c52fe7177e733ccf0b874036f93709d | 5000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 518 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0x86c0bfc14ca1c1c508e420d734c9c60b74eb38bc | 0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 1 | 25 | 213678732 | 2024-05-21T23:06:12.000Z | 0x456d7657f714309cd9bb1b5bc240fe2f15c25dce6ef080bb693315272b687773 |
| 92 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0x02badf2553062eb030d87f7c23b88a74786c32a9 | 0x10a625d21bbb6ae379b2b402d9907dcb9fe1700d | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 1 | 100 | 85374531 | 2023-04-29T03:28:37.000Z | 0xcd8ce81aaa24cb9652dbed9a1c3da47fc718576bd92c20d8641e077e648852b7 |
| 384 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0x717061dd4d3b3c184bba14c58660f9bfa430aecc | 0x87aaffdf26c6885f6010219208d5b161ec7609c0 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 1 | 100 | 150120208 | 2023-11-13T21:29:54.000Z | 0x26be4fe024a4a9a7e58964b93d388f2e2f413a615ecddb6565b5a2045870d603 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBFactoryV2_LBPairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactoryV22\_LBPairCreated\_event
Liquidity book pair creation events from Trader Joe V2.2 factory contract on Arbitrum, recording new trading pool deployments with token pairs, bin step (price granularity), and pool addresses. Used for tracking V2 liquidity pool launches and identifying new trading pairs with their binStep parameters.
| 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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 86 | 0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c | false | 0xf82b333757f756d22b7a41687c4dac08f6b05920 | 0xc760f9782f8cea5b06d862574464729537159966 | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 37 | 100 | 276280565 | 2024-11-20T01:13:17.000Z | 0x43fc8991689e11b06cb824c14a05effe089aa0522acd95061200126e267ef86b |
| 67 | 0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c | false | 0xabef47f6d27c1edf3c89310a29920a142e054030 | 0xaaa6c1e32c55a7bfa8066a6fae9b42650f262418 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 3 | 100 | 240124486 | 2024-08-06T19:02:47.000Z | 0x83ce9f6f037fcaffae48c9414d29a2165dfd6412c58840dfc79a7054d306ec9c |
| 65 | 0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c | false | 0xe8a2aa0dd8fc4771cb29d69e6e32ad8ae1ce06cd | 0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 4 | 25 | 237565409 | 2024-07-30T08:28:37.000Z | 0x8730c579d9dd9a21f07b8750682e3ae4d0623fd9dfe3b4609622cf1d38001e57 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBFactoryV22_LBPairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_CompositionFee\_event
Fee composition events from Trader Joe V2 liquidity book (LB) pairs on Arbitrum, tracking accumulated trading fees in both X and Y tokens per bin ID. Used to analyze fee distribution patterns and liquidity provider earnings 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_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 fees collected in token X for a specific liquidity bin on Trader Joe v2. Denominated in the smallest unit of token X, typically representing protocol or LP fees from trades within that bin. |
| `in_feesY` | `STRING` | Amount of composition fees collected in token Y from this liquidity bin. Denominated in the smallest unit of token Y (e.g., wei for ETH), with values often zero when fees accrue only to token X. |
| in\_id | address | removed | in\_feesX | in\_feesY | in\_sender | log\_index | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | --------- | --------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8375115 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 0 | 2571 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 14 | 63226496 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 2023-02-21T21:43:48.000Z | 0x48b6f9c01754f1a1afb89180ebecb4d600e7c438c21076e4c015574f925fbc7d |
| 8375115 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 0 | 1 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 16 | 63236236 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 2023-02-21T22:27:05.000Z | 0x8a2a8c4a8039e4fb61d82198713b90f25758289d25732d04488be88469504db6 |
| 8375115 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 95355 | 0 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 12 | 63226912 | 0x23cb90f8143260a9c4933e1ccf9965a6f0464f26 | 2023-02-21T21:45:38.000Z | 0x36df1f04a1f6d9a89fd18fe9284870ac1d7a4559fbf7a6a68d2ffb40d7743482 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBPair_CompositionFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_DepositedToBin\_event
Liquidity deposit events for Trader Joe V2 liquidity book (LB) pairs on Arbitrum, recording tokenX and tokenY amounts added to specific price bins. Used for tracking liquidity provider positions and analyzing concentrated liquidity distribution across the V2 AMM's discrete price ranges.
| 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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8380631 | 0x021352af332c70817e25a47578a8f0d8c0fa9210 | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 66 | 1246009174196844151 | 0 | 51715073 | 0xb39f5c87e06c201a03a8b1bf9641217c31d8de57 | 2023-01-08T23:53:57.000Z | 0xe7b640884c87046ffcfa7778d0a977885c594574091d4331aab1ae1c1696d25d |
| 8380623 | 0x021352af332c70817e25a47578a8f0d8c0fa9210 | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 50 | 6230045870984220756 | 0 | 51715073 | 0xb39f5c87e06c201a03a8b1bf9641217c31d8de57 | 2023-01-08T23:53:57.000Z | 0xe7b640884c87046ffcfa7778d0a977885c594574091d4331aab1ae1c1696d25d |
| 8380629 | 0x021352af332c70817e25a47578a8f0d8c0fa9210 | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 62 | 1869013761295266227 | 0 | 51715073 | 0xb39f5c87e06c201a03a8b1bf9641217c31d8de57 | 2023-01-08T23:53:57.000Z | 0xe7b640884c87046ffcfa7778d0a977885c594574091d4331aab1ae1c1696d25d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 Arbitrum, recording tokenX and tokenY fee amounts claimed by liquidity providers. Used to analyze LP profitability and protocol fee generation across different trading pairs.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x5fbbef48ce0850e5a73bc3f4a6e903458b3c0af4 | false | 0x1404d2065a601cbdc19b58cf2d53664f500800dc | 0 | 0 | 0 | 57345368 | 0x1404d2065a601cbdc19b58cf2d53664f500800dc | 2023-02-02T05:50:47.000Z | 0xb3d45498f7cad3a3a1f31962a5d68e5ab869d2520cc74124a72a0e66be3a8e62 |
| 0xa51ee8b744e6cc1f2ac12b9eeaae8deb27619c6b | false | 0x12cabba173f96b53cecf19274e6d66e2ed7a9bc4 | 0 | 0 | 0 | 57525999 | 0xdb7995a2cf3e443ccc2799fae91bc9cdc9c84aef | 2023-02-02T21:07:55.000Z | 0x36b7657bfc150e2cb52fa26ee125b844a010fd2b95d9faf295aefe2201500e3e |
| 0xa51ee8b744e6cc1f2ac12b9eeaae8deb27619c6b | false | 0x93701e77dd84ee668b84259d8dbaa51639afa548 | 1 | 0 | 0 | 57451414 | 0x93701e77dd84ee668b84259d8dbaa51639afa548 | 2023-02-02T14:46:50.000Z | 0xad3b5e009926600addcaa31d55c9a208901e6f1d92061abf08a4e89211765b30 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 pairs on Arbitrum, capturing borrowed token amounts, fees, and sender/receiver addresses. Used for analyzing arbitrage activity and flash loan utilization across Trader Joe V2 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_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 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 169000000 | 0xf85151e3effda6b0cd32e1ab6faba264c056b426 | 169 | 0xf85151e3effda6b0cd32e1ab6faba264c056b426 | 58222802 | 2023-02-05T12:55:58.000Z | 0xdcf15835e615b8f242eb6ed186a92d6d12f8f9fc071bb273f687c967189a178e |
| 0 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 40000000000000000000 | 0xe4141ec0cbd203a93ee60dd0a24273b8f66b83fd | 73 | 0xe4141ec0cbd203a93ee60dd0a24273b8f66b83fd | 58342805 | 2023-02-05T22:39:50.000Z | 0x61b350d4f54ebb41491a8497ba3af426ee5dc275d43d558ae0f5c20ac4185aad |
| 0 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 10328983816 | 0xc0379a7e5360bd02cd35df83a07ec2c73f730d5c | 134 | 0xc0379a7e5360bd02cd35df83a07ec2c73f730d5c | 73887448 | 2023-03-26T13:38:55.000Z | 0xa0ae1420d15d13bcc461dc9ef2301d49e6c4bb109cdc1d4fd3ae8002dfccd657 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBPair_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_Swap\_event
Swap events from Trader Joe V2 liquidity book pairs on Arbitrum, capturing token exchanges with input/output amounts, fees, price bin identifiers, and volatility metrics. Used for analyzing DEX trading patterns, fee generation, and price movement across concentrated liquidity 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_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` | Boolean flag indicating the direction of the swap in the liquidity bin pair. When true, the swap exchanges token X for token Y; when false, it exchanges token Y for token X. |
| `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 used by Trader Joe V2's liquidity book algorithm to adjust dynamic fees. Stored as a raw integer value representing the cumulative market volatility at the time of the swap. |
| `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 |
| ------- | ------------------------------------------ | ------------- | ------- | ------------------------------------------ | ---------- | ---------------- | ------------ | ------------- | ------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8384302 | 0xa0fd049466d57fc3637e27ca585d59e0ad86b902 | 325879828617 | false | 0x00000000049c95d6b6002a72c222809bfbfe2ed8 | 18 | 135911506716659 | false | 151994203 | 740738880000424046 | 0x00000000049c95d6b6002a72c222809bfbfe2ed8 | 2023-11-19T14:33:17.000Z | 0x0c4ae685fd29ebde0a14a3703cedf2e6d2db9fc7affae11346d6db2a6987df1b | 70000 |
| 8384309 | 0xa0fd049466d57fc3637e27ca585d59e0ad86b902 | 2203309291305 | false | 0x00000000049c95d6b6002a72c222809bfbfe2ed8 | 25 | 1099451336360935 | false | 151994203 | 5908957607384818020 | 0x00000000049c95d6b6002a72c222809bfbfe2ed8 | 2023-11-19T14:33:17.000Z | 0x0c4ae685fd29ebde0a14a3703cedf2e6d2db9fc7affae11346d6db2a6987df1b | 0 |
| 8384307 | 0xa0fd049466d57fc3637e27ca585d59e0ad86b902 | 279512942768 | false | 0x00000000049c95d6b6002a72c222809bfbfe2ed8 | 23 | 137276069127903 | false | 151994203 | 740738880000483114 | 0x00000000049c95d6b6002a72c222809bfbfe2ed8 | 2023-11-19T14:33:17.000Z | 0x0c4ae685fd29ebde0a14a3703cedf2e6d2db9fc7affae11346d6db2a6987df1b | 20000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 pairs on Arbitrum. Contains bin ID arrays and token amounts for analyzing concentrated liquidity movements and LP rebalancing 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 |
| ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc308a81cf3985baacc0a4496d937936339033407 | \["8374924","8374925","8374926","8374927","8374928","8374929","8374930","8374931","8374932","8374933","8374934","8374935","8374936","8374937","8374938","8374939","8374940","8374941","8374942","8374943","8374944","8374945","8374946","8374947","8374948","8374949","8374950","8374951","8374952","8374953","8374954","8374956","8374957","8374958","8374959","8374960","8374961","8374962","8374963","8374964","8374965","8374966","8374967","8374968","8374969","8374970","8374971"] | 0xc308a81cf3985baacc0a4496d937936339033407 | 0x5e0c4ce0a2340e6e7fad4557cf33684dcb60b270 | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 161 | \["24390243","24390243","24390243","26208424","26208424","26208424","26208424","26208424","25421312","24637725","26456401","26456897","57226624","57227122","56977654","56568493","56163347","56165355","40838073","25511242","13472652","421353","422195","423040","423886","112429","112654","112880","113105","113331","113558","31175520","31237871","31300347","31362948","31425674","31488525","31551502","31614605","31677834","31741190","31804672","31868282","31932018","31995882","32059874","32123994"] | 81711335 | 2023-04-18T10:15:32.000Z | 0xbcbdeaccc6f73bcf71f8704d3f3f79d974be33958e6c01fddfe91bff7ec3921a |
| 0xc308a81cf3985baacc0a4496d937936339033407 | \["8374989","8374990","8374991","8374992","8374993","8374994","8374995","8374996","8374997","8374998","8374999","8375000","8375001","8375002","8375003","8375004","8375005","8375006","8375007","8375008","8375009","8375010","8375011","8375012","8375013","8375014","8375015","8375016","8375017","8375018","8375019","8375020","8375021","8375022","8375023","8375024","8375025","8375026","8375027","8375028","8375029","8375030","8375031","8375032","8375033","8375034","8375035","8375036","8375037","8375038","8375039","8375040","8375041","8375042","8375043","8375044","8375045"] | 0xc308a81cf3985baacc0a4496d937936339033407 | 0x49462dd5e2092b83043f700745808f695e939cbe | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 75 | \["39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","39770491","22420021","5090201","5100381","5110582","5120803","5131044","5141307","5151589","5161892","5172216","5182561","5192926","5203312","5213718","5224146","5234594","5245063","5255553","5266064","5276596","5287150","5297724","5308319","5318936","5329574","5340233","5350914"] | 81645795 | 2023-04-18T05:44:49.000Z | 0x6d356d1f028f3264caf12334a62ffe32500fb749bea48a8c81d568162c5fe06d |
| 0xc308a81cf3985baacc0a4496d937936339033407 | \["8374991","8374992","8374993","8374994","8374995","8374996","8374997","8374998","8374999","8375000","8375001","8375002","8375003","8375004","8375005","8375006","8375007","8375008","8375009","8375010","8375011","8375012","8375013","8375014","8375015","8375016","8375017","8375018","8375019","8375020","8375021","8375022","8375023","8375024","8375025","8375026","8375027","8375028","8375029","8375030","8375031","8375032","8375033","8375034","8375035","8375036","8375037","8375038","8375039","8375040","8375041"] | 0xc308a81cf3985baacc0a4496d937936339033407 | 0x80b1fb8548a8a9d2162c7c88962657252e724150 | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 56 | \["57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","57753167","60315460","63101446","63227648","63354104","63480812","63607774","63734989","63862459","63990184","64118164","64246401","64374894","64503643","64632651","64761916","64891440","65021223","65151265","65281568","65412131","65542955","65674041","65805389","65937000","66068874","66201012"] | 81718180 | 2023-04-18T10:43:47.000Z | 0x8577cc8582484d033b470e4318fcc70d55fe8edd261e254ac92411c2cf365755 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBPair_TransferBatch_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_TransferSingle\_event
Liquidity bin position transfers from Trader Joe V2 liquidity book pairs on Arbitrum, tracking individual bin ID movements between addresses. Used for analyzing liquidity provider behavior and position management in the protocol's concentrated liquidity model.
| 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 |
| ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 8375120 | 0x0000000000000000000000000000000000000000 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 54545 | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 4 | 98717953 | 2023-06-07T12:55:08.000Z | 0x07a4db438f554e3a745b1581ebc303c6417c2862564d6efa33aa153f703ffe7c |
| 8375121 | 0x0000000000000000000000000000000000000000 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 54545 | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 6 | 98717953 | 2023-06-07T12:55:08.000Z | 0x07a4db438f554e3a745b1581ebc303c6417c2862564d6efa33aa153f703ffe7c |
| 8375123 | 0x0000000000000000000000000000000000000000 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 54545 | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 10 | 98717953 | 2023-06-07T12:55:08.000Z | 0x07a4db438f554e3a745b1581ebc303c6417c2862564d6efa33aa153f703ffe7c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBPair_TransferSingle_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_WithdrawnFromBin\_event
Liquidity removal events from Trader Joe V2 Liquidity Book (LB) price bins on Arbitrum, capturing withdrawn token X and Y amounts per bin ID. Used for analyzing liquidity provider withdrawals and position management 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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8375176 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 56 | 505405983530557551 | 26122 | 75260317 | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 2023-03-30T13:16:08.000Z | 0x00064361edf9205e2315f2dc9584956b9562133deefc806ba20d43379bd127ba |
| 8375186 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 76 | 162711864214066976 | 0 | 75260317 | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 2023-03-30T13:16:08.000Z | 0x00064361edf9205e2315f2dc9584956b9562133deefc806ba20d43379bd127ba |
| 8375199 | 0x7ec3717f70894f6d9ba0be00774610394ce006ee | false | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 102 | 162711864704745009 | 0 | 75260317 | 0x7bfd7192e76d950832c77bb412aae841049d8d9b | 2023-03-30T13:16:08.000Z | 0x00064361edf9205e2315f2dc9584956b9562133deefc806ba20d43379bd127ba |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 Arbitrum. Records fee amounts collected by the protocol and the recipient address for analyzing protocol revenue and fee distribution 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_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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x4b9bfed1dd4e6780454b2b02213788f31ffba74a | false | 2 | 101575309 | 2023-06-15T23:51:41.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0x000000000000000004ba3fac61d1c66a000000000000006629b16f399c248b7b | 0x391494f723deb8d589348a624ec40822e5a8f985202e9ec258d44bafad64d56b |
| 0xf8a60082039a1acbe43b045f87aa0c5f24a358a4 | false | 12 | 145072167 | 2023-10-29T09:12:23.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0x0000000000000000000000001d37409d000000000000001e5625f456aa58fdd9 | 0x8bbc2f200b95e48cfd2315992e3e5114fae632260ea2998551f996ef4449c085 |
| 0xbacd654a7eef4a50dbf1bc8ed8774a58dfbb440d | false | 8 | 98117489 | 2023-06-05T18:08:13.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0x0000000000000000000000001e4495bd0000000000000006ae096590de92631b | 0xa162716cdaa4ef8192d1485497b627a0ab12f886882a298d83c4df7695c86a43 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 Arbitrum, tracking total fees and protocol fees collected per price bin. Used for analyzing fee distribution and protocol revenue across different 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_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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 8374856 | 0xf8a60082039a1acbe43b045f87aa0c5f24a358a4 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 5 | 98020088 | 0x000000000000000000000000000001e800000000000000000000000000000000 | 2023-06-05T11:22:18.000Z | 0x0000000000000000000000000000006100000000000000000000000000000000 | 0x0677a9777de7e2c23435531c090690443587fbb2a70d6627d0790ec88d17eee5 |
| 8375174 | 0xd387c40a72703b38a5181573724bcaf2ce6038a5 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 4 | 98167394 | 0x0000000000000000000000000000000000000000000000000001f73ed83ec5e6 | 2023-06-05T21:42:16.000Z | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x87a668ab12effc96419832a58b433d9a51be8effbae577c689d4cecabfe103f1 |
| 8375175 | 0x94d53be52706a155d27440c4a2434bea772a6f7c | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 4 | 98169592 | 0x0000000000000000000000000000545800000000000000000000000000000000 | 2023-06-05T21:51:53.000Z | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xed6c5d0a807460071aadff2fae68993e3c70b136d3f23c1ddf23821259ccd546 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 |
| ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6 | \["8384144","8384145","8384146","8384147","8384148","8384149","8384150","8384151","8384152","8384153","8384154","8384155","8384156","8384157","8384158","8384159","8384160","8384161","8384162","8384163","8384164","8384165","8384166","8384167","8384168","8384169","8384170","8384171","8384172","8384173","8384174","8384175","8384176","8384177","8384178","8384179","8384180","8384181","8384182","8384183","8384184","8384185","8384186","8384187","8384188","8384189","8384190","8384191","8384192","8384193","8384194"] | 0x4b9bfed1dd4e6780454b2b02213788f31ffba74a | false | 0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6 | 14 | \["0x0000000000000000001ebf38dcf4b70900000000000000000000000000000000","0x0000000000000000001eb75ad635a62200000000000000000000000000000000","0x0000000000000000001eaf7ed2cbe25d00000000000000000000000000000000","0x0000000000000000001ea7a4d2338fc200000000000000000000000000000000","0x0000000000000000001e9fccd3e8f40200000000000000000000000000000000","0x0000000000000000001e97f6d768769500000000000000000000000000000000","0x0000000000000000001e9022dc2ea09200000000000000000000000000000000","0x0000000000000000001e8850e1b81cb800000000000000000000000000000000","0x0000000000000000001e8080e781b76500000000000000000000000000000000","0x0000000000000000001e78b2ed085e8000000000000000000000000000000000","0x0000000000000000002560b97599a52000000000000000000000000000000000","0x0000000000000000002acccccf046c7700000000000000000000000000000000","0x00000000000000000033a3f7e97a34ea00000000000000000000000000000000","0x0000000000000000004166f2f3e7f82700000000000000000000000000000000","0x00000000000000000055d84eaeebf12700000000000000000000000000000000","0x00000000000000000072cbfac643aea300000000000000000000000000000000","0x00000000000000000099d544c899252700000000000000000000000000000000","0x000000000000000000cbd8096cd3d84600000000000000000000000000000000","0x000000000000000001088df32a2e471e00000000000000000000000000000000","0x0000000000000000014e1c95f0fa493f00000000000000000000000000000000","0x00000000000000000198dff9a0072ede00000000000000000000000000000000","0x000000000000000001e389ca9106ec3f00000000000000000000000000000000","0x00000000000000000227a5973acd1e5f00000000000000000000000000000000","0x0000000000000000025e787d1423b65e00000000000000000000000000000000","0x0000000000000000028215a9c0181e1f00000000000000000000000000000000","0x0000000000000000027fabd8146c1a5e0000000000000001998cc1e6db747913","0x000000000000000000000000000000000000000000000053030d0f30f9b7eea1","0x00000000000000000000000000000000000000000000004e5e83ffab209ffba8","0x00000000000000000000000000000000000000000000004739e56cda3c03ecd6","0x00000000000000000000000000000000000000000000003e5a9ebe483147dc92","0x0000000000000000000000000000000000000000000000363d106959c825df9d","0x00000000000000000000000000000000000000000000002e1c2ded290c81f87c","0x000000000000000000000000000000000000000000000026a8c38b97bf09e2e6","0x0000000000000000000000000000000000000000000000205c1f0a0d73a3fa4a","0x00000000000000000000000000000000000000000000001b74006f8cf409fb74","0x00000000000000000000000000000000000000000000000e50c9df3311e07266","0x00000000000000000000000000000000000000000000000a8a3ccfdd861b624e","0x000000000000000000000000000000000000000000000007df366df17a6feaf3","0x00000000000000000000000000000000000000000000000612cecf608f6b1db0","0x000000000000000000000000000000000000000000000004ea60d8161b337f54","0x00000000000000000000000000000000000000000000000433d972edb4996bc3","0x0000000000000000000000000000000000000000000000034bddda0dec5e7738","0x0000000000000000000000000000000000000000000000034b05ee095a81db0d","0x0000000000000000000000000000000000000000000000034a2e39446046c496","0x0000000000000000000000000000000000000000000000034956bbb0dab98989","0x000000000000000000000000000000000000000000000003487f7540aa84c525","0x00000000000000000000000000000000000000000000000347a865e5b3efe29a","0x00000000000000000000000000000000000000000000000346d18d91dedec9fa","0x00000000000000000000000000000000000000000000000345faec3716d0411b","0x000000000000000000000000000000000000000000000003452481c74add988e","0x000000000000000000000000000000000000000000000003444e4e346db9890b"] | 253906233 | 2024-09-15T21:57:48.000Z | 0x79dca308100fe32a33e895b36e313b3b038d875dea85f93c6aa0a2bbb6c6796e |
| 0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6 | \["8384145","8384146","8384147","8384148","8384149","8384150","8384151","8384152","8384153","8384154","8384155","8384156","8384157","8384158","8384159","8384160","8384161","8384162","8384163","8384164","8384165","8384166","8384167","8384168","8384169","8384170","8384171","8384172","8384173","8384174","8384175","8384176","8384177","8384178","8384179","8384180","8384181","8384182","8384183","8384184","8384185","8384186","8384187","8384188","8384189","8384190","8384191","8384192","8384193","8384194","8384195"] | 0x4b9bfed1dd4e6780454b2b02213788f31ffba74a | false | 0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6 | 14 | \["0x0000000000000000001f13ee7348fdf100000000000000000000000000000000","0x0000000000000000001f0bfabfcd2a4f00000000000000000000000000000000","0x0000000000000000001f04091532683a00000000000000000000000000000000","0x0000000000000000001efc1972f3706f00000000000000000000000000000000","0x0000000000000000001ef42bd88b1db800000000000000000000000000000000","0x0000000000000000001eec4045746cfb00000000000000000000000000000000","0x0000000000000000001ee456b92a7d2300000000000000000000000000000000","0x0000000000000000001edc6f33288f1a00000000000000000000000000000000","0x0000000000000000001ed489b2ea05c300000000000000000000000000000000","0x0000000000000000001ecca637ea65ee00000000000000000000000000000000","0x00000000000000000024e4f1af14422e00000000000000000000000000000000","0x00000000000000000029adb7aae11b6900000000000000000000000000000000","0x000000000000000000317b42926daf5700000000000000000000000000000000","0x0000000000000000003da14e5c8af00100000000000000000000000000000000","0x0000000000000000004fadbc880879c300000000000000000000000000000000","0x000000000000000000693dc58478844300000000000000000000000000000000","0x0000000000000000008bb58e60d9d23f00000000000000000000000000000000","0x000000000000000000b7de4efc87ebbf00000000000000000000000000000000","0x000000000000000000ed79eb3192fe6700000000000000000000000000000000","0x0000000000000000012ae5705294743f00000000000000000000000000000000","0x0000000000000000016ce9dfe004dc8f00000000000000000000000000000000","0x000000000000000001aed7ba729bc1ff00000000000000000000000000000000","0x000000000000000001eafbc6dc8ef93f00000000000000000000000000000000","0x0000000000000000021b6497891b5c7f00000000000000000000000000000000","0x0000000000000000023ad6b6c09668df00000000000000000000000000000000","0x000000000000000000e7590516305cb700000000000000254b50e9dd7775fd33","0x00000000000000000000000000000000000000000000003d2b1dd2eb6331eccd","0x000000000000000000000000000000000000000000000039cc2ec2104961e50c","0x0000000000000000000000000000000000000000000000349ca4a9271d75f0c4","0x00000000000000000000000000000000000000000000002f40afd9373559df21","0x0000000000000000000000000000000000000000000000294632e50f62d1f75d","0x000000000000000000000000000000000000000000000023494b76ce456ffb4f","0x00000000000000000000000000000000000000000000001dca4dc5d69b5bffe3","0x00000000000000000000000000000000000000000000001921463da808a9e857","0x00000000000000000000000000000000000000000000000efdb68250910c7487","0x00000000000000000000000000000000000000000000000b4c0229dfd3a46168","0x0000000000000000000000000000000000000000000000088e344fe82242f28c","0x0000000000000000000000000000000000000000000000069e32c01991bcf2c8","0x0000000000000000000000000000000000000000000000054fc8112d9e64356f","0x0000000000000000000000000000000000000000000000047862fa2363f8f976","0x000000000000000000000000000000000000000000000003f3aabb8dfb216a1e","0x0000000000000000000000000000000000000000000000034b0d1f8aee21c20b","0x0000000000000000000000000000000000000000000000034a3568eec33c45a3","0x000000000000000000000000000000000000000000000003495de98485953236","0x0000000000000000000000000000000000000000000000034886a13e15b83b45","0x00000000000000000000000000000000000000000000000347af900d57cdf42e","0x00000000000000000000000000000000000000000000000346d8b5e4339b6963","0x000000000000000000000000000000000000000000000003460212b49480c9b4","0x000000000000000000000000000000000000000000000003452ba6706978bafa","0x00000000000000000000000000000000000000000000000344557109a516e11d","0x000000000000000000000000000000000000000000000003437f72723d87de15"] | 253920279 | 2024-09-15T22:58:45.000Z | 0xc451bcf018441b21a27b5bbebcd216b90b324647f755be285ed3418374593095 |
| 0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6 | \["8384146","8384147","8384148","8384149","8384150","8384151","8384152","8384153","8384154","8384155","8384156","8384157","8384158","8384159","8384160","8384161","8384162","8384163","8384164","8384165","8384166","8384167","8384168","8384169","8384170","8384171","8384172","8384173","8384174","8384175","8384176","8384177","8384178","8384179","8384180","8384181","8384182","8384183","8384184","8384185","8384186","8384187","8384188","8384189","8384190","8384191","8384192","8384193","8384194","8384195","8384196"] | 0x4b9bfed1dd4e6780454b2b02213788f31ffba74a | false | 0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6 | 24 | \["0x0000000000000000001d7c3ec40ad43700000000000000000000000000000000","0x0000000000000000001d74b36157126400000000000000000000000000000000","0x0000000000000000001d6d29ecd35fbc00000000000000000000000000000000","0x0000000000000000001d65a26601495c00000000000000000000000000000000","0x0000000000000000001d5e1ccc627cb700000000000000000000000000000000","0x0000000000000000001d56991f78c78d00000000000000000000000000000000","0x0000000000000000001d4f175ec617f200000000000000000000000000000000","0x0000000000000000001d479789cc7c3100000000000000000000000000000000","0x0000000000000000001d4019a00e22d700000000000000000000000000000000","0x0000000000000000001d389da10d5aa100000000000000000000000000000000","0x000000000000000000367853c3db299100000000000000000000000000000000","0x0000000000000000004a4f75e5a26ff200000000000000000000000000000000","0x0000000000000000006a9b74d174629500000000000000000000000000000000","0x0000000000000000009cd64090ade01400000000000000000000000000000000","0x000000000000000000e769bb623b53dd00000000000000000000000000000000","0x00000000000000000150ff14520379fc00000000000000000000000000000000","0x000000000000000001df53f38742545d00000000000000000000000000000000","0x00000000000000000295a6b070a4563e00000000000000000000000000000000","0x00000000000000000372f6fdf68774fc00000000000000000000000000000000","0x00000000000000000470840a835a603c00000000000000000000000000000000","0x0000000000000000058109b1319937bd00000000000000000000000000000000","0x000000000000000006913221e73e85bd00000000000000000000000000000000","0x0000000000000000078977c5b9fd2ffd00000000000000000000000000000000","0x000000000000000008515454903caffd00000000000000000000000000000000","0x000000000000000008d3306df585d3ff00000000000000000000000000000000","0x000000000000000002d4fbad5e2618fe00000000000000aaa0725795ac7f833e","0x0000000000000000000000000000000000000000000000f7a33d5a10de179a34","0x0000000000000000000000000000000000000000000000e9684fa16b71e7e1f9","0x0000000000000000000000000000000000000000000000d38288668db6e7ff90","0x0000000000000000000000000000000000000000000000b84f534323a7dfab39","0x00000000000000000000000000000000000000000000009a7e5b2ea416c7fe7c","0x00000000000000000000000000000000000000000000007ff9bec1b5e99bdc76","0x00000000000000000000000000000000000000000000006789156cb0babfb7b7","0x000000000000000000000000000000000000000000000052a05b0a266317b814","0x000000000000000000000000000000000000000000000041fceba9e8e617f2df","0x000000000000000000000000000000000000000000000035bad9fa721647aba4","0x00000000000000000000000000000000000000000000001977cb905cd931b12d","0x0000000000000000000000000000000000000000000000114b0546f9dd41bd37","0x00000000000000000000000000000000000000000000000bc8eb6775f18fa3d5","0x0000000000000000000000000000000000000000000000083da7894a8a1ad00f","0x0000000000000000000000000000000000000000000000060fab5a5ba7fb6af9","0x0000000000000000000000000000000000000000000000034a079da8197a0c42","0x000000000000000000000000000000000000000000000003493029f584ad4446","0x0000000000000000000000000000000000000000000000034858ed63be2345a0","0x0000000000000000000000000000000000000000000000034781e7e4aac8f40c","0x00000000000000000000000000000000000000000000000346ab196a33270107","0x00000000000000000000000000000000000000000000000345d481e643626904","0x00000000000000000000000000000000000000000000000344fe214acb39070c","0x0000000000000000000000000000000000000000000000034427f789be028f23","0x0000000000000000000000000000000000000000000000034352049512af16b3","0x000000000000000000000000000000000000000000000003427c485ec3c51fc3"] | 253850686 | 2024-09-15T18:01:52.000Z | 0xe78ea2347f502e003a93c5e9210ae7383635a6440f9439c55782d421ceea090a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBPairV2_DepositedToBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV2\_FlashLoan\_event
Flash loan events from Trader Joe V2 Liquidity Book (LB) pairs on Arbitrum. Records borrowed amounts, fees charged, and active bin IDs for analyzing arbitrage strategies and flash loan usage 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_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 for the liquidity book pair at the time of the flash loan execution. Represented as a decimal integer that determines the current price point in Trader Joe V2's liquidity book. |
| `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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------------------------------ | ------------ | ------------------------------------------ | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x94d53be52706a155d27440c4a2434bea772a6f7c | false | 0x123453a3995a7bd997e69c0b23844c48e3023816 | 20 | 0x0000000000000000000000000000000000000000000000001329de6c3afce52a | 8375097 | 0x123453a3995a7bd997e69c0b23844c48e3023816 | 123984922 | 0x000000000000000000000000000000000000000000000000000006478e1b1bef | 2023-08-22T22:02:53.000Z | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x3de0f2c0a8d3201910e6fb4d5bd8458b3d49043e57101d380d8542449a8fbf22 |
| 0x94d53be52706a155d27440c4a2434bea772a6f7c | false | 0x123453a3995a7bd997e69c0b23844c48e3023816 | 13 | 0x0000000000000000000000000000000000000000000000000bddc20c1520e76f | 8375097 | 0x123453a3995a7bd997e69c0b23844c48e3023816 | 123984923 | 0x000000000000000000000000000000000000000000000000000003e3699c3f9d | 2023-08-22T22:02:53.000Z | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xa1365d13f5d59463bddd771057b2b4c980bf901320a52e0a3686f72997685e6b |
| 0x94d53be52706a155d27440c4a2434bea772a6f7c | false | 0x123453a3995a7bd997e69c0b23844c48e3023816 | 17 | 0x000000000000000000000000000000000000000000000000020cfa2bfaa5609a | 8375098 | 0x123453a3995a7bd997e69c0b23844c48e3023816 | 123978710 | 0x000000000000000000000000000000000000000000000000000000ac06483f21 | 2023-08-22T21:33:30.000Z | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x086a6c2028a1b48783b7f8f7061cdae525e16f36017a316dbbd43f07ad87282d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 Arbitrum. Captures updates to dynamic fee settings including base factors, volatility accumulators, protocol share, and decay periods for analyzing fee structure changes 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_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | -------------- | --------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------- | ---------------------- | ---------------------------- |
| 0xb81076e0300139cd680758448d99d3c157ff16b6 | false | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | 4 | 127754316 | 8000 | 600 | 2023-09-03T20:58:33.000Z | 30 | 2500 | 0x11eb5d3854bc0d87f69bae9b7c2762feee85af6857a5c7ff975b5091e8247c87 | 5000 | 120000 | 300000 |
| 0x5a4ef05343245cf6e5011c48459e68aab0a7b95e | false | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | 1 | 127754316 | 10000 | 120 | 2023-09-03T20:58:33.000Z | 10 | 500 | 0x11eb5d3854bc0d87f69bae9b7c2762feee85af6857a5c7ff975b5091e8247c87 | 5000 | 2000000 | 100000 |
| 0x2ca62fb6d1a754e4f3e844b32230e47bcd44bc6e | false | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | 1 | 88333031 | 8000 | 1200 | 2023-05-07T19:15:22.000Z | 300 | 0 | 0xf8ab57f256d2897972024f56d40a435c9491c495dac5d2f79ec34e993fb830ad | 5000 | 7500 | 150000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8375324 | 0x003ad0975250c810ad75fd83e989f54625cac514 | 0x69f1216cb2905bf0852f74624d5fa7b5fc4da710 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 1 | 175202606 | 0x00000000000000000000000000073e4400000000000000000000000000000000 | 0x000000000000000000000000000002c900000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000bf60c6d449db | 2024-01-28T23:53:11.000Z | 0x0000000000000000000000000000004700000000000000000000000000000000 | 0x40b28d2c66b26d998fb8cf22c7cd0ae560447e92a72917486f506807985ed1b3 | 0 |
| 8375325 | 0x003ad0975250c810ad75fd83e989f54625cac514 | 0x69f1216cb2905bf0852f74624d5fa7b5fc4da710 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 2 | 175202606 | 0x0000000000000000000000000091525a00000000000000000000000000000000 | 0x0000000000000000000000000000381100000000000000000000000000000000 | 0x000000000000000000000000000000000000000000000000000ef9e06306b77a | 2024-01-28T23:53:11.000Z | 0x0000000000000000000000000000059b00000000000000000000000000000000 | 0x40b28d2c66b26d998fb8cf22c7cd0ae560447e92a72917486f506807985ed1b3 | 10000 |
| 8384348 | 0x00904a678800616f2cdf4fde57f7c4df5f2e117e | 0x4b9bfed1dd4e6780454b2b02213788f31ffba74a | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 5 | 174867356 | 0x0000000000000000125637cb4bc897a400000000000000000000000000000000 | 0x000000000000000000096a45e811a8a300000000000000000000000000000000 | 0x00000000000000000000000000000000000000000000016388638cfdb2f007e8 | 2024-01-28T00:15:33.000Z | 0x00000000000000000001e20dfb36bb5300000000000000000000000000000000 | 0x4045859c18523624b1f7319c6384df2c191fe6e2e092b0a86726521afc476817 | 7812 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 pairs on Arbitrum. Records transfers or burns of multiple price bin positions with bin IDs and token amounts for tracking 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 |
| ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0000000000000000000000000000000000000000 | \["8388192","8388193","8388194","8388195","8388196"] | 0x38b1c0b4439e4a0c87a3e33f9714c899f0e2b655 | 0xc3eda3a3eaed8c41df3df081c1aac687c5e86502 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 0 | \["885964800360124634736105395295131751504797054242001052080","900776643878527783417983314499454920381847449601651040363","915796127787262847364518013244164738452447972918892164484","931025923709784782977377893945939556751785577179886710912","946468735937978453202121150931370319524228935444842461721"] | 90314712 | 2023-05-13T15:18:58.000Z | 0x610520b210ba04de38ae67a9afb705ab6c406b3555ba0e1f473c6ca486b4010c |
| 0x0000000000000000000000000000000000000000 | \["8388247","8388248","8388249","8388250","8388251","8388252","8388253","8388254","8388255","8388256","8388257","8388258","8388259","8388260","8388261","8388262","8388263","8388264","8388265","8388266","8388267","8388268","8388269","8388270","8388271","8388272","8388273","8388274","8388275","8388276","8388277","8388278","8388279","8388280","8388281","8388282","8388283","8388284","8388285","8388286","8388287","8388288","8388289","8388290","8388291","8388292","8388293","8388294","8388295","8388296","8388297","8388298","8388299","8388300","8388301","8388302","8388303","8388304","8388305","8388306","8388307","8388308","8388309","8388310","8388311","8388312","8388313","8388314","8388315","8388316","8388317","8388318","8388319","8388320","8388321","8388322","8388323","8388324","8388325","8388326","8388327","8388328","8388329","8388330","8388331","8388332","8388333","8388334","8388335","8388336","8388337"] | 0x38b1c0b4439e4a0c87a3e33f9714c899f0e2b655 | 0xc3eda3a3eaed8c41df3df081c1aac687c5e86502 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 0 | \["190018345562126597372100037241140148453655073870276365170","192973026429933235440181738472048675658804189943963591880","195967799080539925186702079378102694696597934104776337712","199003169881515698445127349310187945278554421367505272595","202079651318602837300910226631313610819905430523025060850","205197762067443683572698322677069413095226462903004248898","208358027066129427800781382294942185748486131928907730296","211560977588582182053213476469790027300890658867762910811","214807151318777338544688044761051157881785921314356949112","218097092425817580250045133595633247399857085130880917178","221431351639866749066007204897352133547785886447177729601","224810486328954278367018104561306805053542262298132475677","228235060576659571589703012413820012074164262875583299576","231705645260686117198362563050303337009990115585007958676","235222818132335527751263679625098808705503348993937542940","238787163896891772329303893334458575092224116102949350021","242399274294925994687060049914192855286813198153854225577","246059748184531212303639322250730227340510024598054166840","249769191624498997595095060139355036974116783512139561530","253528217958447729989915826882075679246769671598320518270","257337447899912942168919558644802905286034396586615884194","261197509618411659232097853677018700799043142509164374500","265109038826490313474593407634922877099339612021889446268","269072678867768699636015662886617435042085959285671768252","273089080805990051278989680163557584924930663126794500505","277158903515089053096878286159733528420701758088223266289","281282813770289388203714709404610331689169341720862250350","285461486340242269314822763738227700099494725581015810557","289695604080217130419813571330593362388985446983284140052","293985858026357464519972712798432515176826331142849366018","298332947491012633257271424726254354304505184192119193982","302737580159158219458003960943716234715623668541151558791","307200472185917666785934174947467645078545998511013316168","311722348295196412838078654359940559280715671710791763200","316303941879442064504084373639258311836112346540974518728","320945995100543161763881035404287259004476803913346368630","325649258991878284038651039642036417316258142721746324187","330414493561530054442740055861000130102542667853594598856","335242467896675726210026990490332205898333050237407162284","340133960269168104085860186584811997865780045781603219170","345089758242320716811157799156203706056492306899805722733","350110658778909464980552777960364767229119021367359477888","355197468350405700074307953326015241405093959742808594705","360351003047453968923440176921182688597151651328764865892","365572088691608219671837867831016102614701237415267683135","370861560948340749075448225963201104966723263153267925704","376220265441338783160607199727191385245611522782803112666","381649057868101982104972094193949610800985107872588699770","387148804116856330474930159117766255227371279975190792583","392720380384798936095804735510066904322492715019339883089","398364673297688589946146421865368326694512602697849677498","404082580030797696322876701796894017766125414974114984736","409875008431239215952423989637860457552526414101407796500","415742877141686344092904895057258159031014199823567438746","421687115725499413909884289114435278237118000088334559543","427708664793274659332551949935009415539804446321742013967","433808476130832734213988651944868401779220635507874328932","439987512828662621991628950060922019640554277248809931936","446246749412836109622097598207746936806132745178674225432","452587171977410114518572544059521099192070183403508120049","459009778318334315902014779068509970123686449453184832101","465515578068879282295351608023935264274688371699501852244","472105592836603425618300975006538247846207993135462009046","478780856341875119007978741385339065323670034589411233864","485542414557968427373000214790356465471501673101383512398","492391325852749574546702439529393947756840596842475286412","499328661131970524705565205650223661355548333778744086304","506355503984190502212998521644153211173103638524596611747","513472950827341800082233502994813786472465059969253948208","520682111056957728656012363244741006362701570712239009563","527984107196083217585904293433705262374630611797033905530","535380075046885471951117730933730525945793304549158690236","542871163843984138544226914419822016390366116493990515152","550458536409520189034732018848942916379136698797828241705","558143369309982462017336665138339289883531468021599266254","565926853014813028460456283976450472432389490282249754176","573810192056809310062252174720046205462359678439188809416","581794605194344036013401594166706700678600554747491885724","589881325575423671384093663600855198588617655434284140142","598071600903605543961075138497986206396706120937963575728","606366693605793538193216603109617440084829302446728927056","614767881001934743942305052203256818790553118286604255400","623276455476638384143988683287796451166045698390900511510","631893724652735794193198559950765804342877220629298440474","640621011566807599160294394802907364107417609032718816765","649459654846695538743012671550711349692056436285402684641","658411008891024499968730277228651696634021008361375612820","667476444050755427817714330989988601277132073197277225548","676657346812791814251528531589466628711331001796674388050","685955119985663823811189694426168144298546185341524877635","695371182887312111760262909056283173464680135501894850720"] | 90305000 | 2023-05-13T14:38:34.000Z | 0x7cf357caf68f649b1dc1e24d198f3ecbd3d0f244ca8c96aacd124e8c472de01e |
| 0x0000000000000000000000000000000000000000 | \["8375128","8375129","8375130","8375131","8375132","8375133","8375134","8375135","8375136","8375137","8375138","8375139","8375140","8375141","8375142","8375143","8375144","8375145","8375146","8375147"] | 0x94d53be52706a155d27440c4a2434bea772a6f7c | 0xdcd87577e10aacf33bd2fefa57e4041c61fdfd50 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 1 | \["80744968220055180444989801403841418648679874560","207629918280141892572830917895592219382319677440","207629918280141892572830917895592219382319677440","207629918280141892572830917895592219382319677440","207652988063489664516899880840477663539983548416","207652988063489664516899880840477663539983548416","207652988063489664516899880840477663539983548416","207652988063489664516899880840477663539983548416","207652988063489664516899880840477663539983548416","207652988063489664516899880840477663539983548416","207652988063489664516899880840477663539983548416","207676057846837436460968843785363107697647419392","207676057846837436460968843785363107697647419392","207676057846837436460968843785363107697647419392","207676057846837436460968843785363107697647419392","207676057846837436460968843785363107697647419392","207676057846837436460968843785363107697647419392","207676057846837436460968843785363107697647419392","212744090369352427848853131008980357617702404096","212744090369352427848853131008980357617702404096"] | 90145840 | 2023-05-13T03:30:39.000Z | 0x878a646c18ff0c6c2953352799e467bcfd037b81ab88ff33d8beee2346dd683e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x060d2ed5c447e194e7a107d2009847e1e475da06 | \["8385808","8385809","8385810","8385811","8385812","8385813","8385814","8385815","8385816","8385817","8385818","8385819","8385820","8385821","8385822","8385823","8385824","8385825","8385826","8385827","8385828","8385829","8385830","8385831","8385832","8385833","8385834","8385835","8385836","8385837","8385838","8385839","8385840","8385841","8385842","8385843","8385844","8385845","8385846","8385847","8385848","8385849","8385850","8385851","8385852","8385853","8385854","8385855","8385856","8385857","8385858","8385859","8385860","8385861","8385862","8385863","8385864","8385865","8385866","8385867","8385868","8385869","8385870","8385871","8385872","8385873","8385874","8385875","8385876","8385877","8385878"] | 0x3136010d266152f3890d303c8ac8bcf3b2fe30e3 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 3 | \["0x00000000000000000000000000000000000000000000000058f4cae4951c9240","0x000000000000000000000000000000000000000000000000629315283dd62923","0x0000000000000000000000000000000000000000000000006ce04ccbf3e0cd21","0x00000000000000000000000000000000000000000000000077e1ccfaf3cabb37","0x00000000000000000000000000000000000000000000000084f82447b93ec3e5","0x000000000000000000000000000000000000000000000000908233f5cab9529d","0x0000000000000000000000000000000000000000000000009cdc27ae6cd23829","0x000000000000000000000000000000000000000000000000aa7947d7a308a51b","0x000000000000000000000000000000000000000000000000b8a11c030387872d","0x000000000000000000000000000000000000000000000000c74ecde8f05671c2","0x000000000000000000000000000000000000000000000000d6b4a2ec0015ad00","0x000000000000000000000000000000000000000000000000ed0241002a629948","0x0000000000000000000000000000000000000000000000010287927609819850","0x0000000000000000000000000000000000000000000000010fafa865dd70e9f2","0x00000000000000000000000000000000000000000000000123856a4ce894c20e","0x0000000000000000000000000000000000000000000000012a5cb926921a9a7e","0x000000000000000000000000000000000000000000000001415433d8a9730ea2","0x00000000000000000000000000000000000000000000000164ba54bfe265efbf","0x00000000000000000000000000000000000000000000000182c1b942b18d777d","0x0000000000000000000000000000000000000000000000018636ade8c25237cd","0x0000000000000000000000000000000000000000000000019d9ad5d81f142945","0x000000000000000000000000000000000000000000000001b6f36151d07b8fbd","0x000000000000000000000000000000000000000000000001cf8167de8f151793","0x000000000000000000000000000000000000000000000001f2fd05f94dd7407e","0x000000000000000000000000000000000000000000000001e3db522504960b8d","0x000000000000000000000000000000000000000000000001d7c99ce94aef57e6","0x000000000000000000000000000000000000000000000001cffb656b44bbd25a","0x000000000000000000000000000000000000000000000001d5d38a1d75008170","0x000000000000000000000000000000000000000000000001d6955622af48bd42","0x000000000000000000000000000000000000000000000001dcd685ddfa8234f0","0x000000000000000000000000000000000000000000000001e64d7501dd049772","0x000000000000000000000000000000000000000000000001ef3dd1837046beef","0x000000000000000000000000000000000000000000000001f0b337fc0c47bd4a","0x000000000000000000000000000000000000000000000002085f14b6c13f7136","0x0000000000000000000000000000000000000000000000021366512b344dbb85","0x000000000000000000000000000000000000000000000002318be1f63e192b96","0x0000000000000000000000000000000000000000000000025073ba85815ae16b","0x0000000000000000000000000000000000000000000000023afe40ced9399fda","0x0000000000000000000000000000000000000000000000020a9148dbf803f68c","0x000000000000000000000000000000000000000000000001f64708c3da6dcbab","0x000000000000000000000000000000000000000000000001ef2a348411753e04","0x000000000000000000000000000000000000000000000001c6a0cad091d6fd0b","0x000000000000000000000000000000000000000000000001bc98e5dec3607b28","0x000000000000000000000000000000000000000000000001bc337146d744cf0b","0x000000000000000000000000000000000000000000000001b4ee62107af1204a","0x000000000000000000000000000000000000000000000001a2b362ca8335f29d","0x0000000000000000000000000000000000000000000000019a3d86cd33d69785","0x0000000000000000000000000000000000000000000000018b7be50e647a1e13","0x000000000000000000000000000000000000000000000001979b3864195b5f68","0x0000000000000000000000000000000000000000000000016f7f66f9ad71593a","0x0000000000000000000000000000000000000000000000014dca2ec7e7e107b1","0x0000000000000000000000000000000000000000000000013479edeede2e13ab","0x0000000000000000000000000000000000000000000000012178f4f0f9424dc0","0x0000000000000000000000000000000000000000000000010e0e5e1636053d69","0x000000000000000000000000000000000000000000000000fe39b9dae67cda1c","0x000000000000000000000000000000000000000000000000ee8aebdc119bfdaf","0x000000000000000000000000000000000000000000000000df18fd073d2616cd","0x000000000000000000000000000000000000000000000000cff8ee496d44001d","0x000000000000000000000000000000000000000000000000c13d966d0798fad5","0x000000000000000000000000000000000000000000000000b2f78af1e8a107ba","0x000000000000000000000000000000000000000000000000a535139136ea1e9f","0x000000000000000000000000000000000000000000000000980227e7eb239c13","0x0000000000000000000000000000000000000000000000008b687693a0f06f85","0x0000000000000000000000000000000000000000000000007f6f74e5e3b39bd2","0x000000000000000000000000000000000000000000000000741c76334d7f7895","0x0000000000000000000000000000000000000000000000006972c9ada84a4b5e","0x0000000000000000000000000000000000000000000000005f73ddaabc55dcef","0x000000000000000000000000000000000000000000000000561f6734393c51b0","0x0000000000000000000000000000000000000000000000004d738cbf9e050cea","0x000000000000000000000000000000000000000000000000456d12f66ca41581","0x0000000000000000000000000000000000000000000000003e078a8665c91b5c"] | 130531360 | 2023-09-12T21:46:35.000Z | 0xb35b8b737c912253f8354dcc6258e0036a415a8cbfedb217c9054d223ff450ad |
| 0x2a71d06dc6fe843f2a4fd102aa71fee706a1fb15 | \["8394168","8394169","8394170","8394171","8394172","8394173","8394174","8394175","8394176","8394177","8394178"] | 0xd8053763b1179bd412a5a5a42fa2d15851518cfb | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 3 | \["0x000000000000000000000000008bc41900000000000000000000000000000000","0x000000000000000000000000008bc41900000000000000000000000000000000","0x000000000000000000000000008bc41900000000000000000000000000000000","0x000000000000000000000000008bc41900000000000000000000000000000000","0x000000000000000000000000008bc41900000000000000000000000000000000","0x000000000000000000000000008b43b900000000000000000000000000000000","0x000000000000000000000000008b285000000000000000000000000000000000","0x000000000000000000000000008b4c2300000000000000000000000000000000","0x000000000000000000000000008b6f6f00000000000000000000000000000000","0x0000000000000000000000000004c6da000000000000000000000000000083e0","0x000000000000000000000000000000000000000000000000000000000000888c"] | 130460664 | 2023-09-12T16:02:10.000Z | 0xde06851d775f3deb8c743a31e75df23c3f9cda72bd1fc7ff448487f5b5411108 |
| 0x35d58b2b325bafa70008d0a5c0c36cd911ceec07 | \["8388604"] | 0x0242dd3b2e792cdbd399cc6195951bc202aee97b | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 2 | \["0x0000000000000000000000037db5ca4a00000000000000000000000000000000"] | 130323299 | 2023-09-12T06:01:25.000Z | 0xbff21a144d515379ee1ae862c74118db1f9bb46dadcf71618e8137db4f3e0b76 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBPairV2_WithdrawnFromBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV22\_DepositedToBins\_event
Liquidity addition events from Trader Joe V2.2 liquidity book pairs on Arbitrum, recording deposits into specific price bins with sender, recipient, bin IDs, and token amounts. Used for tracking liquidity provider positions and analyzing concentrated liquidity distributions across price ranges.
| 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 |
| ------------------------------------------ | ------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x31307ef22c77cc89cd7e61246608f15b82d09fed | \["8380326"] | 0xc09f4ad33a164e29df3c94719ffd5f7b5b057781 | false | 0x18556da13313f3532c54711497a8fedac273220e | 48 | \["0x000000000000000000000000000000000000000000000443b77bb2163e49c901"] | 280547589 | 2024-12-02T11:20:05.000Z | 0xb537aae0eaead6e5ca45c369d1f71ae9c03f4589c67bd07c38212bd65a5186ec |
| 0x31307ef22c77cc89cd7e61246608f15b82d09fed | \["8380331"] | 0xc09f4ad33a164e29df3c94719ffd5f7b5b057781 | false | 0x18556da13313f3532c54711497a8fedac273220e | 39 | \["0x00000000000000000003e12b101840000000000000000192aa8572c997673c13"] | 280565607 | 2024-12-02T12:35:35.000Z | 0xb0751f2f450ad8ddb55854565df7f326b35ef6df6ca5f3406420e3569f7814ce |
| 0x31307ef22c77cc89cd7e61246608f15b82d09fed | \["8380331"] | 0xc09f4ad33a164e29df3c94719ffd5f7b5b057781 | false | 0x18556da13313f3532c54711497a8fedac273220e | 40 | \["0x00000000000000000023777c50c9518400000000000004427f2223876d800000"] | 280564614 | 2024-12-02T12:31:25.000Z | 0xc99bd5603d75dc920e61ba1cfc7e7145c52ce0f7ac5bb7dea9bf24fb7b4713b1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBPairV22_DepositedToBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPairV22\_Swap\_event
Swap execution events from Trader Joe V2.2 Liquidity Book pairs on Arbitrum, capturing token exchanges with input/output amounts, fees, volatility metrics, and active bin identifiers. Used for analyzing DEX trading activity, fee generation, and liquidity distribution 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_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 |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8441346 | 0x00000000063e0e1e06a0fe61e16be8bdec1bea31 | 0xecfe947bf3b6dbf5776ba6eb7bf4d03d4aa7c5f9 | false | 0x6667c8dc9fbfec411e7c1ee2b24de960149f930f | 24 | 274118949 | 0x0000000000000000002c888834313b6000000000000000000000000000000000 | 0x0000000000000000000005318fe4dbea00000000000000000000000000000000 | 0x000000000000000000000000000000000000000000000000000000000000ae0b | 2024-11-13T18:19:52.000Z | 0x000000000000000000000084f4ca15fd00000000000000000000000000000000 | 0xf9ea1c7c5fc9784449bfd2ae46999d6b961593e6ff657a18437c8161e4453cbe | 43026 |
| 8369028 | 0x00000000063e0e1e06a0fe61e16be8bdec1bea31 | 0xb7236b927e03542ac3be0a054f2bea8868af9508 | false | 0x6667c8dc9fbfec411e7c1ee2b24de960149f930f | 21 | 274165826 | 0x000000000000000000000000000000000000000000000000006fd27e2558f113 | 0x000000000000000000000000000000000000000000000000000005f9e40465f2 | 0x00000000000000000000000005f1240500000000000000000000000000000000 | 2024-11-13T21:36:33.000Z | 0x00000000000000000000000000000000000000000000000000000098fd33a3cb | 0x8ef25b097e9ee500223e42ea96419be19fbdd0998ac1f4f6c74651d4b428420e | 14797 |
| 8369029 | 0x00000000063e0e1e06a0fe61e16be8bdec1bea31 | 0xb7236b927e03542ac3be0a054f2bea8868af9508 | false | 0x6667c8dc9fbfec411e7c1ee2b24de960149f930f | 20 | 274165826 | 0x000000000000000000000000000000000000000000000000001aed504f304375 | 0x0000000000000000000000000000000000000000000000000000016291afe7a2 | 0x000000000000000000000000016ea99600000000000000000000000000000000 | 2024-11-13T21:36:33.000Z | 0x0000000000000000000000000000000000000000000000000000002374f7fd90 | 0x8ef25b097e9ee500223e42ea96419be19fbdd0998ac1f4f6c74651d4b428420e | 4797 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.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 Arbitrum, capturing bin IDs and token amounts removed from concentrated liquidity positions. Used for tracking liquidity provider exit activity and position management 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 |
| ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x18556da13313f3532c54711497a8fedac273220e | \["8368851","8368852","8368853","8368854","8368855","8368856","8368857","8368858","8368859","8368860","8368861","8368862","8368863","8368864","8368865","8368866","8368867","8368868","8368869","8368870","8368871","8368872","8368873","8368874","8368875"] | 0xb7236b927e03542ac3be0a054f2bea8868af9508 | false | 0x18556da13313f3532c54711497a8fedac273220e | 50 | \["0x0000000000000000000000000000000000000000000000000000475550c314c2","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a","0x000000000000000000000000000000000000000000000000000047553a199b9a"] | 265788098 | 2024-10-20T12:37:04.000Z | 0xd452b432590bc929e013e1c3dd1d3492a9c69ef5547d76163f419a03a94a8e6d |
| 0x18556da13313f3532c54711497a8fedac273220e | \["8368868"] | 0xb7236b927e03542ac3be0a054f2bea8868af9508 | false | 0x18556da13313f3532c54711497a8fedac273220e | 43 | \["0x000000000000000000000000005227ed00000000000000000000000000000000"] | 265842018 | 2024-10-20T16:22:59.000Z | 0x8ab5c18ff0d44d5a174cd456c0212da7d9ed88b33023d4902b8a12c58fc645da |
| 0x8ea12bb8ce61315abbcfd9795427bf25c98e82fb | \["8380097","8380098","8380099","8380100","8380101","8380102","8380103","8380104","8380105","8380106","8380107","8380108","8380109","8380110","8380111","8380112","8380113","8380114","8380115","8380116","8380117","8380118","8380119","8380120","8380121","8380122","8380123","8380124","8380125","8380126","8380127","8380128","8380129","8380130","8380131","8380132","8380133","8380134","8380135","8380136","8380143","8380144","8380145","8380146","8380147","8380148","8380149","8380150","8380151","8380152","8380153","8380154","8380155","8380156","8380157","8380158","8380159","8380160","8380161"] | 0xc09f4ad33a164e29df3c94719ffd5f7b5b057781 | false | 0x18556da13313f3532c54711497a8fedac273220e | 65 | \["0x00000000000000000035ecbe8396379b00000000000000000000000000000000","0x00000000000000000036747fe36df54a00000000000000000000000000000000","0x000000000000000000364c0dffb1428f00000000000000000000000000000000","0x00000000000000000035e3a9a18b009700000000000000000000000000000000","0x00000000000000000035a9cd52bd39a200000000000000000000000000000000","0x0000000000000000006bf2dc18f03f6400000000000000000000000000000000","0x0000000000000000006d62aa3948784b00000000000000000000000000000000","0x0000000000000000006e691fd3c6732e00000000000000000000000000000000","0x0000000000000000006edba774ea97d200000000000000000000000000000000","0x0000000000000000006fad0e206e7ba300000000000000000000000000000000","0x00000000000000000037d44df7f17d2100000000000000000000000000000000","0x00000000000000000037da343bd62d9e00000000000000000000000000000000","0x00000000000000000037b63924b0e10e00000000000000000000000000000000","0x000000000000000000373fa0fb3b770000000000000000000000000000000000","0x00000000000000000037a5ae39cd121000000000000000000000000000000000","0x00000000000000000038309828b9959000000000000000000000000000000000","0x0000000000000000005087d1a721bf3500000000000000000000000000000000","0x0000000000000000007f99ea5dc2c11700000000000000000000000000000000","0x000000000000000000aef6d872bc2ab000000000000000000000000000000000","0x00000000000000000107042328079ec600000000000000000000000000000000","0x00000000000000000107194b443f45d500000000000000000000000000000000","0x0000000000000000012d5f8c73dc2ef400000000000000000000000000000000","0x0000000000000000012bca19813c9f9300000000000000000000000000000000","0x000000000000000000b363ccdbbca88a00000000000000000000000000000000","0x00000000000000000080391c3bc1989d00000000000000000000000000000000","0x0000000000000000005bb62958a4344e00000000000000000000000000000000","0x0000000000000000005b92aeb042be8e00000000000000000000000000000000","0x0000000000000000005be5463181971a00000000000000000000000000000000","0x0000000000000000005c777c2855341800000000000000000000000000000000","0x0000000000000000005bcf0f7930470800000000000000000000000000000000","0x0000000000000000005b0b59a618b49f00000000000000000000000000000000","0x0000000000000000005a931e0049f57800000000000000000000000000000000","0x000000000000000000367b7a6676ff9300000000000000000000000000000000","0x000000000000000000366599975889b100000000000000000000000000000000","0x000000000000000000369de2b6ddfe6500000000000000000000000000000000","0x000000000000000000d0079d387e651800000000000000000000000000000000","0x000000000000000000d1bc8815161e0000000000000000000000000000000000","0x000000000000000000d2d861ff35508300000000000000000000000000000000","0x000000000000000000d2e028adc0970200000000000000000000000000000000","0x0000000000000000009a3c4bdffb6d9500000000000000000000000000000000","0x0000000000000000001587715d60aca800000000000000000000000000000000","0x000000000000000000157c8afdbcf08500000000000000000000000000000000","0x0000000000000000001564986da3f94100000000000000000000000000000000","0x00000000000000000015861d73e6290200000000000000000000000000000000","0x00000000000000000015b12517aea4e200000000000000000000000000000000","0x00000000000000000015c4a9de5eabd900000000000000000000000000000000","0x000000000000000000160cb786e85e4600000000000000000000000000000000","0x0000000000000000001631f69ff9b35300000000000000000000000000000000","0x000000000000000000163607f5ba4ae100000000000000000000000000000000","0x000000000000000000168517873de0aa00000000000000000000000000000000","0x00000000000000000016b75c5c9e785400000000000000000000000000000000","0x00000000000000000016a15a1636981500000000000000000000000000000000","0x000000000000000000164ab8f09e6ae900000000000000000000000000000000","0x000000000000000000164b99016fd8a200000000000000000000000000000000","0x0000000000000000001fedd7d59cb3ee00000000000000000000000000000000","0x0000000000000000001fa3948c6ccf0500000000000000000000000000000000","0x0000000000000000001f950877772cad00000000000000000000000000000000","0x0000000000000000001fcb26c931339900000000000000000000000000000000","0x0000000000000000001ffc4e341e727900000000000000000000000000000000"] | 265810586 | 2024-10-20T14:11:16.000Z | 0x901a51981b4a355b795974b7902190b3a75fc47ff81967618dccf50008001f5e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_arbitrum.LBPairV22_WithdrawnFromBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***