Raw
degen.blocks
Description of the degen.blocks table on Dune
The data for the degen tables is hosted on Dune by the degen team in the context of hosted blockchain integrations. You can read more about the corresponding trust assumptions and technical details in this section.
Table description
The degen.blocks
table contains information about blocks in the degen 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.
Column Descriptions
Datatypes on Snowflake datashare are different in some cases, read more here.
Table Sample
Examples
Show the most recent blocks
SELECT
number,
hash,
size,
gas_used
FROM degen.blocks
ORDER BY number DESC
LIMIT 10
Show the number of blocks mined each day
SELECT
date_trunc('day', time) AS day,
count(distinct number)
FROM degen.blocks
GROUP BY day
ORDER BY day DESC
Show the number of transactions in each block
SELECT
number,
count(*)
FROM degen.blocks
GROUP BY 1
LIMIT 10