> ## 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_arbitrum
> Tables in tt-contracts.layerzero_v1_arbitrum
## 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` | `STRING` | 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 |
| ------ | ---------------- | ------ | --------- | ---------- | ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------------------------ | -------------- | ---------------- | ------------------------ | ---------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 282492 | 1048640609679772 | true | 155400 | 0xc5803100 | 0x3c2269811836af69497e5f486a85d7316753cf62 | 0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000014f9e611a96fa210d34c7ac573e59cac5e195cceb90000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000024b3aa00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000001000000 | 167638232 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0 | 184 | 2024-01-06T09:41:21.000Z | 0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x359e10fe218eec93622f0eed0a939560e29f6cef80e5a20740f4c87f4d2b9225 | 0x00020000000000000000000000000000000000000000000000000000000000030d400000000000000000000000000000000000000000000000000002d79883d20000f9e611a96fa210d34c7ac573e59cac5e195cceb9 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x0000000000000000000000000000000000000000 |
| 402644 | 1066636512000000 | true | 161057 | 0xc5803100 | 0x3c2269811836af69497e5f486a85d7316753cf62 | 0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000146dd32acd26b58c331b7d2c5c0a727ae829ec16420000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000024b33700000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000001000000 | 167513451 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0 | 158 | 2024-01-06T00:40:10.000Z | 0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222 | 0xf4e2bb7a2b756fdcaf68880da52eae62d55c2873d7dc51c38fa4241fea8682a9 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x0000000000000000000000000000000000000000 |
| 293192 | 128265583966725 | true | 162302 | 0xc5803100 | 0x3c2269811836af69497e5f486a85d7316753cf62 | 0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000146f66c41a3adea17233d501194d4144e21c6b679c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000024b33500000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000001000000 | 167511551 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0 | 202 | 2024-01-06T00:31:52.000Z | 0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222 | 0xb291ac85dcf555149de64b385e817d3feeeda98b76813f504bf9b6043e507108 | 0x00020000000000000000000000000000000000000000000000000000000000030d400000000000000000000000000000000000000000000000000001c6bf526340006f66c41a3adea17233d501194d4144e21c6b679c | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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 |
| ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1b896893dfc86bb67cf57767298b9073d2c1ba2c | 0xe97b93d7b15b16a4f910e302c804d2e27a1b3c16 | false | 55628910820000000000 | 40 | 175416413 | 0x000000000000000000000000e97b93d7b15b16a4f910e302c804d2e27a1b3c16 | 183 | 2024-01-29T14:51:07.000Z | 0x35d1c62788318d9d5e36b2bdbec132aa6ce475645e3375d9624f0acffdd0ae2b |
| 0x1b896893dfc86bb67cf57767298b9073d2c1ba2c | 0x31cc30274a7c8c62dac5bf005bf58a9f8d6470e7 | false | 21533330000000000 | 8 | 175436665 | 0x00000000000000000000000031cc30274a7c8c62dac5bf005bf58a9f8d6470e7 | 202 | 2024-01-29T16:17:10.000Z | 0xe4e8614d5cb558b9c090fc2e21e5bd2c88d7d56e8cc7512cb0797ac63e09c10e |
| 0x64f282290e8d0196c2929a9119250c361e025bab | 0x4100afe4fca13951b51688e1bdf766e762c389d2 | false | 99950000000000 | 7 | 175539148 | 0x0000000000000000000000005334e091595cbfd5067dd914de7d7c9c7ccf48e4 | 196 | 2024-01-29T23:46:11.000Z | 0x0b1a4695dba5547aa92e953f47dd2a153aee1841ceb80c5b372a5a5a8323ac9e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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 |
| ------------------------------------------ | ------- | ------------------------------------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe4dd168822767c4342e54e6241f0b91de0d3c241 | false | \{"nonce":"535","sender":"0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7","srcEid":"102"} | 35 | 0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e | 338308092 | 2025-05-19T12:19:26.000Z | 0x2ad617005cb99b63aed6f0115663e94e1ddfc7d9aa07195b029518481a7f23db |
| 0xe4dd168822767c4342e54e6241f0b91de0d3c241 | false | \{"nonce":"533","sender":"0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7","srcEid":"102"} | 2 | 0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e | 338236689 | 2025-05-19T07:18:54.000Z | 0xffedee61b159dd7426658cc8b66e5b66889dc2e7cc80c53c84c402b7399e3052 |
| 0xe4dd168822767c4342e54e6241f0b91de0d3c241 | false | \{"nonce":"532","sender":"0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7","srcEid":"102"} | 9 | 0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e | 338236304 | 2025-05-19T07:17:18.000Z | 0x9f7b275b3fe928f0f841b6478c38384447792234df2f0413cdfb2fdc39582210 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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 |
| ------------------------------------------ | -------------------------------- | ------- | ---------- | ------------- | ------------------------ | ---------------- | -------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | \["4767348000000"] | false | 42 | 285502814 | 2024-12-16T22:39:17.000Z | \[] | \["0x2f55c492897526677c5b68fb199ea31e2c126416"] | 0xd3b57fb089e280d58e0211f14b80a7301f92e8bbe36d4eb54862054f88a93b24 |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | \["18746732914"] | false | 10 | 285502814 | 2024-12-16T22:39:17.000Z | \[] | \["0x2f55c492897526677c5b68fb199ea31e2c126416"] | 0x02b14c6525e7687b2bdda8e7f23c7f03fd92ba334fc384d4c4a926bb597c2438 |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | \["168779405775","168779405775"] | false | 7 | 337474282 | 2025-05-17T02:02:16.000Z | \[] | \["0x2f55c492897526677c5b68fb199ea31e2c126416","0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc"] | 0xd3197895fce399ee1352db3dfd0ecd70d524a4cd1e32c9048060019b6f078703 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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 |
| --------------- | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 145662450563535 | 0x5cdc927876031b4ef910735225c425a7fc8efed9 | false | 2 | 0x31cae3b7fb82d847621859fb1585353c5720660d | 354517175 | 2025-07-05T13:29:01.000Z | 0xcd91705043488edb11b8c2bb5edad25cb9b0f46ee407f77df730b97f2940ee7d |
| 145697624387271 | 0x5cdc927876031b4ef910735225c425a7fc8efed9 | false | 18 | 0x31cae3b7fb82d847621859fb1585353c5720660d | 354518497 | 2025-07-05T13:34:33.000Z | 0x3d9c55b1ff829e6467b96f1a65bd1172e03221d10f9bbe2ef79cc94969c11d36 |
| 145787918974311 | 0x5cdc927876031b4ef910735225c425a7fc8efed9 | false | 8 | 0x31cae3b7fb82d847621859fb1585353c5720660d | 354518463 | 2025-07-05T13:34:26.000Z | 0x48da05d800ac3d4d50b706553fa7b46ceeaa5635c60d6fc41bb6e7b7b9b6ebc8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | 0x31cae3b7fb82d847621859fb1585353c5720660d | false | 1214127785251026 | 0 | 0xe93685f3bba03016f02bd1828badd6195988d950 | 189410572 | 2024-03-11T21:01:35.000Z | 0x205767b1e84e72feedc4dfd8306afe5d1d78f6e9db67ba025c0ba16c365afa48 |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | 0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc | false | 121246680000000 | 3 | 0x21c3de23d98caddc406e3d31b25e807addf33633 | 189411274 | 2024-03-11T21:04:41.000Z | 0xf49dcab3fa78bd41367ea34a602ac3fc0f04722daf6ea4f5261c16aee28fed05 |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | 0x31cae3b7fb82d847621859fb1585353c5720660d | false | 430834318674917 | 1 | 0xe93685f3bba03016f02bd1828badd6195988d950 | 195179913 | 2024-03-28T18:40:22.000Z | 0xe1939c5252da7dca4d5eaec29e8a0478060c8408e51c993592fc9080699e60a9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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 |
| ------------------------------------------ | ------- | ---------- | ---------------------------------------------------------------------- | ------------- | ---------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | false | 41 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 339145543 | 1289014818334960 | 0 | 2025-05-21T22:40:09.000Z | 0xdf4eaca958c1cea66d9d2bf531b2aecea7ed36e372e601039ffd5700b852290b | 0x01000000000000019c0000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f3926fa439d471e21304d741e36942dced5c799976e1f68fae3b2bba1cbdaf7cf27500000000000000000000000000b24387a9bdc01f219c2c4a649fe784bd6ffd91de000001ff5d14f7bf |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | false | 4 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 338951491 | 148034619161186 | 0 | 2025-05-21T09:10:02.000Z | 0x42423b37aded3729b0070d9717a98bbd0cc8f26c2239313938e644d3f8cc263c | 0x0100000000000005250000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7554f27c8bc24d8575ecaab90dd689abdaed3b3f6407a3029aa0dc4c0e792c1470000000000000000000000000091f82d236f6b88e830864032301b0ba6145a50fc000000414cdbd5d4 |
| 0x5cdc927876031b4ef910735225c425a7fc8efed9 | false | 6 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 338890169 | 160157361205481 | 0 | 2025-05-21T04:54:19.000Z | 0xcff6b4d687c2bb68dddd6667b3073ae522642e29418625a850df49139151a20d | 0x01000000000000025e0000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006600000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c735a7dc304d44b7e40eb5098a5aaa9863284196218efae6208022a8629968fce900000000000000000000000000350254da53d5c6ab6a27a446582fa60fe120930c000015dc7dd78cb8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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 |
| ------------------------------------------ | --------------------- | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc6f41bf72153b4cd991fb0e4d42f15cdca97ec61 | 102117584436773964704 | 0x6694340fc020c5e6b96567843da2df01b2ce1eb6 | false | 5 | 97562246 | 101 | 2023-06-04T03:03:41.000Z | 0xee940eb1ece6780a570512129bc1f4796c71f776805eb9783d352bf2821a88b6 |
| 0x06e6fc96de94e49b771898642831f370a07e0f8d | 2650000000000000000 | 0x6694340fc020c5e6b96567843da2df01b2ce1eb6 | false | 5 | 97719303 | 101 | 2023-06-04T14:05:48.000Z | 0xa474fa2981d6962c04c0447a438df8a2037b79da3d5d96a6d811d00b58c0a215 |
| 0x3fc6094b4c92ecb4eb64cc7898d4492ae87a2cd5 | 900000000000000000 | 0x6694340fc020c5e6b96567843da2df01b2ce1eb6 | false | 5 | 97826629 | 101 | 2023-06-04T21:35:53.000Z | 0xf573df2fe11b1cbccab27e2d89a1074db767fd81b557d5d14f2e6bf39fe2da25 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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 |
| ------------------------------------------ | ------------------------------------------ | ------- | --------- | --------- | ---------- | ----------- | ------------ | ------------ | ------------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb6cfcf89a7b22988bfc96632ac2a9d6dab60d641 | 0xecc19e177d24551aa7ed6bc6fe566eca726cc8a9 | false | 502 | 0 | 41 | 111 | 1244417 | 0 | 226185544 | 1 | 1245 | 2024-06-27T07:35:11.000Z | 0xef5c4ecf341af5824d8568c9aca8fdae622f9f81f3730d08286f09f955acd1ce |
| 0x892785f33cdee22a30aef750f285e18c18040c3e | 0xf787f24186e777debeae0fc3bb04c308af9920ea | false | 687 | 0 | 45 | 111 | 22822545 | 97051 | 226112475 | 1 | 97051 | 2024-06-27T02:30:32.000Z | 0xb2d1a5d1f86b8a7b03136632d538167fa90bce46cdadc2af99f1e180d201fafa |
| 0xb6cfcf89a7b22988bfc96632ac2a9d6dab60d641 | 0xecc19e177d24551aa7ed6bc6fe566eca726cc8a9 | false | 1126 | 0 | 47 | 111 | 2713343 | 0 | 226235479 | 1 | 2716 | 2024-06-27T11:03:15.000Z | 0xee5b6592738f3273a0158c40cb22f6b9ae9452659bb23d72300084f55d13124a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.StargateV1_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***