> ## 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_celo
> Tables in tt-contracts.layerzero_v1_celo
## 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` | `NUMERIC` | 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 |
| ------ | ----------------- | ------ | --------- | ---------- | ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------------------------ | -------------- | ---------------- | ------------------------ | ---------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ---------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ |
| 217649 | 78745704617654380 | true | 151709 | 0xc5803100 | 0x3a73033c0b1407574c76bdbac67f126f6b4a9aa9 | 0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000001440a6025a7b5bf6b89325b8d1019f5359bd00f877000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000e005a00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000200 | 23197929 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0,0 | 126 | 2023-12-27T06:41:23.000Z | 0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x9bee83c42a109f8071ee197b21fa0295346dfa99989ca4754a6761bbe57350c1 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x0000000000000000000000000000000000000000 |
| 217660 | 82337911274779310 | true | 151709 | 0xc5803100 | 0x3a73033c0b1407574c76bdbac67f126f6b4a9aa9 | 0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000014f52be165191e50cb697964ff5fb06a535af09440000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000e001e00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000200 | 23197211 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0,0 | 126 | 2023-12-27T05:41:33.000Z | 0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x0015e9b62d9c3c79544f75ee5d39bac1efd3d8d6bd813443679109702d2b52df | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x0000000000000000000000000000000000000000 |
| 217660 | 78745704617654380 | true | 151709 | 0xc5803100 | 0x3a73033c0b1407574c76bdbac67f126f6b4a9aa9 | 0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000149373d6b0c9f4c138818f10bab9f13512ee3e45e4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000e00a200000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000200 | 23198664 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0,0 | 126 | 2023-12-27T07:42:38.000Z | 0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x8e13aafcd3f120353f92d4d4884a21ff6e92a98d97029c8ecb699fd66c9b73f3 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 0x0000049f63ef0d60abe49fdd8bebfa5a68822222 | 0x0000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xa8cccb1be30604e69d5014022b56aed8b247bfb0 | 0x5414952ef2231e41fd4912f5121946a683749eee | false | 1521570600000000000000 | 17 | 21001481 | 0x0000000000000000000000005414952ef2231e41fd4912f5121946a683749eee | 145 | 2023-08-22T03:44:36.000Z | 0xed65c20b9179600b72e78e9024d1c7f990b6429f9a99ce94abf44a22646a7f79 |
| 0xd35055db8fa9aa4426edccbab2bca760c24a6610 | 0x74900790dd8178239180862d274738bbd8c6e461 | false | 1000000000000000000 | 32 | 20108236 | 0x00000000000000000000000074900790dd8178239180862d274738bbd8c6e461 | 145 | 2023-07-01T11:04:14.000Z | 0xc7a19cfa2998bf7f0519d3554c526dfd82a73020acd8c8342e1cd84bd78f8f44 |
| 0xd35055db8fa9aa4426edccbab2bca760c24a6610 | 0x74900790dd8178239180862d274738bbd8c6e461 | false | 1000000000000000000 | 8 | 20108230 | 0x00000000000000000000000074900790dd8178239180862d274738bbd8c6e461 | 145 | 2023-07-01T11:03:44.000Z | 0x9e207326e592f207b4f5eb83be434ee778b712115b17ab586f7ca9230711e742 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.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 |
| ------------------------------------------ | ------- | ----------------------------------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x556d7664d5b4db11f381c714b6b47a8bf0b494fd | false | \{"nonce":"1","sender":"0x000000000000000000000000fee867ed545f26621dc701e6164e02ead9c6b081","srcEid":"125"} | 5 | 0xfee867ed545f26621dc701e6164e02ead9c6b081 | 23901594 | 2024-02-06T00:06:26.000Z | 0x26823cc99266779f1519426de5a4ed140cf6fa9b0395fd1bfad1a9e59287adec |
| 0x556d7664d5b4db11f381c714b6b47a8bf0b494fd | false | \{"nonce":"1","sender":"0x000000000000000000000000da9264c68295b06a05feff112333e1faa6b40535","srcEid":"102"} | 22 | 0xda9264c68295b06a05feff112333e1faa6b40535 | 23910986 | 2024-02-06T13:09:17.000Z | 0x791dcbcdd2954387100993618d496ebcc7aab6b21d9d333177a989551430893b |
| 0x556d7664d5b4db11f381c714b6b47a8bf0b494fd | false | \{"nonce":"1","sender":"0x000000000000000000000000da9264c68295b06a05feff112333e1faa6b40535","srcEid":"181"} | 3 | 0xda9264c68295b06a05feff112333e1faa6b40535 | 23923176 | 2024-02-07T06:05:25.000Z | 0xcd51af9cedf38d62e06718171c379665ccad047be1c58c16acdbaa7a898609a2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.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 |
| ------------------------------------------ | ---------------------------------------- | ------- | ---------- | ------------- | ------------------------ | ---------------- | -------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | \["1023072000000000","1023072000000000"] | false | 4 | 23901584 | 2024-02-06T00:05:36.000Z | \[] | \["0x75b073994560a5c03cd970414d9170be0c6e5c36","0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc"] | 0xb5121c9b1391fba279c090e8a1f4c3e0cdda87f5cb6cfc5e37c2e3981730de13 |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | \["4932194856"] | false | 10 | 23900972 | 2024-02-05T23:14:36.000Z | \[] | \["0x75b073994560a5c03cd970414d9170be0c6e5c36"] | 0xe3bc3c1ac1557b9226fd68ad03bbce3ab81a1575e8dddab202fad3062e044d61 |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | \["876350338054360"] | false | 13 | 23900972 | 2024-02-05T23:14:36.000Z | \[] | \["0x75b073994560a5c03cd970414d9170be0c6e5c36"] | 0x59955f0838a073325c2ca35840670dbe5ae426b33428e2b973ab0bc1ab3d9912 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.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 |
| ------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 70174189413799511 | 0xc80233ad8251e668becbc3b0415707fc7075501e | false | 3 | 0x1ddbaf8b75f2291a97c22428afef411b7bb19e28 | 23901584 | 2024-02-06T00:05:36.000Z | 0xb5121c9b1391fba279c090e8a1f4c3e0cdda87f5cb6cfc5e37c2e3981730de13 |
| 70168571455066124 | 0xc80233ad8251e668becbc3b0415707fc7075501e | false | 0 | 0x1ddbaf8b75f2291a97c22428afef411b7bb19e28 | 23900972 | 2024-02-05T23:14:36.000Z | 0x88777d357d87c33a20731dfa1f1df59e6592c8e0537f063d4296709f273dd0e3 |
| 469912167447218538 | 0xc80233ad8251e668becbc3b0415707fc7075501e | false | 12 | 0x1ddbaf8b75f2291a97c22428afef411b7bb19e28 | 23900972 | 2024-02-05T23:14:36.000Z | 0x59955f0838a073325c2ca35840670dbe5ae426b33428e2b973ab0bc1ab3d9912 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | 0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc | false | 23072000000000 | 13 | 0x21c3de23d98caddc406e3d31b25e807addf33633 | 24504126 | 2024-03-11T21:04:44.000Z | 0xc4a8736491c282ccc35c159ecbc9c71c0aa66770e90d94437ec03af29cd3c6a5 |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | 0x1ddbaf8b75f2291a97c22428afef411b7bb19e28 | false | 1847456089759365498 | 4 | 0xe93685f3bba03016f02bd1828badd6195988d950 | 24504089 | 2024-03-11T21:01:39.000Z | 0x0f470456d05f1a73f3e8f7d859760a10b3fdf91dd7b67f61dd32c06d74f2ab7f |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | 0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc | false | 1000000000000000 | 2 | 0x21c3de23d98caddc406e3d31b25e807addf33633 | 24386505 | 2024-03-05T01:42:18.000Z | 0xadc12db986dd5eabe2d79dc0bca707ff7b584ab5f991b091b3adc51b03400601 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.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 |
| ------------------------------------------ | ------- | ---------- | ---------------------------------------------- | ------------- | ------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | false | 5 | 0x0003010011010000000000000000000000000007a120 | 23901584 | 72220333413799511 | 0 | 2024-02-06T00:05:36.000Z | 0xb5121c9b1391fba279c090e8a1f4c3e0cdda87f5cb6cfc5e37c2e3981730de13 | 0x0100000000000000010000007d000000000000000000000000fee867ed545f26621dc701e6164e02ead9c6b0810000007d000000000000000000000000fee867ed545f26621dc701e6164e02ead9c6b0815ace80cb26cf3f8e3c17dc8aaa7fdb47a32aff4e4bdf6a7ac6e29d7198a08b270100000000 |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | false | 8 | 0x0003010011010000000000000000000000000007a120 | 23900972 | 1087615684802340552 | 0 | 2024-02-05T23:14:36.000Z | 0xbd4136e87c699be33830dba3da2d6b9ed2712df4ae5d294ea093a7ab4d2bc6a1 | 0x0100000000000000010000007d0000000000000000000000008df53a660a00c3d977d7e778fb7385ecf4482d16000000970000000000000000000000000ac93809f127308de0a962f1fa9693a7ad72f9c48b3661cd46e444f75a0f37206c42c03a20cfe7ddf7afa13f23a126410a38e58f0100000000 |
| 0xc80233ad8251e668becbc3b0415707fc7075501e | false | 2 | 0x0003010011010000000000000000000000000007a120 | 23900972 | 72440394441975020 | 0 | 2024-02-05T23:14:36.000Z | 0x88777d357d87c33a20731dfa1f1df59e6592c8e0537f063d4296709f273dd0e3 | 0x0100000000000000010000007d0000000000000000000000008df53a660a00c3d977d7e778fb7385ecf4482d16000000990000000000000000000000004d97186cd94047e285b7cb78fa63c93e69e7aad09daad3dd9ad136a3d2e210bbc1f18c552dbdeab63e25585e0201f85b94a5dc180100000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.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 |
| ------------------------------------------ | ------------------- | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5464912b966384bf6fb4222a6eca6013d99d6341 | 2000000000000000000 | 0x3108477eb76d943546e009f8ce5c34f0b226560f | false | 5 | 20313389 | 145 | 2023-07-13T08:00:26.000Z | 0xbe321897722c91f27e3d7bddaabbea3fc49f6a424e3284be01134db2c01812b4 |
| 0x5464912b966384bf6fb4222a6eca6013d99d6341 | 2000000000000000000 | 0x3108477eb76d943546e009f8ce5c34f0b226560f | false | 25 | 20313167 | 145 | 2023-07-13T07:41:56.000Z | 0x0dce00595ca5c39a6506e55a4bc92c47f76bad4fc25e72613d352ecb434ab68d |
| 0x5464912b966384bf6fb4222a6eca6013d99d6341 | 1200000000000000 | 0x65aeecf86bf052e81926ca8e1fff1de34e265100 | false | 20 | 20332759 | 145 | 2023-07-14T10:54:43.000Z | 0x1785bd3c33ebb0fae6da01c7b5341282f75af02670d769e219ed897c33cfb715 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.layerzero_v1_celo.StargateV1_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***