> ## 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_polygon
> Tables in tt-contracts.stargate_v1_polygon
## Tables
### Factory\_createPool\_function
Function call data for liquidity pool creation through factory contracts, including token pair addresses, fee tiers, and the resulting pool address. Used for tracking DEX (Decentralized Exchange) pool deployments and factory contract interactions.
| 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `NUMERIC` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__poolId` | `STRING` | Unique identifier for the Stargate liquidity pool being created. Numeric string assigned to distinguish pools across chains. |
| `in__token` | `STRING` | Contract address of the token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__sharedDecimals` | `INT64` | Number of decimal places used for the token's shared representation across chains in Stargate protocol. Integer value standardizing precision for cross-chain transfers. |
| `in__localDecimals` | `INT64` | Number of decimal places for the token on the local chain. Integer value indicating precision for amount conversions. |
| `in__name` | `STRING` | Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes. |
| `in__symbol` | `STRING` | Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols. |
| `out_poolAddress` | `STRING` | Contract address of the newly created Stargate liquidity pool. Hex-encoded, 0x-prefixed, 42-character string. |
| gas | value | status | gas\_used | in\_\_name | in\_\_token | signature | in\_\_poolId | in\_\_symbol | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | out\_poolAddress | transaction\_hash | in\_\_localDecimals | in\_\_sharedDecimals |
| ------- | ----- | ------ | --------- | ----------------------- | ------------------------------------------ | ---------- | ------------ | ------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------- | -------------------- |
| 3939882 | 0 | true | 3824450 | (PoS) Dai Stablecoin-LP | 0x8f3cf7ad23cd3cadbd9735aff958023239c6a063 | 0x7af935a1 | 3 | S\*DAI | 0x808d7c71ad2ba3fa531b068a2417c63106bc0949 | 35610642 | 0x45a01e4e04f14f7a4a6702c74187c5f6222033cd | 0,1,0,0 | 2022-11-14T20:55:34.000Z | 0x1c272232df0bb6225da87f4decd9d37c32f63eea | 0x18c61463aa231e02dc26e7dba2a13ae715ecc7c95f7da12f9fddcef0bf44df68 | 18 | 6 |
| 3836114 | 0 | true | 3824400 | (PoS) Tether USD-LP | 0xc2132d05d31c914a87c6611c10748aeb04b58e8f | 0x7af935a1 | 2 | S\*USDT | 0x808d7c71ad2ba3fa531b068a2417c63106bc0949 | 26032728 | 0x45a01e4e04f14f7a4a6702c74187c5f6222033cd | 0 | 2022-03-17T08:05:56.000Z | 0x29e38769f23701a2e4a8ef0492e19da4604be62c | 0xc71d72461e8a8dd06bfb7488bae27f678110c98a192ff0b74b68c40e83a4f4af | 6 | 6 |
| 3841500 | 0 | true | 3841500 | USD Coin (PoS)-LP | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x7af935a1 | 1 | S\*USDC | 0x808d7c71ad2ba3fa531b068a2417c63106bc0949 | 26032726 | 0x45a01e4e04f14f7a4a6702c74187c5f6222033cd | 0 | 2022-03-17T08:05:48.000Z | 0x1205f31718499dbf1fca446663b532ef87481fe1 | 0x871e66b14aae09a8a71642039647d19843c405d39fab2732e8470297b42fbdf2 | 6 | 6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.stargate_v1_polygon.Factory_createPool_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | in\_from | removed | log\_index | in\_amountLP | in\_amountSD | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------ | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1205f31718499dbf1fca446663b532ef87481fe1 | 0xc77572b549cb83afccc7068e4258b8f094f39947 | false | 169 | 746071504 | 746563217 | 45488610 | 2023-07-25T04:48:46.000Z | 0x1f32f4864ab2688298b05d8848d1d216b5d0e27bdf1f0270f96345fa721d89ea |
| 0x1205f31718499dbf1fca446663b532ef87481fe1 | 0x946e94d7408f928a2f6b07bd19bd87ec87f8ee15 | false | 222 | 5000000 | 5003298 | 45508439 | 2023-07-25T17:14:32.000Z | 0x32c5ea1bbefb6546070fc669c288dbc6fcb7fa556553c9cbd2eae451bdebe8a6 |
| 0x1205f31718499dbf1fca446663b532ef87481fe1 | 0x6a5705376e2c29bac60cd685f199f32269851f3b | false | 84 | 1010753338 | 1011419515 | 45489903 | 2023-07-25T05:36:22.000Z | 0x3d15e987f648ae6b3691008de8b7e00c7745dbc4e2873f8d3dd749e0a1d7e887 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.stargate_v1_polygon.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| in\_to | address | removed | log\_index | in\_amountLP | in\_amountSD | block\_number | block\_timestamp | transaction\_hash | in\_mintFeeAmountSD |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------ | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0xab05bfb2e1a35763fd4b2bd02226f22ecd03a91d | 0x1205f31718499dbf1fca446663b532ef87481fe1 | false | 198 | 10382400 | 10390040 | 52145133 | 2024-01-10T03:18:11.000Z | 0x02082513cce46f376ab23ac333f0c0344b0031d17a586cde99e9a927fe5950c2 | 0 |
| 0x97de76e77635f856dae681faf621be4d60ca9300 | 0x1205f31718499dbf1fca446663b532ef87481fe1 | false | 345 | 199852873 | 200000000 | 52177494 | 2024-01-10T23:35:33.000Z | 0xe000f70a818af64ef8e0c34027698c253aee0f1a9a9bc188f0c043496b42189f | 0 |
| 0xd63946b12168e53c1e032492a3a24ba96f8bf26c | 0x1205f31718499dbf1fca446663b532ef87481fe1 | false | 465 | 99926448 | 100000000 | 52165631 | 2024-01-10T16:16:31.000Z | 0xef3631ae54c7b9d79a4b9926f8ec207f83ac9b68869387e378a0300448dd13de | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.stargate_v1_polygon.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | --------- | --------- | ---------- | ----------- | ------------ | ------------ | ------------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1205f31718499dbf1fca446663b532ef87481fe1 | 0x2faf55a544c5f73666438bc185aecc9d685e6e3c | false | 124397 | 0 | 146 | 101 | 4144091607 | 0 | 38179154 | 1 | 2363549 | 2023-01-17T04:58:42.000Z | 0x45b3e83d4a146fdef81a69c0e7640d405f338d5d75447cece7c657632ff3962a |
| 0x1205f31718499dbf1fca446663b532ef87481fe1 | 0x0f9c8d582c746a2007bb3b0f7f0d237b30bd18ba | false | 155040 | 0 | 152 | 101 | 5164922635 | 0 | 38184746 | 1 | 2945773 | 2023-01-17T08:12:48.000Z | 0x2440b2ff0ea055f97f2f4ed089db2c795ad491e49f9913120f82f05481bb4ade |
| 0x29e38769f23701a2e4a8ef0492e19da4604be62c | 0xdc2716b92480225533abc3328c2ab961f2a9247d | false | 2332 | 0 | 277 | 101 | 77715208 | 0 | 38176515 | 2 | 44324 | 2023-01-17T03:27:58.000Z | 0x1ded090c18c397f8b766c071c76765f02a6526f43cba5a17e20155b45a7af30c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.stargate_v1_polygon.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| in\_to | in\_qty | address | removed | log\_index | block\_number | in\_dstChainId | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ----------------------- | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe70bfaf288a88b048db4b2e952819c44b0e94a8f | 98427700405740000000000 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | false | 314 | 36859391 | 101 | 2022-12-15T12:10:06.000Z | 0x16889d85ebbfa5bab4b18140c68f3f71918d7f2b8eaef003bf08ec47706798e0 |
| 0x58328980d7195f05b4ff52eba2010a43fff7918b | 37519321926565543959 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | false | 329 | 36879007 | 102 | 2022-12-15T23:31:13.000Z | 0x3d8860a18252f7b6aae6df787464fdb78f227db3f4ab576d1ac7f390f15a5d8b |
| 0xdbd950304110fecda365176eb238f52717e3e381 | 26549937757891366870 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | false | 261 | 36856778 | 106 | 2022-12-15T10:36:04.000Z | 0x4000e3f041693317d142f642b4a1dc8194a955384648d3c962f919911b356f72 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.stargate_v1_polygon.StargateToken_SendToChain_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| in\_to | address | in\_from | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0000000000000000000000000000000000000000 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | 0x47ce50339162b2374dfb1dff0d7915804a2be665 | false | 3429763674053187662380 | 114 | 34008661 | 2022-10-06T15:44:40.000Z | 0x4baa9997fa789f50ea690803a23e7f87290088acbb7e2826f45a4883cbf8ceed |
| 0x0319000133d3ada02600f0875d2cf03d442c3367 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | 0xbadffffffff3f678866b558e3fd0a2a4deb4dc48 | false | 9134424827884807826 | 215 | 33981438 | 2022-10-06T00:02:54.000Z | 0x87be45d63f2eb56e4d1e6ce6b6f4a8645c047f3e3f41acdb706254fd52cec55e |
| 0x0319000133d3ada02600f0875d2cf03d442c3367 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | 0xbadffffffff3f678866b558e3fd0a2a4deb4dc48 | false | 2197143883320658229 | 96 | 33981484 | 2022-10-06T00:04:30.000Z | 0x8818ca14aed92cbd0f6cced014357d76986addbcc88f4b7fe2fd8deb25aa105f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.stargate_v1_polygon.StargateToken_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***