Table of contents
The eth_mainnet.blocks Blocks are the base unit that all transactions fit into.
Columns
| Name | Type | Description |
|---|---|---|
| hash | varchar | A unique identifier for that block |
| number | integer | The length of the blockchain in blocks |
| parent_hash | varchar | The unique identifier for the prior block |
| base_fee_per_gas | varchar | This block's base fee |
| nonce | varchar | The block nonce is used to demonstrate the proof of work during mining |
| sha3_uncles | varchar | This is a combined hash of all uncles for a given parent, |
| logs_bloom | varchar | Obtain the logs bloom from a list of log entries. |
| transactions_root | varchar | The root hash is the proof that the block contains all the transactions in the proper order. |
| state_root | varchar | The root hash of the state object |
| miner | varchar | The address of the miner |
| difficulty | decimal(38,0) | The block's mining difficulty. |
| total_difficulty | decimal(38,0) | Total difficulty of all blocks up until the block. |
| extra_data | varchar | Arbitrary additional data as raw bytes |
| size | integer | The block's size (in bytes). |
| gas_limit | decimal(38,0) | The maximum amount of gas that can be used in the block (in gas units). |
| gas_used | decimal(38,0) | The amount of gas used in the block (in gas units). |
| timestamp | integer | The block's timestamp (in ISO-8601 format). |
| block_time | date | N/A |
| receipts_root | varchar | N/A |
| ym | varchar | N/A |