> ## Documentation Index > Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # pharaoh_v3_avalanche > Tables in tt-contracts.pharaoh_v3_avalanche ## Tables ### GaugeV3\_Bribe\_event *No description available.* | 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. | *No sample data available.* **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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.* | 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. | *No sample data available.* **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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.* | 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` | - | *No sample data available.* **Query with partition filter** ```sql theme={null} 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. | 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%. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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.* | 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. | *No sample data available.* **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.pharaoh_v3_avalanche.RamsesV3PositionManager_IncreaseLiquidity_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***