traderjoe_v2_avalanche

Tables

LBFactory_FeeParametersSet_event

Fee configuration events from Trader Joe V2 liquidity book (LB) factory contract on Avalanche, capturing dynamic fee parameter updates for individual trading pairs. Used for analyzing fee tier changes, volatility-based fee mechanisms, and protocol revenue share adjustments across different bin steps.

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_LBPair`	`STRING`	Contract address of the Trader Joe V2 liquidity book pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_binStep`	`STRING`	Price bin step size for the Trader Joe V2 liquidity pool. Numeric string representing the step granularity in basis points.
`in_baseFactor`	`STRING`	Base fee multiplier for the Trader Joe V2 liquidity pool. Numeric string denominated in basis points.
`in_filterPeriod`	`STRING`	Time window used to filter and smooth volatility measurements in the Trader Joe V2 fee model. Numeric string representing seconds.
`in_decayPeriod`	`STRING`	Time period over which volatility accumulation decays in the Trader Joe V2 fee model. Numeric string representing seconds.
`in_reductionFactor`	`STRING`	Multiplier applied to reduce accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points.
`in_variableFeeControl`	`STRING`	Sensitivity parameter controlling how quickly fees adjust to volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points.
`in_protocolShare`	`STRING`	Percentage of trading fees allocated to the protocol in the Trader Joe V2 fee model. Numeric string denominated in basis points.
`in_maxVolatilityAccumulated`	`STRING`	Maximum accumulated volatility threshold for the liquidity bin pair’s dynamic fee calculation. Numeric value representing the cap on volatility accumulation, commonly set to 100000-350000 in Trader Joe V2 configurations.

Sample Data

address	removed	in_LBPair	in_sender	log_index	in_binStep	block_number	in_baseFactor	in_decayPeriod	block_timestamp	in_filterPeriod	transaction_hash	in_reductionFactor	in_variableFeeControl	in_maxVolatilityAccumulated
0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	0x761969787f55cc9f6ccae3a46ca9f0108b160934	0x2fbb61a10b96254900c03f1644e9e1d2f5e76dd2	5	1	22707311	20000	120	2022-11-22T17:43:46.000Z	10	0x6a0efd61c868c5cded03f3c4e37baa8719895d2c4ea7fb3b3f27e59f3dadf7ac	5000	2000000	100000
0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	0xbc811ef83fb68c25eedf83767e24a2de0262aca6	0x2fbb61a10b96254900c03f1644e9e1d2f5e76dd2	8	1	22707311	20000	120	2022-11-22T17:43:46.000Z	10	0x6a0efd61c868c5cded03f3c4e37baa8719895d2c4ea7fb3b3f27e59f3dadf7ac	5000	2000000	100000
0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	0x42be75636374dfa0e57eb96fa7f68fe7fcdad8a3	0x2fbb61a10b96254900c03f1644e9e1d2f5e76dd2	45	10	23927866	10000	600	2022-12-21T16:09:57.000Z	30	0xf411a21233eee712daab01293ad6993aaa07800ff09f2e2fc82f38e1753b142e	5000	40000	350000

Example Query

Query with partition filter

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

LBFactory_FeeRecipientSet_event

Fee recipient address changes for the Trader Joe v2 Liquidity Book (LB) factory contract on Avalanche. Tracks governance updates to protocol fee collection addresses over time.

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
0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	29	29180546	2023-04-24T23:25:27.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0x1119fbb02f38764cd90f2d9fb35fedcd8378ac2a	0xf96970a23b3b95605852769c21fd393f3d8324201d890824fa31db8ad2adc985
0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	3	22426953	2022-11-15T23:25:00.000Z	0x1119fbb02f38764cd90f2d9fb35fedcd8378ac2a	0x0000000000000000000000000000000000000000	0x2b8f6617ecb3fdf1d6e8b21a8fb03fa8380fd147a7cd9942d0d5e541a7755f21

Example Query

Query with partition filter

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

LBFactory_FlashLoanFeeSet_event

Flash loan fee configuration changes from the Trader Joe V2 Liquidity Book (LB) factory contract on Avalanche. Tracks administrative updates to flash loan fee parameters with old and new values for monitoring protocol fee structure adjustments.

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
0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	4	22426953	2022-11-15T23:25:00.000Z	0x2b8f6617ecb3fdf1d6e8b21a8fb03fa8380fd147a7cd9942d0d5e541a7755f21	5000000000000	0
0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	1	24198931	2022-12-28T03:47:35.000Z	0xd4e942aea7f7ad2e8e922bdbf83504c9fd399ed74809e749d6d4d2e305fdc4a6	0	5000000000000

Example Query

Query with partition filter

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

LBFactory_LBPairCreated_event

Liquidity Book (LB) pair creation events from Trader Joe V2 decentralized exchange on Avalanche, recording new trading pool deployments with token addresses and bin step parameters. Used for tracking pool launches and analyzing market structure across different fee tiers.

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
4	0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	0xe4e7aaa5a1aab5b55ee44fab2d5dd6fcd80e4d42	0x50b7545627a5162f82a992c33b87adc75187b218	0x152b9d0fdc40c096757f570a51e494bd4b943e50	30	2	22442423	2022-11-16T08:30:56.000Z	0xe9efcad9cdf96e9ddb323ab03b6d1e4bf0160019308584d95b2d22b93f515505
5	0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	0xa7687be7174721178cfd7aa1ae590209649fc0b8	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	33	5	22442423	2022-11-16T08:30:56.000Z	0xe9efcad9cdf96e9ddb323ab03b6d1e4bf0160019308584d95b2d22b93f515505
2	0x6e77932a92582f504ff6c4bdbcef7da6c198aeef	false	0x12ef33ed026d6eeb6c1ea90e97401ddf3d45f569	0xc7198437980c041c805a1edcba50c1ce5db95118	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	24	1	22442423	2022-11-16T08:30:56.000Z	0xe9efcad9cdf96e9ddb323ab03b6d1e4bf0160019308584d95b2d22b93f515505

Example Query

Query with partition filter

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

LBFactoryV2_FeeRecipientSet_event

Fee recipient address change events from Trader Joe V2 Liquidity Book (LB) factory contract on Avalanche. Tracks protocol fee collection address updates for analyzing fee distribution and governance changes.

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
0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	5	28371397	2023-04-06T00:45:25.000Z	0xc8fc59fceb8259534d8b10879273879eddf7eec0	0x0000000000000000000000000000000000000000	0x4fbbe17808790bb38e851c8e24287871c4a2897cea2665ebee6c4d5daab7fe85
0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	28	29180546	2023-04-24T23:25:27.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0xc8fc59fceb8259534d8b10879273879eddf7eec0	0xf96970a23b3b95605852769c21fd393f3d8324201d890824fa31db8ad2adc985

Example Query

Query with partition filter

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

LBFactoryV2_FlashLoanFeeSet_event

Flash loan fee configuration changes for Trader Joe V2 liquidity book pools on Avalanche. Tracks updates to the protocol’s flash loan fee parameter with old and new values for analyzing fee policy evolution.

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
0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	6	28371397	2023-04-06T00:45:25.000Z	0x4fbbe17808790bb38e851c8e24287871c4a2897cea2665ebee6c4d5daab7fe85	5000000000000	0

Example Query

Query with partition filter

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

LBFactoryV2_LBPairCreated_event

Trader Joe V2 Liquidity Book (LB) pair creation events emitted when new liquidity pools are deployed by the LBFactory contract. Contains token pair addresses, pool identifier, bin step size for price granularity, and the deployed LBPair contract address.

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
420	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0x9322593fe08c4dbe3ee7f8107fd5da273d3d5bd9	0x13e7bcefdde72492e656f3fa58bae6029708e673	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	4	25	35306974	2023-09-17T15:43:31.000Z	0xbb32b88731556c2da72a9712afd331c08432e534c5aff7c9e507102bf0ba2748
419	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0x3a716463892833591fbe425107304d7825c0f3c4	0xf9d922c055a3f1759299467dafafdf43be844f7a	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	2	100	35285220	2023-09-17T03:17:36.000Z	0x18ad0a8c064026b751453eba78a1363dfb66de6499d7d345b5811872c109e32d
273	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0xb47182a94b93da5326beab3ebd3b2221472d5373	0x17677b110273c982eab3f9e6691a5aaaddac9294	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	9	100	31047548	2023-06-08T01:33:33.000Z	0x53eed2682c54cb19aba1af89540582f13774d439cf1820c8f936a41bb319dfc7

Example Query

Query with partition filter

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

LBFactoryV22_LBPairCreated_event

Liquidity Book (LB) trading pair creation events from Trader Joe V2.2 factory contract on Avalanche, capturing new pool deployments with token addresses, bin step parameters, and unique pair identifiers (pid). Used for tracking DEX liquidity pool launches and analyzing fee tier distributions across trading pairs.

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
33	0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c	false	0x67d07097c29aaffa9194ba90ca0e03200e8dd410	0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	4	100	47392000	2024-06-30T22:24:22.000Z	0x2f406e47147b7167b32aa3f03531001b0ab249980c4033ba4a0db00be4399cc2
32	0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c	false	0xd5cd28f57c282cb2206747368d45aaff11d73bc9	0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0	50	47391825	2024-06-30T22:18:20.000Z	0x32573ca73dcad049feefbf84365075accc1b44d0717d57e74a25f493b0b5640a
31	0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c	false	0xaa40a4cccaf04bf3c8890e67877b012704ee6264	0x147929393f770869ad635ce284d66911798d9a5c	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	12	50	47373609	2024-06-30T11:54:36.000Z	0x9ce1f5353f4fedf04a8920b91e9b7502037e02d076dfaf4a965b0a9902cb6c36

Example Query

Query with partition filter

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

LBPair_CompositionFee_event

Composition fee collection events from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, tracking fees earned in token X and Y by liquidity providers. Used to analyze fee revenue distribution across liquidity bins and measure LP earnings.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_feesX`	`STRING`	Composition fee collected in token X for the Trader Joe V2 liquidity bin specified by in_id. Typically zero in sample data, indicating no fees collected in the X token during these transactions.
`in_feesY`	`STRING`	Composition fees collected in token Y for the specified liquidity bin on Trader Joe V2. Denominated in token Y’s smallest unit (wei-equivalent), typically non-zero when in_feesX is zero.

Sample Data

in_id	address	removed	in_feesY	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
8362928	0xf43f906250bea2d84aeaaf28bd7ac74d5c8dbfb6	false	105	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	62	25939690	0xe699e8334d901986d9ff6bc5ae4b44ae5122f1ee	2023-02-07T06:20:37.000Z	0xee0f2be18ce4b6c5cf55f6920364ea7a8adf560f92b0fcbed5a83f5cf8a271b4
8375103	0x5851e2d6396bcc26fb9eee21effbf99e0d2b2148	false	28053	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	36	25928961	0x72cccefec6bd06c938c1ccaf315aeb16ce91ce34	2023-02-07T00:18:17.000Z	0x089ee5d9702e03ec9d1a3a51395710aec9da279b06ea0bb1881debbbac61d0da
8375105	0x5851e2d6396bcc26fb9eee21effbf99e0d2b2148	false	42996	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	13	25930951	0xff4f7b726ee86f810531d2842b3bdd8a512db594	2023-02-07T01:25:05.000Z	0x9ae22328f6b080ceb2b3371c592e6248df1674f9f8ccd50fe9d4a05061fc3a6a

Example Query

Query with partition filter

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

LBPair_DepositedToBin_event

Liquidity deposit events from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, recording tokenX and tokenY amounts added to specific price bins. Used for tracking liquidity provision patterns and bin-level capital allocation in concentrated liquidity pools.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_amountX`	`STRING`	Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_amountY`	`STRING`	Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	address	removed	in_sender	log_index	in_amountX	in_amountY	block_number	in_recipient	block_timestamp	transaction_hash
8376213	0xb5352a39c11a81fe6748993d586ec448a01f08b5	false	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	3	0	5550901764	25395491	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	2023-01-25T12:29:25.000Z	0x00036bddbe5e18e38b30b1081cdc45a4cef12f7629029813524f2c80515aeab8
8376214	0xb5352a39c11a81fe6748993d586ec448a01f08b5	false	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	5	560150433594631662952	54492102	25395491	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	2023-01-25T12:29:25.000Z	0x00036bddbe5e18e38b30b1081cdc45a4cef12f7629029813524f2c80515aeab8
8376205	0xb5352a39c11a81fe6748993d586ec448a01f08b5	false	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	9	64767823843330809194	9890614517	25399257	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	2023-01-25T14:37:33.000Z	0x00233123e16f5e57b64654199d347b2bf672c63fee324266d29ecc90f56319da

Example Query

Query with partition filter

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

LBPair_FeesCollected_event

Fee collection events from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, recording accumulated trading fees claimed by liquidity providers. Used to track fee revenue distribution and liquidity provider returns across trading pairs.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountX`	`STRING`	Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_amountY`	`STRING`	Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x18332988456c4bd9aba6698ec748b331516f5a14	false	0x61921dc906d1576b76e491a7d066c150a108265b	7	29685743	0x61921dc906d1576b76e491a7d066c150a108265b	2023-05-06T22:09:48.000Z	0xfc7a21c8559e606d004c143251b08f3503c02685e7c4708c5e5acc57adc6bd17
0x18332988456c4bd9aba6698ec748b331516f5a14	false	0x61921dc906d1576b76e491a7d066c150a108265b	10	29653883	0x61921dc906d1576b76e491a7d066c150a108265b	2023-05-06T04:09:20.000Z	0x9ba0703f6c22535e49104dc11e116714f067459a76042b9095b2965933964c31
0x18332988456c4bd9aba6698ec748b331516f5a14	false	0x61921dc906d1576b76e491a7d066c150a108265b	11	29675164	0x61921dc906d1576b76e491a7d066c150a108265b	2023-05-06T16:09:37.000Z	0xbc6588be2e20d63e68ccab7336be2bd223ea5966d1df34d36780de1370b8ab1a

Example Query

Query with partition filter

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

LBPair_FlashLoan_event

Flash loan events from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, recording borrowed token amounts, fees, sender/receiver addresses, and pool contract addresses. Used for analyzing flash loan arbitrage patterns and liquidity bootstrapping strategies.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

address	removed	in_token	in_amount	in_sender	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x1d7a1a79e2b4ef88d2323f3845246d24a3c20f1d	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	20073026048	0x5a66c9d69deaac0f979c9903ef07b64bb0614b43	7	0x5a66c9d69deaac0f979c9903ef07b64bb0614b43	28153059	2023-03-31T22:21:30.000Z	0xfb6f5f23619af1eca9fc35bb705103bcff15679c95185facdbf552b6defb751f
0x1d7a1a79e2b4ef88d2323f3845246d24a3c20f1d	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	2156865216	0x5a66c9d69deaac0f979c9903ef07b64bb0614b43	7	0x5a66c9d69deaac0f979c9903ef07b64bb0614b43	28131749	2023-03-31T10:27:12.000Z	0x04487be5a411aee0e50b9ed26adadbf00c5c0a2bbc33f149efb9e5b1af93ba10
0x1d7a1a79e2b4ef88d2323f3845246d24a3c20f1d	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	19979723776	0x5a66c9d69deaac0f979c9903ef07b64bb0614b43	7	0x5a66c9d69deaac0f979c9903ef07b64bb0614b43	28126758	2023-03-31T07:39:29.000Z	0x9d1fe41a2dd963f3cede72c2669d173c381367707d1b9a8bc99fb21cf1a07402

Example Query

Query with partition filter

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

LBPair_Swap_event

Swap event records from Trader Joe V2 Liquidity Book (LB) pairs on Avalanche, capturing token exchanges with amounts, fees, bin IDs, and swap direction. Used for analyzing DEX trading volume, liquidity utilization across price bins, and fee generation in concentrated liquidity markets.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_swapForY`	`BOOL`	Indicates the swap direction within the Trader Joe V2 liquidity bin pair (true when swapping token X for token Y, false for Y to X). This boolean determines which token in the pair is being sold and which is being acquired.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_volatilityAccumulated`	`STRING`	Accumulated volatility metric for the Trader Joe V2 liquidity bin at the time of the swap. Always zero in sample data, indicating stable market conditions or unused parameter in this pool configuration.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.

Sample Data

in_id	address	in_fees	removed	in_sender	log_index	in_amountIn	in_swapForY	block_number	in_amountOut	in_recipient	block_timestamp	transaction_hash
8112282	0xbc811ef83fb68c25eedf83767e24a2de0262aca6	12634235884972419	false	0x982b21c1ffa10be8e7ca8e35dff87eeaa2702d50	6	63158545188977121301	true	28726846	63146082	0x982b21c1ffa10be8e7ca8e35dff87eeaa2702d50	2023-04-14T07:48:11.000Z	0xa71392034d4dc8ba8e4abe4b4ac9fa42b413a289cb80cb199ad9ae5f42596e64
8112282	0xbc811ef83fb68c25eedf83767e24a2de0262aca6	2040000000000000	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	25	10197960000000000000	true	28728413	10195947	0xf4003f4efbe8691b60249e6afbd307abe7758adb	2023-04-14T08:40:48.000Z	0xd657b5681b56d17898622e2c3546536afed0fb5f7f6a175f30f2ae516415634f
8112282	0x855ee438445075f25c18a125ba6607543052a194	49859	false	0xb2a58c5e5399368716067be72d3548f0927f0fe4	7	249244507	false	28715584	249293699303447044401	0x1dac32947cd796b4203f69a5a6748e6775d92800	2023-04-14T01:29:49.000Z	0x2bcd7474025d33361d3f5488761334117511c93ae83816ff8ef6f86758956ef4

Example Query

Query with partition filter

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

LBPair_TransferBatch_event

Batch liquidity position transfers from Trader Joe v2 liquidity book (LB) pairs on Avalanche, containing bin IDs and token amounts transferred between accounts. Used for tracking multi-bin LP position movements and liquidity provision patterns.

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
0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c	[“8394238”,“8394239”,“8394240”,“8394241”,“8394242”,“8394243”,“8394244”,“8394245”,“8394246”,“8394247”,“8394248”,“8394249”,“8394250”,“8394251”,“8394252”,“8394253”,“8394254”,“8394255”]	0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c	0xd13a6119505a470a88ed7ab07818403e5157ce7b	false	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	0	[“3117552”,“3117552”,“3117552”,“3117552”,“3117552”,“1714330”,“312258”,“15966579”,“15966892”,“15967204”,“15967518”,“15654009”,“15660968”,“15690999”,“15706690”,“15722396”,“15738119”,“15753857”]	28129839	2023-03-31T09:23:03.000Z	0x5813f0cda83dba135f16cccc188c2e17c319ec0be2b5b2c6871c8ed877fedd0a
0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c	[“8394253”,“8394254”,“8394255”,“8394256”,“8394257”,“8394258”,“8394259”,“8394260”,“8394261”,“8394262”,“8394263”]	0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c	0xb92d440fae9c92dbb12c2293e4e4eae357194870	false	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	0	[“7159317”,“7159317”,“7159317”,“7159317”,“7159317”,“6302157”,“5457815”,“5463273”,“5468736”,“5474205”,“5479679”]	28123610	2023-03-31T05:54:13.000Z	0x40cbd1c4b20a90c8e346259eebe7dc24a334d6f989e35d9d6a2adb60c5a55a0d
0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c	[“8394248”,“8394249”,“8394250”,“8394251”,“8394252”,“8394253”,“8394254”,“8394255”,“8394256”,“8394257”,“8394258”]	0x11c0f9134d7db45e3dab7a78ac3c957a92229e8c	0xff4f7b726ee86f810531d2842b3bdd8a512db594	false	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	1	[“27092099”,“54184199”,“108368398”,“162552597”,“203190746”,“247561328”,“209784458”,“167995450”,“112108869”,“56110347”,“28083087”]	28126348	2023-03-31T07:25:43.000Z	0x537d18e220c013e49a2aa673153cc8a3117de9945c92c59af0e43abdddaaf382

Example Query

Query with partition filter

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

LBPair_TransferSingle_event

Liquidity bin token transfer events from Trader Joe V2 liquidity book pairs on Avalanche, tracking individual bin position movements between addresses. Used for analyzing liquidity provision activity and LP token ownership changes across price bins.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	in_to	address	in_from	removed	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
8388612	0x0000000000000000000000000000000000000000	0x18332988456c4bd9aba6698ec748b331516f5a14	0x18332988456c4bd9aba6698ec748b331516f5a14	false	20008	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	44	23922081	2022-12-21T12:55:44.000Z	0x0048fcc3a253a52c1219b6f52d27867960a2e94634adccb075ea46bb6c559638
8388604	0x0000000000000000000000000000000000000000	0x18332988456c4bd9aba6698ec748b331516f5a14	0x18332988456c4bd9aba6698ec748b331516f5a14	false	20000	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	28	23922081	2022-12-21T12:55:44.000Z	0x0048fcc3a253a52c1219b6f52d27867960a2e94634adccb075ea46bb6c559638
8388608	0x0000000000000000000000000000000000000000	0x18332988456c4bd9aba6698ec748b331516f5a14	0x18332988456c4bd9aba6698ec748b331516f5a14	false	19999	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	36	23922081	2022-12-21T12:55:44.000Z	0x0048fcc3a253a52c1219b6f52d27867960a2e94634adccb075ea46bb6c559638

Example Query

Query with partition filter

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

LBPair_WithdrawnFromBin_event

Liquidity withdrawal events from Trader Joe V2 liquidity book (LB) pairs on Avalanche, recording tokenX and tokenY amounts removed from specific price bins. Used for tracking liquidity provider position exits and analyzing bin-level liquidity changes over time.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_amountX`	`STRING`	Amount of token X involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.
`in_amountY`	`STRING`	Amount of token Y involved in the liquidity operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	address	removed	in_sender	log_index	in_amountX	block_number	in_recipient	block_timestamp	transaction_hash
8388611	0x18332988456c4bd9aba6698ec748b331516f5a14	false	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	31	1805	32170026	0x0d3015631c1e642e8eb35b5a0efcea24a7685603	2023-07-04T14:34:01.000Z	0x0ba37de594e61cf9b379f063799e01834a687a54bcff98e69bcd5f810447b621
8388612	0x18332988456c4bd9aba6698ec748b331516f5a14	false	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	33	1805	32170026	0x0d3015631c1e642e8eb35b5a0efcea24a7685603	2023-07-04T14:34:01.000Z	0x0ba37de594e61cf9b379f063799e01834a687a54bcff98e69bcd5f810447b621
8388613	0x18332988456c4bd9aba6698ec748b331516f5a14	false	0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3	35	1805	32170026	0x0d3015631c1e642e8eb35b5a0efcea24a7685603	2023-07-04T14:34:01.000Z	0x0ba37de594e61cf9b379f063799e01834a687a54bcff98e69bcd5f810447b621

Example Query

Query with partition filter

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

LBPairV2_CollectedProtocolFees_event

Protocol fee collection events from Trader Joe V2 liquidity book pairs on Avalanche. Records fees withdrawn by the protocol from individual trading pairs, useful for analyzing protocol revenue across different liquidity pools.

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_feeRecipient`	`STRING`	Address designated to receive fees collected from the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolFees`	`STRING`	Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token’s smallest unit.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_feeRecipient	in_protocolFees	transaction_hash
0x4224f6f4c9280509724db2dbac314621e4465c29	false	8	36906041	2023-10-25T14:43:16.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0x0000000000000000000000001f0ae472000000000000000000000000001567b1	0xcd913ac84aea3254315edd29da5cd7998dd2206b534d2d10cfbab4044b70e70b
0xd446eb1660f766d533beceef890df7a69d26f7d1	false	5	36906041	2023-10-25T14:43:16.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0x0000000000000000000000003afa0d460000000000000004a0306793c1e2b8d5	0xcd913ac84aea3254315edd29da5cd7998dd2206b534d2d10cfbab4044b70e70b
0x4224f6f4c9280509724db2dbac314621e4465c29	false	47	30780121	2023-06-01T17:43:12.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0x0000000000000000000000001e4988df000000000000000000000000001e6071	0xb466adaa6679c66148d45585c7b934d93a4da8402468a454dcff8b33ae6313d6

Example Query

Query with partition filter

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

LBPairV2_CompositionFees_event

Fee composition events from Trader Joe V2 Liquidity Book pairs on Avalanche, tracking total trading fees and protocol fees collected per transaction. Used for analyzing fee distribution and protocol revenue across liquidity pools.

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
8376059	0xd446eb1660f766d533beceef890df7a69d26f7d1	false	0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc	72	32046247	0x000000000000000000000000000000000000000000000000336c78fe8e20fe68	2023-07-01T16:38:22.000Z	0x0000000000000000000000000000000000000000000000000524727fdb034ca4	0x9099b1b620b912ef06ee433313b991cfd989ad91acb991e391c3a63f34d84431
8376059	0xd446eb1660f766d533beceef890df7a69d26f7d1	false	0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc	45	32049762	0x00000000000000000000000000000000000000000000000005edf56763daaa16	2023-07-01T18:37:03.000Z	0x0000000000000000000000000000000000000000000000000097cbbd89fc4435	0xd8796cb8eade1f16a247b7727a00870a8b7e35297af8cb4796b4efa4aea4c7c4
8376059	0xd446eb1660f766d533beceef890df7a69d26f7d1	false	0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc	45	32033351	0x000000000000000000000000021c9cca00000000000000000000000000000000	2023-07-01T09:22:48.000Z	0x00000000000000000000000000360fad00000000000000000000000000000000	0x18435f5450fed413ea4ee24630a977c285b126ed662d774dcc5454ea99fe0625

Example Query

Query with partition filter

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

LBPairV2_DepositedToBins_event

Liquidity deposit events from Trader Joe V2 LBPair contracts recording token amounts deposited into discretized price bins. Bin IDs represent specific price points where liquidity is concentrated, with amounts split between the paired token assets.

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
0x05581527c49d84a042e281cc179065b887f1c721	[“8362692”,“8362693”,“8362694”,“8362695”,“8362696”,“8362697”,“8362698”,“8362699”,“8362700”,“8362701”,“8362702”,“8362703”,“8362704”,“8362705”,“8362706”,“8362707”,“8362708”,“8362709”,“8362710”,“8362711”,“8362712”,“8362713”,“8362714”,“8362715”,“8362716”,“8362717”,“8362718”,“8362719”,“8362720”]	0x16396b65d5e0794c44447396f94665d3b9f576a0	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	13	[“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000003b910100000000000000000000000000000000”,“0x000000000000000000000000001dc8800000000000000000058778b106782f1e”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”,“0x0000000000000000000000000000000000000000000000000b0f2239c7344d72”]	36240414	2023-10-09T16:55:20.000Z	0xd05d37653445a7ed6ab6e548fe5c73ee0f62718223103ae46da96b26d0a8b803
0x170ddec929b8dfdfadbaba9bf994d9f3f7343cf1	[“8362706”,“8362707”,“8362708”,“8362709”,“8362710”,“8362711”,“8362712”,“8362713”,“8362714”,“8362715”,“8362716”,“8362717”,“8362718”,“8362719”,“8362720”,“8362721”,“8362722”,“8362723”,“8362724”,“8362725”,“8362726”,“8362727”,“8362728”,“8362729”,“8362730”,“8362731”,“8362732”,“8362733”,“8362734”]	0x16396b65d5e0794c44447396f94665d3b9f576a0	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	8	[“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000007f431400000000000000000000000000000000”,“0x000000000000000000000000003fa18a000000000000000009c04117a980a27c”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”,“0x0000000000000000000000000000000000000000000000001380b18083d8621a”]	36231164	2023-10-09T11:40:00.000Z	0xb982e7a9f17f919c6c712b43cb70a8aa4f21aa0b7caac9483ea3609a276e9c8e
0x71d725c16f6f2dfb3c49557245d9b7fcb872ec3a	[“8362710”,“8362711”,“8362712”,“8362713”,“8362714”,“8362715”,“8362716”,“8362717”,“8362718”,“8362719”,“8362720”]	0x16396b65d5e0794c44447396f94665d3b9f576a0	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	6	[“0x00000000000000000000000000000000000000000000000009b3fff6f95bfb10”,“0x000000000000000000000000000000000000000000000000099ab9b4a361108d”,“0x00000000000000000000000000000000000000000000000009712be85b4c9f27”,“0x00000000000000000000000000000000000000000000000009382c58d159f25d”,“0x00000000000000000000000000000000000000000000000008f0dc363065a370”,“0x000000000000000000000000000000000000000000000000089c9e92e778e93b”,“0x000000000000000000000000000000000000000000000000083d0cea31b86637”,“0x00000000000000000000000000000000000000000000000007d3ea38d8528bdc”,“0x000000000000000000000000000000000000000000000000076315394286bd80”,“0x00000000000000000000000000000000000000000000000006ec7a5858d7db20”,“0x000000000000000000000000000000000000000000000000067205f519918ff0”]	36246676	2023-10-09T20:31:18.000Z	0x51a5b31bcadf326610ff657c93192ef297801a097d7cfd87ad5f24290ccc616f

Example Query

Query with partition filter

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

LBPairV2_FlashLoan_event

Flash loan execution records from Trader Joe V2 liquidity book pairs on Avalanche. Contains borrowed amounts, fees charged, active price bin identifiers, and sender/receiver addresses for analyzing arbitrage activity and protocol fee generation.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_activeId`	`STRING`	Active bin identifier representing the current price point in the liquidity pool at the time of the flash loan. Numeric string value determines the exchange rate between the two tokens in the Trader Joe V2 pair.
`in_amounts`	`STRING`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_totalFees`	`STRING`	Total fees collected from the transaction. Numeric string representation of the fee amount in the token’s smallest unit.
`in_protocolFees`	`STRING`	Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token’s smallest unit.

Sample Data

address	removed	in_sender	log_index	in_amounts	in_activeId	in_receiver	block_number	in_totalFees	block_timestamp	in_protocolFees	transaction_hash
0xd446eb1660f766d533beceef890df7a69d26f7d1	false	0xc96debd23d753557ab236b05ea7585c7e1f001ec	57	0x0000000000000000000000018e7475a900000000000000000000000000000000	8376002	0xc96debd23d753557ab236b05ea7585c7e1f001ec	31485402	0x0000000000000000000000000000829100000000000000000000000000000000	2023-06-18T10:40:50.000Z	0x00000000000000000000000000000d0e00000000000000000000000000000000	0x1bd9d1dbcb6764392a20f1dc3ce8036400ef4bd364cc6429825823964db209e9
0xd446eb1660f766d533beceef890df7a69d26f7d1	false	0xc96debd23d753557ab236b05ea7585c7e1f001ec	45	0x000000000000000000000002596654d600000000000000000000000000000000	8376003	0xc96debd23d753557ab236b05ea7585c7e1f001ec	31479255	0x0000000000000000000000000000c51200000000000000000000000000000000	2023-06-18T07:12:20.000Z	0x000000000000000000000000000013b500000000000000000000000000000000	0x80b83cfc9953a8981d2438b7df069a5a1cb3089f06403ec88999d235f885ec61
0xd446eb1660f766d533beceef890df7a69d26f7d1	false	0xc96debd23d753557ab236b05ea7585c7e1f001ec	33	0x00000000000000000000000174adb35100000000000000000000000000000000	8376003	0xc96debd23d753557ab236b05ea7585c7e1f001ec	31479353	0x00000000000000000000000000007a1f00000000000000000000000000000000	2023-06-18T07:15:37.000Z	0x00000000000000000000000000000c3600000000000000000000000000000000	0xac032f8ccf1cf334a29d78631b5e37336ed5212ba8ef32c0bf5e98121dd507d8

Example Query

Query with partition filter

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

LBPairV2_StaticFeeParametersSet_event

Fee parameter configuration events from Trader Joe V2 Liquidity Book pairs on Avalanche. Captures updates to static fee settings including base factors, protocol share, volatility controls, and decay periods for analyzing liquidity pool fee structures.

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
0x978631c704bd0863343c975388c1f16886aba892	false	0x8e42f2f4101563bf679975178e880fd87d3efd4e	5	29777775	8000	1200	2023-05-09T02:13:56.000Z	120	2500	0xf855b6bca882ecb47c6a3adc8806d167ec99d65d8f69ac14eb478ff2a3540ff2	5000	10000	250000
0x20b32e09359179ec53969f10646142dc2816764c	false	0x8e42f2f4101563bf679975178e880fd87d3efd4e	15	29794404	8000	1200	2023-05-09T11:36:53.000Z	300	2500	0xb4adcd0c8d7fb9923dc27e80e56c71c6a27f9ec03efb5a1d7b1fc79614b6d9cb	5000	7500	150000
0x784c003ea7940aafec91b87608c740440d734a9a	false	0x8e42f2f4101563bf679975178e880fd87d3efd4e	26	29805554	10000	600	2023-05-09T17:52:58.000Z	30	2000	0x227b7ef2e84d028d3b4681df2db237b66e6125765bd8268c2b8c099bacbf9ba5	5000	15000	350000

Example Query

Query with partition filter

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

LBPairV2_Swap_event

Swap events from Trader Joe V2 Liquidity Book (LB) pairs containing swap direction, amounts exchanged, bin identifier, fee breakdown, and volatility accumulator. Used for DEX trading activity analysis and liquidity pool performance tracking.

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
8112282	0xc9ec57087138210a8cbbdd430d5763b94c6122b1	0x2f1da4bafd5f2508ec2e2e425036063a374993b6	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	12	28637563	0x00000000000000000000000009ccb13300000000000000000000000000000000	0x0000000000000000000000000000807300000000000000000000000000000000	0x000000000000000000000000000000000000000000000008e9a8b126f80c8c4c	2023-04-12T05:55:44.000Z	0x0000000000000000000000000000066c00000000000000000000000000000000	0x225f916179f682d58941a7f058480a1dba11b3d0cd8a56cf840b25fc10690d42
8112282	0xafb5ae9934266a131f44f2a80c783d6a827a3d1a	0x2f1da4bafd5f2508ec2e2e425036063a374993b6	false	0x6a68f261f8976559259d74a3494c19ee2bde0e4f	29	28637497	0x000000000000000000000000000f423600000000000000000000000000000000	0x000000000000000000000000000000c800000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000de0b4451af2e249	2023-04-12T05:53:27.000Z	0x0000000000000000000000000000000a00000000000000000000000000000000	0xb81a6f890ed783e7903ad8b7c3cfdb272b1d376d35702597eef70ea773eb2530
8112283	0xa25ff473d49217d8cef3b8f4112bb8b7a9367546	0x2f1da4bafd5f2508ec2e2e425036063a374993b6	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	19	28657533	0x0000000000000000000000005f04573e00000000000000000000000000000000	0x0000000000000000000000000004dd6c00000000000000000000000000000000	0x00000000000000000000000000000000000000000000005668cf1d79a9a43fba	2023-04-12T17:03:41.000Z	0x00000000000000000000000000003e4500000000000000000000000000000000	0x938cae919299a5f4ad9dee56aeec91f279078fee5b1e0c6f3a60379e969c2dec

Example Query

Query with partition filter

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

LBPairV2_TransferBatch_event

Batch liquidity position transfer events from Trader Joe V2 liquidity book (LBPair) contracts on Avalanche. Records minting and burning of multiple liquidity positions with bin IDs and amounts for analyzing liquidity provider activity.

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
0xb0ee4e11e1f7c3134e3d23e023c54ab5fa85235e	[“8362831”,“8362832”,“8362833”,“8362834”,“8362835”,“8362836”,“8362837”,“8362838”,“8362839”]	0x16396b65d5e0794c44447396f94665d3b9f576a0	0x0000000000000000000000000000000000000000	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	12	[“23447402188653097033684258193947486735080394”,“22665177986994131565874567588131657758814439”,“21884271268650136378829902110147769157952093”,“21102259540639577015114268904382497992213801”,“20319672942239229270060967682303496607877689”,“19539128946689751393823460086741938957459859”,“18756957260798293638636900526184634905843972”,“17974797181125309039325532328268665778870317”,“17190035595247320932931336620910780346978925”]	29216464	2023-04-25T19:43:38.000Z	0x0072ee6ca514639c6079b3be56ccb766edecce9db6bf233f55c37cad8c3fb743
0xb1bc6ba8449dfebbbfc0bcf121c76f3c952bad0c	[“8362855”,“8362856”,“8362857”,“8362858”,“8362859”,“8362860”,“8362861”,“8362862”,“8362863”,“8362864”,“8362865”]	0x16396b65d5e0794c44447396f94665d3b9f576a0	0x0000000000000000000000000000000000000000	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	29	[“40721214846896704039166499703709175387884920”,“40709551935933944491682427356744198626863726”,“40720722907200081457968399308402268686074309”,“40732696216283645929573854996297350493334443”,“40721221415368953119854382053431081872037055”,“40628358470216442949881670470482990213810037”,“40615053876591136714497345602411070382136123”,“40638521852462883141239499562363729766947218”,“40694048345077097308049681985345311865152940”,“40660589287923871208481197540913601381706213”,“40696877375989551609131030594471159168065644”]	29205434	2023-04-25T13:26:11.000Z	0xffe091c1dbea14e5b4665301912dcc5c5fbe53ce22bcfb54afc9a5c60ef82107
0x829abd0c0c5caf02459be9e8195c7a467b02cc47	[“8362861”]	0x16396b65d5e0794c44447396f94665d3b9f576a0	0x0000000000000000000000000000000000000000	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	20	[“2980724945273158774354936370132255039113026209”]	29204594	2023-04-25T12:57:58.000Z	0x4d58ffc229b88679712f5a7b276d860da2fae61be5d9d128f1f78aa1d756c48d

Example Query

Query with partition filter

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

LBPairV2_WithdrawnFromBins_event

Liquidity withdrawal events from TraderJoe V2 liquidity book pairs, recording removal of tokens from specific price bins. Contains sender address, recipient address, bin identifiers, and withdrawn token amounts for tracking liquidity position exits.

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
0x00020c6f6f9fa9b9c4b3dec3daf42a7d73e5882c	[“8388608”,“8388609”,“8388610”,“8388611”,“8388612”]	0x9b2cc8e6a2bbb56d6be4682891a91b0e48633c72	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	20	[“0x0000000000000000000000004530367800000000000000000000000000000000”,“0x0000000000000000000000003a22adf9000000000000000000000000213d98d6”,“0x000000000000000000000000000000000000000000000000000000006bef8101”,“0x00000000000000000000000000000000000000000000000000000000cc326821”,“0x00000000000000000000000000000000000000000000000000000000b27c24f8”]	32836158	2023-07-20T06:19:56.000Z	0xa123cfe640c48c563d746bdbd6f6dcc445cdcdeb0890a77b0f477b3473d89c5a
0x00e546cd1301809d5f49daba33e55e4067d417d4	[“8375195”,“8375196”,“8375197”,“8375198”,“8375199”,“8375200”,“8375201”,“8375202”,“8375203”,“8375204”,“8375205”,“8375206”,“8375207”,“8375208”,“8375209”,“8375210”,“8375211”,“8375212”,“8375213”,“8375214”,“8375215”,“8375216”,“8375217”,“8375218”,“8375219”,“8375220”,“8375221”,“8375222”,“8375223”,“8375224”,“8375225”,“8375226”,“8375227”,“8375228”,“8375229”,“8375230”,“8375231”,“8375232”,“8375233”,“8375234”,“8375235”,“8375236”,“8375237”,“8375238”,“8375239”,“8375240”,“8375241”,“8375242”,“8375243”,“8375244”,“8375245”,“8375246”,“8375247”,“8375248”,“8375249”,“8375250”,“8375251”,“8375252”,“8375253”]	0x51146e0bf2dcc368de6f5201fe7c427da28d05de	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	16	[“0x000000000000000000000000001d447a00000000000000000000000000000000”,“0x000000000000000000000000001c4abe00000000000000000000000000000000”,“0x000000000000000000000000001b510200000000000000000000000000000000”,“0x000000000000000000000000001a574600000000000000000000000000000000”,“0x00000000000000000000000000195d8900000000000000000000000000000000”,“0x000000000000000000000000001863cd00000000000000000000000000000000”,“0x000000000000000000000000001769db00000000000000000000000000000000”,“0x0000000000000000000000000016716e00000000000000000000000000000000”,“0x0000000000000000000000000015899000000000000000000000000000000000”,“0x0000000000000000000000000014a4b200000000000000000000000000000000”,“0x0000000000000000000000000013b57700000000000000000000000000000000”,“0x0000000000000000000000000012ba3d00000000000000000000000000000000”,“0x0000000000000000000000000011e7b200000000000000000000000000000000”,“0x0000000000000000000000000011392500000000000000000000000000000000”,“0x0000000000000000000000000009066d00000000000000000000ed9635a52142”,“0x0000000000000000000000000000000000000000000000000001ed76cb9f3a22”,“0x0000000000000000000000000000000000000000000000000001cd95e393ce9a”,“0x0000000000000000000000000000000000000000000000000001a4f06695c3e8”,“0x00000000000000000000000000000000000000000000000000017ddfe4ab6b4f”,“0x00000000000000000000000000000000000000000000000000015ec74de216ab”,“0x00000000000000000000000000000000000000000000000000013d65b9b2115f”,“0x00000000000000000000000000000000000000000000000000011d35ad715d95”,“0x0000000000000000000000000000000000000000000000000000fa6118cb4ae4”,“0x0000000000000000000000000000000000000000000000000000da7a290a9468”,“0x0000000000000000000000000000000000000000000000000000bcaa33678d3b”,“0x00000000000000000000000000000000000000000000000000009c2d8985d182”,“0x00000000000000000000000000000000000000000000000000007ccf46594378”,“0x00000000000000000000000000000000000000000000000000005d968f30c638”,“0x00000000000000000000000000000000000000000000000000003e24bea1468f”,“0x00000000000000000000000000000000000000000000000000003d2d0f26620f”,“0x00000000000000000000000000000000000000000000000000003c9d7430f73b”,“0x00000000000000000000000000000000000000000000000000005a81ea634893”,“0x0000000000000000000000000000000000000000000000000000789d63a68c69”,“0x000000000000000000000000000000000000000000000000000096ce9c33a97a”,“0x0000000000000000000000000000000000000000000000000000b504ea218d41”,“0x0000000000000000000000000000000000000000000000000000d26ad5b499ee”,“0x0000000000000000000000000000000000000000000000000000f04931517451”,“0x00000000000000000000000000000000000000000000000000010e52577ba2db”,“0x00000000000000000000000000000000000000000000000000012c5b7da5d166”,“0x00000000000000000000000000000000000000000000000000014a64a3cffff0”,“0x0000000000000000000000000000000000000000000000000001686dc9fa2e7a”,“0x00000000000000000000000000000000000000000000000000018676f0245d04”,“0x0000000000000000000000000000000000000000000000000001a480164e8b8e”,“0x0000000000000000000000000000000000000000000000000001c2893c78ba19”,“0x0000000000000000000000000000000000000000000000000001e09262a2e8a3”,“0x0000000000000000000000000000000000000000000000000001fe9b88cd172d”,“0x00000000000000000000000000000000000000000000000000021ca4aef745b7”,“0x00000000000000000000000000000000000000000000000000023aadd5217441”,“0x000000000000000000000000000000000000000000000000000258b6fb4ba2cc”,“0x000000000000000000000000000000000000000000000000000276c02175d156”,“0x000000000000000000000000000000000000000000000000000294c9479fffe0”,“0x0000000000000000000000000000000000000000000000000002b2d26dca2e6a”,“0x0000000000000000000000000000000000000000000000000002d0db93f45cf4”,“0x0000000000000000000000000000000000000000000000000002eee4ba1e8b7f”,“0x00000000000000000000000000000000000000000000000000030cede048ba08”,“0x00000000000000000000000000000000000000000000000000032af70672e893”,“0x000000000000000000000000000000000000000000000000000349002c9d171d”,“0x0000000000000000000000000000000000000000000000000003670952c745a7”,“0x0000000000000000000000000000000000000000000000000003851278f17432”]	32851885	2023-07-20T15:07:30.000Z	0x965bbcf3a27cc93bc17c5b61bf35407e5872d84ef6912194df6fbfe960359043
0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc	[“8376066”,“8376067”,“8376068”,“8376069”,“8376070”,“8376071”,“8376072”,“8376073”,“8376074”,“8376075”,“8376076”,“8376077”,“8376078”,“8376079”,“8376080”,“8376081”,“8376082”,“8376083”,“8376084”,“8376085”,“8376086”,“8376087”,“8376088”,“8376089”,“8376090”,“8376091”,“8376092”,“8376093”,“8376094”,“8376095”,“8376096”,“8376097”,“8376098”,“8376099”,“8376100”,“8376101”,“8376102”,“8376103”,“8376104”,“8376105”,“8376106”,“8376107”,“8376108”,“8376109”,“8376110”,“8376111”,“8376112”,“8376113”,“8376114”,“8376115”,“8376116”]	0xd446eb1660f766d533beceef890df7a69d26f7d1	false	0x0ddba20fa3b247fb3381cde1a1fae35c032e33fc	25	[“0x0000000000000000000000000a2a981300000000000000000000000000000000”,“0x0000000000000000000000001455302600000000000000000000000000000000”,“0x0000000000000000000000001455302600000000000000000000000000000000”,“0x0000000000000000000000001455302600000000000000000000000000000000”,“0x0000000000000000000000001455302600000000000000000000000000000000”,“0x00000000000000000000000032d4f86100000000000000000000000000000000”,“0x00000000000000000000000032d4f86100000000000000000000000000000000”,“0x0000000000000000000000005154c09c00000000000000000000000000000000”,“0x0000000000000000000000005154c09c00000000000000000000000000000000”,“0x0000000000000000000000006fd488d700000000000000000000000000000000”,“0x0000000000000000000000008e54511200000000000000000000000000000000”,“0x0000000000000000000000008e54511200000000000000000000000000000000”,“0x000000000000000000000000acd4194d00000000000000000000000000000000”,“0x000000000000000000000000cb53e18800000000000000000000000000000000”,“0x000000000000000000000001085371fe00000000000000000000000000000000”,“0x00000000000000000000000126d33a3900000000000000000000000000000000”,“0x0000000000000000000000014553027400000000000000000000000000000000”,“0x000000000000000000000001825292ea00000000000000000000000000000000”,“0x000000000000000000000001bf52236000000000000000000000000000000000”,“0x000000000000000000000001ddd1eb9b00000000000000000000000000000000”,“0x0000000000000000000000021ad17c1100000000000000000000000000000000”,“0x0000000000000000000000023951444c00000000000000000000000000000000”,“0x00000000000000000000000257d10c8700000000000000000000000000000000”,“0x0000000000000000000000027844007200000000000000000000000000000000”,“0x000000000000000000000002789e999000000000000000000000000000000000”,“0x00000000000000000000000efdddda9a00000000000000000000000000000000”,“0x00000000000000000000000f10778c0a0000000000000003434fdf97c57d8701”,“0x0000000000000000000000000000000000000000000000f16141fa5c7d662de5”,“0x0000000000000000000000000000000000000000000000e17941b758a997e5ae”,“0x0000000000000000000000000000000000000000000000c1d40716e06dcfa0a7”,“0x0000000000000000000000000000000000000000000000a22ecc7668321fb72e”,“0x0000000000000000000000000000000000000000000000828991d5eff65f90ac”,“0x000000000000000000000000000000000000000000000062e4573577baa3fb54”,“0x00000000000000000000000000000000000000000000005311b9e53b9ccbc5a3”,“0x0000000000000000000000000000000000000000000000433f1c94ff7eebf356”,“0x00000000000000000000000000000000000000000000002399e1f4874333eb59”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000003f4a7540f0776d048”,“0x000000000000000000000000000000000000000000000001fa53aa0783bb6824”]	32857606	2023-07-20T18:20:08.000Z	0x25a6f714ea694e74a608b19cd08cc70ab4a57fd61b5a52b3abdf24aa8eea51ad

Example Query

Query with partition filter

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

LBPairV22_DepositedToBins_event

Liquidity deposit events from Trader Joe V2.2 liquidity book pairs on Avalanche, recording when liquidity providers add tokens to specific price bins. Used for analyzing liquidity provision patterns and bin-level liquidity distribution across concentrated liquidity pools.

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
0x17fdcf5ce6ead000aced290171bd6c38241a5342	[“8112231”,“8112232”,“8112233”,“8112234”,“8112235”,“8112236”,“8112237”,“8112238”,“8112239”,“8112240”,“8112241”,“8112242”,“8112243”,“8112244”,“8112245”,“8112246”,“8112247”,“8112248”,“8112249”,“8112250”,“8112251”,“8112252”,“8112253”,“8112254”,“8112255”,“8112256”,“8112257”,“8112258”,“8112259”,“8112260”,“8112261”,“8112262”,“8112263”,“8112264”,“8112265”,“8112266”,“8112267”,“8112268”,“8112269”,“8112270”,“8112271”,“8112272”,“8112273”,“8112274”,“8112275”,“8112276”,“8112277”,“8112278”,“8112279”,“8112280”,“8112281”]	0x934cf521743903d27e388d7e8517c636f3cc4d54	false	0x18556da13313f3532c54711497a8fedac273220e	6	[“0x000000000000000000000000005a84c200000000000000000000000000000000”,“0x000000000000000000000000009b930300000000000000000000000000000000”,“0x00000000000000000000000001058a3000000000000000000000000000000000”,“0x00000000000000000000000001ae119300000000000000000000000000000000”,“0x00000000000000000000000002b3bb5b00000000000000000000000000000000”,“0x000000000000000000000000044045d800000000000000000000000000000000”,“0x000000000000000000000000068ab3f400000000000000000000000000000000”,“0x00000000000000000000000009d8cbe700000000000000000000000000000000”,“0x0000000000000000000000000e7f667300000000000000000000000000000000”,“0x00000000000000000000000014e0e0bc00000000000000000000000000000000”,“0x0000000000000000000000001d69022b00000000000000000000000000000000”,“0x0000000000000000000000002885cc4800000000000000000000000000000000”,“0x000000000000000000000000369cfc4b00000000000000000000000000000000”,“0x00000000000000000000000047fe874400000000000000000000000000000000”,“0x0000000000000000000000005cd4ff8b00000000000000000000000000000000”,“0x000000000000000000000000751585ca00000000000000000000000000000000”,“0x0000000000000000000000009071853d00000000000000000000000000000000”,“0x000000000000000000000000ae4cd83500000000000000000000000000000000”,“0x000000000000000000000000cdbae75300000000000000000000000000000000”,“0x000000000000000000000000ed84c9ff00000000000000000000000000000000”,“0x0000000000000000000000010c395f9800000000000000000000000000000000”,“0x0000000000000000000000012846e43600000000000000000000000000000000”,“0x000000000000000000000001401be45700000000000000000000000000000000”,“0x000000000000000000000001524bf79100000000000000000000000000000000”,“0x0000000000000000000000015db3a6b100000000000000000000000000000000”,“0x000000000000000000000000b0cb4bac00000000000000a0e820ecb4fb5df433”,“0x00000000000000000000000000000000000000000000013e46d7846d77648a4d”,“0x000000000000000000000000000000000000000000000133e5870f67c5e7a194”,“0x00000000000000000000000000000000000000000000012357dbc75b60a16c71”,“0x00000000000000000000000000000000000000000000010da71bc6a7875189eb”,“0x0000000000000000000000000000000000000000000000f41ef057698e460df0”,“0x0000000000000000000000000000000000000000000000d82cb9b239e53bfbf9”,“0x0000000000000000000000000000000000000000000000bb3e2138ee1b7d231b”,“0x00000000000000000000000000000000000000000000009ea31bdb8415127c65”,“0x00000000000000000000000000000000000000000000008376a1d11e85c4712f”,“0x00000000000000000000000000000000000000000000006a9007bd892bfdb50e”,“0x0000000000000000000000000000000000000000000000547d6b2e972e82b993”,“0x00000000000000000000000000000000000000000000004186512a37db12a1b3”,“0x000000000000000000000000000000000000000000000031b49ee987edcad3c3”,“0x000000000000000000000000000000000000000000000024e1956d16efcb8f66”,“0x00000000000000000000000000000000000000000000001ac46f0c35b6b78164”,“0x000000000000000000000000000000000000000000000013009309eeaca2b750”,“0x00000000000000000000000000000000000000000000000d31e288eeeec386fd”,“0x000000000000000000000000000000000000000000000008f6458dddc70526de”,“0x000000000000000000000000000000000000000000000005f435cbed68c67b79”,“0x000000000000000000000000000000000000000000000003de7a6040dc449820”,“0x000000000000000000000000000000000000000000000002759239a45af6f7b2”,“0x000000000000000000000000000000000000000000000001876bf17da1264146”,“0x000000000000000000000000000000000000000000000000ee098673926fd017”,“0x0000000000000000000000000000000000000000000000008d98105024c06a5e”,“0x00000000000000000000000000000000000000000000000052626659b48c5ed0”]	47838432	2024-07-11T15:39:05.000Z	0x242f95f18d643f647953d077c98f39e0a9e3d32f8e5fb4b2deba2d6a4736d3de
0x8f5d6b58850fa1acfb20ca982636ffd821c712c9	[“8112252”,“8112253”,“8112254”,“8112255”,“8112256”,“8112257”,“8112258”,“8112259”,“8112260”,“8112261”]	0x934cf521743903d27e388d7e8517c636f3cc4d54	false	0x18556da13313f3532c54711497a8fedac273220e	22	[“0x0000000000000000000000000108dd2200000000000000000000000000000000”,“0x000000000000000000000000031b5a9a00000000000000000000000000000000”,“0x00000000000000000000000006d0738a00000000000000000000000000000000”,“0x0000000000000000000000000aea96bc00000000000000000000000000000000”,“0x0000000000000000000000000662f5f300000000000000020bcf7578fcf2b5b2”,“0x000000000000000000000000000000000000000000000003b36c0d6f3871e7f7”,“0x000000000000000000000000000000000000000000000002bcbf6bb78608dd16”,“0x000000000000000000000000000000000000000000000001a7e53933c03e58ac”,“0x000000000000000000000000000000000000000000000000d1b7a90e9c776e47”,“0x00000000000000000000000000000000000000000000000054db76dedd33a733”]	47847099	2024-07-11T20:35:02.000Z	0x596128450037c78ecf82d3c708ef7a34edb7b44f50ce410eed2b994b6509515c
0x97dc90f0ac367b2d41a942f4887b054f6151a2ec	[“8112254”,“8112255”,“8112256”,“8112257”,“8112258”]	0x934cf521743903d27e388d7e8517c636f3cc4d54	false	0x18556da13313f3532c54711497a8fedac273220e	123	[“0x00000000000000000000000007ce11a500000000000000000000000000000000”,“0x00000000000000000000000007ce11a500000000000000000000000000000000”,“0x00000000000000000000000003e708ba000000000000000191be6a1fe722ff40”,“0x000000000000000000000000000000000000000000000003237cd43fce45fe80”,“0x000000000000000000000000000000000000000000000003237cd43fce45fe80”]	47838813	2024-07-11T15:52:00.000Z	0xac53f420ddecb0aa6f6d3c09d6a7f6f8a15c19b88c3a1dd69a6702939a0d1ad3

Example Query

Query with partition filter

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

LBPairV22_Swap_event

Swap events from Trader Joe V2.2 liquidity book pairs on Avalanche, capturing token exchanges with input/output amounts, fees, bin IDs, and volatility metrics. Used for analyzing DEX trading patterns, fee collection, and liquidity utilization across concentrated liquidity positions.

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
8378016	0x0249e0913088525154dbcf96466a068894054fb6	0x4548a429c91505eca33a5f7f3807132f39ab2459	false	0x18556da13313f3532c54711497a8fedac273220e	22	46978930	0x0000000000000000000000000000000000000000000000015fc728a491ab555f	0x00000000000000000000000000000000000000000000000000ec1e5067c6b525	0x00000000000000000000000004ed379d00000000000000000000000000000000	2024-06-21T02:38:07.000Z	0x000000000000000000000000000000000000000000000000002f394347f48aa1	0xd63bb3e5177c471390def535a8191ecc473ff91669ec4fd8a5b6fe6583f74bd2	35860
8378006	0x035d10e2ae3406fdd145d59d63ff2aa57870e189	0x4548a429c91505eca33a5f7f3807132f39ab2459	false	0x18556da13313f3532c54711497a8fedac273220e	22	47001029	0x000000000000000000000000000000000000000000000000131e96f4ab5bbffc	0x000000000000000000000000000000000000000000000000000c55052c40b155	0x0000000000000000000000000042dd1100000000000000000000000000000000	2024-06-21T15:10:57.000Z	0x000000000000000000000000000000000000000000000000000277676f402377	0x6c89ac3fe60b7c3c26223db7b4be0cd32764f1f384aff2dc28b9f656d1de2487	13960
8377995	0x0823e6affade2dda8fa4355a414361c9e1c0edfd	0x4548a429c91505eca33a5f7f3807132f39ab2459	false	0x18556da13313f3532c54711497a8fedac273220e	14	46991320	0x00000000000000000000000000000000000000000000000068400c742c24c1df	0x00000000000000000000000000000000000000000000000000632ad7ef9aa11f	0x00000000000000000000000001625c3e00000000000000000000000000000000	2024-06-21T09:41:59.000Z	0x0000000000000000000000000000000000000000000000000013d55e631eed06	0x04840ee6472dc93d1b915655f29196167ef6ef1bfccaab0e28f6e4c2ef98c365	113750

Example Query

Query with partition filter

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

LBPairV22_WithdrawnFromBins_event

Liquidity withdrawal events from Trader Joe V2.2 Liquidity Book (LB) pairs on Avalanche, recording bin IDs and token amounts removed by liquidity providers. Used for tracking LP position exits and liquidity depth changes across price bins.

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
0x8b88064db1595e37fded18102dff6933a8b6ee90	[“8377940”,“8377941”,“8377942”,“8377943”,“8377944”,“8377945”,“8377946”,“8377947”,“8377948”,“8377949”,“8377950”,“8377951”,“8377952”,“8377953”,“8377954”,“8377956”,“8377957”,“8377958”,“8377959”,“8377960”,“8377961”,“8377962”,“8377963”,“8377964”,“8377965”,“8377966”,“8377967”,“8377968”,“8377969”,“8377970”,“8377971”,“8377972”,“8377973”,“8377974”,“8377975”,“8377976”,“8377977”,“8377978”,“8377979”,“8377980”,“8377981”,“8377982”,“8377983”,“8377984”,“8377985”,“8377986”,“8377987”,“8377988”,“8377989”,“8377990”,“8377991”,“8377992”,“8377993”,“8377994”,“8377995”,“8377996”,“8377997”,“8377998”,“8377999”,“8378000”,“8378001”,“8378002”,“8378003”,“8378004”,“8378005”,“8378006”,“8378007”,“8378008”,“8378009”,“8378010”,“8378011”,“8378012”,“8378013”,“8378014”,“8378015”,“8378016”,“8378017”,“8378018”,“8378019”,“8378020”,“8378021”,“8378022”,“8378023”,“8378024”,“8378025”,“8378026”,“8378027”,“8378028”,“8378029”,“8378030”,“8378031”,“8378032”,“8378033”,“8378034”,“8378035”,“8378036”,“8378037”,“8378038”,“8378039”,“8378040”,“8378041”,“8378042”,“8378043”,“8378044”,“8378045”,“8378046”,“8378047”,“8378048”,“8378049”,“8378050”,“8378051”,“8378052”,“8378053”,“8378054”,“8378055”,“8378056”,“8378057”,“8378058”,“8378059”,“8378060”,“8378061”,“8378062”,“8378063”,“8378064”,“8378065”,“8378066”,“8378067”,“8378068”,“8378069”,“8378070”,“8378071”,“8378072”,“8378073”,“8378074”,“8378075”,“8378076”,“8378077”,“8378078”,“8378079”,“8378080”,“8378081”,“8378082”,“8378083”,“8378084”,“8378085”,“8378086”,“8378087”,“8378088”,“8378089”,“8378090”,“8378091”,“8378092”,“8378093”,“8378094”,“8378095”,“8378096”,“8378097”,“8378098”,“8378099”,“8378100”,“8378101”,“8378102”,“8378103”,“8378104”,“8378105”,“8378106”,“8378107”,“8378108”,“8378109”,“8378110”,“8378111”,“8378112”,“8378113”,“8378114”,“8378115”,“8378116”,“8378117”,“8378118”,“8378119”,“8378120”,“8378121”,“8378122”,“8378123”,“8378124”,“8378125”,“8378126”,“8378127”,“8378128”,“8378129”,“8378130”,“8378131”,“8378132”,“8378133”,“8378134”,“8378135”,“8378136”,“8378137”,“8378138”,“8378139”,“8378140”]	0x4548a429c91505eca33a5f7f3807132f39ab2459	false	0x18556da13313f3532c54711497a8fedac273220e	1	[“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ab00000000000000000000000000000000”,“0x000000000000000000000000002635ab00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ab00000000000000000000000000000000”,“0x000000000000000000000000002635ab00000000000000000000000000000000”,“0x000000000000000000000000002635ab00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ab00000000000000000000000000000000”,“0x000000000000000000000000002635ab00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x000000000000000000000000002635ac00000000000000000000000000000000”,“0x00000000000000000000000000266b6a00000000000000000000000000000000”,“0x0000000000000000000000000026802900000000000000000000000000000000”,“0x0000000000000000000000000026bed400000000000000000000000000000000”,“0x0000000000000000000000000026cf8c00000000000000000000000000000000”,“0x0000000000000000000000000026bc8700000000000000000000000000000000”,“0x0000000000000000000000000026c23700000000000000000000000000000000”,“0x0000000000000000000000000026ea2100000000000000000000000000000000”,“0x000000000000000000000000002728d900000000000000000000000000000000”,“0x000000000000000000000000002709d500000000000000000000000000000000”,“0x00000000000000000000000000275bf800000000000000000000000000000000”,“0x00000000000000000000000000277fde00000000000000000000000000000000”,“0x00000000000000000000000000280e3600000000000000000000000000000000”,“0x0000000000000000000000000027ea7c00000000000000000000000000000000”,“0x0000000000000000000000000028954b00000000000000000000dba9686e79f2”,“0x00000000000000000000000000000000000000000000000009e41fcb4e2ebea3”,“0x00000000000000000000000000000000000000000000000009e626b67a089be6”,“0x00000000000000000000000000000000000000000000000009cef43fe5e86cd1”,“0x00000000000000000000000000000000000000000000000009db99508e313a75”,“0x00000000000000000000000000000000000000000000000024bda448c78094e1”,“0x0000000000000000000000000000000000000000000000003fb7e36a8c9fa155”,“0x0000000000000000000000000000000000000000000000004023b3b8acdab58a”,“0x00000000000000000000000000000000000000000000000040085a6c35ee3d03”,“0x0000000000000000000000000000000000000000000000003fd3aba73a1acb7f”,“0x0000000000000000000000000000000000000000000000003fd1c054bc174f00”,“0x00000000000000000000000000000000000000000000000040613c87ea05cdf2”,“0x0000000000000000000000000000000000000000000000003ffcbee5baf47915”,“0x0000000000000000000000000000000000000000000000003f3434a418f99d63”,“0x0000000000000000000000000000000000000000000000003f3878bd6b3016c2”,“0x000000000000000000000000000000000000000000000000401af49bd373ef49”,“0x0000000000000000000000000000000000000000000000003fddf170583cb9c6”,“0x0000000000000000000000000000000000000000000000003f78e1ce782babf0”,“0x0000000000000000000000000000000000000000000000003f7fb948cb4176ea”,“0x0000000000000000000000000000000000000000000000003ed508e98b5663c8”,“0x0000000000000000000000000000000000000000000000003ea6ed92e40849ec”,“0x0000000000000000000000000000000000000000000000003ea7c981a2fa39b0”,“0x0000000000000000000000000000000000000000000000003e6a389661852a9c”,“0x0000000000000000000000000000000000000000000000003ea35763559780c9”,“0x0000000000000000000000000000000000000000000000003e8deff86ce87811”,“0x0000000000000000000000000000000000000000000000003ea8e95438480521”,“0x0000000000000000000000000000000000000000000000003ee754139be4597b”,“0x0000000000000000000000000000000000000000000000003eb02dcf505e94cf”,“0x0000000000000000000000000000000000000000000000003e9eced7eb5f3087”,“0x0000000000000000000000000000000000000000000000003e92f9654b7a9e6b”,“0x0000000000000000000000000000000000000000000000003e8f52f70b2492ac”,“0x0000000000000000000000000000000000000000000000003e50f15a51bcee5d”,“0x0000000000000000000000000000000000000000000000003e2ccda28e1049a6”,“0x0000000000000000000000000000000000000000000000003e59f914ea05253e”,“0x0000000000000000000000000000000000000000000000003def35e64ef14f94”,“0x0000000000000000000000000000000000000000000000003d5c116fa6a60dc5”,“0x0000000000000000000000000000000000000000000000003d050cf631bdfe39”,“0x0000000000000000000000000000000000000000000000003d048f42d3e00531”,“0x0000000000000000000000000000000000000000000000003d89c4b87745465a”,“0x0000000000000000000000000000000000000000000000003db5863e1fd120ab”,“0x0000000000000000000000000000000000000000000000003d43ee7543a2b2da”,“0x0000000000000000000000000000000000000000000000003cf71648acec51cf”,“0x0000000000000000000000000000000000000000000000003cd65e61d459e197”,“0x0000000000000000000000000000000000000000000000003c6b415ba63bba4b”,“0x0000000000000000000000000000000000000000000000003c5ebe2150182fae”,“0x0000000000000000000000000000000000000000000000003c40a6dd5ff6b47a”,“0x0000000000000000000000000000000000000000000000003c4380e58b8729f5”,“0x0000000000000000000000000000000000000000000000003c6b0af93c56fa33”,“0x0000000000000000000000000000000000000000000000003cbb9a219f7fbb1f”,“0x0000000000000000000000000000000000000000000000003cdac35633dd694a”,“0x0000000000000000000000000000000000000000000000003d1157952dc2846a”,“0x0000000000000000000000000000000000000000000000003cf9e30baedd2f86”,“0x0000000000000000000000000000000000000000000000003ce5b77e00eab18f”,“0x0000000000000000000000000000000000000000000000003cc615e91673dd92”,“0x0000000000000000000000000000000000000000000000003cd4dafeda89d016”,“0x0000000000000000000000000000000000000000000000003cbf24c5e6903377”,“0x0000000000000000000000000000000000000000000000003c8bf3e970b609b0”,“0x0000000000000000000000000000000000000000000000003c86a1a6ccaf24d9”,“0x0000000000000000000000000000000000000000000000003c83938d2f427fe1”,“0x0000000000000000000000000000000000000000000000003cbed62976e137bb”,“0x0000000000000000000000000000000000000000000000003cd35bca232b4e34”,“0x0000000000000000000000000000000000000000000000003cbe1e2f6221838b”,“0x0000000000000000000000000000000000000000000000003cfc8eca1a388dd0”,“0x0000000000000000000000000000000000000000000000003d702fbd578d5cf7”,“0x0000000000000000000000000000000000000000000000003d91de337194ca79”,“0x0000000000000000000000000000000000000000000000003dc2346e9f25202a”,“0x0000000000000000000000000000000000000000000000003d7d2c4da1eb3268”,“0x0000000000000000000000000000000000000000000000003d22200173b8689b”,“0x0000000000000000000000000000000000000000000000003cf424da8b814523”,“0x0000000000000000000000000000000000000000000000003ce90dc37463ca35”]	47946097	2024-07-14T06:08:05.000Z	0x46c4735f1a89d9afe683d66459d1815a2d5356be42d3c813693c8150ceb35069
0x8b88064db1595e37fded18102dff6933a8b6ee90	[“8377955”]	0x4548a429c91505eca33a5f7f3807132f39ab2459	false	0x18556da13313f3532c54711497a8fedac273220e	7	[“0x000000000000000000000000002635ac00000000000000000000000000000000”]	47946021	2024-07-14T06:05:19.000Z	0x08803c2c3af42f643be30619a1c96eb5fd6a9fad5cf50983bfc419fcd52ad021
0xc368b7a71a5ce4ef4e702f3ef1ebdbd66f65ed64	[“8378040”,“8378041”,“8378042”,“8378043”,“8378044”,“8378045”,“8378046”,“8378047”,“8378048”,“8378049”,“8378050”,“8378051”,“8378052”,“8378053”,“8378054”,“8378055”,“8378056”,“8378057”,“8378058”,“8378059”,“8378060”,“8378061”,“8378062”,“8378063”,“8378064”,“8378065”,“8378066”,“8378067”,“8378068”,“8378069”,“8378070”,“8378071”,“8378072”,“8378073”,“8378074”,“8378075”,“8378076”,“8378077”,“8378078”,“8378079”,“8378080”,“8378081”,“8378082”,“8378083”,“8378084”,“8378085”,“8378086”,“8378087”,“8378088”,“8378089”,“8378090”]	0x4548a429c91505eca33a5f7f3807132f39ab2459	false	0x18556da13313f3532c54711497a8fedac273220e	2	[“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f2815400000000000000000000000000000000”,“0x00000000000000000000000007f8583000000000000000000000000000000000”,“0x000000000000000000000000080ecb0f00000000000000000000000000000000”,“0x0000000000000000000000000815cad100000000000000000000000000000000”,“0x000000000000000000000000083efc8e00000000000000000000000000000000”,“0x0000000000000000000000000862a08400000000000000000000000000000000”,“0x000000000000000000000000086110c700000000000000000000000000000000”,“0x0000000000000000000000000866be9f00000000000000000000000000000000”,“0x000000000000000000000000086941df00000000000000000000000000000000”,“0x0000000000000000000000000863c73800000000000000000000000000000000”,“0x0000000000000000000000000858f39900000000000000000000000000000000”,“0x000000000000000000000000085ca3f300000000000000000000000000000000”,“0x000000000000000000000000086abc0200000000000000000000000000000000”,“0x000000000000000000000000086b62fd00000000000000000000000000000000”,“0x00000000000000000000000008756eee00000000000000000000000000000000”,“0x00000000000000000000000007e71b95000000000000000024970dc3bf0ce362”,“0x00000000000000000000000000000000000000000000000206a7d7f51665c8d4”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”,“0x0000000000000000000000000000000000000000000000020503fff2ca8d7a11”]	47970697	2024-07-14T20:23:03.000Z	0x8d9cc90fb4af11ab60de14c3b5dcf321ef276de79aba9a2aed96e8e8e741ba10

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LBFactory_FeeParametersSet_event

LBFactory_FeeRecipientSet_event

LBFactory_FlashLoanFeeSet_event

LBFactory_LBPairCreated_event

LBFactoryV2_FeeRecipientSet_event

LBFactoryV2_FlashLoanFeeSet_event

LBFactoryV2_LBPairCreated_event

LBFactoryV22_LBPairCreated_event

LBPair_CompositionFee_event

LBPair_DepositedToBin_event

LBPair_FeesCollected_event

LBPair_FlashLoan_event

LBPair_Swap_event

LBPair_TransferBatch_event

LBPair_TransferSingle_event

LBPair_WithdrawnFromBin_event

LBPairV2_CollectedProtocolFees_event

LBPairV2_CompositionFees_event

LBPairV2_DepositedToBins_event

LBPairV2_FlashLoan_event

LBPairV2_StaticFeeParametersSet_event

LBPairV2_Swap_event

LBPairV2_TransferBatch_event

LBPairV2_WithdrawnFromBins_event

LBPairV22_DepositedToBins_event

LBPairV22_Swap_event

LBPairV22_WithdrawnFromBins_event

​Tables

​LBFactory_FeeParametersSet_event

​LBFactory_FeeRecipientSet_event

​LBFactory_FlashLoanFeeSet_event

​LBFactory_LBPairCreated_event

​LBFactoryV2_FeeRecipientSet_event

​LBFactoryV2_FlashLoanFeeSet_event

​LBFactoryV2_LBPairCreated_event

​LBFactoryV22_LBPairCreated_event

​LBPair_CompositionFee_event

​LBPair_DepositedToBin_event

​LBPair_FeesCollected_event

​LBPair_FlashLoan_event

​LBPair_Swap_event

​LBPair_TransferBatch_event

​LBPair_TransferSingle_event

​LBPair_WithdrawnFromBin_event

​LBPairV2_CollectedProtocolFees_event

​LBPairV2_CompositionFees_event

​LBPairV2_DepositedToBins_event

​LBPairV2_FlashLoan_event

​LBPairV2_StaticFeeParametersSet_event

​LBPairV2_Swap_event

​LBPairV2_TransferBatch_event

​LBPairV2_WithdrawnFromBins_event

​LBPairV22_DepositedToBins_event

​LBPairV22_Swap_event

​LBPairV22_WithdrawnFromBins_event

Tables

LBFactory_FeeParametersSet_event

LBFactory_FeeRecipientSet_event

LBFactory_FlashLoanFeeSet_event

LBFactory_LBPairCreated_event

LBFactoryV2_FeeRecipientSet_event

LBFactoryV2_FlashLoanFeeSet_event

LBFactoryV2_LBPairCreated_event

LBFactoryV22_LBPairCreated_event

LBPair_CompositionFee_event

LBPair_DepositedToBin_event

LBPair_FeesCollected_event

LBPair_FlashLoan_event

LBPair_Swap_event

LBPair_TransferBatch_event

LBPair_TransferSingle_event

LBPair_WithdrawnFromBin_event

LBPairV2_CollectedProtocolFees_event

LBPairV2_CompositionFees_event

LBPairV2_DepositedToBins_event

LBPairV2_FlashLoan_event

LBPairV2_StaticFeeParametersSet_event

LBPairV2_Swap_event

LBPairV2_TransferBatch_event

LBPairV2_WithdrawnFromBins_event

LBPairV22_DepositedToBins_event

LBPairV22_Swap_event

LBPairV22_WithdrawnFromBins_event