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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeDai STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	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.

Sample Data

in_t	address	removed	in_price	log_index	in_orderId	block_number	in_nftHolder	block_timestamp	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	2023-01-04T01:20:01.000Z	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	2023-01-04T16:07:24.000Z	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	2023-01-04T15:52:19.000Z	646800000000	0x939e046e2748fd0e56e14ebb906f0cec0eb35a6544b1565ff104065d99ca7084	67176897816610271800	43999999999999999998

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeDai STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	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.

Sample Data

in_t	address	in_open	removed	in_price	log_index	in_orderId	block_number	block_timestamp	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	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	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	-31163060936	0xf18aae215dae969cb89773b7291c5651d883e611e6e2feb15fac5aa66a0e3b2a	84988031042853818859	93759999999999999995

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeDai STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	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.

Sample Data

in_t	address	removed	in_price	log_index	in_orderId	block_number	in_nftHolder	in_limitIndex	block_timestamp	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	1	2023-04-14T16:14:05.000Z	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	2023-04-14T00:40:23.000Z	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	2023-04-14T02:33:10.000Z	150485436893	0x4112da7b66e9ddf200a0566ff10659eb7a5498410a15ffe88d9b7562701a66a1	562465309595290047953	493999999999999999993

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeDai STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	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.

Sample Data

in_t	address	in_open	removed	in_price	log_index	in_orderId	block_number	block_timestamp	in_priceImpactP	transaction_hash	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	0x4e14c5418648b776d1253982e14c99ddd7b7d376bbb33f7d9dc6be1e54a5923f	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	0x0be2ac39d93c1e480b923d449204b967efcf4026ae6b6aa30e6912153c464588	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	0xd33e7f19ff41af44451fafd42c091ca5bf50c811d8587f6f8d6b2160effc58ca	674999999999999999997

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeDai STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	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.

Sample Data

in_t	address	removed	in_price	log_index	in_orderId	block_number	in_nftHolder	in_orderType	in_limitIndex	block_timestamp	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	-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	-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	-897294267767	0x4396458ff8067504a9484da78c1e75dc1e6231b7892fa70267b5e67f035cfef4	true	1474800003	1474799999999999999996	99969822

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeDai STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<trader STRING, pairIndex STRING, index STRING, initialPosToken STRING, positionSizeDai STRING, openPrice STRING, buy BOOL, leverage STRING, tp STRING, sl STRING>`	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.

Sample Data

in_t	address	in_open	removed	in_price	log_index	in_orderId	block_number	block_timestamp	in_priceImpactP	transaction_hash	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	0xeab19abebda1123005ffcd7ebe4986823b510d3f5c0d34853ffaf665476dea10	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	0x4d59eb35b85a1ed8c17aea8e7b76eca81380ca5031dfbf4e94936b9a2a652631	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	0xfc430b202452b52da49f08bc5bb136028b2dcfae143ee1b700b5027b22343539	44879999999999999999	99985000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gainsnetwork_v6_arbitrum.GNSTradingCallbacksV4v2_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

GNSReferrals_ReferrerRegistered_event

GNSTradingCallbacksV3_DevGovFeeCharged_event

GNSTradingCallbacksV3_LimitExecuted_event

GNSTradingCallbacksV3_LpFeeCharged_event

GNSTradingCallbacksV3_MarketExecuted_event

GNSTradingCallbacksV3_NftBotFeeCharged_event

GNSTradingCallbacksV3_ReferralFeeCharged_event

GNSTradingCallbacksV3_SssFeeCharged_event

GNSTradingCallbacksV3v1_DevGovFeeCharged_event

GNSTradingCallbacksV3v1_LimitExecuted_event

GNSTradingCallbacksV3v1_LpFeeCharged_event

GNSTradingCallbacksV3v1_MarketExecuted_event

GNSTradingCallbacksV3v1_NftBotFeeCharged_event

GNSTradingCallbacksV3v1_ReferralFeeCharged_event

GNSTradingCallbacksV3v1_SssFeeCharged_event

GNSTradingCallbacksV3v2_LimitExecuted_event

GNSTradingCallbacksV3v2_MarketExecuted_event

GNSTradingCallbacksV4v1_BorrowingFeeCharged_event

GNSTradingCallbacksV4v1_DaiVaultFeeCharged_event

GNSTradingCallbacksV4v1_GovFeeCharged_event

GNSTradingCallbacksV4v1_ReferralFeeCharged_event

GNSTradingCallbacksV4v1_SssFeeCharged_event

GNSTradingCallbacksV4v1_TriggerFeeCharged_event

GNSTradingCallbacksV4v2_MarketExecuted_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​GNSReferrals_ReferrerRegistered_event

​GNSTradingCallbacksV3_DevGovFeeCharged_event

​GNSTradingCallbacksV3_LimitExecuted_event

​GNSTradingCallbacksV3_LpFeeCharged_event

​GNSTradingCallbacksV3_MarketExecuted_event

​GNSTradingCallbacksV3_NftBotFeeCharged_event

​GNSTradingCallbacksV3_ReferralFeeCharged_event

​GNSTradingCallbacksV3_SssFeeCharged_event

​GNSTradingCallbacksV3v1_DevGovFeeCharged_event

​GNSTradingCallbacksV3v1_LimitExecuted_event

​GNSTradingCallbacksV3v1_LpFeeCharged_event

​GNSTradingCallbacksV3v1_MarketExecuted_event

​GNSTradingCallbacksV3v1_NftBotFeeCharged_event

​GNSTradingCallbacksV3v1_ReferralFeeCharged_event

​GNSTradingCallbacksV3v1_SssFeeCharged_event

​GNSTradingCallbacksV3v2_LimitExecuted_event

​GNSTradingCallbacksV3v2_MarketExecuted_event

​GNSTradingCallbacksV4v1_BorrowingFeeCharged_event

​GNSTradingCallbacksV4v1_DaiVaultFeeCharged_event

​GNSTradingCallbacksV4v1_GovFeeCharged_event

​GNSTradingCallbacksV4v1_ReferralFeeCharged_event

​GNSTradingCallbacksV4v1_SssFeeCharged_event

​GNSTradingCallbacksV4v1_TriggerFeeCharged_event

​GNSTradingCallbacksV4v2_MarketExecuted_event

Tables

GNSReferrals_ReferrerRegistered_event

GNSTradingCallbacksV3_DevGovFeeCharged_event

GNSTradingCallbacksV3_LimitExecuted_event

GNSTradingCallbacksV3_LpFeeCharged_event

GNSTradingCallbacksV3_MarketExecuted_event

GNSTradingCallbacksV3_NftBotFeeCharged_event

GNSTradingCallbacksV3_ReferralFeeCharged_event

GNSTradingCallbacksV3_SssFeeCharged_event

GNSTradingCallbacksV3v1_DevGovFeeCharged_event

GNSTradingCallbacksV3v1_LimitExecuted_event

GNSTradingCallbacksV3v1_LpFeeCharged_event

GNSTradingCallbacksV3v1_MarketExecuted_event

GNSTradingCallbacksV3v1_NftBotFeeCharged_event

GNSTradingCallbacksV3v1_ReferralFeeCharged_event

GNSTradingCallbacksV3v1_SssFeeCharged_event

GNSTradingCallbacksV3v2_LimitExecuted_event

GNSTradingCallbacksV3v2_MarketExecuted_event

GNSTradingCallbacksV4v1_BorrowingFeeCharged_event

GNSTradingCallbacksV4v1_DaiVaultFeeCharged_event

GNSTradingCallbacksV4v1_GovFeeCharged_event

GNSTradingCallbacksV4v1_ReferralFeeCharged_event

GNSTradingCallbacksV4v1_SssFeeCharged_event

GNSTradingCallbacksV4v1_TriggerFeeCharged_event

GNSTradingCallbacksV4v2_MarketExecuted_event