osmosis.core Table: fact_transactions Type: View
Records of all transactions that have occurred on Osmosis, dating back to the genesis block.
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 was successful, “FALSE” if the transaction failed. |
| CODESPACE | TEXT | Namespace for the code. |
| FEE | TEXT | The fee is paid by the initiator of the transaction. Fee = gas * gas price and is given in micro-OSMO. |
| 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. |
| MSGS | VARIANT | The underlying json from the messages or events within the transactions |
| FACT_TRANSACTIONS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |