osmosis.core Table: fact_transfers Type: View
Records of all transfers on Osmosis, including IBC transfers as on- and off-ramps to Osmosis and
wallet to wallet transfers.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| TX_ID | TEXT | A unique key that identifies a transaction. Called “TxHash” on block explorers. |
| TX_SUCCEEDED | BOOLEAN | Transaction status is “TRUE” if the transaction was successful, “FALSE” if the transaction failed. |
| TRANSFER_TYPE | TEXT | Details on the type of transfer occurring during the transaction. “IBC_Transfer_In” = depositing tokens onto Osmosis. “IBC_transfer_out” = withdrawing tokens from Osmosis. “Osmosis” = wallet to wallet transfer on Osmosis. |
| SENDER | TEXT | The wallet address of the individual sent tokens in the transfer. |
| AMOUNT | NUMBER | The amount that was used in the transaction message. |
| CURRENCY | TEXT | The currency that was used in the transaction message. |
| DECIMAL | NUMBER | Divide the amount by POW(10, decimal) to get the amount used in the transaction. This value can be NULL, as decimals are hand curated from an outside source and not found on-chain. |
| RECEIVER | TEXT | The wallet address of the individual received tokens in the transfer. |
| FOREIGN_ADDRESS | TEXT | The foreign address of the transfer if exists. This can be an IBC address or other non-IBC address |
| FOREIGN_CHAIN | TEXT | The name of the foreign chain transfer if exists |
| FACT_TRANSFERS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |