layerzero_v1_linea

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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__dstChainId`	`STRING`	LayerZero chain identifier for the destination blockchain. String-encoded integer representing the target chain in cross-chain message transfers.
`in__destination`	`STRING`	Concatenated address pair used in LayerZero cross-chain messaging to specify source and destination contracts. 84-character hex string without 0x prefix, consisting of two 42-character addresses concatenated together.
`in__payload`	`STRING`	Application-specific message data sent in LayerZero cross-chain transactions. Hex-encoded byte string including 0x prefix, containing contract function calls, token transfer details, or other custom protocol messages.
`in__refundAddress`	`STRING`	Address designated to receive refunds for unused gas or failed cross-chain message execution. Hex-encoded, 0x-prefixed, 42-character string.
`in__zroPaymentAddress`	`STRING`	Address designated for payment in ZRO tokens for LayerZero cross-chain message fees. Hex-encoded, 0x-prefixed, 42-character string, typically set to zero address when fees are paid in native tokens.
`in__adapterParams`	`STRING`	Configuration parameters for LayerZero cross-chain message delivery controlling gas settings and execution options. Hex-encoded byte string including 0x prefix.

Sample Data

gas	value	status	gas_used	signature	to_address	in__payload	block_number	from_address	trace_address	in__dstChainId	block_timestamp	in__destination	transaction_hash	in__adapterParams	in__refundAddress	in__zroPaymentAddress
54315	538184454686173	false	53944	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000051b660cdd5800000000000000000000000000000000000000000000000000000000000000000146bfec82c58084e4295d51cf6529a7f1817509988000000000000000000000000	1654807	0x808d7c71ad2ba3fa531b068a2417c63106bc0949	0	110	2024-01-14T13:31:06.000Z	0x6694340fc020c5e6b96567843da2df01b2ce1eb6808d7c71ad2ba3fa531b068a2417c63106bc0949	0x54bb350226e883e31be49aab588a146757aa35287344406f587898ea59681db0	0x00010000000000000000000000000000000000000000000000000000000000014c08	0x6bfec82c58084e4295d51cf6529a7f1817509988	0x0000000000000000000000000000000000000000
218669	20927424997052	true	65732	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x	1649471	0xbf94ed69281709958c8f60bc15cd1bb6badcd4a4	3	126	2024-01-14T04:37:30.000Z	0xbf94ed69281709958c8f60bc15cd1bb6badcd4a4bf94ed69281709958c8f60bc15cd1bb6badcd4a4	0x53f09491314e4f4f48b8ef68442e706b9931afca709779bbe26f63ff7f776870	0x00020000000000000000000000000000000000000000000000000000000000004e20000000000000000000000000000000000000000000000000000012309ce54000dcc4b9c9c01e82f3d75b01c7c72e48daa6313678	0xbf94ed69281709958c8f60bc15cd1bb6badcd4a4	0x0000000000000000000000000000000000000000
1704510	8902177682651	true	66919	0xc5803100	0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7	0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000014bd289c8ccf862db985f3651567eb5ff47b630fbd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000773ab40	1652641	0x673f8009ad54945365be1f6394e3f016fdb4135d	10	175	2024-01-14T09:54:30.000Z	0xc84388999dcc40631904b1cbdc9fa27dc96fb5f4673f8009ad54945365be1f6394e3f016fdb4135d	0x00bac9cea1c162691d5adb2411ec0a8e4c167b3f80826588d32fd58bcec8b461	0x00010000000000000000000000000000000000000000000000000000000000061a80	0xbd289c8ccf862db985f3651567eb5ff47b630fbd	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_linea.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
0x0d1e753a25ebda689453309112904807625befbe	0x3bdf8f692474b4309eabd3d4a3c75d22618b09d1	false	5384930590000000000	7	15299438	0x0000000000000000000000003bdf8f692474b4309eabd3d4a3c75d22618b09d1	165	2025-02-01T13:07:09.000Z	0xfcd7beabf317c9768aae7123c82d9ec933260159742e2c9be659f00473071678
0x0d1e753a25ebda689453309112904807625befbe	0x3bb5aa7843ea9d5b61feceba12d8b169b769afba	false	7244477470000000000	5	15288821	0x0000000000000000000000003bb5aa7843ea9d5b61feceba12d8b169b769afba	102	2025-02-01T06:49:21.000Z	0x38edd3fb2cabd0164be275d8b0fdb32dc0bc7192993cad0a2acac22294c421c6
0x2b1d36f5b61addaf7da7ebbd11b35fd8cfb0de31	0xbf5fce55793c4188da85d4f03f8a4d94b1569024	false	1736835930000000000	11	15284311	0x000000000000000000000000bf5fce55793c4188da85d4f03f8a4d94b1569024	111	2025-02-01T03:59:54.000Z	0x87924341ff6d458e0bc90959555557750007da3cf3d54d236cb8aabc80092bd7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_linea.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
0x443caa8cd23d8cc1e04b3ce897822aea6ad3ebda	false	{“nonce”:“299”,“sender”:“0x0000000000000000000000002779106e4f4a8a28d77a24c18283651a2ae22d1c”,“srcEid”:“202”}	2	0x0d1e753a25ebda689453309112904807625befbe	20898645	2025-07-15T17:10:33.000Z	0x4dda29b081597c8f62875bb5b8255c12e10f3eff9143da0fe5b29652702f0562
0x443caa8cd23d8cc1e04b3ce897822aea6ad3ebda	false	{“nonce”:“3423”,“sender”:“0x000000000000000000000000b274202daba6ae180c665b4fbe59857b7c3a8091”,“srcEid”:“102”}	7	0x0d1e753a25ebda689453309112904807625befbe	21564444	2025-08-02T15:09:43.000Z	0xb6ab6225502adf4d971f1f5efc5c9ff7fbe1fdadee4198357478f96ce574e729
0x443caa8cd23d8cc1e04b3ce897822aea6ad3ebda	false	{“nonce”:“2”,“sender”:“0x1b698157f83bc6f09b6c6080b9620b1afca98255edb4e5e95af7a6062a4bb121”,“srcEid”:“30168”}	2	0x0d1e753a25ebda689453309112904807625befbe	21571044	2025-08-02T20:01:35.000Z	0x917725940d5679b5162092a3ddc30fab3ce212371ab7ae2f0ebfc867d47df505

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_linea.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
0x119c04c4e60158fa69ecf4cddf629d09719a7572	[“1976675744228”,“1952934119450”]	false	12	23057236	2025-09-08T02:48:06.000Z	[]	[“0x129ee430cb2ff2708ccaddbdb408a88fe4ffd480”,“0xdd7b5e1db4aafd5c8ec3b764efb8ed265aa5445b”]	0x4d4ea2d3e9c4daab5de687d7cd9e709b1ac160cb474746323d63c3104474fd0e
0x119c04c4e60158fa69ecf4cddf629d09719a7572	[“2430144000000”,“2404536000000”]	false	6	23082470	2025-09-08T17:00:36.000Z	[]	[“0x129ee430cb2ff2708ccaddbdb408a88fe4ffd480”,“0xdd7b5e1db4aafd5c8ec3b764efb8ed265aa5445b”]	0x0999e6b281d0c2076cd89597effaaa1d8c2a03812e7f29012c11ec2fc610bed8
0x119c04c4e60158fa69ecf4cddf629d09719a7572	[“1976675744228”,“1952934119450”]	false	17	23082814	2025-09-08T17:12:10.000Z	[]	[“0x129ee430cb2ff2708ccaddbdb408a88fe4ffd480”,“0xdd7b5e1db4aafd5c8ec3b764efb8ed265aa5445b”]	0xd4e4012e0c070a170bebc6cbb505623185a693c3a0c5099bb6bae296d07de38d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_linea.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
22435596505807	0x119c04c4e60158fa69ecf4cddf629d09719a7572	false	2	0x0408804c5dcd9796f22558464e6fe5bddf16a7c7	21480836	2025-07-31T02:28:37.000Z	0xcf1256b3f68aa3dd99cb0bb62405ca298878ef78ca5adc91c8a6c14767660cda
19422360594024	0x119c04c4e60158fa69ecf4cddf629d09719a7572	false	1	0x0408804c5dcd9796f22558464e6fe5bddf16a7c7	21481059	2025-07-31T02:38:24.000Z	0x2f5a996f2b212443c13b12c18ed8db0c8c7a5a22501207b859158cde171b1924
19422360594024	0x119c04c4e60158fa69ecf4cddf629d09719a7572	false	4	0x0408804c5dcd9796f22558464e6fe5bddf16a7c7	21510605	2025-07-31T23:13:32.000Z	0x41f23041ead33841d6371292f683d8328aa8792cab8b1cd369ff47b3bdc5dcf7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_linea.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
0x119c04c4e60158fa69ecf4cddf629d09719a7572	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	152500374267696	1	0x21c3de23d98caddc406e3d31b25e807addf33633	2833290	2024-03-11T21:04:42.000Z	0xe0a54af00878424736e665e7a6cf7cac1a5418b98027593904a3045ee20bd0f5
0x119c04c4e60158fa69ecf4cddf629d09719a7572	0x0408804c5dcd9796f22558464e6fe5bddf16a7c7	false	1818246437662848	2	0xe93685f3bba03016f02bd1828badd6195988d950	2833243	2024-03-11T21:01:34.000Z	0xa154cd3b563fcd04062ddd43ca46f487de78819379756705c82b2eacc411cb1b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_linea.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
0x119c04c4e60158fa69ecf4cddf629d09719a7572	false	15	0x00010000000000000000000000000000000000000000000000000000000000030d40	22270135	14423932107541	2025-08-20T05:31:33.000Z	0xff8700d9d7cb7599003d69a542a244333b5b6f2789864863dabf36e53abecf02	0x0100000000000007b9000000b70000000000000000000000000d1e753a25ebda689453309112904807625befbe000000b80000000000000000000000003055913c90fcc1a6ce9a358911721eeb942013a11da02a11cef0e4f6263f3d978f2504499b1b65c7f26ea46b52d454189a332ad100000000000000000000000000658633973fe4588c0d755bbd5355a10ed0b8a28b000000009502f900
0x119c04c4e60158fa69ecf4cddf629d09719a7572	false	10	0x00010000000000000000000000000000000000000000000000000000000000030d40	22270135	14423932107541	2025-08-20T05:31:33.000Z	0x9804709d80dfd285a5b9a57cc0cae97d21c9db0a740cb8410a57a9cbffb8ebe9	0x0100000000000007b8000000b70000000000000000000000000d1e753a25ebda689453309112904807625befbe000000b80000000000000000000000003055913c90fcc1a6ce9a358911721eeb942013a1ee868e6f2ff13cfa353d095d405b01a92b7fbda109e6581e2496d91c20935bbf000000000000000000000000004e330ece5588346d685a29febddeb8bce39f55b1000000009502f900
0x119c04c4e60158fa69ecf4cddf629d09719a7572	false	5	0x00010000000000000000000000000000000000000000000000000000000000030d40	22270135	14423932107541	2025-08-20T05:31:33.000Z	0x9b5880b4351a3bc2fd6655f8f4c9453d5c8ea583311482e389044cd7948c4e75	0x0100000000000007b7000000b70000000000000000000000000d1e753a25ebda689453309112904807625befbe000000b80000000000000000000000003055913c90fcc1a6ce9a358911721eeb942013a12ee32d013f9ed8738bc967dec250513edd18e3c0ba949c407d9b23e966c1e29500000000000000000000000000615f5f32afeadcfe7962dd1a8f67ad28bb408a81000000009502f900

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_linea.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
0x72a7bc08aae096b68acc51208a1617560fc11add	154587738196667018448	0x808d7c71ad2ba3fa531b068a2417c63106bc0949	false	28	2467780	101	2024-02-23T22:57:18.000Z	0x030b6491fe747981e8e7b974b5a510ef9571f3fe3c76d55144f2a4ec442e8b80
0x84cc144586b42e480e3d847fa35e46f250bc37f0	5600000000000000000	0x808d7c71ad2ba3fa531b068a2417c63106bc0949	false	17	2447452	102	2024-02-23T00:22:06.000Z	0x7f78e65c57f1a1baef45a5ae6dfdf1ae744c4d4df8076196814bf5352d99044f
0xcdf730856154427497e57fa8a9ad6c368346e12c	51425989728574395681	0x808d7c71ad2ba3fa531b068a2417c63106bc0949	false	78	2454699	102	2024-02-23T08:25:14.000Z	0x5d27ab0ce4bff7c66759f758d9a1cfa91727146b221023b8ed37378e7d78b2e1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_linea.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	in_lpFee	log_index	in_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0xaad094f6a75a14417d39f04e690fc216f080a41a	0x8731d54e9d02c286767d56ac03e8037c07e01e98	false	374738100000	1249127000000	2	184	12483775238000000	7270499	13	5870896900000	2024-07-25T21:52:51.000Z	0x41f5c5c5dd7bb3138ac54f00820adc26283e4383f19003bc37825a4fd8f656eb
0xaad094f6a75a14417d39f04e690fc216f080a41a	0x8731d54e9d02c286767d56ac03e8037c07e01e98	false	397078800000	1323596000000	2	184	13228018424000000	7267691	13	6220901200000	2024-07-25T20:19:15.000Z	0x253cefa2a3cff123cbed8f416f766cdc5381083f7b546fae65228e904da1b0aa
0xaad094f6a75a14417d39f04e690fc216f080a41a	0x8731d54e9d02c286767d56ac03e8037c07e01e98	false	522911999999	1743039999999	2	184	17419941760000000	7268535	13	8192288000000	2024-07-25T20:47:23.000Z	0x5a3e98af04d30e0eff745714fb513ec1ac3d2949ec9ced8c36be4efa32fae0f9

Example Query

Query with partition filter

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