Skip to main content
Schema: blast.core Table: fact_blocks Type: View This table contains block level data for this 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, please see Etherscan Resources or The Ethereum Organization

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_HASHTEXTThe hash of the block header for a given block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
NETWORKTEXTThe network on the blockchain used by a transaction.
TX_COUNTNUMBERTotal number of transactions within a block.
SIZENUMBERBlock size, which is determined by a given block’s gas limit.
MINERTEXTThe address of the beneficiary to whom the mining rewards were given
EXTRA_DATATEXTAny data included by the miner for a given block.
PARENT_HASHTEXTThe hash of the block from which a given block is generated. Also known as the parent block.
GAS_USEDNUMBERTotal gas used in the block.
GAS_LIMITNUMBERTotal gas limit provided by all transactions in the block.
DIFFICULTYNUMBERThe effort required to mine the block.
TOTAL_DIFFICULTYNUMBERTotal difficulty of the chain at a given block.
SHA3_UNCLESTEXTThe mechanism which Ethereum Javascript RLP encodes an empty string.
UNCLE_BLOCKSVARIANTUncle 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.
NONCENUMBERThe number of transactions sent from a given address.
RECEIPTS_ROOTTEXTThe root of the state trie.
STATE_ROOTTEXTThe root of the final state trie of the block
TRANSACTIONS_ROOTTEXTThe root of the transaction trie of the block
LOGS_BLOOMTEXTThe bloom filter for the logs of the block.
BASE_FEE_PER_GASNUMBERA string of the base fee encoded in hexadecimal format. Please note that this response field will not be included in a block requested before the EIP-1559 upgrade
WITHDRAWALS_ROOTTEXTThe root of the withdrawals trie.
FACT_BLOCKS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was last modified.
BLOCKCHAINTEXTThis column is being removed for standardization purposes. Please remove from your queries by March 10, 2025.
HASHTEXTThis column is being deprecated for standardization purposes. Please update your queries to use the block_hash column instead by March 10, 2025.
BLOCK_HEADER_JSONOBJECTThis column is being removed for standardization purposes and will be replaced with new columns associated with the keys extracted from this json. Please remove from your queries by March 10, 2025.