cosmos.core Table: fact_transfers Type: View
Records of all transfers on Cosmos from chain version 4 and beyond. (This info may be available in
the msgs column in core.fact_transactions, but we are not parsing it out at this time.)
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 went through, “FALSE” if the transaction failed. |
| TRANSFER_TYPE | TEXT | Details on the type of transfer occurring during the transaction. “Transfer_In” = depositing tokens onto the Cosmos Hub. “Transfer_out” = withdrawing tokens from the Cosmos Hub. “Cosmos” = wallet to wallet transfer on the Cosmos Hub. |
| 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. |
| RECEIVER | TEXT | The wallet address of the individual received tokens in the transfer. |
| UNIQUE_KEY | TEXT | The unique key for the table. |
| FACT_TRANSFERS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |