> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# layerzero_v1_optimism
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | Array of contract addresses for required Decentralized Verifier Networks (DVNs) in LayerZero message verification. Hex-encoded, 0x-prefixed, 42-character strings. |
| `in_optionalDVNs` | `ARRAY` | Array of contract addresses for optional Decentralized Verifier Networks (DVNs) in LayerZero message verification. Hex-encoded, 0x-prefixed, 42-character strings. |
| `in_fees` | `ARRAY` | Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | in\_options | block\_number | in\_nativeFee | in\_lzTokenFee | block\_timestamp | transaction\_hash | in\_encodedPayload |
| ------------------------------------------ | ------- | ---------- | ---------------------------------------------------------------------- | ------------- | --------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 0x3823094993190fbb3bfabfec8365b8c18517566f | false | 427 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 137615117 | 157681495513648 | 0 | 2025-06-25T05:23:31.000Z | 0x0917d2903ea44ab8a65b8fb1b1d279c70c4bb1f8a4b93a571fe337debff5896e | 0x0100000000000001530000006f000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d75a4a16f3559733eaeb473d03ed756f70f15294848cf83a550347a8629a089869000000000000000000000000004e13a67181efe34e1cad6f2005980c479034132e00000ca679b11033 |
| 0x3823094993190fbb3bfabfec8365b8c18517566f | false | 783 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 137635985 | 205056982265618 | 0 | 2025-06-25T16:59:07.000Z | 0xc96fb7cc7aafeb189adada9774a14e6efc662fd13534093605d37470eccd94eb | 0x0100000000000001600000006f000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e000000b8000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5eca647d6500506fcac9b3c8ac0a3779d7e5b6de7840de705ff8bf0457c01d5b8500000000000000000000000000d27736be4c8c4019e8e89b187bf1ace6b408a9df0000001511f2dbef |
| 0x3823094993190fbb3bfabfec8365b8c18517566f | false | 24 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 137924912 | 161191055811444 | 0 | 2025-07-02T09:30:01.000Z | 0xc14f47edfaeaf1424004716b7d892fb86c4fa71dc755e503e3385e4b8279001d | 0x0100000000000001130000006f000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e79da89d5a894f7c7afc8987d112c474425c31d1552c3ef75ec0b6922c60bb025000000000000000000000000004e13a67181efe34e1cad6f2005980c479034132e0000144ccec8b559 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | in\_from | removed | in\_eqFee | in\_lpFee | log\_index | in\_chainId | in\_amountSD | in\_eqReward | block\_number | in\_dstPoolId | in\_protocolFee | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | --------- | --------- | ---------- | ----------- | ------------ | ------------ | ------------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xdecc0c09c3b5f6e92ef4184125d5648a66e35298 | 0x6538cb0957350eacc1979513a4246f1e699bb3f1 | false | 52671 | 0 | 0 | 110 | 1754673191 | 0 | 106009638 | 1 | 1000764 | 2023-06-24T14:47:33.000Z | 0x3b1126e8c4589c1de5eba7d2842a9788a84aa9e672ef8a2e30353ad5cb7caee9 |
| 0xdecc0c09c3b5f6e92ef4184125d5648a66e35298 | 0x15bfc44733e0acb9a1bf96102e24109334124f87 | false | 3142 | 0 | 0 | 106 | 5432607 | 0 | 106000625 | 1 | 3262 | 2023-06-24T09:47:07.000Z | 0x578ea8d59731bce9972b7baf0987f8f5536c154b919021bf6a67d3ffcd4e3c5a |
| 0xdecc0c09c3b5f6e92ef4184125d5648a66e35298 | 0x90054ab2f98c238ee931e8f9b32d77c24b70a62b | false | 1685 | 0 | 0 | 106 | 2924977 | 0 | 106000571 | 1 | 1756 | 2023-06-24T09:45:19.000Z | 0x8b0f15dccf6bf8bf2ef2ee6c519002e7052c7db08ff38e5b7d29a3102193777f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_optimism.StargateV1_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***