lifi_v2_ethereum

Tables

GenericSwapFacet_LiFiSwappedGeneric_event

Token swap completion events from LiFi’s cross-chain bridge aggregator on Ethereum. Tracks input/output token addresses, amounts, integrator applications, and referrers for analyzing bridge routing patterns and platform usage.

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	86	0x0000000000000000000000000000000000000000	17900159696745	16036497	0x30b679aae922213c01106a550ca818fe5650af55	42880000000000000	AccelDefi	0x0000000000000000000000000000000000000000	2022-11-24T01:16:47.000Z	0xb413153c0e284b4149ce1f768653363ecd1eb3138dd38dce8cb3abe2fc4c7ecd	0x0f4ff9677817480e2b2650e855a8ea49e18715b52c8fd5af193ededa685c717a
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	180	0x0000000000000000000000000000000000000000	1384514016383	16038243	0x8ee325ae3e54e83956ef2d5952d3c8bc1fa6ec27	203310000000000000	AccelDefi	0x0000000000000000000000000000000000000000	2022-11-24T07:07:23.000Z	0x8799adce183e6155729a5ddef2ba7f5f735eac294b5696281b22f7afc8179c73	0xf3d25b82cadd9f42e3b9517c85838da05cabca0047a9505f1025b99625c0567a
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	235	0x0000000000000000000000000000000000000000	1082621548186045431	16041485	0x0000000000000000000000000000000000000000	1300000000	transferto.xyz	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2022-11-24T17:59:11.000Z	0xc24b166cd5c0c81ebf3eb78bd955699e33fe42fe4a08657dce2939629b4093a5	0x01378775032ae7adc34254c1c018c8f1da6ab3ca79577022ca32afce91a6d355

Example Query

Query with partition filter

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

GenericSwapFacet_LiFiTransferStarted_event

Cross-chain bridge transaction events from LiFi protocol on Ethereum, capturing swap and transfer initiation details including bridge provider (Hop, cBridge, Across, Multichain), source/destination chains, token amounts, and integrator information (MetaMask Bridge, Jumper Exchange). Used for analyzing cross-chain transfer patterns and bridge protocol usage.

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	195	16743458	{“bridge”:“hop”,“receiver”:“0x31c2521d9ba567f0d27e7e9209733c13cc3a8ceb”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“6046625000000000”,“integrator”:“metamask-bridge”,“transactionId”:“0x5c8891d1c39013047c94b071c3276447d93ae8e11fede57ac9c92c3f1440e2fd”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-03-02T21:12:23.000Z	0x611eb56b50501de6e8282879016f9d10193d4bf9876a94cec484c061305ba564
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	401	16743976	{“bridge”:“cbridge”,“receiver”:“0x044500949fe2a5b4ee983b47b5040c6016ef4b68”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“27755000000000000”,“integrator”:“metamask-bridge”,“transactionId”:“0xf34a2cae08c0749a3fb89760e4f6e87648db1dffdb20a17ca4f99b37a2020e86”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-03-02T22:56:59.000Z	0xaacd22adfd8351081206acb92c7521659453d6c2feb94981acf983a759f0fcc4
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	316	16738844	{“bridge”:“hop”,“receiver”:“0x1b965034eb2256079d7dc8e5b0bba5ed030fffd1”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“6938750000000000”,“integrator”:“metamask-bridge”,“transactionId”:“0x4a148b831725c438c801afe9a6f7a3d53439e1551efc9547a07080bd0430ba92”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-03-02T05:35:47.000Z	0x0b580f7d60b2bc1a4297cd3a73ba5a631c8df3475623fa926a45f7e5affb0358

Example Query

Query with partition filter

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

HyphenFacet_LiFiTransferStarted_event

Cross-chain bridge transfer initiation events from LiFi’s HyphenFacet integration on Ethereum, capturing bridge route selection, destination chain details, and optional swap parameters. Tracks transfers across bridges including Optimism, Multichain, Stargate, and Cbridge with integrator attribution for analyzing cross-chain routing patterns.

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	123	16624968	{“bridge”:“optimism”,“receiver”:“0xd2abd7a3333395a1ed7e54c67edf43ef934033a1”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“1000000000000000”,“integrator”:“obvious.technology”,“transactionId”:“0x272f29378547860650d825bb39450d0b8b6832b2cd0128babb4f8a89c88438d1”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-02-14T05:40:35.000Z	0x1e945452c8d074ecfe89c25213e5d269106da4bc908cd81f5ab8ae4245c3d022
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	4	16624214	{“bridge”:“multichain”,“receiver”:“0xe456ff3e321be2675a5aeb56b3623586254c3419”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“138000000000000000”,“integrator”:“transferto.xyz”,“transactionId”:“0x4aac540ec001c3ff354f9d77c06187a0e1a72533179ad03293b3b8763f060ec6”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0615dbba33fe61a31c7ed131bda6655ed76748b1”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-02-14T03:08:47.000Z	0x1c46552570504daf2bfcd3c68a852684f3cb9f55a12fcae73decae37b53f9bc6
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	5	16624859	{“bridge”:“multichain”,“receiver”:“0xc06323174d132363a3a1c36c8da7c7cb7cebb392”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“19900000000000000”,“integrator”:“outlet.finance”,“transactionId”:“0xfc41d292ab88f198cabbc723a3d4be83b5000ae7a5e668e9c16ef85345faa8ca”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0615dbba33fe61a31c7ed131bda6655ed76748b1”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-02-14T05:18:47.000Z	0x7c7070e00776999b709e60f914474cce258f1a4c9395b3758493ab5ec52370b8

Example Query

Query with partition filter

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

LiFiDiamond_LiFiSwappedGeneric_event

Token swap execution events from LiFi cross-chain bridge aggregator on Ethereum. Records input/output token addresses, amounts, integrator identifiers, and referrer data for tracking DEX aggregation and bridge routing 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	67	0x0000000000000000000000000000000000000000	658144757874000993	16601759	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	730000000000000000	transferto.xyz	0x0000000000000000000000000000000000000000	2023-02-10T23:51:59.000Z	0x726e4d8688b2b5f4f25a23a0050f985aa18303900650cd2b256f994e4ff1c8cf	0xb01c61368cccb16824a3aa61d371b4c7a12fee92880c2d42409ca96a12083f1c
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	44	0x0000000000000000000000000000000000000000	617323421	16595787	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	400000000000000000	onboardto.xyz	0x0000000000000000000000000000000000000000	2023-02-10T03:51:47.000Z	0x213113e266e4715fd4de4ed7e67756abe465554bf20314617a943a6a3c3131cd	0xbc342a482247e8df736b614486230c7c833ecf9e16f0a3f0938c570e532987da
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	327	0x0000000000000000000000000000000000000000	425517045832348658410	16596331	0x4d224452801aced8b2f0aebe155379bb5d594381	1393000000000000000	omni.app	0x0000000000000000000000000000000000000000	2023-02-10T05:41:11.000Z	0xe12776c6cdf1d51b9dbe87c3e8a28527af65af89e00cf5261db2ba8cfc6eeb9f	0xc102bded0b6a01a1edb7729ae6a15aea0f49147d3c4784a74cda217fcb71cf7e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lifi_v2_ethereum.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	325	16182280	{“bridge”:“optimism”,“receiver”:“0x19396de329f9bf5553457956136273c153b62ae4”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“10000000000000000”,“integrator”:“lifi-api”,“transactionId”:“0x12c38a7a6ffb763ecf0eddc7ad264439684de797bf96456cd9fc7b0314624c2a”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2022-12-14T10:17:11.000Z	0x0511233aeb32fbed46f26cc7d0a87243c332a4689cbb8cd5895722ff97ae758b
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	40	16179671	{“bridge”:“multichain”,“receiver”:“0x214fcbf2848d481d2a2236eca2438cfd05fba996”,“referrer”:“0x0000000000000000000000000000000000000001”,“minAmount”:“575000000000000000”,“integrator”:“transferto.xyz”,“transactionId”:“0x2c94e02778891b3fd2e9d11dee458584e657b4c9da366b7960598a546914724c”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0615dbba33fe61a31c7ed131bda6655ed76748b1”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2022-12-14T01:32:11.000Z	0x091802f4d0c2752c63456299c92ad40d353b7e8833e4d76f4d18bba4be034042
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	220	16183967	{“bridge”:“multichain”,“receiver”:“0x429409dc8e01150f1e65e9be2458da913c1bbc47”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“55000000000000000”,“integrator”:“transferto.xyz”,“transactionId”:“0x4376d142915a209e9339333ba24a43831c13ad54df71a3de181bf817fa06ff4d”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0615dbba33fe61a31c7ed131bda6655ed76748b1”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2022-12-14T15:56:11.000Z	0x65d5fa3ee3fefaecf914fe8d29f24be6921198007ee2ed3e150361561af510ae

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaAcross_function

Cross-chain bridge transactions from LiFi protocol on Ethereum using Across bridge, including optional token swaps before bridging. Records bridge parameters, swap details, relayer fees, and destination chain information for analyzing multi-chain transfer patterns and 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.
`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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__acrossData`	`STRUCT<relayerFeePct STRING, quoteTimestamp STRING>`	Structured data object containing Across Protocol-specific bridging parameters including relayer fee percentage and quote timestamp. Fields define the economic terms and timing for cross-chain token transfers via Across.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__acrossData	in__bridgeData	block_timestamp	transaction_hash
205248	22500000000000000	true	123607	0x4eefe3a5	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16086174	0xb3d861d41462176ad2afd5c745957b6bc10804c6	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xe0cbc5f200000000000000000000000000000000000000000000000000001164e2d4d20000000000000000000000000000000000000000000000000000000311cdad1600000000000000000000000000cac60e91f8bf841dd2c9a28e894fc6676a2af892”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“22500000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“relayerFeePct”:“501131938702747”,“quoteTimestamp”:“1669851767”}	{“bridge”:“across”,“receiver”:“0xb3d861d41462176ad2afd5c745957b6bc10804c6”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“22477500000000000”,“integrator”:“VaporDEX”,“transactionId”:“0x4057f9e43c2b43609179865fba364258a4078b0cfc4160bbcc790497c9c628de”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2022-11-30T23:48:11.000Z	0x3d2f000d0308db111e82e9b231073fa8d7def42050d739a61e1fcf5f84d45fd3
205284	17069999999999998	true	123607	0x4eefe3a5	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16085228	0xbba3cfbb3f2229fd1d37dbff91ea6686185c8ffc	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xe0cbc5f20000000000000000000000000000000000000000000000000000069920cbf3800000000000000000000000000000000000000000000000000000012a14d8b27f00000000000000000000000091ea0c7de959282848ac68d0cda5dffd7d75763b”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“17069999999999998”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“relayerFeePct”:“7127272844583979”,“quoteTimestamp”:“1669840295”}	{“bridge”:“across”,“receiver”:“0xbba3cfbb3f2229fd1d37dbff91ea6686185c8ffc”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“17061464999999999”,“integrator”:“AccelDefi”,“transactionId”:“0x7ec22c788c97454f6f4c912a84597408b5f4472d37124b2e30846e0cccb1b59d”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2022-11-30T20:36:59.000Z	0x1ae866cb20421480ab9964b963bc43a720e27687900cdb5e0fdc2be56f258b2d
365490	10000000000000000	true	228440	0x4eefe3a5	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16082987	0x1c2ac40c7f5d63bf2f62b53d4d13abca184927f7	[{“callTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“callData”:“0x2e95b6c80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002386f26fc100000000000000000000000000000000000000000000000000000000000000ba8a0e0000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000180000000000000003b5dc1003926a168c11a816e10c13977f75f488bfffe88e42e9b3012”,“approveTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“fromAmount”:“10000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}]	{“relayerFeePct”:“2234390093511365”,“quoteTimestamp”:“1669813199”}	{“bridge”:“across”,“receiver”:“0xd9539d5feeef856118b7635c65031433185e30bb”,“referrer”:“0x0000000000000000000000000000000000000001”,“minAmount”:“12225038”,“integrator”:“lifi-etherspot”,“transactionId”:“0xd4049cbb028b4fc9098a4ac1321d6f39a10d4d16a6041a9c83517a99f8167a38”,“hasSourceSwaps”:true,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2022-11-30T13:05:35.000Z	0x1e845ad47c5267ad6e5cc44fe02bda4771a0a70dfd63642ff63de2dc71a72090

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaAmarok_function

Swap and bridge transactions executed through LiFi Diamond contract using Connext Amarok bridge on Ethereum. Contains cross-chain transfers with optional source swaps, destination chain routing, and relayer fee data for analyzing multi-chain token movement patterns.

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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__amarokData`	`STRUCT<callData STRING, callTo STRING, relayerFee STRING, slippageTol STRING, delegate STRING>`	Structured data containing Amarok bridge execution parameters including target contract address, encoded calldata for destination chain actions, delegate address for cross-chain execution, relayer fee in wei, and slippage tolerance basis points. Null when the bridge transaction fails or lacks Amarok-specific routing data.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__amarokData	in__bridgeData	block_timestamp	transaction_hash
1057326	150625231063623673	true	365229	0x64a74ee2	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16846454	0xca7a11e2804fc3ebf55e973a562975503dfb59f0	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0x12aa3caf0000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e00000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000000000000000000000000000000214e8348c4f000000000000000000000000000000000000000000000000000002123e1590ba20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008600000000000000000000000000000000000000000000000000006800001a4061c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2d0e30db080206c4eca27c02aaa39b223fe8d0a0e5c4f27ead9083c756cc21111111254eeb25477b68fb85ed929f73a9605820000000000000000000000000000000000000000000000000214e8348c4f000000000000000000000000000000000000000000000000000000002e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“150000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”}]	{“callTo”:“0x74674dafd6f4495e7f63f7637e94b8b89b2f01db”,“callData”:“0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000ca7a11e2804fc3ebf55e973a562975503dfb59f0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000001111111254eeb25477b68fb85ed929f73a9605820000000000000000000000001111111254eeb25477b68fb85ed929f73a9605820000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021065d95293d3bb00000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000024812aa3caf0000000000000000000000007f9e3430880580713b03670046c7e89a0a91403b0000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000007f9e3430880580713b03670046c7e89a0a91403b000000000000000000000000dd1305150d27aecc60c066630105db419977e367000000000000000000000000000000000000000000000000021065d95293d3bb0000000000000000000000000000000000000000000000000aa0c3f8752f7b9f000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000bf0000000000000000000000000000000000000000000000a100008b00004f02a00000000000000000000000000000000000000000000000000a9317e3e9a97491ee63c1e5010f338ec12d3f7c3d77a4b9fcc1f95f3fb6ad0ea62170ed0880ac9a755fd29b2688956bd959f933f84101bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00042e1a7d4d0000000000000000000000000000000000000000000000000000000000000000c0611111111254eeb25477b68fb85ed929f73a960582002e9b3012000000000000000000000000000000000000000000000000”,“delegate”:“0xca7a11e2804fc3ebf55e973a562975503dfb59f0”,“relayerFee”:“625231063623673”,“slippageTol”:“50”}	{“bridge”:“amarok”,“receiver”:“0xca7a11e2804fc3ebf55e973a562975503dfb59f0”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“149250000000000000”,“integrator”:“lifi-api”,“transactionId”:“0x28fd73ffd6e137e007662334c075ddc6186ba91b7e2a4b2d9a1b276752ee9892”,“hasSourceSwaps”:true,“sendingAssetId”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“destinationChainId”:“56”,“hasDestinationCall”:true}	2023-03-17T08:49:47.000Z	0xf908aed9b942f12cc3031deadca9dc9b32269327f0bd11921b13167d600b2c30
1658321	1059088258533811	false	258564	0x64a74ee2	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16926841	0x3bb4893b1ef4b9e2c2db0ec26ac3f078e5fcbbf8	[]			2023-03-28T15:52:23.000Z	0xdf45679d7036547da2dfd2b7f85aa9dcd5ec61b851fbf54d8eda8713c20b24ff
1664365	1055659497602936	false	258442	0x64a74ee2	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16926851	0x3bb4893b1ef4b9e2c2db0ec26ac3f078e5fcbbf8	[]			2023-03-28T15:54:23.000Z	0xe53f8d9eb0b215b4f605dd22fcae4e07a11d20065311934c4457a6cbd13efe85

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaArbitrumBridge_function

LiFi Diamond function calls for cross-chain token swaps and bridges from Ethereum to Arbitrum. Contains swap parameters, bridge configuration, gas settings, and Arbitrum-specific data for analyzing routing patterns and cross-chain transfer 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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__arbitrumData`	`STRUCT<maxSubmissionCost STRING, maxGas STRING, maxGasPrice STRING>`	Arbitrum bridge-specific parameters including max gas limit, gas price, and submission cost. Null when the transaction fails or bridge data is unavailable.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	in__arbitrumData	transaction_hash
266907	4092900589265600	true	164066	0x3cc9517b	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16220512	0x0b74039269134a2bd20cd09e82cbf30abda1aa52	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xe0cbc5f2000000000000000000000000000000000000000000000000000007bb0f7b08000000000000000000000000000000000000000000000000000000015d3ef798000000000000000000000000003110a855333bfb922aecb1b3542ba2fde28d204f”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“2000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“arbitrum”,“receiver”:“0x0b74039269134a2bd20cd09e82cbf30abda1aa52”,“referrer”:“0x3110a855333bfb922aecb1b3542ba2fde28d204f”,“minAmount”:“1990000000000000”,“integrator”:“blockwallet.io”,“transactionId”:“0x94394d1c59458f469988cdd37006066e3780d0e789ebb1adc769453727f28f61”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2022-12-19T18:23:35.000Z	{“maxGas”:“21801”,“maxGasPrice”:“300000000”,“maxSubmissionCost”:“86360289265600”}	0x5a66b73f814807cbf59419611a6a8d2901fe69b6019038f239bf87d2a52c1415
927391	513703742515648	true	719058	0x3cc9517b	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16890443	0xc93e464ac811eac3d9ec120bb2932d5cd70feb10	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0x12aa3caf0000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e0000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec7000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e00000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000000000000000000000000000000000001794826044000000000000000000000000000000000000000000000000000000178a8410aa000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002de0000000000000000000000000000000000000002c000029200024800022e00a0c9e75c4800000000000000002111000000000000000000000000000000000000000000000000000200000150510677784f96c936042a3adb1dd29c91a55eb2a4219fdac17f958d2ee523a2206206994597c13d831ec70004f41766d8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007f6fbf50d00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e0000000000000000000000000000000000000000000000000000000006422d8af0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec7000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000000000000000000000015120a5407eae9ba41422680e2e00537571bcc53efbfddac17f958d2ee523a2206206994597c13d831ec700443df021240000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f753f676e0020d6bdbf78a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800a0f2fa6b66a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000000000000017a8ccc4da000000000000000000000000004c4e0180a06c4eca27a0b86991c6218b36c1d19d4a2e9eb0ce3606eb481111111254eeb25477b68fb85ed929f73a96058200002e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“101275820100”,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“requiresDeposit”:true,“receivingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}]	{“bridge”:“arbitrum”,“receiver”:“0xc93e464ac811eac3d9ec120bb2932d5cd70feb10”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“101108158635”,“integrator”:“jumper.exchange”,“transactionId”:“0x33f99a866371744180ba7f03da18dee3997288abcb8c9512c1ead5fb18e500c7”,“hasSourceSwaps”:true,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2023-03-23T13:09:59.000Z	{“maxGas”:“75044”,“maxGasPrice”:“611520000”,“maxSubmissionCost”:“467812835635648”}	0x6a7c5b238e28da86b0b0a570080e47007dc928789001b5a77e6f67c2006cf62c
373490	94346369260000	true	292471	0x3cc9517b	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16890026	0x9e817382a12d2b1d15246c4d383beb8171bcdfa9	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0xe449022e000000000000000000000000000000000000000000000000000000050d078c14000000000000000000000000000000000000000000000000ab3f6c48125fac5200000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000011b815efb8f581194ae79006d24e0d814b7697f62e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“21693434900”,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“arbitrum”,“receiver”:“0x9e817382a12d2b1d15246c4d383beb8171bcdfa9”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“12339700560820153426”,“integrator”:“jumper.exchange”,“transactionId”:“0xaf842caa41f6b65ee96817d9cd35c8ebbaa8a3562bb57916c0e0d107b53df1e5”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2023-03-23T11:44:59.000Z	{“maxGas”:“21801”,“maxGasPrice”:“300000000”,“maxSubmissionCost”:“87806069260000”}	0x17c8354d0d0cc121d277dd2d13b6e4daced1a300aedf1076a6b7e2abe4e81abd

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaCBridge_function

Function calls to swap tokens and initiate cross-chain bridges via cBridge protocol through LiFi Diamond aggregator on Ethereum. Used for analyzing multi-hop bridge transactions with integrated DEX swaps.

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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__cBridgeData`	`STRUCT<maxSlippage STRING, nonce STRING>`	CBridge-specific parameters for the cross-chain transfer, including nonce (unique identifier) and maxSlippage (maximum allowed price deviation in basis points). This RECORD type column contains the CBridge protocol configuration that governs how the bridge operation is executed.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	in__cBridgeData	transaction_hash
1028375	true	660260	0x482c6a85	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16017378	0xfd02476801bff2488c035892793c66578f46ebd8	[{“callTo”:“0xdef1c0ded9bec7f1a1670819833240f027b25eff”,“callData”:“0x415565b00000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c530000000000000000000000000000000000000000000000d8d726b7177a8000000000000000000000000000000000000000000000000000d825b9e8f3c2514a0100000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000460000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c5300000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000420000000000000000000000000000000000000000000000000000000000000042000000000000000000000000000000000000000000000000000000000000003e00000000000000000000000000000000000000000000000d8d726b7177a80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000420000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000001942616c616e63657256320000000000000000000000000000000000000000000000000000000000d8d726b7177a8000000000000000000000000000000000000000000000000000d825b9e8f3c2514a01000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001c0000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c80000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020bd482ffb3e6e50dc1c437557c3bea2b68f3683ee0000000000000000000003c600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c53000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000020000000000000000000000006b175474e89094c44da98b954eedeac495271d0f000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000000000869584cd00000000000000000000000010000000000000000000000000000000000000110000000000000000000000000000000000000000000000d8db5f2bb7637b3f3e”,“approveTo”:“0xdef1c0ded9bec7f1a1670819833240f027b25eff”,“fromAmount”:“4000000000000000000000”,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“requiresDeposit”:true,“receivingAssetId”:“0x4fabb145d64652a948d72533023f6e7a623c7c53”}]	{“bridge”:“cbridge”,“receiver”:“0x3cb69f7b46d6840196988303dc1ff39ec7a558ea”,“referrer”:“0x0000000000000000000000000000000000000001”,“minAmount”:“3987215179904992758273”,“integrator”:“transferto.xyz”,“transactionId”:“0xae8e55f9298519f5603d2bb95decf49f176e48c314ba26ba87d8f5e409a6462e”,“hasSourceSwaps”:true,“sendingAssetId”:“0x4fabb145d64652a948d72533023f6e7a623c7c53”,“destinationChainId”:“56”,“hasDestinationCall”:true}	2022-11-21T09:05:11.000Z	{“nonce”:“1669021502453”,“maxSlippage”:“6287”}	0x8dd7fe53f72c12a89e0143553e282747ce746bafa3f988b4ff375a5ee72e3d3d
1142730	true	732022	0x482c6a85	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16021613	0x83e29c2505a969e974e372b2866876b106fa43ac	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xeedd56e1000000000000000000000000c18360217d8f7ab5e7c516566761ea12ce7f9d720000000000000000000000000000000000000000000000000023444dc56872000000000000000000000000000000000000000000000000000006393ae699f600000000000000000000000000cac60e91f8bf841dd2c9a28e894fc6676a2af892”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“11678500000000000000”,“sendingAssetId”:“0xc18360217d8f7ab5e7c516566761ea12ce7f9d72”,“requiresDeposit”:true,“receivingAssetId”:“0xc18360217d8f7ab5e7c516566761ea12ce7f9d72”},{“callTo”:“0x6352a56caadc4f1e25cd6c75970fa768a3304e64”,“callData”:“0x90411a320000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd3000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001c0000000000000000000000000c18360217d8f7ab5e7c516566761ea12ce7f9d720000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c53000000000000000000000000a1181481beb2dc5de0daf2c85392d81c704bf75d0000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae000000000000000000000000000000000000000000000000a1e8e0573d63d8000000000000000000000000000000000000000000000000078d5dd2f7696b5e300000000000000000000000000000000000000000000000079714f80bf398eebd0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000933a06c631ed8b5e4f3848c91a1cfc45e5c7eab300000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000004c000000000000000000000000000000000000000000000000000000000000007c000000000000000000000000000000000000000000000000000000000000008e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064cac460ee80000000000000003b6d0340a1181481beb2dc5de0daf2c85392d81c704bf75d000000000000000000000000c18360217d8f7ab5e7c516566761ea12ce7f9d720000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000002449f865422000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000104e5b07cdb00000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd300000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000002bc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20001f4a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000002449f865422000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000104e5b07cdb00000000000000000000000000cef0386ed94d738c8f8a74e8bfd0376926d24c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd300000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000002ba0b86991c6218b36c1d19d4a2e9eb0ce3606eb480001f44fabb145d64652a948d72533023f6e7a623c7c530000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000648a6a1e850000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c53000000000000000000000000353c1f0bc78fbbc245b3c93ef77b1dcc5b77d2a02710000000000000000000000000000000000000000000079714f80bf398eebd00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a49f8654220000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c5300000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f990000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c530000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“approveTo”:“0x6352a56caadc4f1e25cd6c75970fa768a3304e64”,“fromAmount”:“11666821500000000000”,“sendingAssetId”:“0xc18360217d8f7ab5e7c516566761ea12ce7f9d72”,“requiresDeposit”:false,“receivingAssetId”:“0x4fabb145d64652a948d72533023f6e7a623c7c53”}]	{“bridge”:“cbridge”,“receiver”:“0x83e29c2505a969e974e372b2866876b106fa43ac”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“139107568300823072251”,“integrator”:“VaporDEX”,“transactionId”:“0x12ff1c138fb7d9ca674bbf36922dadb3d812cfd5384cfdcb02da099c38e140fd”,“hasSourceSwaps”:true,“sendingAssetId”:“0x4fabb145d64652a948d72533023f6e7a623c7c53”,“destinationChainId”:“56”,“hasDestinationCall”:true}	2022-11-21T23:16:59.000Z	{“nonce”:“1669072595461”,“maxSlippage”:“8191”}	0x72d9ca54d4fd8e24ba599333b3c00e5ad110176153b3c0704a3a53944d9af40e
532390	true	410313	0x482c6a85	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16735780	0x0eb4d9dc612f691797883414a43cc4d7b5b372b7	[{“callTo”:“0xdef171fe48cf0115b1d80b88dc8eab59176fee57”,“callData”:“0x54e3f31b0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000f411903cbc70a74d22900a5de66a2dda66507255000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000878678326eac900000000000000000000000000000000000000000000000000000002607209e08dc14d000000000000000000000000000000000000000000000000026380c32c4b92ad00000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000024000000000000000000000000000000000000000000000000000000000000003c000000000000000000000000000000000000000000000000000000000000004400000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000008c208b7b5625d78deb49240ef28126cbe2738098010000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000063fff8817dacc4ce4744407da965e696f854e675000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000e592427a0aece92de3edee1f18e0157c05861564000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee570000000000000000000000000000000000000000000000000000000000000148c04b8d59000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee570000000000000000000000000000000000000000000000000000000063ffb230000000000000000000000000000000000000000000000878678326eac90000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002bf411903cbc70a74d22900a5de66a2dda66507255000bb8c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000e1829cfe000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012400000000000000000000000000000000000000000000000000000000000001480000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“approveTo”:“0x216b4b4ba9f3e719726886d34a177484278bfcae”,“fromAmount”:“40000000000000000000000”,“sendingAssetId”:“0xf411903cbc70a74d22900a5de66a2dda66507255”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“cbridge”,“receiver”:“0x0eb4d9dc612f691797883414a43cc4d7b5b372b7”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“171262172587737421”,“integrator”:“jumper.exchange”,“transactionId”:“0x1bba7430944ad72eaa28d62a913561be862b7f580313d597bc81e07075e7735b”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2023-03-01T19:14:59.000Z	{“nonce”:“1677698080905”,“maxSlippage”:“7979”}	0xd54d885b9bd2c08c2b72623e1a12dadbed8992a3bdd7ff0b79757aceceb08f00

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaHop_function

LiFi cross-chain swap and bridge transactions using Hop Protocol on Ethereum. Contains swap parameters, bridge details, and Hop-specific data for analyzing cross-chain token transfers that combine DEX (decentralized exchange) swaps with Hop bridge execution.

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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__hopData`	`STRUCT<bonderFee STRING, amountOutMin STRING, deadline STRING, destinationAmountOutMin STRING, destinationDeadline STRING>`	Hop protocol bridge parameters including deadline timestamps, bonder fees, and minimum output amounts for cross-chain transfers. Nested structure containing both source and destination chain constraints with deadlines typically set 1-2 hours from transaction time.

Sample Data

gas	value	status	gas_used	signature	to_address	in__hopData	block_number	from_address	in__swapData	trace_address	in__bridgeData	block_timestamp	transaction_hash
399137	0	true	304305	0xe55f8110	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	{“deadline”:“1669811970”,“bonderFee”:“0”,“amountOutMin”:“11817119336233799”,“destinationDeadline”:“1669811970”,“destinationAmountOutMin”:“11817119336233799”}	16075706	0x777777773fdd8b28bb03377d10fcea75ad9768da	[{“callTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“callData”:“0x2e95b6c8000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000000000000e4e1c0000000000000000000000000000000000000000000000000002ad793ef78d7590000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000140000000000000003b6d0340397ff1542f962076d0bfe58ea045ffa2d347aca02e9b3012”,“approveTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“fromAmount”:“15000000”,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	5,0,3,3	{“bridge”:“hop”,“receiver”:“0x3f769c3666342f642b0fb3de045ea57b2709cc6b”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“12058979399685977”,“integrator”:“0xff7e5c048a49ab8f28479fb4aadbdb4a697fd382b9fd07e96964fe52df0334f6”,“transactionId”:“0xff7e5c048a49ab8f28479fb4aadbdb4a697fd382b9fd07e96964fe52df0334f6”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2022-11-29T12:39:59.000Z	0x3e2d491ca552645073c81318d95afc2168487315e4546681c7dc5ade61315acc
369435	0	true	277148	0xe55f8110	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	{“deadline”:“1670062481”,“bonderFee”:“0”,“amountOutMin”:“20657516220077650848”,“destinationDeadline”:“1670062481”,“destinationAmountOutMin”:“20657516220077650848”}	16096461	0x777777773fdd8b28bb03377d10fcea75ad9768da	[{“callTo”:“0xdef171fe48cf0115b1d80b88dc8eab59176fee57”,“callData”:“0x0b86a4c1000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec70000000000000000000000000000000000000000000000000000000001312d00000000000000000000000000000000000000000000000001249c7759cb0ac21b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000001000000000000000000004de588c095c8ba2c7a1353cf3d21e692c5d4d0f90793”,“approveTo”:“0x216b4b4ba9f3e719726886d34a177484278bfcae”,“fromAmount”:“20000000”,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“requiresDeposit”:true,“receivingAssetId”:“0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”}]	5,0,3,3	{“bridge”:“hop”,“receiver”:“0x462391b060d9c417d477b47f6cdc56c9d5747353”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“21084858782984094235”,“integrator”:“0xe4340319794a2aa390b009f9c5e2ff53e57e6fdcce2deb46c7ce82a00c4f6f23”,“transactionId”:“0xe4340319794a2aa390b009f9c5e2ff53e57e6fdcce2deb46c7ce82a00c4f6f23”,“hasSourceSwaps”:true,“sendingAssetId”:“0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2022-12-02T10:15:11.000Z	0x17a6f745e46e433a5f5e244fea90092ad96b819b9b631c84196719514d244eee
322658	30845000000000000000	true	200417	0xe55f8110	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	{“deadline”:“1669936025”,“bonderFee”:“0”,“amountOutMin”:“29775613323127121578”,“destinationDeadline”:“1669936025”,“destinationAmountOutMin”:“29775613323127121578”}	16085971	0x34ed7813ebbb6a2a717d5aad388529177797b79d	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xe0cbc5f200000000000000000000000000000000000000000000000001d1bacc1d69740000000000000000000000000000000000000000000000000000523005e7129c000000000000000000000000003110a855333bfb922aecb1b3542ba2fde28d204f”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“30845000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]		{“bridge”:“hop”,“receiver”:“0x34ed7813ebbb6a2a717d5aad388529177797b79d”,“referrer”:“0x3110a855333bfb922aecb1b3542ba2fde28d204f”,“minAmount”:“30690775000000000000”,“integrator”:“blockwallet.io”,“transactionId”:“0xb95035070b48699776d7e70d1769266c542d3d9145148aadf10985fae060a2ff”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2022-11-30T23:07:11.000Z	0xdae661abd8873b34e930e5a13cac44b608560143e2702f61ae20188d47b79015

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaHopL1ERC20_function

Cross-chain swap and bridge transactions through LiFi’s diamond contract using Hop Protocol on Ethereum mainnet. Used to analyze multi-step token swaps before bridging assets to other chains like Polygon, Optimism, and Gnosis Chain.

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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__hopData`	`STRUCT<bonderFee STRING, amountOutMin STRING, deadline STRING, destinationAmountOutMin STRING, destinationDeadline STRING, hopBridge STRING>`	Bridge execution parameters for Hop Protocol including bonder fees, deadlines, minimum output amounts, and destination bridge contract address. Null when transaction fails or uses different bridge provider.

Sample Data

gas	status	gas_used	signature	to_address	in__hopData	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	transaction_hash
268537	false	19865	0x6721556d	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae		16821655	0xb261a9577063f57ebdc7663ee2c30bb9d0162deb	[]		2023-03-13T21:11:11.000Z	0xd1c3359ecf5e3ca12b630a28af744c123803b18766d465c6fbebcd05fe8290e6
268534	true	205798	0x6721556d	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	{“deadline”:“1678810768”,“bonderFee”:“0”,“hopBridge”:“0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2”,“amountOutMin”:“297813494937986962347”,“destinationDeadline”:“1678810768”,“destinationAmountOutMin”:“297813494937986962347”}	16821655	0xb261a9577063f57ebdc7663ee2c30bb9d0162deb	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xeedd56e10000000000000000000000007d1afa7b718fb893db30a3abc0cfc608aacfebb0000000000000000000000000000000000000000000000000129473d1ff08b64500000000000000000000000000000000000000000000000003475fbba57a020c00000000000000000000000091ea0c7de959282848ac68d0cda5dffd7d75763b”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“315017020000000016384”,“sendingAssetId”:“0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”,“requiresDeposit”:true,“receivingAssetId”:“0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”}]	{“bridge”:“hop”,“receiver”:“0xb261a9577063f57ebdc7663ee2c30bb9d0162deb”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“313441934900000016303”,“integrator”:“AccelDefi”,“transactionId”:“0x024a3d5c7036822b5600e31613403d1fea3064b8e24397bac73de92396bd4574”,“hasSourceSwaps”:true,“sendingAssetId”:“0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2023-03-13T21:11:11.000Z	0x3abd14d2de56a6ecf0f86ec8a5f11b1bf5032652d8ed71baf09e7bb9663cf122
302041	true	188698	0x6721556d	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	{“deadline”:“1678827912”,“bonderFee”:“0”,“hopBridge”:“0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2”,“amountOutMin”:“337991287622311116671”,“destinationDeadline”:“1678827912”,“destinationAmountOutMin”:“337991287622311116671”}	16821626	0xf8011b1a4686cdbc6d640c617b670a8535f9a434	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xeedd56e10000000000000000000000007d1afa7b718fb893db30a3abc0cfc608aacfebb0000000000000000000000000000000000000000000000000063cf56d6b4e70300000000000000000000000000000000000000000000000000119d0f5310dd79000000000000000000000000000009cc27c811a3e0fdd2fd737afcc721b67ee8e”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“352552088730000000000”,“sendingAssetId”:“0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”,“requiresDeposit”:true,“receivingAssetId”:“0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”}]	{“bridge”:“hop”,“receiver”:“0xf8011b1a4686cdbc6d640c617b670a8535f9a434”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“352023260596905000000”,“integrator”:“Rubic”,“transactionId”:“0x4329abb0c98954acf226c611d4f192059b3bbcf3b3424b75ed2d52ce78d7ed14”,“hasSourceSwaps”:true,“sendingAssetId”:“0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2023-03-13T21:05:23.000Z	0x4a1ee5ec7d40dfbb9d47383a16b0002a3b3143af2f3554d5736ac9aed604a617

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaHopL1Native_function

LiFi cross-chain bridge transactions using Hop Protocol from Ethereum L1 to other chains, combining token swaps with native ETH bridging. Tracks swap parameters, bridge configuration, and destination chain routing 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.
`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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__hopData`	`STRUCT<bonderFee STRING, amountOutMin STRING, deadline STRING, destinationAmountOutMin STRING, destinationDeadline STRING, hopBridge STRING>`	Nested parameters for the Hop Protocol bridge operation, including bonder fee, deadline timestamps, and minimum output amounts. Contains null values when the transaction failed or did not require Hop-specific bridge configuration.

Sample Data

gas	value	status	gas_used	signature	to_address	in__hopData	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	transaction_hash
445270	0	false	111901	0x82614997	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae		16879308	0xb68c6e64cfaf1a1131f6119c76cee179a71a4edd	[]		2023-03-21T23:35:47.000Z	0x38172bf3684bbafc5002d4c0c8f597fe47de6d9a092252557392cd8c5fab9058
424607	0	true	328624	0x82614997	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	{“deadline”:“1679518978”,“bonderFee”:“0”,“hopBridge”:“0xb8901acb165ed027e32754e0ffe830802919727f”,“amountOutMin”:“118813013127139798”,“destinationDeadline”:“1679518978”,“destinationAmountOutMin”:“118813013127139798”}	16878605	0x00c2cdfd0ccf699632d87bac5802e9136f9989e2	[{“callTo”:“0x7a250d5630b4cf539739df2c5dacb4c659f2488d”,“callData”:“0x18cbafe50000000000000000000000000000000000000000000017d2e8846ef69a44000000000000000000000000000000000000000000000000000001a861f99ea7671f00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000000000000000641a29920000000000000000000000000000000000000000000000000000000000000002000000000000000000000000549020a9cb845220d66d3e9c6d9f9ef61c981102000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“approveTo”:“0x7a250d5630b4cf539739df2c5dacb4c659f2488d”,“fromAmount”:“112505000000000000000000”,“sendingAssetId”:“0x549020a9cb845220d66d3e9c6d9f9ef61c981102”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“hop”,“receiver”:“0x00c2cdfd0ccf699632d87bac5802e9136f9989e2”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“119453114861840159”,“integrator”:“jumper.exchange”,“transactionId”:“0x689678e16a2bfac3fe8101407ae3644e2aaeebda6e76f2a985172342b2d9dc0a”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2023-03-21T21:13:35.000Z	0x63989b0ab776652d6d9515c3e7ee0e04bc7e193cf44386c8410a7533f9e8f5ba
174669	10000000000000000	false	172059	0x82614997	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	{“deadline”:“1679499294”,“bonderFee”:“0”,“hopBridge”:“0xb8901acb165ed027e32754e0ffe830802919727f”,“amountOutMin”:“9917306407545252”,“destinationDeadline”:“1679499294”,“destinationAmountOutMin”:“9917306407545252”}	16876938	0x3076fcd094211cf8bbc2c64395754ee80bd5079d	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xe0cbc5f2000000000000000000000000000000000000000000000000000026a74d672800000000000000000000000000000000000000000000000000000006d23ad5f8000000000000000000000000003110a855333bfb922aecb1b3542ba2fde28d204f”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“10000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“hop”,“receiver”:“0x3076fcd094211cf8bbc2c64395754ee80bd5079d”,“referrer”:“0x3110a855333bfb922aecb1b3542ba2fde28d204f”,“minAmount”:“9950000000000000”,“integrator”:“blockwallet.io”,“transactionId”:“0xd200e3d145c04f0fc72e8bfdb9a4b4c48f5aefd3bd5190ee6cc7097c6dcc03ee”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2023-03-21T15:35:23.000Z	0x52e0a6c7ac83668fb359535c5fa2efc22a410bed9b810610dc737b4456d19dec

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaHyphen_function

Function call logs for cross-chain token swaps routed through LiFi’s aggregator using Hyphen bridge on Ethereum. Captures swap parameters, bridge metadata, and transaction outcomes for analyzing multi-chain transfer patterns and integrator usage.

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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	transaction_hash
381286	0	true	284179	0x9feb6731	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16886438	0xe1a626a3ea90d0c23984e90c95ed48fd4dbc8d59	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0xe449022e0000000000000000000000000000000000000000000000000000000001312d000000000000000000000000000000000000000000000000002b83b904d91db186000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000012000000000000000000000004585fe77225b41b697c938b018e2ac67ac5a20c02e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“20000000”,“sendingAssetId”:“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“hyphen”,“receiver”:“0xe1a626a3ea90d0c23984e90c95ed48fd4dbc8d59”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“3135553196053606791”,“integrator”:“jumper.exchange”,“transactionId”:“0x54ece3eeb7dc7fd9aeb583d334308899b1d70459756958d934bf250aa9f32f52”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“43114”,“hasDestinationCall”:true}	2023-03-22T23:36:35.000Z	0xea9c377b0ae80e545bc1a9b994ad0b0516ee59e3040967b7c6bfa3fc3e897357
342035	0	true	261878	0x9feb6731	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16886289	0x8c9524d7756c3f87ac3a174fc93f193260a3729a	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xeedd56e1000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec70000000000000000000000000000000000000000000000000000000000156bff000000000000000000000000000000000000000000000000000000000003c7c3000000000000000000000000cac60e91f8bf841dd2c9a28e894fc6676a2af892”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“1651650000”,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“requiresDeposit”:true,“receivingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”}]	{“bridge”:“hyphen”,“receiver”:“0x8c9524d7756c3f87ac3a174fc93f193260a3729a”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“1649998350”,“integrator”:“VaporDEX”,“transactionId”:“0x37e9d6eaef8dbd80279ca8b8eff41625a3a092e0593a88049e684a9c3dca26d4”,“hasSourceSwaps”:true,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“destinationChainId”:“56”,“hasDestinationCall”:true}	2023-03-22T23:06:11.000Z	0x725b58bbf6c04df7377753dd4401b885688c93f5160c1be0a61e8004f350af8d
671843	20000000000000000	true	517861	0x9feb6731	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16530746	0xa391d61a3c9ea5c8db6375bf5f223c14f615d1f2	[{“callTo”:“0xdef171fe48cf0115b1d80b88dc8eab59176fee57”,“callData”:“0xa94e78ef0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000000000000000000000000000000470de4df8200000000000000000000000000000000000000000000000000000000000001e0fd670000000000000000000000000000000000000000000000000000000001e3682a0000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000000000000000000001600000000000000000000000008c208b7b5625d78deb49240ef28126cbe273809801000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000063da17562cb41fafebe94a128702b2c32bd1cbee000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000005400000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000fc2ba6e830a04c25e207b8214b26d8c713f6881f000000000000000000000000000000000000000000000000000000000000271000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000009000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c8000000000000000000000000000000000000000000000000000000000000271000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002e0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee5700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000260ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200b09dea16768f0799065c475be02919503cb2a3500020000000000000000001a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000470de4df82000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000006b175474e89094c44da98b954eedeac495271d0f00000000000000000000000000000000000000000000000000000000000000027fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff7fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000fc2ba6e830a04c25e207b8214b26d8c713f6881f000000000000000000000000000000000000000000000000000000000000271000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000009000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c8000000000000000000000000000000000000000000000000000000000000271000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002e0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee570000000000000000000000000000000000000000000000000000000000000000000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee5700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000260ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020178e029173417b1f9c8bc16dcec6f697bc32374600000000000000000000025d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000001b7bce07d71a0bb1700000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000006b175474e89094c44da98b954eedeac495271d0f000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000000000000000000000027fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff7fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000”,“approveTo”:“0x216b4b4ba9f3e719726886d34a177484278bfcae”,“fromAmount”:“20000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}]	{“bridge”:“hyphen”,“receiver”:“0xa391d61a3c9ea5c8db6375bf5f223c14f615d1f2”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“31522151”,“integrator”:“transferto.xyz”,“transactionId”:“0xb6b11e5a9a6651da965fff3e752ef14f1896da1319471fe15d1af0e24ac0f26b”,“hasSourceSwaps”:true,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2023-02-01T01:40:11.000Z	0xbcb6ce28eb29a4958e8cf0c00bc42936933be5789d3ff9a5035501f0816a8317

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaMultichain_function

Cross-chain bridge transactions from LiFi protocol that swap tokens on Ethereum before bridging via Multichain to destination chains like Fantom, Avalanche, Optimism, and Arbitrum. Used for analyzing DEX aggregation behavior and cross-chain transfer 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.
`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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__multichainData`	`STRUCT<router STRING>`	Nested RECORD containing Multichain bridge routing parameters, specifically the router contract address used to execute the cross-chain transfer. This field is always populated when bridging via Multichain protocol.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	transaction_hash	in__multichainData
413489	1000000000000000000	true	316723	0xa342d3ff	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16752079	0x7173a301c832e50119ddb12cfb6570a83b1eec05	[{“callTo”:“0xdef171fe48cf0115b1d80b88dc8eab59176fee57”,“callData”:“0x54e3f31b0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000de0b6b3a7640000000000000000000000000000000000000000000000000000000000005d41f50b000000000000000000000000000000000000000000000000000000005db9ed4500000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000024000000000000000000000000000000000000000000000000000000000000003a000000000000000000000000000000000000000000000000000000000000004200000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000008c208b7b5625d78deb49240ef28126cbe273809801000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000480000000000000000000000000000000000000000000000000000000006402ff3f97c7dda0d16344739a96f136569bab02000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000e592427a0aece92de3edee1f18e0157c058615640000000000000000000000000000000000000000000000000000000000000128d0e30db0c04b8d59000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee57000000000000000000000000000000000000000000000000000000006402b8ee0000000000000000000000000000000000000000000000000de0b6b3a76400000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002bc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000064a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000012800000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000de0b6b3a764000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“approveTo”:“0x216b4b4ba9f3e719726886d34a177484278bfcae”,“fromAmount”:“1000000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}]	{“bridge”:“multichain”,“receiver”:“0x7173a301c832e50119ddb12cfb6570a83b1eec05”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“1564603659”,“integrator”:“jumper.exchange”,“transactionId”:“0xa46aa04c6d992a1f7bfa540f707ae690e2bebf07b8c99715b7ebfa4c0ce6d66f”,“hasSourceSwaps”:true,“sendingAssetId”:“0x7ea2be2df7ba6e54b1a9c70676f668455e329d29”,“destinationChainId”:“250”,“hasDestinationCall”:true}	2023-03-04T02:20:23.000Z	0x0a8fbe0c82318dfc81e44d1648e991d4aa6517256e32ebe703924c49cd691e1a	{“router”:“0x6b7a87899490ece95443e979ca9485cbe7e71522”}
189624	14985000000000000	true	141916	0xa342d3ff	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16417024	0x3da4874b227a63d72ec01138b65a26b34671f406	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xe0cbc5f200000000000000000000000000000000000000000000000000000b9897388c000000000000000000000000000000000000000000000000000000020bde7363ff000000000000000000000000cac60e91f8bf841dd2c9a28e894fc6676a2af892”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“14985000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“multichain”,“receiver”:“0x3da4874b227a63d72ec01138b65a26b34671f406”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“14970000000000001”,“integrator”:“VaporDEX”,“transactionId”:“0xc63acaceb2a45c555ce21410e38265f8cf8a6430cd46f5f8392ef31ad4af05e1”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0615dbba33fe61a31c7ed131bda6655ed76748b1”,“destinationChainId”:“43114”,“hasDestinationCall”:true}	2023-01-16T04:39:59.000Z	0xde7f2be8fd3833c9e50f81c68a219b2419116cae2ef2c63d28a7a1ba5ba7a837	{“router”:“0xba8da9dcf11b50b03fd5284f164ef5cdef910705”}
399928	0	true	304785	0xa342d3ff	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16421195	0x2c864e4c276c6066fbed64559d6262ed85452359	[{“callTo”:“0x6352a56caadc4f1e25cd6c75970fa768a3304e64”,“callData”:“0x90411a320000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd3000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001c00000000000000000000000006b175474e89094c44da98b954eedeac495271d0f000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000682831244b0e97946abc52cb1893cce398de3a350000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000000000000000000000000000159949c371358400000000000000000000000000000000000000000000000000000389a43e76c86ccb000000000000000000000000000000000000000000000000038e314a5b140b920000000000000000000000000000000000000000000000000000000000000002000000000000000000000000933a06c631ed8b5e4f3848c91a1cfc45e5c7eab3000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000003c000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064cac460ee00000000000000003b6d0340682831244b0e97946abc52cb1893cce398de3a350000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001649f865422000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000004000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000242e1a7d4d00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000648a6a1e85000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000353c1f0bc78fbbc245b3c93ef77b1dcc5b77d2a0271000000000000000000000000000000000000000000000038e314a5b140b9200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a49f865422000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“approveTo”:“0x6352a56caadc4f1e25cd6c75970fa768a3304e64”,“fromAmount”:“398427200000000000000”,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“multichain”,“receiver”:“0x2c864e4c276c6066fbed64559d6262ed85452359”,“referrer”:“0x0000000000000000000000000000000000000001”,“minAmount”:“254915442110917835”,“integrator”:“transferto.xyz”,“transactionId”:“0x4685ac494e25dcf33c1fe5e89a4a1aa0c0ad5e1ea655df19036104312c9c02e6”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0615dbba33fe61a31c7ed131bda6655ed76748b1”,“destinationChainId”:“42161”,“hasDestinationCall”:true}	2023-01-16T18:38:35.000Z	0xff7d6a82115cb73ec979ab07babb443f9329cd5c8eee43e3e6956ee72a2cc43c	{“router”:“0xba8da9dcf11b50b03fd5284f164ef5cdef910705”}

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaNXTP_function

Cross-chain swap and bridge execution records from LiFi’s Diamond router contract on Ethereum using Connext (NXTP) protocol. Captures source-chain token swaps, destination chain parameters, and encrypted bridge data for analyzing cross-chain liquidity routing and integrator 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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__nxtpData`	`STRUCT<invariantData STRUCT<receivingChainTxManagerAddress STRING, user STRING, router STRING, initiator STRING, sendingAssetId STRING, receivingAssetId STRING, sendingChainFallback STRING, receivingAddress STRING, callTo STRING, sendingChainId STRING, receivingChainId STRING, callDataHash STRING, transactionId STRING>, expiry STRING, encryptedCallData STRING, encodedBid STRING, bidSignature STRING, encodedMeta STRING>`	Structured data payload for the Connext NXTP (Noncustodial Xchain Transfer Protocol) bridge operation, containing bid details, router addresses, transaction identifiers, and encrypted swap parameters. Null when no cross-chain bridge data is required for the transaction.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__nxtpData	in__swapData	trace_address	in__bridgeData	block_timestamp	transaction_hash
404158	7000000000000000	true	395882	0x9c70d7e6	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16261927	0xe6e3f947ccd0add1effde3bf3d210e5d711beace	{“expiry”:“1672232516”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000997f29174a766a1da04cf77d135d59dd12fb54d100000000000000000000000095829c9acfecaec0ee594a377311b0937c4a28820000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000000000000000000000010000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000000000000000000000000000007089260402f5ec00000000000000000000000000000000000000000000000000000000000000a86a000000000000000000000000d586e7f844cea2f87f50152665bcbc2c279d8d700000000000000000000000000000000000000000000000003c87d096efe1c05e0000000000000000000000005f893809482bcc74ea671de2fba2788824ef2c8cc2ebca1a94f5ba50cc54de63394b7a70dfb0a7ca999b7361d6f59a7d4b2db98d0000000000000000000000000000000000000000000000000000000063ac3e3d7251d2731cdbd07fa19d775c8a6a4793add9777a25b50502f8aabaa35da3bb560000000000000000000000000baee5700179d87fabad13022447bd4e160374dd000000000000000000000000000000000000000000000000000000000000024000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a0900000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000000000000000000000000000000000000063a84aea00000000000000000000000000000000000000000000000000000000000004c44f91bc2ba41253f0b5fdd27c42fdadd7bd84d1ec4d458841177b76d3fd8e92496cf6f3e40000000000000000000000000000000000000000000000000000000000000080000000000000000000000000d586e7f844cea2f87f50152665bcbc2c279d8d700000000000000000000000005f893809482bcc74ea671de2fba2788824ef2c8c000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000d586e7f844cea2f87f50152665bcbc2c279d8d7000000000000000000000000049d5c2bdffac6ce2bfdb6640f4f80f226bc10bab00000000000000000000000000000000000000000000000035dd58af53b366f900000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002e87c025200000000000000000000000000d41b24bba51fac0e4827b6f94c0d6ddeb183cd6400000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000d586e7f844cea2f87f50152665bcbc2c279d8d7000000000000000000000000049d5c2bdffac6ce2bfdb6640f4f80f226bc10bab000000000000000000000000ba09679ab223c6bdaf44d45ba2d7279959289ab0000000000000000000000000dd1305150d27aecc60c066630105db419977e36700000000000000000000000000000000000000000000000035dd58af53b366f9000000000000000000000000000000000000000000000000000ac8fa394d86da00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001300000000000000000000000000000000000000000000000000000000000f200a007e5c0d20000000000000000000000000000000000000000000000000000ce00006700206ae40711b8002dc6c0ba09679ab223c6bdaf44d45ba2d7279959289ab0436929ce28f0b45891f8ef33b615ed578e93401c000000000000000000000000000000000000000000000000046872f210d2b9bdd586e7f844cea2f87f50152665bcbc2c279d8d7000206ae40711b8002dc6c0436929ce28f0b45891f8ef33b615ed578e93401c1111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000000ac8fa394d86dab31f66aa3c1e785363f0875a1b74e27b85fd66c700000000000000000000000000000000000000000000000035dd58af53b366f9000000000000000000000000000000002e9b301200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x99b385ca7ee095c14c22a213203abf91b4f9401f121ee1417a2e74d140b5ced37a25043aa579552bbac42c29c2ab022cf2a20aa2d9c77750e786ed219dfd4acc1b”,“invariantData”:{“user”:“0x997f29174a766a1da04cf77d135d59dd12fb54d1”,“callTo”:“0x0baee5700179d87fabad13022447bd4e160374dd”,“router”:“0x95829c9acfecaec0ee594a377311b0937c4a2882”,“initiator”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“callDataHash”:“0x7251d2731cdbd07fa19d775c8a6a4793add9777a25b50502f8aabaa35da3bb56”,“transactionId”:“0xc2ebca1a94f5ba50cc54de63394b7a70dfb0a7ca999b7361d6f59a7d4b2db98d”,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“sendingChainId”:“1”,“receivingAddress”:“0x5f893809482bcc74ea671de2fba2788824ef2c8c”,“receivingAssetId”:“0xd586e7f844cea2f87f50152665bcbc2c279d8d70”,“receivingChainId”:“43114”,“sendingChainFallback”:“0x5f893809482bcc74ea671de2fba2788824ef2c8c”,“receivingChainTxManagerAddress”:“0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09”},“encryptedCallData”:“0x4f91bc2ba41253f0b5fdd27c42fdadd7bd84d1ec4d458841177b76d3fd8e92496cf6f3e40000000000000000000000000000000000000000000000000000000000000080000000000000000000000000d586e7f844cea2f87f50152665bcbc2c279d8d700000000000000000000000005f893809482bcc74ea671de2fba2788824ef2c8c000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000d586e7f844cea2f87f50152665bcbc2c279d8d7000000000000000000000000049d5c2bdffac6ce2bfdb6640f4f80f226bc10bab00000000000000000000000000000000000000000000000035dd58af53b366f900000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002e87c025200000000000000000000000000d41b24bba51fac0e4827b6f94c0d6ddeb183cd6400000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000d586e7f844cea2f87f50152665bcbc2c279d8d7000000000000000000000000049d5c2bdffac6ce2bfdb6640f4f80f226bc10bab000000000000000000000000ba09679ab223c6bdaf44d45ba2d7279959289ab0000000000000000000000000dd1305150d27aecc60c066630105db419977e36700000000000000000000000000000000000000000000000035dd58af53b366f9000000000000000000000000000000000000000000000000000ac8fa394d86da00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001300000000000000000000000000000000000000000000000000000000000f200a007e5c0d20000000000000000000000000000000000000000000000000000ce00006700206ae40711b8002dc6c0ba09679ab223c6bdaf44d45ba2d7279959289ab0436929ce28f0b45891f8ef33b615ed578e93401c000000000000000000000000000000000000000000000000046872f210d2b9bdd586e7f844cea2f87f50152665bcbc2c279d8d7000206ae40711b8002dc6c0436929ce28f0b45891f8ef33b615ed578e93401c1111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000000ac8fa394d86dab31f66aa3c1e785363f0875a1b74e27b85fd66c700000000000000000000000000000000000000000000000035dd58af53b366f9000000000000000000000000000000002e9b3012000000000000000000000000000000000000000000000000”}	[{“callTo”:“0x6352a56caadc4f1e25cd6c75970fa768a3304e64”,“callData”:“0x90411a320000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd3000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001c0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd30000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000000000000000000000000000000018de76816d80000000000000000000000000000000000000000000000000007089260402f5ec0000000000000000000000000000000000000000000000000076756b6289da71af0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000933a06c631ed8b5e4f3848c91a1cfc45e5c7eab300000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000003c000000000000000000000000000000000000000000000000000000000000004e00000000000000000000000000000000000000000000000000000000000000600000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000018de76816d800000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000004d0e30db000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a49f865422000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000682831244b0e97946abc52cb1893cce398de3a350000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064cac460ee80000000000000003b6d0340682831244b0e97946abc52cb1893cce398de3a35000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000006d8e9bd8f845f51a224e216b6dd25d5e593d8dd300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000648a6a1e850000000000000000000000006b175474e89094c44da98b954eedeac495271d0f000000000000000000000000353c1f0bc78fbbc245b3c93ef77b1dcc5b77d2a027100000000000000000000000000000000000000000000076756b6289da71af00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a49f8654220000000000000000000000006b175474e89094c44da98b954eedeac495271d0f00000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f990000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“approveTo”:“0x6352a56caadc4f1e25cd6c75970fa768a3304e64”,“fromAmount”:“7000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”}]	0,0,0	{“bridge”:“connext”,“receiver”:“0x5f893809482bcc74ea671de2fba2788824ef2c8c”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“8109054402728684544”,“integrator”:“metamask-bridge”,“transactionId”:“0xa41253f0b5fdd27c42fdadd7bd84d1ec4d458841177b76d3fd8e92496cf6f3e4”,“hasSourceSwaps”:true,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“destinationChainId”:“43114”,“hasDestinationCall”:true}	2022-12-25T13:02:35.000Z	0x7fd8a5f7088d024c7f77fa8c130370cf062adbcdc197b4ec2e39d3a36ad3db6a
341724	1000000000000000000	true	201347	0x9c70d7e6	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16056240	0xac0b6fcae9326ef05ca91c341730ef62d7882f3a	{“expiry”:“1669749992”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000997f29174a766a1da04cf77d135d59dd12fb54d1000000000000000000000000826ccd5ed8ca665555fe45a4f045b61516b241c00000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ddeeff45500c00000000000000000000000000000000000000000000000000000000000000000380000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000000000000000000000000000000dd16f346333bfb2000000000000000000000000ac0b6fcae9326ef05ca91c341730ef62d7882f3af04cd619463022c0e36f3c904d7e3503bd3403f92147f05ea651271c35e567a60000000000000000000000000000000000000000000000000000000063865ce13400c818506d72d68c90ccf3331c0bd93cf1564b4c85e54e11eff87819859a37000000000000000000000000b0b9696a7b0f2e508c8027cb1f6be664e5afb25b000000000000000000000000000000000000000000000000000000000000024000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000002a9ea5e8cddf40730f4f4f839f673a51600c314e000000000000000000000000000000000000000000000000000000006382698d00000000000000000000000000000000000000000000000000000000000005444f91bc2b6ba8ab09593dc2f1139afb960229f0dd8db99b31211fc7f98afb975a885529e100000000000000000000000000000000000000000000000000000000000000800000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000ac0b6fcae9326ef05ca91c341730ef62d7882f3a000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000008d3e3a57c5f140b5f9feb0d43d37a347ee01c8510000000000000000000000000000000000000000000000000dcb49f4be97b26800000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003687c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000008d3e3a57c5f140b5f9feb0d43d37a347ee01c8510000000000000000000000009ad32e3054268b849b84a8dbcc7c8f7c52e4e69a000000000000000000000000fa5de8c86966a6514ec44220160e855c5b0f07f30000000000000000000000000000000000000000000000000dcb49f4be97b268000000000000000000000000000000000000000000000000001057b97179a62600000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001a10000000000000000000000000000000000000000000001630001350000eb00a007e5c0d20000000000000000000000000000000000000000000000c700007400003a40209ad32e3054268b849b84a8dbcc7c8f7c52e4e69abd6015b4000000000000000000000000feafe253802b77456b4627f8c2306a9cebb5d6814020feafe253802b77456b4627f8c2306a9cebb5d681dd93f59a000000000000000000000000581012e85c29948a2207575388aae93a1ea8f63400206ae4071198002625a0581012e85c29948a2207575388aae93a1ea8f634000000000000000000000000000000000000000000000000001057b97179a626bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00a0f2fa6b668d3e3a57c5f140b5f9feb0d43d37a347ee01c8510000000000000000000000000000000000000000000000000012591e9b2a0bd90000000000000000000027b64bf5a32080a06c4eca278d3e3a57c5f140b5f9feb0d43d37a347ee01c8511111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000000000000000000000000000000dcb49f4be97b268000000000000000000000000000000000000000000000000000000000000002e9b301200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x8352fa1522eb034dca00fc99c53f20b510aa206cdc87fc5db69f8b78b0aa20e71ef49fbbc415b26b2ec8ce3e012021e33ebf69b33e00e59aa39193028c6084ca1c”,“invariantData”:{“user”:“0x997f29174a766a1da04cf77d135d59dd12fb54d1”,“callTo”:“0xb0b9696a7b0f2e508c8027cb1f6be664e5afb25b”,“router”:“0x826ccd5ed8ca665555fe45a4f045b61516b241c0”,“initiator”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“callDataHash”:“0x3400c818506d72d68c90ccf3331c0bd93cf1564b4c85e54e11eff87819859a37”,“transactionId”:“0xf04cd619463022c0e36f3c904d7e3503bd3403f92147f05ea651271c35e567a6”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“1”,“receivingAddress”:“0xac0b6fcae9326ef05ca91c341730ef62d7882f3a”,“receivingAssetId”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“receivingChainId”:“56”,“sendingChainFallback”:“0xac0b6fcae9326ef05ca91c341730ef62d7882f3a”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“encryptedCallData”:“0x4f91bc2b6ba8ab09593dc2f1139afb960229f0dd8db99b31211fc7f98afb975a885529e100000000000000000000000000000000000000000000000000000000000000800000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000ac0b6fcae9326ef05ca91c341730ef62d7882f3a000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000008d3e3a57c5f140b5f9feb0d43d37a347ee01c8510000000000000000000000000000000000000000000000000dcb49f4be97b26800000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003687c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000008d3e3a57c5f140b5f9feb0d43d37a347ee01c8510000000000000000000000009ad32e3054268b849b84a8dbcc7c8f7c52e4e69a000000000000000000000000fa5de8c86966a6514ec44220160e855c5b0f07f30000000000000000000000000000000000000000000000000dcb49f4be97b268000000000000000000000000000000000000000000000000001057b97179a62600000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001a10000000000000000000000000000000000000000000001630001350000eb00a007e5c0d20000000000000000000000000000000000000000000000c700007400003a40209ad32e3054268b849b84a8dbcc7c8f7c52e4e69abd6015b4000000000000000000000000feafe253802b77456b4627f8c2306a9cebb5d6814020feafe253802b77456b4627f8c2306a9cebb5d681dd93f59a000000000000000000000000581012e85c29948a2207575388aae93a1ea8f63400206ae4071198002625a0581012e85c29948a2207575388aae93a1ea8f634000000000000000000000000000000000000000000000000001057b97179a626bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00a0f2fa6b668d3e3a57c5f140b5f9feb0d43d37a347ee01c8510000000000000000000000000000000000000000000000000012591e9b2a0bd90000000000000000000027b64bf5a32080a06c4eca278d3e3a57c5f140b5f9feb0d43d37a347ee01c8511111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000000000000000000000000000000dcb49f4be97b268000000000000000000000000000000000000000000000000000000000000002e9b3012000000000000000000000000000000000000000000000000”}	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xe0cbc5f20000000000000000000000000000000000000000000000000001828906079000000000000000000000000000000000000000000000000000000044364c5bb00000000000000000000000000091ea0c7de959282848ac68d0cda5dffd7d75763b”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“1000000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]		{“bridge”:“connext”,“receiver”:“0xac0b6fcae9326ef05ca91c341730ef62d7882f3a”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“999500000000000000”,“integrator”:“AccelDefi”,“transactionId”:“0x6ba8ab09593dc2f1139afb960229f0dd8db99b31211fc7f98afb975a885529e1”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“56”,“hasDestinationCall”:true}	2022-11-26T19:26:47.000Z	0x963b0aef1bff97b71afc135d38d047c9e9bad0f6a2a64684cca373fc6f17f873
332529	180000000000000000	true	197072	0x9c70d7e6	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16190990	0xeb814112d97d159736b8cef4da11ba1300cb6f77	{“expiry”:“1671377261”,“encodedBid”:“0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000997f29174a766a1da04cf77d135d59dd12fb54d100000000000000000000000095829c9acfecaec0ee594a377311b0937c4a28820000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000027ed9565782c00000000000000000000000000000000000000000000000000000000000000000380000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000000000000000000000000000026af02ca85f0fcf000000000000000000000000eb814112d97d159736b8cef4da11ba1300cb6f77de290b12564c3ff84fa3999c59d9ef667fda1eeccbd272cd9987ba8dc88f5ca300000000000000000000000000000000000000000000000000000000639f3164821a43b99746007c6e5fe452f9370c9563039cef189e06dc3f7d9c8bbf53a1d10000000000000000000000000baee5700179d87fabad13022447bd4e160374dd000000000000000000000000000000000000000000000000000000000000024000000000000000000000000031efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a090000000000000000000000002a9ea5e8cddf40730f4f4f839f673a51600c314e00000000000000000000000000000000000000000000000000000000639b3e1300000000000000000000000000000000000000000000000000000000000004844f91bc2bf019bfe7e7a8aa304c6c17259e26a1a73e0b837e20de21a8d379c5b44483faed00000000000000000000000000000000000000000000000000000000000000800000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000eb814112d97d159736b8cef4da11ba1300cb6f77000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000026791af2fe42e7200000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002a87c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000074e4716e431f45807dcf19f284c7aa99f18a4fbc000000000000000000000000dd1305150d27aecc60c066630105db419977e367000000000000000000000000000000000000000000000000026791af2fe42e720000000000000000000000000000000000000000000000000b8c003f4c03e30e00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e30000000000000000000000000000000000000000000000a500008f00005300206ae4071118002625a074e4716e431f45807dcf19f284c7aa99f18a4fbc0000000000000000000000000000000000000000000000000b7d258d738339642170ed0880ac9a755fd29b2688956bd959f933f84101bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00042e1a7d4d0000000000000000000000000000000000000000000000000000000000000000c0601111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000026791af2fe42e7200000000000000000000000000000000000000000000000000000000002e9b301200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“encodedMeta”:“0x”,“bidSignature”:“0x1a664043c6868be3946bd8aa7d813ec60593f61dc979c63b44e24ad716fefa1923cfa6363a4e7b7cfb412694ee69bd22a585a20788178f44e7092f1ee56955d91b”,“invariantData”:{“user”:“0x997f29174a766a1da04cf77d135d59dd12fb54d1”,“callTo”:“0x0baee5700179d87fabad13022447bd4e160374dd”,“router”:“0x95829c9acfecaec0ee594a377311b0937c4a2882”,“initiator”:“0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae”,“callDataHash”:“0x821a43b99746007c6e5fe452f9370c9563039cef189e06dc3f7d9c8bbf53a1d1”,“transactionId”:“0xde290b12564c3ff84fa3999c59d9ef667fda1eeccbd272cd9987ba8dc88f5ca3”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“sendingChainId”:“1”,“receivingAddress”:“0xeb814112d97d159736b8cef4da11ba1300cb6f77”,“receivingAssetId”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“receivingChainId”:“56”,“sendingChainFallback”:“0xeb814112d97d159736b8cef4da11ba1300cb6f77”,“receivingChainTxManagerAddress”:“0x2a9ea5e8cddf40730f4f4f839f673a51600c314e”},“encryptedCallData”:“0x4f91bc2bf019bfe7e7a8aa304c6c17259e26a1a73e0b837e20de21a8d379c5b44483faed00000000000000000000000000000000000000000000000000000000000000800000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000eb814112d97d159736b8cef4da11ba1300cb6f77000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000026791af2fe42e7200000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002a87c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000074e4716e431f45807dcf19f284c7aa99f18a4fbc000000000000000000000000dd1305150d27aecc60c066630105db419977e367000000000000000000000000000000000000000000000000026791af2fe42e720000000000000000000000000000000000000000000000000b8c003f4c03e30e00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e30000000000000000000000000000000000000000000000a500008f00005300206ae4071118002625a074e4716e431f45807dcf19f284c7aa99f18a4fbc0000000000000000000000000000000000000000000000000b7d258d738339642170ed0880ac9a755fd29b2688956bd959f933f84101bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00042e1a7d4d0000000000000000000000000000000000000000000000000000000000000000c0601111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000026791af2fe42e7200000000000000000000000000000000000000000000000000000000002e9b3012000000000000000000000000000000000000000000000000”}	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xe0cbc5f200000000000000000000000000000000000000000000000000008b2716a690000000000000000000000000000000000000000000000000000000188e6d68b000000000000000000000000000cac60e91f8bf841dd2c9a28e894fc6676a2af892”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“180000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]		{“bridge”:“connext”,“receiver”:“0xeb814112d97d159736b8cef4da11ba1300cb6f77”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“179820000000000000”,“integrator”:“VaporDEX”,“transactionId”:“0xf019bfe7e7a8aa304c6c17259e26a1a73e0b837e20de21a8d379c5b44483faed”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“56”,“hasDestinationCall”:true}	2022-12-15T15:28:23.000Z	0x448030f6216d316b25026bce80b8af72e9146b43f86b4c4273178426f6a0596d

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaOmniBridge_function

LiFi Diamond contract function calls that execute token swaps on Ethereum before bridging assets to Gnosis Chain via OmniBridge. Used for analyzing cross-chain transaction flows combining decentralized exchange (DEX) aggregation with bridge operations.

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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	transaction_hash
495402	0	true	382623	0x95726782	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16948729	0x7f0d4904908d9bd75c3347c513ca5aeef32dc859	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0xe449022e000000000000000000000000000000000000000000000000000000001ba6bdd00000000000000000000000000000000000000000000000190546c5bd8e0a1901000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000018000000000000000000000005777d92f208679db4b9778590fa3cab3ac9e21682e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“463912400”,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“requiresDeposit”:true,“receivingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”}]	{“bridge”:“omni”,“receiver”:“0x7f0d4904908d9bd75c3347c513ca5aeef32dc859”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“461548810479220693249”,“integrator”:“jumper.exchange”,“transactionId”:“0x00fa734e2d874c8b0fddeeccae7f51926030351b85b1a3a923c41eac606d0a1d”,“hasSourceSwaps”:true,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“destinationChainId”:“100”,“hasDestinationCall”:true}	2023-03-31T17:41:47.000Z	0x588c2297546e821ce361e04afb4be25180e2ad2df7137eeaa9102873fd5ff83c
514826	25000000000000000	true	330616	0x95726782	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16878875	0x0910bdbe7abb67c409f9ddd87c14667b1b715e8b	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0x12aa3caf0000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e00000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000000000000000000000000000000058d15e1762800000000000000000000000000000000000000000000000000000585fae42c9b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008600000000000000000000000000000000000000000000000000006800001a4061c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2d0e30db080206c4eca27c02aaa39b223fe8d0a0e5c4f27ead9083c756cc21111111254eeb25477b68fb85ed929f73a9605820000000000000000000000000000000000000000000000000058d15e1762800000000000000000000000000000000000000000000000000000002e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“25000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”}]	{“bridge”:“omni”,“receiver”:“0x0910bdbe7abb67c409f9ddd87c14667b1b715e8b”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“24875000000000000”,“integrator”:“jumper.exchange”,“transactionId”:“0x20791cef2370e04225ceb67ff5045f96e62c1a54417b3a54502cfd624a618ea0”,“hasSourceSwaps”:true,“sendingAssetId”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“destinationChainId”:“100”,“hasDestinationCall”:true}	2023-03-21T22:08:23.000Z	0xf19d0a56785f4e822cec864f04f3d410cac18834c25006fc071678f7b688fc1c
430161	20000000000000000	true	330616	0x95726782	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16881124	0x0ef4d51f241df229052ecdf297ebd1dc72125030	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0x12aa3caf0000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000007122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e00000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000000000470de4df8200000000000000000000000000000000000000000000000000000046b2f1cf07c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008600000000000000000000000000000000000000000000000000006800001a4061c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2d0e30db080206c4eca27c02aaa39b223fe8d0a0e5c4f27ead9083c756cc21111111254eeb25477b68fb85ed929f73a96058200000000000000000000000000000000000000000000000000470de4df82000000000000000000000000000000000000000000000000000000002e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“20000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”}]	{“bridge”:“omni”,“receiver”:“0x0ef4d51f241df229052ecdf297ebd1dc72125030”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“19900000000000000”,“integrator”:“jumper.exchange”,“transactionId”:“0xccb3aa97b480099031812389ac48f45310c59061c2afee4e579b100de63c2b0f”,“hasSourceSwaps”:true,“sendingAssetId”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“destinationChainId”:“100”,“hasDestinationCall”:true}	2023-03-22T05:41:47.000Z	0xeb729158f48b00eb6e32b99cb39873c7f20ad000b6d06aac54c1a217f0f0b528

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaOptimismBridge_function

LiFi Diamond contract function calls that swap tokens on Ethereum and bridge them to Optimism via the Optimism Bridge. Captures pre-bridge DEX swaps (1inch, Uniswap, Balancer) with source/destination token pairs, bridge parameters including L2 gas and Synthetix flag, and integrator attribution (jumper.exchange, transferto.xyz).

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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__optimismData`	`STRUCT<assetIdOnL2 STRING, l2Gas STRING, isSynthetix BOOL>`	Bridge-specific parameters for Optimism L2 transfers including gas limits and asset mappings. Contains L2 gas amount, L2 asset address, and Synthetix protocol flag for cross-layer bridging operations.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	in__optimismData	transaction_hash
1363540	0	true	366760	0x5bb5d448	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16822400	0xe6d8267cfaa4e2b39b45eb98e2a533eab0821959	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0xe449022e000000000000000000000000000000000000000000000000000000037e11d600000000000000000000000000000000000000000000000000000000037dd97192000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000018000000000000000000000003416cf6c708da44db2624d63ea0aaef7113527c62e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“15000000000”,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“requiresDeposit”:true,“receivingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}]	{“bridge”:“optimism”,“receiver”:“0xe6d8267cfaa4e2b39b45eb98e2a533eab0821959”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“14996304274”,“integrator”:“jumper.exchange”,“transactionId”:“0xd52fd57d06f1d1c56561476c64151934d0a39420eb3b3f24b96bf176732a31cf”,“hasSourceSwaps”:true,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-03-13T23:41:35.000Z	{“l2Gas”:“200000”,“assetIdOnL2”:“0x7f5c764cbc14f9669b88837ca1490cca17c31607”,“isSynthetix”:true}	0x8476640943946c94f0c260c7d6256883e6ec206a24e9e01ea7bb2fd1715ac3c3
437964	0	true	337362	0x5bb5d448	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16476304	0xb44728b211e5024cb6817dc3a1a422525db14d44	[{“callTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“callData”:“0xe449022e0000000000000000000000000000000000000000000000000000000017d78400000000000000000000000000000000000000000000000000036638ff3cc68fc50000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000120000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f56402e9b3012”,“approveTo”:“0x1111111254eeb25477b68fb85ed929f73a960582”,“fromAmount”:“400000000”,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“optimism”,“receiver”:“0xb44728b211e5024cb6817dc3a1a422525db14d44”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“244945898625732550”,“integrator”:“transferto.xyz”,“transactionId”:“0x56a8b91c322e1e5eb8fd932c08ae4f2ac09c3ab4f6a1f8de834d5581a432a679”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-01-24T11:14:35.000Z	{“l2Gas”:“200000”,“assetIdOnL2”:“0x0000000000000000000000000000000000000000”,“isSynthetix”:true}	0x2d56952fd62d2c7ada0e52813dc5a10e844460f807056bcff1481e1a1cf2bd38
538385	4000000000000000	true	416202	0x5bb5d448	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16691042	0x8b64c5802ad854135785851735f6838054a50096	[{“callTo”:“0x7a250d5630b4cf539739df2c5dacb4c659f2488d”,“callData”:“0x7ff36ab50000000000000000000000000000000000000000000000000000000000656c3900000000000000000000000000000000000000000000000000000000000000800000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000000000000000000000000000000000000063f7674e0000000000000000000000000000000000000000000000000000000000000003000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000002260fac5e5542a773aa44fbcfedf7c193bc2c599000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec7”,“approveTo”:“0x7a250d5630b4cf539739df2c5dacb4c659f2488d”,“fromAmount”:“4000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”}]	{“bridge”:“optimism”,“receiver”:“0x8b64c5802ad854135785851735f6838054a50096”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“6646841”,“integrator”:“transferto.xyz”,“transactionId”:“0xb360c8e1c1d0deef303f2cc8992d880c9c4682962d57f42e42094f4878a3aede”,“hasSourceSwaps”:true,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“destinationChainId”:“10”,“hasDestinationCall”:true}	2023-02-23T12:17:11.000Z	{“l2Gas”:“200000”,“assetIdOnL2”:“0x94b008aa00579c1307b0ef2c499ad98a8ce58e58”,“isSynthetix”:true}	0xc5bcb4afda3456a455f8cb982b466f8613df453749c1ff7616d9c426034eb821

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaPolygonBridge_function

LiFi Diamond contract function calls that swap tokens on Ethereum then bridge to Polygon using the Polygon Bridge. Used for analyzing cross-chain routing patterns, swap-to-bridge transaction flows, and LiFi protocol integration usage across DeFi aggregators.

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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	transaction_hash
423239	true	265264	0xb4f37581	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	15926160	0x552008c0f6870c2f77e5cc1d2eb9bdff03e30ea0	[{“callTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“callData”:“0x2e95b6c80000000000000000000000006b175474e89094c44da98b954eedeac495271d0f0000000000000000000000000000000000000000000000004563918244f40000000000000000000000000000000000000000000000000000000c33edf9186b040000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000140000000000000003b74a4607515be43d16f871588adc135d58a9c30a71eb34f2e9b3012”,“approveTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“fromAmount”:“5000000000000000000”,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“requiresDeposit”:true,“receivingAssetId”:“0x0000000000000000000000000000000000000000”}]	{“bridge”:“polygon”,“receiver”:“0x552008c0f6870c2f77e5cc1d2eb9bdff03e30ea0”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“3434796899920645”,“integrator”:“staging.transferto.xyz”,“transactionId”:“0xc5c0fd98a243ad8037b9c516ec9cff766008046525ab4d84e5e11e36a625e8e1”,“hasSourceSwaps”:true,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2022-11-08T15:17:47.000Z	0xf315f86c2b61a616387668b7c01d5c5f997075c2e7877094da828ab48873d752
296884	false	274691	0xb4f37581	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16451694	0x5a9765338181171c30dc3c64452d8f9e59f177ea	[]		2023-01-21T00:47:59.000Z	0x58cd2fb9e251bfc666f25bbd1a51279d49f21f441a63f652ad9fe6ff179e4016
406279	true	309203	0xb4f37581	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16598008	0x1c5068e0d1031b3b0c4932f4c0b71708e17f1367	[{“callTo”:“0xdef1c0ded9bec7f1a1670819833240f027b25eff”,“callData”:“0x6af479b2000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000e951ffac6e4140000000000000000000000000000000000000000000000000000000000000408bf560000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002bf1ca9cb74685755965c7458528a36934df52a3ef000bb8dac17f958d2ee523a2206206994597c13d831ec7000000000000000000000000000000000000000000869584cd00000000000000000000000010000000000000000000000000000000000000110000000000000000000000000000000000000000000000723c6fea7a63e627e2”,“approveTo”:“0xdef1c0ded9bec7f1a1670819833240f027b25eff”,“fromAmount”:“269000000000000000000”,“sendingAssetId”:“0xf1ca9cb74685755965c7458528a36934df52a3ef”,“requiresDeposit”:true,“receivingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”}]	{“bridge”:“polygon”,“receiver”:“0x1c5068e0d1031b3b0c4932f4c0b71708e17f1367”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“67682135”,“integrator”:“transferto.xyz”,“transactionId”:“0xad6cea29fcb6b7c8dee0408ee13fc5bad821ea0658a702bb5ddd7a840d2bf5a0”,“hasSourceSwaps”:true,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2023-02-10T11:18:11.000Z	0x3749a22ca45d7352be644149152e95696e7e5cbc2654ce0bd39b463eb7a4db1f

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaStargate_function

Cross-chain bridge transactions via LiFi’s Stargate integration on Ethereum, capturing token swaps before bridging to destination chains like Polygon, Arbitrum, and BSC. Includes swap parameters, bridge configuration, LayerZero fees, and destination routing data 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.
`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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.
`in__stargateData`	`STRUCT<dstPoolId STRING, minAmountLD STRING, dstGasForCall STRING, lzFee STRING, refundAddress STRING, callTo STRING, callData STRING>`	LayerZero fee paid for cross-chain message delivery via Stargate bridge, denominated in wei. Null when the transaction fails or lacks bridge parameters.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	in__stargateData	transaction_hash
955347	19642566694033	true	611590	0xd7556c1e	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	15980612	0x981950b01874bd66997598c0013c626e740736c6	[{“callTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“callData”:“0xeedd56e10000000000000000000000006b175474e89094c44da98b954eedeac495271d0f00000000000000000000000000000000000000000000000000051973a0e86a240000000000000000000000000000000000000000000000000000e65fb2fbd67e000000000000000000000000d5e230cea6da2f0c62bdeed2cf85326f1063e27d”,“approveTo”:“0xbd6c7b0d2f68c2b7805d88388319cfb6ecb50ea9”,“fromAmount”:“1688657994203298785”,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“requiresDeposit”:true,“receivingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”},{“callTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“callData”:“0x2e95b6c80000000000000000000000006b175474e89094c44da98b954eedeac495271d0f000000000000000000000000000000000000000000000000176951ac5fb83b3f000000000000000000000000000000000000000000000000000000000018e6d80000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000100000000000000003b6d0340b20bd5d04be54f870d5c0d3ca85d82b34b8364052e9b3012”,“approveTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“fromAmount”:“1686969336209095487”,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“requiresDeposit”:false,“receivingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”}]	{“bridge”:“stargate”,“receiver”:“0x981950b01874bd66997598c0013c626e740736c6”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“1631961”,“integrator”:“obvious.technology”,“transactionId”:“0x9b94d6f8829f9268bfcfd78d4f02603f422377fd555ba00b8cee7edc2454b12f”,“hasSourceSwaps”:true,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2022-11-16T05:50:59.000Z	{“lzFee”:“19642566694033”,“callTo”:“0x981950b01874bd66997598c0013c626e740736c6”,“callData”:“0x”,“dstPoolId”:“1”,“minAmountLD”:“1580751”,“dstGasForCall”:“0”,“refundAddress”:“0x552008c0f6870c2f77e5cc1d2eb9bdff03e30ea0”}	0xda36e398b102c6de78703867409e7f4de42e6c2652f41e01d324d16346f4b621
1507040	20255189548254	true	971989	0xd7556c1e	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	15981292	0x29bf02c855fabe805c2f74d8f4be02d060e1306f	[{“callTo”:“0xdef1c0ded9bec7f1a1670819833240f027b25eff”,“callData”:“0x415565b00000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c53000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000010f0cf064dd592000000000000000000000000000000000000000000000000000000000000128d7656000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000460000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c53000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000420000000000000000000000000000000000000000000000000000000000000042000000000000000000000000000000000000000000000000000000000000003e000000000000000000000000000000000000000000000010f0cf064dd5920000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000420000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000001942616c616e636572563200000000000000000000000000000000000000000000000000000000010f0cf064dd592000000000000000000000000000000000000000000000000000000000000128d76560000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001c0000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c80000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020bd482ffb3e6e50dc1c437557c3bea2b68f3683ee0000000000000000000003c600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c53000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000020000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c53000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000000000869584cd000000000000000000000000100000000000000000000000000000000000001100000000000000000000000000000000000000000000008b1e5b247563749a60”,“approveTo”:“0xdef1c0ded9bec7f1a1670819833240f027b25eff”,“fromAmount”:“5000000000000000000000”,“sendingAssetId”:“0x4fabb145d64652a948d72533023f6e7a623c7c53”,“requiresDeposit”:true,“receivingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}]	{“bridge”:“stargate”,“receiver”:“0x29bf02c855fabe805c2f74d8f4be02d060e1306f”,“referrer”:“0x0000000000000000000000000000000000000001”,“minAmount”:“4980172128”,“integrator”:“transferto.xyz”,“transactionId”:“0xd1770560218ec60d672da96decd05366acd39ceed1ea5f882244a8b5a59baba6”,“hasSourceSwaps”:true,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2022-11-16T08:08:11.000Z	{“lzFee”:“20255189548254”,“callTo”:“0x29bf02c855fabe805c2f74d8f4be02d060e1306f”,“callData”:“0x”,“dstPoolId”:“1”,“minAmountLD”:“4949363174”,“dstGasForCall”:“0”,“refundAddress”:“0x552008c0f6870c2f77e5cc1d2eb9bdff03e30ea0”}	0x039cf8c139b4ef5cb6272b6d837807743c57a22798984887400f56b5cac9ee48
1516827	33091015422660	true	979592	0xd7556c1e	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	15981331	0x29bf02c855fabe805c2f74d8f4be02d060e1306f	[{“callTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“callData”:“0x7c02520000000000000000000000000053222470cdcfb8081c0e3a50fd106f0d69e63f20000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000004fabb145d64652a948d72533023f6e7a623c7c53000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec700000000000000000000000053222470cdcfb8081c0e3a50fd106f0d69e63f200000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae00000000000000000000000000000000000000000000021e19e0c9bab24000000000000000000000000000000000000000000000000000000000000251be80be000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000017700000000000000000000000000000000000000000000013900010b0000c100a007e5c0d200000000000000000000000000000000000000000000000000009d00006300a0fbb7cd0680bd482ffb3e6e50dc1c437557c3bea2b68f3683ee0000000000000000000003c64fabb145d64652a948d72533023f6e7a623c7c536b175474e89094c44da98b954eedeac495271d0f3058ef90929cb8180174d74c507176cca6835d7340203058ef90929cb8180174d74c507176cca6835d73bd6015b400000000000000000000000053222470cdcfb8081c0e3a50fd106f0d69e63f2000a0f2fa6b66dac17f958d2ee523a2206206994597c13d831ec70000000000000000000000000000000000000000000000000000000254ba5082000000000000000000000000004c4b4080a06c4eca27dac17f958d2ee523a2206206994597c13d831ec71111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000021e19e0c9bab24000000000000000000000002e9b3012”,“approveTo”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“fromAmount”:“10000000000000000000000”,“sendingAssetId”:“0x4fabb145d64652a948d72533023f6e7a623c7c53”,“requiresDeposit”:true,“receivingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”}]	{“bridge”:“stargate”,“receiver”:“0x29bf02c855fabe805c2f74d8f4be02d060e1306f”,“referrer”:“0x0000000000000000000000000000000000000001”,“minAmount”:“9961852231”,“integrator”:“transferto.xyz”,“transactionId”:“0xc4b9c6926f4fbb40e0e24448e128be5c237a3f4a788ae32cdba8e2fcb595d9f9”,“hasSourceSwaps”:true,“sendingAssetId”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“destinationChainId”:“137”,“hasDestinationCall”:true}	2022-11-16T08:15:59.000Z	{“lzFee”:“33091015422660”,“callTo”:“0x29bf02c855fabe805c2f74d8f4be02d060e1306f”,“callData”:“0x”,“dstPoolId”:“1”,“minAmountLD”:“9896911444”,“dstGasForCall”:“0”,“refundAddress”:“0x552008c0f6870c2f77e5cc1d2eb9bdff03e30ea0”}	0x13ca1b5e86e6f503f28b5613e226fc21e597bc64c48ddca9f699b894449faf46

Example Query

Query with partition filter

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

LiFiDiamond_swapAndStartBridgeTokensViaXDaiBridge_function

Cross-chain transaction records from LiFi protocol executing token swaps on Ethereum before bridging to Gnosis Chain (xDai) via the xDai Bridge. Contains swap parameters, bridge configuration, and transaction metadata for analyzing cross-chain DEX aggregator 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.
`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`	`NUMERIC`	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`	`INT64`	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__bridgeData`	`STRUCT<transactionId STRING, bridge STRING, integrator STRING, referrer STRING, sendingAssetId STRING, receiver STRING, minAmount STRING, destinationChainId STRING, hasSourceSwaps BOOL, hasDestinationCall BOOL>`	Structured bridge transaction parameters including transaction identifier, bridge protocol name, integrator identifier, optional referrer address, token contract addresses for source and destination assets, receiver address, minimum acceptable amount, destination blockchain identifier, and boolean flags indicating presence of token swaps and destination calls.
`in__swapData`	`ARRAY<STRUCT<callTo STRING, approveTo STRING, sendingAssetId STRING, receivingAssetId STRING, fromAmount STRING, callData STRING, requiresDeposit BOOL>>`	Array of token swap operations to execute before the bridge transaction. Each element contains contract addresses for execution and approval, source and destination token addresses, swap amount, encoded swap calldata, and a flag indicating whether the token requires deposit.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	in__swapData	in__bridgeData	block_timestamp	transaction_hash
357749	0	true	223227	0xa9d0550f	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16220439	0x1ddd4ed1a09ba91e03081f121a69a20210934710	[{“callTo”:“0x7a250d5630b4cf539739df2c5dacb4c659f2488d”,“callData”:“0x38ed173900000000000000000000000000000000000000000000000000000000053150b0000000000000000000000000000000000000000000000004b08c518b1229100000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000000000000000000000000000000000000063a0b46f0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000006b175474e89094c44da98b954eedeac495271d0f”,“approveTo”:“0x7a250d5630b4cf539739df2c5dacb4c659f2488d”,“fromAmount”:“87118000”,“sendingAssetId”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“requiresDeposit”:true,“receivingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”}]	{“bridge”:“gnosis”,“receiver”:“0x1ddd4ed1a09ba91e03081f121a69a20210934710”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“86508609000000000000”,“integrator”:“transferto.xyz”,“transactionId”:“0x1fdd18f5bffde7b4d53c54b5ff86d5565cd559f5ecb76443115d85289fa4816d”,“hasSourceSwaps”:true,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“destinationChainId”:“100”,“hasDestinationCall”:true}	2022-12-19T18:08:59.000Z	0xb5f08759b8eb962182a69a79d85734b2209fd6e53007dfb8f629c6810153a2aa
357749	0	false	51987	0xa9d0550f	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16220439	0x1ddd4ed1a09ba91e03081f121a69a20210934710	[]		2022-12-19T18:08:59.000Z	0x806ad2f49ebdefcfaf94a9a3e2bf9de810f6392414e229cd44aab6d986082fbe
290523	10000000000000000	true	221119	0xa9d0550f	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	16539037	0xe3d37b1b353fee1e7bba0f09963bd6802ff2f1e9	[{“callTo”:“0x7a250d5630b4cf539739df2c5dacb4c659f2488d”,“callData”:“0x7ff36ab5000000000000000000000000000000000000000000000000e70e0ec76cf750c600000000000000000000000000000000000000000000000000000000000000800000000000000000000000001231deb6f5749ef6ce6943a275a1d3e7486f4eae0000000000000000000000000000000000000000000000000000000063db58020000000000000000000000000000000000000000000000000000000000000002000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000006b175474e89094c44da98b954eedeac495271d0f”,“approveTo”:“0x7a250d5630b4cf539739df2c5dacb4c659f2488d”,“fromAmount”:“10000000000000000”,“sendingAssetId”:“0x0000000000000000000000000000000000000000”,“requiresDeposit”:true,“receivingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”}]	{“bridge”:“gnosis”,“receiver”:“0xe3d37b1b353fee1e7bba0f09963bd6802ff2f1e9”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“16649261122124730566”,“integrator”:“transferto.xyz”,“transactionId”:“0x988db27b1cf7c0e1fd0b6cbe1d19f4f559dba14a1e6e7f377d7897a7f8cc2201”,“hasSourceSwaps”:true,“sendingAssetId”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“destinationChainId”:“100”,“hasDestinationCall”:true}	2023-02-02T05:28:59.000Z	0x235013a8194c0980766b68fa174d085072c0323270d0ecc581283ef8e90f80d5

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

GenericSwapFacet_LiFiSwappedGeneric_event

GenericSwapFacet_LiFiTransferStarted_event

HyphenFacet_LiFiTransferStarted_event

LiFiDiamond_LiFiSwappedGeneric_event

LiFiDiamond_LiFiTransferStarted_event

LiFiDiamond_swapAndStartBridgeTokensViaAcross_function

LiFiDiamond_swapAndStartBridgeTokensViaAmarok_function

LiFiDiamond_swapAndStartBridgeTokensViaArbitrumBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaCBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaHop_function

LiFiDiamond_swapAndStartBridgeTokensViaHopL1ERC20_function

LiFiDiamond_swapAndStartBridgeTokensViaHopL1Native_function

LiFiDiamond_swapAndStartBridgeTokensViaHyphen_function

LiFiDiamond_swapAndStartBridgeTokensViaMultichain_function

LiFiDiamond_swapAndStartBridgeTokensViaNXTP_function

LiFiDiamond_swapAndStartBridgeTokensViaOmniBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaOptimismBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaPolygonBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaStargate_function

LiFiDiamond_swapAndStartBridgeTokensViaXDaiBridge_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​GenericSwapFacet_LiFiSwappedGeneric_event

​GenericSwapFacet_LiFiTransferStarted_event

​HyphenFacet_LiFiTransferStarted_event

​LiFiDiamond_LiFiSwappedGeneric_event

​LiFiDiamond_LiFiTransferStarted_event

​LiFiDiamond_swapAndStartBridgeTokensViaAcross_function

​LiFiDiamond_swapAndStartBridgeTokensViaAmarok_function

​LiFiDiamond_swapAndStartBridgeTokensViaArbitrumBridge_function

​LiFiDiamond_swapAndStartBridgeTokensViaCBridge_function

​LiFiDiamond_swapAndStartBridgeTokensViaHop_function

​LiFiDiamond_swapAndStartBridgeTokensViaHopL1ERC20_function

​LiFiDiamond_swapAndStartBridgeTokensViaHopL1Native_function

​LiFiDiamond_swapAndStartBridgeTokensViaHyphen_function

​LiFiDiamond_swapAndStartBridgeTokensViaMultichain_function

​LiFiDiamond_swapAndStartBridgeTokensViaNXTP_function

​LiFiDiamond_swapAndStartBridgeTokensViaOmniBridge_function

​LiFiDiamond_swapAndStartBridgeTokensViaOptimismBridge_function

​LiFiDiamond_swapAndStartBridgeTokensViaPolygonBridge_function

​LiFiDiamond_swapAndStartBridgeTokensViaStargate_function

​LiFiDiamond_swapAndStartBridgeTokensViaXDaiBridge_function

Tables

GenericSwapFacet_LiFiSwappedGeneric_event

GenericSwapFacet_LiFiTransferStarted_event

HyphenFacet_LiFiTransferStarted_event

LiFiDiamond_LiFiSwappedGeneric_event

LiFiDiamond_LiFiTransferStarted_event

LiFiDiamond_swapAndStartBridgeTokensViaAcross_function

LiFiDiamond_swapAndStartBridgeTokensViaAmarok_function

LiFiDiamond_swapAndStartBridgeTokensViaArbitrumBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaCBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaHop_function

LiFiDiamond_swapAndStartBridgeTokensViaHopL1ERC20_function

LiFiDiamond_swapAndStartBridgeTokensViaHopL1Native_function

LiFiDiamond_swapAndStartBridgeTokensViaHyphen_function

LiFiDiamond_swapAndStartBridgeTokensViaMultichain_function

LiFiDiamond_swapAndStartBridgeTokensViaNXTP_function

LiFiDiamond_swapAndStartBridgeTokensViaOmniBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaOptimismBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaPolygonBridge_function

LiFiDiamond_swapAndStartBridgeTokensViaStargate_function

LiFiDiamond_swapAndStartBridgeTokensViaXDaiBridge_function