synfutures_v1_bsc

Tables

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
0xaa38539ce2392f4ac1e4609c92f925d28e242afa	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	BTC	false	0xe9e7cea3dedca5984780bafc599bd69add087d56	1625212800	0x5e34ae5f7b98566c4f549131cafebd62cba252f1	184	0x6070a8c8707e53633002099ddcfd4492b299d9bb	8722226	2021-06-29T15:00:08.000Z	0x65bf3c471f193f40357bf7d35030f75711e6f8686980e9f45819dbc278d2fdd2
0xdb6c409ccab0cbe59d8e228f0ce9927b475fa226	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	BTC	false	0xe9e7cea3dedca5984780bafc599bd69add087d56	1625817600	0x5e34ae5f7b98566c4f549131cafebd62cba252f1	297	0x094f6e3d4d455de912eda5d65ef302ad405f0de3	8722166	2021-06-29T14:57:08.000Z	0xc8dc61701092a760c6996d3e5ffa5028efc8e25d22ee3b9d24307c9190b73aa9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_bsc.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
0x7d1763ec0fb204f2e7219e1a85bda607ae953592	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0x4338665cbb7b2485a8855a139b75d5e34ab0db94	false	0x0000000000000000000000000000000000000000	1668124800	0x94682274fe516793d2c9bb6c8fc3ec5a211cec1b	184	0x420a358209e82181794da3d62a5a77da7b29f06b	22753568	2022-11-04T02:57:32.000Z	0x543fe2939ed94273562e415965d977a06b9d2e387e8aeddc3a4f0a8f5ea5f8c6
0x5be15426100d23bd22ccdf179bf8c1207485efdb	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0x3ee2200efb3400fabb9aacf31297cbdd1d435d47	false	0x0000000000000000000000000000000000000000	1668124800	0x0e15480783be14205472c55fb70468e51fb32295	181	0xd7bbd388bb2d58047e8a4baa3d50dab03c2f9728	22753568	2022-11-04T02:57:32.000Z	0x543fe2939ed94273562e415965d977a06b9d2e387e8aeddc3a4f0a8f5ea5f8c6
0x613eab308b2ccd665cbd3c68c6f8c06d98f41de6	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0xf8a0bf9cf54bb92f17374d9e9a321e6a111a51bd	false	0x0000000000000000000000000000000000000000	1668124800	0xad2bc0e18d41a037137c1a80c068fdcb81aec84d	187	0x584b469dd47a61fe61158ae5e9711a119c6fd0b8	22753568	2022-11-04T02:57:32.000Z	0x543fe2939ed94273562e415965d977a06b9d2e387e8aeddc3a4f0a8f5ea5f8c6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_bsc.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
0x094f6e3d4d455de912eda5d65ef302ad405f0de3	1	9178852874912	false	36315358561240000000000	0xbba2cc0d38376019292342562480ce697370df81	161	8722182	2021-06-29T14:57:56.000Z	0x4fcc4037bdc67ca3132a7253eeba087b0068cc475c81258fdac6434a2e217adb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_bsc.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
0xd6eda5c076b80675d7116844482d5d2466aa00e8	1	200000000000000000	false	5716053144801390793	0x87290e028d185ebecf2107101b264a95cae97eef	108	20593446	2022-08-20T01:33:40.000Z	0x8962011aed47fe52dc010cdc4cca1bbedd192583864ae27691ff56ca947f59ad
0xd6eda5c076b80675d7116844482d5d2466aa00e8	1	300000000000000000	false	5603884989973710194	0x87290e028d185ebecf2107101b264a95cae97eef	202	20615476	2022-08-20T19:55:10.000Z	0xb88e5fab3a8f181397fc08769fe72190a107872ceecc2df535782d0dab8c4ff5
0x03876ed9338da63b4c67b0de17aaa23fc1fbb727	1	1000000000000000000	false	280043109163676610803	0x87290e028d185ebecf2107101b264a95cae97eef	146	20615466	2022-08-20T19:54:40.000Z	0xf8c4cce9385f4f8824397c76ec681e444f0a10caaca30879b14bb920f6e06b06

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_NewChainlinkPair_event

Factory_NewUniswapPair_event

FuturesChainlinkPair_Trade_event

FuturesUniswapPair_Trade_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_NewChainlinkPair_event

​Factory_NewUniswapPair_event

​FuturesChainlinkPair_Trade_event

​FuturesUniswapPair_Trade_event

Tables

Factory_NewChainlinkPair_event

Factory_NewUniswapPair_event

FuturesChainlinkPair_Trade_event

FuturesUniswapPair_Trade_event