Skip to main content

​
Tables

​
LimitOrderProtocol_OrderFilled_event

Order fill events from 1inch v2 Limit Order Protocol on Polygon, recording maker addresses, order hashes, and remaining amounts. Used to track partial fills and settlement status of limit orders in the 1inch decentralized exchange aggregator.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_makerSTRINGAddress of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
in_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_remainingSTRINGRemaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
addressremovedin_makerlog_indexblock_numberin_orderHashin_remainingblock_timestamptransaction_hash
0x94bc2a1c732bcad7343b25af48385fe76e08734ffalse0x11431a89893025d2a48dca4eddc396f8c8117187124331849860x065ebe1201189e047f5e3dda84fb7371963fb327cf9097659c37d651a5fac9752705008162022-09-16T16:31:13.000Z0xde028ca5659207d562163869dee623b84057fd126ad13b0f4bf4093d87c42394
0x94bc2a1c732bcad7343b25af48385fe76e08734ffalse0x11431a89893025d2a48dca4eddc396f8c811718749331849370x065ebe1201189e047f5e3dda84fb7371963fb327cf9097659c37d651a5fac9753369766012022-09-16T16:29:31.000Z0x7fbec655bbc29ee891861ac8f28f9c374d1fc0cb2fb6bf3343e3ff885411fe54
0x94bc2a1c732bcad7343b25af48385fe76e08734ffalse0x11431a89893025d2a48dca4eddc396f8c8117187104331758840x1035a3cc5e96e6894b31ee25c3dff1604b497dec6443eebc43d3886b11c521e220058952022-09-16T11:18:01.000Z0x4a2f80fb331c68c9ca77530f55c12778c412f9fb7008ccb073789ba51f183b10
Query with partition filter
SELECT *
FROM `tt-contracts.1inch_v2_polygon.LimitOrderProtocol_OrderFilled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100