Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_transactionIdSTRINGUnique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
in_integratorSTRINGIdentifier of the platform or application that integrated with LiFi to facilitate the transaction. String value representing the integrator name or domain.
in_referrerSTRINGAddress that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_fromAssetIdSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string, or 0x0000000000000000000000000000000000000000 for native chain currency.
in_toAssetIdSTRINGContract address of the destination token received from the swap. Hex-encoded, 0x-prefixed, 42-character string, or 0x0000000000000000000000000000000000000000 for native chain currency.
in_fromAmountSTRINGAmount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
in_toAmountSTRINGAmount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
addressremovedlog_indexin_referrerin_toAmountblock_numberin_toAssetIdin_fromAmountin_integratorin_fromAssetIdblock_timestampin_transactionIdtransaction_hash
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse3230x0000000000000000000000000000000000000000293678042044136946239888410xcc42724c6683b7e57334c4e856f4c9965ed682bd1000000000000000lifi-api0x00000000000000000000000000000000000000002022-12-17T18:13:11.000Z0x65adc06a90cf9a2617554474776dbce962d0f91b13a59c388489d0e5f1c678550xabd5b639e34d39f5259995a5830c0fc10a3e2082130631aa550de620cbb36a18
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse1240x00000000000000000000000000000000000000001467539048527606046239889090xcc42724c6683b7e57334c4e856f4c9965ed682bd5000000000000000lifi-api0x00000000000000000000000000000000000000002022-12-17T18:16:39.000Z0x8652b88fa32f11ea5343e7493b1e729d702fc8ec3f132a4796518c0fc20ec7a30xdd92d9f9d1d6e709f1e008dcb9dd3e6d0a71ab0c2513ec3557027b083016562b
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse1290x000000000000000000000000000000000000000024042665701098004108239948970xe9e7cea3dedca5984780bafc599bd69add087d56100000000000000000rubic0x00000000000000000000000000000000000000002022-12-17T23:18:25.000Z0x9b30155c8e128ef58195946f1fb5ea1dd5b97e0b062f6d7230b793b9e131faee0xbfb28e3ceeded8e9f9bc119f680c83e57267d98ec2e0a24460f1067938c0118b
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_bridgeDataSTRUCT<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.
addressremovedlog_indexblock_numberin_bridgeDatablock_timestamptransaction_hash
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse30826367681{“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.000Z0x5245ff14bbc4e3747bd492dde8017a41d87db85362b83d40b2a58d5847b21434
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse29026373022{“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.000Z0xfb9ccef106423202bf4bc53144150ac39c7f54bb22f09099e955c91bd174e7b4
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse12326385965{“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.000Z0x0f9f646a8541128c878a8c20a76a3f6cb3542d0933813dff1bcf3a818c0dbff0
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