> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Transactions

### 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. |