> ## 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_plasma > Tables in tt-contracts.layerzero_v1_plasma ## Tables ### EndpointV1\_receivePayload\_function LayerZero V1 endpoint function calls for receiving cross-chain message payloads on Plasma, containing source chain identifiers (chain ID 101 for Solana), nonce sequencing, destination addresses, and message payloads for tracking incoming cross-chain transactions. | 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` | `NUMERIC` | 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__srcChainId` | `STRING` | LayerZero chain identifier for the source blockchain where the cross-chain message originated. Typically numeric string values like '101' (Solana) or EVM chain IDs for Ethereum and other networks. | | `in__srcAddress` | `STRING` | Source address on the originating chain that initiated the cross-chain message, concatenated with the destination address. Hex-encoded string combining both addresses without 0x prefix separating them. | | `in__dstAddress` | `STRING` | Destination contract address on the receiving chain that will process the LayerZero cross-chain message payload. Hex-encoded, 0x-prefixed 40-character string representing the final recipient contract. | | `in__nonce` | `STRING` | Sequential message identifier used by LayerZero to ensure in-order delivery and prevent replay attacks. Increments with each cross-chain message from a specific source chain and address pair. | | `in__gasLimit` | `STRING` | Maximum gas allocated for executing the payload on the destination chain. Specified as a string-encoded integer, commonly 200000 for simple transfers or 1000000 for complex contract interactions. | | `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. | | gas | value | status | gas\_used | in\_\_nonce | signature | to\_address | in\_\_payload | block\_number | from\_address | in\_\_gasLimit | trace\_address | in\_\_dstAddress | in\_\_srcAddress | in\_\_srcChainId | block\_timestamp | transaction\_hash | | ------- | ----- | ------ | --------- | ----------- | ---------- | ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------------------------ | -------------- | -------------- | ------------------------------------------ | ---------------------------------------------------------------------------------- | ---------------- | ------------------------ | ------------------------------------------------------------------ | | 604126 | 0 | true | 35377 | 4 | 0xc2fa4813 | 0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7 | 0x0000000000000000000000000000000000000000000000000ea3f13c9576744e | 2103153 | 0x38de71124f7a447a01d67945a51edce9ff491251 | 200000 | 0,0,1 | 0xf1fd29270e61d4a7885e9b4ef6476daf2ab6f85d | 0x0788906b19ba8f8d0e8a7015f0714df3179d9ab6f1fd29270e61d4a7885e9b4ef6476daf2ab6f85d | 101 | 2025-09-28T04:05:35.000Z | 0x9d756f287ef9263cd0b1718407bbb2e43bc663e447f89134eff0387b3cbca40e | | 604126 | 0 | true | 35377 | 46 | 0xc2fa4813 | 0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7 | 0x0000000000000000000000000000000000000000000000000eac714105e6c70d | 5040490 | 0x38de71124f7a447a01d67945a51edce9ff491251 | 200000 | 0,0,1 | 0xf1fd29270e61d4a7885e9b4ef6476daf2ab6f85d | 0x0788906b19ba8f8d0e8a7015f0714df3179d9ab6f1fd29270e61d4a7885e9b4ef6476daf2ab6f85d | 101 | 2025-11-01T04:05:01.000Z | 0x8483cdd9e0bbfc7eca6656bc833abd981cedca10d2afbc499a77d15f3774b770 | | 3286639 | 0 | true | 49625 | 678 | 0xc2fa4813 | 0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7 | 0x0000000000000000000000000d7432a9f5c51fdd2407332d90d9b814827982bf000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000069059f0f0000000000000000000000000000000000000000054c072c51142beb27ce45000000000000000000000000000000000000000000000000000c8eb8b40bd5c23d000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000600000000000000000000000005e014aa0649102e07c074f498845f01bcd520317000000000000000000000000000000000000000000000567c192c351edc14de3000000000000000000000000000000000000000000000000000000006cc26e80 | 5046861 | 0x38de71124f7a447a01d67945a51edce9ff491251 | 1000000 | 0,0,1 | 0x5c3ddc827c40964728336229808e27c6374f07bf | 0x07b1014c88f14c9e910092526db57a20052e989f5c3ddc827c40964728336229808e27c6374f07bf | 101 | 2025-11-01T05:51:12.000Z | 0xd5dc3eeb6345b4d69fb43618ae686a05136727c9b42df983c78c4ca54512609b | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.EndpointV1_receivePayload_function` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` *** ### EndpointV1\_send\_function LayerZero V1 endpoint send function calls initiating cross-chain message transfers. Contains source chain transaction details, destination chain identifiers, message payloads, gas parameters, and refund addresses for tracking omnichain messaging activity. | 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` | `NUMERIC` | 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 | | ------- | ------------------ | ------ | --------- | ---------- | ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------------------------ | -------------- | ---------------- | ------------------------ | ---------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ---------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | | 7813607 | 24043962948565900 | true | 205246 | 0xc5803100 | 0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7 | 0x0100000000 | 1979360 | 0xecbca85d8980512b4e45542e26c2b347c9a1b358 | 0 | 111 | 2025-09-26T17:40:37.000Z | 0xa3457ddfe61e5087abd4d99df056e81538d1f1d0ecbca85d8980512b4e45542e26c2b347c9a1b358 | 0x4741e45189be9f31da4ab7a24a7b6915e9b7d82bfd98fa564594d49989fa2371 | 0x | 0x675f70c1412fae4fe892b36310b87b7145370fb9 | 0x675f70c1412fae4fe892b36310b87b7145370fb9 | | 275425 | 104738849399791671 | false | 155772 | 0xc5803100 | 0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7 | 0x000000000000000000000000003021338c74f10cef1ece6404ac1498c2559f7a5c00000097523930da | 5904448 | 0x116d2cca3d58305764f2daf7ebbc819547099278 | 0 | 184 | 2025-11-11T04:07:00.000Z | 0x116d2cca3d58305764f2daf7ebbc819547099278116d2cca3d58305764f2daf7ebbc819547099278 | 0x4ab464c1ce2a1f81618d67f2e5af40ed56c35a6bacc8a3fe90dacae092d6dd66 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 0x3021338c74f10cef1ece6404ac1498c2559f7a5c | 0x0000000000000000000000000000000000000000 | | 287513 | 123517748849857606 | true | 157321 | 0xc5803100 | 0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7 | 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000017c8ff3345e4a187b6c0000000000000000000000000000000000000000000000000000000000000014b488885afc5a3e1055e598d40a60e3350fef602e000000000000000000000000 | 5935176 | 0xcbfa3f8a32ab63e461b6bbfda881ef01eb4ef75d | 0,7 | 184 | 2025-11-11T12:39:08.000Z | 0x2af13bf84f8b452cb86839330f514cc5c2899217cbfa3f8a32ab63e461b6bbfda881ef01eb4ef75d | 0x01a86ffd67d3ffe7b9ff8b639be195c16d91f4be947cf68c8140829c5ad09568 | 0x00010000000000000000000000000000000000000000000000000000000000030d40 | 0xb488885afc5a3e1055e598d40a60e3350fef602e | 0x0000000000000000000000000000000000000000 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.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. | *No sample data available.* **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.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. | *No sample data available.* **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.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. | *No sample data available.* **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.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. | *No sample data available.* **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.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. | *No sample data available.* **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.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. | *No sample data available.* **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.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. | *No sample data available.* **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.layerzero_v1_plasma.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_plasma.StargateV1_Swap_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***