gainsnetwork_v7_polygon

Tables

GNSTradingCallbacks_LimitExecuted_event

Limit order execution events from gTrade v7 perpetual futures protocol on Polygon, capturing take-profit and stop-loss fills with trader addresses, position details, profit/loss percentages, and NFT holder (bot executor) information. Used for analyzing limit order fill rates, trader PnL outcomes, and bot executor 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_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”:“242060000000000”,“buy”:true,“index”:“0”,“trader”:“0x00f38738c8f5cf18292c2a135473ba635d542949”,“leverage”:“150”,“openPrice”:“241111799952589”,“pairIndex”:“0”,“initialPosToken”:“3460100440000531812”,“positionSizeDai”:“0”}	0x170cc5a70d6f544e5456881b586eb58180998a37	false	242060000000000	75	1391454	31821233	0x12b4cf2e72f813a66b6c58583f81c22926aaf861	2022-08-12T22:36:48.000Z	589892353421	0x33f17e00df724d104bedcccb5aac9243c4fdc756ffd2ab14689d1fa4c4a2316f	13449499862352911607	9099999998634999999
{“sl”:“0”,“tp”:“12205100000”,“buy”:true,“index”:“0”,“trader”:“0x022e3ce4eda264b3e3fef62036c8182ceb88e6ce”,“leverage”:“1000”,“openPrice”:“12190517332”,“pairIndex”:“23”,“initialPosToken”:“148759553821525346718”,“positionSizeDai”:“0”}	0x170cc5a70d6f544e5456881b586eb58180998a37	false	12205100000	49	1390048	31797168	0x5c22cf89ced9a14d5ecf711442f91ed6db1ff646	2022-08-12T06:43:42.000Z	1196230447228	0x5e043be7a528f5dafcbc22dfc47021913d37770ddee7cd352f642b8b57dab312	831491613725326022260	393671999606327999999
{“sl”:“0”,“tp”:“1589009345794”,“buy”:false,“index”:“0”,“trader”:“0x2ae4f1b01f06fa0a28bb0c9dbc098ae12b56aaca”,“leverage”:“107”,“openPrice”:“1604000000000”,“pairIndex”:“51”,“initialPosToken”:“5351082188441961157”,“positionSizeDai”:“0”}	0x170cc5a70d6f544e5456881b586eb58180998a37	false	1589009345794	186	1389779	31790088	0x2430403186b3a9e08ba7264fbb924447cb7a31d6	2022-08-12T02:14:43.000Z	1000000000026	0x7486da66a7247d454d8383f88635c45a8c4f78205fdf1e88fb6104444044442e	27140466084380896542	14194495138481189022

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gainsnetwork_v7_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 (GNS) v7 perpetual trading protocol on Polygon. Contains trade fills with execution prices, profit/loss, position sizes in DAI stablecoin, and leverage data for tracking 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_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	in_percentProfit	transaction_hash	in_daiSentToTrader	in_positionSizeDai
{“sl”:“0”,“tp”:“10150077857142”,“buy”:false,“index”:“0”,“trader”:“0x740320f15bf19a2ece2eb13576e69fd6700bb8d4”,“leverage”:“35”,“openPrice”:“10223083312004”,“pairIndex”:“41”,“initialPosToken”:“79316612426541511842”,“positionSizeDai”:“0”}	0x170cc5a70d6f544e5456881b586eb58180998a37	true	false	10223083312004	41	1346377	30937533	2022-07-20T13:13:03.000Z	76163782	0	0x2416f7792cff707514db46a9dc415649f1c418f8732e50c4fb5326c3d53e6197	0	97899999996573499999
{“sl”:“0”,“tp”:“11158221000”,“buy”:true,“index”:“0”,“trader”:“0xc1f2e41d6b924eee7732e07ea25850cdbffb6381”,“leverage”:“100”,“openPrice”:“10236900000”,“pairIndex”:“21”,“initialPosToken”:“2519049563819368800555”,“positionSizeDai”:“0”}	0x170cc5a70d6f544e5456881b586eb58180998a37	false	false	10220125000	26	1346669	30939918	2022-07-20T14:38:49.000Z	0	-163867967841	0x23cc83dde342c387196ee2e1b0e85fc01b60fc5f40882dd19843b96da63ddcf0	2490316752363977342887	2976035999702396400000
{“sl”:“0”,“tp”:“9868975204”,“buy”:false,“index”:“0”,“trader”:“0x27be3c0b106371b3ced192375b041957a42b842f”,“leverage”:“250”,“openPrice”:“10237526145”,“pairIndex”:“21”,“initialPosToken”:“79476739451018743703”,“positionSizeDai”:“0”}	0x170cc5a70d6f544e5456881b586eb58180998a37	true	false	10237526145	175	1346037	30930292	2022-07-20T08:51:16.000Z	0	0	0xfddb85460e39d132307fe2b326f61bc626de649570403c7843f091a472c586c9	0	98499999975375000000

Example Query

Query with partition filter

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

GNSTradingCallbacksV2_DevGovFeeCharged_event

Development and governance fee collection events from Gains Network v7 perpetual trading protocol on Polygon. Records DAI-denominated fees charged on trade executions for protocol maintenance and governance operations.

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_valueDai`	`STRING`	Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places).

Sample Data

address	removed	log_index	in_valueDai	block_number	block_timestamp	transaction_hash
0x6805dd635aa542210ed572f7b93121002c629690	false	1	930600000000000000	34557545	2022-10-20T00:52:01.000Z	0x2c865c7121378f81371b1e567572502b41685dab1bc1f03028ea2487b901588a
0x6805dd635aa542210ed572f7b93121002c629690	false	1	14928795000000000000	34589976	2022-10-20T20:03:02.000Z	0xd8ed7d5443dbe149e0b6395e5b45ae3d9f79929b50b2d71873498dbfa83ade0d
0x6805dd635aa542210ed572f7b93121002c629690	false	1	223199999999999998	34580689	2022-10-20T14:25:41.000Z	0x07054720938b54e8eb9b928f7cb0b79a663cb4ec3aae3bd118fc059d07e59047

Example Query

Query with partition filter

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

GNSTradingCallbacksV2_LimitExecuted_event

Limit order execution events from Gains Network (gTrade) v7 perpetual trading protocol on Polygon, recording take-profit and stop-loss fills with position details and profit/loss in DAI stablecoin. Used for analyzing trader performance, leverage usage, and automated order execution patterns.

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”:“5380000000”,“buy”:true,“index”:“0”,“trader”:“0x6f9b961c6aa36fe989b3adbc3ade71501951da5e”,“leverage”:“37”,“openPrice”:“5282491243”,“pairIndex”:“19”,“initialPosToken”:“152819574531920935856”,“positionSizeDai”:“359048000000000000000”}	0x6805dd635aa542210ed572f7b93121002c629690	false	5380000000	261	1496693	34137592	0xb00d3c75969f6d8f6531e352e82f1dd1488b47be	2022-10-09T18:53:43.000Z	682977754819	0x42ad79fdf05c42b30dc38aed7e570eda5e96500fdd5f2bfb05647907a2d12655	591890361683162375987	359047999999999999998
{“sl”:“0”,“tp”:“64228483666”,“buy”:true,“index”:“0”,“trader”:“0x1f5e2d8f5177b374958e20796072ad0b29f47472”,“leverage”:“150”,“openPrice”:“64008969765”,“pairIndex”:“11”,“initialPosToken”:“18677502904297990802”,“positionSizeDai”:“43120000000000000000”}	0x6805dd635aa542210ed572f7b93121002c629690	false	64228483666	148	1496582	34130989	0x7ca659f1d19bbc342dd1027104e27cf4cdb38739	2022-10-09T15:06:42.000Z	514413609075	0x914071538ff16e7e506e1bc8d044567c453d72c1dab48ce63042f94e2a7d87eb	60085006291807923887	43119999999999999997
{“sl”:“0”,“tp”:“8792400000000”,“buy”:true,“index”:“0”,“trader”:“0x1e742285cc17bad26a307b4c781c96d29f0b3c21”,“leverage”:“20”,“openPrice”:“8716000000000”,“pairIndex”:“41”,“initialPosToken”:“32392833481100902538”,“positionSizeDai”:“73800000000000000000”}	0x6805dd635aa542210ed572f7b93121002c629690	false	8792400000000	151	1496355	34119140	0x7ca659f1d19bbc342dd1027104e27cf4cdb38739	2022-10-09T08:10:39.000Z	175309775126	0x45c98a93697f6f11749aa3b914756c357bb96f551a850069d9d670efee4e6f8b	88094517859163698739	73799999999999999998

Example Query

Query with partition filter

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

GNSTradingCallbacksV2_LpFeeCharged_event

Liquidity provider fee events from Gains Network v7 leveraged trading protocol on Polygon, recording DAI-denominated fees charged per trade execution. Useful for analyzing LP revenue distribution and protocol fee structure.

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_valueDai`	`STRING`	Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places).

Sample Data

address	removed	log_index	in_valueDai	block_number	block_timestamp	transaction_hash
0x6805dd635aa542210ed572f7b93121002c629690	false	3	487999999999999999	34716283	2022-10-23T21:51:16.000Z	0x582a656f6d0c1e94164e6201c6ec232354255715f1f8fc2e5c7d94b69347f0ba
0x6805dd635aa542210ed572f7b93121002c629690	false	3	220499999999999999	34684841	2022-10-23T03:27:54.000Z	0xb00d1530bc9fac21d2a0d2ff48eed4645fd6fd92922dc9c8e51859897e1226f1
0x6805dd635aa542210ed572f7b93121002c629690	false	3	188373023999999999	34718361	2022-10-23T23:02:45.000Z	0x6e293a2ae75c2cb0ff711554b79cb6095c66f312a105a1b666df8e1870b50204

Example Query

Query with partition filter

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

GNSTradingCallbacksV2_MarketExecuted_event

Market order execution events from Gains Network (gTrade) V7 perpetual trading protocol on Polygon. Contains position open/close details including leverage, profit/loss, price impact, and DAI settlement amounts for analyzing trader behavior and execution quality.

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”:“367217685000”,“tp”:“371830972500”,“buy”:true,“index”:“0”,“trader”:“0x014f5918c712505d4d557402ede7f88671c61a42”,“leverage”:“100”,“openPrice”:“368773065668”,“pairIndex”:“33”,“initialPosToken”:“11660680700801439737”,“positionSizeDai”:“46000000000000000000”}	0x6805dd635aa542210ed572f7b93121002c629690	true	false	368773065668	11	1567236	35249749	2022-11-05T23:19:01.000Z	198171056	0x77adf88db5348bac99e59259150562147167812c1982ed0c8b01d6f4b1b26962	45999999999999999996
{“sl”:“365729165000”,“tp”:“371242670000”,“buy”:true,“index”:“0”,“trader”:“0x014f5918c712505d4d557402ede7f88671c61a42”,“leverage”:“100”,“openPrice”:“367766995076”,“pairIndex”:“33”,“initialPosToken”:“11589832806834591002”,“positionSizeDai”:“46000000000000000000”}	0x6805dd635aa542210ed572f7b93121002c629690	true	false	367766995076	15	1567000	35245618	2022-11-05T20:49:45.000Z	454284757	0x35c5f19ed65bb3300640b541a59beaaa1033f6a0e867fe28edc4b4b7ae6b13d2	45999999999999999998
{“sl”:“16233425000000”,“tp”:“16437362500000”,“buy”:true,“index”:“0”,“trader”:“0x014f5918c712505d4d557402ede7f88671c61a42”,“leverage”:“100”,“openPrice”:“16315874309970”,“pairIndex”:“1”,“initialPosToken”:“11569009141262985077”,“positionSizeDai”:“46000000000000000000”}	0x6805dd635aa542210ed572f7b93121002c629690	true	false	16315874309970	81	1567045	35246523	2022-11-05T21:21:41.000Z	752858876	0xf8fe5dbeb9aa4207e6b64a42587ab53ab0a293fc3351a01796efffc979b816a9	45999999999999999999

Example Query

Query with partition filter

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

GNSTradingCallbacksV2_NftBotFeeCharged_event

NFT bot execution fees charged in DAI on Gains Network v7 perpetual trading protocol on Polygon. Tracks automated bot operator compensation for executing limit orders and stop losses.

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_valueDai`	`STRING`	Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places).

Sample Data

address	removed	log_index	in_valueDai	block_number	block_timestamp	transaction_hash
0x6805dd635aa542210ed572f7b93121002c629690	false	8	569600000000000000	34210216	2022-10-11T12:58:07.000Z	0xd9e4275af84474c54b543671921e4dc793f7b50a2e02fe47d3a72b95ff95099a
0x6805dd635aa542210ed572f7b93121002c629690	false	14	300000000000000000	34226713	2022-10-11T22:27:57.000Z	0x359794aa817ec9ac65882b7bf485c32a4c1d1517bddf4883d5d9ee9e00d76396
0x6805dd635aa542210ed572f7b93121002c629690	false	14	528000000040499999	34188432	2022-10-11T00:17:53.000Z	0xeb9ff0bd0d83a5c10e9165455a4cd320fbf19e0b77a955cb9a032c729b9d1d04

Example Query

Query with partition filter

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

GNSTradingCallbacksV2_ReferralFeeCharged_event

Referral fee charges from Gains Network (gTrade) v7 perpetual trading protocol on Polygon, denominated in DAI with 18 decimal precision. Tracks commission payments to referrers when their referred traders execute 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_valueDai`	`STRING`	Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places).

Sample Data

address	removed	log_index	in_valueDai	block_number	block_timestamp	transaction_hash
0x6805dd635aa542210ed572f7b93121002c629690	false	5	7097945097000000000	36337179	2022-12-02T14:06:04.000Z	0x6637bcd41f72e17ee3713a931475956c32a166418c281e06efce0467f15fe233
0x6805dd635aa542210ed572f7b93121002c629690	false	10	1881584712500000000	36350846	2022-12-02T22:22:26.000Z	0x84c6bcf83a712e564f6dd4967dc6b6d9322ce808290868c1267a1fd0ef83792a
0x6805dd635aa542210ed572f7b93121002c629690	false	16	1374636439200000000	36338330	2022-12-02T14:48:20.000Z	0x4f1b389878f8dd68fe15360ce18362658bde3bcaab3e34246938dde9f11d2d08

Example Query

Query with partition filter

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

GNSTradingCallbacksV2_SssFeeCharged_event

SSS (spread, slippage, and system) fee charges from Gains Network v7 perpetual trading protocol on Polygon. Tracks DAI-denominated fees collected per trade 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_valueDai`	`STRING`	Fee amount denominated in DAI. String-encoded integer representing the value in wei (18 decimal places).

Sample Data

address	removed	log_index	in_valueDai	block_number	block_timestamp	transaction_hash
0x6805dd635aa542210ed572f7b93121002c629690	false	6	334800000000000000	33733623	2022-09-30T00:33:38.000Z	0xf540fee8283149d8863b2703166c89c36c973978f14f7a525dd89148ed1c3c25
0x6805dd635aa542210ed572f7b93121002c629690	false	6	5000000000000000000	33770771	2022-09-30T22:16:07.000Z	0x98b626c80ed1e0a83c110de3f254550e73c373864a0cd2105b70015352ec2930
0x6805dd635aa542210ed572f7b93121002c629690	false	6	9468000000000000000	33757727	2022-09-30T14:38:23.000Z	0x445027bfe88ca339e754d284b04e125a74eeb88e3adf5b9b17397e9a505d30ec

Example Query

Query with partition filter

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

GNSTradingCallbacksV3_DevGovFeeCharged_event

Development and governance fee charges from Gains Network v7 perpetual trading protocol on Polygon. Records DAI-denominated fees collected from traders, useful for analyzing protocol revenue and fee distribution patterns.

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
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x00c62977286812f359805a741f850c4aecbe22c8	65	8610000000000000000	38453003	2023-01-24T02:56:20.000Z	0x135734c47b6e2f0ce20cc5e537b40873272d382b364be9847766dc68aa048dbb
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x015f6d443fc7384c1454a2c15d6e7acad97e5358	73	11520000000000000000	38467477	2023-01-24T11:33:08.000Z	0xac588457d111aa0ae0e649a1a5d46edc7d2ca8be2faaaa049d925184b323515f
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x01b30ca1bdde1f68abe69c46fe88f79b496ec63a	81	1782000000000000000	38451426	2023-01-24T01:58:53.000Z	0x41609248dddd3601458015d1dd6ccdc090439430992a761847557a2b5ac988cd

Example Query

Query with partition filter

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

GNSTradingCallbacksV3_LimitExecuted_event

Limit order execution events from Gains Network (gTrade) v7 perpetual trading protocol on Polygon, capturing take-profit, stop-loss, and pending order fills with position details and profit/loss outcomes. Used for analyzing trader limit order strategies and execution quality 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_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_orderType	block_timestamp	in_percentProfit	transaction_hash	in_daiSentToTrader	in_positionSizeDai
{“sl”:“226935720000000”,“tp”:“245000000000000”,“buy”:true,“index”:“0”,“trader”:“0x007d142b804c417bc177b394d80e8922e17aa23d”,“leverage”:“10”,“openPrice”:“229217750440000”,“pairIndex”:“0”,“initialPosToken”:“32045967449323986096”,“positionSizeDai”:“153760000000000000000”}	0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	226935720000000	113	1787177	38486517	0x3755d7c8f37eced3a3d2e6062d43674ba2ac61a6	1	2023-01-24T23:09:47.000Z	-99557317686	0x4a014ebf8a8b2fb01d5a88d4b1c64f8f79dfa1196e9a85059ec39adefa5931e7	137145357119359740999	153759999999999999998
{“sl”:“0”,“tp”:“261574968750000”,“buy”:true,“index”:“0”,“trader”:“0x015f6d443fc7384c1454a2c15d6e7acad97e5358”,“leverage”:“64”,“openPrice”:“229371962100000”,“pairIndex”:“0”,“initialPosToken”:“60443116422840111469”,“positionSizeDai”:“284640000000000000000”}	0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	226059000000000	54	1787220	38486762	0x7676d49df89c7cf60953beb193724bd6403b8eb0	2	2023-01-24T23:18:34.000Z	-924391858790	0xb87f98db23494113fff867c44aa9b7c9f4374d39d61c59e450af81e15d92a349	0	284639999999999999995
{“sl”:“0”,“tp”:“58667076000”,“buy”:true,“index”:“0”,“trader”:“0x01989c3c9949263da86ada9d96ea1a067d3b1c68”,“leverage”:“50”,“openPrice”:“58366682904”,“pairIndex”:“55”,“initialPosToken”:“139705533476006454884”,“positionSizeDai”:“672000000000000000000”}	0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	57263000000	55	1786324	38481748	0xd31bbd976efdf03496381906d55a6a70a6c805c1	2	2023-01-24T20:17:22.000Z	-945473384032	0x9443b5dcafdba07937fa5dec705bf800e57e7b46d15f221b92b15d675cbe5ae4	0	671999999999999999996

Example Query

Query with partition filter

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

GNSTradingCallbacksV3_LpFeeCharged_event

Liquidity provider fee events from Gains Network v7 perpetual trading protocol on Polygon, denominated in DAI. Tracks fees charged to traders for providing liquidity depth, useful for analyzing LP revenue and trading cost structure.

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
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x08787e3157742bec8d50cca49c8dfaf01cd6dabf	10	1596291375000000000	37251617	2022-12-25T08:19:10.000Z	0x5bb75b95793f15d703ce6a631af915f58bb68d8860846dea21e69b3dcc0955ef
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x0c06dd9d31013ca249535c1c538ead6974772304	277	441599999999999999	37262031	2022-12-25T14:35:19.000Z	0x1b1078af6aef3573b3b4b97d446af23d0e33ccbd1c096277a718bc1a73f40a23
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x0da76cbaeff1d40871d18498a6f26e5aa96961e9	23	4988159999999999999	37270367	2022-12-25T19:41:17.000Z	0xb3cbe9837bddc1e1b2633c9d82900e8843fdfeef6599c2833402fbc92d1c6ea3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.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 V7 perpetual trading protocol on Polygon. Records position opens/closes with execution price, profit/loss, leverage, and trader details for analyzing trade outcomes 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_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	in_percentProfit	transaction_hash	in_daiSentToTrader	in_positionSizeDai
{“sl”:“211120000000000”,“tp”:“208700000000000”,“buy”:false,“index”:“0”,“trader”:“0x011c79c3f951dc3d26fb08d226b60a7653753a95”,“leverage”:“100”,“openPrice”:“210055782237995”,“pairIndex”:“0”,“initialPosToken”:“13935280365629817504”,“positionSizeDai”:“47840000000000000000”}	0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	true	false	210055782237995	15	1754888	38156701	2023-01-16T15:49:32.000Z	472117066	0	0x197a878c611898aa0e23348d5d6bdd2ee5dea41efe968e796c1de0eabc0ab41e	0	47839999999999999998
{“sl”:“0”,“tp”:“8594349800”,“buy”:false,“index”:“0”,“trader”:“0x011c79c3f951dc3d26fb08d226b60a7653753a95”,“leverage”:“150”,“openPrice”:“8645031423”,“pairIndex”:“37”,“initialPosToken”:“2538602866828051224”,“positionSizeDai”:“8800000000000000000”}	0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	true	false	8645031423	72	1756207	38166750	2023-01-16T21:46:40.000Z	516628401	0	0xafdda28ca1163ea6863fb46428ab40b469ac947cce01cb88e668f6b63c992a3f	0	8799999999999999998
{“sl”:“15670000000000”,“tp”:“0”,“buy”:true,“index”:“1”,“trader”:“0x01f699f01e346e84864413850a3b8272b353ef87”,“leverage”:“15”,“openPrice”:“15994214545979”,“pairIndex”:“1”,“initialPosToken”:“57119992749223604241”,“positionSizeDai”:“197600000000000000000”}	0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	false	15792800000000	54	1756090	38166151	2023-01-16T21:26:06.000Z	0	-188894439361	0xe72eadb4ecc051fff80430c46b23e4ad53a9b697992ae56f20d6fba43c5f9b6c	157499953196891344013	197155399999999999999

Example Query

Query with partition filter

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

GNSTradingCallbacksV3_NftBotFeeCharged_event

NFT bot execution fees charged on Gains Network v7 perpetual trading protocol on Polygon, denominated in DAI. Records automated trading bot fees with trader addresses and fee amounts in 18-decimal DAI format for analyzing bot-assisted 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
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x0052d2e4af4548e6cf19e817b944cedb23ae09df	441	292799999999999999	41204560	2023-04-06T08:00:50.000Z	0xbd97feacd613fb4a55d6b46769586f0e98ae14b59e025ebd432f4622c491db86
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x0052d2e4af4548e6cf19e817b944cedb23ae09df	187	292799999999999999	41193745	2023-04-06T01:31:53.000Z	0x0576d234eb1efbd20c3f1c259f454b726128298df1399817b8ab237f0ce9d6c5
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x02df44db75d2b06e6f80797ae3ee4609a0235f66	519	158015999999999999999	41204239	2023-04-06T07:48:54.000Z	0xa31a9a26a36fedb2bdf56d06c093c6aafea258c10e84f7cd4c913b39f79643d6

Example Query

Query with partition filter

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

GNSTradingCallbacksV3_ReferralFeeCharged_event

Referral fee charges from Gains Network (GNS) v7 perpetual trading protocol on Polygon, recording DAI-denominated commission amounts paid when traders execute positions through referral links. Used to track 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
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x032a8848cecee8e915d57148cee6f5b7935e843f	121	232598148000000000	41109785	2023-04-03T21:46:22.000Z	0x4587f26deda8c1771f750c0f99634821013e6212d5989fc61ac84426b762deb5
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x032a8848cecee8e915d57148cee6f5b7935e843f	128	255844487250000000	41086997	2023-04-03T07:27:39.000Z	0x52049a004cf0a216cc3bfd8cc6d237f8b639afef1083b80731e64b1f118cfcc1
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x05bb4f77f69b6f85b334fc03ef16b8b3bb2bab7a	16	232592555160000000	41107011	2023-04-03T19:57:55.000Z	0x474a9ad6c84a1767149cf0d35c7e669c4b1dd575eb1b44567efd96b445bfc24c

Example Query

Query with partition filter

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

GNSTradingCallbacksV3_SssFeeCharged_event

SSS (Spread Staking System) fee charges from Gains Network v7 perpetual trading protocol on Polygon. Records DAI-denominated fees collected per trader 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
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x01ba06eb3b222abb1a4b66f3a2f94f2311a4ea5c	146	1106079999999999998	40425451	2023-03-16T20:54:13.000Z	0xa99dc81c6b5013573d14ac526ae2ef44aa4f4b236d762adab8d12ae44400a56f
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x01ba06eb3b222abb1a4b66f3a2f94f2311a4ea5c	97	787200000000000000	40425732	2023-03-16T21:04:43.000Z	0x5a01df09c47d1b68a6d0b14b2df761d4990ddb615d80cd5bd84bace9dcafa02d
0xb454d8a8c98035c65bb73fe2a11567b9b044e0fa	false	0x01ba06eb3b222abb1a4b66f3a2f94f2311a4ea5c	17	766087199999999998	40418596	2023-03-16T16:41:14.000Z	0x2b08328e17db416c1ad2f4c2778ae94847d7762cbe5dc0a0c053be45c84aeb7e

Example Query

Query with partition filter

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

GNSTradingCallbacksV3v1_DevGovFeeCharged_event

Development and governance fee charges from Gains Network v7 on Polygon. Records DAI-denominated fees collected from traders, 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
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x01c594464a822c36d20bd42e05e4dd76144bbeae	28	1020000000000000000	41483102	2023-04-13T12:03:22.000Z	0x3c138dcf294de3e6ebadd4d2d62383b7a055cd755a431ecb2898c67adf706e0b
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x01c594464a822c36d20bd42e05e4dd76144bbeae	116	2490000000000000000	41485085	2023-04-13T13:24:16.000Z	0xbb41906273f3d9d2340a28600fd39d82c65981d41ecb9bfb60be78ed2406206e
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x01c594464a822c36d20bd42e05e4dd76144bbeae	85	4020000000000000000	41484745	2023-04-13T13:11:10.000Z	0x457b6bdb620b4ef2f3199473e6869c2894e622a1f2c71fc13d4855569fb47b26

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.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) v7 perpetual futures protocol on Polygon, capturing stop-loss and take-profit order fills with entry/exit prices, position sizes in DAI stablecoin, profit/loss percentages, and NFT bot executor addresses for analyzing automated trade closures.

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_orderType	block_timestamp	in_percentProfit	transaction_hash	in_daiSentToTrader	in_positionSizeDai
{“sl”:“271218000000000”,“tp”:“267334000000000”,“buy”:false,“index”:“0”,“trader”:“0x2103a7ea588c939724f42e959ddb3b2e402351f8”,“leverage”:“3”,“openPrice”:“267951826380000”,“pairIndex”:“0”,“initialPosToken”:“390370467807942110407”,“positionSizeDai”:“1562241600000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	271218000000000	493	2073201	44111277	0xfe3be3c5d37c3610a8491e241953b57da9c8e09e	1	2023-06-20T01:13:57.000Z	-36568218221	0xdd6fe3d0435de3d9f7dbd33a20915cc5c37510e0c2c50a15445fcf8058e65146	1500582951381172924671	1561538591280000000000
{“sl”:“17252560855263”,“tp”:“17537256578947”,“buy”:true,“index”:“0”,“trader”:“0x7e087274232dd9378b6f1b972f58f8d419acc5b6”,“leverage”:“76”,“openPrice”:“17303018440000”,“pairIndex”:“1”,“initialPosToken”:“4695829426344002767”,“positionSizeDai”:“18784000000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	17252560855263	53	2073587	44119312	0x2430403186b3a9e08ba7264fbb924447cb7a31d6	1	2023-06-20T06:10:12.000Z	-221624709775	0x8757b6951a593b9dc7c460c1d0d668dbef5a4e98d9f71da3db6832e41573ffe4	13025012875183904002	18783999999999999998
{“sl”:“10550000000”,“tp”:“11110000000”,“buy”:true,“index”:“0”,“trader”:“0x7490da388759d3b069546cf45dc10d40d706bd79”,“leverage”:“4”,“openPrice”:“10020312691”,“pairIndex”:“109”,“initialPosToken”:“124819884309165177999”,“positionSizeDai”:“498400000000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	10550000000	172	2074802	44139889	0x4eaca3a7fca2b5448c0687f2f4d13980bc0c198f	1	2023-06-20T19:06:07.000Z	211445421049	0xd1b7a379616700fbe7b86dd72fef554af098b2f7b799e10343fe31f5887d940a	598627030742859022521	497802099424000000004

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.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_v7_polygon.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 v7 perpetual futures protocol on Polygon. Records position opens and closes with execution price, profit/loss, and collateral flows in DAI for analyzing trader performance and leverage usage.

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	in_percentProfit	transaction_hash	in_daiSentToTrader	in_positionSizeDai
{“sl”:“0”,“tp”:“637500000000”,“buy”:false,“index”:“0”,“trader”:“0x98151e452414756a0fe795dbc51f876fcc3963a8”,“leverage”:“8”,“openPrice”:“1020000000000”,“pairIndex”:“105”,“initialPosToken”:“126881778614519360882”,“positionSizeDai”:“496800000000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	false	1000640000000	75	2061833	43836802	2023-06-12T19:03:06.000Z	0	151843137254	0xf4b764dc51a08f93063f1a84706aaaba090160aa33ceed1156bd308fc1e02511	558958087216238399998	496799999999999999996
{“sl”:“0”,“tp”:“10852904900”,“buy”:true,“index”:“0”,“trader”:“0xdc1b9a875e97987f637f5dbc5660dd7990c8830e”,“leverage”:“1000”,“openPrice”:“10756825575”,“pairIndex”:“21”,“initialPosToken”:“11013867568241254817”,“positionSizeDai”:“43120000000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	true	false	10756825575	14	2061541	43830944	2023-06-12T15:14:13.000Z	0	0	0xa1037fe7c1978b14c4197c6d962404184fa6e2d3ad99cb88601bc106218bbb10	0	43119999999999999997
{“sl”:“11742093000”,“tp”:“11950000000”,“buy”:true,“index”:“0”,“trader”:“0x3331deca24e58144114e250c4598f99b77cc1ed9”,“leverage”:“25”,“openPrice”:“11850657643”,“pairIndex”:“104”,“initialPosToken”:“25207343704631801097”,“positionSizeDai”:“98000000000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	true	false	11850657643	25	2061861	43837400	2023-06-12T19:26:39.000Z	55497345	0	0x5b3c7365380f63124ed2f9cb27cdac366b2f31f5a1186650a20cb2e835f421a8	0	97999999999999999997

Example Query

Query with partition filter

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

GNSTradingCallbacksV3v1_NftBotFeeCharged_event

NFT bot fee charges from Gains Network V7 trading callbacks on Polygon, recording DAI-denominated fees paid by traders for automated bot execution services. Useful for analyzing bot usage costs and trader automation patterns.

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
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x0052d2e4af4548e6cf19e817b944cedb23ae09df	34	296399999999999999	46625784	2023-08-22T17:43:24.000Z	0xf1b1ec3a2ac664ed4d847cbe5ce49cbf4a3ba7a941ae8ecb56a7c2be12c727c6
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x01c594464a822c36d20bd42e05e4dd76144bbeae	106	318719999999999999	46623351	2023-08-22T16:14:14.000Z	0x66955583783755b965a26e17d405fe45e3b7a9660c906ac3d393f4d26874c216
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x01c594464a822c36d20bd42e05e4dd76144bbeae	223	318719999999999999	46619683	2023-08-22T14:01:29.000Z	0xe6625133b1382ed0252edd787860ba779676cef72a82fd2f02778655d947d41f

Example Query

Query with partition filter

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

GNSTradingCallbacksV3v1_ReferralFeeCharged_event

Referral fee records from Gains Network (GNS) v7 trading protocol on Polygon, tracking DAI-denominated commissions charged on referred trades. Used for analyzing referral program performance and fee distribution across traders.

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
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x7a4b9ea38a09940f8db81199c7461494c679320e	86	236793087168000000	46835687	2023-08-28T00:14:39.000Z	0x0adb41e721081ef7445f1964ada952504fed17da7967b4c3894d69270be06bd7
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x99447c9f0b854aa6e1345f0821bac2073d858c6d	79	450584610000000000	46857059	2023-08-28T12:53:15.000Z	0x6e601a09e5f2bd4d4e972807226fd13b78b5cb17fb8dc43b9332afc628e93c3f
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x99447c9f0b854aa6e1345f0821bac2073d858c6d	119	450629160000000000	46862382	2023-08-28T16:02:26.000Z	0xf0c8fb1a35677c11b3b7e105a1712842424849856add883a80d5492224c35bd4

Example Query

Query with partition filter

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

GNSTradingCallbacksV3v1_SssFeeCharged_event

SSS (Spread, Spread Reduction, Slippage) fee charges from Gains Network v7 perpetual trading protocol on Polygon. Tracks DAI-denominated fees collected per trader 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
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x006530596df1ca46f52f15478e98a88ebb4a85f6	37	731999999999999998	44962161	2023-07-11T19:56:28.000Z	0x40b6c4e2a98832ee8ce87bcb72eaf529848aadb46bad34f266335327d9bb1707
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x041ecb817dde8d90e5bba77b056b019fa64c2d27	7	1080000000000000000	44929947	2023-07-11T00:28:22.000Z	0x7cc75f25f9d6ddf11f9e8ae0334298d760309eaca40b368b94bf8bce26e15cf0
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x041ecb817dde8d90e5bba77b056b019fa64c2d27	84	1490399999999999999	44932239	2023-07-11T01:51:18.000Z	0x9f8b39be06556d376e0f22014c4fc63980aa2044ed83575f33b831363ffaf955

Example Query

Query with partition filter

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

GNSTradingCallbacksV3v2_LimitExecuted_event

Limit order execution events from Gains Network v7 perpetual trading protocol on Polygon, capturing take-profit and stop-loss fills with prices, P&L, and collateral settlements. Used for analyzing trader performance, order execution quality, and automated position management 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.
`in_collateralPriceUsd`	`STRING`	USD price of the collateral token used in the position. String-encoded value representing price with extended precision.
`in_exactExecution`	`BOOL`	Whether the limit order was executed at the exact trigger price specified by the trader. False indicates the order was filled at a slightly different price due to market conditions.

Sample Data

in_t	address	removed	in_price	log_index	in_orderId	block_number	in_nftHolder	block_timestamp	in_percentProfit	transaction_hash	in_exactExecution	in_daiSentToTrader	in_positionSizeDai	in_collateralPriceUsd
{“sl”:“0”,“tp”:“1393631666666”,“buy”:false,“index”:“0”,“trader”:“0x34b4dec560c27dc0468e52ebd5c2597f70819a9d”,“leverage”:“9”,“openPrice”:“1479181699274”,“pairIndex”:“51”,“initialPosToken”:“46530991625282312046”,“positionSizeDai”:“248200000000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	1393631666666	154	229834059	53186522	0xfe24cfb2f8872e9ed097c451de065a9f6048915b	2024-02-06T09:05:51.000Z	520524485835	0x5b1f0a1e9870d7a8fe21db9652b2cf89bdedc714d26b8238d4cab247ab1ad6cd	true	375594716685585999995	248199999999999999995	99998800
{“sl”:“1805963310399”,“tp”:“1420000000000”,“buy”:false,“index”:“0”,“trader”:“0x107f8b36ccc1997be2c1a76d5cd6760d57e35021”,“leverage”:“10”,“openPrice”:“1679965870139”,“pairIndex”:“51”,“initialPosToken”:“33292910011842294700”,“positionSizeDai”:“148899200000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	1420000000000	354	229834042	53185715	0xa2fb99d7da1550e439b60cdade83216134233a6b	2024-02-06T08:37:02.000Z	1547447330685	0xd2b6fdbd4a2964f3746bf8e1531d98901010a7539a370b481b0e493505619b3b	true	377547954988519439995	148899199999999999997	99998800
{“sl”:“1806000000000”,“tp”:“1420000000000”,“buy”:false,“index”:“0”,“trader”:“0xae1bb7816ec1a0078161e5034f1153c8755f0117”,“leverage”:“5”,“openPrice”:“1679829964983”,“pairIndex”:“51”,“initialPosToken”:“200429314157600799531”,“positionSizeDai”:“896400000000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	1420000000000	317	229834043	53185715	0xa2fb99d7da1550e439b60cdade83216134233a6b	2024-02-06T08:37:02.000Z	773381742198	0x8f43c06012ee19f3bb2817cc7bf23fb769c3df3735affcbac745a866582cb782	true	1584346841856385199995	896399999999999999996	99998800

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gainsnetwork_v7_polygon.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 v7 perpetual trading protocol on Polygon. Records trade fills with entry/exit prices, profit/loss, leverage ratios, and DAI settlement amounts for analyzing trader performance and position lifecycle.

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”:“0”,“tp”:“9939141666”,“buy”:false,“index”:“0”,“trader”:“0x26d754f9ae6f65c43d63b62e6ffa0c8ed1219db5”,“leverage”:“108”,“openPrice”:“10842015690”,“pairIndex”:“21”,“initialPosToken”:“20923231311636024155”,“positionSizeDai”:“92683056000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	false	10840113000	112	229908408	55465364	2024-04-05T07:59:06.000Z	0	18953165709	0xa31eeccb17d99e58bb18d6faa463631d41fc1846409de1d31e613275a1922fc0	92834119366412383918	92683055999999999996	99987148
{“sl”:“10850000000”,“tp”:“10792800000”,“buy”:false,“index”:“0”,“trader”:“0x9f54debfaf5aa35f05b1a81e5503913bca00aaa3”,“leverage”:“309”,“openPrice”:“10849176974”,“pairIndex”:“21”,“initialPosToken”:“7339895987183795061”,“positionSizeDai”:“34183660000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	false	false	10817725000	122	229908567	55472767	2024-04-05T12:44:16.000Z	0	895796979742	0xea23c0298eb4fa7553bee323f2a02206c5c677ed07dff62ceb2bdaefaf6ba5a1	63248537084331103819	34183659999999999998	99980649
{“sl”:“176402812500”,“tp”:“95823750000”,“buy”:false,“index”:“0”,“trader”:“0xf39e430928ee5ea67957a4d972e4cf9ef8d01442”,“leverage”:“20”,“openPrice”:“174141152346”,“pairIndex”:“2”,“initialPosToken”:“38871694558755777826”,“positionSizeDai”:“173676000000000000000”}	0x82e59334da8c667797009bbe82473b55c7a6b311	true	false	174141152346	54	229908724	55480483	2024-04-05T17:38:26.000Z	26516032	0	0x21796acf410e9abc45a8b8b1007a5122695904b4382d8a73fdf1cfb4ee7f6ea8	0	173675999999999999998	99994437

Example Query

Query with partition filter

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

GNSTradingCallbacksV4v1_BorrowingFeeCharged_event

Borrowing fee events from Gains Network V7 perpetual trading protocol on Polygon, recording fees charged to traders on leveraged positions denominated in DAI. Used to analyze borrowing costs, position funding rates, and trader fee exposure across the platform.

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`	Dollar-denominated value of the trader’s position at the time the borrowing fee was charged, expressed in DAI stablecoin with 18 decimal precision. Represents the notional size of the leveraged trade being assessed for borrowing costs.
`in_feeValueDai`	`STRING`	DAI-denominated borrowing fee charged to the trader for holding a leveraged position on Gains Network. Value is in wei (18 decimals), representing the cost assessed based on the position’s size and duration.

Sample Data

address	removed	in_trader	log_index	block_number	in_feeValueDai	block_timestamp	in_tradeValueDai	transaction_hash
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x006530596df1ca46f52f15478e98a88ebb4a85f6	490	51048740	118002717241499999	2023-12-12T14:45:34.000Z	144448496555044499999	0xec1b581586b94eb323f98da7941bbba5464f87e371e22ff47a63c78e800ff299
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x006530596df1ca46f52f15478e98a88ebb4a85f6	481	51062294	5943450896879999	2023-12-12T23:12:01.000Z	176787257945677439999	0x4c4dfde346e318fc647826457ac7627898b28ee4d7a1c78f5a57930a706587d9
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x041ecb817dde8d90e5bba77b056b019fa64c2d27	176	51052623	85177637248087999	2023-12-12T17:08:59.000Z	74354031298040736000	0xa39e7a665edd6bd49661b6339eae17730d2e37b9b00b4c7c985bfb7f63943f33

Example Query

Query with partition filter

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

GNSTradingCallbacksV4v1_DaiVaultFeeCharged_event

DAI vault fee charge events from Gains Network v7 trading protocol on Polygon, recording fees collected from traders in DAI stablecoin. Used for analyzing protocol revenue, trader fee costs, and vault performance metrics.

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
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0xc7cf4fae2b6ba8f67147ec81b1631775b5b265a9	142	718271999999999999	51997145	2024-01-06T06:45:11.000Z	0x811c00e782fe2f5dea7315ed036d86693aa95bb448f105c1451ac9cbdcad479b
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0xe4a5859e0ec2d52e7371e55f4210dda5dcaef82a	73	2221839359999999999	51999814	2024-01-06T08:20:19.000Z	0x6a4f3f42916296a8cf9d1dcb2c007980a57152e210514d77ed437b2cad9ad27b
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x3ba3e60875becf48efc6ef3e9e3d05f102ec329a	73	14453999999999999999	51986092	2024-01-06T00:01:51.000Z	0x26ac21bf2102a8fc9d50378d8bcda0cea2871252da17674ba7438fe3ec141a08

Example Query

Query with partition filter

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

GNSTradingCallbacksV4v1_GovFeeCharged_event

Governance fee charges from Gains Network v7 perpetual trading protocol on Polygon, denominated in DAI stablecoin. Tracks protocol revenue collection from traders with fee amounts and distribution status for analyzing platform economics.

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 the protocol’s fee recipients. Value is true in all sample transactions, suggesting immediate distribution upon fee collection.

Sample Data

address	removed	in_trader	log_index	in_valueDai	block_number	in_distributed	block_timestamp	transaction_hash
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x07fddfdf8f583b87e0b8ad3fb7adf3918e1ffdad	306	498300000000000000	56805503	true	2024-05-10T14:50:02.000Z	0xe5079b95e83e3fd283319adb9731314af25048326190f688387c965ea33c87c4
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x0e524b070a1e8faf71d953d75b250b4a1646660e	481	489750000000000000	56805478	true	2024-05-10T14:49:10.000Z	0x028e6e4f2aeebc63e8a18062e54b624b448047f0cf2e8b1de806535b2082817b
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x1270951dbbe92faed7893026bf30c9d29894a45f	215	796575000000000000	56819355	true	2024-05-10T23:06:39.000Z	0xbe76bb1514986417e8dd689ccdcd13552a4f237fc9dfb20a3fd8aba23c9f3959

Example Query

Query with partition filter

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

GNSTradingCallbacksV4v1_ReferralFeeCharged_event

Referral fee payment events from Gains Network v7 perpetual futures protocol on Polygon, denominated in DAI. Tracks commission charges for referred traders with fee amounts in wei format for analyzing referral program economics.

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
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x222a227a5dc77c643e836556e573cb266998a870	35	569363983200000000	43022768	2023-05-22T18:57:13.000Z	0xf7a4ff80287d2b31553d0ead4f18983b4391d51e78f39758567bb03e76d0edb8
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x222a227a5dc77c643e836556e573cb266998a870	128	561393769500000000	42994899	2023-05-22T00:54:13.000Z	0xd4a80825fdd2fa82bb8fb5dac3949470819bcb950c38acb5b74762182911b9dc
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x5b8e1306bd9f143941b8698032ca41529580309e	53	364320000000000000	43017103	2023-05-22T15:06:11.000Z	0xc7b420077d70b3464b54f10547d671ba52444316dfe939052d413799cf6451cf

Example Query

Query with partition filter

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

GNSTradingCallbacksV4v1_SssFeeCharged_event

Spread, slippage, and swap (SSS) fee events from Gains Network v7 perpetual trading protocol on Polygon. Tracks DAI-denominated fees charged to traders 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
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x041ecb817dde8d90e5bba77b056b019fa64c2d27	135	1222500000000000000	53515058	2024-02-14T14:40:11.000Z	0x18d66781af412e26d83eee8682d0094eaffcc36d5bd1d6b0706788a3e0d1cbcf
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x08b08d7254909830dde8906bfa05187f58ac8421	409	10724255999999999998	53505858	2024-02-14T08:58:09.000Z	0xa0ab347ac81ec1cbda748fffb8c21fb0c6bef5cf369d509bab892011e32df271
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x08b08d7254909830dde8906bfa05187f58ac8421	315	25000000000000000000	53498941	2024-02-14T04:35:55.000Z	0x13111c0164d3212afb66a269086a88accfd27cd651e55cf4141b7e18636adefb

Example Query

Query with partition filter

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

GNSTradingCallbacksV4v1_TriggerFeeCharged_event

Trigger fee charges from Gains Network v7 perpetual trading protocol on Polygon, denominated in DAI (18 decimals). Records fees paid by traders when automated triggers execute stop-loss, take-profit, or limit orders.

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
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x07fddfdf8f583b87e0b8ad3fb7adf3918e1ffdad	313	66440000000000000	56805503	2024-05-10T14:50:02.000Z	0xe5079b95e83e3fd283319adb9731314af25048326190f688387c965ea33c87c4
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x0ad4de31fc1e1e01eaaf815da18690441190f7ed	171	595199999999999999	56806890	2024-05-10T15:40:14.000Z	0x9a79a32842691b9e69e846bed477eb66d923e6ec724edd2685ae9a2730ebad1c
0x82e59334da8c667797009bbe82473b55c7a6b311	false	0x0d3e5cd13a887be35682b2bdd230a2efdc10ad47	158	55703519999999999	56804953	2024-05-10T14:30:02.000Z	0xcb172fa0c39ef5aba5716a6e53dcd3de26a59e4065e51255adcf091b3fdb7c4f

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

GNSTradingCallbacks_LimitExecuted_event

GNSTradingCallbacks_MarketExecuted_event

GNSTradingCallbacksV2_DevGovFeeCharged_event

GNSTradingCallbacksV2_LimitExecuted_event

GNSTradingCallbacksV2_LpFeeCharged_event

GNSTradingCallbacksV2_MarketExecuted_event

GNSTradingCallbacksV2_NftBotFeeCharged_event

GNSTradingCallbacksV2_ReferralFeeCharged_event

GNSTradingCallbacksV2_SssFeeCharged_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

Metrics

Primitives

Contracts

Blockchain

​Tables

​GNSTradingCallbacks_LimitExecuted_event

​GNSTradingCallbacks_MarketExecuted_event

​GNSTradingCallbacksV2_DevGovFeeCharged_event

​GNSTradingCallbacksV2_LimitExecuted_event

​GNSTradingCallbacksV2_LpFeeCharged_event

​GNSTradingCallbacksV2_MarketExecuted_event

​GNSTradingCallbacksV2_NftBotFeeCharged_event

​GNSTradingCallbacksV2_ReferralFeeCharged_event

​GNSTradingCallbacksV2_SssFeeCharged_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

Tables

GNSTradingCallbacks_LimitExecuted_event

GNSTradingCallbacks_MarketExecuted_event

GNSTradingCallbacksV2_DevGovFeeCharged_event

GNSTradingCallbacksV2_LimitExecuted_event

GNSTradingCallbacksV2_LpFeeCharged_event

GNSTradingCallbacksV2_MarketExecuted_event

GNSTradingCallbacksV2_NftBotFeeCharged_event

GNSTradingCallbacksV2_ReferralFeeCharged_event

GNSTradingCallbacksV2_SssFeeCharged_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