layerzero_v1_sonic

Tables

Endpoint_send_function

LayerZero endpoint function calls initiating cross-chain message transfers with destination chain identifiers, payload data, adapter parameters, and refund addresses. Used for tracking omnichain messaging activity and cross-chain transaction flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__dstChainId`	`STRING`	LayerZero chain identifier for the destination blockchain. String-encoded integer representing the target chain in cross-chain message transfers.
`in__destination`	`STRING`	Concatenated address pair used in LayerZero cross-chain messaging to specify source and destination contracts. 84-character hex string without 0x prefix, consisting of two 42-character addresses concatenated together.
`in__payload`	`STRING`	Application-specific message data sent in LayerZero cross-chain transactions. Hex-encoded byte string including 0x prefix, containing contract function calls, token transfer details, or other custom protocol messages.
`in__refundAddress`	`STRING`	Address designated to receive refunds for unused gas or failed cross-chain message execution. Hex-encoded, 0x-prefixed, 42-character string.
`in__zroPaymentAddress`	`STRING`	Address designated for payment in ZRO tokens for LayerZero cross-chain message fees. Hex-encoded, 0x-prefixed, 42-character string, typically set to zero address when fees are paid in native tokens.
`in__adapterParams`	`STRING`	Configuration parameters for LayerZero cross-chain message delivery controlling gas settings and execution options. Hex-encoded byte string including 0x prefix.

Sample Data

gas	value	status	gas_used	signature	to_address	in__payload	block_number	from_address	trace_address	in__dstChainId	block_timestamp	in__destination	transaction_hash	in__adapterParams	in__refundAddress	in__zroPaymentAddress
369762	16428410506857243000	true	175977	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x00000000000000000000000000000000000000000000000000000000000000080000000000000000000000002702a9118cffeb33d926069a91aabd4815db22590000000000000000000000000000000000000000000002eedd3d2a41bf8c0000	2962910	0x777b1b4e79058778f8362a3dc53ee90f35934e8e	0,2	101	2025-01-08T08:48:19.000Z	0x777b1b4e79058778f8362a3dc53ee90f35934e8e777b1b4e79058778f8362a3dc53ee90f35934e8e	0xa82da7615db71fa0cf4176170d42d4efa0af91ee97c06b6a9d0e73ce6fdaea92	0x	0x2702a9118cffeb33d926069a91aabd4815db2259	0x2702a9118cffeb33d926069a91aabd4815db2259
217240	16307968752664240000	true	168490	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000034636c44f2dbff0c00000000000000000000000000000000000000000000000000000000000000000140467d328b1bc9d4e8bec5ee5af4e2691eb3ded6a000000000000000000000000	3038130	0x0e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	0	101	2025-01-08T21:49:40.000Z	0x92cc36d66e9d739d50673d1f27929a371fb83a670e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	0x50d0512b8c53298c46d6ad361cf048c8907a0ca779f5130166fc25d33c4d51c1	0x0002000000000000000000000000000000000000000000000000000000000002ab9800000000000000000000000000000000000000000000000000000000000000000467d328b1bc9d4e8bec5ee5af4e2691eb3ded6a	0x0467d328b1bc9d4e8bec5ee5af4e2691eb3ded6a	0x0000000000000000000000000000000000000000
217240	16589621470087483000	true	168490	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000007da887833e78cb9a8c000000000000000000000000000000000000000000000000000000000000001448c8786c66c95f14745156e9613eb76778cb3055000000000000000000000000	3036031	0x0e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	0	101	2025-01-08T21:22:52.000Z	0x92cc36d66e9d739d50673d1f27929a371fb83a670e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	0xbdc8e8ec3f8986abf4e46459a7c26cb95d60eda57876c0b220ae4a9e0d360cbe	0x0002000000000000000000000000000000000000000000000000000000000002ab98000000000000000000000000000000000000000000000000000000000000000048c8786c66c95f14745156e9613eb76778cb3055	0x48c8786c66c95f14745156e9613eb76778cb3055	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_sonic.Endpoint_send_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__dstChainId`	`STRING`	LayerZero chain identifier for the destination blockchain. String-encoded integer representing the target chain in cross-chain message transfers.
`in__destination`	`STRING`	Concatenated address pair used in LayerZero cross-chain messaging to specify source and destination contracts. 84-character hex string without 0x prefix, consisting of two 42-character addresses concatenated together.
`in__payload`	`STRING`	Application-specific message data sent in LayerZero cross-chain transactions. Hex-encoded byte string including 0x prefix, containing contract function calls, token transfer details, or other custom protocol messages.
`in__refundAddress`	`STRING`	Address designated to receive refunds for unused gas or failed cross-chain message execution. Hex-encoded, 0x-prefixed, 42-character string.
`in__zroPaymentAddress`	`STRING`	Address designated for payment in ZRO tokens for LayerZero cross-chain message fees. Hex-encoded, 0x-prefixed, 42-character string, typically set to zero address when fees are paid in native tokens.
`in__adapterParams`	`STRING`	Configuration parameters for LayerZero cross-chain message delivery controlling gas settings and execution options. Hex-encoded byte string including 0x prefix.

Sample Data

gas	value	status	gas_used	signature	to_address	in__payload	block_number	from_address	in__dstChainId	block_timestamp	in__destination	transaction_hash	in__adapterParams	in__refundAddress	in__zroPaymentAddress
217237	591668110733754900	true	168490	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000152d02c7e14af68000000000000000000000000000000000000000000000000000000000000000000014698e7c50fb97cda7afd5a128227e0c6af9d1e1e1000000000000000000000000	34975438	0x0e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	151	2025-06-20T10:48:55.000Z	0xaf20f5f19698f1d19351028cd7103b63d30de7d70e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	0xf5c9acd156005af4b877d5a7cd5629f2c83b83ab880f4d5c3472025ed01ba69b	0x0002000000000000000000000000000000000000000000000000000000000002ab980000000000000000000000000000000000000000000000000000000000000000698e7c50fb97cda7afd5a128227e0c6af9d1e1e1	0x698e7c50fb97cda7afd5a128227e0c6af9d1e1e1	0x0000000000000000000000000000000000000000
479557	739510973719128200	true	174785	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000ab8a60b67bee3295bf200000000000000000000000000000000000000000000000000000000000000148678f58ac6c4748b5289d0db70e627eef395dead000000000000000000000000	34982875	0x0e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	151	2025-06-20T11:56:50.000Z	0xaf20f5f19698f1d19351028cd7103b63d30de7d70e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	0xfe8cf3f421a532cfb14dc93e23100c72ceafea7044a724a7d9a00e3ab5889398	0x0001000000000000000000000000000000000000000000000000000000000002ab98	0x8678f58ac6c4748b5289d0db70e627eef395dead	0x0000000000000000000000000000000000000000
479557	739510973719128200	true	174785	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000001cf6c0f59fc9d5397c9000000000000000000000000000000000000000000000000000000000000000148678f58ac6c4748b5289d0db70e627eef395dead000000000000000000000000	34960400	0x0e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	151	2025-06-20T08:31:14.000Z	0xaf20f5f19698f1d19351028cd7103b63d30de7d70e0ce4d450c705f8a0b6dd9d5123e3df2787d16b	0xaf7ee512ab474a5ee9cae9ea246d2ef3bdd7d8f70f86545323a787ad4542d109	0x0001000000000000000000000000000000000000000000000000000000000002ab98	0x8678f58ac6c4748b5289d0db70e627eef395dead	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

OFT_SendToChain_event

LayerZero OFT (Omnichain Fungible Token) cross-chain send events recording token transfers from the source chain to destination chains. Contains sender address, recipient address, token amount, and destination chain identifier for tracking omnichain token movements.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_dstChainId`	`STRING`	Destination chain identifier for cross-chain operations. String-encoded integer representing the target blockchain in LayerZero’s chain ID system.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_toAddress`	`STRING`	Destination address for the cross-chain transfer or operation. Hex-encoded string with 0x prefix, left-padded with zeros to 66 characters total.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	in_toAddress	in_dstChainId	block_timestamp	transaction_hash
0x1e5fe95fb90ac0530f581c617272cd0864626795	0x4efe127e2975cf2703d74261298c72b6193a8270	false	11782658107000000000000	5	7824464	0x0000000000000000000000004efe127e2975cf2703d74261298c72b6193a8270	111	2025-02-14T08:24:40.000Z	0x66955112efac8a130aeb20b31349032068e970ac538ab843f421bde43512e41f
0x1e5fe95fb90ac0530f581c617272cd0864626795	0x0b20a6140118be0235db1bcb0dfa96d5d656ca51	false	10335965270000000000000	5	7824608	0x0000000000000000000000000b20a6140118be0235db1bcb0dfa96d5d656ca51	111	2025-02-14T08:26:11.000Z	0xa080d9d99f394dddca1d6de29f7f2f18ed9f5936e16766cc2333f50d991130fb
0x7a08bf5304094ca4c7b4132ef62b5edc4a3478b7	0x1aafacc008099845d6c35df8c5925c8e659c4400	false	73794660000000000000	5	7809575	0x0000000000000000000000001aafacc008099845d6c35df8c5925c8e659c4400	112	2025-02-14T05:54:19.000Z	0xa78df789f09953a69a604528c9a9061c8df55cc98e2cee11683399c1a71071fa

Example Query

Query with partition filter

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

ReceiveUln301_PacketDelivered_event

LayerZero V2 UltraLight Node (ULN) 301 packet delivery confirmation events emitted when cross-chain messages are successfully received on the destination chain. Contains origin chain endpoint identifier (srcEid), sender address, message nonce, and destination receiver address for tracking message execution across LayerZero-connected blockchains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_origin`	`STRUCT<srcEid STRING, sender STRING, nonce STRING>`	Source endpoint and sender information for a cross-chain message. Struct containing source endpoint identifier (srcEid), sender address, and nonce.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SendUln301_DVNFeePaid_event

DVN (Decentralized Verifier Network) fee payment events emitted by LayerZero V2 SendUln301 contracts. Records fees paid to required and optional DVNs for cross-chain message verification services.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_requiredDVNs`	`ARRAY<STRING>`	Array of contract addresses for required Decentralized Verifier Networks (DVNs) in LayerZero message verification. Hex-encoded, 0x-prefixed, 42-character strings.
`in_optionalDVNs`	`ARRAY<STRING>`	Array of contract addresses for optional Decentralized Verifier Networks (DVNs) in LayerZero message verification. Hex-encoded, 0x-prefixed, 42-character strings.
`in_fees`	`ARRAY<STRING>`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SendUln301_ExecutorFeePaid_event

Executor fee payment events from LayerZero V1 SendUln301 contracts recording cross-chain message execution costs. Contains executor address and fee amount paid for processing LayerZero message deliveries across supported blockchain networks.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_executor`	`STRING`	Address of the executor contract responsible for processing cross-chain message delivery. Hex-encoded, 0x-prefixed, 42-character string.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SendUln301_NativeFeeWithdrawn_event

Native gas fee withdrawal events from LayerZero V1 SendUln301 contracts. Records user-initiated withdrawals of accumulated native token fees to specified receivers, tracking the withdrawal amount and beneficiary addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SendUln301_PacketSent_event

LayerZero V1 Ultra Light Node 301 packet transmission events containing encoded cross-chain message payloads, destination chain routing information, and fee details. Used for tracking omnichain message flow and analyzing cross-chain protocol activity across LayerZero-integrated networks.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_encodedPayload`	`STRING`	Encoded LayerZero message payload containing cross-chain transfer instructions. Hex-encoded byte string including destination chain, recipient address, sender address, and message-specific data.
`in_options`	`STRING`	Configuration parameters for LayerZero message execution. Hex-encoded byte string specifying gas limits, executor settings, and delivery options for cross-chain message handling.
`in_nativeFee`	`STRING`	Fee amount paid in native chain tokens for LayerZero cross-chain message delivery. Numeric string representing wei-denominated token amount.
`in_lzTokenFee`	`STRING`	Fee amount paid in LayerZero tokens for cross-chain message delivery. Numeric string representing wei-denominated token amount.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

StargateV1_SendToChain_event

Cross-chain token transfer events from Stargate V1 protocol recording asset movements between LayerZero-connected chains. Contains destination chain identifier, transfer quantity, recipient address, and transaction metadata for tracking bridge flow analytics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_dstChainId`	`STRING`	Destination chain identifier for cross-chain operations. String-encoded integer representing the target blockchain in LayerZero’s chain ID system.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

StargateV1_Swap_event

Cross-chain token swap events from Stargate V1 protocol via LayerZero messaging. Contains swap amounts, source/destination chain identifiers, pool IDs, fee breakdowns (equilibrium, liquidity provider, protocol), and rewards for analyzing cross-chain liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_dstPoolId`	`STRING`	Identifier for the destination Stargate liquidity pool in a cross-chain swap operation. Numeric string representing the pool ID on the target chain.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSD`	`STRING`	Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.
`in_eqReward`	`STRING`	Reward amount credited for equilibrium rebalancing in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_eqFee`	`STRING`	Fee charged for equilibrium adjustment in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_protocolFee`	`STRING`	Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.
`in_lpFee`	`STRING`	Fee collected by liquidity providers from the swap transaction. Numeric string representation without decimals.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Endpoint_send_function

EndpointV1_send_function

OFT_SendToChain_event

ReceiveUln301_PacketDelivered_event

SendUln301_DVNFeePaid_event

SendUln301_ExecutorFeePaid_event

SendUln301_NativeFeeWithdrawn_event

SendUln301_PacketSent_event

StargateV1_SendToChain_event

StargateV1_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Endpoint_send_function

​EndpointV1_send_function

​OFT_SendToChain_event

​ReceiveUln301_PacketDelivered_event

​SendUln301_DVNFeePaid_event

​SendUln301_ExecutorFeePaid_event

​SendUln301_NativeFeeWithdrawn_event

​SendUln301_PacketSent_event

​StargateV1_SendToChain_event

​StargateV1_Swap_event

Tables

Endpoint_send_function

EndpointV1_send_function

OFT_SendToChain_event

ReceiveUln301_PacketDelivered_event

SendUln301_DVNFeePaid_event

SendUln301_ExecutorFeePaid_event

SendUln301_NativeFeeWithdrawn_event

SendUln301_PacketSent_event

StargateV1_SendToChain_event

StargateV1_Swap_event