layerzero_v1_zksyncera

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`	`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.

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
490983	103429568095369	true	111043	0xc5803100	0x9b896c0e23220469c7ae69cb4bbae391eaa4c8da	0x7191e7f31407c034c0143d2e7f4b74fb2218b2b7	64386978	0x5673b6e6e51de3479b8deb22df46b12308db5e1e	20,0,1,9,1	184	2025-08-31T19:35:22.000Z	0x6bf98654205b1ac38645880ae20fc00b0bb9ffca5673b6e6e51de3479b8deb22df46b12308db5e1e	0xc295f15f170981012127b6bec224077caa6257286c811d3694067f01614af7db	0x00020000000000000000000000000000000000000000000000000000000000030d40000000000000000000000000000000000000000000000000000048c2739500007191e7f31407c034c0143d2e7f4b74fb2218b2b7	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000
491676	3607429568095369	true	111043	0xc5803100	0x9b896c0e23220469c7ae69cb4bbae391eaa4c8da	0xdaea036c018a7dde9531a7ed31f5b859899391f5	64387625	0x5673b6e6e51de3479b8deb22df46b12308db5e1e	20,0,1,9,1	184	2025-08-31T20:38:01.000Z	0x6bf98654205b1ac38645880ae20fc00b0bb9ffca5673b6e6e51de3479b8deb22df46b12308db5e1e	0xb8060f10027c9d7053001cc8020defabf74bdc24199745c4efee6ca25bd253e3	0x00020000000000000000000000000000000000000000000000000000000000030d40000000000000000000000000000000000000000000000000000aa87bee538000daea036c018a7dde9531a7ed31f5b859899391f5	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000
482415	17171465174901	true	111043	0xc5803100	0x9b896c0e23220469c7ae69cb4bbae391eaa4c8da	0xf90ad388daba633662a4e01fee704e4dd5b0949a	64387821	0x5673b6e6e51de3479b8deb22df46b12308db5e1e	20,0,1,9,1	159	2025-08-31T20:52:06.000Z	0x4c24ba5177365b4c0ebae62b31945d830a8586735673b6e6e51de3479b8deb22df46b12308db5e1e	0x4277062dbdc6cd868309838622aa39fa032f27a3580613eab42dd6596b94fee4	0x00020000000000000000000000000000000000000000000000000000000000030d400000000000000000000000000000000000000000000000000de0b6b3a7640000f90ad388daba633662a4e01fee704e4dd5b0949a	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

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
336918	318065902474014	true	199277	0xc5803100	0x9b896c0e23220469c7ae69cb4bbae391eaa4c8da	0x000000000000000000000000004efe127e2975cf2703d74261298c72b6193a82700000000030dae81b	53624433	0x5fc44e95eaa48f9eb84be17bd3ac66b6a82af709	0,19,0,1,15,1	181	2025-01-14T02:29:17.000Z	0x894134a25a5fac1c2c26f1d8fbf05111a3cb94875fc44e95eaa48f9eb84be17bd3ac66b6a82af709	0x97c757d4314cf257642bc10a0de9445a6ca1fe075fc20da9e6f096f966ab21fd	0x	0x4efe127e2975cf2703d74261298c72b6193a8270	0x0000000000000000000000000000000000000000
418314	108658839349184	true	64875	0xc5803100	0x9b896c0e23220469c7ae69cb4bbae391eaa4c8da	0x000000000000000000000000000b20a6140118be0235db1bcb0dfa96d5d656ca51000000003c9e0663	53646266	0x5fc44e95eaa48f9eb84be17bd3ac66b6a82af709	0,19,0,1,15,1	110	2025-01-14T09:26:36.000Z	0x894134a25a5fac1c2c26f1d8fbf05111a3cb94875fc44e95eaa48f9eb84be17bd3ac66b6a82af709	0x9b16a3ed4b1783e5f88e80ef1506110613794ea631292d61e69419baf22a10dc	0x	0x0b20a6140118be0235db1bcb0dfa96d5d656ca51	0x0000000000000000000000000000000000000000
404580	318065902474014	true	104385	0xc5803100	0x9b896c0e23220469c7ae69cb4bbae391eaa4c8da	0x000000000000000000000000000b20a6140118be0235db1bcb0dfa96d5d656ca51000000003087b221	53646117	0x5fc44e95eaa48f9eb84be17bd3ac66b6a82af709	0,19,0,1,15,1	181	2025-01-14T09:24:05.000Z	0x894134a25a5fac1c2c26f1d8fbf05111a3cb94875fc44e95eaa48f9eb84be17bd3ac66b6a82af709	0xcee171c1a88604b7daa88333ba4983814b2205d2ba9f378af0f9b41bbe5bd0d9	0x	0x0b20a6140118be0235db1bcb0dfa96d5d656ca51	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_zksyncera.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
0x4be6f11ee1310ecf29a9d0130a12a9d0885e0c92	0xd2992b29ffcb00d4b167fd76865c6a06605cd6f4	false	32018375588000000000000000000	15	5897153	0x000000000000000000000000d2992b29ffcb00d4b167fd76865c6a06605cd6f4	102	2023-06-12T23:28:22.000Z	0x7d70a066217af136593caa6410c2e0e1148316c37e07389e2c6c3ab9ae40bdc0
0x4be6f11ee1310ecf29a9d0130a12a9d0885e0c92	0x479c52e3b7878c576ab3b3b2e3331c5a0d4157e3	false	3047501865000000000000000000	66	5866940	0x000000000000000000000000479c52e3b7878c576ab3b3b2e3331c5a0d4157e3	102	2023-06-12T14:59:01.000Z	0xa91feb60f622dcdd059082cb91198b760eb20d8b22cae31d1f15806029cdf038
0x4be6f11ee1310ecf29a9d0130a12a9d0885e0c92	0x057b90a36db201a566f089a3aebf16fa5938f213	false	27292187186000000000000000000	16	5898195	0x000000000000000000000000057b90a36db201a566f089a3aebf16fa5938f213	102	2023-06-12T23:46:02.000Z	0xe6ef5138b1f41f204a2fe4f5b46f15f120488e423e5ddb72bd76208e2f571660

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_zksyncera.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_zksyncera.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_zksyncera.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_zksyncera.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_zksyncera.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_zksyncera.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

in_to	in_qty	address	removed	log_index	block_number	in_dstChainId	block_timestamp	transaction_hash
0x38daf90b1a6f29ef3474f8c9a252e9ae3e21e626	4178542714	0x0500829d804b498964849838db9a32c67a0d19c3	false	12	9297291	109	2023-07-22T23:53:21.000Z	0x78715c194e25bb822e45100eb723dadb2d04065572609f08cc6df9d804f8d6f3
0x818cc541af31b71eeb3403d53f31927f9be7d476	4008629189	0x0500829d804b498964849838db9a32c67a0d19c3	false	12	9279257	109	2023-07-22T18:50:29.000Z	0x786f95084514bcd22ce319b060a76587f9f4384a705058191a7e9119c86d0e09
0xbfa45ca4d0d59b31f92e0470e0b5f9d07fa0347b	4179188387	0x0500829d804b498964849838db9a32c67a0d19c3	false	12	9277383	109	2023-07-22T18:18:59.000Z	0xd32039df7af6308bf4b7c58a24a8bc2b77f3f0ca7a088b2c35c024bd229700d1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_zksyncera.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_zksyncera.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