gainsnetwork_v5_polygon

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.

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_tInfo`	`STRUCT<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_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_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_tokenPriceDai`	`STRING`	Price of the protocol’s governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation.

Sample Data

in_t	address	removed	in_price	in_tInfo	log_index	in_orderId	block_number	in_nftHolder	in_orderType	block_timestamp	in_percentProfit	in_tokenPriceDai	transaction_hash	in_positionSizeDai
{“sl”:“0”,“tp”:“106287350000”,“buy”:true,“index”:“0”,“trader”:“0x126dee771c6ce4121833542264762432b67c9ecb”,“leverage”:“50”,“openPrice”:“105242137000”,“pairIndex”:“15”,“initialPosToken”:“42548352387319375092”,“positionSizeDai”:“0”}	0x7af43f23f33642c4ea8bf10211a26d5a028a555f	false	106290000000	{“tokenId”:“0”,“slLastUpdated”:“0”,“tokenPriceDai”:“7957436034”,“tpLastUpdated”:“0”,“openInterestDai”:“1692878962370925600117”,“beingMarketClosed”:false}	51	65274	21468625	0x9930fed40cb550e30b4671cfd9d77825cf077fdc	0	2021-11-17T07:45:38.000Z	497834341771	7992173536	0xa1e5f5b63d028092f5ae698520d5625dc8c4c35bee705d6548f5cc3180ddf5e1	33857579247418512002
{“sl”:“0”,“tp”:“2283804416666”,“buy”:true,“index”:“0”,“trader”:“0x126dee771c6ce4121833542264762432b67c9ecb”,“leverage”:“60”,“openPrice”:“2268133500000”,“pairIndex”:“13”,“initialPosToken”:“66892378808232740826”,“positionSizeDai”:“0”}	0x7af43f23f33642c4ea8bf10211a26d5a028a555f	false	2232810000000	{“tokenId”:“0”,“slLastUpdated”:“0”,“tokenPriceDai”:“7905544385”,“tpLastUpdated”:“0”,“openInterestDai”:“3172924018120304016060”,“beingMarketClosed”:false}	403	65534	21472256	0x877998df4eae3e230646a95d9a2bfc15f4ab2419	2	2021-11-17T09:57:49.000Z	-934429124211	7921937289	0x585378c18801458e5ac00a03ecf05ecfb5007aaa7b034c0236a579da78459e1a	52882066968671733601
{“sl”:“0”,“tp”:“2303270000000”,“buy”:true,“index”:“0”,“trader”:“0x126dee771c6ce4121833542264762432b67c9ecb”,“leverage”:“50”,“openPrice”:“2288143500000”,“pairIndex”:“13”,“initialPosToken”:“66576099185103692549”,“positionSizeDai”:“0”}	0x7af43f23f33642c4ea8bf10211a26d5a028a555f	false	2246900000000	{“tokenId”:“0”,“slLastUpdated”:“21471586”,“tokenPriceDai”:“7991437112”,“tpLastUpdated”:“21470811”,“openInterestDai”:“2660193549000153031021”,“beingMarketClosed”:false}	225	65472	21471808	0xf99f8337a8b4f0791effe21e3e048eef04842a1c	2	2021-11-17T09:42:25.000Z	-901243737554	7905544385	0xcbca128c1e519b6aca3da646544c0f47575f34ab47152a822c6e8ef110bddf2c	53203870980003060620

Example Query

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.

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_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_tokenPriceDai`	`STRING`	Price of the protocol’s governance or reward token denominated in DAI. String-encoded value 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	in_tokenPriceDai	transaction_hash	in_positionSizeDai
{“sl”:“11249093520”,“tp”:“11303132400”,“buy”:true,“index”:“0”,“trader”:“0xc75351e058038dfb1336e65eef37ff298e524513”,“leverage”:“250”,“openPrice”:“11257525640”,“pairIndex”:“21”,“initialPosToken”:“391068752061832229728”,“positionSizeDai”:“0”}	0x7af43f23f33642c4ea8bf10211a26d5a028a555f	true	false	11257525640	56	113060	22234026	2021-12-07T09:10:30.000Z	0	5147502480	0x0141a2b2ebaeb4eb683782f902eed36be88cb25fdfe9be1a361e3f83566d6494	201302737108878651586
{“sl”:“11249093520”,“tp”:“11303132400”,“buy”:true,“index”:“0”,“trader”:“0xc75351e058038dfb1336e65eef37ff298e524513”,“leverage”:“250”,“openPrice”:“11257525640”,“pairIndex”:“21”,“initialPosToken”:“391068752061832229728”,“positionSizeDai”:“0”}	0x7af43f23f33642c4ea8bf10211a26d5a028a555f	false	false	11263300000	97	113073	22234244	2021-12-07T09:20:10.000Z	128233329966	5142026288	0xeeca6c7eb2250703d34bd987b60a394c0379e1a3d446249b16b613398440a8c4	201302737108878651586
{“sl”:“0”,“tp”:“28422725000”,“buy”:true,“index”:“1”,“trader”:“0x0acc2043d0b177d2097e25b24fa1d5ecd89d671d”,“leverage”:“8”,“openPrice”:“13386373000”,“pairIndex”:“9”,“initialPosToken”:“82434448327983187471”,“positionSizeDai”:“0”}	0x7af43f23f33642c4ea8bf10211a26d5a028a555f	true	false	13386373000	210	112373	22223535	2021-12-07T02:42:26.000Z	0	6095130405	0x643e22f0bfb1c4e8d2abe957da1f28befba13805664304c0acbc1ff1964b3207	50244871242329173828

Example Query

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.

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_tInfo`	`STRUCT<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_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_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_tokenPriceDai`	`STRING`	Price of the protocol’s governance or reward token denominated in DAI. String-encoded value with extended precision for decimal representation.

Sample Data

in_t	address	removed	in_price	in_tInfo	log_index	in_orderId	block_number	in_nftHolder	block_timestamp	in_percentProfit	in_tokenPriceDai	transaction_hash	in_positionSizeDai
{“sl”:“470084000000000”,“tp”:“472776000000000”,“buy”:true,“index”:“0”,“trader”:“0x0db56c99b8ad68f35f4b1772a4ffed3fb16204f6”,“leverage”:“50”,“openPrice”:“469343906650000”,“pairIndex”:“0”,“initialPosToken”:“30330248234444051514”,“positionSizeDai”:“0”}	0x1e87e8703883a46ccdec4c8868043abe40235bed	false	472899000000000	{“tokenId”:“0”,“slLastUpdated”:“23250906”,“tokenPriceDai”:“31667990073”,“tpLastUpdated”:“23251626”,“openInterestDai”:“4802490000000000000096”,“beingMarketClosed”:false}	232	172935	23253045	0xb00d3c75969f6d8f6531e352e82f1dd1488b47be	2022-01-02T07:37:29.000Z	378730105965	33455928233	0x829e22d25a5e05ebe9a62ab6a0134137d56e09090c2a0a54732f3527225f90d0	96049800000000000001
{“sl”:“0”,“tp”:“9000000000”,“buy”:true,“index”:“0”,“trader”:“0x207d888427fdcdcf45fd8cc665c23b1da06ba666”,“leverage”:“5”,“openPrice”:“9069060000”,“pairIndex”:“45”,“initialPosToken”:“200365603244854460569”,“positionSizeDai”:“0”}	0x1e87e8703883a46ccdec4c8868043abe40235bed	false	9035000000	{“tokenId”:“0”,“slLastUpdated”:“0”,“tokenPriceDai”:“17415698820”,“tpLastUpdated”:“23116804”,“openInterestDai”:“1744753500000000000001”,“beingMarketClosed”:false}	19	173229	23266042	0x519e23e8d6b5e1682a1635df3419828dea858018	2022-01-02T15:25:58.000Z	-18778131360	30525077576	0x1924044ada9e0657ba87a8654a826a0087983338241ad23de0931143d516f5ed	348950700000000000000
{“sl”:“0”,“tp”:“38000400000000”,“buy”:true,“index”:“0”,“trader”:“0x3a5fd1e9ed261b798a2fee4ccb2b4835407e2c21”,“leverage”:“8”,“openPrice”:“36273127500000”,“pairIndex”:“1”,“initialPosToken”:“525432484344617043579”,“positionSizeDai”:“0”}	0x1e87e8703883a46ccdec4c8868043abe40235bed	false	38042000000000	{“tokenId”:“0”,“slLastUpdated”:“0”,“tokenPriceDai”:“18910379952”,“tpLastUpdated”:“23204492”,“openInterestDai”:“7948902334464000000011”,“beingMarketClosed”:false}	250	173305	23268178	0xb00d3c75969f6d8f6531e352e82f1dd1488b47be	2022-01-02T16:47:58.000Z	390122963618	30472181127	0xfec91ba9a11a7f351723ba5b2605cfa60aff16741b52ee011da7672ae82831a4	993612791808000000001

Example Query

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.

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_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_tokenPriceDai`	`STRING`	Price of the protocol’s governance or reward token denominated in DAI. String-encoded value 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	in_tokenPriceDai	transaction_hash	in_positionSizeDai
{“sl”:“10920000000”,“tp”:“9590000000”,“buy”:false,“index”:“0”,“trader”:“0x9bde27f18ca5e70157a0c05391ed9f430a900762”,“leverage”:“5”,“openPrice”:“10167308803”,“pairIndex”:“5”,“initialPosToken”:“32688583690909317270”,“positionSizeDai”:“0”}	0x1e87e8703883a46ccdec4c8868043abe40235bed	false	false	10478200000	316	241820	24292182	2022-01-29T05:15:10.000Z	-152887653470	39405164763	0xbe04c806609ff24f80da1bd76fa8a946956b3c3bd47bae60e5f93688182f54bd	124500624750000000003
{“sl”:“0”,“tp”:“11456486029”,“buy”:true,“index”:“0”,“trader”:“0x74daf8b664a5769c6bb490965e97b22b5b216fd3”,“leverage”:“100”,“openPrice”:“10510537642”,“pairIndex”:“5”,“initialPosToken”:“120660751631726182834”,“positionSizeDai”:“0”}	0x1e87e8703883a46ccdec4c8868043abe40235bed	false	false	10456170000	20	241627	24286311	2022-01-29T01:41:53.000Z	-517267944341	39077508734	0xc02e33a7dd7e44bb937d8e4f6f440aba74da7f33d44dd9a5fdd6ccfbc336c950	470400000000000000000
{“sl”:“0”,“tp”:“1704662493529”,“buy”:true,“index”:“0”,“trader”:“0x453970503c56c4086b9ddcf13d7992bad698ebdf”,“leverage”:“17”,“openPrice”:“1114587015000”,“pairIndex”:“13”,“initialPosToken”:“52884557732528718516”,“positionSizeDai”:“0”}	0x1e87e8703883a46ccdec4c8868043abe40235bed	true	false	1114587015000	31	243216	24316787	2022-01-29T20:36:13.000Z	0	38219451910	0x5f304a92be63b744752283c1324504e8456665793d5fe87d14a06a2e7396a850	202121881104000000001

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

GFarmTradingCallbacks_LimitExecuted_event

GFarmTradingCallbacks_MarketExecuted_event

GNSTradingCallbacks_LimitExecuted_event

GNSTradingCallbacks_MarketExecuted_event

​Tables

​GFarmTradingCallbacks_LimitExecuted_event

​GFarmTradingCallbacks_MarketExecuted_event

​GNSTradingCallbacks_LimitExecuted_event

​GNSTradingCallbacks_MarketExecuted_event

Tables

GFarmTradingCallbacks_LimitExecuted_event

GFarmTradingCallbacks_MarketExecuted_event

GNSTradingCallbacks_LimitExecuted_event

GNSTradingCallbacks_MarketExecuted_event