layerzero_v2_sonic

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”:“1”,“sender”:“0x00000000000000000000000093e478f428a070ecf11d79cdd6a60f3dee3a92da”,“srcEid”:“30112”}	1	0x4a4988daecaad326aec386e70fb0e6e6af5bda1a	1249850	2024-12-22T23:17:41.000Z	0x176053a7a4e5a15968ee8acf7c3866e1a0acc0e0bfce16201525ad1fcd3ffac4
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	{“nonce”:“99”,“sender”:“0x000000000000000000000000b336ae7d702b2afd75ef8c904cab3d730bc8512c”,“srcEid”:“30112”}	2	0x50bc6e1dff8039a4b967c1bf507ba5ea13fa18b6	1115430	2024-12-22T02:01:38.000Z	0x762fa2e37a0052dc9d755bef2c30ab0a6f8d7d73e2198d1ce034f7d43bc3583f
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	{“nonce”:“102”,“sender”:“0x000000000000000000000000b336ae7d702b2afd75ef8c904cab3d730bc8512c”,“srcEid”:“30112”}	2	0x50bc6e1dff8039a4b967c1bf507ba5ea13fa18b6	1186855	2024-12-22T13:15:25.000Z	0x60d053f09f327ce43ee3062faeac660e62393c17159cf6710dd7adffb691d1cf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_sonic.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	297	0x00030100110100000000000000000000000000009470010011010000000000000000000000000000ea60	35351600	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-06-22T15:01:44.000Z	0xab577dce0d484cfb82d913427b3b80acea7cf49e86c59679a3ef4265562cafac	0x0100000000000007f70000767c0000000000000000000000002086f755a6d9254045c257ea3d382ef854849b0f000075950000000000000000000000006d6620efa72948c5f68a3c8646d58c00d3f4a9805dd6de52c6db11453e7d5389b65f224574e2dffa5a31a98b5686f7d83eefa61502000000000000000000000000000000000000000000000000000eebe0b40e80000001000000000000000000000000984ab9407abf0a07d56adcfd5b1369426a13c6710000000253b0567f00
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	129	0x00030100110100000000000000000000000000009c400100110100000000000000000000000000009c40	35385711	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-06-22T20:00:15.000Z	0xddaefe08cdfe786e0c24c2f082796378eb282a7c9c0d04279eea658b336673b5	0x0100000000000000240000767c0000000000000000000000003a1293bdb83bbbdd5ebf4fac96605ad2021bbc0f0000766800000000000000000000000099e799cbd972362a84145d98498db4430a66a734ef371c6e2678c03a361fbc88f079510a561081746e90dcdb0b14e2a298d4abda010001010000767c000000000001254a
0x6f475642a6e85809b1c36fa62763669b1b48dd5b	false	265	0x00030100110100000000000000000000000000009c400100110100000000000000000000000000009c40	35375535	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	2025-06-22T18:20:13.000Z	0x5d005fa1f30a3f31b055d6f7b33a100826e0557d2c35ee7720f5989e6ad07c29	0x01000000000000000c0000767c0000000000000000000000003a1293bdb83bbbdd5ebf4fac96605ad2021bbc0f000076a1000000000000000000000000c7616b08ffec8b4ba47188bfd1a814316f3e3d79798b182875e0aed89778133ad240fae9c51e54d52700f15302d08334cbce557501000101000075e5000000000060c8a5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_sonic.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
112278	805887351908354000	true	109208	{“fee”:{“nativeFee”:“805887351908354099”,“lzTokenFee”:“0”},“guid”:“0x4087176feacc588e1d81ded73fcbc5670781781aa3d12d6d39f22d80dc11f2de”,“nonce”:“15”}	0x2637a450	{“dstEid”:“30101”,“message”:“0x00000000000000000d7b132e664d8f8f2417f52cbbf5bd82ba82eefc58a87f07”,“options”:“0x000301001101000000000000000000000000000186a0”,“receiver”:“0x000000000000000000000000ace7defe3b94554f0704d8d00f69f273a0cff079”,“payInLzToken”:false}	0x6f475642a6e85809b1c36fa62763669b1b48dd5b	18821126	0xace7defe3b94554f0704d8d00f69f273a0cff079	3	2025-04-07T22:46:46.000Z	0x7a71d4748b12ae04c93a64d9856aaa6279291e7405efab2609f3529613d96140	0x664d8f8f2417f52cbbf5bd82ba82eefc58a87f07
166763	42873604379747850	true	164786	{“fee”:{“nativeFee”:“42873604379747848”,“lzTokenFee”:“0”},“guid”:“0xebe061ab139d0d5af57f864f5a5880b2b07eea4373f356d1df7919296a9425d2”,“nonce”:“59”}	0x2637a450	{“dstEid”:“30284”,“message”:“0x000000000000000000000000af1ee1415b3c58b8d5a2dfeafda5176d2c158bee00000001c620b6c0”,“options”:“0x0003010011010000000000000000000000000007a120”,“receiver”:“0x000000000000000000000000b6258ef0287a06de0d4d8caabeeb24343ba2db5f”,“payInLzToken”:false}	0x6f475642a6e85809b1c36fa62763669b1b48dd5b	18656279	0x57223d89fe4c8c52023d06e7d30ad10cc441f84e	0	2025-04-07T05:56:19.000Z	0xc40f2960f9e7cf67bc5fac7ff9f01403466a1383477dc6fbc432125c4efcaa4a	0xaf1ee1415b3c58b8d5a2dfeafda5176d2c158bee
166763	42648374097897820	true	164786	{“fee”:{“nativeFee”:“42648374097897825”,“lzTokenFee”:“0”},“guid”:“0x339f03a71f815f2b20ad89d10308b80d77c574b0b61e4cb57ff9406597ef5a1a”,“nonce”:“60”}	0x2637a450	{“dstEid”:“30284”,“message”:“0x000000000000000000000000af1ee1415b3c58b8d5a2dfeafda5176d2c158bee00000001b70c3d80”,“options”:“0x0003010011010000000000000000000000000007a120”,“receiver”:“0x000000000000000000000000b6258ef0287a06de0d4d8caabeeb24343ba2db5f”,“payInLzToken”:false}	0x6f475642a6e85809b1c36fa62763669b1b48dd5b	18705648	0x57223d89fe4c8c52023d06e7d30ad10cc441f84e	0	2025-04-07T10:43:12.000Z	0xde709878989d22b7aefab247ab90e3d838a4af40b41590a6b72d99febc02b1ac	0xaf1ee1415b3c58b8d5a2dfeafda5176d2c158bee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_sonic.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
0xc2c08bef6c3659018aff49917a8cbe551a1decaa	0x99764cda90743c3b0320fd739d7515c1367604447b0d9146b952c6030016572c	false	30168	0	36343836	0x22a7d54004d6d570bed319a041f02b0f26c540a8	2025-06-28T17:56:34.000Z	0xa0fbec598a4403a3c635dee8c91687d211357bd645fed3d50332c49b87f43d69	20000000000000000
0xa272ffe20cffe769cdfc4b63088dcd2c82a2d8f9	0xae5ac7c338eafe1daa2ece35b9c17260f21adba7ab6e280d9822abf07f094a25	false	30101	1	36339757	0x8703bdb1b413060a13c2f4712a30adc86b34f7ce	2025-06-28T17:12:16.000Z	0x3855eff24a444ee812614fe3440ad6e5beb95af6fec43839d89571d3a7b81c61	5842711359
0x31aa74232a0b0e50e5bf95780b2116710a34c7e9	0x343adb157802d350a382455b138f088b4820e55e16f39d321481dfbdc1f58458	false	30101	1	36335918	0xc66f2bf012061173afd4643e0a312bfeb0680699	2025-06-28T16:29:54.000Z	0x310534ef6223b82df5a844300690d491f578975a22dd07ed8fc468dab71f179d	227104775000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_sonic.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
0x79bbf4508b1391af3a0f4b30bb5fc4aa9ab0e07c	0xdc4cb1aa03431e98e770c6736c10e1b856329c2821c0d16bdbe599be32f9141c	false	30101	4	4555459	0x28928f2fe543a96101c5192f1268cb9b333172ae	2025-01-19T15:47:36.000Z	1000000000000000000000	0x42681d919e691a2ddba81986143da7a31616a28f987153f7c48c3a0ae82eeca3	1000000000000000000000
0x79bbf4508b1391af3a0f4b30bb5fc4aa9ab0e07c	0x128e0e924fcc2de926bdb3b2e91b76652a528cf5867a96313a36bad7bca99cda	false	30102	4	4581660	0x8678f58ac6c4748b5289d0db70e627eef395dead	2025-01-19T19:40:06.000Z	24118450000000000000	0x6b9622b1e45866b8a4211f4b6b51a4518f75abdd10a7647d9a18829750c5266b	24118450000000000000
0x79bbf4508b1391af3a0f4b30bb5fc4aa9ab0e07c	0x6cc20fe07dd9250995538b2a98859e0462f5fc366d39fe662202f93b2ac5fdd1	false	30102	4	4594442	0x8678f58ac6c4748b5289d0db70e627eef395dead	2025-01-19T21:39:21.000Z	38626399000000000000	0xe57e295c097a924b1864dc7dd19308696db99ef7b8c98d2e4c69fd998d16f0dd	38626399000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_sonic.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	[“20908387713386359”,“21152195094939921”]	false	1	9000705	2025-02-21T00:35:19.000Z	[]	[“0x05aaefdf9db6e0f7d27fa3b6ee099edb33da029e”,“0x282b3386571f7f794450d5789911a9804fa346b4”]	0x0918faf1ea2d1481880fc138dcb5ff5404978e791f821eca9139173bc73699e9
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	[“21675139320638475”,“21927887597311676”]	false	1	9086765	2025-02-21T08:37:40.000Z	[]	[“0x05aaefdf9db6e0f7d27fa3b6ee099edb33da029e”,“0x282b3386571f7f794450d5789911a9804fa346b4”]	0x0db6d6f3f5535be567795bba7286e9325c20584547b81cc183f2a2eab8649ecd
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	[“19440891613326254”,“19667586896783097”]	false	1	9049996	2025-02-21T05:18:14.000Z	[]	[“0x05aaefdf9db6e0f7d27fa3b6ee099edb33da029e”,“0x282b3386571f7f794450d5789911a9804fa346b4”]	0x088263794d1c2d941e866b460981b6a40f13e38c3eb6889adb64fbc2c9bac7a6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_sonic.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
93224266084425432	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	31	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	14242563	2025-03-17T12:51:34.000Z	0x5cc3d33f2cbb7ca915ead7c37555262d6c8e308ea9f3f87ff2a2a4d06b3ead8b
96881431920762083	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	59	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	14214626	2025-03-17T09:28:16.000Z	0x64e3c73035fa655193c40d926ea45ad5ad6197c981dcf8ec0d283746614f0f50
93128591212799081	0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	55	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	14294501	2025-03-17T18:50:06.000Z	0xbf90f773040b7757dea9e10dbcc2d56bb433c96c759ec7ac7c02cd6a634eefa6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_sonic.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	2800000000000000000000	0x282b3386571f7f794450d5789911a9804fa346b4	0xb8ff877ed78ba520ece21b1de7843a8a57ca47cb	28803184	2025-05-22T17:41:44.000Z	0xb7864db833ced49005b34814d2b1fa7acd407aab0b188063920e0b2a2b1601ba
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	28819785308613603580431	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	0xe93685f3bba03016f02bd1828badd6195988d950	16378084	2025-03-27T16:58:25.000Z	0x270066c1e50adb21c150c83a4dfd01b89e01fb7d79a15633f8752cb76639ed3d
0xc39161c743d0307eb9bcc9fef03eeb9dc4802de7	false	2674605789643600961420	0x4208d6e27538189bb48e603d6123a94b8abe0a0b	0xe93685f3bba03016f02bd1828badd6195988d950	2910865	2025-01-07T21:30:55.000Z	0x6dd2dabe54d07f1fd49eb71544e7b4fcc01ce1d09314f9c8ff4b3366385b25b6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_sonic.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
0x2086f755a6d9254045c257ea3d382ef854849b0f	0x8fb5b6cce70e74bf1edea385016d77c33780157b3e18d372d811c6982cf0f935	false	30101	3	40967610	2025-07-31T02:33:46.000Z	1	849	0xbb358c956c9c97830bab2e1f1832417c13c34da75cf664864ac8fa78703341ac
0x2086f755a6d9254045c257ea3d382ef854849b0f	0xba51bf3077d95edcdcde20023789dd93d4fe3ca8c550433d596456012225d308	false	30101	3	41105501	2025-07-31T22:55:23.000Z	1	851	0xf2a4409d5691f028aabc95a82e2847cc855a0aad175809934cfdde56cfb98dbb
0x2086f755a6d9254045c257ea3d382ef854849b0f	0x3c32b6d1368d27772b9d36cdceb86a2804b3cc7a2ff334a90e84c07f14d83e9f	false	30101	3	41094685	2025-07-31T21:27:06.000Z	1	850	0x9953e7287d533060db8b3da0731c28f42c70736656cea854f61eceae27e6035c

Example Query

Query with partition filter

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