lifi_v2_bsc

Tables

LiFiDiamond_LiFiSwappedGeneric_event

Token swap completion events from LiFi’s cross-chain bridge aggregator on BNB Smart Chain, recording source/destination tokens, amounts, integrator platforms, and referrer addresses for analyzing bridge routing patterns and integration partner 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.
`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	323	0x0000000000000000000000000000000000000000	293678042044136946	23988841	0xcc42724c6683b7e57334c4e856f4c9965ed682bd	1000000000000000	lifi-api	0x0000000000000000000000000000000000000000	2022-12-17T18:13:11.000Z	0x65adc06a90cf9a2617554474776dbce962d0f91b13a59c388489d0e5f1c67855	0xabd5b639e34d39f5259995a5830c0fc10a3e2082130631aa550de620cbb36a18
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	124	0x0000000000000000000000000000000000000000	1467539048527606046	23988909	0xcc42724c6683b7e57334c4e856f4c9965ed682bd	5000000000000000	lifi-api	0x0000000000000000000000000000000000000000	2022-12-17T18:16:39.000Z	0x8652b88fa32f11ea5343e7493b1e729d702fc8ec3f132a4796518c0fc20ec7a3	0xdd92d9f9d1d6e709f1e008dcb9dd3e6d0a71ab0c2513ec3557027b083016562b
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	129	0x0000000000000000000000000000000000000000	24042665701098004108	23994897	0xe9e7cea3dedca5984780bafc599bd69add087d56	100000000000000000	rubic	0x0000000000000000000000000000000000000000	2022-12-17T23:18:25.000Z	0x9b30155c8e128ef58195946f1fb5ea1dd5b97e0b062f6d7230b793b9e131faee	0xbfb28e3ceeded8e9f9bc119f680c83e57267d98ec2e0a24460f1067938c0118b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lifi_v2_bsc.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	308	26367681	{“bridge”:“cbridge”,“receiver”:“0xac80e99b94440ea3ed39eb42a9ddbe70385280ee”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“681239536250000000”,“integrator”:“metamask-bridge”,“transactionId”:“0xb363642bbbd4adca8e5b8da8eb886ab8b0de877eae00bf0fece00c1d2c747912”,“hasSourceSwaps”:true,“sendingAssetId”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“destinationChainId”:“1”,“hasDestinationCall”:true}	2023-03-11T08:34:57.000Z	0x5245ff14bbc4e3747bd492dde8017a41d87db85362b83d40b2a58d5847b21434
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	290	26373022	{“bridge”:“cbridge”,“receiver”:“0xd7f655abc84137768d5aba9a5bb36ffc3882584a”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“255440168750000000”,“integrator”:“metamask-bridge”,“transactionId”:“0xc3c9a5c44734fd5da7db98c8da63d109779d5c7dc8843860c32e8fecd2f4e3d8”,“hasSourceSwaps”:true,“sendingAssetId”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“destinationChainId”:“1”,“hasDestinationCall”:true}	2023-03-11T13:03:09.000Z	0xfb9ccef106423202bf4bc53144150ac39c7f54bb22f09099e955c91bd174e7b4
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	123	26385965	{“bridge”:“cbridge”,“receiver”:“0xdb5c4b6c2725f977d9e33d5dcd2d6bd926dc0c21”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“79300000000000000”,“integrator”:“metamask-bridge”,“transactionId”:“0x34963be7f448196178b16ed8a21b2664be2ecaca26743db55c7d456ef967772a”,“hasSourceSwaps”:true,“sendingAssetId”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“destinationChainId”:“1”,“hasDestinationCall”:true}	2023-03-11T23:59:29.000Z	0x0f9f646a8541128c878a8c20a76a3f6cb3542d0933813dff1bcf3a818c0dbff0

Example Query

Query with partition filter

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