Skip to main content

​
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.
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
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse100x000000000000000000000000000000000000000016282569336837400xff970a61a04b1ca14834a43f5de4533ebddb5cc810000000000000000staging.transferto.xyz0x00000000000000000000000000000000000000002022-10-29T18:17:39.000Z0xb63827dca76366e8f11320f89234085f91c2331d58a67c8294f71a964c3599da0x2fb1cb04d15b932dc1265335b565d481f61bd09a8383a2e9dc041d23e7d4e955
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse140x000000000000000000000000000000000000000125103426336002690xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb925110000staging.transferto.xyz0xff970a61a04b1ca14834a43f5de4533ebddb5cc82022-10-29T11:44:19.000Z0x51697bf02db6a60874b39b71fc8663d704e81e20d68c9d66abee964c20aa809a0x38e723b7cfe78a761808add52d49234708300936340279ca3d220ef8d7be94d0
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse240x0000000000000000000000000000000000000000121647684243847593234380x0000000000000000000000000000000000000000198320avault.network0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb92023-02-09T06:27:35.000Z0x3c78e9bdfd36b9d75636a18c4631b481c0669c4286fa1dd7cb16e3864981e9f20x97726fbbc4ce9d742e506628ef30bbafa62c3685cade3726b1e0730e460a4c1c
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.
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
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse1340568988{“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.000Z0xa4e600543aa0791d833807908f2aa7148475c11df4b056553c9cc680ad00b455
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse1940431614{“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.000Z0x580ba21a7d3f01c293388912d192967b794a40f4e65c577234014ade773931f6
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaefalse2640638876{“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.000Z0xaed7a322e7d4d71d002e0b5cba1c37d22af6de74d21b2b273e17e4cb72f0fe7c
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