layerzero_v1_ethereum

Tables

Endpoint_send_function

LayerZero endpoint function calls initiating cross-chain message transfers with destination chain identifiers, payload data, adapter parameters, and refund addresses. Used for tracking omnichain messaging activity and cross-chain transaction flows.

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__dstChainId`	`STRING`	LayerZero chain identifier for the destination blockchain. String-encoded integer representing the target chain in cross-chain message transfers.
`in__destination`	`STRING`	Concatenated address pair used in LayerZero cross-chain messaging to specify source and destination contracts. 84-character hex string without 0x prefix, consisting of two 42-character addresses concatenated together.
`in__payload`	`STRING`	Application-specific message data sent in LayerZero cross-chain transactions. Hex-encoded byte string including 0x prefix, containing contract function calls, token transfer details, or other custom protocol messages.
`in__refundAddress`	`STRING`	Address designated to receive refunds for unused gas or failed cross-chain message execution. Hex-encoded, 0x-prefixed, 42-character string.
`in__zroPaymentAddress`	`STRING`	Address designated for payment in ZRO tokens for LayerZero cross-chain message fees. Hex-encoded, 0x-prefixed, 42-character string, typically set to zero address when fees are paid in native tokens.
`in__adapterParams`	`STRING`	Configuration parameters for LayerZero cross-chain message delivery controlling gas settings and execution options. Hex-encoded byte string including 0x prefix.

Sample Data

gas	value	status	gas_used	signature	to_address	in__payload	block_number	from_address	trace_address	in__dstChainId	block_timestamp	in__destination	transaction_hash	in__adapterParams	in__refundAddress	in__zroPaymentAddress
54214	1352922249571558	false	53815	0xc5803100	0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675	0x0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000d000000000000000000000000000000000000000000000000000000000000000d00000000000000000000000000000000000000000000000000000000003d090000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000847a7bb6cf56645e280000000000000000000000000000000000000000000000000001918b325b3b810000000000000000000000000000000000000000000000000000000315f0ea50000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003aa0e163f3000000000000000000000000000000000000000000000000000191c8e92d89c400000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000014b6184450f75ad46f79ffbfd5b859f9bf55f534ae00000000000000000000000000000000000000000000000000000000000000000000000000000000000001800000000000000000000000007d1b001b69d64d782dd3a795f8a276c46a7339950000000000000000000000000a7ad1eafe5586787f217f5c57684a4494b0d5a500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a7ad1eafe5586787f217f5c57684a4494b0d5a50000000000000000000000000000000000000000000000000001902d7bb3800000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004440c10f190000000000000000000000007d1b001b69d64d782dd3a795f8a276c46a733995000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000	17847618	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	5,6,1	111	2023-08-05T08:36:35.000Z	0x701a95707a0290ac8b90b3719e8ee5b210360883296f55f8fb28e498b858d0bcda06d955b2cb3f97	0x9c53304ae08a0d839d9deed7a169935cce3a6441e1f0105485df81ab02e07cb7	0x000100000000000000000000000000000000000000000000000000000000003fb498	0x7d1b001b69d64d782dd3a795f8a276c46a733995	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97
61835	683204339197709	false	61312	0xc5803100	0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675	0x00000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc25936b835deb5a5d76d0aca8e08d08e34b3bbaa1459dd2b26dffed56b4038f1c600000000000032c8	17848127	0x50002cdfe7ccb0c41f519c6eb0653158d11cd907	1	108	2023-08-05T10:19:23.000Z	0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa50002cdfe7ccb0c41f519c6eb0653158d11cd907	0x6c07c725e05753dfc5e8df66012666b7be6c4fd25576ce15481a80aab58de360	0x00020000000000000000000000000000000000000000000000000000000000002710000000000000000000000000000000000000000000000000000000000007f0d05936b835deb5a5d76d0aca8e08d08e34b3bbaa1459dd2b26dffed56b4038f1c6	0xf89be7f8e9b3e5bde7c17781c6b0263e1b76ccdf	0x0000000000000000000000000000000000000000
71970	704593992173118	false	70922	0xc5803100	0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675	0x0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000d000000000000000000000000000000000000000000000000000000000000000d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f0deacb4767e29c2780000000000000000000000000000000000000000000000000d5f6f9ecebf274700000000000000000000000000000000000000000000000000001a4f340e9e7f000000000000000000000000000000000000000000000000000229ac42103a5e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000229ac42103a5e0000000000000000000000000000000000000000000000000d63dd4686ee3a8200000000000000000000000000000000000000000000000000000000000001c0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000142794d749a8d3b7105e6c1fff40a43f3a6ac8b2ce0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	17846977	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	2,6,1	110	2023-08-05T06:27:23.000Z	0x352d8275aae3e0c2404d9f68f6cee084b5beb3dd296f55f8fb28e498b858d0bcda06d955b2cb3f97	0xb345366273ff8f30a272b358f7a16367f618adbce9d1fbcf188bac6d33a342a1	0x0001000000000000000000000000000000000000000000000000000000000002ab98	0x2794d749a8d3b7105e6c1fff40a43f3a6ac8b2ce	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.Endpoint_send_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EndpointV1_send_function

LayerZero V1 endpoint send function calls initiating cross-chain message transfers. Contains source chain transaction details, destination chain identifiers, message payloads, gas parameters, and refund addresses for tracking omnichain messaging activity.

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__dstChainId`	`STRING`	LayerZero chain identifier for the destination blockchain. String-encoded integer representing the target chain in cross-chain message transfers.
`in__destination`	`STRING`	Concatenated address pair used in LayerZero cross-chain messaging to specify source and destination contracts. 84-character hex string without 0x prefix, consisting of two 42-character addresses concatenated together.
`in__payload`	`STRING`	Application-specific message data sent in LayerZero cross-chain transactions. Hex-encoded byte string including 0x prefix, containing contract function calls, token transfer details, or other custom protocol messages.
`in__refundAddress`	`STRING`	Address designated to receive refunds for unused gas or failed cross-chain message execution. Hex-encoded, 0x-prefixed, 42-character string.
`in__zroPaymentAddress`	`STRING`	Address designated for payment in ZRO tokens for LayerZero cross-chain message fees. Hex-encoded, 0x-prefixed, 42-character string, typically set to zero address when fees are paid in native tokens.
`in__adapterParams`	`STRING`	Configuration parameters for LayerZero cross-chain message delivery controlling gas settings and execution options. Hex-encoded byte string including 0x prefix.

Sample Data

gas	value	status	gas_used	signature	to_address	in__payload	block_number	from_address	trace_address	in__dstChainId	block_timestamp	in__destination	transaction_hash	in__adapterParams	in__refundAddress	in__zroPaymentAddress
201168	5736891592594260	true	110004	0xc5803100	0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675	0x000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012fdcbf00000000000000000000000000000000000000000000000040a06f5417e911650000000000000000000000000000000000000000000000000000000000000012	15223989	0x82be83e303ed594df25166bf485a57c4cfaaf775	1	2	2022-07-27T10:28:37.000Z	0x02a228d826cbb1c0e8765a6db6e7ab64eaa80bfd	0x1533fd7faaae917e7b6dfaf73ae408a119b6e17e5c572cd3365b82c869014555	0x0001000000000000000000000000000000000000000000000000000000000000c350	0x82be83e303ed594df25166bf485a57c4cfaaf775	0x0000000000000000000000000000000000000000
201168	5234727600767830	true	110004	0xc5803100	0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675	0x000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012fd32b00000000000000000000000000000000000000000000000040a38eb5579172180000000000000000000000000000000000000000000000000000000000000012	15223406	0x82be83e303ed594df25166bf485a57c4cfaaf775	1	2	2022-07-27T08:21:41.000Z	0x02a228d826cbb1c0e8765a6db6e7ab64eaa80bfd	0x06b2f70812dc3f0b662c3df9bb1ee0b73130c853d672e07c9de5073cbc764cbf	0x0001000000000000000000000000000000000000000000000000000000000000c350	0x82be83e303ed594df25166bf485a57c4cfaaf775	0x0000000000000000000000000000000000000000
201168	4732563608941400	true	110004	0xc5803100	0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675	0x000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012fb245000000000000000000000000000000000000000000000002865d7fd6996797320000000000000000000000000000000000000000000000000000000000000012	15222413	0x82be83e303ed594df25166bf485a57c4cfaaf775	1	2	2022-07-27T04:38:10.000Z	0x02a228d826cbb1c0e8765a6db6e7ab64eaa80bfd	0x230e52f273e568bdb414b35d6bdf882781d51e6c91b5cde5a65d206ca4e84054	0x0001000000000000000000000000000000000000000000000000000000000000c350	0x82be83e303ed594df25166bf485a57c4cfaaf775	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.EndpointV1_send_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

OFT_SendToChain_event

LayerZero OFT (Omnichain Fungible Token) cross-chain send events recording token transfers from the source chain to destination chains. Contains sender address, recipient address, token amount, and destination chain identifier for tracking omnichain token 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_dstChainId`	`STRING`	Destination chain identifier for cross-chain operations. String-encoded integer representing the target blockchain in LayerZero’s chain ID system.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	in_toAddress	in_dstChainId	block_timestamp	transaction_hash
0x14b4106b754954387c48bca8e7e8e003c9356e53	0xc0fdf38ca6761f20cb47ea9c5a620565ad79c2e7	false	30679290000000000000000	276	22045777	0x000000000000000000000000c0fdf38ca6761f20cb47ea9c5a620565ad79c2e7	102	2025-03-14T14:41:47.000Z	0x2d615aa0034fac34e99625b4af873488ad8787bd7c5420d38ce3baebad37877a
0x14b4106b754954387c48bca8e7e8e003c9356e53	0xbdf14197f933c6d3f0cc768b91aada9570d808e7	false	6993000000000000000	547	22045771	0x000000000000000000000000bdf14197f933c6d3f0cc768b91aada9570d808e7	102	2025-03-14T14:40:35.000Z	0x8bb939cac5fa8c25a29af101fdde4a970177047362d582232c7678797a3d6f08
0x14b4106b754954387c48bca8e7e8e003c9356e53	0xbdf14197f933c6d3f0cc768b91aada9570d808e7	false	4995000000000000000	161	22045758	0x000000000000000000000000bdf14197f933c6d3f0cc768b91aada9570d808e7	102	2025-03-14T14:37:59.000Z	0x7019e4dc3194f79b4ea2e15939420aa3e4f588f511cd1894efa414e4b6f4167e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.OFT_SendToChain_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ReceiveUln301_PacketDelivered_event

LayerZero V2 UltraLight Node (ULN) 301 packet delivery confirmation events emitted when cross-chain messages are successfully received on the destination chain. Contains origin chain endpoint identifier (srcEid), sender address, message nonce, and destination receiver address for tracking message execution across LayerZero-connected 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_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
0x245b6e8ffe9ea5fc301e32d16f66bd4c2123eefc	false	{“nonce”:“9309”,“sender”:“0x000000000000000000000000b274202daba6ae180c665b4fbe59857b7c3a8091”,“srcEid”:“102”}	43	0x152649ea73beab28c5b49b26eb48f7ead6d4c898	22830484	2025-07-02T08:55:59.000Z	0xaf2ea16316417289016fa12a3b617910249bbb48c0b552a14b73a7feeb509674
0x245b6e8ffe9ea5fc301e32d16f66bd4c2123eefc	false	{“nonce”:“9307”,“sender”:“0x000000000000000000000000b274202daba6ae180c665b4fbe59857b7c3a8091”,“srcEid”:“102”}	237	0x152649ea73beab28c5b49b26eb48f7ead6d4c898	22828517	2025-07-02T02:19:47.000Z	0x7b7d722325505e1c3c1417c19759f937b44c669e1be2f973ff062e2cb7becab1
0x245b6e8ffe9ea5fc301e32d16f66bd4c2123eefc	false	{“nonce”:“9306”,“sender”:“0x000000000000000000000000b274202daba6ae180c665b4fbe59857b7c3a8091”,“srcEid”:“102”}	158	0x152649ea73beab28c5b49b26eb48f7ead6d4c898	22828426	2025-07-02T02:01:23.000Z	0xc25c8c801d570fcf337e2e9532a9d8a3cf7b751e98f51431d2eea0f6cf887430

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.ReceiveUln301_PacketDelivered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ReceiveUln302_PacketDelivered_event

Cross-chain message delivery confirmations from LayerZero V1 protocol’s Ultra Light Node (ULN) 302 on Ethereum, tracking packets received from source chains with origin details and receiver addresses. Used for monitoring cross-chain message flow and debugging LayerZero integrations across endpoint IDs (srcEid).

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
0x245b6e8ffe9ea5fc301e32d16f66bd4c2123eefc	false	{“nonce”:“1”,“sender”:“0x0000000000000000000000000da74e446a5083d1546a771a69279eb48caa4b3a”,“srcEid”:“101”}	130	0x0da74e446a5083d1546a771a69279eb48caa4b3a	22168948	2025-03-31T19:21:35.000Z	0x9033eddf3d05556606e48e2875a4a6a2f544d036b79918f914c309a27560b2a3
0x245b6e8ffe9ea5fc301e32d16f66bd4c2123eefc	false	{“nonce”:“345”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“102”}	164	0x58ff71c056942600bc4acf8bdf48f82e6ad1f392	22512255	2025-05-18T20:28:11.000Z	0x75a15f24a17543a573e507a90fbc8bf9fc010daf8194a0d3a44a441bf509fdd4
0x245b6e8ffe9ea5fc301e32d16f66bd4c2123eefc	false	{“nonce”:“346”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“102”}	187	0x58ff71c056942600bc4acf8bdf48f82e6ad1f392	22513284	2025-05-18T23:55:59.000Z	0xf091674f0313d9925624d7ca749c53a09c226f3a3fa5721814baae503381b42d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.ReceiveUln302_PacketDelivered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SendUln301_DVNFeePaid_event

DVN (Decentralized Verifier Network) fee payment events emitted by LayerZero V2 SendUln301 contracts. Records fees paid to required and optional DVNs for cross-chain message verification services.

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
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	[“2435781664281”,“2406525771157”]	false	698	22742807	2025-06-20T02:48:35.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”,“0xa59ba433ac34d2927232918ef5b2eaafcf130ba5”]	0x044eb7ab44ccf236a8aed28ce478ab4a1c7c288093ac47961a7a11271f3482bd
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	[“2435781664281”,“2406525771157”]	false	165	22742597	2025-06-20T02:06:23.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”,“0xa59ba433ac34d2927232918ef5b2eaafcf130ba5”]	0xe2aca3c492e4c054b210011e709b21f11846a21227d365d2e53acb9813b171b2
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	[“2435781664281”,“2406525771157”]	false	496	22742048	2025-06-20T00:16:23.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”,“0xa59ba433ac34d2927232918ef5b2eaafcf130ba5”]	0xdef85db7f6c5a493e162102bf36d990dbf2748d6a10545fd8c78a86916a001af

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.SendUln301_DVNFeePaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SendUln301_ExecutorFeePaid_event

Executor fee payment events from LayerZero V1 SendUln301 contracts recording cross-chain message execution costs. Contains executor address and fee amount paid for processing LayerZero message deliveries across supported blockchain networks.

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
195246514898210	0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	408	0x173272739bd7aa6e4e214714048a9fe699453059	22757069	2025-06-22T02:41:47.000Z	0xf9a8aa395bdabef2cbb085269b1f9021a5644fb3b92e50dc6f2da84278a03c4b
31023402162875	0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	702	0x173272739bd7aa6e4e214714048a9fe699453059	22762907	2025-06-22T22:17:47.000Z	0x119337d473e67f097f9a4a5f5fec042636b3d534a930bf406b4966e5283adf61
31023402162875	0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	406	0x173272739bd7aa6e4e214714048a9fe699453059	22762490	2025-06-22T20:53:59.000Z	0x8621d8b51d9d2342621ee7d8ff7289d6bcbe8307373359fb434fdb7c89e428a7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.SendUln301_ExecutorFeePaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SendUln301_NativeFeeWithdrawn_event

Native gas fee withdrawal events from LayerZero V1 SendUln301 contracts. Records user-initiated withdrawals of accumulated native token fees to specified receivers, tracking the withdrawal amount and beneficiary addresses.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol 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	in_user	removed	in_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	0x173272739bd7aa6e4e214714048a9fe699453059	false	1468376744540652	418	0xe93685f3bba03016f02bd1828badd6195988d950	22441194	2025-05-08T20:31:59.000Z	0xce123ebbad7b58a90b1932dd83bb706e98d47bc9725558924a55ac76c8fc8787
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	0x173272739bd7aa6e4e214714048a9fe699453059	false	28060054754128464	143	0xe93685f3bba03016f02bd1828badd6195988d950	19414401	2024-03-11T21:01:35.000Z	0xbe62a673cdbc94659d2c51c19913d95493ff439b31cb92dd4044ecf443606170
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	1875737797857294	81	0x21c3de23d98caddc406e3d31b25e807addf33633	19414417	2024-03-11T21:04:47.000Z	0x67079b77c54e7e5a9e57b8e02cf94cff03af2f0b6059549d11cde1e1d1eec508

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.SendUln301_NativeFeeWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SendUln301_PacketSent_event

LayerZero V1 Ultra Light Node 301 packet transmission events containing encoded cross-chain message payloads, destination chain routing information, and fee details. Used for tracking omnichain message flow and analyzing cross-chain protocol activity across LayerZero-integrated networks.

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_nativeFee`	`STRING`	Fee amount paid in native chain tokens for LayerZero cross-chain message delivery. Numeric string representing wei-denominated token amount.
`in_lzTokenFee`	`STRING`	Fee amount paid in LayerZero tokens for cross-chain message delivery. Numeric string representing wei-denominated token amount.

Sample Data

address	removed	log_index	in_options	block_number	in_nativeFee	block_timestamp	transaction_hash	in_encodedPayload
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	356	0x00010000000000000000000000000000000000000000000000000000000000030d40	22749989	33291330134685	2025-06-21T02:55:23.000Z	0x9368580223a074190e0a643cc80202f06eeb3d49c7c132e997a3bcf7a4842625	0x0100000000000017ab00000065000000000000000000000000152649ea73beab28c5b49b26eb48f7ead6d4c89800000066000000000000000000000000b274202daba6ae180c665b4fbe59857b7c3a80912176f2eb9a67380ac32737ca0f378d8491a0923512d6d811f71c95ada1bf08cb00000000000000000000000000d89d099b4ff40ea974c2bb84a17f83773614f2d700000003da0ff8af
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	357	0x00010000000000000000000000000000000000000000000000000000000000030d40	22683636	19608246260202	2025-06-11T20:14:47.000Z	0xd69a0c7b7bbe5a33bb09c0b158c926b79de0c2e3e6eda973bc2193733b1c5721	0x0100000000000001d20000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f392000000b8000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e47b89444a53f5eb34c22d921bad0a5a0c40f407056d4717e6f2dc3ca5f488d8d00000000000000000000000000ca74f404e0c7bfa35b13b511097df966d5a6559700002864780ee9ec
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	152	0x00010000000000000000000000000000000000000000000000000000000000030d40	22550273	148891362273852	2025-05-24T04:18:23.000Z	0x0a5319c1fcd3d22f14c6671e7eaff8914e39a04031171642e3cfbdad983d08ae	0x01000000000000037a0000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f3920000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7545acd32e0439fd79c7a0e80df83fa6f339700ca8e931d435b364d60f0541e190000000000000000000000000045d11f7ebbc79f18467dd534e2865d0dba6aa43500002c825a6dfabd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.SendUln301_PacketSent_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
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	[“2718385930822”,“2685735710391”]	false	355	22749989	2025-06-21T02:55:23.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”,“0xa59ba433ac34d2927232918ef5b2eaafcf130ba5”]	0x9368580223a074190e0a643cc80202f06eeb3d49c7c132e997a3bcf7a4842625
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	[“209489443617”,“209489443617”]	false	151	22550273	2025-05-24T04:18:23.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x0a5319c1fcd3d22f14c6671e7eaff8914e39a04031171642e3cfbdad983d08ae
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	[“107590036886”,“39526314253016”]	false	62	22550036	2025-05-24T03:30:23.000Z	[]	[“0x589dedbd617e0cbcb916a9223f4d1300c294236b”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0xcf2bf6c3649daa41a2de5edad9980f3fa98731e27ddda0336d0c02d0136811ee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.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
11757627372876160	0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	52	0x173272739bd7aa6e4e214714048a9fe699453059	22817685	2025-06-30T13:58:59.000Z	0x1a810dfc5c90fd505e37bdcd5ab5179c5e54452154072892050d07d8946d672c
211276413365144	0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	210	0x173272739bd7aa6e4e214714048a9fe699453059	22819218	2025-06-30T19:07:11.000Z	0x7672867045fcd1d97fdeec358bdadb412f47e7651cba69007567af058bd75338
11711845764412372	0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	123	0x173272739bd7aa6e4e214714048a9fe699453059	22818134	2025-06-30T15:28:47.000Z	0xe9db480b22b08b3008d221166ce7c8aa016bebea3aeb680ab3b2d1a72a72acb0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.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_user`	`STRING`	Address of the user account associated with the transaction or protocol 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	in_user	removed	in_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	1875737797857294	81	0x21c3de23d98caddc406e3d31b25e807addf33633	19414417	2024-03-11T21:04:47.000Z	0x67079b77c54e7e5a9e57b8e02cf94cff03af2f0b6059549d11cde1e1d1eec508
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	0x173272739bd7aa6e4e214714048a9fe699453059	false	28060054754128464	143	0xe93685f3bba03016f02bd1828badd6195988d950	19414401	2024-03-11T21:01:35.000Z	0xbe62a673cdbc94659d2c51c19913d95493ff439b31cb92dd4044ecf443606170
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	0x173272739bd7aa6e4e214714048a9fe699453059	false	1468376744540652	418	0xe93685f3bba03016f02bd1828badd6195988d950	22441194	2025-05-08T20:31:59.000Z	0xce123ebbad7b58a90b1932dd83bb706e98d47bc9725558924a55ac76c8fc8787

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.SendUln302_NativeFeeWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SendUln302_PacketSent_event

PacketSent events from LayerZero V1’s Ultra Light Node 302 (ULN302) contract on Ethereum, capturing cross-chain message transmissions with encoded payloads, destination chain routing, and native fee amounts. Used for tracking LayerZero bridge activity and analyzing cross-chain messaging patterns.

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_nativeFee`	`STRING`	Fee amount paid in native chain tokens for LayerZero cross-chain message delivery. Numeric string representing wei-denominated token amount.
`in_lzTokenFee`	`STRING`	Fee amount paid in LayerZero tokens for cross-chain message delivery. Numeric string representing wei-denominated token amount.

Sample Data

address	removed	log_index	in_options	block_number	in_nativeFee	block_timestamp	transaction_hash	in_encodedPayload
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	388	0x00010000000000000000000000000000000000000000000000000000000000030d40	22867720	145506721250933	2025-07-07T13:49:35.000Z	0x7ea695ea8b20ea9e31d0b493fe4cf18d093e51645d91bf38172212dfe7e8d4cf	0x0100000000000000370000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f3920000006f000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5ec94dc7ce84e6ba7d7f3b44e473a146f9178c397f0f3573da0642f06927df0b5e00000000000000000000000000ca74f404e0c7bfa35b13b511097df966d5a6559700001809512d699f
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	58	0x00010000000000000000000000000000000000000000000000000000000000030d40	22867703	146380278071837	2025-07-07T13:46:11.000Z	0x73fadbbd39fc0b3d91b89426daa4420a95dd7feb1a756eb9a2d77d662b64dcbb	0x0100000000000003ca0000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f3920000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7da83dcc114c0cdad76262145509bb508e28f54e0e5618763418a03fadbe4316900000000000000000000000000ca74f404e0c7bfa35b13b511097df966d5a6559700003021e0955bd4
0xd231084bfb234c107d3ee2b22f97f3346fdaf705	false	402	0x00010000000000000000000000000000000000000000000000000000000000030d40	22867702	146380278071837	2025-07-07T13:45:59.000Z	0x6df805339c0bb17e6314260bfd7c9b71501bf9c039c3534286a89ce0ff245dbb	0x0100000000000003c90000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f3920000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7c36f3974518da4baf056002e988d58dec3c3b097cab2e0d87ae4516a3f3b3cee0000000000000000000000000045d11f7ebbc79f18467dd534e2865d0dba6aa435000030363bb30c33

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.SendUln302_PacketSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StargateV1_SendToChain_event

Cross-chain token transfer events from Stargate V1 protocol recording asset movements between LayerZero-connected chains. Contains destination chain identifier, transfer quantity, recipient address, and transaction metadata for tracking bridge flow analytics.

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_dstChainId`	`STRING`	Destination chain identifier for cross-chain operations. String-encoded integer representing the target blockchain in LayerZero’s chain ID system.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.

Sample Data

in_to	in_qty	address	removed	log_index	block_number	in_dstChainId	block_timestamp	transaction_hash
0x35e3a5f9a59a441f5b87416ed68eb99753e59171	13141181699315430879	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	false	550	14983414	10	2022-06-18T05:53:35.000Z	0x660c2927d272e9506d1eb05ce0e6db8fa757238e8008fce83a7b8c07a3d89ed8
0x35e3a5f9a59a441f5b87416ed68eb99753e59171	5282334416642666411	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	false	490	14983016	10	2022-06-18T04:17:01.000Z	0x0ac3f40d988cd99e763a7d06618226692e0cc105e071aed0dd4d1e233fc16645
0x885f4a59c283bbbf72a0c56f9a4637180705c4fd	1183143035424067472344	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	false	112	14983433	6	2022-06-18T05:56:57.000Z	0xde3c7581dfba03628d5f5506011088b64db1326749d67cc690608e545dde0415

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.StargateV1_SendToChain_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StargateV1_Swap_event

Cross-chain token swap events from Stargate V1 protocol via LayerZero messaging. Contains swap amounts, source/destination chain identifiers, pool IDs, fee breakdowns (equilibrium, liquidity provider, protocol), and rewards for analyzing cross-chain liquidity flows.

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_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_dstPoolId`	`STRING`	Identifier for the destination Stargate liquidity pool in a cross-chain swap operation. Numeric string representing the pool ID on the target chain.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSD`	`STRING`	Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.
`in_eqReward`	`STRING`	Reward amount credited for equilibrium rebalancing in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_eqFee`	`STRING`	Fee charged for equilibrium adjustment in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_protocolFee`	`STRING`	Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.
`in_lpFee`	`STRING`	Fee collected by liquidity providers from the swap transaction. Numeric string representation without decimals.

Sample Data

address	in_from	removed	in_eqFee	log_index	in_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0xdf0770df86a8034b3efef0a1bb3c889b8332ff56	0x011e52e4e40cf9498c79273329e8827b21e2e581	false	464	156	102	15452661	16633654	2	15003	2023-02-15T10:49:35.000Z	0x84d32d46833835ca27f6604db3052ae44d77fb523739ebbf3f7551056d2f6b8b
0xdf0770df86a8034b3efef0a1bb3c889b8332ff56	0x04372ad102bfe771c7837033ed2534de66e03b29	false	61950	161	102	2062935000	16633950	2	2003050	2023-02-15T11:50:11.000Z	0x56aa049b7952e6c7f857957d32166349f347b5705c3edb50c8e8cf2dff5f3b12
0x38ea452219524bb87e18de1c24d3bb59510bd783	0x0bcaf6b6437646a5d843f55cc06463b92d490f9c	false	225000	158	102	7495500000	16636733	2	4275000	2023-02-15T21:10:47.000Z	0x0113dc136208b559551aaf4eaf95b8ee4cfa2b5b38a401c63c37bb5b88e78129

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_ethereum.StargateV1_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Endpoint_send_function

EndpointV1_send_function

OFT_SendToChain_event

ReceiveUln301_PacketDelivered_event

ReceiveUln302_PacketDelivered_event

SendUln301_DVNFeePaid_event

SendUln301_ExecutorFeePaid_event

SendUln301_NativeFeeWithdrawn_event

SendUln301_PacketSent_event

SendUln302_DVNFeePaid_event

SendUln302_ExecutorFeePaid_event

SendUln302_NativeFeeWithdrawn_event

SendUln302_PacketSent_event

StargateV1_SendToChain_event

StargateV1_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Endpoint_send_function

​EndpointV1_send_function

​OFT_SendToChain_event

​ReceiveUln301_PacketDelivered_event

​ReceiveUln302_PacketDelivered_event

​SendUln301_DVNFeePaid_event

​SendUln301_ExecutorFeePaid_event

​SendUln301_NativeFeeWithdrawn_event

​SendUln301_PacketSent_event

​SendUln302_DVNFeePaid_event

​SendUln302_ExecutorFeePaid_event

​SendUln302_NativeFeeWithdrawn_event

​SendUln302_PacketSent_event

​StargateV1_SendToChain_event

​StargateV1_Swap_event

Tables

Endpoint_send_function

EndpointV1_send_function

OFT_SendToChain_event

ReceiveUln301_PacketDelivered_event

ReceiveUln302_PacketDelivered_event

SendUln301_DVNFeePaid_event

SendUln301_ExecutorFeePaid_event

SendUln301_NativeFeeWithdrawn_event

SendUln301_PacketSent_event

SendUln302_DVNFeePaid_event

SendUln302_ExecutorFeePaid_event

SendUln302_NativeFeeWithdrawn_event

SendUln302_PacketSent_event

StargateV1_SendToChain_event

StargateV1_Swap_event