layerzero_v2_ethereum

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”:“415”,“sender”:“0x00000000000000000000000022514ffb0d7232a56f0c24090e7b68f179faa940”,“srcEid”:“30102”}	172	0x22514ffb0d7232a56f0c24090e7b68f179faa940	21552534	2025-01-04T17:13:11.000Z	0x48ae3dc21c43d3b302356c452f582eb9270e56e4c5522bd3cfe0b4611e1df904
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“416”,“sender”:“0x00000000000000000000000022514ffb0d7232a56f0c24090e7b68f179faa940”,“srcEid”:“30102”}	512	0x22514ffb0d7232a56f0c24090e7b68f179faa940	21552559	2025-01-04T17:18:11.000Z	0x758353f1aabbcc0cb134cc6fc92db91107350cae6e4467e28b879509bee85b79
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“408”,“sender”:“0x00000000000000000000000022514ffb0d7232a56f0c24090e7b68f179faa940”,“srcEid”:“30102”}	335	0x22514ffb0d7232a56f0c24090e7b68f179faa940	21547671	2025-01-04T00:55:23.000Z	0xdd75c5c94f4e949a60546cb83dd127719dc2f05e2bb3d8f479542600a38c4b4c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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	267	0x00030100110100000000000000000000000000030d400100110100000000000000000000000000030d40	20662263	0xbb2ea70c9e858123480642cf96acbcce1372dce1	2024-09-02T10:22:59.000Z	0x2543070474e67a5371147e2d37516e062f11d8d012db2aece518777fbebbd0ec	0x01000000000000003c000075950000000000000000000000001cd5b73d12cb23b2835c873e4faffe83bbcef20800007596000000000000000000000000300d2c875c6fb8ce4bf5480b4d34b7c9ea8a33a4a3f270dd8fddb03b8643eaa96372d269e64a80399df982a188df4e1d0f31038f000000000000000000000000dc3b2dce95ebd1e7c18eaa37780d10d2401466600000000004ca07cc
0x1a44076050125825900e736c501f859c50fe728c	false	258	0x0003010011010000000000000000000000000003d090	20661070	0xbb2ea70c9e858123480642cf96acbcce1372dce1	2024-09-02T06:23:35.000Z	0x365b8369393083f3157c1761dfc60e62b3e2e45a1671935134ee2e2cea7edcb9	0x01000000000000055e000075950000000000000000000000006502820f3f035c7a9fc0ebd3d74a0383306c5137000075e80000000000000000000000006502820f3f035c7a9fc0ebd3d74a0383306c51370ac2579a5a0f541a9d1a5823a7e7ff7bbed7cda2808113484ce3e0259f0224af000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000600000000000000000000000004f396daea3119ecba181c0dfdcefb3ba35f4dcbf000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000c5b
0x1a44076050125825900e736c501f859c50fe728c	false	132	0x000301001101000000000000000000000000000249f001001303000000000000000000000000000000075300	20661000	0xbb2ea70c9e858123480642cf96acbcce1372dce1	2024-09-02T06:09:35.000Z	0x371f039ff6e1890c9a8bdab67a01948acd6d9ac1877180ffef1776b9e7157961	0x01000000000000078c000075950000000000000000000000006d6620efa72948c5f68a3c8646d58c00d3f4a980000075960000000000000000000000006e3d884c96d640526f273c61dfcf08915ebd7e2b562e9816938eb63551a6a9a57b1bcfdf94e62c0c854fb2b093422d2e82adfc270100010000000000000000000000001493e7b8d4dfade0a178dad9335470337a3a219a000000000003b9550000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae45a4d8d29f613abebb5e1b461c6f76e9e9bf4a205421cdf8aa8d9fb44005fef40000000000000000000000000000000000000000000000000000000000000060000000000000000000000000f60139ae87251737f7d1912b5211361b7cb184070000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000033d91116e0370970444b0281ab117e161febfcdd00000000000000000000000033d91116e0370970444b0281ab117e161febfcdd0000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d0000000000000000000000001bf7aedec439d6bfe38f8f9b20cf3dc99e3571c4000000000000000000000000000000000000000000000000033240e9c91fcfdd00000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000001842646478b0000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000000000000000000000000000033240e9c91fcfdd0000000000000000000000001bf7aedec439d6bfe38f8f9b20cf3dc99e3571c4000000000000000000000000000000000000000000000007a19b993da14ebc280000000000000000000000002dfadab8266483bed9fd9a292ce56596a2d1378d00000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000087028ac76a51cc950d9822d68b83fe1ad97b32cd580d01ffff0006cd679121ec37b0a2fd673d4976b09d817918560131ec8f77a11aa0277948ed5f9b7b1daf23de3fda0007d004bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c0031ec8f77a11aa0277948ed5f9b7b1daf23de3fda002dfadab8266483bed9fd9a292ce56596a2d1378d0009c40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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
386259	125515746581784	true	226184	{“fee”:{“nativeFee”:“125515746581775”,“lzTokenFee”:“0”},“guid”:“0xddb8604fe2c932202a5afc6e565200e018aa9a535ab31f97f4d2e027680a9d42”,“nonce”:“11”}	0x2637a450	{“dstEid”:“30109”,“message”:“0x000000000000000000000000caa3d3153c67527a18f221119a5222c8f121cc6c000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a45194544700000000000000000000000000b19a5200a100e5fc4c9800772f4d002f21840000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e87e734c5a000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a0d3cd5af923300427efda9741be146efb21668c637dc641bb0bb8486a7a8f9f59000000000000000000000000000000000000000000000000000000000000000e4d536e616b6547616c476966747300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000074d53474946545300000000000000000000000000000000000000000000000000029f64e300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“options”:“0x00030100110100000000000000000000000000030d40”,“receiver”:“0x0000000000000000000000000f220412bf22e05ebcc5070d60fd7136a08af22c”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	19644811	0x0f220412bf22e05ebcc5070d60fd7136a08af22c	0,0,1,0	2024-04-13T06:16:59.000Z	0xfda631a7cc07862cc4a61b360fec2b39cb8908faf16b9ef11f5e269c6df1ff11	0xcaa3d3153c67527a18f221119a5222c8f121cc6c
386259	125515746581784	true	226184	{“fee”:{“nativeFee”:“125515746581775”,“lzTokenFee”:“0”},“guid”:“0x01bd0e3e8ba4640819a1101b8193f2a3ac2baae5dfbb91b78cf4b5237c9927b5”,“nonce”:“10”}	0x2637a450	{“dstEid”:“30109”,“message”:“0x000000000000000000000000caa3d3153c67527a18f221119a5222c8f121cc6c000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a45194544700000000000000000000000000b19a5200a100e5fc4c9800772f4d002f21840000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e87e734c5a000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a0ccf7e6d6e03080b8d05e3ad29f1aa72d21193ec8b2293cbae71288321fb79b70000000000000000000000000000000000000000000000000000000000000000e4d536e616b6547616c476966747300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000074d53474946545300000000000000000000000000000000000000000000000000029f64e300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“options”:“0x00030100110100000000000000000000000000030d40”,“receiver”:“0x0000000000000000000000000f220412bf22e05ebcc5070d60fd7136a08af22c”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	19644784	0x0f220412bf22e05ebcc5070d60fd7136a08af22c	0,0,1,0	2024-04-13T06:11:35.000Z	0xded6e227192d03ec1c3781acdc8af89a3fea1e493d2026b478f5b06a0a411e63	0xcaa3d3153c67527a18f221119a5222c8f121cc6c
205157	118197140875556	true	202915	{“fee”:{“nativeFee”:“118197140875556”,“lzTokenFee”:“0”},“guid”:“0xa966584670664442285da40bb3528122553293fd98ed998c5b635eef40e88fee”,“nonce”:“21”}	0x2637a450	{“dstEid”:“30184”,“message”:“0x00000000000000000000000035c0578375d034b10dc73d8bb4d26f8c1bff0001000000000013da88”,“options”:“0x00030100110100000000000000000000000000013880”,“receiver”:“0x0000000000000000000000001f55a02a049033e3419a8e2975cf3f572f4e6e9a”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	19644357	0x1f55a02a049033e3419a8e2975cf3f572f4e6e9a	1	2024-04-13T04:45:11.000Z	0x359cea67c083c46b9ef14d8bc917acd6ce2829d6a426750f18dfa6374cfa2c99	0x35c0578375d034b10dc73d8bb4d26f8c1bff0001

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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
0x00000000bc5ff0261b97004a79c6d361002ba2db	0x7c228ad6e313595309fa1e102c008687bf1a98dcca600c19696b7ad2f3c300db	false	30102	266	23155406	0x0f43e49464a4a3f52505e02b0a7fb043bdb958dd	2025-08-16T18:30:47.000Z	0xae737158c315dc7da865b90f806d61b135898d5d24c6e68bcaf3ca882f3bec41	2000000000000000000
0x0555e30da8f98308edb960aa94c0db47230d2b9c	0xef2ed57088d3e16d83a147d1fd50e97143350f2a1308b93da4851cf13de061e9	false	30102	287	23152849	0x84acee946118abacc23d7dcfa3b4dc5f6bd17a81	2025-08-16T09:57:35.000Z	0x8b98636bfdcf183eb84de7c5c15b7ea6094e482ca1d4c1708d1231f4c0d1cea0	389347
0x0fc2a55d5bd13033f1ee0cdd11f60f7efe66f467	0x2122008c61ac854ba82c3c05fa7aa4e5bd996bb42982acbf16c90e8cbcaa680e	false	30102	417	23151640	0xca74f404e0c7bfa35b13b511097df966d5a65597	2025-08-16T05:53:59.000Z	0xa0a26f2a35fa6da3c0894a9a043e3342d7da0b65eb6469f6d85f4235a5d5eb76	51850792000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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
0x23432452b720c80553458496d4d9d7c5003280d0	0xdeb26fcc95fc4fd4ec65251477673625f430ab3930fc2b0da742782813ec1886	false	30184	370	20304099	0x41ee737595c8952cff90cc3d0bd6eed0b202efa0	2024-07-14T10:18:59.000Z	133589628000000000000	0xd3644628cca496ceb24f36d6046e5c78601455e7695fb4a0ffad451924a32212	133589628000000000000
0xf4e21623496ad3cf88a58b5e3a6b1fd22fdbe3e4	0xfeac63d3c0629327308e8902ab4824b757822d6aa91e1bfb5ab3b5974effe378	false	30184	459	20304874	0xd784ce1e8859d86a390568175f6f8ed8dc7e307c	2024-07-14T12:54:47.000Z	11228500000000000000000	0x83122e752144293447123c8af39530c1b35e2df21d9c63fc9b990d78f4979a0a	11228500000000000000000
0xf1ba5c811ae1f72fd87cfbfc04f781a12e3bcf8f	0x5dec3349c1d3547ae912f8acbe85a460e7683faf3104f3e8afa4d608aa5f25e1	false	30184	292	20302413	0x79d4f98fce0ac4b7e083c1f58fd061d1aae97865	2024-07-14T04:39:59.000Z	0	0x2ba04f0bb406980fb2b16556d18dec7d3fdaecc349f632965a1189dc22177e01	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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
0xbb2ea70c9e858123480642cf96acbcce1372dce1	[“155394120000000”]	false	248	19266097	2024-02-20T02:59:59.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”]	0x01747273f45afde7600d55ee92c982fec01c1b67742166971e4531f3d117c094
0xbb2ea70c9e858123480642cf96acbcce1372dce1	[“297862080000000”,“297862080000000”]	false	308	19270157	2024-02-20T16:39:47.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x08b078a7153d7255f64b9176947bb2fcc282c309438bc2970232ca1e51747db8
0xbb2ea70c9e858123480642cf96acbcce1372dce1	[“297862080000000”,“297862080000000”]	false	125	19270146	2024-02-20T16:37:35.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x0adfe0ad95b5feabc10b69b779368aeab00cc0d41f6ac222b6e3eb5022b23e74

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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	log_index	in_executor	block_number	block_timestamp	transaction_hash
106554518580000	0xbb2ea70c9e858123480642cf96acbcce1372dce1	false	481	0x173272739bd7aa6e4e214714048a9fe699453059	20456113	2024-08-04T15:33:35.000Z	0x5fbdcd45dc70411e84956df3783757bfebdd0eb7d0ad107960ccd0ebbccc4ff4
10675792117081	0xbb2ea70c9e858123480642cf96acbcce1372dce1	false	83	0x173272739bd7aa6e4e214714048a9fe699453059	20455932	2024-08-04T14:56:59.000Z	0x5105eff3d1a036a87892559b8d1c6a8bb713c6305b0121dea0e0cc6b7f27be88
107244895650955	0xbb2ea70c9e858123480642cf96acbcce1372dce1	false	270	0x173272739bd7aa6e4e214714048a9fe699453059	20456945	2024-08-04T18:20:35.000Z	0x7b58c46df0b3aeb694babc47e86fd029d8c205533b11a409a0a72c39a2db2f16

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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
0xbb2ea70c9e858123480642cf96acbcce1372dce1	false	4400000000000000000	0x173272739bd7aa6e4e214714048a9fe699453059	275	0xe93685f3bba03016f02bd1828badd6195988d950	22521980	2025-05-20T05:12:35.000Z	0xf270ebec83d1d951bfc42bcfdd69812bb24edf7fd516ab96ff0f7a058c9d7754
0xbb2ea70c9e858123480642cf96acbcce1372dce1	false	20266106736995417850	0x173272739bd7aa6e4e214714048a9fe699453059	691	0xe93685f3bba03016f02bd1828badd6195988d950	20673376	2024-09-03T23:35:35.000Z	0x384e1cedc8d3abf85d73b3ae9b72a3b0cb899809e011736a11b09b7b41bc2627
0xbb2ea70c9e858123480642cf96acbcce1372dce1	false	30000000000000000000	0x173272739bd7aa6e4e214714048a9fe699453059	78	0xe93685f3bba03016f02bd1828badd6195988d950	22333666	2025-04-23T19:02:23.000Z	0xdd9f162636be392f4c7c120002f70463fe0aa4d86e84f9f011c34986d94bb2f3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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
0x6d6620efa72948c5f68a3c8646d58c00d3f4a980	0xd3bf3f3854fa5c17d422c9560752329f5f325c1f8c9f86f24da7f6ee394d9662	false	30102	405	21524891	2024-12-31T20:39:23.000Z	1	2959	0x20dbc187c0fd0a511c79b6232a0007e3c345eb1a8cf3f8f6f4d6903ae5086918
0x6d6620efa72948c5f68a3c8646d58c00d3f4a980	0x373e984df4a483300feffdf3489703ccfa32a30cca75da6260e648fd16b934a2	false	30102	333	21521826	2024-12-31T10:21:23.000Z	1	2954	0xfd70e78a41c40bc82b9e12d62beabb92a92b1b2aa0cf5c8eeb3fa84b41af0ebb
0x6d6620efa72948c5f68a3c8646d58c00d3f4a980	0x7f8bc17b61d9fd0f324a399e8e1ddab76f16fc547b417574d92b491b564d6046	false	30102	373	21523989	2024-12-31T17:38:11.000Z	1	2957	0xe453bf418f7093a37a7e7d8e1bb8b06580ec120e527cef80f5977d344dac756a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_ethereum.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