Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin.raw.outputs |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, transaction_hash, index |
| Clustering Key(s) | block_timestamp::date, index |
| Search Optimization | utxo_id, transaction_hash, address0 |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| script_asm | VARCHAR(16777216) | Symbolic representation of the bitcoin’s script language op-codes |
| script_hex | VARCHAR(16777216) | Hexadecimal representation of the bitcoin’s script language op-codes. |
| type | VARCHAR(16777216) | The addres type of output. |
| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| index | NUMBER(38,0) | The index of the output. |
| transaction_hash | VARCHAR(66) | Unique hash of the transaction output. |
| block_hash | VARCHAR(66) | Block hash of the transaction output. |
| block_number | NUMBER(38,0) | Block number or block height of the transaction output. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the transaction output. |
| value | NUMBER(38,0) | Value in BTC unnormalized. |
| utxo_id | VARCHAR(73) | Spent UTXO ID generated from transaction hash and index. |
| addresses | VARCHAR(134217728) | Addresses used in the transaction |
| address0 | VARCHAR(130) | Index 0 of the addresses |
| value_max_exclusive | NUMBER(38,0) | sum(value of all inputs with index lesser than itself) + value - 1 within the same transaction. Used for ordinal tracking where FIFO principle is used. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| value_min_inclusive | NUMBER(38,0) | sum(value of all inputs with index lesser than itself) within the same transaction. Used for ordinal tracking where FIFO principle is used. |
| _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. |
| desc | VARCHAR(16777216) | Output descriptor string describing the spending conditions for this UTXO (e.g. P2PKH, P2WPKH script templates). |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |