WAXBlocks

Column Descriptions

for wax.blocks

25 rows

Name	Type	Description
number	NUMBER
schedule_version	NUMBER
failed_transactions	NUMBER
confirmed	NUMBER
time	TIMESTAMP_NTZ
successful_transactions	NUMBER
transaction_mroot	TEXT
blockroot_merkle_active_nodes	ARRAY
producer	TEXT
action_mroot_savanna	TEXT
blockroot_merkle_node_count	NUMBER
total_actions	NUMBER
dpos_irreversible_blocknum	NUMBER
total_transactions	NUMBER
hash	TEXT
producer_signature	TEXT
parent_hash	TEXT
date	DATE
size	NUMBER
version	NUMBER
dpos_proposed_irreversible_blocknum	NUMBER
total_db_ops	NUMBER
action_mroot	TEXT
block_signing_key	TEXT
confirm_count	ARRAY

Sample Queries

Average Block Size Over Time

Calculates the average block size per day

SELECT
  date,
  AVG(size) AS average_block_size
FROM
  wax.blocks
GROUP BY
  date
ORDER BY
  date;

Find Blocks Produced by a Specific Producer

Retrieves all blocks produced by a specific block producer

SELECT
  *
FROM
  wax.blocks
WHERE
  producer = 'eoseouldotio';

Blocks with Highest Transaction Count

Identifies the blocks with the highest number of total transactions

SELECT
  hash,
  total_transactions
FROM
  wax.blocks
ORDER BY
  total_transactions DESC
LIMIT
  10;