layerzero_v2_celo

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”:“16582”,“sender”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“srcEid”:“30110”}	7	0x26da582889f59eaae9da1f063be0140cd93e6a4f	27832231	2024-09-20T11:56:33.000Z	0xc38e44b60ab264381b2e1d1e30dc09f9e033c7bc7dba892f73409d1370eb2462
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“16580”,“sender”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“srcEid”:“30110”}	18	0x26da582889f59eaae9da1f063be0140cd93e6a4f	27831670	2024-09-20T11:09:48.000Z	0x00dfb71f62417cdf1d46d7ca511528fec201a241ec18320a63320e52c03c7a94
0x1a44076050125825900e736c501f859c50fe728c	false	{“nonce”:“16581”,“sender”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“srcEid”:“30110”}	34	0x26da582889f59eaae9da1f063be0140cd93e6a4f	27831731	2024-09-20T11:14:53.000Z	0xb9a8516fe2333206110d33fdd665caf04127f894aad1a692020a11c74bce3f99

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_celo.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	10	0x00030100110100000000000000000000000000004e2001003102000000000000000000003691d6afc0000000000000000000000000007450dee2e6d6c9c273156340c9a55d58e0b7aa33	27639355	0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	2024-09-09T08:02:55.000Z	0xf91b46143489f1aeeaa782e201333568222bb96300b8f80405294c5b7eac778b	0x010000000000000073000075ad00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f0000759f00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4fc9331c7cee3dd6030e18fc69f31fb29cbadc7af7b1ea275aea6805a4ceb49475
0x1a44076050125825900e736c501f859c50fe728c	false	37	0x00030100110100000000000000000000000000004e2001003102000000000000000000005666e940f0000000000000000000000000001b93db54fef544ab3f26db0322d7dea0d7cd25c6	29104039	0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	2024-12-03T02:33:31.000Z	0x1b4d575cf29591142ae72a761f6ea51e9529454904200b2de8c8794a1da27026	0x01000000000000019d000075ad00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f0000759e00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4fdd13c57c1e325f9f5b0c1a57fafeeb8840fc87eecfb65878f8b4708bc867739f
0x1a44076050125825900e736c501f859c50fe728c	false	13	0x00030100110100000000000000000000000000004e2001003102000000000000000000b1a2bc2ec50000000000000000000000000000fd5a5a6625a9565caa2b1b13efcf4917e59f9572	29106782	0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	2024-12-03T06:22:45.000Z	0x80350cc57c1773d29e838fad81da1a8897c38f463263e04a6c2f12ab9ed302d9	0x0100000000000000d7000075ad00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f000075ad00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4fb3a6ccb067b8e01e83cd8c27a7c6d5d7c7d2b8570441dbdf249588d23efa8ee9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_celo.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`	`NUMERIC`	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
244990	5515736886209488000	true	177067	{“fee”:{“nativeFee”:“3718930780270455000”,“lzTokenFee”:“0”},“guid”:“0x66a5cf211cc781a8f73fe7008c8ccbc4f84a47242b9f842b3c8e4325bbcc75ed”,“nonce”:“3770”}	0x2637a450	{“dstEid”:“30175”,“message”:“0x”,“options”:“0x00030100110100000000000000000000000000004e20010031020000000000000000000221b262dd80000000000000000000000000008e58fcb678c92b85c59ec3edb405b04e540ac88e”,“receiver”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	27899896	0x26da582889f59eaae9da1f063be0140cd93e6a4f	2024-09-24T09:55:20.000Z	0x1eeec0426774079df83c99d6237b5051cb8cbc487031e2c211248a4e8d1446fc	0x26da582889f59eaae9da1f063be0140cd93e6a4f
387874	6813316995502508000	true	177067	{“fee”:{“nativeFee”:“5016234283147462417”,“lzTokenFee”:“0”},“guid”:“0x175fea0f67a6c771e9017c21aacbcea90fc4dec6b28870ade125d0549407c13a”,“nonce”:“263”}	0x2637a450	{“dstEid”:“30112”,“message”:“0x”,“options”:“0x00030100110100000000000000000000000000004e200100310200000000000000002f2f39fc6c540000000000000000000000000000355e2c0158d5b2bd82efc204ad8f3494d02eae55”,“receiver”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	27902255	0x26da582889f59eaae9da1f063be0140cd93e6a4f	2024-09-24T13:11:55.000Z	0x3b783d0e61163dfdb2ac2c1dcbc5c24f27e80ad965f0f088eda91597a7a0060a	0x26da582889f59eaae9da1f063be0140cd93e6a4f
454757	2047994638402260000	true	211377	{“fee”:{“nativeFee”:“250386345397855621”,“lzTokenFee”:“0”},“guid”:“0x9fcd93b0ceaf457f407f82d15ccea49b89e2d19160c91bddd8d981e460f6746b”,“nonce”:“5049”}	0x2637a450	{“dstEid”:“30145”,“message”:“0x”,“options”:“0x00030100110100000000000000000000000000004e2001003102000000000000000000b1a2bc2ec500000000000000000000000000009c171d969dcc3f131bd456d8153c00e7e19597cd”,“receiver”:“0x00000000000000000000000026da582889f59eaae9da1f063be0140cd93e6a4f”,“payInLzToken”:false}	0x1a44076050125825900e736c501f859c50fe728c	27909994	0x26da582889f59eaae9da1f063be0140cd93e6a4f	2024-09-24T23:56:50.000Z	0x1cf7cdb19a347d89c5df4a3c01e23d68571b7ffd3c9823343a60f04b311b296c	0x26da582889f59eaae9da1f063be0140cd93e6a4f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_celo.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
0x89bafad9b675973f374ee541634afb9242d65ffc	0x9c5bd0583f5b93b2526e4c9097fbc990d47558252fc572e29584e641bab6beca	false	30112	3	26041042	0x42e82f7be194bb75ff935a56369c103b7c967b2a	2024-06-08T19:52:08.000Z	0xfd3417619a01dbaf081db93cfd26d6fc48715d04c486511db9ec65a52baf2d61
0x89bafad9b675973f374ee541634afb9242d65ffc	0xd3d17b4133be816925496be6c5eb8018db670e66f06bf2c2c343ce99c835fba3	false	30165	9	26041624	0x3d38d6bfa3405d8ad870da881d3cc5f03aee4ff4	2024-06-08T20:40:38.000Z	0x482a25447de734df12a9e447cdfa1295af5df447a88dcc0d9dbec055464e9868
0x89bafad9b675973f374ee541634afb9242d65ffc	0xb91918ec7ac3e1525261dc754f1992eb9600ec054eeb258cd619cb68d5d4bd87	false	30109	2	26032535	0xecc41ce811144b9b67191c0d76756c65a5c965c2	2024-06-08T08:03:13.000Z	0x21c0a956579f12db925094c63bfbba2d64917fc41e06f30015d45a726a677ef5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_celo.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
0x1c0e75f35e8b7bd51df39d8911fa24c76f0de188	0x4a98e2c372c06d51dcabccc20527acae17e8aa09c564da1fbba1d105f9909087	false	30183	46	38247763	0xc042957333fefe2953ce259c549e3e327d821532	2025-06-17T08:22:01.000Z	10000000000000000000	0x8dbeca6133dffdb278c6151132bab831245609fce0ff85c7b00fefc6fc90ea9a	10000000000000000000
0x1c0e75f35e8b7bd51df39d8911fa24c76f0de188	0xe3492b1b4ac1746441cffdbee33abf78631da7c0047570c733e556583fe541ee	false	30110	227	38247657	0xc042957333fefe2953ce259c549e3e327d821532	2025-06-17T08:20:15.000Z	10000000000000000000	0xb512aa629e85767143d79d9424d8491a6d19037eb331f5e1ef89424f84a3e19f	10000000000000000000
0x1c0e75f35e8b7bd51df39d8911fa24c76f0de188	0xdc2a60c4c964d2c98c48cd17ea1f182554f4636d8e4cd151a4f9c7782ce6578a	false	30106	227	38247508	0xc042957333fefe2953ce259c549e3e327d821532	2025-06-17T08:17:46.000Z	10000000000000000000	0xfd1eba23251682974e5d911a02674ebd3e1245d856a87abb4eb26100c8ab8b71	10000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_celo.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
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	[“1948895702546178”]	false	58	30228072	2025-02-06T03:52:43.000Z	[]	[“0x75b073994560a5c03cd970414d9170be0c6e5c36”]	0x1504c21bb508e0a98d081c354ef953f7d607111fad7e12cd1cacd79a7c3f60e5
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	[“190510230451604”,“190510230451604”]	false	194	30236772	2025-02-06T15:57:45.000Z	[]	[“0x75b073994560a5c03cd970414d9170be0c6e5c36”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x1088ccf4049f3a6ad2fb7b35f46037b58b3d8fe303dfffe3d671a4b4a376a0bd
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	[“169829448409084”,“169829448409084”]	false	271	30231632	2025-02-06T08:49:23.000Z	[]	[“0x75b073994560a5c03cd970414d9170be0c6e5c36”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x7e6eb3e6c76c6662beca690c6e5a9d3442ffbada3c605eed06640c685b706b01

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_celo.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
778318407268626288	0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	5	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	24696368	2024-03-23T00:05:52.000Z	0xbcafc2898783f8b3dac009e9ffbc34f9a4c0bdd711a133d173e27ecc12ac6cb0
133202848594462509	0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	8	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	24696368	2024-03-23T00:05:52.000Z	0xbcafc2898783f8b3dac009e9ffbc34f9a4c0bdd711a133d173e27ecc12ac6cb0
48254319977420137	0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	10	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	24697583	2024-03-23T01:47:09.000Z	0x3f9670e09c3edb8f693ddabc1a6bf5a91ed758bbac2bcbd9af185873e573a90a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v2_celo.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
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	71000000000000000000	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	0	0x21c3de23d98caddc406e3d31b25e807addf33633	24386509	2024-03-05T01:42:38.000Z	0x8f2e0977a78569e94c1dc53dd715bdf19c81d3e5403079e27cc8d326cf8b4c5a
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	1991916001064333866801	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	0	0xe93685f3bba03016f02bd1828badd6195988d950	31193949	2025-03-27T16:58:27.000Z	0xa79ff71f45ee5ed4a27f8eaf4cd37722eb2d92945b54035097c6d1843401a685
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	2102942360592875232941	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	71	0xe93685f3bba03016f02bd1828badd6195988d950	29722406	2025-01-07T21:30:58.000Z	0x11e9e4487d7698a606407dba5cf954de65db7a9d7f9fb5c4e9de88dbaea768d7

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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