lighter_v2_optimism

Tables

Factory_OrderBookCreated_event

Order book creation events from Lighter V2 decentralized exchange factory contract on Optimism. Records new trading pair deployments with token addresses, price/size tick parameters, and minimum order amounts for analyzing market initialization and liquidity structure.

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_orderBookAddress`	`STRING`	Contract address of the newly created order book instance on Optimism. Hex-encoded, 0x-prefixed 40-character string representing the deployed order book contract for the specified token pair.
`in_orderBookId`	`INT64`	Sequential identifier assigned to the newly created order book within the Lighter v2 factory contract. Increments with each new order book deployment, starting from 0.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_logSizeTick`	`INT64`	Logarithmic tick size parameter that determines order size granularity in the Lighter V2 order book. Typically ranges from 3 to 16, with higher values allowing larger size increments between orders.
`in_logPriceTick`	`INT64`	Logarithmic price tick size parameter that determines the granularity of price levels in the order book. Higher values indicate coarser price increments between tradeable levels.
`in_minToken0BaseAmount`	`STRING`	Minimum order size required for token0 (the first token in the trading pair) denominated in the token’s base units. Values are stored as strings to preserve precision for large integers beyond native number types.
`in_minToken1BaseAmount`	`STRING`	Minimum order size required for token1 in the trading pair, denominated in token1’s base units. Typically set to prevent dust orders and maintain orderbook efficiency.

Sample Data

address	removed	in_token0	in_token1	log_index	block_number	in_logSizeTick	in_orderBookId	block_timestamp	in_logPriceTick	transaction_hash	in_orderBookAddress	in_minToken0BaseAmount	in_minToken1BaseAmount
0xf3eee5c7d3bed32a9bf70433e9882cef7ecfd5f0	false	0x4200000000000000000000000000000000000006	0x68f180fcce6836688e9084f035309e29bf0a2095	11	112536599	12	1	2023-11-22T16:52:55.000Z	2	0x72833af16faa6f13c5afd170ab4180de0ecd44ebf917e31bbbbb651fe3c03792	0xbab4d6a1329e9a465ae65bcec032b13480d1664f	5000	300000000
0xf3eee5c7d3bed32a9bf70433e9882cef7ecfd5f0	false	0x4200000000000000000000000000000000000006	0x7f5c764cbc14f9669b88837ca1490cca17c31607	9	112536599	12	0	2023-11-22T16:52:55.000Z	4	0x72833af16faa6f13c5afd170ab4180de0ecd44ebf917e31bbbbb651fe3c03792	0xb93dff1d20f781690ab1fc79a6e8a5f8583e03fa	5000	1000000000
0xf3eee5c7d3bed32a9bf70433e9882cef7ecfd5f0	false	0x4200000000000000000000000000000000000006	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	13	112536599	12	2	2023-11-22T16:52:55.000Z	16	0x72833af16faa6f13c5afd170ab4180de0ecd44ebf917e31bbbbb651fe3c03792	0x254af883d97f25f1264c67938fcb718a55c6947d	5000	1000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lighter_v2_optimism.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 (DEX) orderbook on Optimism, matching bid and ask orders with associated token amounts and owner addresses. Useful for analyzing orderbook trading activity, liquidity provision patterns, and price discovery mechanisms.

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_askId`	`STRING`	Order identifier for the ask (sell) side of the matched trade in the Lighter V2 order book. Numeric string value that references a specific limit sell order being filled.
`in_bidId`	`STRING`	Order identifier for the bid side of the matched swap on the Lighter V2 order book. Value of ‘0’ indicates a market order that matched against an existing ask order.
`in_askOwner`	`STRING`	Owner address of the ask order being filled in this Lighter V2 orderbook swap. Hex-encoded, 0x-prefixed 40-character Optimism address of the seller.
`in_bidOwner`	`STRING`	Address of the user who owns the bid order being matched in this Lighter V2 swap. Hex-encoded, 0x-prefixed 40-character Optimism address.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_askId	log_index	in_amount0	in_amount1	in_askOwner	in_bidOwner	block_number	block_timestamp	transaction_hash
0x409b2966dea8b8b9e9b578be51eb58f3ec9f7e1a	false	4404	12	1585114000	1585129851	0xd35138f1a59f8ddc705549a2459250eccddb7a30	0x62b3e98afa30f94f382856a71d811ac41f5211a7	114105051	2023-12-29T00:14:39.000Z	0xd80c9d848a21b8a482788d86c3e18d61df838cb6a435051b3086ef44f883bc20
0x409b2966dea8b8b9e9b578be51eb58f3ec9f7e1a	false	4404	157	1777401000	1777418774	0xd35138f1a59f8ddc705549a2459250eccddb7a30	0xca423977156bb05b13a2ba3b76bc5419e2fe9680	114106186	2023-12-29T00:52:29.000Z	0x003bf8890c3e028418608fde4dcd50b86fbaa48353857c0c92e129f73de9e5aa
0x409b2966dea8b8b9e9b578be51eb58f3ec9f7e1a	false	4404	68	7264456000	7264528644	0xd35138f1a59f8ddc705549a2459250eccddb7a30	0xca423977156bb05b13a2ba3b76bc5419e2fe9680	114106787	2023-12-29T01:12:31.000Z	0x73cb9ee9f36b357d04c397fb0abdc44fe2ce872341d6daaa27200c37c3dfbf5d

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_OrderBookCreated_event

OrderBook_Swap_event

​Tables

​Factory_OrderBookCreated_event

​OrderBook_Swap_event

Tables

Factory_OrderBookCreated_event

OrderBook_Swap_event