wombat_v2_base

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
0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a	false	40	5363200	2023-10-17T04:09:07.000Z	0x911efed2bf3dfe2e08edd9b3df25384f54c4fef2dfc953abf1cdcd7d63415899	500000000000000000	500000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_base.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
0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a	false	400000000000000	11	11071567	2024-02-26T07:28:01.000Z	0x15a8d2e0a69612729c3de893d985356fda20fe210a424706e350d7578d4fcdf1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_base.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
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a	false	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	25	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	383770625	8269726	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	383737895	7675	2023-12-23T10:53:19.000Z	0x7501d6ff650a294049b4370f3df2306eb59c1312295839d977330e6a31f22f73
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a	false	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	20	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	68639937	8269686	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	68632573	1372	2023-12-23T10:51:59.000Z	0xc2c58c721bee0d5310f6bd4b3dbf87b7b020b984260e26684e254ccf2107a895
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a	false	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	22	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2128997148	8275232	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2129084969	42580	2023-12-23T13:56:51.000Z	0xcba04162eb7519c8c2fabea53c61ed2f4fe24604bd35c01596764827a6d67a2f

Example Query

Query with partition filter

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

USDSPool_SetFee_event

Fee configuration change events from Wombat V2’s USDS stablecoin pool on Base, recording updates to LP dividend ratios and retention ratios. Used for tracking protocol fee structure modifications and revenue distribution parameters.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x20d7b9ed2c4e2dcc55f9b463975b21bbf2a6ecd1	false	0	6879795	2023-11-21T06:42:17.000Z	0xe87b3bbfc4c481fee4c89d9b37587f8a6f79ca81e1c3d2047921f9b7463b3848	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

USDSPool_SetHaircutRate_event

Haircut rate parameter updates for the USDS stablecoin pool in Wombat V2 on Base chain. Records governance changes to the haircut rate (penalty fee applied during withdrawals when pool is imbalanced), useful for tracking risk parameter adjustments and protocol management decisions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x20d7b9ed2c4e2dcc55f9b463975b21bbf2a6ecd1	false	400000000000000	12	11071567	2024-02-26T07:28:01.000Z	0x15a8d2e0a69612729c3de893d985356fda20fe210a424706e350d7578d4fcdf1

Example Query

Query with partition filter

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

USDSPool_Swap_event

Swap events from Wombat v2 stablecoin pool on Base featuring USDS token exchanges. Tracks token swaps with sender, recipient, input/output token addresses and amounts for analyzing pool liquidity and trading 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
0xca2cebc209bcde7e178cbcddf7f3bbbe1a26fbc7	0x20d7b9ed2c4e2dcc55f9b463975b21bbf2a6ecd1	false	0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd	28	0xecf3e9b8ccb6f4a6efd68058fd706561c1727031	30097297567695238903	8675067	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	33600000	2024-01-01T20:04:41.000Z	0xd6de3a2181671b9bee6bbcc3d6dd18ec01fed6173e8bfb94e145b0f7fc1aef1c
0x5313514efdf0d5d812b5875ec38c9e4ea0de1e79	0x20d7b9ed2c4e2dcc55f9b463975b21bbf2a6ecd1	false	0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd	15	0xecf3e9b8ccb6f4a6efd68058fd706561c1727031	20925983431771451722	9107304	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	21001804	2024-01-11T20:12:35.000Z	0xc8ea8f2d1ae82af985c30be6046f34a36629596cebe8d701869d9142cfae6015
0x67c2715d8b40ce99288d67d7a949b88470c22c85	0x20d7b9ed2c4e2dcc55f9b463975b21bbf2a6ecd1	false	0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd	38	0xecf3e9b8ccb6f4a6efd68058fd706561c1727031	704542529767143226128	9090231	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	707035463	2024-01-11T10:43:29.000Z	0xeb596816c929f5907a827d04bea49fd0aa45f23b4cad684e865850e208a960de

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_base.USDSPool_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

USDSPool_SetFee_event

USDSPool_SetHaircutRate_event

USDSPool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CrossChainPool_SetFee_event

​CrossChainPool_SetHaircutRate_event

​CrossChainPool_SwapV2_event

​USDSPool_SetFee_event

​USDSPool_SetHaircutRate_event

​USDSPool_Swap_event

Tables

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

USDSPool_SetFee_event

USDSPool_SetHaircutRate_event

USDSPool_Swap_event