synfutures_v3_base - Token Terminal Docs

Tables

Config_SetMarketInfo_event

Configuration events tracking market deployments on SynFutures V3 perpetual protocol on Base, recording market type assignments (PYTH oracle, LINK oracle, DEX V2, emergency) and associated beacon contracts for each market address.

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_mtype`	`STRING`	Market type identifier indicating the price oracle or data feed mechanism used by this market. Common values include PYTH (Pyth Network), LINK (Chainlink), EMG (emergency mode), and DEXV2 (DEX v2 oracle).
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_beacon`	`STRING`	Contract address of the beacon proxy implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_mtype	in_beacon	in_market	log_index	block_number	block_timestamp	transaction_hash
0xb63902d38738e353f3f52add203c418a0bfea172	false	PYTH	0x9674e2f58485b987d7d537a059fb002ae1d44959	0xba2593a538df42f4673a5c72a444d70d6b91f3d9	3	16297492	2024-06-26T06:45:31.000Z	0xfd8474224006b8078de0b171290127bd83d8320e80a3e925ff05c74b30d67a40
0xb63902d38738e353f3f52add203c418a0bfea172	false	LINK	0x9674e2f58485b987d7d537a059fb002ae1d44959	0x6926cc6875d3721c13325d301b4170a57f2c0b18	11	16297482	2024-06-26T06:45:11.000Z	0x8dfc2cfd9e0a4644aeda1801b59d0c27b82f8f751738cf33baef2cb86a6bbe1a
0xb63902d38738e353f3f52add203c418a0bfea172	false	EMG	0x9674e2f58485b987d7d537a059fb002ae1d44959	0x8f76920d741a6e2d324c9cc8878cd5a9371e81cd	8	16297487	2024-06-26T06:45:21.000Z	0x8c5e6742b267830f1eec15498c0c7ad7f0011e4ff777db253bbc4da6257e5b90

Example Query

Query with partition filter

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

Config_SetQuoteParam_event

Configuration update events from SynFutures v3 perpetual protocol on Base, recording parameter changes for quote tokens including trading fees, protocol fees, minimum margin requirements, and stability fee ratios. Used for tracking risk management and fee structure modifications across different quote token types.

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_param`	`STRUCT<minMarginAmount STRING, tradingFeeRatio STRING, protocolFeeRatio STRING, stabilityFeeRatioParam STRING, qtype INT64, tip STRING>`	Configuration parameters for automated market maker or protocol settings. Structured data containing fee ratios, margin requirements, and protocol-specific settings encoded as strings or structs.

Sample Data

address	removed	in_param	in_quote	log_index	block_number	block_timestamp	transaction_hash
0xb63902d38738e353f3f52add203c418a0bfea172	false	{“tip”:“500000000000000000”,“qtype”:2,“minMarginAmount”:“25000000000000000000”,“tradingFeeRatio”:“1”,“protocolFeeRatio”:“2”,“stabilityFeeRatioParam”:“14415916854096691200”}	0x3ee5e23eee121094f1cfc0ccc79d6c809ebd22e5	82	21354510	2024-10-21T08:12:47.000Z	0xd7581b5281d889402c4309daee353d2ece5b16d948c09fbf21216ff39a87af0f
0xb63902d38738e353f3f52add203c418a0bfea172	false	{“tip”:“500000000000000000”,“qtype”:2,“minMarginAmount”:“100000000000000000000”,“tradingFeeRatio”:“6”,“protocolFeeRatio”:“1”,“stabilityFeeRatioParam”:“14415916854096691200”}	0xa88594d404727625a9437c3f886c7643872296ae	133	24507971	2025-01-02T08:08:09.000Z	0x62529b9c65f0781c0772bf739034b1d8afee87591e71c52988a77f69208ee458
0xb63902d38738e353f3f52add203c418a0bfea172	false	{“tip”:“10000000000000”,“qtype”:2,“minMarginAmount”:“2000000000000000”,“tradingFeeRatio”:“1”,“protocolFeeRatio”:“2”,“stabilityFeeRatioParam”:“14415916854096691200”}	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	54	17213659	2024-07-17T11:44:25.000Z	0x512cd3b312d2fa2e02070ea3b75711a9fead93db82608083132c1ef4b6a0d8f7

Example Query

Query with partition filter

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

Gate_Blacklist_event

Trader blacklist status changes from SynFutures V3 perpetual futures protocol on Base. Records when addresses are added to or removed from the trading blacklist for compliance and risk management analysis.

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_banned`	`BOOL`	Indicates whether the trader address was added to (`true`) or removed from (`false`) the blacklist in this event. This boolean flag represents the ban status being applied to the trader at the time of the transaction.

Sample Data

address	removed	in_banned	in_trader	log_index	block_number	block_timestamp	transaction_hash
0x208b443983d8bcc8578e9d86db23fba547071270	false	true	0x9727bf2a8470d24b052377a779b15c50a2e99624	4	16297478	2024-06-26T06:45:03.000Z	0x49dc299dede195c827bf041b967337e4060512e373cd86c40b0f48dde28f96e5
0x208b443983d8bcc8578e9d86db23fba547071270	false	true	0x556ef67910ad3f1b122e0891a6b153387143bb46	333	25373978	2025-01-22T09:15:03.000Z	0x9b4ec47a2a2559943cf203ee4099b54d7b7c701a4c3fb9375dbec154395a77bf
0x208b443983d8bcc8578e9d86db23fba547071270	false	false	0x556ef67910ad3f1b122e0891a6b153387143bb46	72	25379605	2025-01-22T12:22:37.000Z	0x4179e9397de7b2f12d67895ac805359507e95165722588a3434f00f4277ce83e

Example Query

Query with partition filter

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

Gate_Deposit_event

Collateral deposit events from SynFutures V3 decentralized perpetual futures protocol on Base. Records trader deposits with token amounts and quote asset addresses for tracking margin positions and protocol liquidity flows.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.

Sample Data

address	removed	in_quote	in_trader	log_index	in_quantity	block_number	block_timestamp	transaction_hash
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x1d6b1d2ad091bec4aae6a131c92008701531fdaf	0xcc879ab4de63fc7be6aaca522285d6f5d816278e	418	100000000000000000	17144095	2024-07-15T21:05:37.000Z	0xd73b41b8f65905402c54c210de668bade24d421062664b64b6f9acc383c4ade5
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x4ed4e862860bed51a9570b96d89af5e1b0efefed	0x120b0ab071ea6cd2dab788bc01912a72612a9b4c	247	200000000000000000000	17139930	2024-07-15T18:46:47.000Z	0xd097aefa1f859624c27cd8761fca7be294afc13059aaeabc54eb9f833b871962
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x28874dda655ba378de7d75b10236f950e3180140	1	40129154	17132989	2024-07-15T14:55:25.000Z	0x3d82ce40e25ec7a3f41ae25ef2ccb32ae0a8095b954105f11c36c20c06ccb5aa

Example Query

Query with partition filter

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

Gate_Gather_event

Collateral withdrawal events from SynFutures v3 perpetual futures protocol on Base, recording when traders remove quote tokens from specific instruments. Used for tracking capital flows, margin management patterns, and liquidity extraction across derivative markets.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_instrument`	`STRING`	Contract address of the derivative instrument or trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.

Sample Data

address	removed	in_quote	in_expiry	in_trader	log_index	in_quantity	block_number	in_instrument	block_timestamp	transaction_hash
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	4294967295	0x0000fff49d8da8c443921a56a3fffde01c822a0d	222	24066981	26176450	0x04d72fb4803b4e02f14971e5bd092375eb330749	2025-02-09T23:04:07.000Z	0x7834d1f978f18da57837ba9f17d1407239fc4ebf11a68845c53ab63984d31c2d
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	4294967295	0x000c3d78c4d5d5eeaf95b2547ad8dcd7d269566f	300	21197999	26168720	0x04d72fb4803b4e02f14971e5bd092375eb330749	2025-02-09T18:46:27.000Z	0x564e635747841481822203363517c9d0c7327097166979d1ddefd283ea14744f
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	4294967295	0x000cccae9cf0d50ddc7990051c4fc7d4253000ed	350	20281764	26157214	0x04d72fb4803b4e02f14971e5bd092375eb330749	2025-02-09T12:22:55.000Z	0x5c54e471974969809c7959264b054d5bbb77b233ecd51ce1bf6a530122e9aa85

Example Query

Query with partition filter

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

Gate_Initialized_event

No description available.

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_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Gate_NewInstrument_event

New trading instrument creation events from SynFutures v3 perpetual futures protocol on Base. Captures market listings with instrument addresses, base/quote token pairs, symbols, and sequential instrument counts for tracking protocol growth.

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_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_instrument`	`STRING`	Contract address of the derivative instrument or trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`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_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_total`	`STRING`	Total count of instruments registered in the Gate contract at the time this new instrument was created. Increments sequentially with each NewInstrument event emission.

Sample Data

address	in_base	removed	in_index	in_quote	in_total	in_symbol	log_index	block_number	in_instrument	block_timestamp	transaction_hash
0x208b443983d8bcc8578e9d86db23fba547071270	0x0000000000000000000000000000000000000000	false	0x95e03fdc26c31c1ae292aab82906dd929215968c1ef7f9580b525b47f281a34a	0xe4b20925d9e9a62f1e492e15a81dc0de62804dd4	53	JPY-BtcUSD-EMG	411	23823789	0x0a210cadebd32157299b60aa18800ff580887980	2024-12-17T12:02:05.000Z	0x72dfe57109b03b15928c5ed0fd439195f284c5f94f67344e080c96533c7c66e4
0x208b443983d8bcc8578e9d86db23fba547071270	0x0000000000000000000000000000000000000000	false	0x586710022902854e8f41d2331a214aa5b9890a12d02bd4e634cb38bcbae485fb	0x2eac9b08a4d86f347b9e856fb3ec082e61c76545	52	USDC-AIRENE-EMG	28	23822781	0x9e74aa8311e50fe258f8364e4fe593293a4fa639	2024-12-17T11:28:29.000Z	0x3d995114a15dfa590146d2244c073d174853a9267e26a07c8888f91d21016a76
0x208b443983d8bcc8578e9d86db23fba547071270	0x0000000000000000000000000000000000000000	false	0xfb773d6015e106f25586e5855bfb138587e2ce886ac2600077d42fe3889c5d25	0x74aa9bb52b36a378a6e641b86d7acb76dc9b3940	51	USDC-TRVL-EMG	24	23822738	0x32bdb0d18d6cc94d282e1c92e7423007e9a51425	2024-12-17T11:27:03.000Z	0x0efa3712252d81e5a4fd514cf5031e778004f2762de3b12da49f893789b0ce2e

Example Query

Query with partition filter

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

Gate_Scatter_event

Scatter events from SynFutures V3 perpetual futures protocol on Base, recording trader position dispersals across instruments with quantities and expiry timestamps. Used for analyzing position management patterns and instrument-level trading activity.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_instrument`	`STRING`	Contract address of the derivative instrument or trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.

Sample Data

address	removed	in_quote	in_expiry	in_trader	log_index	in_quantity	block_number	in_instrument	block_timestamp	transaction_hash
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	4294967295	0xb38d9719f6561d5338d050247f9dffa2792975bc	1	28376026	18396048	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	2024-08-13T20:37:23.000Z	0x0e41ddedbe93a08854bf6a63dbb653b48c3913b187c90e4b375d5fdb4029f231
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	4294967295	0xd6ba8e0957b29177d230bc1e4e2982a3f8a8080c	1	28517437566	18377297	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	2024-08-13T10:12:21.000Z	0x1670c66781b52040a92cbc2aba09928cb1a4e08db4776403395ed1a3d42de73d
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	4294967295	0x8d10b5acd7a68e05a48e8611b04451bf3c818c87	1	29487384	18387547	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	2024-08-13T15:54:01.000Z	0xebbdf0e3d1b8beac87788fd48f1d6382dbf0d8b7c6f34cc36c05b376495556b2

Example Query

Query with partition filter

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

Gate_SetPendingDuration_event

No description available.

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_duration`	`STRING`	Duration period for the operation or quest. Numeric string representation in seconds.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Gate_SetThreshold_event

Gate configuration events from SynFutures v3 protocol on Base recording threshold parameter updates for different quote tokens. Tracks minimum trading thresholds per collateral token for analyzing protocol risk parameters and market access requirements.

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_threshold`	`STRING`	Minimum threshold amount required for gate operations denominated in the specified quote token. Values are represented as integers in the token’s smallest unit (wei for 18-decimal tokens).

Sample Data

address	removed	in_quote	log_index	block_number	in_threshold	block_timestamp	transaction_hash
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x3ee5e23eee121094f1cfc0ccc79d6c809ebd22e5	58	21354516	2000000000000000000000000	2024-10-21T08:12:59.000Z	0xaf06d41d00a925d6cca3f19a1c61d28752ce1b3e187c61d8519a1ebcf90e88a1
0x208b443983d8bcc8578e9d86db23fba547071270	false	0xdcefd8c8fcc492630b943abcab3429f12ea9fea2	31	20233637	20000000000000	2024-09-25T09:30:21.000Z	0x6f32fae541e92a6d6f41fa6e683277501482e28cd4eecd452ca59721fe55872f
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	41	20246493	10000000000	2024-09-25T16:38:53.000Z	0xe0f187bc824ad4d80571a7fcf1e6d27fb455a83f6c3c0c591689218c749f513a

Example Query

Query with partition filter

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

Gate_UpdatePending_event

Pending balance updates for trader accounts in SynFutures v3 perpetual futures protocol on Base, tracking deposit amounts, exemptions, and timestamps before settlement. Used for monitoring collateral state changes and withdrawal processing in the protocol’s gate contract.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_pending`	`STRUCT<timestamp STRING, native BOOL, amount STRING, exemption STRING>`	Pending state information containing timestamp of last update, boolean flag for native token handling, pending amount, and exemption amount. String-encoded numeric values for timestamp and amounts.

Sample Data

address	removed	in_quote	in_trader	log_index	in_pending	block_number	block_timestamp	transaction_hash
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x4200000000000000000000000000000000000006	0xbe0f37274adadb32441acdb74791de159b0bd87e	34	{“amount”:“20830412029706198397”,“native”:false,“exemption”:“0”,“timestamp”:“1728015885”}	20613269	2024-10-04T04:24:45.000Z	0xd399232dad0051abde8e675546afe2292bcf3bf956756f008f3a6ef1a2a15c87
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x4200000000000000000000000000000000000006	0xbe0f37274adadb32441acdb74791de159b0bd87e	37	{“amount”:“0”,“native”:false,“exemption”:“23770097813842246880”,“timestamp”:“0”}	20613269	2024-10-04T04:24:45.000Z	0xd399232dad0051abde8e675546afe2292bcf3bf956756f008f3a6ef1a2a15c87
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0xbe0f37274adadb32441acdb74791de159b0bd87e	33	{“amount”:“0”,“native”:false,“exemption”:“1581906687093”,“timestamp”:“0”}	20613269	2024-10-04T04:24:45.000Z	0xd399232dad0051abde8e675546afe2292bcf3bf956756f008f3a6ef1a2a15c87

Example Query

Query with partition filter

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

Gate_Withdraw_event

Withdrawal events from SynFutures V3 protocol gate contract on Base, recording when traders remove quote token collateral from their accounts. Useful for tracking capital flows and margin management patterns across different collateral types.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.

Sample Data

address	removed	in_quote	in_trader	log_index	in_quantity	block_number	block_timestamp	transaction_hash
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x1d6b1d2ad091bec4aae6a131c92008701531fdaf	0x959a90a6b88d19184ac7c46dfe43ff2968b12bd2	45	48003301540443719	17594094	2024-07-26T07:05:35.000Z	0x505647d2dfe54e51a6f7d6d4dca644054b6b1b0789b13a3f7a7c5fb16e3d3db2
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x1d6b1d2ad091bec4aae6a131c92008701531fdaf	0xf9663d97dbcb0268136f2154adcf3f81816c5a89	159	37027718300145767	17609413	2024-07-26T15:36:13.000Z	0xd1627f1bd15e22c27bdc7fd8041160e8ccebb80e8a21f81a6649849e4a347ec8
0x208b443983d8bcc8578e9d86db23fba547071270	false	0x1d6b1d2ad091bec4aae6a131c92008701531fdaf	0x883ff97b55a08513d8399b4b22536db80cc18133	270	24310000000000042	17602521	2024-07-26T11:46:29.000Z	0x590a59f2b8a398c90e82add11cea0f9e87c1e7fa40b86bbc9e373231998bc381

Example Query

Query with partition filter

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

Instrument_Add_event

Liquidity position additions on SynFutures V3 perpetual futures protocol on Base, recording trader addresses, tick ranges, balance amounts, and entry prices. Used for tracking concentrated liquidity provisioning activity and analyzing market maker position sizing across price ranges.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_range`	`STRUCT<liquidity STRING, entryFeeIndex STRING, balance STRING, sqrtEntryPX96 STRING>`	Position state data when liquidity is added within a bounded tick range. Contains balance amount, active liquidity, accumulated fee index, and square root price at entry for concentrated liquidity positions.

Sample Data

address	removed	in_range	in_expiry	in_trader	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	{“balance”:“20000000000000000000”,“liquidity”:“6052976099197553804”,“entryFeeIndex”:“294305624768396498”,“sqrtEntryPX96”:“4406475513829317954358661228664”}	4294967295	0x0fb29cc2d5e9fb5271bdf849c6599167022660d7	160	22533690	76300	84450	2024-11-17T15:18:47.000Z	0xcbb3dc43cd296a8dc5f251a820475112dba1e03145bf08ca58fc85bbd22ca2ca
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	{“balance”:“150000000000000000000”,“liquidity”:“7304026890572955394”,“entryFeeIndex”:“291693154024836934”,“sqrtEntryPX96”:“4439725096264764151548080721938”}	4294967295	0x301448fae7a6bca843c485a441cb5e7755138ccc	396	22523677	71350	89700	2024-11-17T09:45:01.000Z	0xd6ab370089dfa1cb680c21859cb6dbdba3be8ddaf7f315c349ca5cec67a0fbaf
0x05fe3b944e9307ddd285ff0024dc073e81984d68	false	{“balance”:“400000000000000000000000”,“liquidity”:“511919435380306207655”,“entryFeeIndex”:“16609302575178819836”,“sqrtEntryPX96”:“34145241892230818289071249841603”}	4294967295	0x4243b77e0f91f7f4b86092189d5c47c0e85de89c	391	22506366	105200	137450	2024-11-17T00:07:59.000Z	0xe7aa5ac2472ddaf5e8cf2186e286caaafbfc36518e935eb456194f9e5eb2a561

Example Query

Query with partition filter

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

Instrument_Adjust_event

Position adjustment events from SynFutures V3 perpetual contracts on Base, recording net position changes for traders. Used to track position size modifications, margin adjustments, and trader activity in perpetual futures markets.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_net`	`STRING`	Net position change for the trader’s instrument, denominated in the smallest unit of the contract. Can be positive (long) or negative (short), representing the size adjustment in wei-equivalent precision.

Sample Data

in_net	address	removed	in_expiry	in_trader	log_index	block_number	block_timestamp	transaction_hash
1075665000000000000	0x04d72fb4803b4e02f14971e5bd092375eb330749	false	4294967295	0x75d5dbb9fff7df8c3b2b974eb89a825f25046dbb	43	19655582	2024-09-12T00:21:51.000Z	0x1f9a9cbf3da3a56c763ad79e824d2d47b4101d8f81a9f1f85ddd31a7e0ba48ec
-14522590430504450000000	0x04d72fb4803b4e02f14971e5bd092375eb330749	false	4294967295	0xaf96de66b93c3448d4a5b55d9cc89456f301c5b9	162	19655665	2024-09-12T00:24:37.000Z	0xc088a705d0acd593b1fc74f155eb6e4706f235f17461e9c543293453945a060f
-1481211893382017	0x04d72fb4803b4e02f14971e5bd092375eb330749	false	4294967295	0x75d5dbb9fff7df8c3b2b974eb89a825f25046dbb	144	19655672	2024-09-12T00:24:51.000Z	0x3a53683e165b8fd5abade0d24ca0ce11772fed235410d56c1ac96de0d355b307

Example Query

Query with partition filter

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

Instrument_AdminChanged_event

No description available.

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_previousAdmin`	`STRING`	-
`in_newAdmin`	`STRING`	Address of the newly assigned administrator. Hex-encoded, 0x-prefixed, 42-character string representing the Ethereum address that will receive admin privileges.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Instrument_Cancel_event

Order cancellation events from SynFutures v3 perpetual futures protocol on Base, recording cancelled limit orders with trader address, price tick, nonce, and position-in-contract (PIC) state at cancellation time. Used for analyzing order book dynamics and trader behavior patterns.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_pic`	`STRUCT<balance STRING, size STRING, entryNotional STRING, entrySocialLossIndex STRING, entryFundingIndex STRING>`	Position-in-contract structure containing the trader’s position state. Contains balance (collateral), size (position quantity), entryNotional (initial position value), entrySocialLossIndex (social loss tracking), and entryFundingIndex (funding rate tracking) as string-encoded numeric values.

Sample Data

in_pic	address	in_tick	removed	in_expiry	in_trader	log_index	block_number	block_timestamp	transaction_hash
{“size”:“0”,“balance”:“0”,“entryNotional”:“0”,“entryFundingIndex”:“0”,“entrySocialLossIndex”:“0”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	110385	false	4294967295	0x110deb03196a82174ca2edf4224898ed45f110af	30	16498516	2024-06-30T22:26:19.000Z	0x7c48b1e2bd7ccdc8b22b913ecbc9ec161602f49dad9ebbe8fbb42cda7c2c9260
{“size”:“0”,“balance”:“0”,“entryNotional”:“0”,“entryFundingIndex”:“0”,“entrySocialLossIndex”:“0”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	110130	false	4294967295	0x110deb03196a82174ca2edf4224898ed45f110af	6	16471005	2024-06-30T07:09:17.000Z	0xe7b1abef07a44dc073784d5e44fa02049c830874b0a66201ee2be11fc2459869
{“size”:“0”,“balance”:“0”,“entryNotional”:“0”,“entryFundingIndex”:“0”,“entrySocialLossIndex”:“0”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	110130	false	4294967295	0x110deb03196a82174ca2edf4224898ed45f110af	60	16470916	2024-06-30T07:06:19.000Z	0xd47738da8551f4034ee87768994dc126de98631885ddf73b46e2440d3b406e75

Example Query

Query with partition filter

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

Instrument_ClaimProtocolFee_event

Protocol fee collection events from SynFutures V3 perpetual futures instruments on Base. Records fee claims by instrument address with claimed amounts and expiry timestamps for tracking protocol revenue distribution.

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_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_expiry	log_index	block_number	block_timestamp	transaction_hash
0xdd53d6fc4b4a97a921d65fe81deccb78f2210891	false	0	4294967295	120	19713824	2024-09-13T08:43:15.000Z	0xb2a8764005135875007552064436c02b661613876840ae5105b7f192bdbf6a65
0x1167525986013bbf615f68b74db6b76490d1c8b4	false	0	4294967295	146	19713824	2024-09-13T08:43:15.000Z	0xb2a8764005135875007552064436c02b661613876840ae5105b7f192bdbf6a65
0xe8427e0ba60252d05e74a718d167e2530e3afb8b	false	103750566277501	4294967295	141	19713824	2024-09-13T08:43:15.000Z	0xb2a8764005135875007552064436c02b661613876840ae5105b7f192bdbf6a65

Example Query

Query with partition filter

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

Instrument_DeleteContext_event

Instrument deletion events from SynFutures V3 perpetual futures protocol on Base, recording when trading instruments are removed with expiry timestamps (4294967295 indicates perpetual contracts). Used for tracking instrument lifecycle and market availability 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_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.

Sample Data

address	removed	in_expiry	log_index	block_number	block_timestamp	transaction_hash
0x7c83c8121b4d7774bf3a95b3dc8a4f89c9394ded	false	4294967295	180	24983569	2025-01-13T08:21:25.000Z	0xb678277bdb4a9935dfa49680cd2b4a0a517ce612b4349b45a3e9d6a2be10e5e3
0x1120a835f81236d49c5823e3fe8477831f397217	false	4294967295	146	24983849	2025-01-13T08:30:45.000Z	0xc8b3983c8d34cf833ebe0ffd82b3e1df164f8d20d44a5d070c20238ad016496c
0xe8427e0ba60252d05e74a718d167e2530e3afb8b	false	4294967295	378	25329712	2025-01-21T08:39:31.000Z	0x1e8a419726609edca24f08ead38b63993a21d77eeb932f88cb1914a6a998c494

Example Query

Query with partition filter

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

Instrument_DonateInsuranceFund_event

No description available.

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_donator`	`STRING`	-
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Instrument_Fill_event

Order fill events from SynFutures V3 perpetual futures protocol on Base, capturing executed trades with position details (size, balance, entry notional), tick prices, fees, and funding indices for analyzing 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_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_pic`	`STRUCT<balance STRING, size STRING, entryNotional STRING, entrySocialLossIndex STRING, entryFundingIndex STRING>`	Position-in-contract structure containing the trader’s position state. Contains balance (collateral), size (position quantity), entryNotional (initial position value), entrySocialLossIndex (social loss tracking), and entryFundingIndex (funding rate tracking) as string-encoded numeric values.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_tip`	`STRING`	Tip amount paid to the operator for executing the transaction. String-encoded integer value representing the tip in the smallest unit of the relevant token or currency.

Sample Data

in_fee	in_pic	in_tip	address	in_tick	removed	in_expiry	in_trader	log_index	in_operator	block_number	block_timestamp	transaction_hash
11999999999998	{“size”:“109730462316987351473852660”,“balance”:“4021590146518312”,“entryNotional”:“40000000000000000”,“entryFundingIndex”:“4433195”,“entrySocialLossIndex”:“0”}	10000000000000	0x903e372da3a3e6c0ba9fd7661d24187325a17a95	-217335	false	4294967295	0x3a2573d07a483f2df23b788b683fa0ca760bf6d9	221	0xc37eaddf40862f4ad5849e013c9c41a4b81384ba	19294383	2024-09-03T15:41:53.000Z	0xdc6c2be30452603e500e434a650dda5604b1ae3e3c125c7c916d20f2415bd775
13320000000000	{“size”:“119269791333014014434185950”,“balance”:“4454663046161915”,“entryNotional”:“44400000000000000”,“entryFundingIndex”:“4707972”,“entrySocialLossIndex”:“0”}	10000000000000	0x903e372da3a3e6c0ba9fd7661d24187325a17a95	-217125	false	4294967295	0x7f178c230a7c68ad1e9121453aeeec4dff6d73c8	189	0xc37eaddf40862f4ad5849e013c9c41a4b81384ba	19290831	2024-09-03T13:43:29.000Z	0xeab9ff6e54a83235d9c0e1798e0a39b7add658ff9f41b1d7a0f9d98e69b0a789
12000000000000	{“size”:“-64654225556840053626348266”,“balance”:“4002000000000000”,“entryNotional”:“40000000000000000”,“entryFundingIndex”:“-53830632”,“entrySocialLossIndex”:“0”}	10000000000000	0xfc3155ec7fc5993625c325a07c00ff5c8f08f212	-212045	false	4294967295	0x122f085cec9723a6350a1d09370df98c334df2af	184	0xc37eaddf40862f4ad5849e013c9c41a4b81384ba	19281781	2024-09-03T08:41:49.000Z	0x32ca09c008e92715bbfddf10fba9ee2e9fa8589d0bcb2f88b6e4d08076663739

Example Query

Query with partition filter

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

Instrument_FundingFee_event

Funding fee payment events from SynFutures V3 perpetual futures protocol on Base, recording periodic funding rate settlements between traders and the protocol. Used for analyzing funding rate costs, trader position exposure, and perpetual market pricing 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_funding`	`STRING`	Funding fee amount applied to the position. String-encoded signed integer value representing the funding payment in the smallest unit of the relevant token or currency.

Sample Data

address	removed	in_trader	log_index	block_number	block_timestamp	transaction_hash
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	0xdf608c4f3c10d82a3eef154ad5589e056ed91f24	42	20734937	2024-10-07T00:00:21.000Z	0x2afb01ab56ab7fcd282415f48c4f9b5c51a3bf710e52710582cdaefde2116d4c
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	0xdf608c4f3c10d82a3eef154ad5589e056ed91f24	43	20734937	2024-10-07T00:00:21.000Z	0x2afb01ab56ab7fcd282415f48c4f9b5c51a3bf710e52710582cdaefde2116d4c
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	0x7d5e2b60f352c98b199e3a4e0323b7d7a34057cb	31	20734942	2024-10-07T00:00:31.000Z	0x68a1b3195755c6ce4cb106c2e76ed8ffcf1314f5d8d2795679500fa8e30670cf

Example Query

Query with partition filter

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

Instrument_Initialized_event

No description available.

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_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Instrument_Liquidate_event

Liquidation events from SynFutures V3 perpetual contracts on Base, recording forced position closures with mark price, position size, and involved trader and liquidator addresses. Used to analyze liquidation cascades, protocol risk events, and market volatility impacts on leveraged positions.

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_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.
`in_mark`	`STRING`	Mark price of the derivative instrument at the time of the event. String-encoded numeric value representing the price in the smallest denomination of the quote asset.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`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_mark	in_size	removed	in_expiry	in_target	in_trader	log_index	block_number	block_timestamp	transaction_hash
0x5067ae26f19e222c39d6166a39ef2168316856a8	9911345747794	1600000000000000000000	false	4294967295	0x46b78f63d6879ef74c0642cc615989aba4a0ad03	0x80533e47ef64225476f3e0771a835f2c8008c0c7	88	21396456	2024-10-22T07:30:59.000Z	0xe91a8d678180d38e44265e27508ca8956cb735b49973704a0dd85060fd6c056f
0x5be23dcb5ecf2f7789b7b6b88baac9c367659c31	269053193755	3652370014307101465909623245	false	4294967295	0xdb5858c302e52064f63abb3d5c0f58bdeed49fe5	0x80533e47ef64225476f3e0771a835f2c8008c0c7	26	21391596	2024-10-22T04:48:59.000Z	0x61024cd49ba3df1dc6f90b908fc79657096c7f4abedfda7d49cc54544e0d83a7
0x5be23dcb5ecf2f7789b7b6b88baac9c367659c31	267185524775	334925603514536373249771872	false	4294967295	0x195bd8acad454922b2cc78573286fb54be087161	0x80533e47ef64225476f3e0771a835f2c8008c0c7	114	21391606	2024-10-22T04:49:19.000Z	0xc9955e8a0d77e4da4d4ffe6e1a0e45e0191a2fcedbf1c4a10b7479522a0d2862

Example Query

Query with partition filter

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

Instrument_Place_event

Order placement events from SynFutures V3 perpetual futures protocol on Base, recording limit orders with price tick, size, balance, and trader address. Used for analyzing order book depth, liquidity provision patterns, and market maker activity.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_order`	`STRUCT<balance STRING, size STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.

Sample Data

address	in_tick	removed	in_order	in_expiry	in_trader	log_index	block_number	block_timestamp	transaction_hash
0x6ad9629078503888f005773cc546979aa37e9ee1	-1740	false	{“size”:“654500000000000000”,“balance”:“55933244183680292”}	4294967295	0xcb371524e3ff832430dba9ebe855f9f60ea92c59	323	18560980	2024-08-17T16:15:07.000Z	0x1626d3567b05ec412521f2c674bcfcb45e9349ec21320f89d03112b120ab0581
0x6ad9629078503888f005773cc546979aa37e9ee1	-1645	false	{“size”:“5000000000000000000”,“balance”:“1034542358440798990”}	4294967295	0x6ab9ce104ef80b6a6d09091760170250209f56a3	177	18574067	2024-08-17T23:31:21.000Z	0x1432f2db4ab989b5652d82411939c37e547b91c155a5ecc8ac2f9dc1090f44b1
0x6ad9629078503888f005773cc546979aa37e9ee1	-1640	false	{“size”:“5000000000000000000”,“balance”:“1035059733084601174”}	4294967295	0x6ab9ce104ef80b6a6d09091760170250209f56a3	117	18547161	2024-08-17T08:34:29.000Z	0x0c4abde2bdc2ed9fb5254c7a7fbbb5329d1bfac507b15f25af2d22b2811f7a98

Example Query

Query with partition filter

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

Instrument_RecycleInsuranceFund_event

Insurance fund recycling events from SynFutures V3 perpetual futures protocol on Base, recording when insurance fund balances are redistributed or reset for trading instruments. Used for tracking protocol risk management and solvency monitoring across different contract expiries.

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_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_expiry	log_index	block_number	block_timestamp	transaction_hash
0x7c83c8121b4d7774bf3a95b3dc8a4f89c9394ded	false	5806890000000000	4294967295	178	24983569	2025-01-13T08:21:25.000Z	0xb678277bdb4a9935dfa49680cd2b4a0a517ce612b4349b45a3e9d6a2be10e5e3
0x1120a835f81236d49c5823e3fe8477831f397217	false	51041250206008	4294967295	144	24983849	2025-01-13T08:30:45.000Z	0xc8b3983c8d34cf833ebe0ffd82b3e1df164f8d20d44a5d070c20238ad016496c
0xf7dcdda337ee076e682ddf179d7f475f42fe7821	false	134782682863000	4294967295	49	19271247	2024-09-03T02:50:41.000Z	0xb9b414872290e332ca85f624104a37751726e7fb57dc7dd6e00250bbaac9ed01

Example Query

Query with partition filter

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

Instrument_Remove_event

Liquidity removal events from SynFutures V3 perpetual futures protocol on Base, capturing when traders withdraw liquidity positions with tick range bounds, balance updates, and funding index snapshots. Used for tracking market maker position adjustments and liquidity provision behavior.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_pic`	`STRUCT<balance STRING, size STRING, entryNotional STRING, entrySocialLossIndex STRING, entryFundingIndex STRING>`	Position-in-contract structure containing the trader’s position state. Contains balance (collateral), size (position quantity), entryNotional (initial position value), entrySocialLossIndex (social loss tracking), and entryFundingIndex (funding rate tracking) as string-encoded numeric values.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_tip`	`STRING`	Tip amount paid to the operator for executing the transaction. String-encoded integer value representing the tip in the smallest unit of the relevant token or currency.

Sample Data

in_pic	address	removed	in_expiry	in_trader	log_index	in_operator	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
{“size”:“0”,“balance”:“26999436000000000000”,“entryNotional”:“0”,“entryFundingIndex”:“-308043696406091809444”,“entrySocialLossIndex”:“0”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	false	4294967295	0x14b21fe5e331e9f7a3b3daf6a54198aed7c3a985	69	0x14b21fe5e331e9f7a3b3daf6a54198aed7c3a985	17063065	109600	110200	2024-07-14T00:04:37.000Z	0x3d95212e3aa10aa23df3176edfee271f846c36aa81add607d9128fd5bb42d178
{“size”:“0”,“balance”:“59133401000000000000”,“entryNotional”:“0”,“entryFundingIndex”:“-308321466520956404371”,“entrySocialLossIndex”:“0”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	false	4294967295	0xdeea6990e9d24495526db047144fc9ba45330377	129	0xdeea6990e9d24495526db047144fc9ba45330377	17063412	109600	110250	2024-07-14T00:16:11.000Z	0xa0c350e360691c27699e2485a5b32b055f5ec0f12eb2e38c18d481d6c231ef65
{“size”:“0”,“balance”:“35944612000000000000”,“entryNotional”:“0”,“entryFundingIndex”:“-308334844632882184133”,“entrySocialLossIndex”:“0”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	false	4294967295	0xc45881873ec5720b3e6a040328f106bfd2c09d7b	164	0xc45881873ec5720b3e6a040328f106bfd2c09d7b	17063426	109600	110250	2024-07-14T00:16:39.000Z	0xd109dc0281ed9c4219063008a2be7e7a2e4a4a752dcf9acff988383a4149c0c5

Example Query

Query with partition filter

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

Instrument_Settle_event

Settlement events from SynFutures V3 perpetual futures contracts on Base, recording final position balances and settlement prices when traders close positions. Used for analyzing PnL realization, position lifecycle tracking, and settlement price discovery across perpetual instruments.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_settlement`	`STRING`	Account address of the settlement being processed or claimed. Base58-encoded Solana public key or hex-encoded EVM address.
`in_balance`	`STRING`	Token balance amount involved in the operation. Numeric string representation in smallest denomination of the token.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_expiry	in_trader	log_index	in_balance	in_operator	block_number	in_settlement	block_timestamp	transaction_hash
0xba01a365dffa8ad0bca001532977ae2eef83407f	false	4294967295	0xda50a0ff48eda9b67a8fb2ba8274eec1e6351843	176	22623448241748458331	0x086c8f3e5c2d4cb5f31b753c2e6eb029fc5c138b	24078351	1002209864814941331	2024-12-23T09:27:29.000Z	0x5eb94466b8d055a151afc3f5b6b7e75ef4ca40cda55e20c927880ad691085cf9
0xba01a365dffa8ad0bca001532977ae2eef83407f	false	4294967295	0x71a0e06525b8db9cfc319748569e7fd1d8a89cbd	185	959203940823942177143	0x086c8f3e5c2d4cb5f31b753c2e6eb029fc5c138b	24078351	1002209864814941331	2024-12-23T09:27:29.000Z	0x5eb94466b8d055a151afc3f5b6b7e75ef4ca40cda55e20c927880ad691085cf9
0xdd53d6fc4b4a97a921d65fe81deccb78f2210891	false	4294967295	0xfc3755da4778d17150b2180c9c0fab9814fe8ed2	239	5500212570261206	0x086c8f3e5c2d4cb5f31b753c2e6eb029fc5c138b	24078166	960756899064577390	2024-12-23T09:21:19.000Z	0x55e18dad5e8ee52191c2c3d6b4fbb9650dd0165eaaae6cb6509fbadef5f3338a

Example Query

Query with partition filter

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

Instrument_Sweep_event

Position sweep events from SynFutures v3 perpetual futures on Base, recording trader position updates with mark price, size changes, and fee ratios. Used for tracking position liquidations, forced closures, and portfolio rebalancing activity.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`in_takenSize`	`STRING`	Amount of the position filled or matched from available liquidity in the order book. String-encoded signed integer representing the executed size in the smallest unit of the derivative contract.
`in_takenValue`	`STRING`	Notional value of the filled portion of the position, matched from available liquidity. String-encoded signed integer representing the monetary value in the smallest unit of the quote asset.
`in_entryNotional`	`STRING`	Notional value of the trader’s entry position in the derivative instrument. String-encoded integer representing the value in the smallest unit of the quote asset.
`in_feeRatio`	`STRING`	Fee tier or ratio applied to the transaction. String-encoded integer representing the fee level, where higher values indicate higher fee tiers.
`in_sqrtPX96`	`STRING`	Square root of the price ratio scaled by 2^96. String-encoded integer used in Uniswap V3-style concentrated liquidity calculations for precise price representation.
`in_mark`	`STRING`	Mark price of the derivative instrument at the time of the event. String-encoded numeric value representing the price in the smallest denomination of the quote asset.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_mark	in_size	removed	in_expiry	in_trader	log_index	in_feeRatio	in_operator	in_sqrtPX96	block_number	block_timestamp	in_entryNotional	transaction_hash
0x04d72fb4803b4e02f14971e5bd092375eb330749	3753127789051632662838	4844224794205191	false	4294967295	0x089f879febdc7374e9cbb7533419bf9e06d69562	129	1	0xc37eaddf40862f4ad5849e013c9c41a4b81384ba	4856281730568719080438296446590	23159605	2024-12-02T03:02:37.000Z	18200020059017737698	0x8d66ee181c1751f4d98a3f9c71ae96a7c459a72dbfeaffc5a0e984706425e9e0
0x620d1d6453873a4e36570ad6ddcf850ad0cd3952	743267196057291291	297733107525425734067	false	4294967295	0x2f22b815ea67da96183398f263d7cfb5e7c1c34d	124	5	0xc37eaddf40862f4ad5849e013c9c41a4b81384ba	69364433269372906990630598906	23159015	2024-12-02T02:42:57.000Z	224729467967610724867	0xb965bac934f2f204e638272295768dae0ddbb5f9cb34293f5a5ab6bc2326874b
0x2ac4298f159ed0e694a4ac2fe4817f6429f9d2de	3238992686507722937231	1287200000000000000	false	4294967295	0xb84815e09f6d24767eeb46cd30f6ec088d599896	159	5	0xc37eaddf40862f4ad5849e013c9c41a4b81384ba	4540231671123026824206959029330	23185196	2024-12-02T17:15:39.000Z	4196133409112630874242	0x1f7af52b83438bab7aa9e273cafd387f5391de3ff80cbf1a3faa2de1a1dadc3d

Example Query

Query with partition filter

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

Instrument_Trade_event

Trade execution events from SynFutures V3 perpetual futures protocol on Base, capturing position changes with size, entry price (sqrtPX96), mark price, and fee data. Used for analyzing trader activity, position sizing, and market price movements across perpetual instruments.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_takenSize`	`STRING`	Amount of the position filled or matched from available liquidity in the order book. String-encoded signed integer representing the executed size in the smallest unit of the derivative contract.
`in_takenValue`	`STRING`	Notional value of the filled portion of the position, matched from available liquidity. String-encoded signed integer representing the monetary value in the smallest unit of the quote asset.
`in_entryNotional`	`STRING`	Notional value of the trader’s entry position in the derivative instrument. String-encoded integer representing the value in the smallest unit of the quote asset.
`in_feeRatio`	`STRING`	Fee tier or ratio applied to the transaction. String-encoded integer representing the fee level, where higher values indicate higher fee tiers.
`in_sqrtPX96`	`STRING`	Square root of the price ratio scaled by 2^96. String-encoded integer used in Uniswap V3-style concentrated liquidity calculations for precise price representation.
`in_mark`	`STRING`	Mark price of the derivative instrument at the time of the event. String-encoded numeric value representing the price in the smallest denomination of the quote asset.

Sample Data

address	in_mark	in_size	removed	in_amount	in_expiry	in_trader	log_index	in_feeRatio	in_sqrtPX96	block_number	block_timestamp	in_entryNotional	transaction_hash
0x04d72fb4803b4e02f14971e5bd092375eb330749	2604718818438877866795	-27349101549420657	false	0	4294967295	0x0005e531ee5d25d685f4de0f3d99fef9732caf49	271	1	4045600096121810833229227773687	25895318	2025-02-03T10:53:03.000Z	71311658160799045269	0x4e63c82404f60c321d71513edfee3499e1cc327883fb0445d7603c9e5631f98e
0x04d72fb4803b4e02f14971e5bd092375eb330749	2604718818438877866795	27349101549420657	false	9789755000000000000	4294967295	0x0005e531ee5d25d685f4de0f3d99fef9732caf49	268	1	4045700113360943873899087318245	25895318	2025-02-03T10:53:03.000Z	71311658160799045270	0x4e63c82404f60c321d71513edfee3499e1cc327883fb0445d7603c9e5631f98e
0x04d72fb4803b4e02f14971e5bd092375eb330749	2728512006382627849115	26358601653830409	false	219141769000000000000	4294967295	0x00249f173b9df38210a408da377ee82a5696537d	259	1	4140642731566876777856947695904	25912312	2025-02-03T20:19:31.000Z	71992795601777284820	0x0bbb79c7e6701e3c04fff8d6017b2cdb2e124f19be0b5932cd46721a319a97c4

Example Query

Query with partition filter

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

Instrument_UpdateAmmStatus_event

Automated Market Maker (AMM) status change events from SynFutures V3 perpetual futures instruments on Base, capturing mark prices, sqrt price ratios (sqrtPX96), and status transitions. Used for tracking liquidity pool state changes and price discovery mechanics across derivative instruments.

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_status`	`INT64`	Status code representing the state of the entity or operation. Integer value with meaning specific to the contract context.
`in_sqrtPX96`	`STRING`	Square root of the price ratio scaled by 2^96. String-encoded integer used in Uniswap V3-style concentrated liquidity calculations for precise price representation.
`in_mark`	`STRING`	Mark price of the derivative instrument at the time of the event. String-encoded numeric value representing the price in the smallest denomination of the quote asset.

Sample Data

address	in_mark	removed	in_expiry	in_status	log_index	in_sqrtPX96	block_number	block_timestamp	transaction_hash
0xba01a365dffa8ad0bca001532977ae2eef83407f	1000849720000000000	false	4294967295	1	215	79261816243846403132836166972	17719009	2024-07-29T04:29:25.000Z	0x484a4d1b78ea24a1b9f0a4d7431c1608b81da2fc83d419f98294d805eca8c89e
0x85dd569bd252967ce7ee4e96617f42d94ca82c5d	80134108575	false	4294967295	1	57	22427883359777783451474836	17725288	2024-07-29T07:58:43.000Z	0x6565f0fb4527592499844afe6d8f9811d2fa26b16bbc7c48a7cf863b09b75cdb
0x62ba13b3e351b4379964de33437d0afd32ab18b0	92210793180380000000000	false	4294967295	1	39	24058606150272829259481412327597	24411722	2024-12-31T02:39:51.000Z	0xa3048537732275c5ff52b3974250215c39f8cf010f8392cdcb4bca656ff9577d

Example Query

Query with partition filter

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

Instrument_UpdateCondition_event

State change events tracking instrument condition updates in SynFutures V3 perpetual futures protocol on Base. Records when trading instruments transition between market conditions (e.g., normal, paused, emergency) with timestamps for monitoring protocol health and trading availability.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_condition`	`INT64`	Status code indicating the current condition state of the SynFutures instrument. Based on sample data, value 0 appears to represent a standard or normal operational state.

Sample Data

address	removed	log_index	block_number	in_timestamp	block_timestamp	transaction_hash
0xb41303f0382dfe669a71f1f9c13146ff41e4b6dd	false	68	18797798	1724384943	2024-08-23T03:49:03.000Z	0x0df2620e1a786ec94323df86d3d8616b65b77030c262544b8b1de59c16424451
0xbdcc0c1068a1c27a52c7902b348af2d033abc189	false	354	16560266	1719909879	2024-07-02T08:44:39.000Z	0x906daf392badfa1b9a38f6384af970323a20deec55a3767277474f2ce2fa67b8
0x75da1f73fa85ce885fd209e34d6d9334ecaff14f	false	206	16560062	1719909471	2024-07-02T08:37:51.000Z	0xd21f99f789f899b502d8339c3e3e35087da551d889fcabba0eda6d9d35ee1d59

Example Query

Query with partition filter

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

Instrument_UpdateFeeState_event

Fee state updates for SynFutures V3 instruments on Base, tracking cumulative fee indices and protocol fee accruals per trading instrument. Used to analyze fee generation patterns and protocol revenue over time.

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_feeIndex`	`STRING`	Cumulative fee index value for the SynFutures V3 instrument at the time of the fee state update. Represented as a high-precision integer that increases monotonically with each fee accrual event.
`in_protocolFee`	`STRING`	Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.

Sample Data

address	removed	in_expiry	log_index	in_feeIndex	block_number	in_protocolFee	block_timestamp	transaction_hash
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	4294967295	81	100000386174310990	21362596	8827100844116076137942	2024-10-21T12:42:19.000Z	0x63092084437bd40fe2db264d155139d779554ad2d6d62556f2c62591d37aa3ef
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	4294967295	45	100000645624689326	21362598	8827129181989790294532	2024-10-21T12:42:23.000Z	0x3e0534ff972799fb43bd8b6d0993401f9791bb54afc24d5e541f7981cc2d35c3
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	4294967295	53	100001197948666084	21362599	8827189508311929648799	2024-10-21T12:42:25.000Z	0xb2da25a445bc8ed6163c4ae47e18635666a758e41b50b862cab4348a7ef60f0e

Example Query

Query with partition filter

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

Instrument_UpdateFundingIndex_event

Funding rate index update events from SynFutures v3 perpetual contracts on Base, tracking the cumulative funding index for each instrument. Used for calculating funding payments between long and short position holders over time.

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_fundingIndex`	`STRING`	Index value tracking cumulative funding rate adjustments for perpetual futures positions. Numeric string representation of the funding rate counter at the time of position modification.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_fundingIndex	transaction_hash
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	1	21952109	2024-11-04T04:12:45.000Z	142543258165934439018094400448903650375783600446394036980814	0x186ff26e739acbca11115d573cfc43117dce85c87fc0b2817661ff80d638e214
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	1	21987011	2024-11-04T23:36:09.000Z	142787784744801274355271026822601888105764119971223383305658	0x0d2a2e1839b1560642460bcb2f27224d200e00da040c0fcbddb9ea75ff2cb444
0x04d72fb4803b4e02f14971e5bd092375eb330749	false	1	21966261	2024-11-04T12:04:29.000Z	142716021974312562030715911476265523854149509093517535329748	0x20567bfc3717fbd63b21daae446578085fe45b49afc425869d48d77526168034

Example Query

Query with partition filter

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

Instrument_UpdateMarginRatio_event

Margin requirement updates for trading instruments on SynFutures V3 perpetual futures protocol on Base, capturing changes to initial margin ratio (IMR) and maintenance margin ratio (MMR). Used for tracking risk parameter adjustments and leverage changes across different instruments.

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_initialMarginRatio`	`STRING`	Initial margin ratio required to open a position on this SynFutures instrument, expressed in basis points (e.g., ‘1000’ = 10%). Updated via governance when risk parameters are adjusted for specific trading instruments.
`in_maintenanceMarginRatio`	`STRING`	Minimum margin ratio that a position must maintain to avoid liquidation, expressed in basis points. Values like ‘500’ represent 5% (500/10000), with typical maintenance ratios ranging from 2% to 7.5%.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_initialMarginRatio	in_maintenanceMarginRatio
0x322a1dbe2b19b68eed0adf59b368db33e60838e2	false	581	25282700	2025-01-20T06:32:27.000Z	0xdd318f0b6c4961a7e1a5ed3e5608ac318b8e9566c52ab57e815279cb1f1ac905	1000	500
0x322a1dbe2b19b68eed0adf59b368db33e60838e2	false	274	25283788	2025-01-20T07:08:43.000Z	0xade99832f3f85cb544410b4f25e7b85b54e16823db5a13bab57021b3e07d3e28	2000	750
0x85dd569bd252967ce7ee4e96617f42d94ca82c5d	false	264	25287073	2025-01-20T08:58:13.000Z	0x7348417e9228f2ec89bfa9a3ed3e3e648baad057cde26e604add9d4d0abcbcaa	2000	750

Example Query

Query with partition filter

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

Instrument_UpdateParam_event

Parameter update events for SynFutures V3 derivative instruments on Base, capturing changes to trading fees, margin requirements, tips, and stability fee ratios for each instrument contract.

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_param`	`STRUCT<minMarginAmount STRING, tradingFeeRatio STRING, protocolFeeRatio STRING, stabilityFeeRatioParam STRING, qtype INT64, tip STRING>`	Configuration parameters for automated market maker or protocol settings. Structured data containing fee ratios, margin requirements, and protocol-specific settings encoded as strings or structs.

Sample Data

address	removed	in_param	log_index	block_number	block_timestamp	transaction_hash
0x0a210cadebd32157299b60aa18800ff580887980	false	{“tip”:“20000000000000000”,“qtype”:1,“minMarginAmount”:“2000000000000000000”,“tradingFeeRatio”:“1”,“protocolFeeRatio”:“2”,“stabilityFeeRatioParam”:“14415916854096691200”}	199	23825012	2024-12-17T12:42:51.000Z	0x83e13fabdc0a3fb155c83fe12a6cef3bdb9ebc7d38cbfa4ba9fea53356674d6e
0x0a210cadebd32157299b60aa18800ff580887980	false	{“tip”:“20000000000000000”,“qtype”:1,“minMarginAmount”:“10000000000000000000”,“tradingFeeRatio”:“1”,“protocolFeeRatio”:“1”,“stabilityFeeRatioParam”:“14415916854096691200”}	409	23823789	2024-12-17T12:02:05.000Z	0x72dfe57109b03b15928c5ed0fd439195f284c5f94f67344e080c96533c7c66e4
0x32bdb0d18d6cc94d282e1c92e7423007e9a51425	false	{“tip”:“500000000000000000”,“qtype”:2,“minMarginAmount”:“50000000000000000000”,“tradingFeeRatio”:“6”,“protocolFeeRatio”:“1”,“stabilityFeeRatioParam”:“14415916854096691200”}	22	23822738	2024-12-17T11:27:03.000Z	0x0efa3712252d81e5a4fd514cf5031e778004f2762de3b12da49f893789b0ce2e

Example Query

Query with partition filter

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

Instrument_UpdatePosition_event

Position state change events from SynFutures V3 perpetual futures protocol on Base, tracking trader positions with size, collateral balance, entry prices, and funding/social loss indices. Used for analyzing position lifecycle, PnL calculations, and trader behavior across perpetual instruments.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_pic`	`STRUCT<balance STRING, size STRING, entryNotional STRING, entrySocialLossIndex STRING, entryFundingIndex STRING>`	Position-in-contract structure containing the trader’s position state. Contains balance (collateral), size (position quantity), entryNotional (initial position value), entrySocialLossIndex (social loss tracking), and entryFundingIndex (funding rate tracking) as string-encoded numeric values.

Sample Data

in_pic	address	removed	in_expiry	in_trader	log_index	block_number	block_timestamp	transaction_hash
{“size”:“-707235648461533”,“balance”:“26860662333333333324”,“entryNotional”:“71333333333333376833”,“entryFundingIndex”:“-142958580279102531092”,“entrySocialLossIndex”:“6308763792900635556”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	false	4294967295	0x000758988ba3f07f3a782c095ae8de141b2ff568	161	23889554	2024-12-19T00:34:15.000Z	0x6c065270f4fe60fa580d61a6fd50ee42c33f68232784dd2f6a2c3ab71bb52884
{“size”:“0”,“balance”:“0”,“entryNotional”:“0”,“entryFundingIndex”:“0”,“entrySocialLossIndex”:“0”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	false	4294967295	0x000758988ba3f07f3a782c095ae8de141b2ff568	167	23889554	2024-12-19T00:34:15.000Z	0x6c065270f4fe60fa580d61a6fd50ee42c33f68232784dd2f6a2c3ab71bb52884
{“size”:“740269789003989”,“balance”:“37478848486599440027”,“entryNotional”:“72677567002799861039”,“entryFundingIndex”:“-3593385173095798565993”,“entrySocialLossIndex”:“0”}	0xec6c44e704eb1932ec5fe1e4aba58db6fee71460	false	4294967295	0x002d5629e91f0b0b638c74badf32e8c39828a03a	316	23922005	2024-12-19T18:35:57.000Z	0xf5e38264fd11e416020484bf999d96ef429bcc9c93d71cbcb1dc2c3938193277

Example Query

Query with partition filter

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

Instrument_UpdateSocialLossInsuranceFund_event

Insurance fund balance updates from SynFutures V3 perpetual contracts on Base, tracking social loss distribution between long and short positions. Used for monitoring protocol solvency and analyzing liquidation backstop mechanisms across derivative instruments.

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_longSocialLossIndex`	`STRING`	Cumulative index tracking socialized losses allocated to long position holders for this instrument. Typically starts at zero and increments when the insurance fund cannot fully cover losses from liquidations.
`in_shortSocialLossIndex`	`STRING`	Index tracking cumulative socialized losses for short positions in this SynFutures V3 instrument. Always zero in samples, indicating no short-side loss socialization has occurred for this perpetual contract (expiry 4294967295).
`in_insuranceFund`	`STRING`	Updated insurance fund balance for the instrument after this event, denominated in the protocol’s base unit. Represents the collateral pool available to cover socialized losses for this perpetual futures instrument.

Sample Data

address	removed	in_expiry	log_index	block_number	block_timestamp	in_insuranceFund	transaction_hash
0xe8427e0ba60252d05e74a718d167e2530e3afb8b	false	4294967295	85	17494934	2024-07-24T00:00:15.000Z	6847740418263904	0xbb64c4aebc2e7d47294d1c52e5ee129775bdfb2172a5baab4003ff5ed3fcc28f
0xe8427e0ba60252d05e74a718d167e2530e3afb8b	false	4294967295	38	17494945	2024-07-24T00:00:37.000Z	6847879944289263	0x69fa3135595739f8119f983ce75c80ad5f8b17d254e27e9b522fd1960bd708ca
0xbdcc0c1068a1c27a52c7902b348af2d033abc189	false	4294967295	45	17494945	2024-07-24T00:00:37.000Z	315953439575867792917	0xcb3396417d83f97ccea894859e68432c5157f764d8325045b45fcee0e7549b10

Example Query

Query with partition filter

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

Instrument_Upgraded_event

No description available.

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_implementation`	`STRING`	Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_AddInvolvedPair_event

No description available.

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_instrument`	`STRING`	Contract address of the derivative instrument or trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_deposit_function

No description available.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_RemoveInvolvedPair_event

No description available.

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_instrument`	`STRING`	Contract address of the derivative instrument or trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_SetPairConfig_event

No description available.

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_pairConfig`	`STRUCT<maxRangeNumber INT64, maxOrderNumber INT64, maxPairNumber INT64>`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_SetProfitFeeRatio_event

No description available.

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_newProfitFeeRatio`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_UpdatePending_event

No description available.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pending`	`STRUCT<status INT64, quantity STRING>`	Pending state information containing timestamp of last update, boolean flag for native token handling, pending amount, and exemption amount. String-encoded numeric values for timestamp and amounts.
`in_totalPendingShares`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_UpdateShareInfo_event

No description available.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_info`	`STRUCT<shares STRING, entryValue STRING>`	-
`in_totalShares`	`STRING`	Total number of shares outstanding in the vault. Numeric string representation of share tokens in the smallest unit.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_UpdateTotalFee_event

No description available.

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_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_withdraw_function

No description available.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_withdrawFromGateAndRelease_function

No description available.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_users`	`ARRAY<STRING>`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

VaultFactory_CreateVault_event

No description available.

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_vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

​Tables

​Config_SetMarketInfo_event

​Config_SetQuoteParam_event

​Gate_Blacklist_event

​Gate_Deposit_event

​Gate_Gather_event

​Gate_Initialized_event

​Gate_NewInstrument_event

​Gate_Scatter_event

​Gate_SetPendingDuration_event

​Gate_SetThreshold_event

​Gate_UpdatePending_event

​Gate_Withdraw_event

​Instrument_Add_event

​Instrument_Adjust_event

​Instrument_AdminChanged_event

​Instrument_Cancel_event

​Instrument_ClaimProtocolFee_event

​Instrument_DeleteContext_event

​Instrument_DonateInsuranceFund_event

​Instrument_Fill_event

​Instrument_FundingFee_event

​Instrument_Initialized_event

​Instrument_Liquidate_event

​Instrument_Place_event

​Instrument_RecycleInsuranceFund_event

​Instrument_Remove_event

​Instrument_Settle_event

​Instrument_Sweep_event

​Instrument_Trade_event

​Instrument_UpdateAmmStatus_event

​Instrument_UpdateCondition_event

​Instrument_UpdateFeeState_event

​Instrument_UpdateFundingIndex_event

​Instrument_UpdateMarginRatio_event

​Instrument_UpdateParam_event

​Instrument_UpdatePosition_event

​Instrument_UpdateSocialLossInsuranceFund_event

​Instrument_Upgraded_event

​Vault_AddInvolvedPair_event

​Vault_deposit_function

​Vault_RemoveInvolvedPair_event

​Vault_SetPairConfig_event

​Vault_SetProfitFeeRatio_event

​Vault_UpdatePending_event

​Vault_UpdateShareInfo_event

​Vault_UpdateTotalFee_event

​Vault_withdraw_function

​Vault_withdrawFromGateAndRelease_function

​VaultFactory_CreateVault_event

Tables

Config_SetMarketInfo_event

Config_SetQuoteParam_event

Gate_Blacklist_event

Gate_Deposit_event

Gate_Gather_event

Gate_Initialized_event

Gate_NewInstrument_event

Gate_Scatter_event

Gate_SetPendingDuration_event

Gate_SetThreshold_event

Gate_UpdatePending_event

Gate_Withdraw_event

Instrument_Add_event

Instrument_Adjust_event

Instrument_AdminChanged_event

Instrument_Cancel_event

Instrument_ClaimProtocolFee_event

Instrument_DeleteContext_event

Instrument_DonateInsuranceFund_event

Instrument_Fill_event

Instrument_FundingFee_event

Instrument_Initialized_event

Instrument_Liquidate_event

Instrument_Place_event

Instrument_RecycleInsuranceFund_event

Instrument_Remove_event

Instrument_Settle_event

Instrument_Sweep_event

Instrument_Trade_event

Instrument_UpdateAmmStatus_event

Instrument_UpdateCondition_event

Instrument_UpdateFeeState_event

Instrument_UpdateFundingIndex_event

Instrument_UpdateMarginRatio_event

Instrument_UpdateParam_event

Instrument_UpdatePosition_event

Instrument_UpdateSocialLossInsuranceFund_event

Instrument_Upgraded_event

Vault_AddInvolvedPair_event

Vault_deposit_function

Vault_RemoveInvolvedPair_event

Vault_SetPairConfig_event

Vault_SetProfitFeeRatio_event

Vault_UpdatePending_event

Vault_UpdateShareInfo_event

Vault_UpdateTotalFee_event

Vault_withdraw_function

Vault_withdrawFromGateAndRelease_function

VaultFactory_CreateVault_event