synfutures_v2_polygon

Tables

Router_NewUnderlying_event

New trading pair registrations on SynFutures V2 perpetual futures protocol on Polygon. Tracks underlying asset additions with their quote tokens and market identifiers for analyzing available trading markets and liquidity pool expansions.

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_quote`	`STRING`	Contract address of the quote token used for pricing and settlement. Hex-encoded, 0x-prefixed, 42-character string.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_underlying`	`STRING`	Contract address of the underlying asset. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_quote	in_market	in_symbol	log_index	block_number	in_underlying	block_timestamp	transaction_hash
0x1267c6e5d4048318ae48f936130c292e2e0edd73	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x150897aec962aa2643394cf650eb2d41ed454d9f	USDC-WMATIC-DEXV2	440	40922969	0xb09d2ec9afff13589ddfab190e2d1aba7e02095b	2023-03-30T02:46:29.000Z	0x40c3e046e8b9c6dd2f9aaaf3ca269a8c5d3fc7eab0d3972efd5adfc909802e7b
0x1267c6e5d4048318ae48f936130c292e2e0edd73	false	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x150897aec962aa2643394cf650eb2d41ed454d9f	WETH-USDC-DEXV2	346	33046122	0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	2022-09-13T08:37:24.000Z	0x548b4f1ee4f582946ca2984a1893bb61b73191423d5d715ccd0114ef1bb48e9d
0x1267c6e5d4048318ae48f936130c292e2e0edd73	false	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	0x150897aec962aa2643394cf650eb2d41ed454d9f	USDC-WETH-DEXV2	174	33046314	0x89cf9a71d45c58673a7f8b4c829df466da7a473a	2022-09-13T08:44:00.000Z	0x2d63e442f19541964defb98325e2c2cd852a578a77d813ea787e812d28dfba95

Example Query

Query with partition filter

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

WMATIC-USDC-DEXV2_ClaimFee_event

Fee claim events from SynFutures V2 WMATIC-USDC perpetual futures market on Polygon. Records trader fee withdrawals with amounts and contract addresses for analyzing protocol revenue distribution and trader earnings.

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_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.

Sample Data

address	removed	in_trader	log_index	block_number	in_feeAmount	block_timestamp	transaction_hash
0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	0xc740409d8e39e085ddb71790f8e974d0b6288e4f	239	40855103	52417549469839870346	2023-03-28T08:01:08.000Z	0x2426c0351baa7fd6c9b414b47e597146159a6f853e935b09acdb4220f1a1f2d9
0x19759660e5ee693df6105fc3629d5d91cb0a9447	false	0xc740409d8e39e085ddb71790f8e974d0b6288e4f	291	40855086	8378619379102028437	2023-03-28T08:00:32.000Z	0x56ae0cb94f28329dcd250fc3159f584c09f3e9182da4b78d85f85424c1edd063
0xf51dcd52bd075c91632aac42c3926b2a523b3da5	false	0xc740409d8e39e085ddb71790f8e974d0b6288e4f	320	40855069	61381397159674281979	2023-03-28T07:59:56.000Z	0x621b1ee1b3d828dd80522cc942dfb5ead69073278ee22149e385f31119dfdb1e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_ClaimFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_Deposit_event

Deposit events for the WMATIC-USDC trading pair on SynFutures V2 perpetual futures protocol on Polygon. Records margin deposits with trader addresses, amounts (in wei), and operator addresses for tracking collateral inflows.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_trader	log_index	in_operator	block_number	block_timestamp	transaction_hash
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	100000000000000000000	0xd3ba0e2067e2399ca0db5b5f03f416d1464dd684	265	0x1267c6e5d4048318ae48f936130c292e2e0edd73	38150063	2023-01-16T12:01:17.000Z	0xede4f354cca04404288c9f7c562e993f43f3b66d158e51d039f40db86b8e3e98
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	462923807000000000000	0x6d81fbdba7cc3afb7926f80c734965746b297668	292	0x1267c6e5d4048318ae48f936130c292e2e0edd73	38151812	2023-01-16T13:01:27.000Z	0xbae242739da16b00edac6d7a7d8ead70076aea0d636628facb535bbb509b80a6
0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	4440085321011665270	0x0dc921b89b2655c44a09e5978d0ff61cb760580b	53	0x0dc921b89b2655c44a09e5978d0ff61cb760580b	43846275	2023-06-13T01:14:36.000Z	0x58b6f07138d92c7557f06a861e941a9a0edf72c7d3f8fc945998b5d773eeb1a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_EnterSettledState_event

Settlement events from SynFutures V2 WMATIC-USDC perpetual contracts on Polygon, recording final settlement prices when futures contracts enter settled state at expiry. Used for analyzing contract expiration outcomes and historical settlement price data.

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_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_settlementPrice`	`STRING`	Final settlement price used when the SynFutures V2 contract entered settled state, denominated in the contract’s quote currency with raw precision (typically 18 decimals). Values represent the determined price at expiry or perpetual settlement, varying by trading pair and market conditions.

Sample Data

address	removed	in_expiry	log_index	block_number	block_timestamp	transaction_hash	in_settlementPrice
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	1680249600	175	40970769	2023-03-31T08:00:13.000Z	0xd0f7a6deb8946f88827eb3925cf55674286a2ecbee5a17d04ff7ac8456ade9a6	1785998389936252950773
0x89cf9a71d45c58673a7f8b4c829df466da7a473a	false	1680249600	167	40970769	2023-03-31T08:00:13.000Z	0xd0f7a6deb8946f88827eb3925cf55674286a2ecbee5a17d04ff7ac8456ade9a6	559912104817479
0x19759660e5ee693df6105fc3629d5d91cb0a9447	false	0	208	42569812	2023-05-11T09:57:16.000Z	0x65c6b2d862552481810753dde8e037d5fd8df74947c79256d30079381373526c	591901610208329220

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_EnterSettledState_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_EnterSettlingState_event

EnterSettlingState event logs from SynFutures V2 WMATIC-USDC perpetual futures contracts on Polygon, tracking when contracts enter the settlement phase. Useful for analyzing contract lifecycle transitions and expiry management across different market pairs.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x4baa9f1af8653a875d51324ca563d12d7925adf5	false	209	36851625	2022-12-15T07:30:09.000Z	0x2fe3bc4848a5b1e479c0cc5f87ddd05a6a07b7cb100c189db0d193d2ccd45c9a
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	224	36851625	2022-12-15T07:30:09.000Z	0x2fe3bc4848a5b1e479c0cc5f87ddd05a6a07b7cb100c189db0d193d2ccd45c9a
0x8c7822f283137e1e73ea0bdc537ccfb2fa1fb030	false	212	36851625	2022-12-15T07:30:09.000Z	0x2fe3bc4848a5b1e479c0cc5f87ddd05a6a07b7cb100c189db0d193d2ccd45c9a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_EnterSettlingState_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_EnterTradingState_event

Market initialization events from SynFutures V2 WMATIC-USDC perpetual contracts on Polygon, capturing when trading pairs enter active state with their opening prices. Used for tracking market launches and initial price discovery across different contract addresses.

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_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_initPrice`	`STRING`	Initial price at which the trading pair entered the trading state on SynFutures V2. Value is denominated in the smallest unit of the quote token (USDC), represented as an integer.

Sample Data

address	removed	log_index	block_number	in_initPrice	block_timestamp	transaction_hash
0xbda26f37656218b2b3983800bc5734998445cc92	false	98	42807342	2042954008765855800	2023-05-17T08:00:11.000Z	0x0840aa4d02f0fb6253edebf021d323d90afec16c9ef43ff1e896767eb852dffc
0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	118	42807342	2127887294670276903901	2023-05-17T08:00:11.000Z	0x0840aa4d02f0fb6253edebf021d323d90afec16c9ef43ff1e896767eb852dffc
0xb09d2ec9afff13589ddfab190e2d1aba7e02095b	false	94	42807342	1171072761770595891	2023-05-17T08:00:11.000Z	0x0840aa4d02f0fb6253edebf021d323d90afec16c9ef43ff1e896767eb852dffc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_EnterTradingState_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_Liquidate_event

Liquidation events from the SynFutures V2 WMATIC-USDC perpetual futures market on Polygon, recording forced position closures with liquidator addresses, target accounts, position sizes, and remaining account values. Used for analyzing liquidation cascades, protocol health metrics, and liquidator bot profitability.

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_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_accountValue`	`STRING`	Account value of the liquidated position at the time of liquidation, denominated in the quote token’s smallest unit (wei). Can be negative when the position is underwater, indicating the extent of undercollateralization.
`in_totalSize`	`STRING`	Total position size being liquidated in the transaction, denominated in the base token’s smallest unit (wei for ETH-like tokens). Values are large integers representing 18-decimal fixed-point numbers, typically ranging from millions to quadrillions of wei.

Sample Data

address	removed	in_target	log_index	block_number	in_totalSize	in_liquidator	block_timestamp	in_accountValue	transaction_hash
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	0x446ccd4633512f321b400cf89c1877f8307f6c26	211	38322071	101737724044452438	0x9189bcac636be8526c88638682559d13221709ac	2023-01-20T20:15:59.000Z	6639312883952986708	0xb052e458ed8f50a4e0b60418e6b24327b678f23304ff16470a43bbf56de5c82b
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	0x58d908a3a5931f3b744e3c442ac7624d2b20973e	100	43913873	416760148254425954	0x311d304c5a23d77d055229fb82e9e0c983f3ab1f	2023-06-14T20:08:37.000Z	35724845476595061112	0x8b35eb0c178858ffcf0e95bff02cb436109fba58bea65afb1284d3fa89ce1214
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	0x64537fda38e99d24919967f65812695cf3a5d8f0	50	43914879	470000000000000000	0x311d304c5a23d77d055229fb82e9e0c983f3ab1f	2023-06-14T20:51:06.000Z	38969336893396547531	0xc8d6a6994780d1c2ab3ce287090747c5ebfb729cb9a96da7a7e1ef0f6ce8378f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_Liquidate_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_NewAccount_event

New trading account registration events for the WMATIC-USDC perpetual futures market on SynFutures V2 protocol. Used to track trader onboarding and account creation activity for this specific trading pair on Polygon.

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.

Sample Data

address	removed	in_trader	log_index	block_number	block_timestamp	transaction_hash
0x89cf9a71d45c58673a7f8b4c829df466da7a473a	false	0x4de89c2ae04a31cc2dba3e2da11a38ddc43682b9	579	38798340	2023-02-01T21:43:42.000Z	0xab0f44ff4eb3442b2b90f841de790f7d5731cf4b55ff652ef1b5f4a9fb77cfff
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	0x4f49c34759b7e888ce77de9dd34fec63d63495cc	205	38775992	2023-02-01T08:07:27.000Z	0x4796941157330571f1d17b6b3e4b3b81c9fc4b96cd7f6fc22b9ed48d4644145c
0x64b8b618cddc31c61305338c6ab7a2d85a7ab5ca	false	0xa22a02a35c8da9042e2f46e5f4f0e1b42859c5e2	262	38778099	2023-02-01T09:22:11.000Z	0xcc646435b1fafea3913fbfd9f71b8859c9a47151eb2f0087a5b9f8cb28e13167

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_NewAccount_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_SetUnderlyingStatus_event

Status change events for the WMATIC-USDC trading pair on SynFutures V2 derivatives protocol on Polygon. Tracks underlying asset status transitions (status values 1 and 2) for this specific perpetual contract market.

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_status`	`INT64`	Status code representing the state of the entity or operation. Integer value with meaning specific to the contract context.

Sample Data

address	removed	in_status	log_index	block_number	block_timestamp	transaction_hash
0xf51dcd52bd075c91632aac42c3926b2a523b3da5	false	1	113	41964034	2023-04-26T02:47:10.000Z	0x51da859c70ff463872495bfa27fb99d79e715a2a91f3679da8b89724c9aa7916
0x19759660e5ee693df6105fc3629d5d91cb0a9447	false	1	68	41964429	2023-04-26T03:01:08.000Z	0xad7adcb3c251f70014374bbe962d56b776132afab1e1399288b542b0007ec7ed
0xf51dcd52bd075c91632aac42c3926b2a523b3da5	false	2	206	42569812	2023-05-11T09:57:16.000Z	0x65c6b2d862552481810753dde8e037d5fd8df74947c79256d30079381373526c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_SetUnderlyingStatus_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_Trade_event

Trade execution events for the WMATIC-USDC perpetual futures pair on SynFutures V2 protocol on Polygon. Records maker-taker matches with execution price, position size changes, and fee breakdowns for analyzing trading patterns and liquidity provision.

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_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`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_takeSize`	`STRING`	Trade size in base token units, with negative values indicating sells and positive values indicating buys. Values are raw 18-decimal fixed-point integers representing the position change for the taker.
`in_tradingFee`	`STRING`	Trading fee charged for this specific trade execution, denominated in the smallest unit of the quote token. Values are raw integers requiring decimal adjustment based on token precision.
`in_reserveFee`	`STRING`	Reserve fee collected by the protocol on this trade, denominated in the smallest unit of the quote token. Stored as a string-encoded integer representing wei-equivalent precision.

Sample Data

address	removed	in_maker	in_price	in_taker	log_index	in_takeSize	block_number	in_reserveFee	in_tradingFee	block_timestamp	transaction_hash
0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	2781833925169354955208	0x05f1a2564e8850b30ef1247d9d1590f262a0d3d8	182	-28497369314654275	52201303	7927494873758543	39637474368792716	2024-01-11T14:34:42.000Z	0x3f05675268c39115ebdd74a53b20c357a886c0654404fc676b5311bebdbca282
0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	2788625893155707295816	0x05f1a2564e8850b30ef1247d9d1590f262a0d3d8	194	17910596614260211	52201303	4994595348039296	24972976740196484	2024-01-11T14:34:42.000Z	0x3f05675268c39115ebdd74a53b20c357a886c0654404fc676b5311bebdbca282
0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	2770343341375485653634	0x05f1a2564e8850b30ef1247d9d1590f262a0d3d8	188	10586772700394064	52201303	2932899525719246	14664497628596232	2024-01-11T14:34:42.000Z	0x3f05675268c39115ebdd74a53b20c357a886c0654404fc676b5311bebdbca282

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_TransferLiquidity_event

Liquidity position transfer events from the SynFutures V2 WMATIC-USDC DEX pool on Polygon, recording share movements between addresses. Enables tracking of liquidity provider position transfers and ownership changes in the perpetual futures market maker system.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_share`	`STRING`	Number of shares minted or burned in the vault or liquidity pool operation. String-encoded integer representing share token quantity in smallest denomination.

Sample Data

in_to	address	in_from	removed	in_share	log_index	block_number	block_timestamp	transaction_hash
0xa70bd583c6f00a7f808bae879f0584d571c16ba6	0x4baa9f1af8653a875d51324ca563d12d7925adf5	0xe0713083ac89a771a3c1765b9f291c83fb88c859	false	518190186555771459	85	44619081	2023-07-03T03:41:34.000Z	0xc372b09fec23e5f8c2c09e7229c9e583307c6ca52f948735d636cf0b51e29c2d
0x311d304c5a23d77d055229fb82e9e0c983f3ab1f	0x8c7822f283137e1e73ea0bdc537ccfb2fa1fb030	0xdcfb5e2ab7d99e5af67cd233877facd3a6ff710e	false	3277050649909765	205	44617048	2023-07-03T02:26:52.000Z	0x61b0489bad433e324caf1ab0308f95ae91d3e5bfda19924ac999e4833b67c890
0x311d304c5a23d77d055229fb82e9e0c983f3ab1f	0x8c7822f283137e1e73ea0bdc537ccfb2fa1fb030	0xa77ce92a601d504a6d64af843eb5a3994616969c	false	39816178835507011	161	44617980	2023-07-03T03:01:27.000Z	0xaedb45c6cb91d119a068b68227c4da845dc1a86438e84ba1eddf81bf3d88d7f4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_TransferLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WMATIC-USDC-DEXV2_Withdraw_event

Withdrawal events from the SynFutures v2 WMATIC-USDC perpetual futures market on Polygon, capturing liquidity removals with trader addresses, amounts, and operator details. Used for analyzing liquidity provider behavior and fund flows in this derivatives trading pair.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_amount	in_trader	log_index	in_operator	block_number	block_timestamp	transaction_hash
0x337e4565e1c730c0c86a6a447bfe15b70f1486ce	0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	23567228919009440408	0x337e4565e1c730c0c86a6a447bfe15b70f1486ce	345	0x1267c6e5d4048318ae48f936130c292e2e0edd73	49242898	2023-10-28T05:40:08.000Z	0x37eab67e400808b53f77ca4f4c27bb821313fcd2a77b3f4821ca488f16e6bf8f
0x279b60f1a63421215f67d9dc748aaf050b5d74a1	0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	35775979379621578184	0x279b60f1a63421215f67d9dc748aaf050b5d74a1	341	0x1267c6e5d4048318ae48f936130c292e2e0edd73	49242898	2023-10-28T05:40:08.000Z	0x82815a8239a29dc4f3d4550a789dcb253f6eb2f9a236200f07cddde6b129cb96
0xad4e1cc0fe9b2f9718cff1be2909e501d00f013a	0x13f7f23db676431a2371d0f1884ae1526a0fe5c2	false	65008753848881925139	0xad4e1cc0fe9b2f9718cff1be2909e501d00f013a	333	0x1267c6e5d4048318ae48f936130c292e2e0edd73	49242898	2023-10-28T05:40:08.000Z	0x1b5ffa6af13569cc47885279128b4e12f3ae73b9c62f164229d37b089d8af02d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v2_polygon.WMATIC-USDC-DEXV2_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Router_NewUnderlying_event

WMATIC-USDC-DEXV2_ClaimFee_event

WMATIC-USDC-DEXV2_Deposit_event

WMATIC-USDC-DEXV2_EnterSettledState_event

WMATIC-USDC-DEXV2_EnterSettlingState_event

WMATIC-USDC-DEXV2_EnterTradingState_event

WMATIC-USDC-DEXV2_Liquidate_event

WMATIC-USDC-DEXV2_NewAccount_event

WMATIC-USDC-DEXV2_SetUnderlyingStatus_event

WMATIC-USDC-DEXV2_Trade_event

WMATIC-USDC-DEXV2_TransferLiquidity_event

WMATIC-USDC-DEXV2_Withdraw_event

​Tables

​Router_NewUnderlying_event

​WMATIC-USDC-DEXV2_ClaimFee_event

​WMATIC-USDC-DEXV2_Deposit_event

​WMATIC-USDC-DEXV2_EnterSettledState_event

​WMATIC-USDC-DEXV2_EnterSettlingState_event

​WMATIC-USDC-DEXV2_EnterTradingState_event

​WMATIC-USDC-DEXV2_Liquidate_event

​WMATIC-USDC-DEXV2_NewAccount_event

​WMATIC-USDC-DEXV2_SetUnderlyingStatus_event

​WMATIC-USDC-DEXV2_Trade_event

​WMATIC-USDC-DEXV2_TransferLiquidity_event

​WMATIC-USDC-DEXV2_Withdraw_event

Tables

Router_NewUnderlying_event

WMATIC-USDC-DEXV2_ClaimFee_event

WMATIC-USDC-DEXV2_Deposit_event

WMATIC-USDC-DEXV2_EnterSettledState_event

WMATIC-USDC-DEXV2_EnterSettlingState_event

WMATIC-USDC-DEXV2_EnterTradingState_event

WMATIC-USDC-DEXV2_Liquidate_event

WMATIC-USDC-DEXV2_NewAccount_event

WMATIC-USDC-DEXV2_SetUnderlyingStatus_event

WMATIC-USDC-DEXV2_Trade_event

WMATIC-USDC-DEXV2_TransferLiquidity_event

WMATIC-USDC-DEXV2_Withdraw_event