unipilot_v2_polygon

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
0x95b77505b38f8a261ada04f54b8d0cda08904708	500	false	0x7e7825eed23a3480c51d4fcfcaea42fd547914eb	196	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	38595281	2023-01-27T17:36:25.000Z	3	0x906d5d72373482e8901cdcd56bb5bc6b065a1a47bf03c01638b6a51af6ada4b7
0x95b77505b38f8a261ada04f54b8d0cda08904708	500	false	0xe5d7753e149e100b589bf5fcb6dc13704751294f	115	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	35185586	2022-11-04T09:45:15.000Z	3	0x9689673116263dc3de89cac09025e0167d6486b04c232b7edd1617d8819fa3c9
0x95b77505b38f8a261ada04f54b8d0cda08904708	3000	false	0xecff5d443bd75717da345c87e3c20bbe281784d5	232	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	41446327	2023-04-12T13:12:03.000Z	2	0x4971ba175184638e8b62f45c6b38e62b27c2b9b8b31a2820e9b8457ebdbfe4f8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x685ce43912b66e5e688140e1270b425ace8edf97	false	237	16969	2370024241488043	39762254	2023-02-27T08:58:15.000Z	0x4a45e6a3a0f0ea4fa4000929c1162d83530fc157189f1ba21f66baeaf0ab619f
0x8e771cd6c07091a667863b47d25fc4a8d3d6b57e	false	167	49158121552304222643	42194261	39781273	2023-02-27T21:04:05.000Z	0x5c75eff011792d28783c3e1d6ab27ef59dfb2717c4c0f6b89deaccef9edd1130
0xe08ec1c73edeeb25ada28fe5a20ad58fe66a082b	false	166	278015682	60149853563115606	39762590	2023-02-27T09:12:41.000Z	0x56d67a62852201b429fe82ec5c14646cf23f309a5904a5b635eddb28992cf43c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x8e771cd6c07091a667863b47d25fc4a8d3d6b57e	false	164	119114230000000000000	358503988	307470516369800458191	38336727	0x1473a0d2beb958077382ffe1d0ef83946f8147fb	0x1473a0d2beb958077382ffe1d0ef83946f8147fb	2023-01-21T04:57:54.000Z	0x1643c5d5e708082c69088f89722d533d3c7ebfb79cc7264876eb28805f231191
0xe08ec1c73edeeb25ada28fe5a20ad58fe66a082b	false	313	18333788	15185562045561612	17336748310901056	38347758	0x0c38c134445714764fd8c61adb6cdf9a9e5ecd21	0x0c38c134445714764fd8c61adb6cdf9a9e5ecd21	2023-01-21T11:37:46.000Z	0x62f6f8aa491429a1ccb4a5dec5ce12b9976578d4a4d08e1be4a6a14f571c86a8
0xe08ec1c73edeeb25ada28fe5a20ad58fe66a082b	false	591	119611409	104186583513270394	116475911674508058	38347562	0x0c38c134445714764fd8c61adb6cdf9a9e5ecd21	0x0c38c134445714764fd8c61adb6cdf9a9e5ecd21	2023-01-21T11:30:18.000Z	0xc71af91f6eafb276e52fa098526ba54fdee8794a53c7519d52dfcdd322fc9dcb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x1c42bcbc0345ef8d7e9c2fc709f60bba3794d5e3	false	78667453	50659824138115155	155	38246227	2023-01-18T21:57:05.000Z	0x9e23ad1297945e47b5e7f4f9d2292cf2bb763524aebbb04f1a76cc3d936200a2	false
0x685ce43912b66e5e688140e1270b425ace8edf97	false	24235	4295540502326230	234	38242999	2023-01-18T20:02:45.000Z	0x2920cea8d9429eeb9ffb5f6ac2e4d8e9a84a6ce91edd7361b7dba22c1d6e4f79	false
0x685ce43912b66e5e688140e1270b425ace8edf97	false	3455	681875684860823	229	38246262	2023-01-18T21:58:19.000Z	0xc0d1e34b7972a066913b5af4796ed4a2934a6fb2bf40d30d5907a0e330384825	false

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x685ce43912b66e5e688140e1270b425ace8edf97	false	1214121440918316434	327	7853653	1193719198047305815	46378996	0x3fd6d5875778ba9415ca913152ccf41b6e2a2064	2023-08-16T14:16:20.000Z	0x81d996e5c155e9f61883b2a493cc35e4d1f96817338f38beb76d04e6a2f75938
0xe08ec1c73edeeb25ada28fe5a20ad58fe66a082b	false	1267215689330929030	347	1460335842	823630521971606381	46378996	0x3fd6d5875778ba9415ca913152ccf41b6e2a2064	2023-08-16T14:16:20.000Z	0xddcf774c68d662225ae1a8c40a7aaf3869770246b46a37120174f2ec7e3e6355
0xe5d7753e149e100b589bf5fcb6dc13704751294f	false	124547985358534982117	188	116892292099275208582	55056528	46379014	0x3fd6d5875778ba9415ca913152ccf41b6e2a2064	2023-08-16T14:16:58.000Z	0x40b2c745d45b31c7c45231cb08dadc67672d8fc3d1a69fda17cbe197abaa16de

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x2536527121fc1048ae5d45327a34241a355a6a95	10000	false	0x8afdb4d815c7eb4993d387070d833d2ebd508881	663	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x6f8a06447ff6fcf75d803135a7de15ce88c1d4ec	37956031	2023-01-11T20:03:44.000Z	0xc1dbc0c4a1968f91ffc322ffd0b6b5b2baf7291b730371230bcd07bf31e1bcb5
0x2536527121fc1048ae5d45327a34241a355a6a95	500	false	0x4a659951e821458884445fe7438d722a60509946	171	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x53e0bca35ec356bd5dddfebbd1fc0fd03fabad39	37955838	2023-01-11T19:57:06.000Z	0xebcf9a0dca3177a65915150e705d7c9f2c4c2a8af0efbaffeb502e4c6b1844b0
0x2536527121fc1048ae5d45327a34241a355a6a95	3000	false	0x107ad7a1d83f9979e3089a4f033e10886b437fe6	238	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0xa486c6bc102f409180ccb8a94ba045d39f8fc7cb	36172108	2022-11-28T12:20:42.000Z	0xfa6bd13b311f53ba7e614a36eb5d3bcc14059cffcbb8c71b1159f927ab077487

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x39a11fbc49f501bec1735f9a1dbd78ab71dcd003	false	174	516624051016262918	0	35342480	2022-11-08T05:27:36.000Z	0x39d90627fc41ae44390ffa9276852d7826501a282ada883d61270af1192842a1
0x39a11fbc49f501bec1735f9a1dbd78ab71dcd003	false	370	198133839564453	1198	35352029	2022-11-08T11:00:07.000Z	0xbb1941b9c5a303a0f9c1c377aa0da123abc048d44a3ddc4c9e69223b2f3f0d7e
0x1307b181d832536b7b8e0d130148845b6634887d	false	221	1663567969022079705	231842588552528	37434335	2022-12-29T21:12:32.000Z	0x3fe349e6cec44e83f7e73e86876c5d0388d897d7a11d365bd6ab87c086d94e84

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x8afdb4d815c7eb4993d387070d833d2ebd508881	false	117	80000000000000000000	5789929585783139020630629	5967630838605905586107630	38585609	0x636266d680fcd3fba735996b91d4f07b961b1598	0x636266d680fcd3fba735996b91d4f07b961b1598	2023-01-27T11:45:29.000Z	0x0f73f19adb69803850b4217cf15cd5027b3fea3efa0b669f9d74a22119cc99c1
0x05bf9467bc4ab29f1ad1b7080a16782d28f4391b	false	178	83675523000000000000	235274194	201543413789785776141	38596479	0x1633f02c9ea29b69e4492173a05ccd9a3f860595	0x1633f02c9ea29b69e4492173a05ccd9a3f860595	2023-01-27T18:20:46.000Z	0x2d1a31799c4616a478155b3c293130da79d2d9b95ad71cd162944fd5f8313e32
0x1307b181d832536b7b8e0d130148845b6634887d	false	172	12557552000000000000	29999999730713310	27812931577996085219	38584962	0x1e13e5b5acbb0c3f0fde50fe7661fdf75df8f932	0x1e13e5b5acbb0c3f0fde50fe7661fdf75df8f932	2023-01-27T11:18:51.000Z	0x1e266fd24b9bad06852e5364b01b2eba2c9d3d57c2405d055034165f9cdb51d4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x233d88df16f9c58c10faed1285cefc104baf3c26	false	1805633301009386345	1742342	195	35512300	2022-11-12T10:40:43.000Z	0x43c8fd010f4a988b80617e9e463f6490ef0296e2678f83310d86e1ba4e4b518d	false
0x233d88df16f9c58c10faed1285cefc104baf3c26	false	608461245957700672	587133	206	35512300	2022-11-12T10:40:43.000Z	0x43c8fd010f4a988b80617e9e463f6490ef0296e2678f83310d86e1ba4e4b518d	false
0xac9e9deaad7659bd83c7a8ff4ea97fd7366d006d	false	330456	63248189411824588	461	35513630	2022-11-12T11:30:49.000Z	0xa6ed2ddfe1189f58b3a4d827d94f2bf452cf7bd451c3fc69331022be230b0af6	false

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unipilot_v2_polygon.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
0x05bf9467bc4ab29f1ad1b7080a16782d28f4391b	false	1	293	0	0	46050716	0x17c6197080bee5e37c70dbb960b46a38070fd5f5	2023-08-08T08:18:23.000Z	0xd194e81c5212f4fde7df54e26188de1e25dc6d1958f1ed2d644faa8938491d3b
0x31cc9b771d59d7c33e0a8a975bc7827193cb3474	false	677112895684950368559	193	124662408648628196610	245202509861517802630	48115895	0x3a4961a71be671f2b19a9156441586865cfeee53	2023-09-29T08:23:59.000Z	0x4f50e5ab0a8c3d7b8cf9082827c0f5bd14d5b15ede50b768fb8d0a62c4b945e3
0x56a5ab2ee9f9320a9b57baa4686ca53c45fb0b3f	false	11515533857194376679	192	28027174317795712589	358655	48115913	0x3a4961a71be671f2b19a9156441586865cfeee53	2023-09-29T08:24:37.000Z	0x134fdf4f34faa7d6173caeba81a17c649ab60ac401c981660cad9e22dcdaa307

Example Query

Query with partition filter

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

UnipilotQuickswapActiveFactory_VaultCreated_event

Vault creation events from Unipilot V2 automated liquidity manager on Quickswap (Polygon), recording new vault deployments with token pair configurations and strategy types. Useful for tracking Unipilot vault launches and analyzing which token pairs and strategies are being deployed on Quickswap DEX.

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__vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in__vault	log_index	in__tokenA	in__tokenB	block_number	block_timestamp	in__strategyType	transaction_hash
0xc99fa77ab721817da9dd3c3b4f8ecb13772fcece	false	0x17b8468b170e1818694a8c78116ef4c1935c7558	381	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	43017441	2023-05-22T15:19:47.000Z	3	0xab591c6fe1efcc90c4fbd25fd5ed53204af0114ddb35410afa809e522a238970
0xc99fa77ab721817da9dd3c3b4f8ecb13772fcece	false	0x8376606db950e794257e2f2d8ae46e326db03d95	427	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	43017471	2023-05-22T15:21:21.000Z	3	0xd2a6f0060c09b29192958d42db49410fc8add393d01c28bee9d7e7b5a82c1738
0xc99fa77ab721817da9dd3c3b4f8ecb13772fcece	false	0x533480391efbe06144a5e08b1f221de8fda2e25e	198	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	43042597	2023-05-23T07:25:28.000Z	3	0x16180d6190fe91b9f950b44d14b00c6213ef06bb01f41188201c2760847f23be

Example Query

Query with partition filter

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

UnipilotQuickswapPassiveFactory_VaultCreated_event

Vault creation events from Unipilot V2’s passive liquidity management factory on Quickswap (Polygon), recording new automated liquidity provider vault deployments with token pair and strategy configuration. Used to track the launch of new Unipilot vaults and their underlying asset pairs for liquidity provision 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__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__vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in__vault	log_index	in__tokenA	in__tokenB	block_number	block_timestamp	transaction_hash
0xbd712d4dbd4b8d0cd2a98adb0f9fc2928031b16f	false	0x8648a47a3a0d581ca6d5437c0f86a0456f4e09a5	302	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	0xba777ae3a3c91fcd83ef85bfe65410592bdd0f7c	43836356	2023-06-12T18:46:01.000Z	0x47c3224d64b924252dc4e5d3609f6633c23a95633bd68cf89874e89bb8aa9e49
0xbd712d4dbd4b8d0cd2a98adb0f9fc2928031b16f	false	0x326215c1a2b47ac150f2f39b38a8e730a9e34921	285	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	0xf4584d3067ce2f1c3c0779d91bb960678f8ff1de	43412905	2023-06-01T15:53:51.000Z	0x05fd4e92a292b9ebd7d2bfa259d0bdc87d8a5460c370cca7ce04ea7bbb72ad36
0xbd712d4dbd4b8d0cd2a98adb0f9fc2928031b16f	false	0xc1721646bd2589cc7a38210707ca393d230a1cad	320	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	0xf4584d3067ce2f1c3c0779d91bb960678f8ff1de	43266763	2023-05-28T23:21:56.000Z	0x2ecca7c0dd4e6520295c97ec9f7f625ebe94c92b0b7ba8d46b7422294d5f6997

Example Query

Query with partition filter

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

UnipilotQuickswapActiveFactory_VaultCreated_event

UnipilotQuickswapPassiveFactory_VaultCreated_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

​UnipilotQuickswapActiveFactory_VaultCreated_event

​UnipilotQuickswapPassiveFactory_VaultCreated_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

UnipilotQuickswapActiveFactory_VaultCreated_event

UnipilotQuickswapPassiveFactory_VaultCreated_event