Beacon ChainBlobs

Column Descriptions

for eth_cl.blobs

9 rows

Name	Type	Description
block_number	NUMBER	Sequential number of the block in the blockchain containing this blob
kzg_commitment	TEXT	KZG commitment for the blob, ensuring data integrity
kzg_proof	TEXT	KZG proof for the blob, used to verify the commitment
block_date	DATE	Calendar date associated with the block containing this blob
block_hash	TEXT	Unique identifier (hash) of the block containing this blob
blob	TEXT	Encoded representation of the blob's data
kzg_commitment_inclusion_proof	ARRAY	List of proofs for inclusion of the KZG commitment in the block
index	NUMBER	Index of the blob within the block
block_time	TIMESTAMP_NTZ	Timestamp indicating when the block containing this blob was created

Sample Queries

Daily Blob Count

Calculates the total number of data blobs included in blocks each day.

SELECT
  block_date,
  COUNT(*) AS daily_blobs
FROM
  eth_cl.blobs
GROUP BY
  block_date
ORDER BY
  block_date;

Blocks with the Most Blobs

Identifies blocks that contain the highest number of data blobs.

SELECT
  block_hash,
  COUNT(*) AS blob_count
FROM
  eth_cl.blobs
GROUP BY
  block_hash
ORDER BY
  blob_count DESC
LIMIT
  10;

Blob Distribution by Block Number

Analyzes the distribution of blobs across different block numbers.

SELECT
  block_number,
  COUNT(index) AS blob_count
FROM
  eth_cl.blobs
GROUP BY
  block_number
ORDER BY
  blob_count DESC;