layerzero_v1_optimism

Tables

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
62499	13047560628538	false	61226	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x16f1be70000000000000000000000000000000000000000000000000000000000000ea4500000000000000000000000000000000000000000000000000000000000000070000000000000000000000001810e6d63fe389b2580133c8da17944d3bab5e6f00000000000000000000000082904fa267ec9588e5cd5a91ec28ea11ea69182f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009d3cc4857590000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000fbf054d38045676ab85884bee6d5d5720ac0d1d3000000000000000000000000fbf054d38045676ab85884bee6d5d5720ac0d1d30000000000000000000000000000000000000000000000000000000000003bcd0000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000777310000000000000000000000000000000000000000000000000000000000e4e1c7	121233313	0x7969414aa6958a44e276e9c3c5f28c5bc42e0271	0,2,0,5,0,1	195	2024-06-11T00:23:23.000Z	0x7969414aa6958a44e276e9c3c5f28c5bc42e02717969414aa6958a44e276e9c3c5f28c5bc42e0271	0x9d80e71d290faa9f2cd765e81e57edc457492f9c99b4af2178ab9a1ce28df2bc	0x0001000000000000000000000000000000000000000000000000000000000001e014	0xfbf054d38045676ab85884bee6d5d5720ac0d1d3	0x7969414aa6958a44e276e9c3c5f28c5bc42e0271
1052546	108916561228235	true	66789	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x0000000000000000000000003a3f74439b6b44d7d591535ca01d158fe1e4d5350000000000000000000000000000000000000000000000075a45e782845ea21f	121253262	0x98cbcd43f28bc0a7bf058191dbe3ad3bd9b49fe6	5,0,16,0,5,0,0,0,10,4	110	2024-06-11T11:28:21.000Z	0x79a124080c2d08eddde62181a5256ecc6580aec798cbcd43f28bc0a7bf058191dbe3ad3bd9b49fe6	0x3ff7bc44c4f9963708129f14b09a6b350198b5ebcc1660dee2e77955c37912ca	0x000100000000000000000000000000000000000000000000000000000000001e8480	0x3a3f74439b6b44d7d591535ca01d158fe1e4d535	0x0000000000000000000000000000000000000000
3248359	191421269374635	true	66789	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x000000000000000000000000ed20c6928644893cd1358fd548ca1ea246b2fec40000000000000000000000000000000000000000000000009f57543efddf0780	121261736	0x98cbcd43f28bc0a7bf058191dbe3ad3bd9b49fe6	0,8,4	110	2024-06-11T16:10:49.000Z	0x79a124080c2d08eddde62181a5256ecc6580aec798cbcd43f28bc0a7bf058191dbe3ad3bd9b49fe6	0xa4d8b7f6137e252a73dca0d51c5a6593ceb2fb2926d58a1a74dafd9b90177c48	0x000100000000000000000000000000000000000000000000000000000000001e8480	0xed20c6928644893cd1358fd548ca1ea246b2fec4	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_optimism.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
0x2297aebd383787a160dd0d9f71508148769342e3	0x63fa319a44517f0c41e7902b2aa016e83fda17aa	false	343605	32	110754689	0x00000000000000000000000063fa319a44517f0c41e7902b2aa016e83fda17aa	102	2023-10-12T10:55:55.000Z	0x7a7e842f5500dfdd9f2cec5d781952ea578e65dc4c8779efaddd70461736f4c6
0x2297aebd383787a160dd0d9f71508148769342e3	0x2ffb08d2eaebf4ab733e5422be6258f63f3f2bef	false	25652	72	110765936	0x0000000000000000000000002ffb08d2eaebf4ab733e5422be6258f63f3f2bef	102	2023-10-12T17:10:49.000Z	0x5114224dc8dc46518f5b05e622b3b0e864b747774aed62ce0e799112ba4e39e7
0x2297aebd383787a160dd0d9f71508148769342e3	0xbaa064b889f8f2a96593f979977e951cdf391523	false	4244	18	110752398	0x000000000000000000000000baa064b889f8f2a96593f979977e951cdf391523	102	2023-10-12T09:39:33.000Z	0xc70012eb240282f006c3de995d9ca8bf7bc7d0b6372bca770594803fbac42657

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_optimism.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
0x6c9ae31dfb56699d6bd553146f653dcec3b174fe	false	{“nonce”:“354”,“sender”:“0x00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7”,“srcEid”:“106”}	66	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	136163860	2025-05-22T15:08:17.000Z	0x1f22831560047f3a834f43a229062e516812b274ad4cd52adb000933cc60035e
0x6c9ae31dfb56699d6bd553146f653dcec3b174fe	false	{“nonce”:“587”,“sender”:“0x000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e”,“srcEid”:“184”}	88	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	136147293	2025-05-22T05:56:03.000Z	0x9c8a393ef396ad2696059aff394b35bef0087ea99f8903afa25438b9c9a66685
0x6c9ae31dfb56699d6bd553146f653dcec3b174fe	false	{“nonce”:“238”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“102”}	3	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	136909718	2025-06-08T21:30:13.000Z	0xd0cd6d5edf76b61735252b93030fe09f3cb4809d53d0ad60349688e6a22d2798

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_optimism.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
0x3823094993190fbb3bfabfec8365b8c18517566f	[“260805850146”,“260805850146”]	false	474	137946245	2025-07-02T21:21:07.000Z	[]	[“0x6a02d83e8d433304bba74ef1c427913958187142”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x3f3f7365d6e3c7ad9150ce8119a544f086de6635ba48f0c6956f14cae8972186
0x3823094993190fbb3bfabfec8365b8c18517566f	[“2343084000000”,“2343084000000”]	false	23	137924912	2025-07-02T09:30:01.000Z	[]	[“0x6a02d83e8d433304bba74ef1c427913958187142”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0xc14f47edfaeaf1424004716b7d892fb86c4fa71dc755e503e3385e4b8279001d
0x3823094993190fbb3bfabfec8365b8c18517566f	[“306841990581”,“306841990581”]	false	31	137928125	2025-07-02T11:17:07.000Z	[]	[“0x6a02d83e8d433304bba74ef1c427913958187142”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x21dd968ba659fa8e0282077c65662c9320b0d6beffb1d979d54f0950c150738c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_optimism.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
1263319867981458	0x3823094993190fbb3bfabfec8365b8c18517566f	false	28	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	136666058	2025-06-03T06:08:13.000Z	0x5f225384a5c177d563bfcd85f73817ba2dc2a3b9b11e7a10f27072717b486194
149248871616342	0x3823094993190fbb3bfabfec8365b8c18517566f	false	92	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	136669257	2025-06-03T07:54:51.000Z	0xe4403e8ace87783e24ded22418878b274e62ae33cab6b1f408d1e498c6a1ccc5
149561299530685	0x3823094993190fbb3bfabfec8365b8c18517566f	false	21	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	136668916	2025-06-03T07:43:29.000Z	0x75ecb488542a33ab285e6c3ad405d4eab1cc33032e4f5fc30cdb41774d676cc8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_optimism.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
0x3823094993190fbb3bfabfec8365b8c18517566f	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	156149929227998	57	0x21c3de23d98caddc406e3d31b25e807addf33633	117296153	2024-03-11T21:04:43.000Z	0x551edc6c446b16965fc11829954a11059d64e7c33aa95df529c6c8223cb23f70
0x3823094993190fbb3bfabfec8365b8c18517566f	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	false	3515505003632571	1	0xe93685f3bba03016f02bd1828badd6195988d950	117296059	2024-03-11T21:01:35.000Z	0xe19039e4798fadde1628538401066ca4dbc64d4beced871eaae5c385c69e9bdd
0x3823094993190fbb3bfabfec8365b8c18517566f	0x2d2ea0697bdbede3f01553d2ae4b8d0c486b666e	false	284146112144805	14	0xe93685f3bba03016f02bd1828badd6195988d950	118026223	2024-03-28T18:40:23.000Z	0xbd95fd305b6fe5d49bdb9020a516c25c564a8d04a85ac0d97316b4e0fc723143

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_optimism.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
0x3823094993190fbb3bfabfec8365b8c18517566f	false	427	0x00010000000000000000000000000000000000000000000000000000000000030d40	137615117	157681495513648	2025-06-25T05:23:31.000Z	0x0917d2903ea44ab8a65b8fb1b1d279c70c4bb1f8a4b93a571fe337debff5896e	0x0100000000000001530000006f000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d75a4a16f3559733eaeb473d03ed756f70f15294848cf83a550347a8629a089869000000000000000000000000004e13a67181efe34e1cad6f2005980c479034132e00000ca679b11033
0x3823094993190fbb3bfabfec8365b8c18517566f	false	783	0x00010000000000000000000000000000000000000000000000000000000000030d40	137635985	205056982265618	2025-06-25T16:59:07.000Z	0xc96fb7cc7aafeb189adada9774a14e6efc662fd13534093605d37470eccd94eb	0x0100000000000001600000006f000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e000000b8000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5eca647d6500506fcac9b3c8ac0a3779d7e5b6de7840de705ff8bf0457c01d5b8500000000000000000000000000d27736be4c8c4019e8e89b187bf1ace6b408a9df0000001511f2dbef
0x3823094993190fbb3bfabfec8365b8c18517566f	false	24	0x00010000000000000000000000000000000000000000000000000000000000030d40	137924912	161191055811444	2025-07-02T09:30:01.000Z	0xc14f47edfaeaf1424004716b7d892fb86c4fa71dc755e503e3385e4b8279001d	0x0100000000000001130000006f000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e79da89d5a894f7c7afc8987d112c474425c31d1552c3ef75ec0b6922c60bb025000000000000000000000000004e13a67181efe34e1cad6f2005980c479034132e0000144ccec8b559

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_optimism.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
0x2ce38803bf39dd09e072255b19ad3912bb799603	3394013367814944231	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	false	4	14420403	2	2022-07-13T18:57:44.000Z	0x521c255fe0ab1039fd194045372626380f19118f8aa718dca6751df53c338e5e
0xce344810e17d57f8adbda1a1fb95737619c3a649	16658030861557356116	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	false	87	121041164	102	2024-06-06T13:38:25.000Z	0xdf33b152f52153af7ae34b344bf14bd3d6bf700706197e44195fa8a5907fd42d
0x2bd6da5b31162e0fd53cdd3cf01b1057249d6811	1632000000000000000000	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	false	10	121024319	102	2024-06-06T04:16:55.000Z	0xd68225122ae1e48e761ef3c530f1abfaae5de6a444b58cfeafbc6ea5f4452fb4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_optimism.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	in_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	0x6538cb0957350eacc1979513a4246f1e699bb3f1	false	52671	110	1754673191	106009638	1	1000764	2023-06-24T14:47:33.000Z	0x3b1126e8c4589c1de5eba7d2842a9788a84aa9e672ef8a2e30353ad5cb7caee9
0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	0x15bfc44733e0acb9a1bf96102e24109334124f87	false	3142	106	5432607	106000625	1	3262	2023-06-24T09:47:07.000Z	0x578ea8d59731bce9972b7baf0987f8f5536c154b919021bf6a67d3ffcd4e3c5a
0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	0x90054ab2f98c238ee931e8f9b32d77c24b70a62b	false	1685	106	2924977	106000571	1	1756	2023-06-24T09:45:19.000Z	0x8b0f15dccf6bf8bf2ef2ee6c519002e7052c7db08ff38e5b7d29a3102193777f

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

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

​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

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