SolanaBlocks

Column Descriptions

for solana.blocks

16 rows

Name	Type	Description
hash	TEXT
date	DATE
failed_transactions	NUMBER
successful_transactions	NUMBER
failed_non_vote_transactions	NUMBER
total_non_vote_transactions	NUMBER
failed_vote_transactions	NUMBER
total_transactions	NUMBER
successful_vote_transactions	NUMBER
slot	NUMBER
successful_non_vote_transactions	NUMBER
total_vote_transactions	NUMBER
parent_slot	NUMBER
height	NUMBER
time	TIMESTAMP_NTZ
previous_block_hash	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
  );