voltz_v1_arbitrum

Tables

Factory_IrsInstance_event

Interest Rate Swap (IRS) pool deployment events from Voltz Protocol v1 factory contract on Arbitrum, capturing the creation of new trading pools with their virtual AMM (VAMM), margin engine, rate oracle, and term parameters. Used for tracking new market launches and analyzing protocol growth across different yield-bearing protocols and underlying tokens.

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_underlyingToken`	`STRING`	Contract address of the underlying token (e.g., USDC, WETH) used in this interest rate swap pool. Hex-encoded, 0x-prefixed 40-character Ethereum address on Arbitrum.
`in_rateOracle`	`STRING`	Contract address of the oracle providing interest rate data for this IRS instance. Hex-encoded, 0x-prefixed 40-character string identifying the rate oracle contract on Arbitrum.
`in_termStartTimestampWad`	`STRING`	Term start timestamp in wei-denominated format (27 trailing zeros). Represents the beginning of the interest rate swap period as a Unix timestamp multiplied by 10^27.
`in_termEndTimestampWad`	`STRING`	Unix timestamp representing the maturity date of the interest rate swap position, scaled by 10^27 (WAD format). Values are typically set to round dates (midnight UTC) marking the end of the swap term.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_marginEngine`	`STRING`	Contract address of the margin engine managing collateral and position accounting for this interest rate swap instance. Hex-encoded, 0x-prefixed 40-character string on Arbitrum.
`in_vamm`	`STRING`	Contract address of the Voltz Virtual Automated Market Maker (vAMM) instance created for this IRS pool. Hex-encoded, 0x-prefixed address that handles automated liquidity provision and position management.
`in_fcm`	`STRING`	Contract address of the Fully Collateralized Margin (FCM) module for this IRS instance, or zero address if not used. Hex-encoded, 0x-prefixed address that manages fully collateralized positions in Voltz interest rate swaps.
`in_yieldBearingProtocolID`	`INT64`	Numeric identifier for the yield-bearing protocol integrated with this IRS instance (e.g., 7 for Aave, 8 for Lido, 9 for Compound). Used to distinguish which DeFi protocol provides the underlying yield source for the interest rate swap.
`in_underlyingTokenDecimals`	`INT64`	Decimal precision of the underlying token specified in the interest rate swap pool. Typically 6 for USDC and 18 for WETH on Arbitrum.

Sample Data

in_fcm	address	in_vamm	removed	log_index	block_number	in_rateOracle	in_tickSpacing	block_timestamp	in_marginEngine	transaction_hash	in_underlyingToken	in_termEndTimestampWad	in_termStartTimestampWad	in_yieldBearingProtocolID	in_underlyingTokenDecimals
0x0000000000000000000000000000000000000000	0xda66a7584da7210fd26726efb12585734f7688c1	0x0c6dbf063fd1effe971ecf4091a40064936eae35	false	10	74969179	0x65f5139977c608c6c2640c088d7fd07fa17a0614	60	2023-03-29T16:57:43.000Z	0x6849d4bda5828db77c7978a145bf9d4b4ae1f3f5	0x479e6796a0b8d008970e56ba55d399792fa8f37314bbeba88e757de1b1a7b541	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1681473600000000000000000000	1680264000000000000000000000	7	6
0x0000000000000000000000000000000000000000	0xda66a7584da7210fd26726efb12585734f7688c1	0x8ce24926b49f9e1b97dc21109ed8ab67cf0293c2	false	25	74969179	0x41ecaac9061f6babf2d42068f8f8daf3ba9644ff	60	2023-03-29T16:57:43.000Z	0xb696f408804ccb345040c9b08ea4b7a8750bf70f	0x479e6796a0b8d008970e56ba55d399792fa8f37314bbeba88e757de1b1a7b541	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1682856000000000000000000000	1680264000000000000000000000	9	6
0x0000000000000000000000000000000000000000	0xda66a7584da7210fd26726efb12585734f7688c1	0xb69c2b77c844b55f9924242df4299a1598753320	false	8	60949827	0xfb47177dc75f3910b8bc6525b4835cca67a12c48	60	2023-02-14T20:03:41.000Z	0xc1a44601a9f141eca8823f99b0b7fff55f2a6e17	0x9bc4784839cd59fba0787aa44d89b41ffff87e95163ff1ba8b0df9e617eab02e	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1678881600000000000000000000	1676396965000000000000000000	8	18

Example Query

Query with partition filter

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

MarginEngine_PositionLiquidation_event

Liquidation events from Voltz Protocol’s interest rate swap margin engine on Arbitrum, recording undercollateralized position closures with notional amounts unwound, liquidator rewards, and tick ranges. Used for analyzing liquidation cascades, keeper profitability, and protocol risk 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_notionalUnwound`	`STRING`	Notional amount of the interest rate swap position that was unwound during liquidation, denominated in the underlying token’s smallest unit. Typically ranges from hundreds of millions to hundreds of quadrillions of base units depending on token decimals.
`in_liquidatorReward`	`STRING`	Reward amount paid to the liquidator for executing the liquidation. String-encoded integer representing the token amount in smallest denomination.

Sample Data

address	removed	in_owner	log_index	block_number	in_tickLower	in_liquidator	block_timestamp	transaction_hash	in_notionalUnwound	in_liquidatorReward
0x6849d4bda5828db77c7978a145bf9d4b4ae1f3f5	false	0x44db04a9d32562be59eb5468d8c685f67905c95c	4	77227971	-69060	0x7ea3ba24146c2e335f951dd0179b3e11a88260b0	2023-04-05T08:02:58.000Z	0x71b47ea60687e2d93278ac90cd19abee6b967acd1e7f37c101f490be6d10dcf4	1000000000	9786
0x6849d4bda5828db77c7978a145bf9d4b4ae1f3f5	false	0x44a2c2a8e5724104420e38a2d8a61518b995ea89	3	77227951	-69060	0x7ea3ba24146c2e335f951dd0179b3e11a88260b0	2023-04-05T08:02:53.000Z	0xdec44709f31d4c22f40fef37185fb739f86acb8c8027ea64a4e76e9b63258e1c	2000000000	24960
0xbe958ba49be73d3020cb62e512619da953a2bab1	false	0xf8f6b70a36f4398f0853a311dc6699aba8333cc1	14	100941380	-69060	0x7ea3ba24146c2e335f951dd0179b3e11a88260b0	2023-06-14T03:01:50.000Z	0xb86b0a21f7f574914607b46f4add5398ad823dbb71d389fad99b345f5b15b46b	20000000000000000	2000004122273

Example Query

Query with partition filter

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

MarginEngine_PositionSettlement_event

Position settlement events from Voltz Protocol V1 interest rate swap contracts on Arbitrum, recording final cashflow payments when positions are closed. Used for analyzing profit/loss (PnL) and settlement behavior across different tick ranges.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_settlementCashflow`	`STRING`	Net cashflow amount settled for this position at maturity, expressed in the margin token’s base units. Negative values indicate payment from the position owner to the protocol, while positive values indicate payment to the owner.

Sample Data

address	removed	in_owner	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash	in_settlementCashflow
0xa1000d63a8f603e9f83356b4fbfc36f11a5100cb	false	0xb6dff2a2c023f47f24ddc2e516adc2e6faa4a1f6	5	98116536	-46080	0	2023-06-05T18:04:14.000Z	0xa1aba8696667f2c04c87cab614bc2c779a5806df4d4c997ba9c4f0d123e32ecc	-111
0xa1000d63a8f603e9f83356b4fbfc36f11a5100cb	false	0x12fea79122404634a03df7ce08e984e6c128fc21	0	98147877	-23040	0	2023-06-05T20:18:16.000Z	0x0a9a0f9ce24a69d2cc8adea2710fbf8a789b5ed3a49f25997c8124c44e5cf42e	-369265
0xbf23844515a0b1f574f2dc6437ea8e1cc98b87a4	false	0xcd07b565eff790bf60eb6f37e3edc50f34ff8971	5	98105782	-23040	23040	2023-06-05T17:19:27.000Z	0x19d928326416beb9b62d4c0382ff2982ab484c92940e55eac490122ea60fc91c	-89732123713

Example Query

Query with partition filter

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

MarginEngine_PositionUpdate_event

Position update events from Voltz Protocol V1 interest rate swap positions on Arbitrum, tracking changes to margin, liquidity, and fixed/variable token balances within specified tick ranges. Used for monitoring position risk, collateralization levels, and swap exposure across the automated market maker.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in__liquidity`	`STRING`	Liquidity amount deposited in this position within the specified tick range. Stored as a string representation of the integer value, often ‘0’ when positions are closed or not providing liquidity.
`in_margin`	`STRING`	Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
`in_fixedTokenBalance`	`STRING`	Fixed rate token balance of the position, representing the trader’s exposure to fixed interest rates in the Voltz interest rate swap. Positive values indicate receiving fixed rate, negative values indicate paying fixed rate.
`in_variableTokenBalance`	`STRING`	Variable rate token balance in the position after the update, representing the trader’s exposure to floating interest rates. Negative values indicate a net payer position, while positive values indicate a net receiver position in the interest rate swap.
`in_accumulatedFees`	`STRING`	Cumulative fees accrued by the vault or position. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_owner	in_margin	log_index	block_number	in_tickLower	block_timestamp	transaction_hash	in_fixedTokenBalance	in_variableTokenBalance
0xf9850b06aaabab6be56558d58e94a3fd621b161e	false	0x04c7c335ecd38e72626eb15c10bc1a62bbc39329	10200000030758498	22	74451027	-69060	2023-03-28T04:48:43.000Z	0x0199c9927d7cc7b3500739e1bb13aef8a02d9a5bb4fece7980b1af087ee1e32b	621179750299817587	-20000000000000000
0xf9850b06aaabab6be56558d58e94a3fd621b161e	false	0x04c7c335ecd38e72626eb15c10bc1a62bbc39329	10200419195205479	21	74451027	-69060	2023-03-28T04:48:43.000Z	0x0199c9927d7cc7b3500739e1bb13aef8a02d9a5bb4fece7980b1af087ee1e32b	310591830765398319	-10000000000000000
0x0ca700b946c446d878a497c50fb98844a85a2dd9	false	0x9c655f248d4f84a4dd70694e890fa81866c4f39c	100000	7	74483826	-69060	2023-03-28T07:05:16.000Z	0x03795186a2f0035cb721c71b8f148af8d2e5dc383a639a13540f3efb8537ba76	114991613	-80000000

Example Query

Query with partition filter

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

vamm_Burn_event

Liquidity removal events from Voltz Protocol V1 virtual automated market maker (vAMM) pools on Arbitrum, capturing position owner, tick range, and liquidity amount burned. Used to track liquidity provider exits and position size changes in interest rate swap markets.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	in_sender	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xaeb387b339ea6e9e0e57c3718e0bd00637f20a1d	false	0x297a0e87f6e65a423d20879d5157f8b9875c036e	251719861174129	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	29	91261850	-48660	-42480	2023-05-16T11:22:33.000Z	0xcf0dcde0ba89b54ba93cbdf0567b3e78f3ac46f71599f7d8c1ef0dbe4f482bf0
0xaeb387b339ea6e9e0e57c3718e0bd00637f20a1d	false	0xaf0b786004e2155e2f94b1f0f46017d00416e9a0	481154374717541	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	1	91396048	-46080	-39120	2023-05-16T20:49:43.000Z	0xf338f9b2f2118fc5feabdab5ffaa1b5c78265c56e0d73d14c8e979b411701a77
0xaeb387b339ea6e9e0e57c3718e0bd00637f20a1d	false	0x1922949c9c3e13afbfa014ab86b3fef440cf34bd	408980832879	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	1	91334147	-16080	23040	2023-05-16T16:23:44.000Z	0x12854220b1f1978e5bd60e6e35c33afd61bb23970beb1d1617916d69993b19b7

Example Query

Query with partition filter

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

vamm_Fee_event

Fee events from Voltz Protocol V1 virtual automated market makers (vAMMs) on Arbitrum, recording fee amounts in WAD format (18 decimals) charged per transaction. Used for tracking protocol fee revenue and vAMM-level fee 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_feeWad`	`STRING`	Fee amount charged by the Voltz vAMM (Virtual Automated Market Maker) in WAD format (18 decimal places). Based on samples showing consistent `1000000000000000` values, this represents 0.001 tokens or 0.1% fee.

Sample Data

address	removed	in_feeWad	log_index	block_number	block_timestamp	transaction_hash
0xb69c2b77c844b55f9924242df4299a1598753320	false	1000000000000000	13	60949827	2023-02-14T20:03:41.000Z	0x9bc4784839cd59fba0787aa44d89b41ffff87e95163ff1ba8b0df9e617eab02e
0x034f2b4137ed637c6b6ca9636d5f9fee0998e5f1	false	1000000000000000	81	79959637	2023-04-13T08:16:54.000Z	0x31f135cdf0ffe3381bac0a594f681dfec23834ccab0ac3174987dbca1615bf62
0x034f2b4137ed637c6b6ca9636d5f9fee0998e5f1	false	1000000000000000	44	79959637	2023-04-13T08:16:54.000Z	0x31f135cdf0ffe3381bac0a594f681dfec23834ccab0ac3174987dbca1615bf62

Example Query

Query with partition filter

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

vamm_FeeProtocol_event

Protocol fee configuration changes for Voltz V1 virtual automated market maker (VAMM) contracts on Arbitrum. Records fee percentage updates with contract addresses and timestamps for tracking protocol revenue 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_feeProtocol`	`INT64`	The protocol fee percentage charged by the Voltz vAMM (virtual Automated Market Maker) contract on trades. Represented as an integer value, commonly set to 5 (indicating 5%).

Sample Data

address	removed	log_index	block_number	in_feeProtocol	block_timestamp	transaction_hash
0x3ecf01157e9b1a66197325771b63789d1fb18f1f	false	1	116689937	5	2023-07-31T08:02:05.000Z	0x17f8f8f02a88bcff48c9d43906c7934d7e8b7c85aeeb7643d4abc437764809ce

Example Query

Query with partition filter

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

vamm_Initialized_event

Virtual Automated Market Maker (vAMM) initialization events from Voltz Protocol v1 on Arbitrum, capturing when new interest rate swap pools are deployed. Used to track new market creation and protocol expansion 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_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x1aac6232b7c7cd6c8479077844eb0302cca0d2af	false	6	1	70061963	2023-03-15T11:49:31.000Z	0x89b63f745a95d7e6ba3069be88fdd6c9773eabc0984995fa80a8b4b60c0797e7
0xb97191595b38b192e776402a6ed2a23c7cf25582	false	6	1	81000196	2023-04-16T09:00:43.000Z	0x737ede27cc6c2b65c5ca1ffbc92a47318cf0b28a8fe3402a4d1b05bf4e865b6b
0xa3c0c89ac146b89edd17efd4e9c43cc4fc35ec1e	false	29	1	96338929	2023-05-31T12:16:33.000Z	0x0085fb0925eadc0c8c4f03757ed527427a3f8d41bd9de889838348c71320cdb0

Example Query

Query with partition filter

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

vamm_Mint_event

Liquidity provision events from Voltz Protocol v1 virtual automated market maker (vAMM) on Arbitrum, recording tick-range positions when users mint concentrated liquidity. Used for analyzing liquidity provider behavior and capital efficiency in interest rate swap markets.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_amount	in_sender	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x034f2b4137ed637c6b6ca9636d5f9fee0998e5f1	false	0x1c22e514203bd6157c7db84c616f3746bd03b431	118152362934700804	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	13	86730228	-34020	-26400	2023-05-03T03:00:01.000Z	0x689fcb7ea236c52efe5dae5a6beadadff14a9c666480fc28c79f5a47f0a02e7a
0x034f2b4137ed637c6b6ca9636d5f9fee0998e5f1	false	0x98c3d15845a471cacddb1a17885479641a6f0ce9	731018016835806768	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	8	86693323	-23040	0	2023-05-03T00:19:49.000Z	0x899a8c1e24907081f132cb6409c2d0c68519284096d42cc088bcc49207184887
0x034f2b4137ed637c6b6ca9636d5f9fee0998e5f1	false	0x7f3c703cbcd18acf9b2d85bc4b59a770d2307ae6	731018016835806768	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	8	86695855	-23040	0	2023-05-03T00:30:59.000Z	0x66a37e085af8a8a284cf9f3740e5a0b6b34636e05fc17236a8f574015e7ef043

Example Query

Query with partition filter

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

vamm_Swap_event

Interest rate swap execution events from Voltz Protocol V1 virtual automated market maker (vAMM) on Arbitrum. Contains fixed and variable token deltas, tick ranges, fees, and recipient data for analyzing interest rate swap trading activity and liquidity provider positions.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_desiredNotional`	`STRING`	Notional amount targeted for the swap operation. String-encoded signed integer representing the value in the token’s smallest unit, with negative values indicating the direction of the trade.
`in_sqrtPriceLimitX96`	`STRING`	Price limit for the swap expressed as a square root price value in Q96 fixed-point format. String-encoded unsigned integer with 96 fractional bits, used to control maximum price movement during execution.
`in_cumulativeFeeIncurred`	`STRING`	Cumulative fees incurred by the position or trader during the swap operation. String-encoded integer representing the fee amount in the token’s smallest unit.
`in_fixedTokenDelta`	`STRING`	Change in fixed token balance resulting from the swap. String-encoded signed integer representing the amount in the token’s smallest unit, with negative values indicating outflows and positive values indicating inflows.
`in_variableTokenDelta`	`STRING`	Change in variable token balance resulting from the swap. String-encoded signed integer representing the amount in the token’s smallest unit, with negative values indicating outflows and positive values indicating inflows.
`in_fixedTokenDeltaUnbalanced`	`STRING`	Change in fixed token balance before adjusting for accrued interest or funding payments. String-encoded signed integer representing the amount in the token’s smallest unit, with negative values indicating outflows and positive values indicating inflows.

Sample Data

address	removed	in_sender	log_index	block_number	in_recipient	in_tickLower	block_timestamp	transaction_hash	in_desiredNotional	in_fixedTokenDelta	in_sqrtPriceLimitX96	in_variableTokenDelta	in_cumulativeFeeIncurred	in_fixedTokenDeltaUnbalanced
0x1d7e4d7c1629c9d6e3bb6a344496b1b782c9ca9a	false	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	9	69361818	0x49fa00fee56062c723bda4af7fbea8f90d40f690	-69060	2023-03-13T06:48:02.000Z	0x6fedc2c0cad71c461ff5d9949768bf27f2c4ea2070bb0c4e1e26a84bb9f66842	-100000	-117802	2503161564979124432035869129	100000	4	-108340
0x1d7e4d7c1629c9d6e3bb6a344496b1b782c9ca9a	false	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	3	69462142	0x8073c62366973b9960f4561f6a72c5826b75e828	-69060	2023-03-13T14:28:56.000Z	0xeec6d9d9aaffb98a3794fbdaf6ccb8870bd66dfd0c1acf3b44391adce9b7a94f	-7000000000	-8270309246	2503161564979124432035869129	7000000000	343221	-7584863918
0x1d7e4d7c1629c9d6e3bb6a344496b1b782c9ca9a	false	0x5971eedc4ae37c7fe86af716737e5c19efd07a80	14	69345521	0xed33841f128347c1106c5c215e89532b02e160d5	-69060	2023-03-13T05:32:14.000Z	0x846d0b604234e198c39dd45d105a9d346e3e42c40eaa1dd91816cde8ecae1aab	-30000000000	-35179160132	2503161564979124432035869129	30000000000	1501584	-32521824253

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_IrsInstance_event

MarginEngine_PositionLiquidation_event

MarginEngine_PositionSettlement_event

MarginEngine_PositionUpdate_event

vamm_Burn_event

vamm_Fee_event

vamm_FeeProtocol_event

vamm_Initialized_event

vamm_Mint_event

vamm_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_IrsInstance_event

​MarginEngine_PositionLiquidation_event

​MarginEngine_PositionSettlement_event

​MarginEngine_PositionUpdate_event

​vamm_Burn_event

​vamm_Fee_event

​vamm_FeeProtocol_event

​vamm_Initialized_event

​vamm_Mint_event

​vamm_Swap_event

Tables

Factory_IrsInstance_event

MarginEngine_PositionLiquidation_event

MarginEngine_PositionSettlement_event

MarginEngine_PositionUpdate_event

vamm_Burn_event

vamm_Fee_event

vamm_FeeProtocol_event

vamm_Initialized_event

vamm_Mint_event

vamm_Swap_event