pharaoh_v1_avalanche

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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_stable`	`BOOL`	Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon4`	`STRING`	Sequential identifier for the liquidity pool pair created by the factory contract. String-encoded integer value.

Sample Data

address	in_pair	removed	in_anon4	in_stable	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0xaaa16c016bf556fcd620328f0759252e29b1ab57	0xe007690d573855b313631a5e545c853a640aee2f	false	141	false	0x4d9f0c88bc5751ada9cd34822291b096dc4c0eec	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	22	55847051	2025-01-15T16:23:23.000Z	0xafa6a39248fe0ec646eaf2a40e407810d39382a7a24b6bfcd3e21bf18d8798f1
0xaaa16c016bf556fcd620328f0759252e29b1ab57	0x119b5e40316bc6a036aec906528bec5cdb0277ce	false	143	false	0x20ed2a29e3d91f6760a64771b2a6b7d7e2f99ef3	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	22	55847066	2025-01-15T16:23:53.000Z	0xf687a67dc0ef8acbc0a391cee9d3ce8bcffdbbdca30961917ff26e6f782effe0
0xaaa16c016bf556fcd620328f0759252e29b1ab57	0x9ba58b4f09f92bdb842fc451988455f30a541b37	false	139	false	0x0cb3a98cea8f11c0fce121c40c64029127e12aad	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	10	55819825	2025-01-15T02:40:59.000Z	0xb7090da59d331e3baa4964b3b99f2a4175f564a7a07aa57aa8ec74fb1d2c3261

Example Query

Query with partition filter

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

LegacyPair_Burn_event

Liquidity removal events from Pharaoh V1 DEX (decentralized exchange) legacy liquidity pairs on Avalanche, recording withdrawn token amounts when LP (liquidity provider) tokens are burned. Used for tracking liquidity exits, analyzing pool depth changes, and calculating LP position returns.

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_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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xaaa45c8f5ef92a000a121d102f4e89278a711faa	0x73f7212838692e560f5b26fdb05cf0aa6cf56f33	false	0xaaa45c8f5ef92a000a121d102f4e89278a711faa	44	10552373828575288634114	336839067171743176	47449840	2024-07-02T07:29:31.000Z	0x86c624c108d44b7c275ac7521a603c11f5637309c4c45b0b3f1870fbd6a83bb6
0xaaa45c8f5ef92a000a121d102f4e89278a711faa	0xaaa3f202babcf7d6493afbc0caee03af9c64f984	false	0xaaa45c8f5ef92a000a121d102f4e89278a711faa	13	102284000338962022008	107803986359799692528	47446315	2024-07-02T05:28:44.000Z	0x3e8f1d4379c1d71ef446630f13be2617ba2099320f23455f51e40f3bc371c8ba
0xaaa45c8f5ef92a000a121d102f4e89278a711faa	0x0d795266ce435a33eb7c700d9439a143087c25f6	false	0xaaa45c8f5ef92a000a121d102f4e89278a711faa	9	1603109666956317925	4406249022151513168	47458449	2024-07-02T12:22:45.000Z	0xf28d24b66751decc4701d7d256d9f1c36be2980c5474ac7d0740a73e523fcf46

Example Query

Query with partition filter

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

LegacyPair_Claim_event

Liquidity provider fee claim events from Pharaoh V1 DEX (decentralized exchange) legacy pairs on Avalanche, recording token0 and token1 amounts withdrawn by LPs from trading fee accumulation. Used for tracking yield generation and liquidity provider earnings across trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x0e13283315fd3d996b22ef40f54c38f24c7f4ee0	false	0xdf4332f5792d60f5c8666d80062e391c337e3d3a	22	2521902107905745539696	26140195391858476	56259331	0xdf4332f5792d60f5c8666d80062e391c337e3d3a	2025-01-23T22:32:00.000Z	0x6e0b7d8510aa7b002686319b05368642a4b7aa9c615d94af75d2a74864a19d9f
0xaaa3f202babcf7d6493afbc0caee03af9c64f984	false	0x52edc4da8423266d81f5cda947f2d1b438d479a1	16	403957626382705829	291914082913197189	56220473	0x52edc4da8423266d81f5cda947f2d1b438d479a1	2025-01-23T03:39:12.000Z	0x92a0155e9ea4957acaf585a501af636493707991c274fd4fbeb4e9523bd68fba
0xaaa3f202babcf7d6493afbc0caee03af9c64f984	false	0x52edc4da8423266d81f5cda947f2d1b438d479a1	7	0	0	56220478	0x52edc4da8423266d81f5cda947f2d1b438d479a1	2025-01-23T03:39:24.000Z	0x9609725fb13b8336234db7b67b55528052270714f95c6214ea6f0bf297a6356f

Example Query

Query with partition filter

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

LegacyPair_Fees_event

Fee collection events from Pharaoh V1 legacy liquidity pairs on Avalanche, recording token amounts collected from trading activity. Used for analyzing fee generation, liquidity provider earnings, and pair-level revenue metrics.

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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	block_number	block_timestamp	transaction_hash
0xc909d2f98de0a2ef734a792192db302ca51b4606	false	0x0f4a1d7fdf4890be35e71f3e0bbc4a0ec377eca3	4	3450000000000000	51370463	2024-10-04T22:25:39.000Z	0x0dc09f1a41856fdbd8f15d723cc7e6c895237f66c70eb6d77ce3770d4eee291d
0xc909d2f98de0a2ef734a792192db302ca51b4606	false	0x0f4a1d7fdf4890be35e71f3e0bbc4a0ec377eca3	4	5000000000000000	51370947	2024-10-04T22:42:22.000Z	0x37475910bc0b0475bd2d5486634bf4408e66e457b9648de42bdb0824ea8413f8
0xc909d2f98de0a2ef734a792192db302ca51b4606	false	0x22c81c051a134c81ce370d82fa26975ae9d100b4	3	7295592919662229914062	51371033	2024-10-04T22:45:18.000Z	0xfd7b9f4faea0dbd4f038301e4423f5545b78f823b712425d172b63a910e81d86

Example Query

Query with partition filter

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

LegacyPair_Mint_event

Liquidity provision events from Pharaoh V1 decentralized exchange (DEX) pairs on Avalanche, recording token amounts deposited by liquidity providers. Used for analyzing liquidity depth, provider behavior, and pool composition across trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x0e13283315fd3d996b22ef40f54c38f24c7f4ee0	false	0xaaa45c8f5ef92a000a121d102f4e89278a711faa	5	1101737511988402093906826	999999999999999852	46268225	2024-06-03T22:12:03.000Z	0x9211b72fcddd0ab5061db673d9e123ff3378f1bea9b3108813b1aeaf1d715455
0x40557c1788ed15d8fdcebd61275b877079543058	false	0xaaa45c8f5ef92a000a121d102f4e89278a711faa	5	4874823769668117728	276064791215798217784789	46247157	2024-06-03T09:54:53.000Z	0xe4a2fa88623652c035c997a990c860e56b55f0f2bbd4e73f4486a0d3f325f59b
0x40557c1788ed15d8fdcebd61275b877079543058	false	0xaaa45c8f5ef92a000a121d102f4e89278a711faa	5	1916483160975643851	110000000000000000000000	46264008	2024-06-03T19:41:45.000Z	0x19af9fbbbab9dd058f40da8691124e3989a3e2f44e55324ab2b8c3db85e73064

Example Query

Query with partition filter

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

LegacyPair_Swap_event

Swap execution events from Pharaoh V1 liquidity pairs on Avalanche, capturing token amounts in/out, sender, and recipient addresses for each trade. Used for analyzing DEX trading volumes, price impacts, and liquidity pool 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x03a5888726667fff1e753fc06b51dd1245e7371a	0xaaa3f202babcf7d6493afbc0caee03af9c64f984	false	0xfe81c675c06f8dd40d0d345505dc4592ccfa89c0	15	51148287	763791801642774169	1135699775482274834	2024-09-29T14:47:07.000Z	0xeb341a78518ae1216b2d6ebb4024f473d4f9aa3705f954d31e7f3b646e0a8d96
0x08776916ec60d4487c5495544927dde4b1012e17	0xaaa3f202babcf7d6493afbc0caee03af9c64f984	false	0x22c81c051a134c81ce370d82fa26975ae9d100b4	13	51124012	6897348977443401665	10246188234871866483	2024-09-29T00:37:44.000Z	0x52069878e3b80fb063901bf8ead7230c1d7b7ba7722871ac0a332ac203fca8cc
0x09661d79b7541ecff7bd6a73fba0c7cefeb3d739	0x73f7212838692e560f5b26fdb05cf0aa6cf56f33	false	0x09661d79b7541ecff7bd6a73fba0c7cefeb3d739	11	51155332	186650559402508443256910	1576471428985077347	2024-09-29T18:48:51.000Z	0xd2f03de1f5765e8955e695300fc5c271b9116b647613b8f9c3dfc3da8782cdcc

Example Query

Query with partition filter

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

LegacyPair_Sync_event

Reserve balance synchronization events from Pharaoh V1 decentralized exchange (DEX) liquidity pairs on Avalanche. Used to track liquidity pool state changes and calculate time-weighted average prices (TWAPs) for trading pair analytics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x0d795266ce435a33eb7c700d9439a143087c25f6	false	8	267469741871242892460	431164866003549254186	44498978	2024-04-21T22:23:18.000Z	0x368337965802b5598b9f9596d515b910bfc961149cc1e47cc5450eecf7426b85
0x0d795266ce435a33eb7c700d9439a143087c25f6	false	8	265176654587236996874	426762816661234718463	44481664	2024-04-21T12:20:02.000Z	0xcb72ee1a7a10ed9ad7a2d338accad13307bae06286168be01a59508e3f008a64
0x0d795266ce435a33eb7c700d9439a143087c25f6	false	8	265311589333742275670	424695696504890603113	44467572	2024-04-21T04:07:49.000Z	0xa55eec4124272baec96bae0c20cb54515e9a835ac7d61f1dff3119d0570bb836

Example Query

Query with partition filter

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

LegacyPair_Transfer_event

Liquidity pool (LP) token transfer events from Pharaoh V1 DEX on Avalanche, tracking mints, burns, and transfers of pool shares between addresses. Used to analyze liquidity provider positions, pool entry/exit activity, and LP token flows.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. 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

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xad53e74895c32120924502d8b650e2220926ca7b	0x0d795266ce435a33eb7c700d9439a143087c25f6	0x115ec2061d165e19e4b6070f34731104d3489ebd	false	15131228191359877117	25	52566058	2024-11-02T14:17:02.000Z	0xd5c864503d2e04f5c039315e1ba1da6c05e5421afd731a6723b383a1953501b4
0xad53e74895c32120924502d8b650e2220926ca7b	0x0d795266ce435a33eb7c700d9439a143087c25f6	0x115ec2061d165e19e4b6070f34731104d3489ebd	false	15131228191359877117	14	52566052	2024-11-02T14:16:50.000Z	0xe3617bcb1bd9dd041684a8876afcf62ab7aa0e2c648f8ce150f78165638e91d4
0xad53e74895c32120924502d8b650e2220926ca7b	0x0d795266ce435a33eb7c700d9439a143087c25f6	0x0000000000000000000000000000000000000000	false	15621572738252421457	26	52566101	2024-11-02T14:18:27.000Z	0x93018db4605b02f041357ca04b049918392844ed619b515a4a0476c175a9a535

Example Query

Query with partition filter

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

Minter_Mint_event

Token minting events from Pharaoh V1 protocol on Avalanche, tracking growth and weekly emission amounts distributed to sender addresses. Useful for analyzing protocol token distribution patterns and emission schedules 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_weekly`	`STRING`	Token amount minted for the weekly emissions period in the Pharaoh protocol. Denominated in the smallest token unit (wei), typically around 4x the growth allocation amount based on sample values.
`in_growth`	`STRING`	Amount of growth tokens minted to the recipient in this emission event, denominated in the smallest token unit (wei). This value represents approximately 25% of the weekly emission amount based on the 4:1 ratio observed in sample data.

Sample Data

address	removed	in_growth	in_sender	in_weekly	log_index	block_number	block_timestamp	transaction_hash
0xaaa823aa799bda3193d46476539bcb1da5b71330	false	229677778596162694121	0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869	918711114384650776485	7	50418532	2024-09-12T00:00:18.000Z	0x1ddc07c2b0b6f44252fd0693dfa31d8faca68d319f3dd920adb0350fd6fadd97
0xaaa823aa799bda3193d46476539bcb1da5b71330	false	168446938144877722811	0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869	673787752579510891245	13	47520807	2024-07-04T00:00:12.000Z	0x42208b8785bf112d94c11eed5dfe043fb319aa5fe91c27e7a31c95f2424b495c
0xaaa823aa799bda3193d46476539bcb1da5b71330	false	170148422368563356375	0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869	680593689474253425501	7	47227407	2024-06-27T00:00:23.000Z	0xa34c2c7e344938e566f9ab9cdb412af67d74b34c28c8e2786c1ac3759e455015

Example Query

Query with partition filter

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

PharaohCommandCenter_feeChangeV1_event

Fee adjustment events from Pharaoh DEX (decentralized exchange) on Avalanche, recording changes to trading pair fee rates in basis points. Used to track protocol fee structure changes and analyze revenue parameters across different liquidity pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__pair`	`STRING`	Contract address of the trading pair that had its fee rate modified in this event. Hex-encoded, 0x-prefixed 40-character string representing the liquidity pool or pair contract on Avalanche.
`in__newrate`	`STRING`	Updated fee rate in basis points for the trading pair. Values typically range from 25 to 300, representing 0.25% to 3.00% trading fees.

Sample Data

address	removed	in__pair	log_index	in__newrate	block_number	block_timestamp	transaction_hash
0xaaa11500dddb2b67a90d1a154dfb7eabb518eae6	false	0xaaa3f202babcf7d6493afbc0caee03af9c64f984	5	200	40491680	2024-01-17T19:07:07.000Z	0x23d6671c5a97a7aa6a5db3b7e3aedc3bce32751630747e47d2f119f9024b7c1f
0xaaa11500dddb2b67a90d1a154dfb7eabb518eae6	false	0xc017949e8c384ebe3c120ad573b5c1a44cb096b1	7	30	48266370	2024-07-21T21:23:09.000Z	0xf345b7498d46a5dc4d88222bd55876e49c977762195da0c204db72302a784e5c
0xaaa11500dddb2b67a90d1a154dfb7eabb518eae6	false	0xaaa3f202babcf7d6493afbc0caee03af9c64f984	29	100	51753079	2024-10-14T04:12:16.000Z	0xe2019b01423c7e604fca4a722c5251b2f7ddd93295cf7c9bec45f2a0565a0c0e

Example Query

Query with partition filter

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

PharaohCommandCenter_feeChangeV2_event

Fee configuration updates for liquidity pairs on Pharaoh DEX (decentralized exchange) on Avalanche, tracking changes to trading fee rates in basis points. Records show fee adjustments ranging from 1 to 3000 basis points (0.01% to 30%) for specific pair contracts.

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__pair`	`STRING`	Contract address of the trading pair for which the fee rate is being updated. Hex-encoded, 0x-prefixed 40-character string representing the liquidity pool or pair contract on Avalanche.
`in__newrate`	`STRING`	Updated fee rate for the trading pair, represented in basis points. Values like 2500 indicate 25%, 1200 indicates 12%, and 1 indicates 0.01% fee.

Sample Data

address	removed	in__pair	log_index	in__newrate	block_number	block_timestamp	transaction_hash
0xaaa11500dddb2b67a90d1a154dfb7eabb518eae6	false	0xa20c959b19f114e9c2d81547734cdc1110bd773d	22	2500	49617539	2024-08-23T14:52:03.000Z	0xdf46fa1e2571eb9393d5a8b72707914643eac8d805110b09df85fd69872286ab
0xaaa11500dddb2b67a90d1a154dfb7eabb518eae6	false	0xa20c959b19f114e9c2d81547734cdc1110bd773d	22	2000	49617712	2024-08-23T14:58:04.000Z	0x85830a4ef3c1d26c57faa3b4c8826999e7b718d1586c74799486a3533ba36dee
0xaaa11500dddb2b67a90d1a154dfb7eabb518eae6	false	0xa20c959b19f114e9c2d81547734cdc1110bd773d	39	2000	49616595	2024-08-23T14:21:06.000Z	0xd35c323445d168f4ac673cba98e087159e288b85b6d6463e8a66ad6b246ffc05

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

LegacyPair_Burn_event

LegacyPair_Claim_event

LegacyPair_Fees_event

LegacyPair_Mint_event

LegacyPair_Swap_event

LegacyPair_Sync_event

LegacyPair_Transfer_event

Minter_Mint_event

PharaohCommandCenter_feeChangeV1_event

PharaohCommandCenter_feeChangeV2_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​LegacyPair_Burn_event

​LegacyPair_Claim_event

​LegacyPair_Fees_event

​LegacyPair_Mint_event

​LegacyPair_Swap_event

​LegacyPair_Sync_event

​LegacyPair_Transfer_event

​Minter_Mint_event

​PharaohCommandCenter_feeChangeV1_event

​PharaohCommandCenter_feeChangeV2_event

Tables

Factory_PairCreated_event

LegacyPair_Burn_event

LegacyPair_Claim_event

LegacyPair_Fees_event

LegacyPair_Mint_event

LegacyPair_Swap_event

LegacyPair_Sync_event

LegacyPair_Transfer_event

Minter_Mint_event

PharaohCommandCenter_feeChangeV1_event

PharaohCommandCenter_feeChangeV2_event