layerzero_v2_unichain

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
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	{“nonce”:“117”,“sender”:“0x00000000000000000000000012dc9256acc9895b076f6638d628382881e62cee”,“srcEid”:“30184”}	39	0xaf368c91793cb22739386dfcbbb2f1a9e4bcbebf	15970821	2025-05-08T15:46:20.000Z	0x09cd6b7db8e179c8f7c9679d704344b1c4dd6bd4046c9ec4805c18361a6f2ac0
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	{“nonce”:“109”,“sender”:“0x00000000000000000000000012dc9256acc9895b076f6638d628382881e62cee”,“srcEid”:“30184”}	39	0xaf368c91793cb22739386dfcbbb2f1a9e4bcbebf	15927296	2025-05-08T03:40:55.000Z	0x9b1f1e3bf66aa4bfde44d3f4c92fdfed6dd437721e164554df435e657baba422
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	{“nonce”:“27”,“sender”:“0x00000000000000000000000013379b489fb2e76cedf96bceaa2441e5930d75e1”,“srcEid”:“30280”}	32	0xaf368c91793cb22739386dfcbbb2f1a9e4bcbebf	15952185	2025-05-08T10:35:44.000Z	0xf0fc2e4f7c7b8574915953802bc16bdca7cff8b0d1e76ba1e19d919d2f4a5b2d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_unichain.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
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	2	0x00030100110100000000000000000000000000009470010011010000000000000000000000000000ea60	11358734	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-03-16T06:38:13.000Z	0xcfe7672da2013e6bb9d86d164bbfda7ca70e22b0b8f0e40230e82bee856ef9aa	0x01000000000000000e00007670000000000000000000000000b1eead6959cb5bb9b20417d6689922523b2b86c30000764c0000000000000000000000001c10cc06dc6d35970d1d53b2a23c76ef370d4135c59ba29a36cfc4bdbb78c9b36b879164650a9cdf6566e8fc27b7fa40e4393f9e02000000000000000000000000000000000000000000000000002386f26fc10000000d000000000000000000000000cf791eb0c1cc0454db6b1b94038189c3ef43eb4f00000000000026ac00
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	2	0x00030100110100000000000000000000000000009470010011010000000000000000000000000000ea60	11343010	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-03-16T02:16:09.000Z	0x4b3e8d5c33cae7d9bd08f43e9f96a644315a2398481e3012f3310a9a7c79f5ac	0x01000000000000017f00007670000000000000000000000000b1eead6959cb5bb9b20417d6689922523b2b86c300007674000000000000000000000000183d6b82680189bb4db826f739cdc9527d467b25bdc255b3c365e236c723a28caf3ea5df2e680dbd42aaf42fe4fba7280e88faa5020000000000000000000000000000000000000000000000000002d79883d20000000d000000000000000000000000836aa96728a55cc77a4a642d3671fd23aa2c2dc000000000000003e600
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	2	0x00030100110100000000000000000000000000009470010011010000000000000000000000000000ea60	11414219	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-03-16T22:02:58.000Z	0x97f6bc78344fc5e1bc0cb5da99a9f0216f34c4bdaf3db7c5af9a5c8fabaa2e51	0x0100000000000001ba00007670000000000000000000000000b1eead6959cb5bb9b20417d6689922523b2b86c3000075e70000000000000000000000005f688f563dc16590e570f97b542fa87931af2fed21029dd544f99138163287afd0488a61ac514ab0e5d67e73d6be1728d1f52f200200000000000000000000000000000000000000000000000000002d79883d2000000d000000000000000000000000f1407b515baddebaffc449a64be2a769fb25b64a00000000000023ef00

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_unichain.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	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
363763	17215090135800	false	202782	0x2637a450	0x6f475642a6e85809b1c36fa62763669b1b48dd5b	27194259	0xc07be8994d035631c36fb4a89c918cefb2f03ec3	0,1	2025-09-15T13:23:38.000Z	0x7c99764ad05be7580d13e3e21c7c784dddac49e38b2852a962a263c3a20a0e4d
339572	13905741928720	false	195137	0x2637a450	0x6f475642a6e85809b1c36fa62763669b1b48dd5b	27215257	0xb1eead6959cb5bb9b20417d6689922523b2b86c3	0,1,1,0	2025-09-15T19:13:36.000Z	0x9786ec101670a6df7106e5971a1da2a51421619404c937ee0773615d1d15b49d
207166	13905741928720	false	195137	0x2637a450	0x6f475642a6e85809b1c36fa62763669b1b48dd5b	27215257	0xb1eead6959cb5bb9b20417d6689922523b2b86c3	1,0	2025-09-15T19:13:36.000Z	0x21f18b25d8d3822d72f3eb9f9900f72bd5b176cade899f259827e64b9fad08a5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_unichain.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	block_number	in_toAddress	block_timestamp	transaction_hash	in_amountReceivedLD
0xe9aba835f813ca05e50a6c0ce65d0d74390f7de7	0x2a1de684ea6bd04b0cad5613037866ce960d0f69be5026b0a33c21c6aa9fed85	false	30101	14669933	0x38bc33ad9d9f4e922035a46e1c4088bf7610116f	2025-04-23T14:24:52.000Z	0x2648da47fedf9e2f4134f68229d4442e98abd067b51d3d78274cf7a90d33935e	619000000000000
0xe9aba835f813ca05e50a6c0ce65d0d74390f7de7	0x0bed955294fb757fa5d2bf21e5f81877b426392d5352af55028f73891d49919b	false	30101	14635444	0x56bb1b054f441e068b986a179d3c047c45f5a94e	2025-04-23T04:50:03.000Z	0xfde066984f4cd7192e1f58d5e96e2115e810b1d805721165691086857b10b9fa	499000000000000
0xe9aba835f813ca05e50a6c0ce65d0d74390f7de7	0x64243b13cdb0e664dcb37d360199b5563ce3fb37227798b9a536a211e6238018	false	30101	14631041	0x98b0ed51e04024bb81863a98ce0d78be7bca93cc	2025-04-23T03:36:40.000Z	0xa6e3c8786b0c6e2880866b3503df6e3131533c897fb42754575fe0ccede48792	1999000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_unichain.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
0xe9aba835f813ca05e50a6c0ce65d0d74390f7de7	0x0bc6414880ab274a80a6fd2ae941590fe3f98cd77af919958939451c90050cc7	false	30101	4	12116579	0x82ebcc13feec6f52994a813193d02d4e83868cac	2025-03-25T01:08:58.000Z	10350000000000000	0x19bf5171c831d3c0df892cf184914bbd4c73f06cabe2397c64f57a4536c5d1b9	10345000000000000
0xe9aba835f813ca05e50a6c0ce65d0d74390f7de7	0x1ccc20787ba0d9f2db5006b24b7a25f2db549dfcbfc302f0d20579f7ab9c3706	false	30101	13	12161742	0x9ee2744b39c2ea731c109f4b5ba50e19621148a8	2025-03-25T13:41:41.000Z	11000000000000000	0x90194e74531ed209a54fa0ba78164ee7571151cb9c2e11ca7a7954d9790f1327	10996000000000000
0xe9aba835f813ca05e50a6c0ce65d0d74390f7de7	0x0000000000000000000000000000000000000000000000000000000000000000	false	30101	2	12165554	0xa1dafb71b030583f93682161c28e5b5f51bd55b7	2025-03-25T14:45:13.000Z	22000000000000000	0xa73c81c89cee040e120dbb7600d35e6db99707466e38cef0bb6ff912fefc9891	21993000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_unichain.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	[“105828431529”,“105828431529”]	false	1	17204624	2025-05-22T22:29:43.000Z	[]	[“0x25e0e650a78e6304a3983fc4b7ffc6544b1beea6”,“0x9885110b909e88bb94f7f767a68ec2558b2afa73”]	0x99e1452221b3c88d8a0921d759415ea4cfba2100b57883dd39e9f292d67c6672
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	[“49377107020”,“49377107020”]	false	1	17206154	2025-05-22T22:55:13.000Z	[]	[“0x25e0e650a78e6304a3983fc4b7ffc6544b1beea6”,“0x9885110b909e88bb94f7f767a68ec2558b2afa73”]	0xb14226ac1e7295f01ef20ae5c29513429fc098f2ab8b65b57504232de78ff4b4
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	[“80554669843”,“80554669843”]	false	1	17168637	2025-05-22T12:29:56.000Z	[]	[“0x25e0e650a78e6304a3983fc4b7ffc6544b1beea6”,“0x9885110b909e88bb94f7f767a68ec2558b2afa73”]	0xbddbd8f3a1e1fd3f2d7ea72c0facd2921c3c6ada98dcd13a9c9dff7424985f1e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_unichain.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
21248941078790	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	20756635	2025-07-03T01:09:54.000Z	0xb8c670a362b9928ac189d84634fed430228423fcd2b93b59a51b1768d5b5fcd5
22447421323150	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	20805786	2025-07-03T14:49:05.000Z	0x02c0eef4fd118b165ca8091aab1dbf7f36785dd1e85f0270cf15b1d9800f2faa
147664911495049	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	20779880	2025-07-03T07:37:19.000Z	0x05d1d0ec71cf40e859e379c0b8b1d4740696265ca48a36060828bee46510f88a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_unichain.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	1000000000000000000	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	0xe93685f3bba03016f02bd1828badd6195988d950	14169336	2025-04-17T19:21:35.000Z	0x8b297191480dfc181a601cdbb8a5f0aa5fcf26179db9155fce127338475ca3aa
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	50540000000000000	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	0xe93685f3bba03016f02bd1828badd6195988d950	14185829	2025-04-17T23:56:28.000Z	0x9c91b960ea5b72caff261f26100442322c2eb79d35eaae9b5f6a6990244b35af
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	498806363293730624	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	0xe93685f3bba03016f02bd1828badd6195988d950	12346348	2025-03-27T16:58:27.000Z	0x906b5b9bdf36784a64b7e27dafd285a7974f8b949a34ba9d8e9f215b0cf0a001

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_unichain.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
0xb1eead6959cb5bb9b20417d6689922523b2b86c3	0xb9fc35fb64dadf0520e48ec0b411ef5d398f03bccf5ffbb789751e86e74de632	false	30101	12	9561217	2025-02-23T11:19:36.000Z	1	49	0x15d931b931397f3fa8a1deb5e73b453de6905ca84d19fbc2fc6dd7ec4bae7e96
0xb1eead6959cb5bb9b20417d6689922523b2b86c3	0xb573cc74ac3deba1967796d15e2829b02efb6e56d8cb30c7993e3f05b0a4d73e	false	30101	3	9546750	2025-02-23T07:18:29.000Z	1	48	0x44c4d1c2e6101c6c7584eac402acbe2a091392fd7bf5e4710e3840f2bc55e921
0xb1eead6959cb5bb9b20417d6689922523b2b86c3	0x5b940b930597a2f3be4c21e25209a1067fe1fc329eb9747452ee209521871f19	false	30101	3	9566068	2025-02-23T12:40:27.000Z	1	51	0x429a3d750c7dac7e0de1e84a27ef8b9ccab9e4b4b47a6105857f615fb26184e8

Example Query

Query with partition filter

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