voltz_v1_ethereum

Tables

Factory_IrsInstance_event

Interest Rate Swap (IRS) pool deployment events from Voltz Protocol v1 on Ethereum, capturing VAMM (Virtual Automated Market Maker), margin engine, and rate oracle contract addresses for each yield-bearing protocol integration. Used to track new fixed-to-variable rate swap market creation with term dates, underlying collateral tokens, and protocol-specific configurations.

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 base token for this interest rate swap instance. Hex-encoded, 0x-prefixed Ethereum address identifying assets like WETH, USDC, DAI, or USDT.
`in_rateOracle`	`STRING`	Contract address of the rate oracle providing interest rate data for this Voltz IRS (Interest Rate Swap) instance. Hex-encoded, 0x-prefixed 40-character Ethereum address.
`in_termStartTimestampWad`	`STRING`	Start timestamp of the interest rate swap term in WAD format (Unix timestamp scaled by 10^27). Represents when the IRS position becomes active for the specified underlying token and yield protocol.
`in_termEndTimestampWad`	`STRING`	Timestamp representing when the interest rate swap term ends, encoded in WAD format (value multiplied by 10^27). Commonly set to quarter-end dates like March 31 or December 31 in future years.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_marginEngine`	`STRING`	Contract address of the Voltz margin engine component managing collateral and position accounting for this interest rate swap instance. Hex-encoded, 0x-prefixed Ethereum address that coordinates with the vAMM and rate oracle.
`in_vamm`	`STRING`	Contract address of the virtual automated market maker (vAMM) created for this interest rate swap instance. Hex-encoded Ethereum address managing price discovery and liquidity for the swap pool.
`in_fcm`	`STRING`	Contract address of the Fully Collateralized Margin (FCM) module for this interest rate swap instance. Zero address (0x0000…) indicates no FCM is used for this position.
`in_yieldBearingProtocolID`	`INT64`	Numeric identifier for the yield-bearing protocol integrated with this IRS instance (e.g., 1 for Aave, 2 for Compound, 5 for Lido, 6 for Rocket Pool, 7 for others). Integer values ranging from 1-7 indicate different DeFi lending or staking protocols.
`in_underlyingTokenDecimals`	`INT64`	Number of decimal places used by the underlying token contract. Commonly 18 for most ERC-20 tokens or 6 for stablecoins like USDC and USDT.

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	0x6a7a5c3824508d03f0d2d24e0482bea39e08ccaf	0x682f3e5685ff51c232cf842840ba27e717c1ae2e	false	156	15373135	0x8fdd62e435039d69de862e267cda02846c6c2f3c	60	2022-08-19T19:26:35.000Z	0x9b76b4d09229c339b049053f171bfb22cbe50092	0x9e4c501612701d5f01e404d95fa3cfd45ae717111dd7f45431425232c50bf6ce	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	1672488000000000000000000000	1661155200000000000000000000	5	18
0x0000000000000000000000000000000000000000	0x6a7a5c3824508d03f0d2d24e0482bea39e08ccaf	0x0f91a255b5ba8e59f3b97b1ede91dec88bcc17eb	false	130	15373135	0x575bf19c89e91278a5a29c83e5401974bcba2894	60	2022-08-19T19:26:35.000Z	0x33ba6a0b16750206195c777879edd8706204154b	0x9e4c501612701d5f01e404d95fa3cfd45ae717111dd7f45431425232c50bf6ce	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1680264000000000000000000000	1661155200000000000000000000	5	6
0x0000000000000000000000000000000000000000	0x6a7a5c3824508d03f0d2d24e0482bea39e08ccaf	0xcd47347a8c4f40e6877425080d22f4c3115b60a5	false	143	15373135	0xd24047316b274d48dbb2fe20068c9cc849b76152	60	2022-08-19T19:26:35.000Z	0x111a75e91625142e85193b67b10e53acf82838cd	0x9e4c501612701d5f01e404d95fa3cfd45ae717111dd7f45431425232c50bf6ce	0xdac17f958d2ee523a2206206994597c13d831ec7	1680264000000000000000000000	1661155200000000000000000000	6	6

Example Query

Query with partition filter

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

Fcm_FullyCollateralisedSwap_event

Fully collateralized interest rate swap executions on Voltz Protocol V1 (Ethereum), recording fixed-for-variable token exchanges with notional amounts, price limits, and cumulative fees. Used for analyzing trader positions and interest rate market dynamics in DeFi (decentralized finance) fixed income 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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`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_trader	log_index	block_number	block_timestamp	transaction_hash	in_desiredNotional	in_fixedTokenDelta	in_sqrtPriceLimitX96	in_variableTokenDelta	in_cumulativeFeeIncurred	in_fixedTokenDeltaUnbalanced
0x62acb164087a90fd9f05a66249c1b18a6db13638	false	0x747811193cd339582929344c74e315339db57446	223	14919902	2022-06-07T08:45:29.000Z	0x7e6eb152156cc27cc1d82a986d40e311fbd8da278293614ba52999b95101cda7	150000000	157082473	2507669430214757147510696507320	-150000000	66536	156549103
0x62acb164087a90fd9f05a66249c1b18a6db13638	false	0x481bb04f60dd1f7d6ec0a3611ed8023e618697cb	350	14919876	2022-06-07T08:40:25.000Z	0x5463a49dd62e40b19f19d9d5072e36ba4fb5c1a7563acadd2fad433dd9549966	3000000	3141681	2507669430214757147510696507320	-3000000	1330	3131014
0x62acb164087a90fd9f05a66249c1b18a6db13638	false	0x92913e71869b091dcf1a1eebcad229e6d0480785	192	14919612	2022-06-07T07:39:32.000Z	0x479b227f805f86339f59d0771a23985cd9999ce72492da46d7d17e3b27d7d2d2	107000000	112044150	2507669430214757147510696507320	-107000000	47502	111664681

Example Query

Query with partition filter

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

MarginEngine_Initialized_event

MarginEngine contract initialization events from Voltz Protocol v1 on Ethereum, capturing when new margin engine instances are deployed. Used for tracking protocol expansion and identifying active margin engine contracts for interest rate swap 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_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
0xe6ba9270cb517b9236331bc972fe016d0cf1168f	false	100	1	16593014	2023-02-09T18:34:35.000Z	0x9feaed852e8392c6682f2eefb956df36de2e3579d433a37918eeabac5733610a
0x107b152efc8900d8aa2cd45297c620d886558477	false	215	1	16934269	2023-03-29T16:56:23.000Z	0x8cf25362e380650e882879fa0be9d77643d39d141cd36114e79b65bc455e0d7a
0x5eaa5ff3a0a7c982715feb768be143461fdd4de9	false	230	1	16934269	2023-03-29T16:56:23.000Z	0x8cf25362e380650e882879fa0be9d77643d39d141cd36114e79b65bc455e0d7a

Example Query

Query with partition filter

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

MarginEngine_liquidatePosition_function

Position liquidation transactions from Voltz V1 interest rate swap protocol on Ethereum, capturing undercollateralized position closures with tick ranges and liquidation rewards. Used for analyzing liquidation events, risk management effectiveness, and liquidator profitability across different market 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__owner`	`STRING`	Address of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string.
`in__tickLower`	`INT64`	Lower tick boundary of the liquidated position’s price range. Represents the minimum price tick in Voltz’s concentrated liquidity model where the position is active.
`in__tickUpper`	`INT64`	Lower bound of the tick range for the liquidated position in Voltz Protocol’s interest rate swap market. Tick values define price ranges in the automated market maker, with negative values common in samples.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in__owner	out_anon0	signature	to_address	block_number	from_address	in__tickLower	block_timestamp	transaction_hash
769193	true	627543	0xa7a9e6137d2582fc8bddad6a6daeb8fb985396f2	1503066162480970	0x1656503e	0x21f9151d6e06f834751b614c2ff40fc28811b235	15970088	0x047387d81a338c296c23962d9002c423f656e3ed	-69060	2022-11-14T18:32:23.000Z	0x1d921e90a88d2d0f0f3000c52ad72503df156122dbc63fc833bc6c164490b31e
656388	true	535134	0xd60bb1dad4ed8df7e34ca61d3a9c37768da070ba	1004325	0x1656503e	0xd6f2ef8e7f5917beda41136cb4a50e8be7735b4f	17124879	0x047387d81a338c296c23962d9002c423f656e3ed	-69060	2023-04-25T17:52:47.000Z	0xead644cde8afa16f5bce671605c96b1a1bd01e57971f4c49da9994d62b9d501c
604566	true	492420	0x47b3fab6a3b16d05d8eab43295744e7555a0623b	877263389459665	0x1656503e	0xb1125ba5878cf3a843be686c6c2486306f03e301	15896149	0x047387d81a338c296c23962d9002c423f656e3ed	-69060	2022-11-04T10:47:47.000Z	0x5fc7046752e328544a2bfd73f4a7b550d48753dac4f0cb68d2702772420835cb

Example Query

Query with partition filter

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

MarginEngine_PositionLiquidation_event

Position liquidation events from Voltz Protocol V1 interest rate swap markets on Ethereum, capturing undercollateralized position closures with liquidator rewards, notional amounts unwound, and tick range boundaries for analyzing liquidation activity and market 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_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 the liquidation, denominated in the underlying token’s smallest unit (wei). Negative values indicate variable taker positions while positive values indicate fixed taker positions.
`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
0xb1125ba5878cf3a843be686c6c2486306f03e301	false	0x42a49dcf7902c6b7938a00cdbe62a112a2b539e8	233	16064341	-69060	0x047387d81a338c296c23962d9002c423f656e3ed	2022-11-27T22:36:11.000Z	0xebe5357dcde674ea2b70b2a35a80112d3bd3612d573f5e27dcaebdd1c3a8b204
0xb1125ba5878cf3a843be686c6c2486306f03e301	false	0x8a331ef91b0e90f0b093658372258a7fdafa15c7	336	16064356	-69060	0x047387d81a338c296c23962d9002c423f656e3ed	2022-11-27T22:39:11.000Z	0xe342b9bb4d8918d40c3e200fae4b14bffdf08b16d5608b6be10ee22196b89453
0xb1125ba5878cf3a843be686c6c2486306f03e301	false	0x2f2e822d0d47a0dfcf5d39e612fbff247351f054	380	16064344	-69060	0x047387d81a338c296c23962d9002c423f656e3ed	2022-11-27T22:36:47.000Z	0x84ecaedcb3dc41f4180578ed676e20d8ebff9c696b165920e8f4475550501896

Example Query

Query with partition filter

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

MarginEngine_PositionMarginUpdate_event

Margin adjustment events from Voltz Protocol V1 interest rate swap positions on Ethereum, recording collateral deposits and withdrawals with tick range boundaries. Used for tracking position health and margin management across fixed and variable rate 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_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_marginDelta`	`STRING`	Change in margin balance for the position, denominated in the protocol’s base units (typically wei for ETH-based collateral). Negative values indicate margin withdrawal, while positive values indicate margin deposits.

Sample Data

address	removed	in_owner	in_sender	log_index	block_number	in_tickLower	in_tickUpper	in_marginDelta	block_timestamp	transaction_hash
0x33ba6a0b16750206195c777879edd8706204154b	false	0x6a780c771281322c8e0bbab55b935c1bb70f66ec	0x07ced903e6ad0278cc32bc83a3fc97112f763722	141	17626362	-10980	0	-1103816819	2023-07-05T08:01:23.000Z	0x263a11e536b345bc0a712bb0e251a0600500839f84a498cce1359c6a80816ffe
0xd47fa3314c9c16ebca3dfe3e0c52c24f1311a22b	false	0xa663473951a57fe34c0a8f4e3d869a29593cf5bc	0x07ced903e6ad0278cc32bc83a3fc97112f763722	139	17624922	-69060	0	-550000687	2023-07-05T03:10:59.000Z	0x5308cc5513c400003df94a2c8368f168c7cc4651b637afa30c10283cbeceeeb9
0x0bc09825ce9433b2cdf60891e1b50a300b069dd2	false	0x31b48d410003ab480bd66398f6e0712c55e11587	0x07ced903e6ad0278cc32bc83a3fc97112f763722	392	16929951	-29940	-16080	-10000000	2023-03-29T02:22:11.000Z	0xf73d2817992f528267cc2fb1dd58a97f2a82ff8668f38fefc2990cecf72e1907

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.voltz_v1_ethereum.MarginEngine_PositionMarginUpdate_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 positions on Ethereum, recording final profit/loss cashflows when positions are closed. Used for tracking realized PnL and settlement patterns 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 settled for the position at maturity, denominated in the margin token’s smallest unit. Negative values indicate payments owed by the position owner, while positive values represent payments received.

Sample Data

address	removed	in_owner	log_index	block_number	in_tickLower	block_timestamp	transaction_hash	in_settlementCashflow
0x1e2f114b6948946a42574a953dcb7838b2c810ea	false	0xf31b066cb8362cbf8e70062cdb9a6bfd32fecece	391	17382794	-69060	2023-06-01T01:47:23.000Z	0x9a9f4ae636c662e770ea824ca34c9759489f83f9ff1969e066c4e27dae20d6ff	-57159395
0x295891cc72a230bcb2c2bea3276ac4d470495894	false	0x3b2f8c00cc8593d9cbd1ca644c44203e817e2c71	268	17383635	-6960	2023-06-01T04:37:35.000Z	0xd99242a86739bc3fdcb2a3bce46218336e7a3d56cb97d29a69d510a5882cfb86	-45743635
0x295891cc72a230bcb2c2bea3276ac4d470495894	false	0x273fdfc4c0b2251c4758b54e1ae9b5b5ee6c4455	636	17382407	-6960	2023-06-01T00:28:35.000Z	0x720057a181bd20472a170cd3e667737c06c8fcfdd4219e4d74bb8765f57fb0a4	-1988470

Example Query

Query with partition filter

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

MarginEngine_PositionUpdate_event

Position state changes from Voltz Protocol’s interest rate swap (IRS) margin engine on Ethereum, tracking user positions with fixed/variable token balances, margin amounts, liquidity ranges (tick bounds), and accumulated fees for analyzing swap position management and collateralization.

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 the position at the time of the update, represented as a decimal string. Always zero in these samples, indicating positions without active liquidity provisioning.
`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`	Balance of fixed-rate tokens held in the position after the update. Positive values indicate a long fixed position (receiving fixed rate), while negative values indicate a short position (paying fixed rate).
`in_variableTokenBalance`	`STRING`	Trader’s net variable-rate token balance in the position after the update, denominated in the smallest unit of the underlying token. Negative values indicate short variable-rate positions (paying variable rate), while positive values indicate long positions (receiving variable rate).
`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
0x3d2821e59f330105c1c3aab8c289bce15f688f8a	false	0x8ee241e011380a1fc2c8be9fb7a71681eae9d605	94641597222223	144	16482306	-69060	2023-01-25T07:20:47.000Z	0xb8f680eb5ae6d324b0f9b2efca4a27d21faf213a8f64a1ae1d80e5adee582e9a	31236328707514670	-10000000000000000
0x3d2821e59f330105c1c3aab8c289bce15f688f8a	false	0x8ee241e011380a1fc2c8be9fb7a71681eae9d605	100000000000000	143	16482306	-69060	2023-01-25T07:20:47.000Z	0xb8f680eb5ae6d324b0f9b2efca4a27d21faf213a8f64a1ae1d80e5adee582e9a	0	0
0x3d2821e59f330105c1c3aab8c289bce15f688f8a	false	0x4cf3bf7c2965c65b84196920db4b5f6b52c24365	94641597222223	160	16482306	-69060	2023-01-25T07:20:47.000Z	0xa791c719422b417e06bbf19739bc9c6257d18991318aff898f1b15a163631460	31236312072776489	-10000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.voltz_v1_ethereum.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 Ethereum, capturing position burns with tick ranges, amounts, and owner addresses. Used for tracking liquidity provider exits and analyzing concentrated liquidity distribution 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
0xe4668bc57b1a73aaa832fb083b121d5b4602f475	false	0x09daabb9a08ef69186377c122637f2330ea471b7	1462036033671613537	0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726	313	14949429	-23040	0	2022-06-12T09:32:49.000Z	0x5462f813c57fde0dcbb014419c73c61b79ca2e32240e1884c68ca056eafcd008
0xae16bb8fe13001b61ddb44e2ceae472d6af08755	false	0x08ab30facb3ef439589f25e85496428f1fb5b077	34026470876	0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726	172	14950307	-6960	0	2022-06-12T13:09:16.000Z	0xc4548140a0a6ec81465d9602f0c0023354492ba09ea9bd86b4e517ba26b8ee64
0x0f91a255b5ba8e59f3b97b1ede91dec88bcc17eb	false	0x1cb96c15327757d3f87ebcf6a2ba895e1437ab0c	46388181655	0x07ced903e6ad0278cc32bc83a3fc97112f763722	397	16845466	-10980	-9540	2023-03-17T05:30:11.000Z	0xecd6f1ab281acc85c4db46dd007d2907774b5f6fb37912526338017645d454e5

Example Query

Query with partition filter

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

Vamm_Burn_event

Liquidity removal events from Voltz Protocol’s Virtual Automated Market Maker (vAMM) on Ethereum, capturing when liquidity providers burn positions within specific tick ranges. Used for tracking liquidity provision behavior and position management 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
0xae16bb8fe13001b61ddb44e2ceae472d6af08755	false	0x675f60d68701ed237e19b78152de1a68f3500e2f	240264708	0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726	182	14985008	0	6960	2022-06-18T12:40:13.000Z	0xfa2954c2c595ce5e6292f83996d421b547abde8b26564f831a1ad335d2bbaf00
0x7df7aa512f1eb4dd5c1b69486f45fe895ba41ece	false	0xcf217ad74d735b020f3628308d0232e886a9fdb6	655402129896675436805622	0x07ced903e6ad0278cc32bc83a3fc97112f763722	264	16350296	-5280	540	2023-01-06T21:01:47.000Z	0xdfebb63024495e1b02dc1816132125c443e541559bde7914b1177cb1c6e345ac
0xef05af8b766b33e8c0fe768278dee326946a4858	false	0xa26f0a1835244aef5fce13c2bd91f448cf85b28b	813824421433989055765800	0x07ced903e6ad0278cc32bc83a3fc97112f763722	262	16350428	-5880	2880	2023-01-06T21:28:11.000Z	0xfa3b15a773228d3de5ffaab897b53f7c4e22820e6ad5972466ea68834f7b58d8

Example Query

Query with partition filter

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

Vamm_Fee_event

Fee update events from Voltz Protocol v1 virtual automated market makers (vAMMs) on Ethereum, showing fee parameter changes in WAD format (18 decimals). Used for tracking fee adjustments across interest rate swap pools and analyzing 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_feeWad`	`STRING`	Fee amount charged by the Voltz protocol VAMM (Virtual Automated Market Maker) denominated in wei with 18 decimal precision. Values are typically 0.001 or 0.003 ETH (1e15 or 3e15 wei), representing 0.1% or 0.3% fee rates respectively.

Sample Data

address	removed	in_feeWad	log_index	block_number	block_timestamp	transaction_hash
0xd790379e8e039f3cc5005eb4b9096ad0f5633666	false	3000000000000000	104	15237236	2022-07-29T12:04:37.000Z	0xb7cfe0e83d3f88f8b4d92b019422aed204ee2581d0b6539307ec0b84fa315a28
0x293e740271ddcdf81c4031149c4ab183bef957e8	false	3000000000000000	83	15237236	2022-07-29T12:04:37.000Z	0xb7cfe0e83d3f88f8b4d92b019422aed204ee2581d0b6539307ec0b84fa315a28
0x77d7edbeb6fed996346c65535226519af7201128	false	3000000000000000	236	15237233	2022-07-29T12:03:31.000Z	0x983e927c93ec5489db3c6d64124f7f9570f76898f46c9d76d4bb69b3352bdc9a

Example Query

Query with partition filter

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

Vamm_FeeProtocol_event

Protocol fee parameter changes for Voltz V1 Virtual Automated Market Maker (VAMM) pools on Ethereum. Tracks fee percentage updates at the pool level for analyzing protocol revenue mechanics and governance 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_feeProtocol`	`INT64`	Protocol fee percentage charged by the Voltz VAMM (Virtual Automated Market Maker) on trades. Value represents the fee tier, with 5 indicating a 5% protocol fee rate.

Sample Data

address	removed	log_index	block_number	in_feeProtocol	block_timestamp	transaction_hash
0xd9a3f015a4ffd645014ec0f43148685be8754737	false	585	17811664	5	2023-07-31T08:01:35.000Z	0x5046a09daa2d1162920e9aed39bbc04adb9dc10629593a1952272453a97aa243
0x037c8d42972c3c058224a2e51b5cb9b504f75b77	false	584	17811664	5	2023-07-31T08:01:35.000Z	0x5046a09daa2d1162920e9aed39bbc04adb9dc10629593a1952272453a97aa243

Example Query

Query with partition filter

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

Vamm_Initialized_event

VAMM (Virtual Automated Market Maker) initialization events from Voltz Protocol v1 on Ethereum, capturing when new interest rate swap pools are deployed. Used for tracking protocol expansion and identifying new trading markets for fixed and variable rate 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_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
0xd9a3f015a4ffd645014ec0f43148685be8754737	false	130	1	17591482	2023-06-30T10:24:59.000Z	0x0f49ebb17a682706f82da541c40369370c19a07d74756503c5e1142d36757d14
0x037c8d42972c3c058224a2e51b5cb9b504f75b77	false	114	1	17591482	2023-06-30T10:24:59.000Z	0x0f49ebb17a682706f82da541c40369370c19a07d74756503c5e1142d36757d14
0xe8ddb4676eec36acffdffa6707f422e23a8dfc12	false	197	1	17378808	2023-05-31T12:18:23.000Z	0x08e9e25258fff31392e0b80cfccbd1dfe857a81b83da08b7a52e43a56b314d5b

Example Query

Query with partition filter

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

vamm_Mint_event

Liquidity provision events from Voltz Protocol’s Virtual Automated Market Maker (vAMM) on Ethereum, capturing when users mint positions by depositing collateral into specific tick ranges. Enables analysis of liquidity provider behavior and position concentration 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
0x368811e781c4300561d1cc204f7333a778d87ad5	false	0xc5e7184d2807b21726d67dd05b6c3011f9c5dca5	64895445	0x07ced903e6ad0278cc32bc83a3fc97112f763722	291	16625817	-47460	-44400	2023-02-14T08:32:35.000Z	0xb129a7375c122889b01da8ba1bb0c3b8cfb8a99e8135067c712e86bdbbdfb87b
0x7df7aa512f1eb4dd5c1b69486f45fe895ba41ece	false	0x65935eeca6a9a5c9d5f3df0bd8341960b2516a5e	84811504963502696436	0x07ced903e6ad0278cc32bc83a3fc97112f763722	199	16626805	-29940	-10980	2023-02-14T11:51:47.000Z	0xa1628665d262da0112e1dbc6a8ba1118e371a8e607e4260f72a9ca9c9c4400d9
0xe07324a394acfff8fe24a09c3f2e2bd62e929efb	false	0x9d32f1e7c5ff707e92b4b30937a1e5e2c2de2462	58915919172938188520	0x07ced903e6ad0278cc32bc83a3fc97112f763722	854	16626295	-17940	-10980	2023-02-14T10:08:59.000Z	0x76421efde2f3d2a8a4706a360829599257ca0647cb140aaa5be7a9eae8b2f156

Example Query

Query with partition filter

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

Vamm_Mint_event

Liquidity provision events from Voltz Protocol v1 VAMM (Virtual Automated Market Maker) pools on Ethereum, capturing concentrated liquidity positions minted within specific tick ranges. Used for tracking liquidity provider behavior and capital deployment across 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
0xe07324a394acfff8fe24a09c3f2e2bd62e929efb	false	0x079219834ebd417b57dce9d2b8462b1455d54103	14263429031962384927966	0x079219834ebd417b57dce9d2b8462b1455d54103	134	16568415	-15540	-14160	2023-02-06T08:00:59.000Z	0xdeeb3b4fdb4e48afaf282c7586de8eaf13339d0098e48ce9ddd3cc06b2159d19
0x8773315b21961828d5bdab9a29881b9ab25147f8	false	0x98dee2f43682a89f1c8405adeaadd47ba2de20cf	10838386	0x07ced903e6ad0278cc32bc83a3fc97112f763722	342	16567516	-4080	0	2023-02-06T05:00:11.000Z	0x85cbe6b43beca41dd734328c55ca2045aec2059531943f3b86bb2bd6e0658b72
0x9a37bcc8ff3055d7223b169bc9c9fe2157a1b60e	false	0x163d1a5708e536605e7b7b4b3b46a95dbf517800	3867605	0x07ced903e6ad0278cc32bc83a3fc97112f763722	172	16568582	-16080	-6960	2023-02-06T08:34:23.000Z	0xf72181dda2f5a375b98e750791e4dee8f17e72f8c1ebca2136fa07d7b6134ca5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.voltz_v1_ethereum.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 V1 protocol on Ethereum. Records fixed-to-variable rate swaps with notional amounts, tick ranges, token deltas, and cumulative fees for analyzing trading activity in decentralized interest rate 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_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
0xa1a75f6689949ff413aa115d300f5e30f35ba061	false	0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726	240	14995436	0x6e17aeef1a7b2ab5c8a71cf6d938f531836c1b05	-69060	2022-06-20T07:57:49.000Z	0xad0b7c9af205fd1f0001b000ba95898aae711906274055e4375c3621cd152293	-1000000000000000000000	-1563398307669814665330	2503161564979124432035869129	1000000000000000000000	336998763318113000	-1556757267542409316694
0xa1a75f6689949ff413aa115d300f5e30f35ba061	false	0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726	52	14995957	0x014607f2d6477badd9d74bf2c5d6356e29a9b957	-69060	2022-06-20T10:06:55.000Z	0xc6b44bb5e4fd137f0c344d9597c7e083b93c4ba41fe761d2ae72be51bf2ed4f7	10000000000000000000	15639321027605393343	2507669430214757147510696507320	-10000000000000000000	3362618911719940	15568507107225966440
0xae16bb8fe13001b61ddb44e2ceae472d6af08755	false	0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726	368	14996734	0x4c71ad0a41f05288286b719795df8f832fc531c0	-69060	2022-06-20T13:11:15.000Z	0x9d2c266a06b486734a43e137265daa13dcbd01fb5a6efe7571db9acc441737ad	5000000000	5464626663	2507669430214757147510696507320	-5000000000	1676048	5565944472

Example Query

Query with partition filter

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

Vamm_Swap_event

Swap transaction events from Voltz Protocol’s Virtual Automated Market Maker (vAMM) on Ethereum, recording interest rate swap executions with fixed and variable token deltas. Used to analyze trading patterns, fee accumulation, and liquidity position changes in decentralized interest rate 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_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
0xe8ddb4676eec36acffdffa6707f422e23a8dfc12	false	0x07ced903e6ad0278cc32bc83a3fc97112f763722	643	17431454	0xd350ef974f447fe8845579c49e78ba1ca79706ce	-69060	2023-06-07T22:29:11.000Z	0x25cab8c7faf3c6efe8a17e2da4613f3f51d8ca17d3a3f2f56abf73832d959d9f	-200000000000	-700077542854	2503161564979124432035869129	200000000000	12363324	-696155921079
0xe8ddb4676eec36acffdffa6707f422e23a8dfc12	false	0x07ced903e6ad0278cc32bc83a3fc97112f763722	194	17427550	0xd350ef974f447fe8845579c49e78ba1ca79706ce	-69060	2023-06-07T09:16:35.000Z	0x536d6c77b3577e98717e334f2c7007cd232150673b551a909d201495bb663b54	200000000000	699826813431	2507669430214757147510696507320	-200000000000	12664922	696186399940
0xe8ddb4676eec36acffdffa6707f422e23a8dfc12	false	0x07ced903e6ad0278cc32bc83a3fc97112f763722	336	17427748	0x96800cfdfa0af48eac2c3ff6a100cda0235517fa	-69060	2023-06-07T09:56:59.000Z	0x8ee7bd8c865064dd91a7a7053fc73255f2ffb209e2c7e6bc802b40d8b86d12ab	11000000000	38483952451	2507669430214757147510696507320	-11000000000	695725	38281970052

Example Query

Query with partition filter

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

Vamm_VAMMInitialization_event

Virtual Automated Market Maker (VAMM) initialization events from Voltz Protocol on Ethereum, capturing initial price configurations via sqrtPriceX96 and tick parameters. Used for tracking interest rate swap pool deployments and their starting price points.

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_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	log_index	block_number	block_timestamp	in_sqrtPriceX96	transaction_hash
0x538e4ffee8aed76efe35565c322a7b0d8cdb4cff	-8970	false	167	15249286	2022-07-31T08:59:26.000Z	50595075348098508863686565806	0x49b7e80f2cff02a138c83cba36cb253fd66dbc24a827b7b03de07648fc6ab131
0xd09723a7f4c26f4723aa63bf4a4a4a5dad970a49	-10860	false	553	15249296	2022-07-31T09:02:29.000Z	46033020278201473567245129680	0xe7f97526f6d9989454f09bbff0ce332c1fa5b3caa261b5b5e789464c0f6afae3
0xc75e6d901817b476a9f3b6b79831d2b61673f9f5	-3480	false	555	15249326	2022-07-31T09:09:22.000Z	66575758335881615895998418424	0x70ff3abf13e19d69f1261ab6f3f30493d2cb93b663c63f98a92d240c2fbe0742

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_IrsInstance_event

Fcm_FullyCollateralisedSwap_event

MarginEngine_Initialized_event

MarginEngine_liquidatePosition_function

MarginEngine_PositionLiquidation_event

MarginEngine_PositionMarginUpdate_event

MarginEngine_PositionSettlement_event

MarginEngine_PositionUpdate_event

vamm_Burn_event

Vamm_Burn_event

Vamm_Fee_event

Vamm_FeeProtocol_event

Vamm_Initialized_event

vamm_Mint_event

Vamm_Mint_event

vamm_Swap_event

Vamm_Swap_event

Vamm_VAMMInitialization_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_IrsInstance_event

​Fcm_FullyCollateralisedSwap_event

​MarginEngine_Initialized_event

​MarginEngine_liquidatePosition_function

​MarginEngine_PositionLiquidation_event

​MarginEngine_PositionMarginUpdate_event

​MarginEngine_PositionSettlement_event

​MarginEngine_PositionUpdate_event

​vamm_Burn_event

​Vamm_Burn_event

​Vamm_Fee_event

​Vamm_FeeProtocol_event

​Vamm_Initialized_event

​vamm_Mint_event

​Vamm_Mint_event

​vamm_Swap_event

​Vamm_Swap_event

​Vamm_VAMMInitialization_event

Tables

Factory_IrsInstance_event

Fcm_FullyCollateralisedSwap_event

MarginEngine_Initialized_event

MarginEngine_liquidatePosition_function

MarginEngine_PositionLiquidation_event

MarginEngine_PositionMarginUpdate_event

MarginEngine_PositionSettlement_event

MarginEngine_PositionUpdate_event

vamm_Burn_event

Vamm_Burn_event

Vamm_Fee_event

Vamm_FeeProtocol_event

Vamm_Initialized_event

vamm_Mint_event

Vamm_Mint_event

vamm_Swap_event

Vamm_Swap_event

Vamm_VAMMInitialization_event