layerzero_v1_base

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.

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
257526	195708923449221	false	152889	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7		29523932	0xaf54be5b6eec24d6bfacf1cce4eaf680a8239398	0,11,1,6,1		2025-04-28T10:46:51.000Z		0x7a4368cb073492e6e4926eec6d1054d367b4d01df7952f3c13e7c6194f49fb0d
946717	193416058673821	false	157472	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7		29523162	0x2859a4ebcb58c8dd5cac1419c4f63a071b642b20	0,3		2025-04-28T10:21:11.000Z		0x836c917ba91f7fd908e46d2257a94247c1a785078e8cc6ad02afee28a174f41c
298358	1391020050440821	true	165390	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000014b5e00621963ce9a051c938d246bc6aa3012d8dd8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000001c829c00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000040000	29506958	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	0	110	2025-04-28T01:21:03.000Z	0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222	0x189cee1ccbd9c7e86956ed38cab91d55042a8506aea729c32d97cf657853db26	0x00020000000000000000000000000000000000000000000000000000000000030d4000000000000000000000000000000000000000000000000000038d7ea4c68000b5e00621963ce9a051c938d246bc6aa3012d8dd8	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_base.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
0x233dc79f924c35acb4524bac4a883c8ce11a75b2	0x3db61d37ee38e2aa668fcbb3ba7b99262040ded3	false	49105627522043007	31	4426160	0x0000000000000000000000003db61d37ee38e2aa668fcbb3ba7b99262040ded3	111	2023-09-25T11:34:27.000Z	0xaebf3c65878e68fcd162881bbcff154fc5babfbe676ef1d22d8b3c074bad5ab9
0x3055913c90fcc1a6ce9a358911721eeb942013a1	0x69fc97e8567f52dccd9d3ef841672d8a11c82a51	false	500991345250000000000	19	4425686	0x00000000000000000000000069fc97e8567f52dccd9d3ef841672d8a11c82a51	102	2023-09-25T11:18:39.000Z	0x65b4a632b77f92e72e11cbde4d608025417f1ed923de56b54be34d4a6acb76b6
0x3055913c90fcc1a6ce9a358911721eeb942013a1	0x42ba161575cc2c46992907d523c77bf10ecb30c6	false	6500000000000000000000	19	4430619	0x00000000000000000000000042ba161575cc2c46992907d523c77bf10ecb30c6	102	2023-09-25T14:03:05.000Z	0x00b7f146348e34fc758e5141cc446992ab173dc740a27bc423ad62fa774ba0d2

Example Query

Query with partition filter

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

address	removed	in_origin	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x58d53a2d6a08b72a15137f3381d21b90638bd753	false	{“nonce”:“447”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“109”}	171	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	30367910	2025-05-17T23:39:27.000Z	0x2969140038cd50a625372ed8d9f8fff16b101988bed70496ef644d7ad5a5703c
0x58d53a2d6a08b72a15137f3381d21b90638bd753	false	{“nonce”:“429”,“sender”:“0x00000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f392”,“srcEid”:“101”}	23	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	30356724	2025-05-17T17:26:35.000Z	0xf697e52c598af883c30691d0d931935302820c98cbd1859a2ce0503de702aaf9
0x58d53a2d6a08b72a15137f3381d21b90638bd753	false	{“nonce”:“427”,“sender”:“0x00000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f392”,“srcEid”:“101”}	157	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	30356691	2025-05-17T17:25:29.000Z	0x4a423e8f305235d900b2c95f4a2fe007fc717a645895a22a7e321293fc6db6ea

Example Query

Query with partition filter

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

address	in_fees	removed	log_index	block_number	block_timestamp	in_optionalDVNs	in_requiredDVNs	transaction_hash
0x9db3714048b5499ec65f807787897d3b3aa70072	[“2435781664281”,“2406525771157”]	false	246	31787791	2025-06-19T20:28:49.000Z	[]	[“0x9e059a54699a285714207b43b055483e78faac25”,“0xcd37ca043f8479064e10635020c65ffc005d36f6”]	0xa58a195f55aeec4ac77e2421ab535411ab12c616d7d44f67e13b0fa95a043bc4
0x9db3714048b5499ec65f807787897d3b3aa70072	[“2435781664281”,“2406525771157”]	false	413	31776831	2025-06-19T14:23:29.000Z	[]	[“0x9e059a54699a285714207b43b055483e78faac25”,“0xcd37ca043f8479064e10635020c65ffc005d36f6”]	0x4c945ebbafc25e02eedeed349b7e2f9cd4a27844b6c7acbdc4a2e22cf480b57e
0x9db3714048b5499ec65f807787897d3b3aa70072	[“2435781664281”,“2406525771157”]	false	12	31754270	2025-06-19T01:51:27.000Z	[]	[“0x9e059a54699a285714207b43b055483e78faac25”,“0xcd37ca043f8479064e10635020c65ffc005d36f6”]	0xe83ec1874ea1498a6371db31b329ab949975d7000ad803c99c2f190484f3cbe4

Example Query

Query with partition filter

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

in_fee	address	removed	log_index	in_executor	block_number	block_timestamp	transaction_hash
148948267340718	0x9db3714048b5499ec65f807787897d3b3aa70072	false	517	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	31180114	2025-06-05T18:52:55.000Z	0xca55b49b5f488e265756c86715161c7a5c1a19d52decd8215c37ec90d74a2222
204606904543155	0x9db3714048b5499ec65f807787897d3b3aa70072	false	192	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	31181181	2025-06-05T19:28:29.000Z	0x7c4810a7ad10adca09c3ad2fb64cea4897c0e5303ed79d324a3a1aa2a9b82311
21875970170352	0x9db3714048b5499ec65f807787897d3b3aa70072	false	45	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	31155913	2025-06-05T05:26:13.000Z	0x66fcc89f977b21786a633b70ebd7c44296aeb5c2438303f1f5cd3c2369e20cc3

Example Query

Query with partition filter

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

address	in_user	removed	in_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x9db3714048b5499ec65f807787897d3b3aa70072	0x2cca08ae69e0c44b18a57ab2a87644234daebae4	false	274852458190410	5	0xe93685f3bba03016f02bd1828badd6195988d950	11700774	2024-03-11T21:01:35.000Z	0x7596e287df746974a0256f33230383082905a36e1433a9d77f554f9d771f60f9
0x9db3714048b5499ec65f807787897d3b3aa70072	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	42190197469472	17	0x21c3de23d98caddc406e3d31b25e807addf33633	11700868	2024-03-11T21:04:43.000Z	0x6245a66f7284d3a935ba4a729a772c30a2c9040adc7b6a219ed3bcaa07007290

Example Query

Query with partition filter

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

address	removed	log_index	in_options	block_number	in_nativeFee	block_timestamp	transaction_hash	in_encodedPayload
0x9db3714048b5499ec65f807787897d3b3aa70072	false	70	0x00010000000000000000000000000000000000000000000000000000000000030d40	32608906	1106022136095021	2025-07-08T20:39:19.000Z	0x0edc909d965562a2a2abfb236d4080c9b7811c9f19d7abcfee4fc710b37cf80c	0x0100000000000001ee000000b8000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f3924b810c6eac10007f2853a2e59ac31eeaf7277d8897e3b42e22914ed3b07d983c00000000000000000000000000ca74f404e0c7bfa35b13b511097df966d5a65597000030ab504d6140
0x9db3714048b5499ec65f807787897d3b3aa70072	false	10	0x00010000000000000000000000000000000000000000000000000000000000030d40	32595503	26279460076821	2025-07-08T13:12:33.000Z	0xbf00dff4088c5a5ce78dc157e991296f9497f319c49aa7e388bf1e22f5c94c59	0x0100000000000003ec000000b8000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5ed22c615c10febebb140f2909907bbfc24a08c6046dbb8e4fe61c66072a7a05be00000000000000000000000000dd60bbe5215dcc48489cdbfd90a026654fc5ad9300000023f7cb1e05
0x9db3714048b5499ec65f807787897d3b3aa70072	false	27	0x00010000000000000000000000000000000000000000000000000000000000030d40	32595475	26279460076821	2025-07-08T13:11:37.000Z	0x8b8e7cf7cd317f54f8ccaf1ff634ec4828a2822a8832c46dd310c9011878404e	0x0100000000000003eb000000b8000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e4c37bc9c779262cff7bd517e9267cd257c8dafac5410b39bfb79d59d8093991200000000000000000000000000c8e74e991fd6aaa6cbf324cb1d095daf6fa7ebc800000020529a1ab3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_base.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
0xcc88833afbffcfd33f54c52d46ccb43e8b261272	40000000000000000000	0xe3b53af74a4bf62ae5511055290838050bf764df	false	39	30342131	106	2025-05-17T09:20:09.000Z	0xf472d4ec90b9d3129b45b4ab49535420d0ab1d3c992729438625b0a9751a6849
0xe09fb79b0313dfeee1fe8682a4b48f3ea00fd2d0	1538844450578655804	0xe3b53af74a4bf62ae5511055290838050bf764df	false	57	30346411	109	2025-05-17T11:42:49.000Z	0x455fffe99ceb894b5c46755091e739dae6ef4085e7649d2c4ab40b3ddb565728
0x061b58aa835f3eab14dcfb57e9fc563ed0db78a5	6957058425126234758	0xe3b53af74a4bf62ae5511055290838050bf764df	false	89	30346681	110	2025-05-17T11:51:49.000Z	0xee64426bc8271f9fea6e75d5f87525f14fc285eca5e6e2ef45fad2b292c08039

Example Query

Query with partition filter

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

address	in_from	removed	in_eqFee	log_index	in_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	0x50b6ebc2103bfec165949cc946d739d5650d7ae4	false	477083284826402	403	101	749072916715173598	4934331	13	450000000000000	2023-10-07T05:53:29.000Z	0xd7b3048f1311db55cd23839fcdf3fe3f12cc3c2e0ac96f5d5390ce4b408a8603
0x4c80e24119cfb836cdf0a6b53dc23f04f7e652ca	0x1952044993727e700594b7d92295dc2ddaf16418	false	12777	84	101	425665500	4936874	1	242775	2023-10-07T07:18:15.000Z	0x46bc7e57ca12de59c2f2c8d9f33beca97b3ec04a61fc96623ecfcd0343ee4d04
0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	0x50b6ebc2103bfec165949cc946d739d5650d7ae4	false	387478123655934	44	101	669998197512267932	4948428	13	402472889115022	2023-10-07T13:43:23.000Z	0xb3747681e47cd6cdd00180b3e9a33b2cf3d7d31e916f20cec93c2fa8bd694a5d

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

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

​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

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