pharaoh_v3_avalanche

Tables

GaugeV3_Bribe_event

No description available.

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

No sample data available.

Example Query

Query with partition filter

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

GaugeV3_ClaimRewards_event

Reward claim events from Pharaoh V3 liquidity gauge contracts on Avalanche, capturing token rewards distributed to liquidity providers by period and position. Used for analyzing reward distribution patterns, liquidity mining participation, and gauge incentive effectiveness.

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__positionHash`	`STRING`	Unique identifier hash for the specific liquidity position claiming rewards from the Pharaoh V3 gauge. Hex-encoded, 0x-prefixed 64-character string used to track individual positions across multiple reward claims.
`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_receiver	block_number	block_timestamp	in__positionHash	transaction_hash
0x4543922018006b46fe7dab001669f38d4e22c728	false	441402760327723	2914	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	82	0x0238b9bb23af9221488ac4d8c0bda0e08e9d130d	71849710	2025-11-12T14:26:41.000Z	0xa192b7073c924dd891bf6561371eb74d9164fb07a64eb1c3e4db2797b8b00201	0xbcb018988cd2e2e0c4fd2f2efc9ff4a5f331b77bf2f868fe95655a75ed63afb5
0x4543922018006b46fe7dab001669f38d4e22c728	false	188039184502352175831	2914	0x13a466998ce03db73abc2d4df3bbd845ed1f28e7	87	0x0238b9bb23af9221488ac4d8c0bda0e08e9d130d	71849710	2025-11-12T14:26:41.000Z	0xa192b7073c924dd891bf6561371eb74d9164fb07a64eb1c3e4db2797b8b00201	0xbcb018988cd2e2e0c4fd2f2efc9ff4a5f331b77bf2f868fe95655a75ed63afb5
0x4543922018006b46fe7dab001669f38d4e22c728	false	477708615025522	2914	0xa25eaf2906fa1a3a13edac9b9657108af7b703e3	84	0x0238b9bb23af9221488ac4d8c0bda0e08e9d130d	71849710	2025-11-12T14:26:41.000Z	0xa192b7073c924dd891bf6561371eb74d9164fb07a64eb1c3e4db2797b8b00201	0xbcb018988cd2e2e0c4fd2f2efc9ff4a5f331b77bf2f868fe95655a75ed63afb5

Example Query

Query with partition filter

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

GaugeV3_NotifyReward_event

Reward distribution events from Pharaoh V3 liquidity gauge contracts on Avalanche, capturing token rewards allocated to gauges per emission period. Used for analyzing liquidity mining incentive flows and yield distribution across different 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_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
0x3e2f72d0ce382ae852f45b26d20a52388dc83ced	0x922b9ca8e2207bfb850b6ff647c054d4b58a2aa7	false	3172543714056796180795	2913	0x13a466998ce03db73abc2d4df3bbd845ed1f28e7	191	71113504	2025-10-30T00:02:05.000Z	0x6e6f8504593561969f54bacd2eea80450ef27059ce7019b5ab907ffcd367da9c
0x375c63522920ccc9c61c25c452d8980be7094ce1	0x922b9ca8e2207bfb850b6ff647c054d4b58a2aa7	false	26335271281329651208385	2913	0x13a466998ce03db73abc2d4df3bbd845ed1f28e7	224	71113504	2025-10-30T00:02:05.000Z	0x6e6f8504593561969f54bacd2eea80450ef27059ce7019b5ab907ffcd367da9c
0x7e2f9dea844aae6ce2b619cffca456cbedf69a61	0x922b9ca8e2207bfb850b6ff647c054d4b58a2aa7	false	1299406694641923384709786	2913	0x13a466998ce03db73abc2d4df3bbd845ed1f28e7	59	71113504	2025-10-30T00:02:05.000Z	0x6e6f8504593561969f54bacd2eea80450ef27059ce7019b5ab907ffcd367da9c

Example Query

Query with partition filter

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

GaugeV3_RewardAdded_event

Reward token addition events from Pharaoh V3 liquidity gauge contracts on Avalanche. Used to track when new reward tokens are configured for distribution to liquidity providers in specific gauge 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x1578aa55bf46389cb43cc15aec81bfc6a3aae2d5	false	0x13a466998ce03db73abc2d4df3bbd845ed1f28e7	4	71430230	2025-11-05T00:03:00.000Z	0x9fd4f266acfcd2846d19cf6bb49fdbb90983c92c7f4cd3ea0aaea08fd4a053c6
0x1578aa55bf46389cb43cc15aec81bfc6a3aae2d5	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	1	71430230	2025-11-05T00:03:00.000Z	0x9fd4f266acfcd2846d19cf6bb49fdbb90983c92c7f4cd3ea0aaea08fd4a053c6
0x1578aa55bf46389cb43cc15aec81bfc6a3aae2d5	false	0xe7c3d8c9a439fede00d2600032d5db0be71c3c29	2	71430230	2025-11-05T00:03:00.000Z	0x9fd4f266acfcd2846d19cf6bb49fdbb90983c92c7f4cd3ea0aaea08fd4a053c6

Example Query

Query with partition filter

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

GaugeV3_RewardRemoved_event

No description available.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

GaugeV3Factory_FeeCollectorChanged_event

Events emitted when Pharaoh V3’s gauge factory updates its fee collector address on Avalanche. Tracks changes in the protocol’s fee collection mechanism with old and new collector addresses for monitoring protocol governance and revenue routing updates.

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_newFeeCollector`	`STRING`	Address of the new fee collector contract after a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldFeeCollector`	`STRING`	Address of the previous fee collector contract before a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFeeCollector	in_oldFeeCollector
0xe565310baa582c768a77a3bb7f86a892ef07d04e	false	97	70003673	2025-10-09T02:42:17.000Z	0x2e6ff7bbca43d62e4ec1c21298a41b67acb5b2ec7106293f081205315d1bb2a9	0x1e1e2a861205767d69a51edf03cf5e3a278437bc	0x088e2efad10f3262e745c6c01f661112f353bb64

Example Query

Query with partition filter

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

GaugeV3Factory_GaugeCreated_event

Gauge deployment events from Pharaoh V3 DEX (decentralized exchange) on Avalanche, recording when new liquidity mining gauges are created for pools. Links gauge contracts to their associated liquidity pools for tracking incentive distribution programs.

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

Sample Data

address	in_pool	removed	in_gauge	log_index	block_number	block_timestamp	transaction_hash
0xe565310baa582c768a77a3bb7f86a892ef07d04e	0x84722fa6f0caf7e8b9d681c9d604cd2a8154faca	false	0xf793f6e7bce74e58f05f161a0db8931ea581ed91	6	70676812	2025-10-21T14:04:30.000Z	0x69a80455cfd3d89d41dbb2e460aa72f92b6d1a1bf406805b3436fc71cccc811a
0xe565310baa582c768a77a3bb7f86a892ef07d04e	0x9bfe3108cc16d17a9ec65545a0f50b2ca1c970c0	false	0xf51b4eb0f6801729170d18bee67c7f5d98985572	103	70001765	2025-10-09T01:49:54.000Z	0xcabb0347a9ae695efa36df792f481d0017cf1d1a35dd07a3a3db07781e93c9f7
0xe565310baa582c768a77a3bb7f86a892ef07d04e	0x5ca009013f6b898d134b6798b336a4592f3b4af2	false	0x7e2f9dea844aae6ce2b619cffca456cbedf69a61	29	70005198	2025-10-09T03:22:05.000Z	0x82bb2b1c996661dcff3abb58ea8b4e4efeb4cdb393d4e5366717fead69e7010c

Example Query

Query with partition filter

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

GaugeV3Factory_VoterChanged_event

No description available.

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_newVoter`	`STRING`	-
`in_oldVoter`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

RamsesV3Factory_FeeAdjustment_event

Fee adjustment events from the Ramses V3 factory contract on Avalanche, recording dynamic fee tier changes for individual liquidity pools. Used to track fee optimization strategies and pool parameter governance over time.

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_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	in_pool	removed	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0xae6e5c62328ade73ceefd42228528b70c8157d0d	0xf01449c0ba930b6e2caca3def3ccbd7a3e589534	false	380	138	70965141	2025-10-27T04:07:08.000Z	0x0036bc492a034aec22f3bffebc734e161171f7b0209f8ee2fc837405c2a4ba12
0xae6e5c62328ade73ceefd42228528b70c8157d0d	0x5ca009013f6b898d134b6798b336a4592f3b4af2	false	400	142	70965141	2025-10-27T04:07:08.000Z	0x0036bc492a034aec22f3bffebc734e161171f7b0209f8ee2fc837405c2a4ba12
0xae6e5c62328ade73ceefd42228528b70c8157d0d	0xff0855a9027f5f5c2bbacc4aac477afbeeefbea9	false	700	140	70965141	2025-10-27T04:07:08.000Z	0x0036bc492a034aec22f3bffebc734e161171f7b0209f8ee2fc837405c2a4ba12

Example Query

Query with partition filter

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

RamsesV3Factory_FeeCollectorChanged_event

Event log capturing fee collector address updates in the Ramses V3 (Pharaoh V3 fork) automated market maker factory contract on Avalanche. Tracks transitions between old and new fee collector addresses for protocol revenue routing 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_oldFeeCollector`	`STRING`	Address of the previous fee collector contract before a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.
`in_newFeeCollector`	`STRING`	Address of the new fee collector contract after a fee collector update. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFeeCollector	in_oldFeeCollector
0xae6e5c62328ade73ceefd42228528b70c8157d0d	false	107	70003667	2025-10-09T02:42:05.000Z	0x29994dc19f22ca872247b2250cfc5237e36508ec859a8a3c909c57ae26ae7707	0x1e1e2a861205767d69a51edf03cf5e3a278437bc	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

RamsesV3Factory_PoolCreated_event

Pool creation events from the Pharaoh V3 (Ramses V3 fork) automated market maker factory contract on Avalanche. Records new liquidity pool deployments with token pairs, fee tiers (basis points), and tick spacing parameters for tracking DEX ecosystem growth.

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
250	0xae6e5c62328ade73ceefd42228528b70c8157d0d	0x6f63efb36e4d30bca6f8bfddf3da8240d8c9ce00	false	0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	45	71471576	5	2025-11-05T17:52:12.000Z	0x005388f4b597a6356e0b4937f7165ce483c0ea56e8ffcc523ae8cd6f59e72cba
10000	0xae6e5c62328ade73ceefd42228528b70c8157d0d	0xf19b004eaf49eceb708ded3b51aa37a26b94fb88	false	0x1166a40e35968f07bcb1d6587c8654aba9742d04	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	51	71444376	100	2025-11-05T06:04:56.000Z	0x0ff50f3393df0e4f853718badbc147e0be51b5092e535f3a7b346755264705a3
10000	0xae6e5c62328ade73ceefd42228528b70c8157d0d	0x29f609c195565d50f3c6d2520498ebce10a7f1e4	false	0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	55	71471420	100	2025-11-05T17:48:06.000Z	0x18197b370442e8ab9e5cc6e99d39b1927238c714404578f3029a8637759a0744

Example Query

Query with partition filter

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

RamsesV3Factory_SetFeeProtocol_event

Protocol fee configuration changes from the Ramses V3 (Uniswap V3 fork) factory contract on Avalanche. Tracks when protocol fee percentages are updated, useful for analyzing fee structure evolution and protocol revenue mechanisms.

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_feeProtocolOld`	`STRING`	Previous protocol fee configuration value before the update. Integer representing the fee percentage allocated to the protocol from trading fees.
`in_feeProtocolNew`	`STRING`	Updated protocol fee configuration value being set. Integer representing the fee percentage allocated to the protocol from trading fees.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeProtocolNew	in_feeProtocolOld
0xae6e5c62328ade73ceefd42228528b70c8157d0d	false	74	68700645	2025-09-13T23:10:11.000Z	0x35edb981381efb5df0dcfe197800ceba3c2b7d5e62ad62e87c1059a8b7904fe0	50000	0

Example Query

Query with partition filter

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

RamsesV3Factory_SetPoolFeeProtocol_event

Protocol fee configuration changes for Ramses V3 liquidity pools on Avalanche, tracking adjustments to the fee portion allocated to the protocol versus liquidity providers. Useful for analyzing fee tier governance decisions and protocol revenue optimization across different pool addresses.

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_feeProtocolOld`	`STRING`	Previous protocol fee configuration value before the update. Integer representing the fee percentage allocated to the protocol from trading fees.
`in_feeProtocolNew`	`STRING`	Updated protocol fee configuration value being set. Integer representing the fee percentage allocated to the protocol from trading fees.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeProtocolNew	in_feeProtocolOld
0xae6e5c62328ade73ceefd42228528b70c8157d0d	0xf01449c0ba930b6e2caca3def3ccbd7a3e589534	false	178	70005769	2025-10-09T03:37:41.000Z	0x398ea77f7c500b2252501ce5d0c169b3ed87756fb40492be7e999ac384166fde	1000000	50000
0xae6e5c62328ade73ceefd42228528b70c8157d0d	0x9bfe3108cc16d17a9ec65545a0f50b2ca1c970c0	false	180	70005769	2025-10-09T03:37:41.000Z	0x398ea77f7c500b2252501ce5d0c169b3ed87756fb40492be7e999ac384166fde	1000000	50000
0xae6e5c62328ade73ceefd42228528b70c8157d0d	0xff0855a9027f5f5c2bbacc4aac477afbeeefbea9	false	174	70005769	2025-10-09T03:37:41.000Z	0x398ea77f7c500b2252501ce5d0c169b3ed87756fb40492be7e999ac384166fde	1000000	50000

Example Query

Query with partition filter

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

RamsesV3Factory_TickSpacingEnabled_event

Factory configuration events from Pharaoh V3 DEX on Avalanche recording enabled tick spacing and fee tier combinations for liquidity pools. Used to track available pool configurations and protocol governance changes to fee structures.

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_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`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.

Sample Data

in_fee	address	removed	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
500	0xae6e5c62328ade73ceefd42228528b70c8157d0d	false	70	68700645	10	2025-09-13T23:10:11.000Z	0x35edb981381efb5df0dcfe197800ceba3c2b7d5e62ad62e87c1059a8b7904fe0
10000	0xae6e5c62328ade73ceefd42228528b70c8157d0d	false	72	68700645	100	2025-09-13T23:10:11.000Z	0x35edb981381efb5df0dcfe197800ceba3c2b7d5e62ad62e87c1059a8b7904fe0
250	0xae6e5c62328ade73ceefd42228528b70c8157d0d	false	69	68700645	5	2025-09-13T23:10:11.000Z	0x35edb981381efb5df0dcfe197800ceba3c2b7d5e62ad62e87c1059a8b7904fe0

Example Query

Query with partition filter

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

RamsesV3Pool_Burn_event

Liquidity removal events from Ramses V3 concentrated liquidity pools on Avalanche, recording burned position amounts with tick ranges and token quantities. Used for tracking liquidity provider withdrawals and position management across concentrated AMM (Automated Market Maker) price 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_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
0xf01449c0ba930b6e2caca3def3ccbd7a3e589534	false	0x0b4478e810d48b5882d4019d435a2f864bab4f39	16268296764336087	96	12620924315182548231	1629446836	70295134	-245580	-245080	2025-10-14T09:59:49.000Z	0x4d87a7443d57c9da5fd962da2c4d9cf86aa1de09ff8f5fa27bd54505df3e1758
0xf01449c0ba930b6e2caca3def3ccbd7a3e589534	false	0x0b4478e810d48b5882d4019d435a2f864bab4f39	808484516825121	249	3224402977547520374	100123132	70310075	-245560	-244650	2025-10-14T16:19:10.000Z	0x36afb9b8aa632d047f29a06a48f3b813afb52d01a8f75ac44af6a60defbcba34
0xf01449c0ba930b6e2caca3def3ccbd7a3e589534	false	0x0b4478e810d48b5882d4019d435a2f864bab4f39	26514875729128919	0	105743851928229723987	753984060	70290585	-245480	-244980	2025-10-14T08:02:34.000Z	0xf0240f69a85c4b9f485011f5266a7a55b111467f2812fd5ef80522427145e535

Example Query

Query with partition filter

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

RamsesV3Pool_Collect_event

Fee collection events from Ramses V3 liquidity pools on Avalanche, recording token amounts withdrawn by position owners with tick range boundaries. Used for analyzing liquidity provider earnings 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
0xc9bfc3cda285a75b32d5b787618128db963de675	false	0x0b4478e810d48b5882d4019d435a2f864bab4f39	12	189566888411303738744	418683756	72270060	0x70f3b86dec3911d5ab43b31d05b5f61f9233fd2f	-276342	-276324	2025-11-20T08:14:38.000Z	0x3db5f012ef31cbc7035dcd8125cad67f95ee66b8f0d87e7d9e39c84251d2cb09
0xc9bfc3cda285a75b32d5b787618128db963de675	false	0x0b4478e810d48b5882d4019d435a2f864bab4f39	173	8570538393859149777	8523684	72256864	0x18a2fd914ce6f826dfad2fdf2e3b00658ce16046	-276334	-276324	2025-11-20T01:37:33.000Z	0xec37d9be07620d27dd76c8bc0b1e302e636bbdc88ecc253f8cc136b2ee014125
0xc9bfc3cda285a75b32d5b787618128db963de675	false	0x0b4478e810d48b5882d4019d435a2f864bab4f39	54	858001348637890012659	851421437	72256823	0x18a2fd914ce6f826dfad2fdf2e3b00658ce16046	-276334	-276324	2025-11-20T01:36:08.000Z	0x03b5a7923e53673a2ce33a9b388c3eed3d8087c8d6f855405433eac8eed42f8e

Example Query

Query with partition filter

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

RamsesV3Pool_Flash_event

Flash loan events from Ramses V3 liquidity pools on Avalanche, recording borrowed amounts (amount0/amount1) and corresponding fees paid (paid0/paid1) by sender addresses. Used for analyzing flash loan arbitrage activity and MEV strategies across DEX 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_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_paid0	in_paid1	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x9bfe3108cc16d17a9ec65545a0f50b2ca1c970c0	false	0	5008	0x29c06a1e864dfe8d8db2747edbc635aa3b59ce51	39	0	100157841	72132426	0x29c06a1e864dfe8d8db2747edbc635aa3b59ce51	2025-11-17T21:02:10.000Z	0xc89e9be9607de1cf5a4c532e5d140a4c81a00f6031689fd1d8124f1f006335c5
0xff0855a9027f5f5c2bbacc4aac477afbeeefbea9	false	11036828231644	0	0x083cfa7fd187be983ce5d519fe7ae78357779998	61	29044284820113871	0	71056857	0x083cfa7fd187be983ce5d519fe7ae78357779998	2025-10-28T21:38:54.000Z	0x941fc62fc6fca210248037ee64ff8c3b84692ac92b6e3d88b9f3d326e092d431
0x9bfe3108cc16d17a9ec65545a0f50b2ca1c970c0	false	0	5942	0x29c06a1e864dfe8d8db2747edbc635aa3b59ce51	61	0	132027824	72245071	0x29c06a1e864dfe8d8db2747edbc635aa3b59ce51	2025-11-19T18:37:47.000Z	0xb417083e74c6c0a656ac87e684d1c65e50fecb6151e4a185f28fdfae4e6a3b6a

Example Query

Query with partition filter

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

RamsesV3Pool_Mint_event

Liquidity provision events from Ramses V3 automated market maker (AMM) pools on Avalanche, capturing mints with tick ranges, token amounts, and liquidity values. Used for analyzing liquidity provider behavior, position sizing, and concentrated liquidity distribution across price 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_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_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`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_index	in_owner	in_amount	in_sender	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x4aa6967ce6b2996feb42fa480c9dfaf80b7a5640	false	101	0x0b4478e810d48b5882d4019d435a2f864bab4f39	1364642643872706364702	0x0b4478e810d48b5882d4019d435a2f864bab4f39	3	15000000000000000000	168035339011376675581	69731385	22850	24350	2025-10-04T01:33:01.000Z	0x9407373a100ad1c8db4953470cf7930efcb819cb29995342024f730675a362dd
0x9d92496076a4067ff5497430cd16dca0a0c9a454	false	79	0x0b4478e810d48b5882d4019d435a2f864bab4f39	56324051419415443508	0x0b4478e810d48b5882d4019d435a2f864bab4f39	3	4191984365232112725	961715155665488262	69777752	-10300	-8800	2025-10-04T22:47:02.000Z	0xc8e73ad14ea678308f45cfd0dab2fe4b25500c5b306c403aee56497d32682d9a
0x4aa6967ce6b2996feb42fa480c9dfaf80b7a5640	false	102	0x0b4478e810d48b5882d4019d435a2f864bab4f39	606665550418328282976	0x0b4478e810d48b5882d4019d435a2f864bab4f39	17	2270856770496309564	24999999999999999990	69731503	23400	23900	2025-10-04T01:35:44.000Z	0x1a6a67bf870a10338818eb9d06e6085687c37a1010ce02a16a88371f565963c5

Example Query

Query with partition filter

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

RamsesV3Pool_SetFeeProtocol_event

No description available.

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.pharaoh_v3_avalanche.RamsesV3Pool_SetFeeProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RamsesV3Pool_Swap_event

Swap event records from Ramses V3 liquidity pools (Uniswap V3 fork) on Avalanche, capturing token exchanges with amounts, price ticks, and sqrt price ratios. Used for analyzing DEX trading volume, price movements, and liquidity utilization across concentrated 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_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
0x55ade233d9cca8cf1bd7d310fa8400223d879de7	-348748	false	0x5acc35397d2ce81ac54a4b1c6d9e1fb29f8ec6c6	35	-33334632049405522887321	23872995	70677397	6927391735452755669	0xb37a69c4f4eb82af5ccba06ae2bd9fafb8940077	2025-10-21T14:18:56.000Z	2119847187337225247688	0x7b9372c74f8c582ac822c978cddc6115468309d2dacb962c66a7c59e3d88768e
0xac8b3e6d6109a2b67f7170432fc41140adfab556	-276380	false	0xaddb698a6723787624f3286369e588de7d780927	57	-616761339751689313	613626	70652487	91944631133214020156	0xaddb698a6723787624f3286369e588de7d780927	2025-10-21T03:41:49.000Z	79006754715306985695320	0x2f3f14bdcc898bd9464b25cb60fc9beb842eb6af999577e714134bd16a434b0a
0xac8b3e6d6109a2b67f7170432fc41140adfab556	-276380	false	0xaddb698a6723787624f3286369e588de7d780927	39	-565907228975023868	563031	70690095	154971783597283338331	0xaddb698a6723787624f3286369e588de7d780927	2025-10-21T19:35:21.000Z	79006774104779753564558	0x41a97fe01298f8be7ff4173708431bf78b7feb3626826779c173c871272dc5a9

Example Query

Query with partition filter

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

RamsesV3PositionManager_Collect_event

Fee collection events from Ramses V3 concentrated liquidity positions on Avalanche. Records token amounts claimed by liquidity providers from their NFT positions, useful for analyzing yield generation and position profitability.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`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	log_index	in_amount0	in_amount1	in_tokenId	block_number	in_recipient	block_timestamp	transaction_hash
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	132	19867622153387820841	264971232	41069	71799782	0x0238b9bb23af9221488ac4d8c0bda0e08e9d130d	2025-11-11T16:14:31.000Z	0xc5db7b688ced7705da5858a6a6f4300e8f4ebe81537f2711bd3df5592036752b
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	25	34315295433864760070	12809420	41069	71808717	0x0238b9bb23af9221488ac4d8c0bda0e08e9d130d	2025-11-11T20:02:11.000Z	0x9bb6b0223fa1bad0daf49fb40de58719ebbe0124e9548da991f30937dc7153d5
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	54	687274585234268191563	8692145431	40591	71791505	0x051fa7b9071a0a202407566d2b1d765235bbcca9	2025-11-11T12:48:36.000Z	0x5f9db97c760d25019a52abd14edd5504b8fc471f560a77f8102498b23d6a380b

Example Query

Query with partition filter

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

RamsesV3PositionManager_DecreaseLiquidity_event

Liquidity removal events from Ramses V3 concentrated liquidity positions on Avalanche, capturing withdrawn token amounts and liquidity changes by position ID. Used for tracking liquidity provider exits 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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity 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	log_index	in_amount0	in_amount1	in_tokenId	block_number	in_liquidity	block_timestamp	transaction_hash
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	1	11226895322206229	999999999999999924	12785	70748448	1827258777028473752	2025-10-22T21:06:28.000Z	0x48f5973b8607113d58eccce82f628d53c820f64acd611176a2a459c98f5cd297
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	1	0	1317177650	12809	70748866	152554367730728699	2025-10-22T21:18:03.000Z	0x25f690acf9769bffbe6ec597a06d0e0552abbf6638f280e358e73dae5c31ce7a
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	1	0	119066056252126386	12004	70716270	4498301804740216	2025-10-22T07:08:36.000Z	0x782fc4b8fdc4f559758e41e4b8c7f481ec613ac5699a2e58abe4131287c269f6

Example Query

Query with partition filter

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

RamsesV3PositionManager_IncreaseLiquidity_event

Liquidity addition events from Ramses V3 concentrated liquidity positions on Avalanche, recording the amounts of both tokens and liquidity units added to specific NFT position IDs. Used for tracking LP strategy changes and capital deployment patterns in V3 AMM 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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity 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	log_index	in_amount0	in_amount1	in_tokenId	block_number	in_liquidity	block_timestamp	transaction_hash
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	102	47827322561502614000	14936872	13	69101231	3739542280178760	2025-09-22T05:57:35.000Z	0x2c7f975d56ccea75c373957b8dd98a9f29c69699d70a0901ea02632f6afdb6a3
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	183	20233806186040078020	101309241	13	69124197	1814618858194384	2025-09-22T16:44:45.000Z	0x015c09e8e28175154b7938fa90a1207d6c7c3ad160df3b1923515f41d0518dab
0x0b4478e810d48b5882d4019d435a2f864bab4f39	false	103	23299	16111797872888598	18	69101220	588078107948	2025-09-22T05:57:19.000Z	0x203fcb15db030802eaa30f95223be38b42798444e0c801cce2b35f205756c145

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

GaugeV3_Bribe_event

GaugeV3_ClaimRewards_event

GaugeV3_NotifyReward_event

GaugeV3_RewardAdded_event

GaugeV3_RewardRemoved_event

GaugeV3Factory_FeeCollectorChanged_event

GaugeV3Factory_GaugeCreated_event

GaugeV3Factory_VoterChanged_event

RamsesV3Factory_FeeAdjustment_event

RamsesV3Factory_FeeCollectorChanged_event

RamsesV3Factory_PoolCreated_event

RamsesV3Factory_SetFeeProtocol_event

RamsesV3Factory_SetPoolFeeProtocol_event

RamsesV3Factory_TickSpacingEnabled_event

RamsesV3Pool_Burn_event

RamsesV3Pool_Collect_event

RamsesV3Pool_Flash_event

RamsesV3Pool_Mint_event

RamsesV3Pool_SetFeeProtocol_event

RamsesV3Pool_Swap_event

RamsesV3PositionManager_Collect_event

RamsesV3PositionManager_DecreaseLiquidity_event

RamsesV3PositionManager_IncreaseLiquidity_event

​Tables

​GaugeV3_Bribe_event

​GaugeV3_ClaimRewards_event

​GaugeV3_NotifyReward_event

​GaugeV3_RewardAdded_event

​GaugeV3_RewardRemoved_event

​GaugeV3Factory_FeeCollectorChanged_event

​GaugeV3Factory_GaugeCreated_event

​GaugeV3Factory_VoterChanged_event

​RamsesV3Factory_FeeAdjustment_event

​RamsesV3Factory_FeeCollectorChanged_event

​RamsesV3Factory_PoolCreated_event

​RamsesV3Factory_SetFeeProtocol_event

​RamsesV3Factory_SetPoolFeeProtocol_event

​RamsesV3Factory_TickSpacingEnabled_event

​RamsesV3Pool_Burn_event

​RamsesV3Pool_Collect_event

​RamsesV3Pool_Flash_event

​RamsesV3Pool_Mint_event

​RamsesV3Pool_SetFeeProtocol_event

​RamsesV3Pool_Swap_event

​RamsesV3PositionManager_Collect_event

​RamsesV3PositionManager_DecreaseLiquidity_event

​RamsesV3PositionManager_IncreaseLiquidity_event

Tables

GaugeV3_Bribe_event

GaugeV3_ClaimRewards_event

GaugeV3_NotifyReward_event

GaugeV3_RewardAdded_event

GaugeV3_RewardRemoved_event

GaugeV3Factory_FeeCollectorChanged_event

GaugeV3Factory_GaugeCreated_event

GaugeV3Factory_VoterChanged_event

RamsesV3Factory_FeeAdjustment_event

RamsesV3Factory_FeeCollectorChanged_event

RamsesV3Factory_PoolCreated_event

RamsesV3Factory_SetFeeProtocol_event

RamsesV3Factory_SetPoolFeeProtocol_event

RamsesV3Factory_TickSpacingEnabled_event

RamsesV3Pool_Burn_event

RamsesV3Pool_Collect_event

RamsesV3Pool_Flash_event

RamsesV3Pool_Mint_event

RamsesV3Pool_SetFeeProtocol_event

RamsesV3Pool_Swap_event

RamsesV3PositionManager_Collect_event

RamsesV3PositionManager_DecreaseLiquidity_event

RamsesV3PositionManager_IncreaseLiquidity_event