layerzero_v2_base

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”:“123”,“sender”:“0x0000000000000000000000000555e30da8f98308edb960aa94c0db47230d2b9c”,“srcEid”:“30101”}	520	0x0555e30da8f98308edb960aa94c0db47230d2b9c	26177326	2025-02-09T23:33:19.000Z	0x1c24b27c609a20fd90ff11fde02384a034a84daca2748b9f95585bd519abb173
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“11”,“sender”:“0x0000000000000000000000001486d39646cdee84619bd05997319545a8575079”,“srcEid”:“30101”}	70	0x850cdf416668210ed0c36bfff5d21921c7ada3b8	26149808	2025-02-09T08:16:03.000Z	0x6f7ddeab0f44d9e9e739910a2f98efb518e29d0b973dc9575c5adb4200fccc91
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“574”,“sender”:“0x000000000000000000000000157a6df6b74f4e5e45af4e4615fde7b49225a662”,“srcEid”:“30101”}	269	0x157a6df6b74f4e5e45af4e4615fde7b49225a662	26174193	2025-02-09T21:48:53.000Z	0x183e44b4b93e66e442cbd0d76a0457c64a6cf7ba023fd1411ad9e4f6decae289

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_base.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	275	0x00030100110100000000000000000000000000001b58010031020000000000000000000009184e72a00000000000000000000000000004927bb3d3a0bdde87ee7e8ae7c5b406b173e39a	17729821	0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	2024-07-29T10:29:49.000Z	0x7d249dc69855d9678ebefbebc472f69162007876f6abc639670553ddc1d4c7c2	0x010000000000000104000075e8000000000000000000000000809e02be51e6c01e626b252021eac254b5374b99000075e7000000000000000000000000809e02be51e6c01e626b252021eac254b5374b99f909b8fbfb97036d9ee90c8556149c7e5543cf8cf108394b23c7a8777be2a4e6
0x1a44076050125825900e736c501f859c50fe728c	false	162	0x00030100110100000000000000000000000000001b58010031020000000000000000016345785d8a00000000000000000000000000007e03b41a3bd79de20e2b38075af02f2dcf174754	17744200	0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	2024-07-29T18:29:07.000Z	0x4eaaafca000a6084a4b3d72cba8af672e9fbf8e7072066d9840a03b3c08b150c	0x01000000000000001f000075e8000000000000000000000000809e02be51e6c01e626b252021eac254b5374b990000759a000000000000000000000000809e02be51e6c01e626b252021eac254b5374b99e4e867812a9ad4c644400b60c809f6806f53749a4e1908e7975c973a592ef095
0x1a44076050125825900e736c501f859c50fe728c	false	215	0x00030100110100000000000000000000000000004e2001003102000000000000000000000000000000000000000000000000000000000382a80b0eee38bde8ec07c2b5eaaadb5b6dab38	17732433	0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	2024-07-29T11:56:53.000Z	0xf0b68eee6823f9ea280ec10f13ed58ccb12a6489e2325997d8eee1f904b47ee2	0x01000000000000037c000075e800000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f0000763400000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f5c167f014c10c02f4777a6c96a6fc8713716d18b3415b4f3550dea1ae7ce8a23

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_base.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
234137	19378036111107	true	93538	{“fee”:{“nativeFee”:“19378036111107”,“lzTokenFee”:“0”},“guid”:“0xbd75c526d777fa6547febc922f58ce25a6f479480efadbcd811f75fac145c9ed”,“nonce”:“2”}	0x2637a450	{“dstEid”:“30110”,“message”:“0x0000000000000000000000005075a6f2c637444fd66a785a1485d7206ae9c153000000000000000000000000000000000000000000000000007eb5296f5a06000000000000000000000000000000000000000000000000000000000000000000”,“options”:“0x00030100110100000000000000000000000000030d40”,“receiver”:“0x000000000000000000000000a170eaa9a74ab4b3218c736210b0421af35c3c00”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	17724982	0xa170eaa9a74ab4b3218c736210b0421af35c3c00	1	2024-07-29T07:48:31.000Z	0xb3cf992045bec333f3950627dd926bf343ca71eacfae0071a0952db44fa57269	0x5075a6f2c637444fd66a785a1485d7206ae9c153
109935	2999313899062291	true	106741	{“fee”:{“nativeFee”:“8312287607642”,“lzTokenFee”:“0”},“guid”:“0x18c9574e6720d95315b3a306bc06f88bf362f5cc47b0c6d7a65b54b0a180a5ab”,“nonce”:“15581”}	0x2637a450	{“dstEid”:“30175”,“message”:“0x”,“options”:“0x00030100110100000000000000000000000000004e200100310200000000000000000000000000000000000000000000000000000000219e24760e5b1ce2e227a434cb0708a358af12d5”,“receiver”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	17732196	0x26da582889f59eaae9da1f063be0140cd93e6a4f	2	2024-07-29T11:48:59.000Z	0xb50951cb2642c2dcc9048f573630f9fc010a97d5805e11205df6e4dbba503702	0x26da582889f59eaae9da1f063be0140cd93e6a4f
109935	3000482500801162	true	106741	{“fee”:{“nativeFee”:“8312287607642”,“lzTokenFee”:“0”},“guid”:“0x357d6830aa2a2eb58f75d82f33925a89b51eb37449ac8dcdeb5fa814e8affe19”,“nonce”:“15582”}	0x2637a450	{“dstEid”:“30175”,“message”:“0x”,“options”:“0x00030100110100000000000000000000000000004e200100310200000000000000000000000000000000000000000000000000000000e61cd11aa389c0ff84f64063e77f7106b1c11f26”,“receiver”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	17732196	0x26da582889f59eaae9da1f063be0140cd93e6a4f	2	2024-07-29T11:48:59.000Z	0x1e6556dcbe380b0caa3aae4f24971ff15989fd3b1c445d23055fab8a21a7f31e	0x26da582889f59eaae9da1f063be0140cd93e6a4f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_base.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	removed	log_index	block_number	block_timestamp	transaction_hash
0x344c796cc2474e4b779d0e81765afb91d7741a42	false	39	19635190	2024-09-11T13:02:07.000Z	0x5955e0044ee77f0763b413ba60ec066a0258a92cb9b93c012c8fdea45a83b362
0x344c796cc2474e4b779d0e81765afb91d7741a42	false	31	19647456	2024-09-11T19:50:59.000Z	0xb4bb2f768f5006d71bdc21cf424620e80dc173736a7ed152f2f2705ed8930692
0x344c796cc2474e4b779d0e81765afb91d7741a42	false	99	19654561	2024-09-11T23:47:49.000Z	0x97cd12a506f46c418579cca31599108cabbcbae391ddad3c654965c5984f51c8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_base.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
0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	0x62aa6b880e56d661135a971e094abe17666c7153f111c5f84b9fb15cdd2c7d95	false	30101	116	19283147	0xc40ca9847255a1b89ac50ee08555ec150a1e23a1	2024-09-03T09:27:21.000Z	170000000000000000000	0xc0e8bf7af10df402f7b9b3ffaefa9e6c000b29421075c1ded112eae71c14a5fc	170000000000000000000
0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	0x252a3260f5e5fc70f046197313283f31b58a65260e10e33ce41c6c19a4390341	false	30101	691	19298676	0x053ce21eaa4e790d423d4b86c5ca7a58dae2fb71	2024-09-03T18:04:59.000Z	64318679000000000000	0xac04a0df688740148cc264fa5fa751dfc72a56795801c83c4281b0b689d443a9	64318679000000000000
0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	0x391c497dfaed50ec37b2620f510803a208aa6396689c668bf39cfccb72226be9	false	30101	198	19298431	0xf756ff3a5d135fb6219ec178a1e1c5de192d0365	2024-09-03T17:56:49.000Z	29994558000000000000	0xc9a54dbad85570daee7df3945cb0ee69198f69dad234621604440f77076ef066	29994558000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_base.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
0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	[“103366440000000”]	false	18	10539930	2024-02-14T00:06:47.000Z	[]	[“0x9e059a54699a285714207b43b055483e78faac25”]	0x6de4fb8ef6774f42f78e7fca165bf9153bd85db73400085a7ac215b0479dc09c
0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	[“226464”]	false	15	10540166	2024-02-14T00:14:39.000Z	[]	[“0x9e059a54699a285714207b43b055483e78faac25”]	0xe4eb2d232b0ea04d72279a74d2c75986af57601711206c384ace085b87806476
0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	[“226464”]	false	14	10540251	2024-02-14T00:17:29.000Z	[]	[“0x9e059a54699a285714207b43b055483e78faac25”]	0x74a4321bfca5069a5206756fc54aee24d903ab2f7d2863f8c2fa832765e314ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_base.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
5626280113690	0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	false	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	24603978	2025-01-04T13:28:23.000Z	0x0c9375f55b8ed8049d5b8f9be6f35dba53c1517fefa44ada7c5f80e32ab3b783
816634390669618	0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	false	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	24593368	2025-01-04T07:34:43.000Z	0xb92e93174dbfca8c70f18e9d57c267634d61a3e4cfc9d3c68b85a920b696742c
2510196332473780	0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	false	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	24586267	2025-01-04T03:38:01.000Z	0xfdb6d3d6f0910d2e14e8d569dc32fdd81cc84c7c0c2bc6e4ab1a34c87c310c77

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_base.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
0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	false	112059905127903390246	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	121	0xe93685f3bba03016f02bd1828badd6195988d950	28152680	2025-03-27T16:58:27.000Z	0x1203b4fd4c280ae334df44097adab25eedf59cea5e3dd1cce418cfa3bd645119
0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	false	17174757806125629772	0xcd37ca043f8479064e10635020c65ffc005d36f6	195	0xb8ff877ed78ba520ece21b1de7843a8a57ca47cb	24748190	2025-01-07T21:35:27.000Z	0x6324a1b64d9f5f206e96008b00e892ab12d05f4dceb6df660c9c6496dd49663a
0xb5320b0b3a13cc860893e2bd79fcd7e13484dda2	false	131592845067659304282	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	121	0xe93685f3bba03016f02bd1828badd6195988d950	24748058	2025-01-07T21:31:03.000Z	0xc2b58b1c18e9d65a35cb2796d0ebb0f726c01f9db61b9876a805acd2393c3025

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_base.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
0x5634c4a5fed09819e3c46d86a965dd9447d86e47	0x2b8be9ebc2040378b0862c1e0dd0ae415f779f6016d555a5e531b264b79d0cf2	false	30101	4	16480638	2024-06-30T12:30:23.000Z	1	5672	0xa212483fe9ebae743157f9fa1381da4da05c90e4e277da5172c123b7930bf45d
0x5634c4a5fed09819e3c46d86a965dd9447d86e47	0x3cdb117524e53d8aa10adbd31c0e413a87ea8fc85eb5cdcff8f739a4ef6fdda7	false	30101	4	16464481	2024-06-30T03:31:49.000Z	1	5552	0x271a53ecc9df30d69948c9dac9df4298747f1cab095eebc9c32e5f5d9aa22a10
0x5634c4a5fed09819e3c46d86a965dd9447d86e47	0xa7a89647b7e1160b690b8bb967041861d3f1ccf1139bab3b0df59ea3e9f503bc	false	30101	5	16468408	2024-06-30T05:42:43.000Z	1	5561	0xa4f3eb7c6bf7876d078aa7b09611cf601c6f7a9543c57dc2680e4d44f6702508

Example Query

Query with partition filter

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