lifi_v2_arbitrum

Tables

LiFiDiamond_LiFiSwappedGeneric_event

Token swap completion events from LiFi cross-chain bridge aggregator on Arbitrum. Records input/output token addresses, amounts, integrator domains, and referrer addresses for analyzing bridge routing patterns and fee distribution.

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_integrator`	`STRING`	Identifier of the platform or application that integrated with LiFi to facilitate the transaction. String value representing the integrator name or domain.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAssetId`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string, or 0x0000000000000000000000000000000000000000 for native chain currency.
`in_toAssetId`	`STRING`	Contract address of the destination token received from the swap. Hex-encoded, 0x-prefixed, 42-character string, or 0x0000000000000000000000000000000000000000 for native chain currency.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.

Sample Data

address	removed	log_index	in_referrer	in_toAmount	block_number	in_toAssetId	in_fromAmount	in_integrator	in_fromAssetId	block_timestamp	in_transactionId	transaction_hash
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	10	0x0000000000000000000000000000000000000000	16282569	33683740	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	10000000000000000	staging.transferto.xyz	0x0000000000000000000000000000000000000000	2022-10-29T18:17:39.000Z	0xb63827dca76366e8f11320f89234085f91c2331d58a67c8294f71a964c3599da	0x2fb1cb04d15b932dc1265335b565d481f61bd09a8383a2e9dc041d23e7d4e955
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	14	0x0000000000000000000000000000000000000001	25103426	33600269	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	25110000	staging.transferto.xyz	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2022-10-29T11:44:19.000Z	0x51697bf02db6a60874b39b71fc8663d704e81e20d68c9d66abee964c20aa809a	0x38e723b7cfe78a761808add52d49234708300936340279ca3d220ef8d7be94d0
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	24	0x0000000000000000000000000000000000000000	121647684243847	59323438	0x0000000000000000000000000000000000000000	198320	avault.network	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2023-02-09T06:27:35.000Z	0x3c78e9bdfd36b9d75636a18c4631b481c0669c4286fa1dd7cb16e3864981e9f2	0x97726fbbc4ce9d742e506628ef30bbafa62c3685cade3726b1e0730e460a4c1c

Example Query

Query with partition filter

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

LiFiDiamond_LiFiTransferStarted_event

LiFi cross-chain transfer initiation events emitted when users start bridge transactions through the LiFi Diamond protocol. Contains bridge routing parameters including source and destination assets, amounts, receiver addresses, chain identifiers, and integration metadata for tracking cross-chain asset transfers.

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_bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Bridge transaction metadata containing identifiers and routing information for cross-chain transfers. Includes transaction ID, bridge protocol name, integrator, referrer address, sending asset ID, receiver address, minimum transfer amount, destination chain ID, and flags indicating whether source swaps or destination calls are included.

Sample Data

address	removed	log_index	block_number	in_bridgeData	block_timestamp	transaction_hash
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	13	40568988	{“bridge”:“hop”,“receiver”:“0x94843434993f2efc1a8fdc47f713c0f97f138e03”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“5000000”,“integrator”:“transferto.xyz”,“transactionId”:“0x630d58cba9923423f21c681f50b9b61803b33ed8c437666660517af9767d4801”,“hasSourceSwaps”:true,“sendingAssetId”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2022-11-23T14:25:16.000Z	0xa4e600543aa0791d833807908f2aa7148475c11df4b056553c9cc680ad00b455
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	19	40431614	{“bridge”:“hop”,“receiver”:“0xdc2f2b4601126add8e22fbe2bb8cb0b4bac6d27c”,“referrer”:“0x0000000000000000000000000000000000000028”,“minAmount”:“50914012”,“integrator”:“transferto.xyz”,“transactionId”:“0xc228243ca1cd953ca7d1978c0238cbceae494667afbc201fb92f494564f9606d”,“hasSourceSwaps”:true,“sendingAssetId”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“destinationChainId”:“1”,“hasDestinationCall”:true}	2022-11-23T03:37:20.000Z	0x580ba21a7d3f01c293388912d192967b794a40f4e65c577234014ade773931f6
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	26	40638876	{“bridge”:“hop”,“receiver”:“0x71e78c7197eee4ab2a5c940477383b89bfb7c5bd”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“60000000”,“integrator”:“transferto.xyz”,“transactionId”:“0x2ba4742f283cc79895b15327c8fd7f72d1d78a97e1c42d484cc5653ffee2dbd3”,“hasSourceSwaps”:true,“sendingAssetId”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2022-11-23T19:54:57.000Z	0xaed7a322e7d4d71d002e0b5cba1c37d22af6de74d21b2b273e17e4cb72f0fe7c

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LiFiDiamond_LiFiSwappedGeneric_event

LiFiDiamond_LiFiTransferStarted_event

​Tables

​LiFiDiamond_LiFiSwappedGeneric_event

​LiFiDiamond_LiFiTransferStarted_event

Tables

LiFiDiamond_LiFiSwappedGeneric_event

LiFiDiamond_LiFiTransferStarted_event