integral_v1_ethereum

Tables

IntegralMerkleTimeRelease_Claim_event

Token claim events from Integral Protocol’s merkle-based time-release vesting contracts on Ethereum. Records recipient addresses and claimed amounts (option1Amount, option2Amount) for tracking token distribution and vesting schedules.

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_claimer`	`STRING`	Address of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_option1Amount`	`STRING`	Quantity of tokens claimed under the first option in the time-release contract. Value is zero in all sample claims, suggesting users primarily selected the second vesting option.
`in_option2Amount`	`STRING`	Token amount claimed under the second option in the time-release vesting schedule. Represented as a wei-denominated integer string, typically non-zero when option1Amount is zero.

Sample Data

address	removed	log_index	in_claimer	in_receiver	block_number	block_timestamp	in_option2Amount	transaction_hash
0x5adbc8e7458f5ba581bd8d3f4ec46cd765a6706b	false	605	0x90a622ac24ea88314c84830bbc19a2b70c7538ed	0x90a622ac24ea88314c84830bbc19a2b70c7538ed	15027109	2022-06-26T04:03:39.000Z	1172513984627564795751	0x9a06173f0c213a2a3b7ffdddb57160c7da16ed07b51862b6efc9438e9f91e68b
0xe96f5a2680981aec61c4980f2f7b9ad666698e61	false	573	0x4334703b0b74e2045926f82f4158a103fce1df4f	0x4334703b0b74e2045926f82f4158a103fce1df4f	15026736	2022-06-26T02:25:31.000Z	9240524712183869275787	0x209ec9360aae38bd9121416b8ca6d59c07e335f90865236426b5d359889c6757
0xe96f5a2680981aec61c4980f2f7b9ad666698e61	false	91	0x90a622ac24ea88314c84830bbc19a2b70c7538ed	0x90a622ac24ea88314c84830bbc19a2b70c7538ed	15027071	2022-06-26T03:56:09.000Z	772084535715826729522	0xd775482fe4504fc0f398a71a1cffdb7346f148c4667b916ba13efd43b5c055db

Example Query

Query with partition filter

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

TwapFactory_PairCreated_event

PairCreated events from Integral SIZE’s TWAP (Time-Weighted Average Price) factory contract on Ethereum, capturing the deployment of new liquidity pool pairs with token addresses and sequential pair identifiers. Used for tracking Integral protocol expansion and identifying available trading pairs for TWAP order execution.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0xc480b33ee5229de3fbdfad1d2dcd3f3bad0c56c6	0x6ec472b613012a492693697fa551420e60567ea7	false	6	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xdac17f958d2ee523a2206206994597c13d831ec7	160	17022679	2023-04-11T05:05:47.000Z	0xcd368e1acc914fd6bb35df012339398a7a7b3a4cbce6fa76ea049e23f25670b4
0xc480b33ee5229de3fbdfad1d2dcd3f3bad0c56c6	0x37f6df71b40c50b2038329cabf5fda3682df1ebf	false	7	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	142	17333304	2023-05-25T02:50:23.000Z	0x8023fffbeb4b45c109e3c7d3b4da41617f8029cebd45c301787f24c727b89847
0xc480b33ee5229de3fbdfad1d2dcd3f3bad0c56c6	0x2fe16dd18bba26e457b7dd2080d5674312b026a2	false	1	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	467	14423189	2022-03-20T12:11:01.000Z	0x50f071b3b62ad1577ba3483dbc49b28f832bf433dff5a3fa9e47e385900a1234

Example Query

Query with partition filter

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

TwapPair_SetSwapFee_event

Fee configuration changes for Integral (Size) TWAP liquidity pairs on Ethereum. Records swap fee updates with values in wei (typically 0.01% to 0.1%) for analyzing fee structure evolution across different trading pairs.

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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
1000000000000000	0x2fe16dd18bba26e457b7dd2080d5674312b026a2	false	108	14433851	2022-03-22T04:03:45.000Z	0xe8c8e577052cfb321d558d3f15d5ed629b6a343179761dca7d2b6ac1eac984da
100000000000000	0x6ec472b613012a492693697fa551420e60567ea7	false	122	17022687	2023-04-11T05:07:23.000Z	0xc685b3939a7700241e5fa807790f84fd566aedbf3e26483ef8900b9b0098c36b
100000000000000	0x43f0e5f2304f261dfa5359a0b74ff030e498d904	false	519	14561778	2022-04-11T02:44:50.000Z	0x557fa0b6748a07cd4c16b3751ac13e4e121fa1ff260fbceab404195679ee8e66

Example Query

Query with partition filter

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

TwapPair_Swap_event

Swap event logs from Integral v1 time-weighted average price (TWAP) liquidity pairs on Ethereum, capturing token amounts exchanged, sender and recipient addresses for each trade. Used for analyzing DEX trading volume, price execution, and liquidity pool activity.

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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount1In	in_amount0Out	block_timestamp	transaction_hash
0xd17b3c9784510e33cd5b87b490e79253bcd81e2e	0x37f6df71b40c50b2038329cabf5fda3682df1ebf	false	0x782534550e2553a42cdff8d5a94066d8c7b6729b	154	17590653	28594315521734645148	174866011	2023-06-30T07:36:47.000Z	0xadbfe7e9cb06ecf20bc7feea14901097da2f36778bc7c1a4866f7e084616540a
0xd17b3c9784510e33cd5b87b490e79253bcd81e2e	0x37f6df71b40c50b2038329cabf5fda3682df1ebf	false	0x782534550e2553a42cdff8d5a94066d8c7b6729b	194	17590249	38108764824074609163	233377269	2023-06-30T06:14:47.000Z	0xaeff2a80916822d195d603c7cb924ee0e2e832e620b05c377ebc089672665f3c
0xd17b3c9784510e33cd5b87b490e79253bcd81e2e	0x37f6df71b40c50b2038329cabf5fda3682df1ebf	false	0x782534550e2553a42cdff8d5a94066d8c7b6729b	195	17594069	88298068345710370317	558820666	2023-06-30T19:07:59.000Z	0x1eadc49fda8a88b3acd10b5da57d9133ba732cd4c85fe9f9ebf89a672e6ae1f8

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

IntegralMerkleTimeRelease_Claim_event

TwapFactory_PairCreated_event

TwapPair_SetSwapFee_event

TwapPair_Swap_event

​Tables

​IntegralMerkleTimeRelease_Claim_event

​TwapFactory_PairCreated_event

​TwapPair_SetSwapFee_event

​TwapPair_Swap_event

Tables

IntegralMerkleTimeRelease_Claim_event

TwapFactory_PairCreated_event

TwapPair_SetSwapFee_event

TwapPair_Swap_event