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 - a legacy integration route which only includes raw EVM data. We are working to migrate it over to the standard EVM integration.

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