BNB Smart ChainBlocks

Column Descriptions

for bsc.blocks

39 rows

Name	Type	Description
gas_limit	NUMBER
date	DATE
blob_gas_price	NUMBER
blob_hashes	ARRAY
receipts_root	TEXT
blob_gas_used	NUMBER
extra_data_utf8	TEXT
gas_used	NUMBER
parent_hash	TEXT
total_difficulty	NUMBER
total_withdrawals	NUMBER
blob_transactions	ARRAY
base_fee_per_gas	TEXT
successful_transactions	NUMBER
total_balance_changes	NUMBER
detail_level_code	NUMBER
difficulty	NUMBER
mix_hash	TEXT
logs_bloom	TEXT
nonce	NUMBER
total_blobs	NUMBER
total_blob_transactions	NUMBER
number	NUMBER
withdrawals_root	TEXT
excess_blob_gas	NUMBER
detail_level	TEXT
total_difficulty_hex	TEXT
blob_gas_price_hex	TEXT
state_root	TEXT
extra_data	TEXT
size	NUMBER
hash	TEXT
transactions_root	TEXT
ommers_hash	TEXT
total_transactions	NUMBER
failed_transactions	NUMBER
time	TIMESTAMP_NTZ
miner	TEXT
parent_beacon_root	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
  bsc.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
  bsc.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
  bsc.blocks
WHERE
  gas_limit > (
    SELECT
      AVG(gas_limit)
    FROM
      bsc.blocks
  )
ORDER BY
  gas_limit DESC
LIMIT
  100;