wombat_v2_optimism

Tables

CrossChainPool_SetFee_event

Fee configuration events emitted when cross-chain liquidity pool fee parameters are updated, containing LP (liquidity provider) dividend ratio and retention ratio settings. Used for tracking fee structure changes across Wombat protocol deployments.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x50a39b94b1dc8472faa08c36a3ef5b0a01c5bd10	false	39	109708830	2023-09-18T05:53:57.000Z	0xaadafc618a99b0ad1f740b9393718d71e9893b6e36192b6fba3b2569d0f0541d	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

CrossChainPool_SetHaircutRate_event

Event log emitted when the haircut rate parameter is updated in a Wombat cross-chain liquidity pool contract. Records the new rate value alongside transaction context for tracking pool fee configuration 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x50a39b94b1dc8472faa08c36a3ef5b0a01c5bd10	false	20000000000000	30	110097781	2023-09-27T05:58:59.000Z	0xae958e08137b725330fc0e4685bdd6cc5594189e2419cfe4817e8ae630d2a58a
0x50a39b94b1dc8472faa08c36a3ef5b0a01c5bd10	false	400000000000000	41	118267732	2024-04-03T08:50:41.000Z	0xded9be66d5e14b5e1252f635d65e7887e29fcaecfa02012a57bfbf7b55936fcc
0x50a39b94b1dc8472faa08c36a3ef5b0a01c5bd10	false	200000000000000	15	118785254	2024-04-15T08:21:25.000Z	0xe30036b416b5b8421b067cbb591eea9ea5f342e54f896aaf70910e7120c5daa5

Example Query

Query with partition filter

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

CrossChainPool_SwapV2_event

Token swap events from Wombat cross-chain pools recording exchange of tokens between different assets. Contains sender, recipient, source/destination token addresses, swap amounts, and fees charged on the destination token.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toTokenFee`	`STRING`	Fee charged in destination token units for the swap transaction. String-encoded integer value representing the fee amount in the smallest unit of the destination token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	in_toTokenFee	block_timestamp	transaction_hash
0x076ed4502762aa6c4809a25651b0a150494f69dc	0x50a39b94b1dc8472faa08c36a3ef5b0a01c5bd10	false	0x35d531fd45d5e3a5d407a4898360c757c98bdf79	3	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	875304832	114190789	0x0b2c639c533813f4aa9d7837caf62653d097ff85	875109109	17506	2023-12-30T23:52:35.000Z	0x6a5f2bd0573cfe7ead5013f4cd6e651e11afef5c82908b344e020190fcbeaf6c
0x0825b2f46dbba2d05cfc1879fe91e2b360733766	0x50a39b94b1dc8472faa08c36a3ef5b0a01c5bd10	false	0x0825b2f46dbba2d05cfc1879fe91e2b360733766	57	0x7f5c764cbc14f9669b88837ca1490cca17c31607	2622126804	114166899	0x0b2c639c533813f4aa9d7837caf62653d097ff85	2622139457	52443	2023-12-30T10:36:15.000Z	0x656e8132439b61319e4c35890caba90ab78a2fd67d80da3cc979d8c7fc52008d
0x1111111254760f7ab3f16433eea9304126dcd199	0x50a39b94b1dc8472faa08c36a3ef5b0a01c5bd10	false	0xb63aae6c353636d66df13b89ba4425cfe13d10ba	9	0x7f5c764cbc14f9669b88837ca1490cca17c31607	99847316	114169276	0x0b2c639c533813f4aa9d7837caf62653d097ff85	99840248	1996	2023-12-30T11:55:29.000Z	0xd38bea41775f410d0e6cf2cae76924ee065ea29e380fd7e82673e5b79a4e08de

Example Query

Query with partition filter

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

DolaPool_SetFee_event

Fee configuration changes for Wombat V2’s DOLA stablecoin pool on Optimism, tracking liquidity provider dividend ratios and protocol retention ratios. Used for monitoring pool economics and fee structure evolution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x489818f2eeaef737105887710f7c5b9323ad3d01	false	9	112259666	2023-11-16T07:01:49.000Z	0x394b02cabb6f9340cbf4195bab33675d7132580e33bdc46753ea18102d3c3a87	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

DolaPool_SetHaircutRate_event

Haircut rate configuration events from Wombat Exchange’s DOLA stablecoin pool on Optimism, tracking risk parameter adjustments that affect withdrawal penalties during imbalanced pool states. Used for monitoring pool risk management and governance parameter 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x489818f2eeaef737105887710f7c5b9323ad3d01	false	400000000000000	44	118267732	2024-04-03T08:50:41.000Z	0xded9be66d5e14b5e1252f635d65e7887e29fcaecfa02012a57bfbf7b55936fcc
0x489818f2eeaef737105887710f7c5b9323ad3d01	false	200000000000000	18	118785254	2024-04-15T08:21:25.000Z	0xe30036b416b5b8421b067cbb591eea9ea5f342e54f896aaf70910e7120c5daa5

Example Query

Query with partition filter

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

DolaPool_Swap_event

Token swap events from Wombat Exchange’s DOLA stablecoin pool on Optimism. Contains exchange amounts, token addresses, and recipient data for analyzing liquidity pool trading activity and stablecoin swap 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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x859148bb1d6413061efeec2d4784c44cce4074a5	0x489818f2eeaef737105887710f7c5b9323ad3d01	false	0x35d531fd45d5e3a5d407a4898360c757c98bdf79	13	0x8ae125e8653821e851f12a49f7765db9a9ce7384	1536095672719438099775	113911044	0x7f5c764cbc14f9669b88837ca1490cca17c31607	1519369629	2023-12-24T12:27:45.000Z	0x330bbeb95dbeab994878a064be15737418f5ed52ee07ada54065f4b0edc8f171
0x859148bb1d6413061efeec2d4784c44cce4074a5	0x489818f2eeaef737105887710f7c5b9323ad3d01	false	0x35d531fd45d5e3a5d407a4898360c757c98bdf79	10	0x8ae125e8653821e851f12a49f7765db9a9ce7384	100682522063459760755	113901871	0x7f5c764cbc14f9669b88837ca1490cca17c31607	99553932	2023-12-24T07:21:59.000Z	0x5b540570293090554a5ee5b61f5a1ade48797f823c9118e93c1a614b143648b2
0x164572acff302ac81c257299fc5c2a074f069c34	0x489818f2eeaef737105887710f7c5b9323ad3d01	false	0x35d531fd45d5e3a5d407a4898360c757c98bdf79	17	0x8ae125e8653821e851f12a49f7765db9a9ce7384	603882354906439318638	113909894	0x7f5c764cbc14f9669b88837ca1490cca17c31607	597201238	2023-12-24T11:49:25.000Z	0x878a0ac13229a881bc955d8d85b75eea83b14aad01a9b3004e2c09d152a30292

Example Query

Query with partition filter

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

FraxPool_SetFee_event

Fee configuration changes for Wombat V2 FRAX stableswap pools on Optimism, tracking updates to retention ratios and liquidity provider (LP) dividend distribution parameters used for protocol revenue allocation.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	false	50	112259609	2023-11-16T06:59:55.000Z	0x0648b86f832f27880d0807d57a636ec789d31f1644c1bdddd6763b1cbef93d84	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

FraxPool_SetHaircutRate_event

Haircut rate configuration changes for Wombat v2 Frax liquidity pools on Optimism, tracking protocol risk parameter adjustments that determine withdrawal penalty rates. Used for monitoring pool safety mechanisms and governance parameter updates.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	false	400000000000000	42	118267732	2024-04-03T08:50:41.000Z	0xded9be66d5e14b5e1252f635d65e7887e29fcaecfa02012a57bfbf7b55936fcc
0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	false	200000000000000	16	118785254	2024-04-15T08:21:25.000Z	0xe30036b416b5b8421b067cbb591eea9ea5f342e54f896aaf70910e7120c5daa5

Example Query

Query with partition filter

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

FraxPool_Swap_event

Token swap events from Wombat V2’s Frax stablecoin pool on Optimism, recording exchanges between USDC and FRAX with sender, recipient, token addresses, and amounts. Used for analyzing stablecoin liquidity provision and swap volume in Wombat’s single-sided AMM.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	false	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	20	0x0b2c639c533813f4aa9d7837caf62653d097ff85	1041383	116035628	0x2e3d870790dc77a83dd1d18184acc7439a53f475	1038580412642386228	2024-02-11T16:47:13.000Z	0xf188c2c56e6692888621c07d5a2fe3f4f5a0475246247eff67b08608ec68610a
0xcc4dd8bc7967d46060ba3faaa8e525a35625f8b4	0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	false	0x0825b2f46dbba2d05cfc1879fe91e2b360733766	20	0x2e3d870790dc77a83dd1d18184acc7439a53f475	567433218464831152805	114080599	0x0b2c639c533813f4aa9d7837caf62653d097ff85	567401107	2023-12-28T10:39:35.000Z	0xc8644d48a80cec1d53e042af9e9d02ec70fde341cfa3d6c8d1a92958f55ffa67
0xcc4dd8bc7967d46060ba3faaa8e525a35625f8b4	0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	false	0x0825b2f46dbba2d05cfc1879fe91e2b360733766	51	0x2e3d870790dc77a83dd1d18184acc7439a53f475	959476610322092721113	114062884	0x0b2c639c533813f4aa9d7837caf62653d097ff85	960089444	2023-12-28T00:49:05.000Z	0xddd9225c132c341e4a404340b8d91abdc85a9a58902cb28f3ecc3cc741b3b3cd

Example Query

Query with partition filter

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

frxETHPool_SetFee_event

Fee configuration change events from Wombat V2’s frxETH liquidity pool on Optimism, capturing adjustments to retention ratios and LP dividend distribution parameters for the protocol’s fee structure.

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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0xb86ba65b75d34402bf377cf83b184554a18fcafa	false	22	112259839	2023-11-16T07:07:35.000Z	0xbe36f6944326bb5e76c2808f3a393d4040bd16d8c9e63c54ebca028cbc55f913	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

frxETHPool_SetHaircutRate_event

Haircut rate configuration events for Wombat V2’s frxETH (Frax Ether) pool on Optimism, capturing parameter changes that affect withdrawal penalties during pool imbalances. Used for tracking pool risk management and liquidity provider protections.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xb86ba65b75d34402bf377cf83b184554a18fcafa	false	400000000000000	45	118267732	2024-04-03T08:50:41.000Z	0xded9be66d5e14b5e1252f635d65e7887e29fcaecfa02012a57bfbf7b55936fcc
0xb86ba65b75d34402bf377cf83b184554a18fcafa	false	200000000000000	19	118785254	2024-04-15T08:21:25.000Z	0xe30036b416b5b8421b067cbb591eea9ea5f342e54f896aaf70910e7120c5daa5

Example Query

Query with partition filter

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

frxETHPool_Swap_event

Swap events from Wombat V2’s frxETH pool on Optimism, recording token exchanges between frxETH (Frax Ether) variants and WETH. Used for analyzing liquidity pool trading activity, swap volumes, and price impacts in the Wombat stableswap AMM.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x62b3e98afa30f94f382856a71d811ac41f5211a7	0xb86ba65b75d34402bf377cf83b184554a18fcafa	false	0x62b3e98afa30f94f382856a71d811ac41f5211a7	56	0x4200000000000000000000000000000000000006	76178943900243039	113683851	0x6806411765af15bddd26f8f544a34cc40cb9838b	76221336026540542	2023-12-19T06:14:39.000Z	0x417d01d337fe09cc788cafcb22a22d1fcdd77e39c6221386b6562af552b51223
0xb63aae6c353636d66df13b89ba4425cfe13d10ba	0xb86ba65b75d34402bf377cf83b184554a18fcafa	false	0xb63aae6c353636d66df13b89ba4425cfe13d10ba	35	0x4200000000000000000000000000000000000006	450201488801120251	113698747	0x6806411765af15bddd26f8f544a34cc40cb9838b	450502844549664439	2023-12-19T14:31:11.000Z	0xa1ad93e6de7e4aeeba556d961de65453c18723ed6f45cb66686027afcde618b9
0xb63aae6c353636d66df13b89ba4425cfe13d10ba	0xb86ba65b75d34402bf377cf83b184554a18fcafa	false	0xb63aae6c353636d66df13b89ba4425cfe13d10ba	14	0x4200000000000000000000000000000000000006	319982357784906180	113679134	0x484c2d6e3cdd945a8b2df735e079178c1036578c	300000000000000000	2023-12-19T03:37:25.000Z	0xe91e9ebbd3b2d37aed3e458db156ece83ef467e8543bc4fa03531090e32c714a

Example Query

Query with partition filter

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

USDVPool_SetFee_event

Fee configuration change events from Wombat V2’s USDV stablecoin pool on Optimism. Tracks updates to retention ratios and LP dividend distribution parameters for analyzing fee structure adjustments and liquidity provider incentive 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_lpDividendRatio`	`STRING`	Liquidity provider dividend ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.
`in_retentionRatio`	`STRING`	Retention ratio parameter for the pool fee structure. Decimal value represented as a string with 18-digit precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_retentionRatio	in_lpDividendRatio
0x1a023186ef2994249120cc7faedbea07f40c6fbd	false	4	112259641	2023-11-16T07:00:59.000Z	0x4c14702d8b6f440ff78b3a6307f1bf5ca7547f846243b07be10c3f4c4072cebe	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

USDVPool_SetHaircutRate_event

Haircut rate configuration events from Wombat V2’s USDV stablecoin pool on Optimism, tracking risk parameter adjustments that determine withdrawal penalties during imbalanced pool conditions. Used for monitoring pool risk management and governance parameter 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x1a023186ef2994249120cc7faedbea07f40c6fbd	false	200000000000000	17	118785254	2024-04-15T08:21:25.000Z	0xe30036b416b5b8421b067cbb591eea9ea5f342e54f896aaf70910e7120c5daa5
0x1a023186ef2994249120cc7faedbea07f40c6fbd	false	400000000000000	43	118267732	2024-04-03T08:50:41.000Z	0xded9be66d5e14b5e1252f635d65e7887e29fcaecfa02012a57bfbf7b55936fcc

Example Query

Query with partition filter

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

USDVPool_Swap_event

Token swap events from Wombat V2’s USDV stablecoin pool on Optimism, recording token exchanges with input/output amounts, addresses, and sender/recipient details. Useful for analyzing stablecoin liquidity, swap volume patterns, and price slippage on Wombat’s Optimism deployment.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_toToken	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	0x1a023186ef2994249120cc7faedbea07f40c6fbd	false	0xb63aae6c353636d66df13b89ba4425cfe13d10ba	11	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	44581721	115110680	0x323665443cef804a3b5206103304bd4872ea4253	44623552	2024-01-21T06:55:37.000Z	0xf57b8ea79df68452b2e6f4572fc76dcd64530cf59bdd203195fe5d3cf0aa4658
0x1111111254eeb25477b68fb85ed929f73a960582	0x1a023186ef2994249120cc7faedbea07f40c6fbd	false	0xb63aae6c353636d66df13b89ba4425cfe13d10ba	8	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	61134123	115122452	0x323665443cef804a3b5206103304bd4872ea4253	61255080	2024-01-21T13:28:01.000Z	0xb080e6a4f3d8a1cb8b18d56fb79eac0b21479186c2a38923ecdb7011a96eb6c9
0x1111111254eeb25477b68fb85ed929f73a960582	0x1a023186ef2994249120cc7faedbea07f40c6fbd	false	0xb63aae6c353636d66df13b89ba4425cfe13d10ba	35	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	134731157	115123396	0x323665443cef804a3b5206103304bd4872ea4253	135000000	2024-01-21T13:59:29.000Z	0x59d90f6cb1542f08a7ecdcb252cb47b01e4fb9a6ac65e3bcd89d3e184a7462a5

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

DolaPool_SetFee_event

DolaPool_SetHaircutRate_event

DolaPool_Swap_event

FraxPool_SetFee_event

FraxPool_SetHaircutRate_event

FraxPool_Swap_event

frxETHPool_SetFee_event

frxETHPool_SetHaircutRate_event

frxETHPool_Swap_event

USDVPool_SetFee_event

USDVPool_SetHaircutRate_event

USDVPool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CrossChainPool_SetFee_event

​CrossChainPool_SetHaircutRate_event

​CrossChainPool_SwapV2_event

​DolaPool_SetFee_event

​DolaPool_SetHaircutRate_event

​DolaPool_Swap_event

​FraxPool_SetFee_event

​FraxPool_SetHaircutRate_event

​FraxPool_Swap_event

​frxETHPool_SetFee_event

​frxETHPool_SetHaircutRate_event

​frxETHPool_Swap_event

​USDVPool_SetFee_event

​USDVPool_SetHaircutRate_event

​USDVPool_Swap_event

Tables

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

DolaPool_SetFee_event

DolaPool_SetHaircutRate_event

DolaPool_Swap_event

FraxPool_SetFee_event

FraxPool_SetHaircutRate_event

FraxPool_Swap_event

frxETHPool_SetFee_event

frxETHPool_SetHaircutRate_event

frxETHPool_Swap_event

USDVPool_SetFee_event

USDVPool_SetHaircutRate_event

USDVPool_Swap_event