sei.core_evm Table: fact_blocks Type: Base Table
This table contains block level data for the SEI EVM Blockchain. This table can be used to analyze
trends at a block level, for example gas fees vs. total transactions over time. For more information
on EVM transactions, please see
Etherscan Resources or
The Ethereum Organization
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_NUMBER | NUMBER | Also known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block. |
| BLOCK_HASH | TEXT | The hash of the block header for a given block. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| NETWORK | TEXT | The network on the blockchain used by a transaction. |
| TX_COUNT | NUMBER | Total number of transactions within a block. |
| SIZE | NUMBER | Block size, which is determined by a given block’s gas limit. |
| MINER | TEXT | |
| MIX_HASH | TEXT | |
| EXTRA_DATA | TEXT | Any data included by the validator for a given block. |
| PARENT_HASH | TEXT | The hash of the block from which a given block is generated. Also known as the parent block. |
| GAS_USED | NUMBER | Total gas used in the block. |
| GAS_LIMIT | NUMBER | Total gas limit provided by all transactions in the block. |
| BASE_FEE_PER_GAS | NUMBER | |
| DIFFICULTY | NUMBER | The effort required to mine the block. |
| TOTAL_DIFFICULTY | NUMBER | Total difficulty of the chain at a given block. |
| SHA3_UNCLES | TEXT | The mechanism which Ethereum Javascript RLP encodes an empty string. |
| UNCLE_BLOCKS | VARIANT | Uncle blocks occur when two blocks are mined and broadcasted at the same time, with the same block number. The block validated across the most nodes will be added to the primary chain, and the other one becomes an uncle block. Miners do receive rewards for uncle blocks. |
| NONCE | NUMBER | |
| RECEIPTS_ROOT | TEXT | The root of the state trie. |
| STATE_ROOT | TEXT | |
| TRANSACTIONS_ROOT | TEXT | |
| LOGS_BLOOM | TEXT | |
| FACT_BLOCKS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |