layerzero_v1_celo

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`	`NUMERIC`	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
217649	78745704617654380	true	151709	0xc5803100	0x3a73033c0b1407574c76bdbac67f126f6b4a9aa9	0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000001440a6025a7b5bf6b89325b8d1019f5359bd00f877000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000e005a00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000200	23197929	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	126	2023-12-27T06:41:23.000Z	0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222	0x9bee83c42a109f8071ee197b21fa0295346dfa99989ca4754a6761bbe57350c1	0x00010000000000000000000000000000000000000000000000000000000000030d40	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	0x0000000000000000000000000000000000000000
217660	82337911274779310	true	151709	0xc5803100	0x3a73033c0b1407574c76bdbac67f126f6b4a9aa9	0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000014f52be165191e50cb697964ff5fb06a535af09440000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000e001e00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000200	23197211	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	126	2023-12-27T05:41:33.000Z	0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222	0x0015e9b62d9c3c79544f75ee5d39bac1efd3d8d6bd813443679109702d2b52df	0x00010000000000000000000000000000000000000000000000000000000000030d40	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	0x0000000000000000000000000000000000000000
217660	78745704617654380	true	151709	0xc5803100	0x3a73033c0b1407574c76bdbac67f126f6b4a9aa9	0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000149373d6b0c9f4c138818f10bab9f13512ee3e45e4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000e00a200000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000200	23198664	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	126	2023-12-27T07:42:38.000Z	0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222	0x8e13aafcd3f120353f92d4d4884a21ff6e92a98d97029c8ecb699fd66c9b73f3	0x00010000000000000000000000000000000000000000000000000000000000030d40	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_celo.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
0xa8cccb1be30604e69d5014022b56aed8b247bfb0	0x5414952ef2231e41fd4912f5121946a683749eee	false	1521570600000000000000	17	21001481	0x0000000000000000000000005414952ef2231e41fd4912f5121946a683749eee	145	2023-08-22T03:44:36.000Z	0xed65c20b9179600b72e78e9024d1c7f990b6429f9a99ce94abf44a22646a7f79
0xd35055db8fa9aa4426edccbab2bca760c24a6610	0x74900790dd8178239180862d274738bbd8c6e461	false	1000000000000000000	32	20108236	0x00000000000000000000000074900790dd8178239180862d274738bbd8c6e461	145	2023-07-01T11:04:14.000Z	0xc7a19cfa2998bf7f0519d3554c526dfd82a73020acd8c8342e1cd84bd78f8f44
0xd35055db8fa9aa4426edccbab2bca760c24a6610	0x74900790dd8178239180862d274738bbd8c6e461	false	1000000000000000000	8	20108230	0x00000000000000000000000074900790dd8178239180862d274738bbd8c6e461	145	2023-07-01T11:03:44.000Z	0x9e207326e592f207b4f5eb83be434ee778b712115b17ab586f7ca9230711e742

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_celo.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
0x556d7664d5b4db11f381c714b6b47a8bf0b494fd	false	{“nonce”:“1”,“sender”:“0x000000000000000000000000fee867ed545f26621dc701e6164e02ead9c6b081”,“srcEid”:“125”}	5	0xfee867ed545f26621dc701e6164e02ead9c6b081	23901594	2024-02-06T00:06:26.000Z	0x26823cc99266779f1519426de5a4ed140cf6fa9b0395fd1bfad1a9e59287adec
0x556d7664d5b4db11f381c714b6b47a8bf0b494fd	false	{“nonce”:“1”,“sender”:“0x000000000000000000000000da9264c68295b06a05feff112333e1faa6b40535”,“srcEid”:“102”}	22	0xda9264c68295b06a05feff112333e1faa6b40535	23910986	2024-02-06T13:09:17.000Z	0x791dcbcdd2954387100993618d496ebcc7aab6b21d9d333177a989551430893b
0x556d7664d5b4db11f381c714b6b47a8bf0b494fd	false	{“nonce”:“1”,“sender”:“0x000000000000000000000000da9264c68295b06a05feff112333e1faa6b40535”,“srcEid”:“181”}	3	0xda9264c68295b06a05feff112333e1faa6b40535	23923176	2024-02-07T06:05:25.000Z	0xcd51af9cedf38d62e06718171c379665ccad047be1c58c16acdbaa7a898609a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_celo.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
0xc80233ad8251e668becbc3b0415707fc7075501e	[“1023072000000000”,“1023072000000000”]	false	4	23901584	2024-02-06T00:05:36.000Z	[]	[“0x75b073994560a5c03cd970414d9170be0c6e5c36”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0xb5121c9b1391fba279c090e8a1f4c3e0cdda87f5cb6cfc5e37c2e3981730de13
0xc80233ad8251e668becbc3b0415707fc7075501e	[“4932194856”]	false	10	23900972	2024-02-05T23:14:36.000Z	[]	[“0x75b073994560a5c03cd970414d9170be0c6e5c36”]	0xe3bc3c1ac1557b9226fd68ad03bbce3ab81a1575e8dddab202fad3062e044d61
0xc80233ad8251e668becbc3b0415707fc7075501e	[“876350338054360”]	false	13	23900972	2024-02-05T23:14:36.000Z	[]	[“0x75b073994560a5c03cd970414d9170be0c6e5c36”]	0x59955f0838a073325c2ca35840670dbe5ae426b33428e2b973ab0bc1ab3d9912

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_celo.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
70174189413799511	0xc80233ad8251e668becbc3b0415707fc7075501e	false	3	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	23901584	2024-02-06T00:05:36.000Z	0xb5121c9b1391fba279c090e8a1f4c3e0cdda87f5cb6cfc5e37c2e3981730de13
70168571455066124	0xc80233ad8251e668becbc3b0415707fc7075501e	false	0	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	23900972	2024-02-05T23:14:36.000Z	0x88777d357d87c33a20731dfa1f1df59e6592c8e0537f063d4296709f273dd0e3
469912167447218538	0xc80233ad8251e668becbc3b0415707fc7075501e	false	12	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	23900972	2024-02-05T23:14:36.000Z	0x59955f0838a073325c2ca35840670dbe5ae426b33428e2b973ab0bc1ab3d9912

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_celo.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
0xc80233ad8251e668becbc3b0415707fc7075501e	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	23072000000000	13	0x21c3de23d98caddc406e3d31b25e807addf33633	24504126	2024-03-11T21:04:44.000Z	0xc4a8736491c282ccc35c159ecbc9c71c0aa66770e90d94437ec03af29cd3c6a5
0xc80233ad8251e668becbc3b0415707fc7075501e	0x1ddbaf8b75f2291a97c22428afef411b7bb19e28	false	1847456089759365498	4	0xe93685f3bba03016f02bd1828badd6195988d950	24504089	2024-03-11T21:01:39.000Z	0x0f470456d05f1a73f3e8f7d859760a10b3fdf91dd7b67f61dd32c06d74f2ab7f
0xc80233ad8251e668becbc3b0415707fc7075501e	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	1000000000000000	2	0x21c3de23d98caddc406e3d31b25e807addf33633	24386505	2024-03-05T01:42:18.000Z	0xadc12db986dd5eabe2d79dc0bca707ff7b584ab5f991b091b3adc51b03400601

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_celo.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
0xc80233ad8251e668becbc3b0415707fc7075501e	false	5	0x0003010011010000000000000000000000000007a120	23901584	72220333413799511	2024-02-06T00:05:36.000Z	0xb5121c9b1391fba279c090e8a1f4c3e0cdda87f5cb6cfc5e37c2e3981730de13	0x0100000000000000010000007d000000000000000000000000fee867ed545f26621dc701e6164e02ead9c6b0810000007d000000000000000000000000fee867ed545f26621dc701e6164e02ead9c6b0815ace80cb26cf3f8e3c17dc8aaa7fdb47a32aff4e4bdf6a7ac6e29d7198a08b270100000000
0xc80233ad8251e668becbc3b0415707fc7075501e	false	8	0x0003010011010000000000000000000000000007a120	23900972	1087615684802340552	2024-02-05T23:14:36.000Z	0xbd4136e87c699be33830dba3da2d6b9ed2712df4ae5d294ea093a7ab4d2bc6a1	0x0100000000000000010000007d0000000000000000000000008df53a660a00c3d977d7e778fb7385ecf4482d16000000970000000000000000000000000ac93809f127308de0a962f1fa9693a7ad72f9c48b3661cd46e444f75a0f37206c42c03a20cfe7ddf7afa13f23a126410a38e58f0100000000
0xc80233ad8251e668becbc3b0415707fc7075501e	false	2	0x0003010011010000000000000000000000000007a120	23900972	72440394441975020	2024-02-05T23:14:36.000Z	0x88777d357d87c33a20731dfa1f1df59e6592c8e0537f063d4296709f273dd0e3	0x0100000000000000010000007d0000000000000000000000008df53a660a00c3d977d7e778fb7385ecf4482d16000000990000000000000000000000004d97186cd94047e285b7cb78fa63c93e69e7aad09daad3dd9ad136a3d2e210bbc1f18c552dbdeab63e25585e0201f85b94a5dc180100000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_celo.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
0x5464912b966384bf6fb4222a6eca6013d99d6341	2000000000000000000	0x3108477eb76d943546e009f8ce5c34f0b226560f	false	5	20313389	145	2023-07-13T08:00:26.000Z	0xbe321897722c91f27e3d7bddaabbea3fc49f6a424e3284be01134db2c01812b4
0x5464912b966384bf6fb4222a6eca6013d99d6341	2000000000000000000	0x3108477eb76d943546e009f8ce5c34f0b226560f	false	25	20313167	145	2023-07-13T07:41:56.000Z	0x0dce00595ca5c39a6506e55a4bc92c47f76bad4fc25e72613d352ecb434ab68d
0x5464912b966384bf6fb4222a6eca6013d99d6341	1200000000000000	0x65aeecf86bf052e81926ca8e1fff1de34e265100	false	20	20332759	145	2023-07-14T10:54:43.000Z	0x1785bd3c33ebb0fae6da01c7b5341282f75af02670d769e219ed897c33cfb715

Example Query

Query with partition filter

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