Tables
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
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
Sample Data
| address | removed | log_index | block_number | in_bridgeData | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | false | 29 | 25753151 | {“bridge”:“cbridge”,“receiver”:“0x1082e1c4a9c9f946ba102667a14f206c0f81e147”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“24910000000000000”,“integrator”:“metamask-bridge”,“transactionId”:“0x46bb7391607ec0c971b3eac549caec95032b0b6b78e75adf6cea6f8eaf85615c”,“hasSourceSwaps”:true,“sendingAssetId”:“0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab”,“destinationChainId”:“1”,“hasDestinationCall”:true} | 2023-02-02T21:34:12.000Z | 0x38a1428828be1d6fbd0d5c68d6b864025f3c7e622923c9f17b967c9847c7b21d |
| 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | false | 15 | 25741390 | {“bridge”:“cbridge”,“receiver”:“0x53edae248e79d7298fcb2071a7e607a75f51cbb2”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“130410000000000000”,“integrator”:“metamask-bridge”,“transactionId”:“0x1f52917efc26cb515d55426874310dd85656defa1a24aaf68eb2c17d5c41e485”,“hasSourceSwaps”:true,“sendingAssetId”:“0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab”,“destinationChainId”:“1”,“hasDestinationCall”:true} | 2023-02-02T15:03:03.000Z | 0x44fa9550ca1dc06a07a74058445242c741b7589fa966cc3be8cbcdc226a9b7b0 |
| 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | false | 10 | 25732628 | {“bridge”:“connext”,“receiver”:“0x7cfea92056365bd2fb62c9de1fbb048b75911b62”,“referrer”:“0x0000000000000000000000000000000000000000”,“minAmount”:“32813000000000000”,“integrator”:“metamask-bridge”,“transactionId”:“0x6390104dc3af2eb1a25835596fac6f5f881cacb7dc9d6d8bd861a5256edb75f4”,“hasSourceSwaps”:true,“sendingAssetId”:“0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab”,“destinationChainId”:“1”,“hasDestinationCall”:true} | 2023-02-02T10:13:53.000Z | 0xe5fe6e2b819c598e9c9e0a7ddb7b2fa50b530f238e234211943509f12dfffc26 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.lifi_v2_avalanche.LiFiDiamond_LiFiTransferStarted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100