Skip to main content

​
Tables

​
LimitOrder_LimitOrderFilledByProtocol_event

Limit order fill events from Tokenlon DEX (decentralized exchange) aggregator on Arbitrum, capturing maker-taker swaps with token amounts, relayer details, and profit distribution to protocol participants.
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_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_makerSTRINGAddress of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
in_takerSTRINGAddress of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
in_allowFillHashSTRINGUnique identifier authorizing the relayer to execute this specific limit order fill. 64-character hexadecimal hash (0x-prefixed) used for permission verification.
in_relayerSTRINGAddress of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_profitRecipientSTRINGAddress designated to receive profit generated from the limit order fill. Typically a relayer or protocol fee collector on Arbitrum.
in_fillReceiptSTRUCT<makerToken STRING, takerToken STRING, makerTokenFilledAmount STRING, takerTokenFilledAmount STRING, remainingAmount STRING, makerTokenFee STRING, takerTokenFee STRING>Structured record containing the complete fill details for this limit order, including maker/taker tokens, filled amounts, fees, and remaining quantity. Nested fields show token addresses, fill quantities in token base units, and any protocol fees charged.
in_takerTokenProfitSTRINGProfit amount earned in taker token denomination from filling this limit order. String-encoded integer representing the token amount in base units (wei for ETH, smallest divisible unit for other tokens).
in_takerTokenProfitFeeSTRINGFee charged on the taker token profit from the limit order fill, denominated in the smallest unit of the taker token. Consistently zero in sample data, suggesting fees may be optional or handled separately.
in_takerTokenProfitBackToMakerSTRINGPortion of the taker token profit that was returned to the order maker, denominated in the smallest unit of the taker token. Typically zero when the full profit is retained by the protocol or relayer.
addressremovedin_makerin_takerlog_indexin_relayerblock_numberin_orderHashin_fillReceiptblock_timestampin_allowFillHashtransaction_hashin_profitRecipientin_takerTokenProfitin_takerTokenProfitFeein_takerTokenProfitBackToMaker
0xdc842f306d05fc0e3a2469976ab860b453af2d1afalse0x59966e8e109b62acd549e6ce5f485e08a4a6b7a70xe592427a0aece92de3edee1f18e0157c05861564130xd9d4a0e1db0992ef16a6bb11809c78428db622e6286628860xd0e995c789b11744167b23c60d09cc1be439e05a9e65f02670bac2c0b1aa56b0{“makerToken”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“takerToken”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“makerTokenFee”:“0”,“takerTokenFee”:“0”,“remainingAmount”:“0”,“makerTokenFilledAmount”:“111000000”,“takerTokenFilledAmount”:“110987124”}2022-10-06T09:15:50.000Z0x3de9bf56f270d204c502d18c4320e2c10c5676dc97a7c93ebae2068c7da286540x0340d52e7e1f19410cec7a8d0f76d53ef66f19748eeed655bc22f889780f742a0x6e66fc8380cd5e8c56619f7c724f2c5fcc5a202927100
0xdc842f306d05fc0e3a2469976ab860b453af2d1afalse0xf44f6645e8421bcd93d66d1df7eebd73e8c061b80xe592427a0aece92de3edee1f18e0157c05861564170xab32249d8afcf18f1c8f73fd7c27e9e977bc48ba850427680xd26c5441a9cf4cf687c31412ac13eb46d3623ea4462abded9312027664a99a6e{“makerToken”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“takerToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“makerTokenFee”:“0”,“takerTokenFee”:“0”,“remainingAmount”:“0”,“makerTokenFilledAmount”:“22707839”,“takerTokenFilledAmount”:“11898907636000000”}2023-04-28T03:42:57.000Z0x3f009ad2ce78ed93fd712f787a66d127342139f269fdbf25a0ad451d212248210xaa3ced01cbdc81b39da78d9c73288f4e6a0e3a478224b2f9b971b088929783390xb52e282fbc180db0ea7704850623115f5ac5f5ed1053371934256300
0xdc842f306d05fc0e3a2469976ab860b453af2d1afalse0xe33bb51f16f470730b361258678ab39ed00ab5f50xe592427a0aece92de3edee1f18e0157c05861564400x0efca09d140c09ca9f1a123ee5063d9e6824d979674918240xdf707361262edae616388aeb3d95ec71dd9c7b5378329fd69d05c91873bab4d4{“makerToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“takerToken”:“0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8”,“makerTokenFee”:“0”,“takerTokenFee”:“0”,“remainingAmount”:“0”,“makerTokenFilledAmount”:“370074000000000000”,“takerTokenFilledAmount”:“2053422437316990000000”}2023-03-07T04:50:12.000Z0x44090f3c1750d9eefea24f0bdeb37ba6869ef3eb82ac988883e437a0353f14690x6335ef368d5ff327cb79ed052b02337517f576afc73efc21168d5ecaf516a4810x6e66fc8380cd5e8c56619f7c724f2c5fcc5a20291748675216968586685500
Query with partition filter
SELECT *
FROM `tt-contracts.tokenlon_v1_arbitrum.LimitOrder_LimitOrderFilledByProtocol_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100