All blocks, starting from genesis.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.
Table Details
| Property | Value |
|---|---|
| Table Name | rootstock.raw.blocks |
| Table Status | Production-Ready |
| Unique Key | number |
| Clustering Key(s) | to_date("timestamp") |
| Search Optimization | number, hash, miner |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| timestamp | TIMESTAMP_NTZ(9) | The unix timestamp for when the block was collated. |
| number | NUMBER(38,0) | The length of the chain, in blocks. |
| hash | VARCHAR(66) | Unique identifier of a block. |
| parent_hash | VARCHAR(66) | Unique identifier of the block preceding this block, also known as the parent block. |
| nonce | VARCHAR(42) | The hash of the generated proof-of-work. null if pending. |
| sha3_uncles | VARCHAR(66) | An array of uncle hashes. |
| logs_bloom | VARCHAR(16777216) | The bloom filter for the logs of the block. |
| transactions_root | VARCHAR(66) | The root of the transaction trie of the block. |
| state_root | VARCHAR(66) | The root of the final state trie of the block. |
| receipts_root | VARCHAR(66) | The root of the receipts trie of the block. |
| miner | VARCHAR(42) | The address of the beneficiary to whom the mining rewards were given. |
| difficulty | NUMBER(38,0) | The integer of the difficulty for this block. |
| total_difficulty | VARCHAR(66) | The integer of the total difficulty of the chain until this block. |
| size | NUMBER(38,0) | The size of the block, in bytes, as determined by the gas_limit. |
| extra_data | VARCHAR(16777216) | The “extra data” field of this block. |
| gas_limit | NUMBER(38,0) | Gas limit of the current block. |
| gas_used | NUMBER(38,0) | Total gas used in the block. |
| transaction_count | NUMBER(38,0) | Number of transactions included in this block. |
| base_fee_per_gas | NUMBER(38,0) | Post London Upgrade (EIP1559), this represents the minimum gas_used required for a transaction to be included in a block. Represented in wei. |
| bitcoin_merged_mining_coinbase_transaction | VARCHAR(16777216) | The coinbase transaction of the Bitcoin block that was used to merge-mine this Rootstock block. |
| bitcoin_merged_mining_header | VARCHAR(16777216) | The Bitcoin block header of the block that was used to merge-mine this Rootstock block. |
| bitcoin_merged_mining_merkle_proof | VARCHAR(16777216) | The Merkle proof that links the Bitcoin block’s Merkle root to the coinbase transaction containing the Rootstock block’s merge-mining tag. |
| cumulative_difficulty | NUMBER(38,0) | The total accumulated difficulty of the Rootstock chain up to and including this block. |
| hash_for_merged_mining | VARCHAR(16777216) | A hash derived from the Rootstock block header fields that Bitcoin miners commit to in the merge-mining coinbase transaction. |
| minimum_gas_price | NUMBER(38,0) | The minimum gas price required for a transaction to be included in this block, in wei. |
| paid_fees | NUMBER(38,0) | The total amount of transaction fees paid by all transactions included in this block, in wei. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated. |