layerzero_v2_optimism

Tables

EndpointV2_PacketDelivered_event

LayerZero V2 packet delivery confirmation events emitted when cross-chain messages are successfully received at their destination endpoint. Contains origin chain identifier (srcEid), sender address, nonce for message ordering, and destination receiver address for tracking cross-chain message flow.

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_origin`	`STRUCT<srcEid STRING, sender STRING, nonce STRING>`	Source endpoint and sender information for a cross-chain message. Struct containing source endpoint identifier (srcEid), sender address, and nonce.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_origin	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“1”,“sender”:“0x000000000000000000000000d2e2c7c099e728a66fb9b27582b76907bb840284”,“srcEid”:“30125”}	11	0x0ddaeb3cff09ef98f06d73c25e7505862e05daab	115561841	2024-01-31T17:34:19.000Z	0x715641899ede7adf28f5ae2e2357245e3f0f45388ab6be113aa30838b99c4928
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“1”,“sender”:“0x000000000000000000000000a5c5a7fe4c05ed84c4947ba58d97564e84817eb3”,“srcEid”:“30106”}	67	0x0ddaeb3cff09ef98f06d73c25e7505862e05daab	115561856	2024-01-31T17:34:49.000Z	0xd319218e8dce699c325d954c5f53b2a415bb8e316c7f0daf05f5ddb2d6d32f01
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“1”,“sender”:“0x000000000000000000000000934363addcac4b84bab4b16f895d65f72f54eb67”,“srcEid”:“30145”}	6	0x0ddaeb3cff09ef98f06d73c25e7505862e05daab	115562131	2024-01-31T17:43:59.000Z	0x93b7386291cbf0268341b8da5d0abe8e0ce2825724a3b1a729b8d4c867e7bb2e

Example Query

Query with partition filter

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

EndpointV2_PacketSent_event

Cross-chain message transmission events from LayerZero V2 protocol endpoints. Records packet details including encoded payload, execution options, and sending library address for tracking message flows between blockchains.

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_encodedPayload`	`STRING`	Encoded LayerZero message payload containing cross-chain transfer instructions. Hex-encoded byte string including destination chain, recipient address, sender address, and message-specific data.
`in_options`	`STRING`	Configuration parameters for LayerZero message execution. Hex-encoded byte string specifying gas limits, executor settings, and delivery options for cross-chain message handling.
`in_sendLibrary`	`STRING`	Contract address of the LayerZero messaging library used to send the cross-chain packet. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_options	block_number	in_sendLibrary	block_timestamp	transaction_hash	in_encodedPayload
0x1a44076050125825900e736c501f859c50fe728c	false	2	0x00030100110100000000000000000000000000009470010021010000000000000000000000000003a980000000000000000053444835ec580000	130252437	0x1322871e4ab09bc7f5717189434f97bbd9546e95	2025-01-05T19:00:51.000Z	0xc76e52b3c73e8dad8038b2705f1f1649cdf2fd8d26aa292b9cb90ef5eac53e78	0x010000000000001a1b0000759f000000000000000000000000f1fcb4cbd57b67d683972a59b6a7b1e2e8bf27e6000076560000000000000000000000009c2dc7377717603eb92b2655c5f2e7997a4945bd25bce8b6c61a2ac78402743991618c424941a66c4f251396169c7a9f8b3946b5020000000000000000000000000000000300000000000000001bc16d674ec80000000d000000000000000000000000d3829d0a654e976e9f0a6d7c3a90f3b21c34afcd000000000000006401000d000000000000000000000000814e82fd08fd00c9933aaa622109bb1e91a2c7c7000000000000006401000d0000000000000000000000003ad18fdb56152554ccaca081c2cbfc7b7e63d306000000000000006401
0x1a44076050125825900e736c501f859c50fe728c	false	2	0x000301001101000000000000000000000000000094700100110100000000000000000000000000057e40	130224129	0x1322871e4ab09bc7f5717189434f97bbd9546e95	2025-01-05T03:17:15.000Z	0x04c658de1319b942b67b2cd89902da443b660ad6be2cb3dd9f0b2ba2d8ce3416	0x01000000000000a7780000759f000000000000000000000000f1fcb4cbd57b67d683972a59b6a7b1e2e8bf27e6000075e70000000000000000000000005f688f563dc16590e570f97b542fa87931af2fedf554197fc3ee69030ecae91cddc2615362b19fb7d649bb1d3ec65b8dc564aa250200000000000000000000000000000000000000000000000000002d79883d2000000d00000000000000000000000080b0f66fc8008b17293f18c8227a087f32045d1b0000000000000bfd00000d000000000000000000000000614a9826e7e7ca9d6eb3049c496b655a1fab94ad0000000000000bfd00000d000000000000000000000000f722f01c36b16ddef8c2eb779948f46c7c43ce540000000000000bf300000d000000000000000000000000ab7ae832b31617ff50681e538ee90c50e9d437140000000000000ba300000d0000000000000000000000003ac75d1f8374317d89ad7081421112bc318d517d0000000000000ba300000d000000000000000000000000199005a35620e5986f46b6231fc243f7d35072aa0000000000000bfd00
0x1a44076050125825900e736c501f859c50fe728c	false	2	0x00030100110100000000000000000000000000009470010021010000000000000000000000000003a980000000000000000053444835ec580000	130252823	0x1322871e4ab09bc7f5717189434f97bbd9546e95	2025-01-05T19:13:43.000Z	0x18115e68dd0bc36445d6dad35b077eae0d31d74145103f4c1717ab1fd32bf8a9	0x010000000000001a200000759f000000000000000000000000f1fcb4cbd57b67d683972a59b6a7b1e2e8bf27e6000076560000000000000000000000009c2dc7377717603eb92b2655c5f2e7997a4945bd0718adc2141bf16a8c48fc0614abc775e97460e96d7a4fb6fef3288c7abea77b020000000000000000000000000000000300000000000000001bc16d674ec80000000d000000000000000000000000cad72da9bc47058f7ab0d3167667c22bdaec8243000000000000006401000d0000000000000000000000009279e9bf85593aeab2c7c170c88f280c6eb42821000000000000006401000d000000000000000000000000ab6f3172829a0cd6a3069673d11796157de1b49e000000000000006401

Example Query

Query with partition filter

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

EndpointV2_send_function

LayerZero V2 endpoint send function calls containing cross-chain message parameters including destination endpoint identifier (dstEid), receiver address, message payload, execution options, and fee structures. Returns unique message identifier (guid), nonce, and calculated native/LZ token fees for tracking cross-chain message transmission.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__params`	`STRUCT<dstEid STRING, receiver STRING, message STRING, options STRING, payInLzToken BOOL>`	Parameters for LayerZero cross-chain message transmission. Struct containing destination endpoint ID (dstEid), receiver address, message payload, execution options, and payment method flag (payInLzToken).
`in__refundAddress`	`STRING`	Address designated to receive refunds for unused gas or failed cross-chain message execution. Hex-encoded, 0x-prefixed, 42-character string.
`out_anon0`	`STRUCT<guid STRING, nonce STRING, fee STRUCT<nativeFee STRING, lzTokenFee STRING>>`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	value	status	gas_used	out_anon0	signature	in__params	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in__refundAddress
247392	4469693769134	true	99004	{“fee”:{“nativeFee”:“4469693769134”,“lzTokenFee”:“0”},“guid”:“0x8ed29e67c944254025e03591d33462a4ef6500ba8dc0fb4abb01b3b5aa4ae8dc”,“nonce”:“119”}	0x2637a450	{“dstEid”:“30213”,“message”:“0x000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000003000000000000000000000000a0a07a78c7d31e6f8698f48fc9219f9a3030f38c000000000000000000000000a0a07a78c7d31e6f8698f48fc9219f9a3030f38c000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000123000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000c0a3426a1cef4052c056fced18099be899d93f1427d13b9a1df1806b91fad3d0c200000000000000000000000070fe7d65ac7c1a1732f64d2e6fc0e33622d0c99195d85ced8adb371760e4b6437896a075632fbd6cefe699f8125a8bc1d9b19e5bd6aca1be9729c13d677335161321649cccae6a591554772516700f986f942eaa00000000000000000000000000000000000000000000000000000000b2c11bc0000000000000000000000000000000000000000000000000000000000001371a”,“options”:“0x000301001101000000000000000000000000000493e001000104”,“receiver”:“0x000000000000000000000000461c12fba639303da045255dd32eea7e38ac69b0”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	136815539	0x461c12fba639303da045255dd32eea7e38ac69b0	0,0,0,0,0,0,3,0,1,0,0,0,1	2025-06-06T17:10:55.000Z	0xf7cf2c26c3bb3b3ccc59a31517669cf62579f836ed3dbd507f4e84284a2f2667	0x70fe7d65ac7c1a1732f64d2e6fc0e33622d0c991
217204	4368454117025	true	100406	{“fee”:{“nativeFee”:“4368454117025”,“lzTokenFee”:“0”},“guid”:“0x46ef85f13d3e18bd65c965cdc57bbb6c3ebdf2ed257beddb65bb670762ca8313”,“nonce”:“117”}	0x2637a450	{“dstEid”:“30213”,“message”:“0x000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000004000000000000000000000000a0a07a78c7d31e6f8698f48fc9219f9a3030f38c000000000000000000000000a0a07a78c7d31e6f8698f48fc9219f9a3030f38c000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000123000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001006bc1b4057926d02b12392d5bbd9d2c080b29ce4ec01483ef0af0d61a07eb4077cd5853ffaba572f2d589c5c8be2668efee814657ab495c263b71fb51fbd02673d6aca1be9729c13d677335161321649cccae6a591554772516700f986f942eaa0000000000000000000000000000000000000000000000000000000002a2704000000000000000000000000000000000000000000000000000000000000f4240000000000000000000000000ef09101b6362a125a2fc73260a6f31fd13cf4a61000000000000000000000000ef09101b6362a125a2fc73260a6f31fd13cf4a610000000000000000000000000000000000000000000000000000000000000002”,“options”:“0x00030100110100000000000000000000000000030d4001000104”,“receiver”:“0x000000000000000000000000461c12fba639303da045255dd32eea7e38ac69b0”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	136805642	0x461c12fba639303da045255dd32eea7e38ac69b0	0,0,0,0,0,0,0,0,0,0,0,0,1	2025-06-06T11:41:01.000Z	0x4e759d37b5534a6973854db883b3531bb8a5ae25f1ea0643bffc13dd1c5b7bf0	0x461c12fba639303da045255dd32eea7e38ac69b0
217204	4368454117025	true	100406	{“fee”:{“nativeFee”:“4368454117025”,“lzTokenFee”:“0”},“guid”:“0xbca1a3bb9e95db8a97cf01b032dfea3e735ff9724ca60703ed62d53f1242dbab”,“nonce”:“116”}	0x2637a450	{“dstEid”:“30213”,“message”:“0x000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000004000000000000000000000000a0a07a78c7d31e6f8698f48fc9219f9a3030f38c000000000000000000000000a0a07a78c7d31e6f8698f48fc9219f9a3030f38c000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000123000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001001f348f3aa0395fe1a42ea0b9d63386534e89e39e57fb8c49c054d60526e4ec245fba7bf51c53553886dc23356476a14d1720165957b4eecf8f6eda199647ef40d6aca1be9729c13d677335161321649cccae6a591554772516700f986f942eaa00000000000000000000000000000000000000000000000000000000013e842600000000000000000000000000000000000000000000000000000000000f4240000000000000000000000000ae5b831049f3f6f82be3b87541af91a7df175d69000000000000000000000000ae5b831049f3f6f82be3b87541af91a7df175d690000000000000000000000000000000000000000000000000000000000000001”,“options”:“0x00030100110100000000000000000000000000030d4001000104”,“receiver”:“0x000000000000000000000000461c12fba639303da045255dd32eea7e38ac69b0”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	136795596	0x461c12fba639303da045255dd32eea7e38ac69b0	0,0,0,0,0,0,0,0,0,0,0,0,1	2025-06-06T06:06:09.000Z	0x142eff9fa75baae76f82ee6a0af3799e02d0036d1f9957dab522535afefb58af	0x461c12fba639303da045255dd32eea7e38ac69b0

Example Query

Query with partition filter

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

OFT_OFTReceived_event

LayerZero V2 OFT (Omnichain Fungible Token) receipt events capturing cross-chain token transfers upon arrival at destination chains. Contains source chain endpoint identifier, transfer GUID, recipient address, and received token amount in local decimals for tracking omnichain asset movements.

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_guid`	`STRING`	Globally unique identifier for the LayerZero cross-chain message. 66-character hex string including 0x prefix.
`in_srcEid`	`STRING`	LayerZero source endpoint identifier for the cross-chain message origin. String-encoded integer representing the chain ID in LayerZero’s endpoint numbering scheme.
`in_toAddress`	`STRING`	Destination address for the cross-chain transfer or operation. Hex-encoded string with 0x prefix, left-padded with zeros to 66 characters total.
`in_amountReceivedLD`	`STRING`	Amount of tokens received after cross-chain transfer in local decimals. String-encoded integer representing the token quantity in the destination chain’s native decimal precision.

Sample Data

address	in_guid	removed	in_srcEid	log_index	block_number	in_toAddress	block_timestamp	transaction_hash	in_amountReceivedLD
0xfe5b10f053871e66a319a57a16cf4e709f51367f		false		26	123356667		2024-07-30T04:01:51.000Z	0x249ebcb82b6e4141ca2f6e9c6a8b28160d6c55d2a511c09beef529e5708533bb
0x19cfce47ed54a88614648dc3f19a5980097007dd	0x7a01086652f4f4a69d12e1c4646593610cc60699f2b47d278caf35bdce812663	false	30101	4	123349547	0x00cb66a05d00ca66160ea188dbe8f3262b9bbb8c	2024-07-30T00:04:31.000Z	0xf8661707fb9012ac91cf7ac308678bb641cccf2ec09fe4b057be80a97f86797b	1999979
0xe8cdf27acd73a434d661c84887215f7598e7d0d3	0x5f03152ae832e4987b505a587ad6046220addcda906d39d3efd46f7c496b86ee	false	30101	28	123358426	0x308f3cc82ca445fd5dbfd27a6e3ec38367a12a46	2024-07-30T05:00:29.000Z	0x8b5c85704739ae11bed25801bb10fdf66283b1246b3feb4b8eda6715438bf73c	1099000000000000

Example Query

Query with partition filter

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

OFT_OFTSent_event

LayerZero OFT (Omnichain Fungible Token) send events capturing cross-chain token transfers with sender address, destination endpoint identifier, and sent/received amounts. Used for tracking cross-chain asset movements and analyzing bridging activity across LayerZero-enabled chains.

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_guid`	`STRING`	Globally unique identifier for the LayerZero cross-chain message. 66-character hex string including 0x prefix.
`in_dstEid`	`STRING`	LayerZero endpoint identifier (EID) for the destination chain in the cross-chain message. String-encoded integer representing the target blockchain in LayerZero v2’s unified chain addressing system.
`in_fromAddress`	`STRING`	Address of the sender initiating the cross-chain token transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSentLD`	`STRING`	Amount of tokens sent in the cross-chain transfer in local decimals. String-encoded integer representing the token quantity in the source chain’s native decimal precision.
`in_amountReceivedLD`	`STRING`	Amount of tokens received after cross-chain transfer in local decimals. String-encoded integer representing the token quantity in the destination chain’s native decimal precision.

Sample Data

address	in_guid	removed	in_dstEid	log_index	block_number	in_fromAddress	block_timestamp	in_amountSentLD	transaction_hash	in_amountReceivedLD
0xe8cdf27acd73a434d661c84887215f7598e7d0d3	0x0000000000000000000000000000000000000000000000000000000000000000	false	30101	109	121102648	0x6dff8e471858df4ec0342f953fc78492bb628158	2024-06-07T23:47:53.000Z	2765000000000000	0xb5c93c3c580a916a439b73de6bbf84f7e6e973cebfa91a92bdb77dc5b01fbc44	2760000000000000
0xe8cdf27acd73a434d661c84887215f7598e7d0d3	0x0000000000000000000000000000000000000000000000000000000000000000	false	30101	265	121101989	0x5f8f2110b11c2896f82d25ce4e67005a0c5006b6	2024-06-07T23:25:55.000Z	602000000000000000	0xe509e9ae2e172c8cb682e5816488750186e78167ec3a744f809e43c814da226a	601096000000000000
0xe8cdf27acd73a434d661c84887215f7598e7d0d3	0x0000000000000000000000000000000000000000000000000000000000000000	false	30101	90	121100031	0x9f7ef899becd23360a6f3c96dae9f32b6493b2a2	2024-06-07T22:20:39.000Z	262500000000000000	0x2bfd1f2f8f64b1fb4bc1867040365633fe1e2dbaae714e598905d6ad69e32378	262106000000000000

Example Query

Query with partition filter

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

SendUln302_DVNFeePaid_event

LayerZero ULN302 (Ultra Light Node) DVN (Decentralized Verifier Network) fee payment events emitted when cross-chain message fees are paid to required and optional verifiers. Records fee amounts per DVN address for cross-chain transaction validation.

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_requiredDVNs`	`ARRAY<STRING>`	Array of contract addresses for required Decentralized Verifier Networks (DVNs) in LayerZero message verification. Hex-encoded, 0x-prefixed, 42-character strings.
`in_optionalDVNs`	`ARRAY<STRING>`	Array of contract addresses for optional Decentralized Verifier Networks (DVNs) in LayerZero message verification. Hex-encoded, 0x-prefixed, 42-character strings.
`in_fees`	`ARRAY<STRING>`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.

Sample Data

address	in_fees	removed	log_index	block_number	block_timestamp	in_optionalDVNs	in_requiredDVNs	transaction_hash
0x1322871e4ab09bc7f5717189434f97bbd9546e95	[“2607396000000”,“2607396000000”]	false	1	135811234	2025-05-14T11:14:05.000Z	[]	[“0xa7b5189bca84cd304d8553977c7c614329750d99”,“0xfe6507f094155cabb4784403cd784c2df04122dd”]	0x8b1f1861fb3663b49d84f7dfdf06132ee02ad4e438adfde775e735d65d0e29be
0x1322871e4ab09bc7f5717189434f97bbd9546e95	[“106590002995”,“106590002995”]	false	1	135832778	2025-05-14T23:12:13.000Z	[]	[“0xa7b5189bca84cd304d8553977c7c614329750d99”,“0xfe6507f094155cabb4784403cd784c2df04122dd”]	0x9daeb0c0275e9d1fbc2ccb97242fb51c72784cc07ffe1d92a69a4afb78bf66d4
0x1322871e4ab09bc7f5717189434f97bbd9546e95	[“2563920000000”,“2563920000000”]	false	1	135827285	2025-05-14T20:09:07.000Z	[]	[“0xa7b5189bca84cd304d8553977c7c614329750d99”,“0xfe6507f094155cabb4784403cd784c2df04122dd”]	0xe4e5bbcfe9de9d4b7af1440be5fd7cabbcb45c019d2017daa0f5ea7d0a5d606f

Example Query

Query with partition filter

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

SendUln302_ExecutorFeePaid_event

Executor fee payment events from LayerZero’s SendUln302 contract, recording fees paid to cross-chain message executors. Contains executor address and fee amounts for tracking cross-chain messaging costs.

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_executor`	`STRING`	Address of the executor contract responsible for processing cross-chain message delivery. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	in_executor	block_number	block_timestamp	transaction_hash
134007824760645	0x1322871e4ab09bc7f5717189434f97bbd9546e95	false	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	137065434	2025-06-12T12:00:45.000Z	0xa5efdbce15f6e78e1df92d2304392a53fe159f41dc3092704ae9f6671c408649
18171924905317	0x1322871e4ab09bc7f5717189434f97bbd9546e95	false	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	137069368	2025-06-12T14:11:53.000Z	0xb0c9f82cd492661fbca6fc3e62c4c29ae0dbb46edbee662129953e87262526ba
18071951242077	0x1322871e4ab09bc7f5717189434f97bbd9546e95	false	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	137048557	2025-06-12T02:38:11.000Z	0x41dd0a541738c4e8e96b4d6c510b3aeabf9c96f1a4b1a4df91a3403d47c7406b

Example Query

Query with partition filter

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

SendUln302_NativeFeeWithdrawn_event

Native fee withdrawal events from LayerZero’s SendUln302 contract recording when workers or users extract accumulated native token fees. Contains worker/user address, receiver, withdrawal amount, and transaction context for fee settlement tracking across chains.

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_worker`	`STRING`	Address of the worker entity that performed the LayerZero message processing operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_worker	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x1322871e4ab09bc7f5717189434f97bbd9546e95	false	39024302517882	0x03d2414476a742aba715bcc337583c820525e22a	20	0xb8ff877ed78ba520ece21b1de7843a8a57ca47cb	118585202	2024-04-10T17:13:01.000Z	0xfd08349e64138f59f0b6c01132c66a5ec9ad0bfffe04e432bae8ac08e8600c7a
0x1322871e4ab09bc7f5717189434f97bbd9546e95	false	7791959535369379017	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	4	0xe93685f3bba03016f02bd1828badd6195988d950	121648937	2024-06-20T15:17:31.000Z	0xec4f80a604944dfb394163401ebc52c60332940d192079fd5ffb6a8188c909b4
0x1322871e4ab09bc7f5717189434f97bbd9546e95	false	10000000000000000000	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	3	0xe93685f3bba03016f02bd1828badd6195988d950	121644264	2024-06-20T12:41:45.000Z	0x5908ffca1ef9b1428a7672b094d802a9dec5cf98dd4130c751248c3dbea34d43

Example Query

Query with partition filter

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

StargateTokenMessaging_BusDriven_event

Stargate cross-chain message bus events emitted when token transfer batches are dispatched to destination chains. Contains destination endpoint identifier (dstEid), batch metadata including number of passengers and starting ticket ID, and LayerZero message GUID for tracking cross-chain transfers.

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_dstEid`	`STRING`	LayerZero endpoint identifier (EID) for the destination chain in the cross-chain message. String-encoded integer representing the target blockchain in LayerZero v2’s unified chain addressing system.
`in_startTicketId`	`STRING`	Starting ticket identifier for the first passenger in the Stargate cross-chain message batch. String-encoded integer representing the sequential position in the bus-driven messaging queue.
`in_numPassengers`	`STRING`	Number of passengers included in the Stargate cross-chain message batch. String-encoded integer representing the count of individual transfers bundled together in the LayerZero bus-driven messaging system.
`in_guid`	`STRING`	Globally unique identifier for the LayerZero cross-chain message. 66-character hex string including 0x prefix.

Sample Data

address	in_guid	removed	in_dstEid	log_index	block_number	block_timestamp	in_numPassengers	in_startTicketId	transaction_hash
0xf1fcb4cbd57b67d683972a59b6a7b1e2e8bf27e6	0x24d3cb25999cdbad8e84d8c49370d7514bed05ebdccf1eda336bc9183c5dd1c0	false	30101	57	121504628	2024-06-17T07:07:13.000Z	6	1798	0x2a947d6f926e34e9e467aebdc9f3a687fb5a7f689bd4e4ccdae23a6b020a1d90
0xf1fcb4cbd57b67d683972a59b6a7b1e2e8bf27e6	0x4c25ff94f403369c4be8a2d4fdf377137a541eb02cd978b94633a18ac84035f8	false	30101	11	121492005	2024-06-17T00:06:27.000Z	1	1722	0xd7f1e5597761a5c892fa9b549848b9acfc52872d5005e8ae349d1579f0e291f2
0xf1fcb4cbd57b67d683972a59b6a7b1e2e8bf27e6	0x3e9d9976690b6c14f39aa23ea9939f867328de7caadd86f4d0dd01e4c9b877a3	false	30101	18	121500205	2024-06-17T04:39:47.000Z	1	1782	0x28c278a54f6ea48454551d22e484b18e62f482227d54e5a5f1a8affb319c9778

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

EndpointV2_PacketDelivered_event

EndpointV2_PacketSent_event

EndpointV2_send_function

OFT_OFTReceived_event

OFT_OFTSent_event

SendUln302_DVNFeePaid_event

SendUln302_ExecutorFeePaid_event

SendUln302_NativeFeeWithdrawn_event

StargateTokenMessaging_BusDriven_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​EndpointV2_PacketDelivered_event

​EndpointV2_PacketSent_event

​EndpointV2_send_function

​OFT_OFTReceived_event

​OFT_OFTSent_event

​SendUln302_DVNFeePaid_event

​SendUln302_ExecutorFeePaid_event

​SendUln302_NativeFeeWithdrawn_event

​StargateTokenMessaging_BusDriven_event

Tables

EndpointV2_PacketDelivered_event

EndpointV2_PacketSent_event

EndpointV2_send_function

OFT_OFTReceived_event

OFT_OFTSent_event

SendUln302_DVNFeePaid_event

SendUln302_ExecutorFeePaid_event

SendUln302_NativeFeeWithdrawn_event

StargateTokenMessaging_BusDriven_event