synfutures_v1_polygon

Tables

BTCFutures_Trade_event

Trade execution events from SynFutures V1 Bitcoin perpetual futures contracts on Polygon, capturing trader addresses, position sides (long/short), trade sizes, and execution prices for analyzing trading patterns and liquidity dynamics.

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_side`	`INT64`	Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short.
`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_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.

Sample Data

address	in_side	in_size	removed	in_price	in_trader	log_index	block_number	block_timestamp	transaction_hash
0xe72fce55b0119dfbd1b4f5bb5cbc01cf8aa80e0c	2	30000000000000000	false	63789032668273751	0x5f3d59b5b06e9d3ff0c5cd143556f73983f67692	43	25535351	2022-03-03T14:40:16.000Z	0xe359869b9cb962d70852e18c7e346ca2282f9bbb3d651cd252398876e1346497
0xdbf1ccebcff075297fbf00956cc99ea4ccea3fc5	1	200000000000000000	false	67501083275879690	0x5f3d59b5b06e9d3ff0c5cd143556f73983f67692	374	23946055	2022-01-20T12:29:23.000Z	0x5055a29e1a44450d507acd7332b5848a4ff1deff81dde722645a4a73f2d8eb7a
0xd5fc9c820b2abbecc9c87a269e71a38c3618b827	2	100000000000000000	false	69387289060897029	0x7456cf09262d80720fd3778a1f7e50f1f3ce2929	399	23145472	2021-12-30T14:51:51.000Z	0xb5003838a534af045f3b5eeda76cf794b57f6488b26857cf0f35252ce18ea7c6

Example Query

Query with partition filter

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

BtcHashRateFactory_NewBitcoinMiningDifficultyPair_event

Bitcoin mining difficulty futures pair creation events from SynFutures V1 protocol on Polygon. Records new automated market maker (AMM) deployments with associated futures contracts, quote tokens, and expiry block heights for trading BTC hashrate derivatives.

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_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_amm`	`STRING`	Contract address of the automated market maker (AMM). Hex-encoded, 0x-prefixed, 42-character string.
`in_futures`	`STRING`	Contract address of the futures or derivative instrument. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_amm	address	removed	in_quote	in_expiry	log_index	in_futures	block_number	block_timestamp	transaction_hash
0xfd0bc07d3df5d197875dbbaa8c59a289c2b71eb4	0x24de4e74dec1200577838081ee4c0665911ae4ee	false	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	729792	30	0x398e3d0a214dcfee66381d96bce7831b0ae2284d	19731950	2021-10-01T20:46:40.000Z	0xe4a123695a222cf534c9a50607dfbd5631f96bd2762ea93890e35b3142a32874
0x0a29aa79e59bceb838930fa27e5d83b4c05b1503	0x24de4e74dec1200577838081ee4c0665911ae4ee	false	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	731808	30	0xadb37cf74f9d637a5c40acb7eee176fe40320639	19731997	2021-10-01T20:48:18.000Z	0xc5cd762beb647d3f46bebb8606b22bb0386c3b8c633cf61a29d640d6afa4a295
0x4ab400004f4bbdb5e9a9aec93c2236a266428562	0x24de4e74dec1200577838081ee4c0665911ae4ee	false	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	703584	150	0xa76046434f761db507ad17beb19c4903b09e3b4b	17672599	2021-08-06T07:18:23.000Z	0x5fc78a430dd82d3e4a52c787f73d2e606dcb4f225c965855bea52aabc32b49f2

Example Query

Query with partition filter

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

Factory_NewChainlinkPair_event

Factory event logs recording the creation of new futures trading pairs that use Chainlink oracles for price feeds. Contains base asset, quote token, expiration timestamp, and deployed contract addresses for the AMM (Automated Market Maker) and futures instrument.

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_base`	`STRING`	Token or asset identifier serving as the base asset in a trading pair or financial instrument. String representation that can be either a contract address (hex-encoded, 0x-prefixed, 42-character string) or a ticker symbol.
`in_quote`	`STRING`	Contract address of the quote token used for pricing and settlement. Hex-encoded, 0x-prefixed, 42-character string.
`in_oracle`	`STRING`	Contract address of the oracle providing price feed data. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_amm`	`STRING`	Contract address of the automated market maker (AMM). Hex-encoded, 0x-prefixed, 42-character string.
`in_futures`	`STRING`	Contract address of the futures or derivative instrument. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_amm	address	in_base	removed	in_quote	in_expiry	in_oracle	log_index	in_futures	block_number	block_timestamp	transaction_hash
0x0a72ebbf7f57d93ef2b79f19d7b5576ac1ffeaa1	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	BTC	false	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	1645171200	0x4fac302cda8bfb21d4e5d667c3669bc8992fab28	155	0xfd855ea24ca1f3787d6e14553d8d11248e1ad3f1	24803353	2022-02-11T06:12:50.000Z	0x12abcd0513b8fb1692e05fc24a544b98c65eefe4210fee8bfe19fe09dc636def
0xed0ad599d0c5f427a15c3ae9faf46a57b93b3cdd	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	BTC	false	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	1650009600	0x4fac302cda8bfb21d4e5d667c3669bc8992fab28	137	0xf912c7cabd9345446bccc233cd9b164e8fbf422e	26887790	2022-04-08T10:53:54.000Z	0x0ec7c801784a4cef0bbb691c1f60be8ec52a66e5ca07d1d4281cbd9fdbb906da
0x59690be063aca8aaee9671382045954f75b5c949	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	BTC	false	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	1654243200	0x4fac302cda8bfb21d4e5d667c3669bc8992fab28	230	0xd7414de29d35cf26ce3f064421c9e6697bac4131	28544581	2022-05-20T10:13:52.000Z	0x6ed5b4f123bd4163dcfd103fc6efa3fae9cc9e96ca4ca6bbf1c7e3b5a1f30f89

Example Query

Query with partition filter

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

Factory_NewUniswapPair_event

Factory creation event emitted when a new automated market maker (AMM) and futures contract pair is deployed. Contains contract addresses for the AMM, futures instrument, base/quote tokens, oracle, and expiration timestamp for the derivative 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_base`	`STRING`	Token or asset identifier serving as the base asset in a trading pair or financial instrument. String representation that can be either a contract address (hex-encoded, 0x-prefixed, 42-character string) or a ticker symbol.
`in_quote`	`STRING`	Contract address of the quote token used for pricing and settlement. Hex-encoded, 0x-prefixed, 42-character string.
`in_oracle`	`STRING`	Contract address of the oracle providing price feed data. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_amm`	`STRING`	Contract address of the automated market maker (AMM). Hex-encoded, 0x-prefixed, 42-character string.
`in_futures`	`STRING`	Contract address of the futures or derivative instrument. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_amm	address	in_base	removed	in_quote	in_expiry	in_oracle	log_index	in_futures	block_number	block_timestamp	transaction_hash
0x720991ee4280cb44fe70a02526c47b7626c2829a	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0x0000000000000000000000000000000000000000	false	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	1661500800	0xddb38c3c0f3506d78d88a3116a5399f1f02d423e	131	0xa526ed6b83e43a9d1b2342142d392000172e7ba0	31400970	2022-08-01T17:05:02.000Z	0xe2934ebae83917e026294d8a15a7f590f3aa214530b3941ccf846a8eab972182
0x7dd88e886e300572dd9b343ef8683e2d92aaa687	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0x0000000000000000000000000000000000000000	false	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	1660896000	0xddb38c3c0f3506d78d88a3116a5399f1f02d423e	159	0x1ee0a90df78ff11a9b31f6ed9d5e5e86ddcca0d6	31386420	2022-08-01T08:11:00.000Z	0xfa6a7d649278c319057d8d9b6526aed333c5ffeb6a3188157bae9fe438c66e24
0xd119a329762962bde8dc3b52b38ad290228d65ee	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0x1a3acf6d19267e2d3e7f898f42803e90c9219062	false	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	1648195200	0x6eb5f34f13f9c858b92ed26b5184dc828fd154c2	511	0x82b0f3dcc6e056a7d26787d3234d020a6ba92d56	26059782	2022-03-18T02:44:15.000Z	0xbde7b87b53d316a70c0d8bc3f0ddb0ffd7b1346642ec457c011dd83c9f3e1d71

Example Query

Query with partition filter

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

FuturesChainlinkPair_Trade_event

Trade execution events from SynFutures v1 Chainlink-based futures pairs containing trader address, position side (long/short), execution price, and position size. Used for tracking perpetual futures trading activity and position changes.

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_side`	`INT64`	Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short.
`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_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.

Sample Data

address	in_side	in_size	removed	in_price	in_trader	log_index	block_number	block_timestamp	transaction_hash
0x5028c1aafb35504c78cf65c229fad20b7b32c404	2	64300000000000000	false	20825742975175878139848	0x001d626ad166e7508df6e58faf2618aaff44d530	233	38211175	2023-01-18T00:15:25.000Z	0x4c6c44e68084a2bffad17e17465bf3bc3522d06e511dca0b158e31086f4fc0db
0x5028c1aafb35504c78cf65c229fad20b7b32c404	1	64300000000000000	false	20824944890148348797398	0x001d626ad166e7508df6e58faf2618aaff44d530	227	38211175	2023-01-18T00:15:25.000Z	0x4c6c44e68084a2bffad17e17465bf3bc3522d06e511dca0b158e31086f4fc0db
0x5028c1aafb35504c78cf65c229fad20b7b32c404	2	62200000000000000	false	21608354530457171175226	0x001d626ad166e7508df6e58faf2618aaff44d530	130	38211508	2023-01-18T00:27:13.000Z	0x4276513b202646916635dca33be2a1ed671b2581e2e4525e8af19bf0b95596ca

Example Query

Query with partition filter

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

FuturesUniswapPair_Trade_event

Perpetual futures trade execution events from SynFutures V1 contracts. Records trader address, position side (long/short), size, and execution price for derivative contract trades.

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_side`	`INT64`	Direction of the trade or position. Integer value where 0 indicates long and 1 indicates short.
`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_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.

Sample Data

address	in_side	in_size	removed	in_price	in_trader	log_index	block_number	block_timestamp	transaction_hash
0xb1b16562a289ba30e32fd12da292d8b08096a27f	2	1000000000000000	false	3497318086749371042090	0x3cbf5a2ad28271f6ec30e0d891905e663b78b865	63	19740770	2021-10-02T02:03:50.000Z	0xeedeaf3621536082ad9fd7e52500938159ee86dfdc0920e257401872690d87fc
0xb1b16562a289ba30e32fd12da292d8b08096a27f	2	1000000000000000	false	3501894470558892880021	0x5c600f23e2c4dd1b7f65878f04709b6b06ec1678	70	19741769	2021-10-02T02:42:55.000Z	0x6b0199c3c2ffd6075979a0537582edef253ac0b802bbb8b3349ac294fe79cda2
0xb1b16562a289ba30e32fd12da292d8b08096a27f	2	1000000000000000	false	3440929464433721347709	0x69bbc677070017b6eec90d8c6e4c2dba724381cb	86	19742717	2021-10-02T03:15:27.000Z	0xd90efbe55a96a1e865e4e3deae54fe40668bbcc65f5eac92aa55a0db8e298c15

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BTCFutures_Trade_event

BtcHashRateFactory_NewBitcoinMiningDifficultyPair_event

Factory_NewChainlinkPair_event

Factory_NewUniswapPair_event

FuturesChainlinkPair_Trade_event

FuturesUniswapPair_Trade_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BTCFutures_Trade_event

​BtcHashRateFactory_NewBitcoinMiningDifficultyPair_event

​Factory_NewChainlinkPair_event

​Factory_NewUniswapPair_event

​FuturesChainlinkPair_Trade_event

​FuturesUniswapPair_Trade_event

Tables

BTCFutures_Trade_event

BtcHashRateFactory_NewBitcoinMiningDifficultyPair_event

Factory_NewChainlinkPair_event

Factory_NewUniswapPair_event

FuturesChainlinkPair_Trade_event

FuturesUniswapPair_Trade_event