Skip to main content

​
Tables

​
Factory_OrderBookCreated_event

Order book initialization events from Lighter V2 decentralized exchange factory contract on Polygon. Records new trading pair deployments with configuration parameters including token addresses, price/size tick increments, and minimum order amounts for market structure analysis.
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_orderBookAddressSTRINGContract address of the newly created order book on Polygon for the specified token pair. Hex-encoded, 0x-prefixed 40-character string representing the deployed order book smart contract.
in_orderBookIdINT64Sequential identifier assigned to each newly created order book in the Lighter V2 protocol. Increments with each new order book deployment, starting from 0.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_logSizeTickINT64Logarithmic size tick parameter defining the granularity of order size increments for this order book. Lower values allow smaller size steps between orders, while higher values enforce larger minimum size increments.
in_logPriceTickINT64Logarithmic price tick parameter defining the granularity of price levels for the created order book. Smaller values (like 0, 2, 4, or 5) indicate finer price increments between tradeable levels.
in_minToken0BaseAmountSTRINGMinimum order size required for token0 in the order book, denominated in the token’s base units (smallest indivisible unit). Values typically range from thousands to tens of thousands, enforcing a minimum trade threshold for this trading pair.
in_minToken1BaseAmountSTRINGMinimum order size denominated in token1 (the quote token) required for trades in this order book. Specified in base units (smallest token denomination) to enforce a minimum trade threshold.
addressremovedin_token0in_token1log_indexblock_numberin_logSizeTickin_orderBookIdblock_timestampin_logPriceTicktransaction_hashin_orderBookAddressin_minToken0BaseAmountin_minToken1BaseAmount
0xdad36b6acd05c0807c6e7ba7197bc1b23c4dc06cfalse0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd60x2791bca1f2de4661ed88a30c99a7a9449aa8417493149989550142023-11-15T22:13:32.000Z50x90e04af000a25b29895d6773efecf7d59864c3c9af3f230db0cab8c4971713a40xc54f8d2d2edb0cc0bca221de262132792c83255330001000000000
0xdad36b6acd05c0807c6e7ba7197bc1b23c4dc06cfalse0x7ceb23fd6bc0add59e62ac25578270cff1b9f6190x3c499c542cef5e3811e1192ce70d8cc03d5c3359935499895501262023-11-15T22:13:32.000Z40x90e04af000a25b29895d6773efecf7d59864c3c9af3f230db0cab8c4971713a40x69fefd6fa4a65fe63cc65bbcf89717b7bdc7bcf450001000000000
0xdad36b6acd05c0807c6e7ba7197bc1b23c4dc06cfalse0x7ceb23fd6bc0add59e62ac25578270cff1b9f6190x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6933499895501252023-11-15T22:13:32.000Z20x90e04af000a25b29895d6773efecf7d59864c3c9af3f230db0cab8c4971713a40x38f0fcbbc92e0f26b2ba95ad01f272768e0d9dc65000300000000
Query with partition filter
SELECT *
FROM `tt-contracts.lighter_v2_polygon.Factory_OrderBookCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
OrderBook_Swap_event

Swap execution events from Lighter V2 decentralized exchange order book on Polygon, matching ask and bid orders with trade amounts and participant addresses. Enables analysis of order book trading activity, liquidity patterns, and maker-taker dynamics.
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_askIdSTRINGOrder identifier for the ask side of the swap that was matched. Numeric string representing the sell order ID in the Lighter V2 order book.
in_bidIdSTRINGUnique identifier for the bid order being matched in this swap on the Lighter V2 order book. Numeric string value, with ‘0’ appearing frequently in samples suggesting market or instant fill orders.
in_askOwnerSTRINGAddress of the account that owns the ask (sell) order being matched in this swap event. Hex-encoded, 0x-prefixed 40-character Polygon address.
in_bidOwnerSTRINGPolygon address of the account that owns the bid order being filled in this swap event. Hex-encoded, 0x-prefixed 40-character string representing the buyer in the order book transaction.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_askIdin_bidIdlog_indexin_amount0in_amount1in_askOwnerin_bidOwnerblock_numberblock_timestamptransaction_hash
0xc055bb3aaf245521f92c697ac509e0ba798dec48false3801022549670002549672540xd35138f1a59f8ddc705549a2459250eccddb7a300x4e3288c9ca110bcc82bf38f09a7b425c095d92bf497354822023-11-09T13:55:32.000Z0x3ed887a55940da8105c848b41eddbba50f0ff3e267518a3da131e2187fecfb9e
0xc055bb3aaf245521f92c697ac509e0ba798dec48false6203102247440002247442240xd35138f1a59f8ddc705549a2459250eccddb7a300x4e3288c9ca110bcc82bf38f09a7b425c095d92bf497389762023-11-09T16:02:10.000Z0x0804a275e82b2a6ce12b63df4e55b31f940bd3bc192e203f6180f06ff518d9eb
0xc055bb3aaf245521f92c697ac509e0ba798dec48false6803581458550001458551450xd35138f1a59f8ddc705549a2459250eccddb7a300x4e3288c9ca110bcc82bf38f09a7b425c095d92bf497403892023-11-09T16:53:17.000Z0x34a06918ecb6e3e66faf544797fd7b61712958aa9afc02ddc569267a1f37dd51
Query with partition filter
SELECT *
FROM `tt-contracts.lighter_v2_polygon.OrderBook_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100