unipilot_v2_bsc

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
0x9c7cb0bb03044d6c1c472b26058bfa61b9956d22	500	false	0x4b8e629c2a406d3950fe4ce745e88f9c9ecf9c44	170	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	27141279	2023-04-07T12:54:51.000Z	2	0xda704a118dcfa6fc316d1b5956d20d3f0fb3a650a41c647484d6e4cd02058b77
0x9c7cb0bb03044d6c1c472b26058bfa61b9956d22	3000	false	0x84bce0a2f488ea3bbb7477e4c02cd3523973d2cd	328	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xe9e7cea3dedca5984780bafc599bd69add087d56	27453437	2023-04-18T10:41:04.000Z	2	0xf22a2f950898ff13115404b071cfdcbbd009dc9468a5dfa559d3618a1749a90c
0x9c7cb0bb03044d6c1c472b26058bfa61b9956d22	500	false	0x74d6a2f87b7430c9bad0a9343f98c9ae4f3f63f8	232	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	27452921	2023-04-18T10:15:16.000Z	2	0x6cc0eb13a692f064d77662058779b56d858583e54ed0f5fcf72f9c58f7f80f8b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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
0x4b8e629c2a406d3950fe4ce745e88f9c9ecf9c44	false	331	4166970427403	55639075894109	27421820	2023-04-17T08:15:41.000Z	0xe96f7b9f7916a35589b4d0029db1977f05283bd7ac8390a89f9fbbbd05214ed0
0x74d6a2f87b7430c9bad0a9343f98c9ae4f3f63f8	false	194	1541629041252564	5637376282045593	28238089	2023-05-15T17:41:20.000Z	0x6a4a2777073d62a10a3cb7df922c76cf362ef9c3ee57805d154e2ddfdb1ab88f
0xbcf63b6d12275c5a688f939162459f8105488995	false	241	68748138255565565	241831298733014	31648608	2023-09-11T12:19:44.000Z	0xa436cb0a599c1303331a92c0b5559bec728613e8110dafed93c9cb216873412d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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
0x4b8e629c2a406d3950fe4ce745e88f9c9ecf9c44	false	198	656853611235211	60411483000000000	60411483000000000	27364537	0x1e13e5b5acbb0c3f0fde50fe7661fdf75df8f932	0x1e13e5b5acbb0c3f0fde50fe7661fdf75df8f932	2023-04-15T08:18:45.000Z	0xbfe1206d6ba18f7c00796964a4003ce6dd22420cca1d28d8b59ea3ee96705f2c
0x74d6a2f87b7430c9bad0a9343f98c9ae4f3f63f8	false	148	34097828267378881	235473489787447200	219379449108556431	27960372	0x521f3805ce5d1d4bfc3dae22a454400edcf6538c	0x521f3805ce5d1d4bfc3dae22a454400edcf6538c	2023-05-06T01:52:37.000Z	0xfd9d6e3eaa9af1dcfa0879f9a2c76fa661bc82cc104a50b3221512a4f24335e9
0x84bce0a2f488ea3bbb7477e4c02cd3523973d2cd	false	335	60375450000000000	19767360822976492623	19767360822976492623	27482308	0x1e3881227010c8dcdfa2f11833d3d70a00893f94	0x1e3881227010c8dcdfa2f11833d3d70a00893f94	2023-04-19T10:48:37.000Z	0xe30755af7ea18d5604a4534eb14ee8398fa4e2da34d7ed2edebe32af5efe76ef

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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
0x84bce0a2f488ea3bbb7477e4c02cd3523973d2cd	false	922706957141299	257995710483633782	100	28891372	2023-06-07T11:07:17.000Z	0x40922f4f4f2b01479a927dc4284ed8c5b36be2d422467229e5c96e4a07dbce1c	true
0x62c580d1593b5d09d9416a6d9b07c5f3be25c56a	false	30965855352622832065	99402345443105274	393	28891388	2023-06-07T11:08:05.000Z	0x0cad73d1996cb682555c32fbbb6f9528c85dec817f220ef68dc34981d2605452	true
0x74d6a2f87b7430c9bad0a9343f98c9ae4f3f63f8	false	3217653861478146	21552069683331558	412	28891352	2023-06-07T11:06:17.000Z	0x22a41c484e2cba5265247d3b6c3f30bb2a7dd715d5405bd3ac775dd7e236d142	true

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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
0x84bce0a2f488ea3bbb7477e4c02cd3523973d2cd	false	3089089981415456005	375	14052302942771530	1977698309452240999	30331213	0x7c51fdf3185f4d5c7372dd15091d03b967399fc6	2023-07-27T14:24:30.000Z	0xbcd865c8f78ba8536614478a3d713f4975eecb96f5ae679c7d6ef28fe7876d70
0x74d6a2f87b7430c9bad0a9343f98c9ae4f3f63f8	false	36989506490801940	422	7473060783987485	29408210463471792	27979600	0x25d4ef82374e02e8f94535efa18f224e1e715e6a	2023-05-06T17:54:57.000Z	0x9e05a5fd83aa69e13d9c3a3ef0ce46162fc27a4a125ca974aae4d4986f4f5eba
0x74d6a2f87b7430c9bad0a9343f98c9ae4f3f63f8	false	1	322	0	0	29466879	0x7dffe4c2f7b3410b0261b0259210fc5ec6522560	2023-06-27T11:57:52.000Z	0xf7fccaaad6af6c7b682e99a98fbae425d3f37eb8a1255cddb7a674c934a4e55a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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	3000	false	0x3dca78bd578c1376b0d563cc13a054c2a42d3877	71	0x55d398326f99059ff775485246999027b3197955	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	27380382	2023-04-15T21:36:14.000Z	0xabf5b9523961f9cf3cdac04e603aaa5226cd7b28690a89fbf2efddb7924c9447
0x6900c436cf15d6d0016dc71a5ce5ade843031efd	10000	false	0x68ae2188e6cabe7851f009be991aebed7f314152	189	0x031b41e504677879370e9dbcf937283a8691fa7f	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	32879427	2023-10-24T09:20:11.000Z	0x52b043b8506f33405efcd92aea1c7a709013c573cfdb024e36a934e897c17bec
0x6900c436cf15d6d0016dc71a5ce5ade843031efd	100	false	0xe49b0def5df1ae4068abd2aeae083888656a881f	141	0x55d398326f99059ff775485246999027b3197955	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	40848540	2024-07-27T20:29:11.000Z	0x11b5bc5725837593d166c9992c4ca22269a5adbdf8c1fcf603f2af10596f9f1f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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_amount1	block_number	block_timestamp	transaction_hash
0x68ae2188e6cabe7851f009be991aebed7f314152	false	157	10646957361085818	32992592	2023-10-28T07:58:37.000Z	0x81140f9a733d3b1d13c28f2ae2823df8ac6bfe8843972d972649e1f91738ebc8
0x3dca78bd578c1376b0d563cc13a054c2a42d3877	false	79	0	31486654	2023-09-05T20:46:21.000Z	0x408e3475342fda1eb115e03f74215ab75421e450067d559af9d757683430f70c
0x68ae2188e6cabe7851f009be991aebed7f314152	false	158	0	33065914	2023-10-30T21:22:48.000Z	0x9d3725ee1a136f05cbc60b783f3ad42893f240e1852ae5030260d610ef1bf38f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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
0x3dca78bd578c1376b0d563cc13a054c2a42d3877	false	67	30000000000000000000	90258000000000000	30000000000000000000	27380519	0x1e3881227010c8dcdfa2f11833d3d70a00893f94	0x1e3881227010c8dcdfa2f11833d3d70a00893f94	2023-04-15T21:43:19.000Z	0x49a35096afacab7741a5ba4111910dbf1a6c25121d9b34cedd558d465ba725a3
0x68ae2188e6cabe7851f009be991aebed7f314152	false	227	264251415262063502232	296146560000000000	264251415262063502232	32879860	0x04d4491252151fce7d1bd762472d3a8ea6c8c422	0x04d4491252151fce7d1bd762472d3a8ea6c8c422	2023-10-24T09:42:02.000Z	0x92337d628e8037d63269ec848cc0c2349c1e4f7fbb3bd7cae291b7eca0d5140a
0x68ae2188e6cabe7851f009be991aebed7f314152	false	245	12540283564938304297	20347669000000000	15308915551472381537	32882148	0x43e3bba2305e0a8881d1a341a185444aa88087e1	0x43e3bba2305e0a8881d1a341a185444aa88087e1	2023-10-24T11:36:53.000Z	0x3ed0e8c611e286f541a25538b43686325428f6e1c01f8e150fa9d65d8214c06b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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
0x3dca78bd578c1376b0d563cc13a054c2a42d3877	false	617804330312224687	2233536547886288	136	28900955	2023-06-07T19:07:51.000Z	0x4b166b452e46b501014e4bc93d2388388cb38bc434bb154abdd184e997178455	true
0x68ae2188e6cabe7851f009be991aebed7f314152	false	571022048782647943	932872171192858	150	32992592	2023-10-28T07:58:37.000Z	0x81140f9a733d3b1d13c28f2ae2823df8ac6bfe8843972d972649e1f91738ebc8	false
0x68ae2188e6cabe7851f009be991aebed7f314152	false	13542951463476954725	22645812087668035	140	32992592	2023-10-28T07:58:37.000Z	0x81140f9a733d3b1d13c28f2ae2823df8ac6bfe8843972d972649e1f91738ebc8	false

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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
0x3dca78bd578c1376b0d563cc13a054c2a42d3877	false	30000000000000000000	78	953922011737355098	204184936866683569	31486654	0x1e3881227010c8dcdfa2f11833d3d70a00893f94	2023-09-05T20:46:21.000Z	0x408e3475342fda1eb115e03f74215ab75421e450067d559af9d757683430f70c
0x68ae2188e6cabe7851f009be991aebed7f314152	false	262437142482598088796	156	12795894835915624232	618104768858828101	32992592	0x43e3bba2305e0a8881d1a341a185444aa88087e1	2023-10-28T07:58:37.000Z	0x81140f9a733d3b1d13c28f2ae2823df8ac6bfe8843972d972649e1f91738ebc8
0x68ae2188e6cabe7851f009be991aebed7f314152	false	264251415262063502232	157	12884355041929501048	622377832672852420	33065914	0x04d4491252151fce7d1bd762472d3a8ea6c8c422	2023-10-30T21:22:48.000Z	0x9d3725ee1a136f05cbc60b783f3ad42893f240e1852ae5030260d610ef1bf38f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_bsc.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