Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin_cash.raw.transactions |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, hash |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | hash |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| hash | VARCHAR(66) | Transaction hash. |
| size | NUMBER(38,0) | The serialized transaction size. |
| virtual_size | NUMBER(38,0) | The virtual transaction size (differs from size for witness transactions). |
| version | NUMBER(38,0) | The transaction version number. |
| lock_time | NUMBER(38,0) | The transaction lock time. |
| index | NUMBER(38,0) | The index of the transaction within the block. |
| block_hash | VARCHAR(66) | Block hash of the transaction. |
| block_number | NUMBER(38,0) | Block number or block height of the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the transaction. |
| input_count | NUMBER(38,0) | The total number of inputs in the transaction. |
| output_count | NUMBER(38,0) | The total number of outputs in the transaction. |
| output_value | NUMBER(38,0) | Total value of outputs in the transaction in sats. One sat = 1e-8 BCH. |
| is_coinbase | BOOLEAN | Whether the transaction is a coinbase transaction, which is the first transaction in a block. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| output_value_str | VARCHAR(16777216) | String of the total output value of the transaction in sats. One sat = 1e-8 BCH. |
| output_value_float | FLOAT | The total output value of the transaction as a float in sats. One sat = 1e-8 BCH. |
| txid | VARCHAR(16777216) | Transaction ID (the non-witness transaction hash). |