> ## 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_v6_arbitrum
> Tables in tt-contracts.gainsnetwork_v6_arbitrum
## Tables
### GNSReferrals\_ReferrerRegistered\_event
Referral registration events from Gains Network v6 perpetual trading protocol on Arbitrum, linking trader addresses to their referring accounts. Used to track referral program participation and analyze user acquisition channels.
| 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_referrer` | `STRING` | Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_trader | log\_index | in\_referrer | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaa379dd7ec0bae467490e89bb2055a7e01231b8f | false | 0x4216eb9777befa7ab8fc8dbb5428e84c6221c6f8 | 2 | 0x10c2cbfe29f4f5e4c24d54d36c8f283a61eb0c2f | 66337310 | 2023-03-03T09:48:57.000Z | 0x206430c5b38ad244fe42752e6cbd5d59011bebf3e32c737997bd1363cc24b8c8 |
| 0xaa379dd7ec0bae467490e89bb2055a7e01231b8f | false | 0x6841e7796d740f86c672e1a1bad69601d876723f | 41 | 0x10c2cbfe29f4f5e4c24d54d36c8f283a61eb0c2f | 83856451 | 2023-04-24T16:10:52.000Z | 0xe48c63d3676124c7e562d4bfb5ed308dcf6e714e6c5d49401b72ae236d8c78b2 |
| 0xaa379dd7ec0bae467490e89bb2055a7e01231b8f | false | 0x99d112cc5c9fcbbfcb8c29ddcfff3be8fb0a6ef8 | 42 | 0x10c2cbfe29f4f5e4c24d54d36c8f283a61eb0c2f | 83806919 | 2023-04-24T12:46:08.000Z | 0x4bfbe2e52b4d3b6970149cacd0aa2064656af229435b59c0e56acd272169ce98 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSReferrals_ReferrerRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_DevGovFeeCharged\_event
Development and governance fee charges from Gains Network V6 perpetual trading protocol on Arbitrum. Records DAI-denominated fees collected from traders for protocol development and governance funding.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x00050fd6133088a4cabee4160cd449bb664f7dff | 1 | 12000000000000000000 | 71524987 | 2023-03-19T19:11:43.000Z | 0xcc8ca1dc6d4ad27f3d1b0683751491caba2371f702ca3e85482c28cb06d4f13f |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x02215b8a1e227391e6b8114e985f7ccfeb796d9b | 1 | 3518168831999999998 | 71467538 | 2023-03-19T15:13:53.000Z | 0xe3d641cd52436288392cb7dd17a4dc64f812d392aae93ef3576b872ec84e2521 |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x02215b8a1e227391e6b8114e985f7ccfeb796d9b | 1 | 1935449999999999998 | 71253671 | 2023-03-19T00:12:14.000Z | 0x8689f15e0373a8710640b3f1ace90b1c2edcda51d9d7e5cc76289b5b257c4c36 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3_DevGovFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_LimitExecuted\_event
Take-profit and stop-loss order execution events from Gains Network v6 perpetual futures protocol on Arbitrum. Records limit order fills including profit/loss, position details, and NFT bot holder addresses for analyzing automated trading and position exit strategies.
| 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":"12240000000000","buy":true,"index":"0","trader":"0x2232baf89455a331f15928fa1be8a102802c9134","leverage":"38","openPrice":"12160000000000","pairIndex":"1","initialPosToken":"58241947577396447840","positionSizeDai":"193920000000000000000"} | 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 12240000000000 | 29 | 1231 | 50668500 | 0xb47b0b60752afe377b112c5490d26ec0e0a224fe | 0 | 0 | 2023-01-04T01:20:01.000Z | 0 | 250000000000 | 0x4499372f62c892d9581d84f2cefc225bbb195e27a7eea7e29d10d4b3fb228e66 | 236165148252430220717 | 193919999999999999998 |
| \{"sl":"12550000000000","tp":"12511600000000","buy":false,"index":"0","trader":"0x37e1c1889f2358c3695688aa7af383f15165d1d7","leverage":"150","openPrice":"12555715938791","pairIndex":"1","initialPosToken":"13643866131476224911","positionSizeDai":"44000000000000000000"} | 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 12511600000000 | 17 | 1692 | 50837830 | 0x7676d49df89c7cf60953beb193724bd6403b8eb0 | 0 | 0 | 2023-01-04T16:07:24.000Z | 0 | 527042093888 | 0x2a072db2e800066e5ac0a1136943b4261cf7ce22f4d8e6c0c39793b310ef5e97 | 60520553041561807439 | 43010000000000000002 |
| \{"sl":"0","tp":"12553900000000","buy":true,"index":"0","trader":"0x37e1c1889f2358c3695688aa7af383f15165d1d7","leverage":"150","openPrice":"12500000000000","pairIndex":"1","initialPosToken":"13995654731287309454","positionSizeDai":"44000000000000000000"} | 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 12553900000000 | 67 | 1675 | 50834856 | 0xa20dec41a1e26b050fdd352eeb387cc6cb28c2be | 0 | 0 | 2023-01-04T15:52:19.000Z | 0 | 646800000000 | 0x939e046e2748fd0e56e14ebb906f0cec0eb35a6544b1565ff104065d99ca7084 | 67176897816610271800 | 43999999999999999998 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_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_v6_arbitrum.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 V6 perpetual trading protocol on Arbitrum. Records position opens and closes with execution price, profit/loss percentages, and collateral flows for analyzing trader performance and protocol mechanics.
| 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":"0","buy":false,"index":"0","trader":"0x09cc15dda77789d42c0133c909e88fb6e3af793a","leverage":"42","openPrice":"16346808660000","pairIndex":"1","initialPosToken":"288276516545715868900","positionSizeDai":"1932800000000000000000"} | 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | false | 15820949999999 | 19 | 41252 | 56647743 | 2023-01-30T14:11:17.000Z | 0 | 1351093303862 | 0xe6d983fefa01f1612fcbcb171ee3229dcb3be5df4bb3190a61c446f5bdedc4f0 | 4479439191375109167429 | 1932799999999999999996 |
| \{"sl":"0","tp":"0","buy":false,"index":"0","trader":"0xfc1ef5819d6cabd9e2198b27c171dd8cf44c30e2","leverage":"64","openPrice":"15757694400000","pairIndex":"1","initialPosToken":"427219162396205015228","positionSizeDai":"2466880000000000000000"} | 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | false | 15540600000000 | 19 | 42374 | 56719285 | 2023-01-30T19:58:46.000Z | 0 | 881730616631 | 0x2aac43f80896c2d640583c41b3607cc58670f2ff438697e4ee342ecc136d471b | 4514833863350673210714 | 2466879999999999999997 |
| \{"sl":"0","tp":"0","buy":false,"index":"0","trader":"0x5a039173c24d0fcd873d5f120f8564e578963c15","leverage":"78","openPrice":"236726821380000","pairIndex":"0","initialPosToken":"14927873942693176310","positionSizeDai":"93760000000000000000"} | 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | false | 236821400000000 | 16 | 40559 | 56542776 | 2023-01-30T05:32:08.000Z | 0 | -31163060936 | 0xf18aae215dae969cb89773b7291c5651d883e611e6e2feb15fac5aa66a0e3b2a | 84988031042853818859 | 93759999999999999995 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_NftBotFeeCharged\_event
NFT bot fee charges on Gains Network v6 perpetual trading protocol on Arbitrum, denominated in DAI (18 decimals). Tracks automated bot execution fees paid by traders for order execution and keeper services.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x5c0d0605569f48a8e63e4c86d9e0520d3a708df4 | 6 | 1500000000000000000 | 57486218 | 2023-02-02T17:41:02.000Z | 0x535f45f3e6b288465b917e1156fef9cc6f2d85582facf910b03ae7a1dd2c2df4 |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x7206bc81e2c52441eeffe120118ac880f4528dda | 6 | 5000000000000000000 | 57502263 | 2023-02-02T19:03:42.000Z | 0x7461dd8a1be7c45b5d4f3c685b227d9050e1d3dec08785f3d0d0df7edd36e32a |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x108e4f1486bb38b60629ab570d82bf5420181217 | 6 | 1500000000000000000 | 57535417 | 2023-02-02T22:00:26.000Z | 0x57801e2e9d9d3ba5654f3ab1ed3fe1e181fa4c299fa8bee79439ea453780632b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3_NftBotFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_ReferralFeeCharged\_event
Referral fee charges from Gains Network v6 perpetual trading protocol on Arbitrum, denominated in DAI. Records trader addresses and fee amounts for analyzing 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x1b4d5ff27a62aac8b96d96449c4f7c07aca925b5 | 6 | 1223031237944897597 | 60868207 | 2023-02-14T13:52:38.000Z | 0x89a2bb9a38fc29228bf4e4ab17c690c6d766e24c590d770301599970e22c3da7 |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x3a70b9fc6f7a1cf901e57ebb6a0741819ccc4e8a | 6 | 1980000000000000000 | 60882098 | 2023-02-14T14:50:53.000Z | 0x96b9968951c645087157a54adcc751ba72a540f9b23500a0e54d3e95ee4642c9 |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x4ef3f62f6c68e95d1a1f69ff39c590c4bf517368 | 6 | 1170967920315000000 | 60865618 | 2023-02-14T13:41:47.000Z | 0x288c4905510176ffe31669c1a999663cf0658b540da1ae39ce8e4e052b67791e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3_ReferralFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3\_SssFeeCharged\_event
SSS (Spread Sharing System) fee events from Gains Network v6 perpetual trading protocol on Arbitrum. Records DAI-denominated fees charged to traders, useful for analyzing protocol revenue and trader cost basis.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x040635e5fd80b59b0501613a17fa0055fa464143 | 5 | 16000000000000000000 | 62532711 | 2023-02-19T20:03:07.000Z | 0x6a264aadb8f51ec489449b492ceb4bcd52b688256461dab06510ffff6ae7b1c7 |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x0b00c0ca9f461977a55ff5ddf6c3492819d0ed71 | 5 | 1800000000000000000 | 62539376 | 2023-02-19T20:31:43.000Z | 0xaba71c39a79c1839fd47ae8e85f2bdf7ed2b308b8583dba3cb92907bce4d7662 |
| 0x6c612c804c84e3d20e3109c8efd06cd2d8b28f46 | false | 0x0b00c0ca9f461977a55ff5ddf6c3492819d0ed71 | 5 | 1800000000000000000 | 62539314 | 2023-02-19T20:31:26.000Z | 0x2f15afac8796fd6f70c800646f7709f1d585cda11a2c6391c8c344000240aa00 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3_SssFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_DevGovFeeCharged\_event
Development and governance fee charges from gTrade (Gains Network) V6 perpetual trading protocol on Arbitrum. Records DAI-denominated fees collected from traders for protocol development and governance, 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0xcb11673592cc6c4b9584f33bbba6c6cf07dde3f7 | 27 | 6874200000000000000 | 100431927 | 2023-06-12T14:50:47.000Z | 0x325a2e782656bb596a7ae3fa088e82edc13da8fbffed54ad6c5c13ebe894a8fb |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0xa3609cf7872faa7804281c7c5edb8b2d33001089 | 65 | 150000000000000000000 | 100416372 | 2023-06-12T13:46:27.000Z | 0x752db8842ea3fddd1cc20239c0ef23c9dfa3ac5fc985a29ee9d53ae4aa8c23f5 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0xbc2530c310276d9b4d2497c58e5adadb09f2ba41 | 1 | 36000000000000000000 | 100467467 | 2023-06-12T17:17:55.000Z | 0x8cc4297057220d4d0e46b31a2919557bc51fba99eac17999012c9a25f12e6094 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.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) v6 perpetual trading protocol on Arbitrum, capturing take-profit and stop-loss triggers with realized profit/loss, position details, and NFT bot holder addresses. Used for analyzing trader performance, leverage patterns, and automated order execution 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\_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":"20949360000000","tp":"19930400000000","buy":false,"index":"1","trader":"0x0246b0a279dd8466ecba9b3b0af5f51076763e09","leverage":"30","openPrice":"20439155880000","pairIndex":"90","initialPosToken":"55977424627555043836","positionSizeDai":"394000000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 19928600000000 | 53 | 199883 | 80417222 | 0x711668093a7da9557adb76c59b6e27805fbe9c82 | 0 | 1 | 2023-04-14T16:14:05.000Z | 0 | 749379107920 | 0x0d9e3fa51422f1b3ea5496e6fbdb9177e555e88560b59af167c0f79946dbeb13 | 687279188819314093896 | 393999999999999999997 |
| \{"sl":"0","tp":"21200530000000","buy":true,"index":"0","trader":"0x0418d49ae668d538ccc7f3812a896b0c92b7e796","leverage":"150","openPrice":"20015503000000","pairIndex":"1","initialPosToken":"36257458794294536007","positionSizeDai":"255200000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 21200530000000 | 90 | 197876 | 80192514 | 0x0376529a4a3347721575400cb9f5b4aee34800a5 | 0 | 0 | 2023-04-14T00:40:23.000Z | 0 | 8880818533513 | 0xd918b85ddafa630aa0ebf3d65c2ce971d12eeca7cf6637e9ffe0768c736024dc | 2488685554180082155304 | 255199999999999999994 |
| \{"sl":"0","tp":"15295000000","buy":false,"index":"0","trader":"0x19c2a0e1398ba78c00af784fdec4cd0bbe70a392","leverage":"15","openPrice":"15450000000","pairIndex":"109","initialPosToken":"66955983481228539914","positionSizeDai":"494000000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 15295000000 | 25 | 198361 | 80219646 | 0x3d889a438fb78f0e1a87c8bcbd78c3fc7338b71e | 0 | 0 | 2023-04-14T02:33:10.000Z | 0 | 150485436893 | 0x4112da7b66e9ddf200a0566ff10659eb7a5498410a15ffe88d9b7562701a66a1 | 562465309595290047953 | 493999999999999999993 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.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_v6_arbitrum.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 v6 leveraged trading protocol on Arbitrum, capturing trade opens and closes with position details, profit/loss, and price impact. Used for analyzing trader behavior, leverage usage, and slippage patterns across perpetual futures pairs.
| Column | Type | Description |
| -------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_orderId` | `STRING` | Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations. |
| `in_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":"435982163461","buy":false,"index":"0","trader":"0x006f34f3a6c36222742528c2db16fb4af7a70059","leverage":"26","openPrice":"440128292634","pairIndex":"136","initialPosToken":"118754644826822566287","positionSizeDai":"489600000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | true | false | 440128292634 | 14 | 344222 | 144661923 | 2023-10-28T00:48:33.000Z | 907314349 | 0 | 0x4e14c5418648b776d1253982e14c99ddd7b7d376bbb33f7d9dc6be1e54a5923f | 0 | 489599999999999999999 |
| \{"sl":"0","tp":"338159326000000","buy":false,"index":"0","trader":"0x006f34f3a6c36222742528c2db16fb4af7a70059","leverage":"125","openPrice":"338837150904000","pairIndex":"0","initialPosToken":"163724234595803170432","positionSizeDai":"675000000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | true | false | 338837150904000 | 15 | 344227 | 144662649 | 2023-10-28T00:52:19.000Z | 0 | 0 | 0x0be2ac39d93c1e480b923d449204b967efcf4026ae6b6aa30e6912153c464588 | 0 | 674999999999999999997 |
| \{"sl":"0","tp":"929496084","buy":false,"index":"0","trader":"0x006f34f3a6c36222742528c2db16fb4af7a70059","leverage":"125","openPrice":"933199176","pairIndex":"44","initialPosToken":"163724234595803170432","positionSizeDai":"675000000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | true | false | 933199176 | 14 | 344225 | 144662482 | 2023-10-28T00:51:21.000Z | 705551391 | 0 | 0xd33e7f19ff41af44451fafd42c091ca5bf50c811d8587f6f8d6b2160effc58ca | 0 | 674999999999999999997 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3v1_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_NftBotFeeCharged\_event
NFT (non-fungible token) bot fee charges from Gains Network V6 perpetual trading protocol on Arbitrum, denominated in DAI. Records automation service fees paid by traders when bots execute trades or manage positions on their behalf.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x006f34f3a6c36222742528c2db16fb4af7a70059 | 24 | 719399999999999999999 | 122310783 | 2023-08-17T15:36:38.000Z | 0x5f32cfda93abddf3c9cbaf6e7036e287d14336be2d0aa4fd5a5987ae44e0f4dd |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x006f34f3a6c36222742528c2db16fb4af7a70059 | 43 | 241999999999999999999 | 122107408 | 2023-08-17T00:44:55.000Z | 0x710dbe90a1a162c89ba543aefa77ca9996d5939fbdae5c9b0d658a23390d0cdd |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x006f34f3a6c36222742528c2db16fb4af7a70059 | 54 | 263999999999999999999 | 122106018 | 2023-08-17T00:38:45.000Z | 0x314c526c5996ff83fddab4185b8c801aef4560241026af2f7b9b1f8dae829b10 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3v1_NftBotFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_ReferralFeeCharged\_event
Referral fee charges from Gains Network v6 perpetual trading platform on Arbitrum, denominated in DAI stablecoin. Used for analyzing 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x0b49f8f8ec743b76fea08b4c8f3077f7ffe1a0fd | 9 | 1148011884450000000 | 173658377 | 2024-01-24T09:53:16.000Z | 0x1ec07f54bcb730ce01e05d80168dc6517d3b1e258f69745db040b26be66e0345 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x0b49f8f8ec743b76fea08b4c8f3077f7ffe1a0fd | 10 | 1170220771200000000 | 173642566 | 2024-01-24T08:47:27.000Z | 0x5d3c03e61f9adb9fd9a3e48f88a69f55bd73236927cf2fbc241cd2ab5170f49a |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x0b49f8f8ec743b76fea08b4c8f3077f7ffe1a0fd | 10 | 1134136097600000000 | 173636670 | 2024-01-24T08:22:51.000Z | 0x637f3f6df37a42e79c30225c011d97b9c9abc3a8b49604852b0b117fd492e27d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3v1_ReferralFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v1\_SssFeeCharged\_event
Spread, slippage, and swap (SSS) fee charges from Gains Network V6 perpetual trading protocol on Arbitrum. Records DAI-denominated fees paid by traders during trade executions for analyzing trading costs and protocol fee revenue.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x995dcf49847775fbd1489a77fe451317a131c816 | 5 | 1791600000000000000 | 117886180 | 2023-08-03T23:09:35.000Z | 0x5bb44ce2ceb22ff438679602c5557f912ceaebe96b2be080f92f4d7d966e6202 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x45b8a9da6a2eb3962ea6fe15d546a9f1c4d3bdef | 5 | 1500000000000000000 | 117688323 | 2023-08-03T09:02:13.000Z | 0x773c966c0b0846ed436daaab08891c0b02373c8d3fc73418a83c176e326eb19b |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0xd95677f6b9cc860b6fd54dc6554236a78e6ec8da | 5 | 3480000000000000000 | 117567096 | 2023-08-03T00:07:30.000Z | 0x8e3c66228f247ecad8969ffa6cd95f22f3be135734d11def87719aae679ff079 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3v1_SssFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV3v2\_LimitExecuted\_event
Limit order execution records from Gains Network V6 perpetual trading protocol on Arbitrum. Contains filled stop-loss and take-profit orders with execution prices, position details, profit/loss calculations, and NFT holder rewards for analyzing trade outcomes and bot performance.
| 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` | Indicates whether the limit order was executed at the exact requested price versus experiencing slippage. Null values indicate execution precision could not be determined. |
| 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":"141400000000","buy":true,"index":"0","trader":"0x0171d947ee6ce0f487490bd4f8d89878ff2d88ba","leverage":"17","openPrice":"135853019838","pairIndex":"103","initialPosToken":"429593777163805417493","positionSizeDai":"2466000000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 128764522307 | 32 | 39050430 | 190496103 | 0xc83b78a64485e24be0af82ae2341c42dc5bd8fd8 | 2 | 0 | 2024-03-15T03:22:18.000Z | 0 | -887020827146 | 0x12e490b5b6d4a50a54daef56105d5c111e1e89160ca772d95675f2f9e2453401 | true | 214542000003 | 2465999999999999999996 | 99969822 |
| \{"sl":"0","tp":"704186275000000","buy":true,"index":"0","trader":"0x0171d947ee6ce0f487490bd4f8d89878ff2d88ba","leverage":"40","openPrice":"687365766371998","pairIndex":"0","initialPosToken":"252140060705941867687","positionSizeDai":"1452000000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 671952761252068 | 37 | 39050484 | 190497348 | 0xc83b78a64485e24be0af82ae2341c42dc5bd8fd8 | 2 | 0 | 2024-03-15T03:27:30.000Z | 0 | -896931786479 | 0x916ce9bb9d5cc1b4abf43c937cc15b21eb24017df8722af54222cf2979b33cab | true | 1452000003 | 1451999999999999999998 | 99969822 |
| \{"sl":"0","tp":"721233880952381","buy":true,"index":"1","trader":"0x0171d947ee6ce0f487490bd4f8d89878ff2d88ba","leverage":"21","openPrice":"704693884848000","pairIndex":"0","initialPosToken":"253754093055951340043","positionSizeDai":"1474800000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 674583514209654 | 62 | 39050463 | 190496906 | 0xc83b78a64485e24be0af82ae2341c42dc5bd8fd8 | 2 | 1 | 2024-03-15T03:25:40.000Z | 0 | -897294267767 | 0x4396458ff8067504a9484da78c1e75dc1e6231b7892fa70267b5e67f035cfef4 | true | 1474800003 | 1474799999999999999996 | 99969822 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.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 v6 perpetual trading protocol on Arbitrum, capturing position opens/closes with entry/exit prices, profit/loss, leverage, and collateral amounts. Used for analyzing trader performance, position sizing patterns, and execution quality across trading pairs.
| Column | Type | Description |
| ----------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_orderId` | `STRING` | Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations. |
| `in_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":"5565000000","tp":"6264180000","buy":true,"index":"0","trader":"0x5cc6014061456d2fc3afe05dc454c6530960bc84","leverage":"2","openPrice":"5570285555","pairIndex":"5","initialPosToken":"798087143313810119247","positionSizeDai":"4492800000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | false | 5573156200 | 28 | 38980354 | 180251135 | 2024-02-13T07:12:14.000Z | 0 | 1030699403 | 0xb05df7b71bbe12ed2cd87bbff4de42f5262fdb0d24688b3824ad6c7d8983370d | 4490239321150502399998 | 4492799999999999999996 | 99994386 |
| \{"sl":"5565000000","tp":"6264180000","buy":true,"index":"0","trader":"0x5cc6014061456d2fc3afe05dc454c6530960bc84","leverage":"2","openPrice":"5570285555","pairIndex":"5","initialPosToken":"798087143313810119247","positionSizeDai":"4492800000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | true | false | 5570285555 | 15 | 38980353 | 180250923 | 2024-02-13T07:11:21.000Z | 190952236 | 0 | 0xf6661cf1dac091045f03f22b3996c58b977855560fc286a9edd629e630f63f85 | 0 | 4492799999999999999996 | 99994386 |
| \{"sl":"7421480000","tp":"6491607500","buy":false,"index":"0","trader":"0x87caed3780e0217e0f4ed919bcf663c8ea0ea788","leverage":"2","openPrice":"7417649878","pairIndex":"159","initialPosToken":"798007342585771776242","positionSizeDai":"4492800000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | true | false | 7417649878 | 19 | 38980385 | 180253148 | 2024-02-13T07:20:37.000Z | 155917581 | 0 | 0x9068c8e1e7c982d9e05f71775a84e3f0b5975c2d55a4ac01e8eb5f37736ae179 | 0 | 4492799999999999999998 | 99994386 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV3v2_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_BorrowingFeeCharged\_event
Borrowing fee events from Gains Network v6 perpetual trading protocol on Arbitrum, recording fees charged on open positions denominated in DAI. Used for analyzing trader funding costs and protocol fee revenue across different position sizes.
| 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` | Trade position value denominated in DAI stablecoin, represented as an integer with 18 decimal places. Non-zero for all trades, indicating the notional size of the leveraged position. |
| `in_feeValueDai` | `STRING` | Borrowing fee charged to the trader denominated in DAI, stored as a string representation of the raw wei-equivalent value (18 decimals). Can be zero when no borrowing fee applies to the trade event. |
| address | removed | in\_trader | log\_index | block\_number | in\_feeValueDai | block\_timestamp | in\_tradeValueDai | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | -------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x08f4a02c1fc844b7bfe51d65e33856fe4141dc8f | 3 | 130034329 | 98591054510015999999 | 2023-09-11T07:18:56.000Z | 257342400002 | 0x2d1672b7434757c3ced8b5daedcb02783b20c49589c18df7fa4d78cfb7f7a03b |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x0b00c0ca9f461977a55ff5ddf6c3492819d0ed71 | 3 | 130006164 | 0 | 2023-09-11T05:09:48.000Z | 21780000002 | 0x0911959afa71036aa7274bf5f083f7baf34497649c29c7094cddb41f72bdc4ac |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x0b00c0ca9f461977a55ff5ddf6c3492819d0ed71 | 3 | 130138048 | 148117140599999999 | 2023-09-11T14:46:41.000Z | 433657759532491999972 | 0x67004da26317615e3b111c4659ae8faa21c46ebba992739e08d00f88b0eb6a89 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV4v1_BorrowingFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_DaiVaultFeeCharged\_event
DAI vault fee charges from Gains Network v6 trading callbacks on Arbitrum, recording fees deducted from traders' positions in DAI stablecoin. Used for analyzing protocol revenue and trading cost distribution across users.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x053be9d5adda195c12ac6e33c70c3623a9323d5f | 13 | 2763492187499999999 | 131217620 | 2023-09-15T04:47:26.000Z | 0xaf9e687a6af8c4af5c93a329bf4913ed0a02a3b37da7837b9fd26cc7e5758fe0 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x1065505790f00eb0da18d9299e1cce2a667b32ea | 13 | 2114999999999999999 | 131185304 | 2023-09-15T02:13:26.000Z | 0x3a8d6ad142b56bbcde9e0943feb50d631a0f519fd0913c54b7dc9537b88621d3 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x1e4fe1ae915dfa642ba401a8789fad2a5bae5da4 | 13 | 2213999999999999999 | 131462435 | 2023-09-15T23:54:45.000Z | 0x48504e84e95e236f9020d4e3a0920ed6da888c2b8a18d7a09e9e3762d1b3568d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV4v1_DaiVaultFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_GovFeeCharged\_event
Governance fee collection events from Gains Network v6 perpetual trading protocol on Arbitrum, recording DAI-denominated fees charged to traders. Tracks fee amounts, distribution status, and trader addresses for protocol revenue analysis.
| 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 protocol stakeholders. Always true in sample data, suggesting immediate distribution upon fee collection. |
| address | removed | in\_trader | log\_index | in\_valueDai | block\_number | in\_distributed | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x0ba80bd575c61ecdba729a7f4f2d23df54c48193 | 2 | 1462500000000000000 | 199682325 | true | 2024-04-10T20:57:22.000Z | 0x517ac89f24f26a38c792525fe3b143501799b620944276eee76a333ef99fdd22 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x21646828d5a487226342d107e8996ae86dcff7cc | 2 | 3835979955433438343 | 199498193 | true | 2024-04-10T08:03:27.000Z | 0x513e5181abab5309a38d0225655745fefe0b368868736250d19d3dec70f94c97 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x21646828d5a487226342d107e8996ae86dcff7cc | 2 | 3619203345163111132 | 199647823 | true | 2024-04-10T18:32:43.000Z | 0x3d61b10050bc420c9b55738cc981f12ebe98e98065a654ad0627796ef81c4271 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV4v1_GovFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_ReferralFeeCharged\_event
Referral fee charges from Gains Network v6 perpetual trading protocol on Arbitrum, recording DAI-denominated fees collected per trader when trades are executed. Useful for analyzing 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x0eb9f16749ef6e6e43d3e51ea8f741c4cd0c66be | 7 | 2449260000000000000 | 181192183 | 2024-02-16T02:25:55.000Z | 0x88409ac089b82028a572fe9910cfa85864dd849d65f48fca1814fb64f153771f |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x104fc0fefb0470cd886cadd15f943d78d03d5b07 | 7 | 10149937380000000000 | 181468822 | 2024-02-16T22:14:25.000Z | 0x668bc2a71bbc22567d531b33a7441ddcea0403d26f2dd044c01d3557a6a5133f |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x104fc0fefb0470cd886cadd15f943d78d03d5b07 | 7 | 2627101620000000000 | 181443678 | 2024-02-16T20:23:01.000Z | 0x003533ccb694c798eaf9938a7a0d34ba4c8b1dfd6f20e46eacba31fa0d4e2f90 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV4v1_ReferralFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_SssFeeCharged\_event
SSS (spread, slippage, and staking) fee charge events from Gains Network v6 perpetual trading protocol on Arbitrum. Records trader addresses and DAI-denominated fee amounts 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0xf940ce19b9cd0b9efd586381b488cefb75eb413f | 516 | 14703046874999999998 | 86224741 | 2023-05-01T15:04:14.000Z | 0x63fd1e13e14dfee39de5f6f2cf5c7facf2f35883034c141515bee0d164a1ff5b |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x6d4854423b82e1509978df9573508904b38c8998 | 5 | 2000000000000000000 | 86166150 | 2023-05-01T11:00:45.000Z | 0x1cfafe82c63272eee0b962ef2ba102bde35abf0a0de3f72e79c8289da722e8c9 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x5d7425780f475bf22e93dc32fa9b7177b1e10621 | 5 | 4520000000000000000 | 86249032 | 2023-05-01T16:44:58.000Z | 0xfb71ef4d25c83f20e8825396a7f8d62b3b6731ec3340a84f5dbc14551f0c5769 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV4v1_SssFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v1\_TriggerFeeCharged\_event
Trigger execution fees charged on Gains Network (gTrade) perpetual trading protocol on Arbitrum, denominated in DAI. Records keeper fees paid when stop-loss, take-profit, or limit orders are executed for analyzing protocol fee economics and trader order execution 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x09475262c6a1ffbedd480d2a15f35f978aaaac38 | 71 | 614443737599999999 | 192565995 | 2024-03-21T04:39:56.000Z | 0x298257080375d94ead45b9388742674d25353fc638aa44bea47b764de99764e9 |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x1358a588c8961c2a121e406bf0eb0c1551b9905f | 24 | 2831999999999999999 | 192791611 | 2024-03-21T20:22:04.000Z | 0xf56a9c31b39da0b49b786997a5d4567c0c9718573356f2c29af23c79fe3f937c |
| 0x298a695906e16aea0a184a2815a76ead1a0b7522 | false | 0x13fca4c52b8b7c78f5148f7b51415c17ba996bb9 | 29 | 941599999999999999 | 192550766 | 2024-03-21T03:36:12.000Z | 0x4ae2534a9f8a167a36271d0f1badc715bcbcc225d01d0cf214141c0862ff9d74 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV4v1_TriggerFeeCharged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GNSTradingCallbacksV4v2\_MarketExecuted\_event
Market order execution events from Gains Network v6 perpetual trading protocol on Arbitrum, tracking position opens and closes with execution price, profit/loss, leverage, and DAI settlement amounts. Used for analyzing trader performance, slippage patterns, and protocol trading volume 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_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":"10148","buy":false,"index":"0","trader":"0x7e66f801ea83af1d72629a9fb44d77fe7a4f80e3","leverage":"150","openPrice":"10221","pairIndex":"134","initialPosToken":"10613898817439638127","positionSizeDai":"44880000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | true | false | 10221 | 18 | 38921723 | 173322410 | 2024-01-23T10:15:34.000Z | 66664219 | 0 | 0xeab19abebda1123005ffcd7ebe4986823b510d3f5c0d34853ffaf665476dea10 | 0 | 44879999999999999999 | 99985000 |
| \{"sl":"0","tp":"10287","buy":true,"index":"0","trader":"0x183adddac8a2f604fbba18cee497f399020fc114","leverage":"150","openPrice":"10222","pairIndex":"134","initialPosToken":"10613898817439638127","positionSizeDai":"44880000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | true | false | 10222 | 14 | 38921724 | 173322433 | 2024-01-23T10:15:40.000Z | 107649958 | 0 | 0x4d59eb35b85a1ed8c17aea8e7b76eca81380ca5031dfbf4e94936b9a2a652631 | 0 | 44879999999999999999 | 99985000 |
| \{"sl":"0","tp":"10472","buy":true,"index":"0","trader":"0x8488d107dba8320450070e79de56c049e303e54a","leverage":"150","openPrice":"10266","pairIndex":"134","initialPosToken":"10448570098443910079","positionSizeDai":"44880000000000000000"} | 0x298a695906e16aea0a184a2815a76ead1a0b7522 | true | false | 10266 | 23 | 38923390 | 173503207 | 2024-01-23T23:01:25.000Z | 94151079 | 0 | 0xfc430b202452b52da49f08bc5bb136028b2dcfae143ee1b700b5027b22343539 | 0 | 44879999999999999999 | 99985000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV4v2_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***