synfutures_v3_blast - Token Terminal Docs

Tables

Config_SetMarketInfo_event

Configuration events recording market registration on SynFutures V3 (Blast), mapping market types (PYTH, LINK, DEXV2, EMG) to their beacon and market contract addresses for tracking oracle and pricing infrastructure.

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 for the SynFutures V3 trading pair configuration. Common values include EMG (emergency), DEXV2 (DEX version 2), LINK (Chainlink oracle), and PYTH (Pyth oracle), indicating the price feed mechanism.
`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	block_number	block_timestamp	transaction_hash
0x03f2e7452095a708ff19516ede92f757ade2816c	false	EMG	0x245bb4abb5c7f09b785e3483057c130a52fabb7a	0x29c4c77feda2bd90933fcfaeaf531612f51c3f26	193982	2024-02-29T09:09:39.000Z	0xd60e66bd0a16ba4a2461d624c274052407febe4890b355171bac0a1bacaecb1e
0x03f2e7452095a708ff19516ede92f757ade2816c	false	DEXV2	0x245bb4abb5c7f09b785e3483057c130a52fabb7a	0x409204744a267df16ed2a96f7686ede029e6fba7	193989	2024-02-29T09:09:53.000Z	0x0cffc7094e31cd9ae2b4193fa82a229dadf60b278787f4d6834b790f5f8b302c
0x03f2e7452095a708ff19516ede92f757ade2816c	false	LINK	0x245bb4abb5c7f09b785e3483057c130a52fabb7a	0x19bac642e72a15ac87920d4abf972c120aaaf33a	193978	2024-02-29T09:09:31.000Z	0x7697f9353be643f8e5270aa94056334a40a53f7134ecb0f8fab4f5362048f9c7

Example Query

Query with partition filter

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

Config_SetQuoteParam_event

Configuration change events for quote token parameters on SynFutures V3 perpetual futures protocol on Blast. Tracks updates to trading fees, margin requirements, and stability fee ratios for different quote asset 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
0x03f2e7452095a708ff19516ede92f757ade2816c	false	{“tip”:“200000000000000000”,“qtype”:1,“minMarginAmount”:“10000000000000000000”,“tradingFeeRatio”:“30”,“protocolFeeRatio”:“20”,“stabilityFeeRatioParam”:“14415916854096691200”}	0x4300000000000000000000000000000000000003	0	4734980	2024-06-13T11:56:15.000Z	0x5a75aabac8e47f64a2b25db9b9894243c46567c05be49178807575b972f197f0
0x03f2e7452095a708ff19516ede92f757ade2816c	false	{“tip”:“4000000000000000000”,“qtype”:2,“minMarginAmount”:“150000000000000000000”,“tradingFeeRatio”:“30”,“protocolFeeRatio”:“20”,“stabilityFeeRatioParam”:“14415916854096691200”}	0x491e6de43b55c8eae702edc263e32339da42f58c	0	4735017	2024-06-13T11:57:29.000Z	0xfba78a9884d47f9f2c8465d502791a9028c364a9bb860de5b32d488ec63616d7
0x03f2e7452095a708ff19516ede92f757ade2816c	false	{“tip”:“100000000000000”,“qtype”:2,“minMarginAmount”:“2000000000000000”,“tradingFeeRatio”:“30”,“protocolFeeRatio”:“20”,“stabilityFeeRatioParam”:“14415916854096691200”}	0xe7903b1f75c534dd8159b313d92cdcfbc62cb3cd	20	4735023	2024-06-13T11:57:41.000Z	0x4f206530aeab00a51f00ee302f1ae65d5175666135416c16f8751c65aa42f962

Example Query

Query with partition filter

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

Gate_Blacklist_event

Trader blacklist status change events from SynFutures V3 perpetual trading protocol on Blast, tracking when accounts are banned or unbanned from trading. Used for compliance monitoring and identifying sanctioned addresses in derivatives 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_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. Most events show traders being banned, though unbanning events also occur as shown in the samples.

Sample Data

address	removed	in_banned	in_trader	log_index	block_number	block_timestamp	transaction_hash
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	true	0x9727bf2a8470d24b052377a779b15c50a2e99624	1	4988196	2024-06-19T08:36:47.000Z	0xe177df928ce86e15746e01a68e532f79b7bcf49c110e680eeb24adc6425d8fed
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	true	0xf2d340a8ba536bf9a60e0a6111a0a1329b3cfb40	0	7032968	2024-08-05T16:35:51.000Z	0x2b60f6fdbf7bdee53a4f9d68413b84fa00049c415fc578dcb1096aece5a8cf6e
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	true	0x5886dc296336cc01e6c7257676171170795e8cbc	0	7032909	2024-08-05T16:33:53.000Z	0x7b6bdc07e22ddd43a80c77490641986becb821bbc9eab57afa9e633819fca656

Example Query

Query with partition filter

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

Gate_Deposit_event

Collateral deposit events from SynFutures V3 perpetual futures protocol on Blast, recording trader margin deposits by quote token and quantity. Used to track funding flows and margin account activity across the exchange.

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
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x1d6b1d2ad091bec4aae6a131c92008701531fdaf	0x1e98e9821c1d5478f4d2622c54b8f849c69218fb	1	352992302999	5276770	2024-06-26T00:55:55.000Z	0x7f98b98c8547cd21ccd4286711316d03db54094639a4113760d2f3367b59a0ce
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x1d6b1d2ad091bec4aae6a131c92008701531fdaf	0xe95dfea046847812620ae92912b1314c1a43950c	1	20000000000000	5286242	2024-06-26T06:11:39.000Z	0x3d485e851b11e633bcda1ee72873eaae641488a472e354fc8429fe963a833b56
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x1d6b1d2ad091bec4aae6a131c92008701531fdaf	0x639b8e28654edd28cc529142a8f7ef16236f41bd	1	827435259707	5277408	2024-06-26T01:17:11.000Z	0x568de7ecf097ecf10ea3b8bbd0271ca0a6c56a3462d95dd52ccf1e4773fac03c

Example Query

Query with partition filter

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

Gate_Gather_event

Collateral deposit events from SynFutures v3 perpetual futures protocol on Blast, tracking when traders add quote tokens to instrument positions. Used for analyzing margin management and account funding 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_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
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000003	4294967295	0x00b85d97a0daa1b8199b9a0e2f6a8a05bc84137e	53	68637206450763067415	6184689	0x5430561b09c627264549fdb3a6154c34f5cabea7	2024-07-17T01:19:53.000Z	0x9072b4224f3959d8614168b8032431ad6f3b30474b11520fe1d8c4035973da8d
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000003	4294967295	0x01545bcfc8d73b3469fd27be5464e642a7c45146	95	59753699342713393970	6184248	0x5430561b09c627264549fdb3a6154c34f5cabea7	2024-07-17T01:05:11.000Z	0xbf7460ffee5e46b00dc2d8c7a28db9f7ed8db951c8e7f5df804d57bdc91335ae
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000003	4294967295	0x017cd5bc2a5525c9007e07e27f54972c564ef4d0	56	43581015156361956150	6199857	0x5430561b09c627264549fdb3a6154c34f5cabea7	2024-07-17T09:45:29.000Z	0x6efc8ee5c5051467358711fb5c714c47367530b448d3c355a1d2f5ab621bf021

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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_blast.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 Blast, capturing instrument initialization with base/quote token pairs, price index sources (PYTH oracle, DEXV2, EMG emergency mode), and instrument identifiers for tracking available trading pairs.

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 created for this trading pair on SynFutures. Incrementing integer value representing the cumulative number of instrument instances.

Sample Data

address	in_base	removed	in_index	in_quote	in_total	in_symbol	log_index	block_number	in_instrument	block_timestamp	transaction_hash
0x6a372dbc1968f4a07cf2ce352f410962a972c257	0x818a92bc81aad0053d72ba753fb5bc3d0c5c0923	false	0x411f1c2c192fc141fe3f85c0e283e3875e6105447c6e627296eb411c20e6e3dc	0x4300000000000000000000000000000000000004	24	JUICE-WETH-DEXV2	18	2223029	0x99c1ca21a54d5d8d7e2ad52e0b3f7bd2326a92b4	2024-04-16T08:24:33.000Z	0xe6f1f7581e711cad111facdd1114a641fcc230eebdfc59fe5bb23e939cc07ed2
0x6a372dbc1968f4a07cf2ce352f410962a972c257	0x0000000000000000000000000000000000000000	false	0xbeab20c3cc6bfd0ddf515b1a6dcae05cb135dede56437b468491aae1ca5142e7	0x4300000000000000000000000000000000000004	8	WIF-WETH-EMG	19	497866	0xdd56a994568e01eb16c69718dae13073098f4003	2024-03-07T09:59:07.000Z	0xa591fd1693119fa454e770254c834c2ed44a0413c55a3c918161f807052a2797
0x6a372dbc1968f4a07cf2ce352f410962a972c257	0x0000000000000000000000000000000000000000	false	0x4bb3026dd82acb44b56d3bfae848b5ad811fc360035d1680cf172dbd2d93aedf	0x4300000000000000000000000000000000000004	13	SLERF-WETH-EMG	42	1005173	0x70c604e8e9beaf08ecf04c6161968a9dce491c91	2024-03-19T03:49:21.000Z	0x8be74e1969b5a5963f45b073173f3991aad688193a7c148bf9c3d73c36178c29

Example Query

Query with partition filter

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

Gate_Scatter_event

Scatter event logs from SynFutures v3 perpetual futures protocol on Blast, capturing position liquidations or forced closures with trader addresses, instrument identifiers, quantities, and perpetual expiry timestamps (4294967295 indicates perpetual contracts). Used for analyzing liquidation patterns and risk management across trading pairs.

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
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x2416092f143378750bb29b79ed961ab195cceea5	4294967295	0xd1c54453b0e602ca70feec06fdf223ecdd3cfc5c	25	45438361475962195	3044804	0x0c116455bc6c58402c82048a0e3edaa1b6ddf0db	2024-05-05T08:57:03.000Z	0xa8e1e0e3de8480c38746caa50e30a11dd1a434da0d21aa8f25aaa7c1c9ac4b4b
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x2416092f143378750bb29b79ed961ab195cceea5	4294967295	0x41e8b9986d15e234c83e1ccd781f3003b018acb4	96	7000000000000000	3053769	0x0c116455bc6c58402c82048a0e3edaa1b6ddf0db	2024-05-05T13:55:53.000Z	0x9b66ed717c5444e3ad46628b4d965c66c7070cb4f0addad60b29930f29e4e94e
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x2416092f143378750bb29b79ed961ab195cceea5	4294967295	0x867a5ea65b04a27b120142e80776ad76a0298da8	29	315115552211706813	3055138	0x0c116455bc6c58402c82048a0e3edaa1b6ddf0db	2024-05-05T14:41:31.000Z	0x4cc5d05e2816888e93eb94811f8d034c5ee694f78551886c31bd8f7d6295d7f5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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_blast.Gate_SetPendingDuration_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Gate_SetThreshold_event

Gate threshold configuration events from SynFutures v3 perpetual futures protocol on Blast, recording minimum collateral requirements per quote token. Contains threshold updates with token addresses and amounts for tracking risk parameter changes 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_threshold`	`STRING`	Minimum threshold value required for the specified quote token in the SynFutures v3 Gate contract, denominated in the token’s smallest unit (wei for 18-decimal tokens). Values range from 12.5 to 3 million tokens depending on the quote asset’s volatility and liquidity.

Sample Data

address	removed	in_quote	log_index	block_number	in_threshold	block_timestamp	transaction_hash
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x2416092f143378750bb29b79ed961ab195cceea5	18	1963953	50000000000000000000	2024-04-10T08:28:41.000Z	0x00b29e99b427f5ee3c7da61364bc66687be9dc7a3b2e38aaf1318b654f542bab
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000004	0	7018610	12500000000000000000	2024-08-05T08:37:15.000Z	0xdbcc4848e71bd81d1bc55c88a0d39850ccd2ba5d18e9e082f26ba37d464be75f
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000003	8	7018604	25000000000000000000000	2024-08-05T08:37:03.000Z	0xf8b3e8f60bbd38c518c2de6a5e255710c3ba04f8749490b8d9c3b53e61e4e1a5

Example Query

Query with partition filter

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

Gate_UpdatePending_event

Pending withdrawal state changes from SynFutures V3 perpetual futures protocol on Blast. Tracks trader withdrawal requests with amount, exemption thresholds, and timestamps for monitoring settlement queue 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_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
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000004	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	9	{“amount”:“0”,“native”:false,“exemption”:“127216365070471775729”,“timestamp”:“0”}	3776349	2024-05-22T07:21:53.000Z	0x62123fd6c4c9bb549ff2eb31086d7676e99f10407c1ce60bef3c33b7cdfd8f56
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000004	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	3	{“amount”:“69546444740136471607”,“native”:false,“exemption”:“76475882763388435587”,“timestamp”:“1716362373”}	3776279	2024-05-22T07:19:33.000Z	0xfbbd1af2cfd567f8bf099db91aa0eef3ef67ee69f8f2b69d268e082659e1449f
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000003	0x8ee6470d8396421631dd6c1b6b447b91b0555e21	11	{“amount”:“1746652011593274932097”,“native”:false,“exemption”:“54856849018329629818745”,“timestamp”:“1731589705”}	11389945	2024-11-14T13:08:25.000Z	0x08df10c3eccb7431bc4ecb86015980c75b4e970d1de7f37e27ca7356b09ce0f8

Example Query

Query with partition filter

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

Gate_Withdraw_event

Withdrawal events from SynFutures V3 perpetual futures protocol on Blast, recording when traders remove quote tokens (collateral) from the exchange. Useful for analyzing capital flows, trader liquidity management, and withdrawal patterns across different quote tokens.

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
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000003	0x1a055232ea9ee99fe7b4a56cde8ef57b81dea31a	1	55711979845245872811	6304577	2024-07-19T19:56:09.000Z	0xce21f7dbc57ebadced29dde432385c95dd71911f34e252409f5bfe94100de2ac
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000003	0xde8cedf7524fff3b43c853ab9d9a137823a597c1	1	26732749513633852498	6304211	2024-07-19T19:43:57.000Z	0x4faaf1eebf09da53319d1b72eeace6f1ac7f60413229a4785229bfe2c4c820f4
0x6a372dbc1968f4a07cf2ce352f410962a972c257	false	0x4300000000000000000000000000000000000003	0x9a7f04cc43d8e21ac4b2b79a6006fcc7378812b9	1	35697569121110418852	6301162	2024-07-19T18:02:19.000Z	0x9b28565cb8771ce475ba3f2a492122ff4acaea7e127964e2be3eefd3283b723f

Example Query

Query with partition filter

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

Instrument_Add_event

Liquidity provider position additions on SynFutures V3 perpetual futures protocol on Blast, capturing range order placements with tick bounds, entry prices, and initial liquidity amounts. Used to track LP behavior and concentrated liquidity distribution 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 details including balance, liquidity, fee index, and square root price at entry. Nested record containing four numeric fields tracking the trader’s range-bound position parameters at the time of addition.

Sample Data

address	removed	in_range	in_expiry	in_trader	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x5430561b09c627264549fdb3a6154c34f5cabea7	false	{“balance”:“2751272705135759547519”,“liquidity”:“4066721131789539394007”,“entryFeeIndex”:“3655440555246039342”,“sqrtEntryPX96”:“24749105280545605271058294213031”}	4294967295	0x4b89d407e366d948709df4c5cfcf86f78933c693	5	15394442	114200	115550	2025-02-15T05:51:39.000Z	0xe5e2e0a2e4c722d91ce1b40be5d83641a520c08c4d2169ba04beda649d26eb27
0x5430561b09c627264549fdb3a6154c34f5cabea7	false	{“balance”:“46529708015176559194”,“liquidity”:“212406195796809032834”,“entryFeeIndex”:“3655449927511969065”,“sqrtEntryPX96”:“24756530754627676474965814280134”}	4294967295	0x74b413eae30972905d2c62cddef5072355669ccc	2	15395658	114600	115200	2025-02-15T06:32:11.000Z	0xeb8453a9b731d9831059b544329f676630745d3fafef15cca784ffb616d06bfe
0x5430561b09c627264549fdb3a6154c34f5cabea7	false	{“balance”:“6156741384991719566”,“liquidity”:“24829935757229833606”,“entryFeeIndex”:“3655453051913010757”,“sqrtEntryPX96”:“24754055349092767197140122907559”}	4294967295	0xdd65e005b50544add72ac5b913d300af494ff0e6	2	15395913	114550	115200	2025-02-15T06:40:41.000Z	0x9faa60157467a013fd9f15d152db20c0475264a50e34c26d84a292daff19c690

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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 futures on Blast, recording net position changes for traders with contract addresses and expiry timestamps. Used for tracking position modifications and trader activity 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_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 adjustment amount for the trader in the instrument, denominated in the instrument’s base units. Negative values indicate position decreases or shorts, while positive values indicate position increases or longs.

Sample Data

in_net	address	removed	in_expiry	in_trader	log_index	block_number	block_timestamp	transaction_hash
-769643890518744544	0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	4294967295	0x4ec8c2cc818d5903122050581d6da8bc7c459d83	9	8437927	2024-09-07T05:07:49.000Z	0x3998bd9512e31d117cda51b9660a31509a2841f77ca4213f9719fd09fd3145f4
-674655465803680426	0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	4294967295	0x4ec8c2cc818d5903122050581d6da8bc7c459d83	9	8434797	2024-09-07T03:23:29.000Z	0xf44f06d4992b575098fa0dc328d6e3dd13fd2dd9da416f54e94de16542bc6100
-638960908819994686	0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	4294967295	0x4ec8c2cc818d5903122050581d6da8bc7c459d83	9	8430008	2024-09-07T00:43:51.000Z	0xb5f6a1a61580efc738c9b8c78482031262417886214a202e49f73f11c224a323

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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_blast.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 Blast. Contains cancelled order details including trader address, tick price, nonce, and position information for tracking order lifecycle and trading 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_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_nonce	in_expiry	in_trader	log_index	block_number	block_timestamp	transaction_hash
{“size”:“0”,“balance”:“0”,“entryNotional”:“0”,“entryFundingIndex”:“0”,“entrySocialLossIndex”:“0”}	0x5430561b09c627264549fdb3a6154c34f5cabea7	112850	false	15	4294967295	0x39ab0ec1fa9c98ad47c44f569cb0599c9330879b	6	11217731	2024-11-10T13:27:57.000Z	0xc722534860b80ac2d1a6069a98d9f63ccd7ec687df5c76b598d4df82d3047a6a
{“size”:“0”,“balance”:“0”,“entryNotional”:“0”,“entryFundingIndex”:“0”,“entrySocialLossIndex”:“0”}	0x5430561b09c627264549fdb3a6154c34f5cabea7	113280	false	0	4294967295	0x6318cf5996d1b151ccf05d2ab5ccd0feb6f43484	6	11235210	2024-11-10T23:10:35.000Z	0xb96ef58550e56b113ecfac875bb36b2fc937fb090cf804acbbf602978ef4e754
{“size”:“0”,“balance”:“0”,“entryNotional”:“0”,“entryFundingIndex”:“0”,“entrySocialLossIndex”:“0”}	0x5430561b09c627264549fdb3a6154c34f5cabea7	113295	false	0	4294967295	0xd925c1b07c0958f4a667830527d86d77aa2078a8	6	11235224	2024-11-10T23:11:03.000Z	0x6b94313bc1ed325012fe62c10d04b5f980cee1f70702200e8c6d2fb3d9b75134

Example Query

Query with partition filter

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

Instrument_ClaimProtocolFee_event

Protocol fee claim events from SynFutures V3 perpetual futures instruments on Blast. Tracks fee collection by instrument contract addresses with amount and expiry data for revenue 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_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	log_index	block_number	block_timestamp	transaction_hash
0xfc37d560b7102ad725193cf1220690740d2601cf	false	67	3420455	2024-05-14T01:38:45.000Z	0xedc9ce1475b16965926e933a4ccaaf8734ca152c2290110ae43ed28a047ac877
0x0c116455bc6c58402c82048a0e3edaa1b6ddf0db	false	86	3420455	2024-05-14T01:38:45.000Z	0xedc9ce1475b16965926e933a4ccaaf8734ca152c2290110ae43ed28a047ac877
0x99c1ca21a54d5d8d7e2ad52e0b3f7bd2326a92b4	false	92	3420455	2024-05-14T01:38:45.000Z	0xedc9ce1475b16965926e933a4ccaaf8734ca152c2290110ae43ed28a047ac877

Example Query

Query with partition filter

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

Instrument_DeleteContext_event

Instrument context deletion events from SynFutures V3 perpetual protocol on Blast, tracking when trading instruments are removed or updated with expiry timestamps. Used for monitoring instrument lifecycle and perpetual contract configuration 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
0x645fc6477c29f430362bfa40d5b7701a6e5923be	false	4294967295	19	10116521	2024-10-16T01:40:57.000Z	0xc1ec37d2267a4d34b72bb41551d9f2b06d6ab31a6c8513e9e978b9e87e64caf1
0xfa5460277d1272b8f46d5ac1753fb9162c9620f5	false	4294967295	3	12195559	2024-12-03T04:42:13.000Z	0xab76b6c67ad90e6d06c3bb3d24bae44ce13ad4e51b474bb473ad2556cc647157
0x5e89ac90f3a871948d6f50075e33dd927d7554b1	false	4294967295	6	12194387	2024-12-03T04:03:09.000Z	0x3dfef43d3c452062b5b4865c9614dd45318f7e7445ddebad092b461cf106a1d1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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_blast.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 Blast, capturing trade executions with position details (PIC - Position in Contract), fees, tick prices, 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_nonce	in_expiry	in_trader	log_index	in_operator	block_number	block_timestamp	transaction_hash
5798800000000000	{“size”:“184394519596409437194050”,“balance”:“3871565466666666666”,“entryNotional”:“57988000000000000000”,“entryFundingIndex”:“39699298002787”,“entrySocialLossIndex”:“0”}	100000000000000	0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	-80650	false	334	4294967295	0x2f56a3bdb07c64010022c495bbcdcf95fbccfb57	48	0xe38109db50602cb55d9ee272ce66aafc01b5a2d4	3044618	2024-05-05T08:50:51.000Z	0x628fa540aab17ca601cb7524dc3cd2bcf1b7c4d3496205700a56f03dd21f6672
15723894649071	{“size”:“500000000000000000000”,“balance”:“9743158050318446”,“entryNotional”:“157238946490710000”,“entryFundingIndex”:“39699016839741”,“entrySocialLossIndex”:“0”}	100000000000000	0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	-80650	false	332	4294967295	0x818445a686a41d9463cba12d707c54183ae3d4fb	27	0xc003fae5a3996a257cca4db2c3f9101ce14a47d1	3044584	2024-05-05T08:49:43.000Z	0x6df834f64bfb4472824febc365004060004d3be474fd41b84497bdab542e12be
5873562631269362	{“size”:“186771876890449171758458”,“balance”:“20145920656167379699”,“entryNotional”:“58735626312693625886”,“entryFundingIndex”:“39698965051131”,“entrySocialLossIndex”:“0”}	100000000000000	0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	-80650	false	332	4294967295	0xe38109db50602cb55d9ee272ce66aafc01b5a2d4	78	0x2f56a3bdb07c64010022c495bbcdcf95fbccfb57	3044573	2024-05-05T08:49:21.000Z	0xa878384308c44705576738e75f36ebdca87ac395777bafd5db2c65b85dd2365e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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 Blast, tracking periodic funding rate charges or credits applied to trader positions. Used for analyzing funding rate dynamics, trader funding costs, and position profitability 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_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	in_funding	block_number	block_timestamp	transaction_hash
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	0x019b28867411261e86ed2c8b1cc786ba67a4b095	93	-4517239858	14257164	2025-01-19T22:02:23.000Z	0x061497c8ede7c5bc972381a1797d538c9983aa7155bfe3f90373a061a53c329a
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	0x019b28867411261e86ed2c8b1cc786ba67a4b095	68	-341532592141	14260084	2025-01-19T23:39:43.000Z	0x1bf42285e9b603e0fd3cd1b50c26b729fafe4463cdd90b9269de743d20dbcac4
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	0x019b28867411261e86ed2c8b1cc786ba67a4b095	135	-123164606219	14257408	2025-01-19T22:10:31.000Z	0x9bc9cc8b9d6ae9b9319ede1c62aaf62c8e4f50b3c6eb8df7603611367aef6ffa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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_blast.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 Blast, recording forced position closures with trader addresses, liquidated account targets, position sizes, and mark prices. Used to analyze leverage risk, liquidation cascades, and market volatility periods.

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
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	20588117530260231822	-154000000000000000	false	4294967295	0x774becb632401af54c00f046d4ca5b8378faa40b	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	29	1848911	2024-04-07T16:33:57.000Z	0xa278bee8826f02bd64d089e09b4e5b44ec519895cbdb813161e079f3cab0a40c
0x379226d215509de2089103e0d5c425e54889830e	1250560000000009	100000000000000000000	false	4294967295	0xb5693b3fe31603dc8e83bfadf52c00fa294ddc17	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	17	1822341	2024-04-07T01:48:17.000Z	0x15289748d89dfe7e019d3c0774b5521b4b922798ea7cf6fc6edc954ff1968c59
0x379226d215509de2089103e0d5c425e54889830e	1250560000000023	20000000000000000000	false	4294967295	0x15ee162eca0686c0b8372dace195f6478064db67	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	23	1819571	2024-04-07T00:15:57.000Z	0x164a32a390a72c24210642a6ddc5eafdfc67c1d2c6eb5ed0d7d274f1a86be21c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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 Blast. Contains limit order book positions with tick price levels, order sizes, and trader balances for analyzing market depth and liquidity provision.

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_nonce	in_order	in_expiry	in_trader	log_index	block_number	block_timestamp	transaction_hash
0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	-81585	false	799	{“size”:“-169297589753714443212489”,“balance”:“33419822029903876569”}	4294967295	0x356c339ed07ebe8ba97cbc473c74cb13e88fcabd	48	6249477	2024-07-18T13:19:29.000Z	0xb40c4dd53cddae565f34ef2fec0474d43d83992e7abeeb13dc4d61aba24d5668
0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	-81545	false	409	{“size”:“-238534256479791161119911”,“balance”:“4572799999999999999”}	4294967295	0x356c339ed07ebe8ba97cbc473c74cb13e88fcabd	58	6248952	2024-07-18T13:01:59.000Z	0xa0a79ba4e16f62008627029b2d968aab28a3a9ecf5d19f931c57c0faf4f79552
0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	-81525	false	410	{“size”:“242277978777678476522148”,“balance”:“4653866666666666666”}	4294967295	0x356c339ed07ebe8ba97cbc473c74cb13e88fcabd	50	6248168	2024-07-18T12:35:51.000Z	0x8179e47d79b667c06c779c2f52827baffef5f5fbac7e3da19102fe827c0af61c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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 Blast, capturing when insurance fund balances are redistributed back into the system. Used for tracking protocol risk management and capital efficiency across different instrument contracts.

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
0x3bdd590514fcb7c2cfbd60f05416b7739989f9a0	false	0	4294967295	12	1575819	2024-04-01T08:50:53.000Z	0x28bace96ecd7b134ece40e2c216f623ab85c13ff86151d852c90e9b5fa63697c
0x5da9285ee39646c8408060c33d6ee105f2c807ca	false	6703011387262950	4294967295	17	1575581	2024-04-01T08:42:57.000Z	0xdcf18d1eed4ef2d2622722e473e734a71b81ec8fef70f0e998f16173d444c362
0x70c604e8e9beaf08ecf04c6161968a9dce491c91	false	0	4294967295	36	1275847	2024-03-25T10:11:49.000Z	0x1a82eefa85f4f98df4fb09b1196213703c664e5eeb00af13179a97f2f9b39647

Example Query

Query with partition filter

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

Instrument_Remove_event

Liquidity position removal events from SynFutures V3 perpetual futures protocol on Blast, tracking when traders close concentrated liquidity positions with tick ranges, fees, and position-in-curve (PIC) accounting data. Used for analyzing liquidity provider behavior and position management in the automated market maker.

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_fee	in_pic	address	removed	in_expiry	in_trader	log_index	in_operator	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
66555862155558	{“size”:“225315899071921768065”,“balance”:“3544438358636009”,“entryNotional”:“2532979379752442”,“entryFundingIndex”:“170663424336”,“entrySocialLossIndex”:“101467687989”}	0x5da9285ee39646c8408060c33d6ee105f2c807ca	false	4294967295	0x96a6269b5444d79d231b70794d5125259938faaa	4	0x96a6269b5444d79d231b70794d5125259938faaa	1295836	-115500	-111850	2024-03-25T21:18:07.000Z	0x98d3424655d7c8a3d18e28982bcd07282c8aa4fd51123a060bba176a15e88400
1595136463188748	{“size”:“-1480070554282068000385”,“balance”:“42721562153516135”,“entryNotional”:“15781520351329307”,“entryFundingIndex”:“1745097291699”,“entrySocialLossIndex”:“0”}	0x5da9285ee39646c8408060c33d6ee105f2c807ca	false	4294967295	0x52e05569d49d8fa5b25e750f744540680f95e9f8	47	0x52e05569d49d8fa5b25e750f744540680f95e9f8	1290061	-125650	-108100	2024-03-25T18:05:37.000Z	0x018f21e922171b35270c7276a596a56c7367116a632ae1672be0fa5744615166
67240336195411	{“size”:“-84754975338746821952”,“balance”:“98061244190809494”,“entryNotional”:“1006209413980798”,“entryFundingIndex”:“213297564442”,“entrySocialLossIndex”:“0”}	0x5da9285ee39646c8408060c33d6ee105f2c807ca	false	4294967295	0xf747b6fae88bb391d4ac25ee70096cc1a2785ae7	36	0xf747b6fae88bb391d4ac25ee70096cc1a2785ae7	1281076	-124550	-102550	2024-03-25T13:06:07.000Z	0xd66366f2f820013038a751633823d9f8e366c05c509a9f56ca17c6efd972490c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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 protocol on Blast, recording trader positions and settlement amounts at contract expiry. Used for tracking position closures, final balances, and settlement prices for expired 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
0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	false	1711699200	0xecb2b0f30f63eba68bf532c92e68d33541ac8abf	56	202184731383284567	0xecb2b0f30f63eba68bf532c92e68d33541ac8abf	2851351	282778125186210	2024-04-30T21:28:37.000Z	0x671ccd7dc8d22fb1c88651d648455faf2d2f112c2047d38184e6e3db4201044a
0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	false	1711699200	0x971df5505d4f442570ca9e05dc2dd1ecccfd7865	46	26419413497072488	0x971df5505d4f442570ca9e05dc2dd1ecccfd7865	2833189	282778125186210	2024-04-30T11:23:13.000Z	0x4be610fdc638d2b4cae950357263e7b0213db45411c367284618c98d2ed4b1b3
0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	false	1711699200	0x9debed472f9ed23e427e59b4eb4becb2b1eddfc6	48	101001462689466135	0x9debed472f9ed23e427e59b4eb4becb2b1eddfc6	2360587	282778125186210	2024-04-19T12:49:49.000Z	0xfc87f8bcf7e3ce3955edd71663c0fb6e1f1d18907c04e71ac11a7b6cf9012dd4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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 contracts on Blast, capturing position adjustments with entry price, size changes, and mark price data. Used for analyzing position management, liquidations, and trader 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
0x0660a2b1a94cf13045b7a96bcb73e1620d775377	56554695708658	1391945925942630804738	false	4294967295	0x1754939802190d39a223049a3bf036903c3347b2	9	50	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	608429202551533661231100796	989920	2024-03-18T19:20:55.000Z	81274645307822636	0x886fbcff78f9c2c7ecabc8716c8c9f0f1700b0dad9087a66ce9bf28438e56932
0x0660a2b1a94cf13045b7a96bcb73e1620d775377	57420488564527	-195087528140640419514	false	4294967295	0x47af85b3402ad74325f277d2bdd14a36f5dc7114	15	50	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	666114373074852619768932147	985390	2024-03-18T16:49:55.000Z	13809627081806892	0xcfec1f232295694d138fba40995e2d3a79abd2899d37c2a427776248b7f91c45
0x0660a2b1a94cf13045b7a96bcb73e1620d775377	57465044491880	-150565165911937488057	false	4294967295	0x3ef418118d1decf42226580305fd4f5ccadccfa6	23	50	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	691866328075312754751947845	985381	2024-03-18T16:49:37.000Z	11494613010184791	0xaf235249b767a97b3cbd467816f771311e0e47b8050cc6aa69aeb068ffb47510

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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 Blast. Captures position changes with fill prices (sqrtPX96), sizes, entry notional values, and mark prices for analyzing trading activity and position management.

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	in_takenSize	in_takenValue	block_timestamp	in_entryNotional	transaction_hash
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	28977453717530544720	915219279447294	false	0	4294967295	0x1bfda4d1bd8a28cab70f53d30ba7fa2a10d2c221	9	1	426525735746445302876853775310	11433959	0	0	2024-11-15T13:35:33.000Z	26521749488395460	0x7b17aaa197823aa1e19f49ed303234a2698f119e32e264844b1f6926941fe8e2
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	29568753363023744396	4065948440251061	false	3993799132710357	4294967295	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	19	1	430204210569919230414437584267	11442485	-3973245042928663	117145173321231623	2024-11-15T18:19:45.000Z	119878428927504244	0xe2d7f01d5e497a8d1b0b8d0543668561554338e1263b0f513631cad8ae3ba5b6
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	29568753363023744396	3929699951005332	false	3859960803782341	4294967295	0xe19af541e9e452dfa4a1d7823db4e85bc787a2ad	5	1	430198714444494438166515897872	11442485	-1026754957071337	30272330577400797	2024-11-15T18:19:45.000Z	115827084534346561	0x7666276b8f38ac4537b48d16b0f7933f5093732284e43a6502b1d5c802a51e4b

Example Query

Query with partition filter

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

Instrument_UpdateAmmStatus_event

Automated Market Maker (AMM) status update events from SynFutures v3 perpetual contracts on Blast, recording changes to pricing state including sqrt price (sqrtPX96), mark price, and market status for each instrument. Used for tracking AMM configuration changes and perpetual market state transitions.

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
0x99c1ca21a54d5d8d7e2ad52e0b3f7bd2326a92b4	8358635190056	false	4294967295	3	0	229058951924977968711390831	5424111	2024-06-29T10:47:17.000Z	0xf9a0e32fc0c8484f851bff762725892a5628cdc828ca5ea8982a80f471056f5e
0xd9c076eae3a2d721626f61f5bf0c8d003cb745b8	207251694217809178	false	4294967295	3	22	36068545430006457436543677947	5424047	2024-06-29T10:45:09.000Z	0x3fdb96313a68a8e692e6248c0d7b13b04945d8d0c3562198c6160227e1daf984
0xd973506bf52c2cfa89f92deb75f2d85b139e35fa	75753372774011129411646	false	4294967295	3	3	21806229103197540132611053280296	5424356	2024-06-29T10:55:27.000Z	0xe2bdd478ac1c6fa00ba0cb081cc9f0da7686ee0de816cbc0318d9b9a27010498

Example Query

Query with partition filter

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

Instrument_UpdateCondition_event

Trading instrument condition state changes from SynFutures v3 perpetual protocol on Blast. Tracks status updates (0=initialized, 1=active, 2=settled) for derivative contracts with timestamps for monitoring instrument lifecycle.

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`	Numeric status code indicating the current condition state of the SynFutures instrument at the time of the update event. Common values include 0, 1, and 2, representing different instrument trading or settlement states.

Sample Data

address	removed	log_index	block_number	in_timestamp	block_timestamp	transaction_hash
0xfc37d560b7102ad725193cf1220690740d2601cf	false	38	1576385	1711962585	2024-04-01T09:09:45.000Z	0xee375bb73d5ddc14cc77bf21f5ffd7d5ba3e6663d7e3fbd1889af205017b1235
0x5da9285ee39646c8408060c33d6ee105f2c807ca	false	21	1575581	1711960977	2024-04-01T08:42:57.000Z	0xdcf18d1eed4ef2d2622722e473e734a71b81ec8fef70f0e998f16173d444c362
0x3bdd590514fcb7c2cfbd60f05416b7739989f9a0	false	16	1575819	1711961453	2024-04-01T08:50:53.000Z	0x28bace96ecd7b134ece40e2c216f623ab85c13ff86151d852c90e9b5fa63697c

Example Query

Query with partition filter

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

Instrument_UpdateFeeState_event

Fee state updates for perpetual futures instruments on SynFutures V3 deployed on Blast. Tracks protocol fee accumulation and fee index changes per instrument contract for fee distribution 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_expiry`	`STRING`	Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds.
`in_feeIndex`	`STRING`	Cumulative fee index value for this SynFutures V3 instrument at the time of the update. This scaled integer tracks fee accrual over time and increases with each fee state update.
`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
0xb0ceff252f18710a3315e735b5e26481840ad286	false	4294967295	33	22639146514725	10037374	28606058262968790	2024-10-14T05:42:43.000Z	0x7d29666dd630f2c76bc6e60663d1790fa181d9cc720a3fbd649024772095f131
0x5430561b09c627264549fdb3a6154c34f5cabea7	false	4294967295	10	2334982739038320019	10027172	12082504326205073439556	2024-10-14T00:02:39.000Z	0x15b4277dfdaff792d5a59ad981bc5e75362c232435c9c896b51c89c08a20dfe6
0x5430561b09c627264549fdb3a6154c34f5cabea7	false	4294967295	15	2334982739038320019	10027172	12096524326205073439547	2024-10-14T00:02:39.000Z	0x15b4277dfdaff792d5a59ad981bc5e75362c232435c9c896b51c89c08a20dfe6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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 Blast, capturing periodic adjustments to the cumulative funding index for each instrument. Used for calculating funding payments between long and short positions 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
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	1	9968843	2024-10-12T15:38:21.000Z	115792089237316195421391125642290520537301359722097913555257716127974460503401	0xcfca04af790d81616641fc08a15f83de4f96f9bdc0e0a78fabc26c719af8011f
0x645fc6477c29f430362bfa40d5b7701a6e5923be	false	1	9979526	2024-10-12T21:34:27.000Z	115792089237316195423556261271210999443627584350139714353678986066669375277982	0x2074f9c4ef78d725d5c358ae552f3f487f2be30d36104421ec95c99983bf18c2
0x645fc6477c29f430362bfa40d5b7701a6e5923be	false	1	9951646	2024-10-12T06:05:07.000Z	115792089237316195423556261271210999443627584350139714353678986066669375277982	0x1f5fedf1fdea632e57117d3551adfc005a23cfed2b6785459887a4cdc4b0e092

Example Query

Query with partition filter

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

Instrument_UpdateMarginRatio_event

Margin requirement update events from SynFutures V3 perpetual contracts on Blast, recording changes to initial and maintenance margin ratios for trading instruments. Used for tracking risk parameter adjustments and analyzing leverage requirements across different 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_initialMarginRatio`	`STRING`	Initial margin requirement for opening positions, expressed in basis points where 1000 equals 10% collateral. This parameter determines the minimum collateral ratio traders must maintain when establishing new perpetual futures positions on the SynFutures protocol.
`in_maintenanceMarginRatio`	`STRING`	Maintenance margin ratio threshold for the trading instrument, below which positions face liquidation. Expressed in basis points where 500 represents 5% and 50 represents 0.5%.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_initialMarginRatio	in_maintenanceMarginRatio
0x298417f3a0a54bc6eac013a9be00757b4d2f03ca	false	1	3398667	2024-05-13T13:32:29.000Z	0x75a0e0ac2ca7d5fcfa862561086f7c1fd75a98cacaece5fa49a8e5cb8502f9cb	1000	500
0x298417f3a0a54bc6eac013a9be00757b4d2f03ca	false	4	3397661	2024-05-13T12:58:57.000Z	0x893435058a901986ce19dbc048059acbed9159b5b7d18beb194fbca70634094d	1000	500
0xd9c076eae3a2d721626f61f5bf0c8d003cb745b8	false	7	3398656	2024-05-13T13:32:07.000Z	0x05f6c513f45daa8a86d1088168f6a7ce4a0dd7d9ddacbf33dc39cbf2ac5c3731	1000	500

Example Query

Query with partition filter

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

Instrument_UpdateParam_event

Parameter configuration updates for trading instruments on SynFutures V3 perpetual futures protocol on Blast. Records changes to fee structures, margin requirements, and quote types for analyzing protocol governance and risk parameter evolution.

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
0x4fde5557d54ed955c7e3da40f2c7900cde5eefe0	false	{“tip”:“100000000000000”,“qtype”:2,“minMarginAmount”:“2000000000000000”,“tradingFeeRatio”:“30”,“protocolFeeRatio”:“20”,“stabilityFeeRatioParam”:“1370113808827263642”}	4	754579	2024-03-13T08:36:13.000Z	0xa172cd412993cddc625d03c4b00b1ce711c45369f795f39b5db646b40bfa7394
0x4fde5557d54ed955c7e3da40f2c7900cde5eefe0	false	{“tip”:“100000000000000”,“qtype”:2,“minMarginAmount”:“2000000000000000”,“tradingFeeRatio”:“50”,“protocolFeeRatio”:“50”,“stabilityFeeRatioParam”:“1370113808827263642”}	0	754753	2024-03-13T08:42:01.000Z	0x9185f27504efc7d280c786dbe4c54c91819649cd164961c77f481ff3edab8b3f
0xfc37d560b7102ad725193cf1220690740d2601cf	false	{“tip”:“10000000000000”,“qtype”:2,“minMarginAmount”:“500000000000000”,“tradingFeeRatio”:“3”,“protocolFeeRatio”:“1”,“stabilityFeeRatioParam”:“14415916854096691200”}	0	8055483	2024-08-29T08:39:41.000Z	0x7cd9e8fdda21e0cdac46b44afbb23813e8374bdf6fc79d36b900749c38f3cf24

Example Query

Query with partition filter

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

Instrument_UpdatePosition_event

Position update events from SynFutures V3 perpetual trading instruments on Blast, tracking trader position changes including size, balance, entry notional, and funding/social loss indices. Used for analyzing trader positions, leverage, and PnL calculations across perpetual futures contracts.

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”:“-3452003501642356728457”,“balance”:“1033822643832305989”,“entryNotional”:“1100146953242017603”,“entryFundingIndex”:“-1479382417151683”,“entrySocialLossIndex”:“1002164116294461139”}	0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	false	4294967295	0xc3ed31c47f70ee8b0b2d319fdd058357df379976	28	14001822	2025-01-14T00:10:59.000Z	0xacf84d2639a49896637083bb6ae544abedda97a1a6fbfa06f2ce8b561f7e4e9b
{“size”:“-16659350863134844597426”,“balance”:“757537960000000000”,“entryNotional”:“5310200000000000000”,“entryFundingIndex”:“-1479382417151683”,“entrySocialLossIndex”:“1002164116294461139”}	0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	false	4294967295	0x8236c37573ed590c09280b54f4a8c6f39d4688d2	33	14001822	2025-01-14T00:10:59.000Z	0xacf84d2639a49896637083bb6ae544abedda97a1a6fbfa06f2ce8b561f7e4e9b
{“size”:“-15004798038182551266446”,“balance”:“684068520000000000”,“entryNotional”:“4785200000000000000”,“entryFundingIndex”:“-1479383704521115”,“entrySocialLossIndex”:“1002164116294461139”}	0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8	false	4294967295	0x01f0349e4b9f783897286c43c58a89b7c13e6576	28	14001901	2025-01-14T00:13:37.000Z	0x18fe86cae4354ac3f23ef04bd4798e2a3d2ba14f811377673a1868ee214521a7

Example Query

Query with partition filter

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

Instrument_UpdateSocialLossInsuranceFund_event

Insurance fund balance updates for SynFutures V3 perpetual contracts on Blast, tracking socialized loss distribution across long and short positions. Used for analyzing protocol solvency and trader liquidation risk exposure.

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`	Accumulated loss index for long positions in this perpetual instrument, representing socialized losses distributed among long position holders. Remains at zero when no social loss events have occurred for long positions.
`in_shortSocialLossIndex`	`STRING`	Cumulative index tracking socialized losses distributed to short position holders for this instrument. Remains at zero when no short-side losses have been socialized across the market.
`in_insuranceFund`	`STRING`	Current balance of the insurance fund for this instrument, denominated in the base token’s smallest unit. Updated when the fund absorbs losses or receives contributions from liquidations.

Sample Data

address	removed	in_expiry	log_index	block_number	block_timestamp	in_insuranceFund	transaction_hash
0x0c116455bc6c58402c82048a0e3edaa1b6ddf0db	false	4294967295	40	2121877	2024-04-14T00:12:49.000Z	9022467026728894	0x02ef9345c624d7eb55017ec27d39b44c4eaf7ce8dd3324e8a03471bc6ad45789
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	4294967295	83	2122567	2024-04-14T00:35:49.000Z	89682942740962161	0x5cad002d2a6bfc3635ad3e1a6d4b50869539fbb1a24073aa87f1aba2647dc57a
0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8	false	4294967295	81	2122567	2024-04-14T00:35:49.000Z	88801440831301899	0x5cad002d2a6bfc3635ad3e1a6d4b50869539fbb1a24073aa87f1aba2647dc57a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.synfutures_v3_blast.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_blast.Instrument_Upgraded_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

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