> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# lifi_v1_ethereum

> Tables in tt-contracts.lifi_v1_ethereum

## Tables

### LiFiDiamond\_LiFiTransferCompleted\_event

Cross-chain transfer completion events from LiFi Diamond proxy contracts recording finalized asset deliveries. Contains receiver address, asset identifier, transferred amount, and cross-chain transaction identifier for tracking bridge settlement status.

<Accordion title="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_receivingAssetId` | `STRING`    | Contract address of the asset being received in the transaction. Hex-encoded, 0x-prefixed, 42-character string, or 0x0000000000000000000000000000000000000000 for native tokens. |
  | `in_receiver`         | `STRING`    | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                            |
  | `in_amount`           | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                                                  |
  | `in_timestamp`        | `STRING`    | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.                                                                       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount          | log\_index | in\_receiver                               | block\_number | in\_timestamp | block\_timestamp         | in\_transactionId                                                  | transaction\_hash                                                  | in\_receivingAssetId                       |
  | ------------------------------------------ | ------- | ------------------- | ---------- | ------------------------------------------ | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
  | 0x362fa9d0bca5d19f743db50738345ce2b40ec99f | false   | 1429074940956550197 | 72         | 0x3969095577e902dfccdbff04fd16f93f4d6539d8 | 15281636      | 1659693589    | 2022-08-05T09:59:49.000Z | 0x2fafe46b9b9c42cbc4c53d2afb410cc93b58a42742a19bba2f5947ddabdf7870 | 0xe987f9044ab268d058317010cd6c6435c462b4ccca914cafae6b44c9fa9716ec | 0x514910771af9ca656af840dff83e8264ecf986ca |
  | 0x362fa9d0bca5d19f743db50738345ce2b40ec99f | false   | 1331067519211226199 | 25         | 0x3969095577e902dfccdbff04fd16f93f4d6539d8 | 15281581      | 1659692859    | 2022-08-05T09:47:39.000Z | 0x209f7f04300979b5b6cc13f633bad64ae67ad63c5d967bb9032106687c4c9cee | 0xbe28c86a77b76a748097df6ccd012da69d3477d97cdd88feed7da6128c3e746d | 0x514910771af9ca656af840dff83e8264ecf986ca |
  | 0x362fa9d0bca5d19f743db50738345ce2b40ec99f | false   | 532570200           | 23         | 0x8ff946337fe90bbcf52f0605152e91da63348d58 | 15731657      | 1665573167    | 2022-10-12T11:12:47.000Z | 0xacc3e54548b41aeb46d0615128ce0feb17f7385f60651b17341c910188b06880 | 0x0e0d214606113666f40380ecbfc1480163583c93120d5c65caa353f5a1ae8797 | 0xdac17f958d2ee523a2206206994597c13d831ec7 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.lifi_v1_ethereum.LiFiDiamond_LiFiTransferCompleted_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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_bridge`             | `STRING`    | Name of the bridge protocol used to facilitate the cross-chain transfer. String value identifying the bridge service such as hop, nxtp, or across.                                                                                                                                                                                                 |
  | `in_bridgeData`         | `STRING`    | 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. |
  | `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_sendingAssetId`     | `STRING`    | Contract address of the asset being sent in the transaction. Hex-encoded, 0x-prefixed, 42-character string, or 0x0000000000000000000000000000000000000000 for native tokens.                                                                                                                                                                       |
  | `in_receivingAssetId`   | `STRING`    | Contract address of the asset being received in the transaction. Hex-encoded, 0x-prefixed, 42-character string, or 0x0000000000000000000000000000000000000000 for native tokens.                                                                                                                                                                   |
  | `in_receiver`           | `STRING`    | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                                                                              |
  | `in_amount`             | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                                                                                                                                                                                                                    |
  | `in_destinationChainId` | `STRING`    | Chain identifier for the destination blockchain where tokens or messages will be received. Numeric string representing the standard chain ID.                                                                                                                                                                                                      |
  | `in_hasSourceSwap`      | `BOOL`      | Boolean flag indicating whether a token swap was executed on the source chain before initiating the bridge transfer.                                                                                                                                                                                                                               |
  | `in_hasDestinationCall` | `BOOL`      | Boolean flag indicating whether a smart contract call will be executed on the destination chain after the bridge transfer completes.                                                                                                                                                                                                               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_amount          | in\_bridge | log\_index | in\_receiver                               | in\_referrer                               | block\_number | in\_bridgeData | in\_integrator | block\_timestamp         | in\_hasSourceSwap | in\_transactionId                                                  | transaction\_hash                                                  | in\_sendingAssetId                         | in\_receivingAssetId                       | in\_destinationChainId | in\_hasDestinationCall |
  | ------------------------------------------ | ------- | ------------------- | ---------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | -------------- | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------------------- | ---------------------- |
  | 0x362fa9d0bca5d19f743db50738345ce2b40ec99f | false   | 2100000000          | hop        | 72         | 0x8ee3fc743653bc3854a71fb06505ba4c988a3148 | 0x0000000000000000000000000000000000000000 | 15127860      |                | transferto.xyz | 2022-07-12T12:40:44.000Z | false             | 0xabd8291189a6a498b183bc61a2dad503a4fb24f6657b9294d15524575ba174a7 | 0x07b3c216762e08b228dffc4f17c696f9765ee2a75febed91c278a1dc56e3b7b0 | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0x94b008aa00579c1307b0ef2c499ad98a8ce58e58 | 10                     | false                  |
  | 0x362fa9d0bca5d19f743db50738345ce2b40ec99f | false   | 1048700000000000000 | hop        | 434        | 0xe5a38fc94b755ff042fdf7078318fad205a16c08 | 0x0000000000000000000000000000000000000000 | 15126435      |                | transferto.xyz | 2022-07-12T07:09:00.000Z | false             | 0x4fd9afff033fb9d01ccc31b41966d4933deca310a847dd6290dd9916ec82dce5 | 0x1be1eb0d0508b6811837cd2cdcabbd2f53153e0bccca5ace9510cd69fc101ce2 | 0x0000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000 | 10                     | false                  |
  | 0x362fa9d0bca5d19f743db50738345ce2b40ec99f | false   | 5000000             | across     | 230        | 0x552008c0f6870c2f77e5cc1d2eb9bdff03e30ea0 | 0x0000000000000000000000000000000000000000 | 15128420      |                | transferto.xyz | 2022-07-12T14:40:57.000Z | false             | 0x8a833947099152b5bc827de548a459d6ec86035bd6e529c3910dc1e275ad1d67 | 0xf931c22a6352b4f23ed0158ca16ef62dff7fdc9f3850ad137df708111432a2c4 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 | 10                     | false                  |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.lifi_v1_ethereum.LiFiDiamond_LiFiTransferStarted_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***