BaseBlocks

Column Descriptions

for base.blocks

39 rows

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

Sample Queries

Average Transactions Per Block Daily

Calculates the average number of total transactions per block for each day.

SELECT
  date,
  AVG(total_transactions) AS avg_transactions
FROM
  solana.blocks
GROUP BY
  date
ORDER BY
  date;

Top 10 Dates with Highest Failed Non-Vote Transactions

Identifies the top 10 dates with the highest number of failed non-vote transactions.

SELECT
  date,
  SUM(failed_non_vote_transactions) AS total_failed_non_vote
FROM
  solana.blocks
GROUP BY
  date
ORDER BY
  total_failed_non_vote DESC
LIMIT
  10;

Blocks with Above Average Successful Transactions

Retrieves blocks that have a number of successful transactions greater than the average number of successful transactions across all blocks.

SELECT
  slot,
  height,
  hash
FROM
  solana.blocks
WHERE
  successful_transactions > (
    SELECT
      AVG(successful_transactions)
    FROM
      solana.blocks
  );