cosmos.core Table: fact_transactions Type: View
Records of all transactions that have occurred on Cosmos, dating back to the genesis block. NOTE -
FOR CHAIN VERSIONS 1-3 THE TX_FROM, FEE, AND FEE_DENOM COLUMNS ARE ALWAYS NULL. (This info may be
available in the msgs column, 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_FROM | TEXT | The wallet address of the individual who initiated the transaction |
| TX_SUCCEEDED | BOOLEAN | Transaction status is “TRUE” if the transaction went through, “FALSE” if the transaction failed. |
| CODESPACE | VARIANT | Namespace for the code. |
| FEE | TEXT | The fee is paid by the initiator of the transaction. Fee = gas * gas price. |
| FEE_DENOM | TEXT | The denominator of the transaction fee. |
| GAS_USED | NUMBER | The amount of gas consumed by the transaction. |
| GAS_WANTED | NUMBER | Amount of gas requested for a transaction. It is provided by users when the transaction is generated. |
| TX_CODE | NUMBER | A number that corresponds to various error codes. When “0”, the transaction is successful. Non-zero numbers signify different types of transaction failures. |
| TX_LOG | TEXT | A string that contains the transaction logs, which are logs written by the program interacted with during the transaction. |
| MSGS | VARIANT | The underlying json from the messages or events within the transactions |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| UNIQUE_KEY | TEXT | The unique key for the table. |
| FACT_TRANSACTIONS_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. |