> ## 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_v1_avalanche

> Tables in tt-contracts.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.

<Accordion title="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.                                     |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.Factory_PairCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.LegacyPair_Burn_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                 |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.LegacyPair_Claim_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_sender                                 | log\_index | in\_amount0            | in\_amount1 | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xc909d2f98de0a2ef734a792192db302ca51b4606 | false   | 0x0f4a1d7fdf4890be35e71f3e0bbc4a0ec377eca3 | 4          | 3450000000000000       | 0           | 51370463      | 2024-10-04T22:25:39.000Z | 0x0dc09f1a41856fdbd8f15d723cc7e6c895237f66c70eb6d77ce3770d4eee291d |
  | 0xc909d2f98de0a2ef734a792192db302ca51b4606 | false   | 0x0f4a1d7fdf4890be35e71f3e0bbc4a0ec377eca3 | 4          | 5000000000000000       | 0           | 51370947      | 2024-10-04T22:42:22.000Z | 0x37475910bc0b0475bd2d5486634bf4408e66e457b9648de42bdb0824ea8413f8 |
  | 0xc909d2f98de0a2ef734a792192db302ca51b4606 | false   | 0x22c81c051a134c81ce370d82fa26975ae9d100b4 | 3          | 7295592919662229914062 | 0           | 51371033      | 2024-10-04T22:45:18.000Z | 0xfd7b9f4faea0dbd4f038301e4423f5545b78f823b712425d172b63a910e81d86 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.LegacyPair_Fees_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                 |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.LegacyPair_Mint_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                       |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | block\_number | in\_amount0In            | in\_amount1In | in\_amount0Out | in\_amount1Out       | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------- | -------------- | -------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x03a5888726667fff1e753fc06b51dd1245e7371a | 0xaaa3f202babcf7d6493afbc0caee03af9c64f984 | false   | 0xfe81c675c06f8dd40d0d345505dc4592ccfa89c0 | 15         | 51148287      | 763791801642774169       | 0             | 0              | 1135699775482274834  | 2024-09-29T14:47:07.000Z | 0xeb341a78518ae1216b2d6ebb4024f473d4f9aa3705f954d31e7f3b646e0a8d96 |
  | 0x08776916ec60d4487c5495544927dde4b1012e17 | 0xaaa3f202babcf7d6493afbc0caee03af9c64f984 | false   | 0x22c81c051a134c81ce370d82fa26975ae9d100b4 | 13         | 51124012      | 6897348977443401665      | 0             | 0              | 10246188234871866483 | 2024-09-29T00:37:44.000Z | 0x52069878e3b80fb063901bf8ead7230c1d7b7ba7722871ac0a332ac203fca8cc |
  | 0x09661d79b7541ecff7bd6a73fba0c7cefeb3d739 | 0x73f7212838692e560f5b26fdb05cf0aa6cf56f33 | false   | 0x09661d79b7541ecff7bd6a73fba0c7cefeb3d739 | 11         | 51155332      | 186650559402508443256910 | 0             | 0              | 1576471428985077347  | 2024-09-29T18:48:51.000Z | 0xd2f03de1f5765e8955e695300fc5c271b9116b647613b8f9c3dfc3da8782cdcc |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.LegacyPair_Swap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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. |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.LegacyPair_Sync_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.LegacyPair_Transfer_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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. |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.Minter_Mint_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                                        |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.PharaohCommandCenter_feeChangeV1_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                         |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.pharaoh_v1_avalanche.PharaohCommandCenter_feeChangeV2_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***