wombat_v2_ethereum

Tables

agEurPool_SetFee_event

Fee parameter update events from Wombat V2’s agEUR stablecoin pool on Ethereum. Tracks changes to liquidity provider (LP) dividend ratios and retention ratios used for protocol fee distribution.

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
0x0020a8890e723cd94660a5404c4bccbb91680db6	false	164	17832235	2023-08-03T04:58:11.000Z	0x5962fd3c145d2d0143d28c7d3e831e3c68e66a7a31fe3d1bdbcc47f9808aadc4	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

agEurPool_SetHaircutRate_event

Haircut rate configuration changes for the agEUR (Angle Euro stablecoin) pool on Wombat V2 Ethereum, tracking risk parameter adjustments that affect withdrawal penalties during imbalanced pool conditions.

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
0x0020a8890e723cd94660a5404c4bccbb91680db6	false	400000000000000	237	19292404	2024-02-23T19:34:11.000Z	0x2787a0cde39fee3670a123e6c5da86664a4a6877dcd4a562c0c8a953f0239700

Example Query

Query with partition filter

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

agEurPool_Swap_event

Token swap events from Wombat V2’s agEUR stablecoin pool on Ethereum. Tracks token exchanges between agEUR and Euro-pegged stablecoins with sender, recipient, amounts, and token addresses 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
0x65654ef196d92ff739a4de49a133887002a08df2	0x0020a8890e723cd94660a5404c4bccbb91680db6	false	0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	411	0x1a7e4e63778b4f12a199c062f3efdd288afcbce8	999800208708247704997	17850305	0x3231cb76718cdef2155fc47b5286d82e6eda273f	997912763353417052674	2023-08-05T17:37:35.000Z	0xba858a5bd804cffaff9720ae9028f761bed6d0bbf6297843bc4053524118ac83
0x65654ef196d92ff739a4de49a133887002a08df2	0x0020a8890e723cd94660a5404c4bccbb91680db6	false	0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	357	0x3231cb76718cdef2155fc47b5286d82e6eda273f	997912763353417049918	17850043	0x1a7e4e63778b4f12a199c062f3efdd288afcbce8	999999999999999999999	2023-08-05T16:44:35.000Z	0x023415def6bfdd57fb5a84b41d009ea5b57b8fd1e3ee15976441dc3c1d936a5b
0x735a26a57a0a0069dfabd41595a970faf5e1ee8b	0x0020a8890e723cd94660a5404c4bccbb91680db6	false	0x9db7378614d8d9d7149c4ee4763f88c38f9b1517	159	0x1a7e4e63778b4f12a199c062f3efdd288afcbce8	3622333986001715151615	18063520	0x3231cb76718cdef2155fc47b5286d82e6eda273f	3625393055860465403271	2023-09-04T13:49:47.000Z	0xb5865e57f1da2f839f964f9df20fbc53f27f0df22b4cffeefe9c5363657ecc05

Example Query

Query with partition filter

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

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
0xa45c0abeef67c363364e0e73832df9986aba3800	false	46	18018380	2023-08-29T06:04:59.000Z	0xa8e45d20ebe991713f0e129afa3eba75567f7db9b6087a6f8706a9da74315aa4	500000000000000000	500000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_ethereum.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
0xa45c0abeef67c363364e0e73832df9986aba3800	false	20000000000000	197	18225029	2023-09-27T05:30:59.000Z	0x953fa6e806ce58a92f85491a84a63ac5695d419d84d3e37e0bdb14da6fa91beb
0xa45c0abeef67c363364e0e73832df9986aba3800	false	400000000000000	235	19292404	2024-02-23T19:34:11.000Z	0x2787a0cde39fee3670a123e6c5da86664a4a6877dcd4a562c0c8a953f0239700

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_ethereum.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
0x5f515f6c524b18ca30f7783fb58dd4be2e9904ec	0xa45c0abeef67c363364e0e73832df9986aba3800	false	0x5f515f6c524b18ca30f7783fb58dd4be2e9904ec	301	0xdac17f958d2ee523a2206206994597c13d831ec7	542847358	18374218	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	543058025	10857	2023-10-18T02:18:59.000Z	0xa432d15363d2792e381143484c77e5aaa69a9ba07523d41599a67e16749acee5
0x5f515f6c524b18ca30f7783fb58dd4be2e9904ec	0xa45c0abeef67c363364e0e73832df9986aba3800	false	0x5f515f6c524b18ca30f7783fb58dd4be2e9904ec	397	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1572226713	18375465	0xdac17f958d2ee523a2206206994597c13d831ec7	1571673196	31445	2023-10-18T06:30:11.000Z	0x4f68c5ac324e0f51bfc6e96bc0da3cfe946fad9424a717c77baf82bfe001af02
0x1111111254eeb25477b68fb85ed929f73a960582	0xa45c0abeef67c363364e0e73832df9986aba3800	false	0x5f515f6c524b18ca30f7783fb58dd4be2e9904ec	321	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	4941212720	18379528	0xdac17f958d2ee523a2206206994597c13d831ec7	4940217420	98826	2023-10-18T20:09:47.000Z	0xb4fbfcb531f8676b38bd0659a6cf22a5e87f55a158ece54445f28af213ccbe28

Example Query

Query with partition filter

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

EthxPool_SetFee_event

Fee configuration change events from Wombat V2’s ETHX liquidity pool on Ethereum, capturing retention and LP dividend ratio updates. Used to track fee structure adjustments and revenue distribution parameters over time.

Columns

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

Example Query

Query with partition filter

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

EthxPool_SetHaircutRate_event

Haircut rate parameter updates for the Wombat V2 ETHX stablecoin pool on Ethereum, where haircut rate controls withdrawal penalties during imbalanced pool conditions. Used for tracking pool risk parameter governance changes and their impact on liquidity provider incentives.

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
0x647cc8816c2d60a5ff4d1ffef27a5b3637d5ac81	false	400000000000000	241	19292404	2024-02-23T19:34:11.000Z	0x2787a0cde39fee3670a123e6c5da86664a4a6877dcd4a562c0c8a953f0239700

Example Query

Query with partition filter

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

EthxPool_Swap_event

Swap events from Wombat V2’s ETHx pool on Ethereum, recording token exchanges between WETH (Wrapped Ether) and ETHx with swap amounts, sender addresses, and recipient details. Used for analyzing liquidity pool trading activity and price discovery between ETH and its liquid staking derivative.

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
0x4c81f1b8b4a6b1897c18f5edd110a96ff94c9fde	0x647cc8816c2d60a5ff4d1ffef27a5b3637d5ac81	false	0x6bb82a9b0b9b9716b885baeefdbe47b685a0f919	92	0xa35b1b31ce002fbf2058d22f30f95d405200a15b	29719867614799071	18339995	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	30000000000000000	2023-10-13T07:31:11.000Z	0xd417dedd03b9b52e83d2414e0aadf91c5784cfefd46d9e969dae600fcf1a2a37
0x1111111254fb6c44bac0bed2854e76f90643097d	0x647cc8816c2d60a5ff4d1ffef27a5b3637d5ac81	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	140	0xa35b1b31ce002fbf2058d22f30f95d405200a15b	1980996213045497321	18338365	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2000000000000000000	2023-10-13T02:00:47.000Z	0x74ee746af8e8148e13163bd7115725ec06770a376078db42a122ad47a0366b1c
0xe37e799d5077682fa0a244d46e5649f71457bd09	0x647cc8816c2d60a5ff4d1ffef27a5b3637d5ac81	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	383	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	15005620913785629252	18338762	0xa35b1b31ce002fbf2058d22f30f95d405200a15b	14868004119374462743	2023-10-13T03:21:11.000Z	0xc6c2a4246342b95877d4ef573488334648d923e06166a4090baa1134531a7cc8

Example Query

Query with partition filter

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

fraxEthPool_SetFee_event

Fee configuration change events from the Wombat V2 fraxETH pool on Ethereum, tracking updates to LP dividend and retention ratios. Used for analyzing fee structure modifications and pool economics over time.

Columns

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

Example Query

Query with partition filter

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

fraxEthPool_SetHaircutRate_event

Haircut rate parameter changes for the Wombat V2 fraxETH pool on Ethereum, recording governance adjustments to the fee charged on withdrawals that create pool imbalances. Used for tracking pool risk management 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_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
0x3161f40ea6c0c4cc8b2433d6d530ef255816e854	false	400000000000000	239	19292404	2024-02-23T19:34:11.000Z	0x2787a0cde39fee3670a123e6c5da86664a4a6877dcd4a562c0c8a953f0239700

Example Query

Query with partition filter

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

fraxEthPool_Swap_event

Swap events from Wombat V2’s Frax Ethereum pool on Ethereum, capturing token exchanges between WETH (Wrapped Ether), frxETH (Frax Ether), and sfrxETH (Staked Frax Ether). Contains sender/recipient addresses, token amounts, and swap directions for analyzing liquidity pool activity and stablecoin-ETH derivative 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
0x1111111254eeb25477b68fb85ed929f73a960582	0x3161f40ea6c0c4cc8b2433d6d530ef255816e854	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	288	0xac3e018457b222d93114458476f3e3416abbe38f	28498745686491740	18343300	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	30187893486143307	2023-10-13T18:36:23.000Z	0x188e40ed2e2cab1a8db5481cbf583b27e75da38770be2b801f2ef7e0bcf6ec67
0x3208684f96458c540eb08f6f01b9e9afb2b7d4f0	0x3161f40ea6c0c4cc8b2433d6d530ef255816e854	false	0x3208684f96458c540eb08f6f01b9e9afb2b7d4f0	161	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	754951119503217836	18086467	0x5e8422345238f34275888049021821e8e08caa1f	756185427978491907	2023-09-07T18:54:35.000Z	0x5e16b2e8c7e0b98e3eac8a8ff2d42b69d9a7c99cc53bb070124e9b0ae5de6d71
0x3208684f96458c540eb08f6f01b9e9afb2b7d4f0	0x3161f40ea6c0c4cc8b2433d6d530ef255816e854	false	0x3208684f96458c540eb08f6f01b9e9afb2b7d4f0	237	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	1055131701790510123	18086450	0x5e8422345238f34275888049021821e8e08caa1f	1056593432183017882	2023-09-07T18:51:11.000Z	0x528fc0bd3e4689c2aeeef12d80681fadcf5b2650e2125deae709418a41c0fabb

Example Query

Query with partition filter

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

FraxPool_SetFee_event

Fee parameter update events from Wombat V2’s Frax liquidity pool on Ethereum, recording changes to LP dividend and retention ratios. Used for tracking pool economics and fee distribution configuration over time.

Columns

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

Example Query

Query with partition filter

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

FraxPool_SetHaircutRate_event

Haircut rate parameter updates for Wombat V2’s FRAX liquidity pool on Ethereum, tracking changes to the slippage penalty applied during asset swaps. Used to analyze pool risk management and fee structure adjustments over time.

Columns

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

Example Query

Query with partition filter

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

FraxPool_Swap_event

No description available.

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

No sample data available.

Example Query

Query with partition filter

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

WstethPool_SetFee_event

Fee configuration events from Wombat V2’s wrapped staked ETH (wstETH) pool on Ethereum, capturing changes to LP dividend and retention ratios. Used for tracking pool economics and revenue distribution 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_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
0xf8e32ca46ac28799c8fb7dce1ac11a4541160734	false	222	17832272	2023-08-03T05:05:35.000Z	0x838b153c89fcfaa2a54fbef4a9b11756ce73a668820fd87c22299cf7449943ae	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

WstethPool_SetHaircutRate_event

Haircut rate configuration changes for Wombat’s wstETH liquidity pool on Ethereum, tracking risk parameter adjustments that affect withdrawal penalties during imbalanced pool conditions.

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
0xf8e32ca46ac28799c8fb7dce1ac11a4541160734	false	400000000000000	240	19292404	2024-02-23T19:34:11.000Z	0x2787a0cde39fee3670a123e6c5da86664a4a6877dcd4a562c0c8a953f0239700

Example Query

Query with partition filter

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

WstethPool_Swap_event

Swap events from Wombat V2’s wrapped staked ETH (wstETH) pool on Ethereum, capturing token exchanges between WETH (0xc02a…) and wstETH (0x7f39…). Used for analyzing liquidity pool trading activity, exchange rates, and user swap patterns in Wombat’s stablecoin-optimized 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
0x1111111254eeb25477b68fb85ed929f73a960582	0xf8e32ca46ac28799c8fb7dce1ac11a4541160734	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	368	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	1137655326753442311	18382622	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	1300000000000000000	2023-10-19T06:32:59.000Z	0x4406530be2b6251078816c7f0aa81f6141db4c21f969fe1eefc9ceaf1cc20e47
0xe37e799d5077682fa0a244d46e5649f71457bd09	0xf8e32ca46ac28799c8fb7dce1ac11a4541160734	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	31	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	1779599880891245334	18387043	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2034127991494713688	2023-10-19T21:24:35.000Z	0xaf2aea3e228dae59a52bbce026383c04c76e89ddb419a9817b66b15e7ff86ecb
0xe37e799d5077682fa0a244d46e5649f71457bd09	0xf8e32ca46ac28799c8fb7dce1ac11a4541160734	false	0xe37e799d5077682fa0a244d46e5649f71457bd09	45	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	23220910782328477	18381743	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	20335327961844566	2023-10-19T03:35:59.000Z	0x86678c81cd56dd36574d7532f974a30cb855f154c9faf89abd76a9dd688ce35e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

agEurPool_SetFee_event

agEurPool_SetHaircutRate_event

agEurPool_Swap_event

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

EthxPool_SetFee_event

EthxPool_SetHaircutRate_event

EthxPool_Swap_event

fraxEthPool_SetFee_event

fraxEthPool_SetHaircutRate_event

fraxEthPool_Swap_event

FraxPool_SetFee_event

FraxPool_SetHaircutRate_event

FraxPool_Swap_event

WstethPool_SetFee_event

WstethPool_SetHaircutRate_event

WstethPool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​agEurPool_SetFee_event

​agEurPool_SetHaircutRate_event

​agEurPool_Swap_event

​CrossChainPool_SetFee_event

​CrossChainPool_SetHaircutRate_event

​CrossChainPool_SwapV2_event

​EthxPool_SetFee_event

​EthxPool_SetHaircutRate_event

​EthxPool_Swap_event

​fraxEthPool_SetFee_event

​fraxEthPool_SetHaircutRate_event

​fraxEthPool_Swap_event

​FraxPool_SetFee_event

​FraxPool_SetHaircutRate_event

​FraxPool_Swap_event

​WstethPool_SetFee_event

​WstethPool_SetHaircutRate_event

​WstethPool_Swap_event

Tables

agEurPool_SetFee_event

agEurPool_SetHaircutRate_event

agEurPool_Swap_event

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

EthxPool_SetFee_event

EthxPool_SetHaircutRate_event

EthxPool_Swap_event

fraxEthPool_SetFee_event

fraxEthPool_SetHaircutRate_event

fraxEthPool_Swap_event

FraxPool_SetFee_event

FraxPool_SetHaircutRate_event

FraxPool_Swap_event

WstethPool_SetFee_event

WstethPool_SetHaircutRate_event

WstethPool_Swap_event