layerzero_v1_avalanche

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`	`STRING`	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
165153	15661463529066838	true	161672	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000020abd0f97172d0000000000000000000000000000000000000000000000000000000000000000014afb8ba583d397ca3179f6037ad1abf27c7d6152b000000000000000000000000	58198706	0x1509706a6c66ca549ff0cb464de88231ddbe213b	109	2025-03-04T09:17:51.000Z	0x1509706a6c66ca549ff0cb464de88231ddbe213b1509706a6c66ca549ff0cb464de88231ddbe213b	0x4c217506bcefc687c310d6c13c22a140c0e26ea8add4ab63373ea57c644ee3c2	0x	0xafb8ba583d397ca3179f6037ad1abf27c7d6152b	0x0000000000000000000000000000000000000000
203050	1483487754935552	true	175476	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000001ffe2919c9fd140000000000000000000000000000000000000000000000000000000000000000014b21a66f9bb622b60139073ae908b648598e6deb5000000000000000000000000	58200304	0x1509706a6c66ca549ff0cb464de88231ddbe213b	111	2025-03-04T10:01:16.000Z	0x1509706a6c66ca549ff0cb464de88231ddbe213b1509706a6c66ca549ff0cb464de88231ddbe213b	0x87d1b73c435610699fd63cd845e95d3ab7acff17f1fe05737aa8bab80481da15	0x	0xb21a66f9bb622b60139073ae908b648598e6deb5	0x0000000000000000000000000000000000000000
165423	6767341292462373	true	161945	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000002d2a83b65d3a68000000000000000000000000000000000000000000000000000000000000000001414b4a7258812ad64a94bd7a8a8e37d09c568f8c0000000000000000000000000	58211882	0x1509706a6c66ca549ff0cb464de88231ddbe213b	184	2025-03-04T15:03:33.000Z	0x1509706a6c66ca549ff0cb464de88231ddbe213b1509706a6c66ca549ff0cb464de88231ddbe213b	0x855a4031037c0a5c0f80c4eed1409b3e706f185c2c34c84b7dc42a7e5e97d563	0x	0x14b4a7258812ad64a94bd7a8a8e37d09c568f8c0	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_avalanche.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
0x188fb5f5ae5bbe4154d5778f2bbb2fb985c94d25	0x08498064e991defe658124262c1c7ef13d9ae4c5	false	2048575000000000000000000	6	46820565	0x00000000000000000000000008498064e991defe658124262c1c7ef13d9ae4c5	110	2024-06-17T07:11:54.000Z	0xc4d162851edadc91b69e5bbe60e92c639928d178521ba36e151ef4e67d5a6964
0x2297aebd383787a160dd0d9f71508148769342e3	0x009bc05f5e109b99738a00552a97fb907a891126	false	90	6	46825089	0x000000000000000000000000009bc05f5e109b99738a00552a97fb907a891126	111	2024-06-17T09:47:40.000Z	0xb2524a5552060985f5766b5c9b13601c2ec7a00d5f72cef761cbb74b925cf6b7
0x2297aebd383787a160dd0d9f71508148769342e3	0x25d53538d04b0486c753ae330d76cff3787a2f27	false	38251	6	46824796	0x00000000000000000000000025d53538d04b0486c753ae330d76cff3787a2f27	102	2024-06-17T09:37:38.000Z	0x1ba5c1b91f8d613a780cb553053be6daa9c431feec591ebded02a29faed0de72

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_avalanche.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
0xf85ed5489e6add01fec9e8d53cf8facfc70590bd	false	{“nonce”:“922”,“sender”:“0x00000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f392”,“srcEid”:“101”}	19	0x96e1056a8814de39c8c3cd0176042d6cecd807d7	63080257	2025-05-31T20:04:40.000Z	0x3ed6ad082b2bc58d55b6b8f3dc106d3e02bd732b2166a9ccd1043910e5f8a122
0xf85ed5489e6add01fec9e8d53cf8facfc70590bd	false	{“nonce”:“1324”,“sender”:“0x000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e”,“srcEid”:“110”}	63	0x96e1056a8814de39c8c3cd0176042d6cecd807d7	63058687	2025-05-31T11:02:36.000Z	0xfae2924d0e6b0fe46cf2b836db37f23561915bfba93027704e5a53e2058527b5
0xf85ed5489e6add01fec9e8d53cf8facfc70590bd	false	{“nonce”:“330”,“sender”:“0x000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e”,“srcEid”:“111”}	2	0x96e1056a8814de39c8c3cd0176042d6cecd807d7	63055981	2025-05-31T09:52:19.000Z	0x1bd77812b5b2af3b32ae9c230cee4a3309950a1185ce97c36120319c3d5e32f8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_avalanche.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
0x31cae3b7fb82d847621859fb1585353c5720660d	[“5739784884927052”,“5739784884927052”]	false	3	63817934	2025-06-14T01:57:41.000Z	[]	[“0x962f502a63f5fbeb44dc9ab932122648e8352959”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0x2bd3a8b0a63a1b6bbbbbb914c7f150e5603b14c6c3eca001ebcc5c6c9a6217be
0x31cae3b7fb82d847621859fb1585353c5720660d	[“780489918270865”]	false	3	63813255	2025-06-14T00:01:59.000Z	[]	[“0x962f502a63f5fbeb44dc9ab932122648e8352959”]	0xbefa2fc28e890985defbc56e17ea90c71aa560d7ee281c1d5f85fedf8a88ec2a
0x31cae3b7fb82d847621859fb1585353c5720660d	[“4962612989797787”,“4962612989797787”]	false	24	63829192	2025-06-14T06:43:24.000Z	[]	[“0x962f502a63f5fbeb44dc9ab932122648e8352959”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0xc4d5bfee5d66a41b8b7c503bfa862dd7e2b7ef40a3ec7ac81dfb581e50270c5c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_avalanche.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
24999540372030003	0x31cae3b7fb82d847621859fb1585353c5720660d	false	2	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	63080765	2025-05-31T20:16:59.000Z	0x2100890bee685c049890467ca9b2af03a887127eaac8da7149a98a2a5e45f1a1
18801420872825733	0x31cae3b7fb82d847621859fb1585353c5720660d	false	2	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	63051545	2025-05-31T07:58:21.000Z	0x86213fda410c7eff95f95227cfcae0bfa5594d7a7c55d1c45c3d242de756c535
19346523267828533	0x31cae3b7fb82d847621859fb1585353c5720660d	false	2	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	63033023	2025-05-31T00:17:16.000Z	0xe860d0590af73d3ce4edb877a15700b8ad502177f62a29028d38d043896d60b5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_avalanche.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
0x31cae3b7fb82d847621859fb1585353c5720660d	0x90e595783e43eb89ff07f63d27b8430e6b44bd9c	false	918358445087006115	9	0xe93685f3bba03016f02bd1828badd6195988d950	42776802	2024-03-11T21:01:37.000Z	0x73c637ce6fcd14c7086cce81fe12bc0bd16c63b9d2e9968cc556fac64068e037
0x31cae3b7fb82d847621859fb1585353c5720660d	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	2557680000000000	6	0x21c3de23d98caddc406e3d31b25e807addf33633	42776894	2024-03-11T21:04:42.000Z	0xf3d6e080531a499d1e6a278101af4950d6f635acb1ee6f51da294acc2cab00c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_avalanche.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
0x31cae3b7fb82d847621859fb1585353c5720660d	false	4	0x00010000000000000000000000000000000000000000000000000000000000030d40	64714907	21909730033567943	2025-06-30T11:12:06.000Z	0x69c2b54abfed145a250520ece72d93119f9a3d556702a58b4ba50081747d3a5f	0x0100000000000006450000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d70000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e5b00f4a4d43c8d80942c0f497b8ac8721c5e852e217388554e18fd203fd9a88d000000000000000000000000003b8328c9c44217a8162112350c4601cf849e44c000000d92c0689da1
0x31cae3b7fb82d847621859fb1585353c5720660d	false	31	0x00010000000000000000000000000000000000000000000000000000000000030d40	64738253	195955843816704482	2025-06-30T21:16:04.000Z	0x6a9f00113cbbb72a7bf38b0d5bcfd57ce447a0e2d6fb6592733a121b04a8605c	0x0100000000000003790000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d70000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f3928b35907ea8744e1f36d8b723ba8893b28a26a7123fd0c011cec1d6edf1f354980000000000000000000000000045d11f7ebbc79f18467dd534e2865d0dba6aa4350000351b0cf9084c
0x31cae3b7fb82d847621859fb1585353c5720660d	false	37	0x00010000000000000000000000000000000000000000000000000000000000030d40	64722025	26977877630374583	2025-06-30T14:25:08.000Z	0x6afe20e32972ff75e528f1eb3522728facf9b6d85ba9a18269cf4489bbeeaed8	0x01000000000000068b0000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7000000b8000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5ec10159b076de29b409924418721cbbd276280a4b5580ee91d329b4289d76e0ac00000000000000000000000000ca74f404e0c7bfa35b13b511097df966d5a6559700002af6203318dc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_avalanche.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
0x97f16b00d436fcd49d5911e68002f1cd4d5e47c5	5212495179397303665	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	5	25773800	102	2023-02-03T09:12:46.000Z	0x910f00ac8264088b884b22c7d5d2e8770550f870a2445704e794799daecf6b42
0xe8c4f2a3fdbd8d3e3143038b60c1c4655567fe58	12000000000000000000	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	5	25779571	110	2023-02-03T12:29:12.000Z	0x5290f34f8d477ae2cb8ba0fd5eccbd08f816f0593ba02fafb3b47bf898af11ca
0x21383e05df94a7adb53713d28905e159a6332ebb	100169648725484113589	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	6	25794936	110	2023-02-03T20:58:41.000Z	0x766c6ebc4b4ae05d137d469b70d6057cee18e341e44d01e81f5d914d2d375655

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_avalanche.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
0x1205f31718499dbf1fca446663b532ef87481fe1	0x708f741b5fa76c9f4a70355207b4f0226ce265f3	false	156011	0	101	5197250915	26542346	1	2964211	2023-02-21T11:01:30.000Z	0xd561eb25eef44699b43e2e7d08c9b409557b884698be1cc6576d4992b2f8d33d
0x1205f31718499dbf1fca446663b532ef87481fe1	0x96ea017109c7691a3080e16c2095b547e29d82f5	false	64963	1	101	2164153851	26526596	1	1234308	2023-02-21T02:09:14.000Z	0xb304ff94613bffba83e4107987e65434db3cfa7d1d1e4e2b1e3c6405c98c0eb0
0x1205f31718499dbf1fca446663b532ef87481fe1	0x708f741b5fa76c9f4a70355207b4f0226ce265f3	false	343949	1	101	11458094593	26542240	1	6535034	2023-02-21T10:57:54.000Z	0x111f7d08bbc9debbb15e1a299d5b204e8c2e6e23c2c744883ddbb3203bf6d1b2

Example Query

Query with partition filter

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