layerzero_v1_polygon

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`	`NUMERIC`	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
7611	45995230884576450	false	7611	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000014d99f41c31bbcc0450a5a4438e8554e21e60d6f3a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000170f952	50006519	0xa184998ec58dc1da77a1f9f1e361541257a50cf4	0	138	2023-11-16T08:17:29.000Z	0xffd57b46bd670b0461c7c3ebbaedc4cdb7c4fb80a184998ec58dc1da77a1f9f1e361541257a50cf4	0x6b0067f567e302a63c8701910818ba9d767d1d73e68c78d814d249f9d8edc742	0x00010000000000000000000000000000000000000000000000000000000000061a80	0xd99f41c31bbcc0450a5a4438e8554e21e60d6f3a	0x0000000000000000000000000000000000000000
21828	78940252944968290	false	21828	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000016345785d8a0000000000000000000000000000000000000000000000000000000000000000001473088d88d40eb7e6c40026da6fae8b2ef60c27bb000000000000000000000000	50025870	0x0c1ebbb61374da1a8c57cb6681bf27178360d36f	0,2	145	2023-11-16T19:51:21.000Z	0xfa5ed56a203466cbbc2430a43c66b9d8723528e70c1ebbb61374da1a8c57cb6681bf27178360d36f	0x49e3eb5c5a071d3e2d37a54d31a87c2135728f3f65ff99a028bd15cd8a9ad048	0x00010000000000000000000000000000000000000000000000000000000000030d40	0x73088d88d40eb7e6c40026da6fae8b2ef60c27bb	0x0000000000000000000000000000000000000000
21831	53619590787554424	false	21831	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000195f2f06cd8400000000000000000000000000000000000000000000000000000000000000001451731946cb353964e924999f2f74f5516c41bda7000000000000000000000000	50003616	0x0c1ebbb61374da1a8c57cb6681bf27178360d36f	0,2	125	2023-11-16T06:33:47.000Z	0xf1ddcaca7d17f8030ab2eb54f2d9811365efe1230c1ebbb61374da1a8c57cb6681bf27178360d36f	0x9f7e08b6fc77c2e3bbd6be72ae387cadfb4670138d681140c8c8de6654e409e1	0x00010000000000000000000000000000000000000000000000000000000000030d40	0x51731946cb353964e924999f2f74f5516c41bda7	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.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`	`NUMERIC`	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	block_number	from_address	block_timestamp	transaction_hash
113176	9155922261168765000	false	102760	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	30999693	0xacf63e56fd08970b43401492a02f6f38b6635c91	2022-07-22T04:45:08.000Z	0x0fdc52cd3ca4626aa57c9e55ada3a42604969b2a1fef84d305cb7abd00309177
113176	9155922261168765000	false	102760	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	30999693	0xacf63e56fd08970b43401492a02f6f38b6635c91	2022-07-22T04:45:08.000Z	0x1b4082bfccd93bc71c87c38a7835c1dae7b5799518db8adb6611c9fb6549bbb0
113176	9155922261168765000	false	102760	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	30999693	0xacf63e56fd08970b43401492a02f6f38b6635c91	2022-07-22T04:45:08.000Z	0x74dc5b096fd079e51f0839c701001f467cc821dc071b018600d3b25b671b7244

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.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
0x110b25d2b21ee73eb401f3ae7833f7072912a0bf	0x82573c3012b40ed72f963677e0232734c5fdd5aa	false	70741949779800000000000	27	59561272	0x00000000000000000000000082573c3012b40ed72f963677e0232734c5fdd5aa	112	2024-07-19T19:00:14.000Z	0x88abeb8f94d8b598bced119f5d009ce29a329bf65992e852f3f33e89d77723db
0x110b25d2b21ee73eb401f3ae7833f7072912a0bf	0x82573c3012b40ed72f963677e0232734c5fdd5aa	false	71386141915600000000000	12	59561254	0x00000000000000000000000082573c3012b40ed72f963677e0232734c5fdd5aa	112	2024-07-19T18:59:36.000Z	0x42563b98c408e8c30f2134b375a3afe60f4b410f6a06fc0aac80dbc4cc5a4995
0x110b25d2b21ee73eb401f3ae7833f7072912a0bf	0x82573c3012b40ed72f963677e0232734c5fdd5aa	false	72106497815600000000000	12	59561206	0x00000000000000000000000082573c3012b40ed72f963677e0232734c5fdd5aa	112	2024-07-19T18:57:54.000Z	0xa38fc1e9802faafd712c5cc0580a3831f4bed1028e5f102da8aa61e8d7bc28c4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.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
0x3823094993190fbb3bfabfec8365b8c18517566f	false	{“nonce”:“609”,“sender”:“0x00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7”,“srcEid”:“106”}	189	0x11cd72f7a4b699c67f225ca8abb20bc9f8db90c7	79265783	2025-11-20T11:03:17.000Z	0x75539c61d33e0af316aa64656bc21dbde8f03c945fcaf5e383eee529bb2954a7
0x3823094993190fbb3bfabfec8365b8c18517566f	false	{“nonce”:“340”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“102”}	144	0x11cd72f7a4b699c67f225ca8abb20bc9f8db90c7	73622516	2025-07-05T21:10:35.000Z	0x8d7240196f82d42483f55175b25a6a080fa958503e88b2c214237791857ca943
0x3823094993190fbb3bfabfec8365b8c18517566f	false	{“nonce”:“339”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“102”}	72	0x11cd72f7a4b699c67f225ca8abb20bc9f8db90c7	72909771	2025-06-18T06:33:20.000Z	0xa5760d0eb0cb47f4a4728ea099286bd973c70142af1afe2c8e79d8459f439ebf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.ReceiveUln301_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
0x5727e81a40015961145330d91cc27b5e189ff3e1	[“2686274049356191”,“520480684427531486”]	false	412	72987818	2025-06-20T04:44:21.000Z	[]	[“0x23de2fe932d9043291f870324b74f820e11dc81a”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x88cf6f840e8645a87c6bde54421a62718e12eee6bf86a87692159863c2c7ac2b
0x5727e81a40015961145330d91cc27b5e189ff3e1	[“31786484347627038”,“31786484347627038”]	false	379	72997756	2025-06-20T10:37:09.000Z	[]	[“0x23de2fe932d9043291f870324b74f820e11dc81a”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x8019bac77e814397d458ccb153f1eeceaa07f516a29bbeb23ee0f63ae1fbe5a2
0x5727e81a40015961145330d91cc27b5e189ff3e1	[“809201449399005378”,“809201449399005378”]	false	6	72989589	2025-06-20T05:47:31.000Z	[]	[“0x23de2fe932d9043291f870324b74f820e11dc81a”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x2d76d13a4d8579058860d8244a6eaf5e924d5f63dd1c5f7eb604ba69a0bbb56d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.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
2166815994923783115	0x5727e81a40015961145330d91cc27b5e189ff3e1	false	278	0xcd3f213ad101472e1713c72b1697e727c803885b	73547728	2025-07-04T00:58:03.000Z	0xab2727fbff6ec03818acc53b9d4c0b4a938a64f1c5c229d59aa43899d8b2066d
2201357209935550683	0x5727e81a40015961145330d91cc27b5e189ff3e1	false	324	0xcd3f213ad101472e1713c72b1697e727c803885b	73547378	2025-07-04T00:45:37.000Z	0x48890bbf8b4b33da84dc71c97a53b4a8e696ecfc34c72393fbdc7fddda43a9c1
2851695376469757561	0x5727e81a40015961145330d91cc27b5e189ff3e1	false	281	0xcd3f213ad101472e1713c72b1697e727c803885b	73548171	2025-07-04T01:13:49.000Z	0x88346254ff20d59cbbbc2eccefd74a78d7373c06912d5983aa616fbd55282714

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.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
0x5727e81a40015961145330d91cc27b5e189ff3e1	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	3487455047076057	9	0x21c3de23d98caddc406e3d31b25e807addf33633	54315612	2024-03-06T01:47:30.000Z	0xfa88200384578623b8e2f3a0f4d63f66430d9b80eea4886be9bddbf5c2a7a4ea
0x5727e81a40015961145330d91cc27b5e189ff3e1	0xcd3f213ad101472e1713c72b1697e727c803885b	false	40049983254445122894	272	0xe93685f3bba03016f02bd1828badd6195988d950	54316010	2024-03-06T02:02:24.000Z	0x976cbc65c6dcc643d5eea5e169a666d912022308d7a70d3f6108db88420f7a08
0x5727e81a40015961145330d91cc27b5e189ff3e1	0xcd3f213ad101472e1713c72b1697e727c803885b	false	100000000000000000000	37	0x339d413ccefd986b1b3647a9cfa9cbbe70a30749	80996816	2025-12-30T16:41:15.000Z	0x360f1b6228987645a54d6ecb2e159e65adad0833a50cf9decdfcc234ae6a62bd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.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
0x5727e81a40015961145330d91cc27b5e189ff3e1	false	753	0x00010000000000000000000000000000000000000000000000000000000000030d40	74016173	1580335741466411512	2025-07-16T04:54:06.000Z	0x78058b2af3cb8b5968a66be5f8dafd362d51e67c0e20dc16591f3d8bf33ae930	0x0100000000000001c20000006d00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c70000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7bd1dd8daee574a2266aaf6cab2646a5b3054e31bbcef83413507bca9f3779e9c000000000000000000000000007e8fbbdef68a2a965646fb95847fd8773cd2afc500000f18c3abcf1f
0x5727e81a40015961145330d91cc27b5e189ff3e1	false	766	0x00010000000000000000000000000000000000000000000000000000000000030d40	74024756	1711427211131475034	2025-07-16T10:04:24.000Z	0x871b93caa6370eb21d211229d4015f8113f3dbe6b284cf815fcc2a396d22839c	0x01000000000000011c0000006d00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c70000006600000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7234aeb25af28464a9973a4e469797ef752aa1ba610f8e3ab1e93ebbfffecf29300000000000000000000000000d68dcec4b7c992afafbb50bd79387a5aedb9aa150000006055a1ffe7
0x5727e81a40015961145330d91cc27b5e189ff3e1	false	315	0x00010000000000000000000000000000000000000000000000000000000000030d40	74016041	1659368431667166052	2025-07-16T04:49:26.000Z	0x21ed2d0c5193a064d62732e728f53c75dc2db414a0c174caf51eaea0458ee2a5	0x0100000000000000e00000006d00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c70000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e916fa00552eedc459cffef5ac3b029e41fd538397866502b44105f295dc3b89100000000000000000000000000c004c58ce7cdd5aed53e2f268d7a494341990f06000005866c637ef5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.SendUln301_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
0x0c13317b02fcd71dd2f3623b42cebe063edacb76	13080000000000000000	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	167	32289004	10	2022-08-25T02:10:21.000Z	0x3931cd6d25040ad35360065c5e73c97fc132b358e77dcc413d886748e6a46282
0x40cb16980dec30df798e7d34336ba6da4de510f6	194284017834598820305	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	200	32299248	10	2022-08-25T08:26:46.000Z	0x8ac6365db53612896023037b4f3dfe35e41e9901f572f89eb7e66125ee0d0dcf
0x67c9f6bae63ef1cca260796db5d0fcc3b423092b	991178483525547175235	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	303	32298570	12	2022-08-25T08:03:28.000Z	0x6dc450d2f03686af06d74a8d955761f98995c7400a7beb028685e6f92e3545c8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_polygon.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
0x1205f31718499dbf1fca446663b532ef87481fe1	0x652e9a2b260bd1ce3155e4af229e48fec1720023	false	749864	546	101	24980481285	51783030	1	14247422	2023-12-31T15:09:58.000Z	0x50f143dfb877858550ca9d2b27d43e7b765d4b4f76013daa50248019e3c451bd
0x1205f31718499dbf1fca446663b532ef87481fe1	0xecc19e177d24551aa7ed6bc6fe566eca726cc8a9	false	94965	326	101	3163601120	51784002	1	1804335	2023-12-31T15:44:24.000Z	0xf9aac0ae6b2fea17ee3c688f0ff1b3d80d6b33a36dd7d6ec513fcc10001cf9a5
0x1205f31718499dbf1fca446663b532ef87481fe1	0xecc19e177d24551aa7ed6bc6fe566eca726cc8a9	false	146573	775	101	4882854413	51772078	1	2784897	2023-12-31T08:40:22.000Z	0xb339e142d86d36067ab6b9eb6961005c18f8af4cc0b0351eee6f2e045ddc4cfe

Example Query

Query with partition filter

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

SendUln301_DVNFeePaid_event

SendUln301_ExecutorFeePaid_event

SendUln301_NativeFeeWithdrawn_event

SendUln301_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

​SendUln301_DVNFeePaid_event

​SendUln301_ExecutorFeePaid_event

​SendUln301_NativeFeeWithdrawn_event

​SendUln301_PacketSent_event

​StargateV1_SendToChain_event

​StargateV1_Swap_event

Tables

Endpoint_send_function

EndpointV1_send_function

OFT_SendToChain_event

ReceiveUln301_PacketDelivered_event

SendUln301_DVNFeePaid_event

SendUln301_ExecutorFeePaid_event

SendUln301_NativeFeeWithdrawn_event

SendUln301_PacketSent_event

StargateV1_SendToChain_event

StargateV1_Swap_event