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

> Tables in tt-contracts.lifi_v1_avalanche

## 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   | 541925005721443721   | 30         | 0xd6fd3928b07710d7f77d31f8747f756da0de2aff | 15499144      | 1654165905    | 2022-06-02T10:31:45.000Z | 0x7bdaa2c7b6862d16e5bb456914c486a7e1d0d5a7fee012e5beaf53d2213c4cc2 | 0x4cc7d2f5d7b356aae1e61f9977dcac156a610f729e9ff0ab179127fd3254c821 | 0x0000000000000000000000000000000000000000 |
  | 0x362fa9d0bca5d19f743db50738345ce2b40ec99f | false   | 1040090763656369477  | 16         | 0xd122f221d9c56afac72b04ddc48f415e540376eb | 15496649      | 1654160869    | 2022-06-02T09:07:49.000Z | 0x8a7f48a31481a98c390507b338b7f14fa656ca71b798dd5fb50fade7a358b006 | 0xa26299f7bf133cf368a5dcf3f7cf2791322abd7122d664076db7e63dc4aeca37 | 0x0000000000000000000000000000000000000000 |
  | 0x362fa9d0bca5d19f743db50738345ce2b40ec99f | false   | 25965575507009304051 | 27         | 0x7b556b32552311ac11cecd2488b159fa77929f4d | 15504627      | 1654176923    | 2022-06-02T13:35:23.000Z | 0x2f5ecf28e96bb1c6fa883cf45c4f30b5a717eac3d4a3d8c5f3d132918f50a6bf | 0xed62d76b920293ca72245542e89a0f9ca98acf7f76a1dbe65478b740fdd47ef3 | 0x0000000000000000000000000000000000000000 |
</Accordion>

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

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

***