layerzero_v1_arbitrum

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
282492	1048640609679772	true	155400	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000014f9e611a96fa210d34c7ac573e59cac5e195cceb90000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000024b3aa00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000001000000	167638232	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	184	2024-01-06T09:41:21.000Z	0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222	0x359e10fe218eec93622f0eed0a939560e29f6cef80e5a20740f4c87f4d2b9225	0x00020000000000000000000000000000000000000000000000000000000000030d400000000000000000000000000000000000000000000000000002d79883d20000f9e611a96fa210d34c7ac573e59cac5e195cceb9	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	0x0000000000000000000000000000000000000000
402644	1066636512000000	true	161057	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000146dd32acd26b58c331b7d2c5c0a727ae829ec16420000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000024b33700000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000001000000	167513451	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	158	2024-01-06T00:40:10.000Z	0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222	0xf4e2bb7a2b756fdcaf68880da52eae62d55c2873d7dc51c38fa4241fea8682a9	0x00010000000000000000000000000000000000000000000000000000000000030d40	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	0x0000000000000000000000000000000000000000
293192	128265583966725	true	162302	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	0x000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000146f66c41a3adea17233d501194d4144e21c6b679c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000024b33500000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000001000000	167511551	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	202	2024-01-06T00:31:52.000Z	0x0000049f63ef0d60abe49fdd8bebfa5a688222220000049f63ef0d60abe49fdd8bebfa5a68822222	0xb291ac85dcf555149de64b385e817d3feeeda98b76813f504bf9b6043e507108	0x00020000000000000000000000000000000000000000000000000000000000030d400000000000000000000000000000000000000000000000000001c6bf526340006f66c41a3adea17233d501194d4144e21c6b679c	0x0000049f63ef0d60abe49fdd8bebfa5a68822222	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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
0x1b896893dfc86bb67cf57767298b9073d2c1ba2c	0xe97b93d7b15b16a4f910e302c804d2e27a1b3c16	false	55628910820000000000	40	175416413	0x000000000000000000000000e97b93d7b15b16a4f910e302c804d2e27a1b3c16	183	2024-01-29T14:51:07.000Z	0x35d1c62788318d9d5e36b2bdbec132aa6ce475645e3375d9624f0acffdd0ae2b
0x1b896893dfc86bb67cf57767298b9073d2c1ba2c	0x31cc30274a7c8c62dac5bf005bf58a9f8d6470e7	false	21533330000000000	8	175436665	0x00000000000000000000000031cc30274a7c8c62dac5bf005bf58a9f8d6470e7	202	2024-01-29T16:17:10.000Z	0xe4e8614d5cb558b9c090fc2e21e5bd2c88d7d56e8cc7512cb0797ac63e09c10e
0x64f282290e8d0196c2929a9119250c361e025bab	0x4100afe4fca13951b51688e1bdf766e762c389d2	false	99950000000000	7	175539148	0x0000000000000000000000005334e091595cbfd5067dd914de7d7c9c7ccf48e4	196	2024-01-29T23:46:11.000Z	0x0b1a4695dba5547aa92e953f47dd2a153aee1841ceb80c5b372a5a5a8323ac9e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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
0xe4dd168822767c4342e54e6241f0b91de0d3c241	false	{“nonce”:“535”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“102”}	35	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	338308092	2025-05-19T12:19:26.000Z	0x2ad617005cb99b63aed6f0115663e94e1ddfc7d9aa07195b029518481a7f23db
0xe4dd168822767c4342e54e6241f0b91de0d3c241	false	{“nonce”:“533”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“102”}	2	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	338236689	2025-05-19T07:18:54.000Z	0xffedee61b159dd7426658cc8b66e5b66889dc2e7cc80c53c84c402b7399e3052
0xe4dd168822767c4342e54e6241f0b91de0d3c241	false	{“nonce”:“532”,“sender”:“0x00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c7”,“srcEid”:“102”}	9	0xbfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e	338236304	2025-05-19T07:17:18.000Z	0x9f7b275b3fe928f0f841b6478c38384447792234df2f0413cdfb2fdc39582210

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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
0x5cdc927876031b4ef910735225c425a7fc8efed9	[“4767348000000”]	false	42	285502814	2024-12-16T22:39:17.000Z	[]	[“0x2f55c492897526677c5b68fb199ea31e2c126416”]	0xd3b57fb089e280d58e0211f14b80a7301f92e8bbe36d4eb54862054f88a93b24
0x5cdc927876031b4ef910735225c425a7fc8efed9	[“18746732914”]	false	10	285502814	2024-12-16T22:39:17.000Z	[]	[“0x2f55c492897526677c5b68fb199ea31e2c126416”]	0x02b14c6525e7687b2bdda8e7f23c7f03fd92ba334fc384d4c4a926bb597c2438
0x5cdc927876031b4ef910735225c425a7fc8efed9	[“168779405775”,“168779405775”]	false	7	337474282	2025-05-17T02:02:16.000Z	[]	[“0x2f55c492897526677c5b68fb199ea31e2c126416”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0xd3197895fce399ee1352db3dfd0ecd70d524a4cd1e32c9048060019b6f078703

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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
145662450563535	0x5cdc927876031b4ef910735225c425a7fc8efed9	false	2	0x31cae3b7fb82d847621859fb1585353c5720660d	354517175	2025-07-05T13:29:01.000Z	0xcd91705043488edb11b8c2bb5edad25cb9b0f46ee407f77df730b97f2940ee7d
145697624387271	0x5cdc927876031b4ef910735225c425a7fc8efed9	false	18	0x31cae3b7fb82d847621859fb1585353c5720660d	354518497	2025-07-05T13:34:33.000Z	0x3d9c55b1ff829e6467b96f1a65bd1172e03221d10f9bbe2ef79cc94969c11d36
145787918974311	0x5cdc927876031b4ef910735225c425a7fc8efed9	false	8	0x31cae3b7fb82d847621859fb1585353c5720660d	354518463	2025-07-05T13:34:26.000Z	0x48da05d800ac3d4d50b706553fa7b46ceeaa5635c60d6fc41bb6e7b7b9b6ebc8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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
0x5cdc927876031b4ef910735225c425a7fc8efed9	0x31cae3b7fb82d847621859fb1585353c5720660d	false	1214127785251026	0	0xe93685f3bba03016f02bd1828badd6195988d950	189410572	2024-03-11T21:01:35.000Z	0x205767b1e84e72feedc4dfd8306afe5d1d78f6e9db67ba025c0ba16c365afa48
0x5cdc927876031b4ef910735225c425a7fc8efed9	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	121246680000000	3	0x21c3de23d98caddc406e3d31b25e807addf33633	189411274	2024-03-11T21:04:41.000Z	0xf49dcab3fa78bd41367ea34a602ac3fc0f04722daf6ea4f5261c16aee28fed05
0x5cdc927876031b4ef910735225c425a7fc8efed9	0x31cae3b7fb82d847621859fb1585353c5720660d	false	430834318674917	1	0xe93685f3bba03016f02bd1828badd6195988d950	195179913	2024-03-28T18:40:22.000Z	0xe1939c5252da7dca4d5eaec29e8a0478060c8408e51c993592fc9080699e60a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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
0x5cdc927876031b4ef910735225c425a7fc8efed9	false	41	0x00010000000000000000000000000000000000000000000000000000000000030d40	339145543	1289014818334960	2025-05-21T22:40:09.000Z	0xdf4eaca958c1cea66d9d2bf531b2aecea7ed36e372e601039ffd5700b852290b	0x01000000000000019c0000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006500000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f3926fa439d471e21304d741e36942dced5c799976e1f68fae3b2bba1cbdaf7cf27500000000000000000000000000b24387a9bdc01f219c2c4a649fe784bd6ffd91de000001ff5d14f7bf
0x5cdc927876031b4ef910735225c425a7fc8efed9	false	4	0x00010000000000000000000000000000000000000000000000000000000000030d40	338951491	148034619161186	2025-05-21T09:10:02.000Z	0x42423b37aded3729b0070d9717a98bbd0cc8f26c2239313938e644d3f8cc263c	0x0100000000000005250000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7554f27c8bc24d8575ecaab90dd689abdaed3b3f6407a3029aa0dc4c0e792c1470000000000000000000000000091f82d236f6b88e830864032301b0ba6145a50fc000000414cdbd5d4
0x5cdc927876031b4ef910735225c425a7fc8efed9	false	6	0x00010000000000000000000000000000000000000000000000000000000000030d40	338890169	160157361205481	2025-05-21T04:54:19.000Z	0xcff6b4d687c2bb68dddd6667b3073ae522642e29418625a850df49139151a20d	0x01000000000000025e0000006e000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e0000006600000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c735a7dc304d44b7e40eb5098a5aaa9863284196218efae6208022a8629968fce900000000000000000000000000350254da53d5c6ab6a27a446582fa60fe120930c000015dc7dd78cb8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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
0xc6f41bf72153b4cd991fb0e4d42f15cdca97ec61	102117584436773964704	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	false	5	97562246	101	2023-06-04T03:03:41.000Z	0xee940eb1ece6780a570512129bc1f4796c71f776805eb9783d352bf2821a88b6
0x06e6fc96de94e49b771898642831f370a07e0f8d	2650000000000000000	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	false	5	97719303	101	2023-06-04T14:05:48.000Z	0xa474fa2981d6962c04c0447a438df8a2037b79da3d5d96a6d811d00b58c0a215
0x3fc6094b4c92ecb4eb64cc7898d4492ae87a2cd5	900000000000000000	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	false	5	97826629	101	2023-06-04T21:35:53.000Z	0xf573df2fe11b1cbccab27e2d89a1074db767fd81b557d5d14f2e6bf39fe2da25

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_arbitrum.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	in_eqReward	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0xb6cfcf89a7b22988bfc96632ac2a9d6dab60d641	0xecc19e177d24551aa7ed6bc6fe566eca726cc8a9	false	502	41	111	1244417	0	226185544	1	1245	2024-06-27T07:35:11.000Z	0xef5c4ecf341af5824d8568c9aca8fdae622f9f81f3730d08286f09f955acd1ce
0x892785f33cdee22a30aef750f285e18c18040c3e	0xf787f24186e777debeae0fc3bb04c308af9920ea	false	687	45	111	22822545	97051	226112475	1	97051	2024-06-27T02:30:32.000Z	0xb2d1a5d1f86b8a7b03136632d538167fa90bce46cdadc2af99f1e180d201fafa
0xb6cfcf89a7b22988bfc96632ac2a9d6dab60d641	0xecc19e177d24551aa7ed6bc6fe566eca726cc8a9	false	1126	47	111	2713343	0	226235479	1	2716	2024-06-27T11:03:15.000Z	0xee5b6592738f3273a0158c40cb22f6b9ae9452659bb23d72300084f55d13124a

Example Query

Query with partition filter

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