sushiswap_v3_avalanche

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
3000	0x3e603c14af37ebdad31709c4f848fc6ad5bec715	0x5face58d5e55b4a3d8bf67241aa1641d8356d99f	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xbdef4444668ba0011e8b45f54b4bca4e7b786792	45	30275830	60	2023-05-20T19:54:56.000Z	0x3c0bc2767a4a8164c677d8916a59f4c56cf375a2e589148dfe78cb3c0a10f955
3000	0x3e603c14af37ebdad31709c4f848fc6ad5bec715	0x18aef861f39203d14ae2d1488f8ee88dfc243b8a	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xce1bffbd5374dac86a2893119683f4911a2f7814	22	30219776	60	2023-05-19T12:19:41.000Z	0x167fef662eba781f1a34e1560a059bd540d98787a61fd94cb057ea06bf1d83a0
3000	0x3e603c14af37ebdad31709c4f848fc6ad5bec715	0x1c484179c3c3d58a09f572a3d8a5cb5b9f239a21	false	0xa752b27a0007d754f74035abf46ad39bdf066fa8	0xbdef4444668ba0011e8b45f54b4bca4e7b786792	15	30236304	60	2023-05-19T21:36:30.000Z	0x62e0b51a779f5c416637c72b590ba1ceb2a19b8f03612e2c1d38fe093626fbd7

Example Query

Query with partition filter

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

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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_owner	in_amount	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x8c29a143d26b053d777338670d2dbd865c3f75a9	false	0x18350b048ab366ed601ffdbc669110ecb36016f3	71614707994	0	8296996	252718122	36182527	-64	9	2023-10-08T07:45:21.000Z	0x24603631221824d9c3ae0b2bb359ce238e2dcb2efffe4932514b643648cbb75d
0x0ce37db103eb3d6e4290a0cbb14a5f18f3f05e8d	false	0x18350b048ab366ed601ffdbc669110ecb36016f3	28358156257	4	16480142	180080870	36182635	-120	19	2023-10-08T07:48:58.000Z	0x3ba66838009e9bc6b3701347c90665405573e3631f05f032d26913df7faa3944
0x6a069a8cab98803e6785453041e0ceba57e0138c	false	0x18350b048ab366ed601ffdbc669110ecb36016f3	84755089555	11	38254191	194585905	36182583	-45	10	2023-10-08T07:47:14.000Z	0xa646ba1b7b0bb74e9073f6da23184d1c995c42a10744e3c2ecb78fe61d881e15

Example Query

Query with partition filter

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

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`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_owner	log_index	in_amount0	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x4a5c0e100f830a1f6b76a42e6bb4be2a7fe0d61b	false	0xdba2ccc38908c2cfbc867d4625940d2a9903383a	55	3666456068019399539	54601753	32714156	0xdba2ccc38908c2cfbc867d4625940d2a9903383a	-253410	-245980	2023-07-17T09:35:50.000Z	0x2b2709a52013335ac22d3cfa192cfc464662df3c5dfcc4716b56b60946fea3f5
0x14200e0892ce1929346f5c5d07820f69a1774d3b	false	0xbc92fc8b0e4129215a9dd17a1a54d5b603488aad	46	27516162525980984	1858144193197789908	32713886	0xbc92fc8b0e4129215a9dd17a1a54d5b603488aad	48180	50340	2023-07-17T09:26:41.000Z	0xb1cb667256451244fe61fc79e133b43a03ae51a7e96a1647ebcd51cfc35b49a4
0x4a5c0e100f830a1f6b76a42e6bb4be2a7fe0d61b	false	0x18350b048ab366ed601ffdbc669110ecb36016f3	4	170037910135044806	1589488	36329665	0x18350b048ab366ed601ffdbc669110ecb36016f3	-887270	887270	2023-10-11T20:35:45.000Z	0xed82f2f58a1dc4e6d0adb1fd1c911acb189ec1a6b7448de0f54bd2d9397de64e

Example Query

Query with partition filter

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

Pool_CollectProtocol_event

Protocol fee collection events from concentrated liquidity pools, recording fees withdrawn by the protocol from trading activity. Contains token amounts collected (amount0, amount1), sender address initiating the collection, and recipient address receiving the fees.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x815482b1a596603fa036f4372e6ce3e25b380d17	false	0xcd03e2e276f6eedd424d41314437531f665187b9	2	43578445591967478673	130637731430401862	50371345	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-09-10T20:41:46.000Z	0xff951c3a007ba72371d9344f24ea1e9adc8bd322c7acbb6103cd8197ab5595db
0xc0b6dc34777d66ae1537455abf65760a1dbd0f87	false	0xcd03e2e276f6eedd424d41314437531f665187b9	52	1313940552955458968	9862	57538555	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-02-19T04:57:25.000Z	0x1e33f6de229b7a8fc230da9ee3f259a586b57815b1613dd7d719e02bb123aa72
0x14200e0892ce1929346f5c5d07820f69a1774d3b	false	0xcd03e2e276f6eedd424d41314437531f665187b9	5	345666573668254	32648166467823584	56100641	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2025-01-20T17:17:47.000Z	0x4e8670e900041dadf07df04a1f84dad320655513a12e2f33decf3c15e016c88e

Example Query

Query with partition filter

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

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation 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_sender`	`STRING`	Address that initiated the transaction or operation. 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_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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_owner	in_amount	in_sender	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xd937a05df90918f584a17a168026cc06f9cb099d	false	0x18350b048ab366ed601ffdbc669110ecb36016f3	1743640400575	0x18350b048ab366ed601ffdbc669110ecb36016f3	32	130348963883201441	2000000	29843563	-256020	-242160	2023-05-10T15:19:57.000Z	0xad8684e8332842b94dfad506aa3ae43e3398c3b3429cba949398137e88c765ee
0xd937a05df90918f584a17a168026cc06f9cb099d	false	0x18350b048ab366ed601ffdbc669110ecb36016f3	3051370701007	0x18350b048ab366ed601ffdbc669110ecb36016f3	153	228110686795658590	3500000	29853174	-256020	-242160	2023-05-10T20:43:04.000Z	0xc8542fe5d3e8e0e16c1285c8c9b608951f07d2f9c0721481c4bb74e8aeb1493e
0x14200e0892ce1929346f5c5d07820f69a1774d3b	false	0xbc92fc8b0e4129215a9dd17a1a54d5b603488aad	7741046163984922744	0xbc92fc8b0e4129215a9dd17a1a54d5b603488aad	20	9184512867193646	4416027313667695907	35212141	50700	51900	2023-09-15T09:40:06.000Z	0xaab9e962ac8deab22225ae44aeef5fb21ac7577f565add9bbec02632bb518ff4

Example Query

Query with partition filter

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

Pool_SetFeeProtocol_event

Protocol fee configuration change events emitted when liquidity pool fee parameters are updated. Records old and new fee protocol values for both tokens in the pool, tracking governance-initiated fee structure modifications.

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_feeProtocol0Old`	`INT64`	Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol1Old`	`INT64`	Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol0New`	`INT64`	New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
`in_feeProtocol1New`	`INT64`	New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeProtocol0New	in_feeProtocol1New
0x119178ed33e7d462ef2d4a787dc8d801e0397150	false	3	54437324	2024-12-16T21:16:08.000Z	0x065575e03f77e1270fa1ad45df8c9aa5ba1a892c901020e8a86431e220fd0336	4	4
0x8a43554da0c3a2d6c2005c88c2097a24a4366773	false	13	56100477	2025-01-20T17:13:02.000Z	0x290c1eaa78f6436766d6adf0aff3f9ed536f1ba7e59c73599b0683172d200743	4	4
0x7434d02933bf3943bde4a7208c00ef7239dfa936	false	12	56100477	2025-01-20T17:13:02.000Z	0x290c1eaa78f6436766d6adf0aff3f9ed536f1ba7e59c73599b0683172d200743	4	4

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	in_sqrtPriceX96	transaction_hash
0x4a5c0e100f830a1f6b76a42e6bb4be2a7fe0d61b	-250158	false	0x3cafaa48f875f3efa8339b5dbd6577a9992b5ab0	25	-2186982785676972987	29918061	32779968	7359076717159817	0xf7fd3edfcd7c3c51f01e06557fa18ff7fb46e0ef	2023-07-18T22:42:19.000Z	293125525063248412021646	0xf3a2dd4f06f7d45a5669a2cc31230ab92a20286a9d90846d77459154b770d9da
0x4a5c0e100f830a1f6b76a42e6bb4be2a7fe0d61b	-250119	false	0x3cafaa48f875f3efa8339b5dbd6577a9992b5ab0	38	-3898468269475443150	53494773	32780213	7359076717159817	0xf7fd3edfcd7c3c51f01e06557fa18ff7fb46e0ef	2023-07-18T22:51:42.000Z	293701164309424346610921	0x1ad05a50d35d7e0574d818f5e582bd21a567ed48b80fec8c7773df6cfa842c3c
0x6d8874e20603d5d34a3257cc9a6cc79a712d5a39	249985	false	0x3cafaa48f875f3efa8339b5dbd6577a9992b5ab0	17	-2050292	141109294451045738	32772896	11798791746305	0x519b4a90596f9cee0cafaefc781bb9170f5b2f4f	2023-07-18T18:45:09.000Z	21231495193120248627392227072380393	0x00641d0c78253ba82a200b580bf832627b043f8fb31320762d77e56ef6f8be11

Example Query

Query with partition filter

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

V3Factory_PoolCreated_event

Uniswap V3 factory pool creation events emitted when new concentrated liquidity pools are deployed, containing token pair addresses, fee tier, tick spacing, and the deployed pool contract address. Used for tracking DEX pool deployments and liquidity pool registry construction.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
10000	0x3e603c14af37ebdad31709c4f848fc6ad5bec715	0x8eaf84001447da898054d06edf6e4ebc010f33a1	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	1	34329285	200	2023-08-24T18:33:06.000Z	0x485692d38b44e459690d2cb75ed153a6662f21ddd05e9f8b7528e3d0caa8adfe
100	0x3e603c14af37ebdad31709c4f848fc6ad5bec715	0x75d1fd674400d88c48c7f2f05c303c6568edf69d	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	0x50b7545627a5162f82a992c33b87adc75187b218	0	28370763	1	2023-04-06T00:24:11.000Z	0xa18e0bab73c7f0d4d79cf3bed8da09cb93fe74a7fe9aba44708109273da56302
100	0x3e603c14af37ebdad31709c4f848fc6ad5bec715	0x8c29a143d26b053d777338670d2dbd865c3f75a9	false	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0	28370611	1	2023-04-06T00:19:07.000Z	0x9dffb3b0f027a654164606f0e794a49c3d3e9862c459f32d06557c427f30e89b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

V3Factory_PoolCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

​V3Factory_PoolCreated_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

V3Factory_PoolCreated_event