unipilot_v2_ethereum

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__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
0x4b8e58d252ba251e044ec63125e83172eca5118f	10000	false	0x03471db4f1ec626b2f495ec789157676b3282820	124	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xde30da39c46104798bb5aa3fe8b9e0e1f348163f	16720227	2023-02-27T14:49:11.000Z	0x8e0d1ac82a8c95cf8338006f44a30969eac453893546991dd946e66831d4c996
0x4b8e58d252ba251e044ec63125e83172eca5118f	500	false	0x2e00b08a9131bc663ee80d267b67d2aa220da41d	294	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	14563650	2022-04-11T09:40:19.000Z	0x1dca8ab947a80b8d840f5941b023c69e9a8e6ce071b788eaeb89b84126aed9ef
0x4b8e58d252ba251e044ec63125e83172eca5118f	500	false	0x0efec68f73eefe12e077b4a0a4ed6faa86a95ac5	164	0x5f98805a4e8be255a32880fdec7f6728c6568ba0	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	17115095	2023-04-24T08:55:47.000Z	0x027fcf095ea6c5045abb9287f632eba602f782ce4f0f029ad02bfb18ecf54c03

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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
0xab170c6bda86b521c16f83e836f6b4fecb867508	false	485	238399374803867715137	241546730555804605	16183590	2022-12-14T14:40:47.000Z	0xb6d701b736cf71f9ca7702f9dfc629b46c91e6af119a7d876bdc91a479f689cc
0xab170c6bda86b521c16f83e836f6b4fecb867508	false	149	41917231112571125791	20880441671664390	16185546	2022-12-14T21:12:59.000Z	0x4fbf54a20434b2ff3627405d73145ac605876eca6cdad66ff0cdfc792cb1a982
0x3d2677a567a645fc0b90a0f7c2cf3d21b01ff01d	false	168	256247979184424049	194513868392918384249	17613174	2023-07-03T11:33:59.000Z	0x6126bfcf2efeb4aac0eb3683e30de0a622fe5a901a9e6cf92e26574a0ac98de2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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
0xab170c6bda86b521c16f83e836f6b4fecb867508	false	238	90027336050597050698	158685578282616432	195731892984450135570	16159160	0xe45419390b38f2a90645a8930ce4039d99f116f7	0xe45419390b38f2a90645a8930ce4039d99f116f7	2022-12-11T04:44:59.000Z	0x83055df50bd95ad0fdb405d58e96035cef16f27adf2e1b7eea420b725e40f203
0x045fe18eebe96f75f6ed5542a292dfa82adb09cd	false	352	999999998731914755	881683980000000000	926062111157640390	16645899	0xbf51f7d5037a4f7d59eaa056dba49366d4cb1d1f	0xbf51f7d5037a4f7d59eaa056dba49366d4cb1d1f	2023-02-17T03:55:35.000Z	0xe632030bc9d119217ec091f82157bae23cd6406fba0875c67beb241794e954ea
0xa85288c861c95b471c3c44828d1a1a8c3242ac8c	false	211	62273351554819519941	2000000000000000000	281166247291034410187	17437920	0x9cb54db0072194bf718a70c54fd095e1f32086aa	0x9cb54db0072194bf718a70c54fd095e1f32086aa	2023-06-08T20:24:11.000Z	0xcaaa1a9b2ce8d6f0d85d52decfdeb6fb8d59738d06f0c8475e3d56bbf24adbc9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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
0x2e43450afc8a1d277e6b3a07ed41335412d72536	false	187657785600371662	1118582171128193133731	304	15567435	2022-09-19T12:02:23.000Z	0x5c950e4a4a083df3c309759161bb33cc8da067e8e40198d5ebb53cc8d5f62165	false
0x1ae1df64bf695ea1f1a7ebdc280af712340f09a9	false	537067091	399257458387019358	337	15568153	2022-09-19T14:28:11.000Z	0xe132f1c90be8bf10d31ce6829b0fd4c9628856a226bdb839d2deba9a79bd1499	false
0x84aed18d5ffd6be9dd9c7410d3137065411c571e	false	76783525696926045262	49791332894806617	596	15568107	2022-09-19T14:18:47.000Z	0xd13680e1e20e9215b92ac105c0eda44c0078d4052dc77695f6490421ad23663a	true

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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
0xab170c6bda86b521c16f83e836f6b4fecb867508	false	473629208195710860689	56	187536838663147379025	421878777162407823	17008405	0x3aa6327088c308aaca2f32308e82e649e7662e37	2023-04-09T04:31:35.000Z	0x83522e05e4ed150277f147b7ea18e21835a5a9e27e92d0d781113b6375e3892a
0xab170c6bda86b521c16f83e836f6b4fecb867508	false	48877142067475870394	93	18371750913341088701	45620355494872916	17013077	0x8cb88f6a0856fc5f9afa3255bc3dbefa3cf49272	2023-04-09T20:26:59.000Z	0xf4586d0886d8894de3d2389d4abce6930cf0fff60e642bf0536aee7679c2465b
0x2e00b08a9131bc663ee80d267b67d2aa220da41d	false	1160636401263913011	84	2881716	2089809667430446861	18076423	0x8b31f376d36e76387775d3618c4b489ee2e87ceb	2023-09-06T09:08:59.000Z	0x7eed477c8ef5a5ea6a87120ac5e838f8acfa959f62651d3eef7d177e1413fba7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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__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
0x06c2ae330c57a6320b2de720971ebd09003c7a01	3000	false	0x48ffe3c338914dae7e3954ef158ef74ea3b90c49	176	0x5b4c95f76b8bd3ada1d8baa717cf658e14cf0dbf	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	17709482	2023-07-17T00:42:11.000Z	0xd377534ff67d3d60c60c57fc60c37eba42fc5e78ce9a5bfd34cf72cc0c62a4c5
0x06c2ae330c57a6320b2de720971ebd09003c7a01	10000	false	0x2c1bc52a06ee08375ae228a88b46619be08c2af6	565	0xb3999f658c0391d94a37f7ff328f3fec942bcadc	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	16743020	2023-03-02T19:44:35.000Z	0x6693e575aea3f6bbc6702af50b6f580152ddcf3f547c91f275d007b82aa17489
0x06c2ae330c57a6320b2de720971ebd09003c7a01	3000	false	0x6d425d67d96dcf3f46691efa3cc9964e36037a16	174	0x04fa0d235c4abf4bcf4787af4cf447de572ef828	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	16707976	2023-02-25T21:31:23.000Z	0x78d048b1a667e7377513106bac517d65301bac7fa79e2750f0bb9697baffff74

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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	in_amount1	block_number	block_timestamp	transaction_hash
0x3c4f5c7d8d6a493fd7b6c338f77f26302f4d3cb1	false	49	10308508816520564	10830129840827541545	17015394	2023-04-10T04:19:35.000Z	0xd28d3fbdb77c2506e7e4de92fdb61bb246d54cd5b60dabde3708f2843580d08a
0x78012e5fd9aa90b0d9a30d7595826b9089ca9163	false	170	350690065675087909	38566615569475936	17018195	2023-04-10T13:49:23.000Z	0x2d00c0b1de055bef78681ce5bd6cbe35ccfc48b2f07b9e589018b0ec8864aade
0xa5606d30057a79a8f8474833a04637e2606dc297	false	312	0	0	17379861	2023-05-31T15:52:11.000Z	0x8d3206e2f786ebf67705427b8cbfd15382c1fada109b6ba73105ea9408ba4c8e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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
0x3c5bd1331f2283fd752e757c266f9abf19978765	false	191	328269130000000000	796755521249420782699	657630591868206991042	14741597	0xd864077f557d48e25fe04fa89f9926b8cc66970e	0xd864077f557d48e25fe04fa89f9926b8cc66970e	2022-05-09T09:17:10.000Z	0x571baa5427cf8891a749887c302add4fa179a8e881b24747ef1dbd4c09c3f28c
0x4e20a56907fc89dad65bdb6817606fcfcaaa283a	false	58	25001106000	25028637311	25028637311	14813085	0xde8bfa80913f0a07780506ed460d74c8ceab6c7a	0xde8bfa80913f0a07780506ed460d74c8ceab6c7a	2022-05-20T20:12:56.000Z	0xcb6223e2386306d8b1802ebb844f3f85ea5e30d3f7afb0bcfeff71bb55c40bef
0x3c4f5c7d8d6a493fd7b6c338f77f26302f4d3cb1	false	60	674707260000000000	855181171553200630826	632304370708041370654	15724098	0x1e13e5b5acbb0c3f0fde50fe7661fdf75df8f932	0x1e13e5b5acbb0c3f0fde50fe7661fdf75df8f932	2022-10-11T09:53:35.000Z	0xbb777c3bd10f1daeb1fb987e65f7abd6b112aa66dc2e9f6d526a5f71ebfad645

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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
0x0c5eda1517d9fdb38abbb419b30e3f397169dd6b	false	649397415902924	178599178805195564036	261	15744001	2022-10-14T04:35:47.000Z	0x7f85d77621fe85aa024379a3142477f271370d47b815a8909b100efc20d85bdb	false
0x0c5eda1517d9fdb38abbb419b30e3f397169dd6b	false	832140559513481307	217121307740138425427237	250	15744001	2022-10-14T04:35:47.000Z	0x7f85d77621fe85aa024379a3142477f271370d47b815a8909b100efc20d85bdb	false
0x9ae67a8910b07629c98f2a3d9da8597b32e6bdac	false	47456864578615280024	211026678312005026	143	15743814	2022-10-14T03:58:11.000Z	0x54035abd8cb9b29b19803f896a95624b974dad1abad0676fb3d8479ee0087c2b	false

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_ethereum.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
0x8cffc60fa9a11d11383caaa68e9217298e3bbb8d	false	1802628959	679	5317035	2441646053	16600816	0x9ca627de8e06213671b6166717c8cf876c1d7808	2023-02-10T20:42:23.000Z	0x3cc6fc8ce89fc5fd85f950d90e466915bc449b04fd95e57dc3c4ee0300c84af5
0x3c5bd1331f2283fd752e757c266f9abf19978765	false	15001003439437029755718	182	8854274794965030747	14992421657236398313002	14733181	0x97d0ca9d5be59db4a7451a762fc6a1d7ce51ef24	2022-05-08T01:21:16.000Z	0x9160f716bf65a01b5a7f2d12d8d443d3665988e5f63a6cff7e6f4c694035f1e8
0xac24387167ecf998b6e0ab0dce521ec6c3f1e38e	false	1230119479200876624960	318	32804734288079713124	9675758514868412109	14929723	0xd6cb7a7b544e24e5160a948a16c45b1096276f9d	2022-06-09T00:37:11.000Z	0x1be36f6cbaf781d1acb2e03ca407c4cc6b42d95706545f4e61346dba59808fe6

Example Query

Query with partition filter

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