Table Description
Contains block-level data for the Cardano blockchain. Each row represents a single block and includes information about the epoch, slot, transaction count, total output value, fees collected, and protocol version.Column Descriptions
| Column | Description | Type |
|---|---|---|
| block_hash | The hash uniquely identifying the block. | varchar |
| block_number | The sequential number of the block in the chain. | bigint |
| block_time | The timestamp when the block was produced. | timestamp |
| epoch | The epoch number in which the block was produced. | integer |
| slot | The absolute slot number of the block. | bigint |
| epoch_slot | The slot number relative to the start of the epoch. | bigint |
| era | The Cardano era during which the block was produced (e.g., Shelley, Alonzo, Conway). | integer |
| tx_count | The number of transactions included in the block. | integer |
| total_output_lovelace | The total output value of all transactions in the block, in lovelace. | decimal(38,0) |
| total_fees_lovelace | The total transaction fees collected in the block, in lovelace. | bigint |
| protocol_version | The protocol version active when the block was produced. | varchar |
| prev_block_hash | The hash of the preceding block. | varchar |
| pool_hash | The hash of the stake pool that produced the block. | varchar |
| _updated_at | The time when this record was last updated. | timestamp |
| _ingested_at | The time when this record was ingested into Dune. | timestamp |