tron.blocks

Tron block data — block number, timestamp, witness address, and transaction count.

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.

Table Schema

Column	Type	Description
time	timestamp(3)	Timestamp when this block was added to the chain
number	bigint	Sequential position of this block in the blockchain
gas_limit	decimal(38,0)	Maximum amount of energy that can be used by all transactions in this block
gas_used	decimal(38,0)	Total amount of energy actually consumed by all transactions in this block
difficulty	bigint	Measure of how difficult it was to produce this block
total_difficulty	decimal(38,0)	Total chain difficulty up to this block
size	bigint	Size of this block in bytes
base_fee_per_gas	bigint	Minimum fee per energy unit required for transaction inclusion in this block
hash	varbinary	Unique identifier (hash) of this block
parent_hash	varbinary	Hash of the previous block in the blockchain
miner	varbinary	Address of the block producer (super representative) who produced this block
nonce	varbinary	Block nonce value used in the consensus mechanism
date	date	The UTC date when this block was added to the chain

Table Sample

Examples

Show the most recent blocks

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

Show the number of blocks produced each day

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

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

LIMIT 10