unipilot_v2_arbitrum

Tables

UnipilotActiveFactory_VaultCreated_event

Unipilot Active Factory vault creation events containing token pair addresses, fee tier, strategy type identifier, and vault contract address. Emitted when new liquidity management vaults are deployed on Unipilot V2 protocol.

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__tokenA`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in__tokenB`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in__strategyType`	`STRING`	Identifier for the liquidity management strategy type used by the vault. Numeric string representing the strategy configuration.
`in__fee`	`STRING`	Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points.
`in__vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in__fee	removed	in__vault	log_index	in__tokenA	in__tokenB	block_number	block_timestamp	in__strategyType	transaction_hash
0xca69c359e3297aa855e77f83e071feab17f0ede6	10000	false	0xaecbd433e6f493dd0a45439ca6d513029b91d531	0	0x0c4681e6c0235179ec3d4f4fc4df3d14fdd96017	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	65998545	2023-03-02T08:11:10.000Z	2	0xbeb04dc00118323d78436719b844e10e720242cbee0ae000c091aa8ea00517ad
0xca69c359e3297aa855e77f83e071feab17f0ede6	10000	false	0x9959b32a1480b0ac5801ab265c325230b89a2b7e	13	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x912ce59144191c1204e64559fe8253a0e49e6548	72927868	2023-03-23T19:28:34.000Z	2	0x8e55586749f061078b4a37360a305aee1ee8dcf45c70b94fce05a3cc600419fc
0xca69c359e3297aa855e77f83e071feab17f0ede6	10000	false	0x08526f42a08b103f5b934657933032eae5ba5e10	9	0x088cd8f5ef3652623c22d48b1605dcfe860cd704	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	64101923	2023-02-24T12:09:48.000Z	2	0xa0a24ec61db8e9ddec4ecfd0d76be83b95110203705e9c22e9ab0f48c4331d26

Example Query

Query with partition filter

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

UnipilotActiveVault_CompoundFees_event

Unipilot Active Vault fee compounding events recording reinvestment of accumulated trading fees back into liquidity positions. Contains token0 and token1 amounts reinvested during compound operations on Unipilot V2 automated liquidity management vaults.

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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xffa7469bbbf8b269546362b5582a984471328794	false	23	124648183395430151145	18105562248882636	108717408	2023-07-07T08:38:13.000Z	0x0158da00731c309f74aa8f48b5b85e8b9a0e05fce0c1560bd29db1e8539542cb
0xffa7469bbbf8b269546362b5582a984471328794	false	18	16122198197027839899	2469113611948778	102488048	2023-06-18T17:25:04.000Z	0x463a997ed98ca4a7d175f0af7e3dff48f96437f6d338e8762561ece6c51508d3
0xffa7469bbbf8b269546362b5582a984471328794	false	22	190197536236319940435	10452460915837946	76597350	2023-04-03T11:39:30.000Z	0x5bb423bb97fb6ba74e0c037c1544f5899b7dba40d8913b4697fb2c812da1a42b

Example Query

Query with partition filter

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

UnipilotActiveVault_Deposit_event

Deposit events from Unipilot active vault contracts recording liquidity additions with token pair amounts and LP (liquidity provider) share issuance. Tracks depositor addresses, token quantities deposited, and corresponding LP shares minted to depositors.

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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_lpShares`	`STRING`	Number of liquidity provider shares minted to the depositor. Numeric string representation of share quantity in smallest denomination.

Sample Data

address	removed	log_index	in_amount0	in_amount1	in_lpShares	block_number	in_depositor	in_recipient	block_timestamp	transaction_hash
0x14f7d13c148dd50d58b8f83ac0e59f76e617f894	false	9	928182797517495	4005340000000000000	2608513139636300296	125443139	0x590633c7a387f5f8260bcbfb7c58cf7eb97f370f	0x590633c7a387f5f8260bcbfb7c58cf7eb97f370f	2023-08-27T11:00:46.000Z	0x0bc7ddf1c1bc53b5dc9d0adfb2bc6b2e97dedb0fcb5f205c50cef86c651cc6aa
0x14f7d13c148dd50d58b8f83ac0e59f76e617f894	false	9	13433640945037951155	11926072000000000000000	15982279824767309781091	102695813	0xfc7e2b665062b127047171ebb5000d53880bc88c	0xfc7e2b665062b127047171ebb5000d53880bc88c	2023-06-19T08:43:20.000Z	0x3290a19684530b5a0269009611c2b74e82d9043f6fd1609a5380d2df373af249
0x08fff4c7064cc0713c5aff086206c7b75d8f3af1	false	9	17899268043964979815	44663749519324617	10330997466387541245	169980048	0xb4269ff7c2fae58c23a87b7ac472fc721445a199	0xb4269ff7c2fae58c23a87b7ac472fc721445a199	2024-01-13T07:55:45.000Z	0xa6b05416632b8ac4faac1b478b68e7db67344b6097ada44b481f37cec834b44c

Example Query

Query with partition filter

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

UnipilotActiveVault_FeesSnapshot_event

Unipilot V2 vault fee snapshot events recording collected trading fees in both tokens of a liquidity pair. Contains fee amounts for token0 and token1, along with a flag indicating whether the snapshot was triggered by liquidity readjustment.

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_isReadjustLiquidity`	`BOOL`	Boolean flag indicating whether the fee snapshot event was triggered by a liquidity readjustment operation.
`in_fees0`	`STRING`	Fee amount collected in token0 of the liquidity pair. String-encoded integer representing the fee in the smallest unit of token0.
`in_fees1`	`STRING`	Fee amount collected in token1 of the liquidity pair. String-encoded integer representing the fee in the smallest unit of token1.

Sample Data

address	removed	in_fees0	in_fees1	log_index	block_number	block_timestamp	transaction_hash	in_isReadjustLiquidity
0x2ce15a47663106ce68b0cee6d36ea422afc0e256	false	30345844724975111	59197599	13	79986357	2023-04-13T10:07:32.000Z	0xec26d1fc6556dda8115d96ff76e9363555a056f21449949e1c6df288e1fc6b13	false
0x2ce15a47663106ce68b0cee6d36ea422afc0e256	false	0	0	16	79999927	2023-04-13T11:03:58.000Z	0xd884078034047eda27b1f818c2946a5909413627ce4656915802e818413ee269	true
0x8b0951d3c18e90f2ef04ceb6e1b0d0258287d479	false	2239299533346035	5685481	26	79999119	2023-04-13T11:00:38.000Z	0x2c45a3b4993859b97cc2c8d822bfccd3e244d4d2fb7f0d7b223bfe2c0e2c3428	true

Example Query

Query with partition filter

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

UnipilotActiveVault_Withdraw_event

Withdrawal events from Unipilot V2 active liquidity vaults recording share redemptions and corresponding token amounts returned to recipients. Contains share quantities burned, amounts of both pool tokens withdrawn, and recipient addresses for tracking vault liquidity removals.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_shares	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x2ce15a47663106ce68b0cee6d36ea422afc0e256	false	909140522190456380	14	984280750365357658	1236033657	120410197	0x12f3406984bbcb04a6b017cda9a90a5b5bded8d1	2023-08-11T16:22:48.000Z	0x0e330c94fb63e0579ec7bfa84d31de5035726ead455c0c575da58098b8d910c8
0x8b0951d3c18e90f2ef04ceb6e1b0d0258287d479	false	864847158993509446	14	1180854434123520764	860110335	120410401	0x12f3406984bbcb04a6b017cda9a90a5b5bded8d1	2023-08-11T16:23:43.000Z	0x4e37d6b274303ccee8ed9acd1e99a5a38210696f960db7f5710679fe4a3b0aee
0x14f7d13c148dd50d58b8f83ac0e59f76e617f894	false	148520932002795428658	15	100019127203862282	147519593829281440171	120412039	0x743a356ac36e9030465c7c72ac11e9a551a556ce	2023-08-11T16:31:12.000Z	0x3f80a604dc4e68b557b9f297692812e803b088145396481016e5f7d13cb0c07e

Example Query

Query with partition filter

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

UnipilotPassiveFactory_VaultCreated_event

Vault creation events emitted by the Unipilot Passive Factory contract, recording new liquidity vault deployments with their associated token pairs, fee tiers, and strategy configurations. Used for tracking Unipilot vault launches and liquidity management infrastructure.

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__tokenA`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in__tokenB`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in__strategyType`	`STRING`	Identifier for the liquidity management strategy type used by the vault. Numeric string representing the strategy configuration.
`in__fee`	`STRING`	Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points.
`in__vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in__fee	removed	in__vault	log_index	in__tokenA	in__tokenB	block_number	block_timestamp	transaction_hash
0x6900c436cf15d6d0016dc71a5ce5ade843031efd	10000	false	0x6aad534582b46c87774b3672d4ae5990a6b434d7	0	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xc628534100180582e43271448098cb2c185795bd	75027470	2023-03-29T21:03:36.000Z	0x60a7fcbe78dfbe07aa6e732ce73d40f106973122fac6e4d6db5a5c2566562c4e
0x6900c436cf15d6d0016dc71a5ce5ade843031efd	500	false	0x7532dc4dee0b6d882be51e34361f57c93f2f438c	12	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	84840692	2023-04-27T13:14:54.000Z	0xaf5394863f358c377185ba3a75fd3ea968fd96a372eee64eef1591beb82879d7
0x6900c436cf15d6d0016dc71a5ce5ade843031efd	100	false	0x84786dfdb04a00db5365ef30defd310b2ce79e12	0	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	182116911	2024-02-18T21:00:20.000Z	0x8aaf18a3f4f0b50fe5d24a11937c1c2511243891eaa254675b2e766520f0d0e0

Example Query

Query with partition filter

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

UnipilotPassiveVault_CompoundFees_event

Unipilot Passive Vault fee compounding event logs capturing the reinvestment of accumulated trading fees back into liquidity positions. Records token0 and token1 amounts compounded into the vault’s active liquidity 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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	log_index	in_amount0	block_number	block_timestamp	transaction_hash
0x913ec3667df6c3c28eaa87876fd906897e107f22	false	40	0	71857290	2023-03-20T18:19:26.000Z	0xe600d1d4b20c0cefdd594b4f93c6be0d9ca5a243b6bc1456033d5ab82e476698
0x913ec3667df6c3c28eaa87876fd906897e107f22	false	35	298703355098048443929	73268792	2023-03-24T18:42:18.000Z	0xade292540763ee4090ae5c6bbb31d7f5401903f85a60edd1926964ff8446bd60
0x913ec3667df6c3c28eaa87876fd906897e107f22	false	21	0	73268902	2023-03-24T18:42:46.000Z	0xd777f93689894a280575d1eaf4030ce6eb86a80ce6135560d6a8e9c91bda4de9

Example Query

Query with partition filter

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

UnipilotPassiveVault_Deposit_event

Deposit events from Unipilot passive vault contracts recording liquidity additions to automated market maker pools. Contains deposited token amounts, minted liquidity provider shares, and participant addresses for tracking vault position 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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_lpShares`	`STRING`	Number of liquidity provider shares minted to the depositor. Numeric string representation of share quantity in smallest denomination.

Sample Data

address	removed	log_index	in_amount0	in_amount1	in_lpShares	block_number	in_depositor	in_recipient	block_timestamp	transaction_hash
0x3a3186c613a64db192cca40de6e29706b695c191	false	22	448902640248086067778	95135937000000000	448902640248086067778	80616997	0x3da320613c7a45fdbe1ba0da677bf5f0d1c857a1	0x3da320613c7a45fdbe1ba0da677bf5f0d1c857a1	2023-04-15T06:18:34.000Z	0xc5d1fbb27d847c93b455bdc920d5d8473d77b1ce27e6bd5c85d35e8c4de04e37
0xa320d85d91ae3c436a6b3e6a2ba5238e148b8be3	false	13	1761172400000000	10983426071866974862	6225278760215919285	100704237	0x2c76f60c1b939cdfce6cab6c6324c05bae067496	0x2c76f60c1b939cdfce6cab6c6324c05bae067496	2023-06-13T10:07:17.000Z	0xb13945250d68d8f767158eccd470b0dcb60de000623747b3e88241f7bbf6d803
0xa320d85d91ae3c436a6b3e6a2ba5238e148b8be3	false	17	1988710388813285	11808194931110269856	6766147636505961185	100709994	0x2c76f60c1b939cdfce6cab6c6324c05bae067496	0x2c76f60c1b939cdfce6cab6c6324c05bae067496	2023-06-13T10:31:13.000Z	0xa6bb4c8a87b9aa6b5b136dc33b13cdd02b60dab7c00e0fbefef3d82d503b987f

Example Query

Query with partition filter

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

UnipilotPassiveVault_FeesSnapshot_event

Unipilot Passive Vault fee collection events recording token0 and token1 fee amounts earned from liquidity positions. Tracks fee snapshots with readjustment operation flags for automated liquidity management analytics.

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_isReadjustLiquidity`	`BOOL`	Boolean flag indicating whether the fee snapshot event was triggered by a liquidity readjustment operation.
`in_fees0`	`STRING`	Fee amount collected in token0 of the liquidity pair. String-encoded integer representing the fee in the smallest unit of token0.
`in_fees1`	`STRING`	Fee amount collected in token1 of the liquidity pair. String-encoded integer representing the fee in the smallest unit of token1.

Sample Data

address	removed	in_fees0	in_fees1	log_index	block_number	block_timestamp	transaction_hash	in_isReadjustLiquidity
0xdf3cc349165dce278dfdae721c54971a98b12581	false	4397892254057818	29154407688738717141	8	129548510	2023-09-09T16:04:45.000Z	0x8931c181a0ff67bad8923b90d5b98d16d321361203816f5efa48b4154534484b	false
0xdf3cc349165dce278dfdae721c54971a98b12581	false	471506082494536	3567190849826228524	16	129548510	2023-09-09T16:04:45.000Z	0x8931c181a0ff67bad8923b90d5b98d16d321361203816f5efa48b4154534484b	false
0xdf3cc349165dce278dfdae721c54971a98b12581	false	0	0	6	129548641	2023-09-09T16:05:21.000Z	0x81f91062009f5b77db1d4d8e7de9c27440075cfed50b521b94869587ac6a288e	true

Example Query

Query with partition filter

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

UnipilotPassiveVault_Withdraw_event

Withdrawal events from Unipilot Passive Vault contracts recording liquidity removals from automated liquidity management positions. Contains burned share amounts, withdrawn token0 and token1 quantities, and recipient addresses for tracking vault exits and liquidity flow 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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_shares	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x8b16b13cc6d0b973d7f5aed635c77788ae49c058	false	1038081267680735901103	25	129700742857061925146	2478613513	80272128	0x2cd14957ca789a448105767d5191467e04a7ed5a	2023-04-14T06:12:30.000Z	0x3218bf89e750f517d7133af1a89e2d51a0f9e6ef6b80df23fc946ac089b6329d
0xa320d85d91ae3c436a6b3e6a2ba5238e148b8be3	false	84843199234588376892	29	43606514695004033	114605390917215418190	86265992	0x44f0dba7ec5790788ee0a4b4c7a6f1fc9c7d9a8b	2023-05-01T17:55:52.000Z	0x5c79699f61b3681f4349c457ff8fe7596345559b75599748474ce31d7f5f8fff
0xdf3cc349165dce278dfdae721c54971a98b12581	false	1	20	0	0	126386338	0x865fcda847083c81e9c3fdf0e4612e13bf5086dc	2023-08-30T12:39:48.000Z	0xb5c61b5af3bd0608bee2834865bf60011b2b318310c110f84f448118fa28a3b6

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

UnipilotActiveFactory_VaultCreated_event

UnipilotActiveVault_CompoundFees_event

UnipilotActiveVault_Deposit_event

UnipilotActiveVault_FeesSnapshot_event

UnipilotActiveVault_Withdraw_event

UnipilotPassiveFactory_VaultCreated_event

UnipilotPassiveVault_CompoundFees_event

UnipilotPassiveVault_Deposit_event

UnipilotPassiveVault_FeesSnapshot_event

UnipilotPassiveVault_Withdraw_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​UnipilotActiveFactory_VaultCreated_event

​UnipilotActiveVault_CompoundFees_event

​UnipilotActiveVault_Deposit_event

​UnipilotActiveVault_FeesSnapshot_event

​UnipilotActiveVault_Withdraw_event

​UnipilotPassiveFactory_VaultCreated_event

​UnipilotPassiveVault_CompoundFees_event

​UnipilotPassiveVault_Deposit_event

​UnipilotPassiveVault_FeesSnapshot_event

​UnipilotPassiveVault_Withdraw_event

Tables

UnipilotActiveFactory_VaultCreated_event

UnipilotActiveVault_CompoundFees_event

UnipilotActiveVault_Deposit_event

UnipilotActiveVault_FeesSnapshot_event

UnipilotActiveVault_Withdraw_event

UnipilotPassiveFactory_VaultCreated_event

UnipilotPassiveVault_CompoundFees_event

UnipilotPassiveVault_Deposit_event

UnipilotPassiveVault_FeesSnapshot_event

UnipilotPassiveVault_Withdraw_event