integral_v1_arbitrum

Tables

TwapFactory_PairCreated_event

Liquidity pool creation events from the Integral TWAP (Time-Weighted Average Price) decentralized exchange factory contract on Arbitrum. Tracks new trading pair deployments with token addresses and sequential pair identifiers for monitoring protocol expansion.

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
0x717ef162cf831db83c51134734a15d1ebe9e516a	0x7a0f899ef730fe178e0574b8dab4440ca336e415	false	4	0x5979d7b546e38e414f7e9822514be443a4800529	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0	159654644	2023-12-13T08:38:44.000Z	0x2984ea48494008226b212fab1b64e2f0e7b61b7e0a4acdd5b6839d3c3548319f
0x717ef162cf831db83c51134734a15d1ebe9e516a	0x12b8bc27ca8a997680f49d1a6fc1d93d552aacbe	false	2	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0	159654089	2023-12-13T08:36:20.000Z	0x282bd7f4d2651988f53a40225e52fc3c5e7d0a2378f95f6628fbaf4f02342f12
0x717ef162cf831db83c51134734a15d1ebe9e516a	0xf31778748b3364fc43d6ab6aac4f52e2c29b6353	false	3	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	6	159654336	2023-12-13T08:37:24.000Z	0xfc5e0e46275a3be949a93fb8a532361ecf34d119fa95a9ee9c9ab3373512cfd2

Example Query

Query with partition filter

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

TwapPair_SetSwapFee_event

Swap fee configuration events from Integral V1 TWAP (Time-Weighted Average Price) pairs on Arbitrum, recording when liquidity pool fee parameters are updated. Tracks fee changes ranging from 0.01% to 0.05% across different pair contracts for analyzing fee tier adjustments and pool economics.

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	block_number	block_timestamp	transaction_hash
100000000000000	0x4bca34ad27df83566016b55c60dd80a9eb14913b	false	17463100	2022-07-12T06:45:13.000Z	0x655ed0a8ff566071989d09e6676f4a0abfe0d7b0c86999d40af1db13cf0e20bf
200000000000000	0x4bca34ad27df83566016b55c60dd80a9eb14913b	false	188265955	2024-03-08T08:04:35.000Z	0x0c16f7deec764f3a3d76acb741cf026f7219182855e622c2d34cc8764ee903d0
200000000000000	0xf31778748b3364fc43d6ab6aac4f52e2c29b6353	false	188266054	2024-03-08T08:05:00.000Z	0x7afbe8d303f99c8ff49dce9a8c4edb66049b5b8b95d44c04fe0a88bcb7541384

Example Query

Query with partition filter

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

TwapPair_Swap_event

Swap events from Integral Size TWAP (Time-Weighted Average Price) liquidity pools on Arbitrum, capturing token amounts in/out, sender, and recipient addresses. Used for analyzing limit order execution and TWAP strategy performance in Integral’s oracle-based AMM.

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_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x9ead888876b3978e8b138d4b6416111255b89e03	0x4bca34ad27df83566016b55c60dd80a9eb14913b	false	0x7b96662d4dbbf6894a888ba53afbe2f98359c973	3	39166946	43000000000000000	51919407	2022-11-18T23:18:23.000Z	0x21a15e739bea674bac3f0fe7a60a03c0e2c2292cb0b91aaec30a00ea5673e3f7
0xa51b7930684773e0a6ea594a45584f9b9c2ec660	0x4bca34ad27df83566016b55c60dd80a9eb14913b	false	0x7b96662d4dbbf6894a888ba53afbe2f98359c973	3	39042676	226000000000000000	274795503	2022-11-18T11:55:16.000Z	0x739ccac3107a15e4026779669972795af28ff7bfaf53a5fe511e3813abf164e4
0xa51b7930684773e0a6ea594a45584f9b9c2ec660	0x4bca34ad27df83566016b55c60dd80a9eb14913b	false	0x7b96662d4dbbf6894a888ba53afbe2f98359c973	4	39035499	8207045555683706	10000000	2022-11-18T11:20:07.000Z	0x5def48211d6986f40a549d4d9e15c9cc71b0d7422d664ebf41af5cb59ca9cf16

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

TwapFactory_PairCreated_event

TwapPair_SetSwapFee_event

TwapPair_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​TwapFactory_PairCreated_event

​TwapPair_SetSwapFee_event

​TwapPair_Swap_event

Tables

TwapFactory_PairCreated_event

TwapPair_SetSwapFee_event

TwapPair_Swap_event