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

# stargate_v1_fantom

> Tables in tt-contracts.stargate_v1_fantom

## Tables

### Pool\_Burn\_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.

<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_amountLP`      | `STRING`    | Amount of liquidity provider (LP) tokens involved in the mint or burn operation. Numeric string representing the quantity of pool-specific LP tokens.                                                        |
  | `in_amountSD`      | `STRING`    | Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_from                                   | removed | log\_index | in\_amountLP | in\_amountSD | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------ | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | 0x1c180075ef61ba11c027cf0d709ee570f9a7cbf6 | false   | 7          | 6190474304   | 6190474304   | 76649204      | 2024-03-03T05:28:10.000Z | 0x18915cdf651bef798aeff04a6356af28095335669a6c30103dd9c94b33b282af |
  | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | 0x36e7e8fc9552d4f1590c0f3978e0386c8ca72969 | false   | 183        | 200800000    | 200800000    | 76654598      | 2024-03-03T10:39:38.000Z | 0x8fd7a655ec4cb5bf7ae70231f1cdbcde49712f506b450a183b7477c7cbd17bad |
  | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | 0x3baa16325f0014e1dfd2e33a4fe1fd3e510159af | false   | 1          | 1398274472   | 1398274472   | 76654795      | 2024-03-03T10:52:40.000Z | 0xff1c118454bcb541a05c6f0bb551b3cbd7de45f26b183e4e7c889f5ed6e74f56 |
</Accordion>

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

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

***

### Pool\_Mint\_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

<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_to`              | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                       |
  | `in_amountLP`        | `STRING`    | Amount of liquidity provider (LP) tokens involved in the mint or burn operation. Numeric string representing the quantity of pool-specific LP tokens.                                                                 |
  | `in_amountSD`        | `STRING`    | Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.          |
  | `in_mintFeeAmountSD` | `STRING`    | Fee amount charged for minting liquidity provider tokens, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility. |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | log\_index | in\_amountLP | in\_amountSD | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_mintFeeAmountSD |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------ | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
  | 0x77ac6a6d7d81d5992b20f567904229c2556faf7b | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | false   | 3          | 300000       | 300000       | 97738327      | 2024-11-19T14:08:01.000Z | 0x5514c21cb4b907a47293653182cb0911d9975859ccf2cfeb7002787e1cfbda94 | 0                   |
  | 0xf32be088eef49ea0fe9841c3a08592e606d0b65b | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | false   | 2          | 10000        | 10000        | 77088609      | 2024-03-10T19:49:00.000Z | 0xd3142dbf037afe0244dd322ba8123452b980075ac0bac1e3d260529f9d25fe58 | 0                   |
  | 0x5094086cb7f12bceb2639549f4691f856cd422bc | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | false   | 2          | 103854786    | 103854786    | 77053012      | 2024-03-10T01:51:31.000Z | 0x552139a6448d2c1d74723f5ac7a3623511c74dcbb516b4cc5af8918d3f4ae531 | 0                   |
</Accordion>

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

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

***

### Pool\_Swap\_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

<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_chainId`       | `STRING`    | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.                                                |
  | `in_dstPoolId`     | `STRING`    | Identifier for the destination Stargate liquidity pool in a cross-chain swap operation. Numeric string representing the pool ID on the target chain.                                                         |
  | `in_from`          | `STRING`    | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                |
  | `in_amountSD`      | `STRING`    | Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility. |
  | `in_eqReward`      | `STRING`    | Reward amount credited for equilibrium rebalancing in the Stargate cross-chain swap operation. Numeric string representation without decimals.                                                               |
  | `in_eqFee`         | `STRING`    | Fee charged for equilibrium adjustment in the Stargate cross-chain swap operation. Numeric string representation without decimals.                                                                           |
  | `in_protocolFee`   | `STRING`    | Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.                                                                                             |
  | `in_lpFee`         | `STRING`    | Fee collected by liquidity providers from the swap transaction. Numeric string representation without decimals.                                                                                              |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_from                                   | removed | in\_eqFee | in\_lpFee | log\_index | in\_chainId | in\_amountSD | in\_eqReward | block\_number | in\_dstPoolId | in\_protocolFee | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | --------- | --------- | ---------- | ----------- | ------------ | ------------ | ------------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | 0x162f4635222abbf76d25f6e02bb76ef21b246041 | false   | 163235    | 5146      | 0          | 106         | 51253255     | 0            | 101485353     | 1             | 46321           | 2024-12-30T10:38:31.000Z | 0xc66bc946396d3da77618a594eb3e0c9cc4f894588734e85c1ac59969f269838f |
  | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | 0x68b2ca416a9109c9aa5221079ab64d2921410c61 | false   | 480584    | 15173     | 41         | 106         | 151104082    | 0            | 101485086     | 1             | 136562          | 2024-12-30T10:33:18.000Z | 0xa32d4995e490f16345b944e3baf1958430f2b75c154566ecc7edc6be85637670 |
  | 0xc647ce76ec30033aa319d472ae9f4462068f2ad7 | 0x0dd1aa0fb1ca21af1f0a7da0b54339fac617c141 | false   | 808909    | 22032     | 3          | 109         | 219295690    | 0            | 101454582     | 1             | 198292          | 2024-12-30T01:28:42.000Z | 0xbd48f1efc4489c26b92bc9fa1fe7adcd1169150ae7ebb57f24d49a543195f39e |
</Accordion>

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

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

***

### StargateToken\_SendToChain\_event

Cross-chain token transfer events from Stargate protocol capturing outbound transactions to destination blockchains via LayerZero. Records sender address, recipient address, token quantity, and destination chain identifier for tracking omnichain liquidity movements.

<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_dstChainId`    | `STRING`    | Destination chain identifier for cross-chain operations. String-encoded integer representing the target blockchain in LayerZero's chain ID system.   |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_qty`           | `STRING`    | Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.               |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | in\_qty                | address                                    | removed | log\_index | block\_number | in\_dstChainId | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ---------------------- | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x1118869ea46bd1673e0ac7261e85a2bcfb6764cd | 2804967103500574685145 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | false   | 4          | 42903375      | 2              | 2022-07-16T17:29:13.000Z | 0x364df4f5608b8e200db6f8494a4fa0f084a6d563caa9d9dd4ffdb140c892bfb9 |
  | 0x1118869ea46bd1673e0ac7261e85a2bcfb6764cd | 2814469051302754721487 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | false   | 35         | 42903290      | 2              | 2022-07-16T17:27:47.000Z | 0x60795cb90b487d385f629a2e858f7101b8e8cdbea219fb691e3ae0a81d429f64 |
  | 0x1118869ea46bd1673e0ac7261e85a2bcfb6764cd | 2824157376064068797737 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | false   | 38         | 42903232      | 2              | 2022-07-16T17:26:37.000Z | 0x1b74abdf9293592ddbc7e759c9323e5aba65c60cd1867b382dd2e1d0131125d6 |
</Accordion>

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

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

***

### StargateToken\_Transfer\_event

ERC-20 Transfer events emitted by Stargate token contracts. Records token movements between addresses including mints (from zero address) and burns (to zero address) for cross-chain liquidity management and staking operations.

<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_value`         | `STRING`    | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.       |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | in\_from                                   | removed | in\_value               | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ----------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x327518480b2d37b6b0a2834aa1f15d41b0f19af9 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | 0x0000000000000000000000000000000000000000 | false   | 100000000000000000      | 157        | 74800719      | 2024-01-26T16:34:23.000Z | 0x2fb0e57d1ccfb13ae4baa48771b04773957e8d7889d276e62af41c89e4a15f1b |
  | 0xe8745f7f4c0b61fbc2b56c25abf3b19b22c73948 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | 0x0000000000000000000000000000000000000000 | false   | 744761140000000000000   | 211        | 74788113      | 2024-01-26T06:15:28.000Z | 0xba10a65b0ae1a6070249f1acd3ca890a933569b8693a5d44086e279cf7ce9cba |
  | 0x6948d663e33a73a183f265b50a2a98fc0c9c3b87 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | 0x0000000000000000000000000000000000000000 | false   | 21314310000000000000000 | 279        | 74791003      | 2024-01-26T08:41:24.000Z | 0xb9be3f8152ab8dcc347aac686d930ed00f532bf7c1ce54ee706b7d0cdefb2bf3 |
</Accordion>

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

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

***