layerzero_v1_bsc

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`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	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	block_number	from_address	trace_address	block_timestamp	transaction_hash
187201	190499999999999	false	147269	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	32845470	0x128aedc7f41ffb82131215e1722d8366faad0cd4	0	2023-10-23T04:56:11.000Z	0x962f674ee3a92022b5210779b09c2b849b37ae728e83b1c493d5de53a82f853b
187189	210500000000001	false	147269	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	32845663	0x128aedc7f41ffb82131215e1722d8366faad0cd4	0	2023-10-23T05:05:50.000Z	0x43441495c8c0a6bfce5f6e9b18f23d69a849e04d2a142c3ecab054ac22582441
229954	216200313156514	false	147209	0xc5803100	0x3c2269811836af69497e5f486a85d7316753cf62	32853837	0xe9f183fc656656f1f17af1f2b0df79b8ff9ad8ed	0,3	2023-10-23T11:56:07.000Z	0xcb4aef8de9aac461acb985a023474520628a0d33b44270320004fcff1ea932b6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_bsc.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
0x2297aebd383787a160dd0d9f71508148769342e3	0x790a6c3c8f66bf7b10ef183eb587842c12b3af7c	false	200000	50	39740402	0x000000000000000000000000790a6c3c8f66bf7b10ef183eb587842c12b3af7c	101	2024-06-19T05:31:26.000Z	0x21508006e78e52e28a7426165ceb5ea621c42f3b913c7830a49b91ea75b0265a
0x25d887ce7a35172c62febfd67a1856f20faebb00	0x6fd30d118d20d94455bf7b6bcd0337fdcd17d43d	false	4229338743099100000000000000	99	39756396	0x0000000000000000000000006fd30d118d20d94455bf7b6bcd0337fdcd17d43d	101	2024-06-19T18:53:41.000Z	0x483782fe8f62c6831236548b9e05997ace247ee1df5ecff9151beb1a8cd43547
0x52242cbab41e290e9e17ccc50cc437bb60020a9d	0xddf298522c58aeecffd15624217b63bc79cc6708	false	141594400000000000000000	61	39738223	0x000000000000000000000000ddf298522c58aeecffd15624217b63bc79cc6708	101	2024-06-19T03:42:09.000Z	0xc21708d94adec911c4bf8c59ce2e81d7f8c323d62a6d47c06d3f780508b02b44

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_bsc.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
0xff3da3a1cd39bbaeb8d7cb2deb83efc065cbb38f	false	{“nonce”:“424”,“sender”:“0x00000000000000000000000058ff71c056942600bc4acf8bdf48f82e6ad1f392”,“srcEid”:“101”}	328	0x11cd72f7a4b699c67f225ca8abb20bc9f8db90c7	50018053	2025-05-20T19:48:00.000Z	0xfc4bbb4571ca709ad01e54f73f82110dcb51fe87b25d3e874d4f79d67186c5ff
0xff3da3a1cd39bbaeb8d7cb2deb83efc065cbb38f	false	{“nonce”:“1372”,“sender”:“0x00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7”,“srcEid”:“106”}	881	0x11cd72f7a4b699c67f225ca8abb20bc9f8db90c7	49989036	2025-05-20T07:42:20.000Z	0xcbab33dc54525667f3c8bd3ca6eb103f6abb2b832229456d62495e6617898ff2
0xff3da3a1cd39bbaeb8d7cb2deb83efc065cbb38f	false	{“nonce”:“1374”,“sender”:“0x00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d7”,“srcEid”:“106”}	562	0x11cd72f7a4b699c67f225ca8abb20bc9f8db90c7	50018008	2025-05-20T19:46:52.000Z	0x030554e7d5d8f30c5a85e6e9c99fbab585e3896359dca03f857fc667df568140

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_bsc.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
0xfcce712c9be5a78fe5f842008e0ed7af59455278	[“951151046391”,“951151046391”]	false	489	50018069	2025-05-20T19:48:24.000Z	[]	[“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”,“0xfd6865c841c2d64565562fcc7e05e619a30615f0”]	0xcd0cb4380916dbb84774a041de07c5397cf0983ac5bb141df6d17a61ea7cd12a
0xfcce712c9be5a78fe5f842008e0ed7af59455278	[“181714751730”,“181714751730”]	false	34	49989064	2025-05-20T07:43:02.000Z	[]	[“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”,“0xfd6865c841c2d64565562fcc7e05e619a30615f0”]	0x670898d3f9e148caab1f11ecddd85e75118d1643bc654393f9fd9d9fbc8ea48d
0xfcce712c9be5a78fe5f842008e0ed7af59455278	[“2589239960763”,“26516942400409”]	false	650	50015120	2025-05-20T18:34:40.000Z	[]	[“0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc”,“0xfd6865c841c2d64565562fcc7e05e619a30615f0”]	0xe06c320c35ea015cc22cf4f6dcc53011d93191e9916eac6b23a74ddd8bc916c2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_bsc.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
992439329262382	0xfcce712c9be5a78fe5f842008e0ed7af59455278	false	1631	0x3ebd570ed38b1b3b4bc886999fcf507e9d584859	52278726	2025-06-29T02:00:08.000Z	0x20541b2a84fad755dc0238449b871cfeac6a4703cd8717b51d09c8145275f335
83304931033109	0xfcce712c9be5a78fe5f842008e0ed7af59455278	false	934	0x3ebd570ed38b1b3b4bc886999fcf507e9d584859	52291884	2025-06-29T07:32:41.000Z	0xbc665b06b490f1e75087bc958f3a480f78fef3b3937d3374c934669a14929c38
87050819727319	0xfcce712c9be5a78fe5f842008e0ed7af59455278	false	591	0x3ebd570ed38b1b3b4bc886999fcf507e9d584859	52292983	2025-06-29T08:00:10.000Z	0xd40b284929030aa0060b715e0e6bee06420d89b2a6c83cedb4ef4ba1523ac8bc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_bsc.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
0xfcce712c9be5a78fe5f842008e0ed7af59455278	0x3ebd570ed38b1b3b4bc886999fcf507e9d584859	false	33408998120450770	21	0xe93685f3bba03016f02bd1828badd6195988d950	36885832	2024-03-11T21:01:35.000Z	0x71d0f2dfb1eba21e6382a6734469dec3989987d7bbc6d8657b6de8c2bbb792ec
0xfcce712c9be5a78fe5f842008e0ed7af59455278	0xd56e4eab23cb81f43168f9f45211eb027b9ac7cc	false	306921600000000	17	0x21c3de23d98caddc406e3d31b25e807addf33633	36885895	2024-03-11T21:04:44.000Z	0x59d06f5280a224eb8e1fda41f5b790a2fa2e277495f137da7ed1be8c38e02d6f
0xfcce712c9be5a78fe5f842008e0ed7af59455278	0x3ebd570ed38b1b3b4bc886999fcf507e9d584859	false	1089484928535271	36	0xe93685f3bba03016f02bd1828badd6195988d950	39701134	2024-06-17T20:41:24.000Z	0x63ac9b53ec18d08d0f6a0ba34c8f15477009dab6594b472ecedfd8c7d95837bc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_bsc.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
0xfcce712c9be5a78fe5f842008e0ed7af59455278	false	1089	0x00010000000000000000000000000000000000000000000000000000000000030d40	50050183	576924159699969	2025-05-21T09:11:47.000Z	0x92a2c6a6b301301d31396856a6136a8dc7a3d244f7028487fd26b225da76982d	0x0100000000000001490000006600000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c70000006d00000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c737b9cc6a627303d9e83355c605b703ab7a482653f9bc6dc42e0abc3b136ce7ed0000000000000000000000000091f82d236f6b88e830864032301b0ba6145a50fc000000412b711546
0xfcce712c9be5a78fe5f842008e0ed7af59455278	false	321	0x00010000000000000000000000000000000000000000000000000000000000030d40	50063056	571484590245322	2025-05-21T14:33:40.000Z	0x0c16773acae1199872c97d7913e112e47990745bf2b3ecdfb43f31f692f6b9cb	0x0100000000000003eb0000006600000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c70000006a00000000000000000000000096e1056a8814de39c8c3cd0176042d6cecd807d720a93a219dd24086bf682936c9ff1a162c8cc0719c2e839f5ee7f18a45e0620d00000000000000000000000000350254da53d5c6ab6a27a446582fa60fe120930c000016bebbddde08
0xfcce712c9be5a78fe5f842008e0ed7af59455278	false	362	0x00010000000000000000000000000000000000000000000000000000000000030d40	50079607	570357552062948	2025-05-21T21:27:32.000Z	0x891f3335f5e2a138a8479b7f87a834f7d36a3e33dca95b9921fab2eedeaeb839	0x0100000000000000e10000006600000000000000000000000011cd72f7a4b699c67f225ca8abb20bc9f8db90c70000006f000000000000000000000000bfd5206962267c7b4b4a8b3d76ac2e1b2a5c4d5e660616c89480ecc7541ee69273324ce2d019fb00e1dd138804deec646d5598c200000000000000000000000000feb623adaf1821de8a0689d544c672269d736743000000af954034f3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_bsc.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
0x46f997877dbd03c2b37fa6a9d34a384e19690640	4770000000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	false	114	43951910	106	2024-11-12T18:34:24.000Z	0x4e6c3ce5b3fc8b7a948db704e005729c913008d17553c84405011346bcc22793
0x46f997877dbd03c2b37fa6a9d34a384e19690640	5000000000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	false	77	43951850	106	2024-11-12T18:31:24.000Z	0x97b1973f88f014c41c8b320bce8de545304bb316b910766e1b2a02f208457589
0x46f997877dbd03c2b37fa6a9d34a384e19690640	4790000000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	false	185	43952014	106	2024-11-12T18:39:36.000Z	0x673d8d6f94058da29065738a3ed8db73f7fcb46c2b61a6df4f383d1f06695b78

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.layerzero_v1_bsc.StargateV1_SendToChain_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StargateV1_Swap_event

Cross-chain token swap events from Stargate V1 protocol via LayerZero messaging. Contains swap amounts, source/destination chain identifiers, pool IDs, fee breakdowns (equilibrium, liquidity provider, protocol), and rewards for analyzing cross-chain liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_dstPoolId`	`STRING`	Identifier for the destination Stargate liquidity pool in a cross-chain swap operation. Numeric string representing the pool ID on the target chain.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSD`	`STRING`	Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.
`in_eqReward`	`STRING`	Reward amount credited for equilibrium rebalancing in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_eqFee`	`STRING`	Fee charged for equilibrium adjustment in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_protocolFee`	`STRING`	Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.
`in_lpFee`	`STRING`	Fee collected by liquidity providers from the swap transaction. Numeric string representation without decimals.

Sample Data

address	in_from	removed	in_eqFee	log_index	in_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0x9aa83081aa06af7208dcc7a4cb72c94d057d2cda	0x19b84c79fa69c3ccd8159fb1265cf0fe8d23f513	false	89144	0	109	2968502693	27628915	1	2882329	2023-04-24T13:13:44.000Z	0x4cc2e882f372527b5efea9a86e348411ce7f2560b27e27db207478586f424a73
0x9aa83081aa06af7208dcc7a4cb72c94d057d2cda	0xa6a25dac84fa92fd3425acc8b934917940ff77c7	false	2445	1	112	81431998	27636170	1	79068	2023-04-24T19:17:09.000Z	0xe78fc13fb11f9ada9d555023e394d21d868ac94fc49ce53b986f412ee1e45895
0x9aa83081aa06af7208dcc7a4cb72c94d057d2cda	0x2967e7bb9daa5711ac332caf874bd47ef99b3820	false	3	4	109	99900	27635195	1	97	2023-04-24T18:28:14.000Z	0x918b76182710b5c11f77e64e1f0c142467d2fab4ef887507fc29e6338a8d0b4b

Example Query

Query with partition filter

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