layerzero_v1_gnosis

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
401529	42694466536440165	true	88730	0xc5803100	0x9740ff91f1985d8d2b71494ae1a2f723bb3ed9e4	0x	40004718	0x0000c74e9931c7d6c1a6e811fe96a8a808e06969	1	111	2025-05-11T07:58:00.000Z	0x0000c74e9931c7d6c1a6e811fe96a8a808e069690000c74e9931c7d6c1a6e811fe96a8a808e06969	0x54e8e0e6e3232f0ce6d5275ae2b4f2475a2c2f546f3bc96e9df5bb11d75dbd46	0x00020000000000000000000000000000000000000000000000000000000000004e20000000000000000000000000000000000000000000000000000003aca2c3d000c4fa9997f8ab4704916cdd1432a62e6c427f1ac0	0x0000c74e9931c7d6c1a6e811fe96a8a808e06969	0x0000000000000000000000000000000000000000
263932	47816093366806802	true	72580	0xc5803100	0x9740ff91f1985d8d2b71494ae1a2f723bb3ed9e4	0x	40004480	0x0000c74e9931c7d6c1a6e811fe96a8a808e06969	3	125	2025-05-11T07:36:55.000Z	0x0000c74e9931c7d6c1a6e811fe96a8a808e069690000c74e9931c7d6c1a6e811fe96a8a808e06969	0x372a56b9f75a4903108ec7bcc9c118ef93411a684b03ec84ac0488596a86f7c3	0x00020000000000000000000000000000000000000000000000000000000000004e2000000000000000000000000000000000000000000000000000038d7ea4c68000c4fa9997f8ab4704916cdd1432a62e6c427f1ac0	0x0000c74e9931c7d6c1a6e811fe96a8a808e06969	0x0000000000000000000000000000000000000000
422115	40239880516461681	true	83062	0xc5803100	0x9740ff91f1985d8d2b71494ae1a2f723bb3ed9e4	0x	40004480	0x0000c74e9931c7d6c1a6e811fe96a8a808e06969	1	138	2025-05-11T07:36:55.000Z	0x0000c74e9931c7d6c1a6e811fe96a8a808e069690000c74e9931c7d6c1a6e811fe96a8a808e06969	0x372a56b9f75a4903108ec7bcc9c118ef93411a684b03ec84ac0488596a86f7c3	0x00020000000000000000000000000000000000000000000000000000000000004e20000000000000000000000000000000000000000000000000002386f26fc10000c4fa9997f8ab4704916cdd1432a62e6c427f1ac0	0x0000c74e9931c7d6c1a6e811fe96a8a808e06969	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_gnosis.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
0x990d37ddc64ddeb495895480c6ac0efac2bb37a9	0x6c50e008bb5414ac3aaf28309297beb578358a63	false	88000000000000000000	5	27404080	0x0000000000000000000000006c50e008bb5414ac3aaf28309297beb578358a63	110	2023-04-12T03:21:10.000Z	0xbe2611a9d33b4eb62b984d3370526faa935760df8cee8771f595fa4411107b89
0x990d37ddc64ddeb495895480c6ac0efac2bb37a9	0x6c50e008bb5414ac3aaf28309297beb578358a63	false	88000000000000000000	5	27404159	0x0000000000000000000000006c50e008bb5414ac3aaf28309297beb578358a63	111	2023-04-12T03:27:50.000Z	0xc8a76aaf41389cf059959d28113bf6fda3953057e98a6c99d00370e79a1ce190
0x990d37ddc64ddeb495895480c6ac0efac2bb37a9	0x6c50e008bb5414ac3aaf28309297beb578358a63	false	88000000000000000000	7	27404138	0x0000000000000000000000006c50e008bb5414ac3aaf28309297beb578358a63	111	2023-04-12T03:26:05.000Z	0xd4f9e5f8f1bef85aeb8e96bd6402e910c30cc6506676db4cd1d0c04427acea1d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_gnosis.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
0xadded4478b423d991c21e525cd3638fbce1aad17	false	{“nonce”:“1”,“sender”:“0x000000000000000000000000d9278b1632b4f2f5b63f9f13a812ea1c83b1f1df”,“srcEid”:“145”}	13	0xd9278b1632b4f2f5b63f9f13a812ea1c83b1f1df	32308123	2024-02-05T23:27:20.000Z	0xb62aff2387fbc5a4cc354229261c9bc80a4787ff0ac59d0589c28ac910ad38b3
0xadded4478b423d991c21e525cd3638fbce1aad17	false	{“nonce”:“1”,“sender”:“0x00000000000000000000000040d0dc337fecdc4c09774e7f92cb963674cf7ef2”,“srcEid”:“145”}	3002	0x40d0dc337fecdc4c09774e7f92cb963674cf7ef2	32308563	2024-02-06T00:06:50.000Z	0xbb0dac5ae0cd19d1cbdd499a453d53ba69b3b921070b3fb7fc4785261b4bd63a
0xadded4478b423d991c21e525cd3638fbce1aad17	false	{“nonce”:“1”,“sender”:“0x000000000000000000000000da9264c68295b06a05feff112333e1faa6b40535”,“srcEid”:“102”}	3003	0xda9264c68295b06a05feff112333e1faa6b40535	32317398	2024-02-06T13:09:40.000Z	0xcc0fa0909e40aca94929ff8b57ee806cd5ce9fa17aab955dc08478d5603f7535

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_gnosis.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
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	[“635272168704969”,“635272168704969”]	false	15	32308551	2024-02-06T00:05:40.000Z	[]	[“0x11bb2991882a86dc3e38858d922559a385d506ba”,“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”]	0xb62efe81279ee43873f4a1069ddd00705a8591925cd7d7c3f3cb468fced1be4c
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	[“507135355029984”]	false	316	32308111	2024-02-05T23:26:20.000Z	[]	[“0x11bb2991882a86dc3e38858d922559a385d506ba”]	0xdca63252affd2c603ebbf6930c79b3f8610f5ffc24bc50d3d9fedba87b959039

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_gnosis.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
47925897980166037	0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	315	0x38340337f9adf5d76029ab3a667d34e5a032f7ba	32308111	2024-02-05T23:26:20.000Z	0xdca63252affd2c603ebbf6930c79b3f8610f5ffc24bc50d3d9fedba87b959039
48658693784810877	0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	14	0x38340337f9adf5d76029ab3a667d34e5a032f7ba	32308551	2024-02-06T00:05:40.000Z	0xb62efe81279ee43873f4a1069ddd00705a8591925cd7d7c3f3cb468fced1be4c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_gnosis.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
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	635272168704969	2001	0x21c3de23d98caddc406e3d31b25e807addf33633	32882429	2024-03-11T21:04:45.000Z	0x26030564518236d56bb2e4170d2e73d22edae6a05a46e7e0b9a62b73c5a3099d
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	0x38340337f9adf5d76029ab3a667d34e5a032f7ba	false	96584591764976914	2309	0xe93685f3bba03016f02bd1828badd6195988d950	32882394	2024-03-11T21:01:40.000Z	0x85b168a2b2a67d2a359d2e343dce51cd6a3c5cdd0506e7e108f1110e4bd01e21

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_gnosis.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	in_lzTokenFee	block_timestamp	transaction_hash	in_encodedPayload
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	16	0x0003010011010000000000000000000000000007a120	32308551	49929238122220815	0	2024-02-06T00:05:40.000Z	0xb62efe81279ee43873f4a1069ddd00705a8591925cd7d7c3f3cb468fced1be4c	0x0100000000000000010000009100000000000000000000000040d0dc337fecdc4c09774e7f92cb963674cf7ef20000009100000000000000000000000040d0dc337fecdc4c09774e7f92cb963674cf7ef2534563993ef7992858f64d3ec36dd98c22673c38fdae3a0f4f309c579ed6fce70100000000
0x42b4e9c6495b4cfdae024b1ec32e09f28027620e	false	317	0x0003010011010000000000000000000000000007a120	32308111	48433033335196021	0	2024-02-05T23:26:20.000Z	0xdca63252affd2c603ebbf6930c79b3f8610f5ffc24bc50d3d9fedba87b959039	0x01000000000000000100000091000000000000000000000000d9278b1632b4f2f5b63f9f13a812ea1c83b1f1df00000091000000000000000000000000d9278b1632b4f2f5b63f9f13a812ea1c83b1f1dfe9251005503de1282b22edd769e8147e37aeb9ffda1290053b8edef4d598d47c0100000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_gnosis.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
0x40efeb425672547d5f3e4bfaf6362fdef888390d	1200000000000000	0xe876836edc2f24c37dd80d81971887a4d6410407	false	28	28927670	125	2023-07-13T10:48:45.000Z	0x0f85aa0f88329b081da7b0c00caae7360f8295c4abc8f286c8f11800eefc8667
0x5464912b966384bf6fb4222a6eca6013d99d6341	10000000000000000	0xe876836edc2f24c37dd80d81971887a4d6410407	false	12	28925696	125	2023-07-13T07:55:55.000Z	0xd2cd8a382e3699de6cdee88a903268edcacee1b20f80fc11094cf0d46cfc66a0
0x5464912b966384bf6fb4222a6eca6013d99d6341	10000000000000000000	0xe876836edc2f24c37dd80d81971887a4d6410407	false	10	28924805	125	2023-07-13T06:36:55.000Z	0xbc03b8fa18c3fa73b9f2d61f343d6c16fc3d9141d0eed595780d9cdc533cd0e7

Example Query

Query with partition filter

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