tokenlon_v1_arbitrum - Token Terminal Docs

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.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_allowFillHash`	`STRING`	Unique identifier authorizing the relayer to execute this specific limit order fill. 64-character hexadecimal hash (0x-prefixed) used for permission verification.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_profitRecipient`	`STRING`	Address designated to receive profit generated from the limit order fill. Typically a relayer or protocol fee collector on Arbitrum.
`in_fillReceipt`	`STRUCT<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_takerTokenProfit`	`STRING`	Profit 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_takerTokenProfitFee`	`STRING`	Fee 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_takerTokenProfitBackToMaker`	`STRING`	Portion 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.

Sample Data

address	removed	in_maker	in_taker	log_index	in_relayer	block_number	in_orderHash	in_fillReceipt	block_timestamp	in_allowFillHash	transaction_hash	in_profitRecipient	in_takerTokenProfit	in_takerTokenProfitFee	in_takerTokenProfitBackToMaker
0xdc842f306d05fc0e3a2469976ab860b453af2d1a	false	0x59966e8e109b62acd549e6ce5f485e08a4a6b7a7	0xe592427a0aece92de3edee1f18e0157c05861564	13	0xd9d4a0e1db0992ef16a6bb11809c78428db622e6	28662886	0xd0e995c789b11744167b23c60d09cc1be439e05a9e65f02670bac2c0b1aa56b0	{“makerToken”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“takerToken”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“makerTokenFee”:“0”,“takerTokenFee”:“0”,“remainingAmount”:“0”,“makerTokenFilledAmount”:“111000000”,“takerTokenFilledAmount”:“110987124”}	2022-10-06T09:15:50.000Z	0x3de9bf56f270d204c502d18c4320e2c10c5676dc97a7c93ebae2068c7da28654	0x0340d52e7e1f19410cec7a8d0f76d53ef66f19748eeed655bc22f889780f742a	0x6e66fc8380cd5e8c56619f7c724f2c5fcc5a2029	271	0	0
0xdc842f306d05fc0e3a2469976ab860b453af2d1a	false	0xf44f6645e8421bcd93d66d1df7eebd73e8c061b8	0xe592427a0aece92de3edee1f18e0157c05861564	17	0xab32249d8afcf18f1c8f73fd7c27e9e977bc48ba	85042768	0xd26c5441a9cf4cf687c31412ac13eb46d3623ea4462abded9312027664a99a6e	{“makerToken”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“takerToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“makerTokenFee”:“0”,“takerTokenFee”:“0”,“remainingAmount”:“0”,“makerTokenFilledAmount”:“22707839”,“takerTokenFilledAmount”:“11898907636000000”}	2023-04-28T03:42:57.000Z	0x3f009ad2ce78ed93fd712f787a66d127342139f269fdbf25a0ad451d21224821	0xaa3ced01cbdc81b39da78d9c73288f4e6a0e3a478224b2f9b971b08892978339	0xb52e282fbc180db0ea7704850623115f5ac5f5ed	10533719342563	0	0
0xdc842f306d05fc0e3a2469976ab860b453af2d1a	false	0xe33bb51f16f470730b361258678ab39ed00ab5f5	0xe592427a0aece92de3edee1f18e0157c05861564	40	0x0efca09d140c09ca9f1a123ee5063d9e6824d979	67491824	0xdf707361262edae616388aeb3d95ec71dd9c7b5378329fd69d05c91873bab4d4	{“makerToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“takerToken”:“0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8”,“makerTokenFee”:“0”,“takerTokenFee”:“0”,“remainingAmount”:“0”,“makerTokenFilledAmount”:“370074000000000000”,“takerTokenFilledAmount”:“2053422437316990000000”}	2023-03-07T04:50:12.000Z	0x44090f3c1750d9eefea24f0bdeb37ba6869ef3eb82ac988883e437a0353f1469	0x6335ef368d5ff327cb79ed052b02337517f576afc73efc21168d5ecaf516a481	0x6e66fc8380cd5e8c56619f7c724f2c5fcc5a2029	17486752169685866855	0	0

Example Query

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

⌘I