> ## 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_ethereum > Tables in tt-contracts.traderjoe_v2_ethereum ## Tables ### Factory\_FeeRecipientSet\_event Fee recipient configuration changes from Trader Joe V2 DEX factory contract on Ethereum. Records transitions of protocol fee collection addresses for analyzing fee routing and protocol governance decisions. | 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 | | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 109 | 17821282 | 2023-08-01T16:15:23.000Z | 0x1f36930a75c44f323d4d66aee449af0c72d19f2e | 0x0000000000000000000000000000000000000000 | 0xf040aa8c43237d471689f2382055ca966baad75ae2f8aa6c95b2648b2849e420 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_FeeRecipientSet_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### Factory\_FlashLoanFeeSet\_event Factory contract events tracking flash loan fee parameter changes on Trader Joe V2 (Ethereum). Records old and new fee values for monitoring protocol fee adjustments 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 | | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- | ------------------- | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 110 | 17821282 | 2023-08-01T16:15:23.000Z | 0xf040aa8c43237d471689f2382055ca966baad75ae2f8aa6c95b2648b2849e420 | 5000000000000 | 0 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_FlashLoanFeeSet_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### Factory\_LBPairCreated\_event Liquidity Book (LB) pair creation events from Trader Joe v2 factory contract on Ethereum, recording new liquidity pool deployments with token pairs, bin step (fee tier), and pool addresses. Used for tracking pool launches and analyzing available trading pairs across different fee tiers in Trader Joe's v2 concentrated liquidity model. | Column | Type | Description | | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_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 | | ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ | | 0 | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 166 | 1 | 17822480 | 2023-08-01T20:16:23.000Z | 0x95a32374eee375f39354dfb58509ba7d16b56dc4aca565642fdec393c924cf1a | | 1 | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | 0x6b175474e89094c44da98b954eedeac495271d0f | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 168 | 1 | 17822480 | 2023-08-01T20:16:23.000Z | 0x95a32374eee375f39354dfb58509ba7d16b56dc4aca565642fdec393c924cf1a | | 2 | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 0xa3b2b212529b953fc482fe5e3faf81e30b075b2d | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 121 | 100 | 18493587 | 2023-11-03T19:21:59.000Z | 0x406d9fb39b405c5fd68d68adc26128e391c7ce336bb66f5a2122cdc1c0e03e52 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_LBPairCreated_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### Factory\_LBPairImplementationSet\_event Factory contract events tracking updates to the Liquidity Book (LB) pair implementation contract addresses on Trader Joe V2 Ethereum deployment. Used for monitoring protocol upgrades and implementation contract changes over time. | Column | Type | Description | | ---------------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_oldLBPairImplementation` | `STRING` | Contract address of the previous LBPair (Liquidity Book Pair) implementation before the upgrade event. Zero address (0x000...000) indicates this was the initial implementation set with no prior version. | | `in_LBPairImplementation` | `STRING` | Contract address of the new liquidity book (LB) pair implementation being set in the Trader Joe v2 factory. Non-zero hex-encoded address indicating the upgraded implementation contract that will be used for new LB pair deployments. | | address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_LBPairImplementation | in\_oldLBPairImplementation | | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 111 | 17821282 | 2023-08-01T16:15:23.000Z | 0x72402c1fbd91b9ebd23029293c4accb2f9d9f3976222bb0c72ed222a9bd096d0 | 0x7f89d5e94d6bd0351426e113fde9ef9ea678c186 | 0x0000000000000000000000000000000000000000 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_LBPairImplementationSet_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### Factory\_OwnershipTransferred\_event Ownership transfer events from the Trader Joe V2 liquidity book factory contract on Ethereum, recording transitions of administrative control from previous to new owner addresses. Used for tracking protocol governance changes and administrative authority updates. | 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_previousOwner` | `STRING` | Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string. | | `in_newOwner` | `STRING` | Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string. | | address | removed | log\_index | in\_newOwner | block\_number | block\_timestamp | in\_previousOwner | transaction\_hash | | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 194 | 0xf8965d150f0a376011fd1e12db3266fca1b15cd6 | 17821854 | 2023-08-01T18:10:47.000Z | 0x1f36930a75c44f323d4d66aee449af0c72d19f2e | 0x9f184e8c9e72816f3345c03283c211307810aad7b8a5e34be04802620ffaf61f | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 108 | 0x1f36930a75c44f323d4d66aee449af0c72d19f2e | 17821282 | 2023-08-01T16:15:23.000Z | 0x0000000000000000000000000000000000000000 | 0xf040aa8c43237d471689f2382055ca966baad75ae2f8aa6c95b2648b2849e420 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_OwnershipTransferred_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### Factory\_PendingOwnerSet\_event Ownership transfer events from Trader Joe V2 liquidity pool factory contract on Ethereum, recording when a new pending owner address is proposed for protocol governance. Used for tracking ownership changes and governance transitions in the DEX protocol. | Column | Type | Description | | ------------------ | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_pendingOwner` | `STRING` | Address of the account being proposed as the new contract owner in a pending ownership transfer. Hex-encoded, 0x-prefixed 40-character Ethereum address that must be accepted to complete the ownership change. | | address | removed | log\_index | block\_number | block\_timestamp | in\_pendingOwner | transaction\_hash | | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 130 | 17821282 | 2023-08-01T16:15:23.000Z | 0xf8965d150f0a376011fd1e12db3266fca1b15cd6 | 0xd5614ea9f784fff9f8f5bf352b44914a8efb208f6d043e2f761c2e91fc056fe4 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_PendingOwnerSet_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### Factory\_PresetOpenStateChanged\_event Factory preset configuration changes for Trader Joe v2 liquidity pools on Ethereum, tracking when specific bin step fee tiers are enabled or disabled for pool creation. Used for monitoring protocol governance decisions and available pool types over time. | Column | Type | Description | | ------------------ | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_binStep` | `STRING` | Price bin step size for the Trader Joe V2 liquidity pool. Numeric string representing the step granularity in basis points. | | `in_isOpen` | `BOOL` | Indicates whether the specified bin step preset was opened or closed for new liquidity book pair creation. When true, pairs with this bin step configuration can be deployed; when false, deployment is disabled. | | address | removed | in\_isOpen | log\_index | in\_binStep | block\_number | block\_timestamp | transaction\_hash | | ------------------------------------------ | ------- | ---------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | true | 87 | 100 | 18448026 | 2023-10-28T10:13:11.000Z | 0xc9cc1c0ef8069f3593aa69979a9bfdd8941ebe0cb1dff972c5d11e9e26eb1b15 | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | true | 89 | 25 | 18448026 | 2023-10-28T10:13:11.000Z | 0xc9cc1c0ef8069f3593aa69979a9bfdd8941ebe0cb1dff972c5d11e9e26eb1b15 | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | true | 88 | 50 | 18448026 | 2023-10-28T10:13:11.000Z | 0xc9cc1c0ef8069f3593aa69979a9bfdd8941ebe0cb1dff972c5d11e9e26eb1b15 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_PresetOpenStateChanged_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### Factory\_PresetSet\_event Trader Joe V2 liquidity pool preset configuration events on Ethereum containing fee parameters (bin step, base factor, protocol share) and volatility controls (decay period, filter period, max volatility accumulator) for different pool types. Used for analyzing AMM (Automated Market Maker) configuration changes and fee structure evolution across liquidity bins. | Column | Type | Description | | ----------------------------- | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_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_maxVolatilityAccumulator` | `STRING` | Maximum threshold for accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. | | address | removed | log\_index | in\_binStep | block\_number | in\_baseFactor | in\_decayPeriod | block\_timestamp | in\_filterPeriod | in\_protocolShare | transaction\_hash | in\_reductionFactor | in\_variableFeeControl | in\_maxVolatilityAccumulator | | ------------------------------------------ | ------- | ---------- | ----------- | ------------- | -------------- | --------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------- | ---------------------- | ---------------------------- | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 116 | 5 | 17821282 | 8000 | 600 | 2023-08-01T16:15:23.000Z | 30 | 2500 | 0xd428a1dee632d5902081c9ef84e25cea4861c6ad9e805584c40fb0df85d0bb34 | 5000 | 120000 | 300000 | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 126 | 50 | 17821282 | 8000 | 1200 | 2023-08-01T16:15:23.000Z | 120 | 2500 | 0x09876f57abf2f9e630aa5ea41eb7ee26c1c65f418f9f8e42b8f2c2c7cb1bba6f | 5000 | 10000 | 250000 | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 128 | 100 | 17821282 | 8000 | 1200 | 2023-08-01T16:15:23.000Z | 300 | 2500 | 0xa568baca4a3e3d4cb52a16dec8f5db2d58e67c3157a2b053a90be617b61bd542 | 5000 | 7500 | 150000 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_PresetSet_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### Factory\_QuoteAssetAdded\_event Events tracking quote assets added to or removed from the Trader Joe V2 factory contract on Ethereum. Used for monitoring which tokens are approved as quote assets (pricing denominators) in 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_quoteAsset` | `STRING` | Contract address of the asset being added as an approved quote asset in the TraderJoe V2 factory. Hex-encoded, 0x-prefixed 40-character string representing ERC-20 tokens like USDC or WETH that can be used as quote currencies in liquidity pairs. | | address | removed | log\_index | block\_number | in\_quoteAsset | block\_timestamp | transaction\_hash | | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 164 | 17822480 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 2023-08-01T20:16:23.000Z | 0x95a32374eee375f39354dfb58509ba7d16b56dc4aca565642fdec393c924cf1a | | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 117 | 18484959 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 2023-11-02T14:22:47.000Z | 0xe2aed6d440e28f5db75a8df0b8c2c3e79ef36749ea8617c468c7942fd9355d25 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.Factory_QuoteAssetAdded_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 | | ------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ | | 1 | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | 0x6b175474e89094c44da98b954eedeac495271d0f | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 168 | 1 | 17822480 | 2023-08-01T20:16:23.000Z | 0x95a32374eee375f39354dfb58509ba7d16b56dc4aca565642fdec393c924cf1a | | 0 | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 166 | 1 | 17822480 | 2023-08-01T20:16:23.000Z | 0x95a32374eee375f39354dfb58509ba7d16b56dc4aca565642fdec393c924cf1a | | 2 | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | false | 0xa3b2b212529b953fc482fe5e3faf81e30b075b2d | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 121 | 100 | 18493587 | 2023-11-03T19:21:59.000Z | 0x406d9fb39b405c5fd68d68adc26128e391c7ce336bb66f5a2122cdc1c0e03e52 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.LBFactoryV2_LBPairCreated_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### LBPairV2\_ApprovalForAll\_event Operator approval events from Trader Joe V2 liquidity book pairs on Ethereum, tracking when users grant or revoke permission for other addresses to manage their liquidity positions. Used for analyzing delegation patterns and third-party integrations with Trader Joe V2 automated market maker (AMM) 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_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_approved` | `BOOL` | Boolean flag indicating whether approval was granted or revoked for the operation. | | address | removed | in\_sender | log\_index | in\_account | in\_approved | block\_number | block\_timestamp | transaction\_hash | | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ | | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 213 | 0x9b921fad875b06183d3992a125026c89915d71f6 | true | 18369199 | 2023-10-17T09:28:35.000Z | 0xbac5186af48ae87dc487089ab9e77ee04c7b66d71f36603856a1a487cb833e1d | | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 222 | 0x163e7078a0b17f2caf246cd5556bdb870089a5d4 | true | 18458068 | 2023-10-29T19:57:59.000Z | 0xa7b2219c972b11ff9a4fa0b31e76f582848fb461817dacbbb6e9f4aa25276a6f | | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 374 | 0x3b0abc81fa6a47135e36a513ad8845f48f1ee179 | true | 17836747 | 2023-08-03T20:07:23.000Z | 0x9f56243e8e657af1724832aebdb08682ce1379830ba25c9900cccbd3d5252449 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.LBPairV2_ApprovalForAll_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### LBPairV2\_CompositionFees\_event Fee composition events from Trader Joe V2 Liquidity Book (LB) pairs on Ethereum, showing total fees and protocol fee splits by liquidity bin ID. Used for analyzing fee distribution and protocol revenue 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. | | `in_totalFees` | `STRING` | Total fees collected from the transaction. Numeric string representation of the fee amount in the token's smallest unit. | | `in_protocolFees` | `STRING` | Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token's smallest unit. | | in\_id | address | removed | in\_sender | log\_index | block\_number | in\_totalFees | block\_timestamp | in\_protocolFees | transaction\_hash | | ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | | 8388612 | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 145 | 18369182 | 0x0000000000000000000000000000001500000000000000000000000000000000 | 2023-10-17T09:25:11.000Z | 0x0000000000000000000000000000000100000000000000000000000000000000 | 0xcba2251807c2bba0f81e83b07d3c09bd416744036c1330c8d3246a512e7a7a1d | | 8388602 | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 395 | 17842805 | 0x000000000000000000000000000008d300000000000000000000000000000000 | 2023-08-04T16:27:35.000Z | 0x0000000000000000000000000000007000000000000000000000000000000000 | 0xe3d21a35a9d03d950043a6e5a2521be3ee5365a9953075cf3d692f2586401c63 | | 8388602 | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 437 | 17844415 | 0x0000000000000000000000000000000500000000000000000000000000000000 | 2023-08-04T21:51:59.000Z | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0xf0dae021969b91df67d524812b08b1ff072c8f2b539a32b89a1a610a681e6c68 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.LBPairV2_CompositionFees_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### LBPairV2\_DepositedToBins\_event Liquidity deposit events from Trader Joe V2 LBPair contracts recording token amounts deposited into discretized price bins. Bin IDs represent specific price points where liquidity is concentrated, with amounts split between the paired token assets. | Column | Type | Description | | ------------------ | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_ids` | `ARRAY` | Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types. | | `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). | | in\_to | in\_ids | address | removed | in\_sender | log\_index | in\_amounts | block\_number | block\_timestamp | transaction\_hash | | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ | | 0x163e7078a0b17f2caf246cd5556bdb870089a5d4 | \["8388598","8388599","8388600","8388601","8388602","8388603","8388604","8388605","8388606","8388607","8388608","8388609","8388610"] | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 237 | \["0x000000000000000000000000089bdb1400000000000000000000000000000000","0x0000000000000000000000000c23f0cf00000000000000000000000000000000","0x000000000000000000000000101551c900000000000000000000000000000000","0x00000000000000000000000014041ca400000000000000000000000000000000","0x0000000000000000000000001766b1a200000000000000000000000000000000","0x00000000000000000000000019b379bb00000000000000000000000000000000","0x0000000000000000000000000d422c5a00000000000000000000000002a7228f","0x000000000000000000000000000000000000000000000000000000000524796f","0x0000000000000000000000000000000000000000000000000000000004aeaa8b","0x0000000000000000000000000000000000000000000000000000000004014604","0x000000000000000000000000000000000000000000000000000000000337d38d","0x00000000000000000000000000000000000000000000000000000000026ddc9b","0x0000000000000000000000000000000000000000000000000000000001b8f716"] | 18109819 | 2023-09-11T01:24:47.000Z | 0x5e485bf85a1a0d26bfe9fb4503f56100dddc0f6bbf5d3591df5cd1163533385a | | 0x7459e3045eaa7dfebb7b75c81e840d90ce029511 | \["8112279","8112280","8112281","8112282","8112283","8112284","8112285","8112286","8112287","8112288","8112289"] | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 265 | \["0x0000000000000000000000000000470500000000000000000000000000000000","0x0000000000000000000000000000470500000000000000000000000000000000","0x0000000000000000000000000000470500000000000000000000000000000000","0x0000000000000000000000000000470500000000000000000000000000000000","0x0000000000000000000000000000470500000000000000000000000000000000","0x00000000000000000000000000002382000000000000000000204c22370c8ba2","0x000000000000000000000000000000000000000000000000004098446e191745","0x000000000000000000000000000000000000000000000000004098446e191745","0x000000000000000000000000000000000000000000000000004098446e191745","0x000000000000000000000000000000000000000000000000004098446e191745","0x000000000000000000000000000000000000000000000000004098446e191745"] | 18374502 | 2023-10-18T03:16:35.000Z | 0x738526939c27799c76ae6eca5671ac1d1e7b9b171ea5269526544c5b5795f19a | | 0x7459e3045eaa7dfebb7b75c81e840d90ce029511 | \["8112279","8112280","8112281","8112282","8112283","8112284","8112285","8112286","8112287","8112288","8112289"] | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 143 | \["0x0000000000000000000000000000219700000000000000000000000000000000","0x0000000000000000000000000000326700000000000000000000000000000000","0x0000000000000000000000000000451a00000000000000000000000000000000","0x0000000000000000000000000000569300000000000000000000000000000000","0x0000000000000000000000000000631c00000000000000000000000000000000","0x000000000000000000000000000033d70000000000000000002f2622518bd6f6","0x000000000000000000000000000000000000000000000000005a242db233b35c","0x000000000000000000000000000000000000000000000000004ebd2857085765","0x000000000000000000000000000000000000000000000000003ed957a4cadaa5","0x000000000000000000000000000000000000000000000000002dd735f7f8ceda","0x000000000000000000000000000000000000000000000000001e8d7265fe74c6"] | 18374533 | 2023-10-18T03:22:47.000Z | 0x02ad8e7744309a912015296249cc54e98f8fce724cf2f4ad82ad6a61e84caf9c | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.LBPairV2_DepositedToBins_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### LBPairV2\_StaticFeeParametersSet\_event Static fee parameter configuration events from Trader Joe V2 liquidity book (LB) pairs on Ethereum. Captures governance updates to dynamic fee controls including base factors, volatility accumulators, protocol share splits, and decay periods for analyzing DEX 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_baseFactor` | `STRING` | Base fee multiplier for the Trader Joe V2 liquidity pool. Numeric string denominated in basis points. | | `in_filterPeriod` | `STRING` | Time window used to filter and smooth volatility measurements in the Trader Joe V2 fee model. Numeric string representing seconds. | | `in_decayPeriod` | `STRING` | Time period over which volatility accumulation decays in the Trader Joe V2 fee model. Numeric string representing seconds. | | `in_reductionFactor` | `STRING` | Multiplier applied to reduce accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. | | `in_variableFeeControl` | `STRING` | Sensitivity parameter controlling how quickly fees adjust to volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. | | `in_protocolShare` | `STRING` | Percentage of trading fees allocated to the protocol in the Trader Joe V2 fee model. Numeric string denominated in basis points. | | `in_maxVolatilityAccumulator` | `STRING` | Maximum threshold for accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points. | | address | removed | in\_sender | log\_index | block\_number | in\_baseFactor | in\_decayPeriod | block\_timestamp | in\_filterPeriod | in\_protocolShare | transaction\_hash | in\_reductionFactor | in\_variableFeeControl | in\_maxVolatilityAccumulator | | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | -------------- | --------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------- | ---------------------- | ---------------------------- | | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | 174 | 17822610 | 5000 | 120 | 2023-08-01T20:42:23.000Z | 10 | 500 | 0xfdeac09fb66cd480928022e3aa9d70cc2bebee359a3e90e003dc76416911134c | 5000 | 2000000 | 100000 | | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | false | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | 175 | 17822610 | 5000 | 120 | 2023-08-01T20:42:23.000Z | 10 | 500 | 0xfdeac09fb66cd480928022e3aa9d70cc2bebee359a3e90e003dc76416911134c | 5000 | 2000000 | 100000 | | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | false | 0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a | 167 | 17822480 | 20000 | 120 | 2023-08-01T20:16:23.000Z | 10 | 500 | 0x95a32374eee375f39354dfb58509ba7d16b56dc4aca565642fdec393c924cf1a | 5000 | 2000000 | 100000 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.LBPairV2_StaticFeeParametersSet_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### LBPairV2\_Swap\_event Swap events from Trader Joe V2 Liquidity Book (LB) pairs containing swap direction, amounts exchanged, bin identifier, fee breakdown, and volatility accumulator. Used for DEX trading activity analysis and liquidity pool performance tracking. | Column | Type | Description | | -------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. | | `in_amountsIn` | `STRING` | Input amounts of tokens provided in the swap operation. Hex-encoded, 0x-prefixed, 64-character string representing two packed uint128 values for token pairs. | | `in_amountsOut` | `STRING` | Output amounts of tokens received from the swap operation. Hex-encoded, 0x-prefixed, 64-character string representing two packed uint128 values for token pairs. | | `in_volatilityAccumulator` | `STRING` | Volatility accumulator value tracking price movement activity in the liquidity pool. Numeric string representation. | | `in_totalFees` | `STRING` | Total fees collected from the transaction. Numeric string representation of the fee amount in the token's smallest unit. | | `in_protocolFees` | `STRING` | Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token's smallest unit. | | in\_id | in\_to | address | removed | in\_sender | log\_index | block\_number | in\_amountsIn | in\_totalFees | in\_amountsOut | block\_timestamp | in\_protocolFees | transaction\_hash | in\_volatilityAccumulator | | ------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------- | | 8388603 | 0x23ebcd701fd92867235aeb0174b7c444b9b2b3ad | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x23ebcd701fd92867235aeb0174b7c444b9b2b3ad | 458 | 18226656 | 0x000000000000000000000000000000000000000000000000000000004adea7bb | 0x000000000000000000000000000000000000000000000000000000000000f556 | 0x0000000000000000000000004ad42a2e00000000000000000000000000000000 | 2023-09-27T11:00:11.000Z | 0x0000000000000000000000000000000000000000000000000000000000000c44 | 0x75f2bca307b00840f3112f11b31bff2b947c5e74baa848d9155584ec82bacedf | 0 | | 8388602 | 0x23ebcd701fd92867235aeb0174b7c444b9b2b3ad | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x23ebcd701fd92867235aeb0174b7c444b9b2b3ad | 459 | 18226656 | 0x0000000000000000000000000000000000000000000000000000000075265c8f | 0x0000000000000000000000000000000000000000000000000000000000018f3c | 0x0000000000000000000000007512e49a00000000000000000000000000000000 | 2023-09-27T11:00:11.000Z | 0x00000000000000000000000000000000000000000000000000000000000013f6 | 0x75f2bca307b00840f3112f11b31bff2b947c5e74baa848d9155584ec82bacedf | 10000 | | 8388603 | 0x23ebcd701fd92867235aeb0174b7c444b9b2b3ad | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x23ebcd701fd92867235aeb0174b7c444b9b2b3ad | 260 | 18225487 | 0x000000000000000000000000000000000000000000000000000000007bddd7f3 | 0x00000000000000000000000000000000000000000000000000000000000195e4 | 0x0000000000000000000000007bcc7ce600000000000000000000000000000000 | 2023-09-27T07:03:11.000Z | 0x000000000000000000000000000000000000000000000000000000000000144b | 0x19225bf69a75e201e5ac7f3f2258809f19f9fab2b31125fcc07b769be5859182 | 0 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.LBPairV2_Swap_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### LBPairV2\_TransferBatch\_event Batch liquidity position transfers from Trader Joe V2 liquidity book pairs on Ethereum, tracking multi-bin position mints, burns, and transfers with bin IDs and liquidity amounts. Used for analyzing concentrated liquidity provision patterns and position management across price bins. | Column | Type | Description | | ------------------ | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_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 | | ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ | | 0xbfbbb30f717e500f7df85dfed7ae8b20c7c618f8 | \["8388599","8388600","8388601","8388602","8388603","8388604","8388605","8388606","8388607","8388608","8388609"] | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | 0x0000000000000000000000000000000000000000 | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 225 | \["3820924801012367177332653216410792572005660576","5437391037733757525836622657210363632924150722","7153981727103729408276166448307280494598004250","8703586830031196827704448531397097379781284797","9790079769781455923376905386748449935490800190","9154750725304788425933494860533013126403368999","7816596998724797353450829185259423985584839620","6950050558349136101349817095523014897539627584","5713604292819331930407894527238694528303981981","4342930611643401272044061150009221378322989056","3052138480095854697410066205338724946126699364"] | 17986242 | 2023-08-24T18:06:59.000Z | 0x46602c1a5bbab872b9fe802a658c682c825d5010258791b53c4abf8d55d335be | | 0x7459e3045eaa7dfebb7b75c81e840d90ce029511 | \["8112279","8112280","8112281","8112282","8112283","8112284","8112285","8112286","8112287","8112288","8112289"] | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | 0x0000000000000000000000000000000000000000 | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 264 | \["6186673712989582204227613737716977852481536","6186673712989582204227613737716977852481536","6186673712989582204227613737716977852481536","6186673712989582204227613737716977852481536","6186673712989582204227613737716977852481536","6185715966429472350420540278677261653497912","6187260841628971041291638441140339179652729","6188205938657068095637112524068286801576547","6188824759250933802446676233707966357529432","6189443641726858895826920904109518972347003","6190062586091031581716503589539929924244238"] | 18374502 | 2023-10-18T03:16:35.000Z | 0x738526939c27799c76ae6eca5671ac1d1e7b9b171ea5269526544c5b5795f19a | | 0x7459e3045eaa7dfebb7b75c81e840d90ce029511 | \["8112279","8112280","8112281","8112282","8112283","8112284","8112285","8112286","8112287","8112288","8112289"] | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | 0x0000000000000000000000000000000000000000 | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 142 | \["2926088073153149847321558249305774850310144","4390663380380868994067922559692105232416768","6019595070831401418667096805467979660656640","7541678098068759165738771424510278870499328","8633644213518050694992740539758823061061632","9030507537079461854269712265681102979342964","8634254210869874326126718524465235230578384","7543216369831371646664447914304640555479875","6021559673090327581635177759598209702008920","4392431775787488756541676884619592549580966","2927821904351808457595544550478142876579012"] | 18374533 | 2023-10-18T03:22:47.000Z | 0x02ad8e7744309a912015296249cc54e98f8fce724cf2f4ad82ad6a61e84caf9c | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.LBPairV2_TransferBatch_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### LBPairV2\_WithdrawnFromBins\_event Liquidity withdrawal events from TraderJoe V2 liquidity book pairs, recording removal of tokens from specific price bins. Contains sender address, recipient address, bin identifiers, and withdrawn token amounts for tracking liquidity position exits. | Column | Type | Description | | ------------------ | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. | | `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. | | `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. | | `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. | | `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. | | `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. | | `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. | | `in_ids` | `ARRAY` | Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types. | | `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). | | in\_to | in\_ids | address | removed | in\_sender | log\_index | in\_amounts | block\_number | block\_timestamp | transaction\_hash | | ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ | | 0xedad9aaff8932605729c0331eb3b84adcc9435b8 | \["8112279","8112280","8112281","8112282","8112283","8112284","8112285","8112286","8112287","8112288","8112289"] | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 269 | \["0x00000000000000000000000003f8e2b500000000000000000000000000000000","0x00000000000000000000000003f8e2b500000000000000000000000000000000","0x00000000000000000000000003f8e2b500000000000000000000000000000000","0x00000000000000000000000003f8e2b500000000000000000000000000000000","0x00000000000000000000000003f8e2b500000000000000000000000000000000","0x00000000000000000000000001e18c650000000000000001e6ffc469fb54d8e5","0x0000000000000000000000000000000000000000000000039d147725b4081463","0x0000000000000000000000000000000000000000000000039d147725b4081463","0x0000000000000000000000000000000000000000000000039d147725b4081463","0x0000000000000000000000000000000000000000000000039d147725b4081463","0x0000000000000000000000000000000000000000000000039d147725b4081463"] | 17868715 | 2023-08-08T07:28:59.000Z | 0x5c2e724766ca99e20a0e7f261eebf84915612d71cc257c92ff65d6262ccb6536 | | 0x3b0abc81fa6a47135e36a513ad8845f48f1ee179 | \["8112280"] | 0xae4c7ddef4360d0cb5156b2c1435761525ff3997 | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 182 | \["0x00000000000000000000000009bc7ef800000000000000000000000000000000"] | 17836749 | 2023-08-03T20:07:47.000Z | 0x9fa735f40e891196c9162afcddadc29c06d55f4758adc5812f069bd81df252ce | | 0xbfbbb30f717e500f7df85dfed7ae8b20c7c618f8 | \["8388599","8388600","8388601","8388602","8388603","8388604","8388605","8388606","8388607","8388608","8388609"] | 0x47b1cec2d2370e11b049c73ab6732f03e920c71a | false | 0x9a93a421b74f1c5755b83dd2c211614dc419c44b | 233 | \["0x00000000000000000000000000ab5b6e00000000000000000000000000000000","0x00000000000000000000000000f3e61900000000000000000000000000000000","0x0000000000000000000000000140e97b00000000000000000000000000000000","0x00000000000000000000000001866ba100000000000000000000000000000000","0x00000000000000000000000001b7287000000000000000000000000000000000","0x000000000000000000000000019aabf000000000000000000000000000000000","0x000000000000000000000000015e98b300000000000000000000000000000000","0x0000000000000000000000000137b2ad00000000000000000000000000000000","0x000000000000000000000000010042c100000000000000000000000000000000","0x00000000000000000000000000c2c84600000000000000000000000000000000","0x000000000000000000000000006da476000000000000000000000000001b3f7c"] | 18263027 | 2023-10-02T13:04:23.000Z | 0x4046809e83a7fab595126dc96c4ce226617bc2cfa883753fec17838855382061 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.traderjoe_v2_ethereum.LBPairV2_WithdrawnFromBins_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***