synthetix_v2_optimism

Tables

FuturesMarketManager_MarketAdded_event

Event log tracking new perpetual futures market deployments on Synthetix v2 Optimism protocol. Records asset identifiers, market contract addresses, and market keys for tracking protocol expansion and available trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_marketKey`	`STRING`	Identifier for the perpetual futures market being tracked. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros, representing the market symbol with ‘s’ prefix (e.g., 0x7345544850455250 for sETHPERP).

Sample Data

address	removed	in_asset	in_market	log_index	block_number	in_marketKey	block_timestamp	transaction_hash
0xdb89f3fc45a707dd49781495f77f8ae69bf5ca6e	false	0x4141564500000000000000000000000000000000000000000000000000000000	0x001b7876f567f0b3a639332ed1e363839c6d85e2	15	52487673	0x7341415645000000000000000000000000000000000000000000000000000000	2022-12-20T17:03:41.000Z	0x4668fbaf9887809a0faf54697905b1adb12f350d9fe81034f113109516e57d43
0xdb89f3fc45a707dd49781495f77f8ae69bf5ca6e	false	0x4150450000000000000000000000000000000000000000000000000000000000	0xfe00395ec846240dc693e92ab2dd720f94765aa3	21	52487673	0x7341504500000000000000000000000000000000000000000000000000000000	2022-12-20T17:03:41.000Z	0x4668fbaf9887809a0faf54697905b1adb12f350d9fe81034f113109516e57d43
0xdb89f3fc45a707dd49781495f77f8ae69bf5ca6e	false	0x4156415800000000000000000000000000000000000000000000000000000000	0x4ff54624d5fb61c34c634c3314ed3bfe4dbb665a	14	52487673	0x7341564158000000000000000000000000000000000000000000000000000000	2022-12-20T17:03:41.000Z	0x4668fbaf9887809a0faf54697905b1adb12f350d9fe81034f113109516e57d43

Example Query

Query with partition filter

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

FuturesMarketManagerV21_MarketAdded_event

Event log tracking when new perpetual futures markets are added to Synthetix v2 on Optimism. Records market contract addresses, asset identifiers, and market keys for tracking protocol expansion and available trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_marketKey`	`STRING`	Identifier for the perpetual futures market being tracked. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros, representing the market symbol with ‘s’ prefix (e.g., 0x7345544850455250 for sETHPERP).

Sample Data

address	removed	in_asset	in_market	log_index	block_number	in_marketKey	block_timestamp	transaction_hash
0xd30bdfd7e7a65fe109d5de1d4e95f3b800fb7463	false	0x5553445400000000000000000000000000000000000000000000000000000000	0x1681212a0edaf314496b489ab57cb3a5ad7a833f	15	108003498	0x7355534454504552500000000000000000000000000000000000000000000000	2023-08-09T18:29:33.000Z	0x8f3e40e3cc82805c61c29345184900a67e174fb82907a2c43ddf3da39e49b6d8
0xd30bdfd7e7a65fe109d5de1d4e95f3b800fb7463	false	0x4a544f0000000000000000000000000000000000000000000000000000000000	0xae90e9bb73b32505fb56a0f4fd4ec8cf94bab730	16	115256855	0x734a544f50455250000000000000000000000000000000000000000000000000	2024-01-24T16:08:07.000Z	0x59921126b9043f8177ee4e6b4b5b8757d9ef6ea7e0eda3ac0b9cc162a73711c2
0xd30bdfd7e7a65fe109d5de1d4e95f3b800fb7463	false	0x4f52444900000000000000000000000000000000000000000000000000000000	0xe698ccc3cd4f2172a848094ea6d28d89d750c16f	66	115256855	0x734f524449504552500000000000000000000000000000000000000000000000	2024-01-24T16:08:07.000Z	0x59921126b9043f8177ee4e6b4b5b8757d9ef6ea7e0eda3ac0b9cc162a73711c2

Example Query

Query with partition filter

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

ProxyPerpsV2_PerpsTracking_event

Perpetual futures position modification events from Synthetix V2 on Optimism, tracking trade execution with position size changes, fees, market identifiers, and referral codes. Used for analyzing trading volumes, fee generation, and referral partner attribution across perpetual markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_trackingCode`	`STRING`	Identifier used to track the source or referrer of the perpetual futures trade. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros.
`in_baseAsset`	`STRING`	Symbol identifier for the underlying asset of the futures market. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros.
`in_marketKey`	`STRING`	Identifier for the perpetual futures market being tracked. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros, representing the market symbol with ‘s’ prefix (e.g., 0x7345544850455250 for sETHPERP).
`in_sizeDelta`	`STRING`	Change in position size denominated in USD. String-encoded integer value representing the delta in smallest unit with extended precision (30 decimal places).
`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.

Sample Data

in_fee	address	removed	log_index	block_number	in_baseAsset	in_marketKey	in_sizeDelta	block_timestamp	in_trackingCode	transaction_hash
994532603507713359	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	false	10	57838541	0x7345544800000000000000000000000000000000000000000000000000000000	0x7345544850455250000000000000000000000000000000000000000000000000	1669800000000000000	2022-12-30T14:10:29.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0xd9163fcb57281f50c83a09a2a554c1cdc0f6fd2d972399cbf68405f8860179ed
17998399884589982205	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	false	10	57967906	0x7345544800000000000000000000000000000000000000000000000000000000	0x7345544850455250000000000000000000000000000000000000000000000000	-14997500000000000000	2022-12-30T21:12:05.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0x92880bf64549395390c5e94c679b5ac731ce0cea294e45b57eb9031e87fabbc2
8949021024113139605	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	false	10	57873756	0x7345544800000000000000000000000000000000000000000000000000000000	0x7345544850455250000000000000000000000000000000000000000000000000	14997500000000000000	2022-12-30T15:33:00.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0x203334dcff195e2485782d04ac4354d3b1dd1f1d645db361f4d28317a7c07348

Example Query

Query with partition filter

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

ProxyPerpsV2_PositionLiquidated_event

Liquidation events from Synthetix v2 perpetual futures markets on Optimism, capturing when undercollateralized positions are forcibly closed. Used to analyze liquidation cascades, keeper profitability, and protocol risk management during volatile market conditions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. 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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`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.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xcf853f7f8f78b2b801095b66f8ba9c5f04db1640	false	4	30310452	2022-10-19T23:48:44.000Z	0x603bd784a9a5b7dcb3995d576a96489726d4521cca0982b9987f7d1f328a95c7
0x1228c7d8bbc5bc53db181bd7b1fce765aa83bf8a	false	4	30310431	2022-10-19T23:48:44.000Z	0x034ebf7e26ff67b8c16054faa59cd2dda1faaec80745c390dfba171d6d6ccf23
0x10305c1854d6db8a1060df60bdf8a8b2981249cf	false	4	11955513	2022-06-15T21:47:34.000Z	0x3add75ac9474bb7bf2fb4ad6e7a8f3a9f34b9433146935fb544b0b2e55725a35

Example Query

Query with partition filter

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

ProxyPerpsV2_PositionModified_event

Position modification events from Synthetix V2 perpetual futures contracts on Optimism, capturing changes to trader positions including size adjustments, margin updates, fees, and funding rate snapshots. Used for analyzing perps trading activity, position lifecycle tracking, and fee/funding calculations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_margin`	`STRING`	Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
`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_tradeSize`	`STRING`	Quantity change applied to the position in the derivative contract. String-encoded integer value representing the delta in position size, with negative values indicating position decreases and positive values indicating increases.
`in_lastPrice`	`STRING`	Price of the underlying asset at the time of position modification. String-encoded integer value representing the price in the smallest unit with 18 decimal precision.
`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.
`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.

Sample Data

in_id	in_fee	address	in_size	removed	in_margin	log_index	in_account	block_number	in_lastPrice	in_tradeSize	block_timestamp	in_fundingIndex	transaction_hash
0	0	0xf86048dff23cf130107dfb4e6386f574231a5c65	0	false	101353500000000000061	4	0x000a62c51e6f33c48ddd7a0ad62bd66a1f648bac	44689761	1276120000000000000000	0	2022-12-02T16:40:55.000Z	264159	0xe9fe8a08246e30f38b0315955091256de4a979cbf3d32775b19ef74b3d9e4821
66904	353499999999999998	0xf86048dff23cf130107dfb4e6386f574231a5c65	-79146161802965238	false	101000000000000000063	9	0x000a62c51e6f33c48ddd7a0ad62bd66a1f648bac	44689761	1276120000000000000000	-79146161802965238	2022-12-02T16:40:55.000Z	264160	0xe9fe8a08246e30f38b0315955091256de4a979cbf3d32775b19ef74b3d9e4821
66904	302999999999999998	0xf86048dff23cf130107dfb4e6386f574231a5c65	0	false	100696996240158561208	4	0x000a62c51e6f33c48ddd7a0ad62bd66a1f648bac	44690119	1276120000000000000000	79146161802965238	2022-12-02T16:42:25.000Z	264175	0x6b54f42ee66cc24f595ffcdb4e50cdbfb0f8d61a025ea631af6282db4e0d8ab1

Example Query

Query with partition filter

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

ProxyPerpsV21_PerpsTracking_event

Perpetual futures trade tracking events from Synthetix V2 on Optimism, capturing position changes with associated fees and referral codes. Links trades to frontends and aggregators through tracking codes like DEXTORO, LYRA, and DHEDGE for analyzing order flow sources and fee attribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_trackingCode`	`STRING`	Identifier used to track the source or referrer of the perpetual futures trade. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros.
`in_baseAsset`	`STRING`	Symbol identifier for the underlying asset of the futures market. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros.
`in_marketKey`	`STRING`	Identifier for the perpetual futures market being tracked. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros, representing the market symbol with ‘s’ prefix (e.g., 0x7345544850455250 for sETHPERP).
`in_sizeDelta`	`STRING`	Change in position size denominated in USD. String-encoded integer value representing the delta in smallest unit with extended precision (30 decimal places).
`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.

Sample Data

in_fee	address	removed	log_index	block_number	in_baseAsset	in_marketKey	in_sizeDelta	block_timestamp	in_trackingCode	transaction_hash
1615047123335277794	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	false	25	114871464	0x7345544800000000000000000000000000000000000000000000000000000000	0x7345544850455250000000000000000000000000000000000000000000000000	-3188970861061419810	2024-01-15T18:01:45.000Z	0x4448454447450000000000000000000000000000000000000000000000000000	0x31e384d6743a238ccb223d10c04e2f0d6de271d98946cde3704fdfd8f1726796
2087168854030081744	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	false	11	114842758	0x7345544800000000000000000000000000000000000000000000000000000000	0x7345544850455250000000000000000000000000000000000000000000000000	-4174545350350383176	2024-01-15T02:04:53.000Z	0x4c59524100000000000000000000000000000000000000000000000000000000	0x9f8fae7ca9c8ba123c28689a7e6ef4aba98db232d8db59f87a3a31fed98c838f
1530921221381086118	0x0940b0a96c5e1ba33aee331a9f950bb2a6f2fb25	false	22	114864989	0x424e420000000000000000000000000000000000000000000000000000000000	0x73424e4250455250000000000000000000000000000000000000000000000000	-24179400000000000000	2024-01-15T14:25:55.000Z	0x444558544f524f00000000000000000000000000000000000000000000000000	0x8f7b7de246c3d0ec06f4c63e95a76c39987618500075f827c762088a88ff09f4

Example Query

Query with partition filter

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

ProxyPerpsV21_PositionModified_event

Position modification events from Synthetix Perps V2 on Optimism, capturing changes to perpetual futures positions including margin, size, price, and funding rate updates. Used for tracking position lifecycle, funding payments, and market skew dynamics across trader accounts.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_margin`	`STRING`	Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
`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_tradeSize`	`STRING`	Quantity change applied to the position in the derivative contract. String-encoded integer value representing the delta in position size, with negative values indicating position decreases and positive values indicating increases.
`in_lastPrice`	`STRING`	Price of the underlying asset at the time of position modification. String-encoded integer value representing the price in the smallest unit with 18 decimal precision.
`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.
`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_skew`	`STRING`	Market skew representing the imbalance between long and short positions in the derivative contract. Numeric string representation of the net directional exposure in the smallest unit of the underlying asset.

Sample Data

address	in_skew	removed	in_margin	log_index	in_account	block_number	in_lastPrice	block_timestamp	in_fundingIndex	transaction_hash
0x27665271210acff4fab08ad9bb657e91866471f0	6155392999900000000000	false	1167000000000000000000	28	0xcd1efe0958c0da3c304f240823ef7ee6d3ed21d6	113253892	865224900000000000	2023-12-09T07:22:41.000Z	4593	0x6a256d7fa28a2e7127f57c2e6bfc83a940d1f4d0809e3057de561a5e2d292949
0x27665271210acff4fab08ad9bb657e91866471f0	6155392999900000000000	false	1164655101860548034310	30	0xcd1efe0958c0da3c304f240823ef7ee6d3ed21d6	113253892	865463259394494561	2023-12-09T07:22:41.000Z	4594	0x6a256d7fa28a2e7127f57c2e6bfc83a940d1f4d0809e3057de561a5e2d292949
0x27665271210acff4fab08ad9bb657e91866471f0	2109257999900000000000	false	500000000000000000000	150	0x3f96f45f17e5c879cc1fd8c2502a70e6ddb225a6	113260408	857910000000000000	2023-12-09T10:59:53.000Z	4596	0x0868b77e58b110d1161d5529792df377b179e1c510e32613fa1b1343a7c1417c

Example Query

Query with partition filter

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

ProxyPerpsV22_PerpsTracking_event

Fee tracking events from Synthetix V2 perpetual futures markets on Optimism, capturing trading fees by referral code for sETH-PERP and other markets. Used for analyzing fee attribution, referral partner performance, and trading volume patterns across different integration sources like KWENTA.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_trackingCode`	`STRING`	Identifier used to track the source or referrer of the perpetual futures trade. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros.
`in_baseAsset`	`STRING`	Symbol identifier for the underlying asset of the futures market. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros.
`in_marketKey`	`STRING`	Identifier for the perpetual futures market being tracked. Hex-encoded bytes32 value with 0x prefix, right-padded with zeros, representing the market symbol with ‘s’ prefix (e.g., 0x7345544850455250 for sETHPERP).
`in_sizeDelta`	`STRING`	Change in position size denominated in USD. String-encoded integer value representing the delta in smallest unit with extended precision (30 decimal places).
`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.

Sample Data

in_fee	address	removed	log_index	block_number	in_baseAsset	in_marketKey	in_sizeDelta	block_timestamp	in_trackingCode	transaction_hash
100982690955169578	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	false	10	60648289	0x7345544800000000000000000000000000000000000000000000000000000000	0x7345544850455250000000000000000000000000000000000000000000000000	-80854981387343393	2023-01-05T14:20:39.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0x86259f5ff5107de3cdd3b821d708737d6d608c0eda4e0d59518b7ada72ef946f
100967166762278655	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	false	10	60648947	0x7345544800000000000000000000000000000000000000000000000000000000	0x7345544850455250000000000000000000000000000000000000000000000000	161705755673595159	2023-01-05T14:22:09.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0x54d8b90c47dba6beeb100977b497bf0dafbb97e05a322b734b6d7fb5aed9f022
12554684860793904000	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	false	10	60750031	0x7345544800000000000000000000000000000000000000000000000000000000	0x7345544850455250000000000000000000000000000000000000000000000000	-10012900000000000000	2023-01-05T19:52:16.000Z	0x4b57454e54410000000000000000000000000000000000000000000000000000	0x14540323bed869eff91f07bba89e2a63853cbc1295a148db65bed2219003a0a4

Example Query

Query with partition filter

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

ProxyPerpsV22_PositionModified_event

Position modification events from Synthetix Perps V2 perpetual futures markets on Optimism, capturing changes to trader positions including size, margin, fees, and funding rate updates. Tracks per-account position state changes across different market contracts for analyzing trading patterns and funding dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_margin`	`STRING`	Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
`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_tradeSize`	`STRING`	Quantity change applied to the position in the derivative contract. String-encoded integer value representing the delta in position size, with negative values indicating position decreases and positive values indicating increases.
`in_lastPrice`	`STRING`	Price of the underlying asset at the time of position modification. String-encoded integer value representing the price in the smallest unit with 18 decimal precision.
`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.
`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_skew`	`STRING`	Market skew representing the imbalance between long and short positions in the derivative contract. Numeric string representation of the net directional exposure in the smallest unit of the underlying asset.

Sample Data

address	in_skew	removed	in_margin	log_index	in_account	block_number	in_lastPrice	block_timestamp	in_fundingIndex	transaction_hash
0x2c5e2148bf3409659967fe3684fd999a76171235	2932150000000000000000	false	0	4	0x03299145ce57d5c645fda8fa8182ffe70087e0ea	104367697	4841471510000000000	2023-06-04T03:38:09.000Z	380	0x77156576d1aa088d0368fd93dfc508c8d4c3c01d080ccf69160e946575a9dee0
0x2c5e2148bf3409659967fe3684fd999a76171235	1382446700000000000000	false	0	4	0xa49a725b78ff10135d428783d3d654a90e97ef81	104588603	4732900000000000000	2023-06-04T18:02:51.000Z	383	0xe4d2f1449aa1b024d74aae262ddc511a3fe0add0f1e55b7db0a6e3c8964f95bc
0xf9dd29d2fd9b38cd90e390c797f1b7e0523f43a9	5564009800000000000000	false	2130560000000000000000	9	0xacce6451bd75b7e9e4cb32009bc0005887a21129	104344006	378393000000000000	2023-06-04T01:29:07.000Z	411	0xbcc4789c578174e73009e01f47c96d7398ca98a537c079d390fd03bb7d4ef386

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

FuturesMarketManager_MarketAdded_event

FuturesMarketManagerV21_MarketAdded_event

ProxyPerpsV2_PerpsTracking_event

ProxyPerpsV2_PositionLiquidated_event

ProxyPerpsV2_PositionModified_event

ProxyPerpsV21_PerpsTracking_event

ProxyPerpsV21_PositionModified_event

ProxyPerpsV22_PerpsTracking_event

ProxyPerpsV22_PositionModified_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​FuturesMarketManager_MarketAdded_event

​FuturesMarketManagerV21_MarketAdded_event

​ProxyPerpsV2_PerpsTracking_event

​ProxyPerpsV2_PositionLiquidated_event

​ProxyPerpsV2_PositionModified_event

​ProxyPerpsV21_PerpsTracking_event

​ProxyPerpsV21_PositionModified_event

​ProxyPerpsV22_PerpsTracking_event

​ProxyPerpsV22_PositionModified_event

Tables

FuturesMarketManager_MarketAdded_event

FuturesMarketManagerV21_MarketAdded_event

ProxyPerpsV2_PerpsTracking_event

ProxyPerpsV2_PositionLiquidated_event

ProxyPerpsV2_PositionModified_event

ProxyPerpsV21_PerpsTracking_event

ProxyPerpsV21_PositionModified_event

ProxyPerpsV22_PerpsTracking_event

ProxyPerpsV22_PositionModified_event