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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_pendingOwner	transaction_hash
0xdc8d77b69155c7e68a95a4fb0f06a71ff90b943a	false	130	17821282	2023-08-01T16:15:23.000Z	0xf8965d150f0a376011fd1e12db3266fca1b15cd6	0xd5614ea9f784fff9f8f5bf352b44914a8efb208f6d043e2f761c2e91fc056fe4

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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<STRING>`	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<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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<STRING>`	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<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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<STRING>`	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<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).

Sample Data

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.traderjoe_v2_ethereum.LBPairV2_WithdrawnFromBins_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_FeeRecipientSet_event

Factory_FlashLoanFeeSet_event

Factory_LBPairCreated_event

Factory_LBPairImplementationSet_event

Factory_OwnershipTransferred_event

Factory_PendingOwnerSet_event

Factory_PresetOpenStateChanged_event

Factory_PresetSet_event

Factory_QuoteAssetAdded_event

LBFactoryV2_LBPairCreated_event

LBPairV2_ApprovalForAll_event

LBPairV2_CompositionFees_event

LBPairV2_DepositedToBins_event

LBPairV2_StaticFeeParametersSet_event

LBPairV2_Swap_event

LBPairV2_TransferBatch_event

LBPairV2_WithdrawnFromBins_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_FeeRecipientSet_event

​Factory_FlashLoanFeeSet_event

​Factory_LBPairCreated_event

​Factory_LBPairImplementationSet_event

​Factory_OwnershipTransferred_event

​Factory_PendingOwnerSet_event

​Factory_PresetOpenStateChanged_event

​Factory_PresetSet_event

​Factory_QuoteAssetAdded_event

​LBFactoryV2_LBPairCreated_event

​LBPairV2_ApprovalForAll_event

​LBPairV2_CompositionFees_event

​LBPairV2_DepositedToBins_event

​LBPairV2_StaticFeeParametersSet_event

​LBPairV2_Swap_event

​LBPairV2_TransferBatch_event

​LBPairV2_WithdrawnFromBins_event

Tables

Factory_FeeRecipientSet_event

Factory_FlashLoanFeeSet_event

Factory_LBPairCreated_event

Factory_LBPairImplementationSet_event

Factory_OwnershipTransferred_event

Factory_PendingOwnerSet_event

Factory_PresetOpenStateChanged_event

Factory_PresetSet_event

Factory_QuoteAssetAdded_event

LBFactoryV2_LBPairCreated_event

LBPairV2_ApprovalForAll_event

LBPairV2_CompositionFees_event

LBPairV2_DepositedToBins_event

LBPairV2_StaticFeeParametersSet_event

LBPairV2_Swap_event

LBPairV2_TransferBatch_event

LBPairV2_WithdrawnFromBins_event