> ## Documentation Index
> Fetch the complete documentation index at: https://dune-pro-1110-add-delete-endpoints-python-js-docs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# tron.blocks

> Description of the tron.blocks table on Dune

export const TableSample = ({tableName, tableSchema}) => <div>
    <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6c1ea=${tableSchema}&table_name_t6c1ea=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
  </div>;

export const ColumnDescriptions = ({tableName, tableSchema}) => <div>
    <iframe src={`https://dune.com/embeds/3424601/5785601?table_name_t6c1ea=${tableName}&table_schema_t6c1ea=${tableSchema}`} style={{
  width: "100%",
  height: "500px",
  border: "none",
  marginTop: "10px"
}} />
    <Info> Datatypes on Snowflake datashare are different in some cases, read more <a href="/datashare/datashare#datatypes">here</a>.  </Info>
  </div>;

## Table Description

The `tron.blocks` table contains information about blocks in the Tron 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

<ColumnDescriptions tableSchema="tron" tableName="blocks" />

## Table Sample

<TableSample tableSchema="tron" tableName="blocks" />

## Examples

### Show the most recent blocks

```sql
SELECT
  number,
  hash,
  size,
  gas_used
FROM
  tron.blocks
ORDER BY
  number DESC
LIMIT 10
```

### Show the number of blocks produced each day

```sql
SELECT
  date_trunc('day', time) AS day,
  count(distinct number)
FROM
  tron.blocks
GROUP BY
  day
ORDER BY
  day DESC
```

### Show the number of transactions in each block

```sql
SELECT
  number,
  count(*)
FROM
  tron.blocks
group by 1 

LIMIT 10
```