layerzero_v2_zksyncera

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
0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	false	{“nonce”:“403”,“sender”:“0x00000000000000000000000096b6aae5cdc5b6d2e1ac2efc46162402f5a868b1”,“srcEid”:“30101”}	3	0x8b73bb0557c151daa39b6ff556e281e445b296d5	61778441	2025-06-16T12:29:59.000Z	0x5fa71f149991d47adc9f41ec2822e91d9c1d03e9314dbdeb61eb022f04dbcc1e
0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	false	{“nonce”:“402”,“sender”:“0x00000000000000000000000096b6aae5cdc5b6d2e1ac2efc46162402f5a868b1”,“srcEid”:“30101”}	3	0x8b73bb0557c151daa39b6ff556e281e445b296d5	61759621	2025-06-16T00:29:55.000Z	0x1c6e67afc4c30cdcc66ab9048e087347b20444dbda2f0163afca6b9cb508af93
0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	false	{“nonce”:“20”,“sender”:“0x0000000000000000000000005d3a1ff2b6bab83b63cd9ad0787074081a52ef34”,“srcEid”:“30183”}	4	0x39fe7a0dacce31bd90418e3e659fb0b5f0b3db0d	61773238	2025-06-16T09:09:23.000Z	0x27aac970e2e7ae7221455adff7f5346a48c695dff942fedc5dd18a7041b3a632

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_zksyncera.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
0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	false	10	0x0003010011010000000000000000000000000000fde8010011010000000000000000000000000000fde8	60408470	0x07fd0e370b49919ca8da0ce842b8177263c0e12c	2025-05-14T14:21:19.000Z	0x262d2e34fabbc86496b1173b9f4fb2f478103ad5d75687b269e2cd81d53a5541	0x0100000000000000c0000075d50000000000000000000000000469d9d1de0ee58fa1153ef00836b9bbcb84c0b60000767e000000000000000000000000c1aa99c3881b26901af70738a7c217dc32536d3629841a9d706b68a8809036c1af0e7bcd7838c25c5f5f0f2249f1bb8bc543f95e0000000000000000000000005abf94199d5121fd304656bca1492458c9ade09000000000002dc6c0
0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	false	11	0x0003010011010000000000000000000000000000fde8010011010000000000000000000000000000fde8	60408482	0x07fd0e370b49919ca8da0ce842b8177263c0e12c	2025-05-14T14:21:32.000Z	0xe6fc83b828a290b74269dc8126bb76a93d2971c6fd52a933d2bc283796891fc6	0x0100000000000000c1000075d50000000000000000000000000469d9d1de0ee58fa1153ef00836b9bbcb84c0b60000767e000000000000000000000000c1aa99c3881b26901af70738a7c217dc32536d36005da3963c29a070c218a299809bbe2bc9f384a4b256549177bd778ac464035e0000000000000000000000005abf94199d5121fd304656bca1492458c9ade090000000000007a120
0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	false	7	0x00030100110100000000000000000000000000013880	60422190	0x07fd0e370b49919ca8da0ce842b8177263c0e12c	2025-05-14T20:03:18.000Z	0x38e8ec6ae213f8a5c78da8db9be488d174d9dd0d34000cfc9b96530a53b59cc6	0x010000000000000016000075d500000000000000000000000039fe7a0dacce31bd90418e3e659fb0b5f0b3db0d0000759f0000000000000000000000005d3a1ff2b6bab83b63cd9ad0787074081a52ef34b656a7b009acab1395bfddf1144ae52c1c7937654cea1b6efd0f3a85dfb2b5a70000000000000000000000008e87bfa242881710c9e68190e522d90db514faa2000000001a354848

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_zksyncera.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
406626	42106618882199	true	132378	{“fee”:{“nativeFee”:“42106618882199”,“lzTokenFee”:“0”},“guid”:“0xecbecff43ab07328285aa8c4e2e11e4dc6743cb93e356fcae47c0040e7a398d8”,“nonce”:“1”}	0x2637a450	{“dstEid”:“30332”,“message”:“0x0000000000000000000000004bc9b68c77a9cd6071a21c6d9d4ae7f2ee92196000000000000f4240”,“options”:“0x00030100110100000000000000000000000000030d40”,“receiver”:“0x000000000000000000000000123468b48eadbc13c65cd9c66a9913cde4e94321”,“payInLzToken”:false}	0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	61528235	0x8bced94e69d611478c4c26e2582e83a80290af57	19,0,1,8,1	2025-06-10T10:54:18.000Z	0xf850d9bdda887601af1253036ca4a24a7a441e18c94380b2d13e0f6d39eb8ba2	0x4bc9b68c77a9cd6071a21c6d9d4ae7f2ee921960
406791	42106618882199	true	224282	{“fee”:{“nativeFee”:“42106618882199”,“lzTokenFee”:“0”},“guid”:“0xa12aa641dc24035a02c05d2d07eecd7d7ecacf8d756fd244475f55c54b17c0d6”,“nonce”:“1”}	0x2637a450	{“dstEid”:“30332”,“message”:“0x0000000000000000000000004bc9b68c77a9cd6071a21c6d9d4ae7f2ee92196000000000000f4240”,“options”:“0x00030100110100000000000000000000000000030d40”,“receiver”:“0x000000000000000000000000513ac02371110353758783e395fc056380ffddd2”,“payInLzToken”:false}	0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	61525355	0x8bced94e69d611478c4c26e2582e83a80290af57	19,0,1,8,1	2025-06-10T09:03:43.000Z	0xba601cff061875fc15c6ab2dbdf1c64e474417fce246b81a015ed2e9d7f17df0	0x4bc9b68c77a9cd6071a21c6d9d4ae7f2ee921960
421557	7444643935400	true	119088	{“fee”:{“nativeFee”:“7444643935400”,“lzTokenFee”:“0”},“guid”:“0xbbf3de2ddda9ccc21085d381defffafc83c35a321002fea0d93dd55403f9ead7”,“nonce”:“1297”}	0x2637a450	{“dstEid”:“30362”,“message”:“0x000000000000000000000000708e3c5914dcdfa29988ccc28302896ae9df8d8000000000002ee730”,“options”:“0x000301001101000000000000000000000000000249f0”,“receiver”:“0x00000000000000000000000099c24cf8253be59f067a2902c4ea9a0e8e02cd41”,“payInLzToken”:false}	0xd07c30af3ff30d96bdc9c6044958230eb797ddbf	61535346	0x800cc21f905e224537e491fe169a781c4088e929	20,0,1,0,14,1	2025-06-10T14:08:24.000Z	0x24ef0069a879737a8c22c4c8542a4f641617e71e33adc7371e43a9b9109ae85e	0x708e3c5914dcdfa29988ccc28302896ae9df8d80

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_zksyncera.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
0x0469d9d1de0ee58fa1153ef00836b9bbcb84c0b6	0x2b64a88fbbf3ddd827ba16a842630cd46d0bb33f902b6becba1395b55a271b74	false	30334	3	54905861	0xac3a89ea9da567e86e97fee815b90b804dd2fc55	2025-01-30T18:38:06.000Z	0x728bfa3fa5be02a6c42d35e2e199b52b5b89faf67fce105e68db288b180d371a	10454700000000000000
0xb0588f9a9cade7cd5f194a5fe77acd6a58250f82	0x9e376bb87d8a66d6f91522113f43945dab56007fcdc335b1e410699d34198bda	false	30109	3	54853748	0x7501f3387b6ea5c4bcf983a990e9757baaba792b	2025-01-30T00:45:01.000Z	0xad58d2753e29bc259f26dc0af83c6c48f1dc00153a59d086194c0cee158ff26a	82227000000000000000000
0xb0588f9a9cade7cd5f194a5fe77acd6a58250f82	0x59f06e596cb0ba3e8704260031358901c3a409e63bdfcc89f9adc9952d6fc807	false	30109	3	54916936	0x7501f3387b6ea5c4bcf983a990e9757baaba792b	2025-01-30T22:45:43.000Z	0x759a0613d9d2cf3e985dd6ce7a251c38a7c29e9c69d54501bfe8991a6ee4d4b2	83362000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_zksyncera.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
0x6be2425c381eb034045b527780d2bf4e21ab7236	0x30a5020ae8cd7aeac246595313366a776a17896b7b2fee36a610d12fe15433e0	false	30101	9	53872997	0x8574c91d7c27a0f85c2000e588d1dc7ca000d8df	2025-01-17T06:13:58.000Z	2533100000000000000	0x7d7b613fbc55fa736c6b298c83838f0b1ffcf9f1a00f83b6b54fabd596e3634f	2533100000000000000
0xc1fa6e2e8667d9be0ca938a54c7e0285e9df924a	0xe6f36e12f6d90a36236efe69fea2a558c364f4cf1d732b1938a6656cf5a88952	false	30184	9	53928591	0x67b00d6dae6316a8099578b4f13d6c2a214e1b31	2025-01-17T23:20:22.000Z	564238000000000000	0xacf0354e06d7f4c0556cef5bc38f3843c5a8035d8c6309a820342528756dd682	564238000000000000
0xc1fa6e2e8667d9be0ca938a54c7e0285e9df924a	0x60406cc329ec925ec30e9243c9a64a52d4c1eaa2904928d6bb987f7ec56883b1	false	30184	9	53893077	0x9efbf5ac668d11dea60f0cbb20fbd237bf4cc918	2025-01-17T12:04:13.000Z	94522000000000000	0xfac39fdda8cac084faec1f6515f2f6e9b0ed31549d28240115a5644a8c7d1318	94522000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_zksyncera.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
0x07fd0e370b49919ca8da0ce842b8177263c0e12c	[“83475770284”,“83475770284”]	false	6	59503098	2025-04-23T11:59:36.000Z	[]	[“0x1253e268bc04bb43cb96d2f7ee858b8a1433cf6d”,“0x620a9df73d2f1015ea75aea1067227f9013f5c51”]	0xf08e278373c9119043c997fb21d4c19ce1ee46e10132e3cc111b5ef15ed73c93
0x07fd0e370b49919ca8da0ce842b8177263c0e12c	[“27201724796160”,“26875008011520”]	false	6	59498360	2025-04-23T08:51:53.000Z	[]	[“0x620a9df73d2f1015ea75aea1067227f9013f5c51”,“0xb183c2b91cf76cad13602b32ada2fd273f19009c”]	0xc1ec3ee28713d9803fbf24d414cc88ac5ff15a80eac556cd0b48fcd81c8d691b
0x07fd0e370b49919ca8da0ce842b8177263c0e12c	[“102344644435”,“102344644435”]	false	6	59499425	2025-04-23T09:38:24.000Z	[]	[“0x1253e268bc04bb43cb96d2f7ee858b8a1433cf6d”,“0x620a9df73d2f1015ea75aea1067227f9013f5c51”]	0xd54d32340ad7cc32a1c3e0e75d62284fd57112b7dab23dd2069b547d606fe4ba

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_zksyncera.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
28088922591689	0x07fd0e370b49919ca8da0ce842b8177263c0e12c	false	5	0x664e390e672a811c12091db8426cbb7d68d5d8a6	57703934	2025-03-15T12:06:34.000Z	0x2a6adf5f420e0bb492f378778dd72cec3a1fe5125eb9c9112348a2ebfaba3f45
238653309053819	0x07fd0e370b49919ca8da0ce842b8177263c0e12c	false	5	0x664e390e672a811c12091db8426cbb7d68d5d8a6	57681878	2025-03-15T02:54:10.000Z	0xff05455a566d7cff0dbb1aa0179c205934043b428d3ee8d4c66211c60c1e8d09
27970380079249	0x07fd0e370b49919ca8da0ce842b8177263c0e12c	false	5	0x664e390e672a811c12091db8426cbb7d68d5d8a6	57681595	2025-03-15T02:46:50.000Z	0x8e0259e6e891af5798e60a64563086081ba6ea24a3136dac7ff8dea6a20c56bb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_zksyncera.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
0x07fd0e370b49919ca8da0ce842b8177263c0e12c	false	1517734621876043	0x664e390e672a811c12091db8426cbb7d68d5d8a6	51	0xe93685f3bba03016f02bd1828badd6195988d950	30099839	2024-03-28T18:40:22.000Z	0xa5b0409dbf48ebe58f373d0e44fb7fec28033e518cc3570ad7d1d69d136ad89e
0x07fd0e370b49919ca8da0ce842b8177263c0e12c	false	258195689508511446	0x664e390e672a811c12091db8426cbb7d68d5d8a6	11	0xe93685f3bba03016f02bd1828badd6195988d950	43339338	2024-09-03T23:35:30.000Z	0xc4b1969160b022c90485ac32f0d4a1e4b16cd0504a223e4ea2b90da21d49d7be
0x07fd0e370b49919ca8da0ce842b8177263c0e12c	false	319517933093506578	0x664e390e672a811c12091db8426cbb7d68d5d8a6	3	0xe93685f3bba03016f02bd1828badd6195988d950	58281672	2025-03-27T16:58:25.000Z	0xf0cc3e7b3c02c69f9f38b9355051d11c05638673f09ce22c8985d56097f235df

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_zksyncera.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
0xda84dee0e3249e73266558a9fa2f889ffbf89b14	0xb5d05f59ef9957da3253b1bcafa51ec8c67f7295bc18a7b1bd9942a1b600a3fa	false	30110	8	34679131	2024-05-23T01:23:21.000Z	3	0	0x9840b2cafa3ae54351665b1ec3cced5eddfc1764782d6268c21775d676f0ffb0

Example Query

Query with partition filter

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