layerzero_v2_gnosis

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”:“5”,“sender”:“0x0000000000000000000000001a8805194d0ef2f73045a00c70da399d9e74221c”,“srcEid”:“30110”}	12	0x1a8805194d0ef2f73045a00c70da399d9e74221c	34276668	2024-06-03T13:26:25.000Z	0x7234e57cd542ea55afc168944715784224062e1421b48a957889a231029f8c68
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“12430”,“sender”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“srcEid”:“30184”}	0	0x26da582889f59eaae9da1f063be0140cd93e6a4f	34274876	2024-06-03T10:51:40.000Z	0x7bac1eea101aa6cd88dd5b82ce445ded778b70c3e227a06397fe8a544e73827f
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“12431”,“sender”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“srcEid”:“30184”}	4	0x26da582889f59eaae9da1f063be0140cd93e6a4f	34276296	2024-06-03T12:53:45.000Z	0xd17993ed1bbf7baa91d875cbcbd846137e747bc6ba18173f46b60d929c9866c5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_gnosis.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	8	0x00030100110100000000000000000000000000004e2001003102000000000000000000038d7ea4c6800000000000000000000000000038d83fffc356d817222ad9595d5923be5a1076b6	40946010	0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	2025-07-06T06:34:55.000Z	0x9d3bdb3825361504e662c7e67badd6aba366f13138d4a3d6bc5254670c18b3f7	0x010000000000001670000075c100000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f000075ba00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f85ee725d7d81f239a7e360bb9be3f2286f3c58192d1bf545e42d210be11f5c30
0x1a44076050125825900e736c501f859c50fe728c	false	10	0x00030100110100000000000000000000000000009470010011010000000000000000000000000000ea60	40950493	0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	2025-07-06T12:57:40.000Z	0x560513137b8c18489c77e72e69d9f3b2d99f45ff6df83982d38ccf90a310c0a5	0x0100000000000004ca000075c1000000000000000000000000af368c91793cb22739386dfcbbb2f1a9e4bcbebf0000759d0000000000000000000000006ce9bf8cdab780416ad1fd87b318a077d2f50eacbf73c24467a968cedb646bc76975a4d7291f78313e37433725043c18570108610200000000000000000000000000000000000000000000000000731ba0dab900000001000000000000000000000000edbe49e8b202e4cb4fcfeb4f0cd1d1717434b3990000000029903b6d00
0x1a44076050125825900e736c501f859c50fe728c	false	183	0x00030100110100000000000000000000000000009470010011010000000000000000000000000000ea60	40954391	0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	2025-07-06T18:29:50.000Z	0x84fc6cbaa5736ed2da0291d630534a20a9602db4bc5ec84acc03bafabbd8f816	0x010000000000000179000075c1000000000000000000000000af368c91793cb22739386dfcbbb2f1a9e4bcbebf000075960000000000000000000000006e3d884c96d640526f273c61dfcf08915ebd7e2b0efe237dda65d52368b34cba3b04df87b284e63cbe5aa9d5d3927b458d3c611b0200000000000000000000000000000000000000000000000000044364c5bb00000001000000000000000000000000ce66c6a88bd7bec215aa04fda4cf7c81055521d00000000000ff0dfa00

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_gnosis.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	block_timestamp	transaction_hash	in__refundAddress
288950	102186893338770596659	true	177067	{“fee”:{“nativeFee”:“1433487689445426220”,“lzTokenFee”:“0”},“guid”:“0x322b03115e904230aed80d0960fcc1c9ef52e09c60d05f32d39ba1c78067e49d”,“nonce”:“151”}	0x2637a450	{“dstEid”:“30102”,“message”:“0x”,“options”:“0x00030100110100000000000000000000000000004e2001003102000000000000000000071afd498d00000000000000000000000000009e4ff0a09e734f745b2250df69d5a5f4a1e51e75”,“receiver”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	35832560	0x26da582889f59eaae9da1f063be0140cd93e6a4f	2024-09-04T18:32:50.000Z	0x0ce693bad62ded3f6b0505b39fd1733d97ae23744bb2fb1929eb8e0f92729835	0x26da582889f59eaae9da1f063be0140cd93e6a4f
203104	101479202490138799771	true	201127	{“fee”:{“nativeFee”:“732062236114506065”,“lzTokenFee”:“0”},“guid”:“0x2ed40b0eb630f1e247a68948777ccacf5070527c78990cdc30a2865c3a4c7a23”,“nonce”:“57”}	0x2637a450	{“dstEid”:“30111”,“message”:“0x”,“options”:“0x00030100110100000000000000000000000000004e200100310200000000000000000000f1041edd900000000000000000000000000092901d73c25419c927bf9036270d55cc9e63e9e2”,“receiver”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	35826824	0x26da582889f59eaae9da1f063be0140cd93e6a4f	2024-09-04T10:17:50.000Z	0xef30202340f719a21a67e9ab692e264dd00553edae18a21c4f97d8e8bcf38392	0x26da582889f59eaae9da1f063be0140cd93e6a4f
186448	101667397970209005206	true	184471	{“fee”:{“nativeFee”:“919298405158028315”,“lzTokenFee”:“0”},“guid”:“0xe6f5671feb5ee17c0929a14536b0412e285085c4e7db5952d1c1c351033b3f0b”,“nonce”:“169”}	0x2637a450	{“dstEid”:“30110”,“message”:“0x”,“options”:“0x00030100110100000000000000000000000000004e2001003102000000000000000000010ff05cc9b00000000000000000000000000026dee9fbb7f635afb954f27f952c35ed0fdcf10d”,“receiver”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	35829850	0x26da582889f59eaae9da1f063be0140cd93e6a4f	2024-09-04T14:38:30.000Z	0x5f63d27be568f029d0fdc8186fea1110c960fa615ae4408bede993dea94f7275	0x26da582889f59eaae9da1f063be0140cd93e6a4f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_gnosis.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
0x0cc0ab38d20614d6f68954f2bdd59a049722e864	0xd963e267d435bef6be9dcfe844f7e44e3a172bc948949be40630504130eb30bb	false	30184	168	37205088	0x3f719fc043f7dcd2d33c6bfefc44e77eb9e1eb47	2024-11-25T15:55:55.000Z	0x7ef2d4b421f057e0a832a3509ca631adbdef56d40f3b8b2a8eb1987eb42639bb	41592074890000000000000000000
0xb1eead6959cb5bb9b20417d6689922523b2b86c3	0x0f64d3e1696495508a2286b0e19dd7ecf9c892c63c8b271faab9a1428e5ff0eb	false	30101	1	39761462	0xf70da97812cb96acdf810712aa562db8dfa3dbef	2025-04-26T16:50:35.000Z	0x4989fbace7369080d3b75bb7907547241c700768d35cc962300750003eaf1f5f	26332275137
0xb1eead6959cb5bb9b20417d6689922523b2b86c3	0xd23e5d41b38c01f8569e6e1ba90ab13c675a6fb34267aa19dd9cd9f465995bcf	false	30101	20	39758233	0xf70da97812cb96acdf810712aa562db8dfa3dbef	2025-04-26T12:15:35.000Z	0x4681ce0f8b397941b2d0d24f4e1c1ea842b6b68f8340f59c44b057885a1f891a	25720314810

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_gnosis.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
0xa7490a2d3e0fa0ffc461eadc465c19d370265d1b	0xec34d1af756839ce5587e4f95b29c6dc7a7efd11b79adc2f4037931ef8b15def	false	30110	9	40654330	0x337b17597275d1655691ec0b6f851d02be54de79	2025-06-18T22:15:10.000Z	4812000000000000	0xe3083228ed6890dff6184c7424d29666e7924d2c5a9034a00a5430508415f5af	4812000000000000
0xa7490a2d3e0fa0ffc461eadc465c19d370265d1b	0xf80ee13152f40a0c1d969560d93bf55dcd341dd8f5c46c6d72acdca525c2106e	false	30110	15	40653289	0xf7519e9222fe4e60e2b8509af8da883d02819050	2025-06-18T20:43:40.000Z	5610000000000000	0x6551037c69f865c68a2c2d590e3f2042890e7c43d137068835c2bbec7467bfe9	5610000000000000
0xa7490a2d3e0fa0ffc461eadc465c19d370265d1b	0x2d15d565e5bfb3a27451fc9e4f563e073eb41848fc5b3673700bbb4b5f05368c	false	30110	21	40655285	0x61bf24dd015dd2e37fb13310258007aa05d04e99	2025-06-18T23:38:20.000Z	25000000000000000	0xf140e7bf24f1b049f653465360d08b711dc23105bf3427a9e7a99120b1fdea0e	25000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_gnosis.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
0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	[“6295625078211226”,“6295625078211226”]	false	4	38452721	2025-02-08T05:40:35.000Z	[]	[“0x11bb2991882a86dc3e38858d922559a385d506ba”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x9fedf4452b5db8804ff692b8a1450413cb18d670469cdbfaad320c45bb66d37b
0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	[“6423654377542376”,“6423654377542376”]	false	6	38456962	2025-02-08T11:40:35.000Z	[]	[“0x11bb2991882a86dc3e38858d922559a385d506ba”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x4fed9db84f362a3439b0e733ee1ac850cc66be31203ea32f21178bf800c2406b
0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	[“6295625078211226”,“6295625078211226”]	false	6	38454130	2025-02-08T07:40:35.000Z	[]	[“0x11bb2991882a86dc3e38858d922559a385d506ba”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0xe3e2fae08088ba91b73c74b6e0d635d194b96f015bf01d69ba252a0356457830

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_gnosis.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
50616013953887970	0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	false	0	0x38340337f9adf5d76029ab3a667d34e5a032f7ba	40085026	2025-05-16T03:28:05.000Z	0x586bc97d8aedc568a35bbc38b8c2af1e99f61593907cec9d46b7c89b50dbbdb7
51133693552016314	0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	false	1	0x38340337f9adf5d76029ab3a667d34e5a032f7ba	40090507	2025-05-16T11:22:15.000Z	0x9995dfc149ae183c246cdb72d3e480b3311adacb653295e98db1832da762ea04
51410415642363725	0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	false	3	0x38340337f9adf5d76029ab3a667d34e5a032f7ba	40092657	2025-05-16T14:28:55.000Z	0xb9dd8efee30102809a1f045c4ae94ea2ae61d559df669af38e17e75a6e7ff407

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_gnosis.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
0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	false	42336706970597912571	0x38340337f9adf5d76029ab3a667d34e5a032f7ba	0	0xe93685f3bba03016f02bd1828badd6195988d950	34515936	2024-06-17T20:41:30.000Z	0xba5aa30e48c7bcd9f163a31385e2a8117c56fa4c7828a81ff741b23aeba92c4c
0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	false	3553030740166974472263	0x38340337f9adf5d76029ab3a667d34e5a032f7ba	16	0xe93685f3bba03016f02bd1828badd6195988d950	33530472	2024-04-19T23:40:30.000Z	0xdef532b5621a20723eadab6829a6bb9b4daa4cdeab5db49de688516283abe69b
0x3c156b1f625d2b4e004d43e91ac2c3a719c29c7b	false	3882535198772493468	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	6	0x21c3de23d98caddc406e3d31b25e807addf33633	36171002	2024-09-24T20:57:40.000Z	0xcf9131d1aebe94f440a68cde0e55c94c7d8f07887e57540f5b108ecb3be1093a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_gnosis.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
0xaf368c91793cb22739386dfcbbb2f1a9e4bcbebf	0xa48a33223bbcd3d20cf04fe89e6ef37ce54732c03ce407b9022aca24bf9ec119	false	30101	13	39931488	2025-05-06T23:20:05.000Z	1	105	0x311ee8449048029aa1f3907202cd678fc41dc7405eb10f0e15da548104f916d7
0xaf368c91793cb22739386dfcbbb2f1a9e4bcbebf	0x9c7efd48387e25c84a765f883e2559c2032390bf6e1e19bc4280b6f1e42268cd	false	30102	51	39915693	2025-05-06T00:46:05.000Z	1	160	0xcfa746072d79c5a43ee49217e6c27a623bcde5a7bccb4ddc982ae15a4e53fb29
0xaf368c91793cb22739386dfcbbb2f1a9e4bcbebf	0xa13079e474bab0f56df78e61387c2d5b0cd1e549cb34fd2c8ad338969165491a	false	30102	14	39927260	2025-05-06T17:18:50.000Z	1	162	0xa312d1487a21552734b61091e8c181c4569e2405fa01bcaf042487a11c38bde9

Example Query

Query with partition filter

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