Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the blockโ€™s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the blockโ€™s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_transactionIdSTRINGUnique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
in_receivingAssetIdSTRINGContract address of the asset being received in the transaction. Hex-encoded, 0x-prefixed, 42-character string, or 0x0000000000000000000000000000000000000000 for native tokens.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_timestampSTRINGUnix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
addressremovedin_amountlog_indexin_receiverblock_numberin_timestampblock_timestampin_transactionIdtransaction_hashin_receivingAssetId
0x362fa9d0bca5d19f743db50738345ce2b40ec99ffalse541925005721443721300xd6fd3928b07710d7f77d31f8747f756da0de2aff1549914416541659052022-06-02T10:31:45.000Z0x7bdaa2c7b6862d16e5bb456914c486a7e1d0d5a7fee012e5beaf53d2213c4cc20x4cc7d2f5d7b356aae1e61f9977dcac156a610f729e9ff0ab179127fd3254c8210x0000000000000000000000000000000000000000
0x362fa9d0bca5d19f743db50738345ce2b40ec99ffalse1040090763656369477160xd122f221d9c56afac72b04ddc48f415e540376eb1549664916541608692022-06-02T09:07:49.000Z0x8a7f48a31481a98c390507b338b7f14fa656ca71b798dd5fb50fade7a358b0060xa26299f7bf133cf368a5dcf3f7cf2791322abd7122d664076db7e63dc4aeca370x0000000000000000000000000000000000000000
0x362fa9d0bca5d19f743db50738345ce2b40ec99ffalse25965575507009304051270x7b556b32552311ac11cecd2488b159fa77929f4d1550462716541769232022-06-02T13:35:23.000Z0x2f5ecf28e96bb1c6fa883cf45c4f30b5a717eac3d4a3d8c5f3d132918f50a6bf0xed62d76b920293ca72245542e89a0f9ca98acf7f76a1dbe65478b740fdd47ef30x0000000000000000000000000000000000000000
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