layerzero_v2_avalanche

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	in_receiver	block_number	block_timestamp	transaction_hash
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“282”,“sender”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“srcEid”:“30102”}	0x26da582889f59eaae9da1f063be0140cd93e6a4f	42108564	2024-02-25T03:00:18.000Z	0xbdc578fb6292852dd5b31f14b3a32464ce7be818fd1d6863bb0e912f07880339
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“313”,“sender”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“srcEid”:“30102”}	0x26da582889f59eaae9da1f063be0140cd93e6a4f	42144306	2024-02-25T22:59:55.000Z	0x2d09197f1f5ac98e3cc24a7d3169e7bf731ed1b9abbc87033f6af38bfe0ca4ec
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“304”,“sender”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“srcEid”:“30102”}	0x26da582889f59eaae9da1f063be0140cd93e6a4f	42142689	2024-02-25T22:05:28.000Z	0x91905e5f15c994f8aca53b7f54d1c94a523f859a458c42de68a381d5bc34c97c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_avalanche.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	2	0x00030100110100000000000000000000000000004e20010031020000000000000000000001897bd9840000000000000000000000000021b8aef0e8c40a43db9bced3f1ad60a0d0e038cc	55103787	0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	2024-12-30T18:41:03.000Z	0x0e0a36239a28ff0fcd3ee95510abbdd0a7178b6d02a1956203756e2aef8a0111	0x0100000000000005050000759a00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f0000760300000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f8cff648b52325df971f95d8b15e335d5709b532375feef82e1bd981793d023f5
0x1a44076050125825900e736c501f859c50fe728c	false	2	0x00030100110100000000000000000000000000004e200100310200000000000000000000da475abf0000000000000000000000000000bbda51bf102b0f50ce27680c4478d56274b55434	55076311	0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	2024-12-30T05:23:09.000Z	0x191016783df1aca858e2c88405e7888ec43491609c46259034d0c394ecd19c23	0x0100000000000007f60000759a00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f0000759e00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4fea6ae37629c352f97727fa0e94bfbfef3eca5279c4b95a0d52b7bf3f2aa44f01
0x1a44076050125825900e736c501f859c50fe728c	false	2	0x0003010011010000000000000000000000000001388001003102000000000000000000060a24181e400000000000000000000000000094e2b9287f7b09bf30e9a859995e8ffe29b8da67	55090508	0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	2024-12-30T12:40:49.000Z	0x3c2a98d6394a17a39ce0953a7d7e49a7c50e94356af4623cc12f29d23ca606ef	0x0100000000000007e00000759a00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f000075e800000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f5cfb690f4b88ff5f7b137e80c5d0f17f1dee93346a434f32ab855b775ab9acac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_avalanche.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`	`STRING`	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
143428	926177473477724	true	137960	{“fee”:{“nativeFee”:“926010282339580”,“lzTokenFee”:“0”},“guid”:“0x5ad4fd1642e3f5b44e2d611fc80c67d0be612f842b8209b18273cba786a7b2eb”,“nonce”:“5199”}	0x2637a450	{“dstEid”:“30118”,“message”:“0x00000000000000000000000000000000000068a59631000000000000a6d401000000000000000000000000005c4185b8cca5198a94bf2b97569deb2bbaf1f50c555344430000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004c4b40”,“options”:“0x0003010011010000000000000000000000000007a120”,“receiver”:“0x000000000000000000000000170c15cb9887e6adb097518104b174df212bb190”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	67356900	0x170c15cb9887e6adb097518104b174df212bb190	0,5,0,1,0	2025-08-20T09:32:33.000Z	0x52d88588cb83621e8e11bf659c987feada63c9d218bc7b8ad39e458a075ed1e1	0x5c4185b8cca5198a94bf2b97569deb2bbaf1f50c
349753	34464586389633922	true	204459	{“fee”:{“nativeFee”:“34464586389633922”,“lzTokenFee”:“0”},“guid”:“0x56c769fcba0dcdc6ff74e296daf3c9b79473752afd3e65d75c35cedbeb51d0b4”,“nonce”:“6”}	0x2637a450	{“dstEid”:“30101”,“message”:“0x0000000000000000000000003c37dc9b5d4c60d404ec834987c106510d03442f00000014dbdc65000000000000000000000000003c37dc9b5d4c60d404ec834987c106510d03442f00”,“options”:“0x00030100110100000000000000000000000000030d40”,“receiver”:“0x000000000000000000000000e2fc85bfb48c4cf147921fbe110cf92ef9f26f94”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	67352943	0x94f9bb5c972285728dcee7eaece48bec2ff341ce	0	2025-08-20T07:48:32.000Z	0x05b35924aace009cab1cd0a0bb6b496094a8c24a8485aa66442792c69275a80d	0x94f9bb5c972285728dcee7eaece48bec2ff341ce
772010	40518814251019934	true	215925	{“fee”:{“nativeFee”:“40518814251019934”,“lzTokenFee”:“0”},“guid”:“0x8d6b58ef12426973521eee0a942429a7b161345f02c7083ef4dcd401ed13a0a5”,“nonce”:“598”}	0x2637a450	{“dstEid”:“30110”,“message”:“0x000000000000000000000000487843b6de2816567e1cdcf0dbd60f8ee020b82200000000005e9ac0”,“options”:“0x0003010011010000000000000000000000000034316c”,“receiver”:“0x000000000000000000000000ac800fd6159c2a2cb8fc31ef74621eb430287a5a”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	67369986	0xac800fd6159c2a2cb8fc31ef74621eb430287a5a	0	2025-08-20T15:37:45.000Z	0x923c01489025abddc7b023bfc0741a1a69b0a30835883d077c7614b03878cdf3	0x487843b6de2816567e1cdcf0dbd60f8ee020b822

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_avalanche.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
0x12dc9256acc9895b076f6638d628382881e62cee	0x71029fcbe5d20d9fdbcba141cf92a2266f094629ade0732f51f1f006f3eea440	false	30101	1	46742391	0x28b4ab97b1df8ad5d7d4b9cea94c5f15730148c3	2024-06-15T08:45:48.000Z	0xc8a31cc182ebdb3d8b73b7c9f1250e53a7be279acac959c300db0f324894077a	529607594
0x12dc9256acc9895b076f6638d628382881e62cee	0xa55f529e37e4ffe8ca3ad9757f0301a42c3e685e03a70b2380289d841a5d9f05	false	30102	1	46743525	0x68e8c724b9e88e6cfeeb44a40d09c36b39d0f089	2024-06-15T09:25:27.000Z	0x54a8dce3562c3d98cf89eb41cbc6efb37a35f04ff237909b517ce71e880c2164	1997179
0x12dc9256acc9895b076f6638d628382881e62cee	0x3d7c8b1f4b59afa2ea2bf037789c2914e8a99d6135c25ee454e4f81c05bae16b	false	30102	1	46734319	0xddd22419c4e2695c9fa0ae218db1d6f72f8d4efa	2024-06-15T04:02:46.000Z	0x83d932a17e5e24a98d4fa54dc482ba45e6faf71b70ef8767b9aa36e20307c12c	15887731

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_avalanche.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
0x0555e30da8f98308edb960aa94c0db47230d2b9c	0x05dc22d08dc10771939a593c28033bd19e837e1132a221b7afc4958a62093406	false	30280	11	64487389	0xa36c071c62abeb7b84fcd2688e28939590a66288	2025-06-26T06:25:37.000Z	883260	0x35f80ce26aa5d62e81bdcd5b541a45399894d4ef58672647f542c95a3ebed8c1	883260
0x0555e30da8f98308edb960aa94c0db47230d2b9c	0x9533c143ef2c52d5d7cacb0ca506b3aeee81df6d86eb020111d89d4c3f380039	false	30280	59	64496017	0xfd51582ff672a328fdc95a93b615e9b8ddf1ae3a	2025-06-26T10:40:10.000Z	523941	0x7e45e3a61e27d9eb2519b7baf2682fc221b41dc4e8ce0697a9e27c69cd43ab2d	523941
0x0555e30da8f98308edb960aa94c0db47230d2b9c	0x89e08d0dee2f88a9ace1c8c79a2d2c6dfcc48dd71d7bcfa1e394a56cb5754fbe	false	30280	17	64477113	0x59290828a7652eb3556051d2ee18d9e013fe3a67	2025-06-26T01:36:42.000Z	547070	0x73041b833d26c624cb54cff1887424cb3d56e0a4f1653217805d93cfe57dd205	547070

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_avalanche.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
0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	[“2459967420582141”,“2459967420582141”]	false	14	41660963	2024-02-14T10:10:30.000Z	[]	[“0x962f502a63f5fbeb44dc9ab932122648e8352959”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0xc1385306f88d042a87c351c152e3be3e2d8dce2e3d3ceed1118245d7e82f7270
0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	[“1822681944726”]	false	11	41665709	2024-02-14T12:50:11.000Z	[]	[“0x962f502a63f5fbeb44dc9ab932122648e8352959”]	0x1f50c70494d48571481c1993d0ec493915c050d6d1b053ab3171a9721c702fb0
0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	[“2459967420582141”]	false	7	41680363	2024-02-14T21:03:00.000Z	[]	[“0x962f502a63f5fbeb44dc9ab932122648e8352959”]	0xcad79110776105178a52ea3b4a69d6a3fca76bc37930d16e0a05725bf3589425

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_avalanche.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
1062861721664360	0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	false	5	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	43249902	2024-03-23T00:07:24.000Z	0x0009dbcf2b198031cfc2d8e32084515a7eb37f1577a9eedf655499a111f5cc79
32106796070027051	0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	false	22	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	43249968	2024-03-23T00:09:38.000Z	0x51b8e8631de24e9d6819cfab79a674fa4fef3167aa7cd1a25a5633e954b24a47
9238224133981596	0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	false	5	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	43250226	2024-03-23T00:18:27.000Z	0x62ee133de54da9527520c07684290672ba9ebaebaa1053e89e40248f2dd2bedd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_avalanche.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
0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	false	225496192849565484743	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	0	0xe93685f3bba03016f02bd1828badd6195988d950	46431052	2024-06-07T20:08:29.000Z	0x746d64fb5d11524a6b4b978bffc3c65f3b7384ab4b3230b0af1dd13df999a5ee
0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	false	823708056750339334535	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	23	0xe93685f3bba03016f02bd1828badd6195988d950	42776801	2024-03-11T21:01:34.000Z	0xd32ec0a39e0ddda117b258f71ad9b289fa98fa7a43c182f92dea10e049554a3d
0x197d1333dea5fe0d6600e9b396c7f1b1cfcc558a	false	80040492757850233338	0x962f502a63f5fbeb44dc9ab932122648e8352959	37	0xb8ff877ed78ba520ece21b1de7843a8a57ca47cb	42776939	2024-03-11T21:05:57.000Z	0xf8ec84121b97c2f20dbc03eb44c25808dc5544e3ee4a5a75af1b96839f2576e5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_avalanche.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
0x17e450be3ba9557f2378e20d64ad417e59ef9a34	0x136e4a35db64d5d80fa099273ddeeccfe00455af4899264ee81d79efa1acff42	false	30101	3	66473992	2025-08-03T01:38:43.000Z	1	1915	0xa2eb25d9b0eee409b3cfb99bd92102f0d10b29c09b0ef3cbc35495a9a4c7239b
0x17e450be3ba9557f2378e20d64ad417e59ef9a34	0xc3b3fd0a5300594a0f6afc9086f4fc94ad61d8b6ddcb4a78880225f042819eab	false	30101	10	66517404	2025-08-03T22:14:07.000Z	1	1916	0x189605a41215496f4e04d6e11e726a1e280e8d30d113200d620f158f38fed5ec
0x17e450be3ba9557f2378e20d64ad417e59ef9a34	0x9b9d9ea1c1c1a54dce4c7da62956c6351f42acf294a92dbaddb5c6450d34ea70	false	30102	8	66497046	2025-08-03T12:52:57.000Z	1	8188	0x0730a5a31fdf20e05d45125860c216a9c7f85e58d1539c84e7ab04632972f354

Example Query

Query with partition filter

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