EthereumBlocks

Column Descriptions

for eth.blocks

39 rows

Name	Type	Description
total_blob_transactions	NUMBER
extra_data_utf8	TEXT
hash	TEXT
gas_limit	NUMBER
miner	TEXT
detail_level_code	NUMBER
total_difficulty	NUMBER
difficulty	NUMBER
blob_gas_price	NUMBER
blob_gas_used	NUMBER
total_withdrawals	NUMBER
size	NUMBER
blob_transactions	ARRAY
total_blobs	NUMBER
time	TIMESTAMP_NTZ
number	NUMBER
withdrawals_root	TEXT
detail_level	TEXT
successful_transactions	NUMBER
date	DATE
base_fee_per_gas	TEXT
state_root	TEXT
total_difficulty_hex	TEXT
mix_hash	TEXT
gas_used	NUMBER
total_balance_changes	NUMBER
parent_beacon_root	TEXT
extra_data	TEXT
excess_blob_gas	NUMBER
failed_transactions	NUMBER
nonce	NUMBER
blob_gas_price_hex	TEXT
total_transactions	NUMBER
parent_hash	TEXT
transactions_root	TEXT
logs_bloom	TEXT
blob_hashes	ARRAY
receipts_root	TEXT
ommers_hash	TEXT

Sample Queries

Average Gas Used Per Block Daily

Calculates the average gas used per block for each day, providing insight into daily network activity.

SELECT
  date,
  AVG(gas_used) AS avg_gas_used
FROM
  eth.blocks
GROUP BY
  date
ORDER BY
  date;

Top 10 Miners by Block Count

Identifies the top 10 miners who have produced the most blocks, showing the most active block producers on the network.

SELECT
  miner,
  COUNT(*) AS block_count
FROM
  eth.blocks
GROUP BY
  miner
ORDER BY
  block_count DESC
LIMIT
  10;

Blocks with Higher Than Average Gas Limit

Retrieves information about blocks that have a gas limit above the overall average gas limit, which might indicate blocks with more complex transactions.

SELECT
  time,
  number,
  gas_limit
FROM
  eth.blocks
WHERE
  gas_limit > (
    SELECT
      AVG(gas_limit)
    FROM
      eth.blocks
  )
ORDER BY
  gas_limit DESC
LIMIT
  100;