synfutures_v1_arbitrum

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
0x682211885c24939c25f1c818b39aa75313895156	0x1e7db497d664e77fc96321a1ad0bf018e55cbff8	BTC	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1639123200	0x717df7dc2809ccd93b7d4d3aac88848d14e23d73	2	0xa2ed7aeda59ce4d95f852f731e93ccd2791c8a8d	2041044	2021-10-09T09:19:15.000Z	0x4440b71090f1eefcb7e64fd1aba1496a185a326a0f30d1b5742efca9ea326104
0xc032c18eaa487ab8ece5f8032aaf535f0c815532	0x1e7db497d664e77fc96321a1ad0bf018e55cbff8	BTC	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1640937600	0x717df7dc2809ccd93b7d4d3aac88848d14e23d73	2	0xf90eebaf28e388c367b4fb3c3d01330ef374fb12	1487640	2021-09-23T01:33:49.000Z	0x615975138fe3dc9ba0c37e67db0e4a4f76b9cab2e59432de58ac8f9438b3f219
0xbd78b707ba05c00e13403ba25d6a5680d5ddc322	0x1e7db497d664e77fc96321a1ad0bf018e55cbff8	BTC	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1634284800	0x717df7dc2809ccd93b7d4d3aac88848d14e23d73	2	0xc0c57322bf6bc9fe686602226abd38c60259e812	1489664	2021-09-23T02:48:53.000Z	0x51b44f742ff4cf7a68cb716c07c3e38d61e53b420c64a0ce51fcef63903eb893

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_arbitrum.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
0xb8f59691c5cfd09da5e3d6016e8f2495711ea8ea	0x1e7db497d664e77fc96321a1ad0bf018e55cbff8	0x10393c20975cf177a3513071bc110f7962cd67da	false	0x0000000000000000000000000000000000000000	1668758400	0x3cf9b01e96c765d39d791a162df2ca9e399c6fbd	3	0x66106f2baaa78b038d312e512b054d2e9b168d0f	37129891	2022-11-11T06:30:53.000Z	0x4cea36767d6201370048787c5d347c11a5e4cff04d1ccb088c83c4140d1f8b00
0x5978fa3bc24c6bc7b472a374fa3afa0d262b58c7	0x1e7db497d664e77fc96321a1ad0bf018e55cbff8	0x539bde0d7dbd336b79148aa742883198bbf60342	false	0x0000000000000000000000000000000000000000	1668758400	0x3d1a17937687fa938ff152aaee1cb3acd29378b8	2	0xe29c56dc6514c3172e34f750cc77e09dd007b915	37129761	2022-11-11T06:30:16.000Z	0x4740521dd757ea1af3dbc29d6baa299a7510e5162e4701ebd19a7506b1c01248
0x50bb28797a27acbdf818f2d7bdef3ddc1282f5ab	0x1e7db497d664e77fc96321a1ad0bf018e55cbff8	0x3e6648c5a70a150a88bce65f4ad4d506fe15d2af	false	0x0000000000000000000000000000000000000000	1668729600	0xcf22818f2f0765410a0394c1be4a654f73a2c158	11	0x61b75360006b76680177ec03ac5089307a47bba0	37130098	2022-11-11T06:31:50.000Z	0x4ee665695029164226ad27933c9b2872632f2afd616a8fcbf79eaca8767a951d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_arbitrum.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
0xf90eebaf28e388c367b4fb3c3d01330ef374fb12	1	69025905120106	false	63744184047190443230331	0xfd958503c1d12b2f9d5f4ba67eab8a604bd0cb67	6	2869077	2021-11-06T15:09:34.000Z	0x9dbb4179f8b55a013fe957b23bf773b4b1c351fd7308fbc8fc1b8b4f39faf059
0xf90eebaf28e388c367b4fb3c3d01330ef374fb12	1	69144610610732	false	63634749854489028365754	0xb4f9a18b5dccc06c07c3b12986a6089e0acf6f6e	6	2869390	2021-11-06T15:31:54.000Z	0x8b149ab66d529c9b3387de24ac47e29d4cd43d77ec97e5357308b1930778b532
0xf90eebaf28e388c367b4fb3c3d01330ef374fb12	1	69144908708421	false	63634475512209693243582	0xc6c945dd717f010b9a8d3f6bfdd1717a7f39b9e2	6	2869300	2021-11-06T15:26:46.000Z	0xe14045a4763ebfd30e9e37cc303ae5037b9e8a895451b2b06f10e52c5d9268a7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v1_arbitrum.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
0x9a610776d93eec81a1979a70adb7c0cc7eb5a30f	2	250000000000000000	false	2734033516462356385137	0x5f3d59b5b06e9d3ff0c5cd143556f73983f67692	4	7643859	2022-03-09T10:32:53.000Z	0x16e667856bb3a001769751abdf63d2ad5be32adc7bd1db94541bedf48e094da5
0x9a610776d93eec81a1979a70adb7c0cc7eb5a30f	2	250000000000000000	false	2624480891981989508565	0x5f3d59b5b06e9d3ff0c5cd143556f73983f67692	4	7606647	2022-03-09T01:42:36.000Z	0xc97c57d234f44c64e726578c05ff9878ca3ee8d98f4a1ab57a1ba22682c6c758
0xd60022535ee3a9f77a09820bfdd030a08b4dbaa3	1	765703781858699341	false	4353293548115786346	0x9be65289cd8a97b6f06b83673bc0bd33af6f4985	8	7663891	2022-03-09T21:11:56.000Z	0x6b254d71a2b88fed4029b6a090e1c830a131a77e5b3c52d2b372274dc8ba4bc1

Example Query

Query with partition filter

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

Overview

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

Tables

Factory_NewChainlinkPair_event

Factory_NewUniswapPair_event

FuturesChainlinkPair_Trade_event

FuturesUniswapPair_Trade_event