> ## 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.
# gainsnetwork_v5_polygon
> Tables in tt-contracts.gainsnetwork_v5_polygon
## Tables
### GFarmTradingCallbacks\_LimitExecuted\_event
Limit order execution events from Gains Network (gTrade) v5 perpetual trading protocol on Polygon, capturing take-profit and stop-loss fills with position details, profit/loss percentages, and NFT bot executor addresses. Used for analyzing automated order execution performance and trader profit-taking behavior.
| 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_orderId` | `STRING` | Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations. |
| `in_limitIndex` | `STRING` | Index of the limit order within a trader's position. String-encoded integer identifier used to track multiple limit orders (take profit or stop loss) associated with a single trading position. |
| `in_t` | `STRUCT` | Structured trading position data containing trader address, pair identifier, position index, initial position token amount, position size in DAI, opening price, buy/sell direction, leverage multiplier, take profit price, and stop loss price. |
| `in_tInfo` | `STRUCT` | Trade state information including token pricing, interest tracking, and last update timestamps. Contains tokenPriceDai for position valuation, openInterestDai for protocol exposure, and timestamps for stop-loss/take-profit modifications. |
| `in_nftHolder` | `STRING` | Address of the NFT holder who is entitled to collect execution fees for the limit order. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_orderType` | `INT64` | Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol. |
| `in_price` | `STRING` | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision. |
| `in_positionSizeDai` | `STRING` | Position size of the trade denominated in DAI. String-encoded value representing the trade size with extended precision for decimal representation. |
| `in_percentProfit` | `STRING` | Percentage profit or loss on a trading position. String-encoded value with extended precision representing the profit/loss ratio as a percentage multiplied by a scaling factor. |
| `in_tokenPriceDai` | `STRING` | Price of the protocol's governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation. |
| in\_t | address | removed | in\_price | in\_tInfo | log\_index | in\_orderId | block\_number | in\_nftHolder | in\_orderType | in\_limitIndex | block\_timestamp | in\_percentProfit | in\_tokenPriceDai | transaction\_hash | in\_positionSizeDai |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------- | ----------- | ------------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ----------------- | ----------------- | ------------------------------------------------------------------ | -------------------- |
| \{"sl":"0","tp":"106287350000","buy":true,"index":"0","trader":"0x126dee771c6ce4121833542264762432b67c9ecb","leverage":"50","openPrice":"105242137000","pairIndex":"15","initialPosToken":"42548352387319375092","positionSizeDai":"0"} | 0x7af43f23f33642c4ea8bf10211a26d5a028a555f | false | 106290000000 | \{"tokenId":"0","slLastUpdated":"0","tokenPriceDai":"7957436034","tpLastUpdated":"0","openInterestDai":"1692878962370925600117","beingMarketClosed":false} | 51 | 65274 | 21468625 | 0x9930fed40cb550e30b4671cfd9d77825cf077fdc | 0 | 0 | 2021-11-17T07:45:38.000Z | 497834341771 | 7992173536 | 0xa1e5f5b63d028092f5ae698520d5625dc8c4c35bee705d6548f5cc3180ddf5e1 | 33857579247418512002 |
| \{"sl":"0","tp":"2283804416666","buy":true,"index":"0","trader":"0x126dee771c6ce4121833542264762432b67c9ecb","leverage":"60","openPrice":"2268133500000","pairIndex":"13","initialPosToken":"66892378808232740826","positionSizeDai":"0"} | 0x7af43f23f33642c4ea8bf10211a26d5a028a555f | false | 2232810000000 | \{"tokenId":"0","slLastUpdated":"0","tokenPriceDai":"7905544385","tpLastUpdated":"0","openInterestDai":"3172924018120304016060","beingMarketClosed":false} | 403 | 65534 | 21472256 | 0x877998df4eae3e230646a95d9a2bfc15f4ab2419 | 2 | 0 | 2021-11-17T09:57:49.000Z | -934429124211 | 7921937289 | 0x585378c18801458e5ac00a03ecf05ecfb5007aaa7b034c0236a579da78459e1a | 52882066968671733601 |
| \{"sl":"0","tp":"2303270000000","buy":true,"index":"0","trader":"0x126dee771c6ce4121833542264762432b67c9ecb","leverage":"50","openPrice":"2288143500000","pairIndex":"13","initialPosToken":"66576099185103692549","positionSizeDai":"0"} | 0x7af43f23f33642c4ea8bf10211a26d5a028a555f | false | 2246900000000 | \{"tokenId":"0","slLastUpdated":"21471586","tokenPriceDai":"7991437112","tpLastUpdated":"21470811","openInterestDai":"2660193549000153031021","beingMarketClosed":false} | 225 | 65472 | 21471808 | 0xf99f8337a8b4f0791effe21e3e048eef04842a1c | 2 | 0 | 2021-11-17T09:42:25.000Z | -901243737554 | 7905544385 | 0xcbca128c1e519b6aca3da646544c0f47575f34ab47152a822c6e8ef110bddf2c | 53203870980003060620 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v5_polygon.GFarmTradingCallbacks_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GFarmTradingCallbacks\_MarketExecuted\_event
Market order execution events from Gains Network (gTrade) perpetual trading protocol on Polygon. Contains position opens/closes with entry/exit prices, profit/loss percentages, leverage, and stop-loss/take-profit levels for analyzing trader performance and protocol activity.
| Column | Type | Description |
| -------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_orderId` | `STRING` | Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations. |
| `in_t` | `STRUCT` | Structured trading position data containing trader address, pair identifier, position index, initial position token amount, position size in DAI, opening price, buy/sell direction, leverage multiplier, take profit price, and stop loss price. |
| `in_open` | `BOOL` | Boolean flag indicating whether the event represents a position opening (true) or closing (false) operation. |
| `in_price` | `STRING` | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision. |
| `in_positionSizeDai` | `STRING` | Position size of the trade denominated in DAI. String-encoded value representing the trade size with extended precision for decimal representation. |
| `in_percentProfit` | `STRING` | Percentage profit or loss on a trading position. String-encoded value with extended precision representing the profit/loss ratio as a percentage multiplied by a scaling factor. |
| `in_tokenPriceDai` | `STRING` | Price of the protocol's governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation. |
| in\_t | address | in\_open | removed | in\_price | log\_index | in\_orderId | block\_number | block\_timestamp | in\_percentProfit | in\_tokenPriceDai | transaction\_hash | in\_positionSizeDai |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | -------- | ------- | ----------- | ---------- | ----------- | ------------- | ------------------------ | ----------------- | ----------------- | ------------------------------------------------------------------ | --------------------- |
| \{"sl":"11249093520","tp":"11303132400","buy":true,"index":"0","trader":"0xc75351e058038dfb1336e65eef37ff298e524513","leverage":"250","openPrice":"11257525640","pairIndex":"21","initialPosToken":"391068752061832229728","positionSizeDai":"0"} | 0x7af43f23f33642c4ea8bf10211a26d5a028a555f | true | false | 11257525640 | 56 | 113060 | 22234026 | 2021-12-07T09:10:30.000Z | 0 | 5147502480 | 0x0141a2b2ebaeb4eb683782f902eed36be88cb25fdfe9be1a361e3f83566d6494 | 201302737108878651586 |
| \{"sl":"11249093520","tp":"11303132400","buy":true,"index":"0","trader":"0xc75351e058038dfb1336e65eef37ff298e524513","leverage":"250","openPrice":"11257525640","pairIndex":"21","initialPosToken":"391068752061832229728","positionSizeDai":"0"} | 0x7af43f23f33642c4ea8bf10211a26d5a028a555f | false | false | 11263300000 | 97 | 113073 | 22234244 | 2021-12-07T09:20:10.000Z | 128233329966 | 5142026288 | 0xeeca6c7eb2250703d34bd987b60a394c0379e1a3d446249b16b613398440a8c4 | 201302737108878651586 |
| \{"sl":"0","tp":"28422725000","buy":true,"index":"1","trader":"0x0acc2043d0b177d2097e25b24fa1d5ecd89d671d","leverage":"8","openPrice":"13386373000","pairIndex":"9","initialPosToken":"82434448327983187471","positionSizeDai":"0"} | 0x7af43f23f33642c4ea8bf10211a26d5a028a555f | true | false | 13386373000 | 210 | 112373 | 22223535 | 2021-12-07T02:42:26.000Z | 0 | 6095130405 | 0x643e22f0bfb1c4e8d2abe957da1f28befba13805664304c0acbc1ff1964b3207 | 50244871242329173828 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v5_polygon.GFarmTradingCallbacks_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacks\_LimitExecuted\_event
Limit order executions from Gains Network (GNS) v5 decentralized leverage trading protocol on Polygon, capturing take-profit and stop-loss triggers with profit/loss percentages and NFT bot executor addresses. Used for analyzing automated trade closures and position performance across trading pairs.
| 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_orderId` | `STRING` | Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations. |
| `in_limitIndex` | `STRING` | Index of the limit order within a trader's position. String-encoded integer identifier used to track multiple limit orders (take profit or stop loss) associated with a single trading position. |
| `in_t` | `STRUCT` | Structured trading position data containing trader address, pair identifier, position index, initial position token amount, position size in DAI, opening price, buy/sell direction, leverage multiplier, take profit price, and stop loss price. |
| `in_tInfo` | `STRUCT` | Trade metadata and state information at execution time, including token price in DAI, last update blocks for stop-loss and take-pair orders, total open interest, and market closure status. Nested record structure containing supplementary position data used for settlement calculations. |
| `in_nftHolder` | `STRING` | Address of the NFT holder who is entitled to collect execution fees for the limit order. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_orderType` | `INT64` | Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol. |
| `in_price` | `STRING` | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision. |
| `in_positionSizeDai` | `STRING` | Position size of the trade denominated in DAI. String-encoded value representing the trade size with extended precision for decimal representation. |
| `in_percentProfit` | `STRING` | Percentage profit or loss on a trading position. String-encoded value with extended precision representing the profit/loss ratio as a percentage multiplied by a scaling factor. |
| `in_tokenPriceDai` | `STRING` | Price of the protocol's governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation. |
| in\_t | address | removed | in\_price | in\_tInfo | log\_index | in\_orderId | block\_number | in\_nftHolder | in\_orderType | in\_limitIndex | block\_timestamp | in\_percentProfit | in\_tokenPriceDai | transaction\_hash | in\_positionSizeDai |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ----------- | ------------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ----------------- | ----------------- | ------------------------------------------------------------------ | --------------------- |
| \{"sl":"470084000000000","tp":"472776000000000","buy":true,"index":"0","trader":"0x0db56c99b8ad68f35f4b1772a4ffed3fb16204f6","leverage":"50","openPrice":"469343906650000","pairIndex":"0","initialPosToken":"30330248234444051514","positionSizeDai":"0"} | 0x1e87e8703883a46ccdec4c8868043abe40235bed | false | 472899000000000 | \{"tokenId":"0","slLastUpdated":"23250906","tokenPriceDai":"31667990073","tpLastUpdated":"23251626","openInterestDai":"4802490000000000000096","beingMarketClosed":false} | 232 | 172935 | 23253045 | 0xb00d3c75969f6d8f6531e352e82f1dd1488b47be | 0 | 0 | 2022-01-02T07:37:29.000Z | 378730105965 | 33455928233 | 0x829e22d25a5e05ebe9a62ab6a0134137d56e09090c2a0a54732f3527225f90d0 | 96049800000000000001 |
| \{"sl":"0","tp":"9000000000","buy":true,"index":"0","trader":"0x207d888427fdcdcf45fd8cc665c23b1da06ba666","leverage":"5","openPrice":"9069060000","pairIndex":"45","initialPosToken":"200365603244854460569","positionSizeDai":"0"} | 0x1e87e8703883a46ccdec4c8868043abe40235bed | false | 9035000000 | \{"tokenId":"0","slLastUpdated":"0","tokenPriceDai":"17415698820","tpLastUpdated":"23116804","openInterestDai":"1744753500000000000001","beingMarketClosed":false} | 19 | 173229 | 23266042 | 0x519e23e8d6b5e1682a1635df3419828dea858018 | 0 | 0 | 2022-01-02T15:25:58.000Z | -18778131360 | 30525077576 | 0x1924044ada9e0657ba87a8654a826a0087983338241ad23de0931143d516f5ed | 348950700000000000000 |
| \{"sl":"0","tp":"38000400000000","buy":true,"index":"0","trader":"0x3a5fd1e9ed261b798a2fee4ccb2b4835407e2c21","leverage":"8","openPrice":"36273127500000","pairIndex":"1","initialPosToken":"525432484344617043579","positionSizeDai":"0"} | 0x1e87e8703883a46ccdec4c8868043abe40235bed | false | 38042000000000 | \{"tokenId":"0","slLastUpdated":"0","tokenPriceDai":"18910379952","tpLastUpdated":"23204492","openInterestDai":"7948902334464000000011","beingMarketClosed":false} | 250 | 173305 | 23268178 | 0xb00d3c75969f6d8f6531e352e82f1dd1488b47be | 0 | 0 | 2022-01-02T16:47:58.000Z | 390122963618 | 30472181127 | 0xfec91ba9a11a7f351723ba5b2605cfa60aff16741b52ee011da7672ae82831a4 | 993612791808000000001 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v5_polygon.GNSTradingCallbacks_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacks\_MarketExecuted\_event
Market order execution events from Gains Network v5 perpetual trading protocol on Polygon, recording position opens/closes with profit/loss, leverage, and trade parameters. Tracks trader activity across multiple trading pairs denominated in DAI stablecoin.
| 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_orderId` | `STRING` | Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations. |
| `in_t` | `STRUCT` | Structured trading position data containing trader address, pair identifier, position index, initial position token amount, position size in DAI, opening price, buy/sell direction, leverage multiplier, take profit price, and stop loss price. |
| `in_open` | `BOOL` | Boolean flag indicating whether the event represents a position opening (true) or closing (false) operation. |
| `in_price` | `STRING` | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision. |
| `in_positionSizeDai` | `STRING` | Position size of the trade denominated in DAI. String-encoded value representing the trade size with extended precision for decimal representation. |
| `in_percentProfit` | `STRING` | Percentage profit or loss on a trading position. String-encoded value with extended precision representing the profit/loss ratio as a percentage multiplied by a scaling factor. |
| `in_tokenPriceDai` | `STRING` | Price of the protocol's governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation. |
| in\_t | address | in\_open | removed | in\_price | log\_index | in\_orderId | block\_number | block\_timestamp | in\_percentProfit | in\_tokenPriceDai | transaction\_hash | in\_positionSizeDai |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | -------- | ------- | ------------- | ---------- | ----------- | ------------- | ------------------------ | ----------------- | ----------------- | ------------------------------------------------------------------ | --------------------- |
| \{"sl":"10920000000","tp":"9590000000","buy":false,"index":"0","trader":"0x9bde27f18ca5e70157a0c05391ed9f430a900762","leverage":"5","openPrice":"10167308803","pairIndex":"5","initialPosToken":"32688583690909317270","positionSizeDai":"0"} | 0x1e87e8703883a46ccdec4c8868043abe40235bed | false | false | 10478200000 | 316 | 241820 | 24292182 | 2022-01-29T05:15:10.000Z | -152887653470 | 39405164763 | 0xbe04c806609ff24f80da1bd76fa8a946956b3c3bd47bae60e5f93688182f54bd | 124500624750000000003 |
| \{"sl":"0","tp":"11456486029","buy":true,"index":"0","trader":"0x74daf8b664a5769c6bb490965e97b22b5b216fd3","leverage":"100","openPrice":"10510537642","pairIndex":"5","initialPosToken":"120660751631726182834","positionSizeDai":"0"} | 0x1e87e8703883a46ccdec4c8868043abe40235bed | false | false | 10456170000 | 20 | 241627 | 24286311 | 2022-01-29T01:41:53.000Z | -517267944341 | 39077508734 | 0xc02e33a7dd7e44bb937d8e4f6f440aba74da7f33d44dd9a5fdd6ccfbc336c950 | 470400000000000000000 |
| \{"sl":"0","tp":"1704662493529","buy":true,"index":"0","trader":"0x453970503c56c4086b9ddcf13d7992bad698ebdf","leverage":"17","openPrice":"1114587015000","pairIndex":"13","initialPosToken":"52884557732528718516","positionSizeDai":"0"} | 0x1e87e8703883a46ccdec4c8868043abe40235bed | true | false | 1114587015000 | 31 | 243216 | 24316787 | 2022-01-29T20:36:13.000Z | 0 | 38219451910 | 0x5f304a92be63b744752283c1324504e8456665793d5fe87d14a06a2e7396a850 | 202121881104000000001 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v5_polygon.GNSTradingCallbacks_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***