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.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_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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.lifi_v1_avalanche.LiFiDiamond_LiFiTransferCompleted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100