Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin.raw.transactions |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, hash |
| 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).Virtual size is a way of measuring the size of a transaction that takes into account the amount of data needed to create the transaction, as well as the priority of the transaction. |
| version | NUMBER(38,0) | The transaction version number. |
| lock_time | NUMBER(38,0) | The transaction lock time. |
| fee | FLOAT | The transaction fee paid to the miner in bitcoin. Calculated by the substracting the input_value with the output_value. |
| weight | NUMBER(38,0) | Transaction or block weight in weight units (WU), computed as stripped_size × 3 + total_size. Determines fee priority after SegWit. |
| index | NUMBER(38,0) | The unique index identifier for the perpetual market on Hyperliquid. |
| block_hash | VARCHAR(66) | Unique hash of the transaction. |
| block_number | NUMBER(38,0) | Block hash of the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block number or block height of the transaction input. |
| 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 satoshi. |
| is_coinbase | BOOLEAN | The transaction is a coinbase transaction, which is the first transaction in a block |
| _stg_created_at | TIMESTAMP_NTZ(9) | Internal staging timestamp recording when this row was first written to the staging layer. |
| _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. |