synfutures_v1_ethereum

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
0x7839b0a48da17a8a6bacca09149cb2a4dadd3178	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	XAU	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1632470400	0x5e34ae5f7b98566c4f549131cafebd62cba252f1	129	0x75b8370112c1ddaed3ca723a78d5732268b01ad1	12643947	2021-06-16T06:37:39.000Z	0x5da8482735dac88b8ac60cfbb86be5c1efb07e4944f0a90f9b1d936e01aa7f6e
0x0f52065833c8559157b97408240f7740f12ace66	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	BTC	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1632470400	0x37ebb20ff39b894b173eed4e1e322c52af7ee7ba	281	0x19e64bbd9bfb8945e7eeefa6198de86302545ef8	12643932	2021-06-16T06:34:29.000Z	0x920de6da8af713e84a55bed4808a772dbf23dabb5a01506e17fe76e1134cc89a
0x22e72aeafd2bb050a957d7017be3b0501ba0aab9	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	BTC	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1627632000	0x37ebb20ff39b894b173eed4e1e322c52af7ee7ba	230	0x16de1dac0fd84094ac6aba98bef2a781ecb6c790	12837638	2021-07-16T11:25:55.000Z	0xb5fe5c6d913e4a60754a789ea6bace66ab1116ffb6b4ef982f22802b105ce5ce

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_ethereum.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
0x5d714bad35487f03edf6260e8662128474c7689c	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce	false	0xdac17f958d2ee523a2206206994597c13d831ec7	1628841600	0x346fbd99c7053abe295b1dba2232163220d2f13a	170	0xb754f5ad2c54ebd2272c5c5b5fd2c56e66223332	12926148	2021-07-30T09:21:08.000Z	0xab7dd9c60d3b99268208c9e55bfe319ccb9080596d0103e4732cab08d82cd98d
0x88a4a6cef54054c83c3e27ce3987317932121f83	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0x0000000000000000000000000000000000000000	false	0xdac17f958d2ee523a2206206994597c13d831ec7	1628841600	0x4fac302cda8bfb21d4e5d667c3669bc8992fab28	255	0x2a2a1a246057693d1d747e709d86eb08cc305280	12926162	2021-07-30T09:25:18.000Z	0xc9e9ded3ec56b2af0d482d1f93e7f7893f3e8b2ebd78c622fe753e2a68fa894f
0x5653a94face0efc79da1a919387aee5201d918c7	0x6e893ddfa75d67febb853e00f81c913c151bf9a9	0x0000000000000000000000000000000000000000	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1656057600	0x7b36dc354fb9e5014def505fb823d9d39f3ee051	587	0xee52294495ad3b4b3b19dbff27b00f01ea758109	14454558	2022-03-25T09:12:26.000Z	0x78f3415e2c46b58356b8a9ab9651a2b32b7838e20838522df8c7b87ec048c2eb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_ethereum.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
0xe6be38853c857785e4d33a9079879546f8d648a5	1	15000000000000000	false	33445035503556926669795	0x5801d48030a9231b271def344d723a7a9f95a6a8	32	12790314	2021-07-09T01:40:44.000Z	0xa83a48b0e5570c646b60d6320d79d5d14912a18ef416eee7a7710b534056730a
0x19e64bbd9bfb8945e7eeefa6198de86302545ef8	1	10000000000000000	false	38420966819199157428468	0x4adda7eb957c83b44b6703f7c54856829a7b9e29	258	12863522	2021-07-20T12:54:34.000Z	0x13b50fefda648d4353c2bbd6f3d1a37f88d3deed42df0521094995cc7a138c40
0x19e64bbd9bfb8945e7eeefa6198de86302545ef8	2	5000000000000000	false	41280393324335547631199	0x6fe619c554d7b435c90911e043304c95e959105c	334	13001620	2021-08-11T03:59:10.000Z	0x7871d675d4d9e0a095f89f4c61d67c9e32c534a2390b4b6d893ab2678cf27d64

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_ethereum.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
0xa3cb3ca977934d7073f83ab28ad9f490dc3407f0	1	5303758733680247808847311	false	7541821189186	0x09164d5744ff870737a3b21101729dc7a5ff5f4a	73	12819473	2021-07-13T15:00:35.000Z	0x5ab77249e5e5c31c5436dac462b6615a15abfb46fec60f22c7a44fb2d0260572
0xa3cb3ca977934d7073f83ab28ad9f490dc3407f0	2	530375873368024780884731	false	7541821189186	0x09164d5744ff870737a3b21101729dc7a5ff5f4a	169	12819524	2021-07-13T15:11:56.000Z	0x391340b368cc34d2964818ec015d0f91a1e440c31d64da78636faebd439d9102
0x467ee110246e0d133876a25c76fe8f4ed879bc75	2	700000000000000000	false	2013540687918853098137	0x09164d5744ff870737a3b21101729dc7a5ff5f4a	281	12819828	2021-07-13T16:15:29.000Z	0x9d9acc914db8ad5d924bf247efe7696aed3b7d529c9bb8bd941251e58e594e1c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_ethereum.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