wombat_v2_avalanche

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	0	36551919	2023-10-17T06:00:56.000Z	0x700c26a4fc378a64d49372c8d4cbe4a507cceafae77f4a7a71a81be5de6717d3	500000000000000000	500000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_avalanche.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	3	43724842	2024-04-03T08:52:15.000Z	0xf1511eb7be3cb780edb82090e366d59a0676bdf33eb15feb9f853a992f51816b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_avalanche.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
0x1d39a90dac4596b36d60682b6cec147eb758af90	0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a	false	0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd	8	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	39998	36696256	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	40000	0	2023-10-20T15:59:37.000Z	0x823c3171ae80cac94fd7bc136051180e5b3f329e2ae6988acc17cbecf7c1d341
0xc3f0cb0b70ef09c17fbdea0059c0e85fd324f94b	0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a	false	0xc3f0cb0b70ef09c17fbdea0059c0e85fd324f94b	4	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	1099124237	36936009	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	1099225718	21982	2023-10-26T07:47:53.000Z	0x7c7c9b1f2701b4941afc204bd7e94c0afddf0a48f7feb3bed3cb3ed4bd06ae2d
0xadf5349df8186379a4e8c919c5d6fb447f8956f0	0xc9bfc3efefe4cf96877009f75a61f5c1937e5d1a	false	0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd	10	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	949930650	37039252	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	930000000	18998	2023-10-28T18:12:06.000Z	0x9faa0eb55b3a2e732533fdd07dc5807273407c4d4392aa20370d6b3edf32646f

Example Query

Query with partition filter

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

SAVAXPool_SetFee_event

Fee configuration events from Wombat Exchange’s SAVAX (Staked AVAX) pool on Avalanche, recording changes to retention and LP dividend ratios. Used for tracking protocol fee structure adjustments 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
0xe3abc29b035874a9f6dcdb06f8f20d9975069d87	false	0	36841295	2023-10-24T01:58:06.000Z	0xb16e0204a50b6d74789fd0acaeeacf9b6e59aca0f62459d08333be055c8c0d2e	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

SAVAXPool_SetHaircutRate_event

Haircut rate configuration changes for the sAVAX (staked AVAX) pool in Wombat Exchange V2 on Avalanche. Tracks adjustments to the stability fee parameter that affects withdrawal costs 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
0xe3abc29b035874a9f6dcdb06f8f20d9975069d87	false	20000000000000	19	43970022	2024-04-09T05:38:47.000Z	0x0741bf87e28ecb6c35098ec4db833b9385693fc80ccab7c0029bde4f905b0245
0xe3abc29b035874a9f6dcdb06f8f20d9975069d87	false	400000000000000	5	43724842	2024-04-03T08:52:15.000Z	0xf1511eb7be3cb780edb82090e366d59a0676bdf33eb15feb9f853a992f51816b

Example Query

Query with partition filter

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

SAVAXPool_Swap_event

Swap events from Wombat Exchange’s sAVAX liquidity pool on Avalanche, recording token exchanges between sAVAX (staked AVAX) and WAVAX with amounts, participants, and transaction details. Used for analyzing stablecoin-like swap volumes, liquidity provider activity, and price stability between liquid staking derivatives.

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
0xd291d9355a7b1a1d297b5f3c6c59f64458632ed1	0xe3abc29b035874a9f6dcdb06f8f20d9975069d87	false	0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd	24	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	3155788889603891692	36929339	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	3500000000000000000	2023-10-26T03:59:51.000Z	0x046500450096bbb6042f29125419ef6306e2f3878cdabe20a4d555edd4af1495
0x6a376d33decf462274c9d1768cbc1b9d6c1927bc	0xe3abc29b035874a9f6dcdb06f8f20d9975069d87	false	0x6a376d33decf462274c9d1768cbc1b9d6c1927bc	20	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	18881549853891298922	36961092	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	17020497221196443854	2023-10-26T21:52:13.000Z	0x16f567a2f2998b5272fbcfff2d12aef2cadd77c02579a13630eb784921058b23
0x6a376d33decf462274c9d1768cbc1b9d6c1927bc	0xe3abc29b035874a9f6dcdb06f8f20d9975069d87	false	0x6a376d33decf462274c9d1768cbc1b9d6c1927bc	52	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	19165181287872434437	36957142	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	17277191664131368863	2023-10-26T19:37:48.000Z	0x9d932d632862cc1f5fb7b9ad67202d636b1f9f36b12490db008957ae00b71126

Example Query

Query with partition filter

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

USDVPool_SetFee_event

Fee parameter change events from Wombat V2’s USDV stablecoin pool on Avalanche, capturing updates to retention ratios and LP dividend distribution settings for protocol revenue management.

Columns

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

Example Query

Query with partition filter

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

USDVPool_SetHaircutRate_event

Haircut rate parameter changes for the USDV pool in Wombat V2 protocol on Avalanche, tracking risk management adjustments where haircut represents the percentage deducted during withdrawals to protect liquidity providers.

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
0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02	false	400000000000000	4	43724842	2024-04-03T08:52:15.000Z	0xf1511eb7be3cb780edb82090e366d59a0676bdf33eb15feb9f853a992f51816b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_avalanche.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 Avalanche. Captures stablecoin exchanges with 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
0x1111111254eeb25477b68fb85ed929f73a960582	0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02	false	0x7ab5194e730c4ec4a9d1d7f1dcad9c173075888a	11	0x323665443cef804a3b5206103304bd4872ea4253	6008495614	38099217	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	5999699460	2023-11-22T14:43:25.000Z	0x008c977be94a2e5f770927f565f18cf5d18783c7c4cf25cb7a5dbf530c17d828
0x1111111254eeb25477b68fb85ed929f73a960582	0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02	false	0x7ab5194e730c4ec4a9d1d7f1dcad9c173075888a	9	0x323665443cef804a3b5206103304bd4872ea4253	24053021	38096312	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	23992854	2023-11-22T13:04:31.000Z	0xaccb06568c41998e0fcb3c83a2b3c0f7973e76205103cfbfde97920f650a74aa
0x1111111254eeb25477b68fb85ed929f73a960582	0x108c990c93fa8e3cd88ddb13594d39f09d9b3c02	false	0x7ab5194e730c4ec4a9d1d7f1dcad9c173075888a	11	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	964472817	38093537	0x323665443cef804a3b5206103304bd4872ea4253	966889551	2023-11-22T11:28:41.000Z	0x545261a33742588fc3bcb4272c0f3ba130428e955dbbf7d214ee587ac72d1fb5

Example Query

Query with partition filter

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

SAVAXPool_SetFee_event

SAVAXPool_SetHaircutRate_event

SAVAXPool_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

​SAVAXPool_SetFee_event

​SAVAXPool_SetHaircutRate_event

​SAVAXPool_Swap_event

​USDVPool_SetFee_event

​USDVPool_SetHaircutRate_event

​USDVPool_Swap_event

Tables

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

SAVAXPool_SetFee_event

SAVAXPool_SetHaircutRate_event

SAVAXPool_Swap_event

USDVPool_SetFee_event

USDVPool_SetHaircutRate_event

USDVPool_Swap_event