Table Details
| Property | Value |
|---|---|
| Table Name | bitcoin_cash.raw.blocks |
| Table Status | Production-Ready |
| Unique Key | timestamp, number |
| Clustering Key(s) | to_date("timestamp") |
| Search Optimization | hash |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block. |
| number | NUMBER(38,0) | Block number or block height. |
| hash | VARCHAR(66) | Block hash. |
| confirmations | NUMBER(38,0) | The number of confirmations, or -1 if the block is not on the main chain. A confirmation indicates that a transaction has been added to a block on the blockchain. |
| version | NUMBER(38,0) | The block version. |
| merkle_root | VARCHAR(66) | The root node of a Merkle tree, where leaves are transaction hashes. |
| median_time | NUMBER(38,0) | The median block time expressed in UNIX epoch time. |
| nonce | NUMBER(38,0) | A 32-bit number that miners change to try to get a valid block hash. |
| bits | VARCHAR(16777216) | The difficulty threshold specified in the block header. |
| difficulty | FLOAT | The estimated amount of work done to find this block relative to the estimated amount of work done to find block 0. |
| chainwork | VARCHAR(16777216) | Expected number of hashes required to produce the current chain. |
| transaction_count | NUMBER(38,0) | Total number of transactions in the block. |
| previous_block_hash | VARCHAR(66) | The block hash of the previous block. |
| next_block_hash | VARCHAR(66) | The block hash of the next block, if applicable. |
| stripped_size | NUMBER(38,0) | The block size excluding witness data. |
| size | NUMBER(38,0) | Size of the block mined. |
| weight | NUMBER(38,0) | The block weight as defined in BIP 141. |
| auxpow | VARIANT | Auxiliary proof-of-work data, when present (used for merged mining). |
| _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. |