> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# synfutures_v3_base
> Tables in tt-contracts.synfutures_v3_base
## Tables
### Config\_SetMarketInfo\_event
Configuration events tracking market deployments on SynFutures V3 perpetual protocol on Base, recording market type assignments (PYTH oracle, LINK oracle, DEX V2, emergency) and associated beacon contracts for each market address.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_mtype` | `STRING` | Market type identifier indicating the price oracle or data feed mechanism used by this market. Common values include PYTH (Pyth Network), LINK (Chainlink), EMG (emergency mode), and DEXV2 (DEX v2 oracle). |
| `in_market` | `STRING` | Trading pair or market identifier specifying the assets being traded or operated on. |
| `in_beacon` | `STRING` | Contract address of the beacon proxy implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_mtype | in\_beacon | in\_market | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb63902d38738e353f3f52add203c418a0bfea172 | false | PYTH | 0x9674e2f58485b987d7d537a059fb002ae1d44959 | 0xba2593a538df42f4673a5c72a444d70d6b91f3d9 | 3 | 16297492 | 2024-06-26T06:45:31.000Z | 0xfd8474224006b8078de0b171290127bd83d8320e80a3e925ff05c74b30d67a40 |
| 0xb63902d38738e353f3f52add203c418a0bfea172 | false | LINK | 0x9674e2f58485b987d7d537a059fb002ae1d44959 | 0x6926cc6875d3721c13325d301b4170a57f2c0b18 | 11 | 16297482 | 2024-06-26T06:45:11.000Z | 0x8dfc2cfd9e0a4644aeda1801b59d0c27b82f8f751738cf33baef2cb86a6bbe1a |
| 0xb63902d38738e353f3f52add203c418a0bfea172 | false | EMG | 0x9674e2f58485b987d7d537a059fb002ae1d44959 | 0x8f76920d741a6e2d324c9cc8878cd5a9371e81cd | 8 | 16297487 | 2024-06-26T06:45:21.000Z | 0x8c5e6742b267830f1eec15498c0c7ad7f0011e4ff777db253bbc4da6257e5b90 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Config_SetMarketInfo_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Config\_SetQuoteParam\_event
Configuration update events from SynFutures v3 perpetual protocol on Base, recording parameter changes for quote tokens including trading fees, protocol fees, minimum margin requirements, and stability fee ratios. Used for tracking risk management and fee structure modifications across different quote token types.
| 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` | 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. |
| address | removed | in\_param | in\_quote | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb63902d38738e353f3f52add203c418a0bfea172 | false | \{"tip":"500000000000000000","qtype":2,"minMarginAmount":"25000000000000000000","tradingFeeRatio":"1","protocolFeeRatio":"2","stabilityFeeRatioParam":"14415916854096691200"} | 0x3ee5e23eee121094f1cfc0ccc79d6c809ebd22e5 | 82 | 21354510 | 2024-10-21T08:12:47.000Z | 0xd7581b5281d889402c4309daee353d2ece5b16d948c09fbf21216ff39a87af0f |
| 0xb63902d38738e353f3f52add203c418a0bfea172 | false | \{"tip":"500000000000000000","qtype":2,"minMarginAmount":"100000000000000000000","tradingFeeRatio":"6","protocolFeeRatio":"1","stabilityFeeRatioParam":"14415916854096691200"} | 0xa88594d404727625a9437c3f886c7643872296ae | 133 | 24507971 | 2025-01-02T08:08:09.000Z | 0x62529b9c65f0781c0772bf739034b1d8afee87591e71c52988a77f69208ee458 |
| 0xb63902d38738e353f3f52add203c418a0bfea172 | false | \{"tip":"10000000000000","qtype":2,"minMarginAmount":"2000000000000000","tradingFeeRatio":"1","protocolFeeRatio":"2","stabilityFeeRatioParam":"14415916854096691200"} | 0x04c0599ae5a44757c0af6f9ec3b93da8976c150a | 54 | 17213659 | 2024-07-17T11:44:25.000Z | 0x512cd3b312d2fa2e02070ea3b75711a9fead93db82608083132c1ef4b6a0d8f7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Config_SetQuoteParam_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_Blacklist\_event
Trader blacklist status changes from SynFutures V3 perpetual futures protocol on Base. Records when addresses are added to or removed from the trading blacklist for compliance and risk management analysis.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_banned` | `BOOL` | Indicates whether the trader address was added to (`true`) or removed from (`false`) the blacklist in this event. This boolean flag represents the ban status being applied to the trader at the time of the transaction. |
| address | removed | in\_banned | in\_trader | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | true | 0x9727bf2a8470d24b052377a779b15c50a2e99624 | 4 | 16297478 | 2024-06-26T06:45:03.000Z | 0x49dc299dede195c827bf041b967337e4060512e373cd86c40b0f48dde28f96e5 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | true | 0x556ef67910ad3f1b122e0891a6b153387143bb46 | 333 | 25373978 | 2025-01-22T09:15:03.000Z | 0x9b4ec47a2a2559943cf203ee4099b54d7b7c701a4c3fb9375dbec154395a77bf |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | false | 0x556ef67910ad3f1b122e0891a6b153387143bb46 | 72 | 25379605 | 2025-01-22T12:22:37.000Z | 0x4179e9397de7b2f12d67895ac805359507e95165722588a3434f00f4277ce83e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_Blacklist_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_Deposit\_event
Collateral deposit events from SynFutures V3 decentralized perpetual futures protocol on Base. Records trader deposits with token amounts and quote asset addresses for tracking margin positions and protocol liquidity flows.
| 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. |
| address | removed | in\_quote | in\_trader | log\_index | in\_quantity | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x1d6b1d2ad091bec4aae6a131c92008701531fdaf | 0xcc879ab4de63fc7be6aaca522285d6f5d816278e | 418 | 100000000000000000 | 17144095 | 2024-07-15T21:05:37.000Z | 0xd73b41b8f65905402c54c210de668bade24d421062664b64b6f9acc383c4ade5 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x4ed4e862860bed51a9570b96d89af5e1b0efefed | 0x120b0ab071ea6cd2dab788bc01912a72612a9b4c | 247 | 200000000000000000000 | 17139930 | 2024-07-15T18:46:47.000Z | 0xd097aefa1f859624c27cd8761fca7be294afc13059aaeabc54eb9f833b871962 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 0x28874dda655ba378de7d75b10236f950e3180140 | 1 | 40129154 | 17132989 | 2024-07-15T14:55:25.000Z | 0x3d82ce40e25ec7a3f41ae25ef2ccb32ae0a8095b954105f11c36c20c06ccb5aa |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_Gather\_event
Collateral withdrawal events from SynFutures v3 perpetual futures protocol on Base, recording when traders remove quote tokens from specific instruments. Used for tracking capital flows, margin management patterns, and liquidity extraction across derivative markets.
| 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. |
| address | removed | in\_quote | in\_expiry | in\_trader | log\_index | in\_quantity | block\_number | in\_instrument | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ---------- | ------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 4294967295 | 0x0000fff49d8da8c443921a56a3fffde01c822a0d | 222 | 24066981 | 26176450 | 0x04d72fb4803b4e02f14971e5bd092375eb330749 | 2025-02-09T23:04:07.000Z | 0x7834d1f978f18da57837ba9f17d1407239fc4ebf11a68845c53ab63984d31c2d |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 4294967295 | 0x000c3d78c4d5d5eeaf95b2547ad8dcd7d269566f | 300 | 21197999 | 26168720 | 0x04d72fb4803b4e02f14971e5bd092375eb330749 | 2025-02-09T18:46:27.000Z | 0x564e635747841481822203363517c9d0c7327097166979d1ddefd283ea14744f |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 4294967295 | 0x000cccae9cf0d50ddc7990051c4fc7d4253000ed | 350 | 20281764 | 26157214 | 0x04d72fb4803b4e02f14971e5bd092375eb330749 | 2025-02-09T12:22:55.000Z | 0x5c54e471974969809c7959264b054d5bbb77b233ecd51ce1bf6a530122e9aa85 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_Gather_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_Initialized\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_NewInstrument\_event
New trading instrument creation events from SynFutures v3 perpetual futures protocol on Base. Captures market listings with instrument addresses, base/quote token pairs, symbols, and sequential instrument counts for tracking protocol growth.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| `in_instrument` | `STRING` | Contract address of the derivative instrument or trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_base` | `STRING` | Token or asset identifier serving as the base asset in a trading pair or financial instrument. String representation that can be either a contract address (hex-encoded, 0x-prefixed, 42-character string) or a ticker symbol. |
| `in_quote` | `STRING` | Contract address of the quote token used for pricing and settlement. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_symbol` | `STRING` | Symbol of the token involved in the transaction or event. |
| `in_total` | `STRING` | Total count of instruments registered in the Gate contract at the time this new instrument was created. Increments sequentially with each NewInstrument event emission. |
| address | in\_base | removed | in\_index | in\_quote | in\_total | in\_symbol | log\_index | block\_number | in\_instrument | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------------------------------ | ------------------------------------------ | --------- | --------------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | 0x0000000000000000000000000000000000000000 | false | 0x95e03fdc26c31c1ae292aab82906dd929215968c1ef7f9580b525b47f281a34a | 0xe4b20925d9e9a62f1e492e15a81dc0de62804dd4 | 53 | JPY-BtcUSD-EMG | 411 | 23823789 | 0x0a210cadebd32157299b60aa18800ff580887980 | 2024-12-17T12:02:05.000Z | 0x72dfe57109b03b15928c5ed0fd439195f284c5f94f67344e080c96533c7c66e4 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | 0x0000000000000000000000000000000000000000 | false | 0x586710022902854e8f41d2331a214aa5b9890a12d02bd4e634cb38bcbae485fb | 0x2eac9b08a4d86f347b9e856fb3ec082e61c76545 | 52 | USDC-AIRENE-EMG | 28 | 23822781 | 0x9e74aa8311e50fe258f8364e4fe593293a4fa639 | 2024-12-17T11:28:29.000Z | 0x3d995114a15dfa590146d2244c073d174853a9267e26a07c8888f91d21016a76 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | 0x0000000000000000000000000000000000000000 | false | 0xfb773d6015e106f25586e5855bfb138587e2ce886ac2600077d42fe3889c5d25 | 0x74aa9bb52b36a378a6e641b86d7acb76dc9b3940 | 51 | USDC-TRVL-EMG | 24 | 23822738 | 0x32bdb0d18d6cc94d282e1c92e7423007e9a51425 | 2024-12-17T11:27:03.000Z | 0x0efa3712252d81e5a4fd514cf5031e778004f2762de3b12da49f893789b0ce2e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_NewInstrument_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_Scatter\_event
Scatter events from SynFutures V3 perpetual futures protocol on Base, recording trader position dispersals across instruments with quantities and expiry timestamps. Used for analyzing position management patterns and instrument-level trading activity.
| 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. |
| address | removed | in\_quote | in\_expiry | in\_trader | log\_index | in\_quantity | block\_number | in\_instrument | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ---------- | ------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 4294967295 | 0xb38d9719f6561d5338d050247f9dffa2792975bc | 1 | 28376026 | 18396048 | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | 2024-08-13T20:37:23.000Z | 0x0e41ddedbe93a08854bf6a63dbb653b48c3913b187c90e4b375d5fdb4029f231 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 4294967295 | 0xd6ba8e0957b29177d230bc1e4e2982a3f8a8080c | 1 | 28517437566 | 18377297 | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | 2024-08-13T10:12:21.000Z | 0x1670c66781b52040a92cbc2aba09928cb1a4e08db4776403395ed1a3d42de73d |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 4294967295 | 0x8d10b5acd7a68e05a48e8611b04451bf3c818c87 | 1 | 29487384 | 18387547 | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | 2024-08-13T15:54:01.000Z | 0xebbdf0e3d1b8beac87788fd48f1d6382dbf0d8b7c6f34cc36c05b376495556b2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_Scatter_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_SetPendingDuration\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_SetPendingDuration_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_SetThreshold\_event
Gate configuration events from SynFutures v3 protocol on Base recording threshold parameter updates for different quote tokens. Tracks minimum trading thresholds per collateral token for analyzing protocol risk parameters and market access requirements.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_quote` | `STRING` | Contract address of the quote token used for pricing and settlement. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_threshold` | `STRING` | Minimum threshold amount required for gate operations denominated in the specified quote token. Values are represented as integers in the token's smallest unit (wei for 18-decimal tokens). |
| address | removed | in\_quote | log\_index | block\_number | in\_threshold | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x3ee5e23eee121094f1cfc0ccc79d6c809ebd22e5 | 58 | 21354516 | 2000000000000000000000000 | 2024-10-21T08:12:59.000Z | 0xaf06d41d00a925d6cca3f19a1c61d28752ce1b3e187c61d8519a1ebcf90e88a1 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0xdcefd8c8fcc492630b943abcab3429f12ea9fea2 | 31 | 20233637 | 20000000000000 | 2024-09-25T09:30:21.000Z | 0x6f32fae541e92a6d6f41fa6e683277501482e28cd4eecd452ca59721fe55872f |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 41 | 20246493 | 10000000000 | 2024-09-25T16:38:53.000Z | 0xe0f187bc824ad4d80571a7fcf1e6d27fb455a83f6c3c0c591689218c749f513a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_SetThreshold_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_UpdatePending\_event
Pending balance updates for trader accounts in SynFutures v3 perpetual futures protocol on Base, tracking deposit amounts, exemptions, and timestamps before settlement. Used for monitoring collateral state changes and withdrawal processing in the protocol's gate contract.
| 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` | 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. |
| address | removed | in\_quote | in\_trader | log\_index | in\_pending | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------------------------------------------------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x4200000000000000000000000000000000000006 | 0xbe0f37274adadb32441acdb74791de159b0bd87e | 34 | \{"amount":"20830412029706198397","native":false,"exemption":"0","timestamp":"1728015885"} | 20613269 | 2024-10-04T04:24:45.000Z | 0xd399232dad0051abde8e675546afe2292bcf3bf956756f008f3a6ef1a2a15c87 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x4200000000000000000000000000000000000006 | 0xbe0f37274adadb32441acdb74791de159b0bd87e | 37 | \{"amount":"0","native":false,"exemption":"23770097813842246880","timestamp":"0"} | 20613269 | 2024-10-04T04:24:45.000Z | 0xd399232dad0051abde8e675546afe2292bcf3bf956756f008f3a6ef1a2a15c87 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 0xbe0f37274adadb32441acdb74791de159b0bd87e | 33 | \{"amount":"0","native":false,"exemption":"1581906687093","timestamp":"0"} | 20613269 | 2024-10-04T04:24:45.000Z | 0xd399232dad0051abde8e675546afe2292bcf3bf956756f008f3a6ef1a2a15c87 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_UpdatePending_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gate\_Withdraw\_event
Withdrawal events from SynFutures V3 protocol gate contract on Base, recording when traders remove quote token collateral from their accounts. Useful for tracking capital flows and margin management patterns across different collateral types.
| 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. |
| address | removed | in\_quote | in\_trader | log\_index | in\_quantity | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ----------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x1d6b1d2ad091bec4aae6a131c92008701531fdaf | 0x959a90a6b88d19184ac7c46dfe43ff2968b12bd2 | 45 | 48003301540443719 | 17594094 | 2024-07-26T07:05:35.000Z | 0x505647d2dfe54e51a6f7d6d4dca644054b6b1b0789b13a3f7a7c5fb16e3d3db2 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x1d6b1d2ad091bec4aae6a131c92008701531fdaf | 0xf9663d97dbcb0268136f2154adcf3f81816c5a89 | 159 | 37027718300145767 | 17609413 | 2024-07-26T15:36:13.000Z | 0xd1627f1bd15e22c27bdc7fd8041160e8ccebb80e8a21f81a6649849e4a347ec8 |
| 0x208b443983d8bcc8578e9d86db23fba547071270 | false | 0x1d6b1d2ad091bec4aae6a131c92008701531fdaf | 0x883ff97b55a08513d8399b4b22536db80cc18133 | 270 | 24310000000000042 | 17602521 | 2024-07-26T11:46:29.000Z | 0x590a59f2b8a398c90e82add11cea0f9e87c1e7fa40b86bbc9e373231998bc381 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Gate_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Add\_event
Liquidity position additions on SynFutures V3 perpetual futures protocol on Base, recording trader addresses, tick ranges, balance amounts, and entry prices. Used for tracking concentrated liquidity provisioning activity and analyzing market maker position sizing across price ranges.
| 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` | Position state data when liquidity is added within a bounded tick range. Contains balance amount, active liquidity, accumulated fee index, and square root price at entry for concentrated liquidity positions. |
| address | removed | in\_range | in\_expiry | in\_trader | log\_index | block\_number | in\_tickLower | in\_tickUpper | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | \{"balance":"20000000000000000000","liquidity":"6052976099197553804","entryFeeIndex":"294305624768396498","sqrtEntryPX96":"4406475513829317954358661228664"} | 4294967295 | 0x0fb29cc2d5e9fb5271bdf849c6599167022660d7 | 160 | 22533690 | 76300 | 84450 | 2024-11-17T15:18:47.000Z | 0xcbb3dc43cd296a8dc5f251a820475112dba1e03145bf08ca58fc85bbd22ca2ca |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | \{"balance":"150000000000000000000","liquidity":"7304026890572955394","entryFeeIndex":"291693154024836934","sqrtEntryPX96":"4439725096264764151548080721938"} | 4294967295 | 0x301448fae7a6bca843c485a441cb5e7755138ccc | 396 | 22523677 | 71350 | 89700 | 2024-11-17T09:45:01.000Z | 0xd6ab370089dfa1cb680c21859cb6dbdba3be8ddaf7f315c349ca5cec67a0fbaf |
| 0x05fe3b944e9307ddd285ff0024dc073e81984d68 | false | \{"balance":"400000000000000000000000","liquidity":"511919435380306207655","entryFeeIndex":"16609302575178819836","sqrtEntryPX96":"34145241892230818289071249841603"} | 4294967295 | 0x4243b77e0f91f7f4b86092189d5c47c0e85de89c | 391 | 22506366 | 105200 | 137450 | 2024-11-17T00:07:59.000Z | 0xe7aa5ac2472ddaf5e8cf2186e286caaafbfc36518e935eb456194f9e5eb2a561 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Add_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Adjust\_event
Position adjustment events from SynFutures V3 perpetual contracts on Base, recording net position changes for traders. Used to track position size modifications, margin adjustments, and trader activity in perpetual futures markets.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_expiry` | `STRING` | Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds. |
| `in_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_net` | `STRING` | Net position change for the trader's instrument, denominated in the smallest unit of the contract. Can be positive (long) or negative (short), representing the size adjustment in wei-equivalent precision. |
| in\_net | address | removed | in\_expiry | in\_trader | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 1075665000000000000 | 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 4294967295 | 0x75d5dbb9fff7df8c3b2b974eb89a825f25046dbb | 43 | 19655582 | 2024-09-12T00:21:51.000Z | 0x1f9a9cbf3da3a56c763ad79e824d2d47b4101d8f81a9f1f85ddd31a7e0ba48ec |
| -14522590430504450000000 | 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 4294967295 | 0xaf96de66b93c3448d4a5b55d9cc89456f301c5b9 | 162 | 19655665 | 2024-09-12T00:24:37.000Z | 0xc088a705d0acd593b1fc74f155eb6e4706f235f17461e9c543293453945a060f |
| -1481211893382017 | 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 4294967295 | 0x75d5dbb9fff7df8c3b2b974eb89a825f25046dbb | 144 | 19655672 | 2024-09-12T00:24:51.000Z | 0x3a53683e165b8fd5abade0d24ca0ce11772fed235410d56c1ac96de0d355b307 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Adjust_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_AdminChanged\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_AdminChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Cancel\_event
Order cancellation events from SynFutures v3 perpetual futures protocol on Base, recording cancelled limit orders with trader address, price tick, nonce, and position-in-contract (PIC) state at cancellation time. Used for analyzing order book dynamics and trader behavior patterns.
| 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` | 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\_fee | in\_pic | address | in\_tick | removed | in\_nonce | in\_expiry | in\_trader | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------- | -------------------------------------------------------------------------------------------------- | ------------------------------------------ | -------- | ------- | --------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0 | \{"size":"0","balance":"0","entryNotional":"0","entryFundingIndex":"0","entrySocialLossIndex":"0"} | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | 110385 | false | 0 | 4294967295 | 0x110deb03196a82174ca2edf4224898ed45f110af | 30 | 16498516 | 2024-06-30T22:26:19.000Z | 0x7c48b1e2bd7ccdc8b22b913ecbc9ec161602f49dad9ebbe8fbb42cda7c2c9260 |
| 0 | \{"size":"0","balance":"0","entryNotional":"0","entryFundingIndex":"0","entrySocialLossIndex":"0"} | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | 110130 | false | 0 | 4294967295 | 0x110deb03196a82174ca2edf4224898ed45f110af | 6 | 16471005 | 2024-06-30T07:09:17.000Z | 0xe7b1abef07a44dc073784d5e44fa02049c830874b0a66201ee2be11fc2459869 |
| 0 | \{"size":"0","balance":"0","entryNotional":"0","entryFundingIndex":"0","entrySocialLossIndex":"0"} | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | 110130 | false | 0 | 4294967295 | 0x110deb03196a82174ca2edf4224898ed45f110af | 60 | 16470916 | 2024-06-30T07:06:19.000Z | 0xd47738da8551f4034ee87768994dc126de98631885ddf73b46e2440d3b406e75 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Cancel_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_ClaimProtocolFee\_event
Protocol fee collection events from SynFutures V3 perpetual futures instruments on Base. Records fee claims by instrument address with claimed amounts and expiry timestamps for tracking protocol revenue distribution.
| 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. |
| address | removed | in\_amount | in\_expiry | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xdd53d6fc4b4a97a921d65fe81deccb78f2210891 | false | 0 | 4294967295 | 120 | 19713824 | 2024-09-13T08:43:15.000Z | 0xb2a8764005135875007552064436c02b661613876840ae5105b7f192bdbf6a65 |
| 0x1167525986013bbf615f68b74db6b76490d1c8b4 | false | 0 | 4294967295 | 146 | 19713824 | 2024-09-13T08:43:15.000Z | 0xb2a8764005135875007552064436c02b661613876840ae5105b7f192bdbf6a65 |
| 0xe8427e0ba60252d05e74a718d167e2530e3afb8b | false | 103750566277501 | 4294967295 | 141 | 19713824 | 2024-09-13T08:43:15.000Z | 0xb2a8764005135875007552064436c02b661613876840ae5105b7f192bdbf6a65 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_ClaimProtocolFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_DeleteContext\_event
Instrument deletion events from SynFutures V3 perpetual futures protocol on Base, recording when trading instruments are removed with expiry timestamps (4294967295 indicates perpetual contracts). Used for tracking instrument lifecycle and market availability changes.
| 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. |
| address | removed | in\_expiry | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x7c83c8121b4d7774bf3a95b3dc8a4f89c9394ded | false | 4294967295 | 180 | 24983569 | 2025-01-13T08:21:25.000Z | 0xb678277bdb4a9935dfa49680cd2b4a0a517ce612b4349b45a3e9d6a2be10e5e3 |
| 0x1120a835f81236d49c5823e3fe8477831f397217 | false | 4294967295 | 146 | 24983849 | 2025-01-13T08:30:45.000Z | 0xc8b3983c8d34cf833ebe0ffd82b3e1df164f8d20d44a5d070c20238ad016496c |
| 0xe8427e0ba60252d05e74a718d167e2530e3afb8b | false | 4294967295 | 378 | 25329712 | 2025-01-21T08:39:31.000Z | 0x1e8a419726609edca24f08ead38b63993a21d77eeb932f88cb1914a6a998c494 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_DeleteContext_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_DonateInsuranceFund\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_DonateInsuranceFund_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Fill\_event
Order fill events from SynFutures V3 perpetual futures protocol on Base, capturing executed trades with position details (size, balance, entry notional), tick prices, fees, and funding indices for analyzing trading activity and position changes.
| 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` | 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. |
| 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 |
| -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------- | ------------------------------------------ | -------- | ------- | --------- | ---------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 11999999999998 | \{"size":"109730462316987351473852660","balance":"4021590146518312","entryNotional":"40000000000000000","entryFundingIndex":"4433195","entrySocialLossIndex":"0"} | 10000000000000 | 0x903e372da3a3e6c0ba9fd7661d24187325a17a95 | -217335 | false | 0 | 4294967295 | 0x3a2573d07a483f2df23b788b683fa0ca760bf6d9 | 221 | 0xc37eaddf40862f4ad5849e013c9c41a4b81384ba | 19294383 | 2024-09-03T15:41:53.000Z | 0xdc6c2be30452603e500e434a650dda5604b1ae3e3c125c7c916d20f2415bd775 |
| 13320000000000 | \{"size":"119269791333014014434185950","balance":"4454663046161915","entryNotional":"44400000000000000","entryFundingIndex":"4707972","entrySocialLossIndex":"0"} | 10000000000000 | 0x903e372da3a3e6c0ba9fd7661d24187325a17a95 | -217125 | false | 0 | 4294967295 | 0x7f178c230a7c68ad1e9121453aeeec4dff6d73c8 | 189 | 0xc37eaddf40862f4ad5849e013c9c41a4b81384ba | 19290831 | 2024-09-03T13:43:29.000Z | 0xeab9ff6e54a83235d9c0e1798e0a39b7add658ff9f41b1d7a0f9d98e69b0a789 |
| 12000000000000 | \{"size":"-64654225556840053626348266","balance":"4002000000000000","entryNotional":"40000000000000000","entryFundingIndex":"-53830632","entrySocialLossIndex":"0"} | 10000000000000 | 0xfc3155ec7fc5993625c325a07c00ff5c8f08f212 | -212045 | false | 0 | 4294967295 | 0x122f085cec9723a6350a1d09370df98c334df2af | 184 | 0xc37eaddf40862f4ad5849e013c9c41a4b81384ba | 19281781 | 2024-09-03T08:41:49.000Z | 0x32ca09c008e92715bbfddf10fba9ee2e9fa8589d0bcb2f88b6e4d08076663739 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Fill_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_FundingFee\_event
Funding fee payment events from SynFutures V3 perpetual futures protocol on Base, recording periodic funding rate settlements between traders and the protocol. Used for analyzing funding rate costs, trader position exposure, and perpetual market pricing dynamics.
| 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. |
| address | removed | in\_trader | log\_index | in\_funding | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 0xdf608c4f3c10d82a3eef154ad5589e056ed91f24 | 42 | 0 | 20734937 | 2024-10-07T00:00:21.000Z | 0x2afb01ab56ab7fcd282415f48c4f9b5c51a3bf710e52710582cdaefde2116d4c |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 0xdf608c4f3c10d82a3eef154ad5589e056ed91f24 | 43 | 0 | 20734937 | 2024-10-07T00:00:21.000Z | 0x2afb01ab56ab7fcd282415f48c4f9b5c51a3bf710e52710582cdaefde2116d4c |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 0x7d5e2b60f352c98b199e3a4e0323b7d7a34057cb | 31 | 0 | 20734942 | 2024-10-07T00:00:31.000Z | 0x68a1b3195755c6ce4cb106c2e76ed8ffcf1314f5d8d2795679500fa8e30670cf |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_FundingFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Initialized\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Liquidate\_event
Liquidation events from SynFutures V3 perpetual contracts on Base, recording forced position closures with mark price, position size, and involved trader and liquidator addresses. Used to analyze liquidation cascades, protocol risk events, and market volatility impacts on leveraged positions.
| 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. |
| address | in\_mark | in\_size | removed | in\_amount | in\_expiry | in\_target | in\_trader | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------- | ---------------------------- | ------- | ---------- | ---------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5067ae26f19e222c39d6166a39ef2168316856a8 | 9911345747794 | 1600000000000000000000 | false | 0 | 4294967295 | 0x46b78f63d6879ef74c0642cc615989aba4a0ad03 | 0x80533e47ef64225476f3e0771a835f2c8008c0c7 | 88 | 21396456 | 2024-10-22T07:30:59.000Z | 0xe91a8d678180d38e44265e27508ca8956cb735b49973704a0dd85060fd6c056f |
| 0x5be23dcb5ecf2f7789b7b6b88baac9c367659c31 | 269053193755 | 3652370014307101465909623245 | false | 0 | 4294967295 | 0xdb5858c302e52064f63abb3d5c0f58bdeed49fe5 | 0x80533e47ef64225476f3e0771a835f2c8008c0c7 | 26 | 21391596 | 2024-10-22T04:48:59.000Z | 0x61024cd49ba3df1dc6f90b908fc79657096c7f4abedfda7d49cc54544e0d83a7 |
| 0x5be23dcb5ecf2f7789b7b6b88baac9c367659c31 | 267185524775 | 334925603514536373249771872 | false | 0 | 4294967295 | 0x195bd8acad454922b2cc78573286fb54be087161 | 0x80533e47ef64225476f3e0771a835f2c8008c0c7 | 114 | 21391606 | 2024-10-22T04:49:19.000Z | 0xc9955e8a0d77e4da4d4ffe6e1a0e45e0191a2fcedbf1c4a10b7479522a0d2862 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Liquidate_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Place\_event
Order placement events from SynFutures V3 perpetual futures protocol on Base, recording limit orders with price tick, size, balance, and trader address. Used for analyzing order book depth, liquidity provision patterns, and market maker activity.
| 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` | 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. |
| address | in\_tick | removed | in\_nonce | in\_order | in\_expiry | in\_trader | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | -------- | ------- | --------- | --------------------------------------------------------------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6ad9629078503888f005773cc546979aa37e9ee1 | -1740 | false | 0 | \{"size":"654500000000000000","balance":"55933244183680292"} | 4294967295 | 0xcb371524e3ff832430dba9ebe855f9f60ea92c59 | 323 | 18560980 | 2024-08-17T16:15:07.000Z | 0x1626d3567b05ec412521f2c674bcfcb45e9349ec21320f89d03112b120ab0581 |
| 0x6ad9629078503888f005773cc546979aa37e9ee1 | -1645 | false | 0 | \{"size":"5000000000000000000","balance":"1034542358440798990"} | 4294967295 | 0x6ab9ce104ef80b6a6d09091760170250209f56a3 | 177 | 18574067 | 2024-08-17T23:31:21.000Z | 0x1432f2db4ab989b5652d82411939c37e547b91c155a5ecc8ac2f9dc1090f44b1 |
| 0x6ad9629078503888f005773cc546979aa37e9ee1 | -1640 | false | 0 | \{"size":"5000000000000000000","balance":"1035059733084601174"} | 4294967295 | 0x6ab9ce104ef80b6a6d09091760170250209f56a3 | 117 | 18547161 | 2024-08-17T08:34:29.000Z | 0x0c4abde2bdc2ed9fb5254c7a7fbbb5329d1bfac507b15f25af2d22b2811f7a98 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Place_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_RecycleInsuranceFund\_event
Insurance fund recycling events from SynFutures V3 perpetual futures protocol on Base, recording when insurance fund balances are redistributed or reset for trading instruments. Used for tracking protocol risk management and solvency monitoring across different contract expiries.
| 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. |
| address | removed | in\_amount | in\_expiry | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x7c83c8121b4d7774bf3a95b3dc8a4f89c9394ded | false | 5806890000000000 | 4294967295 | 178 | 24983569 | 2025-01-13T08:21:25.000Z | 0xb678277bdb4a9935dfa49680cd2b4a0a517ce612b4349b45a3e9d6a2be10e5e3 |
| 0x1120a835f81236d49c5823e3fe8477831f397217 | false | 51041250206008 | 4294967295 | 144 | 24983849 | 2025-01-13T08:30:45.000Z | 0xc8b3983c8d34cf833ebe0ffd82b3e1df164f8d20d44a5d070c20238ad016496c |
| 0xf7dcdda337ee076e682ddf179d7f475f42fe7821 | false | 134782682863000 | 4294967295 | 49 | 19271247 | 2024-09-03T02:50:41.000Z | 0xb9b414872290e332ca85f624104a37751726e7fb57dc7dd6e00250bbaac9ed01 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_RecycleInsuranceFund_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Remove\_event
Liquidity removal events from SynFutures V3 perpetual futures protocol on Base, capturing when traders withdraw liquidity positions with tick range bounds, balance updates, and funding index snapshots. Used for tracking market maker position adjustments and liquidity provision behavior.
| 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` | 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. |
| in\_fee | in\_pic | in\_tip | address | removed | in\_expiry | in\_trader | log\_index | in\_operator | block\_number | in\_tickLower | in\_tickUpper | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------------------------------------------------------------------------------------------------------ | ------- | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0 | \{"size":"0","balance":"26999436000000000000","entryNotional":"0","entryFundingIndex":"-308043696406091809444","entrySocialLossIndex":"0"} | 0 | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | false | 4294967295 | 0x14b21fe5e331e9f7a3b3daf6a54198aed7c3a985 | 69 | 0x14b21fe5e331e9f7a3b3daf6a54198aed7c3a985 | 17063065 | 109600 | 110200 | 2024-07-14T00:04:37.000Z | 0x3d95212e3aa10aa23df3176edfee271f846c36aa81add607d9128fd5bb42d178 |
| 0 | \{"size":"0","balance":"59133401000000000000","entryNotional":"0","entryFundingIndex":"-308321466520956404371","entrySocialLossIndex":"0"} | 0 | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | false | 4294967295 | 0xdeea6990e9d24495526db047144fc9ba45330377 | 129 | 0xdeea6990e9d24495526db047144fc9ba45330377 | 17063412 | 109600 | 110250 | 2024-07-14T00:16:11.000Z | 0xa0c350e360691c27699e2485a5b32b055f5ec0f12eb2e38c18d481d6c231ef65 |
| 0 | \{"size":"0","balance":"35944612000000000000","entryNotional":"0","entryFundingIndex":"-308334844632882184133","entrySocialLossIndex":"0"} | 0 | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | false | 4294967295 | 0xc45881873ec5720b3e6a040328f106bfd2c09d7b | 164 | 0xc45881873ec5720b3e6a040328f106bfd2c09d7b | 17063426 | 109600 | 110250 | 2024-07-14T00:16:39.000Z | 0xd109dc0281ed9c4219063008a2be7e7a2e4a4a752dcf9acff988383a4149c0c5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Remove_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Settle\_event
Settlement events from SynFutures V3 perpetual futures contracts on Base, recording final position balances and settlement prices when traders close positions. Used for analyzing PnL realization, position lifecycle tracking, and settlement price discovery across perpetual instruments.
| 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. |
| address | removed | in\_expiry | in\_trader | log\_index | in\_balance | in\_operator | block\_number | in\_settlement | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | --------------------- | ------------------------------------------ | ------------- | ------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xba01a365dffa8ad0bca001532977ae2eef83407f | false | 4294967295 | 0xda50a0ff48eda9b67a8fb2ba8274eec1e6351843 | 176 | 22623448241748458331 | 0x086c8f3e5c2d4cb5f31b753c2e6eb029fc5c138b | 24078351 | 1002209864814941331 | 2024-12-23T09:27:29.000Z | 0x5eb94466b8d055a151afc3f5b6b7e75ef4ca40cda55e20c927880ad691085cf9 |
| 0xba01a365dffa8ad0bca001532977ae2eef83407f | false | 4294967295 | 0x71a0e06525b8db9cfc319748569e7fd1d8a89cbd | 185 | 959203940823942177143 | 0x086c8f3e5c2d4cb5f31b753c2e6eb029fc5c138b | 24078351 | 1002209864814941331 | 2024-12-23T09:27:29.000Z | 0x5eb94466b8d055a151afc3f5b6b7e75ef4ca40cda55e20c927880ad691085cf9 |
| 0xdd53d6fc4b4a97a921d65fe81deccb78f2210891 | false | 4294967295 | 0xfc3755da4778d17150b2180c9c0fab9814fe8ed2 | 239 | 5500212570261206 | 0x086c8f3e5c2d4cb5f31b753c2e6eb029fc5c138b | 24078166 | 960756899064577390 | 2024-12-23T09:21:19.000Z | 0x55e18dad5e8ee52191c2c3d6b4fbb9650dd0165eaaae6cb6509fbadef5f3338a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Settle_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Sweep\_event
Position sweep events from SynFutures v3 perpetual futures on Base, recording trader position updates with mark price, size changes, and fee ratios. Used for tracking position liquidations, forced closures, and portfolio rebalancing activity.
| 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. |
| address | in\_mark | in\_size | removed | in\_expiry | in\_trader | log\_index | in\_feeRatio | in\_operator | in\_sqrtPX96 | block\_number | in\_takenSize | in\_takenValue | block\_timestamp | in\_entryNotional | transaction\_hash |
| ------------------------------------------ | ---------------------- | --------------------- | ------- | ---------- | ------------------------------------------ | ---------- | ------------ | ------------------------------------------ | ------------------------------- | ------------- | ------------- | -------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | 3753127789051632662838 | 4844224794205191 | false | 4294967295 | 0x089f879febdc7374e9cbb7533419bf9e06d69562 | 129 | 1 | 0xc37eaddf40862f4ad5849e013c9c41a4b81384ba | 4856281730568719080438296446590 | 23159605 | 0 | 0 | 2024-12-02T03:02:37.000Z | 18200020059017737698 | 0x8d66ee181c1751f4d98a3f9c71ae96a7c459a72dbfeaffc5a0e984706425e9e0 |
| 0x620d1d6453873a4e36570ad6ddcf850ad0cd3952 | 743267196057291291 | 297733107525425734067 | false | 4294967295 | 0x2f22b815ea67da96183398f263d7cfb5e7c1c34d | 124 | 5 | 0xc37eaddf40862f4ad5849e013c9c41a4b81384ba | 69364433269372906990630598906 | 23159015 | 0 | 0 | 2024-12-02T02:42:57.000Z | 224729467967610724867 | 0xb965bac934f2f204e638272295768dae0ddbb5f9cb34293f5a5ab6bc2326874b |
| 0x2ac4298f159ed0e694a4ac2fe4817f6429f9d2de | 3238992686507722937231 | 1287200000000000000 | false | 4294967295 | 0xb84815e09f6d24767eeb46cd30f6ec088d599896 | 159 | 5 | 0xc37eaddf40862f4ad5849e013c9c41a4b81384ba | 4540231671123026824206959029330 | 23185196 | 0 | 0 | 2024-12-02T17:15:39.000Z | 4196133409112630874242 | 0x1f7af52b83438bab7aa9e273cafd387f5391de3ff80cbf1a3faa2de1a1dadc3d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Sweep_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Trade\_event
Trade execution events from SynFutures V3 perpetual futures protocol on Base, capturing position changes with size, entry price (sqrtPX96), mark price, and fee data. Used for analyzing trader activity, position sizing, and market price movements across perpetual instruments.
| 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. |
| 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 |
| ------------------------------------------ | ---------------------- | ------------------ | ------- | --------------------- | ---------- | ------------------------------------------ | ---------- | ------------ | ------------------------------- | ------------- | ------------- | -------------- | ------------------------ | -------------------- | ------------------------------------------------------------------ |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | 2604718818438877866795 | -27349101549420657 | false | 0 | 4294967295 | 0x0005e531ee5d25d685f4de0f3d99fef9732caf49 | 271 | 1 | 4045600096121810833229227773687 | 25895318 | 0 | 0 | 2025-02-03T10:53:03.000Z | 71311658160799045269 | 0x4e63c82404f60c321d71513edfee3499e1cc327883fb0445d7603c9e5631f98e |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | 2604718818438877866795 | 27349101549420657 | false | 9789755000000000000 | 4294967295 | 0x0005e531ee5d25d685f4de0f3d99fef9732caf49 | 268 | 1 | 4045700113360943873899087318245 | 25895318 | 0 | 0 | 2025-02-03T10:53:03.000Z | 71311658160799045270 | 0x4e63c82404f60c321d71513edfee3499e1cc327883fb0445d7603c9e5631f98e |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | 2728512006382627849115 | 26358601653830409 | false | 219141769000000000000 | 4294967295 | 0x00249f173b9df38210a408da377ee82a5696537d | 259 | 1 | 4140642731566876777856947695904 | 25912312 | 0 | 0 | 2025-02-03T20:19:31.000Z | 71992795601777284820 | 0x0bbb79c7e6701e3c04fff8d6017b2cdb2e124f19be0b5932cd46721a319a97c4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_UpdateAmmStatus\_event
Automated Market Maker (AMM) status change events from SynFutures V3 perpetual futures instruments on Base, capturing mark prices, sqrt price ratios (sqrtPX96), and status transitions. Used for tracking liquidity pool state changes and price discovery mechanics across derivative instruments.
| 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. |
| address | in\_mark | removed | in\_expiry | in\_status | log\_index | in\_sqrtPX96 | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ----------------------- | ------- | ---------- | ---------- | ---------- | -------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xba01a365dffa8ad0bca001532977ae2eef83407f | 1000849720000000000 | false | 4294967295 | 1 | 215 | 79261816243846403132836166972 | 17719009 | 2024-07-29T04:29:25.000Z | 0x484a4d1b78ea24a1b9f0a4d7431c1608b81da2fc83d419f98294d805eca8c89e |
| 0x85dd569bd252967ce7ee4e96617f42d94ca82c5d | 80134108575 | false | 4294967295 | 1 | 57 | 22427883359777783451474836 | 17725288 | 2024-07-29T07:58:43.000Z | 0x6565f0fb4527592499844afe6d8f9811d2fa26b16bbc7c48a7cf863b09b75cdb |
| 0x62ba13b3e351b4379964de33437d0afd32ab18b0 | 92210793180380000000000 | false | 4294967295 | 1 | 39 | 24058606150272829259481412327597 | 24411722 | 2024-12-31T02:39:51.000Z | 0xa3048537732275c5ff52b3974250215c39f8cf010f8392cdcb4bca656ff9577d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_UpdateAmmStatus_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_UpdateCondition\_event
State change events tracking instrument condition updates in SynFutures V3 perpetual futures protocol on Base. Records when trading instruments transition between market conditions (e.g., normal, paused, emergency) with timestamps for monitoring protocol health and trading availability.
| Column | Type | Description |
| ------------------ | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_timestamp` | `STRING` | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch. |
| `in_condition` | `INT64` | Status code indicating the current condition state of the SynFutures instrument. Based on sample data, value 0 appears to represent a standard or normal operational state. |
| address | removed | log\_index | block\_number | in\_condition | in\_timestamp | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb41303f0382dfe669a71f1f9c13146ff41e4b6dd | false | 68 | 18797798 | 0 | 1724384943 | 2024-08-23T03:49:03.000Z | 0x0df2620e1a786ec94323df86d3d8616b65b77030c262544b8b1de59c16424451 |
| 0xbdcc0c1068a1c27a52c7902b348af2d033abc189 | false | 354 | 16560266 | 0 | 1719909879 | 2024-07-02T08:44:39.000Z | 0x906daf392badfa1b9a38f6384af970323a20deec55a3767277474f2ce2fa67b8 |
| 0x75da1f73fa85ce885fd209e34d6d9334ecaff14f | false | 206 | 16560062 | 0 | 1719909471 | 2024-07-02T08:37:51.000Z | 0xd21f99f789f899b502d8339c3e3e35087da551d889fcabba0eda6d9d35ee1d59 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_UpdateCondition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_UpdateFeeState\_event
Fee state updates for SynFutures V3 instruments on Base, tracking cumulative fee indices and protocol fee accruals per trading instrument. Used to analyze fee generation patterns and protocol revenue over time.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_expiry` | `STRING` | Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds. |
| `in_feeIndex` | `STRING` | Cumulative fee index value for the SynFutures V3 instrument at the time of the fee state update. Represented as a high-precision integer that increases monotonically with each fee accrual event. |
| `in_protocolFee` | `STRING` | Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals. |
| address | removed | in\_expiry | log\_index | in\_feeIndex | block\_number | in\_protocolFee | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------- | ------------------ | ------------- | ---------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 4294967295 | 81 | 100000386174310990 | 21362596 | 8827100844116076137942 | 2024-10-21T12:42:19.000Z | 0x63092084437bd40fe2db264d155139d779554ad2d6d62556f2c62591d37aa3ef |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 4294967295 | 45 | 100000645624689326 | 21362598 | 8827129181989790294532 | 2024-10-21T12:42:23.000Z | 0x3e0534ff972799fb43bd8b6d0993401f9791bb54afc24d5e541f7981cc2d35c3 |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 4294967295 | 53 | 100001197948666084 | 21362599 | 8827189508311929648799 | 2024-10-21T12:42:25.000Z | 0xb2da25a445bc8ed6163c4ae47e18635666a758e41b50b862cab4348a7ef60f0e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_UpdateFeeState_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_UpdateFundingIndex\_event
Funding rate index update events from SynFutures v3 perpetual contracts on Base, tracking the cumulative funding index for each instrument. Used for calculating funding payments between long and short position holders over time.
| 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. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_fundingIndex | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 1 | 21952109 | 2024-11-04T04:12:45.000Z | 142543258165934439018094400448903650375783600446394036980814 | 0x186ff26e739acbca11115d573cfc43117dce85c87fc0b2817661ff80d638e214 |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 1 | 21987011 | 2024-11-04T23:36:09.000Z | 142787784744801274355271026822601888105764119971223383305658 | 0x0d2a2e1839b1560642460bcb2f27224d200e00da040c0fcbddb9ea75ff2cb444 |
| 0x04d72fb4803b4e02f14971e5bd092375eb330749 | false | 1 | 21966261 | 2024-11-04T12:04:29.000Z | 142716021974312562030715911476265523854149509093517535329748 | 0x20567bfc3717fbd63b21daae446578085fe45b49afc425869d48d77526168034 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_UpdateFundingIndex_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_UpdateMarginRatio\_event
Margin requirement updates for trading instruments on SynFutures V3 perpetual futures protocol on Base, capturing changes to initial margin ratio (IMR) and maintenance margin ratio (MMR). Used for tracking risk parameter adjustments and leverage changes across different instruments.
| Column | Type | Description |
| --------------------------- | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_initialMarginRatio` | `STRING` | Initial margin ratio required to open a position on this SynFutures instrument, expressed in basis points (e.g., '1000' = 10%). Updated via governance when risk parameters are adjusted for specific trading instruments. |
| `in_maintenanceMarginRatio` | `STRING` | Minimum margin ratio that a position must maintain to avoid liquidation, expressed in basis points. Values like '500' represent 5% (500/10000), with typical maintenance ratios ranging from 2% to 7.5%. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_initialMarginRatio | in\_maintenanceMarginRatio |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------- | -------------------------- |
| 0x322a1dbe2b19b68eed0adf59b368db33e60838e2 | false | 581 | 25282700 | 2025-01-20T06:32:27.000Z | 0xdd318f0b6c4961a7e1a5ed3e5608ac318b8e9566c52ab57e815279cb1f1ac905 | 1000 | 500 |
| 0x322a1dbe2b19b68eed0adf59b368db33e60838e2 | false | 274 | 25283788 | 2025-01-20T07:08:43.000Z | 0xade99832f3f85cb544410b4f25e7b85b54e16823db5a13bab57021b3e07d3e28 | 2000 | 750 |
| 0x85dd569bd252967ce7ee4e96617f42d94ca82c5d | false | 264 | 25287073 | 2025-01-20T08:58:13.000Z | 0x7348417e9228f2ec89bfa9a3ed3e3e648baad057cde26e604add9d4d0abcbcaa | 2000 | 750 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_UpdateMarginRatio_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_UpdateParam\_event
Parameter update events for SynFutures V3 derivative instruments on Base, capturing changes to trading fees, margin requirements, tips, and stability fee ratios for each instrument contract.
| 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` | 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. |
| address | removed | in\_param | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0a210cadebd32157299b60aa18800ff580887980 | false | \{"tip":"20000000000000000","qtype":1,"minMarginAmount":"2000000000000000000","tradingFeeRatio":"1","protocolFeeRatio":"2","stabilityFeeRatioParam":"14415916854096691200"} | 199 | 23825012 | 2024-12-17T12:42:51.000Z | 0x83e13fabdc0a3fb155c83fe12a6cef3bdb9ebc7d38cbfa4ba9fea53356674d6e |
| 0x0a210cadebd32157299b60aa18800ff580887980 | false | \{"tip":"20000000000000000","qtype":1,"minMarginAmount":"10000000000000000000","tradingFeeRatio":"1","protocolFeeRatio":"1","stabilityFeeRatioParam":"14415916854096691200"} | 409 | 23823789 | 2024-12-17T12:02:05.000Z | 0x72dfe57109b03b15928c5ed0fd439195f284c5f94f67344e080c96533c7c66e4 |
| 0x32bdb0d18d6cc94d282e1c92e7423007e9a51425 | false | \{"tip":"500000000000000000","qtype":2,"minMarginAmount":"50000000000000000000","tradingFeeRatio":"6","protocolFeeRatio":"1","stabilityFeeRatioParam":"14415916854096691200"} | 22 | 23822738 | 2024-12-17T11:27:03.000Z | 0x0efa3712252d81e5a4fd514cf5031e778004f2762de3b12da49f893789b0ce2e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_UpdateParam_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_UpdatePosition\_event
Position state change events from SynFutures V3 perpetual futures protocol on Base, tracking trader positions with size, collateral balance, entry prices, and funding/social loss indices. Used for analyzing position lifecycle, PnL calculations, and trader behavior across perpetual instruments.
| 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` | 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\_pic | address | removed | in\_expiry | in\_trader | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| \{"size":"-707235648461533","balance":"26860662333333333324","entryNotional":"71333333333333376833","entryFundingIndex":"-142958580279102531092","entrySocialLossIndex":"6308763792900635556"} | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | false | 4294967295 | 0x000758988ba3f07f3a782c095ae8de141b2ff568 | 161 | 23889554 | 2024-12-19T00:34:15.000Z | 0x6c065270f4fe60fa580d61a6fd50ee42c33f68232784dd2f6a2c3ab71bb52884 |
| \{"size":"0","balance":"0","entryNotional":"0","entryFundingIndex":"0","entrySocialLossIndex":"0"} | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | false | 4294967295 | 0x000758988ba3f07f3a782c095ae8de141b2ff568 | 167 | 23889554 | 2024-12-19T00:34:15.000Z | 0x6c065270f4fe60fa580d61a6fd50ee42c33f68232784dd2f6a2c3ab71bb52884 |
| \{"size":"740269789003989","balance":"37478848486599440027","entryNotional":"72677567002799861039","entryFundingIndex":"-3593385173095798565993","entrySocialLossIndex":"0"} | 0xec6c44e704eb1932ec5fe1e4aba58db6fee71460 | false | 4294967295 | 0x002d5629e91f0b0b638c74badf32e8c39828a03a | 316 | 23922005 | 2024-12-19T18:35:57.000Z | 0xf5e38264fd11e416020484bf999d96ef429bcc9c93d71cbcb1dc2c3938193277 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_UpdatePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_UpdateSocialLossInsuranceFund\_event
Insurance fund balance updates from SynFutures V3 perpetual contracts on Base, tracking social loss distribution between long and short positions. Used for monitoring protocol solvency and analyzing liquidation backstop mechanisms across derivative instruments.
| Column | Type | Description |
| ------------------------- | ----------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_expiry` | `STRING` | Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds. |
| `in_longSocialLossIndex` | `STRING` | Cumulative index tracking socialized losses allocated to long position holders for this instrument. Typically starts at zero and increments when the insurance fund cannot fully cover losses from liquidations. |
| `in_shortSocialLossIndex` | `STRING` | Index tracking cumulative socialized losses for short positions in this SynFutures V3 instrument. Always zero in samples, indicating no short-side loss socialization has occurred for this perpetual contract (expiry 4294967295). |
| `in_insuranceFund` | `STRING` | Updated insurance fund balance for the instrument after this event, denominated in the protocol's base unit. Represents the collateral pool available to cover socialized losses for this perpetual futures instrument. |
| address | removed | in\_expiry | log\_index | block\_number | block\_timestamp | in\_insuranceFund | transaction\_hash | in\_longSocialLossIndex | in\_shortSocialLossIndex |
| ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ | ----------------------- | ------------------------ |
| 0xe8427e0ba60252d05e74a718d167e2530e3afb8b | false | 4294967295 | 85 | 17494934 | 2024-07-24T00:00:15.000Z | 6847740418263904 | 0xbb64c4aebc2e7d47294d1c52e5ee129775bdfb2172a5baab4003ff5ed3fcc28f | 0 | 0 |
| 0xe8427e0ba60252d05e74a718d167e2530e3afb8b | false | 4294967295 | 38 | 17494945 | 2024-07-24T00:00:37.000Z | 6847879944289263 | 0x69fa3135595739f8119f983ce75c80ad5f8b17d254e27e9b522fd1960bd708ca | 0 | 0 |
| 0xbdcc0c1068a1c27a52c7902b348af2d033abc189 | false | 4294967295 | 45 | 17494945 | 2024-07-24T00:00:37.000Z | 315953439575867792917 | 0xcb3396417d83f97ccea894859e68432c5157f764d8325045b45fcee0e7549b10 | 0 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_UpdateSocialLossInsuranceFund_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Instrument\_Upgraded\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Instrument_Upgraded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_AddInvolvedPair\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_instrument` | `STRING` | Contract address of the derivative instrument or trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_expiry` | `STRING` | Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_AddInvolvedPair_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_deposit\_function
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_quantity` | `STRING` | Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_RemoveInvolvedPair\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_instrument` | `STRING` | Contract address of the derivative instrument or trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_expiry` | `STRING` | Expiration timestamp for the contract or derivative instrument. Unix timestamp in seconds. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_RemoveInvolvedPair_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_SetPairConfig\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_pairConfig` | `STRUCT` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_SetPairConfig_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_SetProfitFeeRatio\_event
*No description available.*
| Column | Type | Description |
| ---------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_newProfitFeeRatio` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_SetProfitFeeRatio_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_UpdatePending\_event
*No description available.*
| Column | Type | Description |
| ----------------------- | --------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pending` | `STRUCT` | Pending state information containing timestamp of last update, boolean flag for native token handling, pending amount, and exemption amount. String-encoded numeric values for timestamp and amounts. |
| `in_totalPendingShares` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_UpdatePending_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_UpdateShareInfo\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_info` | `STRUCT` | - |
| `in_totalShares` | `STRING` | Total number of shares outstanding in the vault. Numeric string representation of share tokens in the smallest unit. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_UpdateShareInfo_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_UpdateTotalFee\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_totalFee` | `STRING` | Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_UpdateTotalFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_withdraw\_function
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_withdrawFromGateAndRelease\_function
*No description available.*
| Column | Type | Description |
| ------------------ | --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_users` | `ARRAY` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.Vault_withdrawFromGateAndRelease_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### VaultFactory\_CreateVault\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_quote` | `STRING` | Contract address of the quote token used for pricing and settlement. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_vault` | `STRING` | Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_manager` | `STRING` | Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.synfutures_v3_base.VaultFactory_CreateVault_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***