> ## 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_v7_polygon
> Tables in tt-contracts.gainsnetwork_v7_polygon
## Tables
### GNSTradingCallbacks\_LimitExecuted\_event
Limit order execution events from gTrade v7 perpetual futures protocol on Polygon, capturing take-profit and stop-loss fills with trader addresses, position details, profit/loss percentages, and NFT holder (bot executor) information. Used for analyzing limit order fill rates, trader PnL outcomes, and bot executor 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_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_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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| in\_t | address | removed | in\_price | log\_index | in\_orderId | block\_number | in\_nftHolder | in\_orderType | in\_limitIndex | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | --------------- | ---------- | ----------- | ------------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | --------------------- | --------------------- |
| \{"sl":"0","tp":"242060000000000","buy":true,"index":"0","trader":"0x00f38738c8f5cf18292c2a135473ba635d542949","leverage":"150","openPrice":"241111799952589","pairIndex":"0","initialPosToken":"3460100440000531812","positionSizeDai":"0"} | 0x170cc5a70d6f544e5456881b586eb58180998a37 | false | 242060000000000 | 75 | 1391454 | 31821233 | 0x12b4cf2e72f813a66b6c58583f81c22926aaf861 | 0 | 0 | 2022-08-12T22:36:48.000Z | 0 | 589892353421 | 0x33f17e00df724d104bedcccb5aac9243c4fdc756ffd2ab14689d1fa4c4a2316f | 13449499862352911607 | 9099999998634999999 |
| \{"sl":"0","tp":"12205100000","buy":true,"index":"0","trader":"0x022e3ce4eda264b3e3fef62036c8182ceb88e6ce","leverage":"1000","openPrice":"12190517332","pairIndex":"23","initialPosToken":"148759553821525346718","positionSizeDai":"0"} | 0x170cc5a70d6f544e5456881b586eb58180998a37 | false | 12205100000 | 49 | 1390048 | 31797168 | 0x5c22cf89ced9a14d5ecf711442f91ed6db1ff646 | 0 | 0 | 2022-08-12T06:43:42.000Z | 0 | 1196230447228 | 0x5e043be7a528f5dafcbc22dfc47021913d37770ddee7cd352f642b8b57dab312 | 831491613725326022260 | 393671999606327999999 |
| \{"sl":"0","tp":"1589009345794","buy":false,"index":"0","trader":"0x2ae4f1b01f06fa0a28bb0c9dbc098ae12b56aaca","leverage":"107","openPrice":"1604000000000","pairIndex":"51","initialPosToken":"5351082188441961157","positionSizeDai":"0"} | 0x170cc5a70d6f544e5456881b586eb58180998a37 | false | 1589009345794 | 186 | 1389779 | 31790088 | 0x2430403186b3a9e08ba7264fbb924447cb7a31d6 | 0 | 0 | 2022-08-12T02:14:43.000Z | 0 | 1000000000026 | 0x7486da66a7247d454d8383f88635c45a8c4f78205fdf1e88fb6104444044442e | 27140466084380896542 | 14194495138481189022 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_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 (GNS) v7 perpetual trading protocol on Polygon. Contains trade fills with execution prices, profit/loss, position sizes in DAI stablecoin, and leverage data for tracking 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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| in\_t | address | in\_open | removed | in\_price | log\_index | in\_orderId | block\_number | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | -------- | ------- | -------------- | ---------- | ----------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ---------------------- | ---------------------- |
| \{"sl":"0","tp":"10150077857142","buy":false,"index":"0","trader":"0x740320f15bf19a2ece2eb13576e69fd6700bb8d4","leverage":"35","openPrice":"10223083312004","pairIndex":"41","initialPosToken":"79316612426541511842","positionSizeDai":"0"} | 0x170cc5a70d6f544e5456881b586eb58180998a37 | true | false | 10223083312004 | 41 | 1346377 | 30937533 | 2022-07-20T13:13:03.000Z | 76163782 | 0 | 0x2416f7792cff707514db46a9dc415649f1c418f8732e50c4fb5326c3d53e6197 | 0 | 97899999996573499999 |
| \{"sl":"0","tp":"11158221000","buy":true,"index":"0","trader":"0xc1f2e41d6b924eee7732e07ea25850cdbffb6381","leverage":"100","openPrice":"10236900000","pairIndex":"21","initialPosToken":"2519049563819368800555","positionSizeDai":"0"} | 0x170cc5a70d6f544e5456881b586eb58180998a37 | false | false | 10220125000 | 26 | 1346669 | 30939918 | 2022-07-20T14:38:49.000Z | 0 | -163867967841 | 0x23cc83dde342c387196ee2e1b0e85fc01b60fc5f40882dd19843b96da63ddcf0 | 2490316752363977342887 | 2976035999702396400000 |
| \{"sl":"0","tp":"9868975204","buy":false,"index":"0","trader":"0x27be3c0b106371b3ced192375b041957a42b842f","leverage":"250","openPrice":"10237526145","pairIndex":"21","initialPosToken":"79476739451018743703","positionSizeDai":"0"} | 0x170cc5a70d6f544e5456881b586eb58180998a37 | true | false | 10237526145 | 175 | 1346037 | 30930292 | 2022-07-20T08:51:16.000Z | 0 | 0 | 0xfddb85460e39d132307fe2b326f61bc626de649570403c7843f091a472c586c9 | 0 | 98499999975375000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacks_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV2\_DevGovFeeCharged\_event
Development and governance fee collection events from Gains Network v7 perpetual trading protocol on Polygon. Records DAI-denominated fees charged on trade executions for protocol maintenance and governance 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_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 1 | 930600000000000000 | 34557545 | 2022-10-20T00:52:01.000Z | 0x2c865c7121378f81371b1e567572502b41685dab1bc1f03028ea2487b901588a |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 1 | 14928795000000000000 | 34589976 | 2022-10-20T20:03:02.000Z | 0xd8ed7d5443dbe149e0b6395e5b45ae3d9f79929b50b2d71873498dbfa83ade0d |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 1 | 223199999999999998 | 34580689 | 2022-10-20T14:25:41.000Z | 0x07054720938b54e8eb9b928f7cb0b79a663cb4ec3aae3bd118fc059d07e59047 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV2_DevGovFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV2\_LimitExecuted\_event
Limit order execution events from Gains Network (gTrade) v7 perpetual trading protocol on Polygon, recording take-profit and stop-loss fills with position details and profit/loss in DAI stablecoin. Used for analyzing trader performance, leverage usage, and automated order execution patterns.
| 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_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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| in\_t | address | removed | in\_price | log\_index | in\_orderId | block\_number | in\_nftHolder | in\_orderType | in\_limitIndex | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | ------- | ------------- | ---------- | ----------- | ------------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | --------------------- | --------------------- |
| \{"sl":"0","tp":"5380000000","buy":true,"index":"0","trader":"0x6f9b961c6aa36fe989b3adbc3ade71501951da5e","leverage":"37","openPrice":"5282491243","pairIndex":"19","initialPosToken":"152819574531920935856","positionSizeDai":"359048000000000000000"} | 0x6805dd635aa542210ed572f7b93121002c629690 | false | 5380000000 | 261 | 1496693 | 34137592 | 0xb00d3c75969f6d8f6531e352e82f1dd1488b47be | 0 | 0 | 2022-10-09T18:53:43.000Z | 0 | 682977754819 | 0x42ad79fdf05c42b30dc38aed7e570eda5e96500fdd5f2bfb05647907a2d12655 | 591890361683162375987 | 359047999999999999998 |
| \{"sl":"0","tp":"64228483666","buy":true,"index":"0","trader":"0x1f5e2d8f5177b374958e20796072ad0b29f47472","leverage":"150","openPrice":"64008969765","pairIndex":"11","initialPosToken":"18677502904297990802","positionSizeDai":"43120000000000000000"} | 0x6805dd635aa542210ed572f7b93121002c629690 | false | 64228483666 | 148 | 1496582 | 34130989 | 0x7ca659f1d19bbc342dd1027104e27cf4cdb38739 | 0 | 0 | 2022-10-09T15:06:42.000Z | 0 | 514413609075 | 0x914071538ff16e7e506e1bc8d044567c453d72c1dab48ce63042f94e2a7d87eb | 60085006291807923887 | 43119999999999999997 |
| \{"sl":"0","tp":"8792400000000","buy":true,"index":"0","trader":"0x1e742285cc17bad26a307b4c781c96d29f0b3c21","leverage":"20","openPrice":"8716000000000","pairIndex":"41","initialPosToken":"32392833481100902538","positionSizeDai":"73800000000000000000"} | 0x6805dd635aa542210ed572f7b93121002c629690 | false | 8792400000000 | 151 | 1496355 | 34119140 | 0x7ca659f1d19bbc342dd1027104e27cf4cdb38739 | 0 | 0 | 2022-10-09T08:10:39.000Z | 0 | 175309775126 | 0x45c98a93697f6f11749aa3b914756c357bb96f551a850069d9d670efee4e6f8b | 88094517859163698739 | 73799999999999999998 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV2_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV2\_LpFeeCharged\_event
Liquidity provider fee events from Gains Network v7 leveraged trading protocol on Polygon, recording DAI-denominated fees charged per trade execution. Useful for analyzing LP revenue distribution and protocol fee structure.
| 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_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 3 | 487999999999999999 | 34716283 | 2022-10-23T21:51:16.000Z | 0x582a656f6d0c1e94164e6201c6ec232354255715f1f8fc2e5c7d94b69347f0ba |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 3 | 220499999999999999 | 34684841 | 2022-10-23T03:27:54.000Z | 0xb00d1530bc9fac21d2a0d2ff48eed4645fd6fd92922dc9c8e51859897e1226f1 |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 3 | 188373023999999999 | 34718361 | 2022-10-23T23:02:45.000Z | 0x6e293a2ae75c2cb0ff711554b79cb6095c66f312a105a1b666df8e1870b50204 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV2_LpFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV2\_MarketExecuted\_event
Market order execution events from Gains Network (gTrade) V7 perpetual trading protocol on Polygon. Contains position open/close details including leverage, profit/loss, price impact, and DAI settlement amounts for analyzing trader behavior and execution quality.
| 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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| in\_t | address | in\_open | removed | in\_price | log\_index | in\_orderId | block\_number | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | -------- | ------- | -------------- | ---------- | ----------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------- | -------------------- |
| \{"sl":"367217685000","tp":"371830972500","buy":true,"index":"0","trader":"0x014f5918c712505d4d557402ede7f88671c61a42","leverage":"100","openPrice":"368773065668","pairIndex":"33","initialPosToken":"11660680700801439737","positionSizeDai":"46000000000000000000"} | 0x6805dd635aa542210ed572f7b93121002c629690 | true | false | 368773065668 | 11 | 1567236 | 35249749 | 2022-11-05T23:19:01.000Z | 198171056 | 0 | 0x77adf88db5348bac99e59259150562147167812c1982ed0c8b01d6f4b1b26962 | 0 | 45999999999999999996 |
| \{"sl":"365729165000","tp":"371242670000","buy":true,"index":"0","trader":"0x014f5918c712505d4d557402ede7f88671c61a42","leverage":"100","openPrice":"367766995076","pairIndex":"33","initialPosToken":"11589832806834591002","positionSizeDai":"46000000000000000000"} | 0x6805dd635aa542210ed572f7b93121002c629690 | true | false | 367766995076 | 15 | 1567000 | 35245618 | 2022-11-05T20:49:45.000Z | 454284757 | 0 | 0x35c5f19ed65bb3300640b541a59beaaa1033f6a0e867fe28edc4b4b7ae6b13d2 | 0 | 45999999999999999998 |
| \{"sl":"16233425000000","tp":"16437362500000","buy":true,"index":"0","trader":"0x014f5918c712505d4d557402ede7f88671c61a42","leverage":"100","openPrice":"16315874309970","pairIndex":"1","initialPosToken":"11569009141262985077","positionSizeDai":"46000000000000000000"} | 0x6805dd635aa542210ed572f7b93121002c629690 | true | false | 16315874309970 | 81 | 1567045 | 35246523 | 2022-11-05T21:21:41.000Z | 752858876 | 0 | 0xf8fe5dbeb9aa4207e6b64a42587ab53ab0a293fc3351a01796efffc979b816a9 | 0 | 45999999999999999999 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV2_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV2\_NftBotFeeCharged\_event
NFT bot execution fees charged in DAI on Gains Network v7 perpetual trading protocol on Polygon. Tracks automated bot operator compensation for executing limit orders and stop losses.
| 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_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 8 | 569600000000000000 | 34210216 | 2022-10-11T12:58:07.000Z | 0xd9e4275af84474c54b543671921e4dc793f7b50a2e02fe47d3a72b95ff95099a |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 14 | 300000000000000000 | 34226713 | 2022-10-11T22:27:57.000Z | 0x359794aa817ec9ac65882b7bf485c32a4c1d1517bddf4883d5d9ee9e00d76396 |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 14 | 528000000040499999 | 34188432 | 2022-10-11T00:17:53.000Z | 0xeb9ff0bd0d83a5c10e9165455a4cd320fbf19e0b77a955cb9a032c729b9d1d04 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV2_NftBotFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV2\_ReferralFeeCharged\_event
Referral fee charges from Gains Network (gTrade) v7 perpetual trading protocol on Polygon, denominated in DAI with 18 decimal precision. Tracks commission payments to referrers when their referred traders execute positions.
| 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_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 5 | 7097945097000000000 | 36337179 | 2022-12-02T14:06:04.000Z | 0x6637bcd41f72e17ee3713a931475956c32a166418c281e06efce0467f15fe233 |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 10 | 1881584712500000000 | 36350846 | 2022-12-02T22:22:26.000Z | 0x84c6bcf83a712e564f6dd4967dc6b6d9322ce808290868c1267a1fd0ef83792a |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 16 | 1374636439200000000 | 36338330 | 2022-12-02T14:48:20.000Z | 0x4f1b389878f8dd68fe15360ce18362658bde3bcaab3e34246938dde9f11d2d08 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV2_ReferralFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV2\_SssFeeCharged\_event
SSS (spread, slippage, and system) fee charges from Gains Network v7 perpetual trading protocol on Polygon. Tracks DAI-denominated fees collected per trade for analyzing protocol revenue and trading costs.
| 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_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 6 | 334800000000000000 | 33733623 | 2022-09-30T00:33:38.000Z | 0xf540fee8283149d8863b2703166c89c36c973978f14f7a525dd89148ed1c3c25 |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 6 | 5000000000000000000 | 33770771 | 2022-09-30T22:16:07.000Z | 0x98b626c80ed1e0a83c110de3f254550e73c373864a0cd2105b70015352ec2930 |
| 0x6805dd635aa542210ed572f7b93121002c629690 | false | 6 | 9468000000000000000 | 33757727 | 2022-09-30T14:38:23.000Z | 0x445027bfe88ca339e754d284b04e125a74eeb88e3adf5b9b17397e9a505d30ec |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV2_SssFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_DevGovFeeCharged\_event
Development and governance fee charges from Gains Network v7 perpetual trading protocol on Polygon. Records DAI-denominated fees collected from traders, useful for analyzing protocol revenue and fee distribution patterns.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x00c62977286812f359805a741f850c4aecbe22c8 | 65 | 8610000000000000000 | 38453003 | 2023-01-24T02:56:20.000Z | 0x135734c47b6e2f0ce20cc5e537b40873272d382b364be9847766dc68aa048dbb |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x015f6d443fc7384c1454a2c15d6e7acad97e5358 | 73 | 11520000000000000000 | 38467477 | 2023-01-24T11:33:08.000Z | 0xac588457d111aa0ae0e649a1a5d46edc7d2ca8be2faaaa049d925184b323515f |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x01b30ca1bdde1f68abe69c46fe88f79b496ec63a | 81 | 1782000000000000000 | 38451426 | 2023-01-24T01:58:53.000Z | 0x41609248dddd3601458015d1dd6ccdc090439430992a761847557a2b5ac988cd |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3_DevGovFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_LimitExecuted\_event
Limit order execution events from Gains Network (gTrade) v7 perpetual trading protocol on Polygon, capturing take-profit, stop-loss, and pending order fills with position details and profit/loss outcomes. Used for analyzing trader limit order strategies and execution quality across leveraged positions.
| 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_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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| in\_t | address | removed | in\_price | log\_index | in\_orderId | block\_number | in\_nftHolder | in\_orderType | in\_limitIndex | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | ------- | --------------- | ---------- | ----------- | ------------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | --------------------- | --------------------- |
| \{"sl":"226935720000000","tp":"245000000000000","buy":true,"index":"0","trader":"0x007d142b804c417bc177b394d80e8922e17aa23d","leverage":"10","openPrice":"229217750440000","pairIndex":"0","initialPosToken":"32045967449323986096","positionSizeDai":"153760000000000000000"} | 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 226935720000000 | 113 | 1787177 | 38486517 | 0x3755d7c8f37eced3a3d2e6062d43674ba2ac61a6 | 1 | 0 | 2023-01-24T23:09:47.000Z | 0 | -99557317686 | 0x4a014ebf8a8b2fb01d5a88d4b1c64f8f79dfa1196e9a85059ec39adefa5931e7 | 137145357119359740999 | 153759999999999999998 |
| \{"sl":"0","tp":"261574968750000","buy":true,"index":"0","trader":"0x015f6d443fc7384c1454a2c15d6e7acad97e5358","leverage":"64","openPrice":"229371962100000","pairIndex":"0","initialPosToken":"60443116422840111469","positionSizeDai":"284640000000000000000"} | 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 226059000000000 | 54 | 1787220 | 38486762 | 0x7676d49df89c7cf60953beb193724bd6403b8eb0 | 2 | 0 | 2023-01-24T23:18:34.000Z | 0 | -924391858790 | 0xb87f98db23494113fff867c44aa9b7c9f4374d39d61c59e450af81e15d92a349 | 0 | 284639999999999999995 |
| \{"sl":"0","tp":"58667076000","buy":true,"index":"0","trader":"0x01989c3c9949263da86ada9d96ea1a067d3b1c68","leverage":"50","openPrice":"58366682904","pairIndex":"55","initialPosToken":"139705533476006454884","positionSizeDai":"672000000000000000000"} | 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 57263000000 | 55 | 1786324 | 38481748 | 0xd31bbd976efdf03496381906d55a6a70a6c805c1 | 2 | 0 | 2023-01-24T20:17:22.000Z | 0 | -945473384032 | 0x9443b5dcafdba07937fa5dec705bf800e57e7b46d15f221b92b15d675cbe5ae4 | 0 | 671999999999999999996 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_LpFeeCharged\_event
Liquidity provider fee events from Gains Network v7 perpetual trading protocol on Polygon, denominated in DAI. Tracks fees charged to traders for providing liquidity depth, useful for analyzing LP revenue and trading cost structure.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x08787e3157742bec8d50cca49c8dfaf01cd6dabf | 10 | 1596291375000000000 | 37251617 | 2022-12-25T08:19:10.000Z | 0x5bb75b95793f15d703ce6a631af915f58bb68d8860846dea21e69b3dcc0955ef |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x0c06dd9d31013ca249535c1c538ead6974772304 | 277 | 441599999999999999 | 37262031 | 2022-12-25T14:35:19.000Z | 0x1b1078af6aef3573b3b4b97d446af23d0e33ccbd1c096277a718bc1a73f40a23 |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x0da76cbaeff1d40871d18498a6f26e5aa96961e9 | 23 | 4988159999999999999 | 37270367 | 2022-12-25T19:41:17.000Z | 0xb3cbe9837bddc1e1b2633c9d82900e8843fdfeef6599c2833402fbc92d1c6ea3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3_LpFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_MarketExecuted\_event
Market order execution events from Gains Network V7 perpetual trading protocol on Polygon. Records position opens/closes with execution price, profit/loss, leverage, and trader details for analyzing trade outcomes 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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| in\_t | address | in\_open | removed | in\_price | log\_index | in\_orderId | block\_number | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | -------- | ------- | --------------- | ---------- | ----------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | --------------------- | --------------------- |
| \{"sl":"211120000000000","tp":"208700000000000","buy":false,"index":"0","trader":"0x011c79c3f951dc3d26fb08d226b60a7653753a95","leverage":"100","openPrice":"210055782237995","pairIndex":"0","initialPosToken":"13935280365629817504","positionSizeDai":"47840000000000000000"} | 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | true | false | 210055782237995 | 15 | 1754888 | 38156701 | 2023-01-16T15:49:32.000Z | 472117066 | 0 | 0x197a878c611898aa0e23348d5d6bdd2ee5dea41efe968e796c1de0eabc0ab41e | 0 | 47839999999999999998 |
| \{"sl":"0","tp":"8594349800","buy":false,"index":"0","trader":"0x011c79c3f951dc3d26fb08d226b60a7653753a95","leverage":"150","openPrice":"8645031423","pairIndex":"37","initialPosToken":"2538602866828051224","positionSizeDai":"8800000000000000000"} | 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | true | false | 8645031423 | 72 | 1756207 | 38166750 | 2023-01-16T21:46:40.000Z | 516628401 | 0 | 0xafdda28ca1163ea6863fb46428ab40b469ac947cce01cb88e668f6b63c992a3f | 0 | 8799999999999999998 |
| \{"sl":"15670000000000","tp":"0","buy":true,"index":"1","trader":"0x01f699f01e346e84864413850a3b8272b353ef87","leverage":"15","openPrice":"15994214545979","pairIndex":"1","initialPosToken":"57119992749223604241","positionSizeDai":"197600000000000000000"} | 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | false | 15792800000000 | 54 | 1756090 | 38166151 | 2023-01-16T21:26:06.000Z | 0 | -188894439361 | 0xe72eadb4ecc051fff80430c46b23e4ad53a9b697992ae56f20d6fba43c5f9b6c | 157499953196891344013 | 197155399999999999999 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_NftBotFeeCharged\_event
NFT bot execution fees charged on Gains Network v7 perpetual trading protocol on Polygon, denominated in DAI. Records automated trading bot fees with trader addresses and fee amounts in 18-decimal DAI format for analyzing bot-assisted trading costs.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x0052d2e4af4548e6cf19e817b944cedb23ae09df | 441 | 292799999999999999 | 41204560 | 2023-04-06T08:00:50.000Z | 0xbd97feacd613fb4a55d6b46769586f0e98ae14b59e025ebd432f4622c491db86 |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x0052d2e4af4548e6cf19e817b944cedb23ae09df | 187 | 292799999999999999 | 41193745 | 2023-04-06T01:31:53.000Z | 0x0576d234eb1efbd20c3f1c259f454b726128298df1399817b8ab237f0ce9d6c5 |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x02df44db75d2b06e6f80797ae3ee4609a0235f66 | 519 | 158015999999999999999 | 41204239 | 2023-04-06T07:48:54.000Z | 0xa31a9a26a36fedb2bdf56d06c093c6aafea258c10e84f7cd4c913b39f79643d6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3_NftBotFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_ReferralFeeCharged\_event
Referral fee charges from Gains Network (GNS) v7 perpetual trading protocol on Polygon, recording DAI-denominated commission amounts paid when traders execute positions through referral links. Used to track referral program economics and trader acquisition costs.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x032a8848cecee8e915d57148cee6f5b7935e843f | 121 | 232598148000000000 | 41109785 | 2023-04-03T21:46:22.000Z | 0x4587f26deda8c1771f750c0f99634821013e6212d5989fc61ac84426b762deb5 |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x032a8848cecee8e915d57148cee6f5b7935e843f | 128 | 255844487250000000 | 41086997 | 2023-04-03T07:27:39.000Z | 0x52049a004cf0a216cc3bfd8cc6d237f8b639afef1083b80731e64b1f118cfcc1 |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x05bb4f77f69b6f85b334fc03ef16b8b3bb2bab7a | 16 | 232592555160000000 | 41107011 | 2023-04-03T19:57:55.000Z | 0x474a9ad6c84a1767149cf0d35c7e669c4b1dd575eb1b44567efd96b445bfc24c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3_ReferralFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_SssFeeCharged\_event
SSS (Spread Staking System) fee charges from Gains Network v7 perpetual trading protocol on Polygon. Records DAI-denominated fees collected per trader for analyzing protocol revenue and trading costs.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x01ba06eb3b222abb1a4b66f3a2f94f2311a4ea5c | 146 | 1106079999999999998 | 40425451 | 2023-03-16T20:54:13.000Z | 0xa99dc81c6b5013573d14ac526ae2ef44aa4f4b236d762adab8d12ae44400a56f |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x01ba06eb3b222abb1a4b66f3a2f94f2311a4ea5c | 97 | 787200000000000000 | 40425732 | 2023-03-16T21:04:43.000Z | 0x5a01df09c47d1b68a6d0b14b2df761d4990ddb615d80cd5bd84bace9dcafa02d |
| 0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa | false | 0x01ba06eb3b222abb1a4b66f3a2f94f2311a4ea5c | 17 | 766087199999999998 | 40418596 | 2023-03-16T16:41:14.000Z | 0x2b08328e17db416c1ad2f4c2778ae94847d7762cbe5dc0a0c053be45c84aeb7e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3_SssFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_DevGovFeeCharged\_event
Development and governance fee charges from Gains Network v7 on Polygon. Records DAI-denominated fees collected from traders, useful for analyzing protocol revenue and fee distribution.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x01c594464a822c36d20bd42e05e4dd76144bbeae | 28 | 1020000000000000000 | 41483102 | 2023-04-13T12:03:22.000Z | 0x3c138dcf294de3e6ebadd4d2d62383b7a055cd755a431ecb2898c67adf706e0b |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x01c594464a822c36d20bd42e05e4dd76144bbeae | 116 | 2490000000000000000 | 41485085 | 2023-04-13T13:24:16.000Z | 0xbb41906273f3d9d2340a28600fd39d82c65981d41ecb9bfb60be78ed2406206e |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x01c594464a822c36d20bd42e05e4dd76144bbeae | 85 | 4020000000000000000 | 41484745 | 2023-04-13T13:11:10.000Z | 0x457b6bdb620b4ef2f3199473e6869c2894e622a1f2c71fc13d4855569fb47b26 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v1_DevGovFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_LimitExecuted\_event
Limit order execution events from Gains Network (gTrade) v7 perpetual futures protocol on Polygon, capturing stop-loss and take-profit order fills with entry/exit prices, position sizes in DAI stablecoin, profit/loss percentages, and NFT bot executor addresses for analyzing automated trade closures.
| 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_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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| in\_t | address | removed | in\_price | log\_index | in\_orderId | block\_number | in\_nftHolder | in\_orderType | in\_limitIndex | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | --------------- | ---------- | ----------- | ------------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ---------------------- | ---------------------- |
| \{"sl":"271218000000000","tp":"267334000000000","buy":false,"index":"0","trader":"0x2103a7ea588c939724f42e959ddb3b2e402351f8","leverage":"3","openPrice":"267951826380000","pairIndex":"0","initialPosToken":"390370467807942110407","positionSizeDai":"1562241600000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 271218000000000 | 493 | 2073201 | 44111277 | 0xfe3be3c5d37c3610a8491e241953b57da9c8e09e | 1 | 0 | 2023-06-20T01:13:57.000Z | 0 | -36568218221 | 0xdd6fe3d0435de3d9f7dbd33a20915cc5c37510e0c2c50a15445fcf8058e65146 | 1500582951381172924671 | 1561538591280000000000 |
| \{"sl":"17252560855263","tp":"17537256578947","buy":true,"index":"0","trader":"0x7e087274232dd9378b6f1b972f58f8d419acc5b6","leverage":"76","openPrice":"17303018440000","pairIndex":"1","initialPosToken":"4695829426344002767","positionSizeDai":"18784000000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 17252560855263 | 53 | 2073587 | 44119312 | 0x2430403186b3a9e08ba7264fbb924447cb7a31d6 | 1 | 0 | 2023-06-20T06:10:12.000Z | 0 | -221624709775 | 0x8757b6951a593b9dc7c460c1d0d668dbef5a4e98d9f71da3db6832e41573ffe4 | 13025012875183904002 | 18783999999999999998 |
| \{"sl":"10550000000","tp":"11110000000","buy":true,"index":"0","trader":"0x7490da388759d3b069546cf45dc10d40d706bd79","leverage":"4","openPrice":"10020312691","pairIndex":"109","initialPosToken":"124819884309165177999","positionSizeDai":"498400000000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 10550000000 | 172 | 2074802 | 44139889 | 0x4eaca3a7fca2b5448c0687f2f4d13980bc0c198f | 1 | 0 | 2023-06-20T19:06:07.000Z | 0 | 211445421049 | 0xd1b7a379616700fbe7b86dd72fef554af098b2f7b799e10343fe31f5887d940a | 598627030742859022521 | 497802099424000000004 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v1_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_LpFeeCharged\_event
*No description available.*
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v1_LpFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_MarketExecuted\_event
Market order execution events from Gains Network v7 perpetual futures protocol on Polygon. Records position opens and closes with execution price, profit/loss, and collateral flows in DAI for analyzing trader performance and leverage usage.
| 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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| in\_t | address | in\_open | removed | in\_price | log\_index | in\_orderId | block\_number | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | -------- | ------- | ------------- | ---------- | ----------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | --------------------- | --------------------- |
| \{"sl":"0","tp":"637500000000","buy":false,"index":"0","trader":"0x98151e452414756a0fe795dbc51f876fcc3963a8","leverage":"8","openPrice":"1020000000000","pairIndex":"105","initialPosToken":"126881778614519360882","positionSizeDai":"496800000000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | false | 1000640000000 | 75 | 2061833 | 43836802 | 2023-06-12T19:03:06.000Z | 0 | 151843137254 | 0xf4b764dc51a08f93063f1a84706aaaba090160aa33ceed1156bd308fc1e02511 | 558958087216238399998 | 496799999999999999996 |
| \{"sl":"0","tp":"10852904900","buy":true,"index":"0","trader":"0xdc1b9a875e97987f637f5dbc5660dd7990c8830e","leverage":"1000","openPrice":"10756825575","pairIndex":"21","initialPosToken":"11013867568241254817","positionSizeDai":"43120000000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | true | false | 10756825575 | 14 | 2061541 | 43830944 | 2023-06-12T15:14:13.000Z | 0 | 0 | 0xa1037fe7c1978b14c4197c6d962404184fa6e2d3ad99cb88601bc106218bbb10 | 0 | 43119999999999999997 |
| \{"sl":"11742093000","tp":"11950000000","buy":true,"index":"0","trader":"0x3331deca24e58144114e250c4598f99b77cc1ed9","leverage":"25","openPrice":"11850657643","pairIndex":"104","initialPosToken":"25207343704631801097","positionSizeDai":"98000000000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | true | false | 11850657643 | 25 | 2061861 | 43837400 | 2023-06-12T19:26:39.000Z | 55497345 | 0 | 0x5b3c7365380f63124ed2f9cb27cdac366b2f31f5a1186650a20cb2e835f421a8 | 0 | 97999999999999999997 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v1_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_NftBotFeeCharged\_event
NFT bot fee charges from Gains Network V7 trading callbacks on Polygon, recording DAI-denominated fees paid by traders for automated bot execution services. Useful for analyzing bot usage costs and trader automation patterns.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x0052d2e4af4548e6cf19e817b944cedb23ae09df | 34 | 296399999999999999 | 46625784 | 2023-08-22T17:43:24.000Z | 0xf1b1ec3a2ac664ed4d847cbe5ce49cbf4a3ba7a941ae8ecb56a7c2be12c727c6 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x01c594464a822c36d20bd42e05e4dd76144bbeae | 106 | 318719999999999999 | 46623351 | 2023-08-22T16:14:14.000Z | 0x66955583783755b965a26e17d405fe45e3b7a9660c906ac3d393f4d26874c216 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x01c594464a822c36d20bd42e05e4dd76144bbeae | 223 | 318719999999999999 | 46619683 | 2023-08-22T14:01:29.000Z | 0xe6625133b1382ed0252edd787860ba779676cef72a82fd2f02778655d947d41f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v1_NftBotFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_ReferralFeeCharged\_event
Referral fee records from Gains Network (GNS) v7 trading protocol on Polygon, tracking DAI-denominated commissions charged on referred trades. Used for analyzing referral program performance and fee distribution across traders.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x7a4b9ea38a09940f8db81199c7461494c679320e | 86 | 236793087168000000 | 46835687 | 2023-08-28T00:14:39.000Z | 0x0adb41e721081ef7445f1964ada952504fed17da7967b4c3894d69270be06bd7 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x99447c9f0b854aa6e1345f0821bac2073d858c6d | 79 | 450584610000000000 | 46857059 | 2023-08-28T12:53:15.000Z | 0x6e601a09e5f2bd4d4e972807226fd13b78b5cb17fb8dc43b9332afc628e93c3f |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x99447c9f0b854aa6e1345f0821bac2073d858c6d | 119 | 450629160000000000 | 46862382 | 2023-08-28T16:02:26.000Z | 0xf0c8fb1a35677c11b3b7e105a1712842424849856add883a80d5492224c35bd4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v1_ReferralFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_SssFeeCharged\_event
SSS (Spread, Spread Reduction, Slippage) fee charges from Gains Network v7 perpetual trading protocol on Polygon. Tracks DAI-denominated fees collected per trader for analyzing protocol revenue and trading costs.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x006530596df1ca46f52f15478e98a88ebb4a85f6 | 37 | 731999999999999998 | 44962161 | 2023-07-11T19:56:28.000Z | 0x40b6c4e2a98832ee8ce87bcb72eaf529848aadb46bad34f266335327d9bb1707 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x041ecb817dde8d90e5bba77b056b019fa64c2d27 | 7 | 1080000000000000000 | 44929947 | 2023-07-11T00:28:22.000Z | 0x7cc75f25f9d6ddf11f9e8ae0334298d760309eaca40b368b94bf8bce26e15cf0 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x041ecb817dde8d90e5bba77b056b019fa64c2d27 | 84 | 1490399999999999999 | 44932239 | 2023-07-11T01:51:18.000Z | 0x9f8b39be06556d376e0f22014c4fc63980aa2044ed83575f33b831363ffaf955 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v1_SssFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v2\_LimitExecuted\_event
Limit order execution events from Gains Network v7 perpetual trading protocol on Polygon, capturing take-profit and stop-loss fills with prices, P\&L, and collateral settlements. Used for analyzing trader performance, order execution quality, and automated position management 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_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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| `in_collateralPriceUsd` | `STRING` | USD price of the collateral token used in the position. String-encoded value representing price with extended precision. |
| `in_exactExecution` | `BOOL` | Whether the limit order was executed at the exact trigger price specified by the trader. False indicates the order was filled at a slightly different price due to market conditions. |
| in\_t | address | removed | in\_price | log\_index | in\_orderId | block\_number | in\_nftHolder | in\_orderType | in\_limitIndex | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_exactExecution | in\_daiSentToTrader | in\_positionSizeDai | in\_collateralPriceUsd |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ------------- | ---------- | ----------- | ------------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | ------------------ | ---------------------- | --------------------- | ---------------------- |
| \{"sl":"0","tp":"1393631666666","buy":false,"index":"0","trader":"0x34b4dec560c27dc0468e52ebd5c2597f70819a9d","leverage":"9","openPrice":"1479181699274","pairIndex":"51","initialPosToken":"46530991625282312046","positionSizeDai":"248200000000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 1393631666666 | 154 | 229834059 | 53186522 | 0xfe24cfb2f8872e9ed097c451de065a9f6048915b | 0 | 0 | 2024-02-06T09:05:51.000Z | 0 | 520524485835 | 0x5b1f0a1e9870d7a8fe21db9652b2cf89bdedc714d26b8238d4cab247ab1ad6cd | true | 375594716685585999995 | 248199999999999999995 | 99998800 |
| \{"sl":"1805963310399","tp":"1420000000000","buy":false,"index":"0","trader":"0x107f8b36ccc1997be2c1a76d5cd6760d57e35021","leverage":"10","openPrice":"1679965870139","pairIndex":"51","initialPosToken":"33292910011842294700","positionSizeDai":"148899200000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 1420000000000 | 354 | 229834042 | 53185715 | 0xa2fb99d7da1550e439b60cdade83216134233a6b | 0 | 0 | 2024-02-06T08:37:02.000Z | 0 | 1547447330685 | 0xd2b6fdbd4a2964f3746bf8e1531d98901010a7539a370b481b0e493505619b3b | true | 377547954988519439995 | 148899199999999999997 | 99998800 |
| \{"sl":"1806000000000","tp":"1420000000000","buy":false,"index":"0","trader":"0xae1bb7816ec1a0078161e5034f1153c8755f0117","leverage":"5","openPrice":"1679829964983","pairIndex":"51","initialPosToken":"200429314157600799531","positionSizeDai":"896400000000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 1420000000000 | 317 | 229834043 | 53185715 | 0xa2fb99d7da1550e439b60cdade83216134233a6b | 0 | 0 | 2024-02-06T08:37:02.000Z | 0 | 773381742198 | 0x8f43c06012ee19f3bb2817cc7bf23fb769c3df3735affcbac745a866582cb782 | true | 1584346841856385199995 | 896399999999999999996 | 99998800 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v2_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v2\_MarketExecuted\_event
Market order execution events from Gains Network v7 perpetual trading protocol on Polygon. Records trade fills with entry/exit prices, profit/loss, leverage ratios, and DAI settlement amounts for analyzing trader performance and position lifecycle.
| 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_priceImpactP` | `STRING` | Price impact of the trade expressed as a percentage. String-encoded value representing the slippage or market impact caused by the position size relative to available liquidity. |
| `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_daiSentToTrader` | `STRING` | Amount of DAI sent to the trader upon position closure or settlement. String-encoded value representing the DAI transfer amount with extended precision for decimal representation. |
| `in_collateralPriceUsd` | `STRING` | USD price of the collateral token used in the position. String-encoded value representing price with extended precision. |
| in\_t | address | in\_open | removed | in\_price | log\_index | in\_orderId | block\_number | block\_timestamp | in\_priceImpactP | in\_percentProfit | transaction\_hash | in\_daiSentToTrader | in\_positionSizeDai | in\_collateralPriceUsd |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | -------- | ------- | ------------ | ---------- | ----------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ | -------------------- | --------------------- | ---------------------- |
| \{"sl":"0","tp":"9939141666","buy":false,"index":"0","trader":"0x26d754f9ae6f65c43d63b62e6ffa0c8ed1219db5","leverage":"108","openPrice":"10842015690","pairIndex":"21","initialPosToken":"20923231311636024155","positionSizeDai":"92683056000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | false | 10840113000 | 112 | 229908408 | 55465364 | 2024-04-05T07:59:06.000Z | 0 | 18953165709 | 0xa31eeccb17d99e58bb18d6faa463631d41fc1846409de1d31e613275a1922fc0 | 92834119366412383918 | 92683055999999999996 | 99987148 |
| \{"sl":"10850000000","tp":"10792800000","buy":false,"index":"0","trader":"0x9f54debfaf5aa35f05b1a81e5503913bca00aaa3","leverage":"309","openPrice":"10849176974","pairIndex":"21","initialPosToken":"7339895987183795061","positionSizeDai":"34183660000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | false | 10817725000 | 122 | 229908567 | 55472767 | 2024-04-05T12:44:16.000Z | 0 | 895796979742 | 0xea23c0298eb4fa7553bee323f2a02206c5c677ed07dff62ceb2bdaefaf6ba5a1 | 63248537084331103819 | 34183659999999999998 | 99980649 |
| \{"sl":"176402812500","tp":"95823750000","buy":false,"index":"0","trader":"0xf39e430928ee5ea67957a4d972e4cf9ef8d01442","leverage":"20","openPrice":"174141152346","pairIndex":"2","initialPosToken":"38871694558755777826","positionSizeDai":"173676000000000000000"} | 0x82e59334da8c667797009bbe82473b55c7a6b311 | true | false | 174141152346 | 54 | 229908724 | 55480483 | 2024-04-05T17:38:26.000Z | 26516032 | 0 | 0x21796acf410e9abc45a8b8b1007a5122695904b4382d8a73fdf1cfb4ee7f6ea8 | 0 | 173675999999999999998 | 99994437 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV3v2_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_BorrowingFeeCharged\_event
Borrowing fee events from Gains Network V7 perpetual trading protocol on Polygon, recording fees charged to traders on leveraged positions denominated in DAI. Used to analyze borrowing costs, position funding rates, and trader fee exposure across the platform.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tradeValueDai` | `STRING` | Dollar-denominated value of the trader's position at the time the borrowing fee was charged, expressed in DAI stablecoin with 18 decimal precision. Represents the notional size of the leveraged trade being assessed for borrowing costs. |
| `in_feeValueDai` | `STRING` | DAI-denominated borrowing fee charged to the trader for holding a leveraged position on Gains Network. Value is in wei (18 decimals), representing the cost assessed based on the position's size and duration. |
| address | removed | in\_trader | log\_index | block\_number | in\_feeValueDai | block\_timestamp | in\_tradeValueDai | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------ | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x006530596df1ca46f52f15478e98a88ebb4a85f6 | 490 | 51048740 | 118002717241499999 | 2023-12-12T14:45:34.000Z | 144448496555044499999 | 0xec1b581586b94eb323f98da7941bbba5464f87e371e22ff47a63c78e800ff299 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x006530596df1ca46f52f15478e98a88ebb4a85f6 | 481 | 51062294 | 5943450896879999 | 2023-12-12T23:12:01.000Z | 176787257945677439999 | 0x4c4dfde346e318fc647826457ac7627898b28ee4d7a1c78f5a57930a706587d9 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x041ecb817dde8d90e5bba77b056b019fa64c2d27 | 176 | 51052623 | 85177637248087999 | 2023-12-12T17:08:59.000Z | 74354031298040736000 | 0xa39e7a665edd6bd49661b6339eae17730d2e37b9b00b4c7c985bfb7f63943f33 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV4v1_BorrowingFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_DaiVaultFeeCharged\_event
DAI vault fee charge events from Gains Network v7 trading protocol on Polygon, recording fees collected from traders in DAI stablecoin. Used for analyzing protocol revenue, trader fee costs, and vault performance metrics.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0xc7cf4fae2b6ba8f67147ec81b1631775b5b265a9 | 142 | 718271999999999999 | 51997145 | 2024-01-06T06:45:11.000Z | 0x811c00e782fe2f5dea7315ed036d86693aa95bb448f105c1451ac9cbdcad479b |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0xe4a5859e0ec2d52e7371e55f4210dda5dcaef82a | 73 | 2221839359999999999 | 51999814 | 2024-01-06T08:20:19.000Z | 0x6a4f3f42916296a8cf9d1dcb2c007980a57152e210514d77ed437b2cad9ad27b |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x3ba3e60875becf48efc6ef3e9e3d05f102ec329a | 73 | 14453999999999999999 | 51986092 | 2024-01-06T00:01:51.000Z | 0x26ac21bf2102a8fc9d50378d8bcda0cea2871252da17674ba7438fe3ec141a08 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV4v1_DaiVaultFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_GovFeeCharged\_event
Governance fee charges from Gains Network v7 perpetual trading protocol on Polygon, denominated in DAI stablecoin. Tracks protocol revenue collection from traders with fee amounts and distribution status for analyzing platform economics.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| `in_distributed` | `BOOL` | Indicates whether the governance fee has been distributed to the protocol's fee recipients. Value is true in all sample transactions, suggesting immediate distribution upon fee collection. |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | in\_distributed | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x07fddfdf8f583b87e0b8ad3fb7adf3918e1ffdad | 306 | 498300000000000000 | 56805503 | true | 2024-05-10T14:50:02.000Z | 0xe5079b95e83e3fd283319adb9731314af25048326190f688387c965ea33c87c4 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x0e524b070a1e8faf71d953d75b250b4a1646660e | 481 | 489750000000000000 | 56805478 | true | 2024-05-10T14:49:10.000Z | 0x028e6e4f2aeebc63e8a18062e54b624b448047f0cf2e8b1de806535b2082817b |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x1270951dbbe92faed7893026bf30c9d29894a45f | 215 | 796575000000000000 | 56819355 | true | 2024-05-10T23:06:39.000Z | 0xbe76bb1514986417e8dd689ccdcd13552a4f237fc9dfb20a3fd8aba23c9f3959 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV4v1_GovFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_ReferralFeeCharged\_event
Referral fee payment events from Gains Network v7 perpetual futures protocol on Polygon, denominated in DAI. Tracks commission charges for referred traders with fee amounts in wei format for analyzing referral program economics.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x222a227a5dc77c643e836556e573cb266998a870 | 35 | 569363983200000000 | 43022768 | 2023-05-22T18:57:13.000Z | 0xf7a4ff80287d2b31553d0ead4f18983b4391d51e78f39758567bb03e76d0edb8 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x222a227a5dc77c643e836556e573cb266998a870 | 128 | 561393769500000000 | 42994899 | 2023-05-22T00:54:13.000Z | 0xd4a80825fdd2fa82bb8fb5dac3949470819bcb950c38acb5b74762182911b9dc |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x5b8e1306bd9f143941b8698032ca41529580309e | 53 | 364320000000000000 | 43017103 | 2023-05-22T15:06:11.000Z | 0xc7b420077d70b3464b54f10547d671ba52444316dfe939052d413799cf6451cf |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV4v1_ReferralFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_SssFeeCharged\_event
Spread, slippage, and swap (SSS) fee events from Gains Network v7 perpetual trading protocol on Polygon. Tracks DAI-denominated fees charged to traders for analyzing protocol revenue and trading costs.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x041ecb817dde8d90e5bba77b056b019fa64c2d27 | 135 | 1222500000000000000 | 53515058 | 2024-02-14T14:40:11.000Z | 0x18d66781af412e26d83eee8682d0094eaffcc36d5bd1d6b0706788a3e0d1cbcf |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x08b08d7254909830dde8906bfa05187f58ac8421 | 409 | 10724255999999999998 | 53505858 | 2024-02-14T08:58:09.000Z | 0xa0ab347ac81ec1cbda748fffb8c21fb0c6bef5cf369d509bab892011e32df271 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x08b08d7254909830dde8906bfa05187f58ac8421 | 315 | 25000000000000000000 | 53498941 | 2024-02-14T04:35:55.000Z | 0x13111c0164d3212afb66a269086a88accfd27cd651e55cf4141b7e18636adefb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV4v1_SssFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_TriggerFeeCharged\_event
Trigger fee charges from Gains Network v7 perpetual trading protocol on Polygon, denominated in DAI (18 decimals). Records fees paid by traders when automated triggers execute stop-loss, take-profit, or limit orders.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_valueDai` | `STRING` | Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places). |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x07fddfdf8f583b87e0b8ad3fb7adf3918e1ffdad | 313 | 66440000000000000 | 56805503 | 2024-05-10T14:50:02.000Z | 0xe5079b95e83e3fd283319adb9731314af25048326190f688387c965ea33c87c4 |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x0ad4de31fc1e1e01eaaf815da18690441190f7ed | 171 | 595199999999999999 | 56806890 | 2024-05-10T15:40:14.000Z | 0x9a79a32842691b9e69e846bed477eb66d923e6ec724edd2685ae9a2730ebad1c |
| 0x82e59334da8c667797009bbe82473b55c7a6b311 | false | 0x0d3e5cd13a887be35682b2bdd230a2efdc10ad47 | 158 | 55703519999999999 | 56804953 | 2024-05-10T14:30:02.000Z | 0xcb172fa0c39ef5aba5716a6e53dcd3de26a59e4065e51255adcf091b3fdb7c4f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.GNSTradingCallbacksV4v1_TriggerFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***