wombat_v2_arbitrum

Tables

BobPool_SetFee_event

Fee configuration change events from Wombat V2’s BobPool contract on Arbitrum, capturing updates to LP dividend ratios and retention ratios. Used for tracking fee structure adjustments and analyzing protocol 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
0x917caf2b4d6040a9d67a5f8cefc4f89d1b214c1a	false	21	76814186	2023-04-04T02:59:55.000Z	0xd62e7c5a220eff15ab78904323786a5702b8d51df0ec303d02d65971c9d8fd6e	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

BobPool_SetHaircutRate_event

Haircut rate parameter changes for Wombat’s BobPool on Arbitrum, recording administrative adjustments to the protocol’s withdrawal penalty rate. Used for tracking risk parameter governance and pool configuration history.

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
0x917caf2b4d6040a9d67a5f8cefc4f89d1b214c1a	false	100000000000000	59	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe
0x917caf2b4d6040a9d67a5f8cefc4f89d1b214c1a	false	400000000000000	6	197100966	2024-04-03T08:48:19.000Z	0x0e2858fa377ec608e2f795db2177963563d2656f4c67f6f382a656e71dae8024

Example Query

Query with partition filter

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

BobPool_Swap_event

Swap event logs from Wombat V2 BobPool on Arbitrum, capturing token exchanges with input/output amounts, token addresses, and participant details. Used for analyzing liquidity pool trading patterns and token swap volumes.

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
0x0aacc6124269f9591a5fcb33d34654918c151221	0x917caf2b4d6040a9d67a5f8cefc4f89d1b214c1a	false	0x0aacc6124269f9591a5fcb33d34654918c151221	6	0xb0b195aefa3650a6908f15cdac7d92f8a5791b0b	272491238428871844133	88691050	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	272475579	2023-05-08T20:45:02.000Z	0x56b377f4b93621d609309ff68bd9d1e9def9e39866e300502764a98053fff2ac
0x1f635e0e79016e2cf89b31611d13646ec538e8c1	0x917caf2b4d6040a9d67a5f8cefc4f89d1b214c1a	false	0x1f635e0e79016e2cf89b31611d13646ec538e8c1	106	0xb0b195aefa3650a6908f15cdac7d92f8a5791b0b	36427150495462705713	88550119	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	36422990	2023-05-08T10:54:06.000Z	0x3022a2f0b187e42708726c4ac5083eea84a155bbce154543508976a1fcb92cfc
0x1f635e0e79016e2cf89b31611d13646ec538e8c1	0x917caf2b4d6040a9d67a5f8cefc4f89d1b214c1a	false	0x1f635e0e79016e2cf89b31611d13646ec538e8c1	47	0xb0b195aefa3650a6908f15cdac7d92f8a5791b0b	41747448079205288109	88399438	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	41739321	2023-05-08T00:15:44.000Z	0x578430a3d70bdaea06814e1abba8d18942494bf4bc0afa77bee11660cc9786fa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_arbitrum.BobPool_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
0xe78876c360716f2225f55a6726b32324fe1b1145	false	1	125983517	2023-08-29T05:57:03.000Z	0xb8eeb2dc0bcc306b5104975fcdd268cf1a5dc8c958bbe4c3aeda54d706d16156	500000000000000000	500000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_arbitrum.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
0xe78876c360716f2225f55a6726b32324fe1b1145	false	20000000000000	8	134991263	2023-09-27T04:42:35.000Z	0xe46ca0f58642567a1a1165cd4e30a624b4872f06f87ab743c244d9a56d556c13

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.wombat_v2_arbitrum.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
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197	0xe78876c360716f2225f55a6726b32324fe1b1145	false	0x9e52272477c2fcbe2c38bf12dd06cb5739975867	29	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2154532808	175038671	0xaf88d065e77c8cc2239327c5edb3a432268e5831	2154272264	43091	2024-01-28T12:17:50.000Z	0x5ec5204b1dca2e704807b9471a7c59455cdd9ec7cd16422d059957aa44b6368a
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197	0xe78876c360716f2225f55a6726b32324fe1b1145	false	0x9e52272477c2fcbe2c38bf12dd06cb5739975867	10	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	795678469	175188724	0xaf88d065e77c8cc2239327c5edb3a432268e5831	795498536	15913	2024-01-28T22:52:48.000Z	0xfc8cd141c6ad7aab15b8f76dde4a4f451888f4b241a327e780e6dc66fc2b3719
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0xe78876c360716f2225f55a6726b32324fe1b1145	false	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	24	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	116842629	175014035	0xaf88d065e77c8cc2239327c5edb3a432268e5831	116828760	2336	2024-01-28T10:34:35.000Z	0x1c075f2b5f9f56674dab2d234eb690a459036e8ccc89f5cf6645e26a149e6657

Example Query

Query with partition filter

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

FraxEthPool_SetFee_event

Fee parameter update events from the Wombat V2 FraxETH liquidity pool on Arbitrum, tracking changes to retention ratios and LP dividend ratios. Used for monitoring pool configuration changes 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_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
0x20d7ee728900848752fa280fad51af40c47302f1	false	28	76524033	2023-04-03T06:33:43.000Z	0x2fc03e6296fc2e30631e2a07ccbfcfb2d61ef6fce67d798f4dc413ebed4e3047	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

FraxEthPool_SetHaircutRate_event

Haircut rate configuration changes for the Wombat V2 frxETH liquidity pool on Arbitrum. Records protocol parameter updates that control withdrawal penalties, useful for tracking risk management 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
0x20d7ee728900848752fa280fad51af40c47302f1	false	1000000000000000	61	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe
0x20d7ee728900848752fa280fad51af40c47302f1	false	400000000000000	29	84783456	2023-04-27T09:16:15.000Z	0xd6f20ac879cce01c24cd13984b0e3e64369189facafd292e2187c01933c3c013

Example Query

Query with partition filter

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

FraxEthPool_Swap_event

Swap transactions from Wombat V2’s FraxETH liquidity pool on Arbitrum, recording token exchanges between frxETH, sfrxETH, and WETH with amounts and participant addresses. Useful for analyzing liquidity provision patterns and price discovery in Frax’s Ethereum-pegged stablecoin ecosystem.

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
0x0000900e00070d8090169000d2b090b67f0c1050	0x20d7ee728900848752fa280fad51af40c47302f1	false	0x0000900e00070d8090169000d2b090b67f0c1050	11	0x178412e79c25968a32e89b11f63b33f733770c2a	307016673379776408	110793023	0x95ab45875cffdba1e5f451b950bc2e42c0053f39	292810640134140854	2023-07-13T13:10:27.000Z	0x10ba7745fd73247b4544638ba84d0b015d30ee5c0bd823613de91b016e5c0445
0x018feadd83a8f2ad4d2508469a3a3215483c4377	0x20d7ee728900848752fa280fad51af40c47302f1	false	0x018feadd83a8f2ad4d2508469a3a3215483c4377	15	0x95ab45875cffdba1e5f451b950bc2e42c0053f39	1367211170531532710	110642099	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1429923000000000000	2023-07-13T02:37:35.000Z	0xa854f315eb4f9e127b13c10cdc770247970e6d2ee502f9c635ead28f64479732
0x1f5a3c42f26b72c917b3625c7a964ca33600fa25	0x20d7ee728900848752fa280fad51af40c47302f1	false	0x1f5a3c42f26b72c917b3625c7a964ca33600fa25	25	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	809571246071243203	110924651	0x178412e79c25968a32e89b11f63b33f733770c2a	818293104204462932	2023-07-13T22:29:20.000Z	0x76666dc227f81b2e80045ca391106f0ac8fca7247d2b06ffcecee409a944cdbb

Example Query

Query with partition filter

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

FraxMaiUsdPool_SetFee_event

Fee configuration changes for the Wombat V2 FRAX-MAI-USD liquidity pool on Arbitrum, tracking updates to retention and LP dividend ratios. Used for monitoring fee structure adjustments and protocol 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
0x4a8686df475d4c44324210ffa3fc1dea705296e0	false	1	76843667	2023-04-04T05:05:51.000Z	0x3c1d508acd9097e5948bf5f95c02a292dafb78b60bdcddbe2f7cd51537e35c5f	0	500000000000000000
0x4a8686df475d4c44324210ffa3fc1dea705296e0	false	0	76651814	2023-04-03T15:24:39.000Z	0xa182c87ab741d76baec66b87110f7c9930aeff7859f7563ad3a8899ce9aa59a6	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

FraxMaiUsdPool_SetHaircutRate_event

Haircut rate parameter changes for the Wombat V2 FRAX-MAI-USD stablecoin pool on Arbitrum. Records when the protocol adjusts the haircut rate, which affects slippage and withdrawal penalties during pool imbalances.

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
0x4a8686df475d4c44324210ffa3fc1dea705296e0	false	100000000000000	60	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe
0x4a8686df475d4c44324210ffa3fc1dea705296e0	false	400000000000000	5	197100966	2024-04-03T08:48:19.000Z	0x0e2858fa377ec608e2f795db2177963563d2656f4c67f6f382a656e71dae8024

Example Query

Query with partition filter

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

FraxMaiUsdPool_Swap_event

Swap events from Wombat V2’s FRAX-MAI-USD stablecoin pool on Arbitrum, recording token exchanges with input/output amounts, token addresses, and trader information. Used for analyzing stablecoin swap activity, liquidity patterns, and price stability across USDC, FRAX, and MAI assets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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
0xa669e7a0d4b3e4fa48af2de86bd4cd7126be4e13	0x4a8686df475d4c44324210ffa3fc1dea705296e0	false	0x7f137d1d8d20ba54004ba358e9c229da26fa3fa9	6	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	11004561115951152820	173837680	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	11000000	2024-01-24T22:35:02.000Z	0x7f63bb4e52ba57b8ac8104b2df8551b15ab5481fdc90abbf3ca735877e1b648c
0x7f137d1d8d20ba54004ba358e9c229da26fa3fa9	0x4a8686df475d4c44324210ffa3fc1dea705296e0	false	0x7f137d1d8d20ba54004ba358e9c229da26fa3fa9	37	0xe80772eaf6e2e18b651f160bc9158b2a5cafca65	5021266	173667593	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	5020657	2024-01-24T10:32:45.000Z	0x43aeb63eeb49c6b614920f786e9896decfb41d2dbd797bf0130ccaec1d16eec3
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0x4a8686df475d4c44324210ffa3fc1dea705296e0	false	0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	29	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	50033871	148093585	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	50004762680679507105	2023-11-07T17:35:50.000Z	0xe71e1111d3c2c06a9f61d8cd0d689302f2355507d124fde1cf66a09a52b2e3ba

Example Query

Query with partition filter

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

MimPool_SetFee_event

Fee configuration events from Wombat Exchange’s MIM (Magic Internet Money) stablecoin pool on Arbitrum, recording changes to retention and LP dividend ratios. Used for tracking fee structure updates and liquidity provider incentive 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
0x29eeb257a2a6ecde2984acedf80a1b687f18ec91	false	20	76814186	2023-04-04T02:59:55.000Z	0xd62e7c5a220eff15ab78904323786a5702b8d51df0ec303d02d65971c9d8fd6e	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

MimPool_SetHaircutRate_event

Haircut rate parameter updates for the MIM stablecoin pool in Wombat v2 on Arbitrum, tracking risk management adjustments that affect withdrawal penalties during liquidity imbalances. Values are in basis points (e.g., 400000000000000 = 0.04% haircut rate).

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
0x29eeb257a2a6ecde2984acedf80a1b687f18ec91	false	400000000000000	4	197100966	2024-04-03T08:48:19.000Z	0x0e2858fa377ec608e2f795db2177963563d2656f4c67f6f382a656e71dae8024
0x29eeb257a2a6ecde2984acedf80a1b687f18ec91	false	100000000000000	58	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe

Example Query

Query with partition filter

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

MimPool_Swap_event

Token swap events from Wombat V2’s MIM (Magic Internet Money) pool on Arbitrum, recording token exchanges with amounts, addresses, and transaction details. Useful for analyzing MIM stablecoin liquidity and swap patterns in Wombat’s stableswap pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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
0x7e3e803e966291ee9aa69e6fada116cd07462e5d	0x29eeb257a2a6ecde2984acedf80a1b687f18ec91	false	0x7e3e803e966291ee9aa69e6fada116cd07462e5d	42	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	21607694	124099071	0xfea7a6a0b346362bf88a9e4a88416b77a57d6c2a	21625256932914578357	2023-08-23T06:42:06.000Z	0x9fa879ea86a1a511169b7c4ffd60e4385e69c10a73a110129b21a2f9a1aa1d3b
0x7e3e803e966291ee9aa69e6fada116cd07462e5d	0x29eeb257a2a6ecde2984acedf80a1b687f18ec91	false	0x7e3e803e966291ee9aa69e6fada116cd07462e5d	6	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2178415	124320677	0xfea7a6a0b346362bf88a9e4a88416b77a57d6c2a	2179302182723371741	2023-08-23T23:04:39.000Z	0xca0f2f7a7a7903c7ecc65cfbd153e783bd8c263daebcd0d0fa2eaa36716c9bd4
0x7e3e803e966291ee9aa69e6fada116cd07462e5d	0x29eeb257a2a6ecde2984acedf80a1b687f18ec91	false	0x7e3e803e966291ee9aa69e6fada116cd07462e5d	35	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	11414189	124217175	0xfea7a6a0b346362bf88a9e4a88416b77a57d6c2a	11425025909234115676	2023-08-23T15:02:06.000Z	0xc811e2c64ec48b616ad3ee514b7d9c64e6c7ae958db1db002296c84fc1119a82

Example Query

Query with partition filter

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

MWOMPool_SetFee_event

Fee configuration changes for Wombat Exchange liquidity pools on Arbitrum, capturing retention ratio and LP dividend ratio updates. Used for tracking protocol fee structure modifications and analyzing revenue distribution between the protocol and 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_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
0x90ecddec4e4116e30769a4e1ea52c319aca338b6	false	22	76814186	2023-04-04T02:59:55.000Z	0xd62e7c5a220eff15ab78904323786a5702b8d51df0ec303d02d65971c9d8fd6e	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

MWOMPool_SetHaircutRate_event

Haircut rate configuration changes for Wombat Exchange mWOM pools on Arbitrum, tracking risk parameter adjustments that affect withdrawal penalties. Used to monitor pool safety parameters and governance decisions on collateral haircuts.

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
0x90ecddec4e4116e30769a4e1ea52c319aca338b6	false	2500000000000000	10	76871403	2023-04-04T07:03:38.000Z	0xd9e73ca9160d81fb77b555bab013c5f96a6ab354d3bee50e37a17c4468bd282b
0x90ecddec4e4116e30769a4e1ea52c319aca338b6	false	2000000000000000	62	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe

Example Query

Query with partition filter

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

MWOMPool_Swap_event

Token swap events from Wombat V2 liquidity pools on Arbitrum, capturing input/output token addresses, amounts, and recipient details. Used for analyzing swap flows, pool utilization, and liquidity routing 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
0x176ff4b2ae3682f96c7111a52d9f9e5abcb6e951	0x90ecddec4e4116e30769a4e1ea52c319aca338b6	false	0xc4b2f992496376c6127e73f1211450322e580668	16	0x509fd25ee2ac7833a017f17ee8a6fb4aaf947876	11340530110786662505188	243296133	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	10000000000006487131608	2024-08-16T00:43:31.000Z	0xa3c3e0bd4b576dbde0fd3d4c135a16f7105f706381c1d2a7cc812d3eb7398dd8
0x1a7728e8560b386905d1614cb5abbf33987dc562	0x90ecddec4e4116e30769a4e1ea52c319aca338b6	false	0xc4b2f992496376c6127e73f1211450322e580668	26	0x509fd25ee2ac7833a017f17ee8a6fb4aaf947876	4702040018445683469827	243474616	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	4241285947571195099991	2024-08-16T13:10:19.000Z	0x036c2bf216cee507f340c9bee26a7e0cb7ddfb5678f9e661eab70ac0ea1f204d
0x0dc9f59955d80ff36528dbbe378f5060bb8b348d	0x90ecddec4e4116e30769a4e1ea52c319aca338b6	false	0xc4b2f992496376c6127e73f1211450322e580668	3	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	17033366353010541708	141585645	0x509fd25ee2ac7833a017f17ee8a6fb4aaf947876	23176476611573417158	2023-10-18T04:16:16.000Z	0x291a2bdd7ed5087499c33398d58396de3b5524f0383369c7157637a08833b40a

Example Query

Query with partition filter

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

Pool_SetFee_event

Fee configuration change events from Wombat V2 liquidity pools on Arbitrum, tracking updates to LP dividend ratios and protocol retention ratios. Used for analyzing fee structure evolution and revenue distribution parameters across pools.

Columns

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

Example Query

Query with partition filter

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

Pool_SetHaircutRate_event

Haircut rate parameter updates for Wombat V2 liquidity pools on Arbitrum, recording changes to the protocol’s coverage ratio safety mechanism. Used for tracking risk parameter adjustments that affect how pools handle withdrawals during volatility.

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
0xc6bc781e20f9323012f6e422bdf552ff06ba6cd1	false	20000000000000	9	124482391	2023-08-24T11:03:55.000Z	0xa48dff33b4eb26a75a329a2c4bb9fa63a0df3f4714de11f6768304e7cf3d8da9
0xc6bc781e20f9323012f6e422bdf552ff06ba6cd1	false	400000000000000	2	197100966	2024-04-03T08:48:19.000Z	0x0e2858fa377ec608e2f795db2177963563d2656f4c67f6f382a656e71dae8024
0xc6bc781e20f9323012f6e422bdf552ff06ba6cd1	false	100000000000000	56	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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
0xa38f9b1c6c4fbea7e9e714b224e4efe9faf419d6	0xc6bc781e20f9323012f6e422bdf552ff06ba6cd1	false	0xa38f9b1c6c4fbea7e9e714b224e4efe9faf419d6	40	0xaf88d065e77c8cc2239327c5edb3a432268e5831	12314878	222483243	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	12319963	2024-06-16T14:14:15.000Z	0xc12484369d85064862e5600c23607b8c72f77c6e9ffd03e0f8e14532285c1ab6
0xa669e7a0d4b3e4fa48af2de86bd4cd7126be4e13	0xc6bc781e20f9323012f6e422bdf552ff06ba6cd1	false	0x0f32a1597b43a8cb2f20e8d3023a39c532ff6978	24	0xaf88d065e77c8cc2239327c5edb3a432268e5831	4248476	222603120	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	4247452	2024-06-16T22:33:50.000Z	0xa84ddd8f97cc9784d45867a4f091d45f9f8b448a957968e6429b847f4d629384
0xa669e7a0d4b3e4fa48af2de86bd4cd7126be4e13	0xc6bc781e20f9323012f6e422bdf552ff06ba6cd1	false	0x0f32a1597b43a8cb2f20e8d3023a39c532ff6978	28	0xaf88d065e77c8cc2239327c5edb3a432268e5831	22048859	222604977	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	22055969	2024-06-16T22:41:38.000Z	0xd7ae46e39b7f1f588215cdd75031fa0912748cd78b43001640f6c0cf19d2dbd1

Example Query

Query with partition filter

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

QWOMPool_SetFee_event

Fee configuration updates for Wombat V2’s QWOM pool on Arbitrum, recording changes to LP dividend 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
0x12fa5ab079cff564d599466d39715d35d90af978	false	16	76749284	2023-04-03T22:14:37.000Z	0x82ea5140a35ede6061baf09e38f1708a9ed890e4eac38aa18c41c5c8534a475a	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

QWOMPool_SetHaircutRate_event

Haircut rate parameter updates for Wombat Exchange’s qWOM (veWOM staking token) pool on Arbitrum. Records governance changes to the haircut rate, a risk parameter controlling 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
0x12fa5ab079cff564d599466d39715d35d90af978	false	2000000000000000	64	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe
0x12fa5ab079cff564d599466d39715d35d90af978	false	2500000000000000	12	76871403	2023-04-04T07:03:38.000Z	0xd9e73ca9160d81fb77b555bab013c5f96a6ab354d3bee50e37a17c4468bd282b

Example Query

Query with partition filter

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

QWOMPool_Swap_event

Token swap events from Wombat Exchange’s QWOM pool on Arbitrum, recording trades between token pairs with amounts, participants, and routing addresses. Useful for analyzing QWOM token trading activity and liquidity pool dynamics.

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
0x2031975d8f76c8cec2ab699d34d8eac31801e5a1	0x12fa5ab079cff564d599466d39715d35d90af978	false	0xc4b2f992496376c6127e73f1211450322e580668	5	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	11869124387340255020990	241718150	0x388d157f0bfdc1d30357af63a8be10bff8474f4e	14607000000000000000000	2024-08-11T10:24:59.000Z	0x66c40383468b3767686fb43cb39f8ca9045cdad14c7eb29a1e5d5d4d34d68da6
0x7e9e10514f6a98825c4f54b728ebd41c9c24bdd6	0x12fa5ab079cff564d599466d39715d35d90af978	false	0xc4b2f992496376c6127e73f1211450322e580668	40	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	50038746791097138500	86552868	0x388d157f0bfdc1d30357af63a8be10bff8474f4e	63138169963895222807	2023-05-02T14:16:49.000Z	0xab895972183a6a3e343fd9e3b0339554107685e486c16e09978c32ba4a5c90dd
0x289590572d0e6011b7475a99307cecf47e7d3a0a	0x12fa5ab079cff564d599466d39715d35d90af978	false	0xc4b2f992496376c6127e73f1211450322e580668	5	0x388d157f0bfdc1d30357af63a8be10bff8474f4e	31722688902830124510	86580303	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	25240361521968727741	2023-05-02T16:10:36.000Z	0x45f99737cef34ed46931fb58029da21d1426d3b6deea91743142cfc25fb72385

Example Query

Query with partition filter

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

UsdPlusPool_SetFee_event

Fee configuration change events from Wombat’s USD+ pool on Arbitrum, capturing updates to LP dividend ratios and retention ratios. Used for tracking fee parameter adjustments that affect liquidity provider rewards and protocol revenue 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
0xcf20fda54e37f3fb456930f02fb07fccf49e4849	false	23	76540918	2023-04-03T07:44:31.000Z	0x06e6d9f6dbf312e903cb53575221d0ecb37e1855bb4413d8c51ed9b9b8c87fc4	0	500000000000000000

Example Query

Query with partition filter

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

UsdPlusPool_SetHaircutRate_event

Haircut rate parameter updates for the USD+ pool in Wombat Exchange v2 on Arbitrum, where haircut rate controls withdrawal penalties during imbalanced liquidity conditions. Used for analyzing pool risk management and liquidity protection mechanisms.

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
0xcf20fda54e37f3fb456930f02fb07fccf49e4849	false	100000000000000	57	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe
0xcf20fda54e37f3fb456930f02fb07fccf49e4849	false	400000000000000	3	197100966	2024-04-03T08:48:19.000Z	0x0e2858fa377ec608e2f795db2177963563d2656f4c67f6f382a656e71dae8024

Example Query

Query with partition filter

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

UsdPlusPool_Swap_event

Swap events from Wombat Exchange’s USD+ stablecoin pool on Arbitrum, recording token exchanges between USD+ and USDC with amounts, participants, and execution details. Used for analyzing stablecoin swap activity, liquidity depth, and trader behavior in Wombat’s single-sided AMM pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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
0x308c5b91f63307439fdb51a9fa4dfc979e2ed6b0	0xcf20fda54e37f3fb456930f02fb07fccf49e4849	false	0x0aacc6124269f9591a5fcb33d34654918c151221	71	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	485887330	82243779	0xe80772eaf6e2e18b651f160bc9158b2a5cafca65	486037125	2023-04-19T23:20:29.000Z	0x428a647865235b72827bd5fe10ed9625e0d5a30f630fb687e4456afe386e222e
0x362bc666ca29d62e0d7b42adab58157ec0899a7f	0xcf20fda54e37f3fb456930f02fb07fccf49e4849	false	0xc4b2f992496376c6127e73f1211450322e580668	7	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	77668419	82129261	0xe80772eaf6e2e18b651f160bc9158b2a5cafca65	77688595	2023-04-19T15:20:43.000Z	0x8af3cc9288251592fb6ee1aedac6c3bbbe2da8a45068abba6f7f619298f1843d
0x549a2f915a1f4e9655d71cbdbf5e055ec357efae	0xcf20fda54e37f3fb456930f02fb07fccf49e4849	false	0x549a2f915a1f4e9655d71cbdbf5e055ec357efae	104	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2576025295	81974386	0xe80772eaf6e2e18b651f160bc9158b2a5cafca65	2574587218	2023-04-19T04:40:23.000Z	0xca029126db124fb06dc5c8292f82ddec94caad3d20664910a6782f60504dc4c7

Example Query

Query with partition filter

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

WmxWOMPool_SetFee_event

Fee configuration change events from the Wombat Exchange WMX pool contract on Arbitrum. Tracks updates to retention ratios and liquidity provider (LP) dividend distribution parameters for protocol fee management analysis.

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
0xee9b42b40852a53c7361f527e638b485d49750cd	false	23	76814186	2023-04-04T02:59:55.000Z	0xd62e7c5a220eff15ab78904323786a5702b8d51df0ec303d02d65971c9d8fd6e	500000000000000000	500000000000000000

Example Query

Query with partition filter

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

WmxWOMPool_SetHaircutRate_event

Haircut rate configuration changes for Wombat Exchange (WMX) liquidity pools on Arbitrum. Tracks adjustments to the haircut parameter (shown in wei, e.g., 0.002-0.0025 or 0.2-0.25%) used to penalize imbalanced withdrawals and protect pool solvency.

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
0xee9b42b40852a53c7361f527e638b485d49750cd	false	2000000000000000	63	81953338	2023-04-19T03:13:15.000Z	0xb6804721facce76d2fc0fdf2ce90b527da40d9baa0a1a5014a8c5fc823da06fe
0xee9b42b40852a53c7361f527e638b485d49750cd	false	2500000000000000	14	76871403	2023-04-04T07:03:38.000Z	0xd9e73ca9160d81fb77b555bab013c5f96a6ab354d3bee50e37a17c4468bd282b

Example Query

Query with partition filter

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

WmxWOMPool_Swap_event

Token swap events from Wombat Exchange WMX-WOM pool on Arbitrum. Contains swap details including sender, recipient, token addresses, and exchange amounts for analyzing WMX/WOM trading activity and liquidity pool behavior.

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
0x17b7afbe43503813e525be9dee970d6faff75633	0xee9b42b40852a53c7361f527e638b485d49750cd	false	0xc4b2f992496376c6127e73f1211450322e580668	5	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	272112971871306516814	154088747	0xeff2b1353cdcaa2c3279c2bfde72120c7ffb5e24	1287221425791312048078	2023-11-25T23:45:27.000Z	0x65b65d7b6127c84d87f7a9a123abf5b7f8496c777d9700537dbba65468da939d
0x1a7728e8560b386905d1614cb5abbf33987dc562	0xee9b42b40852a53c7361f527e638b485d49750cd	false	0xc4b2f992496376c6127e73f1211450322e580668	25	0xeff2b1353cdcaa2c3279c2bfde72120c7ffb5e24	38641640814301355548043	204833631	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	13269586608632278042844	2024-04-26T00:01:01.000Z	0x57bbb40f0ca2e5794eab29b86ffc83a62355c43363dec86b989146152823420b
0xe29bb2050e2b27363f503a44f3083fb826ee1ed4	0xee9b42b40852a53c7361f527e638b485d49750cd	false	0xc4b2f992496376c6127e73f1211450322e580668	5	0x7b5eb3940021ec0e8e463d5dbb4b7b09a89ddf96	10510239259815711789130	204849518	0xeff2b1353cdcaa2c3279c2bfde72120c7ffb5e24	30000000000000000000000	2024-04-26T01:08:56.000Z	0x01eadb828b29b56a255ed4c6a650f3e806f798a4b29735ade14d1f8082a762e5

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BobPool_SetFee_event

BobPool_SetHaircutRate_event

BobPool_Swap_event

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

FraxEthPool_SetFee_event

FraxEthPool_SetHaircutRate_event

FraxEthPool_Swap_event

FraxMaiUsdPool_SetFee_event

FraxMaiUsdPool_SetHaircutRate_event

FraxMaiUsdPool_Swap_event

MimPool_SetFee_event

MimPool_SetHaircutRate_event

MimPool_Swap_event

MWOMPool_SetFee_event

MWOMPool_SetHaircutRate_event

MWOMPool_Swap_event

Pool_SetFee_event

Pool_SetHaircutRate_event

Pool_Swap_event

QWOMPool_SetFee_event

QWOMPool_SetHaircutRate_event

QWOMPool_Swap_event

UsdPlusPool_SetFee_event

UsdPlusPool_SetHaircutRate_event

UsdPlusPool_Swap_event

WmxWOMPool_SetFee_event

WmxWOMPool_SetHaircutRate_event

WmxWOMPool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BobPool_SetFee_event

​BobPool_SetHaircutRate_event

​BobPool_Swap_event

​CrossChainPool_SetFee_event

​CrossChainPool_SetHaircutRate_event

​CrossChainPool_SwapV2_event

​FraxEthPool_SetFee_event

​FraxEthPool_SetHaircutRate_event

​FraxEthPool_Swap_event

​FraxMaiUsdPool_SetFee_event

​FraxMaiUsdPool_SetHaircutRate_event

​FraxMaiUsdPool_Swap_event

​MimPool_SetFee_event

​MimPool_SetHaircutRate_event

​MimPool_Swap_event

​MWOMPool_SetFee_event

​MWOMPool_SetHaircutRate_event

​MWOMPool_Swap_event

​Pool_SetFee_event

​Pool_SetHaircutRate_event

​Pool_Swap_event

​QWOMPool_SetFee_event

​QWOMPool_SetHaircutRate_event

​QWOMPool_Swap_event

​UsdPlusPool_SetFee_event

​UsdPlusPool_SetHaircutRate_event

​UsdPlusPool_Swap_event

​WmxWOMPool_SetFee_event

​WmxWOMPool_SetHaircutRate_event

​WmxWOMPool_Swap_event

Tables

BobPool_SetFee_event

BobPool_SetHaircutRate_event

BobPool_Swap_event

CrossChainPool_SetFee_event

CrossChainPool_SetHaircutRate_event

CrossChainPool_SwapV2_event

FraxEthPool_SetFee_event

FraxEthPool_SetHaircutRate_event

FraxEthPool_Swap_event

FraxMaiUsdPool_SetFee_event

FraxMaiUsdPool_SetHaircutRate_event

FraxMaiUsdPool_Swap_event

MimPool_SetFee_event

MimPool_SetHaircutRate_event

MimPool_Swap_event

MWOMPool_SetFee_event

MWOMPool_SetHaircutRate_event

MWOMPool_Swap_event

Pool_SetFee_event

Pool_SetHaircutRate_event

Pool_Swap_event

QWOMPool_SetFee_event

QWOMPool_SetHaircutRate_event

QWOMPool_Swap_event

UsdPlusPool_SetFee_event

UsdPlusPool_SetHaircutRate_event

UsdPlusPool_Swap_event

WmxWOMPool_SetFee_event

WmxWOMPool_SetHaircutRate_event

WmxWOMPool_Swap_event