Blocks
The ethereum.blocks table provides indexed views of all blocks.
Columns
| Name | Type | Description |
|---|---|---|
| base_fee_per_gas | numeric |
The base fee to include a transaction in the block (in Wei per gas unit). |
| block_hash | text |
The hash of all the block's contents. |
| block_number | integer |
The block's number |
| block_reward | numeric |
The amount rewarded to the miner (or validator in PoS Ethereum) of the block (in Wei). |
| difficulty | numeric |
The block's mining difficulty. |
| gas_limit | numeric |
The maximum amount of gas that can be used in the block (in gas units). |
| gas_used | numeric |
The amount of gas used in the block (in gas units). |
| miner_address | text |
The address of the miner who mined the block. |
| mix_hash | text |
The block's mix hash, used in the proof-of-work algorithm. |
| nonce | text |
The block's nonce, used in the proof-of-work algorithm. |
| parent_hash | text |
The hash of the block's parent block. |
| sha3_uncles | text |
The hash of the block's uncle blocks. |
| size_bytes | numeric |
The block's size (in bytes). |
| timestamp | timestamp |
The block's timestamp (in ISO-8601 format). |
| total_difficulty | numeric |
Total difficulty of all blocks up until the block. |
| total_fees_burned | numeric |
The amount of transaction fees burned in the block (see EIP-1559) (in Wei). |
| total_fees_rewarded | numeric |
The amount of transaction fees rewarded to the miner of the block (in Wei). |
| total_fees_saved | numeric |
The amount of transaction fees saved by transactions in the block (in Wei). |
| transaction_count | integer |
The number of transactions in the block. |
| uncle_1_address | text |
The address of the miner who mined the first uncle block. |
| uncle_1_reward | numeric |
The amount rewarded to the miner of the first uncle block (in Wei). |
| uncle_2_address | text |
The address of the miner who mined the second uncle block. |
| uncle_2_reward | numeric |
The amount rewarded to the miner of the second uncle block (in Wei). |
| uncle_count | integer |
The number of uncle blocks included in the block. |
| __confirmed | boolean |
Flag indicating whether the block has been confirmed. |
Indexes
| Index |
|---|
| block_number |
| miner_address, timestamp |
| miner_address, block_number |
| timestamp |
| __confirmed WHERE __confirmed = false |
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.