> ## 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_bsc
> Tables in tt-contracts.traderjoe_v2_bsc
## Tables
### LBFactory\_FeeParametersSet\_event
Fee parameter configuration events from Trader Joe V2 Liquidity Book (LB) factory contract on BNB Chain. Records dynamic fee settings for liquidity pairs including bin step, base factor, volatility controls, and protocol share for analyzing fee structure changes.
| Column | Type | Description |
| ----------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_LBPair` | `STRING` | Contract address of the Trader Joe V2 liquidity book pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_binStep` | `STRING` | Price bin step size for the Trader Joe V2 liquidity pool. Numeric string representing the step granularity in basis points. |
| `in_baseFactor` | `STRING` | Base fee multiplier for the Trader Joe V2 liquidity pool. Numeric string denominated in basis points. |
| `in_filterPeriod` | `STRING` | Time window used to filter and smooth volatility measurements in the Trader Joe V2 fee model. Numeric string representing seconds. |
| `in_decayPeriod` | `STRING` | Time period over which volatility accumulation decays in the Trader Joe V2 fee model. Numeric string representing seconds. |
| `in_reductionFactor` | `STRING` | Multiplier applied to reduce accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. |
| `in_variableFeeControl` | `STRING` | Sensitivity parameter controlling how quickly fees adjust to volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. |
| `in_protocolShare` | `STRING` | Percentage of trading fees allocated to the protocol in the Trader Joe V2 fee model. Numeric string denominated in basis points. |
| `in_maxVolatilityAccumulated` | `STRING` | Maximum accumulated volatility threshold for the liquidity book pair's dynamic fee calculation. Controls how aggressively fees adjust based on price movement, with typical values ranging from 100,000 to 350,000. |
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | -------------- | --------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------- | ---------------------- | ---------------------------- |
| 0x43646a8e839b2f2766392c1bf8f60f6e587b6960 | false | 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | 0x2d5c468ec1dccf3fdeb47211df726496d113c10f | 150 | 100 | 26838948 | 8000 | 1200 | 2023-03-27T21:36:45.000Z | 300 | 0 | 0x55a57922ab6d0c21b4adfa2f7329c5647a26f134a7e480664d3bba5448095a6f | 5000 | 7500 | 150000 |
| 0x43646a8e839b2f2766392c1bf8f60f6e587b6960 | false | 0xa096167678d14d4c0c5fad210182a4aca5ec07b3 | 0x2d5c468ec1dccf3fdeb47211df726496d113c10f | 147 | 25 | 26838948 | 10000 | 600 | 2023-03-27T21:36:45.000Z | 30 | 0 | 0x55a57922ab6d0c21b4adfa2f7329c5647a26f134a7e480664d3bba5448095a6f | 5000 | 15000 | 350000 |
| 0x43646a8e839b2f2766392c1bf8f60f6e587b6960 | false | 0xb7b43dcd658e0b9adb77f8c81d680eb4f887a3cd | 0x3b0abc81fa6a47135e36a513ad8845f48f1ee179 | 74 | 1 | 26154486 | 20000 | 120 | 2023-03-03T21:13:01.000Z | 10 | 0 | 0x9541af2068b479f618fef8b74fa9246f5ea00f5fbae5f7546bc70ac3a592c702 | 5000 | 2000000 | 100000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBFactory_FeeParametersSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactory\_FeeRecipientSet\_event
Fee recipient configuration changes from Trader Joe V2 Liquidity Book (LB) factory contract on BNB Smart Chain. Tracks updates to the address receiving protocol fees, useful 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0x43646a8e839b2f2766392c1bf8f60f6e587b6960 | false | 108 | 26153438 | 2023-03-03T20:20:24.000Z | 0x3b0abc81fa6a47135e36a513ad8845f48f1ee179 | 0x0000000000000000000000000000000000000000 | 0xb9fe7db13274b7c9bd13b06f3bec0cfe84a53cdb534dd78e45fcdb762b7e6d8b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBFactory_FeeRecipientSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactory\_FlashLoanFeeSet\_event
Events capturing flash loan fee parameter changes in Trader Joe V2 liquidity book factory contracts on BSC. Tracks fee adjustments from old to new values for monitoring protocol revenue configuration and governance actions.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- | ------------------- |
| 0x43646a8e839b2f2766392c1bf8f60f6e587b6960 | false | 109 | 26153438 | 2023-03-03T20:20:24.000Z | 0xb9fe7db13274b7c9bd13b06f3bec0cfe84a53cdb534dd78e45fcdb762b7e6d8b | 5000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBFactory_FlashLoanFeeSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactory\_LBPairCreated\_event
Liquidity book (LB) pair creation events from Trader Joe V2 decentralized exchange on BNB Smart Chain, capturing new trading pair deployments with token addresses, bin step (price precision parameter), and unique pair identifiers. Used for tracking DEX pool launches and analyzing liquidity provision strategies across different price granularities.
| 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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 9 | 0x43646a8e839b2f2766392c1bf8f60f6e587b6960 | false | 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | 0xf7de7e8a6bd59ed41a4b5fe50278b3b7f31384df | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 149 | 100 | 26838948 | 2023-03-27T21:36:45.000Z | 0x55a57922ab6d0c21b4adfa2f7329c5647a26f134a7e480664d3bba5448095a6f |
| 8 | 0x43646a8e839b2f2766392c1bf8f60f6e587b6960 | false | 0xa096167678d14d4c0c5fad210182a4aca5ec07b3 | 0xf7de7e8a6bd59ed41a4b5fe50278b3b7f31384df | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 146 | 25 | 26838948 | 2023-03-27T21:36:45.000Z | 0x55a57922ab6d0c21b4adfa2f7329c5647a26f134a7e480664d3bba5448095a6f |
| 0 | 0x43646a8e839b2f2766392c1bf8f60f6e587b6960 | false | 0xd63b2fa0696518b6239ab1f4f7c6556f06c31219 | 0xe9e7cea3dedca5984780bafc599bd69add087d56 | 0x55d398326f99059ff775485246999027b3197955 | 147 | 1 | 26154480 | 2023-03-03T21:12:43.000Z | 0xa11647b11e652f13cb0a5d7db8e5f53c78ff1e30a6894f61a08691a2b91cff40 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBFactory_LBPairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactoryV2\_FeeRecipientSet\_event
Fee recipient address change events from Trader Joe V2 Liquidity Book (LB) factory contract on BSC. Tracks protocol fee collection address updates for analyzing revenue distribution and governance changes.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_oldRecipient` | `STRING` | Address of the previous fee recipient before the protocol fee recipient was updated. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_newRecipient` | `STRING` | Address of the updated fee recipient for the protocol. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_newRecipient | in\_oldRecipient | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 147 | 27099340 | 2023-04-06T01:30:17.000Z | 0xc8fc59fceb8259534d8b10879273879eddf7eec0 | 0x0000000000000000000000000000000000000000 | 0x4c8a1f2f3d1a92281a3067aaea799536118e02a072380ccd3df642e8adecba6d |
| 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 274 | 28096024 | 2023-05-10T19:04:28.000Z | 0x60233142befce7d4ed73e7793ead2d6190fccaab | 0xc8fc59fceb8259534d8b10879273879eddf7eec0 | 0x51acc9650f973d963dfee7989bfa315d0bcef2f8f5609e1abb5f7d0f012b72c6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBFactoryV2_FeeRecipientSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBFactoryV2\_FlashLoanFeeSet\_event
Flash loan fee configuration changes from Trader Joe V2 liquidity book factory contract on BNB Smart Chain. Records updates to flash loan fee parameters with old and new values for tracking protocol fee adjustments.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_oldFlashLoanFee` | `STRING` | Previous flash loan fee value denominated in basis points. Numeric string representing the fee charged on flash loans before the change. |
| `in_newFlashLoanFee` | `STRING` | Updated flash loan fee value denominated in basis points. Numeric string representing the fee charged on flash loans after the change. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newFlashLoanFee | in\_oldFlashLoanFee |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- | ------------------- |
| 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 148 | 27099340 | 2023-04-06T01:30:17.000Z | 0x4c8a1f2f3d1a92281a3067aaea799536118e02a072380ccd3df642e8adecba6d | 5000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 116 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0x8c59d9fe5a6886f033fdfb8f8cf5855ca3bfe8b8 | 0x5037ff2f4598d130788fbd937d82d08b5c05a0cd | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 207 | 100 | 32858069 | 2023-10-23T15:28:31.000Z | 0x16ff8330bfc2832fa768076bc35c0caea90d0f25164d6d703a7b47059aba546d |
| 72 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0x45b612bf038494ec2ece3ca36897efd718bd52ba | 0xb0d502e938ed5f4df2e681fe6e419ff29631d62b | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 821 | 25 | 29207587 | 2023-06-18T11:14:52.000Z | 0xbb2d84fcf4e7f891672bfd9c4cde13c094c83bdf613033f508e565038bce8e25 |
| 73 | 0x8e42f2f4101563bf679975178e880fd87d3efd4e | false | 0xfac2d2fae6a30b43eece86e9b266a04fcc1c28e6 | 0xb0d502e938ed5f4df2e681fe6e419ff29631d62b | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 509 | 50 | 29207608 | 2023-06-18T11:15:55.000Z | 0x0b9eb99e0e00f20defaf3c035930e688a4dd534748753e98885d773aed76a989 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBFactoryV2_LBPairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_CompositionFee\_event
Composition fee collection events from Trader Joe V2 liquidity book pairs on BNB Smart Chain, showing fees accrued in token X and Y for specific bin IDs. Used to analyze fee generation patterns and liquidity provider earnings across different price bins 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_feesX` | `STRING` | Fee amount collected in token X of the liquidity pool pair. Denominated in the smallest unit of token X, typically representing protocol or liquidity provider fees for this specific price bin. |
| `in_feesY` | `STRING` | Fee amount collected in token Y of the liquidity pair for this composition event. Denominated in the smallest unit of token Y, where zero indicates no fees were collected in that token. |
| in\_id | address | removed | in\_feesX | in\_feesY | in\_sender | log\_index | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | -------------- | --------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8392380 | 0xbf529076bf8d976c321e21f0cd3c52fbff51008e | false | 20610842039826 | 0 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 84 | 26413813 | 0xd675d8c0fc1e1c25bf7de99cf44a913e9938eed1 | 2023-03-12T23:26:22.000Z | 0x18a234f4196ad72389b8af10002648248a10bc532557e6fc3259f08a4e72d9b3 |
| 8392357 | 0xbf529076bf8d976c321e21f0cd3c52fbff51008e | false | 22897365879400 | 0 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 316 | 26399298 | 0xacfed12efe4b53bbad28314e600ab9c54ed8b9ff | 2023-03-12T11:13:56.000Z | 0x45d905ed12b2f02aa026984d13f95274afc7f7bd54b08d0cd6c88aa5e8755fbe |
| 8392474 | 0xbf529076bf8d976c321e21f0cd3c52fbff51008e | false | 8022853781499 | 0 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 500 | 27254934 | 0x9c23abb3dfdc67637930e0ec3d2705c5ea461316 | 2023-04-11T12:33:30.000Z | 0xb5fcd86d3887b7b7ab29891b062f685e48852b0304a25a73f86f794adb140b56 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPair_CompositionFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_DepositedToBin\_event
Liquidity provision events from Trader Joe V2 Liquidity Book (LB) pairs on BNB Smart Chain, recording deposits of token X and Y amounts into specific price bins. Used for analyzing liquidity distribution, provider behavior, and bin-level capital allocation across concentrated liquidity positions.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ----------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8387943 | 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 351 | 0 | 20000000000000000 | 27373218 | 0x628f9801b3edf1a1c4b7231185ac40b70d34ba29 | 2023-04-15T15:33:16.000Z | 0x33859e340502d7e666e6272d11c5beeab36ef9dedc6d43d8468814d59b267c22 |
| 8387940 | 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 345 | 0 | 20000000000000000 | 27373218 | 0x628f9801b3edf1a1c4b7231185ac40b70d34ba29 | 2023-04-15T15:33:16.000Z | 0x33859e340502d7e666e6272d11c5beeab36ef9dedc6d43d8468814d59b267c22 |
| 8387942 | 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 349 | 0 | 20000000000000000 | 27373218 | 0x628f9801b3edf1a1c4b7231185ac40b70d34ba29 | 2023-04-15T15:33:16.000Z | 0x33859e340502d7e666e6272d11c5beeab36ef9dedc6d43d8468814d59b267c22 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.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 pairs on BNB Smart Chain, recording amountX and amountY tokens claimed by liquidity providers from their 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_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | false | 0x91ee65424a0a1cf1ca09ba1a04f060b37021f225 | 119 | 26393680512295611895 | 30390780331313651 | 28094803 | 0x91ee65424a0a1cf1ca09ba1a04f060b37021f225 | 2023-05-10T18:03:21.000Z | 0xc77f99c4ceb241d3eed298cb8f4ff18bda61b2f908ad792b7f0c7de0ce60b32c |
| 0x4e657182d565dc7c2b107eb5edd1e01d32f21c79 | false | 0x91ee65424a0a1cf1ca09ba1a04f060b37021f225 | 53 | 3274916644120930 | 291200400072757709 | 28084184 | 0x91ee65424a0a1cf1ca09ba1a04f060b37021f225 | 2023-05-10T09:11:51.000Z | 0xb482e92f3af64d9841e4f83feea9a711ab3fa08adcf1a923fa25c394953c935d |
| 0xbf529076bf8d976c321e21f0cd3c52fbff51008e | false | 0x6b072c23ef64c9da7b69cc6171248a6d010b9268 | 141 | 2723603088927735 | 1102403293031616417 | 26507908 | 0x6b072c23ef64c9da7b69cc6171248a6d010b9268 | 2023-03-16T06:46:17.000Z | 0x7a2d7f4afb2d83d1260903ad4188c1c98b370eda135b958bbd3f59d3c0b5abeb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPair_FeesCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_Swap\_event
Swap execution events from Trader Joe V2 liquidity book pairs on BNB Smart Chain, capturing token exchanges with amounts, fees, active bin IDs, and volatility metrics. Used for analyzing DEX trading activity, price discovery patterns, and liquidity utilization across concentrated liquidity 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_swapForY` | `BOOL` | Direction indicator for the swap within the Trader Joe V2 liquidity book bin. True when swapping token X for token Y; false when swapping 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 for the liquidity bin at the time of the swap, used by Trader Joe v2's dynamic fee mechanism. Typically ranges from 0 to higher values during volatile market conditions. |
| `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 |
| ------- | ------------------------------------------ | ----------------- | ------- | ------------------------------------------ | ---------- | -------------------- | ------------ | ------------- | -------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8388606 | 0xd63b2fa0696518b6239ab1f4f7c6556f06c31219 | 10810432506418322 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 82 | 54041352099585189540 | false | 29934489 | 54052160910418627573 | 0xd955a5b4802a8dc351136b5e68d6aed6e4db9a6a | 2023-07-13T18:51:24.000Z | 0x17bc0415e90477ff1a1833c208f07f9155127c469cc4f00a87a784d1a334411e | 0 |
| 8388607 | 0xd63b2fa0696518b6239ab1f4f7c6556f06c31219 | 15060307625731110 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 83 | 74540918037577779348 | false | 29934489 | 74548372129381537125 | 0xd955a5b4802a8dc351136b5e68d6aed6e4db9a6a | 2023-07-13T18:51:24.000Z | 0x17bc0415e90477ff1a1833c208f07f9155127c469cc4f00a87a784d1a334411e | 10000 |
| 8388606 | 0xd63b2fa0696518b6239ab1f4f7c6556f06c31219 | 200000000000000 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 341 | 999800000000000000 | false | 29934061 | 999999969998000000 | 0xb784c80bfc8f8131bf8d10d4af76dffbed0adf87 | 2023-07-13T18:29:48.000Z | 0x2b7cf52d777bdab3905862f535a10d5166c570662a4577cf19f06c1c07a3e318 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPair_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_TransferBatch\_event
Batch liquidity position transfers from Trader Joe V2 liquidity book (LB) pools on BNB Chain, containing multiple bin IDs and token amounts per transfer. Used for tracking multi-bin LP position movements and concentrated liquidity 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 |
| ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x4e657182d565dc7c2b107eb5edd1e01d32f21c79 | \["8393082","8393083","8393084","8393085","8393086","8393087","8393088","8393089","8393090","8393091","8393092","8393093","8393094","8393095","8393096","8393097","8393098","8393099","8393100","8393101","8393102","8393103","8393104","8393105","8393106","8393107","8393108","8393109","8393110","8393111","8393112","8393113","8393114","8393115","8393116","8393117","8393118","8393119","8393120","8393121","8393122","8393123","8393124","8393125","8393126","8393127","8393128","8393129","8393130","8393131","8393132"] | 0x4e657182d565dc7c2b107eb5edd1e01d32f21c79 | 0xbdbae54705e816b3664969fe255680dc5745e4c0 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 33 | \["33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","33347921592725465","35878376433352608","38455873536102906","38494329409639009","38532823739048648","38571356562787697","38609927919350485","38648537847269835","38687186385117105","38725873571502222","38764599445073724","38803364044518798","38842167408563317","38881009575971880","38919890585547852","38958810476133400","38997769286609533","39036767055896143","39075803822952039","39114879626774991","39153994506401766","39193148500908168","39232341649409076","39271573991058485","39310845565049543","39350156410614593","39389506567025207"] | 27538312 | 2023-04-21T09:35:54.000Z | 0x8fbc241c3c13c7a75c4c572e337539f2737383765ad37e713f2ad9251ec6ec38 |
| 0x4e657182d565dc7c2b107eb5edd1e01d32f21c79 | \["8393084","8393085","8393086","8393087","8393088","8393089","8393090","8393091","8393092","8393093","8393094","8393095","8393096","8393097","8393098","8393099","8393100","8393101","8393102","8393103","8393104","8393105","8393106","8393107","8393108","8393109","8393110","8393111","8393112","8393113","8393114","8393115","8393116","8393117","8393118","8393119","8393120","8393121","8393122","8393123","8393124","8393125","8393126","8393127","8393128","8393129","8393130","8393131","8393132","8393133","8393134"] | 0x4e657182d565dc7c2b107eb5edd1e01d32f21c79 | 0x030df225e4beba45a696a442001d9a5f424d74f6 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 274 | \["31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","31360000000000000","35849460776783814","40390328359377055","40430718687736432","40471149406424169","40511620555830593","40552132176386424","40592684308562810","40633276992871373","40673910269864244","40714584180134108","40755298764314243","40796054063078557","40836850117141635","40877686967258777","40918564654226036","40959483218880262","41000442702099142","41041443144801241","41082484587946042","41123567072533989","41164690639606522","41205855330246129","41247061185576375","41288308246761952","41329596555008713","41370926151563722"] | 27537012 | 2023-04-21T08:30:45.000Z | 0xce2b1416238308107df43c03cb79508081609724319932472c126fb340b4683d |
| 0xbf529076bf8d976c321e21f0cd3c52fbff51008e | \["8392468","8392469","8392470","8392471","8392472","8392473","8392474","8392475","8392476","8392477"] | 0xbf529076bf8d976c321e21f0cd3c52fbff51008e | 0x5d44c3f24e711c9135a1a9d3f33047c19ffc1d35 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 303 | \["18181818181818236","18181818181818236","18181818181818236","18181818181818236","9114213697393350","50468735287331","50544438390262","50620255047848","50696185430420","50772229708565"] | 27537849 | 2023-04-21T09:12:38.000Z | 0x6871d040d4acc181a0c9f8a0280177f1e3f7c3401ffe925ae587ef14d07e8fc2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPair_TransferBatch_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_TransferSingle\_event
ERC-1155 single token transfer events from Trader Joe V2 liquidity book pairs on BNB Chain, tracking mints and burns of liquidity position NFTs. Used for analyzing liquidity provider position changes and bin-level 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_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 |
| ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 8393103 | 0x263e0dc443185338be3bd886aaa0a7d5488432cf | 0x4e657182d565dc7c2b107eb5edd1e01d32f21c79 | 0x0000000000000000000000000000000000000000 | false | 794087461227028189 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 329 | 27500297 | 2023-04-20T01:49:23.000Z | 0xc17cc6be91c4a63297ddf7b6ea0f58088a8892ad6b1f4084522fec125c9c230d |
| 8393105 | 0x263e0dc443185338be3bd886aaa0a7d5488432cf | 0x4e657182d565dc7c2b107eb5edd1e01d32f21c79 | 0x0000000000000000000000000000000000000000 | false | 265225476745647824 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 333 | 27500297 | 2023-04-20T01:49:23.000Z | 0xc17cc6be91c4a63297ddf7b6ea0f58088a8892ad6b1f4084522fec125c9c230d |
| 8393100 | 0x263e0dc443185338be3bd886aaa0a7d5488432cf | 0x4e657182d565dc7c2b107eb5edd1e01d32f21c79 | 0x0000000000000000000000000000000000000000 | false | 45000000000000000 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 322 | 27500297 | 2023-04-20T01:49:23.000Z | 0xc17cc6be91c4a63297ddf7b6ea0f58088a8892ad6b1f4084522fec125c9c230d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPair_TransferSingle_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LBPair\_WithdrawnFromBin\_event
Liquidity withdrawal events from Trader Joe V2 Liquidity Book (LB) price bins on BNB Smart Chain, capturing tokenX and tokenY amounts removed by liquidity providers. Used for analyzing liquidity provider behavior and pool depth changes across 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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 8387924 | 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 155 | 8029105138194828989 | 0 | 27238027 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 2023-04-10T22:20:29.000Z | 0x9251df774a458f718743532ecf88f24ad455672d64f34fe7a5730b33027fd0e2 |
| 8387942 | 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 191 | 15757575757575758499 | 0 | 27238027 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 2023-04-10T22:20:29.000Z | 0x9251df774a458f718743532ecf88f24ad455672d64f34fe7a5730b33027fd0e2 |
| 8387941 | 0xa1696703ca88f0693d30ff6ee0d7b51900dd6916 | false | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 189 | 15757575757575758064 | 0 | 27238027 | 0xb66a2704a0dabc1660941628be987b4418f7a9e8 | 2023-04-10T22:20:29.000Z | 0x9251df774a458f718743532ecf88f24ad455672d64f34fe7a5730b33027fd0e2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPair_WithdrawnFromBin_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 |
| ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x05c53cc0223033b073b11ce741f46bed67ab0dfe | \["8393423","8393424","8393425","8393426","8393427","8393428","8393429","8393430","8393431"] | 0xfd83d084777143b726dd32d9424c789ad7df1632 | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 177 | \["0x00000000000000002dc0e6fa0e278e3500000000000000000000000000000000","0x00000000000000002dc0e6fa0e278e3500000000000000000000000000000000","0x00000000000000002dc0e6fa0e278e3500000000000000000000000000000000","0x00000000000000002dc0e6fa0e278e3500000000000000000000000000000000","0x000000000000000016e04327cf31fae00000000000000000002f71a414cb1253","0x000000000000000000000000000000000000000000000000005ee348299624a7","0x000000000000000000000000000000000000000000000000005ee348299624a7","0x000000000000000000000000000000000000000000000000005ee348299624a7","0x000000000000000000000000000000000000000000000000005ee348299624a7"] | 29595040 | 2023-07-01T23:06:11.000Z | 0xe4e690588f86c5af796ecab7d397900a65d834bcc4f38b72eb4f1af7af04d7ab |
| 0x0b75b9e8ca93aa5d05c832dd4809d72d8ed4125d | \["8385369","8385370","8385371","8385372","8385373","8385374","8385375","8385376","8385377","8385378","8385379","8385380","8385381","8385382","8385383","8385384","8385385","8385386","8385387","8385388","8385389","8385390","8385391","8385392","8385393","8385394","8385395","8385396","8385397","8385398","8385399","8385400","8385401","8385402","8385403","8385404","8385405","8385406","8385407","8385408","8385409","8385410","8385411","8385412","8385413","8385414","8385415","8385416","8385417","8385418","8385419","8385420","8385421","8385422","8385423","8385424","8385425","8385426","8385427","8385428","8385429"] | 0x722edd360b53029e287dd4d1ebcfd6cb3710912f | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 287 | \["0x00000000000000000641c23d7f0ed92400000000000000000000000000000000","0x000000000000000007222800f17c61fc00000000000000000000000000000000","0x00000000000000000818c20375460a1800000000000000000000000000000000","0x000000000000000009263a25acc5185000000000000000000000000000000000","0x00000000000000000a4afdde6a6166d800000000000000000000000000000000","0x00000000000000000b8734531e639a9c00000000000000000000000000000000","0x00000000000000000cdab4d4dfd6269400000000000000000000000000000000","0x00000000000000000e44fe132e58238800000000000000000000000000000000","0x00000000000000000fc52e597e037ed000000000000000000000000000000000","0x00000000000000001159fd2ddc2559f000000000000000000000000000000000","0x00000000000000001301b6a524f1bbcc00000000000000000000000000000000","0x000000000000000014ba38bc12e222ac00000000000000000000000000000000","0x00000000000000001680f2fbc3ac4a3800000000000000000000000000000000","0x00000000000000001852e8a425e95e7c00000000000000000000000000000000","0x00000000000000001a2cb587483abe2c00000000000000000000000000000000","0x00000000000000001c0a95ae0cd7f4f800000000000000000000000000000000","0x00000000000000001de86fc9d3c3846800000000000000000000000000000000","0x00000000000000001fc1e25feb5f8f2000000000000000000000000000000000","0x000000000000000021925383ceaded7400000000000000000000000000000000","0x0000000000000000235502dd5191246400000000000000000000000000000000","0x000000000000000025051da0cf18d75800000000000000000000000000000000","0x0000000000000000269dd40a3c09857400000000000000000000000000000000","0x0000000000000000281a6fd9a25be06800000000000000000000000000000000","0x000000000000000029766b40e8bb31fc00000000000000000000000000000000","0x00000000000000002aad87a8ab444a1800000000000000000000000000000000","0x00000000000000002bbbe3acee77096400000000000000000000000000000000","0x00000000000000002c9e0fb30398d0d800000000000000000000000000000000","0x00000000000000002d5120803c18bb9400000000000000000000000000000000","0x00000000000000002dd2bf44f52d4cc800000000000000000000000000000000","0x00000000000000002e2136a0c1f62e2000000000000000000000000000000000","0x0000000000000000171dbe1d3b155040000000000000002d25c58c65409316ce","0x00000000000000000000000000000000000000000000005a18deb1fad4d21680","0x0000000000000000000000000000000000000000000000597f9d92aedc79f6a0","0x00000000000000000000000000000000000000000000005882737a75604e5d10","0x00000000000000000000000000000000000000000000005724b6a9a30677e5e0","0x0000000000000000000000000000000000000000000000556af8adc1c07e5750","0x0000000000000000000000000000000000000000000000535aecf56e8160b6e0","0x000000000000000000000000000000000000000000000050fb497ac68d9da030","0x00000000000000000000000000000000000000000000004e53a275111b724b20","0x00000000000000000000000000000000000000000000004b6c4223fd4298a690","0x0000000000000000000000000000000000000000000000484dfdde147c8497e0","0x000000000000000000000000000000000000000000000045020998434f7b1350","0x00000000000000000000000000000000000000000000004191cb1d6fabb3c690","0x00000000000000000000000000000000000000000000003e06ae2357b6a38a80","0x00000000000000000000000000000000000000000000003a69fa563199de9b20","0x000000000000000000000000000000000000000000000036c4ac57f115ca7460","0x0000000000000000000000000000000000000000000000331f528c3912bb6df0","0x00000000000000000000000000000000000000000000002f81ee609a0bcc8a30","0x00000000000000000000000000000000000000000000002bf3da93ba2c80f560","0x0000000000000000000000000000000000000000000000287bb6cf54e1abb7f0","0x0000000000000000000000000000000000000000000000251f58ba8c2822ca70","0x000000000000000000000000000000000000000000000021e3c27d91f8f3a8c0","0x00000000000000000000000000000000000000000000001ecd1e86ca1ed3ae40","0x00000000000000000000000000000000000000000000001bdec03d76842565a0","0x0000000000000000000000000000000000000000000000191b292fc52e435910","0x000000000000000000000000000000000000000000000016841232575a89f8b0","0x0000000000000000000000000000000000000000000000141a77d667c63cdde0","0x000000000000000000000000000000000000000000000011dea9919570f37c40","0x00000000000000000000000000000000000000000000000fd05aeec10ccbb6e0","0x00000000000000000000000000000000000000000000000deeb621d7a6ef6030","0x00000000000000000000000000000000000000000000000c386f601c29001a50"] | 29568390 | 2023-07-01T00:49:10.000Z | 0x09201cd5a6af4f9bdf77d15cd1f64051ff14dceda1f9b8eaeb7a479a4c30238c |
| 0x12a0dd19d3f878697c7a1f804aaa1da84229566c | \["8385395","8385396","8385397","8385398","8385399","8385400","8385401"] | 0x722edd360b53029e287dd4d1ebcfd6cb3710912f | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 556 | \["0x0000000000000000041498d5e5682a3100000000000000000000000000000000","0x0000000000000000051405a10477781300000000000000000000000000000000","0x000000000000000005efe133279a018300000000000000000000000000000000","0x0000000000000000068542e2ec69ec0100000000000000000000000000000000","0x0000000000000000035d1fe995d07032000000000000000c6b0088432e9bb52c","0x000000000000000000000000000000000000000000000015ec31094d7b329424","0x00000000000000000000000000000000000000000000000f1132f702f5d1a296"] | 29568124 | 2023-07-01T00:35:52.000Z | 0x2f6d4a753bc61833b76e853588124231c4590371cdc5f0d3a31bd773f971eb20 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPairV2_DepositedToBins_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 |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 8388607 | 0x58e2c10f7ea156477b45b0a33958b6473445a0c2 | 0x023ff63aa03060cfe97018e2854318bea9873fd5 | false | 0x2d1eee087fd8f6d82f4b3bfd8c82e7393545a30f | 229 | 39619412 | 0x0000000000000000821d29782d55c1e500000000000000000000000000000000 | 0x00000000000000000001aa5bbc20fa2800000000000000000000000000000000 | 0x000000000000000000000000000000000000000000000000821ee91a6249c9c2 | 2024-06-15T00:25:49.000Z | 0x0000000000000000000015516301a61b00000000000000000000000000000000 | 0x25f3f9acc4b661fd4b5d49cf48cf7b59a4ae5e832254f6fd533a305343ce33c2 | 0 |
| 8399692 | 0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d | 0x717d06b4d8bc6b71d5a2c45d8cc417930aec073d | false | 0x2d1eee087fd8f6d82f4b3bfd8c82e7393545a30f | 94 | 39633236 | 0x00000000000000000004f7e1a8db733c00000000000000000000000000000000 | 0x00000000000000000000033aa23bfcff00000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000537 | 2024-06-15T11:58:55.000Z | 0x0000000000000000000000a553a598ff00000000000000000000000000000000 | 0x3b89f7d2568e0905d8c308844b48de67829ec635f8773000af238762e181c074 | 20000 |
| 8399690 | 0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d | 0x717d06b4d8bc6b71d5a2c45d8cc417930aec073d | false | 0x2d1eee087fd8f6d82f4b3bfd8c82e7393545a30f | 92 | 39633236 | 0x0000000000000000000611aeeda4120f00000000000000000000000000000000 | 0x0000000000000000000003e2dad0c54400000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000667 | 2024-06-15T11:58:55.000Z | 0x0000000000000000000000c6f890277400000000000000000000000000000000 | 0x3b89f7d2568e0905d8c308844b48de67829ec635f8773000af238762e181c074 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPairV2_Swap_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 |
| ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | \["8385280","8385281","8385282","8385283","8385284","8385285","8385286","8385287","8385288","8385289","8385290","8385291","8385292","8385293","8385294","8385295","8385296","8385297","8385298","8385299","8385300","8385301","8385302","8385303","8385304","8385305","8385306","8385307","8385308","8385309","8385310","8385311","8385312","8385313","8385314","8385315","8385316","8385317","8385318","8385319","8385320","8385321","8385322","8385323","8385324","8385325","8385326","8385327","8385328","8385329","8385330","8385331","8385332","8385333","8385334","8385335","8385336","8385337","8385338"] | 0x722edd360b53029e287dd4d1ebcfd6cb3710912f | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 87 | \["0x00000000000000000061d62c1b4005cd00000000000000000000000000000000","0x0000000000000000005fa04041d0707800000000000000000000000000000000","0x000000000000000000603195f6cddb3b00000000000000000000000000000000","0x000000000000000000609fbb4b02e34a00000000000000000000000000000000","0x0000000000000000005fd548b8123e5200000000000000000000000000000000","0x000000000000000000609246ba85107d00000000000000000000000000000000","0x0000000000000000006203da616dd4c000000000000000000000000000000000","0x00000000000000000060d09c68341f9e00000000000000000000000000000000","0x0000000000000000005fa790a1a18a9200000000000000000000000000000000","0x0000000000000000005fc2f697745c5000000000000000000000000000000000","0x0000000000000000005f931fdcb7644800000000000000000000000000000000","0x0000000000000000005fb3e5657fcdd100000000000000000000000000000000","0x00000000000000000060191578c6f99c00000000000000000000000000000000","0x00000000000000000061859557058d9100000000000000000000000000000000","0x000000000000000000618a2b8686121800000000000000000000000000000000","0x00000000000000000061aaf7af5a125c00000000000000000000000000000000","0x00000000000000000060b5bf0421838f00000000000000000000000000000000","0x0000000000000000005fa463e254ad0b00000000000000000000000000000000","0x0000000000000000005fd3a27c79423d00000000000000000000000000000000","0x0000000000000000006030c418515d6500000000000000000000000000000000","0x000000000000000000616b7de919fce200000000000000000000000000000000","0x00000000000000000062101facccb62f00000000000000000000000000000000","0x0000000000000000005fd658b9340c6800000000000000000000000000000000","0x0000000000000000006125374021993e00000000000000000000000000000000","0x0000000000000000006301f78a2ee30200000000000000000000000000000000","0x00000000000000000064b83e2caa322200000000000000000000000000000000","0x000000000000000000642fd9687802cd00000000000000000000000000000000","0x00000000000000000061e3cee64b3c2600000000000000000000000000000000","0x00000000000000000062141e5d31d16c00000000000000000000000000000000","0x000000000000000000616c863cebbfbf00000000000000000000000000000000","0x000000000000000000624421665e618b00000000000000000000000000000000","0x00000000000000000060cb3b5999ec9500000000000000000000000000000000","0x0000000000000000006189e1fd80189e00000000000000000000000000000000","0x0000000000000000006321e00e21238200000000000000000000000000000000","0x00000000000000000063df4ec6ee536300000000000000000000000000000000","0x00000000000000000065cb7c5aec8b1400000000000000000000000000000000","0x0000000000000000006960184c31838b00000000000000000000000000000000","0x00000000000000000069d776b86e873000000000000000000000000000000000","0x000000000000000000695c5e1e1f6a2900000000000000000000000000000000","0x0000000000000000006bd759fe3345d600000000000000000000000000000000","0x0000000000000000006b2814d08b0e1800000000000000000000000000000000","0x0000000000000000006ba74f477561db00000000000000000000000000000000","0x0000000000000000004368c951dea94d00000000000000006f7962de54c8c19a","0x00000000000000000000000000000000000000000000000129ab107ecf79491f","0x0000000000000000000000000000000000000000000000012dbc19746bcc41cd","0x00000000000000000000000000000000000000000000000134e862c72ee600bf","0x00000000000000000000000000000000000000000000000137cf904420552e0f","0x00000000000000000000000000000000000000000000000137556df78e6d2194","0x00000000000000000000000000000000000000000000000139b4ca99a07e60a6","0x000000000000000000000000000000000000000000000001466db0987e9de4a9","0x00000000000000000000000000000000000000000000000147d48d222c28c5be","0x00000000000000000000000000000000000000000000000148cf9ce9b5657745","0x0000000000000000000000000000000000000000000000014c02c7c4e876b79a","0x000000000000000000000000000000000000000000000001469e2f0a7019bb42","0x000000000000000000000000000000000000000000000001525a8a6371f3c76f","0x00000000000000000000000000000000000000000000000158947ee8a5e3eefe","0x00000000000000000000000000000000000000000000000156306baaddb1c5fa","0x00000000000000000000000000000000000000000000000157936462eea6fdb9","0x000000000000000000000000000000000000000000000001605c7b0a7ffdb142"] | 36624349 | 2024-03-02T18:45:07.000Z | 0xd049f0a05928f7738abbca7756999528414ee3ae051ed3c661c693051ac6be58 |
| 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | \["8386346","8386347","8386348","8386349","8386350","8386351","8386352","8386353","8386354","8386355","8386356","8386357","8386358","8386359","8386360","8386361","8386362","8386363","8386364","8386365","8386366","8386367","8386368","8386369","8386370","8386371","8386372","8386373","8386374","8386375","8386376","8386377","8386378","8386379","8386380","8386381","8386382","8386383","8386384","8386385","8386386","8386387","8386388","8386389","8386390","8386391","8386392","8386393","8386394","8386395","8386396","8386397","8386398","8386399","8386400","8386401","8386402","8386403","8386404","8386405","8386406","8386407","8386408","8386409","8386410","8386411"] | 0x36c95fcc451fd03a586d5c2555c2c8e76d4b119d | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 161 | \["0x000000000000000000ce0050e073e55900000000000000000000000000000000","0x000000000000000000cfe1ad54e0067b00000000000000000000000000000000","0x000000000000000000d235b6fac7d7a400000000000000000000000000000000","0x000000000000000000d5ffcc28f2a6a600000000000000000000000000000000","0x000000000000000000d7862a17db0a1800000000000000000000000000000000","0x000000000000000000da6108bd9a16d400000000000000000000000000000000","0x000000000000000000db638b78d1dc7d00000000000000000000000000000000","0x0000000000000000010d29479be1d92800000000000000000000000000000000","0x0000000000000000010bb044f4137a6600000000000000000000000000000000","0x00000000000000000030963433873c8900000000000000000000000000000000","0x00000000000000000030ac2f3512c77700000000000000000000000000000000","0x000000000000000000307f9fb8faab3200000000000000000000000000000000","0x0000000000000000002f88b5cbe13dbb00000000000000000000000000000000","0x0000000000000000002ed1f1046c0ceb00000000000000000000000000000000","0x0000000000000000000213605d63d7e7000000000000000030ee518da3bbec54","0x00000000000000000000000000000000000000000000000033cebb72422b2d2c","0x00000000000000000000000000000000000000000000000034dc7277813eeeeb","0x0000000000000000000000000000000000000000000000003522ccb72218e125","0x00000000000000000000000000000000000000000000000034ac73d7278a986f","0x00000000000000000000000000000000000000000000000035c291126b680f30","0x000000000000000000000000000000000000000000000000355411fd801e9a4d","0x000000000000000000000000000000000000000000000000351533c0f2a4bf53","0x00000000000000000000000000000000000000000000000034be799777f3ea23","0x000000000000000000000000000000000000000000000000345f59fef7e86bda","0x000000000000000000000000000000000000000000000000339e12511242c7ef","0x00000000000000000000000000000000000000000000000032761e3f2470f758","0x000000000000000000000000000000000000000000000000323f0ce8427b0df2","0x000000000000000000000000000000000000000000000000329949c13afc487d","0x0000000000000000000000000000000000000000000000003167df5be7c51b31","0x00000000000000000000000000000000000000000000000030d27609a17d377e","0x0000000000000000000000000000000000000000000000002ff4841a2c06f559","0x0000000000000000000000000000000000000000000000003096f7524109945c","0x0000000000000000000000000000000000000000000000003024488b449bd704","0x00000000000000000000000000000000000000000000000030343e9536b07692","0x00000000000000000000000000000000000000000000000030e4470570890f3f","0x00000000000000000000000000000000000000000000000030af3b4521f00169","0x00000000000000000000000000000000000000000000000031160479e5c481c3","0x00000000000000000000000000000000000000000000000031b9463ad76ecbc5","0x00000000000000000000000000000000000000000000000031fe0689312d6cf7","0x00000000000000000000000000000000000000000000000032439850b2e961ab","0x000000000000000000000000000000000000000000000000320f5ef5468e5a1d","0x000000000000000000000000000000000000000000000000324166ff937f2d5f","0x00000000000000000000000000000000000000000000000031ce621b0d18602c","0x00000000000000000000000000000000000000000000000031afcbf6f2a83e86","0x00000000000000000000000000000000000000000000000031558ce42c167e7b","0x0000000000000000000000000000000000000000000000003037c10947e5cac4","0x0000000000000000000000000000000000000000000000002f3e6ebf1ffbe702","0x0000000000000000000000000000000000000000000000002f583017c3cfb27d","0x0000000000000000000000000000000000000000000000002f3830a1fb340a52","0x0000000000000000000000000000000000000000000000002efafa1322aff974","0x0000000000000000000000000000000000000000000000002ec0fedd89df0518","0x0000000000000000000000000000000000000000000000002f0da9bf26ebbc05","0x0000000000000000000000000000000000000000000000002e804adde90d5886","0x0000000000000000000000000000000000000000000000002e367599c5332d32","0x0000000000000000000000000000000000000000000000002e64342d72d75ad1","0x0000000000000000000000000000000000000000000000002e041508d1628c71","0x0000000000000000000000000000000000000000000000002dfee0728d3b1f93","0x0000000000000000000000000000000000000000000000002dd9374a06ee3aed","0x0000000000000000000000000000000000000000000000002dac2fbbb6ef5142","0x0000000000000000000000000000000000000000000000002d2f508bba12d35f","0x0000000000000000000000000000000000000000000000002d4342e3681c165f","0x0000000000000000000000000000000000000000000000002d712f03becff688","0x0000000000000000000000000000000000000000000000002da4221b6fa36ff8","0x0000000000000000000000000000000000000000000000002da133c02df8d9f7","0x0000000000000000000000000000000000000000000000002d8938c1bf16b84f","0x0000000000000000000000000000000000000000000000002d6e59a74f49d8d9"] | 36624408 | 2024-03-02T18:48:04.000Z | 0x8a0deb832f0248d6bf06fd62e95340bdd632283b8a8dae340741e8f7299a8ad2 |
| 0x1ec811302800fc9defc6de81ea9138f9fd12c7e7 | \["8388605","8388606","8388607","8388608","8388609","8388610","8388611","8388612","8388613","8388614","8388615"] | 0xaec97c3465d83b1952c3a251036df88a635c060c | false | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 19 | \["0x000000000000000064edeaec07345d0f00000000000000000000000000000000","0x000000000000000064edeaec07345d0f00000000000000000000000000000000","0x000000000000000064c2ae5723f783340000000000000000002cadb69bb6484d","0x000000000000000000000000000000000000000000000000650d8cbef5c49af6","0x0000000000000000000000000000000000000000000000006511a650fb31a91b","0x00000000000000000000000000000000000000000000000064f9fbeb83c00997","0x00000000000000000000000000000000000000000000000064e6af00739d10d7","0x00000000000000000000000000000000000000000000000064e62ae68ce5212b","0x00000000000000000000000000000000000000000000000064e62ae68ce5212c","0x00000000000000000000000000000000000000000000000064e62ae68ce5212c","0x00000000000000000000000000000000000000000000000064e62ae68ce5212c"] | 29760026 | 2023-07-07T17:03:27.000Z | 0xa5bc9700a4db8e051d7b58da7cfff91a4a19b892bed777788bd8840b3743d3ef |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.traderjoe_v2_bsc.LBPairV2_WithdrawnFromBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***