Description of the celo.blocks table on Dune
The celo.blocks
table contains information about blocks in the celo blockchain. A block is a collection of transactions that are hashed and added to the blockchain. Each block contains a reference to the previous block, known as the parent hash, and a timestamp. The table contains information about each block, such as the block number, the block hash, the block size, the number of transactions, and the gas used.
SELECT
number,
hash,
size,
gas_used
FROM celo.blocks
ORDER BY number DESC
LIMIT 10
SELECT
date_trunc('day', time) AS day,
count(distinct number)
FROM celo.blocks
GROUP BY day
ORDER BY day DESC
SELECT
number,
count(*)
FROM celo.blocks
GROUP BY 1
LIMIT 10
Description of the celo.blocks table on Dune
The celo.blocks
table contains information about blocks in the celo blockchain. A block is a collection of transactions that are hashed and added to the blockchain. Each block contains a reference to the previous block, known as the parent hash, and a timestamp. The table contains information about each block, such as the block number, the block hash, the block size, the number of transactions, and the gas used.
SELECT
number,
hash,
size,
gas_used
FROM celo.blocks
ORDER BY number DESC
LIMIT 10
SELECT
date_trunc('day', time) AS day,
count(distinct number)
FROM celo.blocks
GROUP BY day
ORDER BY day DESC
SELECT
number,
count(*)
FROM celo.blocks
GROUP BY 1
LIMIT 10