Skip to main content

​
Tables

​
GNSTradingCallbacks_LimitExecuted_event

Limit order execution events from Gains Network (gTrade) v6 perpetual trading protocol on Polygon, capturing stop-loss, take-profit, and limit order fills with execution price, position size in DAI stablecoin, profit/loss percentage, and NFT holder (bot operator) addresses. Used for analyzing order execution patterns, bot performance, and trader profit outcomes across leveraged positions.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderIdSTRINGUnique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
in_limitIndexSTRINGIndex 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_tSTRUCT<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_nftHolderSTRINGAddress of the NFT holder who is entitled to collect execution fees for the limit order. Hex-encoded, 0x-prefixed, 42-character string.
in_orderTypeINT64Enumerated order type classification. Integer identifier representing the specific type of order or limit being executed within the protocol.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_positionSizeDaiSTRINGPosition size of the trade denominated in DAI. String-encoded value representing the trade size with extended precision for decimal representation.
in_percentProfitSTRINGPercentage 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_taddressremovedin_pricelog_indexin_orderIdblock_numberin_nftHolderin_orderTypein_limitIndexblock_timestampin_percentProfittransaction_hashin_positionSizeDai
{“sl”:“230852272728”,“tp”:“249863636363”,“buy”:true,“index”:“0”,“trader”:“0x02c7d89d8912a3e6a4b54468360c861c5a2c26d9”,“leverage”:“22”,“openPrice”:“239000000000”,“pairIndex”:“54”,“initialPosToken”:“87208058704252515863”,“positionSizeDai”:“0”}0xcf63914f5160e596bc574bf4fd52c13a8d270e28false239000000000411294050296321490x2430403186b3a9e08ba7264fbb924447cb7a31d6302022-06-16T09:25:59.000Z00xffe81da6ec75f5eddafddf1a45979afa01694255e1b313d274f21de0109ed2ed67200132670521597081
{“sl”:“230852272728”,“tp”:“249863636363”,“buy”:true,“index”:“0”,“trader”:“0x02c7d89d8912a3e6a4b54468360c861c5a2c26d9”,“leverage”:“22”,“openPrice”:“239000000000”,“pairIndex”:“54”,“initialPosToken”:“87208058704252515863”,“positionSizeDai”:“0”}0xcf63914f5160e596bc574bf4fd52c13a8d270e28false2308522727282341295212296543310x2430403186b3a9e08ba7264fbb924447cb7a31d6102022-06-16T23:11:51.000Z-7499999999330x85a10cdf1c87cc5f5295f48c65b1cd8089fe6820977cc2a8fe688444cd73742e67200132670521597081
{“sl”:“224000000000000”,“tp”:“245000000000000”,“buy”:true,“index”:“0”,“trader”:“0x03cd8272f4f0396d825e329a797bef66a1575447”,“leverage”:“15”,“openPrice”:“216636564150000”,“pairIndex”:“0”,“initialPosToken”:“1336258990552972359545”,“positionSizeDai”:“0”}0xcf63914f5160e596bc574bf4fd52c13a8d270e28false2240000000000001911293870296204210x5c22cf89ced9a14d5ecf711442f91ed6db1ff646102022-06-16T01:57:57.000Z5098471635350xaa5c5c85b3da992b1b375e0477984b339b141d77a0b12d4bf9f3907dd053f89c1037334859275371017282
Query with partition filter
SELECT *
FROM `tt-contracts.gainsnetwork_v6_polygon.GNSTradingCallbacks_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
GNSTradingCallbacks_MarketExecuted_event

Market order execution events from Gains Network v6 perpetual trading protocol on Polygon, capturing position opens/closes with execution price, profit/loss, leverage, and stop-loss/take-profit parameters for analyzing trader performance and order flow.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderIdSTRINGUnique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
in_tSTRUCT<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_openBOOLBoolean flag indicating whether the event represents a position opening (true) or closing (false) operation.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_positionSizeDaiSTRINGPosition size of the trade denominated in DAI. String-encoded value representing the trade size with extended precision for decimal representation.
in_percentProfitSTRINGPercentage 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_taddressin_openremovedin_pricelog_indexin_orderIdblock_numberblock_timestampin_percentProfittransaction_hashin_positionSizeDai
{“sl”:“0”,“tp”:“1490784235”,“buy”:false,“index”:“0”,“trader”:“0x5864f2c8c5f9c76ca8fa48c8d0de0f0255d8749c”,“leverage”:“10”,“openPrice”:“14907842350”,“pairIndex”:“4”,“initialPosToken”:“74165103556740826766”,“positionSizeDai”:“0”}0xcf63914f5160e596bc574bf4fd52c13a8d270e28falsefalse15352595000281042428253460342022-02-26T06:28:28.000Z-2983346882520x00a442f42db520e04ccefa8177f77d423243efbc972b36a2542324923a3d5557150245603999999999999
{“sl”:“0”,“tp”:“16467899234”,“buy”:true,“index”:“0”,“trader”:“0xa31e953e609ce2c99dcaa1083d2b89bc40c9d912”,“leverage”:“150”,“openPrice”:“15535753995”,“pairIndex”:“4”,“initialPosToken”:“4254814484209303600”,“positionSizeDai”:“0”}0xcf63914f5160e596bc574bf4fd52c13a8d270e28truefalse15535753995321043903253663532022-02-26T21:26:36.000Z00x8b8410a7f5f1fcb7bbc453bae2737bacaa080527d39bd2de4bb83ed14a88fd019118000000000000000
{“sl”:“182500000000”,“tp”:“18116400000”,“buy”:false,“index”:“0”,“trader”:“0x24281783d464d71325a1a783f58f1e06da5b6f38”,“leverage”:“10”,“openPrice”:“180964175000”,“pairIndex”:“40”,“initialPosToken”:“68565938087067753066”,“positionSizeDai”:“0”}0xcf63914f5160e596bc574bf4fd52c13a8d270e28falsefalse179600000000311043210253596452022-02-26T16:21:23.000Z753837050890xbd4a873f182a75bf2e99057efa1ce8fcca8a20bc87f338cf54f85e4079889498149101199999999999999
Query with partition filter
SELECT *
FROM `tt-contracts.gainsnetwork_v6_polygon.GNSTradingCallbacks_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100