polynomial_v1_optimism

Tables

AdvancedOrders_ExecuteLimitOrder_event

Limit order execution events from Polynomial Protocol’s advanced order system on Optimism, capturing filled orders with execution price, fees, and market identifiers. Used for analyzing order flow, price discovery, and fee generation across perpetual futures markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_executionPrice`	`STRING`	Price at which the limit order was executed on the Polynomial protocol, denominated in wei (18 decimal places). Values typically represent prices for perpetual futures or synthetic assets on the specified market.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

address	in_user	removed	in_market	log_index	in_orderId	in_totalFee	block_number	block_timestamp	transaction_hash	in_executionPrice
0x7634e43aa3f446c8d9d5014d609355f728361075	0x0d5c32ef4aaa93937bf0514fa601a0cd60bd0e87	false	0x0940b0a96c5e1ba33aee331a9f950bb2a6f2fb25	41	2100	1658772660794915580	107234677	2023-07-22T23:22:11.000Z	0x7def8501015a67078ae451bdba1a93939a5c2292edb4e93dbd41d66394d1f91b	240583283650000000000
0x7634e43aa3f446c8d9d5014d609355f728361075	0x83e21fc92a60a6e38cdfad33ee0e25b9f4f90469	false	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	71	2182	10881406704143966756	107210498	2023-07-22T09:56:13.000Z	0xe77a38f9f7607bb3319165bc2ca0b62560066fa61196a8d26a404793efbd33b8	1890882500000000000000
0x7634e43aa3f446c8d9d5014d609355f728361075	0x83e21fc92a60a6e38cdfad33ee0e25b9f4f90469	false	0x2b3bb4c683bfc5239b029131eef3b1d214478d93	165	2199	9855912499609393365	107234578	2023-07-22T23:18:53.000Z	0x8771340f230c350114a0bc9227e43c6cc625b1d9e35ab18c00779200a5f63eb1	1856625000000000000000

Example Query

Query with partition filter

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

AdvancedOrders_ExecutePairOrder_event

Paired order execution events from Polynomial protocol’s advanced order system on Optimism, capturing simultaneous long/short position fills with execution price, fees, and market identifiers. Used for analyzing sophisticated trading strategies and order routing patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_executionPrice`	`STRING`	Final price at which the pair order was executed on the Polynomial protocol, denominated in wei (18 decimal places). Values typically represent asset prices in the range of single to tens of thousands of dollars.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

address	in_user	removed	in_market	log_index	in_orderId	in_totalFee	block_number	block_timestamp	transaction_hash	in_executionPrice
0x7634e43aa3f446c8d9d5014d609355f728361075	0x8a411bea5e50f4cbb830d7940f807b434651d4f4	false	0x33d4613639603c845e61a02cd3d2a78be7d513dc	147	5822	1005984341390342812	109720446	2023-09-18T12:21:09.000Z	0x18d076eee8364b490653c52e8c03255ef2ef352d9b54e9952d37738b7516d4cf	34750000000000000000
0x7634e43aa3f446c8d9d5014d609355f728361075	0xbb84d282a6dbd4948f9ac206cd24d5ee578f0082	false	0x59b007e9ea8f89b069c43f8f45834d30853e3699	18	6025	3674988412694000000	109740732	2023-09-18T23:37:21.000Z	0x252a791fb6a621b63fdc5d378ab44f68dcc50bf98c8af6d81fe71ad02648be2c	26749884126940000000000
0x7634e43aa3f446c8d9d5014d609355f728361075	0xbb84d282a6dbd4948f9ac206cd24d5ee578f0082	false	0x59b007e9ea8f89b069c43f8f45834d30853e3699	33	6014	6527402174048216104	109729786	2023-09-18T17:32:29.000Z	0x256b966a8ed98cdc4afea839cac7f7439cb9960ac25b79d5844208c99c172772	26823056734750000000000

Example Query

Query with partition filter

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

SynthetixLimitOrders_ExecuteRequest_event

Limit order execution events from Polynomial protocol’s Synthetix integration on Optimism, capturing when keepers fill user orders with execution price, fees, and market details. Used for analyzing order flow, keeper performance, and fee distribution across Synthetix 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_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.
`in_executionPrice`	`STRING`	Price at which the limit order was executed on the Synthetix market, denominated in wei (18 decimals). Values typically range in the hundreds or thousands when converted to standard units.
`in_keeper`	`STRING`	Address of the keeper who executed this limit order on behalf of the user. Keepers are network participants who monitor and fulfill pending limit orders in exchange for fees.
`in_feeReceipient`	`STRING`	Address receiving the execution fee for this limit order. Hex-encoded, 0x-prefixed Optimism address that collects fees when the keeper executes the order.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.

Sample Data

address	in_user	removed	in_keeper	in_market	log_index	in_totalFee	block_number	in_requestId	block_timestamp	in_feeReceipient	transaction_hash	in_executionPrice
0xc1f7a43db81e7dc4b3f4c6c2acdcbdc17c41b0dc	0x928d983b9c5151daf08ea4e45eb14e9ae1ab1042	false	0xd476e97b61501a237e46d45d2436f48533d98cf5	0x0940b0a96c5e1ba33aee331a9f950bb2a6f2fb25	11	2901491790521509360	106201110	6180	2023-06-29T01:09:57.000Z	0x7cb6bf3e7395965b2162a7c2e6876720c20012d6	0x324e674b558b3bee0c77b68bd1388e1e8ce8168b9603efb89d4998051f1b691b	232475491000000000000
0xc1f7a43db81e7dc4b3f4c6c2acdcbdc17c41b0dc	0x921c8947a80bc7159777a60793125cec823032bc	false	0xd476e97b61501a237e46d45d2436f48533d98cf5	0x96690aae7cb7c4a9b5be5695e94d72827decc33f	11	3220129399645363597	106201429	6177	2023-06-29T01:20:35.000Z	0x7cb6bf3e7395965b2162a7c2e6876720c20012d6	0xa9ae55e4864c7b847497ebde580f7596669522d6eb600d36f152ef6039229cc1	231107784920000000000
0xc1f7a43db81e7dc4b3f4c6c2acdcbdc17c41b0dc	0x921c8947a80bc7159777a60793125cec823032bc	false	0xd476e97b61501a237e46d45d2436f48533d98cf5	0x96690aae7cb7c4a9b5be5695e94d72827decc33f	11	3120361178847885611	106217750	6170	2023-06-29T10:24:37.000Z	0x7cb6bf3e7395965b2162a7c2e6876720c20012d6	0xae4e32000ebddec8c9f8b9117fb7ba1820a7e83199940aa0463907e8dc12c783	234334562340000000000

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AdvancedOrders_ExecuteLimitOrder_event

AdvancedOrders_ExecutePairOrder_event

SynthetixLimitOrders_ExecuteRequest_event

​Tables

​AdvancedOrders_ExecuteLimitOrder_event

​AdvancedOrders_ExecutePairOrder_event

​SynthetixLimitOrders_ExecuteRequest_event

Tables

AdvancedOrders_ExecuteLimitOrder_event

AdvancedOrders_ExecutePairOrder_event

SynthetixLimitOrders_ExecuteRequest_event