traderjoe_v2_bsc

Tables

LBFactory_FeeParametersSet_event

Fee parameter configuration events from Trader Joe V2 Liquidity Book (LB) factory contract on BNB Chain. Records dynamic fee settings for liquidity pairs including bin step, base factor, volatility controls, and protocol share for analyzing fee structure changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_LBPair`	`STRING`	Contract address of the Trader Joe V2 liquidity book pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_binStep`	`STRING`	Price bin step size for the Trader Joe V2 liquidity pool. Numeric string representing the step granularity in basis points.
`in_baseFactor`	`STRING`	Base fee multiplier for the Trader Joe V2 liquidity pool. Numeric string denominated in basis points.
`in_filterPeriod`	`STRING`	Time window used to filter and smooth volatility measurements in the Trader Joe V2 fee model. Numeric string representing seconds.
`in_decayPeriod`	`STRING`	Time period over which volatility accumulation decays in the Trader Joe V2 fee model. Numeric string representing seconds.
`in_reductionFactor`	`STRING`	Multiplier applied to reduce accumulated volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points.
`in_variableFeeControl`	`STRING`	Sensitivity parameter controlling how quickly fees adjust to volatility in the Trader Joe V2 dynamic fee model. Numeric string denominated in basis points.
`in_protocolShare`	`STRING`	Percentage of trading fees allocated to the protocol in the Trader Joe V2 fee model. Numeric string denominated in basis points.
`in_maxVolatilityAccumulated`	`STRING`	Maximum accumulated volatility threshold for the liquidity book pair’s dynamic fee calculation. Controls how aggressively fees adjust based on price movement, with typical values ranging from 100,000 to 350,000.

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
0x43646a8e839b2f2766392c1bf8f60f6e587b6960	false	0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	0x2d5c468ec1dccf3fdeb47211df726496d113c10f	150	100	26838948	8000	1200	2023-03-27T21:36:45.000Z	300	0x55a57922ab6d0c21b4adfa2f7329c5647a26f134a7e480664d3bba5448095a6f	5000	7500	150000
0x43646a8e839b2f2766392c1bf8f60f6e587b6960	false	0xa096167678d14d4c0c5fad210182a4aca5ec07b3	0x2d5c468ec1dccf3fdeb47211df726496d113c10f	147	25	26838948	10000	600	2023-03-27T21:36:45.000Z	30	0x55a57922ab6d0c21b4adfa2f7329c5647a26f134a7e480664d3bba5448095a6f	5000	15000	350000
0x43646a8e839b2f2766392c1bf8f60f6e587b6960	false	0xb7b43dcd658e0b9adb77f8c81d680eb4f887a3cd	0x3b0abc81fa6a47135e36a513ad8845f48f1ee179	74	1	26154486	20000	120	2023-03-03T21:13:01.000Z	10	0x9541af2068b479f618fef8b74fa9246f5ea00f5fbae5f7546bc70ac3a592c702	5000	2000000	100000

Example Query

Query with partition filter

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

LBFactory_FeeRecipientSet_event

Fee recipient configuration changes from Trader Joe V2 Liquidity Book (LB) factory contract on BNB Smart Chain. Tracks updates to the address receiving protocol fees, useful for analyzing fee distribution governance and treasury management.

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
0x43646a8e839b2f2766392c1bf8f60f6e587b6960	false	108	26153438	2023-03-03T20:20:24.000Z	0x3b0abc81fa6a47135e36a513ad8845f48f1ee179	0x0000000000000000000000000000000000000000	0xb9fe7db13274b7c9bd13b06f3bec0cfe84a53cdb534dd78e45fcdb762b7e6d8b

Example Query

Query with partition filter

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

LBFactory_FlashLoanFeeSet_event

Events capturing flash loan fee parameter changes in Trader Joe V2 liquidity book factory contracts on BSC. Tracks fee adjustments from old to new values for monitoring protocol revenue configuration and governance actions.

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
0x43646a8e839b2f2766392c1bf8f60f6e587b6960	false	109	26153438	2023-03-03T20:20:24.000Z	0xb9fe7db13274b7c9bd13b06f3bec0cfe84a53cdb534dd78e45fcdb762b7e6d8b	5000000000000	0

Example Query

Query with partition filter

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

LBFactory_LBPairCreated_event

Liquidity book (LB) pair creation events from Trader Joe V2 decentralized exchange on BNB Smart Chain, capturing new trading pair deployments with token addresses, bin step (price precision parameter), and unique pair identifiers. Used for tracking DEX pool launches and analyzing liquidity provision strategies across different price granularities.

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
9	0x43646a8e839b2f2766392c1bf8f60f6e587b6960	false	0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	0xf7de7e8a6bd59ed41a4b5fe50278b3b7f31384df	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	149	100	26838948	2023-03-27T21:36:45.000Z	0x55a57922ab6d0c21b4adfa2f7329c5647a26f134a7e480664d3bba5448095a6f
8	0x43646a8e839b2f2766392c1bf8f60f6e587b6960	false	0xa096167678d14d4c0c5fad210182a4aca5ec07b3	0xf7de7e8a6bd59ed41a4b5fe50278b3b7f31384df	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	146	25	26838948	2023-03-27T21:36:45.000Z	0x55a57922ab6d0c21b4adfa2f7329c5647a26f134a7e480664d3bba5448095a6f
0	0x43646a8e839b2f2766392c1bf8f60f6e587b6960	false	0xd63b2fa0696518b6239ab1f4f7c6556f06c31219	0xe9e7cea3dedca5984780bafc599bd69add087d56	0x55d398326f99059ff775485246999027b3197955	147	1	26154480	2023-03-03T21:12:43.000Z	0xa11647b11e652f13cb0a5d7db8e5f53c78ff1e30a6894f61a08691a2b91cff40

Example Query

Query with partition filter

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

LBFactoryV2_FeeRecipientSet_event

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

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	147	27099340	2023-04-06T01:30:17.000Z	0xc8fc59fceb8259534d8b10879273879eddf7eec0	0x0000000000000000000000000000000000000000	0x4c8a1f2f3d1a92281a3067aaea799536118e02a072380ccd3df642e8adecba6d
0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	274	28096024	2023-05-10T19:04:28.000Z	0x60233142befce7d4ed73e7793ead2d6190fccaab	0xc8fc59fceb8259534d8b10879273879eddf7eec0	0x51acc9650f973d963dfee7989bfa315d0bcef2f8f5609e1abb5f7d0f012b72c6

Example Query

Query with partition filter

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

LBFactoryV2_FlashLoanFeeSet_event

Flash loan fee configuration changes from Trader Joe V2 liquidity book factory contract on BNB Smart Chain. Records updates to flash loan fee parameters with old and new values for tracking protocol fee adjustments.

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	148	27099340	2023-04-06T01:30:17.000Z	0x4c8a1f2f3d1a92281a3067aaea799536118e02a072380ccd3df642e8adecba6d	5000000000000	0

Example Query

Query with partition filter

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

LBFactoryV2_LBPairCreated_event

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

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
116	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0x8c59d9fe5a6886f033fdfb8f8cf5855ca3bfe8b8	0x5037ff2f4598d130788fbd937d82d08b5c05a0cd	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	207	100	32858069	2023-10-23T15:28:31.000Z	0x16ff8330bfc2832fa768076bc35c0caea90d0f25164d6d703a7b47059aba546d
72	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0x45b612bf038494ec2ece3ca36897efd718bd52ba	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	821	25	29207587	2023-06-18T11:14:52.000Z	0xbb2d84fcf4e7f891672bfd9c4cde13c094c83bdf613033f508e565038bce8e25
73	0x8e42f2f4101563bf679975178e880fd87d3efd4e	false	0xfac2d2fae6a30b43eece86e9b266a04fcc1c28e6	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	509	50	29207608	2023-06-18T11:15:55.000Z	0x0b9eb99e0e00f20defaf3c035930e688a4dd534748753e98885d773aed76a989

Example Query

Query with partition filter

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

LBPair_CompositionFee_event

Composition fee collection events from Trader Joe V2 liquidity book pairs on BNB Smart Chain, showing fees accrued in token X and Y for specific bin IDs. Used to analyze fee generation patterns and liquidity provider earnings across different price bins in concentrated liquidity pools.

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`	Fee amount collected in token X of the liquidity pool pair. Denominated in the smallest unit of token X, typically representing protocol or liquidity provider fees for this specific price bin.
`in_feesY`	`STRING`	Fee amount collected in token Y of the liquidity pair for this composition event. Denominated in the smallest unit of token Y, where zero indicates no fees were collected in that token.

Sample Data

in_id	address	removed	in_feesX	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
8392380	0xbf529076bf8d976c321e21f0cd3c52fbff51008e	false	20610842039826	0xb66a2704a0dabc1660941628be987b4418f7a9e8	84	26413813	0xd675d8c0fc1e1c25bf7de99cf44a913e9938eed1	2023-03-12T23:26:22.000Z	0x18a234f4196ad72389b8af10002648248a10bc532557e6fc3259f08a4e72d9b3
8392357	0xbf529076bf8d976c321e21f0cd3c52fbff51008e	false	22897365879400	0xb66a2704a0dabc1660941628be987b4418f7a9e8	316	26399298	0xacfed12efe4b53bbad28314e600ab9c54ed8b9ff	2023-03-12T11:13:56.000Z	0x45d905ed12b2f02aa026984d13f95274afc7f7bd54b08d0cd6c88aa5e8755fbe
8392474	0xbf529076bf8d976c321e21f0cd3c52fbff51008e	false	8022853781499	0xb66a2704a0dabc1660941628be987b4418f7a9e8	500	27254934	0x9c23abb3dfdc67637930e0ec3d2705c5ea461316	2023-04-11T12:33:30.000Z	0xb5fcd86d3887b7b7ab29891b062f685e48852b0304a25a73f86f794adb140b56

Example Query

Query with partition filter

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

LBPair_DepositedToBin_event

Liquidity provision events from Trader Joe V2 Liquidity Book (LB) pairs on BNB Smart Chain, recording deposits of token X and Y amounts into specific price bins. Used for analyzing liquidity distribution, provider behavior, and bin-level capital allocation across concentrated liquidity positions.

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_amountY	block_number	in_recipient	block_timestamp	transaction_hash
8387943	0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	351	20000000000000000	27373218	0x628f9801b3edf1a1c4b7231185ac40b70d34ba29	2023-04-15T15:33:16.000Z	0x33859e340502d7e666e6272d11c5beeab36ef9dedc6d43d8468814d59b267c22
8387940	0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	345	20000000000000000	27373218	0x628f9801b3edf1a1c4b7231185ac40b70d34ba29	2023-04-15T15:33:16.000Z	0x33859e340502d7e666e6272d11c5beeab36ef9dedc6d43d8468814d59b267c22
8387942	0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	349	20000000000000000	27373218	0x628f9801b3edf1a1c4b7231185ac40b70d34ba29	2023-04-15T15:33:16.000Z	0x33859e340502d7e666e6272d11c5beeab36ef9dedc6d43d8468814d59b267c22

Example Query

Query with partition filter

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

LBPair_FeesCollected_event

Fee collection events from Trader Joe V2 liquidity book pairs on BNB Smart Chain, recording amountX and amountY tokens claimed by liquidity providers from their positions.

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	in_amountX	in_amountY	block_number	in_recipient	block_timestamp	transaction_hash
0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	false	0x91ee65424a0a1cf1ca09ba1a04f060b37021f225	119	26393680512295611895	30390780331313651	28094803	0x91ee65424a0a1cf1ca09ba1a04f060b37021f225	2023-05-10T18:03:21.000Z	0xc77f99c4ceb241d3eed298cb8f4ff18bda61b2f908ad792b7f0c7de0ce60b32c
0x4e657182d565dc7c2b107eb5edd1e01d32f21c79	false	0x91ee65424a0a1cf1ca09ba1a04f060b37021f225	53	3274916644120930	291200400072757709	28084184	0x91ee65424a0a1cf1ca09ba1a04f060b37021f225	2023-05-10T09:11:51.000Z	0xb482e92f3af64d9841e4f83feea9a711ab3fa08adcf1a923fa25c394953c935d
0xbf529076bf8d976c321e21f0cd3c52fbff51008e	false	0x6b072c23ef64c9da7b69cc6171248a6d010b9268	141	2723603088927735	1102403293031616417	26507908	0x6b072c23ef64c9da7b69cc6171248a6d010b9268	2023-03-16T06:46:17.000Z	0x7a2d7f4afb2d83d1260903ad4188c1c98b370eda135b958bbd3f59d3c0b5abeb

Example Query

Query with partition filter

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

LBPair_Swap_event

Swap execution events from Trader Joe V2 liquidity book pairs on BNB Smart Chain, capturing token exchanges with amounts, fees, active bin IDs, and volatility metrics. Used for analyzing DEX trading activity, price discovery patterns, and liquidity utilization across concentrated liquidity ranges.

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`	Direction indicator for the swap within the Trader Joe V2 liquidity book bin. True when swapping token X for token Y; false when swapping token Y for token X.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_volatilityAccumulated`	`STRING`	Accumulated volatility metric for the liquidity bin at the time of the swap, used by Trader Joe v2’s dynamic fee mechanism. Typically ranges from 0 to higher values during volatile market conditions.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.

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
8388606	0xd63b2fa0696518b6239ab1f4f7c6556f06c31219	10810432506418322	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	82	54041352099585189540	false	29934489	54052160910418627573	0xd955a5b4802a8dc351136b5e68d6aed6e4db9a6a	2023-07-13T18:51:24.000Z	0x17bc0415e90477ff1a1833c208f07f9155127c469cc4f00a87a784d1a334411e	0
8388607	0xd63b2fa0696518b6239ab1f4f7c6556f06c31219	15060307625731110	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	83	74540918037577779348	false	29934489	74548372129381537125	0xd955a5b4802a8dc351136b5e68d6aed6e4db9a6a	2023-07-13T18:51:24.000Z	0x17bc0415e90477ff1a1833c208f07f9155127c469cc4f00a87a784d1a334411e	10000
8388606	0xd63b2fa0696518b6239ab1f4f7c6556f06c31219	200000000000000	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	341	999800000000000000	false	29934061	999999969998000000	0xb784c80bfc8f8131bf8d10d4af76dffbed0adf87	2023-07-13T18:29:48.000Z	0x2b7cf52d777bdab3905862f535a10d5166c570662a4577cf19f06c1c07a3e318	0

Example Query

Query with partition filter

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

LBPair_TransferBatch_event

Batch liquidity position transfers from Trader Joe V2 liquidity book (LB) pools on BNB Chain, containing multiple bin IDs and token amounts per transfer. Used for tracking multi-bin LP position movements and concentrated liquidity rebalancing activity.

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
0x4e657182d565dc7c2b107eb5edd1e01d32f21c79	[“8393082”,“8393083”,“8393084”,“8393085”,“8393086”,“8393087”,“8393088”,“8393089”,“8393090”,“8393091”,“8393092”,“8393093”,“8393094”,“8393095”,“8393096”,“8393097”,“8393098”,“8393099”,“8393100”,“8393101”,“8393102”,“8393103”,“8393104”,“8393105”,“8393106”,“8393107”,“8393108”,“8393109”,“8393110”,“8393111”,“8393112”,“8393113”,“8393114”,“8393115”,“8393116”,“8393117”,“8393118”,“8393119”,“8393120”,“8393121”,“8393122”,“8393123”,“8393124”,“8393125”,“8393126”,“8393127”,“8393128”,“8393129”,“8393130”,“8393131”,“8393132”]	0x4e657182d565dc7c2b107eb5edd1e01d32f21c79	0xbdbae54705e816b3664969fe255680dc5745e4c0	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	33	[“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“33347921592725465”,“35878376433352608”,“38455873536102906”,“38494329409639009”,“38532823739048648”,“38571356562787697”,“38609927919350485”,“38648537847269835”,“38687186385117105”,“38725873571502222”,“38764599445073724”,“38803364044518798”,“38842167408563317”,“38881009575971880”,“38919890585547852”,“38958810476133400”,“38997769286609533”,“39036767055896143”,“39075803822952039”,“39114879626774991”,“39153994506401766”,“39193148500908168”,“39232341649409076”,“39271573991058485”,“39310845565049543”,“39350156410614593”,“39389506567025207”]	27538312	2023-04-21T09:35:54.000Z	0x8fbc241c3c13c7a75c4c572e337539f2737383765ad37e713f2ad9251ec6ec38
0x4e657182d565dc7c2b107eb5edd1e01d32f21c79	[“8393084”,“8393085”,“8393086”,“8393087”,“8393088”,“8393089”,“8393090”,“8393091”,“8393092”,“8393093”,“8393094”,“8393095”,“8393096”,“8393097”,“8393098”,“8393099”,“8393100”,“8393101”,“8393102”,“8393103”,“8393104”,“8393105”,“8393106”,“8393107”,“8393108”,“8393109”,“8393110”,“8393111”,“8393112”,“8393113”,“8393114”,“8393115”,“8393116”,“8393117”,“8393118”,“8393119”,“8393120”,“8393121”,“8393122”,“8393123”,“8393124”,“8393125”,“8393126”,“8393127”,“8393128”,“8393129”,“8393130”,“8393131”,“8393132”,“8393133”,“8393134”]	0x4e657182d565dc7c2b107eb5edd1e01d32f21c79	0x030df225e4beba45a696a442001d9a5f424d74f6	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	274	[“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“31360000000000000”,“35849460776783814”,“40390328359377055”,“40430718687736432”,“40471149406424169”,“40511620555830593”,“40552132176386424”,“40592684308562810”,“40633276992871373”,“40673910269864244”,“40714584180134108”,“40755298764314243”,“40796054063078557”,“40836850117141635”,“40877686967258777”,“40918564654226036”,“40959483218880262”,“41000442702099142”,“41041443144801241”,“41082484587946042”,“41123567072533989”,“41164690639606522”,“41205855330246129”,“41247061185576375”,“41288308246761952”,“41329596555008713”,“41370926151563722”]	27537012	2023-04-21T08:30:45.000Z	0xce2b1416238308107df43c03cb79508081609724319932472c126fb340b4683d
0xbf529076bf8d976c321e21f0cd3c52fbff51008e	[“8392468”,“8392469”,“8392470”,“8392471”,“8392472”,“8392473”,“8392474”,“8392475”,“8392476”,“8392477”]	0xbf529076bf8d976c321e21f0cd3c52fbff51008e	0x5d44c3f24e711c9135a1a9d3f33047c19ffc1d35	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	303	[“18181818181818236”,“18181818181818236”,“18181818181818236”,“18181818181818236”,“9114213697393350”,“50468735287331”,“50544438390262”,“50620255047848”,“50696185430420”,“50772229708565”]	27537849	2023-04-21T09:12:38.000Z	0x6871d040d4acc181a0c9f8a0280177f1e3f7c3401ffe925ae587ef14d07e8fc2

Example Query

Query with partition filter

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

LBPair_TransferSingle_event

ERC-1155 single token transfer events from Trader Joe V2 liquidity book pairs on BNB Chain, tracking mints and burns of liquidity position NFTs. Used for analyzing liquidity provider position changes and bin-level liquidity distributions across price ranges.

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
8393103	0x263e0dc443185338be3bd886aaa0a7d5488432cf	0x4e657182d565dc7c2b107eb5edd1e01d32f21c79	0x0000000000000000000000000000000000000000	false	794087461227028189	0xb66a2704a0dabc1660941628be987b4418f7a9e8	329	27500297	2023-04-20T01:49:23.000Z	0xc17cc6be91c4a63297ddf7b6ea0f58088a8892ad6b1f4084522fec125c9c230d
8393105	0x263e0dc443185338be3bd886aaa0a7d5488432cf	0x4e657182d565dc7c2b107eb5edd1e01d32f21c79	0x0000000000000000000000000000000000000000	false	265225476745647824	0xb66a2704a0dabc1660941628be987b4418f7a9e8	333	27500297	2023-04-20T01:49:23.000Z	0xc17cc6be91c4a63297ddf7b6ea0f58088a8892ad6b1f4084522fec125c9c230d
8393100	0x263e0dc443185338be3bd886aaa0a7d5488432cf	0x4e657182d565dc7c2b107eb5edd1e01d32f21c79	0x0000000000000000000000000000000000000000	false	45000000000000000	0xb66a2704a0dabc1660941628be987b4418f7a9e8	322	27500297	2023-04-20T01:49:23.000Z	0xc17cc6be91c4a63297ddf7b6ea0f58088a8892ad6b1f4084522fec125c9c230d

Example Query

Query with partition filter

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

LBPair_WithdrawnFromBin_event

Liquidity withdrawal events from Trader Joe V2 Liquidity Book (LB) price bins on BNB Smart Chain, capturing tokenX and tokenY amounts removed by liquidity providers. Used for analyzing liquidity provider behavior and pool depth changes across discrete price ranges.

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
8387924	0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	155	8029105138194828989	27238027	0xb66a2704a0dabc1660941628be987b4418f7a9e8	2023-04-10T22:20:29.000Z	0x9251df774a458f718743532ecf88f24ad455672d64f34fe7a5730b33027fd0e2
8387942	0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	191	15757575757575758499	27238027	0xb66a2704a0dabc1660941628be987b4418f7a9e8	2023-04-10T22:20:29.000Z	0x9251df774a458f718743532ecf88f24ad455672d64f34fe7a5730b33027fd0e2
8387941	0xa1696703ca88f0693d30ff6ee0d7b51900dd6916	false	0xb66a2704a0dabc1660941628be987b4418f7a9e8	189	15757575757575758064	27238027	0xb66a2704a0dabc1660941628be987b4418f7a9e8	2023-04-10T22:20:29.000Z	0x9251df774a458f718743532ecf88f24ad455672d64f34fe7a5730b33027fd0e2

Example Query

Query with partition filter

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

LBPairV2_DepositedToBins_event

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

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
0x05c53cc0223033b073b11ce741f46bed67ab0dfe	[“8393423”,“8393424”,“8393425”,“8393426”,“8393427”,“8393428”,“8393429”,“8393430”,“8393431”]	0xfd83d084777143b726dd32d9424c789ad7df1632	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	177	[“0x00000000000000002dc0e6fa0e278e3500000000000000000000000000000000”,“0x00000000000000002dc0e6fa0e278e3500000000000000000000000000000000”,“0x00000000000000002dc0e6fa0e278e3500000000000000000000000000000000”,“0x00000000000000002dc0e6fa0e278e3500000000000000000000000000000000”,“0x000000000000000016e04327cf31fae00000000000000000002f71a414cb1253”,“0x000000000000000000000000000000000000000000000000005ee348299624a7”,“0x000000000000000000000000000000000000000000000000005ee348299624a7”,“0x000000000000000000000000000000000000000000000000005ee348299624a7”,“0x000000000000000000000000000000000000000000000000005ee348299624a7”]	29595040	2023-07-01T23:06:11.000Z	0xe4e690588f86c5af796ecab7d397900a65d834bcc4f38b72eb4f1af7af04d7ab
0x0b75b9e8ca93aa5d05c832dd4809d72d8ed4125d	[“8385369”,“8385370”,“8385371”,“8385372”,“8385373”,“8385374”,“8385375”,“8385376”,“8385377”,“8385378”,“8385379”,“8385380”,“8385381”,“8385382”,“8385383”,“8385384”,“8385385”,“8385386”,“8385387”,“8385388”,“8385389”,“8385390”,“8385391”,“8385392”,“8385393”,“8385394”,“8385395”,“8385396”,“8385397”,“8385398”,“8385399”,“8385400”,“8385401”,“8385402”,“8385403”,“8385404”,“8385405”,“8385406”,“8385407”,“8385408”,“8385409”,“8385410”,“8385411”,“8385412”,“8385413”,“8385414”,“8385415”,“8385416”,“8385417”,“8385418”,“8385419”,“8385420”,“8385421”,“8385422”,“8385423”,“8385424”,“8385425”,“8385426”,“8385427”,“8385428”,“8385429”]	0x722edd360b53029e287dd4d1ebcfd6cb3710912f	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	287	[“0x00000000000000000641c23d7f0ed92400000000000000000000000000000000”,“0x000000000000000007222800f17c61fc00000000000000000000000000000000”,“0x00000000000000000818c20375460a1800000000000000000000000000000000”,“0x000000000000000009263a25acc5185000000000000000000000000000000000”,“0x00000000000000000a4afdde6a6166d800000000000000000000000000000000”,“0x00000000000000000b8734531e639a9c00000000000000000000000000000000”,“0x00000000000000000cdab4d4dfd6269400000000000000000000000000000000”,“0x00000000000000000e44fe132e58238800000000000000000000000000000000”,“0x00000000000000000fc52e597e037ed000000000000000000000000000000000”,“0x00000000000000001159fd2ddc2559f000000000000000000000000000000000”,“0x00000000000000001301b6a524f1bbcc00000000000000000000000000000000”,“0x000000000000000014ba38bc12e222ac00000000000000000000000000000000”,“0x00000000000000001680f2fbc3ac4a3800000000000000000000000000000000”,“0x00000000000000001852e8a425e95e7c00000000000000000000000000000000”,“0x00000000000000001a2cb587483abe2c00000000000000000000000000000000”,“0x00000000000000001c0a95ae0cd7f4f800000000000000000000000000000000”,“0x00000000000000001de86fc9d3c3846800000000000000000000000000000000”,“0x00000000000000001fc1e25feb5f8f2000000000000000000000000000000000”,“0x000000000000000021925383ceaded7400000000000000000000000000000000”,“0x0000000000000000235502dd5191246400000000000000000000000000000000”,“0x000000000000000025051da0cf18d75800000000000000000000000000000000”,“0x0000000000000000269dd40a3c09857400000000000000000000000000000000”,“0x0000000000000000281a6fd9a25be06800000000000000000000000000000000”,“0x000000000000000029766b40e8bb31fc00000000000000000000000000000000”,“0x00000000000000002aad87a8ab444a1800000000000000000000000000000000”,“0x00000000000000002bbbe3acee77096400000000000000000000000000000000”,“0x00000000000000002c9e0fb30398d0d800000000000000000000000000000000”,“0x00000000000000002d5120803c18bb9400000000000000000000000000000000”,“0x00000000000000002dd2bf44f52d4cc800000000000000000000000000000000”,“0x00000000000000002e2136a0c1f62e2000000000000000000000000000000000”,“0x0000000000000000171dbe1d3b155040000000000000002d25c58c65409316ce”,“0x00000000000000000000000000000000000000000000005a18deb1fad4d21680”,“0x0000000000000000000000000000000000000000000000597f9d92aedc79f6a0”,“0x00000000000000000000000000000000000000000000005882737a75604e5d10”,“0x00000000000000000000000000000000000000000000005724b6a9a30677e5e0”,“0x0000000000000000000000000000000000000000000000556af8adc1c07e5750”,“0x0000000000000000000000000000000000000000000000535aecf56e8160b6e0”,“0x000000000000000000000000000000000000000000000050fb497ac68d9da030”,“0x00000000000000000000000000000000000000000000004e53a275111b724b20”,“0x00000000000000000000000000000000000000000000004b6c4223fd4298a690”,“0x0000000000000000000000000000000000000000000000484dfdde147c8497e0”,“0x000000000000000000000000000000000000000000000045020998434f7b1350”,“0x00000000000000000000000000000000000000000000004191cb1d6fabb3c690”,“0x00000000000000000000000000000000000000000000003e06ae2357b6a38a80”,“0x00000000000000000000000000000000000000000000003a69fa563199de9b20”,“0x000000000000000000000000000000000000000000000036c4ac57f115ca7460”,“0x0000000000000000000000000000000000000000000000331f528c3912bb6df0”,“0x00000000000000000000000000000000000000000000002f81ee609a0bcc8a30”,“0x00000000000000000000000000000000000000000000002bf3da93ba2c80f560”,“0x0000000000000000000000000000000000000000000000287bb6cf54e1abb7f0”,“0x0000000000000000000000000000000000000000000000251f58ba8c2822ca70”,“0x000000000000000000000000000000000000000000000021e3c27d91f8f3a8c0”,“0x00000000000000000000000000000000000000000000001ecd1e86ca1ed3ae40”,“0x00000000000000000000000000000000000000000000001bdec03d76842565a0”,“0x0000000000000000000000000000000000000000000000191b292fc52e435910”,“0x000000000000000000000000000000000000000000000016841232575a89f8b0”,“0x0000000000000000000000000000000000000000000000141a77d667c63cdde0”,“0x000000000000000000000000000000000000000000000011dea9919570f37c40”,“0x00000000000000000000000000000000000000000000000fd05aeec10ccbb6e0”,“0x00000000000000000000000000000000000000000000000deeb621d7a6ef6030”,“0x00000000000000000000000000000000000000000000000c386f601c29001a50”]	29568390	2023-07-01T00:49:10.000Z	0x09201cd5a6af4f9bdf77d15cd1f64051ff14dceda1f9b8eaeb7a479a4c30238c
0x12a0dd19d3f878697c7a1f804aaa1da84229566c	[“8385395”,“8385396”,“8385397”,“8385398”,“8385399”,“8385400”,“8385401”]	0x722edd360b53029e287dd4d1ebcfd6cb3710912f	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	556	[“0x0000000000000000041498d5e5682a3100000000000000000000000000000000”,“0x0000000000000000051405a10477781300000000000000000000000000000000”,“0x000000000000000005efe133279a018300000000000000000000000000000000”,“0x0000000000000000068542e2ec69ec0100000000000000000000000000000000”,“0x0000000000000000035d1fe995d07032000000000000000c6b0088432e9bb52c”,“0x000000000000000000000000000000000000000000000015ec31094d7b329424”,“0x00000000000000000000000000000000000000000000000f1132f702f5d1a296”]	29568124	2023-07-01T00:35:52.000Z	0x2f6d4a753bc61833b76e853588124231c4590371cdc5f0d3a31bd773f971eb20

Example Query

Query with partition filter

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

LBPairV2_Swap_event

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

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
8388607	0x58e2c10f7ea156477b45b0a33958b6473445a0c2	0x023ff63aa03060cfe97018e2854318bea9873fd5	false	0x2d1eee087fd8f6d82f4b3bfd8c82e7393545a30f	229	39619412	0x0000000000000000821d29782d55c1e500000000000000000000000000000000	0x00000000000000000001aa5bbc20fa2800000000000000000000000000000000	0x000000000000000000000000000000000000000000000000821ee91a6249c9c2	2024-06-15T00:25:49.000Z	0x0000000000000000000015516301a61b00000000000000000000000000000000	0x25f3f9acc4b661fd4b5d49cf48cf7b59a4ae5e832254f6fd533a305343ce33c2	0
8399692	0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d	0x717d06b4d8bc6b71d5a2c45d8cc417930aec073d	false	0x2d1eee087fd8f6d82f4b3bfd8c82e7393545a30f	94	39633236	0x00000000000000000004f7e1a8db733c00000000000000000000000000000000	0x00000000000000000000033aa23bfcff00000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000537	2024-06-15T11:58:55.000Z	0x0000000000000000000000a553a598ff00000000000000000000000000000000	0x3b89f7d2568e0905d8c308844b48de67829ec635f8773000af238762e181c074	20000
8399690	0x6827ab5b01b02a594d9d36f2ffa787f6c7c5a72d	0x717d06b4d8bc6b71d5a2c45d8cc417930aec073d	false	0x2d1eee087fd8f6d82f4b3bfd8c82e7393545a30f	92	39633236	0x0000000000000000000611aeeda4120f00000000000000000000000000000000	0x0000000000000000000003e2dad0c54400000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000667	2024-06-15T11:58:55.000Z	0x0000000000000000000000c6f890277400000000000000000000000000000000	0x3b89f7d2568e0905d8c308844b48de67829ec635f8773000af238762e181c074	0

Example Query

Query with partition filter

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

LBPairV2_WithdrawnFromBins_event

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

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
0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	[“8385280”,“8385281”,“8385282”,“8385283”,“8385284”,“8385285”,“8385286”,“8385287”,“8385288”,“8385289”,“8385290”,“8385291”,“8385292”,“8385293”,“8385294”,“8385295”,“8385296”,“8385297”,“8385298”,“8385299”,“8385300”,“8385301”,“8385302”,“8385303”,“8385304”,“8385305”,“8385306”,“8385307”,“8385308”,“8385309”,“8385310”,“8385311”,“8385312”,“8385313”,“8385314”,“8385315”,“8385316”,“8385317”,“8385318”,“8385319”,“8385320”,“8385321”,“8385322”,“8385323”,“8385324”,“8385325”,“8385326”,“8385327”,“8385328”,“8385329”,“8385330”,“8385331”,“8385332”,“8385333”,“8385334”,“8385335”,“8385336”,“8385337”,“8385338”]	0x722edd360b53029e287dd4d1ebcfd6cb3710912f	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	87	[“0x00000000000000000061d62c1b4005cd00000000000000000000000000000000”,“0x0000000000000000005fa04041d0707800000000000000000000000000000000”,“0x000000000000000000603195f6cddb3b00000000000000000000000000000000”,“0x000000000000000000609fbb4b02e34a00000000000000000000000000000000”,“0x0000000000000000005fd548b8123e5200000000000000000000000000000000”,“0x000000000000000000609246ba85107d00000000000000000000000000000000”,“0x0000000000000000006203da616dd4c000000000000000000000000000000000”,“0x00000000000000000060d09c68341f9e00000000000000000000000000000000”,“0x0000000000000000005fa790a1a18a9200000000000000000000000000000000”,“0x0000000000000000005fc2f697745c5000000000000000000000000000000000”,“0x0000000000000000005f931fdcb7644800000000000000000000000000000000”,“0x0000000000000000005fb3e5657fcdd100000000000000000000000000000000”,“0x00000000000000000060191578c6f99c00000000000000000000000000000000”,“0x00000000000000000061859557058d9100000000000000000000000000000000”,“0x000000000000000000618a2b8686121800000000000000000000000000000000”,“0x00000000000000000061aaf7af5a125c00000000000000000000000000000000”,“0x00000000000000000060b5bf0421838f00000000000000000000000000000000”,“0x0000000000000000005fa463e254ad0b00000000000000000000000000000000”,“0x0000000000000000005fd3a27c79423d00000000000000000000000000000000”,“0x0000000000000000006030c418515d6500000000000000000000000000000000”,“0x000000000000000000616b7de919fce200000000000000000000000000000000”,“0x00000000000000000062101facccb62f00000000000000000000000000000000”,“0x0000000000000000005fd658b9340c6800000000000000000000000000000000”,“0x0000000000000000006125374021993e00000000000000000000000000000000”,“0x0000000000000000006301f78a2ee30200000000000000000000000000000000”,“0x00000000000000000064b83e2caa322200000000000000000000000000000000”,“0x000000000000000000642fd9687802cd00000000000000000000000000000000”,“0x00000000000000000061e3cee64b3c2600000000000000000000000000000000”,“0x00000000000000000062141e5d31d16c00000000000000000000000000000000”,“0x000000000000000000616c863cebbfbf00000000000000000000000000000000”,“0x000000000000000000624421665e618b00000000000000000000000000000000”,“0x00000000000000000060cb3b5999ec9500000000000000000000000000000000”,“0x0000000000000000006189e1fd80189e00000000000000000000000000000000”,“0x0000000000000000006321e00e21238200000000000000000000000000000000”,“0x00000000000000000063df4ec6ee536300000000000000000000000000000000”,“0x00000000000000000065cb7c5aec8b1400000000000000000000000000000000”,“0x0000000000000000006960184c31838b00000000000000000000000000000000”,“0x00000000000000000069d776b86e873000000000000000000000000000000000”,“0x000000000000000000695c5e1e1f6a2900000000000000000000000000000000”,“0x0000000000000000006bd759fe3345d600000000000000000000000000000000”,“0x0000000000000000006b2814d08b0e1800000000000000000000000000000000”,“0x0000000000000000006ba74f477561db00000000000000000000000000000000”,“0x0000000000000000004368c951dea94d00000000000000006f7962de54c8c19a”,“0x00000000000000000000000000000000000000000000000129ab107ecf79491f”,“0x0000000000000000000000000000000000000000000000012dbc19746bcc41cd”,“0x00000000000000000000000000000000000000000000000134e862c72ee600bf”,“0x00000000000000000000000000000000000000000000000137cf904420552e0f”,“0x00000000000000000000000000000000000000000000000137556df78e6d2194”,“0x00000000000000000000000000000000000000000000000139b4ca99a07e60a6”,“0x000000000000000000000000000000000000000000000001466db0987e9de4a9”,“0x00000000000000000000000000000000000000000000000147d48d222c28c5be”,“0x00000000000000000000000000000000000000000000000148cf9ce9b5657745”,“0x0000000000000000000000000000000000000000000000014c02c7c4e876b79a”,“0x000000000000000000000000000000000000000000000001469e2f0a7019bb42”,“0x000000000000000000000000000000000000000000000001525a8a6371f3c76f”,“0x00000000000000000000000000000000000000000000000158947ee8a5e3eefe”,“0x00000000000000000000000000000000000000000000000156306baaddb1c5fa”,“0x00000000000000000000000000000000000000000000000157936462eea6fdb9”,“0x000000000000000000000000000000000000000000000001605c7b0a7ffdb142”]	36624349	2024-03-02T18:45:07.000Z	0xd049f0a05928f7738abbca7756999528414ee3ae051ed3c661c693051ac6be58
0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	[“8386346”,“8386347”,“8386348”,“8386349”,“8386350”,“8386351”,“8386352”,“8386353”,“8386354”,“8386355”,“8386356”,“8386357”,“8386358”,“8386359”,“8386360”,“8386361”,“8386362”,“8386363”,“8386364”,“8386365”,“8386366”,“8386367”,“8386368”,“8386369”,“8386370”,“8386371”,“8386372”,“8386373”,“8386374”,“8386375”,“8386376”,“8386377”,“8386378”,“8386379”,“8386380”,“8386381”,“8386382”,“8386383”,“8386384”,“8386385”,“8386386”,“8386387”,“8386388”,“8386389”,“8386390”,“8386391”,“8386392”,“8386393”,“8386394”,“8386395”,“8386396”,“8386397”,“8386398”,“8386399”,“8386400”,“8386401”,“8386402”,“8386403”,“8386404”,“8386405”,“8386406”,“8386407”,“8386408”,“8386409”,“8386410”,“8386411”]	0x36c95fcc451fd03a586d5c2555c2c8e76d4b119d	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	161	[“0x000000000000000000ce0050e073e55900000000000000000000000000000000”,“0x000000000000000000cfe1ad54e0067b00000000000000000000000000000000”,“0x000000000000000000d235b6fac7d7a400000000000000000000000000000000”,“0x000000000000000000d5ffcc28f2a6a600000000000000000000000000000000”,“0x000000000000000000d7862a17db0a1800000000000000000000000000000000”,“0x000000000000000000da6108bd9a16d400000000000000000000000000000000”,“0x000000000000000000db638b78d1dc7d00000000000000000000000000000000”,“0x0000000000000000010d29479be1d92800000000000000000000000000000000”,“0x0000000000000000010bb044f4137a6600000000000000000000000000000000”,“0x00000000000000000030963433873c8900000000000000000000000000000000”,“0x00000000000000000030ac2f3512c77700000000000000000000000000000000”,“0x000000000000000000307f9fb8faab3200000000000000000000000000000000”,“0x0000000000000000002f88b5cbe13dbb00000000000000000000000000000000”,“0x0000000000000000002ed1f1046c0ceb00000000000000000000000000000000”,“0x0000000000000000000213605d63d7e7000000000000000030ee518da3bbec54”,“0x00000000000000000000000000000000000000000000000033cebb72422b2d2c”,“0x00000000000000000000000000000000000000000000000034dc7277813eeeeb”,“0x0000000000000000000000000000000000000000000000003522ccb72218e125”,“0x00000000000000000000000000000000000000000000000034ac73d7278a986f”,“0x00000000000000000000000000000000000000000000000035c291126b680f30”,“0x000000000000000000000000000000000000000000000000355411fd801e9a4d”,“0x000000000000000000000000000000000000000000000000351533c0f2a4bf53”,“0x00000000000000000000000000000000000000000000000034be799777f3ea23”,“0x000000000000000000000000000000000000000000000000345f59fef7e86bda”,“0x000000000000000000000000000000000000000000000000339e12511242c7ef”,“0x00000000000000000000000000000000000000000000000032761e3f2470f758”,“0x000000000000000000000000000000000000000000000000323f0ce8427b0df2”,“0x000000000000000000000000000000000000000000000000329949c13afc487d”,“0x0000000000000000000000000000000000000000000000003167df5be7c51b31”,“0x00000000000000000000000000000000000000000000000030d27609a17d377e”,“0x0000000000000000000000000000000000000000000000002ff4841a2c06f559”,“0x0000000000000000000000000000000000000000000000003096f7524109945c”,“0x0000000000000000000000000000000000000000000000003024488b449bd704”,“0x00000000000000000000000000000000000000000000000030343e9536b07692”,“0x00000000000000000000000000000000000000000000000030e4470570890f3f”,“0x00000000000000000000000000000000000000000000000030af3b4521f00169”,“0x00000000000000000000000000000000000000000000000031160479e5c481c3”,“0x00000000000000000000000000000000000000000000000031b9463ad76ecbc5”,“0x00000000000000000000000000000000000000000000000031fe0689312d6cf7”,“0x00000000000000000000000000000000000000000000000032439850b2e961ab”,“0x000000000000000000000000000000000000000000000000320f5ef5468e5a1d”,“0x000000000000000000000000000000000000000000000000324166ff937f2d5f”,“0x00000000000000000000000000000000000000000000000031ce621b0d18602c”,“0x00000000000000000000000000000000000000000000000031afcbf6f2a83e86”,“0x00000000000000000000000000000000000000000000000031558ce42c167e7b”,“0x0000000000000000000000000000000000000000000000003037c10947e5cac4”,“0x0000000000000000000000000000000000000000000000002f3e6ebf1ffbe702”,“0x0000000000000000000000000000000000000000000000002f583017c3cfb27d”,“0x0000000000000000000000000000000000000000000000002f3830a1fb340a52”,“0x0000000000000000000000000000000000000000000000002efafa1322aff974”,“0x0000000000000000000000000000000000000000000000002ec0fedd89df0518”,“0x0000000000000000000000000000000000000000000000002f0da9bf26ebbc05”,“0x0000000000000000000000000000000000000000000000002e804adde90d5886”,“0x0000000000000000000000000000000000000000000000002e367599c5332d32”,“0x0000000000000000000000000000000000000000000000002e64342d72d75ad1”,“0x0000000000000000000000000000000000000000000000002e041508d1628c71”,“0x0000000000000000000000000000000000000000000000002dfee0728d3b1f93”,“0x0000000000000000000000000000000000000000000000002dd9374a06ee3aed”,“0x0000000000000000000000000000000000000000000000002dac2fbbb6ef5142”,“0x0000000000000000000000000000000000000000000000002d2f508bba12d35f”,“0x0000000000000000000000000000000000000000000000002d4342e3681c165f”,“0x0000000000000000000000000000000000000000000000002d712f03becff688”,“0x0000000000000000000000000000000000000000000000002da4221b6fa36ff8”,“0x0000000000000000000000000000000000000000000000002da133c02df8d9f7”,“0x0000000000000000000000000000000000000000000000002d8938c1bf16b84f”,“0x0000000000000000000000000000000000000000000000002d6e59a74f49d8d9”]	36624408	2024-03-02T18:48:04.000Z	0x8a0deb832f0248d6bf06fd62e95340bdd632283b8a8dae340741e8f7299a8ad2
0x1ec811302800fc9defc6de81ea9138f9fd12c7e7	[“8388605”,“8388606”,“8388607”,“8388608”,“8388609”,“8388610”,“8388611”,“8388612”,“8388613”,“8388614”,“8388615”]	0xaec97c3465d83b1952c3a251036df88a635c060c	false	0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30	19	[“0x000000000000000064edeaec07345d0f00000000000000000000000000000000”,“0x000000000000000064edeaec07345d0f00000000000000000000000000000000”,“0x000000000000000064c2ae5723f783340000000000000000002cadb69bb6484d”,“0x000000000000000000000000000000000000000000000000650d8cbef5c49af6”,“0x0000000000000000000000000000000000000000000000006511a650fb31a91b”,“0x00000000000000000000000000000000000000000000000064f9fbeb83c00997”,“0x00000000000000000000000000000000000000000000000064e6af00739d10d7”,“0x00000000000000000000000000000000000000000000000064e62ae68ce5212b”,“0x00000000000000000000000000000000000000000000000064e62ae68ce5212c”,“0x00000000000000000000000000000000000000000000000064e62ae68ce5212c”,“0x00000000000000000000000000000000000000000000000064e62ae68ce5212c”]	29760026	2023-07-07T17:03:27.000Z	0xa5bc9700a4db8e051d7b58da7cfff91a4a19b892bed777788bd8840b3743d3ef

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LBFactory_FeeParametersSet_event

LBFactory_FeeRecipientSet_event

LBFactory_FlashLoanFeeSet_event

LBFactory_LBPairCreated_event

LBFactoryV2_FeeRecipientSet_event

LBFactoryV2_FlashLoanFeeSet_event

LBFactoryV2_LBPairCreated_event

LBPair_CompositionFee_event

LBPair_DepositedToBin_event

LBPair_FeesCollected_event

LBPair_Swap_event

LBPair_TransferBatch_event

LBPair_TransferSingle_event

LBPair_WithdrawnFromBin_event

LBPairV2_DepositedToBins_event

LBPairV2_Swap_event

LBPairV2_WithdrawnFromBins_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​LBFactory_FeeParametersSet_event

​LBFactory_FeeRecipientSet_event

​LBFactory_FlashLoanFeeSet_event

​LBFactory_LBPairCreated_event

​LBFactoryV2_FeeRecipientSet_event

​LBFactoryV2_FlashLoanFeeSet_event

​LBFactoryV2_LBPairCreated_event

​LBPair_CompositionFee_event

​LBPair_DepositedToBin_event

​LBPair_FeesCollected_event

​LBPair_Swap_event

​LBPair_TransferBatch_event

​LBPair_TransferSingle_event

​LBPair_WithdrawnFromBin_event

​LBPairV2_DepositedToBins_event

​LBPairV2_Swap_event

​LBPairV2_WithdrawnFromBins_event

Tables

LBFactory_FeeParametersSet_event

LBFactory_FeeRecipientSet_event

LBFactory_FlashLoanFeeSet_event

LBFactory_LBPairCreated_event

LBFactoryV2_FeeRecipientSet_event

LBFactoryV2_FlashLoanFeeSet_event

LBFactoryV2_LBPairCreated_event

LBPair_CompositionFee_event

LBPair_DepositedToBin_event

LBPair_FeesCollected_event

LBPair_Swap_event

LBPair_TransferBatch_event

LBPair_TransferSingle_event

LBPair_WithdrawnFromBin_event

LBPairV2_DepositedToBins_event

LBPairV2_Swap_event

LBPairV2_WithdrawnFromBins_event