traderjoe_v2_arbitrum

Tables

LBFactory_FeeParametersSet_event

Fee parameter configuration events from Trader Joe V2 Liquidity Book (LB) factory on Arbitrum. Tracks dynamic fee settings for individual liquidity pairs including bin step, base factor, volatility controls, and protocol share adjustments.

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 parameter for the liquidity bin pair’s dynamic fee calculation. Controls fee sensitivity to price movements, with higher values allowing greater fee adjustments based on market volatility.

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
0x1886d09c9ade0c5db822d85d21678db67b6c2982	false	0xcba0b8384adfddf2fa4b99b29f0145e8979beb29	0xf1ec4e41b49582af7e00d6525af78111f37b94a8	3	100	66171462	8000	1200	2023-03-02T20:55:37.000Z	300	0xa429a2e18b82a5c985ca92e2332afea143916a5316d5e2b149bc74becb1240bb	5000	7500	150000
0x1886d09c9ade0c5db822d85d21678db67b6c2982	false	0xcca7bc4c85736339ecacdb6f55a077cba6db255e	0xf1ec4e41b49582af7e00d6525af78111f37b94a8	3	100	64508096	8000	1200	2023-02-25T17:45:39.000Z	300	0x330c39254fadab9280a9da41d6e465abacc665b236546696728ed0012fb5048c	5000	7500	150000
0x1886d09c9ade0c5db822d85d21678db67b6c2982	false	0xba7c96e66f7808699f47c364e388272f95a8bfa8	0xf1ec4e41b49582af7e00d6525af78111f37b94a8	6	25	73226239	10000	600	2023-03-24T15:47:23.000Z	30	0x602eb3fd226d9b988c8e67cabc8dabe283117084f19be2a902eeab3101f4a3c3	5000	15000	350000

Example Query

Query with partition filter

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

LBFactory_LBPairCreated_event

Liquidity Book (LB) pair creation events from Trader Joe v2 DEX (Decentralized Exchange) on Arbitrum, recording new token pair pools with their bin step parameters and pool identifiers. Used for tracking pool deployments and analyzing market expansion activity.

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
8	0x1886d09c9ade0c5db822d85d21678db67b6c2982	false	0xa14dbce13c22c97fd99daa0de3b1b480c7c3fdf6	0x6c2c06790b3e3e3c38e12ee22f8183b37a13ee55	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	3	20	52327456	2023-01-11T14:55:50.000Z	0x294ef4c85b51d713d8ca082324d68b88771ded06882cf23f2eb0088363760b55
9	0x1886d09c9ade0c5db822d85d21678db67b6c2982	false	0xc710ab0e740b40c3b1ad5d6d8b22f8bcb7473749	0x18c11fd286c5ec11c3b683caa813b77f5163a122	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	6	25	52327456	2023-01-11T14:55:50.000Z	0x294ef4c85b51d713d8ca082324d68b88771ded06882cf23f2eb0088363760b55
10	0x1886d09c9ade0c5db822d85d21678db67b6c2982	false	0x5d5b29301936f0c8af52425efc2bc5330c73956d	0x32eb7902d4134bf98a28b963d26de779af92a212	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	9	25	52327456	2023-01-11T14:55:50.000Z	0x294ef4c85b51d713d8ca082324d68b88771ded06882cf23f2eb0088363760b55

Example Query

Query with partition filter

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

LBFactoryV2_FeeRecipientSet_event

Fee recipient configuration changes from Trader Joe V2 Liquidity Book (LB) factory contract on Arbitrum. Tracks historical updates to protocol fee collection addresses for analyzing fee distribution governance and treasury management.

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	1	77473199	2023-04-06T01:15:41.000Z	0xc8fc59fceb8259534d8b10879273879eddf7eec0	0x0000000000000000000000000000000000000000	0xe6826a136ea7e84573ff9c849e9e856a9c52fe7177e733ccf0b874036f93709d
0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	38	89350950	2023-05-10T19:02:55.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0xc8fc59fceb8259534d8b10879273879eddf7eec0	0x32a5ef2a18109120923e814d3f36589240cab6d88c465eee8a13ead043d3dc77

Example Query

Query with partition filter

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

LBFactoryV2_FlashLoanFeeSet_event

Flash loan fee configuration changes for Trader Joe V2 liquidity book pools on Arbitrum. Records old and new fee values (in basis points) when protocol administrators update flash loan parameters.

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	2	77473199	2023-04-06T01:15:41.000Z	0xe6826a136ea7e84573ff9c849e9e856a9c52fe7177e733ccf0b874036f93709d	5000000000000	0

Example Query

Query with partition filter

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

LBFactoryV2_LBPairCreated_event

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

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
518	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0x86c0bfc14ca1c1c508e420d734c9c60b74eb38bc	0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	1	25	213678732	2024-05-21T23:06:12.000Z	0x456d7657f714309cd9bb1b5bc240fe2f15c25dce6ef080bb693315272b687773
92	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0x02badf2553062eb030d87f7c23b88a74786c32a9	0x10a625d21bbb6ae379b2b402d9907dcb9fe1700d	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1	100	85374531	2023-04-29T03:28:37.000Z	0xcd8ce81aaa24cb9652dbed9a1c3da47fc718576bd92c20d8641e077e648852b7
384	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0x717061dd4d3b3c184bba14c58660f9bfa430aecc	0x87aaffdf26c6885f6010219208d5b161ec7609c0	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1	100	150120208	2023-11-13T21:29:54.000Z	0x26be4fe024a4a9a7e58964b93d388f2e2f413a615ecddb6565b5a2045870d603

Example Query

Query with partition filter

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

LBFactoryV22_LBPairCreated_event

Liquidity book pair creation events from Trader Joe V2.2 factory contract on Arbitrum, recording new trading pool deployments with token pairs, bin step (price granularity), and pool addresses. Used for tracking V2 liquidity pool launches and identifying new trading pairs with their binStep parameters.

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
86	0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c	false	0xf82b333757f756d22b7a41687c4dac08f6b05920	0xc760f9782f8cea5b06d862574464729537159966	0xaf88d065e77c8cc2239327c5edb3a432268e5831	37	100	276280565	2024-11-20T01:13:17.000Z	0x43fc8991689e11b06cb824c14a05effe089aa0522acd95061200126e267ef86b
67	0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c	false	0xabef47f6d27c1edf3c89310a29920a142e054030	0xaaa6c1e32c55a7bfa8066a6fae9b42650f262418	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	3	100	240124486	2024-08-06T19:02:47.000Z	0x83ce9f6f037fcaffae48c9414d29a2165dfd6412c58840dfc79a7054d306ec9c
65	0xb43120c4745967fa9b93e79c149e66b0f2d6fe0c	false	0xe8a2aa0dd8fc4771cb29d69e6e32ad8ae1ce06cd	0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	4	25	237565409	2024-07-30T08:28:37.000Z	0x8730c579d9dd9a21f07b8750682e3ae4d0623fd9dfe3b4609622cf1d38001e57

Example Query

Query with partition filter

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

LBPair_CompositionFee_event

Fee composition events from Trader Joe V2 liquidity book (LB) pairs on Arbitrum, tracking accumulated trading fees in both X and Y tokens per bin ID. Used to analyze fee distribution patterns and liquidity provider earnings across price bins.

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 fees collected in token X for a specific liquidity bin on Trader Joe v2. Denominated in the smallest unit of token X, typically representing protocol or LP fees from trades within that bin.
`in_feesY`	`STRING`	Amount of composition fees collected in token Y from this liquidity bin. Denominated in the smallest unit of token Y (e.g., wei for ETH), with values often zero when fees accrue only to token X.

Sample Data

in_id	address	removed	in_feesX	in_feesY	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
8375115	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	0	2571	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	14	63226496	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	2023-02-21T21:43:48.000Z	0x48b6f9c01754f1a1afb89180ebecb4d600e7c438c21076e4c015574f925fbc7d
8375115	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	0	1	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	16	63236236	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	2023-02-21T22:27:05.000Z	0x8a2a8c4a8039e4fb61d82198713b90f25758289d25732d04488be88469504db6
8375115	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	95355	0	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	12	63226912	0x23cb90f8143260a9c4933e1ccf9965a6f0464f26	2023-02-21T21:45:38.000Z	0x36df1f04a1f6d9a89fd18fe9284870ac1d7a4559fbf7a6a68d2ffb40d7743482

Example Query

Query with partition filter

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

LBPair_DepositedToBin_event

Liquidity deposit events for Trader Joe V2 liquidity book (LB) pairs on Arbitrum, recording tokenX and tokenY amounts added to specific price bins. Used for tracking liquidity provider positions and analyzing concentrated liquidity distribution across the V2 AMM’s discrete price ranges.

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
8380631	0x021352af332c70817e25a47578a8f0d8c0fa9210	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	66	1246009174196844151	51715073	0xb39f5c87e06c201a03a8b1bf9641217c31d8de57	2023-01-08T23:53:57.000Z	0xe7b640884c87046ffcfa7778d0a977885c594574091d4331aab1ae1c1696d25d
8380623	0x021352af332c70817e25a47578a8f0d8c0fa9210	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	50	6230045870984220756	51715073	0xb39f5c87e06c201a03a8b1bf9641217c31d8de57	2023-01-08T23:53:57.000Z	0xe7b640884c87046ffcfa7778d0a977885c594574091d4331aab1ae1c1696d25d
8380629	0x021352af332c70817e25a47578a8f0d8c0fa9210	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	62	1869013761295266227	51715073	0xb39f5c87e06c201a03a8b1bf9641217c31d8de57	2023-01-08T23:53:57.000Z	0xe7b640884c87046ffcfa7778d0a977885c594574091d4331aab1ae1c1696d25d

Example Query

Query with partition filter

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

LBPair_FeesCollected_event

Fee collection events from Trader Joe V2 liquidity book (LB) pairs on Arbitrum, recording tokenX and tokenY fee amounts claimed by liquidity providers. Used to analyze LP profitability and protocol fee generation across different trading pairs.

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
0x5fbbef48ce0850e5a73bc3f4a6e903458b3c0af4	false	0x1404d2065a601cbdc19b58cf2d53664f500800dc	0	57345368	0x1404d2065a601cbdc19b58cf2d53664f500800dc	2023-02-02T05:50:47.000Z	0xb3d45498f7cad3a3a1f31962a5d68e5ab869d2520cc74124a72a0e66be3a8e62
0xa51ee8b744e6cc1f2ac12b9eeaae8deb27619c6b	false	0x12cabba173f96b53cecf19274e6d66e2ed7a9bc4	0	57525999	0xdb7995a2cf3e443ccc2799fae91bc9cdc9c84aef	2023-02-02T21:07:55.000Z	0x36b7657bfc150e2cb52fa26ee125b844a010fd2b95d9faf295aefe2201500e3e
0xa51ee8b744e6cc1f2ac12b9eeaae8deb27619c6b	false	0x93701e77dd84ee668b84259d8dbaa51639afa548	1	57451414	0x93701e77dd84ee668b84259d8dbaa51639afa548	2023-02-02T14:46:50.000Z	0xad3b5e009926600addcaa31d55c9a208901e6f1d92061abf08a4e89211765b30

Example Query

Query with partition filter

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

LBPair_FlashLoan_event

Flash loan events from Trader Joe V2 liquidity book pairs on Arbitrum, capturing borrowed token amounts, fees, and sender/receiver addresses. Used for analyzing arbitrage activity and flash loan utilization across Trader Joe V2 pools.

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
0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	169000000	0xf85151e3effda6b0cd32e1ab6faba264c056b426	169	0xf85151e3effda6b0cd32e1ab6faba264c056b426	58222802	2023-02-05T12:55:58.000Z	0xdcf15835e615b8f242eb6ed186a92d6d12f8f9fc071bb273f687c967189a178e
0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	40000000000000000000	0xe4141ec0cbd203a93ee60dd0a24273b8f66b83fd	73	0xe4141ec0cbd203a93ee60dd0a24273b8f66b83fd	58342805	2023-02-05T22:39:50.000Z	0x61b350d4f54ebb41491a8497ba3af426ee5dc275d43d558ae0f5c20ac4185aad
0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	10328983816	0xc0379a7e5360bd02cd35df83a07ec2c73f730d5c	134	0xc0379a7e5360bd02cd35df83a07ec2c73f730d5c	73887448	2023-03-26T13:38:55.000Z	0xa0ae1420d15d13bcc461dc9ef2301d49e6c4bb109cdc1d4fd3ae8002dfccd657

Example Query

Query with partition filter

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

LBPair_Swap_event

Swap events from Trader Joe V2 liquidity book pairs on Arbitrum, capturing token exchanges with input/output amounts, fees, price bin identifiers, and volatility metrics. Used for analyzing DEX trading patterns, fee generation, and price movement across concentrated liquidity bins.

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`	Boolean flag indicating the direction of the swap in the liquidity bin pair. When true, the swap exchanges token X for token Y; when false, it exchanges token Y for token X.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_volatilityAccumulated`	`STRING`	Accumulated volatility metric used by Trader Joe V2’s liquidity book algorithm to adjust dynamic fees. Stored as a raw integer value representing the cumulative market volatility at the time of the swap.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.

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	in_volatilityAccumulated
8384302	0xa0fd049466d57fc3637e27ca585d59e0ad86b902	325879828617	false	0x00000000049c95d6b6002a72c222809bfbfe2ed8	18	135911506716659	false	151994203	740738880000424046	0x00000000049c95d6b6002a72c222809bfbfe2ed8	2023-11-19T14:33:17.000Z	0x0c4ae685fd29ebde0a14a3703cedf2e6d2db9fc7affae11346d6db2a6987df1b	70000
8384309	0xa0fd049466d57fc3637e27ca585d59e0ad86b902	2203309291305	false	0x00000000049c95d6b6002a72c222809bfbfe2ed8	25	1099451336360935	false	151994203	5908957607384818020	0x00000000049c95d6b6002a72c222809bfbfe2ed8	2023-11-19T14:33:17.000Z	0x0c4ae685fd29ebde0a14a3703cedf2e6d2db9fc7affae11346d6db2a6987df1b	0
8384307	0xa0fd049466d57fc3637e27ca585d59e0ad86b902	279512942768	false	0x00000000049c95d6b6002a72c222809bfbfe2ed8	23	137276069127903	false	151994203	740738880000483114	0x00000000049c95d6b6002a72c222809bfbfe2ed8	2023-11-19T14:33:17.000Z	0x0c4ae685fd29ebde0a14a3703cedf2e6d2db9fc7affae11346d6db2a6987df1b	20000

Example Query

Query with partition filter

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

LBPair_TransferBatch_event

Batch liquidity position transfers from Trader Joe V2 liquidity book pairs on Arbitrum. Contains bin ID arrays and token amounts for analyzing concentrated liquidity movements and LP rebalancing activity.

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
0xc308a81cf3985baacc0a4496d937936339033407	[“8374924”,“8374925”,“8374926”,“8374927”,“8374928”,“8374929”,“8374930”,“8374931”,“8374932”,“8374933”,“8374934”,“8374935”,“8374936”,“8374937”,“8374938”,“8374939”,“8374940”,“8374941”,“8374942”,“8374943”,“8374944”,“8374945”,“8374946”,“8374947”,“8374948”,“8374949”,“8374950”,“8374951”,“8374952”,“8374953”,“8374954”,“8374956”,“8374957”,“8374958”,“8374959”,“8374960”,“8374961”,“8374962”,“8374963”,“8374964”,“8374965”,“8374966”,“8374967”,“8374968”,“8374969”,“8374970”,“8374971”]	0xc308a81cf3985baacc0a4496d937936339033407	0x5e0c4ce0a2340e6e7fad4557cf33684dcb60b270	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	161	[“24390243”,“24390243”,“24390243”,“26208424”,“26208424”,“26208424”,“26208424”,“26208424”,“25421312”,“24637725”,“26456401”,“26456897”,“57226624”,“57227122”,“56977654”,“56568493”,“56163347”,“56165355”,“40838073”,“25511242”,“13472652”,“421353”,“422195”,“423040”,“423886”,“112429”,“112654”,“112880”,“113105”,“113331”,“113558”,“31175520”,“31237871”,“31300347”,“31362948”,“31425674”,“31488525”,“31551502”,“31614605”,“31677834”,“31741190”,“31804672”,“31868282”,“31932018”,“31995882”,“32059874”,“32123994”]	81711335	2023-04-18T10:15:32.000Z	0xbcbdeaccc6f73bcf71f8704d3f3f79d974be33958e6c01fddfe91bff7ec3921a
0xc308a81cf3985baacc0a4496d937936339033407	[“8374989”,“8374990”,“8374991”,“8374992”,“8374993”,“8374994”,“8374995”,“8374996”,“8374997”,“8374998”,“8374999”,“8375000”,“8375001”,“8375002”,“8375003”,“8375004”,“8375005”,“8375006”,“8375007”,“8375008”,“8375009”,“8375010”,“8375011”,“8375012”,“8375013”,“8375014”,“8375015”,“8375016”,“8375017”,“8375018”,“8375019”,“8375020”,“8375021”,“8375022”,“8375023”,“8375024”,“8375025”,“8375026”,“8375027”,“8375028”,“8375029”,“8375030”,“8375031”,“8375032”,“8375033”,“8375034”,“8375035”,“8375036”,“8375037”,“8375038”,“8375039”,“8375040”,“8375041”,“8375042”,“8375043”,“8375044”,“8375045”]	0xc308a81cf3985baacc0a4496d937936339033407	0x49462dd5e2092b83043f700745808f695e939cbe	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	75	[“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“39770491”,“22420021”,“5090201”,“5100381”,“5110582”,“5120803”,“5131044”,“5141307”,“5151589”,“5161892”,“5172216”,“5182561”,“5192926”,“5203312”,“5213718”,“5224146”,“5234594”,“5245063”,“5255553”,“5266064”,“5276596”,“5287150”,“5297724”,“5308319”,“5318936”,“5329574”,“5340233”,“5350914”]	81645795	2023-04-18T05:44:49.000Z	0x6d356d1f028f3264caf12334a62ffe32500fb749bea48a8c81d568162c5fe06d
0xc308a81cf3985baacc0a4496d937936339033407	[“8374991”,“8374992”,“8374993”,“8374994”,“8374995”,“8374996”,“8374997”,“8374998”,“8374999”,“8375000”,“8375001”,“8375002”,“8375003”,“8375004”,“8375005”,“8375006”,“8375007”,“8375008”,“8375009”,“8375010”,“8375011”,“8375012”,“8375013”,“8375014”,“8375015”,“8375016”,“8375017”,“8375018”,“8375019”,“8375020”,“8375021”,“8375022”,“8375023”,“8375024”,“8375025”,“8375026”,“8375027”,“8375028”,“8375029”,“8375030”,“8375031”,“8375032”,“8375033”,“8375034”,“8375035”,“8375036”,“8375037”,“8375038”,“8375039”,“8375040”,“8375041”]	0xc308a81cf3985baacc0a4496d937936339033407	0x80b1fb8548a8a9d2162c7c88962657252e724150	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	56	[“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“57753167”,“60315460”,“63101446”,“63227648”,“63354104”,“63480812”,“63607774”,“63734989”,“63862459”,“63990184”,“64118164”,“64246401”,“64374894”,“64503643”,“64632651”,“64761916”,“64891440”,“65021223”,“65151265”,“65281568”,“65412131”,“65542955”,“65674041”,“65805389”,“65937000”,“66068874”,“66201012”]	81718180	2023-04-18T10:43:47.000Z	0x8577cc8582484d033b470e4318fcc70d55fe8edd261e254ac92411c2cf365755

Example Query

Query with partition filter

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

LBPair_TransferSingle_event

Liquidity bin position transfers from Trader Joe V2 liquidity book pairs on Arbitrum, tracking individual bin ID movements between addresses. Used for analyzing liquidity provider behavior and position management in the protocol’s concentrated liquidity model.

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
8375120	0x0000000000000000000000000000000000000000	0x7ec3717f70894f6d9ba0be00774610394ce006ee	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	54545	0x7bfd7192e76d950832c77bb412aae841049d8d9b	4	98717953	2023-06-07T12:55:08.000Z	0x07a4db438f554e3a745b1581ebc303c6417c2862564d6efa33aa153f703ffe7c
8375121	0x0000000000000000000000000000000000000000	0x7ec3717f70894f6d9ba0be00774610394ce006ee	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	54545	0x7bfd7192e76d950832c77bb412aae841049d8d9b	6	98717953	2023-06-07T12:55:08.000Z	0x07a4db438f554e3a745b1581ebc303c6417c2862564d6efa33aa153f703ffe7c
8375123	0x0000000000000000000000000000000000000000	0x7ec3717f70894f6d9ba0be00774610394ce006ee	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	54545	0x7bfd7192e76d950832c77bb412aae841049d8d9b	10	98717953	2023-06-07T12:55:08.000Z	0x07a4db438f554e3a745b1581ebc303c6417c2862564d6efa33aa153f703ffe7c

Example Query

Query with partition filter

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

LBPair_WithdrawnFromBin_event

Liquidity removal events from Trader Joe V2 Liquidity Book (LB) price bins on Arbitrum, capturing withdrawn token X and Y amounts per bin ID. Used for analyzing liquidity provider withdrawals and position management in concentrated liquidity pools.

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
8375176	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	56	505405983530557551	26122	75260317	0x7bfd7192e76d950832c77bb412aae841049d8d9b	2023-03-30T13:16:08.000Z	0x00064361edf9205e2315f2dc9584956b9562133deefc806ba20d43379bd127ba
8375186	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	76	162711864214066976	0	75260317	0x7bfd7192e76d950832c77bb412aae841049d8d9b	2023-03-30T13:16:08.000Z	0x00064361edf9205e2315f2dc9584956b9562133deefc806ba20d43379bd127ba
8375199	0x7ec3717f70894f6d9ba0be00774610394ce006ee	false	0x7bfd7192e76d950832c77bb412aae841049d8d9b	102	162711864704745009	0	75260317	0x7bfd7192e76d950832c77bb412aae841049d8d9b	2023-03-30T13:16:08.000Z	0x00064361edf9205e2315f2dc9584956b9562133deefc806ba20d43379bd127ba

Example Query

Query with partition filter

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

LBPairV2_CollectedProtocolFees_event

Protocol fee collection events from Trader Joe V2 liquidity book pairs on Arbitrum. Records fee amounts collected by the protocol and the recipient address for analyzing protocol revenue and fee distribution across trading pairs.

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
0x4b9bfed1dd4e6780454b2b02213788f31ffba74a	false	2	101575309	2023-06-15T23:51:41.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0x000000000000000004ba3fac61d1c66a000000000000006629b16f399c248b7b	0x391494f723deb8d589348a624ec40822e5a8f985202e9ec258d44bafad64d56b
0xf8a60082039a1acbe43b045f87aa0c5f24a358a4	false	12	145072167	2023-10-29T09:12:23.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0x0000000000000000000000001d37409d000000000000001e5625f456aa58fdd9	0x8bbc2f200b95e48cfd2315992e3e5114fae632260ea2998551f996ef4449c085
0xbacd654a7eef4a50dbf1bc8ed8774a58dfbb440d	false	8	98117489	2023-06-05T18:08:13.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0x0000000000000000000000001e4495bd0000000000000006ae096590de92631b	0xa162716cdaa4ef8192d1485497b627a0ab12f886882a298d83c4df7695c86a43

Example Query

Query with partition filter

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

LBPairV2_CompositionFees_event

Fee composition events from Trader Joe V2 liquidity book pairs on Arbitrum, tracking total fees and protocol fees collected per price bin. Used for analyzing fee distribution and protocol revenue across different liquidity positions.

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
8374856	0xf8a60082039a1acbe43b045f87aa0c5f24a358a4	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	5	98020088	0x000000000000000000000000000001e800000000000000000000000000000000	2023-06-05T11:22:18.000Z	0x0000000000000000000000000000006100000000000000000000000000000000	0x0677a9777de7e2c23435531c090690443587fbb2a70d6627d0790ec88d17eee5
8375174	0xd387c40a72703b38a5181573724bcaf2ce6038a5	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	4	98167394	0x0000000000000000000000000000000000000000000000000001f73ed83ec5e6	2023-06-05T21:42:16.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0x87a668ab12effc96419832a58b433d9a51be8effbae577c689d4cecabfe103f1
8375175	0x94d53be52706a155d27440c4a2434bea772a6f7c	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	4	98169592	0x0000000000000000000000000000545800000000000000000000000000000000	2023-06-05T21:51:53.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0xed6c5d0a807460071aadff2fae68993e3c70b136d3f23c1ddf23821259ccd546

Example Query

Query with partition filter

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

LBPairV2_DepositedToBins_event

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

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
0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6	[“8384144”,“8384145”,“8384146”,“8384147”,“8384148”,“8384149”,“8384150”,“8384151”,“8384152”,“8384153”,“8384154”,“8384155”,“8384156”,“8384157”,“8384158”,“8384159”,“8384160”,“8384161”,“8384162”,“8384163”,“8384164”,“8384165”,“8384166”,“8384167”,“8384168”,“8384169”,“8384170”,“8384171”,“8384172”,“8384173”,“8384174”,“8384175”,“8384176”,“8384177”,“8384178”,“8384179”,“8384180”,“8384181”,“8384182”,“8384183”,“8384184”,“8384185”,“8384186”,“8384187”,“8384188”,“8384189”,“8384190”,“8384191”,“8384192”,“8384193”,“8384194”]	0x4b9bfed1dd4e6780454b2b02213788f31ffba74a	false	0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6	14	[“0x0000000000000000001ebf38dcf4b70900000000000000000000000000000000”,“0x0000000000000000001eb75ad635a62200000000000000000000000000000000”,“0x0000000000000000001eaf7ed2cbe25d00000000000000000000000000000000”,“0x0000000000000000001ea7a4d2338fc200000000000000000000000000000000”,“0x0000000000000000001e9fccd3e8f40200000000000000000000000000000000”,“0x0000000000000000001e97f6d768769500000000000000000000000000000000”,“0x0000000000000000001e9022dc2ea09200000000000000000000000000000000”,“0x0000000000000000001e8850e1b81cb800000000000000000000000000000000”,“0x0000000000000000001e8080e781b76500000000000000000000000000000000”,“0x0000000000000000001e78b2ed085e8000000000000000000000000000000000”,“0x0000000000000000002560b97599a52000000000000000000000000000000000”,“0x0000000000000000002acccccf046c7700000000000000000000000000000000”,“0x00000000000000000033a3f7e97a34ea00000000000000000000000000000000”,“0x0000000000000000004166f2f3e7f82700000000000000000000000000000000”,“0x00000000000000000055d84eaeebf12700000000000000000000000000000000”,“0x00000000000000000072cbfac643aea300000000000000000000000000000000”,“0x00000000000000000099d544c899252700000000000000000000000000000000”,“0x000000000000000000cbd8096cd3d84600000000000000000000000000000000”,“0x000000000000000001088df32a2e471e00000000000000000000000000000000”,“0x0000000000000000014e1c95f0fa493f00000000000000000000000000000000”,“0x00000000000000000198dff9a0072ede00000000000000000000000000000000”,“0x000000000000000001e389ca9106ec3f00000000000000000000000000000000”,“0x00000000000000000227a5973acd1e5f00000000000000000000000000000000”,“0x0000000000000000025e787d1423b65e00000000000000000000000000000000”,“0x0000000000000000028215a9c0181e1f00000000000000000000000000000000”,“0x0000000000000000027fabd8146c1a5e0000000000000001998cc1e6db747913”,“0x000000000000000000000000000000000000000000000053030d0f30f9b7eea1”,“0x00000000000000000000000000000000000000000000004e5e83ffab209ffba8”,“0x00000000000000000000000000000000000000000000004739e56cda3c03ecd6”,“0x00000000000000000000000000000000000000000000003e5a9ebe483147dc92”,“0x0000000000000000000000000000000000000000000000363d106959c825df9d”,“0x00000000000000000000000000000000000000000000002e1c2ded290c81f87c”,“0x000000000000000000000000000000000000000000000026a8c38b97bf09e2e6”,“0x0000000000000000000000000000000000000000000000205c1f0a0d73a3fa4a”,“0x00000000000000000000000000000000000000000000001b74006f8cf409fb74”,“0x00000000000000000000000000000000000000000000000e50c9df3311e07266”,“0x00000000000000000000000000000000000000000000000a8a3ccfdd861b624e”,“0x000000000000000000000000000000000000000000000007df366df17a6feaf3”,“0x00000000000000000000000000000000000000000000000612cecf608f6b1db0”,“0x000000000000000000000000000000000000000000000004ea60d8161b337f54”,“0x00000000000000000000000000000000000000000000000433d972edb4996bc3”,“0x0000000000000000000000000000000000000000000000034bddda0dec5e7738”,“0x0000000000000000000000000000000000000000000000034b05ee095a81db0d”,“0x0000000000000000000000000000000000000000000000034a2e39446046c496”,“0x0000000000000000000000000000000000000000000000034956bbb0dab98989”,“0x000000000000000000000000000000000000000000000003487f7540aa84c525”,“0x00000000000000000000000000000000000000000000000347a865e5b3efe29a”,“0x00000000000000000000000000000000000000000000000346d18d91dedec9fa”,“0x00000000000000000000000000000000000000000000000345faec3716d0411b”,“0x000000000000000000000000000000000000000000000003452481c74add988e”,“0x000000000000000000000000000000000000000000000003444e4e346db9890b”]	253906233	2024-09-15T21:57:48.000Z	0x79dca308100fe32a33e895b36e313b3b038d875dea85f93c6aa0a2bbb6c6796e
0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6	[“8384145”,“8384146”,“8384147”,“8384148”,“8384149”,“8384150”,“8384151”,“8384152”,“8384153”,“8384154”,“8384155”,“8384156”,“8384157”,“8384158”,“8384159”,“8384160”,“8384161”,“8384162”,“8384163”,“8384164”,“8384165”,“8384166”,“8384167”,“8384168”,“8384169”,“8384170”,“8384171”,“8384172”,“8384173”,“8384174”,“8384175”,“8384176”,“8384177”,“8384178”,“8384179”,“8384180”,“8384181”,“8384182”,“8384183”,“8384184”,“8384185”,“8384186”,“8384187”,“8384188”,“8384189”,“8384190”,“8384191”,“8384192”,“8384193”,“8384194”,“8384195”]	0x4b9bfed1dd4e6780454b2b02213788f31ffba74a	false	0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6	14	[“0x0000000000000000001f13ee7348fdf100000000000000000000000000000000”,“0x0000000000000000001f0bfabfcd2a4f00000000000000000000000000000000”,“0x0000000000000000001f04091532683a00000000000000000000000000000000”,“0x0000000000000000001efc1972f3706f00000000000000000000000000000000”,“0x0000000000000000001ef42bd88b1db800000000000000000000000000000000”,“0x0000000000000000001eec4045746cfb00000000000000000000000000000000”,“0x0000000000000000001ee456b92a7d2300000000000000000000000000000000”,“0x0000000000000000001edc6f33288f1a00000000000000000000000000000000”,“0x0000000000000000001ed489b2ea05c300000000000000000000000000000000”,“0x0000000000000000001ecca637ea65ee00000000000000000000000000000000”,“0x00000000000000000024e4f1af14422e00000000000000000000000000000000”,“0x00000000000000000029adb7aae11b6900000000000000000000000000000000”,“0x000000000000000000317b42926daf5700000000000000000000000000000000”,“0x0000000000000000003da14e5c8af00100000000000000000000000000000000”,“0x0000000000000000004fadbc880879c300000000000000000000000000000000”,“0x000000000000000000693dc58478844300000000000000000000000000000000”,“0x0000000000000000008bb58e60d9d23f00000000000000000000000000000000”,“0x000000000000000000b7de4efc87ebbf00000000000000000000000000000000”,“0x000000000000000000ed79eb3192fe6700000000000000000000000000000000”,“0x0000000000000000012ae5705294743f00000000000000000000000000000000”,“0x0000000000000000016ce9dfe004dc8f00000000000000000000000000000000”,“0x000000000000000001aed7ba729bc1ff00000000000000000000000000000000”,“0x000000000000000001eafbc6dc8ef93f00000000000000000000000000000000”,“0x0000000000000000021b6497891b5c7f00000000000000000000000000000000”,“0x0000000000000000023ad6b6c09668df00000000000000000000000000000000”,“0x000000000000000000e7590516305cb700000000000000254b50e9dd7775fd33”,“0x00000000000000000000000000000000000000000000003d2b1dd2eb6331eccd”,“0x000000000000000000000000000000000000000000000039cc2ec2104961e50c”,“0x0000000000000000000000000000000000000000000000349ca4a9271d75f0c4”,“0x00000000000000000000000000000000000000000000002f40afd9373559df21”,“0x0000000000000000000000000000000000000000000000294632e50f62d1f75d”,“0x000000000000000000000000000000000000000000000023494b76ce456ffb4f”,“0x00000000000000000000000000000000000000000000001dca4dc5d69b5bffe3”,“0x00000000000000000000000000000000000000000000001921463da808a9e857”,“0x00000000000000000000000000000000000000000000000efdb68250910c7487”,“0x00000000000000000000000000000000000000000000000b4c0229dfd3a46168”,“0x0000000000000000000000000000000000000000000000088e344fe82242f28c”,“0x0000000000000000000000000000000000000000000000069e32c01991bcf2c8”,“0x0000000000000000000000000000000000000000000000054fc8112d9e64356f”,“0x0000000000000000000000000000000000000000000000047862fa2363f8f976”,“0x000000000000000000000000000000000000000000000003f3aabb8dfb216a1e”,“0x0000000000000000000000000000000000000000000000034b0d1f8aee21c20b”,“0x0000000000000000000000000000000000000000000000034a3568eec33c45a3”,“0x000000000000000000000000000000000000000000000003495de98485953236”,“0x0000000000000000000000000000000000000000000000034886a13e15b83b45”,“0x00000000000000000000000000000000000000000000000347af900d57cdf42e”,“0x00000000000000000000000000000000000000000000000346d8b5e4339b6963”,“0x000000000000000000000000000000000000000000000003460212b49480c9b4”,“0x000000000000000000000000000000000000000000000003452ba6706978bafa”,“0x00000000000000000000000000000000000000000000000344557109a516e11d”,“0x000000000000000000000000000000000000000000000003437f72723d87de15”]	253920279	2024-09-15T22:58:45.000Z	0xc451bcf018441b21a27b5bbebcd216b90b324647f755be285ed3418374593095
0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6	[“8384146”,“8384147”,“8384148”,“8384149”,“8384150”,“8384151”,“8384152”,“8384153”,“8384154”,“8384155”,“8384156”,“8384157”,“8384158”,“8384159”,“8384160”,“8384161”,“8384162”,“8384163”,“8384164”,“8384165”,“8384166”,“8384167”,“8384168”,“8384169”,“8384170”,“8384171”,“8384172”,“8384173”,“8384174”,“8384175”,“8384176”,“8384177”,“8384178”,“8384179”,“8384180”,“8384181”,“8384182”,“8384183”,“8384184”,“8384185”,“8384186”,“8384187”,“8384188”,“8384189”,“8384190”,“8384191”,“8384192”,“8384193”,“8384194”,“8384195”,“8384196”]	0x4b9bfed1dd4e6780454b2b02213788f31ffba74a	false	0x8cc78c2b47e5db444742b64c9d8f6afd68603ca6	24	[“0x0000000000000000001d7c3ec40ad43700000000000000000000000000000000”,“0x0000000000000000001d74b36157126400000000000000000000000000000000”,“0x0000000000000000001d6d29ecd35fbc00000000000000000000000000000000”,“0x0000000000000000001d65a26601495c00000000000000000000000000000000”,“0x0000000000000000001d5e1ccc627cb700000000000000000000000000000000”,“0x0000000000000000001d56991f78c78d00000000000000000000000000000000”,“0x0000000000000000001d4f175ec617f200000000000000000000000000000000”,“0x0000000000000000001d479789cc7c3100000000000000000000000000000000”,“0x0000000000000000001d4019a00e22d700000000000000000000000000000000”,“0x0000000000000000001d389da10d5aa100000000000000000000000000000000”,“0x000000000000000000367853c3db299100000000000000000000000000000000”,“0x0000000000000000004a4f75e5a26ff200000000000000000000000000000000”,“0x0000000000000000006a9b74d174629500000000000000000000000000000000”,“0x0000000000000000009cd64090ade01400000000000000000000000000000000”,“0x000000000000000000e769bb623b53dd00000000000000000000000000000000”,“0x00000000000000000150ff14520379fc00000000000000000000000000000000”,“0x000000000000000001df53f38742545d00000000000000000000000000000000”,“0x00000000000000000295a6b070a4563e00000000000000000000000000000000”,“0x00000000000000000372f6fdf68774fc00000000000000000000000000000000”,“0x00000000000000000470840a835a603c00000000000000000000000000000000”,“0x0000000000000000058109b1319937bd00000000000000000000000000000000”,“0x000000000000000006913221e73e85bd00000000000000000000000000000000”,“0x0000000000000000078977c5b9fd2ffd00000000000000000000000000000000”,“0x000000000000000008515454903caffd00000000000000000000000000000000”,“0x000000000000000008d3306df585d3ff00000000000000000000000000000000”,“0x000000000000000002d4fbad5e2618fe00000000000000aaa0725795ac7f833e”,“0x0000000000000000000000000000000000000000000000f7a33d5a10de179a34”,“0x0000000000000000000000000000000000000000000000e9684fa16b71e7e1f9”,“0x0000000000000000000000000000000000000000000000d38288668db6e7ff90”,“0x0000000000000000000000000000000000000000000000b84f534323a7dfab39”,“0x00000000000000000000000000000000000000000000009a7e5b2ea416c7fe7c”,“0x00000000000000000000000000000000000000000000007ff9bec1b5e99bdc76”,“0x00000000000000000000000000000000000000000000006789156cb0babfb7b7”,“0x000000000000000000000000000000000000000000000052a05b0a266317b814”,“0x000000000000000000000000000000000000000000000041fceba9e8e617f2df”,“0x000000000000000000000000000000000000000000000035bad9fa721647aba4”,“0x00000000000000000000000000000000000000000000001977cb905cd931b12d”,“0x0000000000000000000000000000000000000000000000114b0546f9dd41bd37”,“0x00000000000000000000000000000000000000000000000bc8eb6775f18fa3d5”,“0x0000000000000000000000000000000000000000000000083da7894a8a1ad00f”,“0x0000000000000000000000000000000000000000000000060fab5a5ba7fb6af9”,“0x0000000000000000000000000000000000000000000000034a079da8197a0c42”,“0x000000000000000000000000000000000000000000000003493029f584ad4446”,“0x0000000000000000000000000000000000000000000000034858ed63be2345a0”,“0x0000000000000000000000000000000000000000000000034781e7e4aac8f40c”,“0x00000000000000000000000000000000000000000000000346ab196a33270107”,“0x00000000000000000000000000000000000000000000000345d481e643626904”,“0x00000000000000000000000000000000000000000000000344fe214acb39070c”,“0x0000000000000000000000000000000000000000000000034427f789be028f23”,“0x0000000000000000000000000000000000000000000000034352049512af16b3”,“0x000000000000000000000000000000000000000000000003427c485ec3c51fc3”]	253850686	2024-09-15T18:01:52.000Z	0xe78ea2347f502e003a93c5e9210ae7383635a6440f9439c55782d421ceea090a

Example Query

Query with partition filter

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

LBPairV2_FlashLoan_event

Flash loan events from Trader Joe V2 Liquidity Book (LB) pairs on Arbitrum. Records borrowed amounts, fees charged, and active bin IDs for analyzing arbitrage strategies and flash loan usage patterns.

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 for the liquidity book pair at the time of the flash loan execution. Represented as a decimal integer that determines the current price point in Trader Joe V2’s liquidity book.
`in_amounts`	`STRING`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_totalFees`	`STRING`	Total fees collected from the transaction. Numeric string representation of the fee amount in the token’s smallest unit.
`in_protocolFees`	`STRING`	Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token’s smallest unit.

Sample Data

address	removed	in_sender	log_index	in_amounts	in_activeId	in_receiver	block_number	in_totalFees	block_timestamp	in_protocolFees	transaction_hash
0x94d53be52706a155d27440c4a2434bea772a6f7c	false	0x123453a3995a7bd997e69c0b23844c48e3023816	20	0x0000000000000000000000000000000000000000000000001329de6c3afce52a	8375097	0x123453a3995a7bd997e69c0b23844c48e3023816	123984922	0x000000000000000000000000000000000000000000000000000006478e1b1bef	2023-08-22T22:02:53.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0x3de0f2c0a8d3201910e6fb4d5bd8458b3d49043e57101d380d8542449a8fbf22
0x94d53be52706a155d27440c4a2434bea772a6f7c	false	0x123453a3995a7bd997e69c0b23844c48e3023816	13	0x0000000000000000000000000000000000000000000000000bddc20c1520e76f	8375097	0x123453a3995a7bd997e69c0b23844c48e3023816	123984923	0x000000000000000000000000000000000000000000000000000003e3699c3f9d	2023-08-22T22:02:53.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0xa1365d13f5d59463bddd771057b2b4c980bf901320a52e0a3686f72997685e6b
0x94d53be52706a155d27440c4a2434bea772a6f7c	false	0x123453a3995a7bd997e69c0b23844c48e3023816	17	0x000000000000000000000000000000000000000000000000020cfa2bfaa5609a	8375098	0x123453a3995a7bd997e69c0b23844c48e3023816	123978710	0x000000000000000000000000000000000000000000000000000000ac06483f21	2023-08-22T21:33:30.000Z	0x0000000000000000000000000000000000000000000000000000000000000000	0x086a6c2028a1b48783b7f8f7061cdae525e16f36017a316dbbd43f07ad87282d

Example Query

Query with partition filter

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

LBPairV2_StaticFeeParametersSet_event

Fee parameter configuration events from Trader Joe V2 liquidity book pairs on Arbitrum. Captures updates to dynamic fee settings including base factors, volatility accumulators, protocol share, and decay periods for analyzing fee structure changes across trading pairs.

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
0xb81076e0300139cd680758448d99d3c157ff16b6	false	0x8e42f2f4101563bf679975178e880fd87d3efd4e	4	127754316	8000	600	2023-09-03T20:58:33.000Z	30	2500	0x11eb5d3854bc0d87f69bae9b7c2762feee85af6857a5c7ff975b5091e8247c87	5000	120000	300000
0x5a4ef05343245cf6e5011c48459e68aab0a7b95e	false	0x8e42f2f4101563bf679975178e880fd87d3efd4e	1	127754316	10000	120	2023-09-03T20:58:33.000Z	10	500	0x11eb5d3854bc0d87f69bae9b7c2762feee85af6857a5c7ff975b5091e8247c87	5000	2000000	100000
0x2ca62fb6d1a754e4f3e844b32230e47bcd44bc6e	false	0x8e42f2f4101563bf679975178e880fd87d3efd4e	1	88333031	8000	1200	2023-05-07T19:15:22.000Z	300	0	0xf8ab57f256d2897972024f56d40a435c9491c495dac5d2f79ec34e993fb830ad	5000	7500	150000

Example Query

Query with partition filter

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

LBPairV2_Swap_event

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

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
8375324	0x003ad0975250c810ad75fd83e989f54625cac514	0x69f1216cb2905bf0852f74624d5fa7b5fc4da710	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	1	175202606	0x00000000000000000000000000073e4400000000000000000000000000000000	0x000000000000000000000000000002c900000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000bf60c6d449db	2024-01-28T23:53:11.000Z	0x0000000000000000000000000000004700000000000000000000000000000000	0x40b28d2c66b26d998fb8cf22c7cd0ae560447e92a72917486f506807985ed1b3	0
8375325	0x003ad0975250c810ad75fd83e989f54625cac514	0x69f1216cb2905bf0852f74624d5fa7b5fc4da710	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	2	175202606	0x0000000000000000000000000091525a00000000000000000000000000000000	0x0000000000000000000000000000381100000000000000000000000000000000	0x000000000000000000000000000000000000000000000000000ef9e06306b77a	2024-01-28T23:53:11.000Z	0x0000000000000000000000000000059b00000000000000000000000000000000	0x40b28d2c66b26d998fb8cf22c7cd0ae560447e92a72917486f506807985ed1b3	10000
8384348	0x00904a678800616f2cdf4fde57f7c4df5f2e117e	0x4b9bfed1dd4e6780454b2b02213788f31ffba74a	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	5	174867356	0x0000000000000000125637cb4bc897a400000000000000000000000000000000	0x000000000000000000096a45e811a8a300000000000000000000000000000000	0x00000000000000000000000000000000000000000000016388638cfdb2f007e8	2024-01-28T00:15:33.000Z	0x00000000000000000001e20dfb36bb5300000000000000000000000000000000	0x4045859c18523624b1f7319c6384df2c191fe6e2e092b0a86726521afc476817	7812

Example Query

Query with partition filter

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

LBPairV2_TransferBatch_event

Batch liquidity position transfer events from Trader Joe V2 liquidity book pairs on Arbitrum. Records transfers or burns of multiple price bin positions with bin IDs and token amounts for tracking liquidity provider activity.

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
0x0000000000000000000000000000000000000000	[“8388192”,“8388193”,“8388194”,“8388195”,“8388196”]	0x38b1c0b4439e4a0c87a3e33f9714c899f0e2b655	0xc3eda3a3eaed8c41df3df081c1aac687c5e86502	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	0	[“885964800360124634736105395295131751504797054242001052080”,“900776643878527783417983314499454920381847449601651040363”,“915796127787262847364518013244164738452447972918892164484”,“931025923709784782977377893945939556751785577179886710912”,“946468735937978453202121150931370319524228935444842461721”]	90314712	2023-05-13T15:18:58.000Z	0x610520b210ba04de38ae67a9afb705ab6c406b3555ba0e1f473c6ca486b4010c
0x0000000000000000000000000000000000000000	[“8388247”,“8388248”,“8388249”,“8388250”,“8388251”,“8388252”,“8388253”,“8388254”,“8388255”,“8388256”,“8388257”,“8388258”,“8388259”,“8388260”,“8388261”,“8388262”,“8388263”,“8388264”,“8388265”,“8388266”,“8388267”,“8388268”,“8388269”,“8388270”,“8388271”,“8388272”,“8388273”,“8388274”,“8388275”,“8388276”,“8388277”,“8388278”,“8388279”,“8388280”,“8388281”,“8388282”,“8388283”,“8388284”,“8388285”,“8388286”,“8388287”,“8388288”,“8388289”,“8388290”,“8388291”,“8388292”,“8388293”,“8388294”,“8388295”,“8388296”,“8388297”,“8388298”,“8388299”,“8388300”,“8388301”,“8388302”,“8388303”,“8388304”,“8388305”,“8388306”,“8388307”,“8388308”,“8388309”,“8388310”,“8388311”,“8388312”,“8388313”,“8388314”,“8388315”,“8388316”,“8388317”,“8388318”,“8388319”,“8388320”,“8388321”,“8388322”,“8388323”,“8388324”,“8388325”,“8388326”,“8388327”,“8388328”,“8388329”,“8388330”,“8388331”,“8388332”,“8388333”,“8388334”,“8388335”,“8388336”,“8388337”]	0x38b1c0b4439e4a0c87a3e33f9714c899f0e2b655	0xc3eda3a3eaed8c41df3df081c1aac687c5e86502	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	0	[“190018345562126597372100037241140148453655073870276365170”,“192973026429933235440181738472048675658804189943963591880”,“195967799080539925186702079378102694696597934104776337712”,“199003169881515698445127349310187945278554421367505272595”,“202079651318602837300910226631313610819905430523025060850”,“205197762067443683572698322677069413095226462903004248898”,“208358027066129427800781382294942185748486131928907730296”,“211560977588582182053213476469790027300890658867762910811”,“214807151318777338544688044761051157881785921314356949112”,“218097092425817580250045133595633247399857085130880917178”,“221431351639866749066007204897352133547785886447177729601”,“224810486328954278367018104561306805053542262298132475677”,“228235060576659571589703012413820012074164262875583299576”,“231705645260686117198362563050303337009990115585007958676”,“235222818132335527751263679625098808705503348993937542940”,“238787163896891772329303893334458575092224116102949350021”,“242399274294925994687060049914192855286813198153854225577”,“246059748184531212303639322250730227340510024598054166840”,“249769191624498997595095060139355036974116783512139561530”,“253528217958447729989915826882075679246769671598320518270”,“257337447899912942168919558644802905286034396586615884194”,“261197509618411659232097853677018700799043142509164374500”,“265109038826490313474593407634922877099339612021889446268”,“269072678867768699636015662886617435042085959285671768252”,“273089080805990051278989680163557584924930663126794500505”,“277158903515089053096878286159733528420701758088223266289”,“281282813770289388203714709404610331689169341720862250350”,“285461486340242269314822763738227700099494725581015810557”,“289695604080217130419813571330593362388985446983284140052”,“293985858026357464519972712798432515176826331142849366018”,“298332947491012633257271424726254354304505184192119193982”,“302737580159158219458003960943716234715623668541151558791”,“307200472185917666785934174947467645078545998511013316168”,“311722348295196412838078654359940559280715671710791763200”,“316303941879442064504084373639258311836112346540974518728”,“320945995100543161763881035404287259004476803913346368630”,“325649258991878284038651039642036417316258142721746324187”,“330414493561530054442740055861000130102542667853594598856”,“335242467896675726210026990490332205898333050237407162284”,“340133960269168104085860186584811997865780045781603219170”,“345089758242320716811157799156203706056492306899805722733”,“350110658778909464980552777960364767229119021367359477888”,“355197468350405700074307953326015241405093959742808594705”,“360351003047453968923440176921182688597151651328764865892”,“365572088691608219671837867831016102614701237415267683135”,“370861560948340749075448225963201104966723263153267925704”,“376220265441338783160607199727191385245611522782803112666”,“381649057868101982104972094193949610800985107872588699770”,“387148804116856330474930159117766255227371279975190792583”,“392720380384798936095804735510066904322492715019339883089”,“398364673297688589946146421865368326694512602697849677498”,“404082580030797696322876701796894017766125414974114984736”,“409875008431239215952423989637860457552526414101407796500”,“415742877141686344092904895057258159031014199823567438746”,“421687115725499413909884289114435278237118000088334559543”,“427708664793274659332551949935009415539804446321742013967”,“433808476130832734213988651944868401779220635507874328932”,“439987512828662621991628950060922019640554277248809931936”,“446246749412836109622097598207746936806132745178674225432”,“452587171977410114518572544059521099192070183403508120049”,“459009778318334315902014779068509970123686449453184832101”,“465515578068879282295351608023935264274688371699501852244”,“472105592836603425618300975006538247846207993135462009046”,“478780856341875119007978741385339065323670034589411233864”,“485542414557968427373000214790356465471501673101383512398”,“492391325852749574546702439529393947756840596842475286412”,“499328661131970524705565205650223661355548333778744086304”,“506355503984190502212998521644153211173103638524596611747”,“513472950827341800082233502994813786472465059969253948208”,“520682111056957728656012363244741006362701570712239009563”,“527984107196083217585904293433705262374630611797033905530”,“535380075046885471951117730933730525945793304549158690236”,“542871163843984138544226914419822016390366116493990515152”,“550458536409520189034732018848942916379136698797828241705”,“558143369309982462017336665138339289883531468021599266254”,“565926853014813028460456283976450472432389490282249754176”,“573810192056809310062252174720046205462359678439188809416”,“581794605194344036013401594166706700678600554747491885724”,“589881325575423671384093663600855198588617655434284140142”,“598071600903605543961075138497986206396706120937963575728”,“606366693605793538193216603109617440084829302446728927056”,“614767881001934743942305052203256818790553118286604255400”,“623276455476638384143988683287796451166045698390900511510”,“631893724652735794193198559950765804342877220629298440474”,“640621011566807599160294394802907364107417609032718816765”,“649459654846695538743012671550711349692056436285402684641”,“658411008891024499968730277228651696634021008361375612820”,“667476444050755427817714330989988601277132073197277225548”,“676657346812791814251528531589466628711331001796674388050”,“685955119985663823811189694426168144298546185341524877635”,“695371182887312111760262909056283173464680135501894850720”]	90305000	2023-05-13T14:38:34.000Z	0x7cf357caf68f649b1dc1e24d198f3ecbd3d0f244ca8c96aacd124e8c472de01e
0x0000000000000000000000000000000000000000	[“8375128”,“8375129”,“8375130”,“8375131”,“8375132”,“8375133”,“8375134”,“8375135”,“8375136”,“8375137”,“8375138”,“8375139”,“8375140”,“8375141”,“8375142”,“8375143”,“8375144”,“8375145”,“8375146”,“8375147”]	0x94d53be52706a155d27440c4a2434bea772a6f7c	0xdcd87577e10aacf33bd2fefa57e4041c61fdfd50	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	1	[“80744968220055180444989801403841418648679874560”,“207629918280141892572830917895592219382319677440”,“207629918280141892572830917895592219382319677440”,“207629918280141892572830917895592219382319677440”,“207652988063489664516899880840477663539983548416”,“207652988063489664516899880840477663539983548416”,“207652988063489664516899880840477663539983548416”,“207652988063489664516899880840477663539983548416”,“207652988063489664516899880840477663539983548416”,“207652988063489664516899880840477663539983548416”,“207652988063489664516899880840477663539983548416”,“207676057846837436460968843785363107697647419392”,“207676057846837436460968843785363107697647419392”,“207676057846837436460968843785363107697647419392”,“207676057846837436460968843785363107697647419392”,“207676057846837436460968843785363107697647419392”,“207676057846837436460968843785363107697647419392”,“207676057846837436460968843785363107697647419392”,“212744090369352427848853131008980357617702404096”,“212744090369352427848853131008980357617702404096”]	90145840	2023-05-13T03:30:39.000Z	0x878a646c18ff0c6c2953352799e467bcfd037b81ab88ff33d8beee2346dd683e

Example Query

Query with partition filter

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

LBPairV2_WithdrawnFromBins_event

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

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
0x060d2ed5c447e194e7a107d2009847e1e475da06	[“8385808”,“8385809”,“8385810”,“8385811”,“8385812”,“8385813”,“8385814”,“8385815”,“8385816”,“8385817”,“8385818”,“8385819”,“8385820”,“8385821”,“8385822”,“8385823”,“8385824”,“8385825”,“8385826”,“8385827”,“8385828”,“8385829”,“8385830”,“8385831”,“8385832”,“8385833”,“8385834”,“8385835”,“8385836”,“8385837”,“8385838”,“8385839”,“8385840”,“8385841”,“8385842”,“8385843”,“8385844”,“8385845”,“8385846”,“8385847”,“8385848”,“8385849”,“8385850”,“8385851”,“8385852”,“8385853”,“8385854”,“8385855”,“8385856”,“8385857”,“8385858”,“8385859”,“8385860”,“8385861”,“8385862”,“8385863”,“8385864”,“8385865”,“8385866”,“8385867”,“8385868”,“8385869”,“8385870”,“8385871”,“8385872”,“8385873”,“8385874”,“8385875”,“8385876”,“8385877”,“8385878”]	0x3136010d266152f3890d303c8ac8bcf3b2fe30e3	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	3	[“0x00000000000000000000000000000000000000000000000058f4cae4951c9240”,“0x000000000000000000000000000000000000000000000000629315283dd62923”,“0x0000000000000000000000000000000000000000000000006ce04ccbf3e0cd21”,“0x00000000000000000000000000000000000000000000000077e1ccfaf3cabb37”,“0x00000000000000000000000000000000000000000000000084f82447b93ec3e5”,“0x000000000000000000000000000000000000000000000000908233f5cab9529d”,“0x0000000000000000000000000000000000000000000000009cdc27ae6cd23829”,“0x000000000000000000000000000000000000000000000000aa7947d7a308a51b”,“0x000000000000000000000000000000000000000000000000b8a11c030387872d”,“0x000000000000000000000000000000000000000000000000c74ecde8f05671c2”,“0x000000000000000000000000000000000000000000000000d6b4a2ec0015ad00”,“0x000000000000000000000000000000000000000000000000ed0241002a629948”,“0x0000000000000000000000000000000000000000000000010287927609819850”,“0x0000000000000000000000000000000000000000000000010fafa865dd70e9f2”,“0x00000000000000000000000000000000000000000000000123856a4ce894c20e”,“0x0000000000000000000000000000000000000000000000012a5cb926921a9a7e”,“0x000000000000000000000000000000000000000000000001415433d8a9730ea2”,“0x00000000000000000000000000000000000000000000000164ba54bfe265efbf”,“0x00000000000000000000000000000000000000000000000182c1b942b18d777d”,“0x0000000000000000000000000000000000000000000000018636ade8c25237cd”,“0x0000000000000000000000000000000000000000000000019d9ad5d81f142945”,“0x000000000000000000000000000000000000000000000001b6f36151d07b8fbd”,“0x000000000000000000000000000000000000000000000001cf8167de8f151793”,“0x000000000000000000000000000000000000000000000001f2fd05f94dd7407e”,“0x000000000000000000000000000000000000000000000001e3db522504960b8d”,“0x000000000000000000000000000000000000000000000001d7c99ce94aef57e6”,“0x000000000000000000000000000000000000000000000001cffb656b44bbd25a”,“0x000000000000000000000000000000000000000000000001d5d38a1d75008170”,“0x000000000000000000000000000000000000000000000001d6955622af48bd42”,“0x000000000000000000000000000000000000000000000001dcd685ddfa8234f0”,“0x000000000000000000000000000000000000000000000001e64d7501dd049772”,“0x000000000000000000000000000000000000000000000001ef3dd1837046beef”,“0x000000000000000000000000000000000000000000000001f0b337fc0c47bd4a”,“0x000000000000000000000000000000000000000000000002085f14b6c13f7136”,“0x0000000000000000000000000000000000000000000000021366512b344dbb85”,“0x000000000000000000000000000000000000000000000002318be1f63e192b96”,“0x0000000000000000000000000000000000000000000000025073ba85815ae16b”,“0x0000000000000000000000000000000000000000000000023afe40ced9399fda”,“0x0000000000000000000000000000000000000000000000020a9148dbf803f68c”,“0x000000000000000000000000000000000000000000000001f64708c3da6dcbab”,“0x000000000000000000000000000000000000000000000001ef2a348411753e04”,“0x000000000000000000000000000000000000000000000001c6a0cad091d6fd0b”,“0x000000000000000000000000000000000000000000000001bc98e5dec3607b28”,“0x000000000000000000000000000000000000000000000001bc337146d744cf0b”,“0x000000000000000000000000000000000000000000000001b4ee62107af1204a”,“0x000000000000000000000000000000000000000000000001a2b362ca8335f29d”,“0x0000000000000000000000000000000000000000000000019a3d86cd33d69785”,“0x0000000000000000000000000000000000000000000000018b7be50e647a1e13”,“0x000000000000000000000000000000000000000000000001979b3864195b5f68”,“0x0000000000000000000000000000000000000000000000016f7f66f9ad71593a”,“0x0000000000000000000000000000000000000000000000014dca2ec7e7e107b1”,“0x0000000000000000000000000000000000000000000000013479edeede2e13ab”,“0x0000000000000000000000000000000000000000000000012178f4f0f9424dc0”,“0x0000000000000000000000000000000000000000000000010e0e5e1636053d69”,“0x000000000000000000000000000000000000000000000000fe39b9dae67cda1c”,“0x000000000000000000000000000000000000000000000000ee8aebdc119bfdaf”,“0x000000000000000000000000000000000000000000000000df18fd073d2616cd”,“0x000000000000000000000000000000000000000000000000cff8ee496d44001d”,“0x000000000000000000000000000000000000000000000000c13d966d0798fad5”,“0x000000000000000000000000000000000000000000000000b2f78af1e8a107ba”,“0x000000000000000000000000000000000000000000000000a535139136ea1e9f”,“0x000000000000000000000000000000000000000000000000980227e7eb239c13”,“0x0000000000000000000000000000000000000000000000008b687693a0f06f85”,“0x0000000000000000000000000000000000000000000000007f6f74e5e3b39bd2”,“0x000000000000000000000000000000000000000000000000741c76334d7f7895”,“0x0000000000000000000000000000000000000000000000006972c9ada84a4b5e”,“0x0000000000000000000000000000000000000000000000005f73ddaabc55dcef”,“0x000000000000000000000000000000000000000000000000561f6734393c51b0”,“0x0000000000000000000000000000000000000000000000004d738cbf9e050cea”,“0x000000000000000000000000000000000000000000000000456d12f66ca41581”,“0x0000000000000000000000000000000000000000000000003e078a8665c91b5c”]	130531360	2023-09-12T21:46:35.000Z	0xb35b8b737c912253f8354dcc6258e0036a415a8cbfedb217c9054d223ff450ad
0x2a71d06dc6fe843f2a4fd102aa71fee706a1fb15	[“8394168”,“8394169”,“8394170”,“8394171”,“8394172”,“8394173”,“8394174”,“8394175”,“8394176”,“8394177”,“8394178”]	0xd8053763b1179bd412a5a5a42fa2d15851518cfb	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	3	[“0x000000000000000000000000008bc41900000000000000000000000000000000”,“0x000000000000000000000000008bc41900000000000000000000000000000000”,“0x000000000000000000000000008bc41900000000000000000000000000000000”,“0x000000000000000000000000008bc41900000000000000000000000000000000”,“0x000000000000000000000000008bc41900000000000000000000000000000000”,“0x000000000000000000000000008b43b900000000000000000000000000000000”,“0x000000000000000000000000008b285000000000000000000000000000000000”,“0x000000000000000000000000008b4c2300000000000000000000000000000000”,“0x000000000000000000000000008b6f6f00000000000000000000000000000000”,“0x0000000000000000000000000004c6da000000000000000000000000000083e0”,“0x000000000000000000000000000000000000000000000000000000000000888c”]	130460664	2023-09-12T16:02:10.000Z	0xde06851d775f3deb8c743a31e75df23c3f9cda72bd1fc7ff448487f5b5411108
0x35d58b2b325bafa70008d0a5c0c36cd911ceec07	[“8388604”]	0x0242dd3b2e792cdbd399cc6195951bc202aee97b	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	2	[“0x0000000000000000000000037db5ca4a00000000000000000000000000000000”]	130323299	2023-09-12T06:01:25.000Z	0xbff21a144d515379ee1ae862c74118db1f9bb46dadcf71618e8137db4f3e0b76

Example Query

Query with partition filter

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

LBPairV22_DepositedToBins_event

Liquidity addition events from Trader Joe V2.2 liquidity book pairs on Arbitrum, recording deposits into specific price bins with sender, recipient, bin IDs, and token amounts. Used for tracking liquidity provider positions and analyzing concentrated liquidity distributions across price ranges.

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
0x31307ef22c77cc89cd7e61246608f15b82d09fed	[“8380326”]	0xc09f4ad33a164e29df3c94719ffd5f7b5b057781	false	0x18556da13313f3532c54711497a8fedac273220e	48	[“0x000000000000000000000000000000000000000000000443b77bb2163e49c901”]	280547589	2024-12-02T11:20:05.000Z	0xb537aae0eaead6e5ca45c369d1f71ae9c03f4589c67bd07c38212bd65a5186ec
0x31307ef22c77cc89cd7e61246608f15b82d09fed	[“8380331”]	0xc09f4ad33a164e29df3c94719ffd5f7b5b057781	false	0x18556da13313f3532c54711497a8fedac273220e	39	[“0x00000000000000000003e12b101840000000000000000192aa8572c997673c13”]	280565607	2024-12-02T12:35:35.000Z	0xb0751f2f450ad8ddb55854565df7f326b35ef6df6ca5f3406420e3569f7814ce
0x31307ef22c77cc89cd7e61246608f15b82d09fed	[“8380331”]	0xc09f4ad33a164e29df3c94719ffd5f7b5b057781	false	0x18556da13313f3532c54711497a8fedac273220e	40	[“0x00000000000000000023777c50c9518400000000000004427f2223876d800000”]	280564614	2024-12-02T12:31:25.000Z	0xc99bd5603d75dc920e61ba1cfc7e7145c52ce0f7ac5bb7dea9bf24fb7b4713b1

Example Query

Query with partition filter

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

LBPairV22_Swap_event

Swap execution events from Trader Joe V2.2 Liquidity Book pairs on Arbitrum, capturing token exchanges with input/output amounts, fees, volatility metrics, and active bin identifiers. Used for analyzing DEX trading activity, fee generation, and liquidity distribution across price bins.

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
8441346	0x00000000063e0e1e06a0fe61e16be8bdec1bea31	0xecfe947bf3b6dbf5776ba6eb7bf4d03d4aa7c5f9	false	0x6667c8dc9fbfec411e7c1ee2b24de960149f930f	24	274118949	0x0000000000000000002c888834313b6000000000000000000000000000000000	0x0000000000000000000005318fe4dbea00000000000000000000000000000000	0x000000000000000000000000000000000000000000000000000000000000ae0b	2024-11-13T18:19:52.000Z	0x000000000000000000000084f4ca15fd00000000000000000000000000000000	0xf9ea1c7c5fc9784449bfd2ae46999d6b961593e6ff657a18437c8161e4453cbe	43026
8369028	0x00000000063e0e1e06a0fe61e16be8bdec1bea31	0xb7236b927e03542ac3be0a054f2bea8868af9508	false	0x6667c8dc9fbfec411e7c1ee2b24de960149f930f	21	274165826	0x000000000000000000000000000000000000000000000000006fd27e2558f113	0x000000000000000000000000000000000000000000000000000005f9e40465f2	0x00000000000000000000000005f1240500000000000000000000000000000000	2024-11-13T21:36:33.000Z	0x00000000000000000000000000000000000000000000000000000098fd33a3cb	0x8ef25b097e9ee500223e42ea96419be19fbdd0998ac1f4f6c74651d4b428420e	14797
8369029	0x00000000063e0e1e06a0fe61e16be8bdec1bea31	0xb7236b927e03542ac3be0a054f2bea8868af9508	false	0x6667c8dc9fbfec411e7c1ee2b24de960149f930f	20	274165826	0x000000000000000000000000000000000000000000000000001aed504f304375	0x0000000000000000000000000000000000000000000000000000016291afe7a2	0x000000000000000000000000016ea99600000000000000000000000000000000	2024-11-13T21:36:33.000Z	0x0000000000000000000000000000000000000000000000000000002374f7fd90	0x8ef25b097e9ee500223e42ea96419be19fbdd0998ac1f4f6c74651d4b428420e	4797

Example Query

Query with partition filter

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

LBPairV22_WithdrawnFromBins_event

Liquidity withdrawal events from Trader Joe V2.2 liquidity book (LB) pairs on Arbitrum, capturing bin IDs and token amounts removed from concentrated liquidity positions. Used for tracking liquidity provider exit activity and position management across price bins.

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
0x18556da13313f3532c54711497a8fedac273220e	[“8368851”,“8368852”,“8368853”,“8368854”,“8368855”,“8368856”,“8368857”,“8368858”,“8368859”,“8368860”,“8368861”,“8368862”,“8368863”,“8368864”,“8368865”,“8368866”,“8368867”,“8368868”,“8368869”,“8368870”,“8368871”,“8368872”,“8368873”,“8368874”,“8368875”]	0xb7236b927e03542ac3be0a054f2bea8868af9508	false	0x18556da13313f3532c54711497a8fedac273220e	50	[“0x0000000000000000000000000000000000000000000000000000475550c314c2”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”,“0x000000000000000000000000000000000000000000000000000047553a199b9a”]	265788098	2024-10-20T12:37:04.000Z	0xd452b432590bc929e013e1c3dd1d3492a9c69ef5547d76163f419a03a94a8e6d
0x18556da13313f3532c54711497a8fedac273220e	[“8368868”]	0xb7236b927e03542ac3be0a054f2bea8868af9508	false	0x18556da13313f3532c54711497a8fedac273220e	43	[“0x000000000000000000000000005227ed00000000000000000000000000000000”]	265842018	2024-10-20T16:22:59.000Z	0x8ab5c18ff0d44d5a174cd456c0212da7d9ed88b33023d4902b8a12c58fc645da
0x8ea12bb8ce61315abbcfd9795427bf25c98e82fb	[“8380097”,“8380098”,“8380099”,“8380100”,“8380101”,“8380102”,“8380103”,“8380104”,“8380105”,“8380106”,“8380107”,“8380108”,“8380109”,“8380110”,“8380111”,“8380112”,“8380113”,“8380114”,“8380115”,“8380116”,“8380117”,“8380118”,“8380119”,“8380120”,“8380121”,“8380122”,“8380123”,“8380124”,“8380125”,“8380126”,“8380127”,“8380128”,“8380129”,“8380130”,“8380131”,“8380132”,“8380133”,“8380134”,“8380135”,“8380136”,“8380143”,“8380144”,“8380145”,“8380146”,“8380147”,“8380148”,“8380149”,“8380150”,“8380151”,“8380152”,“8380153”,“8380154”,“8380155”,“8380156”,“8380157”,“8380158”,“8380159”,“8380160”,“8380161”]	0xc09f4ad33a164e29df3c94719ffd5f7b5b057781	false	0x18556da13313f3532c54711497a8fedac273220e	65	[“0x00000000000000000035ecbe8396379b00000000000000000000000000000000”,“0x00000000000000000036747fe36df54a00000000000000000000000000000000”,“0x000000000000000000364c0dffb1428f00000000000000000000000000000000”,“0x00000000000000000035e3a9a18b009700000000000000000000000000000000”,“0x00000000000000000035a9cd52bd39a200000000000000000000000000000000”,“0x0000000000000000006bf2dc18f03f6400000000000000000000000000000000”,“0x0000000000000000006d62aa3948784b00000000000000000000000000000000”,“0x0000000000000000006e691fd3c6732e00000000000000000000000000000000”,“0x0000000000000000006edba774ea97d200000000000000000000000000000000”,“0x0000000000000000006fad0e206e7ba300000000000000000000000000000000”,“0x00000000000000000037d44df7f17d2100000000000000000000000000000000”,“0x00000000000000000037da343bd62d9e00000000000000000000000000000000”,“0x00000000000000000037b63924b0e10e00000000000000000000000000000000”,“0x000000000000000000373fa0fb3b770000000000000000000000000000000000”,“0x00000000000000000037a5ae39cd121000000000000000000000000000000000”,“0x00000000000000000038309828b9959000000000000000000000000000000000”,“0x0000000000000000005087d1a721bf3500000000000000000000000000000000”,“0x0000000000000000007f99ea5dc2c11700000000000000000000000000000000”,“0x000000000000000000aef6d872bc2ab000000000000000000000000000000000”,“0x00000000000000000107042328079ec600000000000000000000000000000000”,“0x00000000000000000107194b443f45d500000000000000000000000000000000”,“0x0000000000000000012d5f8c73dc2ef400000000000000000000000000000000”,“0x0000000000000000012bca19813c9f9300000000000000000000000000000000”,“0x000000000000000000b363ccdbbca88a00000000000000000000000000000000”,“0x00000000000000000080391c3bc1989d00000000000000000000000000000000”,“0x0000000000000000005bb62958a4344e00000000000000000000000000000000”,“0x0000000000000000005b92aeb042be8e00000000000000000000000000000000”,“0x0000000000000000005be5463181971a00000000000000000000000000000000”,“0x0000000000000000005c777c2855341800000000000000000000000000000000”,“0x0000000000000000005bcf0f7930470800000000000000000000000000000000”,“0x0000000000000000005b0b59a618b49f00000000000000000000000000000000”,“0x0000000000000000005a931e0049f57800000000000000000000000000000000”,“0x000000000000000000367b7a6676ff9300000000000000000000000000000000”,“0x000000000000000000366599975889b100000000000000000000000000000000”,“0x000000000000000000369de2b6ddfe6500000000000000000000000000000000”,“0x000000000000000000d0079d387e651800000000000000000000000000000000”,“0x000000000000000000d1bc8815161e0000000000000000000000000000000000”,“0x000000000000000000d2d861ff35508300000000000000000000000000000000”,“0x000000000000000000d2e028adc0970200000000000000000000000000000000”,“0x0000000000000000009a3c4bdffb6d9500000000000000000000000000000000”,“0x0000000000000000001587715d60aca800000000000000000000000000000000”,“0x000000000000000000157c8afdbcf08500000000000000000000000000000000”,“0x0000000000000000001564986da3f94100000000000000000000000000000000”,“0x00000000000000000015861d73e6290200000000000000000000000000000000”,“0x00000000000000000015b12517aea4e200000000000000000000000000000000”,“0x00000000000000000015c4a9de5eabd900000000000000000000000000000000”,“0x000000000000000000160cb786e85e4600000000000000000000000000000000”,“0x0000000000000000001631f69ff9b35300000000000000000000000000000000”,“0x000000000000000000163607f5ba4ae100000000000000000000000000000000”,“0x000000000000000000168517873de0aa00000000000000000000000000000000”,“0x00000000000000000016b75c5c9e785400000000000000000000000000000000”,“0x00000000000000000016a15a1636981500000000000000000000000000000000”,“0x000000000000000000164ab8f09e6ae900000000000000000000000000000000”,“0x000000000000000000164b99016fd8a200000000000000000000000000000000”,“0x0000000000000000001fedd7d59cb3ee00000000000000000000000000000000”,“0x0000000000000000001fa3948c6ccf0500000000000000000000000000000000”,“0x0000000000000000001f950877772cad00000000000000000000000000000000”,“0x0000000000000000001fcb26c931339900000000000000000000000000000000”,“0x0000000000000000001ffc4e341e727900000000000000000000000000000000”]	265810586	2024-10-20T14:11:16.000Z	0x901a51981b4a355b795974b7902190b3a75fc47ff81967618dccf50008001f5e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LBFactory_FeeParametersSet_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

Metrics

Primitives

Contracts

Blockchain

​Tables

​LBFactory_FeeParametersSet_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_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