layerzero_v2_bob

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”:“60”,“sender”:“0x000000000000000000000000b4818bb69478730ef4e33cc068dd94278e2766cb”,“srcEid”:“30102”}	2	0xecf21b335b41f9d5a89f6186a99c19a3c467871f	18461132	2025-06-13T03:10:51.000Z	0x7a0155bbe09fde3155e18ac051c3b7bacf779f570e8a0691b598d39d1cc84ae8
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“61”,“sender”:“0x000000000000000000000000b4818bb69478730ef4e33cc068dd94278e2766cb”,“srcEid”:“30102”}	2	0xecf21b335b41f9d5a89f6186a99c19a3c467871f	18461281	2025-06-13T03:15:49.000Z	0xb6a84668012c4d25ddf175724c210ff17f1e68396ae9e219a2806e2451d22a18
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“131”,“sender”:“0x00000000000000000000000019ab8c9896728d3a2ae8677711bc852c706616d3”,“srcEid”:“30101”}	3	0x19ab8c9896728d3a2ae8677711bc852c706616d3	17686564	2025-05-26T04:51:55.000Z	0x6408f1a2c4f8efe96b5d74c0f4968099449db6c69f2d76a1df871cab59acb20f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_bob.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	3	0x00030100110100000000000000000000000000013880	16167306	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-04-21T00:49:59.000Z	0x757834a79e0899701e93ed5b8f1ea8c08705413116c40f4aa4d1bc496044bcd1	0x010000000000000002000076470000000000000000000000003d63825b0d8669307366e6c8202f656b9e91d368000076710000000000000000000000003d63825b0d8669307366e6c8202f656b9e91d3688daa895a5c2e79a69516043930d69ad4e21c1fab99fd59968daad3a0477df03f000000000000000000000000d240a9de14e78e9bd709ddca51f3a0063a96780d00000001b91c9ffd
0x1a44076050125825900e736c501f859c50fe728c	false	3	0x00030100110100000000000000000000000000013880	16199889	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-04-21T18:56:05.000Z	0x3c29ae227da09008a8a96ec8d22c401506381f75c1742f594284463303d8e50c	0x010000000000000003000076470000000000000000000000003d63825b0d8669307366e6c8202f656b9e91d3680000769a000000000000000000000000c53ac24320e3a54c7211e4993c8095078a0cb3cffa419befdf206e3d86794e379f90135fcb03a71adb497634046d7bc9881e2623000000000000000000000000181142de6a3666ddd27bdac934011d6d8dc8ce710000000090283de0
0x1a44076050125825900e736c501f859c50fe728c	false	15	0x00030100110100000000000000000000000000030d40	13297348	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-02-13T14:24:43.000Z	0xe20be6b4a7067f95c4f83b40e08f52df673903843d9c5d7f2cb74c1f9887f007	0x01000000000000000600007647000000000000000000000000ecf21b335b41f9d5a89f6186a99c19a3c467871f0000766d0000000000000000000000002031c8848775a5efb7cff2a4edbe3f04c50a1478718657cc76c6b894f8db2e676083ae314de6002ea3150953969ff4b32e501cf4000000000000000000000000fdf2958561bc1197348539380065186e1f46e11d0000000002aea540

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_bob.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`	`NUMERIC`	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
743241	18638455010726	true	202857	{“fee”:{“nativeFee”:“18638455010726”,“lzTokenFee”:“0”},“guid”:“0x0f101830aa2aa847256fa396582717f6bc4482955d31422aa0817feaf2e31485”,“nonce”:“58”}	0x2637a450	{“dstEid”:“30184”,“message”:“0x0000000000000000000000006711f14a3b55f276b7fb8acbd8ef3db6e17b744d000000000001053b”,“options”:“0x000301001101000000000000000000000000000186a0”,“receiver”:“0x0000000000000000000000009ff7ea0cf94b8665c2f5d17560bd34ab9bbacd21”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	16708377	0x797964f9eb3a733d443810820f56c9ebaab1d1c2	1	2025-05-03T13:25:41.000Z	0xb8367b7faaffab0f914c06f108f6ffbc3a3109819a6ee4561adfe86c0f120bf7	0x6711f14a3b55f276b7fb8acbd8ef3db6e17b744d
340405	18236194370788	true	202857	{“fee”:{“nativeFee”:“18236194370788”,“lzTokenFee”:“0”},“guid”:“0x2557dd159f89df9b79a9ce241739ce3583ab1f849195089a157a1ee05639404a”,“nonce”:“59”}	0x2637a450	{“dstEid”:“30184”,“message”:“0x00000000000000000000000074b3bb13ee674428795877742148c97124ee7358000000000934735b”,“options”:“0x000301001101000000000000000000000000000186a0”,“receiver”:“0x0000000000000000000000009ff7ea0cf94b8665c2f5d17560bd34ab9bbacd21”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	16714290	0x797964f9eb3a733d443810820f56c9ebaab1d1c2	1	2025-05-03T16:42:47.000Z	0x306b8e76036513cd946a54b3342a195c149795a68438adee71b83753ab8443b6	0x74b3bb13ee674428795877742148c97124ee7358
338756	18549387599606	true	202857	{“fee”:{“nativeFee”:“18549387599606”,“lzTokenFee”:“0”},“guid”:“0x61537182e0308a2233220efe84a1dbbda5661c45029b7dcc39b6aa7494f2c9cd”,“nonce”:“57”}	0x2637a450	{“dstEid”:“30184”,“message”:“0x0000000000000000000000005a663235c02e7f3461a2f77fc8105bfdc78f23370000000000009c40”,“options”:“0x000301001101000000000000000000000000000186a0”,“receiver”:“0x0000000000000000000000009ff7ea0cf94b8665c2f5d17560bd34ab9bbacd21”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	16695727	0x797964f9eb3a733d443810820f56c9ebaab1d1c2	1	2025-05-03T06:24:01.000Z	0x412093dcf97747a29a9f0788628d73dbe5011f2908d6997b6cc8568c1939afd8	0x5a663235c02e7f3461a2f77fc8105bfdc78f2337

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_bob.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
0xecf21b335b41f9d5a89f6186a99c19a3c467871f	0x7befe65cd1144b79ac8dcf496a9e1387d4b31d47323bb5cf54156bd39cd54530	false	30102	1	20835213	0xa0398420c7d9ce91db7a3298fb0ae24f620e3ab2	2025-08-07T02:06:53.000Z	0x8f923b69acda2c6ee436f2205390e9f44bc182194a5f789d1dbf4f1ea72a4785	15210000000000000000
0xecf21b335b41f9d5a89f6186a99c19a3c467871f	0x6a360e731ca64a45a87e62ca63d6cd81d0d08fe633b09bc72aa6908428cd21c7	false	30102	1	20845775	0xc7dcd552e40939ceb2c36b36726192c56bc1c875	2025-08-07T07:58:57.000Z	0x9ac2c046619b4419d32640b0bb5578bfd79055c0c3c1d163d9fe2fe4a7b0deed	20288011000000000000
0xecf21b335b41f9d5a89f6186a99c19a3c467871f	0xd2490b5512513195003a1adb0e2e46c2b3e38a4c530b4dc201441aaa1ff8996b	false	30102	1	20847170	0xdeb2945798cf1939de6610d941d2506f130a75b6	2025-08-07T08:45:27.000Z	0x5d2a2beda97fa327eba3e05e86cf7c03e6cd3c5a47a267e2b82cbc467ed446ca	500000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_bob.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
0x797964f9eb3a733d443810820f56c9ebaab1d1c2	0x27fbd24f9300dee841cc2794cfab3c03185f4372d71e8601f36fbf202faa8ebb	false	30184	4	17390011	0xcae11f36afb6ef51d68917f865362623ff1231c8	2025-05-19T08:06:49.000Z	2636062000000000000	0x407184c428cde10702c460c38bfc8832e0b7f0390eff000a97b5ebe03f304de8	2636062000000000000
0x797964f9eb3a733d443810820f56c9ebaab1d1c2	0x7af812afba79f95024fc0e6767c2437c35ebac4c18761b9076bd1c0e24865ed1	false	30184	4	17375910	0xd240a9de14e78e9bd709ddca51f3a0063a96780d	2025-05-19T00:16:47.000Z	4000000000000000	0x093ec2f804949ed8f468b6268763a347a588757d11b20f24646f51ed413345b5	4000000000000000
0x3d63825b0d8669307366e6c8202f656b9e91d368	0x5e66c1ae1baadc3b6405aad447c7a2725f8f952a2a60458338e941c04cd9fad1	false	30362	4	17410012	0x181142de6a3666ddd27bdac934011d6d8dc8ce71	2025-05-19T19:13:31.000Z	111000000	0x00496d5b08bc9d8d9a2687a6ac3e44f4cd1667b9be2405d5a9dee5518dec4d3c	111000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_bob.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
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	[“463810714272”,“458239937184”]	false	2	14861707	2025-03-21T19:30:01.000Z	[]	[“0x6788f52439aca6bff597d3eec2dc9a44b8fee842”,“0xdd7b5e1db4aafd5c8ec3b764efb8ed265aa5445b”]	0x01765a12b0d4d29dfb190685b770854ad0c1727857a84faf8e45c405bc609ad0
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	[“33086143178672”]	false	3	14856478	2025-03-21T16:35:43.000Z	[]	[“0x6788f52439aca6bff597d3eec2dc9a44b8fee842”]	0x1fe732f77ef4c61bd0359ecf9f0e626f65a7ca4db8cd2e46871616c66b230fe2
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	[“34756185602350”,“34536838804347”,“34756185602350”]	false	2	16758971	2025-05-04T17:32:09.000Z	[]	[“0x6788f52439aca6bff597d3eec2dc9a44b8fee842”,“0xdd7b5e1db4aafd5c8ec3b764efb8ed265aa5445b”,“0xf2067660520f79eb7a8326dc1266dce0167d64e7”]	0x26ea86b968f4a13f2c979eb5e6198c50bd0b09cb0361d45600409daa55f59a3d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_bob.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
16196771473866	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	1	0xc097ab8cd7b053326dfe9fb3e3a31a0cce3b526f	15066865	2025-03-26T13:28:37.000Z	0x6e74bb5d3a2eebaec8c5a2f87233d3bf472fc42680030becdd331a0761f17fb3
16338577785786	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	1	0xc097ab8cd7b053326dfe9fb3e3a31a0cce3b526f	15085301	2025-03-26T23:43:09.000Z	0x3a2ca7ed4254d1c2dd41c296cef65e5e3fb2cf5a31244ad0f090c230b5b1ba39
16427457576786	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	1	0xc097ab8cd7b053326dfe9fb3e3a31a0cce3b526f	15043020	2025-03-26T00:13:47.000Z	0xd7d635eb61fb6254c36c2b802198d07283a2efe3b82e34231c2c23d3b1e28946

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_bob.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	in_receiver	block_number	block_timestamp	transaction_hash
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	6000325769126	0xc097ab8cd7b053326dfe9fb3e3a31a0cce3b526f	0xe93685f3bba03016f02bd1828badd6195988d950	6272274	2024-09-03T23:35:35.000Z	0x02ac299653bf96262498563593c68f1e2e285dcbc331ba3dc8dc863b21b99051
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	28053747672131	0x6788f52439aca6bff597d3eec2dc9a44b8fee842	0xb8ff877ed78ba520ece21b1de7843a8a57ca47cb	11711871	2025-01-07T21:35:29.000Z	0xd915ae8601010c4aa12b4c1e156d0204758f9b9634000f0142243b1947361411
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	375140381616717	0xc097ab8cd7b053326dfe9fb3e3a31a0cce3b526f	0xe93685f3bba03016f02bd1828badd6195988d950	11711735	2025-01-07T21:30:57.000Z	0xe6bb7d4cce1ab76d8a7449b0bc9856388b1920a8565ea5759251a35fa72cd033

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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