pharaoh_v2_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
10000	0xaaa32926fce6be95ea2c51cb4fcb60836d320c42	0xf4ddba137346f83f65e751332f8dd368a91d9526	false	0x864b91b166e0411ae52dc06282fe90eddec40923	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	29	55547446	200	2025-01-09T06:13:00.000Z	0x7e3f39a7fc633ff80fa6f29565dcaef85793a9495d11de3c9dec8ab6cc3815cc
10000	0xaaa32926fce6be95ea2c51cb4fcb60836d320c42	0xc24db680efd4a3d3bba81429db8387dd553dedc4	false	0x128ace5bf1a8ec6deac07f91de765e17dc35ef1f	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	5	55541173	200	2025-01-09T02:49:29.000Z	0x5b65791312edf598aa52f3a469855621c7f4f7a50a484ba6c8a1539f933a7db8
3000	0xaaa32926fce6be95ea2c51cb4fcb60836d320c42	0xb6278c6cb4d90c12f391330911996fdb9fbe9421	false	0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b	0xd5d0a9b3f2c264b955ae7161cfa6d38a7aea60a7	35	51864920	60	2024-10-16T20:09:51.000Z	0xa73c0782d6eebed18e5b694fb32eca3ca2594dfa6256da806f3b37e63160c2fe

Example Query

Query with partition filter

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

FeeCollector_FeesCollected_event

Fee collection events from Pharaoh V2 DEX (decentralized exchange) on Avalanche, splitting trading fees between treasury and fee distribution contracts for each liquidity pool. Used to track protocol revenue allocation and analyze fee generation across different token pairs.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeDistAmount0`	`STRING`	Amount of token0 collected as fees allocated for distribution to liquidity providers. Denominated in the smallest unit of token0 (wei-equivalent), as seen in values ranging from 0 to trillions.
`in_feeDistAmount1`	`STRING`	Amount of token1 allocated to fee distribution from the Pharaoh V2 pool on Avalanche. Raw token amount in smallest denomination (e.g., wei), can be zero if only token0 fees were collected.
`in_treasuryAmount0`	`STRING`	Amount of token0 allocated to the protocol treasury from collected fees. Stored as a string-encoded integer representing the smallest denomination of the token.
`in_treasuryAmount1`	`STRING`	Amount of token1 allocated to the protocol treasury from collected fees. Denominated in the token’s smallest unit (wei-equivalent), can be zero if no fees collected for that token.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeDistAmount0	in_feeDistAmount1	in_treasuryAmount0	in_treasuryAmount1
0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	0xa71ba3939cd6c50c674866e321bc6bba1c977dd0	false	15	47410349	2024-07-01T08:55:07.000Z	0x19fd94ba020b619a174051bdd4a91d3b0f13aabd4f1179bbfb484b4f511a2f69	78888	762296900415884001	8765	84699655601764888
0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	0x66a5de11d1e1f20da825d974453f099c4bb13647	false	22	47412116	2024-07-01T09:55:07.000Z	0x24d5c24a5b544301ff5e99d502b35f8631b868844bdd1e8cf3a5d2a29937263e	13927012028790768	1140436036862639601	1547445780976752	126715115206959955
0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	0xa20c959b19f114e9c2d81547734cdc1110bd773d	false	34	47412116	2024-07-01T09:55:07.000Z	0x24d5c24a5b544301ff5e99d502b35f8631b868844bdd1e8cf3a5d2a29937263e	1843662671319129895	75197559	204851407924347766	8355284

Example Query

Query with partition filter

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

FeeDistributor_ClaimRewards_event

Reward claim events from Pharaoh V2 DEX on Avalanche, capturing fee distribution claims by tokenId holders with amount, reward token address, and claiming period. Useful for analyzing fee revenue distribution patterns and liquidity provider earnings across different reward tokens and time periods.

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_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_period	in_reward	log_index	in_tokenId	in_receiver	block_number	block_timestamp	transaction_hash
0x38418af264f9b45e4a3981e2a0fc38d3a394b577	false	39647602053751549	1727308800	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	11	3218	0x6954f7add88b0c0a2761a5dd0a56913df88894c8	51876242	2024-10-17T02:39:40.000Z	0x71ee860fc25911d2f968b7a8c5fcad69b5efeca4debeea7a6ee20a724cbc2476
0x18b1299f80a1fbf63308b65ad4fc5ff37c77220b	false	12318016398866110220589	1727308800	0x8f56421dc48dcce052d9afc80b696291ddaa832a	17	3218	0x6954f7add88b0c0a2761a5dd0a56913df88894c8	51876242	2024-10-17T02:39:40.000Z	0x71ee860fc25911d2f968b7a8c5fcad69b5efeca4debeea7a6ee20a724cbc2476
0x38418af264f9b45e4a3981e2a0fc38d3a394b577	false	5055920101058123179096	1727308800	0x201d04f88bc9b3bdacdf0519a95e117f25062d38	5	3218	0x6954f7add88b0c0a2761a5dd0a56913df88894c8	51876242	2024-10-17T02:39:40.000Z	0x71ee860fc25911d2f968b7a8c5fcad69b5efeca4debeea7a6ee20a724cbc2476

Example Query

Query with partition filter

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

FeeDistributor_NotifyReward_event

Reward distribution events from Pharaoh V2 protocol on Avalanche, recording token rewards allocated to fee distributor contracts by period. Contains reward token addresses, amounts, distribution periods (Unix timestamps), and sender addresses for tracking liquidity mining and fee sharing distributions.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.

Sample Data

address	in_from	removed	in_amount	in_period	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xe9cd59d907ec7351d7671906f4d750bbca25df0f	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	false	2819217245813784547	1723075200	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	33	49140493	2024-08-11T21:55:08.000Z	0xab8a1b1342d5e002865916a0e21b1869677ccf03d79fe30bd1d35bddc867851a
0xe9cd59d907ec7351d7671906f4d750bbca25df0f	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	false	12099699753259506	1723075200	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	31	49140493	2024-08-11T21:55:08.000Z	0xab8a1b1342d5e002865916a0e21b1869677ccf03d79fe30bd1d35bddc867851a
0xe9cd59d907ec7351d7671906f4d750bbca25df0f	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	false	34664300873206293	1723075200	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	16	49121555	2024-08-11T10:55:06.000Z	0x0cea42d911baea54819128f68af882abf610b77f1f0b26d7e13e162dd6441075

Example Query

Query with partition filter

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

FeeDistributor_VotesIncentivized_event

Vote incentive events from Pharaoh V2 DEX (decentralized exchange) on Avalanche, tracking reward token deposits to bribe voters for specific voting periods. Used for analyzing governance incentive programs and vote-buying dynamics in liquidity mining campaigns.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.

Sample Data

address	in_from	removed	in_amount	in_period	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x2c8d5942194430b9acd27627cf09f3bbc45020cd	0x3e1be93dfb853747c160b602419e261d3914b693	false	8500000000000000000	1732147200	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	4	53077905	2024-11-14T20:03:31.000Z	0x11b38cc7cb753f0409ef973b17c2940beb4abc0eda76ff7301669a8c0e8763e6
0xba608c9e0b99a5846602df26a600592eef29adc2	0x3e1be93dfb853747c160b602419e261d3914b693	false	8500000000000000000	1732147200	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	7	53077846	2024-11-14T20:01:33.000Z	0x7370c344f8bc9fa1d2b113b63887348dc95beaa98428ba3076ebe1d578d9ad1b
0x3838287b7e73fef5cbfa6acf0f6ac85540a8f98d	0x3e1be93dfb853747c160b602419e261d3914b693	false	10600000000000000000	1732147200	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	3	53077937	2024-11-14T20:04:36.000Z	0xae9e9d4663e6a656e0cb4647b2aa17a9c9eb3a5831fdbbb1eb7a8dd05e82b9e3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pharaoh_v2_avalanche.FeeDistributor_VotesIncentivized_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	block_timestamp	transaction_hash
0x184b487c7e811f1d9734d49e78293e00b3768079	false	0xaaa78e8c4241990b4ce159e105da08129345946a	24	0	43751802125	54130676	0x4edd50d8f20480e8246fbf7f0c00df58c4e074e5	-1	2024-12-09T15:16:53.000Z	0x186e2be4b16b41744ca16beead39f63fb27f9ca119f1627b1367e89da8eeaffe
0x184b487c7e811f1d9734d49e78293e00b3768079	false	0xaaa78e8c4241990b4ce159e105da08129345946a	4	0	166802174756	54142440	0x1265156d15eccf173f39c41bbe028c95cc420388	-5	2024-12-09T21:52:30.000Z	0x02dc0824c56d9265676f74fbc58f51db53289019fd0433764aa15dea65d2116b
0x184b487c7e811f1d9734d49e78293e00b3768079	false	0xaaa78e8c4241990b4ce159e105da08129345946a	8	3671448	55604016237	54141882	0x1265156d15eccf173f39c41bbe028c95cc420388	-5	2024-12-09T21:34:19.000Z	0x972dcd27664e02f62c99c40b12f94f00c676ba8478325cfa081e2eba2295f533

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pharaoh_v2_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	block_number	in_recipient	block_timestamp	transaction_hash
0x66a5de11d1e1f20da825d974453f099c4bb13647	false	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	161	0	49550138	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	2024-08-22T00:00:18.000Z	0x92e54efae9fa8a543fc3194d222b6478f7f1f8bd9d36db39352ea9ddd52e2e51
0x184b487c7e811f1d9734d49e78293e00b3768079	false	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	41	35732	49550138	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	2024-08-22T00:00:18.000Z	0x92e54efae9fa8a543fc3194d222b6478f7f1f8bd9d36db39352ea9ddd52e2e51
0x4cc5f373a49a8f70b74d531c3845c49025d54014	false	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	73	0	49550138	0xaaa2a49958a443dc9d19fddee873b5d1d6e84a2f	2024-08-22T00:00:18.000Z	0x92e54efae9fa8a543fc3194d222b6478f7f1f8bd9d36db39352ea9ddd52e2e51

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pharaoh_v2_avalanche.Pool_CollectProtocol_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
0x0d969f3cd83aafd55e98c0f3a99e29a7b6c2efab	false	0xaaa78e8c4241990b4ce159e105da08129345946a	4294210958675	0xaaa78e8c4241990b4ce159e105da08129345946a	18	249448812	179950780	43364713	-4	-2	2024-03-25T17:59:30.000Z	0x50600422ca1229a866425cc9d4910dbce29f3c667d1b4c59706fea8371d34eaa
0x0d969f3cd83aafd55e98c0f3a99e29a7b6c2efab	false	0xaaa78e8c4241990b4ce159e105da08129345946a	324306648591020	0xaaa78e8c4241990b4ce159e105da08129345946a	15	20004121281	12424913447	43357161	-3	-1	2024-03-25T13:40:38.000Z	0xb17eb3cd4ec9b9bca5ef36a5a2868b65ad808ad1c70400493cf298570a812915
0x1429d6192c0e63f53a2de56f4828cac8d151a08e	false	0xaaa78e8c4241990b4ce159e105da08129345946a	25597616855978956475	0xaaa78e8c4241990b4ce159e105da08129345946a	2	837264072110840478	459812771224990633	43357500	-2600	-1600	2024-03-25T13:52:16.000Z	0x9b42ca23578ca9fd861e60edd3dfce88cc3eaf50f9f42d1bbb8c660f01b791bd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pharaoh_v2_avalanche.Pool_Mint_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
0x0021368b76e7f280accad186ae06039eb1d499b8	-8	false	0xaaae99091fbb28d400029052821653c1c752483b	113	-2316341214	2314825408	55102924	76372658097374	0x000010036c0190e009a000d0fc3541100a07380a	2024-12-30T18:16:16.000Z	79199475304350547044194411713	0x4a77b90bb2347b2567e6b47c43b5d22647d256a329faeeff658782acd89e0501
0x80b405b44775f0b1c065b748d087137ddef13376	-3072	false	0xaaae99091fbb28d400029052821653c1c752483b	73	1155227608	-849617818	55085822	133648253930902	0x000010036c0190e009a000d0fc3541100a07380a	2024-12-30T10:17:07.000Z	67948162451892753049571174225	0x498c0010e263908545cae3971ea4f11d46e0f1a3ba3aa0c574f6535e3ef1ea71
0x80b405b44775f0b1c065b748d087137ddef13376	-3072	false	0xaaae99091fbb28d400029052821653c1c752483b	33	18213569	-13395359	55085803	133648253930902	0x000010036c0190e009a000d0fc3541100a07380a	2024-12-30T10:16:36.000Z	67948666114728847453218000643	0x67185a02a6879093c99de416bd35df82fd69dcad3c52ad67fb1034a096a88978

Example Query

Query with partition filter

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

Voter_GaugeCreated_event

Gauge creation events emitted when new liquidity mining gauges are deployed for liquidity pools in vote-escrowed token (veToken) protocols. Links pool addresses to their corresponding gauge contracts and associated reward distribution mechanisms for governance-driven liquidity incentives.

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_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeDistributor`	`STRING`	Contract address of the fee distributor associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_gauge	log_index	in_creator	block_number	block_timestamp	transaction_hash	in_feeDistributor
0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869	0x9011362efc771dcedd07ec2bd020eb9ff816c40f	false	0xfdd312fd8d77673d9483c1c2e5b1e51843ee9776	8	0x244a4a90e148ec318a85f8c138a274e16ffe3032	40151108	2024-01-09T19:59:57.000Z	0xb723b08818d362ffb72b445af11b1cad1d878d32a3f8542f3c8d800f0b5c6439	0x3e2fcd98acb0d03d2e4d7e935b3f820f8967c83f
0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869	0xdb8fa07481cab965f563b92a507dbc9e75a3d1e3	false	0xad344b69248ea0a5dddc4b1e3166f13d37ba6bef	13	0x40516765ccb13231aa7df0824eb9c605aad19016	55616990	2025-01-10T17:23:38.000Z	0x4e686908ed631fa8fc439458ca797eaaa931447c03df5dfeb2f8ec58ac436df2	0x18af0453062f6f9d868735db221f1436f8da3133
0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869	0x786167128d4c9df6d3b5e74c3d05ec05de3b3805	false	0x95d263b7abc927b7e672caa4e8bcbbecc130b81e	47	0x40516765ccb13231aa7df0824eb9c605aad19016	55616986	2025-01-10T17:23:28.000Z	0xf2e1b69200064cc5b3db8d7fa3ba96eddfb44e88cfb0b97a6f6596079b502cee	0xd6348eafe52bd16fd0920937c74adfdf0edf4ad4

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

FeeCollector_FeesCollected_event

FeeDistributor_ClaimRewards_event

FeeDistributor_NotifyReward_event

FeeDistributor_VotesIncentivized_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Mint_event

Pool_Swap_event

Voter_GaugeCreated_event

​Tables

​Factory_PoolCreated_event

​FeeCollector_FeesCollected_event

​FeeDistributor_ClaimRewards_event

​FeeDistributor_NotifyReward_event

​FeeDistributor_VotesIncentivized_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Mint_event

​Pool_Swap_event

​Voter_GaugeCreated_event

Tables

Factory_PoolCreated_event

FeeCollector_FeesCollected_event

FeeDistributor_ClaimRewards_event

FeeDistributor_NotifyReward_event

FeeDistributor_VotesIncentivized_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Mint_event

Pool_Swap_event

Voter_GaugeCreated_event