uniswap_v3_avalanche

Tables

Factory_FeeAmountEnabled_event

Factory contract events emitted when a new fee tier is enabled for pool creation in Uniswap V3. Records the fee amount in basis points and corresponding tick spacing parameter for concentrated liquidity pools.

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_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.

Sample Data

in_fee	address	removed	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
500	0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad	false	2	27832972	10	2023-03-24T04:40:28.000Z	0xe800494c82f8d26226091df3c0b5317e1990bda57e90b7a5305e102f55267b6d
3000	0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad	false	3	27832972	60	2023-03-24T04:40:28.000Z	0xe800494c82f8d26226091df3c0b5317e1990bda57e90b7a5305e102f55267b6d
10000	0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad	false	4	27832972	200	2023-03-24T04:40:28.000Z	0xe800494c82f8d26226091df3c0b5317e1990bda57e90b7a5305e102f55267b6d

Example Query

Query with partition filter

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

Factory_OwnerChanged_event

Factory contract ownership transfer event emitted when administrative control changes from one address to another. Records old owner, new owner, and block metadata for governance and access control tracking.

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_oldOwner`	`STRING`	Address of the previous owner before an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	in_oldOwner	block_number	block_timestamp	transaction_hash
0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad	false	1	0xeb0bcf27d1fb4b25e708fbb815c421aeb51ea9fc	0x93ce373cb03065e022eb8b4f5b3ac0ae77415fc8	27833085	2023-03-24T04:44:08.000Z	0x05d05ff666357aaa42007bb34f10c15a3b2454c477981a16f42c46c58e0b7df0
0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad	false	1	0x93ce373cb03065e022eb8b4f5b3ac0ae77415fc8	0x0000000000000000000000000000000000000000	27832972	2023-03-24T04:40:28.000Z	0xe800494c82f8d26226091df3c0b5317e1990bda57e90b7a5305e102f55267b6d

Example Query

Query with partition filter

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

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
100	0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad	0x11331307220b694443057e83c468152bf73b2f75	false	0x130966628846bfd36ff31a822705796e8cb8c18d	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0	36354076	1	2023-10-12T10:36:11.000Z	0x864f1e71cd2015683f93ffaca4f0471fe1d4e0b9f0d57e549abf93eecec7ec03
10000	0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad	0x80c3da91e21d57b5f9f8471b719af08dede40b11	false	0x80b010450fdaf6a3f8df033ee296e92751d603b3	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	1	36338552	200	2023-10-12T01:47:29.000Z	0x89763eb4d3bda94105f021418b3d3d1fd321cd63e14322ee2c8e3d82c909444e
3000	0x740b1c1de25031c31ff4fc9a62f554a55cdc1bad	0x94e909ca096e2add53c01a0aab3e7d63e9b7e313	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4	4	33518975	60	2023-08-05T08:49:50.000Z	0xcdbe13aaf27038d2e07adaadbec70a708eaf9ae0c9f1f08fde5917ea6049807d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_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
0xfae3f424a0a47706811521e3ee268f00cfb5c45e	false	0x5137861d7e47c97f248e360b1a6582fcf703ea91	10628095	46	512867917761	0	34182929	-252600	-249100	2023-08-21T03:12:23.000Z	0xed51cf0beccc07bf3d8720916e714a946892312a6cc7d9d9c9ba649a67d2f779
0xfae3f424a0a47706811521e3ee268f00cfb5c45e	false	0x5137861d7e47c97f248e360b1a6582fcf703ea91	1617420663	42	67553440793895	13	34182929	-252600	-249600	2023-08-21T03:12:23.000Z	0xed51cf0beccc07bf3d8720916e714a946892312a6cc7d9d9c9ba649a67d2f779
0x0e663593657b064e1bae76d28625df5d0ebd4421	false	0x655c406ebfa14ee2006250925e54ec43ad184f8b	0	21	0	0	34205222	-252960	-248640	2023-08-21T16:37:38.000Z	0x3b6408a0089ce87c321827fefbea96273a3c7c25fdfc4b9552ab31736afa5822

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_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
0x7b602f98d71715916e7c963f51bfebc754ade2d0	false	0x655c406ebfa14ee2006250925e54ec43ad184f8b	4	88243127950848	86210057559503405557	36496508	0x655c406ebfa14ee2006250925e54ec43ad184f8b	50110	51360	2023-10-15T21:43:39.000Z	0xbc661f7585c147b47b03714db572ba691687c58cb33b68b6b870cab789e22e54
0x7b602f98d71715916e7c963f51bfebc754ade2d0	false	0x655c406ebfa14ee2006250925e54ec43ad184f8b	5	93351504788	251651673579631252	36483073	0x655c406ebfa14ee2006250925e54ec43ad184f8b	51380	51400	2023-10-15T13:56:40.000Z	0xd7acc1e916460034a3ac822732f6efa83ab64751e96cdc19c1190d3d23e66b7c
0x90fbfd28f16fa163b914be6b9b3eeeb1c3e02fe5	false	0x655c406ebfa14ee2006250925e54ec43ad184f8b	5	4462134835061786839	3984231940263934462379989971	36499896	0x655c406ebfa14ee2006250925e54ec43ad184f8b	218000	224600	2023-10-15T23:42:08.000Z	0xae3f67f387512539b592cc907d83da55d39dc3e2493d03cd086ca0951505025f

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

address	removed	in_paid1	in_sender	log_index	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x502b94576c10c6ab8cc2a208c3d71a79ab249067	false	263795473225680403	0xc85e3309ddb084d38015fa78c872fb803e6e5fae	13	527590946451360805387	33039836	0x1901011a39b11271578a1283d620373abed66faa	2023-07-25T01:20:07.000Z	0x165e0124ee3067ad7bf12567ef0684f9f5acce489f765244bbba094b28097906
0x502b94576c10c6ab8cc2a208c3d71a79ab249067	false	401956536546218185	0xe9165e244307b546b6b2fc0b1aae869ae3758a36	89	803913073092436368435	33042500	0x1901011a39b11271578a1283d620373abed66faa	2023-07-25T02:48:42.000Z	0x2b26c76dd4a85086c94dd58cc38827eb0e57ddfbc04b8a12285699e1a0a1b89b
0x502b94576c10c6ab8cc2a208c3d71a79ab249067	false	74133842306333054	0xe9165e244307b546b6b2fc0b1aae869ae3758a36	117	148267684612666107029	33044411	0x1901011a39b11271578a1283d620373abed66faa	2023-07-25T03:51:11.000Z	0x64572ddfd7fe99be520a5af620affa5f77ce150ede6bb976e3f5173ff0598758

Example Query

Query with partition filter

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

Pool_Initialize_event

Concentrated liquidity pool initialization event emitted when a pool contract is first created and seeded with a starting price. Records the initial sqrtPriceX96 (square root price encoded as Q64.96 fixed-point) and tick index that define the pool’s starting exchange rate between token0 and token1.

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_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_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	log_index	block_number	block_timestamp	in_sqrtPriceX96	transaction_hash
0xe4e077adbd4f93cafcff29fa786dc4d044d7e0cf	31844	false	7	33166636	2023-07-28T01:33:37.000Z	389339696455594445780031035675	0xf592d721806f5e41b2487f3acc5815359e9ab9806f1cb03517f056866ff475dd
0x070d01b522fb39040a36de359f0c97f8218087bf	-65147	false	13	33197307	2023-07-28T19:05:32.000Z	3050009421279040475267480364	0xfabeeffc91661f956c6eee388efde5ba4970a42ea322432caeb550390f26139a
0x9c9a8c53e3e4085a60d5cc714e3a3b5ccac409f9	77552	false	32	33192276	2023-07-28T16:11:57.000Z	3826622945850858760258421246321	0xba8a8ae08a1d999597ba897fed7937694ce7c06efc78d0e884fec57435a9a2ab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_avalanche.Pool_Initialize_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
0x476dad462773eff80f968b4c0a3be8b5c0457b5b	false	0x655c406ebfa14ee2006250925e54ec43ad184f8b	6342571744630	0x655c406ebfa14ee2006250925e54ec43ad184f8b	20	195804	11999995082	34258446	-33400	-33200	2023-08-23T00:17:54.000Z	0xc69acdda2218a770523d38d0bd572c7df91e6be7871d45cc587c241f32bb2630
0x64877ede2fadc6cd65883fcefbc083eabde10f04	false	0x655c406ebfa14ee2006250925e54ec43ad184f8b	11133098148224	0x655c406ebfa14ee2006250925e54ec43ad184f8b	5	0	11154262710606811	34297675	-887200	138200	2023-08-23T23:44:53.000Z	0xefd4c6dbdff761a26285431edc35b07c8bab2e579c1702014f6b418d1666d211
0x749712c45985842b0dd16f175e6cc24d570e0819	false	0x655c406ebfa14ee2006250925e54ec43ad184f8b	4568825554	0x655c406ebfa14ee2006250925e54ec43ad184f8b	13	2881985	1686741	34263886	-30	-10	2023-08-23T03:35:54.000Z	0x5e4754c865418a9c08d2fcc451bbce7f8bcc6e54901318529bf0d220121e3705

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_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
0xd1356d360f37932059e5b89b7992692aa234eda6	56715	false	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	15	0	148	33546629	2749173056	0xb6800292521f722a799c07d31c8b8b014b24fa47	2023-08-06T00:20:01.000Z	1350118148821341689109541199303	0x6bbca7829e8ae90e3528b5844ce5085619a7461c24c5e3b39f4a0aaf8dffba78
0xd1356d360f37932059e5b89b7992692aa234eda6	56625	false	0xe9165e244307b546b6b2fc0b1aae869ae3758a36	50	-14934294	4284487941	33575325	40618446728	0xe9165e244307b546b6b2fc0b1aae869ae3758a36	2023-08-06T16:30:36.000Z	1344109165423675632399069976014	0x4461f746d6065dc5bbe817991a7e2c916dd54411b61911e6a6783e111c8ae67c
0xd1356d360f37932059e5b89b7992692aa234eda6	56718	false	0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad	13	12305	-3563699	33563474	43158015557	0x0fe7a53a44468a9e319ba208d896b99b70c99a0f	2023-08-06T09:48:33.000Z	1350337127886033494143474717055	0xd5cea1aae8ed8746805c63967e08b834b899cdeec87aeaacd7ecdbd90ce89c6c

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_FeeAmountEnabled_event

Factory_OwnerChanged_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Initialize_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_FeeAmountEnabled_event

​Factory_OwnerChanged_event

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Flash_event

​Pool_Initialize_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

Tables

Factory_FeeAmountEnabled_event

Factory_OwnerChanged_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Initialize_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event