Skip to main content

​
Tables

​
GFarmTradingCallbacks_LimitExecuted_event

Limit order execution events from Gains Network (gTrade) v5 perpetual trading protocol on Polygon, capturing take-profit and stop-loss fills with position details, profit/loss percentages, and NFT bot executor addresses. Used for analyzing automated order execution performance and trader profit-taking behavior.
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_tInfoSTRUCT<tokenId STRING, tokenPriceDai STRING, openInterestDai STRING, tpLastUpdated STRING, slLastUpdated STRING, beingMarketClosed BOOL>Trade state information including token pricing, interest tracking, and last update timestamps. Contains tokenPriceDai for position valuation, openInterestDai for protocol exposure, and timestamps for stop-loss/take-profit modifications.
in_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_tokenPriceDaiSTRINGPrice of the protocol’s governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation.
in_taddressremovedin_pricein_tInfolog_indexin_orderIdblock_numberin_nftHolderin_orderTypein_limitIndexblock_timestampin_percentProfitin_tokenPriceDaitransaction_hashin_positionSizeDai
{“sl”:“0”,“tp”:“106287350000”,“buy”:true,“index”:“0”,“trader”:“0x126dee771c6ce4121833542264762432b67c9ecb”,“leverage”:“50”,“openPrice”:“105242137000”,“pairIndex”:“15”,“initialPosToken”:“42548352387319375092”,“positionSizeDai”:“0”}0x7af43f23f33642c4ea8bf10211a26d5a028a555ffalse106290000000{“tokenId”:“0”,“slLastUpdated”:“0”,“tokenPriceDai”:“7957436034”,“tpLastUpdated”:“0”,“openInterestDai”:“1692878962370925600117”,“beingMarketClosed”:false}5165274214686250x9930fed40cb550e30b4671cfd9d77825cf077fdc002021-11-17T07:45:38.000Z49783434177179921735360xa1e5f5b63d028092f5ae698520d5625dc8c4c35bee705d6548f5cc3180ddf5e133857579247418512002
{“sl”:“0”,“tp”:“2283804416666”,“buy”:true,“index”:“0”,“trader”:“0x126dee771c6ce4121833542264762432b67c9ecb”,“leverage”:“60”,“openPrice”:“2268133500000”,“pairIndex”:“13”,“initialPosToken”:“66892378808232740826”,“positionSizeDai”:“0”}0x7af43f23f33642c4ea8bf10211a26d5a028a555ffalse2232810000000{“tokenId”:“0”,“slLastUpdated”:“0”,“tokenPriceDai”:“7905544385”,“tpLastUpdated”:“0”,“openInterestDai”:“3172924018120304016060”,“beingMarketClosed”:false}40365534214722560x877998df4eae3e230646a95d9a2bfc15f4ab2419202021-11-17T09:57:49.000Z-93442912421179219372890x585378c18801458e5ac00a03ecf05ecfb5007aaa7b034c0236a579da78459e1a52882066968671733601
{“sl”:“0”,“tp”:“2303270000000”,“buy”:true,“index”:“0”,“trader”:“0x126dee771c6ce4121833542264762432b67c9ecb”,“leverage”:“50”,“openPrice”:“2288143500000”,“pairIndex”:“13”,“initialPosToken”:“66576099185103692549”,“positionSizeDai”:“0”}0x7af43f23f33642c4ea8bf10211a26d5a028a555ffalse2246900000000{“tokenId”:“0”,“slLastUpdated”:“21471586”,“tokenPriceDai”:“7991437112”,“tpLastUpdated”:“21470811”,“openInterestDai”:“2660193549000153031021”,“beingMarketClosed”:false}22565472214718080xf99f8337a8b4f0791effe21e3e048eef04842a1c202021-11-17T09:42:25.000Z-90124373755479055443850xcbca128c1e519b6aca3da646544c0f47575f34ab47152a822c6e8ef110bddf2c53203870980003060620
Query with partition filter
SELECT *
FROM `tt-contracts.gainsnetwork_v5_polygon.GFarmTradingCallbacks_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
GFarmTradingCallbacks_MarketExecuted_event

Market order execution events from Gains Network (gTrade) perpetual trading protocol on Polygon. Contains position opens/closes with entry/exit prices, profit/loss percentages, leverage, and stop-loss/take-profit levels for analyzing trader performance and protocol activity.
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_tokenPriceDaiSTRINGPrice of the protocol’s governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation.
in_taddressin_openremovedin_pricelog_indexin_orderIdblock_numberblock_timestampin_percentProfitin_tokenPriceDaitransaction_hashin_positionSizeDai
{“sl”:“11249093520”,“tp”:“11303132400”,“buy”:true,“index”:“0”,“trader”:“0xc75351e058038dfb1336e65eef37ff298e524513”,“leverage”:“250”,“openPrice”:“11257525640”,“pairIndex”:“21”,“initialPosToken”:“391068752061832229728”,“positionSizeDai”:“0”}0x7af43f23f33642c4ea8bf10211a26d5a028a555ftruefalse1125752564056113060222340262021-12-07T09:10:30.000Z051475024800x0141a2b2ebaeb4eb683782f902eed36be88cb25fdfe9be1a361e3f83566d6494201302737108878651586
{“sl”:“11249093520”,“tp”:“11303132400”,“buy”:true,“index”:“0”,“trader”:“0xc75351e058038dfb1336e65eef37ff298e524513”,“leverage”:“250”,“openPrice”:“11257525640”,“pairIndex”:“21”,“initialPosToken”:“391068752061832229728”,“positionSizeDai”:“0”}0x7af43f23f33642c4ea8bf10211a26d5a028a555ffalsefalse1126330000097113073222342442021-12-07T09:20:10.000Z12823332996651420262880xeeca6c7eb2250703d34bd987b60a394c0379e1a3d446249b16b613398440a8c4201302737108878651586
{“sl”:“0”,“tp”:“28422725000”,“buy”:true,“index”:“1”,“trader”:“0x0acc2043d0b177d2097e25b24fa1d5ecd89d671d”,“leverage”:“8”,“openPrice”:“13386373000”,“pairIndex”:“9”,“initialPosToken”:“82434448327983187471”,“positionSizeDai”:“0”}0x7af43f23f33642c4ea8bf10211a26d5a028a555ftruefalse13386373000210112373222235352021-12-07T02:42:26.000Z060951304050x643e22f0bfb1c4e8d2abe957da1f28befba13805664304c0acbc1ff1964b320750244871242329173828
Query with partition filter
SELECT *
FROM `tt-contracts.gainsnetwork_v5_polygon.GFarmTradingCallbacks_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
GNSTradingCallbacks_LimitExecuted_event

Limit order executions from Gains Network (GNS) v5 decentralized leverage trading protocol on Polygon, capturing take-profit and stop-loss triggers with profit/loss percentages and NFT bot executor addresses. Used for analyzing automated trade closures and position performance across trading pairs.
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_tInfoSTRUCT<tokenId STRING, tokenPriceDai STRING, openInterestDai STRING, tpLastUpdated STRING, slLastUpdated STRING, beingMarketClosed BOOL>Trade metadata and state information at execution time, including token price in DAI, last update blocks for stop-loss and take-pair orders, total open interest, and market closure status. Nested record structure containing supplementary position data used for settlement calculations.
in_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_tokenPriceDaiSTRINGPrice of the protocol’s governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation.
in_taddressremovedin_pricein_tInfolog_indexin_orderIdblock_numberin_nftHolderin_orderTypein_limitIndexblock_timestampin_percentProfitin_tokenPriceDaitransaction_hashin_positionSizeDai
{“sl”:“470084000000000”,“tp”:“472776000000000”,“buy”:true,“index”:“0”,“trader”:“0x0db56c99b8ad68f35f4b1772a4ffed3fb16204f6”,“leverage”:“50”,“openPrice”:“469343906650000”,“pairIndex”:“0”,“initialPosToken”:“30330248234444051514”,“positionSizeDai”:“0”}0x1e87e8703883a46ccdec4c8868043abe40235bedfalse472899000000000{“tokenId”:“0”,“slLastUpdated”:“23250906”,“tokenPriceDai”:“31667990073”,“tpLastUpdated”:“23251626”,“openInterestDai”:“4802490000000000000096”,“beingMarketClosed”:false}232172935232530450xb00d3c75969f6d8f6531e352e82f1dd1488b47be002022-01-02T07:37:29.000Z378730105965334559282330x829e22d25a5e05ebe9a62ab6a0134137d56e09090c2a0a54732f3527225f90d096049800000000000001
{“sl”:“0”,“tp”:“9000000000”,“buy”:true,“index”:“0”,“trader”:“0x207d888427fdcdcf45fd8cc665c23b1da06ba666”,“leverage”:“5”,“openPrice”:“9069060000”,“pairIndex”:“45”,“initialPosToken”:“200365603244854460569”,“positionSizeDai”:“0”}0x1e87e8703883a46ccdec4c8868043abe40235bedfalse9035000000{“tokenId”:“0”,“slLastUpdated”:“0”,“tokenPriceDai”:“17415698820”,“tpLastUpdated”:“23116804”,“openInterestDai”:“1744753500000000000001”,“beingMarketClosed”:false}19173229232660420x519e23e8d6b5e1682a1635df3419828dea858018002022-01-02T15:25:58.000Z-18778131360305250775760x1924044ada9e0657ba87a8654a826a0087983338241ad23de0931143d516f5ed348950700000000000000
{“sl”:“0”,“tp”:“38000400000000”,“buy”:true,“index”:“0”,“trader”:“0x3a5fd1e9ed261b798a2fee4ccb2b4835407e2c21”,“leverage”:“8”,“openPrice”:“36273127500000”,“pairIndex”:“1”,“initialPosToken”:“525432484344617043579”,“positionSizeDai”:“0”}0x1e87e8703883a46ccdec4c8868043abe40235bedfalse38042000000000{“tokenId”:“0”,“slLastUpdated”:“0”,“tokenPriceDai”:“18910379952”,“tpLastUpdated”:“23204492”,“openInterestDai”:“7948902334464000000011”,“beingMarketClosed”:false}250173305232681780xb00d3c75969f6d8f6531e352e82f1dd1488b47be002022-01-02T16:47:58.000Z390122963618304721811270xfec91ba9a11a7f351723ba5b2605cfa60aff16741b52ee011da7672ae82831a4993612791808000000001
Query with partition filter
SELECT *
FROM `tt-contracts.gainsnetwork_v5_polygon.GNSTradingCallbacks_LimitExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
GNSTradingCallbacks_MarketExecuted_event

Market order execution events from Gains Network v5 perpetual trading protocol on Polygon, recording position opens/closes with profit/loss, leverage, and trade parameters. Tracks trader activity across multiple trading pairs denominated in DAI stablecoin.
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_tokenPriceDaiSTRINGPrice of the protocol’s governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation.
in_taddressin_openremovedin_pricelog_indexin_orderIdblock_numberblock_timestampin_percentProfitin_tokenPriceDaitransaction_hashin_positionSizeDai
{“sl”:“10920000000”,“tp”:“9590000000”,“buy”:false,“index”:“0”,“trader”:“0x9bde27f18ca5e70157a0c05391ed9f430a900762”,“leverage”:“5”,“openPrice”:“10167308803”,“pairIndex”:“5”,“initialPosToken”:“32688583690909317270”,“positionSizeDai”:“0”}0x1e87e8703883a46ccdec4c8868043abe40235bedfalsefalse10478200000316241820242921822022-01-29T05:15:10.000Z-152887653470394051647630xbe04c806609ff24f80da1bd76fa8a946956b3c3bd47bae60e5f93688182f54bd124500624750000000003
{“sl”:“0”,“tp”:“11456486029”,“buy”:true,“index”:“0”,“trader”:“0x74daf8b664a5769c6bb490965e97b22b5b216fd3”,“leverage”:“100”,“openPrice”:“10510537642”,“pairIndex”:“5”,“initialPosToken”:“120660751631726182834”,“positionSizeDai”:“0”}0x1e87e8703883a46ccdec4c8868043abe40235bedfalsefalse1045617000020241627242863112022-01-29T01:41:53.000Z-517267944341390775087340xc02e33a7dd7e44bb937d8e4f6f440aba74da7f33d44dd9a5fdd6ccfbc336c950470400000000000000000
{“sl”:“0”,“tp”:“1704662493529”,“buy”:true,“index”:“0”,“trader”:“0x453970503c56c4086b9ddcf13d7992bad698ebdf”,“leverage”:“17”,“openPrice”:“1114587015000”,“pairIndex”:“13”,“initialPosToken”:“52884557732528718516”,“positionSizeDai”:“0”}0x1e87e8703883a46ccdec4c8868043abe40235bedtruefalse111458701500031243216243167872022-01-29T20:36:13.000Z0382194519100x5f304a92be63b744752283c1324504e8456665793d5fe87d14a06a2e7396a850202121881104000000001
Query with partition filter
SELECT *
FROM `tt-contracts.gainsnetwork_v5_polygon.GNSTradingCallbacks_MarketExecuted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100