Description of the lens.blocks table on Dune
lens.blocks
table contains information about blocks in the lens 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 lens.blocks
ORDER BY number DESC
LIMIT 10
SELECT
date_trunc('day', time) AS day,
count(distinct number)
FROM lens.blocks
GROUP BY day
ORDER BY day DESC
SELECT
number,
count(*)
FROM lens.blocks
GROUP BY 1
LIMIT 10